Creating geo-referenced article collections using JEO's content API

• Editors
• Contributors willing to add geo-referenced contents to the CKAN database

• How to use JEO's Content API for filtering related content and compile a collection of Wordpress posts into a GEOJSON file.
• How to upload the GEOJSON file into the CKAN database

• JEO parent theme comes with a great range of useful tools for creating data-driven journalism-oriented websites. One of them is called the content API.
• Parent themes can be customized by implementing a child theme, which inherits the functionality of its parent adding graphical customization elements on top of it.
• At http://www.opendevelopmentmekong.net we are using both JEO parent and child themes.

Users can access this functionality by navigaing to the following URL http://opendevelopmentmekong.net/?s=Energy (replacing Energy with whatever search term) or by clicking the “GO TO ADVANCED SEARCH” button that appears after inputting some text in the main search bar.

In that particular screen, Editors can filter out the contents of the whole country site by means of the following fields:

• Text search: Textual search.
• Categories: Only show posts belonging to the selected categories.
• Content type: Only show posts belonging to the selected Post types.
• Date range: Filter posts by publication date.

Once the filter criteria has been specified and the Filter button clicked, a list of result will be presented on the screen. Now editors have the possibility to compile the resulting posts into a single geojson file, that will include information such as the title or description accompaigned by geographic information (latitude, longitude). The virtue of this way of collecting data is that the geojson format is machine-readable and provides structured data, which can facilitate the work to developers, researchers or journalists willing to integrate in their workflow contents provided on opendevelopmentmekong.net.

On the same screen, but also in several elements across the platform, User will notice the following buttons:

These buttons provide following functionality:

• RSS Feed: Generates a RSS-compliant XML formatted feed with the contents of the articles filtered.
• Get geojson: Outputs the contents of the filtered articles in geojson format. The interesting aspect of this feature is that the content is dynamic, meaning that if new contents get added to the platform which meet the specified criteria, they will be exposed through the same URL.
• Download: Generates a geojson file that can be downloaded by the user.

After filtering out relevant information and compiling it into a geojson files, editors can follow the Content generation guide for uploading it to CKAN and expose it to users.