Kapalı

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ün: 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

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

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 Daha fazlası

in 3 gün içinde350£ GBP
(15 Değerlendirme)
6.5
in 3 gün içinde20£ GBP
(54 Değerlendirme)
6.0