[postgis-users] psql2shp on two tables to get one shapefile...

Paul Ramsey pramsey at refractions.net
Wed Jun 25 13:24:59 PDT 2003


Yes, a temporary table (look up variants of SELECT INTO and INSERT) 
should work fine. A view might also work, but I do not know that for 
certain. Jeff?

P.

Nick Ton wrote:
> 
> Hi Everyone,
> 
> I am trying to create a shapefile where the data is based on two different
> tables.
> Has anyone done this before? Here is my problem, simplified:
> 
> -- City table contains some information, plus the_geom
> CREATE TABLE city_tbl
> (
>    city_id	int,
>    name text,
>    area_cvrg real,
>    the_geom geometry,
> 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
> complete
> CREATE TABLE city_stats_tbl
> (
>    budget	numeric,
>    population real,
>    city_id REFERENCES city_tbl
> );
> 
> One thought I had but wasn't sure if this is correct -- could I join the two
> tables
> together into a temp table, then perform a pgsql2shp on the temp table.
> Please let
> me your thoughts.
> 
> Thanks,
> Nick
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_




More information about the postgis-users mailing list