Name: Water Hydrants

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 2bec43dbabbc4cac9ad498e5cb9360a6

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 2125836.34232579
YMin: 691071.896611631
XMax: 2313483.06693896
YMax: 835253.862177517
Spatial Reference: 103146  (6570)  VCSWkid(105703)  LatestVCSWkid(6360)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: false
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, length: 40 )
• LEGACYID ( type: esriFieldTypeString, alias: LEGACYID, length: 50 )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: Lifecycle Status, length: 25 , Coded Values: [Abandoned: Abandoned] , [Active: Active] , [ActiveNew: Active-New] , ...4 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, length: 8 )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, length: 200 )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, length: 30 , Coded Values: [American Darling: American Darling] , [Clow Corporation: Clow Corporation] , [Corey: Corey] , ...14 more... )
• MODEL ( type: esriFieldTypeString, alias: Model, length: 15 , Coded Values: [Muell: Mueller A-421] , [AVK: AVK 2780] , [AFC: AFC MK73-5] , ...1 more... )
• YEAROFHYDRANT ( type: esriFieldTypeString, alias: Year of Hydrant Model, length: 4 )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag , Coded Values: [0: False] , [1: True] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By , Coded Values: [1: City of Sumter] , [-1: Private] , [-2: Dalzell] , ...11 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By , Coded Values: [1: City of Sumter] , [-1: Private] , [-2: Other] )
• CONDITION ( type: esriFieldTypeSmallInteger, alias: Condition , Coded Values: [0: Excellent] , [1: Very Good] , [2: Good] , ...4 more... )
• CONDITIONDATE ( type: esriFieldTypeDate, alias: Condition Date, length: 8 )
• LASTSERVICE ( type: esriFieldTypeDate, alias: Last Service Date, length: 8 )
• INLETSIZE ( type: esriFieldTypeString, alias: Inlet Size, length: 25 , Coded Values: [4.5: 4.5"] , [5.25: 5.25"] , [Other: Other (See Comments)] )
• OUTLETCONFIG ( type: esriFieldTypeString, alias: Outlet Configuration, length: 15 , Coded Values: [Other: Other (See Comments)] , [4.5 2-2.5: 1-4.5" & 2-2.5"] , [5.2 2-2.5: 1-5.25" & 2-2.5"] )
• VALVE ( type: esriFieldTypeString, alias: Valve, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• COLORCAP ( type: esriFieldTypeString, alias: Cap Color, length: 10 , Coded Values: [Green: Green] , [Orange: Orange] , [Red: Red] , ...5 more... )
• REF_ENGI ( type: esriFieldTypeString, alias: Referance Folders, length: 25 )
• MARKER ( type: esriFieldTypeString, alias: Marker, length: 7 , Coded Values: [No: No] , [Yes: Yes] , [Damaged: Damaged] )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, length: 8 )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, length: 50 )
• COMMENT ( type: esriFieldTypeString, alias: Comment, length: 250 )
• SOURCE ( type: esriFieldTypeString, alias: Data Source, length: 25 , Coded Values: [0: GPS Mapping Grade] , [1: GPS Survey Grade] , [2: As Built] , ...6 more... )
• GPSDATE ( type: esriFieldTypeDate, alias: GPS Date, length: 8 )
• XCORD ( type: esriFieldTypeDouble, alias: XCORD )
• YCORD ( type: esriFieldTypeDouble, alias: YCORD )
• ZCORD ( type: esriFieldTypeDouble, alias: ZCORD )
• ROTATION ( type: esriFieldTypeDouble, alias: Symbol Rotation )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• YEAR_INSTAL ( type: esriFieldTypeSmallInteger, alias: Year Installed )
• WATERDIST ( type: esriFieldTypeSmallInteger, alias: Water District , Coded Values: [1: City of Sumter] , [-1: Private] , [-2: Dalzell] , ...11 more... )
• HYDTYPE ( type: esriFieldTypeString, alias: Type, length: 50 )
• HYDRANTDATE ( type: esriFieldTypeDate, alias: Hydrant Date, length: 8 )
• OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable , Coded Values: [0: False] , [1: True] )
• HYDRANTVALVE ( type: esriFieldTypeString, alias: Hydrant Valve, length: 3 , Coded Values: [Yes: Yes] , [No: No] )
• CLOCKTOOPEN ( type: esriFieldTypeSmallInteger, alias: Clock To Open , Coded Values: [0: Clockwise] , [1: Counter Clockwise] , [3: Unknown] )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• AncillaryRole ( type: esriFieldTypeSmallInteger, alias: AncillaryRole , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• HERBICIDEUSE ( type: esriFieldTypeString, alias: Herbicide Use, length: 4 , Coded Values: [N: No] , [Y: Yes] )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata