Open gdetry opened 3 years ago
Good day,
I’m using the Pentaho GIS Plugins to convert a spatial PostGIS table to a shapefile. Input Data is in EPSG 25830 (Spain - ETRS 89 – UTM Zone 30N).
The Kettle transformation is quite simple (input table >> Order >> Mapping >> GIS File Output as SHP) and works fine.
However the Coordinate Reference System of the output layers is not recognized by the most recent version of QGIS (I’m using QGIS v.3.14.15).
Taking a look at the .*prj file generated by the transformation, I can see that the definition of the SRS is the following
PROJCS["ETRS89 / UTM zone 30N",GEOGCS["RGF93",DATUM["Réseau géodésique français 1993",SPHEROID["GRS 1980",6378137.0,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6171"]],PRIMEM["Greenwich",0.0,AUTHORITY["EPSG","8901"]]],PROJECTION["Transverse Mercator Zoned Grid System"],PARAMETER["latitude of origin",0],PARAMETER["central meridian",-3],PARAMETER["scale factor",1],PARAMETER["false easting",0],PARAMETER["false northing",0],UNIT["meter",1,AUTHORITY["EPSG","9001"]],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["EPSG","25830"]]
And the definition which is understandable by QGIS looks like
PROJCS["ETRS_1989_UTM_Zone_30N",GEOGCS["GCS_ETRS_1989",DATUM["D_ETRS_1989",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-3.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]]
Is correct the SRS corresponding to the EPSG 25830 in the plugin?
Configuration: PDI - Kettle 9.0; QGIS : 3.14.15 Plugin version: 1.4.0-bin-9
Tks for your effort
Good day,
I’m using the Pentaho GIS Plugins to convert a spatial PostGIS table to a shapefile. Input Data is in EPSG 25830 (Spain - ETRS 89 – UTM Zone 30N).
The Kettle transformation is quite simple (input table >> Order >> Mapping >> GIS File Output as SHP) and works fine.
However the Coordinate Reference System of the output layers is not recognized by the most recent version of QGIS (I’m using QGIS v.3.14.15).
Taking a look at the .*prj file generated by the transformation, I can see that the definition of the SRS is the following
PROJCS["ETRS89 / UTM zone 30N",GEOGCS["RGF93",DATUM["Réseau géodésique français 1993",SPHEROID["GRS 1980",6378137.0,298.257222101,AUTHORITY["EPSG","7019"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6171"]],PRIMEM["Greenwich",0.0,AUTHORITY["EPSG","8901"]]],PROJECTION["Transverse Mercator Zoned Grid System"],PARAMETER["latitude of origin",0],PARAMETER["central meridian",-3],PARAMETER["scale factor",1],PARAMETER["false easting",0],PARAMETER["false northing",0],UNIT["meter",1,AUTHORITY["EPSG","9001"]],AXIS["Easting",EAST],AXIS["Northing",NORTH],AUTHORITY["EPSG","25830"]]And the definition which is understandable by QGIS looks like
PROJCS["ETRS_1989_UTM_Zone_30N",GEOGCS["GCS_ETRS_1989",DATUM["D_ETRS_1989",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-3.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0]]Is correct the SRS corresponding to the EPSG 25830 in the plugin?
Configuration: PDI - Kettle 9.0; QGIS : 3.14.15 Plugin version: 1.4.0-bin-9
Tks for your effort