Color coding from two data sources

[Don Drake]

On 10/16/07, Mark Leslie <mark.leslie at lisasoft.com> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20071016/101e1247/attachment.htm>