By axel_ande


2019-04-12 09:29:30 8 Comments

I got a DXF file with some height data which I can easly open in QGIS, the problem is when I import it to QGIS is that the "float" is separated from it's Integer. Instead of one point with 4.8 is there two points one with 4 and one with 8. And those points that is 5.0 does not have its "float" and is just "5". Like this:

Visualizing the data

Is there any tool in QGIS that I can use to combine the float and integer? The "float" is approximativ 1.7m south east of the integer.

1 comments

@axel_ande 2019-04-15 19:23:15

Thanks for the comment!

To solve this problem, I first used the NNJoin plugin and joined all nearest neighbor. The "problem" is that also the points without the float got a joined value, to solve this I used the wedge buffer algoritm where I "targeted" the integer part (NW). Img1 Now I used select by location and selected all "integer parts" so in the picture above the 5 close to 2 was selected but not the single 5 bellow. Then I updated the selected features of that layer and created a new column "not_int" and set it to 1.

Now I wanted to remove all "float" points so then I created a new wedged buffer (SE) and select by location with the new buffer. Then I deleted all selected rows.

Finally I updated the remaining point with this case statement CASE WHEN not_int THEN to_real("Height" +'.'+ "join_Height") ELSE to_real("Height") END

With this result: img2

Related Questions

Sponsored Content

2 Answered Questions

[SOLVED] QGIS custom UTM CRS including zone number in coordinates?

1 Answered Questions

[SOLVED] How to join many points with lines?

  • 2019-01-02 15:25:24
  • Juker92
  • 52 View
  • 1 Score
  • 1 Answer
  • Tags:   qgis

1 Answered Questions

[SOLVED] QGIS 3.2 - Forcing column type when importing csv

  • 2018-10-12 19:40:54
  • Felipe D.
  • 380 View
  • 1 Score
  • 1 Answer
  • Tags:   qgis csv import

0 Answered Questions

How to export "solid" 3D objects from QGIS to DXF?

  • 2018-09-15 10:40:55
  • Tomek
  • 117 View
  • 3 Score
  • 0 Answer
  • Tags:   qgis dxf extrude

1 Answered Questions

[SOLVED] Too many features in QGIS DXF import: 1 Feature per Column

  • 2018-06-28 12:28:00
  • ldfareleira
  • 77 View
  • 1 Score
  • 1 Answer
  • Tags:   qgis dxf

3 Answered Questions

[SOLVED] How to convert Shapefiles to 3D DXF?

  • 2013-04-01 14:59:23
  • Jorge Marques
  • 3728 View
  • 1 Score
  • 3 Answer
  • Tags:   qgis 3d dxf

1 Answered Questions

2 Answered Questions

[SOLVED] Creating Direction data in QGIS between two layers?

  • 2017-06-05 11:42:45
  • Ferenc Lengyel
  • 393 View
  • 6 Score
  • 2 Answer
  • Tags:   qgis table direction

0 Answered Questions

dxf-Export is not readable in BricsCad

  • 2015-03-27 14:55:59
  • klausk
  • 109 View
  • 1 Score
  • 0 Answer
  • Tags:   qgis export dxf

0 Answered Questions

Sponsored Content