[Geotools-devel] combining data from different sources?

[William S. <wst...@wh...>]

Hi all,

Congrats on your upcoming beta release!

I'm wondering: Is it possible in GT2 at present to do relational "joins" between different datasources? For example, I'm working with a bottow trawl survey database (well, a collection of related dBase tables). There's a shapefile with station locations (point features) and station ids as fields.  I also have a dBase table that has station id field (a foreign key to the shapefile), a species field, and a catch-by-species field.  

First, can GT2 handle non-spatial data (e.g., a dBase table) from the DataSource (or any other) perspective?

Second, is it possible to create a feature collection by "joining" the shapefile and dBase table (as DataSources or FeatureCollections) based on their mutual station id codes using the GT2 API?  

Thanks!

Buck Stockhausen
-- 
************************************************************************
*William T. Stockhausen, Ph.D.     |email: Wil...@no...*
*NRC Postdoctoral Fellow           |voice: 508-289-2238                *
*Northeast Fisheries Science Center|fax:   508-457-2169                *
*National Marine Fisheries Service |web:   http://www.nefsc.noaa.gov   *
*                                  |       http://www.usglobec.org     *
*__________________________________|___________________________________*
*              mailing address:     National Marine Fisheries Service  *
*                                   166 Water Street                   *
*                                   Woods Hole, MA 02543-1026          *
************************************************************************