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

Beceriler: Haritacılık &amp; Haritalar, Javascript, PostgreSQL

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) United Kingdom

Proje NO: #15632318

Bu iş için 2 freelancer ortalamada £185 teklif veriyor


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 Daha Fazla

in %bids___i_period_sub_35% gün içinde350%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)
in %bids___i_period_sub_35% gün içinde20%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(54 Değerlendirme)