...
By enabling the Postgres plugin, you gain access to Clowder's Geostreams API. This module supports definition of Sensors, Streams and Datapoints in Clowder that allow for geospatial visualization and querying.
Installation & Initialization
- Install Postgres
- Create necessary database & roles in Postgres command-line
psql
CREATE DATABASE geostream;
CREATE ROLE clowder;
\\c geostream;
CREATE EXTENSION Postgis;
To prepare database tables, execute geostreams.sql (available on GitHub)
- Install Postgres
- Initialize the PostGIS database using SQL script in Clowder repository
https://opensource.ncsa.illinois.edu/bitbucket/projects/CATS/repos/clowder/browse/geostream.sql
psql -d
geostream -f
~/geostream.sql;
- By default, the SQL script will assign database/tables to owner 'clowder'. If you specify a different Postgres user in Clowder (see Customization below) you should make sure databases/tables are owned by that user.
- Enable Postgres plugin in Clowder In by adding the following to
clowder/custom/play.plugins
include the line:
10502:services.PostgresPlugin
Once installed you should see a "Sensors" entry in the top menu of Clowder, alongside "Help".
...
postgres.user=mediciclowder
- postgres.password=postgresPassword
Location where data for geostream API calls will be cached:
- geostream.cache=/tmp/medici
geostream.dashboard.url=
""
These properties are used when the geostreaming service returns data as type CSV instead of JSON:
json2csv.ignore=
"type,geometry|type"
json2csv.fixgeometry=
true
- json2csv.seperator=|
json2csv.hideprefix=
true
...