athena-sqlite
planetiler
| athena-sqlite | planetiler | |
|---|---|---|
| 1 | 30 | |
| 95 | 1,156 | |
| - | 2.5% | |
| 10.0 | 9.3 | |
| over 4 years ago | 4 days ago | |
| Python | Java | |
| Apache License 2.0 | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
athena-sqlite
-
Show HN: Mbtiles-S3-server – serve vector map tiles directly from mbtiles on S3
A while ago I wrote an Athena connector for querying SQLite in S3. ;) https://github.com/dacort/athena-sqlite Uses a similar approach.
planetiler
-
Protomaps – A free and open source map of the world
Worth mentioning this project (https://github.com/onthegomap/planetiler) that lets you create osm mbtiles and pmtiles pretty easy!
-
Radar Maps: $0.50 per 1K map loads
For a self-hosted vector tile stack you can have a look into https://github.com/onthegomap/planetiler I found it very easy to get started and when you know the other stacks it is also very fast to create these vector tiles even for planet-scale.
(note, that I'm not affiliated with them, but they use some source code from us for the efficient import and also contributed to GraphHopper, but this did not influence my experience ;) )
> I wonder why so many seem to be moving away from raster tiles to vector data.
The flexibility of styling. And you can easily serve customers that need different default languages. This makes maps also more accessible for countries without Latin alphabet.
-
I honestly don't like using most Openstreetmap websites: slow, clunky. Is there a better way to do this faster on my own desktop?
I used https://github.com/onthegomap/planetiler and https://download.geofabrik.de, maybe it helps.
- Mapping LA's Soft-Story Building Earthquake Retrofits [OC]
- Mapping LA's Soft-Story Building Earthquake Retrofit Program [OC]
-
SQLite performance tuning: concurrent reads, multiple GBs and 100k SELECTs/s
I spent a while optimizing sqlite inserts for planetiler, this is what I came up with:
https://github.com/onthegomap/planetiler/blob/db0ab02263baaa...
It batches inserts into bulk statements and is able to do writes in the 500k+ per second range, and reads are 300-400k/s using those settings.
-
How The Post is replacing Mapbox with open source solutions
Checkout https://github.com/onthegomap/planetiler.
Super easy way to generate a MBTiles, which you can then serve directly, or further convert to PMTiles, which can be used to host vector tiles for client-side rendering using MapLibre (or other renderers).
Raster tiles are a lot harder because you have to generate them on the server, and that's a lot more resource intensive.
-
Self-Hosted Vector Tiles
I built planetiler (https://github.com/onthegomap/planetiler) for this purpose. The output up to z14 is ~80gb and depending on how big of a machine you have it takes from 30 minutes up to a few hours - no DB required, just java or docker. If you are only going to z11-12, it should be quite a bit faster/smaller.
Brandon from Protomaps is also helping add pmtiles output natively to planetiler, so you won't need a conversion step afterwards!
-
Does anyone know where to find the global raster set of buildings??
It's not raster directly, but you could use planetiler ( https://github.com/onthegomap/planetiler ) to build a full planet vector map . Then you could use something like TileServer-GL to server the vector map with a style. TileServer-gl ( https://github.com/maptiler/tileserver-gl) would provide a raster source that displays in the style you set on your vector map.
-
Ask HN: Who wants to be hired? (January 2023)
I recently left Twitter after 9 years, most recently serving as tech lead for the knowledge graph group (was 45 people). I helped apply the KG to drive a large portion of Twitter’s revenue and new product launches. In my spare time I do data visualization and web mapping, most recently https://github.com/onthegomap/planetiler
What are some alternatives?
sqlite-s3-query - Python functions to query SQLite files stored on S3
openmaptiles - OpenMapTiles Vector Tile Schema Implementation
ngx_http_mbtiles_module - A nginx module to serve map tiles directly from mbtiles container files
openmaptiles-tools - Tools to turn the schema into other formats
mod_mbtiles - Serve tiles with Apache directly from an .mbtiles file
tilemaker - Make OpenStreetMap vector tiles without the stack
mbtiles-s3-server - Python server to on-the-fly extract and serve vector tiles from an mbtiles file on S3
sequentially-generate-planet-mbtiles - Generate vector tiles for the entire planet on relatively low spec hardware.
com-tiles - Streamable and read optimized file archive for hosting map tiles at global scale on a cloud object storage
headway - Self-hostable maps stack, powered by OpenStreetMap.
operations - OSMF Operations Working Group issue tracking
basemaps - NZ’s authoritative and open digital basemap service for LINZ and the public.