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

[Paul Ramsey]

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
      \_