{ "extent": { "ymin": 3878375.0205493285, "xmin": -10817337.677108053, "ymax": 3893978.9343412239, "xmax": -10793343.933714498, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 } }, "maxRecordCount": 2000, "datesInUnknownTimezone": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "type": "Feature Layer", "maxSelectionCount": 2000, "subtypes": [], "relationships": [], "cimVersion": "3.7.0", "isDataArchived": false, "id": 0, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "spatialReference": { "falseM": -100000, "xyTolerance": 0.001, "mUnits": 10000, "zUnits": 10000, "latestWkid": 3857, "zTolerance": 0.001, "wkid": 102100, "xyUnits": 10000, "mTolerance": 0.001, "falseX": -20037700, "falseY": -30241100, "falseZ": -100000 }, "subtypeFieldName": null, "supportsStatistics": true, "hasLastEditTime": false, "standardMaxRecordCount": 32000, "isDataVersioned": true, "supportsAdvancedQueries": true, "parentLayer": null, "subLayers": [], "currentVersion": 12.1, "referenceScale": 0, "canScaleSymbols": false, "name": "Requests", "displayField": "RequestID", "fields": [ { "nullable": false, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "domain": null, "name": "Shape", "alias": "SHAPE", "type": "esriFieldTypeGeometry" }, { "nullable": false, "domain": null, "name": "GlobalID", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "nullable": true, "domain": null, "name": "RequestID", "length": 50, "alias": "Request ID", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Status", "length": 50, "alias": "Status", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "DueDate", "length": 8, "alias": "Due Date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "ClosedDate", "length": 8, "alias": "Closed Date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "EnteredBy", "length": 40, "alias": "Entered By", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "EnteredDate", "length": 8, "alias": "Entered Date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "AssociatedTasks", "alias": "Associated Tasks", "type": "esriFieldTypeInteger" }, { "nullable": true, "domain": null, "name": "Issue", "length": 255, "alias": "Issue", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Description", "length": 1073741822, "alias": "Description", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "AddressNumber", "alias": "Address Number", "type": "esriFieldTypeDouble" }, { "nullable": true, "domain": null, "name": "Street", "length": 50, "alias": "Street", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "IntersectingStreet", "length": 50, "alias": "Intersecting Street", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "LocationDescription", "length": 500, "alias": "Location Description", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Department", "length": 50, "alias": "Department", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "RequestNotesField", "length": 1073741822, "alias": "Request Notes", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "ResponseNotes", "length": 1073741822, "alias": "Respinse Notes", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "FEMA", "length": 50, "alias": "FEMA", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "Priority", "length": 50, "alias": "Priority", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "LastEditor", "length": 255, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "LastEditDate", "length": 8, "alias": "Last Edit Date", "type": "esriFieldTypeDate" }, { "nullable": true, "domain": null, "name": "CreatedUser", "length": 255, "alias": "Created User", "type": "esriFieldTypeString" }, { "nullable": true, "domain": null, "name": "CreatedDate", "length": 8, "alias": "Created Date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": null, "preferredTimeReference": null, "useStandardizedQueries": true, "sourceSpatialReference": { "falseM": 0, "xyTolerance": 8.983152841195215E-9, "mUnits": 1, "zUnits": 1, "latestWkid": 2276, "zTolerance": 2, "wkid": 102738, "xyUnits": 999999999.99999988, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "falseZ": 0 }, "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.Automatic Workflow: 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.Maintenance & Update Frequency: Daily (Nightly Automated Sync)Process Step (Lineage Description):Intake: Service requests are submitted by staff into the OpenGOV EAM system.ETL Extraction: A scheduled nightly Python/ETL script connects to OpenGOV EAM to pull new request records and modifications.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.", "canModifyLayer": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCountNoGeometry": 32000, "indexes": [ { "name": "R425_pk", "isUnique": true, "description": "", "fields": "OBJECTID", "isAscending": true }, { "name": "UUID_425", "isUnique": true, "description": "", "fields": "GlobalID", "isAscending": true }, { "name": "UUID_OID_425", "isUnique": true, "description": "", "fields": "GlobalID,OBJECTID", "isAscending": true }, { "name": "S306_idx", "isUnique": true, "description": "", "fields": "Shape", "isAscending": true } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "supportsDatumTransformation": true, "minScale": 50000, "supportsDynamicLegends": true, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsSqlFormat": false, "useStandardizedQueries": true, "supportsResultPaginationToken": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryWithLodSR": false, "supportsPagination": true, "supportsMaxRecordCountFactor": false, "supportsStatistics": true, "supportsTrueCurve": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithDistance": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsDistinct": true, "supportsTimeRelation": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": null, "serviceItemId": "785eeaba32f34f4787c0f9c760f48c78", "supportsCoordinatesQuantization": true, "capabilities": "Map,Query,Data", "maxScale": 0, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "hasMetadata": true, "tileMaxRecordCount": 8000, "typeIdField": null, "defaultSubtypeCode": null, "supportedQueryFormats": "JSON, geoJSON, PBF", "hasLabels": false, "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.69999999999999996 }, "color": [ 37, 87, 145, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "name": "Shape", "alias": "SHAPE", "type": "esriFieldTypeGeometry" }, "copyrightText": "City of Grapevine Public Works Department, Customer Service, PW GIS Division, OpenGOV/Cartegraph EAM.", "geometryType": "esriGeometryPoint" }