View In:   ArcGIS Online Map Viewer

Name: Water Valves

Display Field: MATERIAL

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: c9c56bb432e2423ab2b00d3c85714c62

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 8000.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.2687447597945731E7
YMin: 6600078.455532041
XMax: -1.2619991997295765E7
YMax: 6633414.548129643
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 254, defaultValue: null, modelName: MATERIAL )
• FUNCTION_ ( type: esriFieldTypeString, alias: Function, editable: true, nullable: true, length: 254, defaultValue: null, modelName: FUNCTION_ )
• TYPE ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 254, defaultValue: null, modelName: TYPE , Coded Values: [1: AIR RELEASE VALVE] , [2: BUTTERFLY VALVE] , [3: CHECK VALVE] , ...5 more... )
• OWN_TYPE ( type: esriFieldTypeString, alias: Owner Type, editable: true, nullable: true, length: 254, defaultValue: null, modelName: OWN_TYPE )
• INSTALL_YR ( type: esriFieldTypeDouble, alias: Install Year, editable: true, nullable: true, defaultValue: null, modelName: INSTALL_YR )
• ADDRESS ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 254, defaultValue: null, modelName: ADDRESS , Coded Values: [71: 1 102 STRATHAVEN DRIVE] , [2749: 1 113 ORCHARD WAY] , [4533: 1 118 THIRD AVENUE] , ...6096 more... )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 254, defaultValue: null, modelName: LOCATION )
• COMMUNITY ( type: esriFieldTypeString, alias: Community, editable: true, nullable: true, length: 254, defaultValue: null, modelName: COMMUNITY )
• SETTING ( type: esriFieldTypeString, alias: Setting, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SETTING )
• BURY_DEPTH ( type: esriFieldTypeDouble, alias: Bury Depth, editable: true, nullable: true, defaultValue: null, modelName: BURY_DEPTH )
• ROAD_PRJCT ( type: esriFieldTypeString, alias: Road Project Association, editable: true, nullable: true, length: 254, defaultValue: null, modelName: ROAD_PRJCT )
• ELEVATION ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• DEPTH ( type: esriFieldTypeDouble, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: DEPTH )
• MAKEMODEL ( type: esriFieldTypeString, alias: Make/Model, editable: true, nullable: true, length: 254, defaultValue: null, modelName: MAKEMODEL )
• USEFULLIFE ( type: esriFieldTypeDouble, alias: Useful Life (Years), editable: true, nullable: true, defaultValue: null, modelName: USEFULLIFE )
• NORMSTTING ( type: esriFieldTypeString, alias: Normal Setting, editable: true, nullable: true, length: 254, defaultValue: null, modelName: NORMSTTING )
• COMMENT ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 254, defaultValue: null, modelName: COMMENT )
• Collection ( type: esriFieldTypeString, alias: Collection, editable: true, nullable: true, length: 254, defaultValue: null, modelName: Collection )
• SERVICE ( type: esriFieldTypeString, alias: Service Type, editable: true, nullable: true, length: 254, defaultValue: null, modelName: SERVICE )
• Legacy_AID ( type: esriFieldTypeString, alias: Legacy Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Legacy_AID )
• MapLabel ( type: esriFieldTypeString, alias: Map Label Number, editable: true, nullable: true, length: 5, defaultValue: null, modelName: MapLabel )
• 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 )
• ASSET_ID ( type: esriFieldTypeString, alias: Asset ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSET_ID )
• CONDITION ( type: esriFieldTypeSmallInteger, alias: Condition - old (CityWorks), editable: true, nullable: true, defaultValue: null, modelName: CONDITION )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: Condition Date - old (CityWorks), editable: true, nullable: true, length: 8, defaultValue: null, modelName: CONDITIONDATE )
• CW_INSPCOND ( type: esriFieldTypeString, alias: Inspection Condition (CityWorks), editable: true, nullable: true, length: 25, defaultValue: null, modelName: CW_INSPCOND )
• CW_INSPBY ( type: esriFieldTypeString, alias: Inspected By (CityWorks), editable: true, nullable: true, length: 25, defaultValue: null, modelName: CW_INSPBY )
• CW_INSPDATE ( type: esriFieldTypeDate, alias: Inspection Date (CityWorks), editable: true, nullable: true, length: 8, defaultValue: null, modelName: CW_INSPDATE )
• OPEN_DIRTN ( type: esriFieldTypeString, alias: Turn Direction to Open, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OPEN_DIRTN , Coded Values: [1: CLOCKWISE] , [2: COUNTER-CLOCKWISE] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: Global ID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECT ID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• UDFZone ( type: esriFieldTypeString, alias: UDF Zone, editable: true, nullable: true, length: 50, defaultValue: null, modelName: UDFZone )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATUS )
• CDA_PipeSize ( type: esriFieldTypeSingle, alias: CDA Pipe Size, editable: true, nullable: true, defaultValue: null, modelName: CDA_PipeSize )
• CDA_Material ( type: esriFieldTypeString, alias: CDA Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CDA_Material )
• CDA_Total ( type: esriFieldTypeSingle, alias: CDA Total, editable: true, nullable: true, defaultValue: null, modelName: CDA_Total )
• CDA_TotalRate ( type: esriFieldTypeString, alias: CDA_TotalRate, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CDA_TotalRate )
• CDA_Value ( type: esriFieldTypeDouble, alias: CDA_Value, editable: true, nullable: true, defaultValue: null, modelName: CDA_Value )

Templates:

• Name: Water Valves
  Description:
  Prototype:
  CDA_TotalRate: null
  DIAMETER: null
  MATERIAL: null
  FUNCTION_: null
  TYPE: null
  OWN_TYPE: null
  INSTALL_YR: null
  ADDRESS: null
  LOCATION: null
  COMMUNITY: null
  SETTING: null
  BURY_DEPTH: null
  ROAD_PRJCT: null
  ELEVATION: null
  DEPTH: null
  MAKEMODEL: null
  USEFULLIFE: null
  NORMSTTING: null
  COMMENT: null
  Collection: null
  SERVICE: null
  Legacy_AID: null
  MapLabel: null
  CDA_Total: null
  CDA_Material: null
  CDA_PipeSize: null
  STATUS: null
  ASSET_ID: null
  CONDITION: null
  CONDITIONDATE: null
  CW_INSPCOND: null
  CW_INSPBY: null
  CW_INSPDATE: null
  OPEN_DIRTN: null
  CDA_Value: null
  UDFZone: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• Hydrants (0) -- Related To: Water Hydrants (20)

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

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

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

Child Resources:

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