State Planner

ITS Power Service Inventory

Power service connections feeding ODOT's Intelligent Transportation Systems (ITS) field equipment.

Published by
ODOT Office of TSMO
Source
Ohio Department of Transportation TIMS
Original data
tims.dot.state.oh.us
Terms of use
Public information, no warranty (ODOT)
On the map
Points

Ask State Planner a question about this data in plain language, and get the answer as a written explanation and a map.

Sign up to ask

Fields

What each record holds, as the publisher describes it: 74 fields.

FieldDescription
NLFID
14 character Network Linear Feature ID: 1 Jurisdiction, 2-4 County Code, 5-6 Route Type, 7-11 Route Number, 12 Extension Code, 13 Description Code, 14 Direction Code. For more information, see the Roadway Information Manual.
CRS
County Route Section w/no leading zeros in route
ODOT_DISTRICT
From 1-12 plus Central Office – the counties are grouped into districts in Ohio for ease of maintenance and funding
COUNTY
Full County Name
COUNTY_CD
Three Character County Code; second component of the NLFID.
ROUTE_TYPE
Two letter code indicating the basic transportation grouping or system that the route belongs to; third component of the NLFID.
ROUTE_NBR
Transportation route identification number. Each State system route number is unique within the entire state. Local Roadways are unique within a given county. Right justified, left filled with zero. Fourth component of the NLFID.
ROUTE_SUFFIX
Single letter extension code used with the route number in local and municipal systems to guarantee uniqueness; Fifth component of the NLFID.
CTL_BEGIN_NBR
County True Log Begin Number
STL_BEGIN_NBR
State True Log Begin Number
LATITUDE_DD_BEGIN
Latitude of a point feature or beginning of a line feature, in Decimal Degrees.
LONGITUDE_DD_BEGIN
Longitude of a point feature or beginning of a line feature, in Decimal Degrees.
PERP_DATE
Year of the published LRS.
STATUS
Status: A - Active, P - Proposed, R - Retired, C - Cancelled, I - Inactive.
INSTALLATION_DATE
Date asset installed/constructed
PID
Capital Projects Unique Project Identifier
LET_PLANS_URL
URL to PID Project Construction Plan Set
END_CONSTRUCTION_DATE
Date of projected end of construction, derived from PID
MAINTAIN_RESPONSIBLE
Entity responsible for asset maintenance: S - State, C - County, M - Municipality, T - Township, V - Village, N - ODNR, O - Other, D - Split responsibility
QA_COMPLETE
Indicator if inventory record has been reviewed by a Manager
INTERSECTION_ID
Unique Identifier of Intersection
CROSS_ROUTE_LEG_ID
Unique Identifier of Approach
POWER_SERV_FILE_NUMBER
Unique number assigned to each asset
LOCATION_DESCRIPTION
Description of the where the asset is located
POWERS
Indicates what the Power Service powers
DISCONNECT_AMP_RATING
Rating size of the amp
METERED
Indicator if power service is metered
ACCOUNT_NUM
Power Service Account # provided by the utility
METER_NUM
Power Service Meter # provided by the utility
SERVICE_TYPE
How the incoming power is routed
PSI_UTILITY_PROVIDER
The utility company providing power
POWER_SERVICE_OWNER
Owner of the Power Service
BILLING_ADDRESS
Address where the power bill is sent
SERVICE_ADDRESS
The address of the Power Service
SERVICE_CITY
The city of the Power Service
SERVICE_STATE
The state of the Power Service
SERVICE_ZIP
The zip code of the Power Service
SIZE_OF_CONDUIT
The size of the conduit in inches
METER_BASE_HEIGHT
The heigth of the meter base in feet
METER_BASE_WIDTH
The width of the meter base in feet
METER_BASE_DEPTH
The depth of the meter base in feet
METER_BASE_TYPE
The type of base the meter is
DISCONNECT_HEIGHT
The height of the disconnect in inches
DISCONNECT_WIDTH
The width of the disconnect in inches
DISCONNECT_DEPTH
The depth of the disconnect in inches
DISCONNECT_TYPE
The type of disconnect
MYERS_HUB_HEIGHT
The myers hub height in inches
MYERS_HUB_WIDTH
The myers hub width in inches
MYERS_HUB_DEPTH
The myers hub depth in inches
MYERS_HUB_TYPE
The type of myers hub
POWER_SERVICE_MOUNT_TP
How the power service is mounted
POWER_SERVICE_KVA
How much Volt-ampere the power service has
PRE_METER_UNFUSED_DIS
Does the pre-meter have an unfused disconnect
CT_CABINET
Is there a CT cabinet
Image_Attach_Inv
Link to image attachments associated with the asset inventory record
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.
DIVIDED_HWY
Indicates whether a roadway section is part of a divided highway
URBAN_AREA_CODE
U.S. Census Urban Area Code associated with the section of roadway
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.
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.
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.
LANES
Number of lanes in both directions carrying through traffic
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.
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.
PRIORITY_SYSTEM
Priority System code associated with the section of the roadway. (G) General. (P) Priority System. (U) Urban.
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.
SURFACE_WIDTH
Surface width on the right side of the roadway
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
AADT_PASSENGER
Annual Average Daily Traffic for passenger type vehicles
AADT_TOTAL
Total Annual Average Daily Traffic
AADT_BC_TRUCK
Annual Average Daily Traffic for type BC trucks. (B=Buses C= Commercial Trucks)
PAVE_TYPE
Type of Pavement
PCR_YEAR
Year in which conditions of pavements on road in speed zone were last collected and processed by the pavement engineering group
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

More from Ohio Department of Transportation TIMS

Every Ohio data set

HomePricingAboutTerms of ServicePrivacy Policy