civilpy.state.ohio package

Subpackages

civilpy.state.ohio.DOT package

Submodules

civilpy.state.ohio.db_tables module

civilpy.state.ohio.db_tables.setup_django_environment(project_root)[source]: Configures the Django environment by adding the project path to sys.path and detecting the settings module.

civilpy.state.ohio.db_tables.validate_bridge_data(project_path, target_district=None)[source]: Main function to run validation.

civilpy.state.ohio.search_tools module

This program is free software: you can redistribute it and/or modify it under the terms of the GNU Affero General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more details.

You should have received a copy of the GNU Affero General Public License along with this program. If not, see <http://www.gnu.org/licenses/>.

class civilpy.state.ohio.search_tools.D6BridgeLookup(sfn, column_labels=['Bridge Status Code', 'Bridge Status Description calc', 'Structure File Number', 'District Number', 'Deck Area', 'Overall Structure Length', 'Over 20 Ft (Fedl Brdg) (Y/N/Null) calc', 'Sufficiency Rating', 'Sufficiency Rating Converted calc', 'SD/FO', 'SD/FO calc', 'Functional Class Code', 'Functional Class Old Name calc', 'Functional Class Old Group calc', 'Functional Class FHWA Code calc', 'Functional Class New Code calc', 'Funct Class New Name calc', 'Maintenance Responsibility Code', 'Maintenance Responsibility Description calc', 'Maintenance Responsibility plus Null calc', 'Type Service On Bridge Code', 'Type of Service On Bridge Description calc', 'Type Service Under Bridge Code', 'County Code', 'Highway System Code', 'Invent Hwy Sys Name calc', 'Invent Hwy Sys Description calc', 'Route', 'Inventory Route', 'Route On Bridge Code', 'Route On Bridge Description calc', 'Route Under Bridge Code', 'Route Under Bridge Description calc', 'Facility Carried By Structure', 'Feature Intersected', 'Latitude', 'Longitude', 'NHS Code', 'NHS (Y/N) calc', 'NHS Description calc', 'Year Rebuilt Calc', 'Load Rating Year', 'Main Span Type Code', 'Main Structure Type', 'Load Inventory Rating', 'Inventory County', 'FIPS Number', 'BTRS Link Number', 'BTRS Linked (Y/N) calc', 'Analyzed By', 'Approach Alignment Code', 'Approach Guardrail Code', 'Approach Pavement Grade Code', 'Approach Pavement Material Code', 'Approach Roadway Width', 'Approach Slab ', 'Approach Slab Length', 'Approach Span Description Code', 'Approach Span Material Code', 'Approach Span Type Code', 'Approach Spans', 'Approach Structure Type', 'BARS Code', 'Bearing Device1 Code', 'Bearing Device2 Code', 'Bridge Roadway Width Cb Cb', 'Bypass Length', 'Calculated Deck Geometry', 'Calculated Structural Evaluation', 'Calculated Underclearance', 'Channel Protection Type Code', 'Min Horizontal Clearance On Bridge Cardinal', 'Min Horizontal Clearance On Bridge Non-Cardinal', 'Min Horizontal Clearance Under Cardinal', 'Min Horizontal Clearance Under Non-Cardinal', 'Min Lateral Clearance Cardinal Left', 'Min Lateral Clearance Cardinal Right', 'Min Lateral Clearance Non-Cardinal Left', 'Min Lateral Clearance Non-Cardinal Right', 'Min Lateral Clearance Under Cardinal Left', 'Min Lateral Clearance Under Cardinal Right', 'Min Lateral Clearance Under Non-Cardinal Left', 'Min Lateral Clearance Under Non-Cardinal Right', 'Min Vertical Clearance Bridge Cardinal', 'Min Vertical Clearance Bridge Non-Cardinal', 'Min Vertical Clearance Under Bridge Cardinal', 'Min Vertical Clearance Under Bridge Non-Cardinal', 'Clearance Practical Max Vertical On Bridge', 'Clearance Practical Max Vertical Under Bridge', 'Combined', 'Composite Structure Code', 'Culvert Fill Depth', 'Culvert Headwalls/Endwalls Type Code', 'Culvert Length', 'Culvert Sufficiency Rating Default', 'Culvert Type Code', 'Curb/Sidewalk Material Type Left', 'Curb/Sidewalk Material Type Right', 'Curb/Sidewalk Type Left', 'Curb/Sidewalk Type Right', 'Deck Concrete Type Code', 'Deck Drainage Type Code', 'Deck Protection External Code', 'Deck Protection Internal Code', 'Deck Type Code', 'Deck Width Out/Out', 'Design Load Code', 'Directional Suffix Code', 'Expansion Joint Retrofit1 Code', 'Expansion Joint Retrofit2 Code', 'Expansion Joint Retrofit3 Code', 'Expansion Joint Type1 Code', 'Expansion Joint Type2 Code', 'Expansion Joint Type3 Code', 'Expansion Joint With Trough Retrofit1', 'Expansion Joint With Trough Retrofit2', 'Expansion Joint With Trough Retrofit3', 'Future ADT', 'Future ADT Year', 'Haunched Girder', 'Haunched Girder Depth', 'Highway Designation Code', 'Hinge Code', 'Horizontal Curve Radius', 'Lanes On Number', 'Lanes Under Number', 'Macro Corridor', 'Main Member Depth', 'Main Member Type Code', 'Main Span Description Code', 'Main Span Material Code', 'Main Spans Number', 'Major Rehab Date', 'Maximum Span Length', 'Median Code', 'Median Type1 Code', 'Median Type2 Code', 'Median Type3 Code', 'Method Of Analysis Code', 'Moment Plates Code', 'MPO Code', 'Min Vertical Clearance Lift Bridge', 'Navigable Stream', 'Navigable Stream Horizontal Clearance', 'Navigable Stream Vertical Clearance', 'Ohio Percent Of Legal Load', 'On/Under', 'Operating Rating HS', 'Parallel Structure Code', 'Paint Condition Rating Date', 'Paint Supplier', 'Paint Surface Area', 'Preferred Route', 'Railing Type Code', 'Ramp Lateral Under Clearance Cardinal Left', 'Ramp Lateral Under Clearance Cardinal Right', 'Ramp Lateral Under Clearance Non-Cardinal Left', 'Ramp Lateral Under Clearance Non-Cardinal Right', 'Ramp Roadway Width Cardinal', 'Ramp Roadway Width Non-Cardinal', 'Ramp Vertical Under Clearance Cardinal', 'Ramp Vertical Under Clearance Non-Cardinal', 'Record Add Date', 'Record Update Date', 'Remarks', 'Retire Reason Code', 'SFN Control Authority', 'Sidewalk Width Left', 'Sidewalk Width Right', 'Skew', 'Slope Protection Type Code', 'Software Of Rating Analysis', 'Inventory Special Designation', 'Straight Line Kilometers', 'Straight Line Mileage', 'Structure Location', 'Toll Road', 'Total Spans', 'Traffic Direction Code', 'Water Direction Code', 'Waterway Adequacy Code', 'Wearing Surface Date', 'Wearing Surface Thickness', 'Wearing Surface Type Code', 'Total', 'SubClass', 'Subclass1', 'SubClass2', 'Cty', '9', '8', '7', '6', 'A', '5', '4', '3', '2', '1', '0', 'N', 'Maintained', 'Inventoried', 'Date Built', 'Contractor Name', 'Drainage Area', 'Framing Type', 'Historical Bridge Type Code', 'Historical Builder Code', 'Historical Significance Code', 'Longitudinal Member Type', 'Microfilm Number', 'Original Project Number', 'Structural Steel Protection Code', 'Railing Structural Steel Type', 'Standard Drawing Number', 'Stream Velocity', 'Structural Steel Fabricator', 'Structural Steel Paint Type Code', 'Structural Steel Pay Weight', 'Predominant Structural Steel Type', 'Boat Inspection', 'Critical Structure', 'Dive Inspection', 'Dive Inspection Date', 'Dive Inspection Frequency', 'Fracture Critical Inspection', 'Fracture Critical Inspection Date', 'Fracture Critical Inspection Frequency', 'Inspection Frequency', 'Inspection Responsibility Code', 'Probe Inspection', 'Probe Inspection Frequency', 'Scour Critical Code', 'Snooper Inspection', 'Special Inspection', 'Special Inspection Date', 'Special Inspection Frequency', 'Major Bridge Indicator (Y/N)', 'NBIS Length (Y/N)', 'Aperture Card Original', 'Aperture Fabrication', 'Aperture Repairs', 'Bridge Dedicated Name', 'Cable Stayed', 'Catwalks', 'Designated National Network', 'Fencing', 'Fencing Height', 'Flared', 'GASB 34', 'Glare Screen', 'Lighting', 'Noise Barrier', 'Other Features', 'Post Tensioned', 'Railroad Code', 'Scenic Waterway', 'Seismic Susceptibility Code', 'Signs Attached On', 'Signs Attached Under', 'Splash Guard', 'Strahnet Highway Designation', 'Temporary Barrier', 'Temporary Debris Netting', 'Temporary Shored', 'Temporary Structure', 'Temporary Subdecking', 'Utility - Electric', 'Utility - Gas', 'Utility - Other', 'Utility - Sewer', 'Utility - Telephone', 'Utility - TV Cable', 'Utility - Water', 'Abutment Forward Material Code', 'Abutment Forward Type Code', 'Abutment Rear Material Code', 'Abutment Rear Type Code', 'Dynamic Load Test Abutment Forward', 'Dynamic Load Test Abutment Rear', 'Dynamic Load Test Pier Predominate', 'Dynamic Load Test Pier Type1', 'Dynamic Load Test Pier Type2', 'Foundation Abutment Forward Code', 'Foundation Abutment Rear Code', 'Foundation Length Abutment', 'Foundation Length Pier', 'Foundation Pier Predominate Code', 'Foundation Pier Type1 Code', 'Foundation Pier Type2 Code', 'Pier Predominant ', 'Pier Predominate Material Code', 'Pier Predominate Type Code', 'Pier Type1 Number', 'Pier Type1 Material Code', 'Pier Type1 Type Code', 'Pier Type2 Number', 'Pier Type2 Material Code', 'Pier Type2 Type Code', 'Pile Log', 'Static Load Test Abutment Forward', 'Static Load Test Abutment Rear', 'Static Load Test Pier Predominate', 'Static Load Test Pier Type1', 'Static Load Test Pier Type2'], data_path='G:\\ref\\New folder\\Bridges.tsv')[source]

