search

Liverpool-UK / somebody-should

A place to collect issues/suggestions/to-do items for the city of Liverpool
10 stars 1 forks source link

Make planning application information more readily available/usable #33

Open amcewen opened 6 years ago

amcewen commented 6 years ago

Now that we've got some open data of the planning applications in #32, it would be good to work out what we might do with it. A sqlite database is useful for us techies, but not that accessible to most of the population :-)

I wrote up some of what I'd like to have from the planning data a while back - http://www.mcqn.net/mcfilter/archives/urbanism/opening_up_planning_awareness.html

What are the use cases that planning data could help with? What would you like to know about planning applications?

amcewen commented 6 years ago

There's been some discussion on Twitter about getting better geolocation into the dataset to allow mapping of the applications.

I think a set of Twitter bots which tweet details of applications would be good, so you could follow the planning_L3_8 twitter account and see tweets like "[NEW] application for extension at 23 Some Street, details at http://..." or "[APPROVED] To display 2 no. non-illuminated wall mounted signs above entrance to premises [...] details at http://..." for any applications in L3 8xx postcodes (so things not too far from DoES Liverpool), and likewise for other postcodes...

adrianshort commented 6 years ago

https://github.com/adrianshort/kiosks is very nearly a generic planning applications browser. Adding RSS feeds would be useful to drive Twitter bots and lots of other things:

https://github.com/adrianshort/kiosks/issues/2

kiosks adrianshort org system architecture

amcewen commented 4 years ago

So, today I managed to beat Travis-CI and Heroku into submission to publish a browsable version of the data with Datasette, at https://lcr-planning.herokuapp.com/

That will (fingers-crossed) update daily to the latest version of the database. Next step will be to play around with the additional tools and views that datasette can generate (I'm pretty sure it can build atom feeds, for example...)

amcewen commented 4 years ago

I've added code to geocode new applications, and slowly work through the backlog of the existing 11000 applications in the database to geocode them too. The geocoding is actually to the postcode rather than the application itself, so might be off by a bit.

I expect by the time i do any more poking at this it will have worked its way through all of the backlog, so then I'll be able to look at showing the applications on a map in datasette!