View In:   ArcGIS Online Map Viewer

Name: GISDev.DBO.WaterHydrant

Display Field: HydrantID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Definition Expression: N/A

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

XMin: 3061521.524959892
YMin: 1.0136232896385893E7
XMax: 3109855.838913497
YMax: 1.017587450191963E7
Spatial Reference: 102739  (2277)  VCSWkid(115702)  LatestVCSWkid(115702)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [94, 171, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label:
Description:
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

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 )
• HydrantID ( type: esriFieldTypeString, alias: HydrantID, editable: true, nullable: true, length: 8, defaultValue: null, modelName: HydrantID )
• PlanSet ( type: esriFieldTypeString, alias: PlanSet, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PlanSet )
• PlanPage ( type: esriFieldTypeString, alias: PlanPage, editable: true, nullable: true, length: 100, defaultValue: null, modelName: PlanPage )
• ProjectID ( type: esriFieldTypeString, alias: ProjectID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ProjectID )
• CoordNorth ( type: esriFieldTypeDouble, alias: CoordNorth, editable: true, nullable: true, defaultValue: null, modelName: CoordNorth )
• CoordEast ( type: esriFieldTypeDouble, alias: CoordEast, editable: true, nullable: true, defaultValue: null, modelName: CoordEast )
• Elevation ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: Elevation )
• BarrelDiam ( type: esriFieldTypeSmallInteger, alias: BarrelDiam, editable: true, nullable: true, defaultValue: null, modelName: BarrelDiam , Coded Values: [1: 1"] , [2: 1.25"] , [3: 1.5"] , ...28 more... )
• PrZone ( type: esriFieldTypeSmallInteger, alias: PrZone, editable: true, nullable: true, defaultValue: null, modelName: PrZone , Coded Values: [1: PZ 1] , [2: PZ 2 - 870' to 1000'] , [3: PZ 3 - 1000' to 1130'] , ...1 more... )
• MainValveT ( type: esriFieldTypeString, alias: MainValveT, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MainValveT )
• OutletConf ( type: esriFieldTypeString, alias: OutletConf, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OutletConf )
• NozDiam1 ( type: esriFieldTypeSmallInteger, alias: NozDiam1, editable: true, nullable: true, defaultValue: null, modelName: NozDiam1 )
• NozDiam2 ( type: esriFieldTypeSmallInteger, alias: NozDiam2, editable: true, nullable: true, defaultValue: null, modelName: NozDiam2 )
• NozDiam3 ( type: esriFieldTypeSmallInteger, alias: NozDiam3, editable: true, nullable: true, defaultValue: null, modelName: NozDiam3 )
• NozDiam4 ( type: esriFieldTypeSmallInteger, alias: NozDiam4, editable: true, nullable: true, defaultValue: null, modelName: NozDiam4 )
• FFTest ( type: esriFieldTypeString, alias: FFTest, editable: true, nullable: true, length: 12, defaultValue: null, modelName: FFTest )
• DynPress ( type: esriFieldTypeDouble, alias: DynPress, editable: true, nullable: true, defaultValue: null, modelName: DynPress )
• FlowRate ( type: esriFieldTypeDouble, alias: FlowRate, editable: true, nullable: true, defaultValue: null, modelName: FlowRate )
• StatPress ( type: esriFieldTypeDouble, alias: StatPress, editable: true, nullable: true, defaultValue: null, modelName: StatPress )
• DateInst ( type: esriFieldTypeDate, alias: DateInst, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateInst )
• DateTest ( type: esriFieldTypeDate, alias: DateTest, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateTest )
• DrainZone ( type: esriFieldTypeString, alias: DrainZone, editable: true, nullable: true, length: 4, defaultValue: null, modelName: DrainZone )
• Address ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Address )
• Station ( type: esriFieldTypeSmallInteger, alias: Station, editable: true, nullable: true, defaultValue: null, modelName: Station , Coded Values: [1: Station 1] , [2: Station 2] , [3: Station 3] , ...2 more... )
• District ( type: esriFieldTypeSmallInteger, alias: District, editable: true, nullable: true, defaultValue: null, modelName: District )
• Class ( type: esriFieldTypeString, alias: Class, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Class )
• NotInService ( type: esriFieldTypeString, alias: NotInService, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NotInService , Coded Values: [Y: YES] , [N: NO] )
• Description ( type: esriFieldTypeString, alias: Description, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Description )
• MainID ( type: esriFieldTypeString, alias: MainID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MainID )
• MainSize ( type: esriFieldTypeSmallInteger, alias: MainSize, editable: true, nullable: true, defaultValue: null, modelName: MainSize , Coded Values: [1: 1"] , [2: 1.25"] , [3: 1.5"] , ...28 more... )
• MainType ( type: esriFieldTypeString, alias: MainType, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MainType , Coded Values: [Hob: Hobas] , [TL: T-Loc] , [Other: Other] , ...20 more... )
• Make ( type: esriFieldTypeSmallInteger, alias: Make, editable: true, nullable: true, defaultValue: null, modelName: Make , Coded Values: [1: American Darling] , [2: AWWA] , [3: CLOW] , ...7 more... )
• Model ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Model )
• Year_ ( type: esriFieldTypeSmallInteger, alias: Year_, editable: true, nullable: true, defaultValue: null, modelName: Year_ )
• ServiceType ( type: esriFieldTypeSmallInteger, alias: ServiceType, editable: true, nullable: true, defaultValue: null, modelName: ServiceType , Coded Values: [1: Residential] , [2: Commercial] , [3: Industrial] , ...5 more... )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• LucityID ( type: esriFieldTypeInteger, alias: LucityID, editable: true, nullable: true, defaultValue: null, modelName: LucityID )
• ServiceUse ( type: esriFieldTypeSmallInteger, alias: ServiceUse, editable: true, nullable: true, defaultValue: null, modelName: ServiceUse , Coded Values: [1: Public] , [2: Private] , [3: Unknown] , ...1 more... )
• ManufactureCode ( type: esriFieldTypeSmallInteger, alias: ManufactureCode, editable: true, nullable: true, defaultValue: null, modelName: ManufactureCode , Coded Values: [1: S] , [2: L] , [3: Other] )
• FireTag ( type: esriFieldTypeString, alias: FireTag, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FireTag )
• StreetReflector ( type: esriFieldTypeSmallInteger, alias: StreetReflector, editable: true, nullable: true, defaultValue: null, modelName: StreetReflector , Coded Values: [1: Yes] , [2: No] )
• CreatedBy ( type: esriFieldTypeString, alias: CreatedBy, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CreatedBy )
• CreatedDate ( type: esriFieldTypeDate, alias: CreatedDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreatedDate )
• LastEditUser ( type: esriFieldTypeString, alias: LastEditUser, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LastEditUser )
• EditDate ( type: esriFieldTypeDate, alias: EditDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EditDate )

Templates:

• Name: GISDev.DBO.WaterHydrant
  Description:
  Prototype:
  ServiceType: null
  StreetReflector: null
  HydrantID: null
  PlanSet: null
  PlanPage: null
  ProjectID: null
  CoordNorth: null
  CoordEast: null
  Elevation: null
  BarrelDiam: null
  PrZone: null
  MainValveT: null
  OutletConf: null
  NozDiam1: null
  NozDiam2: null
  NozDiam3: null
  NozDiam4: null
  FFTest: null
  DynPress: null
  FlowRate: null
  StatPress: null
  DateInst: null
  DateTest: null
  DrainZone: null
  Address: null
  Station: null
  District: null
  Class: null
  NotInService: null
  Description: null
  MainID: null
  MainSize: null
  MainType: null
  Make: null
  Model: null
  Year_: null
  Enabled: 1
  FireTag: null
  LucityID: null
  ServiceUse: null
  ManufactureCode: 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: CreatedDate
• Creator Field: CreatedBy
• Edit Date Field: EditDate
• Editor Field: LastEditUser

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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