{ "snippet": "Centralized spatial inventory of public service and maintenance requests submitted by staff through OpenGOV Enterprise Asset Management (Cartegraph). Used for spatial analysis, tracking response times, monitoring citizen concerns, and generating operational maps for Public Works.", "summary": "Centralized spatial inventory of public service and maintenance requests submitted by staff through OpenGOV Enterprise Asset Management (Cartegraph). Used for spatial analysis, tracking response times, monitoring citizen concerns, and generating operational maps for Public Works.", "accessInformation": "City of Grapevine Public Works Department, Customer Service, PW GIS Division, OpenGOV/Cartegraph EAM.", "thumbnail": "", "maxScale": 5000, "typeKeywords": [], "description": "

This feature class captures point locations and attribute details for citizen service requests, customer tickets, and internal work requests submitted via the OpenGOV EAM platform.<\/SPAN><\/P>

Automatic Workflow:<\/SPAN> The dataset is maintained through an automated nightly synchronization process (ETL) that extracts newly logged and updated request records from OpenGOV EAM. This sync updates operational statuses, assignment groups, request descriptions, and completion dates to keep GIS reporting aligned with the city's asset management database.<\/SPAN><\/P>

Maintenance & Update Frequency: <\/SPAN>Daily (Nightly Automated Sync)<\/SPAN><\/P>

Process Step (Lineage Description):<\/SPAN><\/P>

  • Intake: Service requests are submitted by staff into the OpenGOV EAM system.<\/SPAN><\/P><\/LI>

  • ETL Extraction: A scheduled nightly Python/ETL script connects to OpenGOV EAM to pull new request records and modifications.<\/SPAN><\/P><\/LI>

  • Spatial Append & Update: The script appends new point features and updates existing record attributes (e.g., status changes, closure dates, assigned division) in the enterprise geodatabase.<\/SPAN><\/P><\/LI><\/UL><\/DIV><\/DIV><\/DIV>", "licenseInfo": "

    For internal municipal tracking, planning, and reference purposes. Point locations reflect reported address points or approximate geographic locations provided during initial request intake.<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "catalogPath": "", "title": "OpenGOV EAM Requests", "type": "", "url": "", "tags": [ "OpenGOV", "Cartegraph", "Service Requests", "EAM", "311", "Work Orders", "Public Works", "Nightly Sync", "Asset Management" ], "culture": "en-US", "portalUrl": "", "name": "", "guid": "", "minScale": 50000, "spatialReference": "" }