Layers:

Layer: HUSA_Valve (1)


Name: HUSA_Valve

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:

XMin: -9114621.61773553
YMin: 3229566.76392723
XMax: -9108020.42093591
YMax: 3239926.66123169
Spatial Reference: 102100 (3857)


Drawing Info:

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

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)
• FacilityID (type: esriFieldTypeString, alias: Facility ID, 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_Descp (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 230, nullable: true, editable: true)
• Vlv_Typ (type: esriFieldTypeString, alias: Valve Type, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Inline: Inline], [FH Control: FH Control], [Bypass: Bypass], ... 8 more ...)
• Hyd_Id (type: esriFieldTypeString, alias: Hyd ID IMPORTANT!, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• Opn_Dir (type: esriFieldTypeString, alias: Open Direction (Plan), SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Left: Left], [Right: Right], [NA: NA])
• Opr_Cond (type: esriFieldTypeString, alias: Operating Condition, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true, Coded Values: [Operable: Operable], [Inoperable: Inoperable], [NonTurnedValve: NonTurnedValve], ... 2 more ...)
• Surf_Cvr (type: esriFieldTypeString, alias: Surface Cover, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Grass_Dirt: Grass_Dirt], [Asphalt: Asphalt], [Concrete: Concrete], ... 2 more ...)
• CO_Cmpltd (type: esriFieldTypeString, alias: CleanOut Completed? (Solids OR Liquids), SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [CO Completed: CO Completed], [CO Attempted: CO Attempted], [No: No])
• Struc_Typ (type: esriFieldTypeString, alias: Structure Type, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true, Coded Values: [Valve Box: Valve Box], [Vault: Vault])
• Struc_Cond (type: esriFieldTypeString, alias: Structure Condition, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 1 more ...)
• NTRpl_Lid (type: esriFieldTypeString, alias: Need to Replace Lid, SQL Type: sqlTypeOther, length: 19, nullable: true, editable: true, Coded Values: [Need to Replace Lid: Need to Replace Lid], [No: No])
• Opr_Dpth_in (type: esriFieldTypeSmallInteger, alias: Operating Nut Depth Inches, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Norml_State (type: esriFieldTypeString, alias: Normal State, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [Open: Open], [Closed: Closed])
• NTRais (type: esriFieldTypeString, alias: Need To Raise, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Need to Raise Asphalt/Concrete: Need to Raise Asphalt/Concrete], [Need to Raise Dirt/Grass: Need to Raise Dirt/Grass], [No: No], ... 1 more ...)
• Fnd_Pos (type: esriFieldTypeString, alias: Found Position, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [Open: Open], [Closed: Closed])
• Lft_Pos (type: esriFieldTypeString, alias: Left Position, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [Open: Open], [Closed: Closed])
• Turns (type: esriFieldTypeSmallInteger, alias: Num Turns, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Vlv_Sz (type: esriFieldTypeSmallInteger, alias: Valve Size (fr turns), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sngl_Feed (type: esriFieldTypeString, alias: Single Feed Valve?, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true, Coded Values: [Single Feed: Single Feed], [No: No])
• Max_Torq (type: esriFieldTypeSmallInteger, alias: Max Torque 100,50,30, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Fnl_Min_Torq (type: esriFieldTypeSmallInteger, alias: Final Min Torque 100,50,30, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Sngd_Pckng_Leak (type: esriFieldTypeString, alias: Snugged Packing Leak, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Snugged Packing Leak: Snugged Packing Leak], [No: No])
• Ongng_Pckng_Leak (type: esriFieldTypeString, alias: Ongoing Packing Leak, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Ongoing Packing Leak: Ongoing Packing Leak], [No: No])
• Frozen (type: esriFieldTypeString, alias: Frozen, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true, Coded Values: [Frozen: Frozen], [No: No])
• Spins_Free (type: esriFieldTypeString, alias: Spins Free, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Spins Free: Spins Free], [No: No])
• Prtly_Oprbl (type: esriFieldTypeString, alias: When FHCV Won't Close Completely, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true, Coded Values: [Partially Operable: Partially Operable], [No: No])
• OpNut_Prob (type: esriFieldTypeString, alias: Op Nut, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [OP Nut Rounded: OP Nut Rounded], [Op Nut Missing: Op Nut Missing], [Op Nut Broken: Op Nut Broken], ... 2 more ...)
• Bx_Mslgnd (type: esriFieldTypeString, alias: Box Misaligned, SQL Type: sqlTypeOther, length: 31, nullable: true, editable: true, Coded Values: [Box Misaligned Asphalt/Concrete: Box Misaligned Asphalt/Concrete], [Box Misaligned Dirt/Grass: Box Misaligned Dirt/Grass], [No: No], ... 1 more ...)
• Pvd_Over (type: esriFieldTypeString, alias: Paved Over, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Paved Over: Paved Over], [Buried: Buried], [No: No], ... 1 more ...)
• Obstruc (type: esriFieldTypeString, alias: Obstruction, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true, Coded Values: [Obstruction: Obstruction], [No: No], [Unknown: Unknown])
• Field_Comm (type: esriFieldTypeString, alias: Field Comments, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• HUSA_Rprs (type: esriFieldTypeString, alias: HUSA Doing Repairs?, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [HUSA Repairs: HUSA Repairs], [No: No])
• RiserInstl (type: esriFieldTypeString, alias: Riser Installed?, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Riser Installed: Riser Installed], [No: No])
• BoxAdj (type: esriFieldTypeString, alias: Valve Box Adjusted?, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true, Coded Values: [Valve Box Adjusted: Valve Box Adjusted], [No: No])
• LidRpld (type: esriFieldTypeString, alias: Lid Replaced?, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true, Coded Values: [Lid Replaced: Lid Replaced], [No: No])
• Marker (type: esriFieldTypeString, alias: Marker Installed?, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true, Coded Values: [Marker Installed: Marker Installed], [No: No])
• Other_Repair (type: esriFieldTypeString, alias: Other Repair Made, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Vlv_Use (type: esriFieldTypeString, alias: Valve Use, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• 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])
• 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:

Name: HUSA_Valve
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: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

Layer: HUSA_Hydrant (2)


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:

XMin: -9114620.80943835
YMin: 3229567.31337561
XMax: -9108018.66616111
YMax: 3239925.403467
Spatial Reference: 102100 (3857)


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:

Name : OBJECTID

IsSystemMaintained : True


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:

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: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