PGRestAPI (a.k.a. Chubbs Spatial Server)
Overview
Node.js REST API for PostgreSQL Spatial Tables.
An introduction to PGRestAPI can be found here
A few key uses for PGRestAPI:
- Create Mapbox Vector Tiles on the fly from PostGIS or shapefiles. more...
- Serve pre-created Vector Tiles .mbtiles files
- Serve pre-created PNG .mbtiles files (like TileStream)
- REST API for querying Postgres tables - Supports spatial intersection, tabular queries and aggregation queries
- REST API returns GeoJSON, CSV, Shapefile or esriJSON
- Templates for creating custom web service endpoints - (Execute custom SQL functions, for example)
- Rasters in PostGIS offer basic intersect operations and zonal stats. Find sum of raster values that intersect a polygon, for example.
Utilities:
- WKT Previewer
- Server side proxy - support requests to servers that don't support CORS
Under development:
-
Better caching for different endpoints
-
Raster map services (Drop a .tif into data/rasters)
-
Authentication with passport/MongoDB/Mongoose (Disabled for now)
More To-Dos:
- Update Express and other libraries to current versions
- More tests
- Major refactoring of endpoints folder
- Break up endpoint functionality into modules
- Persistent caching
- Administrative Panel
- Editing
Soon will drop:
- PNG image creation from PostGIS Tables
- CartoCSS to Mapnik XML parser (Carto module) (this actually works, but is not used by our team)
Installation
Dependencies
- PostgreSQL 9.1 + w/ PostGIS 2.0 +
- Mapnik
Screenshots
Table/View List:
Table Details:
Query Endpoint:
Query Endpoint Results:
Dynamic Map Tile Service Endpoint:
Dynamic Vector Tile Endpoint:
Geoprocessing Operations:
Geoprocessing Operation:
Utililties - WKT Preview endpoint:
Raster Operations List:
Raster Operations - Zonal Statistics:
Tile Rendering Stats (/admin):
