Bug report #6481

ftools function "Export/Add geometry columns" produces incorrect dbase field length in results

Added by Stefan Burgstaller over 7 years ago. Updated almost 3 years ago.

Status:Closed
Priority:Normal
Assignee:-
Category:Processing/QGIS
Affected QGIS version:master Regression?:
Operating System: Easy fix?:
Pull Request or Patch supplied:No Resolution:invalid
Crashes QGIS or corrupts data:No Copied to github as #:15709

Description

dBase field length for numeric values is normally limited to 19 digits. When using the "Export/Add geometry columns" function from ftools two new columns "AREA" and "PERIMETER" are created with 21 digits. This can lead to problems with programs or dBase components who do not support such field lengths.

- This is my first bug report so please be so kind to inform me if some information should be missing or wrong -

History

#1 Updated by Giovanni Manghi over 6 years ago

  • OS version deleted (7)
  • Operating System deleted (Windows)

#2 Updated by Médéric RIBREUX over 4 years ago

  • Status changed from Open to Feedback

Hello, bug triage...

I am sorry for such a late answer but do you have any DBase reference about the maximum number for field size and field precision ?

QGIS uses OGR for creating the two new fields and the specification of Shapefile for OGR says this:

Real (floating point) fields without an explicit width are treated as width 24 with 15 decimal places of precision.

If you have a DBase fields specification, the bug should be reported to GDAL...

#3 Updated by Giovanni Manghi about 4 years ago

  • Resolution set to invalid
  • Status changed from Feedback to Closed

closing for lack of feedback, please reopen if necessary.

#4 Updated by Giovanni Manghi almost 3 years ago

The "ftools" category is being removed from the tracker, changing the category of this ticket to "Processing/QGIS" to not leave the category orphaned.

Also available in: Atom PDF