Data Dictionary

Column Type Label Description
OBJECTID text
STR_ID text

Structure Identification

STR_TYPE text

Structure Type (Major Type)

STR_USE text

Structure Use (Sub Type)

LOC_DESC text

Structure Location Description

YEAR_BUILT text

Structure Built Year

CONDITION text

Condition Based on Validated Inspection

LAST_INSP text

Last Inspection Year

VALI_YEAR text

Inspection Validation Year

NEXT_INSP text

Next Inspection Year

CON_AGENCY text

Contact Agency

CON_METHOD text

Contact Method

CATEGORY text

Data Category

WARD_NO int4

Ward Number

WARD_NAME text

Ward Name

PHOTO_THUM text

Structure Thumbnail Photo

PHOTO_MAIN text

Structure Photo

WESS_DIST int4

Former W.E.S. Service District Number

VERT_CLEAR text

Vertical Clearance of the Bridge

geometry text

Additional Information

Field Value
Data last updated September 22, 2022
Metadata last updated June 1, 2025
Created September 22, 2022
Format GeoJSON
License License not specified
Datastore activeTrue
Datastore cache{'CSV': {'4326': '5b2c65a5-d7f8-431c-b81b-28a833a5b221', '2952': 'aa9bc161-4ac9-48cd-8738-caab2ce44649'}, 'SHP': {'4326': 'ff930b8e-e975-4a60-9de5-6aed376de50a', '2952': '934bcb44-d9bc-4621-8c93-96da946f3467'}, 'GPKG': {'4326': '4013654a-9e10-418b-964d-f699e3f9dacf', '2952': '76ee78eb-6d44-4f9d-9cbb-46123f381ce0'}, 'GEOJSON': {'4326': '9a087353-e2f7-4e44-92a4-56f2208aec5f'}}
Datastore cache last update2 months ago
Extract jobAirflow - files_to_datastore.py - bridge-structure
Has viewsTrue
Id405d75e3-3fb8-4957-8937-3dc9936b17b9
Is previewTrue
Package id4e10dbb5-2d67-4bc4-92d3-af7749707748
Package name or idbridge-structure
Position0
Stateactive
Url typedatastore
Extract Job Airflow - files_to_datastore.py - bridge-structure
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. SHP
  3. GPKG
  4. GEOJSON
Datastore Cache Last Updated
Datastore resource's ID