[GRASS-user] failing to import table

Paolo_Cavallini · August 30, 2013, 8:34am

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all.
Importing a shapefile with space in the name results in an empty table of attributes.
Is this a known problem? Should I file a ticket?
GRASS 6.4.2-2 from Debian unstable.
Thanks.
- --
Paolo Cavallini - Faunalia
www.faunalia.eu
Full contact details at www.faunalia.eu/pc
Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuPG with Icedove - http://www.enigmail.net/

iEYEARECAAYFAlIgWTAACgkQ/NedwLUzIr5WjwCdE2LpHK77nWhC0v5+yC2frlcm
ITkAn2/3HgE4xBWj0k3F4O+nRfJMzT3b
=XaQr
-----END PGP SIGNATURE-----

mlennert · August 30, 2013, 9:03am

On 30/08/13 10:34, Paolo Cavallini wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all.
Importing a shapefile with space in the name results in an empty table of attributes.

I don't get an empty table of attributes, but an erroneous db table connection info.

Is this a known problem? Should I file a ticket?

https://trac.osgeo.org/grass/ticket/1328

Apparently it needs to be reopened ?

Moritz

neteler · August 31, 2013, 11:56am

Hi,

does this persist with the current 6.4.3?

Markus

Paolo_Cavallini · August 31, 2013, 4:58pm

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Il 31/08/2013 13:56, Markus Neteler ha scritto:

does this persist with the current 6.4.3?

untested - I cannot publish the data, but can send it you you are interested to check.
thanks.

- --
Paolo Cavallini - Faunalia
www.faunalia.eu
Full contact details at www.faunalia.eu/pc
Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuPG with Icedove - http://www.enigmail.net/

iEYEARECAAYFAlIiILgACgkQ/NedwLUzIr6NpgCfXg+VJqLfi7NAYI1Xdvd3dNrS
Q1AAn3kkyEC7wznobqN1j2qZjtNfwokQ
=Mi1N
-----END PGP SIGNATURE-----

neteler · August 31, 2013, 5:07pm

On Sat, Aug 31, 2013 at 6:58 PM, Paolo Cavallini <cavallini@faunalia.it> wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Il 31/08/2013 13:56, Markus Neteler ha scritto:

does this persist with the current 6.4.3?

untested - I cannot publish the data, but can send it you you are interested to check.

Due to time constraints at my end please test with the current stable
version first.

thanks
Markus

Paolo_Cavallini · September 1, 2013, 8:56am

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Il 31/08/2013 19:07, Markus Neteler ha scritto:

Due to time constraints at my end please test with the current stable
version first.

Unfortunately it is currently not possible for me right now. If there is anybody with
a clean 6.4.3, I'll be happy to provide the file.
Thanks a lot.

- --
Paolo Cavallini - Faunalia
www.faunalia.eu
Full contact details at www.faunalia.eu/pc
Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuPG with Icedove - http://www.enigmail.net/

iEYEARECAAYFAlIjATgACgkQ/NedwLUzIr4P2wCfVjtWyX23EWzBVQsUksXz2xuM
lLcAnRAvTjJgBOgjoc7q+OkwTH8cV10c
=zibT
-----END PGP SIGNATURE-----

hellik · September 1, 2013, 12:25pm

Paolo Cavallini wrote

Il 31/08/2013 19:07, Markus Neteler ha scritto:

Due to time constraints at my end please test with the current stable
version first.

Unfortunately it is currently not possible for me right now. If there is
anybody with
a clean 6.4.3, I'll be happy to provide the file.
Thanks a lot.

- --
Paolo Cavallini - Faunalia

tested with

GRASS Version: 6.4.3
GRASS SVN Revision: 57300M
GIS Library Revision: 50937 (2012-02-25)
GDAL/OGR: 1.9.2
PROJ4: Rel. 4.8.0, 6 March 2012
Python: 2.7.4
wxPython: 2.8.12.1
Platform: Windows-Vista-6.0.6002-SP2 (OSGeo4W)

v.in.ogr dsn=J:\wd\grassshape\a b.shp output=a_b
Die Projektionsinformationen des Eingabedatensatzes und der aktuellen
Location scheinen übereinzustimmen.
Layer: a b
Zähle Polygone für 71 Objekte...
Importiere 71 Objekte der Karte...
-----------------------------------------------------
Erstelle Topologie für die Vektorkarte <a_b_tmp>...
Registriere Primitive...
71 Primitive registriert
71 Vertices registriert
Anzahl der Knoten: 71
Anzahl der Primitive: 71
Anzahl der Punkte: 71
Anzahl der Linien: 0
Anzahl der Grenzen: 0
Anzahl der Zentroide: 0
Anzahl der Flächen: -
Anzahl der Inseln: -
Erstelle Topologie für die Vektorkarte <a_b>...
Registriere Primitive...
71 Primitive registriert
71 Vertices registriert
Erzeuge Flächen...
0 Flächen angelegt
0 Inseln angelegt
Füge Inseln hinzu...
Füge Zentroide hinzu...
Anzahl der Knoten: 71
Anzahl der Primitive: 71
Anzahl der Punkte: 71
Anzahl der Linien: 0
Anzahl der Grenzen: 0
Anzahl der Zentroide: 0
Anzahl der Flächen: 0
Anzahl der Inseln: 0

import (also attribute table) works here

-----
best regards
Helmut
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/failing-to-import-table-tp5075176p5075450.html
Sent from the Grass - Users mailing list archive at Nabble.com.

Hamish · September 1, 2013, 9:22pm

Paolo wrote:

GRASS 6.4.2-2 from Debian unstable.

just to note that Frankie & me hope to have the 6.4.3 package into debian/unstable
in the coming days.

remaining issue has to do with subtleties of
http://packages.debian.org/sid/libtiff5-alt-dev

regards,
Hamish

mlennert · September 2, 2013, 7:07am

On 31/08/13 13:56, Markus Neteler wrote:

Hi,

does this persist with the current 6.4.3?

I tested with post-6.4.3-release 64 release branch and it does persist.

Moritz

Paolo_Cavallini · September 2, 2013, 7:13am

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Il 02/09/2013 09:07, Moritz Lennert ha scritto:

On 31/08/13 13:56, Markus Neteler wrote:

Hi,

does this persist with the current 6.4.3?

I tested with post-6.4.3-release 64 release branch and it does persist.

Thanks - should I open a ticket then?
All the best.

- --
Paolo Cavallini - Faunalia
www.faunalia.eu
Full contact details at www.faunalia.eu/pc
Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuPG with Icedove - http://www.enigmail.net/

iEYEARECAAYFAlIkOqIACgkQ/NedwLUzIr4UhACcCZy2KD9axwYj7uuGFY8IXs0W
g3MAn17xPMu6O3/92x5Wx/o78BftnTxZ
=9W6o
-----END PGP SIGNATURE-----

hellik · September 2, 2013, 7:28am

GRASS Version: 6.4.3

GRASS SVN Revision: 57300M

GIS Library Revision: 50937 (2012-02-25)

GDAL/OGR: 1.9.2

PROJ4: Rel. 4.8.0, 6 March 2012

Python: 2.7.4

wxPython: 2.8.12.1

Platform: Windows-Vista-6.0.6002-SP2 (OSGeo4W) uote author="Moritz Lennert">
On 31/08/13 13:56, Markus Neteler wrote:

Hi,

does this persist with the current 6.4.3?

I tested with post-6.4.3-release 64 release branch and it does persist.

Moritz
_______________________________________________
grass-user mailing list
grass-user@.osgeo
http://lists.osgeo.org/mailman/listinfo/grass-user

it works for me with

-----
best regards
Helmut
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/failing-to-import-table-tp5075176p5075536.html
Sent from the Grass - Users mailing list archive at Nabble.com.

hellik · September 2, 2013, 7:30am

Helmut Kudrnovsky wrote

GRASS Version: 6.4.3

GRASS SVN Revision: 57300M

GIS Library Revision: 50937 (2012-02-25)

GDAL/OGR: 1.9.2

PROJ4: Rel. 4.8.0, 6 March 2012

Python: 2.7.4

wxPython: 2.8.12.1

Platform: Windows-Vista-6.0.6002-SP2 (OSGeo4W) uote author="Moritz
Lennert">
On 31/08/13 13:56, Markus Neteler wrote:

Hi,

does this persist with the current 6.4.3?

I tested with post-6.4.3-release 64 release branch and it does persist.

Moritz
_______________________________________________
grass-user mailing list

grass-user@.osgeo

http://lists.osgeo.org/mailman/listinfo/grass-user

it works for me with

sorry, too early sent.

it works with osgeo4w-winGRASS6.4.3

-----
best regards
Helmut
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/failing-to-import-table-tp5075176p5075537.html
Sent from the Grass - Users mailing list archive at Nabble.com.

mlennert · September 2, 2013, 8:11am

On 02/09/13 09:13, Paolo Cavallini wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Il 02/09/2013 09:07, Moritz Lennert ha scritto:

On 31/08/13 13:56, Markus Neteler wrote:

Hi,

does this persist with the current 6.4.3?

I tested with post-6.4.3-release 64 release branch and it does persist.

Thanks - should I open a ticket then?

As mentioned, this really resembles https://trac.osgeo.org/grass/ticket/1328, so I think it could just be reopened.

Moritz

mlennert · September 2, 2013, 8:18am

On 01/09/13 14:25, Helmut Kudrnovsky wrote:

Paolo Cavallini wrote

Il 31/08/2013 19:07, Markus Neteler ha scritto:

Due to time constraints at my end please test with the current stable
version first.

Unfortunately it is currently not possible for me right now. If there is
anybody with
a clean 6.4.3, I'll be happy to provide the file.
Thanks a lot.

- --
Paolo Cavallini - Faunalia

tested with

GRASS Version: 6.4.3
GRASS SVN Revision: 57300M
GIS Library Revision: 50937 (2012-02-25)
GDAL/OGR: 1.9.2
PROJ4: Rel. 4.8.0, 6 March 2012
Python: 2.7.4
wxPython: 2.8.12.1
Platform: Windows-Vista-6.0.6002-SP2 (OSGeo4W)

v.in.ogr dsn=J:\wd\grassshape\a b.shp output=a_b
Die Projektionsinformationen des Eingabedatensatzes und der aktuellen
Location scheinen übereinzustimmen.
Layer: a b
Zähle Polygone für 71 Objekte...
Importiere 71 Objekte der Karte...
-----------------------------------------------------
Erstelle Topologie für die Vektorkarte<a_b_tmp>...
Registriere Primitive...
71 Primitive registriert
71 Vertices registriert
Anzahl der Knoten: 71
Anzahl der Primitive: 71
Anzahl der Punkte: 71
Anzahl der Linien: 0
Anzahl der Grenzen: 0
Anzahl der Zentroide: 0
Anzahl der Flächen: -
Anzahl der Inseln: -
Erstelle Topologie für die Vektorkarte<a_b>...
Registriere Primitive...
71 Primitive registriert
71 Vertices registriert
Erzeuge Flächen...
0 Flächen angelegt
0 Inseln angelegt
Füge Inseln hinzu...
Füge Zentroide hinzu...
Anzahl der Knoten: 71
Anzahl der Primitive: 71
Anzahl der Punkte: 71
Anzahl der Linien: 0
Anzahl der Grenzen: 0
Anzahl der Zentroide: 0
Anzahl der Flächen: 0
Anzahl der Inseln: 0

import (also attribute table) works here

Have you tried accessing the attribute table ? Working with it through other modules ?
What does v.db.connect -p give you ?

Moritz

hellik · September 2, 2013, 9:18am

Moritz Lennert wrote

Have you tried accessing the attribute table ? Working with it through
other modules ?
What does v.db.connect -p give you ?

attribute table manager opens without any problems, some further tests below

_____

System Info
GRASS version: 6.4.3
GRASS SVN Revision:
GIS Library Revision: 50937 (2012-02-25)
GDAL/OGR: GDAL 1.9.2, released 2012/10/08
PROJ4: Rel. 4.8.0, 6 March 2012
Python: 2.7.4
wxPython: 2.8.12.1
Platform: Windows-7-6.1.7601-SP1 (OSGeo4W)

_____

nc-sample data set

v.out.ogr -s -e input=geology@PERMANENT type=area dsn=C:\wd olayer=a_b

_____

renaming

a_b.shp => a b.shp
a_b.dbf => a b.shp
a_b.prj => a b.shp
a_b.shx => a b.shp

_____

v.in.ogr dsn=C:\wd\a b.shp output=import_shapefile_with_spaces
Projection of input dataset and current location appear to match
Layer: a b
Counting polygons for 1832 features...
Importing map 1832 features...
-----------------------------------------------------
Building topology for vector map <import_shapefile_with_spaces_tmp>...
Registering primitives...
6462 primitives registered
322207 vertices registered
Number of nodes: 5733
Number of primitives: 6462
Number of points: 0
Number of lines: 0
Number of boundaries: 6462
Number of centroids: 0
Number of areas: -
Number of isles: -
-----------------------------------------------------
WARNING: Cleaning polygons, result is not guaranteed!
-----------------------------------------------------
Break polygons:
-----------------------------------------------------
Remove duplicates:
-----------------------------------------------------
Break boundaries:
-----------------------------------------------------
Remove duplicates:
-----------------------------------------------------
Clean boundaries at nodes:
-----------------------------------------------------
Merge boundaries:
-----------------------------------------------------
Change dangles to lines:
-----------------------------------------------------
Remove bridges:
-----------------------------------------------------
Building topology for vector map <import_shapefile_with_spaces_tmp>...
Building areas...
1832 areas built
907 isles built
Attaching islands...
Number of nodes: 6722
Number of primitives: 19851
Number of points: 0
Number of lines: 0
Number of boundaries: 19851
Number of centroids: 0
Number of areas: 1832
Number of isles: 907
Number of areas without centroid: 1832
-----------------------------------------------------
Find centroids for layer: a b
-----------------------------------------------------
Write centroids:
-----------------------------------------------------
1832 input polygons
Total area: 1.27609E+011 (1832 areas)
Overlapping area: 0 (0 areas)
Area without category: 0 (0 areas)
-----------------------------------------------------
Building topology for vector map <import_shapefile_with_spaces>...
Registering primitives...
5465 primitives registered
191205 vertices registered
Building areas...
1832 areas built
907 isles built
Attaching islands...
Attaching centroids...
Number of nodes: 4540
Number of primitives: 5465
Number of points: 0
Number of lines: 0
Number of boundaries: 3633
Number of centroids: 1832
Number of areas: 1832
Number of isles: 907
(Mon Sep 02 10:59:28 2013) Command finished (12 sec)
_____

