Hot answers tagged

2

It depends on what coordinate system you're using. If you are using a projected coordinate system (with units in meters or feet), you can use the field calculator (use the Python parser) with this expression: math.hypot(!SHAPE!.firstPoint.X-!SHAPE!.lastPoint.X, !SHAPE!.firstPoint.Y-!SHAPE!.lastPoint.Y) Or if you want distance on the earth's ...


2

You can use Feature Vertices to Points tool with the option to put the points at the Start and End of the line. Then use the Near tool or the Point Distance tool, this will then give you the linear distance between the end and start point. This can be added to a model to automate it. ...


1

You can do this using the Network Analyst Extension. Build a network using your road layer (requires network analyst extension) Identify nearest polygon using point distance tool or near tool (or use existing point if known) Add nearest polygon point and postcode point as stops in the network solver then compute a route distance from your post code point ...


1

Euclidean Distance is an ArcGis tool but can also be an operation in GRASS, QGIS or other software package... If I assume ArcGis I would say have a look at your environment settings especially Output Extent, CellSize and Snap Raster and set all three to your constant raster, but that would only be if you were using ArcGis. – Michael Miles-Stimson


1

I think you're overcomplicating things here when you could use ST_MaxDistance, this will return the maximum distance between two points within two point clouds. WITH points AS( SELECT id, (ST_DumpPoints(lane.geometry)).geom as geom FROM lane GROUP BY id ) , min_distances AS( /*Finds the smallest distance for each distinct tuple ...


1

You'll want to update from the results of another query. For performance it's best to do within the context of an indexed column, so you end up with some ugliness. WITH sums AS ( SELECT a.cartodb_id AS cartodb_id, Count(*) as count, sum(a.popn) as popn FROM populated_places_esp a JOIN populated_places_esp b ON ST_DWithin( ...


1

For euclidean distance: You can use Near Tool to calculate the closest points to your input features. This tool will calculate the closest point for each features in your input layer (it can be line or point type). You need to pass: Input features - highway; Nearest features - points and set radius; than optionally you can mark location and angle. After ...



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