{ "currentVersion" : 12, "id" : 0, "name" : "Service Points", "type" : "Feature Layer", "serviceItemId" : "6ee1c5b10770451db3ef358e20f04e0f", "cacheMaxAge" : 30, "displayField" : "CUSTOMERNAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1732738248194, "schemaLastEditDate" : 1732738248194, "dataLastEditDate" : 1732738248194 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : true, "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" : 3017498.8358540088, "ymin" : 590507.81042328477, "xmax" : 3086380.2869261652, "ymax" : 680293.39719489217, "spatialReference" : { "wkid" : 102682, "latestWkid" : 3452 } }, "spatialReference" : { "wkid" : 102682, "latestWkid" : 3452 }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"Material_Classification_for_the","field2":"","field3":"","fieldDelimiter":",","defaultSymbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,130,130,255],"size":15,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}},"defaultLabel":"","uniqueValueInfos":[{"value":"Lead Status Unknown","label":"Lead Status Unknown","description":"","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,130,130,255],"size":15,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.6}}}]},"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" : "Material_Classification_for_the", "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" : "LEGACYID", "type" : "esriFieldTypeString", "alias" : "LEGACYID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FACILITYID", "type" : "esriFieldTypeString", "alias" : "FACILITYID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BADGE_NBR", "type" : "esriFieldTypeString", "alias" : "BADGE NBR", "sqlType" : "sqlTypeOther", "length" : 16, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COMM_MODULE_1", "type" : "esriFieldTypeString", "alias" : "COMM_MODULE_1", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COMM_MODULE_2", "type" : "esriFieldTypeString", "alias" : "COMM_MODULE_2", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOCATION", "type" : "esriFieldTypeString", "alias" : "LOCATION", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PREMISE_ID", "type" : "esriFieldTypeString", "alias" : "PREMISE ID", "sqlType" : "sqlTypeOther", "length" : 16, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "METER_SIZE", "type" : "esriFieldTypeString", "alias" : "METER SIZE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WMETERSIZE", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "WATER METER SIZE", "codedValues" : [ { "name" : "NO INFO", "code" : "NO INFO" }, { "name" : "3/4\"", "code" : "34" }, { "name" : "1-1/2\"", "code" : "112" }, { "name" : "1\"", "code" : "1" }, { "name" : "2\"", "code" : "2" }, { "name" : "3\"", "code" : "3" }, { "name" : "4\"", "code" : "4" }, { "name" : "6\"", "code" : "6" }, { "name" : "8\"", "code" : "8" }, { "name" : "10\"", "code" : "10" } ] }, "defaultValue" : null }, { "name" : "SERVICE_TYPE", "type" : "esriFieldTypeString", "alias" : "SERVICE TYPE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WMETERSERVTYPE", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "WATER METER SERVICE TYPE", "codedValues" : [ { "name" : "Bulk Water", "code" : "W-BULK" }, { "name" : "Commercial", "code" : "W-COM" }, { "name" : "Commercial (Water Only)", "code" : "W-CWONLY" }, { "name" : "Commercial Sprinkler", "code" : "W-CSPRKL" }, { "name" : "Commercial Sprinkler-Out of City", "code" : "W-CSPRKO" }, { "name" : "Commercial-Out of City", "code" : "W-COM-O" }, { "name" : "Commercial-Out of City (Water Only)", "code" : "W-CWONLO" }, { "name" : "LUS", "code" : "W-LUS" }, { "name" : "Municipal", "code" : "W-MUNI" }, { "name" : "Residential", "code" : "W-RES" }, { "name" : "Residential (Water Only)", "code" : "W-RWONLY" }, { "name" : "Residential Sprinkler", "code" : "W-RSPRKL" }, { "name" : "Residential Sprinkler-Out of City", "code" : "W-RSPRKO" }, { "name" : "Residential-Out of City", "code" : "W-RES-O" }, { "name" : "Residential-Out of City (Water Only)", "code" : "W-RWONLO" }, { "name" : "Residential-WDN", "code" : "W-RESWDN" }, { "name" : "School/Church", "code" : "W-S/C" }, { "name" : "School/Church-Out of City", "code" : "W-S/C-O" }, { "name" : "University", "code" : "W-UL" }, { "name" : "WasteWater Deduct Meter Service", "code" : "WW-DDUCT" }, { "name" : "WasteWater Deduct Meter Service (AMI)", "code" : "W-WWDDCT" }, { "name" : "Water Deduct Meter Service", "code" : "WR-DDUCT" }, { "name" : "Wholesale", "code" : "W-WHSALE" }, { "name" : "Residential-WDN Sprinkler", "code" : "WDNRSPKL" }, { "name" : "Commercial-WDN", "code" : "W-COMWDN" }, { "name" : "Commercial-WDN (Purple)", "code" : "WDNCPUR" }, { "name" : "Residential-WDN (Purple)", "code" : "WDNRPUR" }, { "name" : "Commercial-WDN Sprinkler", "code" : "WDNCSPKL" } ] }, "defaultValue" : null }, { "name" : "SMART_METER", "type" : "esriFieldTypeString", "alias" : "SMART METER", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WMETERAMI", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "WATER METER AMI", "codedValues" : [ { "name" : "AMI", "code" : "AMI" }, { "name" : "AMI DEDUCT", "code" : "AMI-DD" }, { "name" : "BOX ONLY", "code" : "BOXONLY" }, { "name" : "NON-AMI", "code" : "NON-AMI" }, { "name" : "NON-AMI DEDUCT", "code" : "NON-AMI-DD" }, { "name" : "AMI-BADGER", "code" : "AMI-B" }, { "name" : "AMI DEDUCT-BADGER", "code" : "AMI-DD-B" }, { "name" : "AMI ESERIES-BADGER", "code" : "AMI-ES-B" } ] }, "defaultValue" : null }, { "name" : "MANUFACTURER", "type" : "esriFieldTypeString", "alias" : "MANUFACTURER", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WMETERMFG", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "WATER METER MANUFACTURER", "codedValues" : [ { "name" : "Badger", "code" : "BADGER" }, { "name" : "Bermad", "code" : "BERMAD" }, { "name" : "Elster", "code" : "ELSTER" }, { "name" : "Hays", "code" : "HAYS" }, { "name" : "Hersey", "code" : "HERSEY" }, { "name" : "Itron", "code" : "ITRON" }, { "name" : "Kent", "code" : "KENT" }, { "name" : "Master", "code" : "MASTER" }, { "name" : "Neptune", "code" : "NEPTUNE" }, { "name" : "Rockwell", "code" : "ROCKWELL" }, { "name" : "Schlumberger", "code" : "SCH" }, { "name" : "Sensus", "code" : "SENSUS" }, { "name" : "Unknown", "code" : "UNKNOWNW" } ] }, "defaultValue" : null }, { "name" : "MODEL", "type" : "esriFieldTypeString", "alias" : "MODEL", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WMETERMODEL", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "WATER METER MODEL", "codedValues" : [ { "name" : "Compound", "code" : "COMPND" }, { "name" : "Positive Displacement", "code" : "POSDISPL" }, { "name" : "Turbine", "code" : "TURBINE" }, { "name" : "Unknown", "code" : "UNKNOWN" }, { "name" : "Ultrasonic", "code" : "ULTRASNC" } ] }, "defaultValue" : null }, { "name" : "METER_TYPE", "type" : "esriFieldTypeString", "alias" : "METER TYPE", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WMETERTYPE_1", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "WATER METER TYPE", "codedValues" : [ { "name" : "Compound-3", "code" : "COMPND3" }, { "name" : "Compound-4", "code" : "COMPND4" }, { "name" : "Compound-6", "code" : "COMPND6" }, { "name" : "Model 120", "code" : "M120" }, { "name" : "Model 25", "code" : "M25" }, { "name" : "Model 70", "code" : "M70" }, { "name" : "Regular Register", "code" : "W-SIMPLE" }, { "name" : "Turbo 1000", "code" : "T1000" }, { "name" : "Turbo 200", "code" : "T200" }, { "name" : "Turbo 2000", "code" : "T2000" }, { "name" : "Turbo 3500", "code" : "T3500" }, { "name" : "Turbo 450", "code" : "T450" }, { "name" : "Wastewater Deduct", "code" : "W-DEDUCT" }, { "name" : "Water Deduct", "code" : "WRDEDUCT" }, { "name" : "Model 170", "code" : "M170" }, { "name" : "Compound-8", "code" : "COMPND8" }, { "name" : "Dual Register (Compound)", "code" : "WDUALREG" }, { "name" : "ESERIES", "code" : "ESERIES" }, { "name" : "G2", "code" : "G2" } ] }, "defaultValue" : null }, { "name" : "DIAL1_NBR", "type" : "esriFieldTypeString", "alias" : "DIAL1 NBR", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WMETERDIAL _1", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "WATER METER DIAL", "codedValues" : [ { "name" : "0", "code" : "0" }, { "name" : "4", "code" : "4" }, { "name" : "5", "code" : "5" }, { "name" : "6", "code" : "6" }, { "name" : "7", "code" : "7" }, { "name" : "8", "code" : "8" }, { "name" : "9", "code" : "9" } ] }, "defaultValue" : null }, { "name" : "DIAL2_NBR", "type" : "esriFieldTypeString", "alias" : "DIAL2 NBR", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WMETERDIAL _1", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "WATER METER DIAL", "codedValues" : [ { "name" : "0", "code" : "0" }, { "name" : "4", "code" : "4" }, { "name" : "5", "code" : "5" }, { "name" : "6", "code" : "6" }, { "name" : "7", "code" : "7" }, { "name" : "8", "code" : "8" }, { "name" : "9", "code" : "9" } ] }, "defaultValue" : null }, { "name" : "MULTIPLIER1", "type" : "esriFieldTypeDouble", "alias" : "MULTIPLIER1", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MULTIPLIER2", "type" : "esriFieldTypeDouble", "alias" : "MULTIPLIER2", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STOCK_NBR", "type" : "esriFieldTypeString", "alias" : "STOCK NBR", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INSTALL_DATE", "type" : "esriFieldTypeDate", "alias" : "INSTALL DATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "GPSDATE", "type" : "esriFieldTypeDate", "alias" : "GPS DATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "GPSBY", "type" : "esriFieldTypeString", "alias" : "GPSBY", "sqlType" : "sqlTypeOther", "length" : 75, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "XLUS", "type" : "esriFieldTypeDouble", "alias" : "X-LUS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "YLUS", "type" : "esriFieldTypeDouble", "alias" : "Y-LUS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MAINID", "type" : "esriFieldTypeString", "alias" : "MAINID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "COMMENTS", "type" : "esriFieldTypeString", "alias" : "COMMENTS", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ENABLED", "type" : "esriFieldTypeSmallInteger", "alias" : "ENABLED", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "EnabledDomain", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "False", "code" : 0 }, { "name" : "True", "code" : 1 } ] }, "defaultValue" : 1 }, { "name" : "CUSTOMERNAME", "type" : "esriFieldTypeString", "alias" : "CUSTOMER NAME", "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" : { "type" : "codedValue", "name" : "WSTATUS", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Water Status-All Scenarios", "codedValues" : [ { "name" : "ABANDONED", "code" : "AB" }, { "name" : "IN SERVICE", "code" : "IS" }, { "name" : "NOT CONFIRMED", "code" : "NA" }, { "name" : "OUT OF SERVICE", "code" : "OS" }, { "name" : "REMOVED", "code" : "REM" }, { "name" : "RESEARCH", "code" : "RESEARCH" } ] }, "defaultValue" : "OS" }, { "name" : "LOC_COMMENTS", "type" : "esriFieldTypeString", "alias" : "LOC COMMENTS", "sqlType" : "sqlTypeOther", "length" : 255, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "USAGELAST1", "type" : "esriFieldTypeInteger", "alias" : "USAGE LAST 1 (GAL)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 0 }, { "name" : "USAGELAST12", "type" : "esriFieldTypeInteger", "alias" : "USAGE LAST 12 AVG (GAL)", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : 0 }, { "name" : "GPS", "type" : "esriFieldTypeString", "alias" : "GPS", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WGPS_STATUS", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Water Asset GPS Status", "codedValues" : [ { "name" : "YES", "code" : "1" }, { "name" : "NO", "code" : "2" }, { "name" : "CAN NOT LOCATE", "code" : "3" }, { "name" : "N/A", "code" : "4" }, { "name" : "FINAL CAN NOT LOCATE", "code" : "5" } ] }, "defaultValue" : null }, { "name" : "SERVICE_ID", "type" : "esriFieldTypeString", "alias" : "SERVICE_ID", "sqlType" : "sqlTypeOther", "length" : 20, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CYCLE", "type" : "esriFieldTypeString", "alias" : "CYCLE", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ROUTE", "type" : "esriFieldTypeString", "alias" : "ROUTE", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "OP_AREA", "type" : "esriFieldTypeString", "alias" : "OP_AREA", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INSTALL_TYPE", "type" : "esriFieldTypeString", "alias" : "INSTALL_TYPE", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WMETERINSTYPE", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Water Meter Service Type", "codedValues" : [ { "name" : "LONG SIDE", "code" : "LS" }, { "name" : "SHORT SIDE", "code" : "SS" }, { "name" : "NO INFO", "code" : "NOINFO" } ] }, "defaultValue" : null }, { "name" : "ADDRESS", "type" : "esriFieldTypeString", "alias" : "ADDRESS_CCB", "sqlType" : "sqlTypeOther", "length" : 70, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PHONE_TYPE", "type" : "esriFieldTypeString", "alias" : "PHONE TYPE", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PHONE", "type" : "esriFieldTypeDouble", "alias" : "PHONE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "REMOVE_DATE", "type" : "esriFieldTypeDate", "alias" : "REMOVE DATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ERP_BOIL", "type" : "esriFieldTypeString", "alias" : "ERP_BOIL", "sqlType" : "sqlTypeOther", "length" : 12, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WERPCC", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "ERP_CRITICAL", "codedValues" : [ { "name" : "N/A", "code" : "N/A" }, { "name" : "DAY CARE", "code" : "DAY CARE" }, { "name" : "DIALYSIS", "code" : "DIALYSIS" }, { "name" : "HOSPITAL", "code" : "HOSPITAL" }, { "name" : "HOTEL", "code" : "HOTEL" }, { "name" : "LG USE CUST", "code" : "LG USE CUST" }, { "name" : "SCHOOL", "code" : "SCHOOL" }, { "name" : "SR/ASST HOME", "code" : "SR/ASST HOME" }, { "name" : "TRANSIT CTR", "code" : "TRANSIT CTR" }, { "name" : "WHOLESALE", "code" : "WHOLESALE" }, { "name" : "MEDICAL BLDG", "code" : "MEDICAL BLDG" }, { "name" : "GOVT BLDG", "code" : "GOVT BLDG" }, { "name" : "FOOD EST", "code" : "FOOD EST" }, { "name" : "ERP/BOIL", "code" : "ERP/BOIL" } ] }, "defaultValue" : null }, { "name" : "LID_TYPE", "type" : "esriFieldTypeString", "alias" : "LID_TYPE", "sqlType" : "sqlTypeOther", "length" : 16, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WMETERBOXLIDTYPE ", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "Waster MeterBox LID", "codedValues" : [ { "name" : "ALUMINUM", "code" : "ALUMINUM" }, { "name" : "COMPOSITE", "code" : "COMPOSITE" }, { "name" : "STEEL", "code" : "STEEL" } ] }, "defaultValue" : null }, { "name" : "CREATEUSER", "type" : "esriFieldTypeString", "alias" : "CREATEUSER", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DATECREATED", "type" : "esriFieldTypeDate", "alias" : "DATECREATED", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "LASTUSER", "type" : "esriFieldTypeString", "alias" : "LASTUSER", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DATEMODIFIED", "type" : "esriFieldTypeDate", "alias" : "DATEMODIFIED", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "MODULE_TYPE", "type" : "esriFieldTypeString", "alias" : "MODULE_TYPE", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "WMETERMODULE", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "description" : "WATER METER MODULE TYPE", "codedValues" : [ { "name" : "Honeywell", "code" : "HONEYWELL" }, { "name" : "None", "code" : "NONE" }, { "name" : "Badger", "code" : "BADGER" } ] }, "defaultValue" : null }, { "name" : "ACCT_ID", "type" : "esriFieldTypeString", "alias" : "ACCT_ID", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Street_Address", "type" : "esriFieldTypeString", "alias" : "Street Address", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "City", "type" : "esriFieldTypeString", "alias" : "City", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "State", "type" : "esriFieldTypeString", "alias" : "State", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Zip", "type" : "esriFieldTypeInteger", "alias" : "Zip", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Unique_Service_Line_ID", "type" : "esriFieldTypeDouble", "alias" : "Unique Service Line ID", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "System_Owned_Service_Line_Mater", "type" : "esriFieldTypeString", "alias" : "System-Owned Service Line Material", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PWSID__Autofill_", "type" : "esriFieldTypeString", "alias" : "PWSID\n(Autofill)", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "System_Name__Autofill_", "type" : "esriFieldTypeString", "alias" : "System Name\n(Autofill)", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Customer_Owned_Service_Line_Mat", "type" : "esriFieldTypeString", "alias" : "Customer-Owned Service Line Material", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Material_Classification_for_the", "type" : "esriFieldTypeString", "alias" : "Material Classification for the Entire Service Line\n(Autofill)", "sqlType" : "sqlTypeOther", "length" : 8000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__SERVICE___F4B70D850D89FBE9", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_42403.SERVICE_LEAD_SERVICE_LATERAL_INVENTORY_SERVICE_POINTS_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [ { "id" : "Lead Status Unknown", "name" : "Lead Status Unknown", "domains" : { "METER_SIZE" : {"type" : "inherited"}, "SERVICE_TYPE" : {"type" : "inherited"}, "SMART_METER" : {"type" : "inherited"}, "MANUFACTURER" : {"type" : "inherited"}, "MODEL" : {"type" : "inherited"}, "METER_TYPE" : {"type" : "inherited"}, "DIAL1_NBR" : {"type" : "inherited"}, "DIAL2_NBR" : {"type" : "inherited"}, "ENABLED" : {"type" : "inherited"}, "STATUS" : {"type" : "inherited"}, "GPS" : {"type" : "inherited"}, "INSTALL_TYPE" : {"type" : "inherited"}, "ERP_BOIL" : {"type" : "inherited"}, "LID_TYPE" : {"type" : "inherited"}, "MODULE_TYPE" : {"type" : "inherited"} }, "templates" : [ { "name" : "Lead Status Unknown", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "Customer_Owned_Service_Line_Mat" : null, "Material_Classification_for_the" : "Lead Status Unknown", "LEGACYID" : null, "FACILITYID" : null, "BADGE_NBR" : null, "COMM_MODULE_1" : null, "COMM_MODULE_2" : null, "LOCATION" : null, "PREMISE_ID" : null, "METER_SIZE" : null, "SERVICE_TYPE" : null, "SMART_METER" : null, "MANUFACTURER" : null, "MODEL" : null, "METER_TYPE" : null, "DIAL1_NBR" : null, "DIAL2_NBR" : null, "MULTIPLIER1" : null, "MULTIPLIER2" : null, "STOCK_NBR" : null, "INSTALL_DATE" : null, "GPSDATE" : null, "GPSBY" : null, "XLUS" : null, "YLUS" : null, "MAINID" : null, "COMMENTS" : null, "ENABLED" : 1, "CUSTOMERNAME" : null, "STATUS" : "OS", "LOC_COMMENTS" : null, "USAGELAST1" : 0, "USAGELAST12" : 0, "GPS" : null, "SERVICE_ID" : null, "CYCLE" : null, "ROUTE" : null, "OP_AREA" : null, "INSTALL_TYPE" : null, "ADDRESS" : null, "PHONE_TYPE" : null, "PHONE" : null, "REMOVE_DATE" : null, "ERP_BOIL" : null, "LID_TYPE" : null, "CREATEUSER" : null, "DATECREATED" : null, "LASTUSER" : null, "DATEMODIFIED" : null, "MODULE_TYPE" : null, "ACCT_ID" : null, "Street_Address" : null, "City" : null, "State" : null, "Zip" : null, "Unique_Service_Line_ID" : null, "System_Owned_Service_Line_Mater" : null, "PWSID__Autofill_" : null, "System_Name__Autofill_" : null } } } ] } ], "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" }