20230926 16265400 1.0 FALSE TIMS.WGIS_SIGN_SUPPORT_INVENTORY Server=DOTICSQLP31; Service=sde:sqlserver:DOTICSQLP31;ApplicationIntent=READWRITE;MultisubnetFailover=YES; Database=TIMS; User=TIMS; Version=dbo.DEFAULT ArcSDE Connection -9442114.521200 -8963327.551800 4637310.143800 5155188.568400 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> UpdateSchema "CIMDATA=<CIMStandardDataConnection xsi:type='typens:CIMStandardDataConnection' 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.2.0'><WorkspaceConnectionString>ENCRYPTED_PASSWORD_UTF8=00022e682b696d5451497961445563494e6b664f7a4b2f4958484c767432362b6f53495a7a41524e63473832476c513d2a00;ENCRYPTED_PASSWORD=00022e68757869336d79767634426e4f736e3478424b7669354757574c50457a70414d35496965695958572b33706f3d2a00;SERVER=DOTICSQLT31;INSTANCE="sde:sqlserver:DOTICSQLT31;APPLICATIONINTENT=READWRITE;MULTISUBNETFAILOVER=YES";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="DOTICSQLT31;APPLICATIONINTENT=READWRITE;MULTISUBNETFAILOVER=YES";DATABASE=TIMS;USER=TIMS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>TIMS.WGIS_SIGN_SUPPORT_INVENTORY</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><EnableEditorTracking><creator_field>created_user</creator_field><creation_date_field>created_date</creation_date_field><last_editor_field>last_edited_user</last_editor_field><last_edit_date_field>last_edited_date</last_edit_date_field><add_fields>TRUE</add_fields><record_dates_in>UTC</record_dates_in></EnableEditorTracking></workflow></operationSequence> 20250610 07355600 20250610 7495400 FGDC 150000000 5000 dataset 20250610 Enterprise Geodatabase Feature Class Microsoft Windows 10 Version 10.0 (Build 26100) ; Esri ArcGIS 13.4.0.55405 Sign Support Inventory Sign Support Inventory <div style='text-align:Left;'><div><div><p><span><span>ODOT's inventory of sign supports.</span></span></p></div></div></div> ODOT Office of Roadway Engineering Asset Collector Office of Roadway Engineering Signs Support Inventory 1 -84.819958 -80.518941 41.961330 38.408607 https://tims.dot.state.oh.us/tims/api/glossary/dataset/9ea9844ce73c4d2dbf4948b29f73c470 ODOT Office of Roadway Engineering https://www.transportation.ohio.gov/working/engineering/roadway/roadway 281949 EPSG 6.18.3(9.3.1.2) TIMS.WGIS_SIGN_SUPPORT_INVENTORY Feature Class 281949 NLFID NLFID Calculated as described in NLFID Description Document. text CRS CRS Concatenate Conty_CD+Route_NBR+CTL_Begin_NBR (ALL-30-10.4) text ODOT_DISTRICT ODOT District ODOT District Number long integer 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 STREET_NAME Street Name Street name. Ex: E Main St text CTL_BEGIN_NBR End Frame/Pole Handhole Covers Missing County True Log Begin Number double STL_BEGIN_NBR STL Begin Number State True Log Begin Number double LATITUDE_DD_BEGIN Latitude DD Begin Latitude of Support double LONGITUDE_DD_BEGIN Longitude DD Begin Longitude of Support - value must be negative double PERP_DATE Perp Date Date of current LRS date STATUS Status Status of Support - Proposed, Active, Inactive, Retired text INSTALLATION_DATE Latitude DD Begin When the sign was installed on the support date PID Route Designation PID of support long integer END_CONSTRUCTION_DATE End Contruction Date End construction date of PID related to Support date LET_PLANS_URL Let Plans URL URL to project plans for PID related to support text MAINTAIN_RESPONSIBLE Maintain Responsible Maintenance responsibility code of support text INTERSECTION_ID Intersection ID ID of intersection related to sign text CROSS_ROUTE_LEG_ID Cross Route Leg ID Cross Route ID related to the intersection where the sign is located text SUPPORT_FILE_NUMBER Support File Number Unique Identifier of Support text OLD_SUPPORT_ID Old Support ID Unique Identifier of support in legacy system text SUPPORT_OWNER Support Owner Owner of the support text LOCATION_DESCRIPTION Location Description Description of the location of the sign text PROJECT_NAME Project Name Project name for sign support text PROJECT_NUMBER Project Number project number of support text ROUTE_DESIGNATION Route Designation Type of route support is on. Used to help identify NLFID. text SUPPORT_CATEGORY Support Category Category of Sign Support text SUPPORT_STYLE Support Style Generic Style of support text SUPPORT_TYPE Support Type Type of support text DESIGN_NUMBER Design Number Design number according to SCD drawing text SUPPORT_SIZE Support Size Ground Mounted Signs text NUM_OF_SUPPORTS Number of Supports Number of supports that touch the ground text NUM_OF_SIGNS Number of Signs Number of signs that the support has text BRIDGE_MOUNTED Bridge Mounted Yes/No if support in mounted to/on a bridge text MEDIAN_WALL_PLATES Median Wall Plates Yes/No if support has a median wall plate text BREAKAWAY_MECHANISM Breakaway Mechanism Yes/No if support has a breakaway mechanism text FLANGE_TYPE Flange Type Flange type of support text REFLECTOR_STRIP Reflector Strip Yes/No if support has a reflective strip text OVERHEAD_SPAN_LENGTH Overhead Span Length (ft) Length of the Overhead span of support double ATTACHMENTS Attatchments Attatchments text ATTACHMENT_COMMENTS Attatchment Comments Attachments Comments text PAINTED Painted Painted Status text SIGN_SUPPORT_REPLACE Sign Support Replace Sign Support replacement text REPLACEMENT_DATE Replacement Date Date of Replacement date REPLACEMENT_PID Replacement PID Replacement PID long integer ACCESS_CONTROL Access Control The degree of access control for a given section of the road text PATH_WEB_VIEWER Path Web Viewer Link to the Path Web Viewer text MAINTAIN_RECOMMEND Maintainence Recommended Maintenance Recommended text INSPECTION_DUE Inspection Due (Years) Date the next inspection is due text SUPPORT_INV_COMMENTS Support Inventory Comments Free text comment field about the inventory text FOUNDATION_CRACKS Foundation Cracks Cracks in Concrete Foundation text FOUND_SPALLING Foundation Spalling Spalling in Concrete foundation text FOUND_SOIL_EROSION Foundation Soil Erosion Erosion in soil foundation text FOUND_COVERED Foundation Covered Foundation buried or covered text FOUND_OTHER Foundation Other Other issues with foundation text FOUND_COMMENTS Foundation Comments Free form text field about foundation text ANCHOR_BOLT_CORROSION Anchor Bolt Corrosion Corroded Anchor Bolts text ANCHOR_BOLT_CRACKING Anchor Bolt Cracking Cracks in Anchor Bolt text ANCHOR_NUTS_CORROSION Anchor Bolt Corrosion Corroded Anchor Nuts text ANCHOR_NUTS_CRACKING Anchor Nuts Cracking Cracks in Anchor Nuts text ANCHOR_NUTS_LOOSE Anchor Nuts Loose Loose Anchor Nuts text MISSING_WASHERS Missing Washers Missing Washers text ANC_BOLT_NUTS_COMMENTS Anchor Bolts/Nuts Comments Anchor Bolts and Anchor Nuts Comments text EF_EP_CORROSION End Frame/Pole Wire Entrance Cap Missing Corroded End Frame or End Pole text EF_EP_DAMAGE Foundation Anchor Bolts Cracks Damage to End frame or end pole text EF_EP_CRACKING Foundation Anchor Bolts Corrosion Cracks in end frame or end pole text EF_EP_WIRE_CAP_MISS End Frame/Pole Wire Entrance Cap Missing Wire Entrance Cap missing on end frame or end pole text EF_EP_COVERS_MISSING Flange Type Handhole covers missing from end frame or end pole text EF_EP_CAP_MISSING End Frame/Pole Weld Corrosion Cap missing from end frame or end pole text EF_EP_BOLT_CORROSION End Frame/Pole Other Corroded structural bolts on end frame or end pole text EF_EP_MISSING_BOLTS Foundation Anchor Bolts/Nuts Comments Missing structural bolts on end frame or end pole text EF_EP_WELD_CORROSION Foundation Comments Corroded structural welds on end frame or end pole text EF_EP_WELD_CRACKING End Frame/Pole Weld Cracking Cracks in structural welds on end frame or end pole text EF_EP_OTHER End Frame/Pole Other Other issues with end frame or end pole text EF_EP_COMMENTS End Frame/Pole Comments Comments about end frame or end pole text CANT_SPAN_CORROSION Cantilever/Span Corrosion Corroded cantilever or span text CANT_SPAN_DAMAGE Cantilever/Span Damage Damage to cantilever or span text CANT_SPAN_CRACKING Cantilever/Span Cracking Cracks in cantilever or span text CANT_SPAN_FLANGE_CRACK Cantilever/Span Flange Cracking Flange cracking in cantilever or span text CANT_SPAN_BOLT_CORROS Cantilever/Span Bolt Corrosion Corroded structural bolts on end frame or end pole text CANT_SPAN_MISS_BOLTS Cantilever/Span Missing Bolts Missing structural bolts on end frame or end pole text CANT_SPAN_WELD_CORROS Cantilever/Span Weld Corrosion Corroded structural welds on end frame or end pole text CANT_SPAN_WELD_CRACK Cantilever/Span Weld Crack Cracks in structural welds on end frame or end pole text CANT_SPAN_ENDCAPS_MISS Cantilever/Span End Caps Missing End caps missing on cantilever or span text CANT_SPAN_OTHER Cantilever/Span Other Other issues with cantilever or span text CANT_SPAN_COMMENTS Cantilever/Span Comments Comments about cantilever or span text SIGN_ATTACH_CORROSION Sign Attachment Corrosion Corroded sign attachment text SIGN_ATTACH_DEFOR Sign Attachment Deformations Deformations on sign attachment text ATTACH_MISS_HARDWARE Cantilever/Span End Caps Missing Missing hardware on sign attachment text SIGN_DAMAGE Sign Damage Damage on sign text LIGHTING_MISS_HARDWARE Lighting Missing Hardware Missing Hardware with sign lighting text OBSTRUCTION_OVERGROWTH Sign Obstruction/Overgrowth Obstruction or overgrowth in front of sign text SIGN_INSP_COMMENTS Sign Inspection Comments Comments about sign text OVERALL_CONDITION Overall Condition Overall condition of Overhead support and sign text INSPECTION_COMMENTS Inspection Comments Comments about inspection overall text INSPECTOR_INITIALS Inspector Initials Initials of inspector text INSPECTION_DATE Inpection Date Date of inspection date MAINTENANCE_RECOMMEND Maintenance Recommended Maintenance Recommended text MAINTENANCE_COMPLETED Maintenance Completed Maintenance Completed text MAINTENANCE_COMPLET_DT Maintenance Completed Date Date of maintenance completed date MAINTENANCE_COMMENT Maintenance Comments Maintenance comments 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 URBAN_AREA_CODE Urban Area Code U.S. Census Urban Area Code associated with the section of roadway 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_supInv Image Attachments Sign Inventory Sign Inventory image attachments text Image_Attach_supInsp Image Attachments Support Inventory Sign Support Inventory image attachments text iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO xAAADsQBlSsOGwAAAqpJREFUeJzt1DENADAMwLAd5U+5o7BvimQjyJXZ3T0AAfM7AOCVYQEZhgVk GBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFY QIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZ hgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgW kGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECG YQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYF ZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBh WECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEB GYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQY FpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhA hmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmG BWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQ YVhAhmEBGYYFnIoLreIHHblfYqUAAAAASUVORK5CYII=