Category Archives: Geospatial Technologies

Blacklight UI for PostgreSQL and Solr – Google Group Discussion

A discussion thread I started in January, 2014: https://groups.google.com/forum/#!topic/blacklight-development/Ax0840hBeUA

Hello,

I’ve poked around a bit and did not see anything about support for geospatial search.
I became interested in Blacklight after visiting the Environment Australia Web site.
Their site is built on PostgreSQL relational database, and since it pertains to the environment, I thought they might have spatially explicit data.
They do have “Search by Region,” but it is just a linked list of regions.
Thanks for any tips,
Tanner

I got a few responses asking for more information and potential use cases so I added (in July 2014):


My opinion is any geographic representation of a collection constitutes value-added.

I am interested building a functional SKOS ontology based on the relationships between EPA ecological regions and protected areas of the United States. There are a few hierarchical levels which the ontology could describe. There are also relationships between protected areas and each ecological region.

For example, Great Smoky Mountains National Park on the North Carolina and Tennessee belongs to two main ecological regions: Ridge and Valley (67) ,and Blue Ridge (66). A full accounting of Level III ecological regions is available at <ftp://ftp.epa.gov/wed/ecoregions/cec_na/NA_LEVEL_III.pdf>.

The Level III ecological regions can be further divided into Level IV ecoregions, a higher level of granularity, available at <ftp://ftp.epa.gov/wed/ecoregions/us/Eco_Level_IV_US.pdf>.

Using the Smokies again as the exemplar, new ecological sub-regions at the Level IV resolution emerge: High mountains (66i), Southern sedimentary ridges (66e), Limestome Valleys and Coves (66f), Southern Metasedimentary mountains (66g), Broad basins (66j), and Southern Dissected Ridges and Knobs (67i), Southern sandstone ridges (67h), Southern Shale Valley (67g).

These regions can be linked via an ontology to other protected areas, allowing environmental information resources to be grouped based on meaningful ecological relationships. For example, a search in an information retrieval system for “High Mountains (66i)” would retrieve results from relevant protected areas: Roane Mountain State Park, Pisgah National Forest, Cherokee National Forest, AND Great Smoky Mountains National Park, and perhaps any location built in to the ontology as a member of the given ecological region’s footprint. This represents a sophisticated query with minimal effort on behalf of the user.

Along with providing a framework for information retrieval via “regions” as the Australia site does, the ontology would have useful text mining and automated spatial metadata creation applications.

Potential use cases include:

I wanted to do a Masters thesis on the impact of an ontology on search and retrieval, but after discussing with my thesis coordinator who indicated this was more of a PhD level undertaking, I opted to instead pursue comprehensive exams as my exit strategy.

I still think this is a worthwhile area of research and I am happy to see the example you have shared, and that there are others interested in the topic.