[Geomoose-users] Linking search results to templates

[Brent Fraser]

Bob,


   Depends on the data.  Are there usually 4 photos? If so, just create 
4 columns in the Site table and populate them with the path to photos.  
If it is more variable (sometimes 1, sometimes 5 photos), create a table 
to relate Sites to Photos:

SitePhotos
-----------
siteID:    photoPath:
1234    1234Front.jpg
1234    1234Rear.jpg

and do a table join within Mapserver's Map file (in the LAYER's DATA 
statement) to relate sites to tables.

Best Regards,
Brent Fraser

On 4/9/2013 1:14 PM, Bistrais, Bob wrote:
>
> I'm working on an application which depicts various sites (several 
> thousand of them).  The customer has photos of the different sites, 
> each site usually has 4 pictures, from different angles.  The spatial 
> data does not have an attribute linking the photos to a particular 
> record. But each photo has the site ID as part of its name.  Example- 
> Site 1234 has photos with names like "1234Front.jpg", "1234Rear.jpg", etc.
>
> What I'd like to do is display search/query results so that the 
> corresponding photos (actually, links to them) will appear in an 
> Identify or query result tab.  I can form the URL's based on the 
> site's ID number, but don't know how to insert these into the 
> identify/query templates.
>
> Has anyone done something similar to this, and would have any advice 
> on how to do this?
>
>
>
> _______________________________________________
> Geomoose-users mailing list
> Geomoose-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/geomoose-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/geomoose-users/attachments/20130409/2c847c98/attachment.html>