timothyclemansinsea/soql-for-cartodb

This is a SoQL emulator for CartoDB

soda-postgres

Uses node-soda2-parser to provide a Socrata-style SODA2 API in front of a postgres database

Installation

1. Clone the repo
2. Install dependencies via npm install
3. Create a copy of .env.sample named .env and fill in the values, pointing it to a postgres database with postgis enabled

git clone https://github.com/timothyclemansinsea/soql-for-cartodb.git
cd soql-for-cartodb/
npm install

Usage

To run a SODA2 API server, use node index.js Then query the API using SODA2 calls, ie. http://localhost:8080/resource/table_name?$select=*&zip_code=19141

Examples

A demo server with the Heart Healthy Screening Sites dataset provides the following examples.

• [$select=zip_code, screening_type, geom](http://104.236.214.217/resource/sites?$select=zip_code, screening_type, geom)
• $select=zip_code, count(*)&$group=zip_code
• [$select=convex_hull(geom) AS hull&zip_code=19146](http://104.236.214.217/resource/sites?$select=convex_hull(geom) AS hull&zip_code=19146)
• $where=within_box(geom, -75.182324, 39.949259, -75.170769, 39.934494)
• $where=within_circle(geom, -75.163406, 39.952503, 1000)
• $where=within_polygon(geom, 'MULTIPOLYGON (((-75.184290 39.926206,-75.168267 39.930942,-75.159473 39.923000,-75.171159 39.917874,-75.184290 39.926206)))')