edrandall / thames_cso_locations

Thames CSO locations


Last run completed successfully .

Console output of last run

Injecting configuration and compiling... Injecting scraper and running... Scraping Outfall dataset: Crane-Outfall-Safari from: http://plus.epicollect.net/RiverCraneZSL/download Saved row: (Crane-Outfall-Safari,732871) Saved row: (Crane-Outfall-Safari,732655) Saved row: (Crane-Outfall-Safari,732656) Saved row: (Crane-Outfall-Safari,732874) Saved row: (Crane-Outfall-Safari,732875) Saved row: (Crane-Outfall-Safari,732876) Saved row: (Crane-Outfall-Safari,732660) Saved row: (Crane-Outfall-Safari,732661) Saved row: (Crane-Outfall-Safari,732662) Saved row: (Crane-Outfall-Safari,732663) Saved row: (Crane-Outfall-Safari,732878) Saved row: (Crane-Outfall-Safari,732665) Saved row: (Crane-Outfall-Safari,732880) Saved row: (Crane-Outfall-Safari,732881) Saved row: (Crane-Outfall-Safari,732882) Saved row: (Crane-Outfall-Safari,732883) Saved row: (Crane-Outfall-Safari,732884) Saved row: (Crane-Outfall-Safari,732959) Saved row: (Crane-Outfall-Safari,732960) Saved row: (Crane-Outfall-Safari,732961) Saved row: (Crane-Outfall-Safari,732962) Saved row: (Crane-Outfall-Safari,732963) Saved row: (Crane-Outfall-Safari,732964) Saved row: (Crane-Outfall-Safari,732965) Saved row: (Crane-Outfall-Safari,736642) Saved row: (Crane-Outfall-Safari,736643) Saved row: (Crane-Outfall-Safari,736644) Saved row: (Crane-Outfall-Safari,738862) Saved row: (Crane-Outfall-Safari,739576) Saved row: (Crane-Outfall-Safari,739577) Saved row: (Crane-Outfall-Safari,739578) Saved row: (Crane-Outfall-Safari,739579) Saved row: (Crane-Outfall-Safari,739580) Saved row: (Crane-Outfall-Safari,739581) Saved row: (Crane-Outfall-Safari,739582) Saved row: (Crane-Outfall-Safari,738863) Saved row: (Crane-Outfall-Safari,739583) Saved row: (Crane-Outfall-Safari,738864) Saved row: (Crane-Outfall-Safari,738865) Saved row: (Crane-Outfall-Safari,738866) Saved row: (Crane-Outfall-Safari,738867) Saved row: (Crane-Outfall-Safari,738868) Saved row: (Crane-Outfall-Safari,740589) Saved row: (Crane-Outfall-Safari,740590) Saved row: (Crane-Outfall-Safari,740591) Saved row: (Crane-Outfall-Safari,740592) Saved row: (Crane-Outfall-Safari,740593) Saved row: (Crane-Outfall-Safari,740595) Saved row: (Crane-Outfall-Safari,740596) Saved row: (Crane-Outfall-Safari,741684) Saved row: (Crane-Outfall-Safari,741685) Saved row: (Crane-Outfall-Safari,741686) Saved row: (Crane-Outfall-Safari,741687) Saved row: (Crane-Outfall-Safari,741688) Saved row: (Crane-Outfall-Safari,741689) Saved row: (Crane-Outfall-Safari,741690) Saved row: (Crane-Outfall-Safari,741691) Saved row: (Crane-Outfall-Safari,741692) Saved row: (Crane-Outfall-Safari,741693) Saved row: (Crane-Outfall-Safari,741694) Saved row: (Crane-Outfall-Safari,741695) Saved row: (Crane-Outfall-Safari,741696) Saved row: (Crane-Outfall-Safari,741697) Saved row: (Crane-Outfall-Safari,741698) Saved row: (Crane-Outfall-Safari,741699) Saved row: (Crane-Outfall-Safari,741700) Saved row: (Crane-Outfall-Safari,741701) Saved row: (Crane-Outfall-Safari,741702) Saved row: (Crane-Outfall-Safari,741703) Saved row: (Crane-Outfall-Safari,741704) Saved row: (Crane-Outfall-Safari,741705) Saved row: (Crane-Outfall-Safari,741706) Saved row: (Crane-Outfall-Safari,741707) Saved row: (Crane-Outfall-Safari,741708) Saved row: (Crane-Outfall-Safari,741709) Saved row: (Crane-Outfall-Safari,741710) Saved row: (Crane-Outfall-Safari,741711) Saved row: (Crane-Outfall-Safari,741712) Saved row: (Crane-Outfall-Safari,741713) Saved row: (Crane-Outfall-Safari,741714) Saved row: (Crane-Outfall-Safari,741715) Saved row: (Crane-Outfall-Safari,741716) Saved row: (Crane-Outfall-Safari,741717) Saved row: (Crane-Outfall-Safari,741718) Saved row: (Crane-Outfall-Safari,741719) Saved row: (Crane-Outfall-Safari,741720) Saved row: (Crane-Outfall-Safari,741721) Saved row: (Crane-Outfall-Safari,741722) Saved row: (Crane-Outfall-Safari,741723) Saved row: (Crane-Outfall-Safari,741724) Saved row: (Crane-Outfall-Safari,741725) Saved row: (Crane-Outfall-Safari,744019) Saved row: (Crane-Outfall-Safari,744020) Saved row: (Crane-Outfall-Safari,744021) Saved row: (Crane-Outfall-Safari,744022) Saved row: (Crane-Outfall-Safari,744023) Saved row: (Crane-Outfall-Safari,744024) Saved row: (Crane-Outfall-Safari,744025) Saved row: (Crane-Outfall-Safari,744026) Saved row: (Crane-Outfall-Safari,744027) Saved row: (Crane-Outfall-Safari,744028) Saved row: (Crane-Outfall-Safari,744029) Saved row: (Crane-Outfall-Safari,744030) Saved row: (Crane-Outfall-Safari,744031) Saved row: (Crane-Outfall-Safari,744032) Saved row: (Crane-Outfall-Safari,744033) Saved row: (Crane-Outfall-Safari,744034) Saved row: (Crane-Outfall-Safari,744035) Saved row: (Crane-Outfall-Safari,744036) Saved row: (Crane-Outfall-Safari,744037) Saved row: (Crane-Outfall-Safari,744038) Saved row: (Crane-Outfall-Safari,744039) Saved row: (Crane-Outfall-Safari,744040) Saved row: (Crane-Outfall-Safari,744041) Saved row: (Crane-Outfall-Safari,744042) Saved row: (Crane-Outfall-Safari,744043) Saved row: (Crane-Outfall-Safari,744044) Saved row: (Crane-Outfall-Safari,744045) Saved row: (Crane-Outfall-Safari,744046) Saved row: (Crane-Outfall-Safari,744047) Saved row: (Crane-Outfall-Safari,744048) Saved row: (Crane-Outfall-Safari,744049) Saved row: (Crane-Outfall-Safari,744050) Saved row: (Crane-Outfall-Safari,744051) Saved row: (Crane-Outfall-Safari,744811) Saved row: (Crane-Outfall-Safari,744812) Saved row: (Crane-Outfall-Safari,744813) Saved row: (Crane-Outfall-Safari,744814) Saved row: (Crane-Outfall-Safari,744815) Saved row: (Crane-Outfall-Safari,744816) Saved row: (Crane-Outfall-Safari,744817) Saved row: (Crane-Outfall-Safari,745157) Saved row: (Crane-Outfall-Safari,745158) Saved row: (Crane-Outfall-Safari,745159) Saved row: (Crane-Outfall-Safari,745160) Saved row: (Crane-Outfall-Safari,745161) Saved row: (Crane-Outfall-Safari,745162) Saved row: (Crane-Outfall-Safari,745163) Saved row: (Crane-Outfall-Safari,745164) Saved row: (Crane-Outfall-Safari,745165) Saved row: (Crane-Outfall-Safari,745166) Saved row: (Crane-Outfall-Safari,745167) Saved row: (Crane-Outfall-Safari,745168) Saved row: (Crane-Outfall-Safari,745169) Saved row: (Crane-Outfall-Safari,745170) Saved row: (Crane-Outfall-Safari,745171) Saved row: (Crane-Outfall-Safari,751283) Saved row: (Crane-Outfall-Safari,751284) Saved row: (Crane-Outfall-Safari,751285) Saved row: (Crane-Outfall-Safari,758117) Saved row: (Crane-Outfall-Safari,764705) Saved row: (Crane-Outfall-Safari,764706) Dataset: Crane-Outfall-Safari saved: 152/152 rows Saved 152 rows total to cso_locations

Data

Downloaded 154 times by edrandall MikeRalphson

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (140 KB) Use the API

rows 10 / 639

datasetid rownumber site_name ndt discharge_type receiving_water receiving_watercourse site_id consent_reference lat lng eastings northings grid_ref grid_reference
datasetid
DEP2009-2983
rownumber
1
site_name
Angel Road Sewar Storm Overflow, He
ndt
Storm Sewer Overflow
discharge_type
Sewage Discharges - Sewer Storm Overflow - Water Company
receiving_water
Thames
receiving_watercourse
site_id
consent_reference
lat
51.53627483073747
lng
-0.9013150863867272
eastings
476300.0
northings
182502.0
grid_ref
grid_reference
datasetid
DEP2009-2983
rownumber
2
site_name
Anyand Park Road, Twickenham
ndt
Storm Sewer Overflow
discharge_type
Sewage Discharges - Sewer Storm Overflow - Water Company
receiving_water
Tidal Thames
receiving_watercourse
site_id
consent_reference
lat
51.45210752415704
lng
-0.32477686129059263
eastings
516500.0
northings
173900.0
grid_ref
grid_reference
datasetid
DEP2009-2983
rownumber
3
site_name
Ashton Keynes
ndt
Storm Sewer Overflow
discharge_type
Sewage Discharges - Sewer Storm Overflow - Water Company
receiving_water
Thames
receiving_watercourse
site_id
consent_reference
lat
51.63937772745485
lng
-1.9089153210299095
eastings
406400.0
northings
193401.0
grid_ref
grid_reference
datasetid
DEP2009-2983
rownumber
4
site_name
Aston Mead
ndt
Sewage Pumping Station
discharge_type
Sewage Discharges - Pumping Station - Water Company
receiving_water
Thames
receiving_watercourse
site_id
consent_reference
lat
51.48413493243494
lng
-0.6462146393378736
eastings
494100.0
northings
177000.0
grid_ref
grid_reference
datasetid
DEP2009-2983
rownumber
5
site_name
Baldwins Shore
ndt
Sewage Pumping Station
discharge_type
Sewage Discharges - Pumping Station - Water Company
receiving_water
Thames
receiving_watercourse
site_id
consent_reference
lat
51.490887956866246
lng
-0.6085637076272631
eastings
496700.0
northings
177800.0
grid_ref
grid_reference
datasetid
DEP2009-2983
rownumber
6
site_name
Barn Elms, Horne Way, Putney
ndt
Sewage Pumping Station
discharge_type
Sewage Discharges - Pumping Station - Water Company
receiving_water
Tidal Thames
receiving_watercourse
site_id
consent_reference
lat
51.46954218949539
lng
-0.2262318736296985
eastings
523300.0
northings
176000.0
grid_ref
grid_reference
datasetid
DEP2009-2983
rownumber
7
site_name
Barnes Storm
ndt
Storm Sewer Overflow
discharge_type
Sewage Discharges - Sewer Storm Overflow - Water Company
receiving_water
Tidal Thames
receiving_watercourse
site_id
consent_reference
lat
51.47372942742568
lng
-0.2535723073840756
eastings
521390.0
northings
176420.0
grid_ref
grid_reference
datasetid
DEP2009-2983
rownumber
8
site_name
Battle Bridge Relief Sewer, London
ndt
Storm Tank Overflow
discharge_type
Sewage Discharges - Stw Storm Overflow/storm Tank - Water Company
receiving_water
Tidal Thames
receiving_watercourse
site_id
consent_reference
lat
51.50633239474044
lng
-0.0840195267620452
eastings
533070.0
northings
180340.0
grid_ref
grid_reference
datasetid
DEP2009-2983
rownumber
9
site_name
Bell Lane Creek, Frogmore Lane, Lon
ndt
Storm Tank Overflow
discharge_type
Sewage Discharges - Stw Storm Overflow/storm Tank - Water Company
receiving_water
Tidal Thames
receiving_watercourse
site_id
consent_reference
lat
51.459984301532415
lng
-0.1950771425625942
eastings
525490.0
northings
174990.0
grid_ref
grid_reference
datasetid
DEP2009-2983
rownumber
10
site_name
Bell Wharf Outlet, London
ndt
Storm Tank Overflow
discharge_type
Sewage Discharges - Stw Storm Overflow/storm Tank - Water Company
receiving_water
Tidal Thames
receiving_watercourse
site_id
consent_reference
lat
51.509046860377666
lng
-0.04686976046719572
eastings
535640.0
northings
180710.0
grid_ref
grid_reference

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (140 KB) Use the API

rows 4 / 4

datasetid northings site_id ndt lat rownumber eastings grid_ref site_name lng consent_reference discharge_type receiving_water
datasetid
Crane-Outfall-Safari
northings
site_id
732871
ndt
Outfall
lat
51.44152371
rownumber
1
eastings
grid_ref
site_name
Hospital bridge rd
lng
-0.36433805
consent_reference
discharge_type
Outfall
receiving_water
River Crane
datasetid
Crane-Outfall-Safari
northings
site_id
732655
ndt
Outfall
lat
51.4415648
rownumber
2
eastings
grid_ref
site_name
Hospital bridge road. Ds left bank
lng
-0.3645006
consent_reference
discharge_type
Outfall
receiving_water
River Crane
datasetid
Crane-Outfall-Safari
northings
site_id
732595
ndt
Outfall
lat
51.4596535
rownumber
3
eastings
grid_ref
site_name
Duke of Northumberlands River upstream of bridge into north Feltham trading estate
lng
-0.4040806
consent_reference
discharge_type
Outfall
receiving_water
River Crane
datasetid
Crane-Outfall-Safari
northings
site_id
732873
ndt
Outfall
lat
51.44146061
rownumber
4
eastings
grid_ref
site_name
Left bank hospital bridge rd
lng
-0.36513525
consent_reference
discharge_type
Outfall
receiving_water
River Crane

Statistics

Average successful run time: 6 minutes

Total run time: about 3 hours

Total cpu time used: less than a minute

Total disk space used: 226 KB

History

  • Manually ran revision 458e6cd6 and completed successfully .
    152 records added, 150 records removed in the database
  • Manually ran revision 458e6cd6 and completed successfully .
    150 records added, 146 records removed in the database
  • Manually ran revision 458e6cd6 and completed successfully .
    162 records added, 162 records removed in the database
  • Manually ran revision 458e6cd6 and completed successfully .
    162 records added, 162 records removed in the database
  • Manually ran revision 92b5f0a6 and completed successfully .
    162 records updated in the database
  • ...
  • Created on morph.io

Show complete history

Scraper code

thames_cso_locations