Bases: TimsBridge

Bridge record lookup for ODOT District 6, backed by a local TSV export.

Extends TimsBridge with District 6-specific plan set and TIFF file retrieval. Requires access to the District 6 file server paths (G:\ref\...).

Parameters:

sfn (str) – The ODOT Structure File Number (SFN) to look up.
column_labels (list) – Column names to include in tabular output. Defaults to default_bridge_labels.
data_path (str) – Path to the local Bridges.tsv file exported from TIMS. Defaults to the D6 server path.

get_d6_plan_sets(district_df_path='G:\\ref\\New folder\\PLANINDX.TXT')[source]

Using the “CTY-RT-SEC” from a SFN, this function finds the various plan sets potentially associated with that structure, it rounds the ‘section’ value up and down to be inclusive, effectively giving every plan segment for that 1 mile segment.

Parameters:: district_df_path – set to default but overrideable to allow development on various devices without network access
Returns:: Dumps .pdf files into a folder on the local machine at W:CivilPy_Outputpulled_plans

get_summary()[source]

Build and print a one-line summary for this bridge and return the CTY-RT-SEC key.

Prints the SFN, route/feature description, and GPS coordinates to stdout.

Returns:: The "CTY-RT-SEC" identifier string used for plan set lookups, formatted as "{county_code}-{route_num}-{section_num}".
Return type:: str

get_tiff_files(path)[source]

This is a helper function to the self.get_d6_plansets() function, giving it a path to a folder returns a list of all files in that folder

Returns:: list of tiff file paths

tiff_to_pdf(tiff_path: str) → str[source]: Helper function to be used by the bridge object to convert tiff files to pdf :param tiff_path: :return:

civilpy.state.ohio.search_tools.get_ohio_data_from_open_street_maps()[source]

Module contents

This program is free software: you can redistribute it and/or modify it under the terms of the GNU Affero General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more details.

You should have received a copy of the GNU Affero General Public License along with this program. If not, see <http://www.gnu.org/licenses/>.