Thanks Steve. I do believe that is the tree I need to be barking up. Now
just to figure it all out. Thanks for your help!
On Aug 3, 2011 12:50 PM, "Stephen V. Mather" <[email protected]>
wrote:
> 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
>
>
>
------------------------------------------------------------------------------
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
