[postgis-users] [Fwd: Error using pgsql2shp]

[Jeff Lounsbury]

I have added support to write out null geometries into pgsql2shp and commited it
to CVS.
I have not tested every type of geometry but it is implemented for every type.

-Jeff


Paul Ramsey wrote:

> Shape files support null geometries, I am pretty sure, so we should be
> able to handle this case gracefully... I wonder if it is just the
> typechecking which cacks, or if there is code farther down the line
> which would also have to be altered. Jeff?
>
> Obe, Regina DND\MIS wrote:
> > Did you check to see if you have null values in your geometry field.  I had
> > that problem when I had null values in my geometry field, but did a view
> > leaving out the nulls and exported the view instead of the table.
> >
> > -----Original Message-----
> > From: Luis Mota [mailto:luis.mota at iscte.pt]
> > Sent: Thursday, October 10, 2002 11:02 AM
> > To: postgis-users at postgis.refractions.net
> > Subject: [postgis-users] [Fwd: Error using pgsql2shp]
> >
> >
> >   Hi.
> >
> > I sent this message about a week ago. In the meantime, I upgraded to
> > version 0.7.3, but the result is the same. Can anyone give me a hint on
> > this?
> >
> > Bye and thanks, Luís
> >
> > -------- Original Message --------
> > Subject: Error using pgsql2shp
> > Date: Thu, 03 Oct 2002 04:17:08 +0100
> > From: Luis Mota <luis.mota at iscte.pt>
> > To: postgis-users at postgis.refractions.net
> > References: <3D99BA66.EA3EBB51 at geo.unizh.ch>
> > <3D9AA5F3.F3928CD9 at geo.unizh.ch> <3D9B857E.68FB203A at refractions.net>
> > <200210021714.39833.andy at streetlight.com>
> >
> >
> >
> > Hi.
> >
> > I was trying to export one of my tables to a shapefile, issuing the command
> >
> > pgsql2shp -f /trabalho/bd/location.shp -g geom gis_teste2 location
> >
> >  but I get the following error:
> > ERROR: Cannot have multiple geometry types in a shapefile.
> >
> > What surprises me is that this table has no multiple geometry, as you
> > can see by its description, included at the end.
> >
> > Am I not understanding this correctly?
> >
> > Bye, Luís
> >
> >
> >                                            Table "location"
> >          Column          |       Type       |
> > Modifiers
> > -------------------------+------------------+-------------------------------
> > --------------------------
> >  slqtid                  | integer          | not null default
> > nextval('"location_slqtid_seq"'::text)
> >  gID                     | integer          |
> >  x                       | double precision |
> >  y                       | double precision |
> >  z                       | double precision |
> >  pcsID                   | integer          |
> >  pcsAuthor               | text             |
> >  latitude                | double precision |
> >  longitude               | double precision |
> >  height                  | double precision |
> >  gcsID                   | integer          |
> >  gcsAuthor               | text             |
> >  publicPlaceType         | text             |
> >  publicPlaceName         | text             |
> >  buildingName            | text             |
> >  buildingSubdivisionType | text             |
> >  buildingSubdivisionName | text             |
> >  numberType              | text             |
> >  doorNumber              | text             |
> >  floorName               | text             |
> >  floorSideName           | text             |
> >  zipCode                 | text             |
> >  cityName                | text             |
> >  stateName               | text             |
> >  countryName             | text             |
> >  language                | text             |
> >  geom                    | geometry         |
> >  dummy                   | boolean          | default 'f'::bool
> > Primary key: location_pkey
> > Check constraints: "$1" (srid(geom) = 20790)
> >                    "$2" ((geometrytype(geom) = 'POINT'::text) OR
> > (NULL::geometry = geom))
> > Rules: loc_insert
> > Triggers: RI_ConstraintTrigger_994633,
> >           RI_ConstraintTrigger_994631,
> >           RI_ConstraintTrigger_994621,
> >           RI_ConstraintTrigger_994619,
> >           RI_ConstraintTrigger_994609,
> >           RI_ConstraintTrigger_994607
> >
> >
> >
> >
> >
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> > _______________________________________________
> > 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
>       \_
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users