whereabouts US geocoding database

[2SFCA]

Hi @ajl2718,

Thanks for sharing this project. I created a dataset for US using the Overture dataset which has more 90 million valid addresses whereabouts-db-us.

Even though, this currently, it does not contains all states in the US, but at least we have an option.

[ajl2718]

Hi @2SFCA, thanks for this. Do you have the code and link to the source data used to create it? That way I can build it, do some tests and upload it to the whereabouts Huggingface space

[2SFCA]

Hi @ajl2718 ,

Sorry, I do not have the code because I cleaned the data in a Linux HPC interactive terminal using python. Basiclly, a few lines of code to clean the empty filed rows.

here is the code I used to download the address data from overture map data:

LOAD spatial; --noqa
LOAD httpfs;  --noqa

-- Set AWS region
SET s3_region='us-west-2';

COPY (
    SELECT
      *
    FROM
      read_parquet(
        's3://overturemaps-us-west-2/release/2025-08-20.1/theme=addresses/type=*/*',
        filename = true,
        hive_partitioning = 1
      )
    WHERE
      country = 'US'
)
TO 'USaddresses.parquet'
WITH (
    FORMAT PARQUET
);

[ajl2718]

Thanks for your work on this @2SFCA, I'll run through these and aim to have them uploaded to the huggingface space this week.