[postgis-users] psql2shp on two tables to get one shapefile.. .
Obe, Regina DND\MIS
robe.dnd at ci.boston.ma.us
Wed Jun 25 13:41:40 PDT 2003
Slight typo in my last
CREATE VIEW myview
SELECT c.*, s.budget, s.population
FROM city_tbl c INNER JOIN city_stats_tbl s ON c.city_id = s.city_id
From: Nick Ton [mailto:nton at photon.com]
Sent: Wednesday, June 25, 2003 3:40 PM
To: 'PostGIS Users Discussion'
Subject: [postgis-users] psql2shp on two tables to get one shapefile...
I am trying to create a shapefile where the data is based on two different
Has anyone done this before? Here is my problem, simplified:
-- City table contains some information, plus the_geom
CREATE TABLE city_tbl
PRIMARY KEY (city_id)
-- City statistics table contains additional information
-- that has to be linked to the city table in order to make the shapefile
CREATE TABLE city_stats_tbl
city_id REFERENCES city_tbl
One thought I had but wasn't sure if this is correct -- could I join the two
together into a temp table, then perform a pgsql2shp on the temp table.
me your thoughts.
postgis-users mailing list
postgis-users at postgis.refractions.net
More information about the postgis-users