[GRASSLIST:8275] exporting to PostGIS

Leonardo Lami lami at faunalia.it
Wed Sep 14 11:44:23 EDT 2005


Hi list,
I'm trying to export a vector in PostGis with the command v.out.ogr.
My Location is Gauss-Boaga with the follow PROJ_INFO file:

name: Transverse Mercator
datum: rome40
datumparams: towgs84=-104.1,-49.1,-9.9,0.971,-2.917,0.714,-11.68
proj: tmerc
ellps: international
a: 6378388.0000000000
es: 0.0067226700
f: 297.0000000000
lat_0: 0.0000000000
lon_0: 9.0
k_0: 0.9996000000
x_0: 1500000.0000000000
y_0: 0.000000000

I wrote:
v.out.ogr input=t_comuni_2003 type=area dsn="PG:host=192.168.0.10 
dbname=faunalia user=########## password=########" olayer=prova_comuni 
layer=1 format=PostgreSQL

The output message said:
Exporting 313 areas (may take some time) ...
 100%
313 features written

All seem rigth but if I look the table in PostGIS I see that the SRID is 32767 
(a value that not exist in the EPSG codes)  and not the correct SRID code 
26591 .

So if I use MapServer to display the PostGIS table I see the map not in the 
correct place.
The control is with shapefiles exported from GRASS vector of the Location 
Gauss-Boaga.

The strange is that if I load the table of PostGIS in QGIS I look it in the 
correct place.
The control is with GRASS vector of the Location Gauss-Boaga

There is an option to use in v.out.ogr to put the correct SRID or somethings 
else?

Thanks
Leonardo

-- 
Leonardo Lami
lami at faunalia.it            www.faunalia.it
Via Colombo 3 - 51010 Massa e Cozzile (PT), Italy   Tel: (+39)349-1310164
GPG key @: hkp://wwwkeys.pgp.net http://www.pgp.net/wwwkeys.html
https://www.biglumber.com




More information about the grass-user mailing list