{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "Collection and Distribution Work Orders", "type" : "Feature Layer", "serviceItemId" : "4ec4791319634b05ae253b26d2b68e3f", "cacheMaxAge" : 30, "displayField" : "DEPARTMENTNAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1787775493375, "schemaLastEditDate" : 1787775493375, "dataLastEditDate" : 1787775493375 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -10560496.526081517, "ymin" : -1.0001008808612823, "xmax" : 7685939.0449507236, "ymax" : 15640598.735697463, "spatialReference" : { "wkid" : 102740, "latestWkid" : 2278 } }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"DEPARTMENT_PROGRAM","uniqueValueGroups":[{"heading":"DEPARTMENT_PROGRAM","classes":[{"label":"Cave-In","description":"Cave-In","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[166,206,227,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Cave-In"]]},{"label":"Collection Pipe Installation ","description":"Collection Pipe Installation ","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[31,120,180,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Collection Pipe Installation "]]},{"label":"Collection Tap Installation","description":"Collection Tap Installation","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[178,223,138,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Collection Tap Installation"]]},{"label":"Distribution Pipe Installation","description":"Distribution Pipe Installation","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[51,160,44,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Distribution Pipe Installation"]]},{"label":"Distribution Tap Installation","description":"Distribution Tap Installation","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[251,154,153,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Distribution Tap Installation"]]},{"label":"Fire Hydrant Repair and Replacement","description":"Fire Hydrant Repair and Replacement","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[227,26,28,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Fire Hydrant Repair and Replacement"]]},{"label":"Manholes","description":"Manholes","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[253,191,111,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Manholes"]]},{"label":"Meter Services","description":"Meter Services","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,127,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Meter Services"]]},{"label":"Sewer Cleanout Installation","description":"Sewer Cleanout Installation","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[202,178,214,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Sewer Cleanout Installation"]]},{"label":"Sewer Inspection & Sewer Line Cleaning","description":"Sewer Inspection & Sewer Line Cleaning","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[106,61,154,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Sewer Inspection & Sewer Line Cleaning"]]},{"label":"Sewer Stoppage","description":"Sewer Stoppage","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,153,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Sewer Stoppage"]]},{"label":"Water Leaks","description":"Water Leaks","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[177,89,40,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Water Leaks"]]},{"label":"Water Valves","description":"Water Valves","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[166,206,227,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"values":[["Water Valves"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[166,206,227,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Cave-In","label":"Cave-In"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[31,120,180,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Collection Pipe Installation ","label":"Collection Pipe Installation "},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[178,223,138,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Collection Tap Installation","label":"Collection Tap Installation"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[51,160,44,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Distribution Pipe Installation","label":"Distribution Pipe Installation"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[251,154,153,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Distribution Tap Installation","label":"Distribution Tap Installation"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[227,26,28,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Fire Hydrant Repair and Replacement","label":"Fire Hydrant Repair and Replacement"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[253,191,111,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Manholes","label":"Manholes"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,127,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Meter Services","label":"Meter Services"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[202,178,214,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Sewer Cleanout Installation","label":"Sewer Cleanout Installation"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[106,61,154,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Sewer Inspection & Sewer Line Cleaning","label":"Sewer Inspection & Sewer Line Cleaning"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[255,255,153,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Sewer Stoppage","label":"Sewer Stoppage"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[177,89,40,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Water Leaks","label":"Water Leaks"},{"symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[166,206,227,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}},"value":"Water Valves","label":"Water Valves"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[166,206,227,255],"toColor":[166,206,227,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[31,121,181,255],"toColor":[31,121,181,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[177,222,138,255],"toColor":[177,222,138,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[51,161,43,255],"toColor":[51,161,43,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[250,154,152,255],"toColor":[250,154,152,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[227,25,28,255],"toColor":[227,25,28,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,191,111,255],"toColor":[252,191,111,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[255,128,0,255],"toColor":[255,128,0,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[202,178,214,255],"toColor":[202,178,214,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[106,61,153,255],"toColor":[106,61,153,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[255,255,153,255],"toColor":[255,255,153,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[176,88,40,255],"toColor":[176,88,40,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "DEPARTMENT_PROGRAM", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "ROWCNT", "type" : "esriFieldTypeDouble", "alias" : "ROWCNT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SORTID", "type" : "esriFieldTypeString", "alias" : "SORTID", "sqlType" : "sqlTypeOther", "length" : 2, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEPARTMENT_PROGRAM", "type" : "esriFieldTypeString", "alias" : "DEPARTMENT_PROGRAM", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEPARTMENTNAME", "type" : "esriFieldTypeString", "alias" : "DEPARTMENTNAME", "sqlType" : "sqlTypeOther", "length" : 80, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PROGRAMNAME", "type" : "esriFieldTypeString", "alias" : "PROGRAMNAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DESCRIPTION", "type" : "esriFieldTypeString", "alias" : "DESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "REPORTID", "type" : "esriFieldTypeString", "alias" : "REPORTID", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OPEN_CLOSE", "type" : "esriFieldTypeString", "alias" : "OPEN_CLOSE", "sqlType" : "sqlTypeOther", "length" : 6, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATUS", "type" : "esriFieldTypeString", "alias" : "STATUS", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOGGEDDATE", "type" : "esriFieldTypeDate", "alias" : "LOGGEDDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "CLOSUREDATE", "type" : "esriFieldTypeDate", "alias" : "CLOSUREDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "POINTX", "type" : "esriFieldTypeDouble", "alias" : "POINTX", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POINTY", "type" : "esriFieldTypeDouble", "alias" : "POINTY", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LATITUDE", "type" : "esriFieldTypeDouble", "alias" : "LATITUDE", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LONGITUDE", "type" : "esriFieldTypeDouble", "alias" : "LONGITUDE", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__COLLECTI__F4B70D85F704C2B2", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_27698.COLLECTION_AND_DISTRIBUTION_WORK_ORDERS_COLLECTION_AND_DISTRIBUTION_WORK_ORDERS2_Shape_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : "Cave-In", "name" : "Cave-In", "domains" : { }, "templates" : [ { "name" : "Cave-In", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LATITUDE" : 0, "LONGITUDE" : 0, "ROWCNT" : null, "SORTID" : " ", "DEPARTMENT_PROGRAM" : "Cave-In", "DEPARTMENTNAME" : null, "PROGRAMNAME" : null, "DESCRIPTION" : null, "REPORTID" : null, "OPEN_CLOSE" : " ", "STATUS" : " ", "LOGGEDDATE" : null, "CLOSUREDATE" : null, "POINTX" : 0, "POINTY" : 0 } } } ] }, { "id" : "Collection Pipe Installation ", "name" : "Collection Pipe Installation ", "domains" : { }, "templates" : [ { "name" : "Collection Pipe Installation ", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LATITUDE" : 0, "LONGITUDE" : 0, "ROWCNT" : null, "SORTID" : " ", "DEPARTMENT_PROGRAM" : "Collection Pipe Installation ", "DEPARTMENTNAME" : null, "PROGRAMNAME" : null, "DESCRIPTION" : null, "REPORTID" : null, "OPEN_CLOSE" : " ", "STATUS" : " ", "LOGGEDDATE" : null, "CLOSUREDATE" : null, "POINTX" : 0, "POINTY" : 0 } } } ] }, { "id" : "Collection Tap Installation", "name" : "Collection Tap Installation", "domains" : { }, "templates" : [ { "name" : "Collection Tap Installation", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LATITUDE" : 0, "LONGITUDE" : 0, "ROWCNT" : null, "SORTID" : " ", "DEPARTMENT_PROGRAM" : "Collection Tap Installation", "DEPARTMENTNAME" : null, "PROGRAMNAME" : null, "DESCRIPTION" : null, "REPORTID" : null, "OPEN_CLOSE" : " ", "STATUS" : " ", "LOGGEDDATE" : null, "CLOSUREDATE" : null, "POINTX" : 0, "POINTY" : 0 } } } ] }, { "id" : "Distribution Pipe Installation", "name" : "Distribution Pipe Installation", "domains" : { }, "templates" : [ { "name" : "Distribution Pipe Installation", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LATITUDE" : 0, "LONGITUDE" : 0, "ROWCNT" : null, "SORTID" : " ", "DEPARTMENT_PROGRAM" : "Distribution Pipe Installation", "DEPARTMENTNAME" : null, "PROGRAMNAME" : null, "DESCRIPTION" : null, "REPORTID" : null, "OPEN_CLOSE" : " ", "STATUS" : " ", "LOGGEDDATE" : null, "CLOSUREDATE" : null, "POINTX" : 0, "POINTY" : 0 } } } ] }, { "id" : "Distribution Tap Installation", "name" : "Distribution Tap Installation", "domains" : { }, "templates" : [ { "name" : "Distribution Tap Installation", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LATITUDE" : 0, "LONGITUDE" : 0, "ROWCNT" : null, "SORTID" : " ", "DEPARTMENT_PROGRAM" : "Distribution Tap Installation", "DEPARTMENTNAME" : null, "PROGRAMNAME" : null, "DESCRIPTION" : null, "REPORTID" : null, "OPEN_CLOSE" : " ", "STATUS" : " ", "LOGGEDDATE" : null, "CLOSUREDATE" : null, "POINTX" : 0, "POINTY" : 0 } } } ] }, { "id" : "Fire Hydrant Repair and Replacement", "name" : "Fire Hydrant Repair and Replacement", "domains" : { }, "templates" : [ { "name" : "Fire Hydrant Repair and Replacement", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LATITUDE" : 0, "LONGITUDE" : 0, "ROWCNT" : null, "SORTID" : " ", "DEPARTMENT_PROGRAM" : "Fire Hydrant Repair and Replacement", "DEPARTMENTNAME" : null, "PROGRAMNAME" : null, "DESCRIPTION" : null, "REPORTID" : null, "OPEN_CLOSE" : " ", "STATUS" : " ", "LOGGEDDATE" : null, "CLOSUREDATE" : null, "POINTX" : 0, "POINTY" : 0 } } } ] }, { "id" : "Manholes", "name" : "Manholes", "domains" : { }, "templates" : [ { "name" : "Manholes", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LATITUDE" : 0, "LONGITUDE" : 0, "ROWCNT" : null, "SORTID" : " ", "DEPARTMENT_PROGRAM" : "Manholes", "DEPARTMENTNAME" : null, "PROGRAMNAME" : null, "DESCRIPTION" : null, "REPORTID" : null, "OPEN_CLOSE" : " ", "STATUS" : " ", "LOGGEDDATE" : null, "CLOSUREDATE" : null, "POINTX" : 0, "POINTY" : 0 } } } ] }, { "id" : "Meter Services", "name" : "Meter Services", "domains" : { }, "templates" : [ { "name" : "Meter Services", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LATITUDE" : 0, "LONGITUDE" : 0, "ROWCNT" : null, "SORTID" : " ", "DEPARTMENT_PROGRAM" : "Meter Services", "DEPARTMENTNAME" : null, "PROGRAMNAME" : null, "DESCRIPTION" : null, "REPORTID" : null, "OPEN_CLOSE" : " ", "STATUS" : " ", "LOGGEDDATE" : null, "CLOSUREDATE" : null, "POINTX" : 0, "POINTY" : 0 } } } ] }, { "id" : "Sewer Cleanout Installation", "name" : "Sewer Cleanout Installation", "domains" : { }, "templates" : [ { "name" : "Sewer Cleanout Installation", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LATITUDE" : 0, "LONGITUDE" : 0, "ROWCNT" : null, "SORTID" : " ", "DEPARTMENT_PROGRAM" : "Sewer Cleanout Installation", "DEPARTMENTNAME" : null, "PROGRAMNAME" : null, "DESCRIPTION" : null, "REPORTID" : null, "OPEN_CLOSE" : " ", "STATUS" : " ", "LOGGEDDATE" : null, "CLOSUREDATE" : null, "POINTX" : 0, "POINTY" : 0 } } } ] }, { "id" : "Sewer Inspection & Sewer Line Cleaning", "name" : "Sewer Inspection & Sewer Line Cleaning", "domains" : { }, "templates" : [ { "name" : "Sewer Inspection & Sewer Line Cleaning", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LATITUDE" : 0, "LONGITUDE" : 0, "ROWCNT" : null, "SORTID" : " ", "DEPARTMENT_PROGRAM" : "Sewer Inspection & Sewer Line Cleaning", "DEPARTMENTNAME" : null, "PROGRAMNAME" : null, "DESCRIPTION" : null, "REPORTID" : null, "OPEN_CLOSE" : " ", "STATUS" : " ", "LOGGEDDATE" : null, "CLOSUREDATE" : null, "POINTX" : 0, "POINTY" : 0 } } } ] }, { "id" : "Sewer Stoppage", "name" : "Sewer Stoppage", "domains" : { }, "templates" : [ { "name" : "Sewer Stoppage", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LATITUDE" : 0, "LONGITUDE" : 0, "ROWCNT" : null, "SORTID" : " ", "DEPARTMENT_PROGRAM" : "Sewer Stoppage", "DEPARTMENTNAME" : null, "PROGRAMNAME" : null, "DESCRIPTION" : null, "REPORTID" : null, "OPEN_CLOSE" : " ", "STATUS" : " ", "LOGGEDDATE" : null, "CLOSUREDATE" : null, "POINTX" : 0, "POINTY" : 0 } } } ] }, { "id" : "Water Leaks", "name" : "Water Leaks", "domains" : { }, "templates" : [ { "name" : "Water Leaks", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LATITUDE" : 0, "LONGITUDE" : 0, "ROWCNT" : null, "SORTID" : " ", "DEPARTMENT_PROGRAM" : "Water Leaks", "DEPARTMENTNAME" : null, "PROGRAMNAME" : null, "DESCRIPTION" : null, "REPORTID" : null, "OPEN_CLOSE" : " ", "STATUS" : " ", "LOGGEDDATE" : null, "CLOSUREDATE" : null, "POINTX" : 0, "POINTY" : 0 } } } ] }, { "id" : "Water Valves", "name" : "Water Valves", "domains" : { }, "templates" : [ { "name" : "Water Valves", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "LATITUDE" : 0, "LONGITUDE" : 0, "ROWCNT" : null, "SORTID" : " ", "DEPARTMENT_PROGRAM" : "Water Valves", "DEPARTMENTNAME" : null, "PROGRAMNAME" : null, "DESCRIPTION" : null, "REPORTID" : null, "OPEN_CLOSE" : " ", "STATUS" : " ", "LOGGEDDATE" : null, "CLOSUREDATE" : null, "POINTX" : 0, "POINTY" : 0 } } } ] } ], "templates" : [], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract" } ], "tables" : [ { "currentVersion" : 12, "id" : 2, "name" : "WorkOrdersCD_Metrics", "type" : "Table", "serviceItemId" : "4ec4791319634b05ae253b26d2b68e3f", "cacheMaxAge" : 30, "displayField" : "Department_Program", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1787775493422, "schemaLastEditDate" : 1787775493422, "dataLastEditDate" : 1787775493422 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsReturningQueryExtent" : false, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "count" ], "useStandardizedQueries" : true, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "ESRI_OID", "uniqueIdField" : { "name" : "ESRI_OID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "Department_Program", "type" : "esriFieldTypeString", "alias" : "Department_Program", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SortID", "type" : "esriFieldTypeDouble", "alias" : "SortID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Open_Or_Hold", "type" : "esriFieldTypeInteger", "alias" : "Open_Or_Hold", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Closed_Last_2_Wks", "type" : "esriFieldTypeInteger", "alias" : "Closed_Last_2_Wks", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Difference", "type" : "esriFieldTypeInteger", "alias" : "Difference", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESRI_OID", "type" : "esriFieldTypeOID", "alias" : "ESRI_OID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__COLLECTI__EEA048A5C85138C8", "fields" : "ESRI_OID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "WorkOrdersCD_Metrics", "description" : "", "drawingTool" : "esriFeatureEditToolNone", "prototype" : { "attributes" : { "Closed_Last_2_Wks" : null, "Department_Program" : null, "SortID" : null, "Open_Or_Hold" : null, "Difference" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 32000, "maxIdsCount" : 1000000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract" } ] }