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

Charlton Purvis cplist at earthlink.net
Wed Nov 2 06:39:47 PST 2005


Sure, pop the JOIN as part of the DATA string.

Taken from the postgis page . . .

DATA "the_geom FROM (SELECT table1.the_geom AS the_geom, table1.oid AS oid,
table2.data AS data
 FROM table1 LEFT JOIN table2 ON table1.id = table2.id) AS new_table USING
UNIQUE oid USING SRID=-1"

Capitalizations count.

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Gerry Creager N5JXS
> 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





More information about the postgis-users mailing list