View In:   ArcGIS Online Map Viewer

Name: Valve

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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.327218496912402E7
YMin: 262979.60048115253
XMax: 5.688133960042183E7
YMax: 1.773825087300299E7
Spatial Reference: 2253  (2253)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUBTYPE
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [124, 0, 145, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label: <all other values>
UniqueValueInfos:
• Value: 2
  Label: WControlValveST
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [133, 0, 11, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 1
  Label: WSystemValveST
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 166, 116, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SUBTYPE

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE, editable: true, nullable: true, defaultValue: null, modelName: ANCILLARYROLE )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: false, length: 20, defaultValue: null, modelName: FACILITYID )
• LOCATION ( type: esriFieldTypeString, alias: LOCATION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LOCATION )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• PRESSURESYSTEM ( type: esriFieldTypeString, alias: PressureSystem, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PressureSystem , Coded Values: [GED: Geddes] , [GRA: Gravity] , [NEHIPRZ: Northeash High Individual Pressure Reduced Zone] , ...10 more... )
• ROTATION ( type: esriFieldTypeDouble, alias: ROTATION, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• SUBTYPE ( type: esriFieldTypeInteger, alias: SUBTYPE, editable: true, nullable: false, defaultValue: 1, modelName: SUBTYPE )
• INSTALLCONTRACTOR ( type: esriFieldTypeString, alias: InstallContractor, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InstallContractor , Coded Values: [3S: 3-S Construction] , [AA: City of Ann Arbor Engineering] , [AAE: AAE] , ...358 more... )
• ASBUILTNUMBER ( type: esriFieldTypeString, alias: ASBUILTNUMBER, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ASBUILTNUMBER )
• DATAORIGIN ( type: esriFieldTypeString, alias: DataOrigin, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DataOrigin , Coded Values: [ASBUILT: Asbuilt] , [CDWG: Construction Drawing] , [EST: Estimate] , ...7 more... )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 10, defaultValue: null, modelName: Manufacturer , Coded Values: [AFC: American Flow Control] , [AM: American] , [CL: Clow] , ...27 more... )
• OWNER ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 10, defaultValue: AA, modelName: Owner , Coded Values: [AA: Ann Arbor] , [UM: University of Michigan] , [PRIVATE: Private] , ...7 more... )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• X_COORD ( type: esriFieldTypeDouble, alias: X_COORD, editable: true, nullable: true, defaultValue: null, modelName: X_COORD )
• Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD, editable: true, nullable: true, defaultValue: null, modelName: Y_COORD )
• Z_COORD ( type: esriFieldTypeDouble, alias: Z_COORD, editable: true, nullable: true, defaultValue: null, modelName: Z_COORD )
• MODELID ( type: esriFieldTypeString, alias: MODELID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MODELID )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: Diameter , Coded Values: [0.5: .5"] , [0.75: .75"] , [1: 1"] , ...24 more... )
• CURRENTPOSITION ( type: esriFieldTypeString, alias: CurrentPosition, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CurrentPosition , Coded Values: [OPEN: Open] , [OPIO: Open InOperable] , [CLOSE: Closed] , ...6 more... )
• MOTORIZED ( type: esriFieldTypeInteger, alias: Motorized, editable: true, nullable: true, defaultValue: 0, modelName: Motorized , Coded Values: [0: False] , [1: True] )
• TURNSTOCLOSE ( type: esriFieldTypeInteger, alias: TURNSTOCLOSE, editable: true, nullable: true, defaultValue: null, modelName: TURNSTOCLOSE )
• CLOCKWISETOCLOSE ( type: esriFieldTypeInteger, alias: ClockwiseToClose, editable: true, nullable: true, defaultValue: 0, modelName: ClockwiseToClose , Coded Values: [0: False] , [1: True] )
• PRESSURESETTING ( type: esriFieldTypeString, alias: PRESSURESETTING, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PRESSURESETTING )
• VALVEFUNCTION ( type: esriFieldTypeString, alias: ValveFunction, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ValveFunction , Coded Values: [IS: Isolation] , [HYD: Hydrant] , [OTH: Other] , ...2 more... )
• NORMALOPERATINGPOSITION ( type: esriFieldTypeString, alias: NormalOperatingPosition, editable: true, nullable: true, length: 20, defaultValue: null, modelName: NormalOperatingPosition , Coded Values: [OPEN: Open] , [OPIO: Open InOperable] , [CLOSE: Closed] , ...6 more... )
• BELOWGRADE ( type: esriFieldTypeInteger, alias: BelowGrade, editable: true, nullable: true, defaultValue: null, modelName: BelowGrade , Coded Values: [0: False] , [1: True] )
• INSTRUCTURE ( type: esriFieldTypeString, alias: InStructure, editable: true, nullable: true, length: 10, defaultValue: null, modelName: InStructure , Coded Values: [BOX: Box] , [NONE: None] , [OTH: Other] , ...5 more... )
• INSPECTOR ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 32, defaultValue: null, modelName: Inspector , Coded Values: [100: A AJAM] , [50: A OLESKI] , [51: ADAM BALL] , ...90 more... )
• VALVETYPE ( type: esriFieldTypeString, alias: VALVETYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVETYPE , Coded Values: [AIR: Air] , [AIRGAP: AirGap] , [AIRRELEASE: AirRelease] , ...18 more... )
• CreatedUser ( type: esriFieldTypeString, alias: CreatedUser, editable: true, nullable: true, length: 40, defaultValue: null, modelName: CreatedUser )
• DateCreated ( type: esriFieldTypeDate, alias: DateCreated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateCreated )
• ModifiedUser ( type: esriFieldTypeString, alias: ModifiedUser, editable: true, nullable: true, length: 40, defaultValue: null, modelName: ModifiedUser )
• DateModified ( type: esriFieldTypeDate, alias: DateModified, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateModified )
• LongKeyRequired ( type: esriFieldTypeString, alias: LongKeyRequired, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LongKeyRequired , Coded Values: [Yes: Yes] , [No: No] )
• BoundaryValve ( type: esriFieldTypeInteger, alias: BoundaryValve, editable: true, nullable: true, defaultValue: null, modelName: BoundaryValve , Coded Values: [0: False] , [1: True] )
• TurningCycle ( type: esriFieldTypeString, alias: TurningCycle, editable: true, nullable: true, length: 30, defaultValue: null, modelName: TurningCycle )
• OwnershipSeparation ( type: esriFieldTypeString, alias: OwnershipSeparation, editable: true, nullable: true, length: 100, defaultValue: null, modelName: OwnershipSeparation , Coded Values: [AA: Ann Arbor] , [UM: University of Michigan] , [PRIVATE: Private] , ...7 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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 )
• DateLastTurned ( type: esriFieldTypeDate, alias: DateLastTurned, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateLastTurned )
• TurnsToCloseActual ( type: esriFieldTypeInteger, alias: TurnsToCloseActual, editable: true, nullable: true, defaultValue: null, modelName: TurnsToCloseActual )

