{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "Open Water Sewer Taps", "type" : "Feature Layer", "serviceItemId" : "66ce6b84db8f4b3aaec0361e7afca10c", "cacheMaxAge" : 30, "displayField" : "LOGGEDBYNAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1773837892855, "schemaLastEditDate" : 1773837892855, "dataLastEditDate" : 1773837892855 }, "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" : -1.0001331865787506, "ymin" : -1.0001008808612823, "xmax" : 3324418.974045068, "ymax" : 13690390.810989887, "spatialReference" : { "wkid" : 102740, "latestWkid" : 2278 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"44586efd02b77beffb775f5b84b66bd9","imageData":"iVBORw0KGgoAAAANSUhEUgAAABcAAAAXCAYAAADgKtSgAAAACXBIWXMAAA7EAAAOxAGVKw4bAAADKklEQVRIibVVTUhUURS+b2Ze/g3jWKIzOgsXFfEoNHQh7cpFJGmQMtPQIpBIWmkrYVoULQo30TYRwYVO76EudFooWLt+IKUoXlBZLUZHxXKSGnX0aXzXzvW+URsJOvC4M3fOfOfvO99zsf9ormwOhmH4NjcdlRZjPoU5fLjbUNZHLweDr/8ZvM8wqpRNZ8eKmnvul7vIuabmOdJqrgO/FSUTkag+aCmM9ToUqzMYDM7uGzyqD3WkCryRRa//QKLsWG7m73RXvPD1esXnyStRfagzHLrYmRW8Xx+Mptze+i8VJwuW871OuvfMJ/i5VOIXvgvFFTk/vH71yIdnkUf6oO9SqOnGnuA8Y7e33tROe+iuNtrFtPGYAA28m+Dni/A1/qy5chzw18ynLVF9aFauwCX3GK1AxnJAs66Bg1D2FARB2xtr2IPhV/z7x6On3JWTjzv6DEMMW4BjeOjxoakpp/YkxrTxEdbTPSLAANzeUMPuvJwWmcePV7OWq42sp3uYVzAd0PICcfM+Y+yMAAfdwAoMKvBtgtX2dzHP/IxtFgiGO2RMlcRPVPOH7vD/8rhZZWsLeAy60R/MuvM2YGQNAGoHgcPG2m7x9tBd8qBf1fWBs6FQ8ygHx4KAxzIrBu4+tGUdeLs1SJx4kATZUkmZ+Awc4InMsXm0INy5dNuZspWt+WarGOQWuF8MGzi0ybsukWduu9+UqWyZ3ylAprlIK7DSGAiciMt/M8oUp9yiomQiDTwBDl5CK2Rua+MxPlhihJwthgdg+IBBoCRMXV/dyP+5aDkVNmvnOWO90AqsNDEAoABBf+VNpWE3R1r5SdwvTCbWgENCJsChbhAhaAUWAoAIMNZ2m1dA676j16V+HvjNhaBVHjdXLMXqtfUchmhQN4gQaQtljC2UNxWVoSpsJvX78Kfny2p69V44tK3zNrZAdKBuECFoBSqQM5a1BQbgvFTSKp95v1z4PRELh5pssruDipBNqBtECFoh67kMjOGhx2jFVsZ24F3BqQKoG0QIWoGVzngTpcEKDA89lluRFRz2Rza5ukErMt+hoNter7es4LJBhPbjl2m/AQPsrlm1UHxeAAAAAElFTkSuQmCC","contentType":"image/png","width":17,"height":17,"angle":0,"xoffset":0,"yoffset":0}},"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" : "", "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" : "ID", "type" : "esriFieldTypeInteger", "alias" : "ID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WORKORDERID", "type" : "esriFieldTypeString", "alias" : "WORKORDERID", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "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" : "LOGGEDBYID", "type" : "esriFieldTypeInteger", "alias" : "LOGGEDBYID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOGGEDBYNAME", "type" : "esriFieldTypeString", "alias" : "LOGGEDBYNAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BEGINDATE", "type" : "esriFieldTypeDate", "alias" : "BEGINDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ENDDATE", "type" : "esriFieldTypeDate", "alias" : "ENDDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "DUEDATE", "type" : "esriFieldTypeDate", "alias" : "DUEDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ASSIGNEDDATE", "type" : "esriFieldTypeDate", "alias" : "ASSIGNEDDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ASSIGNEDTOID", "type" : "esriFieldTypeInteger", "alias" : "ASSIGNEDTOID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ASSIGNEDTONAME", "type" : "esriFieldTypeString", "alias" : "ASSIGNEDTONAME", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ASSIGNEDBYID", "type" : "esriFieldTypeInteger", "alias" : "ASSIGNEDBYID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ASSIGNEDBYNAME", "type" : "esriFieldTypeString", "alias" : "ASSIGNEDBYNAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TYPEID", "type" : "esriFieldTypeInteger", "alias" : "TYPEID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TYPENAME", "type" : "esriFieldTypeString", "alias" : "TYPENAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEPARTMENTID", "type" : "esriFieldTypeInteger", "alias" : "DEPARTMENTID", "sqlType" : "sqlTypeOther", "nullable" : true, "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" : "GROUPID", "type" : "esriFieldTypeInteger", "alias" : "GROUPID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GROUPNAME", "type" : "esriFieldTypeString", "alias" : "GROUPNAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ACTIVITYDESCRIPTIONID", "type" : "esriFieldTypeInteger", "alias" : "ACTIVITYDESCRIPTIONID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ACTIVITYDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "ACTIVITYDESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOCATION", "type" : "esriFieldTypeString", "alias" : "LOCATION", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DESCRIPTION", "type" : "esriFieldTypeString", "alias" : "DESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 1073741822, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PRIORITY", "type" : "esriFieldTypeInteger", "alias" : "PRIORITY", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PRIORITYNAME", "type" : "esriFieldTypeString", "alias" : "PRIORITYNAME", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATUS", "type" : "esriFieldTypeString", "alias" : "STATUS", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATUSNAME", "type" : "esriFieldTypeString", "alias" : "STATUSNAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ISCLOSED", "type" : "esriFieldTypeInteger", "alias" : "ISCLOSED", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ISRECURRINGTEMPLATE", "type" : "esriFieldTypeSmallInteger", "alias" : "ISRECURRINGTEMPLATE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FROMSCHEDULE", "type" : "esriFieldTypeInteger", "alias" : "FROMSCHEDULE", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SCHEDULEWORKORDERID", "type" : "esriFieldTypeInteger", "alias" : "SCHEDULEWORKORDERID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CLOSUREDATE", "type" : "esriFieldTypeDate", "alias" : "CLOSUREDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "CLOSEDBYID", "type" : "esriFieldTypeInteger", "alias" : "CLOSEDBYID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NOTIFICATIONLIST", "type" : "esriFieldTypeString", "alias" : "NOTIFICATIONLIST", "sqlType" : "sqlTypeOther", "length" : 1073741822, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NOTIFICATIONROLES", "type" : "esriFieldTypeString", "alias" : "NOTIFICATIONROLES", "sqlType" : "sqlTypeOther", "length" : 1073741822, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CLOSEDBYNAME", "type" : "esriFieldTypeString", "alias" : "CLOSEDBYNAME", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PARENTWORKORDERID", "type" : "esriFieldTypeInteger", "alias" : "PARENTWORKORDERID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PARENTSERVICEREQUESTID", "type" : "esriFieldTypeInteger", "alias" : "PARENTSERVICEREQUESTID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PARENTID", "type" : "esriFieldTypeString", "alias" : "PARENTID", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PROJECTTITLE", "type" : "esriFieldTypeString", "alias" : "PROJECTTITLE", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PROJECTGROUP", "type" : "esriFieldTypeString", "alias" : "PROJECTGROUP", "sqlType" : "sqlTypeOther", "length" : 40, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LABORCOST", "type" : "esriFieldTypeDouble", "alias" : "LABORCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EQUIPMENTCOST", "type" : "esriFieldTypeDouble", "alias" : "EQUIPMENTCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INVENTORYCOST", "type" : "esriFieldTypeDouble", "alias" : "INVENTORYCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "VENDORCOST", "type" : "esriFieldTypeDouble", "alias" : "VENDORCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OTHERCOST", "type" : "esriFieldTypeDouble", "alias" : "OTHERCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOTALCOST", "type" : "esriFieldTypeDouble", "alias" : "TOTALCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LABORCOSTDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "LABORCOSTDESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EQUIPMENTCOSTDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "EQUIPMENTCOSTDESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INVENTORYCOSTDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "INVENTORYCOSTDESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "VENDORCOSTDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "VENDORCOSTDESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OTHERCOSTDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "OTHERCOSTDESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LABORHOURS", "type" : "esriFieldTypeDouble", "alias" : "LABORHOURS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "VENDORHOURS", "type" : "esriFieldTypeDouble", "alias" : "VENDORHOURS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EQUIPMENTHOURS", "type" : "esriFieldTypeDouble", "alias" : "EQUIPMENTHOURS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EQUIPMENTDISTANCE", "type" : "esriFieldTypeDouble", "alias" : "EQUIPMENTDISTANCE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDLABORCOST", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDLABORCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDEQUIPMENTCOST", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDEQUIPMENTCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDINVENTORYCOST", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDINVENTORYCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDVENDORCOST", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDVENDORCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDOTHERCOST", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDOTHERCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDTOTALCOST", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDTOTALCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDLABORCOSTDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "ESTIMATEDLABORCOSTDESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDEQUIPMENTCOSTDESCRIPT", "type" : "esriFieldTypeString", "alias" : "EstimatedEquipmentCostDescription", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDINVENTORYCOSTDESCRIPT", "type" : "esriFieldTypeString", "alias" : "EstimatedInventoryCostDescription", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDVENDORCOSTDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "ESTIMATEDVENDORCOSTDESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDOTHERCOSTDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "ESTIMATEDOTHERCOSTDESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDLABORHOURS", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDLABORHOURS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDVENDORHOURS", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDVENDORHOURS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDEQUIPMENTHOURS", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDEQUIPMENTHOURS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDEQUIPMENTDISTANCE", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDEQUIPMENTDISTANCE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POINTX", "type" : "esriFieldTypeDouble", "alias" : "POINTX", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POINTY", "type" : "esriFieldTypeDouble", "alias" : "POINTY", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LATITUDE", "type" : "esriFieldTypeDouble", "alias" : "LATITUDE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LONGITUDE", "type" : "esriFieldTypeDouble", "alias" : "LONGITUDE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SPATIALREFERENCE", "type" : "esriFieldTypeInteger", "alias" : "SPATIALREFERENCE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HASMOBILEORIGIN", "type" : "esriFieldTypeInteger", "alias" : "HASMOBILEORIGIN", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DAYSTOCLOSE", "type" : "esriFieldTypeInteger", "alias" : "DaysToClose", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__WATER_AN__F4B70D85EDC1F26E", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_27698.WATER_AND_SEWER_TAPS_OPEN_WATER_SEWER_TAPS_Shape_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Open Water Sewer Taps", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "HASMOBILEORIGIN" : 0, "DAYSTOCLOSE" : null, "ID" : 0, "WORKORDERID" : null, "LOGGEDDATE" : null, "LOGGEDBYID" : null, "LOGGEDBYNAME" : null, "BEGINDATE" : null, "ENDDATE" : null, "DUEDATE" : null, "ASSIGNEDDATE" : null, "ASSIGNEDTOID" : null, "ASSIGNEDTONAME" : null, "ASSIGNEDBYID" : null, "ASSIGNEDBYNAME" : null, "TYPEID" : null, "TYPENAME" : null, "DEPARTMENTID" : null, "DEPARTMENTNAME" : null, "GROUPID" : null, "GROUPNAME" : null, "ACTIVITYDESCRIPTIONID" : null, "ACTIVITYDESCRIPTION" : null, "LOCATION" : null, "DESCRIPTION" : null, "PRIORITY" : null, "PRIORITYNAME" : null, "STATUS" : null, "STATUSNAME" : null, "ISCLOSED" : null, "ISRECURRINGTEMPLATE" : null, "FROMSCHEDULE" : 0, "SCHEDULEWORKORDERID" : null, "CLOSUREDATE" : null, "CLOSEDBYID" : null, "NOTIFICATIONLIST" : null, "NOTIFICATIONROLES" : null, "CLOSEDBYNAME" : null, "PARENTWORKORDERID" : null, "PARENTSERVICEREQUESTID" : null, "PARENTID" : null, "PROJECTTITLE" : null, "PROJECTGROUP" : null, "LABORCOST" : null, "EQUIPMENTCOST" : null, "INVENTORYCOST" : null, "VENDORCOST" : null, "OTHERCOST" : null, "TOTALCOST" : null, "LABORCOSTDESCRIPTION" : null, "EQUIPMENTCOSTDESCRIPTION" : null, "INVENTORYCOSTDESCRIPTION" : null, "VENDORCOSTDESCRIPTION" : null, "OTHERCOSTDESCRIPTION" : null, "LABORHOURS" : null, "VENDORHOURS" : null, "EQUIPMENTHOURS" : null, "EQUIPMENTDISTANCE" : null, "ESTIMATEDLABORCOST" : null, "ESTIMATEDEQUIPMENTCOST" : null, "ESTIMATEDINVENTORYCOST" : null, "ESTIMATEDVENDORCOST" : null, "ESTIMATEDOTHERCOST" : null, "ESTIMATEDTOTALCOST" : null, "ESTIMATEDLABORCOSTDESCRIPTION" : null, "ESTIMATEDEQUIPMENTCOSTDESCRIPT" : null, "ESTIMATEDINVENTORYCOSTDESCRIPT" : null, "ESTIMATEDVENDORCOSTDESCRIPTION" : null, "ESTIMATEDOTHERCOSTDESCRIPTION" : null, "ESTIMATEDLABORHOURS" : null, "ESTIMATEDVENDORHOURS" : null, "ESTIMATEDEQUIPMENTHOURS" : null, "ESTIMATEDEQUIPMENTDISTANCE" : null, "POINTX" : null, "POINTY" : null, "LATITUDE" : null, "LONGITUDE" : null, "SPATIALREFERENCE" : 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", "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" }, { "currentVersion" : 12, "id" : 1, "name" : "Closed Water Sewer Taps", "type" : "Feature Layer", "serviceItemId" : "66ce6b84db8f4b3aaec0361e7afca10c", "cacheMaxAge" : 30, "displayField" : "LOGGEDBYNAME", "description" : "", "copyrightText" : "", "defaultVisibility" : false, "editingInfo" : { "lastEditDate" : 1773837892119, "schemaLastEditDate" : 1773837892119, "dataLastEditDate" : 1773837892119 }, "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" : -1.0001331865787506, "ymin" : -1.0001008808612823, "xmax" : 3324418.974045068, "ymax" : 13690390.810989887, "spatialReference" : { "wkid" : 102740, "latestWkid" : 2278 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"590025e5d615d9c8da039803b697fca8","imageData":"iVBORw0KGgoAAAANSUhEUgAAABcAAAAXCAYAAADgKtSgAAAACXBIWXMAAA7EAAAOxAGVKw4bAAADKElEQVRIibVVXUhTYRj+zraTPxs5Q9zmvJCiCKk0FCLvSiKStB9jaxgEEUlX0tVgXdRVsZvuE28EdZ1DG6HrQsS6K4KUsFhQubxQp2K5wN/pcfF89p5956hNgl44fNu3d8/797zPsbH/aLZ8DqqqurNZS43GmFtiFjfuNqWNwTaf78M/g/eqaq2UtQZX5cILS45S67pcZMnIhRb8VppOhSJKVJMY67ZIWtjn883sGTyixILLdmdowenZl6o4Wmj+ne7K5ifuViVHb0aUWDjgvxrOC96nRCPLDmfT96qT9pVip5Xul+ZS/LSXe3Tf+bKqgl9Oj3z4y5vQMyXqvu5vvbcrOM/Y4WxKVJ/ZT3djkU6WHI7roLOfRvh5InCHP+u2Agv8qxOvb0WU2IxYgU3sMVqBjMWAhxqbOQhlT0EQtKelnt3of8+/fz3S4KgZfRnsVVV92Do4hoceT4yPW5Ov4mx8eIBd6RrQwQDc01zP2t9N6Zm7jtWxF7db2OWufl7BVGV1UeVk4glj7KwODrqBFXxQP0bYWF8nW5ybNswCwXCHjKkS1/E6/tAd/u+dTNQa2gIeg270h4ONFw3AyBoA1A4Ch53ueMDbQ3fpAx5ZUZ6f9/uvDXJwLAh4LLLi3KOnhqxnP24NEiceJEHmKK/QPwMHeHrm2DxaEO7syjlTtqIN3W/XBwnDXGjYwKFN3nGJFmdz/aZMRTN/pwBms5FWYKUxEDgRl/9mlClOsUWl6VQGeDo4eAmtELmdHI7zwRIjxGwxPADDBwwCJWHyxtpm8eKCZpXYjJHnjHVDK7DSxACAAgT9FTeVhj0Uaucncb8knVoHDgmZDg51gwhBK7AQAESAho6HvAJa9229dnl44FOXfJp3MrGqSVq3oecwRIO6QYRIWyhjbKG4qagMVWEzqd/eb29X5Mza44A/p/MGtkB0oG4QIWgFKhAzFrUFBuCi5bTmnf68UvIzFQ/4Ww2yu42KkE2oG0QIWiHquQiM4aHHaMVWxkbgHcGpAqgbRAhagZU2vYkyYAWGhx6LrcgLDvsjm1zdoBXmdyjottvrLS+4aBChvfiZ7TfalqX20swMhgAAAABJRU5ErkJggg==","contentType":"image/png","width":17,"height":17,"angle":0,"xoffset":0,"yoffset":0}},"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" : "", "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" : "ID", "type" : "esriFieldTypeInteger", "alias" : "ID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WORKORDERID", "type" : "esriFieldTypeString", "alias" : "WORKORDERID", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "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" : "LOGGEDBYID", "type" : "esriFieldTypeInteger", "alias" : "LOGGEDBYID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOGGEDBYNAME", "type" : "esriFieldTypeString", "alias" : "LOGGEDBYNAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BEGINDATE", "type" : "esriFieldTypeDate", "alias" : "BEGINDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ENDDATE", "type" : "esriFieldTypeDate", "alias" : "ENDDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "DUEDATE", "type" : "esriFieldTypeDate", "alias" : "DUEDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ASSIGNEDDATE", "type" : "esriFieldTypeDate", "alias" : "ASSIGNEDDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ASSIGNEDTOID", "type" : "esriFieldTypeInteger", "alias" : "ASSIGNEDTOID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ASSIGNEDTONAME", "type" : "esriFieldTypeString", "alias" : "ASSIGNEDTONAME", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ASSIGNEDBYID", "type" : "esriFieldTypeInteger", "alias" : "ASSIGNEDBYID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ASSIGNEDBYNAME", "type" : "esriFieldTypeString", "alias" : "ASSIGNEDBYNAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TYPEID", "type" : "esriFieldTypeInteger", "alias" : "TYPEID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TYPENAME", "type" : "esriFieldTypeString", "alias" : "TYPENAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DEPARTMENTID", "type" : "esriFieldTypeInteger", "alias" : "DEPARTMENTID", "sqlType" : "sqlTypeOther", "nullable" : true, "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" : "GROUPID", "type" : "esriFieldTypeInteger", "alias" : "GROUPID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "GROUPNAME", "type" : "esriFieldTypeString", "alias" : "GROUPNAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ACTIVITYDESCRIPTIONID", "type" : "esriFieldTypeInteger", "alias" : "ACTIVITYDESCRIPTIONID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ACTIVITYDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "ACTIVITYDESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOCATION", "type" : "esriFieldTypeString", "alias" : "LOCATION", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DESCRIPTION", "type" : "esriFieldTypeString", "alias" : "DESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 1073741822, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PRIORITY", "type" : "esriFieldTypeInteger", "alias" : "PRIORITY", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PRIORITYNAME", "type" : "esriFieldTypeString", "alias" : "PRIORITYNAME", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATUS", "type" : "esriFieldTypeString", "alias" : "STATUS", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATUSNAME", "type" : "esriFieldTypeString", "alias" : "STATUSNAME", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ISCLOSED", "type" : "esriFieldTypeInteger", "alias" : "ISCLOSED", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ISRECURRINGTEMPLATE", "type" : "esriFieldTypeSmallInteger", "alias" : "ISRECURRINGTEMPLATE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FROMSCHEDULE", "type" : "esriFieldTypeInteger", "alias" : "FROMSCHEDULE", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SCHEDULEWORKORDERID", "type" : "esriFieldTypeInteger", "alias" : "SCHEDULEWORKORDERID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CLOSUREDATE", "type" : "esriFieldTypeDate", "alias" : "CLOSUREDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "CLOSEDBYID", "type" : "esriFieldTypeInteger", "alias" : "CLOSEDBYID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NOTIFICATIONLIST", "type" : "esriFieldTypeString", "alias" : "NOTIFICATIONLIST", "sqlType" : "sqlTypeOther", "length" : 1073741822, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NOTIFICATIONROLES", "type" : "esriFieldTypeString", "alias" : "NOTIFICATIONROLES", "sqlType" : "sqlTypeOther", "length" : 1073741822, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CLOSEDBYNAME", "type" : "esriFieldTypeString", "alias" : "CLOSEDBYNAME", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PARENTWORKORDERID", "type" : "esriFieldTypeInteger", "alias" : "PARENTWORKORDERID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PARENTSERVICEREQUESTID", "type" : "esriFieldTypeInteger", "alias" : "PARENTSERVICEREQUESTID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PARENTID", "type" : "esriFieldTypeString", "alias" : "PARENTID", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PROJECTTITLE", "type" : "esriFieldTypeString", "alias" : "PROJECTTITLE", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PROJECTGROUP", "type" : "esriFieldTypeString", "alias" : "PROJECTGROUP", "sqlType" : "sqlTypeOther", "length" : 40, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LABORCOST", "type" : "esriFieldTypeDouble", "alias" : "LABORCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EQUIPMENTCOST", "type" : "esriFieldTypeDouble", "alias" : "EQUIPMENTCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INVENTORYCOST", "type" : "esriFieldTypeDouble", "alias" : "INVENTORYCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "VENDORCOST", "type" : "esriFieldTypeDouble", "alias" : "VENDORCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OTHERCOST", "type" : "esriFieldTypeDouble", "alias" : "OTHERCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "TOTALCOST", "type" : "esriFieldTypeDouble", "alias" : "TOTALCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LABORCOSTDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "LABORCOSTDESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EQUIPMENTCOSTDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "EQUIPMENTCOSTDESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INVENTORYCOSTDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "INVENTORYCOSTDESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "VENDORCOSTDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "VENDORCOSTDESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OTHERCOSTDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "OTHERCOSTDESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LABORHOURS", "type" : "esriFieldTypeDouble", "alias" : "LABORHOURS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "VENDORHOURS", "type" : "esriFieldTypeDouble", "alias" : "VENDORHOURS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EQUIPMENTHOURS", "type" : "esriFieldTypeDouble", "alias" : "EQUIPMENTHOURS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EQUIPMENTDISTANCE", "type" : "esriFieldTypeDouble", "alias" : "EQUIPMENTDISTANCE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDLABORCOST", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDLABORCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDEQUIPMENTCOST", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDEQUIPMENTCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDINVENTORYCOST", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDINVENTORYCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDVENDORCOST", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDVENDORCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDOTHERCOST", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDOTHERCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDTOTALCOST", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDTOTALCOST", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDLABORCOSTDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "ESTIMATEDLABORCOSTDESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDEQUIPMENTCOSTDESCRIPT", "type" : "esriFieldTypeString", "alias" : "EstimatedEquipmentCostDescription", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDINVENTORYCOSTDESCRIPT", "type" : "esriFieldTypeString", "alias" : "EstimatedInventoryCostDescription", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDVENDORCOSTDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "ESTIMATEDVENDORCOSTDESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDOTHERCOSTDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "ESTIMATEDOTHERCOSTDESCRIPTION", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDLABORHOURS", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDLABORHOURS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDVENDORHOURS", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDVENDORHOURS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDEQUIPMENTHOURS", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDEQUIPMENTHOURS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDEQUIPMENTDISTANCE", "type" : "esriFieldTypeDouble", "alias" : "ESTIMATEDEQUIPMENTDISTANCE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POINTX", "type" : "esriFieldTypeDouble", "alias" : "POINTX", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POINTY", "type" : "esriFieldTypeDouble", "alias" : "POINTY", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LATITUDE", "type" : "esriFieldTypeDouble", "alias" : "LATITUDE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LONGITUDE", "type" : "esriFieldTypeDouble", "alias" : "LONGITUDE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SPATIALREFERENCE", "type" : "esriFieldTypeInteger", "alias" : "SPATIALREFERENCE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "HASMOBILEORIGIN", "type" : "esriFieldTypeInteger", "alias" : "HASMOBILEORIGIN", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DAYSTOCLOSE", "type" : "esriFieldTypeInteger", "alias" : "DaysToClose", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__WATER_AN__F4B70D85EDC1F26E", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_27698.WATER_AND_SEWER_TAPS_OPEN_WATER_SEWER_TAPS_Shape_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Closed Water Sewer Taps", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "HASMOBILEORIGIN" : 0, "DAYSTOCLOSE" : null, "ID" : 0, "WORKORDERID" : null, "LOGGEDDATE" : null, "LOGGEDBYID" : null, "LOGGEDBYNAME" : null, "BEGINDATE" : null, "ENDDATE" : null, "DUEDATE" : null, "ASSIGNEDDATE" : null, "ASSIGNEDTOID" : null, "ASSIGNEDTONAME" : null, "ASSIGNEDBYID" : null, "ASSIGNEDBYNAME" : null, "TYPEID" : null, "TYPENAME" : null, "DEPARTMENTID" : null, "DEPARTMENTNAME" : null, "GROUPID" : null, "GROUPNAME" : null, "ACTIVITYDESCRIPTIONID" : null, "ACTIVITYDESCRIPTION" : null, "LOCATION" : null, "DESCRIPTION" : null, "PRIORITY" : null, "PRIORITYNAME" : null, "STATUS" : null, "STATUSNAME" : null, "ISCLOSED" : null, "ISRECURRINGTEMPLATE" : null, "FROMSCHEDULE" : 0, "SCHEDULEWORKORDERID" : null, "CLOSUREDATE" : null, "CLOSEDBYID" : null, "NOTIFICATIONLIST" : null, "NOTIFICATIONROLES" : null, "CLOSEDBYNAME" : null, "PARENTWORKORDERID" : null, "PARENTSERVICEREQUESTID" : null, "PARENTID" : null, "PROJECTTITLE" : null, "PROJECTGROUP" : null, "LABORCOST" : null, "EQUIPMENTCOST" : null, "INVENTORYCOST" : null, "VENDORCOST" : null, "OTHERCOST" : null, "TOTALCOST" : null, "LABORCOSTDESCRIPTION" : null, "EQUIPMENTCOSTDESCRIPTION" : null, "INVENTORYCOSTDESCRIPTION" : null, "VENDORCOSTDESCRIPTION" : null, "OTHERCOSTDESCRIPTION" : null, "LABORHOURS" : null, "VENDORHOURS" : null, "EQUIPMENTHOURS" : null, "EQUIPMENTDISTANCE" : null, "ESTIMATEDLABORCOST" : null, "ESTIMATEDEQUIPMENTCOST" : null, "ESTIMATEDINVENTORYCOST" : null, "ESTIMATEDVENDORCOST" : null, "ESTIMATEDOTHERCOST" : null, "ESTIMATEDTOTALCOST" : null, "ESTIMATEDLABORCOSTDESCRIPTION" : null, "ESTIMATEDEQUIPMENTCOSTDESCRIPT" : null, "ESTIMATEDINVENTORYCOSTDESCRIPT" : null, "ESTIMATEDVENDORCOSTDESCRIPTION" : null, "ESTIMATEDOTHERCOSTDESCRIPTION" : null, "ESTIMATEDLABORHOURS" : null, "ESTIMATEDVENDORHOURS" : null, "ESTIMATEDEQUIPMENTHOURS" : null, "ESTIMATEDEQUIPMENTDISTANCE" : null, "POINTX" : null, "POINTY" : null, "LATITUDE" : null, "LONGITUDE" : null, "SPATIALREFERENCE" : 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", "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" : [] }