tippecanoe

Not to sure how your backend is set up, but it looks like you're generating GeoJSON on the fly and the JSON serialization for this amount of data can be slow. In typical HN fashion, I would suggest looking into using Tippecanoe to generate some vector tiles of the data and host that on S3. Then the DB can fall back to performing simple lookups via the accident ID. Filtering by time will need to move to the frontend, but that should be fine (if not, look into clustering the data at further zoom levels). https://github.com/mapbox/tippecanoe

If you have any geospatial data, you can tile it with tippecanoe [0], which gives you an mbtiles file. Protomaps lets you easily convert the mbtiles file into a protomaps file which you can then use. Protomaps doesn’t limit you to any particular type of tiles, it’s just a format which allows you to read tiles out of a single file with HTTP range requests. [0] https://github.com/mapbox/tippecanoe

Author here, so there are a few options: 1) If your information belongs in OpenStreetMap, you can add it via an editor like the web editor at https://openstreetmap.org - this will also benefit all other OSM users. You can then "refresh" your Protomaps download to get a new map. 2) If there isn't many point and polygons, it may sense to add them as Leaflet layers, especially if you want them to be interactive 3) Other options are creating vector tiles of your own data and merging or displaying them in the renderer (https://github.com/mapbox/tippecanoe is a great tool to do this from GeoJSON) but I don't have much to support this yet.

At least for simple GeoJSON you can use tippecanoe (https://github.com/mapbox/tippecanoe) with --output-to-directory to get individual .pbf tiles. Most rendering clients will have some scheme where you can provide a root url and then the tiles need to be stored in some defined structure beneath that (e.g. root/z/x/y.pbf) (posted something similar to another response)

You can use tippecanoe (https://github.com/mapbox/tippecanoe) with the --output-to-directory flag to output the individual .pbf tiles instead of a single MBTiles file. These tiles can then be hosted on something like s3 and your map-rendering client can query the necessary tiles, no server required.

Thanks. My major public project for map utilities has been Tippecanoe, https://github.com/mapbox/tippecanoe

tippecanoe (also from mapbox) is fantastic software for vector tile generation. https://github.com/mapbox/tippecanoe

If your data set isn't dynamic you don't even need a tile server. You can generate the tiles with tippecanoe [1] and serve them straight out of S3. When things get too large you can keep them in the mbtile file and serve them out with an express app. I've done it in a severless environment which scales well but would get crazy expensive for any high use. [1] https://github.com/mapbox/tippecanoe

Eric (the author) built a tool to add dots to maps at scale. To say it's powerful would be an understatement https://github.com/mapbox/tippecanoe http://geohipster.com/2017/08/07/eric-fischer-may-yet-object...

For geographic data https://github.com/mapbox/tippecanoe (examples https://github.com/mapbox/tippecanoe/blob/master/MADE_WITH.m...), if I had enough time to learn a new one http://kepler.gl/ For bar charts http://www.chartjs.org/ and when requirements are more complex http://nvd3.org/ or https://d3js.org/ For time series it used to be https://omnipotent.net/jquery.sparkline/ but last release was 5 years ago.

I'm not. I usually use Tippecanoe [https://github.com/mapbox/tippecanoe] to create vector tiles with my data on, and then pick a set of raster tiles from here [http://leaflet-extras.github.io/leaflet-providers/preview/] (the Stamen ones are very nice, and also the ESRI ones are gorgeous but need you to have an ESRI license) for background and labels.