Skip to main content

I have a tree canopy coverage layer where tree canopies are overlaid. The layer contains around 5,000,000 entities and I need... :

1) remove the overlapping area of the entities (I've tried with the space and overlap cleaner but it takes too long, I have 32gb RAM)

2) merge all entities into one, and for display performance reasons, the resulting layer must be cut on a 1 km or 500 m grid.

 

In attached an exemple of the layer

 

Any idea how to proceed? Thanks to all

I would use Dissolver to merge all overlapping and then use the Tiler to tile up the data into tile chunks of your required size.

It miiiiiight be faster to do it the other way around though (tile then dissolve grouping by tile row and column)


I would use Dissolver to merge all overlapping and then use the Tiler to tile up the data into tile chunks of your required size.

It miiiiiight be faster to do it the other way around though (tile then dissolve grouping by tile row and column)

Thank you for your answer. I will try, it makes sense to do it in the other way (tile and then dissolve)


@virtualcitymatt​  in fact i already made the dissolve and i get about 370.000 entities, but in tiler process i have an error the ID, "OGCGEOPACKAGE writer: failed to execute insert : UNIQUE constraint failed". When i check, in fact, the tiler cut the dissolved polygones but conserve the same FID of the polygones input, and the procces its stopedissue


Hey @pabloolivaresm​ 

 

you could remove the attribute ID or rename it

 

Solution is here ->

OGC Geopackage Writer and UNIQUE constraint failed

 

BG Michael


Thanks @featuremichael​  After a break, I finally did it. With the TILER I got a grid, but my original idea was cut the originals polygones in a lot of small polygones by a grid. Because for display performance its still too heavy with about 400.000 entities. tiler


if you want to reduce the vertices of your areas. you can now use your "tiled data" with the transfromer "generalizer" and the "douglas algorithm" + "perserve shared boundaries" to "yes" if there are more areas are touching each other.


I come back after a break time. It works, but now I would like to erase the small holes that are between the polygones. Exist some tool to "merge" all this holes in the threes polygones?


i would try the donutholeextractor and then the area calculator to know what holes should proceeding and then a spatial filter looking for touching this areas with the tree attribute to merge if they touch each others and then give merge this with the dissolver 🙂 that’s the fastest way my brain would use 😉✌️


@featuremichael​ thanks to answer again! I tryed but i get more or less the same feature that without the donutholeextractor, area calculator and spatial filter. In the spatial filter, the candidate are the holes and the filter it is the tree layers? I dit it in the other way, with tree layer as candidate, maybe that's my error 😶 ? I did'n understund why I need to calculate area to do the spatial filter


I didn't say but I have some "holes" that I would like to keep as holes, becauses they are not really part of tree layer (In the image, N°1 red square), and the others (small red square N°2) I need to dissolve with the tree polygon


@pabloolivaresm​ sry my bad about the area calculator 😉 the area calculator is used to know what holes are to get merged with the trees areas (because I thought you will not use big spaces between the trees to merge this hole all together), so you can set a spezific area size that’s lower than x areasize to proceed this holes (don’t forget to set a tester) BG Michael


@featuremichael​ thanks to answer again! I tryed but i get more or less the same feature that without the donutholeextractor, area calculator and spatial filter. In the spatial filter, the candidate are the holes and the filter it is the tree layers? I dit it in the other way, with tree layer as candidate, maybe that's my error 😶 ? I did'n understund why I need to calculate area to do the spatial filter

And yes u could use only the spatialfilter didn’t had this known without looking into the transformers I tried it out of my memories to help you, sry my bad


Reply