<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt">Flavio,<br><br>Column names are case sensitive, have you checked this ?<br><br>Cheers from México<br><br><div style="font-weight: bold; color: rgb(0, 96, 191);">IC Carlos Ruiz</div><div style="font-family: arial,helvetica,sans-serif; font-size: 10pt;"><br style="font-weight: bold; color: rgb(0, 96, 191);"><div style="font-family: arial,helvetica,sans-serif; font-size: 13px;"><font face="Tahoma" size="2"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> flaviocarmo <flavio.o.carmo@gmail.com><br><b><span style="font-weight: bold;">To:</span></b> mapserver-users@lists.osgeo.org<br><b><span style="font-weight: bold;">Sent:</span></b> Mon, November 29, 2010 8:43:44 AM<br><b><span style="font-weight: bold;">Subject:</span></b> [mapserver-users] Join from SHP file to PostgreSQL
table<br></font><br>
<br>Hi,<br><br>I need to make a layer with a join between a shapefile and a non-spatial<br>table, stored on PostgreSQL. I've found this documentation<br><span>(<a target="_blank" href="http://mapserver.org/mapfile/join.html">http://mapserver.org/mapfile/join.html</a>) but i could make it work, so, can u</span><br>guys help me looking at this configuration and tell me whats wrong?<br><br>LAYER<br> NAME "join_shape"<br> TYPE POLYGON<br> STATUS DEFAULT<br> DATA "join_shapefile.shp"<br> CLASS<br> NAME "Joined Shapes"<br> STYLE<br> OUTLINECOLOR 120 120 120<br> COLOR 0 30 255<br>
END<br> END<br> TOLERANCE 20<br> JOIN<br> NAME "teste"<br> CONNECTION "dbname='testdb' host=GSERVER1 port=5432<br>user='test'<br>password='test' sslmode=disable"<br> CONNECTIONTYPE ogr<br> TABLE '"test"."nonspatial"'<br> FROM "code"<br> TO "code"<br> TYPE ONE-TO-ONE<br> END<br> END # layer<br><br>In this layer, i want to show only the geometrys in the shapefile<br>"join_shapefile.shp" that have a CODE column that is the same the CODE<br>column in the test.nonspatial
table, stored on Postgre.<br><br>That is possible?<br><br>Thanks again<br><br>Regards,<br><br>Flavio Carmo<br>-- <br><span>View this message in context: <a target="_blank" href="http://osgeo-org.1803224.n2.nabble.com/Join-from-SHP-file-to-PostgreSQL-table-tp5784531p5784531.html">http://osgeo-org.1803224.n2.nabble.com/Join-from-SHP-file-to-PostgreSQL-table-tp5784531p5784531.html</a></span><br>Sent from the Mapserver - User mailing list archive at <a target="_blank" href="http://Nabble.com">Nabble.com</a>.<br>_______________________________________________<br>mapserver-users mailing list<br><a ymailto="mailto:mapserver-users@lists.osgeo.org" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br><span><a target="_blank" href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a></span><br></div></div>
</div><br>
</body></html>