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

Evner: Kartografi & Kort, Javascript, PostgreSQL

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) United Kingdom

Projekt ID: #15632318

2 freelancere byder i gennemsnit £185 på dette job


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 Flere

£350 GBP in 3 dage
(15 bedømmelser)
£20 GBP in 3 dage
(54 bedømmelser)