"start_datetime" > '2018-08-01 00:00:00+02' 
AND "end_datetime"  < '2018-08-31 00:00:00+02' 
AND cleaned_geometry && ST_SetSRID(ST_MakeBox2D(ST_Point(2.3500894502,48.8540590792), ST_Point(2.3638760781,48.8580516559)),4326)

select string_agg(reference, ''',''') as reference

from "cyclability_cyclabilityzone"

join "gvSIG_area" on st_contains("gvSIG_area".geo_polygon,"cyclability_cyclabilityzone".geo_polygon) and "gvSIG_area".id = 1313

where "cyclability_cyclabilityzone".administrative_level = 'CITY'

select * from table where value  like any (array['%foo%', '%bar%', '%baz%']);

1. utilisé l'outil v.generalize
2. imput feature = boundary
3. algorithm = lang
4. 
5. type v.out.ogr en sortie =area
6. menu vecteur > outils de geometrie > collecter les geometries