How to load roads of a single country? #60
Answered
by
jiayuasu
BEAT454
asked this question in
Transportation
-
|
I was wondering if there was a possibility of loading the roads (using a polygon perhaps?) of an exact/specific country, so that DuckDB doesn't waste time generating the whole database? |
Beta Was this translation helpful? Give feedback.
Answered by
jiayuasu
Aug 23, 2023
Replies: 1 comment 1 reply
-
|
@BEAT454 This can be easily done by the GeoParquet version of OvertureMap data produced by Apache Sedona. Please refer to my blog post: https://medium.com/@dr.jiayu/harnessing-overture-maps-data-apache-sedonas-journey-from-parquet-to-geoparquet-d99f7767a499 Wherobots uses Sedona to generate these data and provide them for free. Buildings: Sedona supports geospatial filter pushdown on geoparquet so you can only download the data of a country using its real shape. Example spatial SQL queries: Try it now. This query on the 120GB Building dataset will take about 3 min to finish on the docker image. The Jupyter notebook will be available at https://localhost:8888/ |
Beta Was this translation helpful? Give feedback.
1 reply
-
|
Thank you so very much for the quick, yet effective reply! I will surely check it out. |
Beta Was this translation helpful? Give feedback.
Answer selected by
BEAT454
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
@BEAT454 This can be easily done by the GeoParquet version of OvertureMap data produced by Apache Sedona. Please refer to my blog post: https://medium.com/@dr.jiayu/harnessing-overture-maps-data-apache-sedonas-journey-from-parquet-to-geoparquet-d99f7767a499
Wherobots uses Sedona to generate these data and provide them for free.
Buildings:
s3://wherobots-public-data/overturemaps-us-west-2/release/2023-07-26-alpha.0/theme=buildings/type=buildingPlaces:
s3://wherobots-public-data/overturemaps-us-west-2/release/2023-07-26-alpha.0/theme=places/type=placeAdminBoundary:
s3://wherobots-public-data/overturemaps-us-west-2/release/2023-07-26-alpha.0/theme=admins/type=administrativeBoundaryAdminLo…