zawsx / opendata-api-sensor-airquality Goto Github PK

1. Install postgresql
2. Install PostGIS (sudo apt-get install postgresql-9.1-postgis)
3. Create a PostGRES database
4. Log in to the server using sudo -u postgres psql
5. CREATE USER airq WITH PASSWORD 'password';
6. CREATE DATABASE airquality;
7. GRANT ALL PRIVILEGES ON DATABASE airquality TO airq;
8. Load the PostGIS extension
9. sudo -u postgres createlang plpgsql airquality;
10. sudo -u postgres psql -d airquality -f /usr/share/postgresql/9.1/contrib/postgis-1.5/postgis.sql
11. sudo -u postgres psql -d airquality -f /usr/share/postgresql/9.1/contrib/postgis-1.5/spatial_ref_sys.sql

To connect from a remote machine setup an SSH tunnel:

ssh -L 3333:localhost:5432 [email protected]

Then you can tap into the database like so:

psql -h localhost -p 3333 airquality airq

API calls /measurements/stationID (optional limit) Get a list of measurements taken from a specific station. Limits at 1000 if one is not specified Returns stationInfo as an object and measurements as an array

/stationList Get a list of stations

/stationNear/lat/long (optional limit) Get a list of stations near a lat and long coordinate. Limits at 10 if none if specified

/last/limit Get a list of the last limit measurements