20240906 06082300 1.0 FALSE TIMS.WGIS_HIGHWAY_LIGHTING_INV -9441441.274900 -8964269.824500 4638638.871000 5149857.817600 1 Server=DOTICSQLP31; Service=sde:sqlserver:DOTICSQLP31;ApplicationIntent=READWRITE;MultisubnetFailover=YES; Database=TIMS; User=TIMS; Version=dbo.DEFAULT ArcSDE Connection 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.2.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=00022e68375964694232786e792f4c4770593043734f6f4646342b516a51344a356d7935695354757a7a7376674a673d2a00;ENCRYPTED_PASSWORD=00022e6876463864322f3143635342714955566831596f764534557a47715446534f34784c706d596c527642665a733d2a00;SERVER=DOTICSQLT31;INSTANCE="sde:sqlserver:DOTICSQLT31;ApplicationIntent=READWRITE";DBCLIENT=sqlserver;DB_CONNECTION_PROPERTIES="DOTICSQLT31;ApplicationIntent=READWRITE";DATABASE=TIMS;USER=TIMS;VERSION=dbo.DEFAULT;AUTHENTICATION_MODE=DBMS</WorkspaceConnectionString><WorkspaceFactory>SDE</WorkspaceFactory><Dataset>TIMS.WGIS_HIGHWAY_LIGHTING_INV</Dataset><DatasetType>esriDTFeatureClass</DatasetType></CIMStandardDataConnection>" <operationSequence><workflow><AlterField><field_name>NEED_FURTHER_INSPECT</field_name><new_field_name>inspNEED_FURTHER_INSPECT</new_field_name><field_alias>inspNEED_FURTHER_INSPECT</field_alias><field_type>TEXT</field_type><field_is_nullable>True</field_is_nullable><clear_field_alias>False</clear_field_alias></AlterField></workflow><workflow><AddField><field_name>BULB_IS_OUT</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>1</field_length><field_alias>BULB_IS_OUT</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>invNEED_FURTHER_INSPECT</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>1</field_length><field_alias>invNEED_FURTHER_INSPECT</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>invMAINTENANCE_NEEDED</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>1</field_length><field_alias>invMAINTENANCE_NEEDED</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>LATEST_MAINTENANCE_DATE</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_alias>LATEST_MAINTENANCE_DATE</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>inspMAINTENANCE_NEEDED</field_name><field_type>TEXT</field_type><field_precision>0</field_precision><field_length>1</field_length><field_alias>inspMAINTENANCE_NEEDED</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow><workflow><AddField><field_name>MAINTENANCE_COMPLETED_DATE</field_name><field_type>DATE</field_type><field_precision>0</field_precision><field_alias>MAINTENANCE_COMPLETED_DATE</field_alias><field_is_nullable>True</field_is_nullable><field_is_required>False</field_is_required></AddField></workflow></operationSequence> CopyMultiple "D:\TIMS\Connections\T31_TIMS.sde\TIMS.WGIS_HIGHWAY_LIGHTING_INV FeatureClass" D:\TIMS\Connections\TIMS.sde WGIS_HIGHWAY_LIGHTING_INV "TIMS.WGIS_HIGHWAY_LIGHTING_INV FeatureClass TIMS.WGIS_HIGHWAY_LIGHTING_INV #" 20240917 15370400 20240917 15370400 FGDC 150000000 5000 dataset ODOT Transportation Asset Management Program https://www.transportation.ohio.gov/programs/asset-management/asset-management 20250611 ArcGIS Metadata 1.0 Enterprise Geodatabase Feature Class Highway Lighting Inventory vector digital data Highway Lighting Inventory <div style='text-align:Left;'><div><div><p><span>ODOT's Highway Lighting Inventory</span></p></div></div></div> ODOT's Highway Lighting Inventory ODOT Transportation Asset Management Program <div style='text-align:Left;'><div><div><p><span>The information contained within this dataset is maintained by the Ohio Department of Transportation (ODOT), and is deemed to be public information. While every effort is made to assure the data is accurate and current, it must be accepted and used by the recipient with the understanding that no warranties, expressed or implied, concerning the accuracy, reliability or suitability of this data have been made. ODOT, its agents, and the developers of this data set assume no liability whatsoever associated with the use or misuse of the data contained herein.</span></p></div></div></div> Microsoft Windows Server 2016 Technical Preview Version 10.0 (Build 20348) ; Esri ArcGIS 13.2.0.49743 ASSETS COLLECTOR LIGHTING 1 -84.813910 -80.527406 41.925711 38.417959 https://tims.dot.state.oh.us/tims/api/glossary/dataset/7753929ffacd444989f46b32a7694e27 ODOT Transportation Asset Management Program https://www.transportation.ohio.gov/programs/asset-management/asset-management False ODOT Transportation Asset Management Program 38140 EPSG 6.18.3(9.3.1.2) WGIS_HIGHWAY_LIGHTING_INV Feature Class 38140 NLFID NLFID Network Linear Feature Identifier text(14) CRS CRS County-Route-Section. County CD, Route Number, CTL Begin Number (ALL-30-10.432) text(17) ODOT_DISTRICT ODOT_DISTRICT ODOT District Number text(2) COUNTY COUNTY Full County Name text(10) COUNTY_CD COUNTY_CD Three Character County Code text(3) ROUTE_TYPE ROUTE_TYPE IR, US, SR, CR, TR, MR, etc text(2) ROUTE_NBR ROUTE_NBR 5 Digit Route Number text(5) ROUTE_SUFFIX ROUTE_SUFFIX A, B, C, D, I, F, T etc. text(1) CTL_BEGIN_NBR CTL_BEGIN_NBR County log point of highway lighting double STL_BEGIN_NBR STL_BEGIN_NBR State log point of highway lighting double LATITUDE_DD_BEGIN LATITUDE_DD_BEGIN Latitude of highway light double LONGITUDE_DD_BEGIN LONGITUDE_DD_BEGIN Longitude of highway light double PERP_DATE PERP_DATE Date of Linear Referencing System(LRS) highway light is located against date STATUS STATUS status of highway light text(1) INSTALLATION_DATE INSTALLATION_DATE Date highway light was installed date PID PID PID under which the highway light was installed long integer END_CONSTRUCTION_DATE END_CONSTRUCTION_DATE end of construction date in Ellis date MAINTAIN_RESPONIBLE MAINTAIN_RESPONIBLE Agency responsible for maintaining highway light text(1) HL_FILE_NUM HL_FILE_NUM Unique number assigned to lighting pole text(10) DATE_RELAMPED DATE_RELAMPED Date of the last time the luminaires were replaced date CLUSTERID CLUSTERID This field will be used if districts want to group lights together text(50) OWNER_AGENCY OWNER_AGENCY Agency responsible for inspecting light text(1) POLE_ID POLE_ID Identifier on each lighting support text(20) LIGHTING_TYPE LIGHTING_TYPE Type of highway lighting support text(18) DECORATIVE DECORATIVE Indicator if the highway light support is decorative text(1) FOUNDATION_BOLT FOUNDATION_BOLT Number of bolts on the tower foundation text(5) SUPPORT_BASE_TYPE SUPPORT_BASE_TYPE Type of base on highway light support text(5) SUPPORT_BASE_STYLE SUPPORT_BASE_STYLE Style of base on highway light support text(5) FOUNDATION_DEPTH_FT FOUNDATION_DEPTH_FT Depth of foundation of the highway light support long integer POLE_HEIGHT_FT POLE_HEIGHT_FT Height of support long integer MOUNTING_HEIGHT_FT MOUNTING_HEIGHT_FT Height of luminaire on support from ground long integer NUM_BRACKET_ARMS NUM_BRACKET_ARMS Number of bracket arms on support long integer BRACKET_ARM_LENGTH1_FT BRACKET_ARM_LENGTH1_FT Length of bracket on support in feet long integer BRACKET_ARM_LENGTH2_FT BRACKET_ARM_LENGTH2_FT Length of bracket on support in feet long integer BRACKET_ARM_LENGTH3_FT BRACKET_ARM_LENGTH3_FT Length of bracket on support in feet long integer MAINT_PLATFORM MAINT_PLATFORM Indicator if the highway lighting support has a maintenance platform text(1) VARMINT_SCREENING VARMINT_SCREENING Indicator if the highway lighting support has a varmint screen text(1) PAINTED_COATED PAINTED_COATED Indicator if the highway lighting support is painted or coated text(1) MEDIAN_WALL_MOUNT MEDIAN_WALL_MOUNT Indicator if the highway lighting support is mounted on a median wall text(1) BRIDGE_MOUNT BRIDGE_MOUNT Indicator if the highway lighting support is mounted on a bridge text(1) STRUCTURE_MOUNT STRUCTURE_MOUNT Indicator if the highway lighting structure is mounted on a support that is not a bridge text(1) SUPPORT_COMMENTS SUPPORT_COMMENTS Catch all comment field for highway lighting support text(2500) LUMINAIRE_TYPE LUMINAIRE_TYPE Type of Luminaire text(5) NUM_LUMINAIRES NUM_LUMINAIRES Number of luminaires on support long integer HPS_WATTAGE HPS_WATTAGE Wattage of HPS luminaire long integer LED_WATTAGE LED_WATTAGE Wattage of LED luminaire long integer LUMENS LUMENS Amount of lumens luminaire gives off text(15) GLARE_SHIELD GLARE_SHIELD Indicator if highway light has a glare shield text(1) IES_DISTRIBUTION IES_DISTRIBUTION Distrubution of light text(3) LUMINAIRE_BRAND LUMINAIRE_BRAND Brand of luminaire text(50) LUMINAIRE_MODEL_NUM LUMINAIRE_MODEL_NUM Model number of luminaire text(50) VOLTAGE VOLTAGE Voltage of the luminaire text(10) BULB_IS_OUT BULB_IS_OUT Indicator if the bulb is out text(1) SIGNAL_POLE_MOUNTED SIGNAL_POLE_MOUNTED Indicator if the luminaire is mounted on a signal pole text(1) WOOD_POLE_MOUNTED WOOD_POLE_MOUNTED Indicator if the luminaire is mounted on a wood pole text(1) UTILITY_POLE_MOUNTED UTILITY_POLE_MOUNTED Indicator if the luminaire is mounted on a utility pole text(1) SIGN_SUPPORT_MOUNTED SIGN_SUPPORT_MOUNTED Indicator if the luminaire is mounted on a sign support text(1) AIRPORT_OBSTRUCT_LIGHT AIRPORT_OBSTRUCT_LIGHT Indicator if there is an airport obstruction light present text(1) LUMINAIRE_COMMENTS LUMINAIRE_COMMENTS Catch all comment field for highway lighting luminaire text(2500) CCPS_CONFIGURATION CCPS_CONFIGURATION How the Control Center/Power Service is mounted text(20) CONTROL_CENTER_ID CONTROL_CENTER_ID Control Center ID for Control Center/Power Service text(10) CIRCUIT_ID CIRCUIT_ID Circuit ID for the Control Center/Power Service text(10) POWER_SERV_FILE_NUMBER POWER_SERV_FILE_NUMBER Power Service File Number from ITS Inventory text(10) POWER_COMPANY POWER_COMPANY Power Complany that is supplying power to the Control Center/Power Service text(45) ACCOUNT_NUMBER ACCOUNT_NUMBER Account Number of the Control Center/Power Service text(30) METER_NUMBER METER_NUMBER Meter Number of the Control Center/Power Service text(30) CC_KVA CC_KVA cc kVa of the Control Center/Power Service long integer PREMETER_DISCONNECT PREMETER_DISCONNECT Indicator if the Control Center/Power service is a pre-meter unfused disconnect text(1) CT_CABINET CT_CABINET Indicator if the Control Center/Power service is a CT cabinet text(10) CCPS_COMMENTS CCPS_COMMENTS Catch all comment field for highway lighting Control Center/Power Service text(2500) LATEST_INSPECTION_DATE LATEST_INSPECTION_DATE Inspection Date from most recent inspection date INSPECTION_DUE_YEARS INSPECTION_DUE_YEARS Years until the next inspection is due (Calendar Year) long integer RELAMP_DUE_YEARS RELAMP_DUE_YEARS Years until the next relamp is due (Calendar Year) long integer invNEED_FURTHER_INSPECT invNEED_FURTHER_INSPECT Indicator if further inspection is needed, associated with the inventory record text(1) invMAINTENANCE_NEEDED invMAINTENANCE_NEEDED Indicator if maintenance is needed, associated with the inventory record text(1) LATEST_MAINTENANCE_DATE LATEST_MAINTENANCE_DATE Latest maintenance date date FOUNDATION_CRACK_SPALL FOUNDATION_CRACK_SPALL Indicator if there is cracking or spalling on the foundation text(1) FOUNDATION_BURIED_EROS FOUNDATION_BURIED_EROS Indicator if there is foundation is buried or eroded text(1) BOLT_NUT_CORROSION BOLT_NUT_CORROSION Indicator of Corrosion on Anchor Bolts/Nuts text(1) BOLT_NUT_LOOSE BOLT_NUT_LOOSE Indicator if Anchor Bolts/Nuts are loose text(1) BOLT_NUT_WASHER_MISS BOLT_NUT_WASHER_MISS Indicator if Anchor Bolts/Nuts are missing washers text(1) POLE_POSITION POLE_POSITION Indicator if the pole is down text(50) POLE_DAMAGE POLE_DAMAGE Type of damage on pole text(50) BRACKET_ARM_DAMAGE BRACKET_ARM_DAMAGE Type of damage on bracket arm text(50) ANCHOR_BOLT_DAMAGE ANCHOR_BOLT_DAMAGE Type of damage on anchor bolt text(10) TRANSFORM_BASE_DAMAGE TRANSFORM_BASE_DAMAGE Indicator if there is any Transofrmer base damage text(10) LUMINAIRE_DAMAGE LUMINAIRE_DAMAGE Indicator if there is any luminaire damage text(10) inspNEED_FURTHER_INSPECT inspNEED_FURTHER_INSPECT Indicator if further inspection is needed, associated with the inspection record text(1) INSPECTION_COMMENTS INSPECTION_COMMENTS Catch all for comments about inspection text(2500) INSPECTION_DATE INSPECTION_DATE Date the inspection occurred date inspMAINTENANCE_NEEDED inspMAINTENANCE_NEEDED Indicator if maintenance is needed, associated with the inspection record text(1) MAINTENANCE_COMPLETED_DATE MAINTENANCE_COMPLETED_DATE Maintenance completed date date Image_Attach_Inv Image_Attach_Inv Link to view inventory attachments text(255) Image_Attach_Insp Image_Attach_Insp Link to view inspection attachments text(255) JURISDICTION JURISDICTION Type of jurisdiction to which the section of the route belongs. (C) County. (F) Federal. (M) Municipal. (P) Private. (S) State. (T) Township. (X) Unknown. text(1) DIVIDED_HWY DIVIDED_HWY Indicates whether a roadway section is part of a divided highway text(1) URBAN_AREA_CODE URBAN_AREA_CODE U.S. Census Urban Area Code associated with the section of roadway text(5) BASE_TYPE BASE_TYPE Base type on the right side of the roadway. (F) Crack and Seat. (H) Rubblize and Roll. (I) Aggregate Base 304 or Traffic Compacted. (K) Water Bound Macadam. (L) Bituminous Concrete Mix or Penetration Macadam. (N) Plain Concrete. (P) Reinforced Concrete. (R) Brick – Flexible. (T) Brick – Rigid. text(1) FUNCTIONAL_CLASS FUNCTIONAL_CLASS Definition of roadway classes for the FHWA approved Functional Class system. This is based upon assignment of roads into systems according to the character of service they provide in relation to the total road network. (01) Interstate. (02)Other Freeway and Expressway. (03) Principal Arterial. (04) Minor Arterial. (05) Major Collector. (06) Minor Collector. (7) Local. text(5) HPMS_SAMPLE_ID HPMS_SAMPLE_ID Identifier associated with the Highway Performance Management System (HPMS) sample sections. HPMS is a 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(12) LANES LANES Number of lanes in both directions carrying through traffic long integer MAINTENANCE_AUTHORITY MAINTENANCE_AUTHORITY Entity who maintains roadway section. (1) State Highway Agency. (2) County Highway Agency. (3) Town or Township Highway Agency. (4) City or Municipal Highway Agency. (11) State Park, Forest, or Reservation Agency. (12) Local Park, Forest, or Reservation Agency. (21) Other State Agency. (25) Other Local Agency. (26) Private (other than Railroad). (27) Railroad. (31) State Toll Authority. (32) Local Toll Authority. (40) Other Public Instrumentality (e.g., Airport, School, University). (50) Indian Tribe Nation. (60) Other Federal Agency. (62) Bureau of Indian Affairs. (63) Bureau of Fish and Wildlife. (64) U.S. Forest Service. (66) National Park Service. (67) Tennessee Valley Authority. (68) Bureau of Land Management. (69) Bureau of Reclamation. (70) Corps of Engineers. (72) Air Force. (73) Navy/Marines. (74) Army. (80) Other. text(5) NHS NHS Code indicating the type of NHS Route. (N) National Highway System (regular). (H) Congressional Corridor. (S) Strahnet. (C) Strahnet Connector. (2) Major Airport. (3) Major Port Facility. (4) Major Amtrak Facility. (5) Major Rail/Truck Terminal. (6) Major intercity Bus Terminal. (7) Major Public Transit Terminal. (8) Major Pipeline Terminal. (9) Major Ferry Terminal. text(1) PRIORITY_SYSTEM PRIORITY_SYSTEM Priority System code associated with the section of the roadway. (G) General. (P) Priority System. (U) Urban. text(1) SURFACE_TYPE SURFACE_TYPE Surface type on the right side of the roadway. (B) Brick. (D) Reinforced Concrete. (E) Plain Concrete. (G) Dense Graded Asphaltic Concrete. (I) Seal Coat on Penetration Macadam or Water bound Macadam. (K) Open Graded Bituminous. (L) Surface Seal with cover. (S) Wood. (T) Steel Plate. (Z) Right of Way Only. text(5) SURFACE_WIDTH SURFACE_WIDTH Surface width on the right side of the roadway long integer ESAL_TOTAL ESAL_TOTAL Measure of total damage to road in speed zone. ESAL stands for Equivalent 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 Annual Average Daily Traffic for passenger type vehicles long integer AADT_TOTAL AADT_TOTAL Total Annual Average Daily Traffic long integer AADT_BC_TRUCK AADT_BC_TRUCK Annual Average Daily Traffic for type BC trucks. (B=Buses C= Commercial Trucks) long integer PAVE_TYPE PAVE_TYPE Type of Pavement text(10) PCR_YEAR PCR_YEAR Year in which conditions of pavements on road were last collected and processed by the pavement engineering group long integer ROADWAY_WIDTH_NBR ROADWAY_WIDTH_NBR The entire width of the roadway, including all driving lanes and shoulders. This number could include some gravel shoulders. Does not include medians short integer iVBORw0KGgoAAAANSUhEUgAAASwAAADICAYAAABS39xVAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAO xAAADsQBlSsOGwAAAqpJREFUeJzt1DENADAMwLAd5U+5o7BvimQjyJXZ3T0AAfM7AOCVYQEZhgVk GBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFY QIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZ hgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgW kGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECG YQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYF ZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBh WECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEB GYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQY FpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhA hmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmG BWQYFpBhWECGYQEZhgVkGBaQYVhAhmEBGYYFZBgWkGFYQIZhARmGBWQYFpBhWECGYQEZhgVkGBaQ YVhAhmEBGYYFnIoLreIHHblfYqUAAAAASUVORK5CYII=