On 10/16/07, Mark Leslie <[EMAIL PROTECTED]> wrote: > > Don Drake wrote: > > Here's my scenario, I have shapefiles containing polygons of > zipcodes. I > > have a table in Postgres that has a zip code with data that I would like > to > > thematically map. I am not interested in loading the zipcodes into > PostGIS > > if I don't have to. I am using PHP/Mapscript, and I was wondering if > there > > is a way to merge the Postgres data with the shapefile layer on a map? > > > > Thanks. > > > > -Don > > > > That depends what you mean by 'merge'. If you want to display both in > the same layer, you can come close by defining two layers in the same > group (see the GROUP item at > http://mapserver.gis.umn.edu/docs/reference/mapfile/layer). If you want > to join the two sources together, Jeff has a nice example in the > reference docs > ( > http://mapserver.gis.umn.edu/docs/reference/mapfile/join#example-2-join-from-shp-file-to-postgresql-table > ). > If I've missed the point entirely, then I'll need some more details > about what you're trying to end up with. > > Mark Leslie > LISAsoft > www.lisasoft.com >
Very interesting. It looks like the second link is close to what I need, the first is not what I need. 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. If this would work, could I color code using an expression? Is there a Mapscript alternative? Thanks. -Don
