Tag Info

New answers tagged

0

Found the solution. Albeit without SQL style joining, but this structure operates in the same way and is clearer so it is preferable. Double click on the layer you wish to join extra attributes to; Click on 'Joins' on the left; Click the '+' symbol at the bottom to add a new join to the double clicked layer; Select the join layer (layer you wish to take ...


1

Given Paul Ramsey's excellent explanation of why the next question is what can be done about it. How do you SELECT DISTINCT on geometry fields and have it perform as expected? In Paul's answer, I proposed using SELECT MAX(geom) FROM the_table GROUP BY ST_AsBinary(geom); but MAX() is slow, apparently requiring a table scan. Instead, I found this to be ...


0

I'm going to suggest two alternative tools/methods to consider - both do require an Advanced license though, just like Near. Neither make use of buffers, as given the sheer number of records you're working with those would be complicated to work with in a spatial capacity without using a model and iterator. The Near tool only finds the single nearest ...


0

you can create your buffers, then use the Spatial join tool, with the join one to one option. In addition to the optional field statistics, you will have a count field. JOIN_ONE_TO_ONE —If multiple join features are found that have the same spatial relationship with a single target feature, the attributes from the multiple join features will be ...



Top 50 recent answers are included