已关闭

Solve a postgis KNN query

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)'));

技能: 地图学与地图, Javascript, PostgreSQL

查看更多: postgis nearest point, postgis find nearest neighbor, postgis find nearest neighbors, postgis <->, postgresql nearest neighbor, postgis min distance, postgis st_closestpoint, postgis nearest neighbor example, i by nature, I\ m trying to do data entry, i am trying modeling , solve the linear programming problem by the method of corners, i am trying to find someone to design a logo for me, i am trying to find airport marketing manger, directed distance from a line to a point

关于此雇主:
( 0个评论 ) United Kingdom

项目ID: #15632318

2 威客就此工作平均出价 £185

A2Design

Hello, We're a full-cycle team of PHP developers. We specialise in: PHP & PHP frameworks, WordPress & Woocommerce, Opencart, Magento, API development, HTML5, CSS, JavaScript, Bootstrap, MySQL, etc. Get to know 更多

£350 GBP 在3天内
(15条评论)
6.5
£20 GBP 在3天内
(54条评论)
6.0