{"repo":"igor-suhorukov/openstreetmap_h3","free":true,"listed":false,"github":"https://github.com/igor-suhorukov/openstreetmap_h3","clone":"git clone https://github.com/igor-suhorukov/openstreetmap_h3.git","description":"OSM planet dump high performance data loader. Transform OpenStreetMap World/Region PBF dump into partitioned by H3 regions PostGIS pgsnapshot (lossless) OSM schema representation and/or into ArrowIPC/Parquet dumps","language":"Java","stars":98,"topics":["apache-arrow","arrow","duckdb","geometry-processing","geospatial","java","openstreetmap","parquet","pbf","postgis"],"license":"Apache-2.0","category":"deployment-docker-iac","readme_excerpt":"openstreetmap h3 OSM planet dump high performance data loader. Transform OpenStreetMap World/Region PBF dump into partitioned by H3 regions PostGIS pgsnapshot (lossless) OSM schema representation and/or into ArrowIPC/Parquet dumps with schema. \"columnar storage\" option activate Citus columnar storage in PostgreSQL to speedup aggregation queries. More details in blog posts... Build and run in Docker Build and run in JVM: Usage details: Run: Run PostGIS and import data: Apache Parquet export Parquet export activated with \"-arrow format PARQUET\" command line parameter. OpenStreetMap H3 also allows you to convert data to Apache Parquet and process it in Hadoop and Apache Spark/Sedona. In this project, it allows you to do the same as osm-parquetizer but with additional data and collected geo coordinates for ways, as well as enriched h3 geo indexes. The files are successfully uploaded to the DuckDB Geo extension, I checked this and I will tell you the details in the publication. Node: Way: Relation: Multipolygon: Use case diagram Project flowchart diagram","default_branch":null,"files":null,"tree":[],"storefront":"/r/igor-suhorukov","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/igor-suhorukov/openstreetmap_h3/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}