Download instructions for dummies?

[selsin]

Could someone please write dummy-proof instructions on how to download the data, for us who aren't familiar with coding or the coding language?
I have created an AWS account but I have no idea where to paste the link provided in the description s3://overturemaps-us-west-2/release/2023-07-26-alpha.0/theme=places.

I would like to download the data and look at it in QGIS.

Thank you in advance.

[mtravis]

@selsin I'm happy try and help you out.

Firstly you don't need an AWS account to actually get the data. You will need the AWS CLI install on your machine.

Once you have that you can then download the places data using this command.

aws s3 cp --region us-west-2 --no-sign-request --recursive s3://overturemaps-us-west-2/release/2023-07-26-alpha.0/ <DESTINATION>

Once you have all the data in the destination folder you can convert it to spatial formats using GDAL or DuckDB.

Can I check to see which type of OS you're using? What you do next kind of determines what advice I can give here.

[mtravis]

@selsin No problem. Try the following.

INSTALL spatial;
LOAD spatial;

COPY (select * EXCLUDE (geometry), ST_GeomFromWKB(geometry) as geom 
from read_parquet('/data/transportation/type=segment/*') 
where st_intersects(ST_GeomFromWKB(geometry),ST_GeomFromText('POLYGON((10.59 69.06, 24.18 69.06, 24.18 55.14, 10.59 55.14, 10.59 69.06))'))
limit) 
to '/data/transportation/sweden_roads.parquet' (FORMAT PARQUET);

Once you have that you'll need to use gpq to convert from parquet to geoparquet

Run this command gpq convert sweden_roads.parquet sweden_roads_geo.parquet

Hope that helps

Matt

[Sok46]

Can you tell me how to convert parquet to geojson on Windows?

[selsin]

Thank you.
I cant get it to work tho.
Just to make sure, I have downloaded the transportation theme for the whole world which resulted in two folders: type=connector and type=segment:
Lets say I have these saved on my computer at this location: C:\Users\Selma\Desktop\OvertureMaps\type=segment

Does the code look like this instead then:

INSTALL spatial;
LOAD spatial;

COPY (select * EXCLUDE (geometry), ST_GeomFromWKB(geometry) as geom
from read_parquet('C:\Users\Selma\Desktop\OvertureMaps\type=segment*')
where st_intersects(ST_GeomFromWKB(geometry),ST_GeomFromText('POLYGON((10.59 69.06, 24.18 69.06, 24.18 55.14, 10.59 55.14, 10.59 69.06))'))
limit)
to 'C:\Users\Selma\Desktop\OvertureMaps\sweden_roads.parquet' (FORMAT PARQUET);

?

[selsin]

@Sok46 I will let you know once I have figured it out :)

[Krizz]

I've created this easy to use tool to quickly extract GeoJSON/GeoParquet data for different areas from Overture Maps. You might find this useful - or not :)

https://github.com/Krizz/fetch_overture

[snuup]

I just try since an hour to download the GeoParquet file holding the Places. I wonder why there is no download link nowhere that this issue has a nice title but does not answer how to "download for dummies", the github repo about data has text explanations but no clear download instructions either. Please make it imuch more simpler to download the data. For instance OSM data is trivial to download, the planet files are plain http links, please make it as easy as the OSM community does it.