Latest Contributions by SalmanAhmed

Yes I did exactly what I did before except changing the match option to have their center in. I think the above results are correct for that match option. Only the little polygons inside which the larger polygons' centers lie are listed. ... View more

No doing this now gives me a very different and incorrect result. ... View more

Thank you. That was very helpful. I did it but one little problem with one row. You can see in the picture. There are clearly two polygons (Monschau and Simmerath) joined inside the selected polygon. But the table just lists Monschau alone. I don't understand why. In dissolve I selected CONTAINS as the join type. ... View more

I'm sorry I didn't understand. Use join table to join the two ? How do I use this separator? ... View more

Many thanks!! ... View more

The resulting shapefile is perfect, thanks. ... View more

Thank you so much for your work. Although a bit unreadable, this script is very very valuable for me and I will try to understand it. A question though - how do I download your attachment here? I don't even see it anywhere. ... View more

Dropbox - Geodata.rar Ah I think I missed those two when I was deleting each polygon joining with itself after the spatial join. Now I have deleted them here and performed the selection again. Hmmm if I could still see the names of the municipalities merged within each big polygons in the attribute table then it would be really helpful. ... View more

Hello, In your example I would then want Bergheim, Kerpen, Frechen and Koln all dissolved into one polygon. It is a kind of chain that is formed. From Bergheim highest no. of commuters go to Kerpen so dissolve Bergheim with Kerpen. From Kerpen highest no. goes to Frechen. So dissolve Kerpen with Frechen. But Kerpen was already dissolved with Bergheim in the first step so now that polygon which was dissolved before (Bergheim + Kerpen) will further dissolve with Frechen. And this chain will continue for Koln and further. I do believe that at some point this chain will break when for example the highest no. of commuters will go from Koln back to Frechen, then this chain will stop. And similarly other chain have to be created. Hope you get the idea. And the polygons contain the origin geometry but its better to look at the destinations in the attribute table because in the destination field each name comes only once. But in the origin field it may come multiple times. ... View more

Dropbox - Dataset.rar Here you go. I'm sorry I don't know how I can attach a rar file here directly. So the spatial join shapefile is the one in which the dissolve is to be done. And the selection shapefile has the attribute table that shows which polygon(destination) needs to be dissolved with which other(origin). ... View more

First thing - I think statistic field with first or last option for OriginID would not work because if the first name in the origin field for a destination is not the one with maximum commuters then it would select that first name but give the max commuter value from some other name. Same goes for the last option. So it will be mismatch between origin and commuter value. Second thing - yes this can be done but any idea how I would then combine origin and destination polygons for each row after this? ... View more

I do have a field that gives a unique ID to every origin-destination pair. But dont know how that would help to combine polygons. ... View more

Oh Im so sorry I read the names wrong. I was saying Bergkamen for Werne and not Unna. Its just an example. And Bergkamen is there is the destination field further down the table as well. This is not the whole table its just a screenshort. There are around 400 features in total which include each name in the destination field. ... View more

Okay so dissolve still only gives the maximum value for each city. For example it only returns the row with Unna and Bergkamen and removes all other Unna rows. That is the first step but the second and more important thing I want to do is to then make Unna merge with Bergkamen into one polygon somehow. Any ideas about that? ... View more