[postgis-users] RE : Postgis 3 dimension geometry table

[fLaNsch at gmx.de]

Hi Francesco,

using FWTools (Open Source GIS/RS Binary Kit) offers you a really simple export.
open FWTools Shell and use the ogr2ogr Lib. 

Type something like this:


ogr2ogr -f "ESRI Shapefile" "C:/tmp/mydata.shp" PG:"host=myhost user=myloginname dbname=mydbname password=mypassword" -sql "SELECT name, the_geom FROM neighborhoods"

greetings
Simon


-------- Original-Nachricht --------
> Datum: Fri, 14 Sep 2012 11:41:01 +0200
> Von: "Francois Hugues" <hugues.francois at irstea.fr>
> An: francescoboccacci at libero.it, "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Betreff: [postgis-users] RE :  Postgis 3 dimension geometry table

> Hello,
> 
> I'm not sure to understand your question.
> 
> Did you try psql2shp ?
> 
> You could also take a look to openjump, qgis or arcgis where you can add a
> query layer and then export it to shp.
> 
> Hugues.
> 
> 
> -------- Message d'origine--------
> De: postgis-users-bounces at postgis.refractions.net de la part de
> francescoboccacci at libero.it
> Date: ven. 14/09/2012 10:47
> À: postgis-users at postgis.refractions.net
> Objet : [postgis-users] Postgis 3 dimension geometry table
>  
> Hi all,
> i have a question for you. I have a table with these properties:
> 
> CONSTRAINT enforce_dims_geometry CHECK (st_ndims(geometry) = 3),
>   CONSTRAINT enforce_geotype_geometry CHECK (geometrytype(geometry) = 
> 'MULTILINESTRING'::text OR geometry IS NULL),
> 
> i would like to export that table in shapefile or kml format (or any
> external 
> format) but i don't find a good tool to do that.
> Can you help me?Is there a way to do that?
> 
> Francesco
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>