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

[flaviocarmo]

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-tp5768303p5768303.html
Sent from the Mapserver - Dev mailing list archive at Nabble.com.