Name: HUSA_Hydrant

Display Field: Feat_Name

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:

XMin: -9114620.1461
YMin: 3230091.0744
XMax: -9108019.1234
YMax: 3239917.2169
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[54,148,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:

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)
• Inspctr (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• 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: 50, nullable: true, editable: true)
• Manuf (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• Model (type: esriFieldTypeString, alias: Model, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• 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)
• Traf_Hyd (type: esriFieldTypeString, alias: Traffic Hydrant, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• Storz (type: esriFieldTypeString, alias: Storz Connection, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• 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)
• NumOfTstHyds (type: esriFieldTypeString, alias: Number of Hydrant's Test, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• 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)
• 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)
• 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)
• Brok_Flng (type: esriFieldTypeString, alias: Broken Flange?, SQL Type: sqlTypeOther, length: 13, nullable: true, editable: true)
• Frozen (type: esriFieldTypeString, alias: Hydrant Frozen?, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• MainVlvLeaks (type: esriFieldTypeString, alias: Main Valve Leaks?, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• OPNutIssu (type: esriFieldTypeString, alias: OP Nut Issue?, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• StemIssu (type: esriFieldTypeString, alias: Stem Issue?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• 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)
• NozIssue (type: esriFieldTypeString, alias: Nzl/Cplng Issue?, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• DoesNotDrain (type: esriFieldTypeString, alias: Does Not Drain?, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• Nds_Rotate (type: esriFieldTypeString, alias: Needs Rotate? (>30 deg off fr Street), SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• Nds_Align (type: esriFieldTypeString, alias: Needs Alignment? (>30 deg off Vert), SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Nds_Bolts (type: esriFieldTypeString, alias: Needs Bolts?, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• Markered (type: esriFieldTypeString, alias: Marker?, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• Tagged (type: esriFieldTypeString, alias: Tagged?, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
• Brushed (type: esriFieldTypeString, alias: Brushed?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Painted (type: esriFieldTypeString, alias: Painted?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• 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)
• Returned_Srvc (type: esriFieldTypeString, alias: Returned to Service, SQL Type: sqlTypeOther, length: 19, nullable: true, editable: true)
• Deliverable_ID (type: esriFieldTypeDate, alias: Deliverable ID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ProjNo (type: esriFieldTypeString, alias: Project Number, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Max_PDOP (type: esriFieldTypeDouble, alias: Max PDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Max_HDOP (type: esriFieldTypeDouble, alias: Max HDOP, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Corr_Type (type: esriFieldTypeString, alias: Corr Type, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• Rcvr_Type (type: esriFieldTypeString, alias: Rcvr Type, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• GPS_Date (type: esriFieldTypeDate, alias: GPS Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GPS_Time (type: esriFieldTypeDate, alias: GPS Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Update_Status (type: esriFieldTypeString, alias: Update Status, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• Feat_Name (type: esriFieldTypeString, alias: Feat Name, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Datafile (type: esriFieldTypeString, alias: Datafile, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Unfilt_Pos (type: esriFieldTypeSmallInteger, alias: Unfilt Pos, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Filt_Pos (type: esriFieldTypeSmallInteger, alias: Filt Pos, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Data_Dictionary_Name (type: esriFieldTypeString, alias: Data Dictionary Name, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• GPS_Week (type: esriFieldTypeSmallInteger, alias: GPS Week, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPS_Second (type: esriFieldTypeDouble, alias: GPS Second, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GNSS_Height (type: esriFieldTypeDouble, alias: GNSS Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Vert_Prec (type: esriFieldTypeDouble, alias: Vert Prec, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Horz_Prec (type: esriFieldTypeDouble, alias: Horz Prec, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Std_Dev (type: esriFieldTypeDouble, alias: Std Dev, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Latitude (type: esriFieldTypeString, alias: Latitude, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• Longitude (type: esriFieldTypeString, alias: Longitude, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• Point_ID (type: esriFieldTypeSmallInteger, alias: Point_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• 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:

Name: HUSA_Hydrant
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/21/2024 6:56:24 PM

Schema Last Edit Date: 6/21/2024 6:56:24 PM

Data Last Edit Date: 6/21/2024 6:56:24 PM

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