GetFeatureOfInterest returns multiple instances for the same feature if the geometry is resolved via associated stations

[matthesrieke]

The DB query is not DISTINCT on PK_FEATUREOFINTEREST. Though, DISTINCT is not allowed as the query selects shapes. A workaround might use ROW_NUMBER function (SQL):

SELECT  *
FROM    (SELECT Airquality_E2a.DBO.FEATUREOFINTEREST.PK_FEATUREOFINTEREST,Airquality_E2a.DBO.FEATUREOFINTEREST.ID,Airquality_E2a.DBO.FEATUREOFINTEREST.RESOURCE,Airquality_E2a.DBO.FEATUREOFINTEREST.INLETHEIGHT,Airquality_E2a.DBO.FEATUREOFINTEREST.BUILDINGDISTANCE,Airquality_E2a.DBO.FEATUREOFINTEREST.KERBDISTANCE,Airquality_E2a.DBO.STATION.Shape, ROW_NUMBER() OVER (PARTITION BY Airquality_E2a.DBO.FEATUREOFINTEREST.PK_FEATUREOFINTEREST ORDER BY Airquality_E2a.DBO.FEATUREOFINTEREST.PK_FEATUREOFINTEREST) AS RowNumber
FROM Airquality_E2a.DBO.FEATUREOFINTEREST,Airquality_E2a.DBO.STATION
WHERE (Airquality_E2a.DBO.FEATUREOFINTEREST.RESOURCE = 'http://cdr.eionet.europa.eu/hu/eu/aqd/d/envut_vxq/REP_D-HU_OMSZ_20140122_D-001.xml#SPO_F-HU0002A_00001_500_500' AND Airquality_E2a.DBO.STATION.Shape IS NOT NULL)
) AS a
WHERE   a.RowNumber = 1