Types:

ID: 2
Name: WControlValveST
Domains:
• ENABLED:
  Inherited
• PRESSURESYSTEM:
  Inherited
• INSTALLCONTRACTOR:
  Inherited
• DATAORIGIN:
  Inherited
• MANUFACTURER:
  Inherited
• OWNER:
  Inherited
• DIAMETER:
  Inherited
• CURRENTPOSITION:
  Inherited
• MOTORIZED:
  Inherited
• CLOCKWISETOCLOSE:
  Inherited
• VALVEFUNCTION:
  Inherited
• NORMALOPERATINGPOSITION:
  Inherited
• BELOWGRADE:
  Inherited
• INSTRUCTURE:
  Inherited
• INSPECTOR:
  Inherited
• VALVETYPE:
  Inherited
• BoundaryValve:
  Inherited
• OwnershipSeparation:
  Inherited
Templates:
• Name: WControlValveST
  Description:
  Prototype:
  ROTATION: null
  DateLastTurned: null
  ANCILLARYROLE: null
  ENABLED: 1
  FACILITYID:
  LOCATION: null
  INSTALLDATE: null
  PRESSURESYSTEM: null
  SUBTYPE: 2
  INSTALLCONTRACTOR: null
  ASBUILTNUMBER: null
  DATAORIGIN: null
  MANUFACTURER: null
  OWNER: AA
  COMMENTS: null
  X_COORD: null
  Y_COORD: null
  Z_COORD: null
  MODELID: null
  DIAMETER: null
  CURRENTPOSITION: null
  MOTORIZED: 0
  TURNSTOCLOSE: null
  CLOCKWISETOCLOSE: 0
  PRESSURESETTING: null
  VALVEFUNCTION: null
  NORMALOPERATINGPOSITION: null
  BELOWGRADE: null
  INSTRUCTURE: null
  INSPECTOR: null
  VALVETYPE: null
  CreatedUser: null
  DateCreated: null
  ModifiedUser: null
  DateModified: null
  LongKeyRequired: null
  BoundaryValve: null
  TurningCycle: null
  OwnershipSeparation: null
  TurnsToCloseActual: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 1
Name: WSystemValveST
Domains:
• ENABLED:
  Inherited
• PRESSURESYSTEM:
  Inherited
• INSTALLCONTRACTOR:
  Inherited
• DATAORIGIN:
  Inherited
• MANUFACTURER:
  Inherited
• OWNER:
  Inherited
• DIAMETER:
  Inherited
• CURRENTPOSITION:
  Inherited
• MOTORIZED:
  Inherited
• CLOCKWISETOCLOSE:
  Inherited
• VALVEFUNCTION:
  Inherited
• NORMALOPERATINGPOSITION:
  Inherited
• BELOWGRADE:
  Inherited
• INSTRUCTURE:
  Inherited
• INSPECTOR:
  Inherited
• VALVETYPE:
  Inherited
• BoundaryValve:
  Inherited
• OwnershipSeparation:
  Inherited
Templates:
• Name: WSystemValveST
  Description:
  Prototype:
  ROTATION: null
  DateLastTurned: null
  ANCILLARYROLE: null
  ENABLED: 1
  FACILITYID:
  LOCATION: null
  INSTALLDATE: null
  PRESSURESYSTEM: null
  SUBTYPE: 1
  INSTALLCONTRACTOR: null
  ASBUILTNUMBER: null
  DATAORIGIN: null
  MANUFACTURER: null
  OWNER: AA
  COMMENTS: null
  X_COORD: null
  Y_COORD: null
  Z_COORD: null
  MODELID: null
  DIAMETER: null
  CURRENTPOSITION: null
  MOTORIZED: 0
  TURNSTOCLOSE: null
  CLOCKWISETOCLOSE: 0
  PRESSURESETTING: null
  VALVEFUNCTION: null
  NORMALOPERATINGPOSITION: null
  BELOWGRADE: null
  INSTRUCTURE: null
  INSPECTOR: null
  VALVETYPE: null
  CreatedUser: null
  DateCreated: null
  ModifiedUser: null
  DateModified: null
  LongKeyRequired: null
  BoundaryValve: null
  TurningCycle: null
  OwnershipSeparation: null
  TurnsToCloseActual: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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: true

Supports Coordinates Quantization: true

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