Convert PBF file into a format to extract zip code,latitude and longitude information
My Project Requirement:
I have a project requirement where I need to create a database for the country of the United States of America containing the following columns:
Zip code
Latitude(of zip code)
Longitude(of zip code)
Zip code 1 ( which is at a distance of 10 miles from zip code)
Zip code 2 (which is at a distance of 25 miles from zip code)
Zip code 3 (which is at a distance of 50 miles from zip code)
My approach:
1.Download the OSM file (in PBF format ) for the country of united states of America
2.Convert the PBF file into a format which contains the zip code, latitude, and longitude information of USA
3.Extract the information into the database
My Research :
I tried using the site https://mygeodata.cloud/converter/osm-to-xlsx to convert pbf file into excel file.However, it had size limitations and I could not use it for free. I also searched the internet for various other formats in which the PBF file could be converted. I haven't got any such file format.
My Question:
I have downloaded the OSM(PBF) files for the entire country of the United States of America from http://download.geofabrik.de
Do these files contain the following information :
All zip codes in the USA
Latitude
Longitude
In which format can I convert the PBF file so that I can get the above information? Can I get a converter for free which allows the conversion so that I can extract all the relevant information for my database?
Any help will be appreciated
