Subversion Repositories eFlore/Projets.eflore-projets

Rev

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

Rev 1060 Rev 1061
Line 50... Line 50...
50
 
50
 
51
	private function creerTableOsmCommunes() {
51
	private function creerTableOsmCommunes() {
52
		$requete = 'INSERT INTO osm_communes '.
52
		$requete = 'INSERT INTO osm_communes '.
53
			"SELECT osm_id, osm_version, osm_timestamp, name, ref_insee, shape, shape_centroid, wikipedia ".
53
			"SELECT osm_id, osm_version, osm_timestamp, name, ref_insee, shape, shape_centroid, wikipedia ".
54
			"FROM {$this->bddOsmNom}.multipolygons_ref ".
54
			"FROM {$this->bddOsmNom}.multipolygons_ref ".
-
 
55
			"WHERE admin_level = 8 ".
-
 
56
			"AND (ref_insee IS NOT NULL OR ref_insee != '') ".
55
			"WHERE zone = 'france' AND admin_level = 8 ".
57
			"AND CHAR_LENGTH(ref_insee) = 5 ".
56
			' -- '.__FILE__.' : '.__LINE__;
58
			' -- '.__FILE__.' : '.__LINE__;
57
		$this->bdd->requeter($requete);
59
		$this->bdd->requeter($requete);
58
	}
60
	}
59
}
61
}