20230926 14242300 1.0 FALSE TIMS.WGIS_RETAINING_WALL_INVENTORY Server=DOTICSQLP31; Service=sde:sqlserver:DOTICSQLP31;ApplicationIntent=READWRITE;MultisubnetFailover=YES; Database=TIMS; User=TIMS; Version=dbo.DEFAULT ArcSDE Connection -9440305.360400 -8965900.103800 4639542.400800 5152970.951100 1 002 Projected GCS_WGS_1984 Linear Unit: Meter (1.000000) WGS_1984_Web_Mercator_Auxiliary_Sphere <ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/3.4.0'><WKT>PROJCS[&quot;WGS_1984_Web_Mercator_Auxiliary_Sphere&quot;,GEOGCS[&quot;GCS_WGS_1984&quot;,DATUM[&quot;D_WGS_1984&quot;,SPHEROID[&quot;WGS_1984&quot;,6378137.0,298.257223563]],PRIMEM[&quot;Greenwich&quot;,0.0],UNIT[&quot;Degree&quot;,0.0174532925199433]],PROJECTION[&quot;Mercator_Auxiliary_Sphere&quot;],PARAMETER[&quot;False_Easting&quot;,0.0],PARAMETER[&quot;False_Northing&quot;,0.0],PARAMETER[&quot;Central_Meridian&quot;,0.0],PARAMETER[&quot;Standard_Parallel_1&quot;,0.0],PARAMETER[&quot;Auxiliary_Sphere_Type&quot;,0.0],UNIT[&quot;Meter&quot;,1.0],AUTHORITY[&quot;EPSG&quot;,3857]]</WKT><XOrigin>-20037700</XOrigin><YOrigin>-30241100</YOrigin><XYScale>10000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>102100</WKID><LatestWKID>3857</LatestWKID></ProjectedCoordinateSystem> 20250604 12125500 20250604 12125500 FGDC 150000000 5000 dataset 20260118 Enterprise Geodatabase Feature Class Microsoft Windows 10 Version 10.0 (Build 26100) ; Esri ArcGIS 13.4.0.55405 Retaining Wall Inventory Retaining Wall Inventory ODOT's inventory of retaining walls. <div style='text-align:Left;'><div><div><p><span><span>ODOT's inventory of retaining walls.</span></span></p></div></div></div> ODOT Office of Geotechnical Engineering 1 -84.803706 -80.542051 41.946515 38.424318 Asset Inventory Collector Retaining Wall Geotechnical Engineering https://tims.dot.state.oh.us/tims/api/glossary/dataset/5090d6d7d36c42a78dbc88ec1dd9f278 ODOT Office of Geotechnical Engineering https://www.transportation.ohio.gov/working/engineering/geotechnical 5149 EPSG 6.18.3(9.3.1.2) WGIS_RETAINING_WALL_INVENTORY Feature Class 5149 NLFID NLFID Unique Identifier of the route asset is located on Text CRS CRS County, Route and County Milepost asset is located on Text ODOT_DISTRICT ODOT District ODOT District Number Text COUNTY County Full County Name Text COUNTY_CD County CD Three Character County Code Text ROUTE_TYPE Route Type IR, US, SR, CR, TR, MR, etc Text ROUTE_NBR Route Number 5 Digit Route Number Text ROUTE_SUFFIX Route Suffix A, B, C, D, I, F, T etc. Text CTL_BEGIN_NBR CTL Begin Number County True Log Begin Number Number CTL_END_NBR CTL End Number County True Log End Number Number STL_BEGIN_NBR STL Begin Number State True Log Begin Number Number STL_END_NBR STL End Number State True Log End Number Number LATITUDE_DD_BEGIN Latitude DD Begin Latitude of wall start point Number LATITUDE_DD_END Latitude DD End Latitude of wall end point Number LONGITUDE_DD_BEGIN Longitude DD Begin Longitude of wall start point Number LONGITUDE_DD_END Longitude DD End Longitude of wall end point Number PERP_DATE Perp Date Date of LRS asset is located against Date STATUS Status Status of Wall (A = active) Text INSTALLATION_DATE Installation Date Date the wall was installed Date LET_PLANS_URL Let Plans URL Plan Sheets Text PID PID Project ID of the project the wall was built Number MAINTAIN_RESPONSIBLE Maintenance Responsibility Agency responsible for maintenance of the Wall Text RETAINING_WALL_FILENUM Retaining Wall File Number Unique Identifier of Retaining Wall Text SECTION_ID Section ID Unique Identifier of section that makes up a retaining wall Text ABOVE_BELOW_ROAD Above or Below Road Is the retaining wall above or below the roadway? Text LOCATION_DESCRIPTION Location Description Text Description of the Wall Location (for example: Middle wall in the 3 tiered retaining wall system) Text ACCESS_CONSTRAINTS Access Constraints Description of physical constraints limiting access to the retaining wall (For example: Traffic, Steep slope) Text ADJACENT_FEATURE_ABOVE Adjacent Feature Above Text field to describe what is above the retaining wall (For example: Road, Creek, Sidewalk) Text ADJACENT_FEATURE_BELOW Adjacent Feature Below Text field to describe what is below the retaining wall (For example: Road, Creek, Sidewalk) Text PROJECT_NAME Project Name Name of Original Project Construction Text STATE_PROJECT_NUMBER State Project Number State Project Number Text WALL_NAME Wall Name If Present, the name of the wall as it is referred to in plans Text WALL_TYPE Wall Type Construction Method for the Wall Text WALL_SUPPLIER Wall Supplier Who supplied the wall Text WALL_FUNCTION Wall Function Purpose and use of the Wall Text WALL_FACE_MATERIAL Wall Face Material Material that is used as the wall facing Text MAX_EXPOSED_WALL_HT Max Exposed Wall Height (ft) Maximum height of wall exposed above ground. Number WALL_SECTION_LENGTH Wall Section Length (ft) Length of wall measured in feet. Number WALL_FACE_SLOPE Wall Face Slope Is the exposed face vertical or sloped? Text UPSLOPE_ANGLE Upslope Angle Is the backfill behind the wall flat or sloped? Text DOWNSLOPE_ANGLE Downslope Angle Is the backfill in front of the wall flat or sloped? Text FOUNDATION_TYPE Foundation Type Type of foundation Text FOUNDATION_DEPTH Foundation Depth Depth of foundation Number WALL_EMBEDMENT_DEPTH Wall Embedment Depth (ft) Depth of Subsurface Wall Features Number MAX_TOTAL_WALL_HEIGHT Max Total Wall Height (ft) Exposed wall weight + wall embedment depth. Number WALL_HEIGHT_ABOVE_SOIL Wall Height Above Retained Soil (ft) The stick up height of the wall above the retained backfill. Number BRIDGE_CULVERT_ASSOC Bridge/Culvert Association Field to determine if wall is associated with a bridge or culvert Text BRIDGE_CULVERT_REF Bridge/Culvert Reference Text field to input CFN and/or SFN Text WALL_DRAINAGE Wall Drainage Indicator if wall drainage exists Text DRAINAGE_DESCRIPTION Drainage Description Description if WALL_DRAINAGE is 'Y' Text INVENTORY_COMMENTS Inventory Comments Text field for general comments about Retaining Wall Text NEXT_INSPECTION_DUE Next Inspection Due This field is used to display when the next inspection is due DEFORMATION_PRESENT Deformation Present Is the wall bulging, leaning, etc? Text DAMAGE_PRESENT Damage Present Does the wall have significant visible damage? Text DRAINAGE_OUTLETS_OPER Drainage Outlets Operating Are there drainage outlets visible? If so, can water be seen coming from them? Text DRAINAGE_CHANNELS_OPER Drainage Channels Operating Are there drainage channels visible? If so, are they capturing water? Text OVERALL_WALL_CONDITION Overall Wall Condition Condition of the wall Text CONDITION_DESCRIPTION Condition Description Comments about the wall Text REC_ENGINEER_INSP Recommend Engineer Inspection Indicator if inspector believes the wall needs inspected by an engineer Text MAINT_REPAIR_MOD Maintenance/Repair/Modification Comment Inspector records comments about any type of changes made to the wall Text INSPECTOR Inspector The name or initials of the person who inspected the wall Text INSPECTION_DATE Inspection Date Date Wall is inspected Date NEEDS_MAINTENANCE Needs Maintenance Indicator if inspector believes the wall needs maintenance Text JURISDICTION Jurisdiction One-letter code indicating the primary legal authority of the speed zone- one component of the NLFID text DIVIDED_HWY Divided Highway Indicates whether a roadway section is part of a divided highway text BASE_TYPE Base Type Code indicating type of base material on roadway segment associated with the underdrain, please reference Roadway Infromation manual text FUNCTIONAL_CLASS Functional Classification The organization of roadways into a hierarchy based on the character of service provided. Typical classifications include arterial, local, and collector roadways. text HPMS_SAMPLE_ID HPMS Sample ID System used by FHWA to collect roadway data from each state to facilitate consistent reporting on the condition and performance of the nation's highways text LANES Lanes Number of lanes in both directions carrying through traffic long integer MAINTENANCE_AUTHORITY Maintenance Authority Entity who maintains roadway section; For code descriptions, please refer to the Roadway Information Manual text NHS NHS Indicates if the School Zone is included in the National Highway System, a federally designated network of roads, most of which already exist, that are eligible for priority federal aid funding; includes the Interstate system and major State highways text PRIORITY_SYSTEM Priority System Code Priority System code associated with the section of the roadway text SURFACE_TYPE Surface Type Type of road surface text SURFACE_WIDTH Surface Width The surface width on the right side of the roadway traveling in the cardinal direction. This number indicates only the width of the driving lanes right of the centerline long integer ESAL_TOTAL ESAL Total Measure of total damage to road in speed zone. ESAL stands for Equivalend Single Axel Load which is a concept developed from data collected at the American Association of State Highway Officials (AASHO) Road Test to establish a damage relationship for com long integer AADT_PASSENGER AADT Passenger Average Annual Daily Passenger Vehicle Traffic (Does not include trucks) long integer AADT_TOTAL AADT Total Average number of vehicles that pass over point on a daily basis (Includes cars and trucks) long integer AADT_BC_TRUCK AADT BC Truck Average Annual Truck Traffic (Includes all trucks single units and combination units) long integer PAVE_TYPE Pavement Type Type of Pavement text PCR_YEAR PCR Year Year in which conditions of pavements on road in speed zone were last collected and processed by the pavement engineering group long integer ROADWAY_WIDTH_NBR Roadway Width The entire width of the roadway, including all driving lanes and shoulders. This number could include some gravel shoulders. Does not include medians short interger Image_Attach_Inv Image Attachment - Inventory Link to images attached to inspection record Text Image_Attach_Insp Image Attachment - Inspection Link to images attached to inspection record Text iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO xAAADsQBlSsOGwAAAqpJREFUeJzt1DENADAMwLAd5U+5o7BvimQjyJXZ3T0AAfM7AOCVYQEZhgVk GBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFY QIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZ hgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgW kGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECG YQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYF ZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBh WECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEB GYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQY FpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhA hmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmG BWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQ YVhAhmEBGYYFnIoLreIHHblfYqUAAAAASUVORK5CYII=