A free mapping tool that allows you to create a thematic map of London without any specialist GIS skills or software - all you need is Microsoft Excel. Templates are available for London’s Boroughs and Wards. Full instructions are contained within the spreadsheets. Macros The tool works in any version of Excel. But the user MUST ENABLE MACROS, for the features to work. There a some restrictions on functionality in the ward maps in Excel 2003 and earlier - full instructions are included in the spreadsheet. To check whether the macros are enabled in Excel 2003 click Tools, Macro, Security and change the setting to Medium. Then you have to re-start Excel for the changes to take effect. When Excel starts up a prompt will ask if you want to enable macros - click yes. In Excel 2007 and later, it should be set by default to the correct setting, but if it has been changed, click on the Windows Office button in the top corner, then Excel options (at the bottom), Trust Centre, Trust Centre Settings, and make sure it is set to 'Disable all macros with notification'. Then when you open the spreadsheet, a prompt labelled 'Options' will appear at the top for you to enable macros. To create your own thematic borough maps in Excel using the ward map tool as a starting point, read these instructions. You will need to be a confident Excel user, and have access to your boundaries as a picture file from elsewhere. The mapping tools created here are all fully open access with no passwords. Copyright notice: If you publish these maps, a copyright notice must be included within the report saying: "Contains Ordnance Survey data © Crown copyright and database rights." NOTE: Excel 2003 users must 'ungroup' the map for it to work.
This is an excel mapping tool that was built based on Cuba administrative boundaries (admin2) - extracted from the GADM database (www.gadm.org), version 2.8, November 2015. Available on HDX: https://data.humdata.org/dataset/cuba-administrative-boundaries-levels-0-and-1-from-gadm). The population dataset is a sample data. The tool is built to help people to quickly map their datasets.
With this add in it is possible to create map templates from GIS files in KML format, and create choropleths with them.
Providing you have access to KML format map boundary files, it is possible to create your own quick and easy choropleth maps in Excel. The KML format files can be converted from 'shape' files. Many shape files are available to download for free from the web, including from Ordnance Survey and the London Datastore. Standard mapping packages such as QGIS (free to download) and ArcGIS can convert the files to KML format.
A sample of a KML file (London wards) can be downloaded from this page, so that users can easily test the tool out.
Macros must be enabled for the tool to function.
When creating the map using the Excel tool, the 'unique ID' should normally be the area code, the 'Name' should be the area name and then if required and there is additional data in the KML file, further 'data' fields can be added. These columns will appear below and to the right of the map. If not, data can be added later on next to the codes and names.
In the add-in version of the tool the final control, 'Scale (% window)' should not normally be changed. With the default value 0.5, the height of the map is set to be half the total size of the user's Excel window.
To run a choropleth, select the menu option 'Run Choropleth' to get this form.
To specify the colour ramp for the choropleth, the user needs to enter the number of boxes into which the range is to be divided, and the colours for the high and low ends of the range, which is done by selecting coloured option boxes as appropriate. If wished, hit the 'Swap' button to change which colours are for the different ends of the range. Then hit the 'Choropleth' button.
The default options for the colours of the ends of the choropleth colour range are saved in the add in, but different values can be selected but setting up a column range of up to twelve cells, anywhere in Excel, filled with the option colours wanted. Then use the 'Colour range' control to select this range, and hit apply, having selected high or low values as wished. The button 'Copy' sets up a sheet 'ColourRamp' in the active workbook with the default colours, which can just be extended or deleted with just a few cells, so saving the user time.
The add-in was developed entirely within the Excel VBA IDE by Tim Lund. He is kindly distributing the tool for free on the Datastore but suggests that users who find the tool useful make a donation to the Shelter charity. It is not intended to keep the actively maintained, but if any users or developers would like to add more features, email the author.
Acknowledgments
Calculation of Excel freeform shapes from latitudes and longitudes is done using calculations from the Ordnance Survey.
This is an excel mapping tool that was built based on Dominican Republic administrative boundaries (admin3). Available on HDX: Available on HDX: https://data.humdata.org/dataset/dominican-republic-administrative-boundaries-levels-0-6.. The population dataset is a sample data. The tool is built to help people to quickly map their datasets.
Why use Excel 3D Maps? What are the limitations? This presentations shows how to use Excel to create dynamic 3D maps.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
The main objective of the mapping tool is to provide a simple and useable platform for MSs to map their country-specific standard terminology to that used by EFSA and to enable the production of an XML file for the submission of sample or aggregated-based zoonoses monitoring data via the DCF.
The catalogues and the specific hierarchy of each data model (AMR, ESBL, PRV, FBO, POP and DST) are already inserted into each of the specific mapping tool. Specific Excel mapping tools correspond to each of the six data models are available.
You can choose between the dynamic or the manual version of the tool.
This is an excel mapping tool that was built based on Caribbean Islands administrative boundaries (admin0). The Map datasets was coming from GADM, Centre National de l'Information Géo-Spatiale (Haiti) and Oficina Nacional de Estadística (Dominican Republic). The population dataset is a sample data. This tool is made for people in the field with limited access to GIS to quickly map their data.
CC0 1.0 Universal Public Domain Dedicationhttps://creativecommons.org/publicdomain/zero/1.0/
License information was derived automatically
Calculation of Excel freeform shapes from latitudes and longitudes is done using calculations from the Ordnance Survey.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
The main objective of the mapping tools is to provide a simple and useable platform for Member States and other reporting countries to map their country-specific standard terminology to that used by EFSA and to enable the production of an XML file for the submission of antimicrobial resistance data via the Data Collection Framework (DCF).
The tools can be used to report antimicrobial resistance data within the framework of Directive 2003/99/EC and Decision 2020/1729/EU.
The catalogues and the specific hierarchy of each data model (AMR and ESBL) are already inserted into each of the specific mapping tool. Specific Excel mapping tools corresponding to each of the two data models are available.
Dynamic or manual version of the tool can be chosen for each data models.
A free mapping tool that allows you to create a thematic map of London without any specialist GIS skills or software - all you need is Microsoft Excel. Templates are available for London’s Boroughs and Wards. Full instructions are contained within the spreadsheets.
The tool works in any version of Excel. But the user MUST ENABLE MACROS, for the features to work. There a some restrictions on functionality in the ward maps in Excel 2003 and earlier - full instructions are included in the spreadsheet.
To check whether the macros are enabled in Excel 2003 click Tools, Macro, Security and change the setting to Medium. Then you have to re-start Excel for the changes to take effect. When Excel starts up a prompt will ask if you want to enable macros - click yes.
In Excel 2007 and later, it should be set by default to the correct setting, but if it has been changed, click on the Windows Office button in the top corner, then Excel options (at the bottom), Trust Centre, Trust Centre Settings, and make sure it is set to 'Disable all macros with notification'. Then when you open the spreadsheet, a prompt labelled 'Options' will appear at the top for you to enable macros.
To create your own thematic borough maps in Excel using the ward map tool as a starting point, read these instructions. You will need to be a confident Excel user, and have access to your boundaries as a picture file from elsewhere. The mapping tools created here are all fully open access with no passwords.
Copyright notice: If you publish these maps, a copyright notice must be included within the report saying: "Contains Ordnance Survey data © Crown copyright and database rights."
NOTE: Excel 2003 users must 'ungroup' the map for it to work.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
The main objective of the mapping tool is to provide a simple and useable platform for Member states and other reporting countriesto map their country-specific standard terminology to that used by EFSA and to enable the production of an XML file for the submission of sample or aggregated-based zoonoses monitoring data via the Data Collection Framework (DCF).
The catalogues and the specific hierarchy of each data model (AMR, ESBL, PRV, FBO, POP and DST) are already inserted into each of the specific mapping tool. Specific Excel mapping tools correspond to each of the six data models are available.
You can choose between the dynamic or the manual version of the tool.
This video demonstrates how school board administrators map and analyze student achievement using ArcGIS Maps for Office and ArcGIS Online. Specifically, it covers how to prepare and map student data from Microsoft Excel, how to enrich that data with the geoenrichment service in ArcGIS Online and how to share, communicate and present your work in Microsoft PowerPoint and in Story Map applications.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
The main objective of the mapping tool is to provide a simple and useable platform for MSs to map their country-specific standard terminology to that used by EFSA and to enable the production of an XML file for the submission of sample or aggregated-based zoonoses monitoring data via the DCF.
The catalogues and the specific hierarchy of each data model (AMR, ESBL, PRV, FBO, POP and DST) are already inserted into each of the specific mapping tool. Specific Excel mapping tools correspond to each of the six data models are available.
You can choose between the dynamic or the manual version of the tool.
Attribution-NonCommercial 4.0 (CC BY-NC 4.0)https://creativecommons.org/licenses/by-nc/4.0/
License information was derived automatically
Unlocking Data to Inform Public Health Policy and Practice: WP1 Mapping Review Supplementary Excel S1
The data extracted into Excel Tab "S1 Case studies (extracted)" represents information from 31 case studies as part of the "Unlocking Data to Inform Public Health Policy and Practice" project, Workpackage (WP) 1 Mapping Review.
Details about the WP1 mapping review can be found in the "Unlocking Data to Inform Public Health Policy and Practice" project report, which can be found via this DOI link: https://doi.org/10.15131/shef.data.21221606
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
The main objective of the mapping tools is to provide a simple and useable platform for Member states and other reporting countries to map their country-specific standard terminology to that used by EFSA and to enable the production of an XML file for the submission of sample or aggregated-based zoonoses monitoring data via the Data Collection Framework (DCF).
The catalogues and the specific hierarchy of each data model (AMR, ESBL, PRV, FBO, AP, DS and SSD2 for Echinococcus multilocularis) are already inserted into each of the specific mapping tool. Specific Excel mapping tools corresponding to each of the seven data models are available.
Dynamic or manual version of the tool can be chosen for the first six data models.
The Emulti_SSD2_tool can be used to report sample-based results of Echinococcus multilocularis under the Commission Delegated Regulation (EU) 2018/772.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
The main objective of the mapping tools is to provide a simple and useable platform for Member states and other reporting countries to map their country-specific standard terminology to that used by EFSA and to enable the production of an XML file for the submission of sample or aggregated-based zoonoses monitoring data via the Data Collection Framework (DCF).
The catalogues and the specific hierarchy of each data model (AMR, ESBL, PRV, FBO, POP, DST and SSD2 for Echinococcus multilocularis) are already inserted into each of the specific mapping tool. Specific Excel mapping tools correspond to each of the seven data models are available.
You can choose between the dynamic or the manual version of the tool for the first six data models.
The Emulti_SSD2_tool can be used to report sample-based results of Echinococcus multilocularis under the Commission Delegated Regulation (EU) 2018/772.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
List of the thresholds used for each parameter and country to map the forest areas not available for wood supply.
Attribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Data collection is an important task of the European Food Safety Authority (EFSA) and a fundamental component of risk assessment (Articles 22 and 23 of Regulation (EC) No 178/2002). EFSA receives a large volume of data from Member States (MSs) that is used in support of its risk assessment mission.
Council Directive 2005/94/EC and Commission Decision 2010/367/EU lay down the guidelines for monitoring and reporting avian influenza surveillance data on poultry and wild birds by European Union (EU) MSs. EFSA has been assigned the task of collating, validating, analysing, and summarising in an annual report the results from the avian influenza surveillance programmes in poultry and wild birds. For the reporting of data, EFSA provides a Data Collection Framework that allows data providers to submit data in eXtensible Markup Language (XML) format through a web interface or a web service. Here, a data model describing the format, and the content requested when submitting data through the DCF, is provided.
The data model supports the reporting of laboratory testing results for avian influenza in both wild birds, and poultry. The use of this reporting standard ensures that reported results are comparable between reporting countries. Data reported in this format will be used to generate epidemiological updates on the avian influenza surveillance testing carry out in Europe, and to provide scientific advice to the European Commission.
This excel contains results from the 2017 State of Narragansett Bay and Its Watershed Technical Report (nbep.org), Chapter 4: "Population." The methods for analyzing population were developed by the US Environmental Protection Agency ORD Atlantic Coastal Environmental Sciences Division in collaboration with the Narragansett Bay Estuary Program and other partners. Population rasters were generated using the USGS dasymetric mapping tool (see http://geography.wr.usgs.gov/science/dasymetric/index.htm) which uses land use data to distribute population data more accurately than simply within a census mapping unit. The 1990, 2000, and 2010 10m cell population density rasters were produced using Rhode Island state land use data, Massachusetts state land use, Connecticut NLCD land use data, and U.S. Census data. To generate a population estimate (number of persons) for any given area within the boundaries of this raster, NBEP used the the Zonal Statistics as Table tool to sum the 10m cell density values within a given zone dataset (e.g., watershed polygon layer). Results presented include population estimates (1990, 2000, 2010) as well as calculation of percent change (1990-2000;2000-2010;1990-2010).
For many of us, urban areas are the first thing that comes to mind when we think of spaces that have been altered by people. But, as it turns out, these mental images aren't very representative of our overall land use. In the second chapter of our Living in the Age of Humans series, the Esri Story Maps team takes a closer look at the ways Homo sapiens have modified Earth's limited land, and what implications this use has for our future.Data:NASA Blue Marble, July 2004Esri World ImageryESA CCI-LC Land Cover (2015)CIESIN Global Croplands, v1 (2000)CIESIN Global Pastures, v1 (2000)WheatMaizeRiceSoybeansForest Loss**The documentation below is in reference to this items placement in the NM Supply Chain Data Hub. The documentation is of use to understanding the source of this item, and how to reproduce it for updates**Title: The Living LandItem Type: Web Mapping Application Storymap URLSummary: A look at how humans use the Earth's limited land space.Notes: Prepared by: Uploaded by EMcRae_NMCDCSource: Copy of this original map product: https://nmcdc.maps.arcgis.com/home/item.html?id=d29065c5443f4d008e7d7e181e54b05dFeature Service: https://nmcdc.maps.arcgis.com/home/item.html?id=8a16839162554968ac6d2cf0513bcefaUID: 26Data Requested: Ag CensusMethod of Acquisition: Living AtlasDate Acquired: 5/2022Priority rank as Identified in 2022 (scale of 1 being the highest priority, to 11 being the lowest priority): 8Tags: PENDING
A free mapping tool that allows you to create a thematic map of London without any specialist GIS skills or software - all you need is Microsoft Excel. Templates are available for London’s Boroughs and Wards. Full instructions are contained within the spreadsheets. Macros The tool works in any version of Excel. But the user MUST ENABLE MACROS, for the features to work. There a some restrictions on functionality in the ward maps in Excel 2003 and earlier - full instructions are included in the spreadsheet. To check whether the macros are enabled in Excel 2003 click Tools, Macro, Security and change the setting to Medium. Then you have to re-start Excel for the changes to take effect. When Excel starts up a prompt will ask if you want to enable macros - click yes. In Excel 2007 and later, it should be set by default to the correct setting, but if it has been changed, click on the Windows Office button in the top corner, then Excel options (at the bottom), Trust Centre, Trust Centre Settings, and make sure it is set to 'Disable all macros with notification'. Then when you open the spreadsheet, a prompt labelled 'Options' will appear at the top for you to enable macros. To create your own thematic borough maps in Excel using the ward map tool as a starting point, read these instructions. You will need to be a confident Excel user, and have access to your boundaries as a picture file from elsewhere. The mapping tools created here are all fully open access with no passwords. Copyright notice: If you publish these maps, a copyright notice must be included within the report saying: "Contains Ordnance Survey data © Crown copyright and database rights." NOTE: Excel 2003 users must 'ungroup' the map for it to work.