Solve a postgis KNN query
Closed
Posted
6 years ago
Paid on delivery
£10-20 GBP
Paid on delivery
Closed
Paid on delivery
I am trying to return this query with the four nearest neighbours but cannot get the syntax right as im new to postgis. This should be simple for someone with experience with postgis. Would really appreciate help with this one.
var query3 = $.getJSON(('[url removed, login to view] * FROM "mapcomm-admin".permaculture_groups_gb_sct ORDER BY ST_Distance("mapcomm-admin".[url removed, login to view] <-> SRID=26918;POINT(583571.905921312 4506714.34119218) ::geometry)'));
Project ID: #15632318
About the project
2 proposals
Remote project
Active 6 years ago