[GRASS-user] v.external, postgis materialized views and projection

[Saulteau Don]

When I use v.external to load a postgis materialized view it says the
projection mismatches the Location but they are actually the same.

% v.external input="PG:host=localhost dbname=database" layer=table_1
output=t
ERROR: Projection of dataset does not appear to match current location.


      Location PROJ_INFO is:
      name: NAD83 / UTM zone 10N
      datum: nad83
      ellps: grs80
      proj: utm
      zone: 10
      no_defs: defined
      init: EPSG:26910

      Dataset PROJ_INFO is:
      name: NAD83 / BC Albers
      datum: nad83
      ellps: grs80
      proj: aea
      lat_0: 45
      lon_0: -126
      lat_1: 50
      lat_2: 58.5
      x_0: 1000000
      y_0: 0
      no_defs: defined

      Difference in: proj

      In case of no significant differences in the projection definitions,
      use the -o flag to ignore them and use current location definition.
      Consider generating a new location from the input dataset using the
      'location' parameter.

It looks like GRASS sees the projection from the source table used for the
materialized view instead of the materialized views projection that was set
in postgis using ST_Transform().

Is this normal for grass to see materialized views like this?




Donovan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-user/attachments/20210816/21f63590/attachment.html>