{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data","Schema","Validate","About","Example Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":18,"n_cols":28,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["OrganisationURI","OrganisationLabel","SiteReference","PreviouslyPartOf","SiteNameAddress","SiteplanURL","CoordinateReferenceSystem","GeoX","GeoY","Hectares","owned by a public authority","Deliverable","PlanningStatus","PermissionType","PermissionDate","PlanningHistory","ProposedForPIP","MinNetDwellings","DevelopmentDescription","NonHousingDevelopment","Part2","NetDwellingsRangeFrom","NetDwellingsRangeTo","HazardousSubstances","SiteInformation","Notes","FirstAddedDate","LastUpdatedDate"]
["http://opendatacommunities.org/id/unitary-authority/hartlepool","Hartlepool Borough Council ","BR1 - Blakelock Road",null,"Blakelock Road, Blakelock Rd, Manor House Ward ","BR1","OSGB36",449672,531412,0.6,"owned by a public authority","yes","not permissioned",null,null,null,null,10,null,null,null,10,15,null,null,null,"2017-12-17","2021-11-29"]
["http://opendatacommunities.org/id/unitary-authority/hartlepool","Hartlepool Borough Council ","BR6 - The Former Ambulance Station",null,"Former Ambulance Station, Elwick Road","BR6","OSGB36",449352,532215,0.28000000000000003,"owned by a public authority","yes","not permissioned",null,null,null,null,16,null,null,null,16,16,null,null,"Former ambulance station and paddock, paddock not included on spreadsheet. Heritage asset, ideally for conversion.","2019-12-11","2021-11-29"]
["http://opendatacommunities.org/id/unitary-authority/hartlepool","Hartlepool Borough Council ","BR10 - Former King Oswy Public House",null,"Former King Oswy Public House, KingOswy Dr,DeBruce","BR10","OSGB36",449431,535357,0.25,"not owned by a public authority","yes","permissioned","full planning permission","2016-10-14","http://eforms.hartlepool.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=106293",null,8,"8 semi detached bungalows",null,null,8,8,null,null,"Former pub site. Development started but has stalled. Site is partially developed.","2017-12-17","2021-11-29"]
["http://opendatacommunities.org/id/unitary-authority/hartlepool","Hartlepool Borough Council ","BR12 - Garden Centre & Amenity Block",null,"GardenCentre&AmenityBlock,TanfieldRd, Foggy Furze ","BR12","OSGB36",450340,530642,0.47,"not owned by a public authority","yes","permissioned","full planning permission","2022-05-27","http://eforms.hartlepool.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=140019",null,17,"Residential development comprising 17no. bungalows (consisting of 15 x 2 bed, 2 x 2 bed accessible) including car parking, new access road and associated works.",null,null,17,17,null,null,"Former garden centre. Permission granted for redevelopment","2017-12-17","2022-12-15"]
["http://opendatacommunities.org/id/unitary-authority/hartlepool","Hartlepool Borough Council ","BR13 - Hartlepool Hospital",null,"Hartlepool Hospital, Holdforth Rd, De Bruce Ward","BR13","OSGB36",449994,534507,2.64,"not owned by a public authority","yes","not permissioned",null,null,null,null,80,null,null,null,80,100,null,null,"Vacant land at hospital site. Previously had permission but expired.","2017-12-17","2021-11-29"]
["http://opendatacommunities.org/id/unitary-authority/hartlepool","Hartlepool Borough Council ","BR16 - Marina Slake Terrace_Blocks 28 29 32",null,"MarinaBlocks28 29 32, SlakeTerraceHeadland&Harbour","BR16","OSGB36",451743,532995,0.4,"not owned by a public authority","yes","permissioned","full planning permission","2003-11-11","http://eforms.hartlepool.gov.uk:7777/portal/servlets/ApplicationSearchServlet?PKID=18762",null,76,"3 apartment blocks. Block 28 for 20 apartments. Block 31 approx 20 apartments. Block 32 for 36 apartments.",null,null,76,76,null,null,"3 apartment blocks on brownfield site at south east corner of Marina. ","2017-12-17","2021-11-29"]
["http://opendatacommunities.org/id/unitary-authority/hartlepool","Hartlepool Borough Council ","BR18 - Oxford Road",null,"Oxford Road, Oxford Rd, Foggy Furze Ward","BR18","OSGB36",450616,531382,0.74,"not owned by a public authority","yes","not permissioned",null,null,null,null,15,null,null,null,15,25,null,null,"Site with commercial buildings which owner put forward in SHLAA","2017-12-17","2021-11-29"]
["http://opendatacommunities.org/id/unitary-authority/hartlepool","Hartlepool Borough Council ","BR21 - South of Maritime Avenue",null,"SouthofMaritimeAv, MaritimeAv, Headland&HabourWard","BR21","OSGB36",451665,532266,2.33,"mixed ownership","yes","not permissioned",null,null,"http://eforms.hartlepool.gov.uk:7777/portal/servlets/ApplicationSearchServlet?PKID=18762",null,400,"apartment blocks","An element of retail and commercial could come forward on site",null,400,400,null,null,"Brownfield vacant site to south of Marina. 2003 permission, now extant.","2017-12-17","2021-11-29"]
["http://opendatacommunities.org/id/unitary-authority/hartlepool","Hartlepool Borough Council ","BR24 - Trincomalee Wharf",null,"Trincomalee Wharf, Maritime Av, Headland&Harbour","BR24","OSGB36",451384,532973,0.64,"owned by a public authority","yes","not permissioned",null,null,null,null,20,null,null,null,20,50,null,null,"Waterfront site. If apartments were built could accomodate a greater number than town houses. 2021: mixed use development informal application for consideration. This may or may not include apartments.","2017-12-17","2021-11-29"]
["http://opendatacommunities.org/id/unitary-authority/hartlepool","Hartlepool Borough Council ","BR28 - Havelock Centre",null,"Havelock Centre, Burn Valley Ward","BR28","OSGB36",451586,532119,0.38,"owned by a public authority","yes","not permissioned",null,null,null,null,14,null,null,null,14,14,null,null,"Building demolished and site cleared December 2020. Site partially developed.","2020-11-26","2021-11-29"]
["http://opendatacommunities.org/id/unitary-authority/hartlepool","Hartlepool Borough Council ","BR29 - Union House",null,"Union House, Southgate, Headland & Harbour Ward","BR29","OSGB36",452493,533754,0.01,"not owned by a public authority","yes","not permissioned",null,null,"http://eforms.hartlepool.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=60640 ",null,6,"Conversion of Union House to 3 apartments and erection of 4 no town houses with associated external works",null,null,6,6,null,null,"2008 permission","2020-11-26","2021-11-29"]
["http://opendatacommunities.org/id/unitary-authority/hartlepool","Hartlepool Borough Council ","BR30 - 28 Whitby Street",null,"28 Whitby Street, Burn Valley Ward","BR30","OSGB36",451234,532443,0.03,"not owned by a public authority","yes","permissioned","full planning permission","2019-05-17","http://eforms.hartlepool.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=129418 ",null,7,"Change of use from pub and restaurant to 7 apartments.",null,null,7,7,null,null,"Brownfield conversion. Permission expired.","2020-11-26","2022-12-15"]
["http://opendatacommunities.org/id/unitary-authority/hartlepool","Hartlepool Borough Council ","BR32 - New Market ",null,"Whitby Street and Lynn Street, Burn Valley Ward","BR32","OSGB36",451281,532454,1.1000000000000001,"owned by a public authority","yes","permissioned","full planning permission","2021-11-17","http://eforms.hartlepool.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=147232",null,48,"Demolition of existing buildings (incl. former Market Hotel, Lynn Street Council depot and former Drug Rehabilitation Centre) and erection of 48no. dwellings with associated access, infrastructure, and hard and soft landscaping",null,null,48,48,null,null,"Development of a range of house types from 2 bed bungalows to 4 bed townhouses split between 3 sites in close proximity to each other. Three sites form this: former Lynn Street Depot, former Drug & Alcohol Centre and market hotel site. Demolition has taken place but development nor yet commenced - out to tender.","2020-12-08","2022-12-15"]
["http://opendatacommunities.org/id/unitary-authority/hartlepool","Hartlepool Borough Council ","BR34 - Parkview Nursing Home",null,"Parkview Nursing Home, 34 Station Lane, Seaton Ward","BR34",null,452285,529908,0.13,"not owned by a public authority","yes","permissioned","full planning permission","2018-10-22","http://eforms.hartlepool.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=122938 ",null,14,"Change of use from C2 residential care home to 14 No. C3 residential flats with the addition of two second storey extensions to the side and rear, a single storey glazed walkway to the side and demolition of the two external fire escapes",null,null,14,14,null,null,"Permission expired 21/10/2021.","2021-11-08","2021-11-29"]
["http://opendatacommunities.org/id/unitary-authority/hartlepool","Hartlepool Borough Council ","BR35 - Land at St Begas",null,"Land at St Bega's Glade, Headland & Harbour Ward","BR35",null,451901,534484,0.67,"owned by a public authority",null,"not permissioned",null,null,null,null,25,null,null,null,25,25,null,null,"Former school playing field which was previously terraced housing. Not been in use as a playing field for over 10 years","2021-11-15","2021-11-29"]
["http://opendatacommunities.org/id/unitary-authority/hartlepool","Hartlepool Borough Council ","BR36 - Former Engineers Club",null,"Former Engineers Club, Raby Road, Victoria Ward","BR36",null,450824,532676,0.22,"mixed ownership",null,"pending decision",null,null,"http://eforms.hartlepool.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=154896",null,98,"Demolition of Former Engineers Club & Registry Office (The Willows) and erection of 2, 3, 4 & 5 storey residential blocks with commercial units to ground floor providing 98no. residential units","Class E at ground floor of two blocks",null,98,98,null,null,"Full application which includes adjoining undeveloped land to the east is pending consideration ","2021-11-15","2022-12-15"]
["http://opendatacommunities.org/id/unitary-authority/hartlepool","Hartlepool Borough Council ","BR37 - Former Hour Glass PH",null,"Hour Glass, Eaglesfield Road, Manor House Ward","BR37",null,448878,530023,0.16,"not owned by a public authority",null,"pending decision",null,null,"http://eforms.hartlepool.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=154316",null,9,"Application for Permission In Principle for the erection of up to 9no. dwellings (demolition of existing public house)",null,null,9,9,null,null,"Permission in principle application pending consideration","2021-11-15","2022-12-15"]

{"sheet":"Schema","index":1,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["FieldName","DataType","Mandatory?","Pattern"]
["OrganisationURI","anyURI","yes","^http:\\/\\/opendatacommunities.org\\/id\\/"]
["OrganisationLabel","string","yes",""]
["SiteReference","string","yes",""]
["PreviouslyPartOf","string","",""]
["SiteNameAddress","string","yes",""]
["SiteplanURL","anyURI","yes","^(http|https):\\/\\/"]
["CoordinateReferenceSystem","string","yes","(WGS84|OSGB36|ETRS89)"]
["GeoX","decimal","yes","^[+-]?\\d*\\.?\\d*$"]
["GeoY","decimal","yes","^[+-]?\\d*\\.?\\d*$"]
["Hectares","decimal","yes","^\\d*(\\.\\d{1,2})?$"]
["OwnershipStatus","string","yes","(owned by a public authority|not owned by a public authority|unknown ownership|mixed ownership)"]
["Deliverable","string","","(yes)"]
["PlanningStatus","string","yes","(permissioned|not permissioned|pending decision)"]
["PermissionType","string","","(full planning permission|outline planning permission|reserved matters approval|permission in principle|technical details consent|planning permission granted under an order|other)"]
["PermissionDate","date","","^$|^(?:(?:1[6-9]|[2]\\d)\\d{2})-(?:(?:0[1-9])|(?:1[0-2]))-(?:0[1-9]|1\\d|2[0-8])$|^(?:(?:1[6-9]|[2]\\d)\\d{2})-(?:(?:(?:(?:0[13578]|1[02]))-31)|(?:(?:0[1,3-9]|1[0-2])-(?:29|30)))$|^(?:(?:(?:1[6-9]|2\\d)(?:0[48]|[2468][048]|[13579][26])|(?:(?:16|2[048])00))-02-29)$"]
["PlanningHistory","anyURI","","^$|^(http|https):\\/\\/[^\\| ]+(\\|(http|https):\\/\\/[^\\| ]+)*$"]
["ProposedForPIP","string","","(yes)"]
["MinNetDwellings","integer","yes",""]
["DevelopmentDescription","text","",""]
["NonHousingDevelopment","text","",""]
["Part2","string","","(yes)"]
["NetDwellingsRangeFrom","integer","",""]
["NetDwellingsRangeTo","integer","",""]
["HazardousSubstances","string","","(yes)"]
["SiteInformation","anyURI","","^$|^(http|https):\\/\\/[^\\| ]+(\\|(http|https):\\/\\/[^\\| ]+)*$"]
["Notes","text","",""]
["FirstAddedDate","date","yes","^$|^(?:(?:1[6-9]|[2]\\d)\\d{2})-(?:(?:0[1-9])|(?:1[0-2]))-(?:0[1-9]|1\\d|2[0-8])$|^(?:(?:1[6-9]|[2]\\d)\\d{2})-(?:(?:(?:(?:0[13578]|1[02]))-31)|(?:(?:0[1,3-9]|1[0-2])-(?:29|30)))$|^(?:(?:(?:1[6-9]|2\\d)(?:0[48]|[2468][048]|[13579][26])|(?:(?:16|2[048])00))-02-29)$"]
["LastUpdatedDate","date","yes","^$|^(?:(?:1[6-9]|[2]\\d)\\d{2})-(?:(?:0[1-9])|(?:1[0-2]))-(?:0[1-9]|1\\d|2[0-8])$|^(?:(?:1[6-9]|[2]\\d)\\d{2})-(?:(?:(?:(?:0[13578]|1[02]))-31)|(?:(?:0[1,3-9]|1[0-2])-(?:29|30)))$|^(?:(?:(?:1[6-9]|2\\d)(?:0[48]|[2468][048]|[13579][26])|(?:(?:16|2[048])00))-02-29)$"]

{"sheet":"Validate","index":2,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"Row","FieldName","Value","Error"]

{"sheet":"About","index":3,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Name","BrownfieldLandRegisterTemplate-ver1.0.xslm"]
["Version","1.0"]
["Date","05/09/2017"]
["Publisher","Department for Communities and Local Government (DCLG)"]
["Purpose","This is a template that can be used to prepare data that complies to the 'Brownfield land registers data standard' defined at https://www.gov.uk/government/publications/brownfield-land-registers-data-standard "]
["Author","Department for Communities and Local Government (DCLG)"]
["Licence","Open Government Licence - http://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/"]
["Download from ","https://www.gov.uk/government/publications/brownfield-land-registers-data-standard"]
["Created Using","Microsoft Excel 2016"]
["Guidance at","https://www.gov.uk/government/publications/brownfield-land-registers-data-standard"]

{"sheet":"Example Data","index":4,"n_rows":15,"n_cols":28,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["OrganisationURI","OrganisationLabel","SiteReference","PreviouslyPartOf","SiteNameAddress","SiteplanURL","CoordinateReferenceSystem","GeoX","GeoY","Hectares","OwnershipStatus","Deliverable","PlanningStatus","PermissionType","PermissionDate","PlanningHistory","ProposedForPIP","MinNetDwellings","DevelopmentDescription","NonHousingDevelopment","Part2","NetDwellingsRangeFrom","NetDwellingsRangeTo","HazardousSubstances","SiteInformation","Notes","FirstAddedDate","LastUpdatedDate"]
["http://opendatacommunities.org/id/district-council/example","Example District Council","SHLAA001",null,"land behind example lane, example village","http://www.example.gov.uk/siteview.html?siteref=SHLAA001","ETRS89",-1.123456,53.123455999999997,2.25,"not owned by a public authority","yes","permissioned","outline planning permission","2017-08-08","http://www.example.gov.uk/planning/applications?appref=SHLAA001|http://www.example.gov.uk/planning/applications?appref=SHLAA001(2)",null,30,"20, two-storey semi-detached houses. One block of 10 single bedroom flats. C3.",null,null,null,null,null,"http://www.example.gov.uk/planning/applications?appref=SHLAA001",null,"2017-08-08","2017-08-08"]
["http://opendatacommunities.org/id/district-council/example","Example District Council","SHLAA002",null,"example lane, example town","http://www.example.gov.uk/siteview.html?siteref=SHLAA002","ETRS89",-1.234567,53.234566999999998,5.2,"mixed ownership","yes","not permissioned",null,null,null,null,40,null,null,null,40,55,null,null,null,"2017-08-08","2017-08-08"]
["http://opendatacommunities.org/id/district-council/example","Example District Council","SHLAA003",null,"example road, example town","http://www.example.gov.uk/siteview.html?siteref=SHLAA003","ETRS89",-1.134568,53.345677999999999,6,"not owned by a public authority","yes","not permissioned",null,null,null,null,50,null,null,null,50,60,null,null,null,"2017-08-08","2017-08-08"]
["http://opendatacommunities.org/id/district-council/example","Example District Council","SHLAA004",null,"land next to example lane, example village","http://www.example.gov.uk/siteview.html?siteref=SHLAA004","ETRS89",-1.1456789999999999,53.456789000000001,50,"owned by a public authority","yes","permissioned","full planning permission","2017-02-02","http://www.example.gov.uk/planning/applications?appref=SHLAA004|http://www.example.gov.uk/planning/applications?appref=SHLAA004(2)",null,250,"100, two-storey detached houses. 150, two-storey semi-detached houses.","0.03 hectare of retail use. ",null,null,null,null,null,"permission for 30 hectares of the site.","2017-08-08","2017-10-01"]
["http://opendatacommunities.org/id/district-council/example","Example District Council","SHLAA005","SHLAA004","land next to example lane, example village","http://www.example.gov.uk/siteview.html?siteref=SHLAA005","ETRS89",-1.1456789999999999,53.456789000000001,20,"owned by a public authority","yes","permissioned","permission in principle","2017-10-01","http://www.example.gov.uk/planning/applications?appref=SHLAA005","yes",140,null,null,"yes",140,160,null,null,"land allocated in neighbourhood plan for affordable housing.","2017-10-01","2017-10-01"]
["http://opendatacommunities.org/id/district-council/example","Example District Council","SHLAA006",null,"land next to example house, example town","http://www.example.gov.uk/siteview.html?siteref=SHLAA006","ETRS89",-1.165432,53.567898999999997,0.25,"not owned by a public authority","yes","permissioned","full planning permission","2017-08-10","http://www.example.gov.uk/planning/applications?appref=SHLAA006",null,24,"24, two bedroom apartments. C3.",null,null,null,null,null,null,null,"2017-08-08","2017-08-08"]
["http://opendatacommunities.org/id/district-council/example","Example District Council","SHLAA007",null,"example park, example village","http://www.example.gov.uk/siteview.html?siteref=SHLAA007","ETRS89",-1.1543209999999999,53.543210999999999,0.75,"not owned by a public authority","yes","not permissioned",null,null,null,null,19,null,null,null,19,25,null,null,null,"2017-08-08","2017-08-08"]
["http://opendatacommunities.org/id/district-council/example","Example District Council","SHLAA008",null,"land next to example avenue, example village","http://www.example.gov.uk/siteview.html?siteref=SHLAA008","ETRS89",-1.1765429999999999,53.544320999999997,1.5,"mixed ownership","yes","not permissioned",null,null,null,null,50,null,null,null,50,75,null,null,null,"2017-08-08","2017-08-08"]
["http://opendatacommunities.org/id/district-council/example","Example District Council","SHLAA009",null,"land behind example avenue, example town","http://www.example.gov.uk/siteview.html?siteref=SHLAA009","ETRS89",-1.187654,53.564321,15,"owned by a public authority","yes","permissioned","outline planning permission","2017-09-01","http://www.example.gov.uk/planning/applications?appref=SHLAA009",null,160,"40 two-bedroom apartments, 100 single bedroom apartments, 20 three-bedroom apartments. C3.",null,null,null,null,null,"http://www.example.gov.uk/planning/applications?appref=SHLAA009","land allocated in neighbourhood plan for affordable housing.","2017-10-01","2017-10-01"]
["http://opendatacommunities.org/id/district-council/example","Example District Council","SHLAA010",null,"land behind example park, off example lane, example town","http://www.example.gov.uk/siteview.html?siteref=SHLAA010","ETRS89",-1.1987650000000001,53.577654000000003,0.6,"not owned by a public authority",null,"not permissioned",null,null,null,null,20,null,null,null,20,30,null,null,null,"2017-08-08","2017-08-08"]
["http://opendatacommunities.org/id/district-council/example","Example District Council","SHLAA011",null,"land behind example lane, example village","http://www.example.gov.uk/siteview.html?siteref=SHLAA011","ETRS89",-1.1098760000000001,53.588765000000002,0.2,"not owned by a public authority",null,"not permissioned",null,null,null,null,10,null,null,null,10,15,null,null,null,"2017-08-08","2017-08-08"]
["http://opendatacommunities.org/id/district-council/example","Example District Council","SHLAA012",null,"example park, example town","http://www.example.gov.uk/siteview.html?siteref=SHLAA012","ETRS89",-1.234567,53.599876000000002,0.45,"unknown ownership",null,"not permissioned",null,null,null,null,18,null,null,null,18,30,null,null,null,"2017-08-08","2017-08-08"]
["http://opendatacommunities.org/id/district-council/example","Example District Council","SHLAA013",null,"land behind example, example town","http://www.example.gov.uk/siteview.html?siteref=SHLAA013","ETRS89",-1.2456780000000001,53.654321000000003,18,"owned by a public authority","yes","pending decision",null,null,"http://www.example.gov.uk/planning/applications?appref=SHLAA013",null,230,"150 single bedroom apartments, 80 two bedroom apartments.",null,null,null,null,null,"http://www.example.gov.uk/planning/applications?appref=SHLAA013",null,"2017-10-01","2017-10-01"]
["http://opendatacommunities.org/id/district-council/example","Example District Council","SHLAA014",null,"land on example lane, example village","http://www.example.gov.uk/siteview.html?siteref=SHLAA014","ETRS89",-1.2567889999999999,53.678986999999999,0.4,"owned by a public authority","yes","not permissioned",null,null,null,"yes",10,null,null,null,10,12,null,null,"land allocated in neighbourhood plan for affordable housing.","2017-10-01","2017-10-01"]