[GRASS-dev] [GRASS GIS] #3262: v.external.out: SRID lost when not exactly defined

GRASS GRASS developer
,
1

#3262: v.external.out: SRID lost when not exactly defined
-------------------------------------+-------------------------
Reporter: martinl | Owner: grass-dev@…
     Type: defect | Status: new
Priority: normal | Milestone: 7.2.1
Component: Vector | Version: svn-trunk
Keywords: v.external.out, postgis | CPU: Unspecified
Platform: Unspecified |
-------------------------------------+-------------------------
We assume that we have location with EPSG defined:

{{{
g.proj -p
...
-PROJ_EPSG-------------------------------------------------
epsg : 5514
...
}}}

We define external format (PostGIS in our case):

{{{
v.external.out output="PG:dbname=grassdb" format=PostgreSQL
}}}

and run some module

{{{
v.random p1 n=1000 -b
}}}

Check result:

{{{
psql grassdb -c "select f_table_name, srid from geometry_columns"
  f_table_name | srid
--------------+------
  p1 | 0
}}}

SRID information is lost.

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/3262&gt;
GRASS GIS <https://grass.osgeo.org>

2

#3262: v.external.out: SRID lost when not exactly defined
--------------------------+-------------------------------------
  Reporter: martinl | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone: 7.2.1
Component: Vector | Version: svn-trunk
Resolution: | Keywords: v.external.out, postgis
       CPU: Unspecified | Platform: Unspecified
--------------------------+-------------------------------------

Comment (by martinl):

Note that currently it's possible to force SRID by G72:v.external.out
`option` parameter which helps to overcome this issue.

{{{
v.external.out output="PG:dbname=retia" format=PostgreSQL
options=SRID=5514
v.random p1 n=1000 -b --o
psql retia -c "select f_table_name, srid from geometry_columns"
  f_table_name | srid
--------------+------
  p1 | 5514
}}}

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/3262#comment:1&gt;
GRASS GIS <https://grass.osgeo.org>

3

#3262: v.external.out: SRID lost when not exactly defined
--------------------------+-------------------------------------
  Reporter: martinl | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone: 7.2.1
Component: Vector | Version: svn-trunk
Resolution: | Keywords: v.external.out, postgis
       CPU: Unspecified | Platform: Unspecified
--------------------------+-------------------------------------

Comment (by martinl):

In [changeset:"70385" 70385]:
{{{
#!CommitTicketReference repository="" revision="70385"
v.external.out: SRID lost when not exactly defined (see #3262)
}}}

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/3262#comment:2&gt;
GRASS GIS <https://grass.osgeo.org>

4

#3262: v.external.out: SRID lost when not exactly defined
--------------------------+-------------------------------------
  Reporter: martinl | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone: 7.2.1
Component: Vector | Version: svn-trunk
Resolution: | Keywords: v.external.out, postgis
       CPU: Unspecified | Platform: Unspecified
--------------------------+-------------------------------------

Comment (by martinl):

Should be fixed in trunk (r70385). If no objection than will be backported
to relbr72/70.

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/3262#comment:3&gt;
GRASS GIS <https://grass.osgeo.org>

5

#3262: v.external.out: SRID lost when not exactly defined
--------------------------+-------------------------------------
  Reporter: martinl | Owner: grass-dev@…
      Type: defect | Status: new
  Priority: normal | Milestone: 7.2.1
Component: Vector | Version: svn-trunk
Resolution: | Keywords: v.external.out, postgis
       CPU: Unspecified | Platform: Unspecified
--------------------------+-------------------------------------

Comment (by martinl):

In [changeset:"70422" 70422]:
{{{
#!CommitTicketReference repository="" revision="70422"
v.external.out: SRID lost when not exactly defined (see #3262)
}}}

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/3262#comment:4&gt;
GRASS GIS <https://grass.osgeo.org>

6

#3262: v.external.out: SRID lost when not exactly defined
--------------------------+-------------------------------------
  Reporter: martinl | Owner: grass-dev@…
      Type: defect | Status: closed
  Priority: normal | Milestone: 7.2.1
Component: Vector | Version: svn-trunk
Resolution: fixed | Keywords: v.external.out, postgis
       CPU: Unspecified | Platform: Unspecified
--------------------------+-------------------------------------
Changes (by martinl):

* status: new => closed
* resolution: => fixed

Comment:

In [changeset:"70424" 70424]:
{{{
#!CommitTicketReference repository="" revision="70424"
v.external.out: SRID lost when not exactly defined (fix #3262)
                 (merge r70422 from relbr72)
}}}

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/3262#comment:5&gt;
GRASS GIS <https://grass.osgeo.org>