Name: LSSE_MHPS_Survey123_Form

Display Field: objectid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -180
YMin: -90
XMax: 180
YMax: 90
Spatial Reference: 4326 (4326)

Drawing Info:

{"labelingInfo":null,"renderer":{"description":"Survey Data Locations","label":"LSSE MHPS Survey123 Form","symbol":{"angle":0,"color":[255,0,0,255],"outline":{"color":[255,255,0,255],"width":1},"size":8,"style":"esriSMSCircle","type":"esriSMS","xoffset":0,"yoffset":0},"type":"simple"},"transparency":0}

HasZ: false

HasM: false

Has Attachments: true

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)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeGUID, length: 38, nullable: false, editable: false)
• manhole_id (type: esriFieldTypeString, alias: Manhole ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• alcosan_id (type: esriFieldTypeString, alias: ALCOSAN ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• owner_id (type: esriFieldTypeString, alias: Owner, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• date_time (type: esriFieldTypeDate, alias: Date and Time, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• weather (type: esriFieldTypeString, alias: Weather, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [dry: Dry], [heavy_rain: Heavy Rain], [light_rain: Light Rain], ... 2 more ...)
• temperature (type: esriFieldTypeDouble, alias: Temperature (degrees F), SQL Type: sqlTypeOther, nullable: true, editable: true)
• street (type: esriFieldTypeString, alias: Street Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• surface_type (type: esriFieldTypeString, alias: Surface Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [asphalt: Asphalt], [concrete_pavement: Concrete Pavement], [concrete_collar: Concrete Collar], ... 3 more ...)
• surface_type_other (type: esriFieldTypeString, alias: Specify 'Other' Surface Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• location_notes (type: esriFieldTypeString, alias: Location Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• structure_type (type: esriFieldTypeString, alias: Structure Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [manhole: Manhole], [lamphole: Lamphole], [catch_basin: Catch Basin])
• system_type (type: esriFieldTypeString, alias: System Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CB: Combined], [SS: Sanitary], [SW: Stormwater], ... 1 more ...)
• surcharge_yes_no (type: esriFieldTypeString, alias: Evidence of Surcharge, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• surcharge_depth (type: esriFieldTypeDouble, alias: Surcharge Depth (ft.), SQL Type: sqlTypeOther, nullable: true, editable: true)
• rim_invert (type: esriFieldTypeDouble, alias: Rim to Invert (Tenth of a Foot), SQL Type: sqlTypeOther, nullable: true, editable: true)
• rim_grade (type: esriFieldTypeDouble, alias: Rim to Grade (Tenth of a Foot), SQL Type: sqlTypeOther, nullable: true, editable: true)
• grade_invert (type: esriFieldTypeDouble, alias: Grade to Invert (Tenth of a Foot), SQL Type: sqlTypeOther, nullable: true, editable: true)
• pipe_cond_comments (type: esriFieldTypeString, alias: Observed Pipe Condition Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cover_diameter (type: esriFieldTypeDouble, alias: Cover Diameter (Inches), SQL Type: sqlTypeOther, nullable: true, editable: true)
• cover_length (type: esriFieldTypeDouble, alias: Cover Length (Inches) (if Square or Rectangular), SQL Type: sqlTypeOther, nullable: true, editable: true)
• pick_hole_present (type: esriFieldTypeString, alias: Pick Hole Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• cover_condition (type: esriFieldTypeString, alias: Cover Condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [bolts_missing: Bolts Missing], [broken: Broken], [corroded: Corroded (Pitted)], ... 5 more ...)
• frame_material (type: esriFieldTypeString, alias: Frame Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [cas: Cast Iron], [cn: Concrete Cast in Place], [cr: Concrete Precast], ... 8 more ...)
• frame_material_zzz (type: esriFieldTypeDouble, alias: Specify 'Other' Frame Material, SQL Type: sqlTypeOther, nullable: true, editable: true)
• frame_diam (type: esriFieldTypeDouble, alias: Frame Opening Diameter (Inches), SQL Type: sqlTypeOther, nullable: true, editable: true)
• frame_length (type: esriFieldTypeDouble, alias: Frame Opening Length (Inches) (if Square or Rectangular), SQL Type: sqlTypeOther, nullable: true, editable: true)
• frame_condition (type: esriFieldTypeString, alias: Frame Condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [broken: Broken], [coated: Coated], [corroded: Corroded (Pitted/Worn)], ... 4 more ...)
• frame_insert (type: esriFieldTypeString, alias: Insert, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• insert_type (type: esriFieldTypeString, alias: Frame Insert Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [m: Metal], [n: None], [p: Plastic], ... 1 more ...)
• insert_type_other (type: esriFieldTypeString, alias: Specify 'Other' Frame Insert Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• adjustment_ring_type (type: esriFieldTypeString, alias: Adjustment Ring Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [a: Adjustable], [n: None], [s: Solid])
• adjustment_ring_material (type: esriFieldTypeString, alias: Adjustment Ring Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [cas: Cast Iron], [cn: Concrete Cast in Place], [cr: Concrete Precast], ... 8 more ...)
• adjust_ring_material_other (type: esriFieldTypeString, alias: Specify 'Other' Adjustment Right Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• steps_present (type: esriFieldTypeString, alias: Steps Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• steps_material (type: esriFieldTypeString, alias: Steps Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [brick: Brick], [metal: Metal], [plastic: Plastic], ... 1 more ...)
• steps_material_other (type: esriFieldTypeString, alias: Specify 'Other' Steps Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• steps_condition (type: esriFieldTypeString, alias: Steps Condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [d: Defective], [s: Sound], [x: Not Known])
• steps_defects (type: esriFieldTypeString, alias: Steps Defects, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [missing: Missing], [broken: Broken], [corroded: Corroded], ... 1 more ...)
• steps_notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• chimney_present (type: esriFieldTypeString, alias: Chimney Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• chimney_depth (type: esriFieldTypeDouble, alias: Chimney Depth (Tenth of a Foot), SQL Type: sqlTypeOther, nullable: true, editable: true)
• chimney_condition (type: esriFieldTypeString, alias: Chimney Condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [d: Defective], [s: Sound], [x: Not Known])
• chimney_defects (type: esriFieldTypeString, alias: Chimney Defects, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• chimney_notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cone_type (type: esriFieldTypeString, alias: Cone Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [CC: Conical Centeres (Concentric)], [CO: Concial Off-Centered (Eccentric)], [FT: Flat Top], ... 2 more ...)
• cone_type_other (type: esriFieldTypeString, alias: Specify 'Other' Cone Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cone_material (type: esriFieldTypeString, alias: Cone Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [BR: Brick], [CR: Concrete (Precast)], [CN: Concrete (Cast in Place)], ... 12 more ...)
• cone_material_other (type: esriFieldTypeString, alias: Specify 'Other' Cone Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• wall_diameter (type: esriFieldTypeDouble, alias: Wall Diameter (Tenth of a Foot), SQL Type: sqlTypeOther, nullable: true, editable: true)
• wall_length (type: esriFieldTypeDouble, alias: Wall Length (Tenth of a Foot) (If Square or Rectangular), SQL Type: sqlTypeOther, nullable: true, editable: true)
• wall_material (type: esriFieldTypeString, alias: Wall Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [BR: Brick], [CR: Concrete (Precast)], [CN: Concrete (Cast in Place)], ... 12 more ...)
• wall_material_other (type: esriFieldTypeString, alias: Specify 'Other' Wall Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• wall_lined (type: esriFieldTypeString, alias: Wall Liner?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• wall_condition (type: esriFieldTypeString, alias: Wall Condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [D: Defective], [S: Sound], [X: Not Known])
• wall_defects (type: esriFieldTypeString, alias: Wall Defects, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• wall_notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• bench_present (type: esriFieldTypeString, alias: Bench Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [partial: Partial])
• bench_material (type: esriFieldTypeString, alias: Bench Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [BR: Brick], [CN: Concrete (Cast in Place)], [CR: Concrete (Precast)], ... 13 more ...)
• bench_material_other (type: esriFieldTypeString, alias: Specify 'Other' Bench Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• channel_present (type: esriFieldTypeString, alias: Channel Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• manhole_bottom_condition (type: esriFieldTypeString, alias: Manhole Bottom Overall Condition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [d: Defective], [s: Sound], [x: Not Known])
• manhole_bottom_defects (type: esriFieldTypeString, alias: Specify Any Defects or Unknown Observations in the Manhole Bottom, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• infiltration_present (type: esriFieldTypeString, alias: Visible Infiltration Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• frame_cover_infiltration (type: esriFieldTypeString, alias: Frame and Cover Infiltration?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• frame_cover_inf_clock (type: esriFieldTypeString, alias: Clock Position (Outgoing pipe is 6 O'Clock), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• frame_cover_inf_type (type: esriFieldTypeString, alias: Type of Infiltration, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [stain: Stain], [weeper: Weeper], [dripper: Dripper], ... 2 more ...)
• wall_inf_present (type: esriFieldTypeString, alias: Wall Infiltration Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• wall_inf_clock_pos (type: esriFieldTypeString, alias: Clock Position (Outgoing pipe is 6 O'Clock), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• wall_inf_type (type: esriFieldTypeString, alias: Infiltration Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [stain: Stain], [weeper: Weeper], [dripper: Dripper], ... 2 more ...)
• mh_bottom_inf_present (type: esriFieldTypeString, alias: Manhole Bottom Infiltration Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• mh_bottom_inf_clock_pos (type: esriFieldTypeString, alias: Clock Position (Outgoing pipe is 6 O'Clock), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• mh_bottom_loc (type: esriFieldTypeString, alias: Manhole Bottom Infiltration Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [bench: Bench], [channel: Channel], [wall: Wall])
• pipe_conn_inf_present (type: esriFieldTypeString, alias: Pipe Connection Infiltration Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• pipe_conn_inf_clock_pos (type: esriFieldTypeString, alias: Clock Position (Outgoing pipe is 6 O'Clock), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inf_notes (type: esriFieldTypeString, alias: Infiltration Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• debris_present (type: esriFieldTypeString, alias: Debris Present?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• debris_location (type: esriFieldTypeString, alias: Debris Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [channel: Channel], [influent_pipe: Incoming Pipe Invert], [effluent_pipe: Outgoing Pipe Efvert], ... 2 more ...)
• debris_type (type: esriFieldTypeString, alias: Debris Type Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• debris_grease_yes_no (type: esriFieldTypeString, alias: Is Debris Grease?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• repair_rec (type: esriFieldTypeString, alias: Manhole Repair or Replacement Recommended?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [no: No], [repair: Repair], [replacement: Replacement])
• repair_rec_replacement (type: esriFieldTypeString, alias: Specify Repair(s) Required, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• overall_notes (type: esriFieldTypeString, alias: Notes (General Notes to Include Not Covered in Previous Sections), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• level_4_5_obs (type: esriFieldTypeString, alias: Level 4 or 5 Defect Observed In Structure?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• header_group (type: esriFieldTypeString, alias: HEADER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• measurements_group (type: esriFieldTypeString, alias: MANHOLE MACP MEASUREMENTS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• chamber_inverts (type: esriFieldTypeString, alias: Manhole Chamber Invert Measurements (Nearest Tenth of a Foot. For example, 8.5' =8' 6"), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• group_pipe_info (type: esriFieldTypeString, alias: PIPE INFORMATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• manhole_condition (type: esriFieldTypeString, alias: MANHOLE CONDITION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• frame_cover (type: esriFieldTypeString, alias: Frame and Cover, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• steps (type: esriFieldTypeString, alias: STEPS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• chimney (type: esriFieldTypeString, alias: CHIMNEY, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• wall (type: esriFieldTypeString, alias: CONE & WALL, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• manhole_bottom (type: esriFieldTypeString, alias: MANHOLE BOTTOM, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• infiltration (type: esriFieldTypeString, alias: INFILTRATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• group_frame_cover_inf (type: esriFieldTypeString, alias: FRAME AND COVER INFILTRATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• wall_infiltration (type: esriFieldTypeString, alias: WALL INFILTRATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• mh_bottom_inf (type: esriFieldTypeString, alias: MANHOLE BOTTOM INFILTRATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pipe_conn_inf (type: esriFieldTypeString, alias: PIPE CONNECTION INFILTRATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• debris (type: esriFieldTypeString, alias: DEBRIS, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• defects_info (type: esriFieldTypeString, alias: Defect(s) Observations, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

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

Relationships:

• LSSE_MHPS_Survey123_Form_influent_pipes (1) -- Related To: influent_pipes (1)
• LSSE_MHPS_Survey123_Form_effluent_pipe (2) -- Related To: effluent_pipe (2)
• LSSE_MHPS_Survey123_Form_exterior_photos (3) -- Related To: exterior_photos (3)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/29/2025 6:48:50 PM

Schema Last Edit Date: 8/29/2025 6:48:50 PM

Data Last Edit Date: 8/29/2025 6:48:50 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat