metazool / commercial_property_in_edinburgh

Commercial property in Edinburgh


README

This was originally crawling proprietor data as well, i commented that out because at one request per record, that was causing a lot of CPU load on ScraperWiki

There is also a daily rate limit at SAA. Not apparent what it is, must be pretty high considering.

In the end i went through postcode outcodes, adding the first number of the incode for the really big ones. I’ll look at the property data first and then more selectively scrape the ownership info.

I meant to add this fascinating link describing outcode areas: http://en.wikipedia.org/wiki/EH_postcode_area

Forked from ScraperWiki

Contributors metazool

This scraper has not yet been run

Data

Downloaded 1 time by MikeRalphson

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (0 Bytes) Use the API

rows 10 / 20910

lonlat postcode unlock_id
-3.4472816752130546, 55.93666296900026
EH52 5AU
12352326
-3.4469864292727133, 55.95923252637617
EH52 6QW
12352722
-3.4454060788734284, 55.89832876004926
EH53 0HS
12352903
-3.4450992682138883, 55.93524169628918
EH52 5BQ
12352334
-3.4439832624781426, 55.90050232355873
EH53 0HJ
12352899
-3.4433595523505804, 55.93065180746065
EH52 5QB
12352471
-3.4432159631495116, 55.946596251437605
EH52 5PY
12352468
-3.4426375980562094, 55.96205146823359
EH52 6QN
12352715
-3.442623386986927, 55.928934943861364
EH52 5PB
12352452
-3.4421523851455955, 55.93823291973805
EH52 5AQ
12352322

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (0 Bytes) Use the API

rows 10 / 138

