"The explosive growth of the GeoWeb and geographic information has made GIS powerful media for the general public to communicate, but perhaps more importantly, GIS have also become media for constructive dialogs and interactions about social issues." - Sui & Goodchild
Le point de départ était la BD précarité.ch brut de SQL et de CSV : precarite.dump.zip
SELECT ad_geo.title, ad_geo.id, theme.title FROM public.ad_geo, public.ad_theme, public.theme WHERE ad_geo.id::int = ad_theme.ad_id AND ad_theme.theme_id = theme.id;