Esempio n. 1
0
 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();
 }