{"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":11,"n_cols":28,"rows_kept":11,"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/huntingdonshire","Huntingdonshire District Council","HDCBLR01",null,"\"Former Forensic Science Laboratory, Hinchingbrooke Park, Hinchingbrooke Park Road, Huntingdon PE29 6NU\"","https://publicaccess.huntingdonshire.gov.uk/online-applications/applicationDetails.do?keyVal=OTNLYCIKG4I00&activeTab=summary","OSGB36",522187,272099,2.7,"not owned by a public authority","yes","permissioned","full planning permission","2017-11-08","https://publicaccess.huntingdonshire.gov.uk/online-applications/applicationDetails.do?keyVal=OTNLYCIKG4I00&activeTab=summary",null,103,"Demolition of the former science laboratory and erection of 103 residential dwellings and associated infrastructure",null,null,null,null,null,"http://huntsdc.objective.co.uk/portal/pp/hlp2036/cd2017/helaa2017?pointId=s1432198791358#s1432198791358","17/01597/FUL approved November 2017","2017-12-20","2017-12-20"]
["http://opendatacommunities.org/id/district-council/huntingdonshire","Huntingdonshire District Council","HDCBLR02",null,"\"Land At And Including British Gas Plc, Mill Common, Huntingdon\"","https://publicaccess.huntingdonshire.gov.uk/online-applications/simpleSearchResults.do?action=firstPage","OSGB36",523790,271318,0.6,"not owned by a public authority","yes","pending decision",null,null,"https://publicaccess.huntingdonshire.gov.uk/online-applications/simpleSearchResults.do?action=firstPage",null,11,"Residential development for 11 dwellings and creation of access",null,null,null,null,null,"http://huntsdc.objective.co.uk/portal/pp/hlp2036/cd2017/helaa2017?pointId=s1432199916927#s1432199916927","16/02093/FUL submitted October 2016","2017-12-20","2017-12-20"]
["http://opendatacommunities.org/id/district-council/huntingdonshire","Huntingdonshire District Council","HDCBLR03",null,"\"Land Adjacent And Including 2 Cromwell Road, Eynesbury\"","http://huntsdc.objective.co.uk/portal/pp/hlp2036/cd2017/helaa2017?pointId=s1435050323013#s1435050323013","OSGB36",519391,260096,2.6,"not owned by a public authority","yes","not permissioned",null,null,null,null,80,"Residential development",null,null,null,null,null,"http://huntsdc.objective.co.uk/portal/pp/hlp2036/cd2017/helaa2017?pointId=s1435050323013#s1435050323013","Draft allocation in Local Plan to 2036","2017-12-20","2017-12-20"]
["http://opendatacommunities.org/id/district-council/huntingdonshire","Huntingdonshire District Council","HDCBLR04",null,"\"Car Park, Cromwell Road, Eynesbury\"","https://publicaccess.huntingdonshire.gov.uk/online-applications/simpleSearchResults.do?action=firstPage","OSGB36",519252,259811,0.6,"not owned by a public authority","yes","pending decision",null,null,"https://publicaccess.huntingdonshire.gov.uk/online-applications/simpleSearchResults.do?action=firstPage",null,21,"Outline application for residential development of up to 21 dwellings",null,null,null,null,null,"http://huntsdc.objective.co.uk/portal/pp/hlp2036/cd2017/helaa2017?pointId=s1435050323015#s1435050323015","0901288OUT submitted October 2009. Pending completion of S106  agreement.","2017-12-20","2017-12-20"]
["http://opendatacommunities.org/id/district-council/huntingdonshire","Huntingdonshire District Council","HDCBLR05",null,"\"Former Car Showroom, London Road, St Ives, PE27 5EZ\"","https://publicaccess.huntingdonshire.gov.uk/online-applications/simpleSearchResults.do?action=firstPage","OSGB36",531073,270731,1.4,"not owned by a public authority","yes","not permissioned",null,null,"https://publicaccess.huntingdonshire.gov.uk/online-applications/simpleSearchResults.do?action=firstPage",null,50,"Residential development",null,null,null,null,null,"http://huntsdc.objective.co.uk/portal/pp/hlp2036/cd2017/helaa2017?pointId=s1430127365895#s1430127365895","Draft allocation in Local Plan to 2036","2017-12-20","2017-12-20"]
["http://opendatacommunities.org/id/district-council/huntingdonshire","Huntingdonshire District Council","HDCBLR06",null,"\"94 Great Whyte, Ramsey, Huntingdon, PE26 1HR\"","https://publicaccess.huntingdonshire.gov.uk/online-applications/simpleSearchResults.do?action=firstPage","OSGB36",528512,285398,0.7,"not owned by a public authority","yes","pending decision",null,null,"https://publicaccess.huntingdonshire.gov.uk/online-applications/simpleSearchResults.do?action=firstPage",null,32,"\"Change of use of land, demolition of existing warehouse/store buildings and portable cabin.  Construction of a housing development consisting of 32 dwellings with associated vehicular/pedestrian access and landscaping.\"",null,null,null,null,null,"http://huntsdc.objective.co.uk/portal/pp/hlp2036/cd2017/helaa2017?pointId=s1432202757731#s1432202757731","15/02384/FUL submitted December 2015","2017-12-20","2017-12-20"]
["http://opendatacommunities.org/id/district-council/huntingdonshire","Huntingdonshire District Council","HDCBLR07",null,"\"Land At And Including 46 Whytefield Road, Ramsey\"","http://huntsdc.objective.co.uk/portal/pp/hlp2036/cd2017/helaa2017?pointId=s1432202623157#s1432202623157","OSGB36",528399,285160,0.9,"not owned by a public authority","yes","not permissioned",null,null,null,null,40,"Residential development.",null,null,null,null,null,"http://huntsdc.objective.co.uk/portal/pp/hlp2036/cd2017/helaa2017?pointId=s1432202623157#s1432202623157","Allocated for housing in Local Plan Alteration 2002. Draft allocation in Local Plan to 2036","2017-12-20","2017-12-20"]
["http://opendatacommunities.org/id/district-council/huntingdonshire","Huntingdonshire District Council","HDCBLR08",null,"\"Former RAF Upwood and Upwood Hill House, Bury Road, Ramsey\"","https://publicaccess.huntingdonshire.gov.uk/online-applications/simpleSearchResults.do?action=firstPage","OSGB36",527277,283615,25,"not owned by a public authority","yes","permissioned","outline planning permission","2017-06-07","https://publicaccess.huntingdonshire.gov.uk/online-applications/simpleSearchResults.do?action=firstPage",null,160,"\"Selective demolition and clearance of existing (former defence) buildings, environmental remediation and the carrying out of employment-led mixed use development comprising about 2 hectares of employment (Use Class Order B1 uses) (including the conversion and change of use of some buildings) and residential (not more than 160 dwellings) development, together with the provision of infrastructure and the laying out of ancillary open space. (Phased Development)\"","2ha of employment land for business uses (class 'B1'), 3.community facilities appropriate to the scale of development",null,null,null,null,"http://huntsdc.objective.co.uk/portal/pp/hlp2036/cd2017/helaa2017?pointId=s1432202922047#s1432202922047","1201274OUT approved June 2017","2017-12-20","2017-12-20"]
["http://opendatacommunities.org/id/district-council/huntingdonshire","Huntingdonshire District Council","HDCBLR09",null,"\"Clinic, RAF Upwood, Upwood Road, Bury\"","https://publicaccess.huntingdonshire.gov.uk/online-applications/applicationDetails.do?keyVal=NHYSB8IKMNQ00&activeTab=summary","OSGB36",527744,283587,2,"not owned by a public authority","yes","permissioned","full planning permission","2015-12-23","https://publicaccess.huntingdonshire.gov.uk/online-applications/applicationDetails.do?keyVal=NHYSB8IKMNQ00&activeTab=summary",null,60,"Development of 60 houses following demolition of former USAF clinic building",null,null,null,null,null,"https://publicaccess.huntingdonshire.gov.uk/online-applications/applicationDetails.do?keyVal=NHYSB8IKMNQ00&activeTab=summary","15/00029/FUL approved December 2015","2017-12-20","2017-12-20"]
["http://opendatacommunities.org/id/district-council/huntingdonshire","Huntingdonshire District Council","HDCBLR10",null,"\"Land Adjacent St Marys Road Industrial Estate, St Marys Road, Ramsey\"","https://publicaccess.huntingdonshire.gov.uk/online-applications/simpleSearchResults.do?action=firstPage","OSGB36",528270,285730,1.7,"not owned by a public authority","yes","pending decision",null,null,"https://publicaccess.huntingdonshire.gov.uk/online-applications/simpleSearchResults.do?action=firstPage",null,52,"\"Change of use. Construction of 52 dwellings and associated infrastructure, landscaping and parking.\"",null,null,null,null,null,"http://huntsdc.objective.co.uk/portal/pp/hlp2036/cd2017/helaa2017?pointId=s1430127377882#s1430127377882","16/00311/FUL submitted February 2016","2017-12-20","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"]