Name: crossing_inspections

Display Field: OBJECTID

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
• inspect_dt (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• activity (type: esriFieldTypeString, alias: Activity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fp_id_inspect (type: esriFieldTypeString, alias: FPA Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• GUID (type: esriFieldTypeGUID, alias: GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• level_a_assess (type: esriFieldTypeString, alias: Level A, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• levawsdrop (type: esriFieldTypeString, alias: Surface Water Drop, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• levaubstrate (type: esriFieldTypeString, alias: Continuous Substrate, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• levasc (type: esriFieldTypeString, alias: Countersunk, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• levacbw (type: esriFieldTypeString, alias: Channel Bed Width, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• levasitepec (type: esriFieldTypeString, alias: Site Specific Conditions, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• levaaddl (type: esriFieldTypeString, alias: Other Info, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• conduct_fphp_comply (type: esriFieldTypeString, alias: FPHP Compliance, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• fphpspecs (type: esriFieldTypeString, alias: Meet FPHP Specs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• fphpunmetspecs (type: esriFieldTypeString, alias: Unmet FPHP Specs, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [sizeFPHP: Incorrect size culvert (add specifics in "relevant information" below)], [subsrateFPHP: Substrate does not meet plans], [elevFPHP: Elevations do not meet plans], ... 6 more ...)
• fphpunmetspecs_other (type: esriFieldTypeString, alias: Other Unmet FPHP Spects, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• fish_pass_inspect (type: esriFieldTypeString, alias: Crossing Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [fb: Fish Barrier], [fp: Fish Passable], [nf: No Fish], ... 1 more ...)
• resource_concern (type: esriFieldTypeString, alias: Resource Concerns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• f_culvert_concern (type: esriFieldTypeString, alias: Fish Culvert Concerns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [not_level_a: Culvert does not meet DNR Level A Fish Passage Assessment], [sediment: Sediment delivery concerns], [damaged_culvert: Damaged Culvert], ... 15 more ...)
• f_bridge_concern (type: esriFieldTypeString, alias: Fish Bridge Concerns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [fish_pass_concerns: Fish passage concerns (add details in Other section)], [sediment: Sediment Delivery], [sediment_br_deck: Sediment delivery from bridge deck], ... 5 more ...)
• f_removal_concern (type: esriFieldTypeString, alias: Fish Removal Concerns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [fish_pass_removal: Fish passage concerns (add details in Other section)], [sediment: Sediment delivery concerns], [approaches_removal: Approaches not blocked], ... 4 more ...)
• f_temp_crossing_concern (type: esriFieldTypeString, alias: Fish Temp Crossing Concerns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [approach_block: Approaches not blocked], [erosion_bmps: Erosion control BMPs not in place], [timing_window: Temp culvert not removed within timing window], ... 2 more ...)
• f_ford_concern (type: esriFieldTypeString, alias: Fish Ford Concerns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [fish_pass_ford: Fish passage concerns (add details in Other section)], [sediment: Sediment delivery concerns], [ditch: Approach ditch-outs and water bars not functioning], ... 5 more ...)
• nf_concern (type: esriFieldTypeString, alias: Non Typed Concerns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [sediment: Sediment delivery concerns], [ditch_relief: Ditch relief needed], [undersized_culvert: Undersized culvert], ... 9 more ...)
• untype_unknown_concern (type: esriFieldTypeString, alias: Unknown Concerns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [sediment: Sediment delivery concerns], [ditch_relief: Ditch relief needed], [undersized_culvert: Undersized culvert], ... 8 more ...)
• other_concern (type: esriFieldTypeString, alias: Other Concerns, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• addl_info (type: esriFieldTypeString, alias: Additional Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• follow_up (type: esriFieldTypeString, alias: Follow Up Needed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• other_follow_up (type: esriFieldTypeString, alias: Other Follow Up, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• collet_photo_inspect (type: esriFieldTypeString, alias: Collect Photos, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• descimage1_inspect (type: esriFieldTypeString, alias: Photo 1 Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• descimage2_inspect (type: esriFieldTypeString, alias: Photo 2 Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• descimage3_inspect (type: esriFieldTypeString, alias: Photo 3 Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sflo_inspect (type: esriFieldTypeString, alias: SFLO, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• landowner_nm_inspect (type: esriFieldTypeString, alias: Landowner Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• structure_ty_inspect (type: esriFieldTypeString, alias: Structure Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• inspect_water_type (type: esriFieldTypeString, alias: Water Type Insepction, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• other_edits (type: esriFieldTypeString, alias: Describe Other Edits, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• comment_cross (type: esriFieldTypeString, alias: Comment, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• enter_struct_inspect (type: esriFieldTypeString, alias: Enter Stuture Info, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• culv_width_insp (type: esriFieldTypeSmallInteger, alias: Culvert Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• culv_hgt_insp (type: esriFieldTypeSmallInteger, alias: Culvert Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• culv_length_insp (type: esriFieldTypeSmallInteger, alias: Culvert Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• culv_gradient_insp (type: esriFieldTypeSmallInteger, alias: Culvert Gradient, SQL Type: sqlTypeOther, nullable: true, editable: true)
• design_ty_insp (type: esriFieldTypeString, alias: Design Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [stream_sim: Stream simulation], [no_slope: No slope], [other: Other])
• bridge_length_insp (type: esriFieldTypeSmallInteger, alias: Bridge Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• chan_gradient_insp (type: esriFieldTypeSmallInteger, alias: Channel Gradient, SQL Type: sqlTypeOther, nullable: true, editable: true)
• chan_bed_width_insp (type: esriFieldTypeInteger, alias: Channel Bed Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• other_design_ty_insp (type: esriFieldTypeString, alias: Other Design Type, SQL Type: sqlTypeOther, length: 256, 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)
• change_owner (type: esriFieldTypeString, alias: change owner, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• new_owner (type: esriFieldTypeString, alias: New Owner, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• change_sflo (type: esriFieldTypeString, alias: change sflo, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• new_sflo (type: esriFieldTypeString, alias: SFLO, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• change_water_ty (type: esriFieldTypeString, alias: change water ty, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• new_water_ty (type: esriFieldTypeString, alias: New Water Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• water_ty_2_use (type: esriFieldTypeString, alias: water type 2 use, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• change_structure_ty (type: esriFieldTypeString, alias: change structure ty, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• structure_ty_2_use (type: esriFieldTypeString, alias: structure ty 2 use, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• struct_change_note (type: esriFieldTypeString, alias: Enter/Change Structure Info, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• new_structure_ty (type: esriFieldTypeString, alias: New Structure Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• revisit_dt (type: esriFieldTypeDate, alias: Revisit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• follow_up_type (type: esriFieldTypeString, alias: Follow Up Type, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [revisit: Revist], [enforce: Enforcement Action], [for_lo: Forester to contact landowner], ... 8 more ...)
• water_ty_lower (type: esriFieldTypeString, alias: Lower Case WT, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• structure_lower (type: esriFieldTypeString, alias: Lower Case ST, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• dnr_cross_id_inspect (type: esriFieldTypeString, alias: dnr_cross_id_inspect, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• activity_complete (type: esriFieldTypeString, alias: Activity Complete, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No], [na: N/A])
• level_a_note (type: esriFieldTypeString, alias: level_a_note, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• levasitepec_txt (type: esriFieldTypeString, alias: levasitepec_txt, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• region (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [NORTHEAST: Northeast], [NORTHWEST: Northwest], [OLYMPIC: Olympic], ... 3 more ...)
• pass_fp_id (type: esriFieldTypeString, alias: passed fo id, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• report_gen (type: esriFieldTypeString, alias: Generate Report, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• addl_inform (type: esriFieldTypeString, alias: Additional Information, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• name (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Name: crossing_inspections
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• crossings (0) -- Related To: Inspected Crossing (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/1/2026 2:29:23 AM

Schema Last Edit Date: 10/1/2026 2:29:23 AM

Data Last Edit Date: 10/1/2026 4:06:40 AM

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