New answers tagged nearest-neighbor
These two comparable tools exist because ESRI has multiple license levels. Point to Raster (Conversion) is only available with the Advanced license. Feature to Raster (Conversion) is available with all of the license levels. Point to Raster allows you much more control over how multiple points are handled when multiple points fall within a raster cell. ...
The aproach with cross-join doesn't use indexes and requires a lot of memory. So you basically have two choices. Pre 9.3 you'd use a correlated subquery. 9.3+ you can use a LATERAL JOIN. KNN GIST with a Lateral twist Coming soon to a database near you (exact queries to follow soon)
You are nearly there. There is a little trick which is to use Postgres's distinct operator, which will return the first match of each combination -- as you are ordering by ST_Distance, effectively it will return the closest point from each senal to each port. SELECT DISTINCT ON (senal.id) senal.id, port.id, ST_Distance(port."GEOMETRY", senal."GEOMETRY") ...
Just save the ruleset (Develope Ruleset Mode ("4" in the toolbar)) to a file you like. The samples are saved along with the ruleset.
in agreement with PolyGeo - you mentioned 'Made Eastings and Northings into Number format', which leads me to believe most (all?) of the columns are actually text, simply formatted to look like numbers. In some datasets, 'M' can mean 'missing data', which would also account for but a text field and the error. you could try to add a new column to hold a new Z ...
Top 50 recent answers are included