[GRASS-dev] Export from GRASS to Postgres

suprakash maitra suprakashmaitra at yahoo.com
Tue Apr 9 01:02:06 PDT 2013


Hi
You have given some commands,on the basis of that o/p is as follows:

 [user at lab35 ~]$ ogrinfo --version
GDAL 1.8.1, released 2011/07/09
[user at lab35 ~]$ gdal-config --libs
-L/usr/local/lib -lgdal
[user at lab35 ~]$ 

g.version -b (in GRASS 6)
./configure  --with-postgres-includes=/opt/PostgreSQL/9.1/include --with-postgres-libs=/opt/PostgreSQL/9.1/lib --with-freetype-includes=/usr/include/freetype2 --with-freetype-libs=/usr/lib --with-cxx --with-python --with-fftw --with-freetype --with-gdal=/usr/local/bin/gdal-config --with-postgres

according to you there is a different GDAL library,
then how can check it or what should I do with it,to get things done.

Thanks in advance


----------------------------------------------------------------------------------------------
    "If you don't know where you are going any road will get you there"
----------------------------------------------------------------------------------------------
Regards 

suprakash



________________________________
 From: suprakash maitra <suprakashmaitra at yahoo.com>
To: "grass-dev at lists.osgeo.org" <grass-dev at lists.osgeo.org> 
Sent: Monday, April 8, 2013 6:21 PM
Subject: Re: Export from GRASS to Postgres
 

Hi,
v.in.ogr -f                                                                     
 ESRI Shapefile (rw): ESRI Shapefile
 MapInfo File (rw): MapInfo File
 UK .NTF (ro): UK .NTF
 SDTS (ro): SDTS
 TIGER (rw): TIGER
 S57 (rw): S57
 DGN (rw): DGN
 VRT (ro): VRT
 REC (ro): REC
 Memory (rw): Memory
 BNA (rw): BNA
 CSV (rw): CSV
 GML (rw): GML
 GPX (rw): GPX
 KML (rw): KML
 GeoJSON
 (rw): GeoJSON
 GMT (rw): GMT
 SQLite (rw): SQLite
 PCIDSK (rw): PCIDSK
 XPlane (ro): XPlane
 AVCBin (ro): AVCBin
 AVCE00 (ro): AVCE00
 DXF (rw): DXF
 Geoconcept (rw): Geoconcept
 GeoRSS (rw): GeoRSS
 GPSTrackMaker (rw): GPSTrackMaker
 VFK (ro): VFK
 PGDump (rw): PGDump
 GPSBabel (rw): GPSBabel
 SUA (ro): SUA
 OpenAir (ro): OpenAir
 PDS (ro): PDS
 WFS (ro): WFS
 HTF (ro): HTF
 AeronavFAA (ro): AeronavFAA
Available OGR Drivers:
(Mon Apr  8 18:17:56 2013) Command finished (0 sec)    
[user at lab35 local]$ ogrinfo --formats
Supported Formats:
  -> "ESRI Shapefile" (read/write)
  -> "MapInfo File" (read/write)
  -> "UK .NTF" (readonly)
  -> "SDTS" (readonly)
  -> "TIGER" (read/write)
  -> "S57"
 (read/write)
  -> "DGN" (read/write)
  -> "VRT" (readonly)
  -> "REC" (readonly)
  -> "Memory" (read/write)
  -> "BNA" (read/write)
  -> "CSV" (read/write)
  -> "GML" (read/write)
  -> "GPX" (read/write)
  -> "KML" (read/write)
  -> "GeoJSON" (read/write)
  -> "GMT" (read/write)
  -> "SQLite" (read/write)
  -> "PostgreSQL" (read/write)
  -> "PCIDSK" (read/write)
  -> "XPlane" (readonly)
  -> "AVCBin" (readonly)
  -> "AVCE00" (readonly)
  -> "DXF" (read/write)
  -> "Geoconcept" (read/write)
  -> "GeoRSS" (read/write)
  -> "GPSTrackMaker" (read/write)
  -> "VFK" (readonly)
  -> "PGDump" (read/write)
  -> "GPSBabel" (read/write)
  -> "SUA" (readonly)
  -> "OpenAir"
 (readonly)
  -> "PDS" (readonly)
  -> "WFS" (readonly)
  -> "HTF" (readonly)
  -> "AeronavFAA" (readonly)



 
----------------------------------------------------------------------------------------------
    "If you don't know where you are going any road will get you there"
----------------------------------------------------------------------------------------------
Regards 

Suprakash



________________________________
 From: suprakash maitra <suprakashmaitra at yahoo.com>
To: "grass-dev at lists.osgeo.org" <grass-dev at lists.osgeo.org> 
Sent: Monday, April 8, 2013 4:00 PM
Subject: Re: Export from GRASS to Postgres
 

Hi
I am using Fedora15,GRASS-6.4.2,gdal-1.8.1,postgresql-9.1.I have compiled gdal with postgresql support and GRASS with gdal and postgreSQL support ,even then while exporting map/mapset to postgreSQL the format PostgreSQL is not supported.

Plz help me out.
 
----------------------------------------------------------------------------------------------
    "If you don't know where you are going any road will get you there"
----------------------------------------------------------------------------------------------
Regards 

Suprakash



________________________________
 From: suprakash maitra <suprakashmaitra at yahoo.com>
To: "grass-dev at lists.osgeo.org" <grass-dev at lists.osgeo.org> 
Sent: Wednesday, April 3, 2013 5:44 PM
Subject: Export from GRASS to Postgres
 

Hi All,

I am trying to export GRASS maps/mapsets to PostgreSQL.At the time of installation of GRASS ,I have configured it with Postgres.
The command used is:
v.out.ogr -c input=fields type=area 'dsn=PG:host=localhost dbname=grass user=grassuser password=grassuser' olayer=fields2postgis layer=1 format=PostgreSQL
The database grass is postgis enabled.
However the format "PostgreSQL" is taken as invalid format.
Without "PostgreSql" format the maps are exported to ESRI_shapefile format.
One thing more, There is no PostgreSql format type in OGR format dropdown list in case of using GUI. 
Please help me out.

Thanks in advance.
 
----------------------------------------------------------------------------------------------
    "If you don't know where you are going any road will get you there"
----------------------------------------------------------------------------------------------
Regards 


Suprakash
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-dev/attachments/20130409/784ab2e6/attachment.html>


More information about the grass-dev mailing list