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

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