{ "isCoGoEnabled": false, "extent": { "ymin": 100117.07548230886, "xmin": 1251038.2101100832, "ymax": 131720.17041248083, "xmax": 1280253.3836349994, "spatialReference": { "falseM": -100000, "xyTolerance": 6.561666666666666E-4, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2926, "zTolerance": 2.0E-5, "wkid": 2926, "xyUnits": 3048.0060960121928, "mTolerance": 2.0E-5, "falseX": -117104300, "falseY": -99539600, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.4.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "hasZ": false, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "csvtest_XYTableToPoint", "allowTrueCurvesUpdates": false, "displayField": "loggedbyname", "supportsCalculate": true, "fields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "id", "alias": "ID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "servicerequestid", "length": 8000, "alias": "ServiceRequestID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "refid", "alias": "RefID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "loggeddate", "length": 29, "alias": "LoggedDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "loggedbyid", "alias": "LoggedByID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "loggedbyname", "length": 8000, "alias": "LoggedByName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assigneddate", "length": 8000, "alias": "AssignedDate", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assignedtoid", "alias": "AssignedToID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assignedtoname", "length": 8000, "alias": "AssignedToName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assignedbyid", "length": 8000, "alias": "AssignedByID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "notificationlist", "length": 8000, "alias": "NotificationList", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assignedbyname", "length": 8000, "alias": "AssignedByName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "typeid", "alias": "TypeID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "typename", "length": 8000, "alias": "TypeName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "groupid", "alias": "GroupID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "groupname", "length": 8000, "alias": "GroupName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "issueid", "alias": "IssueID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "departmentid", "alias": "DepartmentID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "departmentname", "length": 8000, "alias": "DepartmentName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "complaint", "length": 8000, "alias": "Complaint", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 8000, "alias": "Location", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "status", "length": 8000, "alias": "Status", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "priorityname", "length": 8000, "alias": "PriorityName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "statusname", "length": 8000, "alias": "StatusName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "openeddate", "length": 29, "alias": "OpenedDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "resolveddate", "length": 29, "alias": "ResolvedDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "closeddate", "length": 29, "alias": "ClosedDate", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "closedbyid", "alias": "ClosedByID", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "closedbyname", "length": 8000, "alias": "ClosedByName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "duration", "alias": "Duration", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "closedduration", "alias": "ClosedDuration", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "iscomplete", "alias": "IsComplete", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "callername", "length": 8000, "alias": "CallerName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "callerrelation", "length": 8000, "alias": "CallerRelation", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "calleraddress", "length": 8000, "alias": "CallerAddress", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "callerhphone", "length": 8000, "alias": "CallerHPhone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "callerwphone", "length": 8000, "alias": "CallerWPhone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "callermphone", "length": 8000, "alias": "CallerMPhone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "calleremail", "length": 8000, "alias": "CallerEmail", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "callerautosend", "alias": "CallerAutoSend", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "description", "length": 8000, "alias": "Description", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "occupantname", "length": 8000, "alias": "OccupantName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "occupanthphone", "length": 8000, "alias": "OccupantHPhone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "occupantwphone", "length": 8000, "alias": "OccupantWPhone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "occupantmphone", "length": 8000, "alias": "OccupantMPhone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "occupantemail", "length": 8000, "alias": "OccupantEmail", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "occupantautosend", "alias": "OccupantAutoSend", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownername", "length": 8000, "alias": "OwnerName", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownerref", "length": 8000, "alias": "OwnerRef", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "owneraddress", "length": 8000, "alias": "OwnerAddress", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownerhphone", "length": 8000, "alias": "OwnerHPhone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownerwphone", "length": 8000, "alias": "OwnerWPhone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownermphone", "length": 8000, "alias": "OwnerMPhone", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "owneremail", "length": 8000, "alias": "OwnerEmail", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ownerautosend", "alias": "OwnerAutoSend", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "response", "length": 8000, "alias": "Response", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hasasset", "alias": "HasAsset", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hasdocs", "alias": "HasDocs", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hasnotify", "alias": "HasNotify", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "hasworkorders", "alias": "HasWorkOrders", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "layerid", "length": 8000, "alias": "LayerID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assetid", "length": 8000, "alias": "AssetID", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pointx", "alias": "PointX", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pointy", "alias": "PointY", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "latitude", "alias": "Latitude", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "longitude", "alias": "Longitude", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "spatialreference", "alias": "SpatialReference", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "watchid", "length": 8000, "alias": "WatchID", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "sourceSpatialReference": { "falseM": -100000, "xyTolerance": 6.561666666666671E-4, "mUnits": 10000, "zUnits": 10000, "latestWkid": 2926, "zTolerance": 2.0E-5, "wkid": 2926, "xyUnits": 3048.00609601219, "mTolerance": 2.0E-5, "falseX": -117104300, "falseY": -99539600, "falseZ": -100000 }, "globalIdField": null, "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "r392_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a245_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 0, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "c097fd02211843a68a0889824c50b198", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [ { "templates": [ { "name": "Closed", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "ownerautosend": null, "openeddate": null, "resolveddate": null, "callermphone": null, "issueid": null, "pointx": null, "pointy": null, "occupanthphone": null, "spatialreference": null, "notificationlist": null, "occupantmphone": null, "assignedtoid": null, "occupantemail": null, "hasasset": null, "typeid": null, "id": null, "refid": null, "ownerhphone": null, "longitude": null, "owneraddress": null, "ownerref": null, "ownername": null, "hasworkorders": null, "groupid": null, "statusname": "Closed", "assignedbyid": null, "groupname": null, "assignedtoname": null, "servicerequestid": null, "calleremail": null, "callerhphone": null, "watchid": null, "departmentname": null, "ownerwphone": null, "callerrelation": null, "status": null, "owneremail": null, "iscomplete": null, "closedbyid": null, "closeddate": null, "hasdocs": null, "calleraddress": null, "latitude": null, "closedduration": null, "description": null, "occupantwphone": null, "duration": null, "layerid": null, "assigneddate": null, "callerautosend": null, "loggeddate": null, "callerwphone": null, "callername": null, "loggedbyid": null, "assignedbyname": null, "departmentid": null, "loggedbyname": null, "closedbyname": null, "hasnotify": null, "priorityname": null, "occupantautosend": null, "complaint": null, "response": null, "assetid": null, "occupantname": null, "ownermphone": null, "location": null, "typename": null } } } ], "name": "Closed", "domains": {}, "id": "Closed" }, { "templates": [ { "name": "Open", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "ownerautosend": null, "openeddate": null, "resolveddate": null, "callermphone": null, "issueid": null, "pointx": null, "pointy": null, "occupanthphone": null, "spatialreference": null, "notificationlist": null, "occupantmphone": null, "assignedtoid": null, "occupantemail": null, "hasasset": null, "typeid": null, "id": null, "refid": null, "ownerhphone": null, "longitude": null, "owneraddress": null, "ownerref": null, "ownername": null, "hasworkorders": null, "groupid": null, "statusname": "Open", "assignedbyid": null, "groupname": null, "assignedtoname": null, "servicerequestid": null, "calleremail": null, "callerhphone": null, "watchid": null, "departmentname": null, "ownerwphone": null, "callerrelation": null, "status": null, "owneremail": null, "iscomplete": null, "closedbyid": null, "closeddate": null, "hasdocs": null, "calleraddress": null, "latitude": null, "closedduration": null, "description": null, "occupantwphone": null, "duration": null, "layerid": null, "assigneddate": null, "callerautosend": null, "loggeddate": null, "callerwphone": null, "callername": null, "loggedbyid": null, "assignedbyname": null, "departmentid": null, "loggedbyname": null, "closedbyname": null, "hasnotify": null, "priorityname": null, "occupantautosend": null, "complaint": null, "response": null, "assetid": null, "occupantname": null, "ownermphone": null, "location": null, "typename": null } } } ], "name": "Open", "domains": {}, "id": "Open" } ], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "statusname", "modelName": "GP_856015975", "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "field1": "statusname", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 237, 81, 81, 255 ], "fromColor": [ 237, 81, 81, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 21, 160, 207, 255 ], "fromColor": [ 21, 160, 207, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 167, 199, 54, 255 ], "fromColor": [ 167, 199, 54, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 158, 85, 156, 255 ], "fromColor": [ 158, 85, 156, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 145, 30, 255 ], "fromColor": [ 252, 145, 30, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 255, 223, 61, 255 ], "fromColor": [ 255, 223, 61, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 247, 136, 216, 255 ], "fromColor": [ 247, 136, 216, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 184, 129, 73, 255 ], "fromColor": [ 184, 129, 73, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 60, 176, 155, 255 ], "fromColor": [ 60, 176, 155, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 107, 107, 214, 255 ], "fromColor": [ 107, 107, 214, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" } }, "defaultSymbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0 }, "color": [ 0, 0, 0, 255 ], "size": 10, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "defaultLabel": "", "uniqueValueInfos": [ { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA0UlEQVQ4jbXTyw2DMBBF0TsKTUDKMGVQAbAmbdAG3iaiAWjDZWDKmCwA8VHCR1He0pKPxzN2wI8J/gOk3iBaImKAEOhRdaiU1JHbB7KuQUhAlqshIglCQu4tr+jxGci6BpHkoOqC3DMhM5B6M5x8KgWpt9SRmwHRclP2fm5UQLwAxJzfDSgG1j0ILwFjlkB/EenXgKo7MYFlmg0g5YUpgGi7BurIkXsLFCe2W573TQUwPI7cc4DsvMQJSb3lRjWNiqFhDaLtdPJ3ABg/THx4EeAN1a09imrou+IAAAAASUVORK5CYII=", "yoffset": 0, "width": 12, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "c19aeec45e82f0bfb5b4d9c7d9659cde", "height": 12 }, "label": "Closed", "value": "Closed" }, { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0 }, "color": [ 255, 0, 0, 255 ], "size": 10, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "label": "Open", "value": "Open" } ], "type": "uniqueValue", "fieldDelimiter": "," }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "Shape", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint" }