{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Introductory Note","Data Tracker - Analysis","Data Tracker - Collation","Values"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":2,"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":"Introductory Note","index":0,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Why you need a Data Tracker\n\nRecording each information source e.g. reports, code, images, spatial files etc you use in your evidence or other output will give you a complete record of how your output has been created, and:\n\n·         it can save you time, keep you organised and help you make the most of the data you are working with;\n\n·         you will understand the provenance and use permissions of your input sources, minimising the risk of data misuse and so building trust in our data management across and beyond the organisation.\n\n·         you have all the information to hand which Data Services require to advise you with any difficulties you’re having, and at the end of your work to license your outputs for internal and external use and, where required, publish them; and\n\n·         everyone in Natural England can find, review or re-use the sources underpinning your evidence."]
["When to use a Tracker\n\nYou should create a Tracker at the start of each new piece of work, regardless of whether it is to be published, where you are using multiple existing third party information sources or other intellectual property.  You may need existing data help you collect new data such site maps in data capture apps, or to create a new work by combining or deriving from them.\n\nWhere your work has multiple outputs there is a column for you to indicate which one the item is being used in - as licences permit different uses - for example you may use for navigation in a data capture app, but not in a publishable derived work."]
["How to complete the Data Tracker\n\nHide any optional sections that you don’t need for your project and add additional columns you need at the end.\n\nNavigate horizontally across the spreadsheet and use the notes in each column heading to guide you in what you need to put.\n\nYou should have one record (row) for each Intellectual Property item – reports, articles, images, code etc as well as data unless you are entering a dataset, in which case record the dataset as a whole, rather than one row for each file/part of the dataset (unless you need to record different metadata for each part)."]
["Things to keep in mind\n\nMake sure you properly store your data and Trackers according to Natural England's policies and guidance\n\nUpdate your Tracker every time you use a new item"]
["If you have any queries about this template, please contact Data Services:"]
["https://defra.sharepoint.com/teams/Team2571/SitePages/Home.aspx"]

{"sheet":"Data Tracker - Analysis","index":1,"n_rows":6,"n_cols":40,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,2,0,9],[0,38,0,39],[0,11,0,17],[0,21,0,23],[0,24,0,31],[0,32,0,37],[0,18,0,20]]}
["ID","Internal Contact","Item Description",null,null,null,null,null,null,null,"Natural England-owned data","Licence (for non Natural England-owned data)",null,null,null,null,null,null,"Usage",null,null,"External Contact Details",null,null,"Optional GI Info",null,null,null,null,null,null,null,"Optional Temporal Info",null,null,null,null,null,"Optional project-specific columns"]
["Item Unique ID","Who is responsible for the item?","Item Title","Alternative Title\n(optional)","Sensitive contents","Item Date","Link to Data","Confidence in the Data\n(optional)","Abstract\n(optional)","Data Format\n(optional)","Lineage","Link to INTERNALLY stored licence2","Licence type","Use Constraints","Attribution Statement","Citation\n(optional)","Licence Expiry Date","Date Item Deleted","For non-open licensed data, what of the original item will be visible, reverse engineerable etc in your final product?","Output type/name (where you have multiple outputs)","Comments","Item owner or guardian","Name","Contact Email","Spatial Ref","Geographic Area","N","S","E","W","-Z","+Z","Start Date of Data Capture","End Date of Data Capture","Dataset Creation Date","Dataset Published Date","Dataset Revision Date","Frequency of update","Column1","Column2"]
["IC23/23-0001",null,"Saltmarsh Extent and Zonation",null,"No","2023-02-03","Saltmarsh Extent & Zonation - data.gov.uk",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["IC23/23-0002",null,"People and Nature Survey","PANS","No","2023-05-18","The People and Nature Survey for England: Year 2 Annual Report – Data and publications (April 2021 - March 2022) (Official Statistics) main findings - GOV.UK (www.gov.uk)"]
["IC23/23-0003",null,"Green and Blue Infrastructure Asset Maps",null,"No",null,"Must be requested directly from NE: https://www.gov.uk/guidance/how-to-access-natural-englands-maps-and-data#request-data"]
["IC23/23-0004",null,"Accessible Green Space",null,"No",null,"Must be requested directly from NE: https://www.gov.uk/guidance/how-to-access-natural-englands-maps-and-data#request-data"]

{"sheet":"Data Tracker - Collation","index":2,"n_rows":22,"n_cols":40,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,38,0,39],[0,2,0,9],[0,11,0,17],[0,18,0,20],[0,21,0,23],[0,24,0,31],[0,32,0,37]]}
["ID","Internal Contact","Item Description",null,null,null,null,null,null,null,"Natural England-owned data","Licence (for non Natural England-owned data)",null,null,null,null,null,null,"Usage",null,null,"External Contact Details",null,null,"Optional GI Info",null,null,null,null,null,null,null,"Optional Temporal Info",null,null,null,null,null,"Optional project-specific columns"]
["Item Unique ID","Who is responsible for the item?","Item Title","Alternative Title\n(optional)","Sensitive contents","Item Date","Link to Data","Confidence in the Data\n(optional)","Abstract\n(optional)","Data Format\n(optional)","Lineage","Link to INTERNALLY stored licence2","Licence type","Use Constraints","Attribution Statement","Citation\n(optional)","Licence Expiry Date","Date Item Deleted","For non-open licensed data, what of the original item will be visible, reverse engineerable etc in your final product?","Output type/name (where you have multiple outputs)","Comments","Item owner or guardian","Name","Contact Email","Spatial Ref","Geographic Area","N","S","E","W","-Z","+Z","Start Date of Data Capture","End Date of Data Capture","Dataset Creation Date","Dataset Published Date","Dataset Revision Date","Frequency of update","Column1","Column2"]
["IC23/23-0002",null,"People and Nature Survey","PANS","No","2023-05-18","The People and Nature Survey for England: Year 2 Annual Report – Data and publications (April 2021 - March 2022) (Official Statistics) main findings - GOV.UK (www.gov.uk)"]
["IC23/23-0003",null,"Green and Blue Infrastructure Asset Maps","GI","No",null,"Must be requested directly from NE: https://www.gov.uk/guidance/how-to-access-natural-englands-maps-and-data#request-data"]
["IC23/23-0004",null,"Accessible Green Space","AGST","No",null,"Must be requested directly from NE: https://www.gov.uk/guidance/how-to-access-natural-englands-maps-and-data#request-data"]
["IC23/23-0005",null,"NE Contract \"Data analysis testing for a State of Natural Capital Report\" Outputs",null,"No",null,"Must be requested directly from NE"]
["IC23/23-0006",null,"NE Contract \"Countryside Survey data testing for a State of Natural Capital Report\" Outputs",null,"No",null,"Must be requested directly from NE"]
["IC23/23-0007",null,"Marine Protected Area Coverage/Condition",null,"No",null,"Must be requested directly from NE"]
["IC23/23-0008",null,"UKCEH Soils Report 2007",null,"No","2010-02-23","https://countrysidesurvey.org.uk/sites/default/files/CS_UK_2007_TR9-revised%20-%20Soils%20Report.pdf"]
["IC23/23-0009",null,"UK Butterfly Monitoring Scheme","UKBMS","No","2023-01-04","Butterflies in England: species of the wider countryside on farmland and in woodland, 1990 to 2021 - GOV.UK (www.gov.uk)"]
["IC23/23-0010",null,"Bird Indices","BBS","No","2023-04-13","Wild bird populations in England, 1970 to 2021 - GOV.UK (www.gov.uk)"]
["IC23/23-0011",null,"Water Framework Directive Classification Status Cycle 2",null,"No","2021-01-28","WFD Classification Status Cycle 2 - data.gov.uk"]
["IC23/23-0012",null,"Water Framework Directive Cycle 2 Groundwater Classification Status and Objectives",null,"No","2020-09-29","WFD Cycle 2 groundwater classification status and objectives - data.gov.uk"]
["IC23/23-0013",null,"Outcome Indicator Framework","OIF","No",null,"https://oifdata.defra.gov.uk/"]
["IC23/23-0014",null,"UKMMAS: Pelagic Habitats",null,"No",null,"Pelagic habitats - Marine online assessment tool (cefas.co.uk)"]
["IC23/23-0015",null,"UKMMAS: Benthic Habitats",null,"No",null,"Benthic habitats - Marine online assessment tool (cefas.co.uk)"]
["IC23/23-0016",null,"UKMMAS: Commercially Exploited Fish and Shellfish",null,"No",null,"Commercial fish and shellfish - Marine online assessment tool (cefas.co.uk)"]
["IC23/23-0017",null,"UKMMAS: Seals",null,"No",null,"Seals - Marine online assessment tool (cefas.co.uk)"]
["IC23/23-0018",null,"UKMMAS: Birds",null,"No",null,"Birds - Marine online assessment tool (cefas.co.uk)"]
["IC23/23-0019",null,"2022 Statistics on English Coastal and Inland Bathing Waters",null,"No","2022-10-30","2022 Statistics on English coastal and inland bathing waters: A summary of compliance with the 2013 bathing water regulations - GOV.UK (www.gov.uk)"]
["IC23/23-0020",null,"National Forest Inventory",null,"No",null,"NFI Woodland Ecological Condition - Forest Research"]
["IC23/23-0021",null,"Trends Report 2022: Trends in critical load and critical level exceedances in the UK",null,"No","2022-08-30","Report: Trends Report 2022: Trends in critical load and critical level exceedances in the UK - Defra, UK"]

{"sheet":"Values","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Frequency of update",null,"Confidence",null,"Licence type",null,"Spatial Ref"]
["Values",null,"Values",null,"Values",null,"Values"]
["Annually",null,"Confident",null,"OGL or CC BY (Open licence)",null,"BNG"]
["As needed",null,"Use with caution",null,"Open licence with Share Alike condition (eg CC BY-SA, GNU GPL)",null,"WGS84"]
["Biannually",null,"Unknown",null,"Non-commercial licence: NCGL or CC BY-NC",null,"Custom"]
["Continual",null,null,null,"Non-commercial licence with Share Alike condition (eg CC BY-NC-SA)"]
["Daily",null,null,null,"Natural England's template agreement for developing Derivative Works only"]
["Fortnightly",null,null,null,"Natural England's template agreement for publishing Data as well as Derivative Works"]
["Irregular",null,null,null,"Other licence - follow Use Constraints"]
["Monthly",null,null,null,"NE-owned but unlicensed"]
["Not planned",null,null,null,"N/A as public domain (CC0 or item is out of copyright)"]
["Quarterly"]
["Unknown"]
["Weekly"]