GeoJoin

Categories

Component ID

2202159

Component name

GeoJoin

Component type

module

Maintenance status

Development status

Component security advisory coverage

not-covered

Component created

Component changed

Component body

This module expands Views join functionality to include spatial operators. Aims to be compatible with various underlying spatial data structures such as GeoField, GeoPHP and PostGIS. Users of GeoJoin will add spatial relationships via the "Relationships -> Add" menus in Views.

Current Version Supports:

1. Join Operators: Overlaps, Within, Contains, and Intersects - Will join features in a single GeoField instance based on operator selected in Relationship UI dialog. Features must have the same SRID - two features with NULL SRID will not match.

2. PostGIS / MySQL Detection - tests for "GeomFromText" method in mysql databases and Postgis_Version in PostgreSQL databases in the relationship -> query() method, otherwise query() returns false.

INSTALLATION

----------------

Un-pack geoJoin tar in your module directory and then enable on the admin modules page.

Author:

----------------

Robert Burgholzer

ROADMAP

-----------------

  1. Auto-detect Binary versus WKT storage in GeoField. GeoField has evolved to default to WKB storage now, GeoJoin needs to be able to determine what the storage is and omit/include the "geomFromText" conversion as necessary.
  2. Use "&&" operator when PostGIS present to enable index use (does MySQL have similar function?).
  3. Multiple GeoField - permit joins among multiple GeoFields that are stored in separate tables in the database backend.
  4. Spatial Indexing in GeoField - develop an index table structure that permits spatial indexing of overlaps, intersections and containments. Add cron and hook_field_update/hook_field_insert support for re-indexing/indexing.