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 asked 28 Jan '19, 12:23 sabyasachi_g... aseerel4c26 ♦ |
OpenStreetMap is unsuitable for your project because:
Also, you seem to assume that ZIP codes are tied to one particular lat/lon pair when in reality they cover a larger area, hence it is unclear what you mean by the distance between two zip codes. I suggest you use a web search engine to search "US zipcodes download" and you'll find a few providers giving you simple tables with zip code and lat/lon of the central point, which will make life much easier for you. answered 28 Jan '19, 13:38 Frederik Ramm ♦ |
Cross-posted here