{ "currentVersion": 11.3, "cimVersion": "3.3.0", "id": 2, "name": "Water Service Connections", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 10000, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "CREATEDON", "creatorField": "CREATEDBY", "editDateField": "EDITEDON", "editorField": "EDITEDBY" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": true, "extent": { "xmin": 2049362.84821239, "ymin": 668369.648361132, "xmax": 2222584.72486506, "ymax": 825820.47551921, "spatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.00328083333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121905, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 102719, "latestWkid": 2264, "xyTolerance": 0.00204800000190735, "zTolerance": 0.001, "mTolerance": 2, "falseX": -121841900, "falseY": -93659000, "xyUnits": 3048.0060960121905, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "abb2bd045fbe4d39cbe09681f8730868", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA+0lEQVQokWNhIBOwgElJq2CGP189idLx999chneXj0M0gjS5LUhmYBfAr+nTAwaGgwUgFlQjCLALMBhrKzCcfQzhSvExMEjyM8D5xrIMDGevojsVCs4UMTD4zWFg2HyVgWFTCkQxYyEDg682hM+YjEMjyHRJPogGKX6ETSC8Bck2TI1PGBjSLBkYZh1HcqIMA4OPFkQOp0aQBpBz0xgYGLZcg9gOMggmh9tGpIBIX43wNwg8/4hHI0wzyH9noYY8/8TA8OwjA8OzTwQ0gkIVFA0wYNKLysfUCIpcBojJz5ACAoUPVYPQCEpGkBRBGIDUwjW+uwwKM7Rwww8AHopWIF6sEAQAAAAASUVORK5CYII=", "contentType": "image/png", "width": 10, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "Water Service Connections" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "FACILITYID", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "SP_ID", "type": "esriFieldTypeString", "alias": "SP_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SP_ID" }, { "name": "CSA_ID", "type": "esriFieldTypeString", "alias": "CSA_ID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "CSA_ID" }, { "name": "PREM_ID", "type": "esriFieldTypeString", "alias": "PREM_ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "PREM_ID" }, { "name": "ACTIVEFLAG", "type": "esriFieldTypeSmallInteger", "alias": "Active Flag", "domain": { "type": "codedValue", "name": "ActiveStatus", "description": "State of asset usage", "codedValues": [ { "name": "Active", "code": 1 }, { "name": "Inactive", "code": 2 }, { "name": "Abandoned", "code": 3 }, { "name": "Removed", "code": 4 }, { "name": "Planned", "code": 5 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ACTIVEFLAG" }, { "name": "CRITICAL", "type": "esriFieldTypeString", "alias": "Critical", "domain": { "type": "codedValue", "name": "YesNo", "description": "A yes/no indicator", "codedValues": [ { "name": "YES", "code": "YES" }, { "name": "NO", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "CRITICAL" }, { "name": "CITY_LIMITS", "type": "esriFieldTypeString", "alias": "City Limits", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "CITY_LIMITS" }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "ADDRESS" }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "City", "domain": null, "editable": true, "nullable": true, "length": 90, "defaultValue": null, "modelName": "CITY" }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "State", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "STATE" }, { "name": "ZIP", "type": "esriFieldTypeString", "alias": "Zip Code", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ZIP" }, { "name": "LOCDESC", "type": "esriFieldTypeString", "alias": "Location Description", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "LOCDESC" }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Install Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INSTALLDATE" }, { "name": "METER", "type": "esriFieldTypeString", "alias": "Meter", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "METER" }, { "name": "ENABLED", "type": "esriFieldTypeSmallInteger", "alias": "Enabled", "domain": { "type": "codedValue", "name": "EnabledDomain", "description": "", "codedValues": [ { "name": "False", "code": 0 }, { "name": "True", "code": 1 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "ENABLED" }, { "name": "STATUS", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "STATUS" }, { "name": "PRESSUREZONE", "type": "esriFieldTypeSmallInteger", "alias": "Pressure Zone", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PRESSUREZONE" }, { "name": "PRESSURE_SUBZONE", "type": "esriFieldTypeString", "alias": "Sub-Pressure Zone", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "PRESSURE_SUBZONE" }, { "name": "CONFINED", "type": "esriFieldTypeString", "alias": "Confined", "domain": { "type": "codedValue", "name": "wServiceConnection_Confined", "description": "Confined", "codedValues": [ { "name": "Confined", "code": "CONFINED" }, { "name": "Not Confined", "code": "NOT_CONFINED" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CONFINED" }, { "name": "INSIDE_NEW", "type": "esriFieldTypeString", "alias": "Inside New", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "INSIDE_NEW" }, { "name": "BOXTYPE", "type": "esriFieldTypeString", "alias": "Box Type", "domain": { "type": "codedValue", "name": "wMeterBoxType", "description": "Type of meter box", "codedValues": [ { "name": "Standard", "code": "STD" }, { "name": "Coffin", "code": "COFFIN" }, { "name": "Cast Iron", "code": "CAST" }, { "name": "Aluminum", "code": "AL" }, { "name": "Plastic", "code": "PLASTIC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "BOXTYPE" }, { "name": "SERVICEMATERIAL", "type": "esriFieldTypeString", "alias": "Service Material", "domain": { "type": "codedValue", "name": "wLateralMaterial", "description": "Water Lateral Material", "codedValues": [ { "name": "Copper", "code": "CU" }, { "name": "Galvanized", "code": "GAL" }, { "name": "HDPE", "code": "HDPE" }, { "name": "PVC", "code": "PVC" }, { "name": "Unknown", "code": "UNK" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "SERVICEMATERIAL" }, { "name": "SP_CODE", "type": "esriFieldTypeString", "alias": "SP Code", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SP_CODE" }, { "name": "SP_TYPE_DESCRIPTION", "type": "esriFieldTypeString", "alias": "SP Type Description", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "SP_TYPE_DESCRIPTION" }, { "name": "SP_SIZE", "type": "esriFieldTypeString", "alias": "SP Size", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "SP_SIZE" }, { "name": "SP_SIZE_DESCRIPTION", "type": "esriFieldTypeString", "alias": "SP Size Description", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "SP_SIZE_DESCRIPTION" }, { "name": "UOM", "type": "esriFieldTypeString", "alias": "UOM", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "UOM" }, { "name": "METER_CONFIG", "type": "esriFieldTypeString", "alias": "Meter Configuration", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "METER_CONFIG" }, { "name": "USEAGE_CLASS", "type": "esriFieldTypeString", "alias": "Usage Class", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "USEAGE_CLASS" }, { "name": "USEAGE_CLASS_DESCRIPTION", "type": "esriFieldTypeString", "alias": "Usage Class Description", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "USEAGE_CLASS_DESCRIPTION" }, { "name": "SERVICE_CYCLE", "type": "esriFieldTypeString", "alias": "Service Cycle", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "SERVICE_CYCLE" }, { "name": "ROUTE", "type": "esriFieldTypeString", "alias": "Route", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "ROUTE" }, { "name": "ROUTE_SEQ", "type": "esriFieldTypeString", "alias": "Route Sequence", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ROUTE_SEQ" }, { "name": "SP_CREATED", "type": "esriFieldTypeDate", "alias": "SP Created", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SP_CREATED" }, { "name": "X_LONGITUDE", "type": "esriFieldTypeDouble", "alias": "X Longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "X_LONGITUDE" }, { "name": "Y_LATITUDE", "type": "esriFieldTypeDouble", "alias": "Y Latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Y_LATITUDE" }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "OWNEDBY" }, { "name": "MAINTAINEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Maintained By", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAINTAINEDBY" }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "NOTES" }, { "name": "EDITEDBY", "type": "esriFieldTypeString", "alias": "Edited By", "domain": null, "editable": false, "nullable": true, "length": 256, "defaultValue": null, "modelName": "EDITEDBY" }, { "name": "EDITEDON", "type": "esriFieldTypeDate", "alias": "Edited On", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EDITEDON" }, { "name": "CREATEDBY", "type": "esriFieldTypeString", "alias": "Created By", "domain": null, "editable": false, "nullable": true, "length": 256, "defaultValue": null, "modelName": "CREATEDBY" }, { "name": "CREATEDON", "type": "esriFieldTypeDate", "alias": "Created On", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATEDON" }, { "name": "ESRIGNSS_ALTITUDE", "type": "esriFieldTypeDouble", "alias": "Altitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_ALTITUDE" }, { "name": "ESRIGNSS_RECEIVER", "type": "esriFieldTypeString", "alias": "Receiver Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ESRIGNSS_RECEIVER" }, { "name": "ESRIGNSS_FIXDATETIME", "type": "esriFieldTypeDate", "alias": "Fix Time", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ESRIGNSS_FIXDATETIME" }, { "name": "ESRIGNSS_AVG_POSITIONS", "type": "esriFieldTypeSmallInteger", "alias": "Averaged Positions", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_AVG_POSITIONS" }, { "name": "ESRIGNSS_LONGITUDE", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_LONGITUDE" }, { "name": "ESRIGNSS_PDOP", "type": "esriFieldTypeDouble", "alias": "PDOP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_PDOP" }, { "name": "ESRIGNSS_AVG_V_RMS", "type": "esriFieldTypeDouble", "alias": "Average Vertical Accuracy (m)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_AVG_V_RMS" }, { "name": "ESRIGNSS_V_RMS", "type": "esriFieldTypeDouble", "alias": "Vertical Accuracy (m)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_V_RMS" }, { "name": "ESRIGNSS_CORRECTIONAGE", "type": "esriFieldTypeDouble", "alias": "Correction Age", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_CORRECTIONAGE" }, { "name": "ESRIGNSS_LATITUDE", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_LATITUDE" }, { "name": "ESRIGNSS_FIXTYPE", "type": "esriFieldTypeSmallInteger", "alias": "Fix Type", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_FIXTYPE" }, { "name": "ESRIGNSS_AVG_H_RMS", "type": "esriFieldTypeDouble", "alias": "Average Horizontal Accuracy (m)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_AVG_H_RMS" }, { "name": "ESRIGNSS_H_RMS", "type": "esriFieldTypeDouble", "alias": "Horizontal Accuracy (m)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_H_RMS" }, { "name": "ESRIGNSS_STATIONID", "type": "esriFieldTypeSmallInteger", "alias": "Station ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_STATIONID" }, { "name": "ESRIGNSS_HDOP", "type": "esriFieldTypeDouble", "alias": "HDOP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_HDOP" }, { "name": "ESRIGNSS_NUMSATS", "type": "esriFieldTypeSmallInteger", "alias": "Number of Satellites", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_NUMSATS" }, { "name": "ESRIGNSS_VDOP", "type": "esriFieldTypeDouble", "alias": "VDOP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_VDOP" }, { "name": "ESRIGNSS_H_STDDEV", "type": "esriFieldTypeDouble", "alias": "Standard Deviation (m)", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ESRIGNSS_H_STDDEV" }, { "name": "L_ID", "type": "esriFieldTypeString", "alias": "Location ID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "L_ID" }, { "name": "RESETTER", "type": "esriFieldTypeString", "alias": "Resetter", "domain": { "type": "codedValue", "name": "wServiceConnections_SetterType_1", "description": "Service Connections Setter Type", "codedValues": [ { "name": "None", "code": "None" }, { "name": "AYM", "code": "AYM" }, { "name": "Ford", "code": "Ford" }, { "name": "Mueller", "code": "Mueller" }, { "name": "Retrosetter", "code": "Retrosetter" }, { "name": "MacDonald", "code": "MacDonald" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "RESETTER" }, { "name": "COPPERSETTER", "type": "esriFieldTypeString", "alias": "Copper Setter", "domain": { "type": "codedValue", "name": "wServiceConnections_SetterType_1", "description": "Service Connections Setter Type", "codedValues": [ { "name": "None", "code": "None" }, { "name": "AYM", "code": "AYM" }, { "name": "Ford", "code": "Ford" }, { "name": "Mueller", "code": "Mueller" }, { "name": "Retrosetter", "code": "Retrosetter" }, { "name": "MacDonald", "code": "MacDonald" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "COPPERSETTER" }, { "name": "MAST_MTR", "type": "esriFieldTypeString", "alias": "MAST_MTR", "domain": { "type": "codedValue", "name": "BACKFLOW_MAST_MTR_1", "description": "Master Metered", "codedValues": [ { "name": "The SP is master metered", "code": "YES" }, { "name": "The SP is not master metered", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "MAST_MTR" }, { "name": "COMP_FAC", "type": "esriFieldTypeString", "alias": "COMP_FAC", "domain": { "type": "codedValue", "name": "BACKFLOW_COMPSTAT", "description": "Backflow Compliance Status", "codedValues": [ { "name": "Compliant", "code": "COMPLIANT" }, { "name": "Not Compliant", "code": "NOT_COMPLIANT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "COMP_FAC" }, { "name": "BACKFLOW", "type": "esriFieldTypeString", "alias": "Backflow Status", "domain": { "type": "codedValue", "name": "BACKFLOW_STATUS", "description": "Back Flow Status", "codedValues": [ { "name": "Non-Surveyed", "code": "NON-SURVEYED" }, { "name": "Compliant property", "code": "COMPLIANT" }, { "name": "Non-Compliant Testing NOV", "code": "NON-COMP_TESTNOV" }, { "name": "Installation NOV", "code": "INSTALL_NOV" }, { "name": "Non-Compliant Installation NOV", "code": "NON-COMP_INSTNOV" }, { "name": "Water Service Disconnected", "code": "SVC_DISCONNECTED" }, { "name": "Disconnection has been approaved", "code": "APPD_DISCONNECT" }, { "name": "Door hanger disconnection notice posted at service address", "code": "NOTIFY_COMPLETE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "BACKFLOW" }, { "name": "COMPTYPE", "type": "esriFieldTypeString", "alias": "COMPTYPE", "domain": { "type": "codedValue", "name": "BACKFLOW_COMPTYPE_1", "description": "Compliance Configuration", "codedValues": [ { "name": "Domestic Service", "code": "DOMESTIC" }, { "name": "Irrigation Service on Domestic Meter", "code": "DOMESTIC IRRIG" }, { "name": "Fire Service", "code": "FIRE" }, { "name": "Hydrant Meter", "code": "HYDRANT METER" }, { "name": "Irrigation Service", "code": "IRRIGATION" }, { "name": "Permanent Exemption", "code": "PERM_EXEMPT" }, { "name": "Temporary Exemption", "code": "TEMP_EXEMPT" }, { "name": "Governmental Accounts", "code": "GOVERMENT" }, { "name": "Governmental Metered Irrigation", "code": "GOVERMENT_IRRIG" }, { "name": "Irrigation Well", "code": "IRRIG_WELL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "COMPTYPE" }, { "name": "COMPTIER", "type": "esriFieldTypeString", "alias": "COMPTIER", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "COMPTIER" }, { "name": "COMPHZRD", "type": "esriFieldTypeString", "alias": "COMPHZRD", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "COMPHZRD" }, { "name": "COMPOWNR", "type": "esriFieldTypeString", "alias": "COMPOWNR", "domain": null, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "COMPOWNR" }, { "name": "COMP_EXP", "type": "esriFieldTypeString", "alias": "COMP_EXP", "domain": null, "editable": true, "nullable": true, "length": 256, "defaultValue": null, "modelName": "COMP_EXP" }, { "name": "ACCT_ID", "type": "esriFieldTypeString", "alias": "ACCT_ID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ACCT_ID" }, { "name": "ACCT_EMAIL", "type": "esriFieldTypeString", "alias": "ACCT_EMAIL", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "ACCT_EMAIL" }, { "name": "ACCT_PHONE", "type": "esriFieldTypeString", "alias": "ACCT_PHONE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ACCT_PHONE" }, { "name": "ACCT_NAME", "type": "esriFieldTypeString", "alias": "ACCT_NAME", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "ACCT_NAME" }, { "name": "ACCT_ADDRESS", "type": "esriFieldTypeString", "alias": "ACCT_ADDRESS", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "ACCT_ADDRESS" }, { "name": "ACCT_ADDRESS_2", "type": "esriFieldTypeString", "alias": "ACCT_ADDRESS_2", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "ACCT_ADDRESS_2" }, { "name": "ACCT_CITY", "type": "esriFieldTypeString", "alias": "ACCT_CITY", "domain": null, "editable": true, "nullable": true, "length": 90, "defaultValue": null, "modelName": "ACCT_CITY" }, { "name": "ACCT_STATE", "type": "esriFieldTypeString", "alias": "ACCT_STATE", "domain": null, "editable": true, "nullable": true, "length": 90, "defaultValue": null, "modelName": "ACCT_STATE" }, { "name": "OWN_ACCT_ID", "type": "esriFieldTypeString", "alias": "OWN_ACCT_ID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "OWN_ACCT_ID" }, { "name": "OWN_EMAIL", "type": "esriFieldTypeString", "alias": "OWN_EMAIL", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "OWN_EMAIL" }, { "name": "OWN_PHONE", "type": "esriFieldTypeString", "alias": "OWN_PHONE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OWN_PHONE" }, { "name": "OWN_NAME", "type": "esriFieldTypeString", "alias": "OWN_NAME", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "OWN_NAME" }, { "name": "OWN_ADDRESS", "type": "esriFieldTypeString", "alias": "OWN_ADDRESS", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "OWN_ADDRESS" }, { "name": "OWN_ADDRESS_2", "type": "esriFieldTypeString", "alias": "OWN_ADDRESS_2", "domain": null, "editable": true, "nullable": true, "length": 254, "defaultValue": null, "modelName": "OWN_ADDRESS_2" }, { "name": "OWN_CITY", "type": "esriFieldTypeString", "alias": "OWN_CITY", "domain": null, "editable": true, "nullable": true, "length": 90, "defaultValue": null, "modelName": "OWN_CITY" }, { "name": "OWN_STATE", "type": "esriFieldTypeString", "alias": "OWN_STATE", "domain": null, "editable": true, "nullable": true, "length": 90, "defaultValue": null, "modelName": "OWN_STATE" }, { "name": "OWN_ZIP", "type": "esriFieldTypeString", "alias": "OWN_ZIP", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "OWN_ZIP" }, { "name": "METERSIZ", "type": "esriFieldTypeString", "alias": "METERSIZ", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "METERSIZ" }, { "name": "SP_SRC_STATUS_FLG", "type": "esriFieldTypeString", "alias": "SP_SRC_STATUS_FLG", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "SP_SRC_STATUS_FLG" }, { "name": "METER_SIZE", "type": "esriFieldTypeString", "alias": "METER_SIZE", "domain": null, "editable": true, "nullable": true, "length": 512, "defaultValue": null, "modelName": "METER_SIZE" }, { "name": "ACCT_ZIP", "type": "esriFieldTypeString", "alias": "ACCT_ZIP", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "ACCT_ZIP" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" }, { "name": "CCB_UPDATE", "type": "esriFieldTypeDate", "alias": "CCB Update", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CCB_UPDATE" }, { "name": "O_VALUE", "type": "esriFieldTypeString", "alias": "O_VALUE", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "O_VALUE" }, { "name": "CUSTOMERMATERIAL", "type": "esriFieldTypeString", "alias": "Customer Material", "domain": { "type": "codedValue", "name": "wServiceConnectionsMaterial", "description": "Water Service Connection Materials", "codedValues": [ { "name": "Copper", "code": "CU" }, { "name": "Galvanized", "code": "GAL" }, { "name": "Plastic", "code": "PLA" }, { "name": "Lead", "code": "FE" }, { "name": "Non-Lead", "code": "NONFE" }, { "name": "Unknown", "code": "UNK" }, { "name": "Not Found", "code": "NFD" }, { "name": "Does Not Exist", "code": "DNE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "CUSTOMERSVCMATERIAL" }, { "name": "DUALCHECK", "type": "esriFieldTypeString", "alias": "Dual Check", "domain": { "type": "codedValue", "name": "wServiceConnectionsDualCheck", "description": "Water Service Connections Dual Check Domain", "codedValues": [ { "name": "Unknown", "code": "Unknown" }, { "name": "None", "code": "None" }, { "name": "Ford", "code": "Ford" }, { "name": "Mueller", "code": "Mueller" }, { "name": "AY McDonald", "code": "AY McDonald" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DUALCHECK" }, { "name": "ACCT_TEMP_EXPT_ID", "type": "esriFieldTypeString", "alias": "Account Temp Exempt ID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "ACCT_TEMP_EXPT_ID" }, { "name": "ALT_CSA_ID", "type": "esriFieldTypeString", "alias": "ALT_CSA_ID", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "ALT_CSA_ID" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R475_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_475", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_475", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A300_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Water Service Connections", "description": "", "prototype": { "attributes": { "METER": null, "ACCT_TEMP_EXPT_ID": null, "FACILITYID": null, "SP_ID": null, "CSA_ID": null, "PREM_ID": null, "ACTIVEFLAG": null, "CRITICAL": null, "CITY_LIMITS": null, "ADDRESS": null, "CITY": null, "STATE": null, "ZIP": null, "LOCDESC": null, "INSTALLDATE": null, "ENABLED": 1, "STATUS": null, "PRESSUREZONE": null, "PRESSURE_SUBZONE": null, "CONFINED": null, "INSIDE_NEW": null, "BOXTYPE": null, "SERVICEMATERIAL": null, "SP_CODE": null, "SP_TYPE_DESCRIPTION": null, "SP_SIZE": null, "SP_SIZE_DESCRIPTION": null, "UOM": null, "METER_CONFIG": null, "USEAGE_CLASS": null, "USEAGE_CLASS_DESCRIPTION": null, "SERVICE_CYCLE": null, "ROUTE": null, "ROUTE_SEQ": null, "SP_CREATED": null, "X_LONGITUDE": null, "Y_LATITUDE": null, "OWNEDBY": null, "MAINTAINEDBY": null, "NOTES": null, "DUALCHECK": null, "CUSTOMERMATERIAL": null, "O_VALUE": null, "CCB_UPDATE": null, "ESRIGNSS_ALTITUDE": null, "ESRIGNSS_RECEIVER": null, "ESRIGNSS_FIXDATETIME": null, "ESRIGNSS_AVG_POSITIONS": null, "ESRIGNSS_LONGITUDE": null, "ESRIGNSS_PDOP": null, "ESRIGNSS_AVG_V_RMS": null, "ESRIGNSS_V_RMS": null, "ESRIGNSS_CORRECTIONAGE": null, "ESRIGNSS_LATITUDE": null, "ESRIGNSS_FIXTYPE": null, "ESRIGNSS_AVG_H_RMS": null, "ESRIGNSS_H_RMS": null, "ESRIGNSS_STATIONID": null, "ESRIGNSS_HDOP": null, "ESRIGNSS_NUMSATS": null, "ESRIGNSS_VDOP": null, "ESRIGNSS_H_STDDEV": null, "L_ID": null, "RESETTER": null, "COPPERSETTER": null, "MAST_MTR": null, "COMP_FAC": null, "BACKFLOW": null, "COMPTYPE": null, "COMPTIER": null, "COMPHZRD": null, "COMPOWNR": null, "COMP_EXP": null, "ACCT_ID": null, "ACCT_EMAIL": null, "ACCT_PHONE": null, "ACCT_NAME": null, "ACCT_ADDRESS": null, "ACCT_ADDRESS_2": null, "ACCT_CITY": null, "ACCT_STATE": null, "OWN_ACCT_ID": null, "OWN_EMAIL": null, "OWN_PHONE": null, "OWN_NAME": null, "OWN_ADDRESS": null, "OWN_ADDRESS_2": null, "OWN_CITY": null, "OWN_STATE": null, "OWN_ZIP": null, "METERSIZ": null, "SP_SRC_STATUS_FLG": null, "METER_SIZE": null, "ACCT_ZIP": null, "ALT_CSA_ID": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 4000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "088c606e8c794a1a999e5d361fc24674" }