scraping

RSS feed of planning applications and appeals in Hackney

Submitted by aendrew on Tue, 01/03/2012 - 19:53

UPDATED: Now allows you to filter based on a comma-separated list of wards! More accurate application geolocation data based on eastings/northings! Wicked, yo! See below!

Ever wanted a way to learn about planning applications and appeals in the London borough of Hackney? The borough council's website has an ASP-driven search tool for both applications and appeals, but no way to get the latest ones in something as convenient as an RSS feed.

Tags:

hackney

rss

scraperwiki

scraping

geo

georss

Paul Bradshaw Data Journalism Massive -- scattered notes

Submitted by aendrew on Wed, 10/19/2011 - 15:47

Scraping

Tools:
- OutWit Hub
- Needlebase
- Scraperwiki
- Google Spreadsheets
- Formulae
Walkthru using Google Docs (=import)
1. Open a spreadsheet
2. In A1, type the URL of a page with a table.
3. In cell A2, type: =ImportHTML(A1, "table", 1)
4. Function importHTML($source, $element, $index)
  - Source = Where you're getting data from. Can be a spreadsheet cell.