As of January 1, 2018, OSM contains 10,003,605 nodes, 1,029,174 ways, and 11,414 relations in Ohio, including:
- 262,073 buildings covering 51,242 acres
- 42,822 electric transmission towers
- 28,654 street addresses
- 27,074 cul-de-sacs (not counting those with traffic islands)
- 19,914 crosswalk nodes and 10,164 crosswalk ways
- 16,819 parking lots
- 14,488 athletic fields and courts
- 12,068 bridges (44% complete)
- 9,910 at-grade level crossings (111% complete)
- 8,388 signalized intersections (79% complete)
- 6,923 farms (9% complete) covering 721,271 acres (5% complete)
- 6,571 Wikidata QIDs
- 5,000 website URLs
- 4,070 swimming pools
- 3,681 phone numbers
- 2,816 bus stops
- 2,439 turn restrictions
- 2,410 playgrounds
- 2,039 county route relations
- 1,966 highway exits
- 1,575 communications towers
- 1,347 power substations
- 1,128 culverts
- 1,078 staircases
- 1,062 dams
- 884 named residential subdivisions and apartment complexes
- 737 water towers
- 715 speed bumps
- 469 roundabouts (345% complete)
- 431 township boundaries (33% complete)
- 401 outdoor bleachers
- 335 helipads (156% complete)
- 329 flagpoles
- 282 wind turbines (83% complete)
- 212 works of art
- 208 bus routes
- 195 boat launches
- 135 unique etymologies of names
- 62 fords
- 58 unique pronunciations of names
- 48 dog parks
- 45 buildings with intricate 3D detail
- 29 rooftop solar panels
- 22 tornado sirens
- 15 ferry routes (250% complete)
Points of interest
|Type||2018 OSM||2012 Economic Census||Other|
|NAICS codes||Count||OSM completeness||Year||Count||OSM completeness|
|Alternative fuel stations||39||2018||621||6%|
|Banks, credit unions, and money lenders||1,088||5221||5,100||21%|
|Bars and pubs||801||7224||2,119||38%|
|Child care centers||87||6244||2,583||3%|
|Convenience stores||1,044||445120, 447110||4,725||22%||2018||5,686||18%|
|Elementary and secondary schools||7,906||6111||N/A||N/A||2017||4,199||188%|
|Fast food restaurants||2,398||722513||9,009||27%|
|Hotels, motels, and bed-and-breakfasts||896||7211||1,362||66%|
|Pharmacies and drugstores||452||446110||1,453||31%|
|Supermarkets and grocery stores||754||445110||2,089||36%|
|Pathway type||Centerline miles||Lane miles|
|2018 OSM||2016 ODOT/FHWA||Completeness||2018 OSM||2016 ODOT/FHWA||Completeness|
|Dedicated bike paths||1,493||N/A||N/A||N/A||N/A||N/A|
|Shared lanes (sharrows)||N/A||N/A||N/A||137||N/A||N/A|
|2018 OSM||2017 FHWA NBI||Completeness|
|2018 OSM||2017 FHWA||Completeness|
|2018 OSM||2012 AAR||Completeness||2018 OSM||2012 AAR||Completeness|
|2018 OSM||2018 PHMSA NPMS||Completeness|
By road classification
|highway=*||Centerline miles||Centerline miles of speed limits||Completeness|
To generate these statistics, download the latest .osm.pbf extract from Geofabrik, then use osmium to filter it by the desired tags. For example, the following command filters out everything but parking lots and displays the number of elements in the resulting extract:
osmium tags-filter data/ohio-latest.osm.pbf -R 'nwr/amenity=parking' --overwrite -o data/ohio-latest-parking-lots.osm.pbf osmium fileinfo -e data/ohio-latest-parking-lots.osm.pbf
To count unique tag values, use this formula:
osmium tags-filter data/ohio-latest.osm.pbf -R 'nwr/*:etymology*' --overwrite -o data/ohio-latest-etymologies.opl cut -d' ' -f8 data/ohio-latest-etymologies.opl | cut -c2- | grep -oE '\w+:etymology(:wikidata)?=[^,]+' | cut -d'=' -f2 | sort -u | wc -l osmium tags-filter data/ohio-latest.osm.pbf -R 'nwr/*:pronunciation' --overwrite -o data/ohio-latest-pronunciations.opl cut -d' ' -f8 data/ohio-latest-pronunciations.opl | cut -c2- | grep -oE '\w+:pronunciation=([^,]+)' | cut -d'=' -f2 | grep -oE '[^;]+' | sort -u | wc -l
Then install Vainilla and follow the instructions in the tool's readme to generate the pathway statistics.
Notes and references
- “Bridge Condition by Functional Classification Count 2017”. Federal Highway Administration. December 31, 2017. Retrieved May 7, 2018.
- “Total at-grade highway-rail crossings for state=Ohio”. Federal Railroad Administration Office of Safety Analysis. Retrieved May 7, 2018.
- Only includes freight rail.
- “2012 National Traffic Signal Report Card Technical Report” (PDF). National Transportation Options Coalition. 2012. p. 7. Retrieved May 8, 2017.
- “Proposed Accessibility Guidelines for Pedestrian Facilities in the Public Right-of-Way” (PDF). United States Access Board. July 26, 2011. p. 29. Retrieved May 21, 2018.
- “Frequently Asked Questions – Part 4 – Highway Traffic Signals”. Manual on Uniform Traffic Control Devices. Federal Highway Administration. April 4, 2018. Retrieved May 21, 2018.
- Tarnoff, Philip J.; Javier Ordonez (March 2004). “Signal Timing Practices and Procedures: State of the Practice”. Institute of Transportation Engineers. p. 3. “A common rule of thumb states that in an urban area there is approximately one signal controller per 1,000 population. This “rule” was tested using data from 75 urban areas. The results of this test are shown in Figure 2. The total population of the analyzed metropolitan areas is 168,895,184. The total number of signals in these metropolitan areas is 153,228. The ratio of signals to population is one signal per 1,102 of population—a value that is very close to the rule of thumb. Using this ratio (1:1,102) and assuming the population of the United States is approximately 290 million, the total number of signals in the United States can be estimated to be 265,000.”
- There were an estimated 311,000 signalized intersections in the U.S. as of 2011. The Institute of Transportation Engineers calculates this estimate and an annual growth of 2,550 on a per-capita basis. Ohio had an estimated 11,658,609 residents in 2017 for an estimated 10,580 signalized intersections.
- The OSM figure may be overcounted due to certain traffic signal tagging styles.
- “Farms, Land in Farms, Value of Land and Buildings, and Land Use: 2012 and 2007” (PDF). 2012 Census of Agriculture. National Agricultural Statistics Service, U.S. Department of Agriculture. October 13, 2017. Retrieved May 9, 2018.
- “Roundabouts Database Reports”. Roundabouts Database. Kittelson & Associates. 2018. Retrieved May 21, 2018.
- “The Ohio Township Roster” (Office Open XML Workbook). Ohio Secretary of State. May 4, 2017. Retrieved January 4, 2018.
- “Public and Private Airports, Heliports, and Seaplane Bases by State”. Bureau of Transportation Statistics. August 2015. Retrieved May 7, 2018.
- “United States Wind Turbine Database”. United States Geological Survey. April 2018. Retrieved May 19, 2018. Filter out values of
- 285 sites according to “Power Siting Wind Case Status” (PDF). Ohio Power Siting Board. February 5, 2018. p. 1. Retrieved May 9, 2018.
- “Vehicular Toll Ferries in the United States”. Office of Highway Policy Information, Federal Highway Administration. January 1, 2017. Retrieved May 7, 2018.
- “2012 Economic Census”. U.S. Census Bureau. October 9, 2015. Retrieved May 10, 2018.
- Compressed natural gas, ethanol, liquefied petroleum gas, electric charging, biodiesel, hydrogen, and liquefied natural gas.
- “Alternative Fueling Station Counts by State”. Alternative Fuels Data Center, Office of Energy Efficiency and Renewable Energy, U.S. Department of Energy. Retrieved May 8, 2018.
- The Economic Census reports 1,772 educational institutions (excluding educational support services), but it does not distinguish elementary and secondary schools from colleges and universities as NAICS does.
- “U.S. Convenience Stores Continue Growth” (PDF). NACS Magazine. National Association of Convenience Stores. February 2018.
- “Fall Enrollment (Headcount) - October 2017 Public Districts and Buildings” (Microsoft Excel). Ohio Department of Education. January 30, 2018. Retrieved May 12, 2018. Number of rows in the
- “Fall Enrollment (ADM) - October 2017 Non-Public Buildings” (Microsoft Excel). Ohio Department of Education. January 30, 2018. Retrieved May 12, 2018. Number of unique values in the
irncolumn of the
- There are 4,368 active, licensed gas station facilities according to “List of Active Underground Storage Tanks” (ZIP, CSV). Bureau of Underground Storage Tank Regulations, Ohio Department of Commerce. Retrieved May 9, 2018. Filter out values of
Gas Station, values of
ABN - Orphaned, or any value of
AbandonedApproved. Then remove duplicate values of
FacilityNumber. Finally, remove rows that have identical values in all the columns
- There were 4,617 gas stations in 2012 according to Ognibene, Jessica (July 8, 2014). “Public Retail Gasoline Stations by State and Year” (Microsoft Excel). Alternative Fuels Data Center, Office of Energy Efficiency and Renewable Energy. Retrieved May 7, 2018. This figure comes from the defunct National Petroleum News.
- A one-way road tagged highway=motorway/trunk/primary/secondary/tertiary may or may not be one side of a divided road. The lower bound assumes they all are, causing false positives' lengths to be undercounted by half. The upper bound assumes none of them are, double-counting the length of every false negative.
- "Public Road Length - 2016, Miles By Functional System". In “Highway Statistics 2016”. Federal Highway Administration. 2017-09-18. p. HM-20.
- Figures over 100% may be due to a combination of new road construction since 2016, overcounting divided highways, privately-owned roads missing access=* tags, overnoding in TIGER-imported roads in some counties such as Clermont County, and TIGER-imported driveways incorrectly classified as highway=residential ways.
- "Functional System Lane-Length - 2016, Lane-Miles". In “Highway Statistics 2016”. Federal Highway Administration. 2017-09-18. p. HM-60.
- Rural minor collector and rural/urban local functional system lane miles are estimates.
- Figures over 100% may be due to a combination of new road construction since 2016, privately-owned roads missing access=* tags, overnoding in TIGER-imported roads in some counties such as Clermont County, and TIGER-imported driveways incorrectly classified as highway=residential ways. Figures less than the corresponding centerline mile figures may be due to multilane roads missing lanes=* tags.
- FHWA calls this category “Other freeways and expressways”, but as seen in TIMS, ODOT classifies expressways and super-twos as principal arterials.
- Excluding all highway=service roads and roads with access=* values other than access=yes, access=destination, or access=designated.
- Only marked or signposted turn lanes; excludes implicit turns.
- Maximum speed limits, including advisory speed limits.
- The TIGER import erroneously tagged any road with "bridge" in the name as a bridge. Many but not all occurrences have been corrected.
- “Bridge Condition by Functional Classification Length 2017”. Federal Highway Administration. December 31, 2017. Retrieved May 7, 2018.
- “Interstate System Toll Roads in the United States”. Office of Highway Policy Information, Federal Highway Administration. January 1, 2017. Retrieved May 7, 2018.
- “Miles of Freight Railroad Operated by Class of Railroad”. Bureau of Transportation Statistics. Retrieved May 7, 2018.
- Field, Katie (April 24, 2018). “Summary of active pipeline mileage by county” (Microsoft Excel). National Pipeline Mapping System, Pipeline and Hazardous Materials Safety Administration, U.S. Department of Transportation. Retrieved May 9, 2018.