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

• Ubuntu 12/13/14
• Windows
• OSX

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):