Import openaddresses.io zipcodes longitude and latitude data

Show HN: Import openaddresses.io zipcodes longitude and latitude data

Import openaddresses.io zipcodes longitude and latitude data is a company in show hn launch.

Profile

This is a screenshot of all the USA data from https://openaddresses.io/https://i.imgur.com/nHIYtap.pngIt's about 80GB un-compressed. I wanted a postgres table like:zip | integer location | geometry(Point,4326) "zip_locations_zip_index" UNIQUE, btree (zip)The following takes hours and hours to run:https://github.com/andrewarrow/feedback/blob/main/location/zip.goBut you end up with a nice way to get an approximate postgis geometry for any zip code in the USA. (For free.) Anyone know of a faster way?My favorite part of this code is buffer := make([]byte, 1). By making the buffer just a single byte, I can look for "\n" so much easier than if I was reading in 1024 bytes or 2,048 bytes etc and the

As a business in show hn launch, Import openaddresses.io zipcodes longitude and latitude data is listed here with the public details available about it.

The company is listed at the Show HN launch stage of development.

Website: openaddresses.io/https://i.imgur.com/nHIYtap.pngIt