qgis_postgis
Table des matières
Exemple de requête POSTGIS sous QGIS
Télécharger une BBOX
"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)
concaténer reference commune
select string_agg(reference, ''',''') as reference from communes
like sur plusieurs valeurs
select * from table where value like any (array['%foo%', '%bar%', '%baz%']);
Memo QGIS
simplifier limites communes
qgis_postgis.txt · Dernière modification : de simon

