Hi Jason,
GeoServer can read in SQL views (views can also be created
and used from within GeoServer).Steve http://www.clemetparks.com/images/esig/cmp-ms-90x122.pngStephen Mather Geographic Information Systems (GIS) Manager (216) 635-3243 [email protected] <http://www.clemetparks.com/> clevelandmetroparks.com From: Jason Wheatley [mailto:[email protected]] Sent: Wednesday, August 03, 2011 10:55 AM To: [email protected]; [email protected] Subject: Re: Accessing related tables I don't know if that is exactly what I'm looking for... Though good to know for formatting once I get the functionality worked out. What I have is a point layer (Ex. Street Intersection Centroid), each with a primary key (ex. X_ID). I also have just a table (object class) that is storing the file names of all of the photos for all of the intersection points. There are several photos for each point, and this table is related to the point layer via an foreign key of the (X_ID), many photos to one intersection. What I am looking to do, is to populate the API with the point data and upon clicking, displays table data that is appended to the point file. Also, however, I would like to display the related photos (either as tabular links or as thumbs) for the intersection point clicked. So referencing not only the data on the point file itself, but also the data within it's related tables. Thanks for any help! On Wed, Aug 3, 2011 at 9:34 AM, Stephen V. Mather <[email protected]> wrote: If I understand the query, you would like to be able to click on the map, get associated information in e.g. a pop-up, including a photo. You might look to GetFeatureInfo templates, e.g. http://docs.geoserver.org/latest/en/user/tutorials/GetFeatureInfo/index.html . Steve http://www.clemetparks.com/images/esig/cmp-ms-90x122.pngStephen Mather Geographic Information Systems (GIS) Manager (216) 635-3243 <tel:%28216%29%20635-3243> [email protected] <http://www.clemetparks.com/> clevelandmetroparks.com From: Jason Wheatley [mailto:[email protected]] Sent: Wednesday, August 03, 2011 9:28 AM To: [email protected] Subject: [Geoserver-users] Accessing related tables Hello all, I've been messing around with OS solutions for about 6 months now and loving it. <Preface: as I am a noob to geoserver/>. I would like to leverage GeoServer/OpenLayers for a web solution I'm currently working on, and I'm not sure how to accomplish accessing related information through geoserver/openlayers. The scenario is I have point data that is linked at table of photos (1-M). I would like to be able to click the point data on the map and have access in some form to the related photo information. This is something I've been struggling with for some time. Previous "workarounds" have been to generate an HTML page that contains the images, linked to the point data. Maintenance nightmare! Seems like such a simple functionality, though I just don't have the know-how to make it happen. Any help would be greatly appreciated. Jason M. Wheatley -- Jason M. Wheatley, GISP Senior GIS Analyst Century Engineering, Inc. Hunt Valley, Maryland
<<image001.png>>
------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA The must-attend event for mobile developers. Connect with experts. Get tools for creating Super Apps. See the latest technologies. Sessions, hands-on labs, demos & much more. Register early & save! http://p.sf.net/sfu/rim-blackberry-1
_______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
