pg_tileserv
A very thin PostGIS-only tile server in Go. Takes in HTTP tile requests, executes SQL, returns MVT tiles. (by CrunchyData)
FastVector
A PostGIS based Vector Tile server with caching and filtering. (by mkeller3)
| pg_tileserv | FastVector | |
|---|---|---|
| 5 | 7 | |
| 801 | 45 | |
| 2.2% | - | |
| 7.0 | 0.0 | |
| 27 days ago | almost 2 years ago | |
| Go | Python | |
| Apache License 2.0 | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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.
pg_tileserv
Posts with mentions or reviews of pg_tileserv.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-08-02.
-
Generating Vector Tiles with PostGIS and Python for OpenLayers Map Rendering
Fine for a POC but there are much better libraries for serving MVT, for instance: https://github.com/CrunchyData/pg_tileserv
-
I have a shapefile with 35 fields. I need to build a web map to allow users to query it. What approach should I take
If it's small as in the couple-of-MB range you could convert to GeoJSON, serve it as a static file fed into a small web app like u/techmavengeospatial suggested that handles filtering by query, and update the file as new data comes in. Alternatively if you want something more robust you can feed it into PostgreSQL and serve with something like pg_tileserv (with equivalent filtering in the web client).
-
Making a web based map working with millions of records
ArcGIS Online could be the right move as long as you set up the service correctly. You could also load the shapefile into a database like PostgreSQL and connect to the database via an API like Geoserver FastVector, or pg_tileserv. This would cause a lot more time, cost, and knowledge on your end though to host a database and api vs loading the data into the ESRI ecosystem.
-
I made a web dashboard using Python and FOSS tools to view my Strava data, take a look!
One thing I will recommend -- because it seems like you are simple using flask to query the DB and render to the frontend (just from looking through the code) you **MAY** be able to use https://github.com/CrunchyData/pg_tileserv and cut out the need to even have flask as a the server side language. Curious what your thoughts would be because I am currently working on a few web apps and in the past i've mainly used geodjango and flask as server side but recently created an entire application with postgres, pg_tileserv, leaflet
- Indexing OSM Data on Postgres/PostGIS database
FastVector
Posts with mentions or reviews of FastVector.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-05-01.
- Generating Vector Tiles with PostGIS and Python for OpenLayers Map Rendering
- Mapbox GL JS: How to render a polygon from a postgresql? The data is store within a geodjango GeometryField
-
Tileserver specs
You can use a package I created postgresVectorTileGenerator to seed tiles at larger zoom levels and load those into a cache sitting in front your tile service. The other thing you can is simplify your data or limit the number of features per tile. You can check out an API I created called FastVector. It allows you to limit the number of features per tile and dynamically cache data as well in a filestore. This will help at the higher zoom levels for larger datasets.
-
Making a web based map working with millions of records
ArcGIS Online could be the right move as long as you set up the service correctly. You could also load the shapefile into a database like PostgreSQL and connect to the database via an API like Geoserver FastVector, or pg_tileserv. This would cause a lot more time, cost, and knowledge on your end though to host a database and api vs loading the data into the ESRI ecosystem.
-
FastGeospatial - A PostGIS geospatial api to enable geospatial queries on geographical data within a spatial database.
Good idea, were you thinking of something like a cql_filter that I used in FastVector?
- FastVector - A multi database PostGIS based vector tile server with cql filtering and caching written in Python with FastAPI.
What are some alternatives?
When comparing pg_tileserv and FastVector you can also consider the following projects:
martin - Blazing fast and lightweight PostGIS, MBtiles and PMtiles tile server, tile generation, and mbtiles tooling.
FastGeosuitability - FastGeosuitability is a PostGIS geospatial api to perform suitability analysis with geographical tables within a spatial database.
openstreetmap-carto - A general-purpose OpenStreetMap mapnik style, in CartoCSS
NG911GISDataModel - GIS Data Model templates based on the NENA Standard for NG9-1-1 GIS Data Model (NENA-STA-006.x)
Flask_Website_Project - This repo contains all the source code for my Flask based website
FastGeostats - FastGeostats is a geospatial api to perform math and statistics on tables from a multitude of PostgreSQL databases with geographical data.
FastGeofeature - FastGeofeature is a geospatial api to serve data via the OGC Features API standard.
fastapi_asyncpg - asyncpg integration for fastapi
cidr-listings
search-management-map - Plan and manage search and rescue missions
postgresVectorTileGenerator
pg_tileserv vs martin
FastVector vs FastGeosuitability
pg_tileserv vs openstreetmap-carto
FastVector vs NG911GISDataModel
pg_tileserv vs Flask_Website_Project
FastVector vs FastGeostats
FastVector vs FastGeofeature
FastVector vs fastapi_asyncpg
FastVector vs cidr-listings
FastVector vs search-management-map
FastVector vs postgresVectorTileGenerator
FastVector vs martin