Name: wValve

Display Field: LegacyID

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 1b15a571ddfa4756be69f800b988be82

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• COMPKEY ( type: esriFieldTypeInteger, alias: COMPKEY, editable: true, nullable: true, defaultValue: null, modelName: COMPKEY )
• LegacyID ( type: esriFieldTypeString, alias: LegacyID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LegacyID )
• AssetID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: AssetID )
• ParentAssetID ( type: esriFieldTypeString, alias: ParentAssetID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ParentAssetID )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Description )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Location , Coded Values: )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Address )
• Safety_Note ( type: esriFieldTypeString, alias: Safety_Note, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Safety_Note )
• District ( type: esriFieldTypeString, alias: District, editable: true, nullable: true, length: 25, defaultValue: null, modelName: District , Coded Values: )
• PressureZone ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PresZone , Coded Values: )
• ValveType ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: EquipmentType , Coded Values: )
• Elevation ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: Elevation )
• Status ( type: esriFieldTypeString, alias: Valve Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: AquaDuct , Coded Values: )
• ValveSize ( type: esriFieldTypeString, alias: Valve Size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Destn )
• Direction ( type: esriFieldTypeString, alias: Direction, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Direction , Coded Values: )
• HighPress ( type: esriFieldTypeDouble, alias: High Pressure, editable: true, nullable: true, defaultValue: null, modelName: HighPress )
• LowPress ( type: esriFieldTypeDouble, alias: Low Pressure, editable: true, nullable: true, defaultValue: null, modelName: LowPress )
• Depth ( type: esriFieldTypeDouble, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: OperDepth )
• Obstr ( type: esriFieldTypeString, alias: Obstruction, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Obstr )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer , Coded Values: )
• ModelNum ( type: esriFieldTypeString, alias: Model Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ModelNum )
• SerialNum ( type: esriFieldTypeString, alias: SerialNum, editable: true, nullable: true, length: 125, defaultValue: null, modelName: SerialNum )
• MapNum ( type: esriFieldTypeString, alias: Map Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MapNum )
• BudgetNum ( type: esriFieldTypeString, alias: Budget Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BudgetNum )
• InstallationDate ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• WarrantyDate ( type: esriFieldTypeDate, alias: Warranty Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WarrantyDate )
• LifecycleStatus ( type: esriFieldTypeString, alias: LifecycleStatus, editable: true, nullable: true, length: 25, defaultValue: null, modelName: LifecycleStatus , Coded Values: [In Service: In Service - In Service] , [Out of Service: Out of Service - Out of Service] , [Abandoned: Abandoned - Abandoned] , ...3 more... )
• Condition ( type: esriFieldTypeString, alias: Condition, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Condition , Coded Values: )
• ConditionDate ( type: esriFieldTypeDate, alias: Condition Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Condition_Date )
• ConditionScore ( type: esriFieldTypeDouble, alias: Condition Score, editable: true, nullable: true, defaultValue: null, modelName: ConditionScore )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MaintainedBy , Coded Values: )
• Img_Path ( type: esriFieldTypeString, alias: Image Path, editable: true, nullable: true, length: 150, defaultValue: null, modelName: Img_Path )
• Asbuilt ( type: esriFieldTypeString, alias: Asbuilt, editable: true, nullable: true, length: 16, defaultValue: null, modelName: Asbuilt )
• Comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Comments )
• POF ( type: esriFieldTypeDouble, alias: POF, editable: true, nullable: true, defaultValue: null, modelName: POF )
• COF ( type: esriFieldTypeDouble, alias: COF, editable: true, nullable: true, defaultValue: null, modelName: COF )
• BRE ( type: esriFieldTypeDouble, alias: BRE, editable: true, nullable: true, defaultValue: null, modelName: BRE )
• 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 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• NumTurns ( type: esriFieldTypeDouble, alias: Number of Turns, editable: true, nullable: true, defaultValue: null, modelName: NumTurns )

Templates:

• Name: wValve
  Description:
  Prototype:
  NumTurns: null
  BRE: null
  COMPKEY: null
  LegacyID: null
  AssetID: null
  ParentAssetID: null
  Description: null
  Location: null
  Address: null
  Safety_Note: null
  District: null
  PressureZone: null
  ValveType: null
  Elevation: null
  Status: null
  ValveSize: null
  Direction: null
  HighPress: null
  LowPress: null
  Depth: null
  Obstr: null
  Manufacturer: null
  ModelNum: null
  SerialNum: null
  MapNum: null
  BudgetNum: null
  InstallationDate: null
  WarrantyDate: null
  LifecycleStatus: null
  Condition: null
  ConditionDate: null
  ConditionScore: null
  Owner: null
  Img_Path: null
  Asbuilt: null
  Comments: null
  POF: null
  COF: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• DBO.wWell (1) -- Related To: wWell (0)
• wPumpStation (3) -- Related To: Pump Station - Water (4)
• wSamplingStation (0) -- Related To: wSamplingStation (2)

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

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