PGRestAPI (a.k.a. Chubbs Spatial Server)

Overview

Node.js REST API for PostgreSQL Spatial Entities.

Point it at your instance of PostgreSQL and PostGIS, and you'll get a REST API that supports:

• Dynamic Tiled Map Services for spatial tables using Mapnik (Not for Windows installs, yet)
• Dynamic Vector Tile Services for spatial tables using Mapnik (Not for Windows installs, yet)
• RESTful Query endpoint for each table and view - return GeoJSON, esriJSON or Shapefile. Supports spatial and tabular queries and aggregation.
• Geoprocessing Framework - (You still have to know how to write PostGIS logic, but...), with dynamic tiled maps available as output.
• Route Caching for .pngs
• Admin panel (/admin) to show tile generation statistics and cache size
• Shapefile List (/shapefiles) to display shapefiles being served as map services

Utilities:

• WKT Previewer

Under development:

• GeoJSON to .png endpoint
• Better caching for different endpoints
• In-memory map services (Loads a Shapefile into memory for faster response times. Drop shapefiles into endpoints/mapnik/data/inmemory-shapefiles)
• Raster map services (Drop a .tif into endpoints/mapnik/data/rasters)
• Shapefile map services ((Drop shapefiles into endpoints/mapnik/data/shapefiles)
• Datablaster - Sort of an ETL to pregenerate .json/.geojson files for use in your applications (similar to how Jeckyll produces HTML/CSS/Javascirpt)
• Authentication with passport/MongoDB/Mongoose (Disabled for now)
• Vector Tiles endpoint for serving .tm2 or .mbtiles sources (not working yet)

More To-Dos:

• CartoCSS to Mapnik XML parser (Carto module)
• Persistent caching
• Administrative Panel

Express, Jade and general structure based on: Project is structured based on http://www.bearfruit.org/2013/06/21/start-a-new-node-js-express-app-the-right-way/

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