{"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":21,"n_cols":28,"rows_kept":21,"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/allerdale","Allerdale Borough Council","BR/ABB/01H",null,"Land to the north of Laurel Terrace, Laurel Terrace, Abbeytown","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",317284,550804,0.28000000000000003,"Not owned by a public authority",null,"Not Permissioned",null,null,null,null,5,null,"N/A",null,5,10,null,null,null,"2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/BRM/01H",null,"Land at former Broughton Moor RNAD, Moor Road, Broughton Moor","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",306461,532113,4.3,"Owned by a public authority","Yes","Permissioned","Outline Planning Permission","06.05.2015","http://planning.allerdale.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=123998",null,24,null,"N/A",null,24,30,null,null,"24 selfbuild plots and demolition of 3 buildings","2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/FLI/01H",null,"Former Flimby Garage, Church Road, Flimby","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",302381,533419,0.17,"Not owned by a public authority",null,"Not Permissioned",null,null,"http://planning.allerdale.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=108925",null,5,null,"N/A",null,5,6,null,null,null,"2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/GRC/02H",null,"Land at William Street, Great Clifton","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",303964,529858,0.52,"Not owned by a public authority","Yes","Permissioned","Full Planning Permission","19.09.2012","http://planning.allerdale.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=96500",null,10,null,"N/A",null,15,18,null,null,"18 dwellings","2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/KBR/01H",null,"Land adjacent to Rodway, West Lane, Kirkbride","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",322802,556235,0.6,"Not owned by a public authority","Yes","Permissioned","Full Planning Permission","12.11.2010","http://planning.allerdale.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=77252",null,5,null,"N/A",null,5,19,null,null,"19 dwellings","2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/MAR/01H",null,"Land at Ropery Street, Maryport","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",303302,535961,0.8,"Not owned by a public authority","Yes","Permissioned","Outline Planning Permission","16.06.2014","http://planning.allerdale.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=114404",null,12,null,"N/A",null,12,20,null,null,"Use of land for residential development","2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/MAR/02H",null,"Land at The Netherdales, Ellenborough Road, Maryport","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",304410,536130,0.3,"Not owned by a public authority","Yes","Permissioned","Outline Planning Permission","14.05.2015","http://planning.allerdale.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=124486",null,5,null,"N/A",null,5,9,null,null,"9 dwellings","2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/MAR/03H",null,"Land to the east of Marine Road, Maryport","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",300309,303645,1.53,"owned by a public authority",null,"not permissioned",null,null,null,null,30,null,null,null,30,50,null,null,null,"2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/PRO/01H",null,"Prospect Garage, Main Road (A596), Prospect","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",312057,541023,0.6,"Not owned by a public authority",null,"Not Permissioned",null,null,"http://planning.allerdale.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=152298",null,12,null,"N/A",null,12,20,null,null,null,"2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/SIL/01H",null,"Former Fisons Factory, Skiddaw Street, Silloth","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",311145,553175,8.6999999999999993,"Not owned by a public authority","Yes","Permissioned","Outline Planning Permission","23.05.2011","http://planning.allerdale.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=74376",null,170,null,"C2/C3 Extra Care Housing?",null,170,254,null,null,"Residential development (first phase - 22 dwellings)","2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/WIG/02H",null,"Former Brookside Works, Brookside, Wigton","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",325675,548343,0.1,"Not owned by a public authority","Yes","Permissioned","Full Planning Permission","27.05.2015","http://planning.allerdale.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=116991",null,5,null,"N/A",null,5,10,null,null,"9 flats and 1 dwelling","2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/WOR/01H",null,"Former Workington Fire Station, Guard Street, Workington","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",300672,528392,0.5,"Owned by a public authority",null,"Not Permissioned",null,null,null,null,12,null,"N/A",null,12,50,null,null,null,"2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/WOR/02H",null,"Land off Curwen Road, Curwen Road, Workington","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",299095,529007,1.8,"Not owned by a public authority","Yes","Permissioned","Reserved Matters Approval","13.04.2016","http://planning.allerdale.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=134609",null,80,null,"N/A",null,80,120,null,null,"94 residential units","2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/WOR/03H",null,"Land at Stanley Street, Workington","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",299380,528881,0.8,"Not owned by a public authority",null,"Not Permissioned",null,null,null,null,40,null,"N/A",null,40,90,null,null,null,"2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/WOR/04H",null,"Former Senhouse Terrace, Senhouse Street, Workington","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",299786,528787,0.1,"Not owned by a public authority","Yes","Permissioned","Full Planning Permission","19.01.2016","http://planning.allerdale.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=125499",null,5,null,"N/A",null,5,14,null,null,"14 flats","2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/WOR/06H",null,"Land off Mossbay Road, Workington","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",299216,527272,0.32,"Owned by a public authority",null,"Not Permissioned",null,null,null,null,5,null,"N/A",null,5,10,null,null,null,"2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/WOR/07H",null,"Former Southfield School, Moorclose Road, Workington","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",299676,526616,2.7,"Owned by a public authority",null,"Not Permissioned",null,null,null,null,50,null,"N/A",null,50,70,null,null,null,"2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/WOR/08H",null,"Land at Duke Street, Workington","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",299943,528960,0.1,"Not owned by a public authority","Yes","Permissioned","Full Planning Permission","03.12.2013","http://planning.allerdale.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=106364",null,12,null,"N/A",null,12,15,null,null,"Demolition of former hall and erection of 14 flats","2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/WOR/09H",null,"Mermaid Tavern, Derwent Street, Workington","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",299997,529010,0.06,"Not owned by a public authority",null,"Permissioned","Full Planning Permission","13.04.2010","http://planning.allerdale.gov.uk/portal/servlets/ApplicationSearchServlet?PKID=74263",null,5,null,"N/A",null,5,5,null,null,"5 bedsits","2017-12-20"]
["http://opendatacommunities.org/id/district-council/allerdale","Allerdale Borough Council","BR/WOR/010H",null,"Land south of Isabella Road, Workington","http://mapping.allerdale.gov.uk/myallerdale.aspx","OSGB36",298714,529086,3,"Not owned by a public authority",null,"Not Permissioned",null,null,null,null,80,null,"N/A",null,80,120,null,null,null,"2017-12-20"]

{"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"]