Tag Info

Hot answers tagged

3

I think you want to exclude the intersection of the buffer in the where clause. WITH subq AS ( SELECT p.id, p.name, unnest(ARRAY(SELECT q.name FROM w_point q WHERE p.id != q.id AND NOT ST_Intersects(q.geom, ST_Buffer(p.geom, 0.1)) ORDER BY ST_Buffer(p.geom, 0.1) <#> q.geom LIMIT 5) ) as name FROM w_point p ) SELECT ...


2

This can be achieved in several steps. Run a Spatial Join for your buffer polygons and road network layers (right-click the buffer polygons layer in the TOC and choose Join and Relates > Join). You will get an output polygon feature class which contains information on how many road features were located (even partially) within the buffered polygons. ...


1

The function (Locate Features Along Routes) should locate any lines within the search radius without any need for buffering. Be aware that the function will give you results against both branches for the part north of the intersection, as both "legs" will be within the radius. The result will be a table with the from-to measures from your routes per object ...


1

Your buffer distance is given in the units of your dataset. Your coordinate system is lon/lat geographic. Thus 0.01 = 0.01 decimal degrees. To be able to buffer by 1 km (1000 m) you need to reproject your dataset to a projected coordinate system which has units in metres. There are examples in the Python GDAL/OGR Cookbook of how to reproject layers and ...


1

The easy way is to use Zonal statistics as a table to extract the mean value for all buffers, then join the table to your shapefile. However, there might be a problem if your buffers overlap : in this case, it gets more difficult because you need to iterate on each polygon (e.g. in model builder). Alternatively, you can use focal statistics with a circular ...


1

You can use Expand to buffer raster "zones" that represent specific values in the raster. Buffers value 10 by 3 cells Expand("landcover", 3, [10])


1

You can use the euclidean distance tool, see: http://resources.arcgis.com/en/help/main/10.2/index.html#//009z0000001p000000


1

I suggest that you use the unsplit line tool instead of dissolve. This will be based on the geometry and not on some attribute which do not seem consistent in your example (merging 1 with 2). In order to get the attribute, I would convert the length to a large integer value (round and multiply by 1000), ask for the "MAX" of this new field and join the table ...


1

If the points that you want to join is really identical (you wrote one table is a subset of the other) you should be able to just join on intersecting bboxes. If you have a working spatial index that will be very fast. Just use the && operator between the points. If the points is not identical you can expand one of the bboxes. That is what ...



Only top voted, non community-wiki answers of a minimum length are eligible