public static function propertiesForFeature(MapDBPlacemark $feature) { $sql = 'SELECT property_name, property_value FROM ' . self::PLACEMARK_PROPERTIES_TABLE . ' WHERE placemark_id = ? AND lat = ? AND lon = ?'; $center = $feature->getGeometry()->getCenterCoordinate(); $params = array($feature->getId(), $center['lat'], $center['lon']); $results = self::connection()->query($sql, $params); if ($results) { return $results->fetchAll(); } return array(); }