Changes between Version 13 and Version 14 of Cookbook gdal

Timestamp:

Jan 29, 2010 11:39:33 AM (15 years ago)

Author:

cedric

Comment:

--

Cookbook gdal

@@ -10 +10 @@
 gdal comes with two main tools (executable files), the command files for gdal are in C:\OSGeo4W\share\gdal
  call >cmd
-{{{C:\OSGeo4W\bin\ogr2ogr
+{{{
+C:\OSGeo4W\bin\ogr2ogr
 }}}
 or 
-{{{C:\OSGeo4W\bin\ogrinfo
+{{{
+C:\OSGeo4W\bin\ogrinfo
 }}}
 
@@ -46 +48 @@
 Sometimes you have more than one geometry field in a table, and ESRI shape can only support one geometry field per shape. Also you may only want a subset of data. In these cases, you will need to select the geometry field to use. The most flexible way to do this is to use the -sql command which will take any sql statement.
 {{{
-C:\OSGeo4W\bin\ogr2ogr -f "ESRI Shapefile" C:\base\basesig\essai1.shp PG:"host=locahost user=postgres dbname=CCM password=postgres port=5433" -sql "SELECT gid, the_geom FROM riversegments"
+C:\OSGeo4W\bin\ogr2ogr -f "ESRI Shapefile" C:\base\basesig\essai1 PG:"host=locahost user=postgres dbname=CCM password=postgres port=5433" -sql "SELECT gid, the_geom FROM riversegments"
 }}}
-'' Cedric : ne marche pas, j'obtiens un message du type  Unable to open datasource with following drivers, celui là on l'a très très souvent''[[BR]]
-Example snippet converting from PostGIS to KML
-ogr2ogr -f "KML" neighborhoods.kml PG:"host=myhost user=myloginname dbname=mydbname password=mypassword" -sql "select gid, name, the_geom from neighborhoods"
-The below outputs the neighborhood table to KML and sets the KML description field to name of neighborhood
-ogr2ogr -f "KML" neighborhoods.kml PG:"host=myhost user=myloginname dbname=mydbname password=mypassword" neighborhoods -dsco NameField=name
-Exporting multiple tables from PostGIS using Ogr2Ogr
+'' Cedric : ne marche pas, j'obtiens un message du type  Unable to open datasource with following drivers, celui là on l'a très très souvent, j'ai essayé plusieurs trucs je ne comprends pas, la requete marche dans pgadmin''[[BR]]
 
-One way in which ogr2ogr excels above using the pgsql2shp tool is that ogr2ogr can export multiple tables at once. This is pretty handy for sharing your postgis data with others who do not have a postgis database.
+''' One way in which ogr2ogr excels above using the pgsql2shp tool is that ogr2ogr can export multiple tables at once. This is pretty handy for sharing your postgis data with others who do not have a postgis database. '''
 
 The code below will export all your postgis tables out into a folder called mydatadump in ESRI shape (shp) format.
-ogr2ogr -f "ESRI Shapefile" mydatadump PG:"host=myhost user=myloginname dbname=mydbname password=mypassword"
+{{{
+ogr2ogr -f "ESRI Shapefile" essai2 PG:"host=locahost user=postgres dbname=CCM password=postgres port=5433"
+}}}
 
-The code below will export all your postgis tables out into a folder called mydatadump in MapInfo .tab format.
-ogr2ogr -f "MapInfo File" mydatadump PG:"host=myhost user=myloginname dbname=mydbname password=mypassword"
 
 Now most of the time you probably only want to output a subset of your postgis tables rather than all your tables. This code exports only the neighborhoods and parcels tables to a folder called mydatadump in ESRI shapefile format