Subscribe to this thread
Home - General / All posts - Put small areas to the next larger one
klausk115 post(s)
#05-Nov-14 08:13

Hallo,

How can I merge small areas lower the 5 m² to the next larger one??

Thk Klaus

volker

1,086 post(s)
#06-Nov-14 19:32

Not directly what you want but it should work.

In this query you need a column [DISTRIKT] ,

[ABTEILUNG] and [TEXT]. The [TEXT] of your

Areas <5m² must be empty. The [TEXT] of your

areas >=5m² must be filled.

Run the query twice or more to fill all areas.

A query of Tim (tjhb):

____________________________________________

--SQL

--In allen Nichtholzbodenflächen wird das Feld [TEXT]

--mit der TEXT des größten Bestandes aus derselben Abteilung gefüllt

--Bezeichnung des DRAWINGS ändern !

UPDATE

-- start of (3) - rearrange WEFL with corrosponding first NeighborWEFL

( SELECT [D14].[TEXT] AS [TEXT], [NeigborWEFL] FROM

-- Start of (2) - aggregate [ID], First NeighborWEFL from ordered list

( SELECT [ID], First([NeigborWEFL]) AS [NeigborWEFL] FROM

-- Start of (1) - oder list of neighbours

( SELECT [D11].[ID], [D12].[TEXT] AS [NeigborWEFL],

CASE WHEN [D11].[DISTRIKT] = [D12].[DISTRIKT] AND [D11].[ABTEILUNG] = [D12].[ABTEILUNG] THEN 0

WHEN [D11].[DISTRIKT] = [D12].[DISTRIKT] THEN 1

WHEN [D11].[ABTEILUNG] = [D12].[ABTEILUNG] THEN 2

ELSE 3

END AS [Weight],

[D12].[AREA (I)] AS [Area]

FROM [119_36_wefl] AS [D11] INNER JOIN [119_36_wefl] AS [D12]

ON Adjacent([D11].[ID],[D12].[ID])

WHERE TRIM([D11].[TEXT]) = "" AND TRIM([D12].[TEXT]) <> ""

ORDER BY [ID],[Weight],[Area] DESC ) -- END OF (1)

GROUP BY [ID] ) AS [D13] -- END OF (2)

JOIN [119_36_wefl] AS [D14] ON [D14].[ID] = [D13].[ID] ) -- END OF (3)

SET [TEXT] = [NeigborWEFL]


http://www.thegisservicesector.de

volker

1,086 post(s)
#07-Nov-14 07:45

What i forgot: After this you must dissolve with Usuíng [TEXT].


http://www.thegisservicesector.de

mapasPT1

468 post(s)
#13-Nov-14 20:49

http://www.georeference.org/doc/edit_toolbar.htm

Manifold User Community Use Agreement Copyright (C) 2007-2021 Manifold Software Limited. All rights reserved.