Hi,
I am not sure I am sending this to the right list or not. So please let me know if I should send to another list.
We have a shapefile that has country boundaries. Then we have a dbf table that has data that could be related to the country shapefile by country code. This is a one-to-many relationship. What we would like to do is be able to send a wfs query about the country the user selects, and return the multiple records from the dbf file that meet this query. So the user selects China and all of the records from the dbf for China are returned.
I am having a difficult time figuring out where this “relate” should occur (possibly inside a spatial database, or with geoserver) and exactly how to do this. Could someone suggest a way to do a one-to-many relate with either geoserver or postgis?
Please let me know if you need clarification on what we are trying to do. We are using PostGIS, Geoserver, Mapbuilder.
Thanks in advance for your help.
Scott