View In:   ArcGIS Online Map Viewer

Name: Water Valve

Display Field: ASSETID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 1.343491382720571E7
YMin: 379262.5472747298
XMax: 1.3468281246831294E7
YMax: 412243.29834107426
Spatial Reference: 2253  (2253)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUBTYPEFIELD
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 3
  Label: Air Realease Valve
  Description: N/A
  Symbol:
  
• Value: 10
  Label: Isolation Valve
  Description: N/A
  Symbol:
  
• Value: 4
  Label: Gate Valve
  Description: N/A
  Symbol:
  
• Value: 9
  Label: Butterfly Valve
  Description: N/A
  Symbol:
  
• Value: 5
  Label: Tapping Sleeve and Valve
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Blow Off Valve
  Description: N/A
  Symbol:
  
• Value: 6
  Label: Post Indicator Valve
  Description: N/A
  Symbol:
  
• Value: 11
  Label: Vault
  Description: N/A
  Symbol:
  
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: SUBTYPEFIELD

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: Ancillary Role, editable: true, nullable: true, defaultValue: 0, modelName: ANCILLARYROLE , Coded Values: [1: Source] , [2: Sink] , [0: None] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• ASSETID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ASSETID )
• PLACEMENTMETHOD ( type: esriFieldTypeString, alias: Placement Method, editable: true, nullable: false, length: 3, defaultValue: DIG, modelName: PlacementMethod , Coded Values: [DIM: Dimensional] , [DIF: Differential GPS (<3ft)] , [DIG: Digitized (>3ft)] , ...4 more... )
• ASSETOWNER ( type: esriFieldTypeString, alias: Asset Owner, editable: true, nullable: false, length: 4, defaultValue: TROY, modelName: AssetOwner , Coded Values: [DDA: Downtown Development Authority] , [DNR: Data Not Researched] , [DTE: Detroit Edison] , ...5 more... )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: Lifecycle Status, editable: true, nullable: true, length: 3, defaultValue: ONL, modelName: LIFECYCLESTATUS , Coded Values: [ABA: Abandoned] , [ONL: On Line] , [PRO: Proposed] , ...2 more... )
• SURFACETYPE ( type: esriFieldTypeString, alias: Ground Surface Type, editable: true, nullable: false, length: 3, defaultValue: Y, modelName: GroundSurfaceType , Coded Values: [DNR: Data Not Researched] , [A: Primary Major Road] , [B: Secondary Road] , ...10 more... )
• ENCLOSURETYPE ( type: esriFieldTypeString, alias: Valve Enclosure Type, editable: true, nullable: false, length: 3, defaultValue: GAT, modelName: ValveEnclosureType , Coded Values: [BOX: Box] , [CHA: Chamber] , [CRB: Curbbox] , ...6 more... )
• SUBTYPEFIELD ( type: esriFieldTypeInteger, alias: Subtype, editable: true, nullable: false, defaultValue: 1, modelName: SubtypeField )
• PROJECTNUMBER ( type: esriFieldTypeString, alias: Project Number, editable: true, nullable: true, length: 15, defaultValue: null, modelName: ProjectNumber )
• TURNSOPEN ( type: esriFieldTypeSmallInteger, alias: Turns To Open, editable: true, nullable: true, defaultValue: null, modelName: TURNSOPEN )
• TURNDIR ( type: esriFieldTypeString, alias: Turn Direction, editable: true, nullable: true, length: 1, defaultValue: L, modelName: TURNDIR , Coded Values: [L: Turns Left] , [R: Turns Right] )
• VALVESTAT ( type: esriFieldTypeString, alias: Operation Status, editable: true, nullable: true, length: 3, defaultValue: OPN, modelName: VALVESTAT , Coded Values: [OPN: Open] , [CLS: Closed] , [OSO: Open Summer Only] , ...3 more... )
• REGULATIONTYPE ( type: esriFieldTypeString, alias: Regulation Type, editable: true, nullable: false, length: 4, defaultValue: FLOW, modelName: REGULATIONTYPE , Coded Values: [FLOW: Flow] , [PRES: Pressure] )
• MANUFACTURERMODEL ( type: esriFieldTypeString, alias: Manufacture & Model, editable: true, nullable: true, length: 3, defaultValue: DNR, modelName: MANUFACTURERMODEL , Coded Values: [AFD: American Flow/Double Disk] , [AFR: American Flow/Resilient Wedge] , [EJD: East Jordan/Double Disk] , ...6 more... )
• MAPDISPLAY ( type: esriFieldTypeSmallInteger, alias: Display on Map Sheet, editable: true, nullable: true, defaultValue: null, modelName: MAPDISPLAY , Coded Values: [0: No] , [1: Yes] , [-99: Data Not Researched] , ...1 more... )
• SECNUM ( type: esriFieldTypeSmallInteger, alias: Section Number, editable: true, nullable: true, defaultValue: null, modelName: SECNUM , Coded Values: [1: Section 1] , [2: Section 2] , [3: Section 3] , ...32 more... )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LOCATION )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NOTES )
• ELEVATION ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: GPSElevation , Range: [500, 1300] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 100, defaultValue: null, modelName: QUALIFIER )
• INSERVICEYEAR ( type: esriFieldTypeSmallInteger, alias: In Service Year, editable: true, nullable: true, defaultValue: null, modelName: INSERVICEYEAR )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter (Inches), editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [-99: Data Not Researched] , [0.625: 5/8"] , [0.75: 3/4"] , ...24 more... )
• created_user ( type: esriFieldTypeString, alias: Created User, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Created Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: Last Edited User, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last Edited Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Types:

ID: 3
Name: Air Release Valve
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• PLACEMENTMETHOD:
  Inherited
• ASSETOWNER:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• SURFACETYPE:
  Inherited
• ENCLOSURETYPE:
  Inherited
• TURNDIR:
  Inherited
• VALVESTAT:
  Inherited
• REGULATIONTYPE:
  Inherited
• MANUFACTURERMODEL:
  Inherited
• MAPDISPLAY:
  Inherited
• SECNUM:
  Inherited
• ELEVATION:
  Inherited
• DIAMETER:
  Inherited
Templates:
• Name: Air Realease Valve
  Description:
  Prototype:
  TURNDIR: L
  ENABLED: 1
  REGULATIONTYPE: FLOW
  SUBTYPEFIELD: 3
  ASSETOWNER: TROY
  MANUFACTURERMODEL: DNR
  ENCLOSURETYPE: GAT
  ANCILLARYROLE: 0
  VALVESTAT: OPN
  SURFACETYPE: LAW
  PLACEMENTMETHOD: DIG
  LIFECYCLESTATUS: ONL
  MAPDISPLAY: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 10
Name: Isolation Valve
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• PLACEMENTMETHOD:
  Inherited
• ASSETOWNER:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• SURFACETYPE:
  Inherited
• ENCLOSURETYPE:
  Inherited
• TURNDIR:
  Inherited
• VALVESTAT:
  Inherited
• REGULATIONTYPE:
  Inherited
• MANUFACTURERMODEL:
  Inherited
• MAPDISPLAY:
  Inherited
• SECNUM:
  Inherited
• ELEVATION:
  Inherited
• DIAMETER:
  Inherited
Templates:
• Name: Isolation Valve
  Description:
  Prototype:
  TURNDIR: L
  ENABLED: 1
  REGULATIONTYPE: FLOW
  SUBTYPEFIELD: 10
  ASSETOWNER: TROY
  MANUFACTURERMODEL: DNR
  ENCLOSURETYPE: GAT
  ANCILLARYROLE: 0
  VALVESTAT: OPN
  SURFACETYPE: LAW
  PLACEMENTMETHOD: DIG
  LIFECYCLESTATUS: ONL
  MAPDISPLAY: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Gate Valve
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• PLACEMENTMETHOD:
  Inherited
• ASSETOWNER:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• SURFACETYPE:
  Inherited
• ENCLOSURETYPE:
  Inherited
• TURNDIR:
  Inherited
• VALVESTAT:
  Inherited
• REGULATIONTYPE:
  Inherited
• MANUFACTURERMODEL:
  Inherited
• MAPDISPLAY:
  Inherited
• SECNUM:
  Inherited
• ELEVATION:
  Inherited
• DIAMETER:
  Inherited
Templates:
• Name: Gate Valve
  Description:
  Prototype:
  TURNDIR: L
  ENABLED: 1
  REGULATIONTYPE: FLOW
  SUBTYPEFIELD: 4
  ASSETOWNER: TROY
  MANUFACTURERMODEL: DNR
  ENCLOSURETYPE: GAT
  ANCILLARYROLE: 0
  VALVESTAT: OPN
  SURFACETYPE: LAW
  PLACEMENTMETHOD: DIG
  LIFECYCLESTATUS: ONL
  MAPDISPLAY: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 9
Name: Butterfly Valve
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• PLACEMENTMETHOD:
  Inherited
• ASSETOWNER:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• SURFACETYPE:
  Inherited
• ENCLOSURETYPE:
  Inherited
• TURNDIR:
  Inherited
• VALVESTAT:
  Inherited
• REGULATIONTYPE:
  Inherited
• MANUFACTURERMODEL:
  Inherited
• MAPDISPLAY:
  Inherited
• SECNUM:
  Inherited
• ELEVATION:
  Inherited
• DIAMETER:
  Inherited
Templates:
• Name: Butterfly Valve
  Description:
  Prototype:
  TURNDIR: L
  ENABLED: 1
  REGULATIONTYPE: FLOW
  SUBTYPEFIELD: 9
  ASSETOWNER: TROY
  MANUFACTURERMODEL: DNR
  ENCLOSURETYPE: GAT
  ANCILLARYROLE: 0
  VALVESTAT: OPN
  SURFACETYPE: LAW
  PLACEMENTMETHOD: DIG
  LIFECYCLESTATUS: ONL
  MAPDISPLAY: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: Tapping Sleeve and Valve
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• PLACEMENTMETHOD:
  Inherited
• ASSETOWNER:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• SURFACETYPE:
  Inherited
• ENCLOSURETYPE:
  Inherited
• TURNDIR:
  Inherited
• VALVESTAT:
  Inherited
• REGULATIONTYPE:
  Inherited
• MANUFACTURERMODEL:
  Inherited
• MAPDISPLAY:
  Inherited
• SECNUM:
  Inherited
• ELEVATION:
  Inherited
• DIAMETER:
  Inherited
Templates:
• Name: Tapping Sleeve and Valve
  Description:
  Prototype:
  TURNDIR: L
  ENABLED: 1
  REGULATIONTYPE: FLOW
  SUBTYPEFIELD: 5
  ASSETOWNER: TROY
  MANUFACTURERMODEL: DNR
  ENCLOSURETYPE: GAT
  ANCILLARYROLE: 0
  VALVESTAT: OPN
  SURFACETYPE: LAW
  PLACEMENTMETHOD: DIG
  LIFECYCLESTATUS: ONL
  MAPDISPLAY: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Blow Off Valve
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• PLACEMENTMETHOD:
  Inherited
• ASSETOWNER:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• SURFACETYPE:
  Inherited
• ENCLOSURETYPE:
  Inherited
• TURNDIR:
  Inherited
• VALVESTAT:
  Inherited
• REGULATIONTYPE:
  Inherited
• MANUFACTURERMODEL:
  Inherited
• MAPDISPLAY:
  Inherited
• SECNUM:
  Inherited
• ELEVATION:
  Inherited
• DIAMETER:
  Inherited
Templates:
• Name: Blow Off Valve
  Description:
  Prototype:
  TURNDIR: L
  ENABLED: 1
  REGULATIONTYPE: FLOW
  SUBTYPEFIELD: 2
  ASSETOWNER: TROY
  MANUFACTURERMODEL: DNR
  ENCLOSURETYPE: GAT
  ANCILLARYROLE: 0
  VALVESTAT: OPN
  SURFACETYPE: LAW
  PLACEMENTMETHOD: DIG
  LIFECYCLESTATUS: ONL
  MAPDISPLAY: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 6
Name: Post Indicator Valve
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• PLACEMENTMETHOD:
  Inherited
• ASSETOWNER:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• SURFACETYPE:
  Inherited
• ENCLOSURETYPE:
  Inherited
• TURNDIR:
  Inherited
• VALVESTAT:
  Inherited
• REGULATIONTYPE:
  Inherited
• MANUFACTURERMODEL:
  Inherited
• MAPDISPLAY:
  Inherited
• SECNUM:
  Inherited
• ELEVATION:
  Inherited
• DIAMETER:
  Inherited
Templates:
• Name: Post Indicator Valve
  Description:
  Prototype:
  TURNDIR: L
  ENABLED: 1
  REGULATIONTYPE: FLOW
  SUBTYPEFIELD: 6
  ASSETOWNER: TROY
  MANUFACTURERMODEL: DNR
  ENCLOSURETYPE: GAT
  ANCILLARYROLE: 0
  VALVESTAT: OPN
  SURFACETYPE: LAW
  PLACEMENTMETHOD: DIG
  LIFECYCLESTATUS: ONL
  MAPDISPLAY: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 11
Name: Vault
Domains:
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
• PLACEMENTMETHOD:
  Inherited
• ASSETOWNER:
  Inherited
• LIFECYCLESTATUS:
  Inherited
• SURFACETYPE:
  Inherited
• ENCLOSURETYPE:
  Inherited
• TURNDIR:
  Inherited
• VALVESTAT:
  Inherited
• REGULATIONTYPE:
  Inherited
• MANUFACTURERMODEL:
  Inherited
• MAPDISPLAY:
  Inherited
• SECNUM:
  Inherited
• ELEVATION:
  Inherited
• DIAMETER:
  Inherited
Templates:
• Name: Vault
  Description:
  Prototype:
  TURNDIR: L
  ENABLED: 1
  REGULATIONTYPE: FLOW
  SUBTYPEFIELD: 11
  ASSETOWNER: TROY
  MANUFACTURERMODEL: DNR
  ENCLOSURETYPE: GAT
  ANCILLARYROLE: 0
  VALVESTAT: OPN
  SURFACETYPE: LAW
  PLACEMENTMETHOD: DIG
  LIFECYCLESTATUS: ONL
  MAPDISPLAY: 1
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• wPressureReducingValve (1) -- Related To: Pressure Reducing Valve (30)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query DateBins   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata