{ "layers": [ { "currentVersion": 10.81, "id": 0, "name": "ARCGIS.SDE.BackflowMeters", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": { "creationDateField": "created_date", "creatorField": "created_user", "editDateField": "last_edited_date", "editorField": "last_edited_user" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true }, "extent": { "xmin": 827498.5454244949, "ymin": 2.662674436471699E7, "xmax": 884618.922325246, "ymax": 2.6703992714813158E7, "spatialReference": { "wkid": 102707, "latestWkid": 3421 } }, "sourceSpatialReference": { "wkid": 102707, "latestWkid": 3421 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "7e282790f34910f57a93861f65b0dfae", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABQAAAAUCAYAAACNiR0NAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAhlJREFUOI2t1F1Ik2EUwPH/Xre9uGbFxi5GDA2FNe1jJaOiLSTBVRYVdFNpESwNSfoAQfOiuujCgkE3RTLoQ4KughTpctVFIUEU2pdEWDBfWPSWMjefubZu3NhyrW11Lp/D+T3nOTwcLf85tAVyGlmWm3Y6RIvDhsmop1KNEnnyitA01mFFUcaLBk0m0+aTHrWvbbuota+iXtIgpXMLSaJjk8qeO0HeBh5zCfhSEPQ6OXZ2l9rtddKY7zKdhMG9hi1b7bjWV1NzccR0XlXVsbygs05u7t0neprqaSgwCgAqNFR072aHVlKvdt2iLd1pNqg/7hYXisGyo8OLeyrMwJVRDuWAhxs5ccTDplKwxU41B7fhGnppXacoyngGdK3FazayrFQQwLma2v0O5egNhZ4MaF2BrRwMQCeBw0YdZD1Z1lJVLghg1LE8B0xB4l/AxGJ9Bpybl2dBlIUlUzAT5UcOGJ4Rr6NxXAZ96eBUmJ/Kd+7lgKEI/cE3HGjdiLlUMDghT/ofiZEc0P+QsN0i3/38VZyptqApFnv2nuh8XPQCqRwQoDMgzgV8NDQ7aamx/B178ZH4u5DsP3VbDKfPliwHXwDvUBc3P6yk3eOgMt9M1QgEJ1BjwtTnG1QHs3N511f7dTpH+xl48JxrVQY2GPSYJQk5kSQ6G5OnF+Li6dw3TnfcV2O/1/5xwbZe5hOwd2mm8NcqtLHLil/JR6V5ILWN9wAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 15, "height": 15, "angle": 0, "xoffset": 0, "yoffset": 0 }, "label": "", "description": "" }, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GlobalID", "displayField": "Acct_Name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "Acct_Number", "type": "esriFieldTypeString", "alias": "Acct_Number", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "Acct_Number" }, { "name": "Acct_Name", "type": "esriFieldTypeString", "alias": "Acct_Name", "domain": null, "editable": true, "nullable": true, "length": 35, "defaultValue": null, "modelName": "Acct_Name" }, { "name": "Street_Num", "type": "esriFieldTypeString", "alias": "Street_Num", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Street_Num" }, { "name": "Street_Name", "type": "esriFieldTypeString", "alias": "Street_Name", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Street_Name1" }, { "name": "Location_Description", "type": "esriFieldTypeString", "alias": "Location_Description", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "Location_Description1" }, { "name": "Backflow_Serial_Num", "type": "esriFieldTypeString", "alias": "Backflow_Serial_Num", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Serial_Num" }, { "name": "Backflow_Present", "type": "esriFieldTypeString", "alias": "Backflow_Present", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Backflow_Present" }, { "name": "Backflow_Inspected", "type": "esriFieldTypeString", "alias": "Backflow_Inspected", "domain": null, "editable": true, "nullable": true, "length": 6, "defaultValue": null, "modelName": "Backflow_Inspected" }, { "name": "Account_Type", "type": "esriFieldTypeString", "alias": "Account_Type", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Account_Type" }, { "name": "Rate", "type": "esriFieldTypeSmallInteger", "alias": "Rate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Rate_" }, { "name": "Backflow_Size", "type": "esriFieldTypeString", "alias": "Backflow_Size", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Backflow_Size_" }, { "name": "Backflow_Brand", "type": "esriFieldTypeString", "alias": "Backflow_Brand", "domain": { "type": "codedValue", "name": "Manufacturer", "description": "Meter/Backflow manufacturers", "codedValues": [ { "name": "AMCO", "code": "AMC" }, { "name": "AMERICAN", "code": "AMR" }, { "name": "BADGER", "code": "BAD" }, { "name": "CAMCO", "code": "CAM" }, { "name": "ELSTER", "code": "ELS" }, { "name": "FEBCO", "code": "FEB" }, { "name": "GAMON", "code": "GAM" }, { "name": "HERSEY", "code": "HER" }, { "name": "MASTER METER", "code": "MM" }, { "name": "NEPTUNE", "code": "NEP" }, { "name": "OCTAVE", "code": "OCT" }, { "name": "ROCKWELL", "code": "ROC" }, { "name": "SENSUS", "code": "SEN" }, { "name": "WILKINS ZURN", "code": "WIL" }, { "name": "WATER SPECIALIST", "code": "WS" }, { "name": "ZENNER", "code": "ZEN" }, { "name": "WATTS", "code": "WAT" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Backflow_Brand_" }, { "name": "Device_Type", "type": "esriFieldTypeString", "alias": "Device_Type", "domain": { "type": "codedValue", "name": "DeviceType", "description": "Type of backflow", "codedValues": [ { "name": "DOUBLE CHECK", "code": "DC" }, { "name": "REDUCED PRESSURE", "code": "RP" }, { "name": "REDUCED PRESSURE DETECTOR", "code": "RPD" }, { "name": "DOUBLE CHECK DETECTOR", "code": "DCD" }, { "name": "PRESSURE VAC BREAKER", "code": "PVB" }, { "name": "SPILL VAC BREAKER", "code": "SVB" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "Device_Type_" }, { "name": "Backflow_Model_Num", "type": "esriFieldTypeString", "alias": "Backflow_Model_Num", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Model_Num" }, { "name": "Installation_Date", "type": "esriFieldTypeString", "alias": "Installation_Date", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Installation_Date" }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "Notes" }, { "name": "Hazard_Rating", "type": "esriFieldTypeString", "alias": "Hazard_Rating", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Hazard_Rating" }, { "name": "Enclosure", "type": "esriFieldTypeString", "alias": "Enclosure", "domain": { "type": "codedValue", "name": "Enclosure", "description": "Type of backflow/meter enclosure", "codedValues": [ { "name": "ABOVE GROUND HOTBOX", "code": "HOT" }, { "name": "EXPOSED", "code": "EXP" }, { "name": "VAULT", "code": "VAU" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "Enclosure" }, { "name": "Service_Type", "type": "esriFieldTypeString", "alias": "Service_Type", "domain": { "type": "codedValue", "name": "ServiceType", "description": "Type of service meter feeds", "codedValues": [ { "name": "DOMESTIC", "code": "DOM" }, { "name": "DOMESTIC/IRRIGATION", "code": "DOM/IRR" }, { "name": "FIRE", "code": "FIRE" }, { "name": "IRRIGATION", "code": "IRR" }, { "name": "MECHANICAL", "code": "MECH" }, { "name": "RAW", "code": "RAW" }, { "name": "TRUCK FILL", "code": "TCKFL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Service_Type" }, { "name": "Water_Type", "type": "esriFieldTypeString", "alias": "Water_Type", "domain": { "type": "codedValue", "name": "WaterType", "description": "Type of water", "codedValues": [ { "name": "POTABLE", "code": "POT" }, { "name": "RAW", "code": "RAW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "Water_Type" }, { "name": "Meter_Num", "type": "esriFieldTypeString", "alias": "Meter_Num", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "Meter_Num" }, { "name": "FIELD_CHECK_DATE", "type": "esriFieldTypeDate", "alias": "FIELD_CHECK_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FIELD_CHECK_DATE" }, { "name": "FIELD_CHECK_WORKER", "type": "esriFieldTypeString", "alias": "FIELD_CHECK_WORKER", "domain": { "type": "codedValue", "name": "WorkerName", "description": "Names of water field crew", "codedValues": [ { "name": "Todd Abratowski", "code": "TA" }, { "name": "Adam Carver", "code": "AC" }, { "name": "Dave Joseph", "code": "DJ" }, { "name": "Mark McCreery", "code": "MM" }, { "name": "Joel Pepper", "code": "JP" }, { "name": "Steve Priscu", "code": "SP" }, { "name": "Mike Noe", "code": "MN" }, { "name": "Tyler Langston", "code": "TL" }, { "name": "Brock Fletcher", "code": "BF" }, { "name": "Jennifer Woodward", "code": "JW" }, { "name": "Donnie Trumble", "code": "DT" }, { "name": "Kyle Choltko", "code": "KC" }, { "name": "Daniel Castleberry", "code": "DC" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "FIELD_CHECK_WORKER" }, { "name": "Install_By", "type": "esriFieldTypeString", "alias": "Install_By", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "Install_By" }, { "name": "LAST_UPDATE", "type": "esriFieldTypeDate", "alias": "LAST_UPDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_UPDATE" }, { "name": "UPDATED_BY", "type": "esriFieldTypeString", "alias": "UPDATED_BY", "domain": { "type": "codedValue", "name": "Updated_By", "description": "*Use this one - Person who updated GIS features", "codedValues": [ { "name": "Jennifer Switzer", "code": "JS" }, { "name": "Jennifer Woodward", "code": "JW" }, { "name": "Mauricio Morteo", "code": "MM" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "UPDATED_BY" }, { "name": "PSI", "type": "esriFieldTypeSmallInteger", "alias": "PSI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "PSI" }, { "name": "LABEL_NUM", "type": "esriFieldTypeSmallInteger", "alias": "LABEL_NUM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LABEL_NUM" }, { "name": "BACKFLOW_PRI", "type": "esriFieldTypeSmallInteger", "alias": "BACKFLOW PRIORITY", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "BACKFLOW_PRI" }, { "name": "YR_BCKFLW_INST_SUB", "type": "esriFieldTypeSmallInteger", "alias": "YEAR INSTALL SUBMITTED", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "YR_BCKFLW_INST_SUB" }, { "name": "LAST_TEST_DATE", "type": "esriFieldTypeDate", "alias": "LAST TEST DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_TEST_DATE" }, { "name": "LAST_TEST_RESULT", "type": "esriFieldTypeString", "alias": "LAST TEST RESULT", "domain": { "type": "codedValue", "name": "BackflowTestRes", "description": "Backflow testing result", "codedValues": [ { "name": "PASS", "code": "PASS" }, { "name": "FAIL", "code": "FAIL" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "LAST_TEST_RESULT" }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "ADDRESS", "domain": null, "editable": true, "nullable": true, "length": 250, "defaultValue": null, "modelName": "ADDRESS" }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "created_user" }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "created_date" }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "last_edited_user" }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_edited_date" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "name": "check_", "type": "esriFieldTypeInteger", "alias": "check_", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "check_" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Shape" }, "indexes": [ { "name": "R467_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_467", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "S360_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "ARCGIS.SDE.BackflowMeters", "description": "", "prototype": { "attributes": { "check_": null, "ADDRESS": null, "Acct_Number": null, "Acct_Name": null, "Street_Num": null, "Street_Name": null, "Location_Description": null, "Backflow_Serial_Num": null, "Backflow_Present": null, "Backflow_Inspected": null, "Account_Type": null, "Rate": null, "Backflow_Size": null, "Backflow_Brand": null, "Device_Type": null, "Backflow_Model_Num": null, "Installation_Date": null, "Notes": null, "Hazard_Rating": null, "Enclosure": null, "Service_Type": null, "Water_Type": null, "Meter_Num": null, "FIELD_CHECK_DATE": null, "FIELD_CHECK_WORKER": null, "Install_By": null, "LAST_UPDATE": null, "UPDATED_BY": null, "PSI": null, "LABEL_NUM": null, "BACKFLOW_PRI": null, "YR_BCKFLW_INST_SUB": null, "LAST_TEST_DATE": null, "LAST_TEST_RESULT": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 } ], "tables": [ { "currentVersion": 10.81, "id": 1, "name": "ARCGIS.SDE.Line_Cleaning", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "Status", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "MMS_Id", "type": "esriFieldTypeInteger", "alias": "MMS_Id", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MMS_Id" }, { "name": "Date_Issued", "type": "esriFieldTypeDate", "alias": "Date_Issued", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Date_Issued" }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "Status" }, { "name": "Cleaning_Date", "type": "esriFieldTypeDate", "alias": "Cleaning_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "Cleaning_Date" }, { "name": "featureId", "type": "esriFieldTypeString", "alias": "featureId", "domain": null, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "featureId" } ], "indexes": [ { "name": "R471_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "ARCGIS.SDE.Line_Cleaning", "description": "", "prototype": { "attributes": { "Cleaning_Date": null, "featureId": null, "MMS_Id": null, "Date_Issued": null, "Status": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 } ] }