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

[Carlos Ruiz]

Flavio,

Column names are case sensitive, have you checked this ?

Cheers from México


IC Carlos Ruiz



________________________________
From: flaviocarmo <flavio.o.carmo at gmail.com>
To: mapserver-users at lists.osgeo.org
Sent: Mon, November 29, 2010 8:43:44 AM
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



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20101129/e61390a1/attachment.html