[gdal-dev] exporting PostGIS to GMT format

Seb spluque at gmail.com
Fri Nov 9 11:59:53 PST 2012


Hi,

I'm trying to export a PostGIS table in GMT format, following a tip
(http://comments.gmane.org/gmane.comp.gis.gmt.user/16632), but I'm
running into problems.

Here's ogrinfo output:

---<--------------------cut here---------------start------------------->---
ogrinfo PG:"host=localhost user=user password=password dbname=gshhs" subset_c
INFO: Open of `PG:host=localhost user=user password=password dbname=gshhs'
      using driver `PostgreSQL' successful.

Layer name: subset_c
Geometry: Unknown (any)
Feature Count: 1
Extent: (-75.000000, 54.000000) - (-57.334194, 62.482194)
Layer SRS WKT:
(unknown)
Geometry Column = geom
gid: Integer (0.0)
OGRFeature(subset_c):0
  gid (Integer) = 4
  MULTIPOLYGON (((-75.0 62.183672426395042,-74.532194 62.106944,-73.69475 62.482194,-72.270722 61.574167,-71.554583 61.617194,-71.619694 61.153556,-69.897417 60.799278,-69.504083 61.067639,-69.617306 60.071444,-70.874722 60.045917,-69.7175 59.966639,-69.761167 59.321556,-69.238028 59.322944,-69.546111 58.809111,-69.846389 59.059944,-70.255556 58.777222,-68.348472 58.781583,-68.684778 58.002583,-68.007639 58.584861,-67.674667 58.015111,-66.376944 58.854833,-65.970944 58.272667,-66.086417 58.818361,-65.315472 59.045722,-65.747667 59.270528,-65.013889 59.383472,-65.536667 59.745694,-64.848444 60.372917,-64.367528 60.246667,-64.699167 60.024972,-63.357556 59.1975,-64.050889 59.019167,-63.138306 59.054556,-62.8525 58.700806,-63.607556 58.291667,-62.557583 58.479972,-63.355861 57.969139,-62.45 58.172889,-62.679194 57.929139,-61.8925 57.6325,-62.532556 57.489139,-61.3625 57.099972,-61.671694 56.618722,-62.539222 56.755806,-61.650833 56.539194,-62.22425 56.471639,-61.580806 56.2825,-62.02675 56.226278,-61.320861 56.224139,-61.753306 55.964556,-60.595 55.812083,-60.67 55.54875,-60.322583 55.7775,-60.695833 54.986667,-59.778333 55.335389,-59.987528 55.107472,-59.415889 55.158333,-59.935028 54.744556,-59.196639 55.239528,-59.405 54.968694,-59.028417 55.154556,-58.973361 54.827083,-57.943361 54.930389,-58.189194 54.748333,-57.334194 54.580806,-59.593361 54.037111,-58.380889 54.2275,-58.935126371828702 54.0,-75 54,-75.0 62.183672426395042)),((-58.797890335147365 54.0,-58.175056 54.237889,-57.338518268187144 54.0,-58.797890335147365 54.0)))
---<--------------------cut here---------------end--------------------->---

But then ogr2ogr fails:

ogr2ogr -f GMT -nln test.gmt PG:"host=localhost user=user password=password dbname=gshhs" subset_c
FAILURE:
Unable to open datasource `subset_c' with the following drivers.

and the list of drivers does include GMT, so the capabilities are there.
I am using the latest Debian sid packages.  Any tips would be
appreciated.

Cheers,

-- 
Seb



More information about the gdal-dev mailing list