{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 0, "name": "Water_GIS.DBO.SystemValves", "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": 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, "hasContingentValuesDefinition": false, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "extent": { "xmin": 0, "ymin": 0, "xmax": 447477.49289999995, "ymax": 4941711.5187, "spatialReference": { "wkid": 26918, "latestWkid": 26918, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "spatialReference": { "wkid": 26918, "latestWkid": 26918, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 }, "sourceSpatialReference": { "wkid": 26918, "latestWkid": 26918, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 0, 112, 255, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 52, 52, 52, 255 ], "width": 0.7 } } }, "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": "ComputerName", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "ANCILLARYROLE", "type": "esriFieldTypeSmallInteger", "alias": "ANCILLARYROLE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ANCILLARYROLE" }, { "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": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "FACILITYID" }, { "name": "GRIDNUMBER", "type": "esriFieldTypeString", "alias": "GRIDNUMBER", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "GRIDNUMBER" }, { "name": "ASSETNUMBER", "type": "esriFieldTypeString", "alias": "ASSETNUMBER", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "ASSETNUMBER" }, { "name": "WORKORDERID", "type": "esriFieldTypeString", "alias": "WORKORDERID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "WORKORDERID" }, { "name": "INSTALLYEAR", "type": "esriFieldTypeInteger", "alias": "INSTALLYEAR", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "INSTALLYEAR" }, { "name": "LIFECYCLESTATUS", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "domain": null, "editable": true, "nullable": false, "length": 20, "defaultValue": "Active", "modelName": "LifeCycleStatus" }, { "name": "PRESSUREZONE", "type": "esriFieldTypeString", "alias": "PressureZone", "domain": null, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "PressureZone" }, { "name": "SERVICEAREA", "type": "esriFieldTypeString", "alias": "ServiceArea", "domain": null, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "ServiceArea" }, { "name": "ROTATION", "type": "esriFieldTypeDouble", "alias": "ROTATION", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ROTATION" }, { "name": "DIAMETER", "type": "esriFieldTypeString", "alias": "Diameter", "domain": { "type": "codedValue", "name": "dmnDiameterMetric", "description": "Diameter in Metric units.", "codedValues": [ { "name": "100", "code": "100" }, { "name": "150", "code": "150" }, { "name": "200", "code": "200" }, { "name": "250", "code": "250" }, { "name": "300", "code": "300" }, { "name": "350", "code": "350" }, { "name": "400", "code": "400" }, { "name": "450", "code": "450" }, { "name": "500", "code": "500" }, { "name": "550", "code": "550" }, { "name": "600", "code": "600" }, { "name": "50", "code": "50" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "Diameter" }, { "name": "GPS_X", "type": "esriFieldTypeDouble", "alias": "GPS_X", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GPS_X" }, { "name": "GPS_Y", "type": "esriFieldTypeDouble", "alias": "GPS_Y", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GPS_Y" }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "DESCRIPTION" }, { "name": "SYSTEMVALVETYPE", "type": "esriFieldTypeInteger", "alias": "SystemValveType", "domain": null, "editable": true, "nullable": true, "defaultValue": 10, "modelName": "SystemValveType" }, { "name": "SYSTEMVALVEID", "type": "esriFieldTypeString", "alias": "SystemValveID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ValveID" }, { "name": "NORMALLYOPEN", "type": "esriFieldTypeSmallInteger", "alias": "NormallyOpen", "domain": null, "editable": true, "nullable": false, "defaultValue": 1, "modelName": "NormallyOpen" }, { "name": "VALVESTATUS", "type": "esriFieldTypeString", "alias": "ValveStatus", "domain": { "type": "codedValue", "name": "dmnValveStatus", "description": "", "codedValues": [ { "name": "Open", "code": "OPEN" }, { "name": "Close", "code": "CLO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": false, "length": 10, "defaultValue": null, "modelName": "ValveStatus" }, { "name": "OPERATIONAL", "type": "esriFieldTypeSmallInteger", "alias": "Operational", "domain": null, "editable": true, "nullable": false, "defaultValue": 1, "modelName": "Operational" }, { "name": "BYPASSVALVE", "type": "esriFieldTypeSmallInteger", "alias": "BypassValve", "domain": null, "editable": true, "nullable": false, "defaultValue": 0, "modelName": "BypassValve" }, { "name": "CLOCKWISETOCLOSE", "type": "esriFieldTypeSmallInteger", "alias": "ClockwiseToClose", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "ClockwiseToClose" }, { "name": "MOTORIZED", "type": "esriFieldTypeSmallInteger", "alias": "Motorized", "domain": null, "editable": true, "nullable": false, "defaultValue": null, "modelName": "Motorized" }, { "name": "PERCENTOPEN", "type": "esriFieldTypeInteger", "alias": "PercentOpen", "domain": null, "editable": true, "nullable": true, "defaultValue": 100, "modelName": "PercentOpen" }, { "name": "TURNSTOCLOSE", "type": "esriFieldTypeInteger", "alias": "TURNSTOCLOSE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TURNSTOCLOSE" }, { "name": "REGULATIONTYPE", "type": "esriFieldTypeString", "alias": "RegulationType", "domain": null, "editable": true, "nullable": false, "length": 20, "defaultValue": null, "modelName": "RegulationType" }, { "name": "ASSOCIATEDFACILITY", "type": "esriFieldTypeString", "alias": "AssociatedFacility", "domain": null, "editable": true, "nullable": false, "length": 50, "defaultValue": null, "modelName": "AssociatedFacility" }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer", "domain": null, "editable": true, "nullable": false, "length": 20, "defaultValue": null, "modelName": "Manufacturer" }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "COMMENTS" }, { "name": "SLID", "type": "esriFieldTypeSmallInteger", "alias": "Slid", "domain": null, "editable": true, "nullable": false, "defaultValue": 0, "modelName": "Slid" }, { "name": "REMARKS", "type": "esriFieldTypeString", "alias": "REMARKS", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "REMARKS" }, { "name": "HYPERLINK", "type": "esriFieldTypeString", "alias": "HYPERLINK", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "HYPERLINK" }, { "name": "CROSSSTREET", "type": "esriFieldTypeString", "alias": "CROSSSTREET", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CROSSSTREET" }, { "name": "VALVESTREET", "type": "esriFieldTypeString", "alias": "VALVESTREET", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "VALVESTREET" }, { "name": "DISTRICT", "type": "esriFieldTypeString", "alias": "DISTRICT", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "DISTRICT" }, { "name": "EXERCISEPERCENT", "type": "esriFieldTypeInteger", "alias": "EXERCISEPERCENT", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "EXERCISEPERCENT" }, { "name": "MAP", "type": "esriFieldTypeInteger", "alias": "MAP", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAP" }, { "name": "VALVEOPEN", "type": "esriFieldTypeString", "alias": "VALVEOPEN", "domain": { "type": "codedValue", "name": "dmnYesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "VALVEOPEN" }, { "name": "QUARTER", "type": "esriFieldTypeString", "alias": "QUARTER", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "QUARTER" }, { "name": "SECTIONS", "type": "esriFieldTypeString", "alias": "SECTIONS", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "SECTIONS" }, { "name": "SUBDIVISION", "type": "esriFieldTypeString", "alias": "SUBDIVISION", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SUBDIVISION" }, { "name": "ELEVATION", "type": "esriFieldTypeDouble", "alias": "ELEVATION", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ELEVATION" }, { "name": "VALVEADDRESS", "type": "esriFieldTypeString", "alias": "VALVEADDRESS", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "VALVEADDRESS" }, { "name": "VALVEBOX", "type": "esriFieldTypeInteger", "alias": "VALVEBOX", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "VALVEBOX" }, { "name": "VALVEDRIVE", "type": "esriFieldTypeString", "alias": "VALVEDRIVE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": "Main", "modelName": "VALVEDRIVE" }, { "name": "VALVEFUNCTION", "type": "esriFieldTypeString", "alias": "VALVE FUNCTION", "domain": { "type": "codedValue", "name": "dmnFunction", "description": "Function of the Valve", "codedValues": [ { "name": "Distribution Valve", "code": "DV" }, { "name": "Hydrant Valve", "code": "HV" }, { "name": "Domestic Service", "code": "DS" }, { "name": "Fire Service", "code": "FS" }, { "name": "Interconnect", "code": "IC" }, { "name": "Check Valve", "code": "CV" }, { "name": "Zone Valve", "code": "ZONE" }, { "name": "Reclaimed Valve", "code": "RV" }, { "name": "Tapping Valve", "code": "TV" }, { "name": "Transmission Valve", "code": "TRAN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "VALVEFUNCTION" }, { "name": "VALVELATITUDEDIRECTION", "type": "esriFieldTypeString", "alias": "VALVELATITUDEDIRECTION", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "VALVELATITUDEDIRECTION" }, { "name": "VALVELATITUDEDEGREES", "type": "esriFieldTypeString", "alias": "VALVELATITUDEDEGREES", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "VALVELATITUDEDEGREES" }, { "name": "VALVELATITUDEMINUTES", "type": "esriFieldTypeString", "alias": "VALVELATITUDEMINUTES", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "VALVELATITUDEMINUTES" }, { "name": "VALVELONGITUDEDIRECTION", "type": "esriFieldTypeString", "alias": "VALVELONGITUDEDIRECTION", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "VALVELONGITUDEDIRECTION" }, { "name": "VALVELONGITUDEDEGRESS", "type": "esriFieldTypeString", "alias": "VALVELONGITUDEDEGRESS", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "VALVELONGITUDEDEGRESS" }, { "name": "VALVELONGITUDEMINUTES", "type": "esriFieldTypeString", "alias": "VALVELONGITUDEMINUTES", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "VALVELONGITUDEMINUTES" }, { "name": "VALVELOCATION", "type": "esriFieldTypeString", "alias": "VALVELOCATION", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "VALVELOCATION" }, { "name": "VALVETYPE", "type": "esriFieldTypeString", "alias": "VALVETYPE", "domain": { "type": "codedValue", "name": "dmnFunction", "description": "Function of the Valve", "codedValues": [ { "name": "Distribution Valve", "code": "DV" }, { "name": "Hydrant Valve", "code": "HV" }, { "name": "Domestic Service", "code": "DS" }, { "name": "Fire Service", "code": "FS" }, { "name": "Interconnect", "code": "IC" }, { "name": "Check Valve", "code": "CV" }, { "name": "Zone Valve", "code": "ZONE" }, { "name": "Reclaimed Valve", "code": "RV" }, { "name": "Tapping Valve", "code": "TV" }, { "name": "Transmission Valve", "code": "TRAN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "VALVETYPE" }, { "name": "LOCATIONDESCRIPTION", "type": "esriFieldTypeString", "alias": "LOCATIONDESCRIPTION", "domain": null, "editable": true, "nullable": true, "length": 211, "defaultValue": null, "modelName": "LOCATIONDESCRIPTION" }, { "name": "SETTING", "type": "esriFieldTypeDouble", "alias": "SETTING", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SETTING" }, { "name": "MINORLOSS", "type": "esriFieldTypeDouble", "alias": "MINORLOSS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MINORLOSS" }, { "name": "CURVE", "type": "esriFieldTypeString", "alias": "CURVE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CURVE" }, { "name": "CONTROLID", "type": "esriFieldTypeString", "alias": "CONTROLID", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CONTROLID" }, { "name": "UPPERLEVEL", "type": "esriFieldTypeDouble", "alias": "UPPERLEVEL", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UPPERLEVEL" }, { "name": "LOWERLEVEL", "type": "esriFieldTypeDouble", "alias": "LOWERLEVEL", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LOWERLEVEL" }, { "name": "ID", "type": "esriFieldTypeString", "alias": "ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ID" }, { "name": "MODELINGVALVETYPE", "type": "esriFieldTypeString", "alias": "MODELINGVALVETYPE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MODELINGVALVETYPE" }, { "name": "LastActivity", "type": "esriFieldTypeString", "alias": "LastActivity", "domain": { "type": "codedValue", "name": "dmnValveActivity", "description": "Activity Performed on the Valve", "codedValues": [ { "name": "Installation", "code": "INST" }, { "name": "Update Info", "code": "UPDT" }, { "name": "Exercise Valve", "code": "EXE" }, { "name": "Line Shutdown", "code": "CLS" }, { "name": "Line Reopen", "code": "OPN" }, { "name": "Repair/Replacement", "code": "RPR" }, { "name": "Remove/Abandon", "code": "ABAN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "LastActivity" }, { "name": "DateStamp", "type": "esriFieldTypeDate", "alias": "DateStamp", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateStamp" }, { "name": "OperatedBy", "type": "esriFieldTypeString", "alias": "OperatedBy", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "OperatedBy" }, { "name": "ComputerName", "type": "esriFieldTypeString", "alias": "ComputerName", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "ComputerName" }, { "name": "OperationalStatus", "type": "esriFieldTypeString", "alias": "OperationalStatus", "domain": { "type": "codedValue", "name": "dmnOperationalStatus", "description": "Operational Status of the Asset", "codedValues": [ { "name": "OK", "code": "OK" }, { "name": "Needs Repair", "code": "NRPR" }, { "name": "Inoperable", "code": "INOP" }, { "name": "Size/Turns Conflict", "code": "SIZE" }, { "name": "Unable to Locate", "code": "UTL" }, { "name": "No Access", "code": "NOAC" }, { "name": "Resurvey", "code": "RGPS" }, { "name": "Incomplete/Return", "code": "RTRN" }, { "name": "Abandoned", "code": "ABAN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 4, "defaultValue": null, "modelName": "OperationalStatus" }, { "name": "HighTorque", "type": "esriFieldTypeString", "alias": "HighTorque", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "HighTorque" }, { "name": "ActivityId", "type": "esriFieldTypeString", "alias": "ActivityId", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ActivityId" }, { "name": "AssemblytType", "type": "esriFieldTypeString", "alias": "AssemblytType", "domain": { "type": "codedValue", "name": "dmnAssemblyType", "description": "Valve Assembly Type", "codedValues": [ { "name": "Gate Valve", "code": "GV" }, { "name": "Butterfly Valve", "code": "BFV" }, { "name": "Ball Valve", "code": "BAL" }, { "name": "Plug Valve", "code": "PLG" }, { "name": "Cone Valve", "code": "CONE" }, { "name": "Check Valve", "code": "CV" }, { "name": "Meter", "code": "MTR" }, { "name": "Altitude Valve", "code": "ALT" }, { "name": "Pump", "code": "PMP" }, { "name": "Pump Control Valve", "code": "PC" }, { "name": "Cathodic Protection", "code": "CATH" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "AssemblytType" }, { "name": "Depth", "type": "esriFieldTypeString", "alias": "Depth", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "Depth" }, { "name": "UpdateGps", "type": "esriFieldTypeString", "alias": "UpdateGps", "domain": { "type": "codedValue", "name": "dmnYesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "UpdateGps" }, { "name": "LinkedDocuments", "type": "esriFieldTypeString", "alias": "LinkedDocuments", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "LinkedDocuments" }, { "name": "OpTime", "type": "esriFieldTypeString", "alias": "OpTime", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "OpTime" }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Address" }, { "name": "AddressNumber", "type": "esriFieldTypeString", "alias": "AddressNumber", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "AddressNumber" }, { "name": "CloseDirection", "type": "esriFieldTypeString", "alias": "CloseDirection", "domain": { "type": "codedValue", "name": "dmnClosePosition", "description": "", "codedValues": [ { "name": "Clockwise", "code": "CLW" }, { "name": "Counter Clockwise", "code": "CCW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "CloseDirection" }, { "name": "Crew", "type": "esriFieldTypeString", "alias": "Crew", "domain": { "type": "codedValue", "name": "Crew", "description": "", "codedValues": [ { "name": "Chris Hall", "code": "Chris" }, { "name": "Clay Sluytman", "code": "Clay" }, { "name": "Jason McConnell", "code": "Jason" }, { "name": "Andrew Christophersen", "code": "Andrew" }, { "name": "Dwayne Mallory", "code": "Dwayne" }, { "name": "Doug Jensen", "code": "Doug" }, { "name": "Mike Hanley", "code": "Mike" }, { "name": "Greg Grant", "code": "Greg" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Crew" }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AssetID" }, { "name": "Abbr", "type": "esriFieldTypeString", "alias": "Abbr", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Abbr" }, { "name": "RIMS", "type": "esriFieldTypeDouble", "alias": "RIMS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "RIMS" }, { "name": "InstallDate", "type": "esriFieldTypeDouble", "alias": "InstallDate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "InstallDate" }, { "name": "AssetTypeNew", "type": "esriFieldTypeString", "alias": "AssetTypeNew", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AssetTypeNew" }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GlobalID" }, { "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" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R14_pk", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "UUID_14", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID" }, { "name": "UUID_OID_14", "isAscending": true, "isUnique": true, "description": "", "fields": "GlobalID,OBJECTID" }, { "name": "S3_idx", "isAscending": true, "isUnique": true, "description": "", "fields": "SHAPE" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Water_GIS.DBO.SystemValves", "description": "", "prototype": { "attributes": { "AssetTypeNew": null, "InstallDate": null, "ANCILLARYROLE": null, "ENABLED": 1, "FACILITYID": null, "GRIDNUMBER": null, "ASSETNUMBER": null, "WORKORDERID": null, "INSTALLYEAR": null, "LIFECYCLESTATUS": "Active", "PRESSUREZONE": " ", "SERVICEAREA": " ", "ROTATION": null, "DIAMETER": " ", "GPS_X": null, "GPS_Y": null, "DESCRIPTION": null, "SYSTEMVALVETYPE": 10, "SYSTEMVALVEID": null, "NORMALLYOPEN": 1, "VALVESTATUS": " ", "OPERATIONAL": 1, "BYPASSVALVE": 0, "CLOCKWISETOCLOSE": 0, "MOTORIZED": 0, "PERCENTOPEN": 100, "TURNSTOCLOSE": null, "REGULATIONTYPE": " ", "ASSOCIATEDFACILITY": " ", "MANUFACTURER": " ", "COMMENTS": null, "SLID": 0, "REMARKS": null, "HYPERLINK": null, "CROSSSTREET": null, "VALVESTREET": null, "DISTRICT": null, "EXERCISEPERCENT": null, "MAP": null, "VALVEOPEN": null, "QUARTER": null, "SECTIONS": null, "SUBDIVISION": null, "ELEVATION": null, "VALVEADDRESS": null, "VALVEBOX": null, "VALVEDRIVE": "Main", "VALVEFUNCTION": null, "VALVELATITUDEDIRECTION": null, "VALVELATITUDEDEGREES": null, "VALVELATITUDEMINUTES": null, "VALVELONGITUDEDIRECTION": null, "VALVELONGITUDEDEGRESS": null, "VALVELONGITUDEMINUTES": null, "VALVELOCATION": null, "VALVETYPE": null, "LOCATIONDESCRIPTION": null, "SETTING": null, "MINORLOSS": null, "CURVE": null, "CONTROLID": null, "UPPERLEVEL": null, "LOWERLEVEL": null, "ID": null, "MODELINGVALVETYPE": null, "LastActivity": null, "DateStamp": null, "OperatedBy": null, "ComputerName": null, "OperationalStatus": null, "HighTorque": null, "ActivityId": null, "AssemblytType": null, "Depth": null, "UpdateGps": null, "LinkedDocuments": null, "OpTime": null, "Address": null, "AddressNumber": null, "CloseDirection": null, "Crew": null, "AssetID": null, "Abbr": null, "RIMS": null } }, "drawingTool": "esriFeatureEditToolPoint" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1 }