These CKAN Versions are exactely matched:

• 2.10.0
• 2.10.1
• 2.10.2
• 2.10.3
• 2.10.4
• 2.10.5
• 2.10.6
• 2.10.7
• 2.10.8
• 2.10.9
• 2.11.0
• 2.11.1
• 2.11.2
• 2.11.3
• 2.11.4
• 2.12.0
• 2.5.0
• 2.5.1
• 2.5.2
• 2.5.3
• 2.5.4
• 2.5.5
• 2.5.6
• 2.5.7
• 2.5.8
• 2.5.9
• 2.6.0
• 2.6.1
• 2.6.2
• 2.6.3
• 2.6.4
• 2.6.5
• 2.6.6
• 2.6.7
• 2.6.8
• 2.6.9
• 2.7.0
• 2.7.1
• 2.7.10
• 2.7.11
• 2.7.12
• 2.7.2
• 2.7.3
• 2.7.4
• 2.7.5
• 2.7.6
• 2.7.7
• 2.7.8
• 2.7.9
• 2.8.0
• 2.8.1
• 2.8.10
• 2.8.11
• 2.8.12
• 2.8.2
• 2.8.3
• 2.8.4
• 2.8.5
• 2.8.6
• 2.8.7
• 2.8.8
• 2.8.9
• 2.9.0
• 2.9.0a
• 2.9.1
• 2.9.10
• 2.9.11
• 2.9.13
• 2.9.2
• 2.9.3
• 2.9.4
• 2.9.5
• 2.9.6
• 2.9.7
• 2.9.8
• 2.9.9

ckanext-dataspatial

⚠️ This extension is no longer maintained. (Archived on Nov 26, 2019)

A CKAN extension that provides geospatial awareness of datastore data.

Overview

NB: This extension is unmaintained. There have been some syntax updates so it should work with CKAN 2.8+, but it hasn’t been tested and is not currently in use by the Museum.

This extension provides geospatial awareness of datastore data. This includes:

• Geospatial searches within datasets
• Spatial extent of datastore searches
• Support for PostGIS
• Support for Solr via the ckanext-datasolr extension

Installation

1. Clone the repository into the src folder:

cd $INSTALL_FOLDER/src
git clone https://github.com/NaturalHistoryMuseum/ckanext-dataspatial.git

2. Activate the virtual env and install requirements:

. $INSTALL_FOLDER/bin/activate
cd $INSTALL_FOLDER/src/ckanext-dataspatial
pip install -r requirements.txt
python setup.py develop

3. Add ‘dataspatial’ to the list of plugins in your config file.

Configuration

# Backend for query_extent queries ('postgis' or 'solr'), default: postgis
dataspatial.query_extent = postgis

# WGS data field in PostGIS database, default: _geom
dataspatial.postgis.field = _geom

# Mercator field in PostGIS database, default: _the_geom_webmercator
dataspatial.postgis.mercator_field = _the_geom_webmercator

# For Solr (requires ckanext-datasolr)
dataspatial.solr.index_field = _geom
dataspatial.solr.latitude_field = latitude
dataspatial.solr.longitude_field = longitude

Actions

• create_geom_columns: Creates PostGIS columns on a resource table
• update_geom_columns: Updates geospatial columns when a row is updated
• datastore_search: Supports filtering by WKT polygon using _tmgeom filter
• datastore_query_extent: Returns geospatial extent of query results

Commands

# Create PostGIS columns
paster --plugin=ckanext-dataspatial dataspatial create-columns $RESOURCE_ID -c $CONFIG_FILE

# Create index
paster --plugin=ckanext-dataspatial dataspatial create-index $RESOURCE_ID -c $CONFIG_FILE

# Populate columns from lat/long
paster --plugin=ckanext-dataspatial dataspatial populate-columns $RESOURCE_ID -l $LATITUDE_COLUMN -g $LONGITUDE_COLUMN -c $CONFIG_FILE

Further Setup

PostGIS

Your PostgreSQL database must have PostGIS support installed.

Solr

Requires the ckanext-datasolr extension for Solr support.