Name: Zone_Valve
Display Field: SubtypeName
Type: Feature Layer
Geometry Type: esriGeometryPoint
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description:
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 6225466.33766177
YMin: 1895061.27445827
XMax: 6260463.53374335
YMax: 1915581.15172552
Spatial Reference: 102645 (2229)
Drawing Info:
{"renderer":{"type":"uniqueValue","field1":"VALVEPURPOSE","uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"f21d5ebc58e25fcde7195cd43f54f0f3","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA3ElEQVQokZXRsSuEcRgH8I96b7jpMjiDI4P5Fht5YyWjZBd/AGI+0lG2WywGBmXwD/gDTnTDlS5ZpM7gShYZdDmLu95f7i2+4/N8P8PTE/lnoj6zXJE4T/aau3caqWCZpTW255gcQJNWhZMDdvERgHniQ47HGOzOCuTL7GTI7LEZgBU2kuVk1lm94OyBeg8MU0w7tEBulqkAfNFOAx18/ux74JFbTPQDVV4aXAagytYo8QIjyXKT9hX7N7wG4JTnIaZbVMaZici+cV+jXOK82wv+cMQTFtNu+QX+km8IizEX48kbKgAAAABJRU5ErkJggg==","contentType":"image/png","width":9,"height":9,"angle":0,"xoffset":0,"yoffset":0},"value":"Zone","label":"ZoneValve"}],"fieldDelimiter":",","visualVariables":[{"type":"rotationInfo","field":"ANGLE","rotationType":"arithmetic"}]},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field: VALVEPURPOSE
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- ANCILLARYROLE (type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- GRIDNO (type: esriFieldTypeString, alias: GRIDNO, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- SUBTYPE (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SUBTYPENAME (type: esriFieldTypeString, alias: SUBTYPENAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ASBUILT (type: esriFieldTypeSmallInteger, alias: Asbuilt, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- INSTALLDATE (type: esriFieldTypeDate, alias: INSTALLDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Proposed: Proposed], [Active: Active], [Abandoned: Abandoned], ... 2 more ...)
- SOURCE (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [AsBuilt: AsBuilt], [Atlas: Atlas], [GPS: GPS], ... 1 more ...)
- OWNER (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Public: Public], [Private: Private], [CAM: Cal American], ... 7 more ...)
- DWGNO (type: esriFieldTypeString, alias: DWGNO, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
- LASTEXERCISED (type: esriFieldTypeDate, alias: LASTEXERCISED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- ANGLE (type: esriFieldTypeDouble, alias: Angle, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GPS (type: esriFieldTypeSmallInteger, alias: GPS, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- MANUFACTURER (type: esriFieldTypeString, alias: MANUFACTURER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- SERVICEDATE (type: esriFieldTypeDate, alias: SERVICEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- VALVE_NO (type: esriFieldTypeString, alias: VALVE_NO, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
- DIAMETER (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.625: 5/8 inch], [0.75: 3/4 inch], [1: 1 inch], ... 30 more ...)
- LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- CLOCKWISETOCLOSE (type: esriFieldTypeSmallInteger, alias: ClockwiseToClose, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- CURRENTLYOPEN (type: esriFieldTypeSmallInteger, alias: CurrentlyOpen, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- MOTORIZED (type: esriFieldTypeSmallInteger, alias: Motorized, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- NORMALLYOPEN (type: esriFieldTypeSmallInteger, alias: NormallyOpen, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- PERCENTOPEN (type: esriFieldTypeInteger, alias: PercentOpen, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PRESSURESETTING (type: esriFieldTypeString, alias: PRESSURESETTING, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- TURNSTOCLOSE (type: esriFieldTypeDouble, alias: TURNSTOCLOSE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- VALVEPURPOSE (type: esriFieldTypeString, alias: ValvePurpose, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Zone: ZoneValve], [Reservoir: ReservoirValve], [Hydrant: HydrantValve], ... 8 more ...)
- OPERATIONALSTATUS (type: esriFieldTypeString, alias: OPERATIONALSTATUS, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [OK: OK], [NRPR: Needs Repair], [INOP: Inoperable], ... 5 more ...)
- DEPTHTONUT (type: esriFieldTypeSmallInteger, alias: DEPTHTONUT, SQL Type: sqlTypeOther, nullable: true, editable: true)
- OPERATIONCOMMENTS (type: esriFieldTypeString, alias: OPERATIONCOMMENTS, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- LASTACTIVITY (type: esriFieldTypeString, alias: LASTACTIVITY, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [INST: Installation], [UPDT: Update Info], [EXE: Exercise Valve], ... 4 more ...)
- TRAFFICLANE (type: esriFieldTypeString, alias: TRAFFICLANE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [1: Lane #1], [2: Lane #2], [3: Lane #3], ... 5 more ...)
- IWATERID (type: esriFieldTypeString, alias: IWATERID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- ADDRESSNUMBER (type: esriFieldTypeString, alias: ADDRESSNUMBER, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
- STREETPREFIX (type: esriFieldTypeString, alias: STREETPREFIX, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [N: N], [S: S], [E: E], ... 5 more ...)
- STREET (type: esriFieldTypeString, alias: STREET, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- STREETSUFFIX (type: esriFieldTypeString, alias: STREETSUFFIX, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [Ave: Ave], [Blvd: Blvd], [Cir: Cir], ... 13 more ...)
- CROSSSTREET (type: esriFieldTypeString, alias: CROSSSTREET, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- HIGHTORQUE (type: esriFieldTypeSmallInteger, alias: HIGHTORQUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
- OPTIME (type: esriFieldTypeString, alias: OPTIME, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- OPERATEDBY (type: esriFieldTypeString, alias: OPERATEDBY, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- COMPUTERNAME (type: esriFieldTypeString, alias: COMPUTERNAME, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
- Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
- ID (type: esriFieldTypeInteger, alias: ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- BoxRepair (type: esriFieldTypeSmallInteger, alias: BoxRepair, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- ValveModel (type: esriFieldTypeString, alias: ValveModel, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- ValveManufacDate (type: esriFieldTypeDate, alias: ValveManufacDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- AsbuiltDate (type: esriFieldTypeDate, alias: AsbuiltDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Types:
ID: Zone
Name: ZoneValve
Domains:
- Field Name: ENABLED
Inherited
- Field Name: ASBUILT
Inherited
- Field Name: STATUS
Inherited
- Field Name: SOURCE
Inherited
- Field Name: OWNER
Inherited
- Field Name: GPS
Inherited
- Field Name: DIAMETER
Inherited
- Field Name: CLOCKWISETOCLOSE
Inherited
- Field Name: CURRENTLYOPEN
Inherited
- Field Name: MOTORIZED
Inherited
- Field Name: NORMALLYOPEN
Inherited
- Field Name: VALVEPURPOSE
Inherited
- Field Name: OPERATIONALSTATUS
Inherited
- Field Name: LASTACTIVITY
Inherited
- Field Name: TRAFFICLANE
Inherited
- Field Name: STREETPREFIX
Inherited
- Field Name: STREETSUFFIX
Inherited
- Field Name: BoxRepair
Inherited
Templates:
Name: ZoneValve
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Attributes:
- OWNER: Public
- ASBUILT: 1
- CURRENTLYOPEN: 1
- DIAMETER: 8
- NORMALLYOPEN: 1
- ANGLE: 0
- SUBTYPE: 1
- SUBTYPENAME: Gate
- CLOCKWISETOCLOSE: 1
- MOTORIZED: 0
- VALVEPURPOSE: Zone
- GPS: 0
- STATUS: Active
- SOURCE: AsBuilt
- PERCENTOPEN: 100
- ENABLED: 1
- BoxRepair: 0
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 10/24/2023 5:03:35 PM
Schema Last Edit Date: 12/19/2023 11:52:26 PM
Data Last Edit Date: 12/19/2023 11:52:26 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat