Baselight

Conservation Areas - Rochdale Borough Council

Rochdale Borough Council

@ukgov.conservation_areas_rochdale_borough_council

Table 1
@ukgov.conservation_areas_rochdale_borough_council.table_1

  • 99.93 KB
  • 29 rows
  • 10 columns
reference

Reference

name

Name

conservation_area

Conservation Area

geometry

Geometry

document_url_actual_document_link

Document-url (actual Document Link)

n__document_type_i_e_area_appraisal

Document Type (i.e Area Appraisal

start_date

Start-date

designation_date

Designation-date

end_date

End-date

entry_date

Entry-date

CA1Rochdale Town Centre Conservation AreaCA1MULTIPOLYGON (((-2.16216472166044 53.6160171543473,-2.16207579453325 53.6162211931957,-2.1620508200148 53.616232335078,-2.16126542033581 53.6165827198024,-2.16129389727051 53.6167166062177,-2.16103077475929 53.6166922438793,-2.16092394106563 53.6166236278911,-2.16070945895857 53.6166693075826,-2.160…https://www.rochdale.gov.uk/downloads/file/496/rochdale-town-centre-conservation-area-appraisalAppraisalWed Sep 07 2011 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Sep 07 2011 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Sep 07 2011 00:00:00 GMT+0000 (Coordinated Universal Time)
CA2Ogden Conservation AreaCA2MULTIPOLYGON (((-2.0724210932188 53.6047467127267,-2.07270834185751 53.6052533772843,-2.07227012026462 53.6052758392297,-2.07153816620628 53.6053300208802,-2.07151347000725 53.605292824905,-2.07134577681335 53.6053252804351,-2.07137155593424 53.605377395962,-2.07129238869461 53.6053904750929,-2.0711…https://www.rochdale.gov.uk/downloads/file/491/ogden-1974-conservation-area-mapMapSun Sep 01 1974 00:00:00 GMT+0000 (Coordinated Universal Time)Sun Sep 01 1974 00:00:00 GMT+0000 (Coordinated Universal Time)Sun Sep 01 1974 00:00:00 GMT+0000 (Coordinated Universal Time)
CA3Wardle Conservation AreaCA3MULTIPOLYGON (((-2.13725070530743 53.6510530794186,-2.13683602150835 53.6510061873887,-2.13670436300136 53.6509946534274,-2.13664012303996 53.6510122534945,-2.13615024702887 53.6510573027549,-2.13601778611179 53.6510781259143,-2.13594531947182 53.6510782981533,-2.13597085896812 53.6512091350686,-2.1…https://www.rochdale.gov.uk/downloads/file/504/wardle-littleborough-1977-conservation-area-mapMapSun Dec 01 1974 00:00:00 GMT+0000 (Coordinated Universal Time)Sun Dec 01 1974 00:00:00 GMT+0000 (Coordinated Universal Time)Sun Dec 01 1974 00:00:00 GMT+0000 (Coordinated Universal Time)
CA4Ashworth Fold Conservation AreaCA4MULTIPOLYGON (((-2.22827903957575 53.616220036574,-2.22832939956039 53.6160284900248,-2.22665996662306 53.6156923613731,-2.22676574565748 53.6156296921248,-2.2267976950314 53.6156116549256,-2.2268366392402 53.6156013343547,-2.22685235454913 53.6156003158051,-2.22686413439219 53.6155983160161,-2.2269…https://www.rochdale.gov.uk/downloads/file/472/ashworth-fold-1975-conservation-area-mapMapFri Jan 03 1975 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Jan 03 1975 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Jan 03 1975 00:00:00 GMT+0000 (Coordinated Universal Time)
CA5Clegg Village Conservation AreaCA5MULTIPOLYGON (((-2.1180310062485 53.6282129074631,-2.11849155975283 53.627938225517,-2.11871224880822 53.6278066007903,-2.11893296925161 53.6276864803751,-2.11924983767019 53.6275604214418,-2.11969169665957 53.6274684812224,-2.12013348858135 53.6273538894651,-2.12060400617302 53.6272390873469,-2.120…https://www.rochdale.gov.uk/downloads/file/483/clegg-village-1977-conservation-area-mapMapWed Nov 23 1977 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Nov 23 1977 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Nov 23 1977 00:00:00 GMT+0000 (Coordinated Universal Time)
CA6Littleborough Town Centre Conservation AreaCA6MULTIPOLYGON (((-2.09303040305178 53.6441658481673,-2.09295031737911 53.6441361598145,-2.09292000370894 53.6440411790483,-2.09289986437923 53.6439638969437,-2.09321946129713 53.6437497312043,-2.09373886393811 53.6434640427034,-2.09442810255542 53.6431010103961,-2.0950075527661 53.6428212015453,-2.09…https://www.rochdale.gov.uk/downloads/file/486/littleborough-town-centre-1977-extended-2011-conservation-area-mapMapFri Mar 18 2011 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Mar 18 2011 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Mar 18 2011 00:00:00 GMT+0000 (Coordinated Universal Time)
CA7Toad Lane Conservation AreaCA7MULTIPOLYGON (((-2.15793116054115 53.6194115475982,-2.1575201184257 53.6190082502678,-2.15813113219018 53.618797567497,-2.15836999747485 53.618719862251,-2.15852778795974 53.6186703973513,-2.15879091213144 53.6186119836974,-2.15885106217704 53.6186074994316,-2.15899021609184 53.6185871805417,-2.1592…https://www.rochdale.gov.uk/downloads/file/501/toad-lane-rochdale-1977-conservation-area-mapMapWed Nov 23 1977 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Nov 23 1977 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Nov 23 1977 00:00:00 GMT+0000 (Coordinated Universal Time)
CA8Rakewood Conservation AreaCA8MULTIPOLYGON (((-2.08562251736873 53.6262101756728,-2.08506124991709 53.6260559728171,-2.08478293686248 53.6260040357442,-2.08451374592128 53.6259763591953,-2.08411757716602 53.6259631509008,-2.08403592787897 53.6259623083956,-2.0839966378352 53.6259731213504,-2.08381087052484 53.6260766138432,-2.08…https://www.rochdale.gov.uk/downloads/file/494/rakewood-1982-conservation-area-mapMapWed Mar 31 1982 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Mar 31 1982 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Mar 31 1982 00:00:00 GMT+0000 (Coordinated Universal Time)
CA9Hollingworth Fold Conservation AreaCA9MULTIPOLYGON (((-2.08837855964642 53.6311917993633,-2.08829093295663 53.6312296138879,-2.08827132589828 53.6312538963609,-2.08810187591461 53.6312135731653,-2.08817758589905 53.6310465171325,-2.08824801983092 53.6309591003839,-2.08778572289008 53.6307315861779,-2.08722288911157 53.6304396971782,-2.0…https://www.rochdale.gov.uk/downloads/file/485/hollingworth-fold-1982-conservation-area-mapMapWed Mar 31 1982 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Mar 31 1982 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Mar 31 1982 00:00:00 GMT+0000 (Coordinated Universal Time)
CA10Whittaker Conservation AreaCA10MULTIPOLYGON (((-2.08048725097431 53.6365221742162,-2.08076045551333 53.6364025402729,-2.08068925993319 53.6363434450108,-2.08082526573771 53.6362883470944,-2.080774227463 53.6362513495058,-2.08078416285171 53.6362275241739,-2.0808490314511 53.6362215489578,-2.08091402823217 53.6362037091884,-2.0812…https://www.rochdale.gov.uk/downloads/file/505/whittaker-hollingworth-lake-1982-conservation-area-mapMapWed Mar 31 1982 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Mar 31 1982 00:00:00 GMT+0000 (Coordinated Universal Time)Wed Mar 31 1982 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATE TABLE table_1 (
  "reference" VARCHAR,
  "name" VARCHAR,
  "conservation_area" VARCHAR,
  "geometry" VARCHAR,
  "document_url_actual_document_link" VARCHAR,
  "n__document_type_i_e_area_appraisal" VARCHAR,
  "start_date" TIMESTAMP,
  "designation_date" TIMESTAMP,
  "end_date" VARCHAR,
  "entry_date" TIMESTAMP
);

Share link

Anyone who has the link will be able to view this.