Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 1063 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1063 Rev 1066
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);