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

[Luis Mota]

That was it. I created the view and everything worked fine.

Thanks for the tip!

Bye, Luís

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
>