[mapserver-users] Mapserver JOIN to html template

[Marco Afonso]

Hello Pierre,

I don't know how is your database designed to get redundant geometries as
you said...

We here also use relations and views on PostgreSQL and it works pretty
fine. Look at this simple example to get the geometry from table1, and a
label from table2:

CREATE OR REPLACE VIEW my_view AS
 SELECT table1.gid, table1.the_geom, table2.label1
   FROM table1
   LEFT JOIN table2 ON table2.id = table1.table2_id;

2016-03-14 12:02 GMT+00:00 pe_lord <pe_lord at yahoo.ca>:

> 1- Concerning view, at this time, I don't want to plan to make view
> because,
> if I create view, I will get redundant geometries, resulting varying
> numbers
> of geometries between 1 an M possiblities... And My example is based on
> only
> 1 table. I plan to make 1:M relationships with 5-6 others tables. If I'm
> wrong, tell my!
>
> 2- About OIDs, every table has OIDs. I've loaded my datasets with ogr2ogr
> from esri filegdb.
>
> 3- Concerning others manipulation. I didn't try at this time,  I will try
> it
> soon. Before, I will test 2 things:
> 3A- Log SQL query from PG to see if there is not a baq query sent by
> Mpaserver to PG.
> 3B- Update Mapserver to 7.
>
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/Mapserver-JOIN-to-html-template-tp5255688p5256205.html
> Sent from the Mapserver - User mailing list archive at Nabble.com.
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>



-- 
Regards,
Marco Afonso
http://goo.gl/ZDtQjm
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20160314/7f128eaa/attachment.html>