Layer: Hydrant (ID:120)

View In: Map Viewer

Name: Hydrant

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:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"OWNER","uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"09abd62bd2e163ee515e026a8949a55a","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABCElEQVQoka3QvysEYBgH8E85P4p0CulIyXSjH0kWzsjAosjqL8CiDGwmG6WMBtvFILcYLGQgA2IRue4MGO6Uzo8zOBF3kTzT837f99Pz9Ab8sQL/DXvQkOu3cflbOBmo0P+S4SVj6FewdUE4UK4r2E42w+2eiYekzaMZ6UKwGzVlIXP1g6rew2CLzrN561jELq6+wtnioO7a3rfD2TwVzYQGqAyLIIIRrH5bNftEUclbnzpFNpc/f/+Ez3DnKe3+YkVH05jqtqWPi+uYcxwjng9OQXxD+DFlq3FYXeaOxJpYMmoUN4UmgkTUSSJq/3BcXy5a/orywlwdoPR903wPCsHpAvmP8Md6BaUJRmwxYCj1AAAAAElFTkSuQmCC","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"Private","label":"Private"},{"symbol":{"type":"esriPMS","url":"f31ffb9e61b7bb51164bc754ea88eadb","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA6UlEQVQoka3QL0uDURQH4CcMF4SB4EDQsGIYiFFEw2ZSNJgMzo+hRTAoFtkHGCh+gBWLMHAGZRZNrmkScWgwGISt+AcNu8KY78uGeODC7557H87lJvyxEv8N8xgL+QKNfuHGIEtveGelL7hLNsXMZBups/7ASYlmHMwhPcreAkM/zQmmDzhGCVd47IY7KXKzYbOPDOYxzpz2WkX511M/MRDyHb5C/oj4hE542aJ1xFSB4WLHQY173OApCm7COdkmZ8uMvOKUapU1vMRNBBVuK1xvsxhah90oEoaqIxnyc9SFOLgV0+8Je9Y3tzww4qgkwAwAAAAASUVORK5CYII=","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0},"value":"Public","label":"Public"}],"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:

Global ID Field: GlobalID

Type ID Field: OWNER

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, Coded Values: [0: None], [1: Source], [2: Sink])
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)
AsbuiltDate (type: esriFieldTypeDate, alias: AsbuiltDate, 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)
MANUFACTURER (type: esriFieldTypeString, alias: MANUFACTURER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [JONE: Jones], [CLOW: Clow], [RICH: Rich], ... 6 more ...)
SERVICEDATE (type: esriFieldTypeDate, alias: SERVICEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
HYDNO (type: esriFieldTypeString, alias: HYDNO, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
VALVE_NO (type: esriFieldTypeString, alias: VALVE_NO, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
BARRELDIA (type: esriFieldTypeDouble, alias: BarrelDia, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.625: 5/8 inch], [0.75: 3/4 inch], [1: 1 inch], ... 30 more ...)
NOZZLEDIA1 (type: esriFieldTypeDouble, alias: NozzleDia1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.625: 5/8 inch], [0.75: 3/4 inch], [1: 1 inch], ... 30 more ...)
NOZZLEDIA2 (type: esriFieldTypeDouble, alias: NozzleDia2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.625: 5/8 inch], [0.75: 3/4 inch], [1: 1 inch], ... 30 more ...)
NOZZLEDIA3 (type: esriFieldTypeDouble, alias: NozzleDia3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.625: 5/8 inch], [0.75: 3/4 inch], [1: 1 inch], ... 30 more ...)
NOZZLEDIA4 (type: esriFieldTypeDouble, alias: NozzleDia4, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.625: 5/8 inch], [0.75: 3/4 inch], [1: 1 inch], ... 30 more ...)
FIREFLOWTESTID (type: esriFieldTypeString, alias: FIREFLOWTESTID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
HIGHPRESSURE (type: esriFieldTypeSmallInteger, alias: HighPressure, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
TYPE (type: esriFieldTypeString, alias: TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
LASTPAINTED (type: esriFieldTypeDate, alias: LASTPAINTED, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
REMARKS (type: esriFieldTypeString, alias: REMARKS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
BARRELTYPE (type: esriFieldTypeString, alias: BARRELTYPE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [W: Wet Barrel], [D: Dry Barrel])
IWATERID (type: esriFieldTypeString, alias: IWATERID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
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 ...)
LASTACTIVITY (type: esriFieldTypeString, alias: LASTACTIVITY, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [INST: Installation], [UPDT: Update Info], [INSP: Inspection], ... 6 more ...)
HYDRANTMODEL (type: esriFieldTypeString, alias: HYDRANTMODEL, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
MODELYEAR (type: esriFieldTypeSmallInteger, alias: MODELYEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
STATICPSI (type: esriFieldTypeSmallInteger, alias: STATICPSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
RESIDUALPSI (type: esriFieldTypeSmallInteger, alias: RESIDUALPSI, SQL Type: sqlTypeOther, nullable: true, editable: true)
PITOT (type: esriFieldTypeSmallInteger, alias: PITOT, SQL Type: sqlTypeOther, nullable: true, editable: true)
FLOWDURATION (type: esriFieldTypeSmallInteger, alias: FLOWTIME, SQL Type: sqlTypeOther, nullable: true, editable: true)
FLOWGPM (type: esriFieldTypeSmallInteger, alias: FLOWGPM, SQL Type: sqlTypeOther, nullable: true, editable: true)
FLOWBASELINE (type: esriFieldTypeSmallInteger, alias: FLOWBASELINE, SQL Type: sqlTypeOther, nullable: true, editable: true)
PORTS2IN (type: esriFieldTypeSmallInteger, alias: PORTS2IN, SQL Type: sqlTypeOther, nullable: true, editable: true)
PORTS4IN (type: esriFieldTypeSmallInteger, alias: PORTS4IN, SQL Type: sqlTypeOther, nullable: true, editable: true)
LOCATIONDESCRIPTION (type: esriFieldTypeString, alias: LOCATIONDESCRIPTION, SQL Type: sqlTypeOther, length: 150, 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)
ISOLATIONVALVE (type: esriFieldTypeString, alias: ISOLATIONVALVE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
OPTIME (type: esriFieldTypeString, alias: OPTIME, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
ID (type: esriFieldTypeSmallInteger, alias: ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
OUTLETSIZE (type: esriFieldTypeDouble, alias: OUTLET SIZE, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2.5: 2.5"], [4: 4"], [4.5: 4.5"])
GALLONSUSED (type: esriFieldTypeSmallInteger, alias: GALLONSUSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
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)

Types:

Field Name: ANCILLARYROLE
Inherited
Field Name: ENABLED
Inherited
Field Name: ASBUILT
Inherited
Field Name: STATUS
Inherited
Field Name: SOURCE
Inherited
Field Name: OWNER
Inherited
Field Name: MANUFACTURER
Inherited
Field Name: BARRELDIA
Inherited
Field Name: NOZZLEDIA1
Inherited
Field Name: NOZZLEDIA2
Inherited
Field Name: NOZZLEDIA3
Inherited
Field Name: NOZZLEDIA4
Inherited
Field Name: HIGHPRESSURE
Inherited
Field Name: BARRELTYPE
Inherited
Field Name: OPERATIONALSTATUS
Inherited
Field Name: LASTACTIVITY
Inherited
Field Name: ISOLATIONVALVE
Inherited
Field Name: OUTLETSIZE
Inherited

OWNER: Private
ASBUILT: 1
SUBTYPE: 1
ANCILLARYROLE: 0
ENABLED: 1
STATUS: Active
SOURCE: AsBuilt
ANGLE: 0

Field Name: ANCILLARYROLE
Inherited
Field Name: ENABLED
Inherited
Field Name: ASBUILT
Inherited
Field Name: STATUS
Inherited
Field Name: SOURCE
Inherited
Field Name: OWNER
Inherited
Field Name: MANUFACTURER
Inherited
Field Name: BARRELDIA
Inherited
Field Name: NOZZLEDIA1
Inherited
Field Name: NOZZLEDIA2
Inherited
Field Name: NOZZLEDIA3
Inherited
Field Name: NOZZLEDIA4
Inherited
Field Name: HIGHPRESSURE
Inherited
Field Name: BARRELTYPE
Inherited
Field Name: OPERATIONALSTATUS
Inherited
Field Name: LASTACTIVITY
Inherited
Field Name: ISOLATIONVALVE
Inherited
Field Name: OUTLETSIZE
Inherited

OWNER: Public
ASBUILT: 1
SUBTYPE: 1
ANCILLARYROLE: 0
ENABLED: 1
STATUS: Active
SOURCE: AsBuilt
ANGLE: 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: 10/24/2023 5:03:35 PM

Data Last Edit Date: 10/24/2023 5:03:35 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat