[GRASS-dev] [GRASS GIS] #550: v.to.3d: column name case sensitive

#550: v.to.3d: column name case sensitive
---------------------+------------------------------------------------------
Reporter: hamish | Owner: grass-dev@lists.osgeo.org
     Type: defect | Status: new
Priority: minor | Milestone: 6.4.0
Component: Vector | Version: svn-develbranch6
Keywords: v.to.3d | Platform: Linux
      Cpu: x86-32 |
---------------------+------------------------------------------------------
Hi,

just had need to use v.to.3d for the first time. It's nice!

minor issue: the imported shapefile created columns named as:
{{{
INTEGER|cat
DOUBLE PRECISION|EASTING
DOUBLE PRECISION|NORTHING
DOUBLE PRECISION|ELEVATION
}}}
(using dbf driver)

I tried to use 'v.to.3d column=elevation' but it exited with the message:
{{{
ERROR: Column <elevation> not found in table <bathymetry_point>
}}}

It needed to see 'column=ELEVATION'. G_strcasecmp() or tolower() needed?

also that failure left an empty map behind.

thanks,
Hamish

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

On 09/04/09 05:10, GRASS GIS wrote:

#550: v.to.3d: column name case sensitive
---------------------+------------------------------------------------------
Reporter: hamish | Owner: grass-dev@lists.osgeo.org
     Type: defect | Status: new Priority: minor | Milestone: 6.4.0 Component: Vector | Version: svn-develbranch6 Keywords: v.to.3d | Platform: Linux Cpu: x86-32 | ---------------------+------------------------------------------------------
Hi,

just had need to use v.to.3d for the first time. It's nice!

minor issue: the imported shapefile created columns named as:
{{{
INTEGER|cat
DOUBLE PRECISION|EASTING
DOUBLE PRECISION|NORTHING
DOUBLE PRECISION|ELEVATION
}}}
(using dbf driver)

I tried to use 'v.to.3d column=elevation' but it exited with the message:
{{{
ERROR: Column <elevation> not found in table <bathymetry_point>
}}}

It needed to see 'column=ELEVATION'. G_strcasecmp() or tolower() needed?

Are column names case insensitive in all db backends ?

Moritz

Dear all,

I have attached a little patch for v.in.dxf. This just makes a small but
useful addition:

it allows parsing of the 'handle' field which exists for every DXF
entity and provides a way for transporting small bits of data in the DXF
file.

The patch is against the current sources in:

http://trac.osgeo.org/grass/browser/grass/trunk

I am not sure which version of GRASS this should go into,
as it does add a new feature (but really just a tiny one).

Cheers,

Ben

--
Benjamin Ducke
Senior Geospatial Consultant

Oxford Archaeology
Janus House
Osney Mead
OX2 0ES
Oxford, U.K.

Tel: +44 (0)1865 263 800 (switchboard)
Tel: +44 (0)1865 980 758 (direct)
Fax :+44 (0)1865 793 496
benjamin.ducke@oxfordarch.co.uk

------
Files attached to this email may be in ISO 26300 format (OASIS Open Document Format). If you have difficulty opening them, please visit http://iso26300.info for more information.

(attachments)

v.in.dxf.patch (21.3 KB)

#550: v.to.3d: column name case sensitive
---------------------+------------------------------------------------------
  Reporter: hamish | Owner: grass-dev@lists.osgeo.org
      Type: defect | Status: new
  Priority: minor | Milestone: 6.4.0
Component: Vector | Version: svn-develbranch6
Resolution: | Keywords: v.to.3d
  Platform: Linux | Cpu: x86-32
---------------------+------------------------------------------------------
Comment (by martinl):

Replying to [ticket:550 hamish]:
> also that failure left an empty map behind.

Fixed in r38297.

Martin

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

#550: v.to.3d: column name case sensitive
---------------------+------------------------------------------------------
  Reporter: hamish | Owner: grass-dev@lists.osgeo.org
      Type: defect | Status: new
  Priority: minor | Milestone: 6.4.0
Component: Vector | Version: svn-develbranch6
Resolution: | Keywords: v.to.3d
  Platform: Linux | Cpu: x86-32
---------------------+------------------------------------------------------
Comment (by martinl):

Replying to [ticket:550 hamish]:
> It needed to see 'column=ELEVATION'. G_strcasecmp() or tolower() needed?

It seems to be related to the db drivers, not v.to.3d.

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

#550: v.to.3d: column name case sensitive
---------------------+------------------------------------------------------
  Reporter: hamish | Owner: grass-dev@…
      Type: defect | Status: closed
  Priority: minor | Milestone: 6.4.0
Component: Vector | Version: svn-develbranch6
Resolution: fixed | Keywords: v.to.3d
  Platform: Linux | Cpu: x86-32
---------------------+------------------------------------------------------
Changes (by neteler):

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

Comment:

The fix has been backported to G6 long time ago, closing.

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