{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "premnum", "role": "esriRelRoleDestination", "composite": false, "name": "Premise", "relatedTableId": 37, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 29, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "wtrSAPMeter", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "devicecat": null, "installtype": null, "receiveddt": null, "mtrmanuf": null, "equipnum": null, "mtrlat": null, "warrntydt": null, "med": null, "manufdate": null, "installdt": null, "high": null, "low": null, "mtrlong": null, "premnum": null, "mtrsize": null, "last_edited_date": null, "installnum": null, "mtrstatus": null, "created_user": null, "ratecat": null, "mtrservid": null, "mtrserial": null, "pipematcs": null, "last_edited_user": null, "mtrmodel": null, "stkrmloca": null, "created_date": null, "objectid": 0 } } } ], "supportsAdvancedQueries": true, "currentVersion": 10.91, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid_1", "supportsQuantizationEditMode": true, "name": "wtrSAPMeter", "displayField": "mtrserial", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "objectid", "alias": "OBJECTID", "type": "esriFieldTypeInteger" }, { "modelName": "devicecat", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "devicecat", "length": 24, "alias": "DeviceCat", "type": "esriFieldTypeString" }, { "modelName": "equipnum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "equipnum", "length": 15, "alias": "Unique Identifier", "type": "esriFieldTypeString" }, { "modelName": "created_user", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_user", "length": 12, "alias": "created_user", "type": "esriFieldTypeString" }, { "modelName": "created_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "created_date", "type": "esriFieldTypeDate" }, { "modelName": "last_edited_user", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 12, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "modelName": "last_edited_date", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "last_edited_date", "length": 29, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID_1", "domain": null, "name": "objectid_1", "alias": "OBJECTID_1" }, { "modelName": "mtrserial", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mtrserial", "length": 15, "alias": "MtrSerial", "type": "esriFieldTypeString" }, { "modelName": "premnum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "premnum", "length": 15, "alias": "PremNum", "type": "esriFieldTypeString" }, { "modelName": "mtrservid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mtrservid", "length": 16, "alias": "MtrServID", "type": "esriFieldTypeString" }, { "modelName": "MtrManuf", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "WtrMeterManuf", "description": "", "type": "codedValue", "codedValues": [ { "code": "A_American", "name": "A_American" }, { "code": "B_Badger", "name": "B_Badger" }, { "code": "C_Carlon", "name": "C_Carlon" }, { "code": "D_Keystone", "name": "D_Keystone" }, { "code": "E_ELSTER", "name": "E_ELSTER" }, { "code": "H_Hersey", "name": "H_Hersey" }, { "code": "K_Kent", "name": "K_Kent" }, { "code": "M_Master Meter Co", "name": "M_Master Meter Co" }, { "code": "M_Metron", "name": "M_Metron" }, { "code": "N_Neptune", "name": "N_Neptune" }, { "code": "P_Pittsburg", "name": "P_Pittsburg" }, { "code": "R_Rockwell", "name": "R_Rockwell" }, { "code": "S_Sensus", "name": "S_Sensus" }, { "code": "S_Sewer", "name": "S_Sewer" }, { "code": "T_Trident", "name": "T_Trident" }, { "code": "W_Worth", "name": "W_Worth" }, { "code": "O_Other", "name": "O_Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "mtrmanuf", "length": 25, "alias": "MtrManuf", "type": "esriFieldTypeString" }, { "modelName": "mtrmodel", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mtrmodel", "length": 25, "alias": "MtrModel", "type": "esriFieldTypeString" }, { "modelName": "MtrSize", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "WtrMeterSize", "description": "", "type": "codedValue", "codedValues": [ { "code": "3/4\"", "name": "3/4\"" }, { "code": "5/8\"", "name": "5/8\"" }, { "code": "1\"", "name": "1\"" }, { "code": "1 1/2\"", "name": "1 1/2\"" }, { "code": "2\"", "name": "2\"" }, { "code": "3\"", "name": "3\"" }, { "code": "4\"", "name": "4\"" }, { "code": "6\"", "name": "6\"" }, { "code": "8\"", "name": "8\"" }, { "code": "10\"", "name": "10\"" }, { "code": "12\"", "name": "12\"" }, { "code": "16\"", "name": "16\"" }, { "code": "20\"", "name": "20\"" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "mtrsize", "length": 6, "alias": "MtrSize", "type": "esriFieldTypeString" }, { "modelName": "MtrStatus", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "WtrMeterStat", "description": "", "type": "codedValue", "codedValues": [ { "code": "AVLB", "name": "AVLB" }, { "code": "DLFL", "name": "DLFL" }, { "code": "ESTO", "name": "ESTO" }, { "code": "INST", "name": "INST" }, { "code": "RETD", "name": "RETD" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "mtrstatus", "length": 4, "alias": "MtrStatus", "type": "esriFieldTypeString" }, { "modelName": "stkrmloca", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stkrmloca", "length": 25, "alias": "StkRmLoca", "type": "esriFieldTypeString" }, { "modelName": "low", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "low", "alias": "Low", "type": "esriFieldTypeDouble" }, { "modelName": "med", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "med", "alias": "Med", "type": "esriFieldTypeDouble" }, { "modelName": "high", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "high", "alias": "High", "type": "esriFieldTypeDouble" }, { "modelName": "pipematcs", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pipematcs", "alias": "PipeMatCS", "type": "esriFieldTypeInteger" }, { "modelName": "mtrlat", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mtrlat", "alias": "MtrLat", "type": "esriFieldTypeDouble" }, { "modelName": "mtrlong", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mtrlong", "alias": "MtrLong", "type": "esriFieldTypeDouble" }, { "modelName": "manufdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "manufdate", "length": 29, "alias": "ManufDate", "type": "esriFieldTypeDate" }, { "modelName": "receiveddt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "receiveddt", "length": 29, "alias": "ReceivedDt", "type": "esriFieldTypeDate" }, { "modelName": "installdt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "installdt", "length": 29, "alias": "InstallDt", "type": "esriFieldTypeDate" }, { "modelName": "warrntydt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "warrntydt", "length": 29, "alias": "WarrntyDt", "type": "esriFieldTypeDate" }, { "modelName": "InstallNum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "installnum", "length": 20, "alias": "InstallNum", "type": "esriFieldTypeString" }, { "modelName": "installtype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "installtype", "length": 20, "alias": "InstallType", "type": "esriFieldTypeString" }, { "modelName": "ratecat", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ratecat", "length": 10, "alias": "RateCat", "type": "esriFieldTypeString" }, { "modelName": "creationdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creationdate", "length": 29, "alias": "CreationDate", "type": "esriFieldTypeDate" }, { "modelName": "creator", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "creator", "length": 255, "alias": "Creator", "type": "esriFieldTypeString" }, { "modelName": "editdate", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editdate", "length": 29, "alias": "EditDate", "type": "esriFieldTypeDate" }, { "modelName": "editor", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "editor", "length": 255, "alias": "Editor", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "indexes": [ { "name": "g1365premnum", "isUnique": false, "description": "", "fields": "premnum", "isAscending": true }, { "name": "i1365objectid", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "r425_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid_1", "isAscending": true }, { "name": "uuid_425", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "editdate", "editorField": "editor", "creationDateField": "creationdate", "creatorField": "creator" }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsStatistics": true, "supportsQueryWithResultType": true, "supportsOrderBy": true, "supportsLod": false, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAttachments": true, "supportsQueryDateBins": false, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsQueryWithLodSR": false, "supportsTopFeaturesQuery": true, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "eef310124b8f4299aae27a1d5f4bcb8d", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Create,Editing,Uploads,Query,Update,Delete", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "copyrightText": "", "zDefault": 0 } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 642056.3556095809, "xmin": 1564489.8129232824, "ymax": 824264.8074823767, "xmax": 1708128.8528319448, "spatialReference": { "falseM": -100000, "xyTolerance": 0.0010240000009536746, "mUnits": 10000, "zUnits": 1, "latestWkid": 3734, "zTolerance": 2, "wkid": 102722, "xyUnits": 3.7240637144144125E7, "mTolerance": 2, "falseX": -118963900, "falseY": -96373800, "falseZ": 0 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "premnum", "role": "esriRelRoleOrigin", "composite": false, "name": "WTRSAPMETER", "relatedTableId": 29, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 37, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "Premise", "allowTrueCurvesUpdates": false, "displayField": "streetname", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "wsl_id", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "wsl_id", "length": 16, "alias": "WSL_ID", "type": "esriFieldTypeString" }, { "modelName": "streetnum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "streetnum", "length": 10, "alias": "StreetNum", "type": "esriFieldTypeString" }, { "modelName": "dir", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "dir", "length": 6, "alias": "Dir", "type": "esriFieldTypeString" }, { "modelName": "streetname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "streetname", "length": 60, "alias": "StreetName", "type": "esriFieldTypeString" }, { "modelName": "streettype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "streettype", "length": 10, "alias": "StreetType", "type": "esriFieldTypeString" }, { "modelName": "postdir", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "postdir", "length": 6, "alias": "PostDir", "type": "esriFieldTypeString" }, { "modelName": "aptunit", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "aptunit", "length": 10, "alias": "AptUnit", "type": "esriFieldTypeString" }, { "modelName": "city", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 40, "alias": "City", "type": "esriFieldTypeString" }, { "modelName": "state", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "state", "length": 2, "alias": "State", "type": "esriFieldTypeString" }, { "modelName": "zip", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zip", "length": 12, "alias": "Zip", "type": "esriFieldTypeString" }, { "modelName": "sapaddrnum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "sapaddrnum", "length": 16, "alias": "SAPaddrNum", "type": "esriFieldTypeString" }, { "modelName": "keywords", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "keywords", "length": 40, "alias": "Keywords", "type": "esriFieldTypeString" }, { "modelName": "building", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "building", "length": 40, "alias": "Building", "type": "esriFieldTypeString" }, { "modelName": "assessorno", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assessorno", "length": 16, "alias": "AssessorNo", "type": "esriFieldTypeString" }, { "modelName": "parcelno", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parcelno", "length": 16, "alias": "ParcelNo", "type": "esriFieldTypeString" }, { "modelName": "parcelseq", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "parcelseq", "alias": "ParcelSeq", "type": "esriFieldTypeInteger" }, { "modelName": "PremNum", "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "premnum", "length": 16, "alias": "PremNum", "type": "esriFieldTypeString" }, { "modelName": "premtype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "premtype", "length": 4, "alias": "PremType", "type": "esriFieldTypeString" }, { "modelName": "premaddr", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "premaddr", "length": 255, "alias": "PremAddr", "type": "esriFieldTypeString" }, { "modelName": "ServType", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "WtrPremiseInstallType", "description": "", "type": "codedValue", "codedValues": [ { "code": "WTR", "name": "WTR" }, { "code": "ALTS", "name": "ALTS" }, { "code": "FIRE", "name": "FIRE" }, { "code": "IRRG", "name": "IRRG" }, { "code": "ONLYW", "name": "ONLYW" }, { "code": "HYD", "name": "HYD" }, { "code": "GARB", "name": "GARB" }, { "code": "ONLYS", "name": "ONLYS" }, { "code": "SWR", "name": "SWR" }, { "code": "SWTR", "name": "SWTR" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "servtype", "length": 16, "alias": "ServType", "type": "esriFieldTypeString" }, { "modelName": "mslat", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mslat", "alias": "MSlat", "type": "esriFieldTypeDouble" }, { "modelName": "mslong", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "mslong", "alias": "MSlong", "type": "esriFieldTypeDouble" }, { "modelName": "curblat", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "curblat", "alias": "CurbLat", "type": "esriFieldTypeDouble" }, { "modelName": "curblong", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "curblong", "alias": "CurbLong", "type": "esriFieldTypeDouble" }, { "modelName": "centroid_x", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "centroid_x", "alias": "Centroid_X", "type": "esriFieldTypeDouble" }, { "modelName": "centroid_y", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "centroid_y", "alias": "Centroid_Y", "type": "esriFieldTypeDouble" }, { "modelName": "bpname", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bpname", "length": 145, "alias": "BPname", "type": "esriFieldTypeString" }, { "modelName": "bpnumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "bpnumber", "length": 30, "alias": "BPnumber", "type": "esriFieldTypeString" }, { "modelName": "phone", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "phone", "length": 30, "alias": "Phone", "type": "esriFieldTypeString" }, { "modelName": "acctnum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "acctnum", "length": 20, "alias": "AcctNum", "type": "esriFieldTypeString" }, { "modelName": "accttype", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "accttype", "length": 1, "alias": "AcctType", "type": "esriFieldTypeString" }, { "modelName": "regstgrp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "regstgrp", "length": 16, "alias": "RegStGrp", "type": "esriFieldTypeString" }, { "modelName": "installnum", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "installnum", "length": 16, "alias": "InstallNum", "type": "esriFieldTypeString" }, { "modelName": "deviceloc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "deviceloc", "length": 16, "alias": "DeviceLoc", "type": "esriFieldTypeString" }, { "modelName": "conobjid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "conobjid", "length": 16, "alias": "ConObjID", "type": "esriFieldTypeString" }, { "modelName": "tapdesc", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tapdesc", "length": 255, "alias": "TapDesc", "type": "esriFieldTypeString" }, { "modelName": "tapid", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tapid", "length": 80, "alias": "TapID", "type": "esriFieldTypeString" }, { "modelName": "installdate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "installdate", "length": 16, "alias": "InstallDate", "type": "esriFieldTypeString" }, { "modelName": "conobjsize", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "conobjsize", "length": 100, "alias": "ConObjSize", "type": "esriFieldTypeString" }, { "modelName": "tapnotes", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tapnotes", "length": 255, "alias": "TapNotes", "type": "esriFieldTypeString" }, { "modelName": "tapkilled", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "tapkilled", "length": 24, "alias": "TapKilled", "type": "esriFieldTypeString" }, { "modelName": "Created_User", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 12, "alias": "Created_User", "type": "esriFieldTypeString" }, { "modelName": "Created_date", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_date", "length": 29, "alias": "Created_date", "type": "esriFieldTypeDate" }, { "modelName": "Last_edited_user", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 12, "alias": "Last_edited_user", "type": "esriFieldTypeString" }, { "modelName": "Last_edited_date", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_date", "length": 29, "alias": "Last_edited_date", "type": "esriFieldTypeDate" }, { "modelName": "Division", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "wtrDivisionNum", "description": "10,20,30,40", "type": "codedValue", "codedValues": [ { "code": "10", "name": "10" }, { "code": "20", "name": "20" }, { "code": "30", "name": "30" }, { "code": "40", "name": "40" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "division", "length": 16, "alias": "Division", "type": "esriFieldTypeString" }, { "modelName": "Status", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "WtrPremiseStatus", "description": "Active Inactive", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Inactive", "name": "Inactive" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "status", "length": 25, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "Address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 4000, "alias": "Address", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "g1367premnum", "isUnique": false, "description": "", "fields": "premnum", "isAscending": true }, { "name": "r426_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a332_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true }, { "name": "uuid_426", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 4514, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "eef310124b8f4299aae27a1d5f4bcb8d", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [ { "templates": [ { "name": "Active", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "bpname": null, "postdir": null, "installdate": null, "keywords": null, "streetname": null, "city": null, "acctnum": null, "tapdesc": null, "streetnum": null, "premaddr": null, "dir": null, "parcelseq": null, "mslat": null, "building": null, "division": null, "bpnumber": null, "sapaddrnum": null, "premnum": " ", "conobjsize": null, "curblat": null, "state": null, "tapnotes": null, "assessorno": null, "aptunit": null, "zip": null, "installnum": null, "parcelno": null, "address": null, "mslong": null, "centroid_x": null, "servtype": null, "centroid_y": null, "deviceloc": null, "accttype": null, "tapid": null, "streettype": null, "curblong": null, "phone": null, "conobjid": null, "regstgrp": null, "wsl_id": null, "premtype": null, "status": "Active", "tapkilled": null } } } ], "name": "Active", "domains": { "division": {"type": "inherited"}, "servtype": {"type": "inherited"}, "status": {"type": "inherited"} }, "id": "Active" }, { "templates": [ { "name": "Inactive", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "bpname": null, "postdir": null, "installdate": null, "keywords": null, "streetname": null, "city": null, "acctnum": null, "tapdesc": null, "streetnum": null, "premaddr": null, "dir": null, "parcelseq": null, "mslat": null, "building": null, "division": null, "bpnumber": null, "sapaddrnum": null, "premnum": " ", "conobjsize": null, "curblat": null, "state": null, "tapnotes": null, "assessorno": null, "aptunit": null, "zip": null, "installnum": null, "parcelno": null, "address": null, "mslong": null, "centroid_x": null, "servtype": null, "centroid_y": null, "deviceloc": null, "accttype": null, "tapid": null, "streettype": null, "curblong": null, "phone": null, "conobjid": null, "regstgrp": null, "wsl_id": null, "premtype": null, "status": "Inactive", "tapkilled": null } } } ], "name": "Inactive", "domains": { "division": {"type": "inherited"}, "servtype": {"type": "inherited"}, "status": {"type": "inherited"} }, "id": "Inactive" } ], "capabilities": "Create,Editing,Uploads,Query,Update,Delete", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 4000, "typeIdField": "status", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "field1": "status", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 252, 214, 187, 255 ], "fromColor": [ 252, 214, 187, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 179, 179, 252, 255 ], "fromColor": [ 179, 179, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 179, 252, 251, 255 ], "fromColor": [ 179, 252, 251, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 182, 252, 179, 255 ], "fromColor": [ 182, 252, 179, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 182, 219, 255 ], "fromColor": [ 252, 182, 219, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 215, 223, 252, 255 ], "fromColor": [ 215, 223, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 249, 252, 182, 255 ], "fromColor": [ 249, 252, 182, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 215, 252, 220, 255 ], "fromColor": [ 215, 252, 220, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 182, 184, 255 ], "fromColor": [ 252, 182, 184, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 238, 182, 252, 255 ], "fromColor": [ 238, 182, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 247, 212, 255 ], "fromColor": [ 252, 247, 212, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 249, 215, 252, 255 ], "fromColor": [ 249, 215, 252, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 252, 215, 218, 255 ], "fromColor": [ 252, 215, 218, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" } }, "defaultSymbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAtUlEQVRIie2WQQ6CMBBF32AvIWeSa+iGhTcw3MCFGz0HZ4JLEOqiIAm1BOOkIdq/66ST17R/fmqIKLNNWGlzMvZevaflJo0ubMcd4eDVMx7ASRemoI3ChFXvogNT0D/ASptjuCzsLYL1sw13dVTjHE4wN7DHDw46arnPzeEMFkEJpgzraRHq19pPjALepL6lXpsuE8zZM2RvBnv7rhMarpJSP8F+FtZRDaEaAebm8KuvQdRrfAIMLSJCgM0PxAAAAABJRU5ErkJggg==", "yoffset": 0, "width": 20, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "b814c8f45b843896d52da5a7d85244ac", "height": 20 }, "defaultLabel": "", "uniqueValueInfos": [ { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA0klEQVRIieWWzw2CMBhH34El6BBc6hg4g0cHYAB1AAZwDi8mztCLQ7RreGkEm/4B2yCRl3Dp1+YRvl9pKxakWqNMAmeg9tQMsC8pE0DbeQr98DKqlAyAiGwSq+xZCkHpz5jLz2SCIdrCmeeL/BgZqSlAu7Ir0IZWNJHxJ5wSsp0rqzv88Y5xj9R6PrfGNgLyvzLjNnRMgz8MB+ARdxif7Eh4v8hQvK3oQvh39R4fy7R9vkEBt9SkbQRkw7I5V4AcmQJUQGaYcErPkWnsMZHDoj17AeqPIhTxj1U+AAAAAElFTkSuQmCC", "yoffset": 0, "width": 20, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "d4aa48d97c5e5366390e3b1d386dc9c8", "height": 20 }, "label": "Active", "value": "Active" }, { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA60lEQVRIieWVwQ2CMBSGPxJ2ILAGXGQGdALvjkEZwy1M2AEudgSvEKeoB5AItrUJRIn8x76Xfs3r/7c+X5S/OpiCGBBAqCm3HuwXgwERkCHS94qoUBB7IJeCdcp3Wpir1ndnDopYfIwz9RuY6kbxtHY06dNZ/lWxMtekB80IBpyBzLxdYF6X99xyEAkkU1iISPX2tul6NNeKehSNDRjkr2EtojK/dXGgN8PhAuXNxmh1sBPdV6JFGe3dgQrMz9WwPsD64DW6bktghw09KD81bcMgW4YV9VdgEpCGDLY4/NLOsD4WiePB5sGW0gOJzzM+nBiiBAAAAABJRU5ErkJggg==", "yoffset": 0, "width": 20, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "4a2ae5fb556044a2b87d8a890e516a50", "height": 20 }, "label": "Inactive", "value": "Inactive" } ], "type": "uniqueValue", "fieldDelimiter": "," }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "Shape", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint" }, { "isCoGoEnabled": false, "extent": { "ymin": 672105.771118179, "xmin": 1599359.8450927734, "ymax": 754176.604675293, "xmax": 1707612.573486358, "spatialReference": { "falseM": -100000, "xyTolerance": 0.0010240000009536746, "mUnits": 10000, "zUnits": 1, "latestWkid": 3734, "zTolerance": 2, "wkid": 102722, "xyUnits": 3.7240637144144125E7, "mTolerance": 2, "falseX": -118963900, "falseY": -96373800, "falseZ": 0 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "definitionQuery": "Status LIKE 'I' OR Status LIKE 'C'", "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "2.9.0", "isDataArchived": false, "id": 42, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 10.91, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": false, "supportedSqlFormatsInCalculate": [ "standard" ] }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "name": "wtrServiceLateral", "allowTrueCurvesUpdates": false, "displayField": "stname", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "modelName": "AssetID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "assetid", "length": 20, "alias": "AssetID", "type": "esriFieldTypeString" }, { "modelName": "LegacyID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "legacyid", "length": 20, "alias": "LegacyID", "type": "esriFieldTypeString" }, { "modelName": "InstallationDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "installationdate", "length": 29, "alias": "InstallationDate", "type": "esriFieldTypeDate" }, { "modelName": "Location", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "location", "length": 250, "alias": "Location", "type": "esriFieldTypeString" }, { "modelName": "Status", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wtrServiceStatus_1", "description": "", "type": "codedValue", "codedValues": [ { "code": "A", "name": "Abandoned" }, { "code": "EOC", "name": "End of Contract" }, { "code": "P", "name": "Abandoned and Filled" }, { "code": "F", "name": "Frozen" }, { "code": "I", "name": "In Service" }, { "code": "O", "name": "Out of Service" }, { "code": "R", "name": "Removed" }, { "code": "K", "name": "Killed" }, { "code": "X", "name": "Inactive" }, { "code": "C", "name": "Construction" }, { "code": "PMAS", "name": "Private Main Affecting System" }, { "code": "PR", "name": "Proposed" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "status", "length": 10, "alias": "Status", "type": "esriFieldTypeString" }, { "modelName": "Source", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wtrSource_7", "description": "", "type": "codedValue", "codedValues": [ { "code": "ATL", "name": "Atlas" }, { "code": "ASB", "name": "As Built" }, { "code": "FVE", "name": "Field Verified" }, { "code": "AMS", "name": "Asset Management System" }, { "code": "ORT", "name": "Orthophoto" }, { "code": "TAB", "name": "Tab Sheet" }, { "code": "COT", "name": "City of Toledo" }, { "code": "INV", "name": "Invert Field Collection" }, { "code": "CON", "name": "Construction Report" }, { "code": "PRE", "name": "Preliminary Drawing" }, { "code": "SVY", "name": "Survey Crew GPS" }, { "code": "HND", "name": "Handheld GPS Non-Survey" }, { "code": "HLD", "name": "GIS created for holding spot" }, { "code": "TAP", "name": "Tap Card" }, { "code": "CWS", "name": "Cityworks" }, { "code": "POR", "name": "Private Owner Reported" }, { "code": "SAP", "name": "SAP" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "source", "length": 20, "alias": "Source", "type": "esriFieldTypeString" }, { "modelName": "Comments", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "comments", "length": 250, "alias": "Comments", "type": "esriFieldTypeString" }, { "modelName": "SvcType", "nullable": true, "editable": true, "defaultValue": 1, "domain": null, "name": "svctype", "alias": "Type", "type": "esriFieldTypeInteger" }, { "modelName": "Diameter", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wtrServiceDomIRRS", "description": "WSL Diameter", "type": "codedValue", "codedValues": [ { "code": 0.625, "name": "5/8" }, { "code": 0.75, "name": "3/4" }, { "code": 1, "name": "1" }, { "code": 1.5, "name": "1 1/2" }, { "code": 2, "name": "2" }, { "code": 3, "name": "3" }, { "code": 4, "name": "4" }, { "code": 6, "name": "6" }, { "code": 8, "name": "8" }, { "code": 12, "name": "12" }, { "code": 24, "name": "24" }, { "code": 0.5, "name": "1/2" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "diameter", "alias": "Service Size", "type": "esriFieldTypeDouble" }, { "modelName": "Asbuilt", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "asbuilt", "length": 20, "alias": "Asbuilt", "type": "esriFieldTypeString" }, { "modelName": "TapMainDiam", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wtrMainSize", "description": "", "type": "codedValue", "codedValues": [ { "code": 4, "name": "4" }, { "code": 6, "name": "6" }, { "code": 8, "name": "8" }, { "code": 10, "name": "10" }, { "code": 12, "name": "12" }, { "code": 16, "name": "16" }, { "code": 18, "name": "18" }, { "code": 20, "name": "20" }, { "code": 24, "name": "24" }, { "code": 30, "name": "30" }, { "code": 36, "name": "36" }, { "code": 42, "name": "42" }, { "code": 48, "name": "48" }, { "code": 54, "name": "54" }, { "code": 60, "name": "60" }, { "code": 66, "name": "66" }, { "code": 72, "name": "72" }, { "code": 78, "name": "78" }, { "code": 96, "name": "96" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "tapmaindiam", "alias": "Tapped Main Diameter", "type": "esriFieldTypeDouble" }, { "modelName": "Address", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "address", "length": 60, "alias": "Address", "type": "esriFieldTypeString" }, { "modelName": "DepthOfCover", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "depthofcover", "alias": "Depth of Main at Tap", "type": "esriFieldTypeDouble" }, { "modelName": "StNumber", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stnumber", "length": 25, "alias": "Street Number", "type": "esriFieldTypeString" }, { "modelName": "StName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "stname", "length": 50, "alias": "Street Name", "type": "esriFieldTypeString" }, { "modelName": "Length", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "length", "alias": "Pipe Length", "type": "esriFieldTypeDouble" }, { "modelName": "WO", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "wo", "length": 7, "alias": "WO", "type": "esriFieldTypeString" }, { "modelName": "OverTap", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YESNO_2_3", "description": "YesOrNo", "type": "codedValue", "codedValues": [ { "code": "NO", "name": "NO" }, { "code": "YES", "name": "YES" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "overtap", "length": 3, "alias": "OverTap", "type": "esriFieldTypeString" }, { "modelName": "Split", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "YESNO_2_3", "description": "YesOrNo", "type": "codedValue", "codedValues": [ { "code": "NO", "name": "NO" }, { "code": "YES", "name": "YES" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "split", "length": 10, "alias": "Split", "type": "esriFieldTypeString" }, { "modelName": "URLLink", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "urllink", "length": 200, "alias": "URLLink", "type": "esriFieldTypeString" }, { "modelName": "Date_Material_Verified", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "date_material_verified", "length": 29, "alias": "Date_Material_Verified", "type": "esriFieldTypeDate" }, { "modelName": "Material", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wtrServiceMaterial_5", "description": "", "type": "codedValue", "codedValues": [ { "code": "LEAD", "name": "LEAD" }, { "code": "GALVANIZED", "name": "GALVANIZED" }, { "code": "UNKNOWN", "name": "UNKNOWN" }, { "code": "NON-LEAD-COPPER", "name": "NON-LEAD-COPPER" }, { "code": "NON-LEAD-OTHER", "name": "NON-LEAD-OTHER" }, { "code": "NON-LEAD-PLASTIC", "name": "NON-LEAD-PLASTIC" }, { "code": "UNKNOWN-LIKELY LEAD", "name": "UNKNOWN-LIKELY LEAD" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "cityownedmaterial", "length": 30, "alias": "CityOwnedMaterial", "type": "esriFieldTypeString" }, { "modelName": "Mat_Cust", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wtrServiceMaterial_5", "description": "", "type": "codedValue", "codedValues": [ { "code": "LEAD", "name": "LEAD" }, { "code": "GALVANIZED", "name": "GALVANIZED" }, { "code": "UNKNOWN", "name": "UNKNOWN" }, { "code": "NON-LEAD-COPPER", "name": "NON-LEAD-COPPER" }, { "code": "NON-LEAD-OTHER", "name": "NON-LEAD-OTHER" }, { "code": "NON-LEAD-PLASTIC", "name": "NON-LEAD-PLASTIC" }, { "code": "UNKNOWN-LIKELY LEAD", "name": "UNKNOWN-LIKELY LEAD" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "customerownedmaterial", "length": 30, "alias": "Customer Owned Material", "type": "esriFieldTypeString" }, { "modelName": "DateLeadReplaced", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "datecitymaterialreplaced", "length": 29, "alias": "Date City Material Replaced", "type": "esriFieldTypeDate" }, { "modelName": "DateCustSideReplaced", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "datecustomermaterialreplaced", "length": 29, "alias": "DateCustomerMaterialReplaced", "type": "esriFieldTypeDate" }, { "modelName": "DateKilled", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "datekilled", "length": 29, "alias": "Date Killed", "type": "esriFieldTypeDate" }, { "modelName": "Owner", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "city", "length": 50, "alias": "City", "type": "esriFieldTypeString" }, { "modelName": "CustomerType", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "zipcode", "length": 20, "alias": "ZipCode", "type": "esriFieldTypeString" }, { "modelName": "Plan", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "plan_hyperlink", "length": 150, "alias": "Plan Hyperlink", "type": "esriFieldTypeString" }, { "modelName": "X", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "longitude", "alias": "Longitude", "type": "esriFieldTypeDouble" }, { "modelName": "Y", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "latitude", "alias": "Latitude", "type": "esriFieldTypeDouble" }, { "modelName": "PWSID", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pwsid", "length": 25, "alias": "PWSID", "type": "esriFieldTypeString" }, { "modelName": "County", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "county", "length": 50, "alias": "County", "type": "esriFieldTypeString" }, { "modelName": "ConObj", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "premise", "length": 50, "alias": "Premise", "type": "esriFieldTypeString" }, { "modelName": "RequiredReplacement", "nullable": true, "editable": true, "defaultValue": null, "domain": { "splitPolicy": "esriSPTDuplicate", "name": "wtrServReqRep", "description": "Text", "type": "codedValue", "codedValues": [ { "code": "LEAD", "name": "LEAD" }, { "code": "GALVANIZED", "name": "GALVANIZED" }, { "code": "UNKNOWN", "name": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "requiredreplacement", "length": 50, "alias": "RequiredReplacement", "type": "esriFieldTypeString" }, { "modelName": "PlanName", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "planname", "length": 30, "alias": "PlanName", "type": "esriFieldTypeString" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "globalid", "length": 38, "alias": "globalid", "type": "esriFieldTypeGlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeLengthFieldName": "SHAPE__Length", "units": "esriFeet" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "indexes": [ { "name": "r427_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "a333_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true }, { "name": "uuid_427", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "minScale": 6000, "hasAttachments": false, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "eef310124b8f4299aae27a1d5f4bcb8d", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [ { "templates": [ { "name": "Domestic", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "city": null, "pwsid": null, "installationdate": null, "latitude": null, "county": null, "requiredreplacement": null, "date_material_verified": null, "source": null, "urllink": null, "split": null, "diameter": null, "premise": null, "planname": null, "wo": null, "asbuilt": null, "depthofcover": null, "longitude": null, "comments": null, "address": null, "customerownedmaterial": null, "tapmaindiam": null, "datekilled": null, "svctype": 1, "length": null, "datecitymaterialreplaced": null, "zipcode": null, "assetid": null, "cityownedmaterial": null, "stnumber": null, "legacyid": null, "location": null, "overtap": null, "plan_hyperlink": null, "datecustomermaterialreplaced": null, "status": null, "stname": null } } } ], "name": "Domestic", "domains": { "split": {"type": "inherited"}, "diameter": {"type": "inherited"}, "customerownedmaterial": {"type": "inherited"}, "tapmaindiam": {"type": "inherited"}, "cityownedmaterial": {"type": "inherited"}, "source": {"type": "inherited"}, "overtap": {"type": "inherited"}, "status": {"type": "inherited"} }, "id": 1 }, { "templates": [ { "name": "Fire", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "city": null, "pwsid": null, "installationdate": null, "latitude": null, "county": null, "requiredreplacement": null, "date_material_verified": null, "source": null, "urllink": null, "split": null, "diameter": null, "premise": null, "planname": null, "wo": null, "asbuilt": null, "depthofcover": null, "longitude": null, "comments": null, "address": null, "customerownedmaterial": null, "tapmaindiam": null, "datekilled": null, "svctype": 2, "length": null, "datecitymaterialreplaced": null, "zipcode": null, "assetid": null, "cityownedmaterial": null, "stnumber": null, "legacyid": null, "location": null, "overtap": null, "plan_hyperlink": null, "datecustomermaterialreplaced": null, "status": null, "stname": null } } } ], "name": "Fire", "domains": { "split": {"type": "inherited"}, "diameter": {"type": "inherited"}, "customerownedmaterial": {"type": "inherited"}, "tapmaindiam": {"type": "inherited"}, "cityownedmaterial": {"type": "inherited"}, "source": {"type": "inherited"}, "overtap": {"type": "inherited"}, "status": {"type": "inherited"} }, "id": 2 }, { "templates": [ { "name": "Irrigation", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "city": null, "pwsid": null, "installationdate": null, "latitude": null, "county": null, "requiredreplacement": null, "date_material_verified": null, "source": null, "urllink": null, "split": null, "diameter": null, "premise": null, "planname": null, "wo": null, "asbuilt": null, "depthofcover": null, "longitude": null, "comments": null, "address": null, "customerownedmaterial": null, "tapmaindiam": null, "datekilled": null, "svctype": 3, "length": null, "datecitymaterialreplaced": null, "zipcode": null, "assetid": null, "cityownedmaterial": null, "stnumber": null, "legacyid": null, "location": null, "overtap": null, "plan_hyperlink": null, "datecustomermaterialreplaced": null, "status": null, "stname": null } } } ], "name": "Irrigation", "domains": { "split": {"type": "inherited"}, "diameter": {"type": "inherited"}, "customerownedmaterial": {"type": "inherited"}, "tapmaindiam": {"type": "inherited"}, "cityownedmaterial": {"type": "inherited"}, "source": {"type": "inherited"}, "overtap": {"type": "inherited"}, "status": {"type": "inherited"} }, "id": 3 }, { "templates": [ { "name": "Null", "description": "", "drawingTool": "esriFeatureEditToolLine", "prototype": { "attributes": { "city": null, "pwsid": null, "installationdate": null, "latitude": null, "county": null, "requiredreplacement": null, "date_material_verified": null, "source": null, "urllink": null, "split": null, "diameter": null, "premise": null, "planname": null, "wo": null, "asbuilt": null, "depthofcover": null, "longitude": null, "comments": null, "address": null, "customerownedmaterial": null, "tapmaindiam": null, "datekilled": null, "svctype": 4, "length": null, "datecitymaterialreplaced": null, "zipcode": null, "assetid": null, "cityownedmaterial": null, "stnumber": null, "legacyid": null, "location": null, "overtap": null, "plan_hyperlink": null, "datecustomermaterialreplaced": null, "status": null, "stname": null } } } ], "name": "Unknown", "domains": { "split": {"type": "inherited"}, "diameter": {"type": "inherited"}, "customerownedmaterial": {"type": "inherited"}, "tapmaindiam": {"type": "inherited"}, "cityownedmaterial": {"type": "inherited"}, "source": {"type": "inherited"}, "overtap": {"type": "inherited"}, "status": { "splitPolicy": "esriSPTDuplicate", "name": "wtrServiceStatus_1_1", "description": "", "type": "codedValue", "codedValues": [ { "code": "I", "name": "In Service" }, { "code": "R", "name": "Removed" }, { "code": "K", "name": "Killed" }, { "code": "C", "name": "Construction" }, { "code": "PR", "name": "Proposed" } ], "mergePolicy": "esriMPTDefaultValue" } }, "id": 4 } ], "capabilities": "Create,Editing,Uploads,Query,Update,Delete", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": false, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel", "tileMaxRecordCount": 2000, "typeIdField": "svctype", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_10.9.1", "drawingInfo": { "renderer": { "field1": "svctype", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 186, 109, 54, 255 ], "fromColor": [ 186, 109, 54, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 44, 41, 196, 255 ], "fromColor": [ 44, 41, 196, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 58, 196, 45, 255 ], "fromColor": [ 58, 196, 45, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 61, 170, 186, 255 ], "fromColor": [ 61, 170, 186, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 181, 67, 143, 255 ], "fromColor": [ 181, 67, 143, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 64, 92, 168, 255 ], "fromColor": [ 64, 92, 168, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 48, 156, 97, 255 ], "fromColor": [ 48, 156, 97, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 172, 176, 48, 255 ], "fromColor": [ 172, 176, 48, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 184, 44, 70, 255 ], "fromColor": [ 184, 44, 70, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 153, 44, 184, 255 ], "fromColor": [ 153, 44, 184, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 63, 138, 191, 255 ], "fromColor": [ 63, 138, 191, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 60, 55, 161, 255 ], "fromColor": [ 60, 55, 161, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 97, 158, 43, 255 ], "fromColor": [ 97, 158, 43, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" } }, "uniqueValueInfos": [ { "symbol": { "color": [ 255, 255, 255, 255 ], "width": 2.5, "style": "esriSLSSolid", "type": "esriSLS" }, "label": "Domestic", "value": "1" }, { "symbol": { "color": [ 255, 255, 255, 255 ], "width": 3, "style": "esriSLSSolid", "type": "esriSLS" }, "label": "Fire", "value": "2" }, { "symbol": { "color": [ 255, 255, 255, 255 ], "width": 3, "style": "esriSLSSolid", "type": "esriSLS" }, "label": "Irrigation", "value": "3" }, { "symbol": { "color": [ 115, 223, 255, 255 ], "width": 2.5, "style": "esriSLSDash", "type": "esriSLS" }, "label": "Null", "value": "4" } ], "type": "uniqueValue", "fieldDelimiter": "," }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "modelName": "Shape", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "shape", "alias": "Shape", "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPolyline" } ] }