View In:   ArcGIS Online Map Viewer

Name: Water Hydrants

Display Field: SDELOADER.Infrastructure_wHydrant.FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 2d8b012ae5ee4a869c98c81ef497d8ac

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

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: 1438115.2840203382
YMin: 710030.3119273409
XMax: 1462813.5610672534
YMax: 740172.4849105924
Spatial Reference: 102745  (5646)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 112, 255, 255]
Size: 12.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
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: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ASSETID )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• LOCDESC ( type: esriFieldTypeString, alias: LOCDESC, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCDESC )
• ROTATION ( type: esriFieldTypeDouble, alias: ROTATION, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• MANUFACTURER ( type: esriFieldTypeString, alias: MANUFACTURER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MANUFACTURER , Coded Values: [American Darling: American Darling] , [Dresser: Dresser] , [Kennedy Valve: Kennedy Valve] , ...13 more... )
• OPERABLE ( type: esriFieldTypeDouble, alias: OPERABLE, editable: true, nullable: true, defaultValue: null, modelName: OPERABLE )
• LASTSERVICE ( type: esriFieldTypeDate, alias: LASTSERVICE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTSERVICE )
• ENABLED ( type: esriFieldTypeString, alias: ENABLED, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ENABLED )
• ACTIVEFLAG ( type: esriFieldTypeDouble, alias: ACTIVEFLAG, editable: true, nullable: true, defaultValue: null, modelName: ACTIVEFLAG )
• LASTUPDATE ( type: esriFieldTypeDate, alias: LASTUPDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: LASTEDITOR, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LASTEDITOR )
• GPSDATE ( type: esriFieldTypeDate, alias: GPSDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPSDATE )
• GPSSTATUS ( type: esriFieldTypeString, alias: GPSSTATUS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GPSSTATUS )
• GPSID ( type: esriFieldTypeDouble, alias: GPSID, editable: true, nullable: true, defaultValue: null, modelName: GPSID )
• NORTHING ( type: esriFieldTypeDouble, alias: NORTHING, editable: true, nullable: true, defaultValue: null, modelName: NORTHING )
• EASTING ( type: esriFieldTypeDouble, alias: EASTING, editable: true, nullable: true, defaultValue: null, modelName: EASTING )
• NEWORREPLACE ( type: esriFieldTypeString, alias: NEWORREPLACE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: NEWORREPLACE )
• MODEL ( type: esriFieldTypeString, alias: MODEL, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MODEL )
• LASTFLOWDATE ( type: esriFieldTypeDate, alias: LASTFLOWDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTFLOWDATE )
• LASTFLUSHDATE ( type: esriFieldTypeDate, alias: LASTFLUSHDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTFLUSHDATE )
• MAINSIZE ( type: esriFieldTypeString, alias: MAINSIZE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAINSIZE )
• HAS_TAG ( type: esriFieldTypeString, alias: HAS_TAG, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HAS_TAG )
• DEMELEV ( type: esriFieldTypeDouble, alias: DEMELEV, editable: true, nullable: true, defaultValue: null, modelName: DEMELEV )
• MANUYEAR ( type: esriFieldTypeString, alias: MANUYEAR, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MANUYEAR )
• CLASS ( type: esriFieldTypeString, alias: CLASS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CLASS )
• STATICPRES ( type: esriFieldTypeString, alias: STATICPRES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STATICPRES )
• RESIDPRES ( type: esriFieldTypeString, alias: RESIDPRES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: RESIDPRES )
• FLOW ( type: esriFieldTypeString, alias: FLOW, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FLOW )
• SUPELEV ( type: esriFieldTypeString, alias: SUPELEV, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SUPELEV )
• PoF ( type: esriFieldTypeString, alias: PoF, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PoF )
• CoF ( type: esriFieldTypeString, alias: CoF, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CoF )
• GlobalID ( type: esriFieldTypeString, alias: GlobalID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: GlobalID )
• OWNEDBY ( type: esriFieldTypeString, alias: OWNEDBY, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OWNEDBY )
• MAINTBY ( type: esriFieldTypeString, alias: MAINTBY, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MAINTBY )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeString, alias: created_date, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_date )
• GlobalID_1 ( type: esriFieldTypeGlobalID, alias: GlobalID_1, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID_1 )
• LifeStatus ( type: esriFieldTypeString, alias: Life Status, editable: true, nullable: true, length: 255, defaultValue: Active, modelName: LifeStatus , Coded Values: [Active: Active (in use)] , [Abandoned In: Abandoned in place] , [Abandoned Ex: Abandoned (removed)] )

Templates:

• Name: Abandoned (removed)
  Description:
  Prototype:
  LifeStatus: Abandoned Ex
  created_date: null
  ASSETID: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  MANUFACTURER: null
  OPERABLE: null
  LASTSERVICE: null
  ENABLED: null
  ACTIVEFLAG: null
  LASTUPDATE: null
  MAINTBY: null
  GPSDATE: null
  GPSSTATUS: null
  GPSID: null
  NORTHING: null
  EASTING: null
  NEWORREPLACE: null
  MODEL: null
  LASTFLOWDATE: null
  LASTFLUSHDATE: null
  MAINSIZE: null
  HAS_TAG: null
  DEMELEV: null
  MANUYEAR: null
  CLASS: null
  STATICPRES: null
  RESIDPRES: null
  FLOW: null
  SUPELEV: null
  PoF: null
  CoF: null
  GlobalID: null
  OWNEDBY: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Abandoned in place
  Description:
  Prototype:
  LifeStatus: Abandoned In
  created_date: null
  ASSETID: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  MANUFACTURER: null
  OPERABLE: null
  LASTSERVICE: null
  ENABLED: null
  ACTIVEFLAG: null
  LASTUPDATE: null
  MAINTBY: null
  GPSDATE: null
  GPSSTATUS: null
  GPSID: null
  NORTHING: null
  EASTING: null
  NEWORREPLACE: null
  MODEL: null
  LASTFLOWDATE: null
  LASTFLUSHDATE: null
  MAINSIZE: null
  HAS_TAG: null
  DEMELEV: null
  MANUYEAR: null
  CLASS: null
  STATICPRES: null
  RESIDPRES: null
  FLOW: null
  SUPELEV: null
  PoF: null
  CoF: null
  GlobalID: null
  OWNEDBY: null
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Active (in use)
  Description:
  Prototype:
  LifeStatus: Active
  created_date: null
  ASSETID: null
  FACILITYID: null
  INSTALLDATE: null
  LOCDESC: null
  ROTATION: null
  MANUFACTURER: null
  OPERABLE: null
  LASTSERVICE: null
  ENABLED: null
  ACTIVEFLAG: null
  LASTUPDATE: null
  MAINTBY: null
  GPSDATE: null
  GPSSTATUS: null
  GPSID: null
  NORTHING: null
  EASTING: null
  NEWORREPLACE: null
  MODEL: null
  LASTFLOWDATE: null
  LASTFLUSHDATE: null
  MAINSIZE: null
  HAS_TAG: null
  DEMELEV: null
  MANUYEAR: null
  CLASS: null
  STATICPRES: null
  RESIDPRES: null
  FLOW: null
  SUPELEV: null
  PoF: null
  CoF: null
  GlobalID: null
  OWNEDBY: null
  
  Drawing Tool: esriFeatureEditToolPoint

Relationships:

• SDELOADER.Infrastructure_wHydrantFlushingWorkorder (0) -- Related To: btvgis.SDELOADER.Infrastructure_wHydrantFlushingWorkorder (1)

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:
• Creator Field: created_user
• Edit Date Field:
• Editor Field: LASTEDITOR

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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