[postgis-users] [Fwd: Error using pgsql2shp]
Luis Mota
luis.mota at iscte.pt
Thu Oct 10 08:14:36 PDT 2002
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
>
More information about the postgis-users
mailing list