| Line 64... |
Line 64... |
| 64 |
"if(iso3166_2 != '', CONCAT('ISO-3166-2:',iso3166_2), ".
|
64 |
"if(iso3166_2 != '', CONCAT('ISO-3166-2:',iso3166_2), ".
|
| 65 |
"if(iso3166_1 != '', CONCAT('ISO-3166-1:',iso3166_1), ".
|
65 |
"if(iso3166_1 != '', CONCAT('ISO-3166-1:',iso3166_1), ".
|
| 66 |
"CONCAT('OSM-ID:',osm_id)))))), ".
|
66 |
"CONCAT('OSM-ID:',osm_id)))))), ".
|
| 67 |
'osm_id, osm_version, osm_timestamp, '.
|
67 |
'osm_id, osm_version, osm_timestamp, '.
|
| 68 |
"if(name_fr != '', name_fr, name), ".
|
68 |
"if(name_fr != '', name_fr, name), ".
|
| 69 |
'shape, shape_centroid, Y(shape_centroid), X(shape_centroid), '.
|
69 |
'shape, shape_centroid, Y(shape_centroid), X(shape_centroid), zone, '.
|
| 70 |
'admin_level, iso3166_1, iso3166_2, ref_insee, ref_nuts, '.
|
70 |
'admin_level, iso3166_1, iso3166_2, ref_insee, ref_nuts, '.
|
| 71 |
'name, name_fr, name_en, name_es, wikipedia '.
|
71 |
'name, name_fr, name_en, name_es, wikipedia '.
|
| 72 |
"FROM {$this->bddOsmNom}.multipolygons_ref ".
|
72 |
"FROM {$this->bddOsmNom}.multipolygons_ref ".
|
| 73 |
' -- '.__FILE__.' : '.__LINE__;
|
73 |
' -- '.__FILE__.' : '.__LINE__;
|
| 74 |
$this->bdd->requeter($requete);
|
74 |
$this->bdd->requeter($requete);
|