|
15 |
|
https://mida.cartodb.com/api/v2/sql?format=GeoJSON&q=SELECT%20cartodb_id,%20adgangsadresse_dawa_start,forventet_deltagerantal_max,forventet_deltagerantal_samlet,plotaroute_url,startpunkt,%20name,name_id,%20subject_routename%20as%20subject,%20workflow_title%20AS%20status,%20TO_CHAR(arrangementets_starttidspunkt,%20'YYYY-MM-DD%5C%22T%5C%22HH:MI:SS')%20as%20startdato,%20TO_CHAR(arrangementets_sluttidspunkt,%20'YYYY-MM-DD%5C%22T%5C%22HH:MI:SS')%20as%20slutdato,%20ref,%20agent_name,category_title,%20the_geom%20FROM%20arrangementsruter%20WHERE%20hide%20IN%20('Unchecked')%20AND%20workflow_title%20IN%20('Ans%C3%B8gning%20godkendt','Ans%C3%B8gning%20indsendt','Ans%C3%B8gning%20under%20behandling','Ans%C3%B8gning%20forh%C3%A5ndsgodkendt')%20AND%20workflow_title%20IS%20NOT%20NULL%20AND%20arrangementets_sluttidspunkt%20%3E%20now() |