{ "snippet": "Centralized spatial dataset designed to aggregate and track municipal work tasks containing an Americans with Disabilities Act (ADA) component. This dataset supports state reporting requirements and enables internal staff (e.g., ADA Coordinator) to monitor citywide ADA-related infrastructure improvements and maintenance.", "summary": "Centralized spatial dataset designed to aggregate and track municipal work tasks containing an Americans with Disabilities Act (ADA) component. This dataset supports state reporting requirements and enables internal staff (e.g., ADA Coordinator) to monitor citywide ADA-related infrastructure improvements and maintenance.", "accessInformation": "City of Grapevine Public Works Department, PW GIS Division, OpenGOV/Cartegraph EAM.", "thumbnail": "", "maxScale": 5000, "typeKeywords": [], "description": "
This feature class serves as a consolidated repository for point location records representing completed municipal work tasks related to ADA compliance.<\/SPAN><\/P> Automation Workflow:<\/SPAN><\/P> Data is populated via an automated nightly Python script (ADATransfers). The script extracts completed task points from OpenGOV Enterprise Asset Management (Cartegraph) stored in DBO.Tasks_Point where:<\/SPAN><\/P> ADARelated is marked as 'True' (triggered when field crews include \"ADA\" in the task Notes field).<\/SPAN><\/P><\/LI> StopDateActual equals the current execution date.<\/SPAN><\/P><\/LI><\/UL> Newly appended records have their Source attribute updated automatically to 'OpenGOV'.<\/SPAN><\/P> Maintenance & Update Frequency:<\/SPAN> Daily (Nightly Script)<\/SPAN><\/P> Process Step (Lineage Description):<\/SPAN><\/P> Field staff perform maintenance/repair activities and flag tasks in OpenGOV (Cartegraph) with \"ADA\" in the notes section.<\/SPAN><\/P><\/LI> Nightly ETL script queries DBO.Tasks_Point for records completed on the current date where ADARelated = 'True'.<\/SPAN><\/P><\/LI> Matching features are appended to DBO.ADAActions using field mapping.<\/SPAN><\/P><\/LI> Script assigns 'OpenGOV' to the Source attribute for all newly appended TaskIDs.<\/SPAN><\/P><\/LI><\/UL><\/DIV><\/DIV><\/DIV>",
"licenseInfo": "",
"catalogPath": "",
"title": "ADA Compliance Actions",
"type": "",
"url": "",
"tags": [
"ADA",
"Americans with Disabilities Act",
"Compliance",
"Asset Management",
"OpenGOV",
"Cartegraph",
"Public Works",
"Infrastructure"
],
"culture": "en-US",
"portalUrl": "",
"name": "",
"guid": "",
"minScale": 50000,
"spatialReference": ""
}