[mapserver-users] Join from SHP file to PostgreSQL table

[Fawcett, David (MPCA)]

Flavio, 

Take a look at this page if you haven't:  http://mapserver.org/mapfile/join.html

Under 'Description', it mentions that you can't use joined data to 'affect the look of a map'.  I am pretty sure that this rules out your case.

David.

-----Original Message-----
From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of flaviocarmo
Sent: Monday, November 29, 2010 8:44 AM
To: mapserver-users at lists.osgeo.org
Subject: [mapserver-users] Join from SHP file to PostgreSQL table


Hi,

I need to make a layer with a join between a shapefile and a non-spatial
table, stored on PostgreSQL. I've found this documentation
(http://mapserver.org/mapfile/join.html) but i could make it work, so, can u
guys help me looking at this configuration and tell me whats wrong?

LAYER
         NAME "join_shape"
         TYPE POLYGON
         STATUS DEFAULT
         DATA "join_shapefile.shp"
         CLASS
               NAME "Joined Shapes"
               STYLE
                 OUTLINECOLOR 120 120 120
                 COLOR 0 30 255
               END
         END
         TOLERANCE 20
         JOIN
               NAME "teste"
               CONNECTION "dbname='testdb' host=GSERVER1 port=5432
user='test'
password='test' sslmode=disable"
               CONNECTIONTYPE ogr
               TABLE '"test"."nonspatial"'
               FROM "code"
               TO "code"
               TYPE ONE-TO-ONE
         END
       END # layer

In this layer, i want to show only the geometrys in the shapefile
"join_shapefile.shp" that have a CODE column that is the same the CODE
column in the test.nonspatial table, stored on Postgre.

That is possible?

Thanks again

Regards,

Flavio Carmo
-- 
View this message in context: http://osgeo-org.1803224.n2.nabble.com/Join-from-SHP-file-to-PostgreSQL-table-tp5784531p5784531.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