Name: Hydrants

Display Field: RECORDNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: All hydrants in Cary.

Copyright Text: Utilities Engineering

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8788587.9041733
YMin: 4252958.04695837
XMax: -8763915.75012023
YMax: 4286410.86164123
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[137,55,50,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FACILITYID (type: esriFieldTypeString, alias: Facility Identifier, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• HYDRANTNUM (type: esriFieldTypeString, alias: Hydrant Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• INSTALLDATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ESTINSTALLYEAR (type: esriFieldTypeSmallInteger, alias: Estimated Install Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YEAR (type: esriFieldTypeSmallInteger, alias: Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MANUFACTURER (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [AD: American Darling], [AFC: American Flow Control], [CLOW: Clow], ... 7 more ...)
• MODEL (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [F2345: F2345], [MARK735: Mark 73-5], [MEDALLION: Medallion], ... 2 more ...)
• MAINSIZE (type: esriFieldTypeDouble, alias: Main Size, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [0.75: 3/4"], [1: 1"], ... 27 more ...)
• MAINTYPE (type: esriFieldTypeString, alias: Main Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PUMPNOZZLESIZE (type: esriFieldTypeString, alias: Pumper Nozzle Size, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [4.5: 4 1/2"], [5.25: 5 1/4"], [4.25: 4 1/4"])
• OPERABLE (type: esriFieldTypeSmallInteger, alias: Operable, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• VALVELOCATION (type: esriFieldTypeString, alias: Valve Location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• PRESSURERATING (type: esriFieldTypeSmallInteger, alias: Pressure Rating, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PRESSUREZONE (type: esriFieldTypeString, alias: Pressure Zone, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [CPZ: Central Pressure Zone], [MOT: Morrisville Old Town], [SPZ: Southern Pressure Zone], ... 1 more ...)
• ADDRESS (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• STATUS (type: esriFieldTypeString, alias: Mapping Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Existing: Existing], [Proposed: Proposed])
• OWNEDBY (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [4: Aqua], [7: Apex], [13: Chatham County], ... 5 more ...)
• MAINTBY (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [7: Apex], [4: Aqua], [1: Cary], ... 5 more ...)
• ACTIVEFLAG (type: esriFieldTypeSmallInteger, alias: Active Flag, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• UTILEXTPERMNUM (type: esriFieldTypeString, alias: Utility Extension Permit Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• RECORDNAME (type: esriFieldTypeString, alias: Record Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• RECORDNUM (type: esriFieldTypeString, alias: Record Number, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• RECORDSOURCE (type: esriFieldTypeString, alias: Record Source, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Auto: Auto Generated], [Construction: Construction], [Construction (Permitted): Construction (Permitted)], ... 6 more ...)
• RECORDNOTES (type: esriFieldTypeString, alias: Record Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SURVEYDATE (type: esriFieldTypeDate, alias: Survey Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SURVEYNAME (type: esriFieldTypeString, alias: Survey Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• SURVEYPROJNUM (type: esriFieldTypeString, alias: Survey Project Number, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• SURVEYSOURCE (type: esriFieldTypeString, alias: Survey Source, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Consultant: Consultant Resources], [Town: Town Resources], [Record Drawing: Survey Submitted with Record Drawing], ... 1 more ...)
• SURVEYQUALHORZ (type: esriFieldTypeString, alias: Survey Quality, Horizontal, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AA: AA (PLS certified survey per NCBELS)], [A: A (PLS certified survey per NCBELS)], [B: B (PLS certified survey per NCBELS)], ... 6 more ...)
• SURVEYQUALVERT (type: esriFieldTypeString, alias: Survey Quality, Vertical, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [A: A (PLS certified survey per NCBELS)], [B: B (PLS certified survey per NCBELS)], [C: C (PLS certified survey per NCBELS)], ... 3 more ...)
• SURVEYDATUMHORZ (type: esriFieldTypeString, alias: Survey Datum, Horizontal, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [NAD27: NAD27], [NAD8386: NAD83 (1986)], [NAD8396: NAD83 (CORS96)], ... 4 more ...)
• SURVEYDATUMVERT (type: esriFieldTypeString, alias: Survey Datum, Vertical, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [NGVD29: NGVD29], [NAVD88: NAVD88])
• SURVEYPOSTPROCESSERROR (type: esriFieldTypeDouble, alias: Surrvey Post Process Error, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LOCDESC (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ROTATION (type: esriFieldTypeDouble, alias: Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• CREATED_USER (type: esriFieldTypeString, alias: Created User, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CREATED_DATE (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LAST_EDITED_USER (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LAST_EDITED_DATE (type: esriFieldTypeDate, alias: Last Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Hydrants
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• OWNEDBY: 1
• MAINTBY: 1
• ACTIVEFLAG: 0
• ENABLED: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/5/2024 7:08:59 PM

Schema Last Edit Date: 12/5/2024 7:08:59 PM

Data Last Edit Date: 12/5/2024 7:08:59 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat