[postgis-users] query question (probably pitifully simple)

[Obe, Regina DND\MIS]

Yes.   I'm assuming you have a station id or equivalent in both tables that
you will be joining by?

There are two ways that come to mind

1) CREATE a view where you do the join and register that view point in the
geometry_columns table.  This is good if it's a join you do commonly or is
fairly complex - that way you don't have to repeat it in all your map files.
Then you just use the view as you would any other table.

2) Do the join directly in mapserver which is well documented here
http://postgis.refractions.net/docs/ch04.html#id2512615



-----Original Message-----
From: Gerry Creager N5JXS [mailto:gerry.creager at tamu.edu] 
Sent: Wednesday, November 02, 2005 9:33 AM
To: PostGIS Users Discussion
Subject: [postgis-users] query question (probably pitifully simple)


If I have a spatially enabled table (weather station sites) with 
point-geometry and an appropriate srid, and a "regular" PostgreSQL table 
of timestamped weather observations, can I perform a query on the two 
tables, effectively doing a join, to get the surface data for display 
in, say, Mapserver?

Or, is this a better question to the mapserver list?

Thanks,
Gerry
-- 
Gerry Creager -- gerry.creager at tamu.edu
Texas Mesonet -- AATLT, Texas A&M University	
Cell: 979.229.5301 Office: 979.458.4020 FAX: 979.847.8578
Page: 979.228.0173
Office: 903A Eller Bldg, TAMU, College Station, TX 77843
_______________________________________________
postgis-users mailing list postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users