[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