[GRASS-user] Grass7 - Inconsistencies with v.out.ogr and v.out.postgis

Mark Wynter mark at dimensionaledge.com
Fri Apr 26 19:09:19 PDT 2013


> 
> v.out.ogr in=roadsmajor dsn=PG:dbname=pgis_grass format=PostgreSQL
> 
> ->
> 
> $ db.select data=pgis_grass dri=pg sql="select count(*) from roadsmajor" -c
> 355
> 
> db.select data=pgis_grass dri=pg sql="select srid from
> geometry_columns where f_table_name = 'roadsmajor'" -c
> 900914
> 
> (new srid added to the table `spatial_ref_sys`)

Hi Martin, just noticed PostGIS assigned 900914 to your table above, yet below its 3358.
This is the same as what I'm experiencing.
When I inspect the details of 900914, it mirrors the correct SRID - its just labelled 900914 instead?
Yet v.out.postgis handles everything the way you would expect


> $ v.out.postgis in=roadsmajor dsn=PG:dbname=pgis_grass
> options="GEOMETRY_NAME=wkb_geometry,SRID=3358" --o
> 
> $ db.select data=pgis_grass dri=pg sql="select count(*) from roadsmajor" -c
> 355
> 
> $ db.select data=pgis_grass dri=pg sql="select srid from
> geometry_columns where f_table_name = 'roadsmajor'" -c
> 3358
> 
> 
> Everything seems to be OK. Do you have fresh installation from svn? Martin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20130427/65e36df0/attachment-0001.html>


More information about the grass-user mailing list