Layer: HUSA_Hydrant (ID:2)

View In: Map Viewer

Name: HUSA_Hydrant

Display Field: Inspctr

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[56,161,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}}},"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:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
Inspctr (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true, Coded Values: [Gary Simpson: Gary Simpson], [Hasch Pinchinat: Hasch Pinchinat], [Jordan Simpson: Jordan Simpson], ... 20 more ...)
Inspct_Date (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Inspct_Time (type: esriFieldTypeDate, alias: Inspection Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Hyd_Id (type: esriFieldTypeString, alias: Hyd ID IMPORTANT!, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
St_No (type: esriFieldTypeInteger, alias: Street Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
Strt (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
X_Strt (type: esriFieldTypeString, alias: Cross Street, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
Loc__Desc (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 230, nullable: true, editable: true)
Hyd_Status (type: esriFieldTypeString, alias: Hydrant Status, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true, Coded Values: [Operable: Operable], [Out Of Srvc: Out Of Srvc], [Not Found: Not Found], ... 3 more ...)
Manuf (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true, Coded Values: [American Darling: American Darling], [AVK: AVK], [Clow: Clow], ... 9 more ...)
Model (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true, Coded Values: [2500: 2500], [27-80: 27-80], [B-50-B: B-50-B], ... 41 more ...)
Yr_Made (type: esriFieldTypeString, alias: Year (xxxx), SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
MainVlv_Sz (type: esriFieldTypeString, alias: Main Valve Size, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [4: 4], [4.25: 4.25], [4.5: 4.5], ... 4 more ...)
Traf_Hyd (type: esriFieldTypeString, alias: Traffic Hydrant, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true, Coded Values: [Traffic Hyd: Traffic Hyd], [No: No])
Storz (type: esriFieldTypeString, alias: Storz Connection, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Storz: Storz], [No: No])
Pmpr_Hght (type: esriFieldTypeSmallInteger, alias: Pumper Cap Cntr Height above grade (in.), SQL Type: sqlTypeOther, nullable: true, editable: true)
Needs_Ext (type: esriFieldTypeString, alias: How Much Needed Extension?, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [6: 6], [12: 12], [18: 18], ... 1 more ...)
NumOfTstHyds (type: esriFieldTypeString, alias: Number of Hydrant's Test, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [Single: Single])
FlHyd_Static (type: esriFieldTypeSmallInteger, alias: Flow Hydrant Static Pressure (psi), SQL Type: sqlTypeOther, nullable: true, editable: true)
Pitot_FlHyd (type: esriFieldTypeSmallInteger, alias: Flow Hydrant Pitot Pressure (psi), SQL Type: sqlTypeOther, nullable: true, editable: true)
Low_Flo_Hyd (type: esriFieldTypeString, alias: Low Flow Hyd? (Pitot pressure < 20psi), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [Low Flow: Low Flow])
Mins_Flowed (type: esriFieldTypeSmallInteger, alias: Total Minutes Hydrant was Flowed, SQL Type: sqlTypeOther, nullable: true, editable: true)
Diffus_Type (type: esriFieldTypeString, alias: Diffuser Type, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true, Coded Values: [Yellow: Yellow], [Orange Dechlor: Orange Dechlor])
FlHyd_GPM (type: esriFieldTypeSmallInteger, alias: Flow Hydrant GPM (calc'd), SQL Type: sqlTypeOther, nullable: true, editable: true)
GalsFlowed (type: esriFieldTypeInteger, alias: Gallons Flowed, SQL Type: sqlTypeOther, nullable: true, editable: true)
Brok_Cplng (type: esriFieldTypeString, alias: Broken Stem Coupling?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Broken Coupling: Broken Coupling], [No: No])
Brok_Flng (type: esriFieldTypeString, alias: Broken Flange?, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true, Coded Values: [Broken Flange: Broken Flange], [No: No])
Frozen (type: esriFieldTypeString, alias: Hydrant Frozen?, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [Frozen: Frozen], [No: No])
MainVlvLeaks (type: esriFieldTypeString, alias: Main Valve Leaks?, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true, Coded Values: [Main Valve Leaks: Main Valve Leaks], [No: No])
OPNutIssu (type: esriFieldTypeString, alias: OP Nut Issue?, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [OP Nut Issue: OP Nut Issue], [No: No])
StemIssu (type: esriFieldTypeString, alias: Stem Issue?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Stem Issue: Stem Issue], [No: No])
OOS_Notified (type: esriFieldTypeDate, alias: Out of Svc Date Client Notified?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Leaks (type: esriFieldTypeString, alias: Leaks?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Leaks: Leaks], [No: No])
NozIssue (type: esriFieldTypeString, alias: Nzl/Cplng Issue?, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Nozzle Issue: Nozzle Issue], [No: No])
DoesNotDrain (type: esriFieldTypeString, alias: Does Not Drain?, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true, Coded Values: [Does Not Drain: Does Not Drain], [No: No])
Nds_Rotate (type: esriFieldTypeString, alias: Needs Rotate? (>30 deg off fr Street), SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true, Coded Values: [Needs Rotation: Needs Rotation], [No: No])
Nds_Align (type: esriFieldTypeString, alias: Needs Alignment? (>30 deg off Vert), SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Needs Alignment: Needs Alignment], [No: No])
Nds_Bolts (type: esriFieldTypeString, alias: Needs Bolts?, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true, Coded Values: [Needs Bolts: Needs Bolts], [No: No])
Markered (type: esriFieldTypeString, alias: Marker?, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true, Coded Values: [Already Markered: Already Markered], [Needs Marker: Needs Marker], [Markered by HUSA: Markered by HUSA])
Tagged (type: esriFieldTypeString, alias: Tagged?, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true, Coded Values: [Already Tagged: Already Tagged], [Needs Tag: Needs Tag], [Tagged by HUSA: Tagged by HUSA])
Brushed (type: esriFieldTypeString, alias: Brushed?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Already Brushed: Already Brushed], [Needs Brush: Needs Brush], [Brushed by HUSA: Brushed by HUSA])
Painted (type: esriFieldTypeString, alias: Painted?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Already Painted: Already Painted], [Needs Painted: Needs Painted], [Painted by HUSA: Painted by HUSA])
Comment (type: esriFieldTypeString, alias: Final Comments, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
Bonn_Color (type: esriFieldTypeString, alias: Bonnet Color:, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Body Color: Body Color], [Blue: Blue], [Green: Green], ... 2 more ...)
Returned_Srvc (type: esriFieldTypeString, alias: Returned to Service, SQL Type: sqlTypeOther, length: 19, nullable: true, editable: true, Coded Values: [Returned to Service: Returned to Service])
WO_Issued (type: esriFieldTypeString, alias: Work Order Issued, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [CC_RR: CC_RR], [CW_Repl: CW_Repl])
WO_Issue_Date (type: esriFieldTypeDate, alias: WO Issue Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
WO_Complete_Date (type: esriFieldTypeDate, alias: WO Complete Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Deliverable_ID (type: esriFieldTypeDate, alias: Deliverable ID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Northing (type: esriFieldTypeDouble, alias: Northing, SQL Type: sqlTypeOther, nullable: true, editable: true)
Easting (type: esriFieldTypeDouble, alias: Easting, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/21/2024 6:51:26 PM

Schema Last Edit Date: 6/21/2024 6:51:26 PM

Data Last Edit Date: 6/21/2024 6:51:26 PM

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