description rateable ref_no proprietor address occupier more
YARD
22,500
331C119AW(11)
ELIZABETH GRIEVE CAMPS COTTAGE CAMPS IND ESTATE KIRKNEWTON EH27 8DF
(11) CAMPS EAST CALDER WEST LOTHIAN EH27 8DF
Vacant
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH27+8DF&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&DISPLAY_MODE=FULL&UARN=331C119AW%2811%29&PPRN=000000000026974&ASSESSOR_IDX=10&#results
YARD
3,450
331C119AW(12)
ELIZABETH GRIEVE CAMPS COTTAGE CAMPS IND ESTATE KIRKNEWTON EH27 8DF
(12) CAMPS EAST CALDER WEST LOTHIAN EH27 8DF
Vacant
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH27+8DF&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&DISPLAY_MODE=FULL&UARN=331C119AW%2812%29&PPRN=000000000026975&ASSESSOR_IDX=10&#results
STORE
8,600
331C121AW(18)
ANGLE PARK PROPERTIES 99 SLATEFORD ROAD EDINBURGH EH11 1QY
(18) CAMPS INDUSTRIAL ESTATE EAST CALDER WEST LOTHIAN EH27 8DF
ROSS MACKINNON T/A ELITE AUTO CARE 15 KENNEDIE PARK MID CALDER WEST LOTHIAN EH53 0RG
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH27+8DF&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&DISPLAY_MODE=FULL&UARN=331C121AW%2818%29&PPRN=000000000026999&ASSESSOR_IDX=10&#results
YARD
1,600
331C121AW(18B)
ANGLE PARK PROPERTIES 99 SLATEFORD ROAD EDINBURGH EH11 1QY
(18B) CAMPS INDUSTRIAL ESTATE EAST CALDER WEST LOTHIAN EH27 8DF
ANGLE PARK PROPERTIES 99 SLATEFORD ROAD EDINBURGH EH11 1QY
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH27+8DF&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&DISPLAY_MODE=FULL&UARN=331C121AW%2818B%29&PPRN=000000000474587&ASSESSOR_IDX=10&#results
POTTERY
1,100
331C119AW(2A)
MR GAVIN MURRAY 22 HOLLYHOCK GLADE ADAMBRAE PARKS ESTATE LIVINGSTON WEST LOTHIAN EH54 9JQ
(2A) CAMPS EAST CALDER WEST LOTHIAN EH27 8DF
MR GAVIN MURRAY 22 HOLLYHOCK GLADE ADAMBRAE PARKS ESTATE LIVINGSTON WEST LOTHIAN EH54 9JQ
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH27+8DF&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&DISPLAY_MODE=FULL&UARN=331C119AW%282A%29&PPRN=000000000026969&ASSESSOR_IDX=10&#results
YARD
9,200
331C119AW(3)
HENRY GRANT CARRIDEN INDUSTRIAL ESATE BRIDGENESS ROAD BO'NESS EH51 9LH
(3) CAMPS EAST CALDER WEST LOTHIAN EH27 8DF
HENRY GRANT CARRIDEN INDUSTRIAL ESATE BRIDGENESS ROAD BO'NESS EH51 9LH
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH27+8DF&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&DISPLAY_MODE=FULL&UARN=331C119AW%283%29&PPRN=000000000455038&ASSESSOR_IDX=10&#results
STORE
80,600
331R296AW(3)
J.B. MCBEAN (HAULAGE) LTD.
(3) RAW CAMPS EAST CALDER WEST LOTHIAN EH27 8DF
J.B. MCBEAN (HAULAGE) LTD.
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH27+8DF&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&DISPLAY_MODE=FULL&UARN=331R296AW%283%29&PPRN=000000000027086&ASSESSOR_IDX=10&#results
WORKSHOP
3,400
331C119AW(4/1)
PAUL CRANE & SONS (BUTCHERS) LTD.
(4/1) CAMPS EAST CALDER WEST LOTHIAN EH27 8DF
PAUL CRANE & SONS (BUTCHERS) LTD.
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH27+8DF&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&DISPLAY_MODE=FULL&UARN=331C119AW%284%2F1%29&PPRN=000000000026971&ASSESSOR_IDX=10&#results
GARAGE
20,500
331C121AW(6)
NISBET OF KIRKNEWTON LTD (6) CAMPS INDUSTRIAL ESTATE KIKNEWTON WEST LOTHIAN EH27 8DF
(6) CAMPS INDUSTRIAL ESTATE EAST CALDER WEST LOTHIAN EH27 8DF
NISBET OF KIRKNEWTON LTD (6) CAMPS INDUSTRIAL ESTATE KIKNEWTON WEST LOTHIAN EH27 8DF
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH27+8DF&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&DISPLAY_MODE=FULL&UARN=331C121AW%286%29&PPRN=000000000026984&ASSESSOR_IDX=10&#results
STORE
10,400
331C121AW(7A)
AAA COACHES 7 CAMPS INDUSTRIAL ESTATE EAST CALDER WEST LOTHIAN EH27 8DF
(7A) CAMPS INDUSTRIAL ESTATE EAST CALDER WEST LOTHIAN EH27 8DF
CHARLES LAING AND SON (7A) CAMPS INDUSTRIAL ESTATE EAST CALDER EH27 8DF
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH27+8DF&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&DISPLAY_MODE=FULL&UARN=331C121AW%287A%29&PPRN=000000000026986&ASSESSOR_IDX=10&#results

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (0 Bytes) Use the API

rows 10 / 21472

