<br><div><span class="gmail_quote">On 10/16/07, <b class="gmail_sendername">Mark Leslie</b> <<a href="mailto:mark.leslie@lisasoft.com">mark.leslie@lisasoft.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Don Drake wrote:<br>> Here's my scenario, I have shapefiles containing polygons of zipcodes. I<br>> have a table in Postgres that has a zip code with data that I would like to<br>> thematically map. I am not interested in loading the zipcodes into PostGIS
<br>> if I don't have to. I am using PHP/Mapscript, and I was wondering if there<br>> is a way to merge the Postgres data with the shapefile layer on a map?<br>><br>> Thanks.<br>><br>> -Don<br>><br>
<br>That depends what you mean by 'merge'. If you want to display both in<br>the same layer, you can come close by defining two layers in the same<br>group (see the GROUP item at<br><a href="http://mapserver.gis.umn.edu/docs/reference/mapfile/layer">
http://mapserver.gis.umn.edu/docs/reference/mapfile/layer</a>). If you want<br>to join the two sources together, Jeff has a nice example in the<br>reference docs<br>(<a href="http://mapserver.gis.umn.edu/docs/reference/mapfile/join#example-2-join-from-shp-file-to-postgresql-table">
http://mapserver.gis.umn.edu/docs/reference/mapfile/join#example-2-join-from-shp-file-to-postgresql-table</a>).<br>If I've missed the point entirely, then I'll need some more details<br>about what you're trying to end up with.
<br><br>Mark Leslie<br>LISAsoft<br><a href="http://www.lisasoft.com">www.lisasoft.com</a><br></blockquote></div><br>Very interesting. It looks like the second link is close to what I need, the first is not what I need.<br>
<br>The thing is that the postgres table the data is coming out of does not have a geometry column, the key is the zipcode. Furthermore, it will probably come from a query, or a view. I tried using a view with no geometry and could not get it to work. The geometry will come from a shapefile.
<br><br>If this would work, could I color code using an expression? Is there a Mapscript alternative?<br><br>Thanks.<br><br>-Don<br><br>