Name: WaterHydrant

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 288896

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10258125.0447787
YMin: 5884033.34513325
XMax: -10241356.9266385
YMax: 5900946.54348215
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"RedSphere.png","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAAB3VJREFUeF7tmPlTlEcexnve94U5mANQbgQSbgiHXHINlxpRIBpRI6wHorLERUmIisKCQWM8cqigESVQS1Kx1piNi4mW2YpbcZONrilE140RCTcy3DDAcL/zbJP8CYPDL+9Ufau7uqb7eZ7P+/a8PS8hwkcgIBAQCAgEBAICAYGAQEAgIBAQCAgEBAICAYGAQEAgIBAQCDx/AoowKXFMUhD3lQrioZaQRVRS+fxl51eBTZUTdZ41U1Rox13/0JF9csGJ05Qv4jSz/YPWohtvLmSKN5iTGGqTm1+rc6weICOBRbZs1UVnrv87T1PUeovxyNsUP9P6n5cpHtCxu24cbrmwKLdj+osWiqrVKhI0xzbmZ7m1SpJ+1pFpvE2DPvGTomOxAoNLLKGLscZYvB10cbYYjrJCb7A5mrxleOBqim+cWJRakZY0JfnD/LieI9V1MrKtwokbrAtU4Vm0A3TJnphJD4B+RxD0u0LA7w7FTE4oprOCMbklEGNrfdGf4IqnQTb4wc0MFTYibZqM7JgjO8ZdJkpMln/sKu16pHZGb7IfptIWg389DPp9kcChWODoMuDdBOhL1JgpisbUvghM7AqFbtNiaFP80RLnhbuBdqi0N+1dbUpWGde9gWpuhFi95yL7sS7BA93JAb+Fn8mh4QujgPeTgb9kAZf3Apd2A+fXQ38yHjOHozB1IAJjOSEY2RSIwVUv4dd4X9wJccGHNrJ7CYQ4GGjLeNNfM+dyvgpzQstKf3pbB2A6m97uBRE0/Ergcxr8hyqg7hrwn0vAtRIKIRX6Y2pMl0RhIj8co9nBGFrvh55l3ngU7YObng7IVnFvGS+BYUpmHziY/Ls2zgP9SX50by/G9N5w6I+ogYvpwK1SoOlHQNsGfWcd9Peqof88B/rTyzF9hAIopAByQzC0JQB9ST5oVnvhnt+LOGsprvUhxNIwa0aY7cGR6Cp7tr8+whkjawIxkRWC6YJI6N+lAKq3Qf/Tx+B77oGfaQc/8hB8w2Xwtw9Bf3kzZspXY/JIDEbfpAB2BKLvVV90Jvjgoac9vpRxE8kciTVCBMMkNirJ7k/tRHyjtxwjKV4Yp3t/6s+R4E+/DH3N6+BrS8E314Dvvg2+/Sb4hxfBf5sP/up2TF3ZhonK1zD6dhwGdwail26DzqgX8MRKiq9ZBpkSkmeYOyPM3m9Jjl+1Z9D8AgNtlAq6bZ70qsZi+q+bwV/7I/hbB8D/dAr8Axq89iz474p/G5++koHJy1sx/lkGdBc2YjA3HF0rHNHuboomuQj/5DgclIvOGCGCYRKFFuTMV7YUAD3VDQaLMfyqBcZORGPy01QKYSNm/rYV/Nd/Av9NHvgbueBrsjDzRQamKKDxT9Kgq1iLkbIUDOSHoiNcgnYHgnYZi+9ZExSbiSoMc2eE2flKcuJLa4KGRQz6/U0wlGaP0feiMH4uFpMXEjBVlYjp6lWY+SSZtim0kulYMiYuJEJXuhTDJ9UYPByOvoIwdCxfgE4bAo0Jh39xLAoVpMwIEQyTyFCQvGpLon9sJ0K3J4OBDDcMH1dj9FQsxkrjMPFRPCbOx2GyfLal9VEcxstioTulxjAFNfROJPqLl6Bnfyg6V7ugz5yBhuHwrZjBdiU5YJg7I8wOpifAKoVIW7uQ3rpOBH2b3ekVjYT2WCRG3o+mIGKgO0OrlIaebU/HYOQDNbQnojB4NJyGD0NPfjA0bwTRE6Q7hsUcWhkWN8yZqSQlWWGECAZLmJfJmbrvVSI8taK37xpbdB/wQW8xPee/8xIGjvlj8IQ/hk4G0JbWcX8MHPVDX4kveoq8ocn3xLM33NCZRcPHOGJYZIKfpQyq7JjHS6yJjcHujLHADgkpuC7h8F8zEVqXSNC2awE69lqhs8AamkO26HrbDt2H7dBVQov2NcW26CiwQtu+BWjdY4n2nZboTbfCmKcCnRyDO/YmyLPnDlHvjDH8G6zhS9/wlEnYR7X00fWrFYuWdVI0ZpuhcbcczW/R2qdAcz6t/bRov4mONeaaoYl+p22rHF0bVNAmKtBvweIXGxNcfFH8eNlC4m6wMWMusEnKpn5hyo48pj9gLe4SNG9QoGGLAk8z5XiaJUd99u8122/IpBA2K9BGg2vWWKAvRYVeLzEa7E1R422m2+MsSTem97nSYnfKyN6/mzATv7AUgqcMrUnmaFlLX3ysM0fj+t/b5lQLtK22QEfyAmiSLKFZpUJ7kBRPXKW4HqCYynWVHKSG2LkyZex1uO1mZM9lKem9Tx9jjY5iNEYo0bKMhn7ZAu0r6H5PpLXCAq0rKJClSjSGynE/QIkrQYqBPe6S2X+AJsY2Ped6iWZk6RlL0c2r5szofRsO9R5S1IfQLRCpQL1aifoYFerpsbkuTImaUJXuXIDiH6/Ys8vm3Mg8L2i20YqsO7fItKLcSXyn0kXccclVqv3MS6at9JU/Ox+ouns+SF6Z4cSupz7l8+z1ucs7LF1AQjOdxfGZzmx8Iu1TRcfnrioICAQEAgIBgYBAQCAgEBAICAQEAgIBgYBAQCAgEBAICAQEAv8H44b/6ZiGvGAAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15}}}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
• ANCILLARYROLE (type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE, 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])
• CREATIONUSER (type: esriFieldTypeString, alias: Creation User, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• DATECREATED (type: esriFieldTypeDate, alias: Date Created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• DATEMODIFIED (type: esriFieldTypeDate, alias: Date Modified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• LASTUSER (type: esriFieldTypeString, alias: Last User, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CONDITION (type: esriFieldTypeString, alias: CONDITION, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CONDITIONDATE (type: esriFieldTypeDate, alias: Condition Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INSTALLDATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [PROP: Proposed], [ACT: Active], [ABN: Abandoned], ... 1 more ...)
• WORKORDERID (type: esriFieldTypeString, alias: Work Order ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ELEVATION (type: esriFieldTypeDouble, alias: ELEVATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WATERTYPE (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [POT: Potable Water], [RAW: Raw Water])
• SYMBOLROTATION (type: esriFieldTypeDouble, alias: SymbolRotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WATERTRACEWEIGHT (type: esriFieldTypeInteger, alias: Water Trace Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BARRELDIAMETER (type: esriFieldTypeDouble, alias: Barrel Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 0.75"], [1: 1"], [1.5: 1.5"], ... 18 more ...)
• NOZZLEDIAMETER1 (type: esriFieldTypeDouble, alias: Nozzle Diameter 1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 0.75"], [1: 1"], [1.5: 1.5"], ... 18 more ...)
• NOZZLEDIAMETER2 (type: esriFieldTypeDouble, alias: Nozzle Diameter 2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 0.75"], [1: 1"], [1.5: 1.5"], ... 18 more ...)
• NOZZLEDIAMETER3 (type: esriFieldTypeDouble, alias: Nozzle Diameter 3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 0.75"], [1: 1"], [1.5: 1.5"], ... 18 more ...)
• NOZZLEDIAMETER4 (type: esriFieldTypeDouble, alias: Nozzle Diameter 4, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 0.75"], [1: 1"], [1.5: 1.5"], ... 18 more ...)
• OUTLETCONFIGURATION (type: esriFieldTypeString, alias: Outlet Configuration, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Standard: Standard Configuration], [DoubleHead: Double Head Configuration], [TwoHole: Two Hole Configuration])
• SEATDIAMETER (type: esriFieldTypeInteger, alias: Seat Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MANUFACTURER (type: esriFieldTypeString, alias: MANUFACTURER, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [RDW: RD Wood], [KEN: Kennedy], [SPK: South Park], ... 3 more ...)
• WETDRY (type: esriFieldTypeString, alias: Wet/Dry, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• SUBTYPECD (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MAPNUM (type: esriFieldTypeString, alias: MAPNUM, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• BADGENUMBER (type: esriFieldTypeInteger, alias: BADGENUMBER, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PURCHASEDATE (type: esriFieldTypeDate, alias: PURCHASEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LENGTH (type: esriFieldTypeInteger, alias: Length, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [76: 7 Feet 6 Inches], [86: 8 Feet 6 Inches])
• LABELTEXT (type: esriFieldTypeString, alias: LABELTEXT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• OWNER (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [SWL&P: SWL&P], [Private: Private])
• GPS_DATE (type: esriFieldTypeDate, alias: GPS_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ENG_PLUG (type: esriFieldTypeString, alias: ENG_PLUG, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• GPS_LAT (type: esriFieldTypeDouble, alias: GPS_LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPS_LONG (type: esriFieldTypeDouble, alias: GPS_LONG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DRAIN (type: esriFieldTypeString, alias: DRAIN, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• FIREDEPTID (type: esriFieldTypeString, alias: FIREDEPTID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FIRE_DIST (type: esriFieldTypeString, alias: Fire District, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• MAINTENANCEDATE (type: esriFieldTypeDate, alias: Maintenance Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LINKEDDOC (type: esriFieldTypeString, alias: Linked Documents, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• SLAMSCLOSED (type: esriFieldTypeString, alias: Slams Closed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• RVANTIFREEZE (type: esriFieldTypeString, alias: RV Antifreeze Added, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• RVANTIFREEZEDATE (type: esriFieldTypeDate, alias: RV Antifreeze Added Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OPERABLE (type: esriFieldTypeString, alias: Operable, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• INSPECTED (type: esriFieldTypeString, alias: INSPECTED, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• ServerOID (type: esriFieldTypeInteger, alias: ServerOID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• FLUSHDAYS (type: esriFieldTypeInteger, alias: Days since flushed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LASTINSPGUID (type: esriFieldTypeGUID, alias: LASTINSPGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• FLUSHBY (type: esriFieldTypeString, alias: Flushed by, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• ENABLED: 1
• LIFECYCLESTATUS: ACT
• WATERTYPE: POT
• SYMBOLROTATION: 0
• BARRELDIAMETER: 5.25
• NOZZLEDIAMETER1: 4
• NOZZLEDIAMETER2: 2.5
• NOZZLEDIAMETER3: 2.5
• SUBTYPECD: 1
• SLAMSCLOSED: N
• RVANTIFREEZE: N

Relationships:

• WaterHydrant_InspectionHydrant (0) -- Related To: InspectionHydrant (4)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/14/2023 7:32:09 PM

Schema Last Edit Date: 10/27/2023 7:21:15 PM

Data Last Edit Date: 11/14/2023 7:32:09 PM

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