description rateable ref_no proprietor address occupier postcode more rates lonlat lon lat
OFFICE
44600
116A58318
18 ALVA STREET EDINBURGH EH2 4QN
GRANITE EDGE LTD GRANITE HOUSE 18 ALVA STREET EDINBURGH EH2 4QG
EH2 4QN
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH2+4&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&PT=1&DISPLAY_MODE=FULL&UARN=116A58318&PPRN=000000000003199&ASSESSOR_IDX=10&#results
SHOP
45600
118H71919
19 HOPE STREET EDINBURGH EH2 4ES
THE ORVIS COMPANY INC.
EH2 4ES
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH2+4&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&PT=1&DISPLAY_MODE=FULL&UARN=118H71919&PPRN=000000000005756&ASSESSOR_IDX=10&#results
CAFE
150500
118G110106-106B
106-106B GEORGE STREET EDINBURGH EH2 4LJ
STARBUCKS COFFEE COMPANY (UK) LTD BUILDING 4 CHISWICK PARK 566 CHISWICK HIGH ROAD LONDON W4 5YE
EH2 4LJ
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH2+4&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&PT=1&DISPLAY_MODE=FULL&UARN=118G110106-106B&PPRN=000000000005385&ASSESSOR_IDX=10&#results
GARDEN
0
118A270(A)
(A) AINSLIE PLACE EDINBURGH EH3 1XX
Vacant
EH3 1XX
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH3+1&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&DISPLAY_MODE=FULL&UARN=118A270%28A%29&PPRN=000000000004455&ASSESSOR_IDX=10&#results
GARDEN
0
118M672(51)
(51) MORAY PLACE EDINBURGH EH3 1XX
Vacant
EH3 1XX
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH3+1&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&DISPLAY_MODE=FULL&UARN=118M672%2851%29&PPRN=000000000005861&ASSESSOR_IDX=10&#results
LOCK-UP
1600
118S165(8)
(8) SCOTLAND STREET LANE, EAST EDINBURGH EH3 3PR
DERMOT M FERRIGAN 18 CRAIGCROOK ROAD EDINBURGH EH4 3NQ
EH3 3PR
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH3+3&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&DISPLAY_MODE=FULL&UARN=118S165%288%29&PPRN=000000000471521&ASSESSOR_IDX=10&#results
SHOP
43300
117D882117
117 DUNDAS STREET EDINBURGH EH3 5DE
KITCHENS INTERNATIONAL LTD 11 YOUNGS ROAD EAST MAINS INDUSTRIAL ESTATE BROXBURN EH52 5LY
EH3 5DE
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH3+5&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&PT=1&DISPLAY_MODE=FULL&UARN=117D882117&PPRN=000000000004124&ASSESSOR_IDX=10&#results
TENNIS COURT
2700
118S165(1)
DRUMMOND LTC,(1) SCOTLAND STREET LANE, EAST EDINBURGH EH3 6PR
DRUMMOND LAWN TENNIS CLUB PER RYAN DEELEY (PRESIDENT) 4/3 DEAN PARK STREET EDINBURGH EH4 1JL
EH3 6PR
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH3+6&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&DISPLAY_MODE=FULL&UARN=118S165%281%29&PPRN=000000000006528&ASSESSOR_IDX=10&#results
SELF CATERING UNIT
9300
117F41428/7
28/7 FETTES ROW EDINBURGH EH3 6UT
GRAHAM BRIGHTWELL 5 KINGSWOOD AVENUE HAMPTON MIDDLESEX TW12 3AU
EH3 6UT
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH3+6&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&PT=1&DISPLAY_MODE=FULL&UARN=117F41428%2F7&PPRN=000000000468550&ASSESSOR_IDX=10&#results
OFFICE
3125000
117F41434
34 FETTES ROW EDINBURGH EH3 6UT
DIRECT LINE INSURANCE PLC
EH3 6UT
/search.php?SEARCHED=1&ST=advanced&SEARCH_TABLE=valuation_roll&TYPE_FLAG=C&x=11&y=6&AS_UARN=&DISPLAY_COUNT=100&POSTCODE=EH3+6&ASSESSOR_ID=&ORDER_BY=SET+DESC&SEARCH_TERM=&STREET=&TPTLA=&FEFFECTIVE_DATE=&TEFFECTIVE_DATE=&MIN_RV=&MAX_RV=&PT=1&DISPLAY_MODE=FULL&UARN=117F41434&PPRN=000000000004165&ASSESSOR_IDX=10&#results

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (0 Bytes) Use the API

rows 10 / 774

postcode
EH1 1AA
EH1 1BA
EH1 1BH
EH1 1EU
EH1 1JD
EH1 1RU
EH1 2AQ
EH1 2EB
EH1 2NR
EH1 2NZ

Statistics

Total run time: less than 5 seconds

Total cpu time used: less than 5 seconds

Total disk space used: 30.2 KB

History