Ceci est une ancienne révision du document !
Tests de regroupement d'observations par mailles
Regrouper 100 000 observations par maille 10x10
Exemple de requête:
SELECT la.area_code, COUNT(s.id_synthese) AS nbr FROM gn_synthese.synthese AS s JOIN gn_synthese.cor_area_synthese AS cas ON (s.id_synthese = cas.id_synthese) JOIN ref_geo.l_areas AS la ON (cas.id_area = la.id_area) WHERE la.id_type = ref_geo.get_id_area_type_by_code('M10') GROUP BY la.id_area LIMIT 100000 ;