/usr/local/bin/ogr2ogr -f "MapInfo File" /var/www/localhost/htdocs/oocms_dde34/cli//docs/tmp/accident_edite749d1af0cb013c4e2b7682ecad4d9c8/accident_edit.mif PG:"hostaddr=127.0.0.1 dbname=dde34 user=postgres" -sql "select "numero_pv", (SELECT lb FROM zone_accident WHERE id=id_zone) AS \"Zone\", date_pv AS \"Date\", heure AS \"Heure\", (SELECT lb FROM type_voie WHERE id=id_type_voie) AS \"Type_de_voie\", numero_voie AS \"Numero_voie\", (SELECT nom_commune FROM communes_lr WHERE ogc_fid=id_commune) AS \"Commune\", (SELECT lb FROM facteur_principal WHERE id=id_facteur_principal) AS \"Cause\", lattitude AS lat, longitude AS long, get_nb_of(implique,ARRAY[1,3],ARRAY[1,2]) AS \"Tues_pieton\", get_nb_of(implique,ARRAY[1,3],ARRAY[1,2]) AS \"Tues_velo\", get_nb_of(implique,ARRAY[1,3],ARRAY[3,2]) AS \"Tues_cyclo\", get_nb_of(implique,ARRAY[1,3],ARRAY[4,2]) AS \"Tues_moto\", get_nb_of(implique,ARRAY[1,3],ARRAY[5,2]) AS \"Tues_vl\", get_nb_of(implique,ARRAY[1,3],ARRAY[6,2]) AS \"Tues_pl\", get_nb_of(implique,ARRAY[1,3],ARRAY[7,2]) AS \"Tues_autres\", get_nb_of(implique,ARRAY[1,3],ARRAY[1,3]) AS \"Bh_pieton\", get_nb_of(implique,ARRAY[1,3],ARRAY[2,3]) AS \"Bh_velo\", get_nb_of(implique,ARRAY[1,3],ARRAY[3,3]) AS \"Bh_cyclo\", get_nb_of(implique,ARRAY[1,3],ARRAY[4,3]) AS \"Bh_moto\", get_nb_of(implique,ARRAY[1,3],ARRAY[5,3]) AS \"BH_vl\", get_nb_of(implique,ARRAY[1,3],ARRAY[6,3]) AS \"Bh_pl\", get_nb_of(implique,ARRAY[1,3],ARRAY[7,3]) AS \"Bh_autres\", get_nb_of(implique,ARRAY[1,3],ARRAY[1,4]) AS \"Bnh_pieton\", get_nb_of(implique,ARRAY[1,3],ARRAY[2,4]) AS \"Bnh_velo\", get_nb_of(implique,ARRAY[1,3],ARRAY[3,4]) AS \"Bnh_cyclo\", get_nb_of(implique,ARRAY[1,3],ARRAY[4,4]) AS \"Bnh_moto\", get_nb_of(implique,ARRAY[1,3],ARRAY[5,4]) AS \"Bnh_vl\", get_nb_of(implique,ARRAY[1,3],ARRAY[6,4]) AS \"Bnh_pl\", get_nb_of(implique,ARRAY[1,3],ARRAY[7,4]) AS \"Bnh_autres\", CASE WHEN get_nb_of(implique,ARRAY[3],ARRAY[2]) > 0 THEN 'T' WHEN get_nb_of(implique,ARRAY[3],ARRAY[3]) > 0 THEN 'BH' WHEN get_nb_of(implique,ARRAY[3],ARRAY[4]) > 0 THEN 'BNH' ELSE 'I' END AS \"GraviteMax\" , PointFromText('POINT(' || "longitude" || ' ' || "lattitude" || ')',4269) as the_geom from "accident_edit" WHERE "longitude"::float > 0 AND "lattitude"::float > 0"