{ "isCoGoEnabled": false, "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 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": ["extent"], "datesInUnknownTimezone": false, "ownershipBasedAccessControlForFeatures": null, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "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 }, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson,kml,excel,featureCollection", "hasLastEditTime": false, "standardMaxRecordCount": 32000, "isDataVersioned": true, "templates": [{ "name": "Requests", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": {"attributes": { "Status": null, "AssociatedTasks": null, "Issue": null, "Description": null, "RequestID": null, "Priority": null, "EnteredDate": null, "Department": null, "FEMA": null, "LocationDescription": null, "RequestNotesField": null, "AddressNumber": null, "Street": null, "ClosedDate": null, "EnteredBy": null, "IntersectingStreet": null, "DueDate": null, "ResponseNotes": null }} }], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 12.1, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsSessionBasedAddAttachments": true, "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsSessionBasedUpdateFeatures": true, "supportsSessionBasedDeleteAttachments": true, "supportsDivideCombineGroupedObjects": true, "supportsDeleteAssociations": true, "supportsSessionBasedUpdateAttachments": true, "supportedSqlFormatsInCalculate": ["standard"], "supportedApplyEditsUploadIDFormats": "JSON,PBF", "supportsSessionBasedDeleteFeatures": true, "supportsSessionBasedAddFeatures": true }, "supportsQuantizationEditMode": true, "objectIdField": "OBJECTID", "name": "Requests", "allowTrueCurvesUpdates": true, "displayField": "RequestID", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "modelName": "GlobalID", "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "GlobalID", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "modelName": "RequestID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "RequestID", "length": 50, "alias": "Request ID", "type": "esriFieldTypeString" }, { "modelName": "Status", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Status", "length": 50, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "DueDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "DueDate", "length": 8, "alias": "Due Date", "type": "esriFieldTypeDate" }, { "modelName": "ClosedDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ClosedDate", "length": 8, "alias": "Closed Date", "type": "esriFieldTypeDate" }, { "modelName": "EnteredBy", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "EnteredBy", "length": 40, "alias": "Entered By", "type": "esriFieldTypeString" }, { "modelName": "EnteredDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "EnteredDate", "length": 8, "alias": "Entered Date", "type": "esriFieldTypeDate" }, { "modelName": "AssociatedTasks", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "AssociatedTasks", "alias": "Associated Tasks", "type": "esriFieldTypeInteger" }, { "modelName": "Issue", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Issue", "length": 255, "alias": "Issue", "type": "esriFieldTypeString" }, { "modelName": "Description", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Description", "length": 1073741822, "alias": "Description", "type": "esriFieldTypeString" }, { "modelName": "AddressNumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "AddressNumber", "alias": "Address Number", "type": "esriFieldTypeDouble" }, { "modelName": "Street", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Street", "length": 50, "alias": "Street", "type": "esriFieldTypeString" }, { "modelName": "IntersectingStreet", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "IntersectingStreet", "length": 50, "alias": "Intersecting Street", "type": "esriFieldTypeString" }, { "modelName": "LocationDescription", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "LocationDescription", "length": 500, "alias": "Location Description", "type": "esriFieldTypeString" }, { "modelName": "Department", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Department", "length": 50, "alias": "Department", "type": "esriFieldTypeString" }, { "modelName": "RequestNotesField", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "RequestNotesField", "length": 1073741822, "alias": "Request Notes", "type": "esriFieldTypeString" }, { "modelName": "ResponseNotes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ResponseNotes", "length": 1073741822, "alias": "Respinse Notes", "type": "esriFieldTypeString" }, { "modelName": "FEMA", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "FEMA", "length": 50, "alias": "FEMA", "type": "esriFieldTypeString" }, { "modelName": "Priority", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Priority", "length": 50, "alias": "Priority", "type": "esriFieldTypeString" }, { "modelName": "LastEditor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "LastEditor", "length": 255, "alias": "Last Editor", "type": "esriFieldTypeString" }, { "modelName": "LastEditDate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "LastEditDate", "length": 8, "alias": "Last Edit Date", "type": "esriFieldTypeDate" }, { "modelName": "CreatedUser", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "CreatedUser", "length": 255, "alias": "Created User", "type": "esriFieldTypeString" }, { "modelName": "CreatedDate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "CreatedDate", "length": 8, "alias": "Created Date", "type": "esriFieldTypeDate" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "bigIntegerRestrictedTo53Bits": true, "hasM": false, "allowGeometryUpdates": true, "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 }, "globalIdField": "GlobalID", "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.", "syncCanReturnChanges": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "supportsRollbackOnFailureParameter": false, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 32000, "indexes": [ { "name": "R425_pk", "isUnique": true, "description": "", "isAscending": true, "fields": "OBJECTID" }, { "name": "UUID_425", "isUnique": true, "description": "", "isAscending": true, "fields": "GlobalID" }, { "name": "UUID_OID_425", "isUnique": true, "description": "", "isAscending": true, "fields": "GlobalID,OBJECTID" }, { "name": "S306_idx", "isUnique": true, "description": "", "isAscending": true, "fields": "Shape" } ], "editFieldsInfo": { "editDateField": "LastEditDate", "editorField": "LastEditor", "creationDateField": "CreatedDate", "creatorField": "CreatedUser" }, "supportsDatumTransformation": true, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 50000, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsUseEstimateForExceedsLimit": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "fullTextSearchCapabilities": { "supportsSqlExpressionInFullText": true, "supportsOperator": false, "supportsSearchOperator": true }, "supportsQueryWithLodSR": false, "supportsPagination": true, "supportsMaxRecordCountFactor": false, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsReturningQueryExtent": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "serviceItemId": "a8f488b544734327b59282b17e43b6ed", "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "supportedTrueCurvePbfFeatureEncodings": [ "esriCompressedShapeBuffer", "esriDefault" ], "hasMetadata": true, "supportedAppendFormats": "FILEGDB,PBF,CSV", "tileMaxRecordCount": 8000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "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": { "modelName": "Shape", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Shape", "alias": "SHAPE", "type": "esriFieldTypeGeometry" }, "copyrightText": "City of Grapevine Public Works Department, Customer Service, PW GIS Division, OpenGOV/Cartegraph EAM.", "geometryType": "esriGeometryPoint" }