[GRASS-user] Error trying to export a database table

GRASS GRASS user
, ,
1

Hi all:

I’m using GRASS on a Mac:

GRASS version: 7.8.6dev
Code revision: 0d636df8f
Build date: 2021-09-09
Build platform: x86_64-apple-darwin20.6.0
GDAL: 3.1.4
PROJ: 7.1.1
GEOS: 3.8.1
SQLite: 3.35.4
Python: 3.8.8
wxPython: 4.1.1
Platform: macOS-10.16-x86_64-i386-64bit

I get an error trying to export a database table using…

db.out.ogr --overwrite input=CEATI_dams_not_RR_gauge_rfc_fcst@teaiii output=/Users/teaiii/CEATI_dams_not_RR_gauge_rfc_fcst format=CSV table=CEATI_dams_not_RR_gauge_rfc_fcst

ERROR:

GRASS 7.8.6dev (global-dataset):~ >

<fcst@teaiii output=/Users/teaiii/CEATI_dams_not_RR_gauge_rfc_fcst format=CSV table=CEATI_dams_not_RR_gauge_rfc_fcst

WARNING: The combination of types is not supported by all formats.

ERROR 10: Pointer ‘hSRS’ is NULL in ‘OSRImportFromWkt’.

ERROR: Unable to create OGR spatial reference

ERROR: Module <v.out.ogr> failed

This happens using with the GRASS GUI or from the command line.

Any suggestions?

Regards,
Tom

2

Hello Tom

It is the same error as reported here: https://lists.osgeo.org/pipermail/grass-dev/2021-November/095454.html

I have encountered it myself but it’s not clear where it comes from. It happens in only one location (an old latlong one) and I can’t reproduce with other locations. I use Fedora Linux.

Sorry for not being of more help.

Vero

El jue, 2 dic 2021 a las 19:40, Thomas Adams (<tea3rd@gmail.com>) escribió:

Hi all:

I’m using GRASS on a Mac:

GRASS version: 7.8.6dev
Code revision: 0d636df8f
Build date: 2021-09-09
Build platform: x86_64-apple-darwin20.6.0
GDAL: 3.1.4
PROJ: 7.1.1
GEOS: 3.8.1
SQLite: 3.35.4
Python: 3.8.8
wxPython: 4.1.1
Platform: macOS-10.16-x86_64-i386-64bit

I get an error trying to export a database table using…

db.out.ogr --overwrite input=CEATI_dams_not_RR_gauge_rfc_fcst@teaiii output=/Users/teaiii/CEATI_dams_not_RR_gauge_rfc_fcst format=CSV table=CEATI_dams_not_RR_gauge_rfc_fcst

ERROR:

GRASS 7.8.6dev (global-dataset):~ >

<fcst@teaiii output=/Users/teaiii/CEATI_dams_not_RR_gauge_rfc_fcst format=CSV table=CEATI_dams_not_RR_gauge_rfc_fcst

WARNING: The combination of types is not supported by all formats.

ERROR 10: Pointer ‘hSRS’ is NULL in ‘OSRImportFromWkt’.

ERROR: Unable to create OGR spatial reference

ERROR: Module <v.out.ogr> failed

This happens using with the GRASS GUI or from the command line.

Any suggestions?

Regards,
Tom

grass-user mailing list
grass-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/grass-user

3

Hi Veronica!

Thank you for your response and the information. At least I know that I am not doing anything wrong …

Best,
Tom

4

Hi Tom,

Note that if all you want is to create a CSV file from the attribute table, v.db.select can do the job for you. In GRASS 8 it actually has a format parameter that lets you choose CSV explicitly, but even without that you can get a satisfying result.

Moritz

5

Hi Moritz!

Thank you so much! That’s a great idea… oddly enough, after you mention this, I remember seeing this for v.db.select.

Thanks again!

Best,
Tom

On Fri, Dec 3, 2021 at 9:18 AM Moritz Lennert <mlennert@club.worldonline.be> wrote:

Hi Tom,

Note that if all you want is to create a CSV file from the attribute table, v.db.select can do the job for you. In GRASS 8 it actually has a format parameter that lets you choose CSV explicitly, but even without that you can get a satisfying result.

Moritz

Le 3 décembre 2021 13:48:58 GMT+01:00, Thomas Adams <tea3rd@gmail.com> a écrit :

Hi Veronica!

Thank you for your response and the information. At least I know that I am not doing anything wrong …

Best,
Tom

On Fri, Dec 3, 2021 at 6:14 AM Veronica Andreo <veroandreo@gmail.com> wrote:

Hello Tom

It is the same error as reported here: https://lists.osgeo.org/pipermail/grass-dev/2021-November/095454.html

I have encountered it myself but it’s not clear where it comes from. It happens in only one location (an old latlong one) and I can’t reproduce with other locations. I use Fedora Linux.

Sorry for not being of more help.

Vero

El jue, 2 dic 2021 a las 19:40, Thomas Adams (<tea3rd@gmail.com>) escribió:

Hi all:

I’m using GRASS on a Mac:

GRASS version: 7.8.6dev
Code revision: 0d636df8f
Build date: 2021-09-09
Build platform: x86_64-apple-darwin20.6.0
GDAL: 3.1.4
PROJ: 7.1.1
GEOS: 3.8.1
SQLite: 3.35.4
Python: 3.8.8
wxPython: 4.1.1
Platform: macOS-10.16-x86_64-i386-64bit

I get an error trying to export a database table using…

db.out.ogr --overwrite input=CEATI_dams_not_RR_gauge_rfc_fcst@teaiii output=/Users/teaiii/CEATI_dams_not_RR_gauge_rfc_fcst format=CSV table=CEATI_dams_not_RR_gauge_rfc_fcst

ERROR:

GRASS 7.8.6dev (global-dataset):~ >

<fcst@teaiii output=/Users/teaiii/CEATI_dams_not_RR_gauge_rfc_fcst format=CSV table=CEATI_dams_not_RR_gauge_rfc_fcst

WARNING: The combination of types is not supported by all formats.

ERROR 10: Pointer ‘hSRS’ is NULL in ‘OSRImportFromWkt’.

ERROR: Unable to create OGR spatial reference

ERROR: Module <v.out.ogr> failed

This happens using with the GRASS GUI or from the command line.

Any suggestions?

Regards,
Tom

grass-user mailing list
grass-user@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/grass-user