Geoserver Extension for CKAN
custom configurations:
- geoserver.rest_url = ‘geoserver://admin:geoserver@localhost:8080/geoserver/rest’
- geoserver.default_workspace = ‘ckan’
- geoserver.workspace_name = ckan
- geoserver.workspace_uri = ‘http://localhost:5000/ckan’
Also requires this to be set:
ckan.datastore.write_url = ‘postgresql://ckanuser:pass@localhost/datastore’
Geoserver publishing (automated)
This extension contains two paster commands that can be used in conjunction with crontab & supervisor to automatically publish tier 3 data to NGDS services (Geoserver)
paster geoserver publish-ogc-redis-queue: this command will run a sql query against the database and return all eligible datasets (dataset package extra key md_package has to include NGDS Tier 3 Data, csv format: as its package extra value & it also must be tagged with a keyword that contains usgincm:) that can be published to ogc (geoserver). The ids of these datasets will be added to a redis queue (the name of the queue = publish_ogc_queue (info on redis queues and operations that can be performed on them can be found @ http://redis.io))
We run this everything 15 minutes through a cronjob (See: https://github.com/ngds/install-and-run/blob/master/rpm_install/etc/cron.d/ckan-harvest)
paster geoserver publish-ogc-worker: This command will start a worker that runs in the background. It will pop dataset ids from the redis queue and publish them to ogc (geoserver). Worker processes can be managed through supervisor (see: https://github.com/ngds/install-and-run/blob/master/rpm_install/etc/supervisord.conf)
Possible ogc publishing errors:
PUBLISH_OGC: Error Connecting to Redis while building publish_ogc_queue: check redis connection paramenters in production.ini. Also make sure that the redis server is up and running.
PUBLISH_OGC_QUEUE: There was en ERROR while pushing ids to publish_ogc_queue: this means that publish-ogs-redis-queue was not able to add datase