|
15 |
|
https://mida.cartodb.com/api/v2/sql?format=GeoJSON&q=SELECT%20cartodb_id,%20status,%20to_date(startdato,%20'YYYY-MM-DDTHH:MI:SS')%20%252B%20interval%20'1%20day'%20as%20startdato,%20to_date(reel_slutdato,%20'YYYY-MM-DDTHH:MI:SS')%20%252B%20interval%20'1%20day'%20as%20slutdato,%20vejnavn,%20type,%20tilladelsesnr,sagsbeh_navn,the_geom%20FROM%20vm_tilladelser_2%20WHERE%20type%20IN%20('Materiel')%20AND%20type%20IS%20NOT%20NULL%20AND%20status%20IN%20('Godkendt')%20AND%20status%20IS%20NOT%20NULL%20AND%20the_geom%20IS%20NOT%20NULL%20AND%20to_date(reel_slutdato,'YYYY-MM-DDTHH:MI:SS')%20%3E%20now() |