SELECT occurrences_point.name, occurrences_point.type, occurrences_point.date, occurrences_point.id, occurrences_point.image,  ST_AsGeoJSON(occurrences_point.point) as geom FROM occurrences_point, regions where ST_Intersects(occurrences_point.point, regions.geom) and regions.freguesia ='${req.query.locality}'