[postgis] Re: How to use pgsql2shp
lr1234567 at yahoo.com
Thu Dec 6 09:21:05 PST 2001
That part I understand about the limitation of shp, but the geometry
table I was joining with only has one type of geometry
(multipolygons) - and that is the geometry field I am selecting in my
view. The other table I am joining with has no geometries.
My view query looks something like this
SELECT ap.*, l.the_geom
FROM ap INNER JOIN landparcels l ON ap.parcelid = l.parcelid
landparcels is the one with the geometry field of type multipolygon
and ap has no geometries - just a simple postgres table.
I assumed that if I defined my new table remsactive setting the
geometry type the same as my landparcels, I would only have one type
Note that if I try to dump out landparcels using pgsql2shp it works
fine. Or is the fact that I am inserting from a view posing a
--- In postgis at y..., jeff lounsbury <jeffloun at r...> wrote:
> This is simply a limitation of the .shp format. The format only
allows a file
> to consists of homogeneous shape types.
> eg all Points , all MultiPolygons etc...
> What you can do if you really need the shapes in .shp format is
> different types in separate PostGIS tables and then dump each of
> The other possibility is converting all the shapes to the most
> eg. Just call points multipoints so you can have a single
> file. If the types are very different like points and mutipolygons,
> probably not work though.
> lr1234567 wrote:
> > Is there a particular structure that pgsql2shp is expecting
> > When I try to use it on a table I created it generates the dbf
> > but can't generate the shp file
> > It states as an error, can not have multiple geometry types in a
> > shape file.
> > It works fine on tables I generated using the shp2pgsql loader.
> > The way I created and populated the table I'm trying to dump out
> > as follows
> > create table remsactive ( PARCELID varchar(10), ADDRESS varchar,
> > NEIGHBORHO varchar, USE varchar, TYPE varchar, STATUS varchar,
> > LOTAREA int);
> > select AddGeometryColumn
> > ('dts','remsactive','the_geom','102686','MULTIPOLYGON',2);
> > INSERT INTO remsactive(gid, parcelid, address, neighborho,use,
> > status, lotarea, the_geom)
> > SELECT gid, parcelid, address,neighborhood, cuse, propertytype,
> > status, sqfeet,the_geom
> > FROM vwavailableparcels;
> > _______
> > the vwavailableparcels is a view I set up that joins a table of
> > multipolygon geometries I loaded from a shape file with a non-
> > geometry table.
> > To unsubscribe from this group, send an email to:
> > postgis-unsubscribe at y...
> > Your use of Yahoo! Groups is subject to
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Tiny Wireless Camera under $80!
Order Now! FREE VCR Commander!
Click Here - Only 1 Day Left!
To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
More information about the postgis-users