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 
}