attribute table manager opens without any problem
_____

v.db.connect map=import_shapefile_with_spaces -p
Vector map <import_shapefile_with_spaces@user1> is connected by:
layer <1> table <import_shapefile_with_spaces> in database
<C:\grassdata\nc_spm_08\user1\dbf\> through driver <dbf> with key <cat>
_____

v.report map=import_shapefile_with_spaces@user1 option=area units=hectares
Displaying column types/names for database connection of layer 1:
cat|onemap_pro|PERIMETER|GEOL250_|GEOL250_ID|GEO_NAME|SHAPE_area|SHAPE_len|area
1|141526064|232209.09375|12|11|Qp|141526058.758|232209.096991|14152.6058758046
2|163779.1875|1767.666138|14|13|Qp|163779.303257|1767.666078|16.3779303256575
3|45783944|43256.566406|15|14|Qp|45783948.3426|43256.564356|4578.39483425879
[...]
_____

v.db.addcol --verbose map=import_shapefile_with_spaces@user1 columns=ncoladd
integer
(Mon Sep 02 11:05:37 2013) Command finished (1 sec)
_____

db.columns --verbose table=import_shapefile_with_spaces
cat
onemap_pro
PERIMETER
GEOL250_
GEOL250_ID
GEO_NAME
SHAPE_area
SHAPE_len
ncoladd
(Mon Sep 02 11:09:08 2013) Command finished (0 sec)
_____

-----
best regards
Helmut
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/failing-to-import-table-tp5075176p5075573.html
Sent from the Grass - Users mailing list archive at Nabble.com.

Paolo_Cavallini · September 2, 2013, 1:11pm

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Il 02/09/2013 11:18, Helmut Kudrnovsky ha scritto:

Moritz Lennert wrote

Have you tried accessing the attribute table ? Working with it through
other modules ?
What does v.db.connect -p give you ?

attribute table manager opens without any problems, some further tests below

Thanks for the tests. So it seems that this is sometimes working, sometimes not,
right? What could be the reason?
All the best.

- --
Paolo Cavallini - Faunalia
www.faunalia.eu
Full contact details at www.faunalia.eu/pc
Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuPG with Icedove - http://www.enigmail.net/

iEYEARECAAYFAlIkjoMACgkQ/NedwLUzIr41kACdE3P/G58Ytb7qXIFtmnVad+9D
EfUAn2ic0pVlYJxtTlVJYjZQtcSy/XxM
=Gvxi
-----END PGP SIGNATURE-----

mlennert · September 2, 2013, 1:30pm

On 02/09/13 15:11, Paolo Cavallini wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Il 02/09/2013 11:18, Helmut Kudrnovsky ha scritto:

Moritz Lennert wrote

Have you tried accessing the attribute table ? Working with it through
other modules ?
What does v.db.connect -p give you ?

attribute table manager opens without any problems, some further tests below

Thanks for the tests. So it seems that this is sometimes working, sometimes not,
right? What could be the reason?

I've just tried again with a freshly checked out and compiled grass64 release branch. I cannot reproduce the error. I'm not sure what might have caused it in my previous run, but at least in the current release branch (and thus 6.4.3 probably) it seems to be working.

Sorry for the noise...

Moritz

Paolo_Cavallini · September 2, 2013, 1:32pm

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Il 02/09/2013 15:30, Moritz Lennert ha scritto:

I've just tried again with a freshly checked out and compiled grass64 release branch.
I cannot reproduce the error. I'm not sure what might have caused it in my previous
run, but at least in the current release branch (and thus 6.4.3 probably) it seems to
be working.

ok, thanks; I'll check again as soon as 6.4.3 hits Debian.
All the best.

- --
Paolo Cavallini - Faunalia
www.faunalia.eu
Full contact details at www.faunalia.eu/pc
Nuovi corsi QGIS e PostGIS: http://www.faunalia.it/calendario
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.14 (GNU/Linux)
Comment: Using GnuPG with Icedove - http://www.enigmail.net/

iEYEARECAAYFAlIkk2MACgkQ/NedwLUzIr4YVQCfca+JAkfRdGaUoKCvPxyQkeql
W58AniC2aHf3EAA+gToy93VPI2kkRaIZ
=Shjh
-----END PGP SIGNATURE-----