{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 0, "name": "Water_GIS.DBO.SystemValves", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "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 }, "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 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "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 }, "defaultVisibility": 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 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "ComputerName", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "ANCILLARYROLE", "type": "esriFieldTypeSmallInteger", "alias": "ANCILLARYROLE", "domain": null }, { "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" } }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "FACILITYID", "length": 20, "domain": null }, { "name": "GRIDNUMBER", "type": "esriFieldTypeString", "alias": "GRIDNUMBER", "length": 15, "domain": null }, { "name": "ASSETNUMBER", "type": "esriFieldTypeString", "alias": "ASSETNUMBER", "length": 15, "domain": null }, { "name": "WORKORDERID", "type": "esriFieldTypeString", "alias": "WORKORDERID", "length": 20, "domain": null }, { "name": "INSTALLYEAR", "type": "esriFieldTypeInteger", "alias": "INSTALLYEAR", "domain": null }, { "name": "LIFECYCLESTATUS", "type": "esriFieldTypeString", "alias": "LifeCycleStatus", "length": 20, "domain": null }, { "name": "PRESSUREZONE", "type": "esriFieldTypeString", "alias": "PressureZone", "length": 50, "domain": null }, { "name": "SERVICEAREA", "type": "esriFieldTypeString", "alias": "ServiceArea", "length": 50, "domain": null }, { "name": "ROTATION", "type": "esriFieldTypeDouble", "alias": "ROTATION", "domain": null }, { "name": "DIAMETER", "type": "esriFieldTypeString", "alias": "Diameter", "length": 10, "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" } }, { "name": "GPS_X", "type": "esriFieldTypeDouble", "alias": "GPS_X", "domain": null }, { "name": "GPS_Y", "type": "esriFieldTypeDouble", "alias": "GPS_Y", "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "DESCRIPTION", "length": 20, "domain": null }, { "name": "SYSTEMVALVETYPE", "type": "esriFieldTypeInteger", "alias": "SystemValveType", "domain": null }, { "name": "SYSTEMVALVEID", "type": "esriFieldTypeString", "alias": "SystemValveID", "length": 50, "domain": null }, { "name": "NORMALLYOPEN", "type": "esriFieldTypeSmallInteger", "alias": "NormallyOpen", "domain": null }, { "name": "VALVESTATUS", "type": "esriFieldTypeString", "alias": "ValveStatus", "length": 10, "domain": { "type": "codedValue", "name": "dmnValveStatus", "description": "", "codedValues": [ { "name": "Open", "code": "OPEN" }, { "name": "Close", "code": "CLO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "OPERATIONAL", "type": "esriFieldTypeSmallInteger", "alias": "Operational", "domain": null }, { "name": "BYPASSVALVE", "type": "esriFieldTypeSmallInteger", "alias": "BypassValve", "domain": null }, { "name": "CLOCKWISETOCLOSE", "type": "esriFieldTypeSmallInteger", "alias": "ClockwiseToClose", "domain": null }, { "name": "MOTORIZED", "type": "esriFieldTypeSmallInteger", "alias": "Motorized", "domain": null }, { "name": "PERCENTOPEN", "type": "esriFieldTypeInteger", "alias": "PercentOpen", "domain": null }, { "name": "TURNSTOCLOSE", "type": "esriFieldTypeInteger", "alias": "TURNSTOCLOSE", "domain": null }, { "name": "REGULATIONTYPE", "type": "esriFieldTypeString", "alias": "RegulationType", "length": 20, "domain": null }, { "name": "ASSOCIATEDFACILITY", "type": "esriFieldTypeString", "alias": "AssociatedFacility", "length": 50, "domain": null }, { "name": "MANUFACTURER", "type": "esriFieldTypeString", "alias": "Manufacturer", "length": 20, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "COMMENTS", "length": 50, "domain": null }, { "name": "SLID", "type": "esriFieldTypeSmallInteger", "alias": "Slid", "domain": null }, { "name": "REMARKS", "type": "esriFieldTypeString", "alias": "REMARKS", "length": 100, "domain": null }, { "name": "HYPERLINK", "type": "esriFieldTypeString", "alias": "HYPERLINK", "length": 100, "domain": null }, { "name": "CROSSSTREET", "type": "esriFieldTypeString", "alias": "CROSSSTREET", "length": 50, "domain": null }, { "name": "VALVESTREET", "type": "esriFieldTypeString", "alias": "VALVESTREET", "length": 50, "domain": null }, { "name": "DISTRICT", "type": "esriFieldTypeString", "alias": "DISTRICT", "length": 20, "domain": null }, { "name": "EXERCISEPERCENT", "type": "esriFieldTypeInteger", "alias": "EXERCISEPERCENT", "domain": null }, { "name": "MAP", "type": "esriFieldTypeInteger", "alias": "MAP", "domain": null }, { "name": "VALVEOPEN", "type": "esriFieldTypeString", "alias": "VALVEOPEN", "length": 10, "domain": { "type": "codedValue", "name": "dmnYesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "QUARTER", "type": "esriFieldTypeString", "alias": "QUARTER", "length": 10, "domain": null }, { "name": "SECTIONS", "type": "esriFieldTypeString", "alias": "SECTIONS", "length": 10, "domain": null }, { "name": "SUBDIVISION", "type": "esriFieldTypeString", "alias": "SUBDIVISION", "length": 20, "domain": null }, { "name": "ELEVATION", "type": "esriFieldTypeDouble", "alias": "ELEVATION", "domain": null }, { "name": "VALVEADDRESS", "type": "esriFieldTypeString", "alias": "VALVEADDRESS", "length": 100, "domain": null }, { "name": "VALVEBOX", "type": "esriFieldTypeInteger", "alias": "VALVEBOX", "domain": null }, { "name": "VALVEDRIVE", "type": "esriFieldTypeString", "alias": "VALVEDRIVE", "length": 20, "domain": null }, { "name": "VALVEFUNCTION", "type": "esriFieldTypeString", "alias": "VALVE FUNCTION", "length": 20, "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" } }, { "name": "VALVELATITUDEDIRECTION", "type": "esriFieldTypeString", "alias": "VALVELATITUDEDIRECTION", "length": 20, "domain": null }, { "name": "VALVELATITUDEDEGREES", "type": "esriFieldTypeString", "alias": "VALVELATITUDEDEGREES", "length": 20, "domain": null }, { "name": "VALVELATITUDEMINUTES", "type": "esriFieldTypeString", "alias": "VALVELATITUDEMINUTES", "length": 20, "domain": null }, { "name": "VALVELONGITUDEDIRECTION", "type": "esriFieldTypeString", "alias": "VALVELONGITUDEDIRECTION", "length": 20, "domain": null }, { "name": "VALVELONGITUDEDEGRESS", "type": "esriFieldTypeString", "alias": "VALVELONGITUDEDEGRESS", "length": 20, "domain": null }, { "name": "VALVELONGITUDEMINUTES", "type": "esriFieldTypeString", "alias": "VALVELONGITUDEMINUTES", "length": 20, "domain": null }, { "name": "VALVELOCATION", "type": "esriFieldTypeString", "alias": "VALVELOCATION", "length": 20, "domain": null }, { "name": "VALVETYPE", "type": "esriFieldTypeString", "alias": "VALVETYPE", "length": 20, "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" } }, { "name": "LOCATIONDESCRIPTION", "type": "esriFieldTypeString", "alias": "LOCATIONDESCRIPTION", "length": 211, "domain": null }, { "name": "SETTING", "type": "esriFieldTypeDouble", "alias": "SETTING", "domain": null }, { "name": "MINORLOSS", "type": "esriFieldTypeDouble", "alias": "MINORLOSS", "domain": null }, { "name": "CURVE", "type": "esriFieldTypeString", "alias": "CURVE", "length": 20, "domain": null }, { "name": "CONTROLID", "type": "esriFieldTypeString", "alias": "CONTROLID", "length": 20, "domain": null }, { "name": "UPPERLEVEL", "type": "esriFieldTypeDouble", "alias": "UPPERLEVEL", "domain": null }, { "name": "LOWERLEVEL", "type": "esriFieldTypeDouble", "alias": "LOWERLEVEL", "domain": null }, { "name": "ID", "type": "esriFieldTypeString", "alias": "ID", "length": 50, "domain": null }, { "name": "MODELINGVALVETYPE", "type": "esriFieldTypeString", "alias": "MODELINGVALVETYPE", "length": 50, "domain": null }, { "name": "LastActivity", "type": "esriFieldTypeString", "alias": "LastActivity", "length": 4, "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" } }, { "name": "DateStamp", "type": "esriFieldTypeDate", "alias": "DateStamp", "length": 8, "domain": null }, { "name": "OperatedBy", "type": "esriFieldTypeString", "alias": "OperatedBy", "length": 30, "domain": null }, { "name": "ComputerName", "type": "esriFieldTypeString", "alias": "ComputerName", "length": 30, "domain": null }, { "name": "OperationalStatus", "type": "esriFieldTypeString", "alias": "OperationalStatus", "length": 4, "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" } }, { "name": "HighTorque", "type": "esriFieldTypeString", "alias": "HighTorque", "length": 5, "domain": null }, { "name": "ActivityId", "type": "esriFieldTypeString", "alias": "ActivityId", "length": 20, "domain": null }, { "name": "AssemblytType", "type": "esriFieldTypeString", "alias": "AssemblytType", "length": 25, "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" } }, { "name": "Depth", "type": "esriFieldTypeString", "alias": "Depth", "length": 5, "domain": null }, { "name": "UpdateGps", "type": "esriFieldTypeString", "alias": "UpdateGps", "length": 5, "domain": { "type": "codedValue", "name": "dmnYesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "LinkedDocuments", "type": "esriFieldTypeString", "alias": "LinkedDocuments", "length": 500, "domain": null }, { "name": "OpTime", "type": "esriFieldTypeString", "alias": "OpTime", "length": 5, "domain": null }, { "name": "Address", "type": "esriFieldTypeString", "alias": "Address", "length": 50, "domain": null }, { "name": "AddressNumber", "type": "esriFieldTypeString", "alias": "AddressNumber", "length": 10, "domain": null }, { "name": "CloseDirection", "type": "esriFieldTypeString", "alias": "CloseDirection", "length": 25, "domain": { "type": "codedValue", "name": "dmnClosePosition", "description": "", "codedValues": [ { "name": "Clockwise", "code": "CLW" }, { "name": "Counter Clockwise", "code": "CCW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Crew", "type": "esriFieldTypeString", "alias": "Crew", "length": 100, "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" } }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 50, "domain": null }, { "name": "Abbr", "type": "esriFieldTypeString", "alias": "Abbr", "length": 50, "domain": null }, { "name": "RIMS", "type": "esriFieldTypeDouble", "alias": "RIMS", "domain": null }, { "name": "InstallDate", "type": "esriFieldTypeDouble", "alias": "InstallDate", "domain": null }, { "name": "AssetTypeNew", "type": "esriFieldTypeString", "alias": "AssetTypeNew", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255, "domain": null }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8, "domain": null }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255, "domain": null }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8, "domain": null }, { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE" }, "indexes": [ { "name": "R14_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_14", "fields": "GlobalID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_14", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S3_idx", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "maxSelectionCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }