Screencast on how to export field observations with gps coordinates in Excel to a .csv file.

This is a collection of all GPS- and computer-generated geospatial data specific to the Alpine Treeline Warming Experiment (ATWE), located on Niwot Ridge, Colorado, USA. The experiment ran between 2008 and 2016, and consisted of three sites spread across an elevation gradient. Geospatial data for all three experimental sites and cone/seed collection locations are included in this package. ––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––– Geospatial files include cone collection, experimental site, seed trap, and other GPS location/terrain data. File types include ESRI shapefiles, ESRI grid files or Arc/Info binary grids, TIFFs (.tif), and keyhole markup language (.kml) files. Trimble-imported data include plain text files (.txt), Trimble COR (CorelDRAW) files, and Trimble SSF (Standard Storage Format) files. Microsoft Excel (.xlsx) and comma-separated values (.csv) files corresponding to the attribute tables of many files within this package are also included. A complete list of files can be found in this document in the “Data File Organization” section in the included Data User's Guide. Maps are also included in this data package for reference and use. These maps are separated into two categories, 2021 maps and legacy maps, which were made in 2010. Each 2021 map has one copy in portable network graphics (.png) format, and the other in .pdf format. All legacy maps are in .pdf format. .png image files can be opened with any compatible programs, such as Preview (Mac OS) and Photos (Windows). All GIS files were imported into geopackages (.gpkg) using QGIS, and double-checked for compatibility and data/attribute integrity using ESRI ArcGIS Pro. Note that files packaged within geopackages will open in ArcGIS Pro with “main.” preceding each file name, and an extra column named “geom” defining geometry type in the attribute table. The contents of each geospatial file remain intact, unless otherwise stated in “niwot_geospatial_data_list_07012021.pdf/.xlsx”. This list of files can be found as an .xlsx and a .pdf in this archive. As an open-source file format, files within gpkgs (TIFF, shapefiles, ESRI grid or “Arc/Info Binary”) can be read using both QGIS and ArcGIS Pro, and any other geospatial softwares. Text and .csv files can be read using TextEdit/Notepad/any simple text-editing software; .csv’s can also be opened using Microsoft Excel and R. .kml files can be opened using Google Maps or Google Earth, and Trimble files are most compatible with Trimble’s GPS Pathfinder Office software. .xlsx files can be opened using Microsoft Excel. PDFs can be opened using Adobe Acrobat Reader, and any other compatible programs. A selection of original shapefiles within this archive were generated using ArcMap with associated FGDC-standardized metadata (xml file format). We are including these original files because they contain metadata only accessible using ESRI programs at this time, and so that the relationship between shapefiles and xml files is maintained. Individual xml files can be opened (without a GIS-specific program) using TextEdit or Notepad. Since ESRI’s compatibility with FGDC metadata has changed since the generation of these files, many shapefiles will require upgrading to be compatible with ESRI’s latest versions of geospatial software. These details are also noted in the “niwot_geospatial_data_list_07012021” file.

The data are derived from interpretation of seismic reflection profiles within the offshore Corinth Rift, Greece (the Gulf of Corinth) integrated with IODP scientific ocean drilling borehole data from IODP Expedition 381 (McNeill et al., 2019a, 2019b). The data include rift fault coordinate (location, geometry) information and slip rate and extension rate information for the major faults. Seismic reflection data were published in Taylor et al. (2011) and in Nixon et al. (2016). Preliminary fault interpretations and rate data, prior to IODP drilling, were published in Nixon et al. (2016). Details of datasets: The data can be viewed in GIS software (ArcGIS, QGIS) or the Excel and .dbf files can be used for viewing of rate data and import of fault coordinates into other software. The 4 folders are for different time periods with shape files for the N-Dipping and S-Dipping Faults in the offshore Corinth Rift and respective slip and extension (horizontal) rates. The shapefiles are digitised fault traces for the basement offsetting faults, picked from the Multichannel Seismic Data collected by the R/V Maurice Ewing. Fault traces are segmented and each segment has an average throw (vertical) rate (Tavg) in mm/yr. The rates for the segments are averages based on measurements at the ends of each segment. The major fault trace segments also have slip-rates (slip_rate) and extension-rates (ext_rate or extension_) in mm/yr. All rates as well as the names for major faults can be located in the attribute table of the shape files along with X- and Y-coordinates. The coordinate system is WGS84 UTM Zone 34N. The shape files can be loaded into a GIS (ArcGIS, QGIS etc.) allowing mapping and visualization of the fault traces and their activity rates. In addition, the attribute tables are .dbf files found within each folder. These have also been provided as .xlsx (Excel) files which include the fault coordinate information, and slip rates and extension rates along the major faults. References McNeill, L.C., Shillington, D.J., Carter, G.D.O., and the Expedition 381 Participants, 2019a. Corinth Active Rift Development. Proceedings of the International Ocean Discovery Program, 381: College Station, TX (International Ocean Discovery Program). McNeill, L.C., Shillington, D.J., et al., 2019b, High-resolution record reveals climate-driven environmental and sedimentary changes in an active rift, Scientific Reports, 9, 3116. Nixon, C.W., McNeill, L.C., Bull, J.M., Bell, R.E., Gawthorpe, R.L., Henstock, T.J., Christodoulou, D., Ford, M., Taylor, B., Sakellariou, S. et al., 2016. Rapid spatiotemporal variations in rift structure during development of the Corinth Rift, central Greece. Tectonics, 35, 1225–1248. Taylor, B., J. R. Weiss, A. M. Goodliffe, M. Sachpazi, M. Laigle, and A. Hirn (2011), The structures, stratigraphy and evolution of the Gulf of Corinth Rift, Greece, Geophys. J. Int., 185(3), 1189–1219.

Here is an image of the global municipal tax (founcier bati + habitation). Average tax per asset Nancy 2014

To do it again you will need: — QGIS software (Free: https://www.qgis.org/fr/site/forusers/download.html), — a qgs file of your department (http://www.actualitix.com/shapefiles-des-departements-de-france.html) — an export of tax rates (https://www.data.gouv.fr/fr/datasets/impots-locaux/ > Municipal and intercommunal data > Your Department > Local Direct Tax Data 2014 (XLS format)) — data (most days of INSEE here 2012 http://www.insee.fr/fr/themes/detail.asp?reg_id=99&ref_id=base-cc-emploi-pop-active-2012)

Operating Mode: — process your data in your favorite spreadsheet (Excel or OpenOffice Calc) by integrating impot data, and INSEE to pull out the numbers that seem revealing to you — Install QGIS — Open the.qgs of your department

Add columns — Right click property on the main layer — Go to the field menu (on the left) — Add (via pencil) the desired columns (here average housing tax per asset, average property tax per asset, and the sum of both) — These are reals of precision 2, and length 6 — Register

Insert data: — Right-click on the “Open attribute table” layer — Select all — Copy — Paste in excel (or openOffice calcs) — Put the ad hoc formulas in excel (SOMME.SI.ENS to recover the rate) — Save the desired tab in CSV DOS with the new values — In QGIS > Menu > Layer > Add a delimited layer of text — Import the CSV

Present the data: — To simplify I advise you to make a layer by rate, and layers sums. So rots you in three clicks out the image of the desired rate — For each layer (or rate) — Right click properties on the csv layer — Labels to add city name and desired rate — Style for fct coloring of a csv field

Print the data in pdf: — To print, you need to define a print template — In the menu choose new printing dialer — choose the format (a department in A0 is rather readable) — Add vas legend, scale, and other — Print and here...

NB: this method creates aberrations: — in the case where the INSEE does not have a number or numbers that have moved a lot since — it is assumed that only assets pay taxes (which is more fair, but not 100 %)

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.

Introduction

We are enclosing the database used in our research titled "Concentration and Geospatial Modelling of Health Development Offices' Accessibility for the Total and Elderly Populations in Hungary", along with our statistical calculations. For the sake of reproducibility, further information can be found in the file Short_Description_of_Data_Analysis.pdf and Statistical_formulas.pdf

The sharing of data is part of our aim to strengthen the base of our scientific research. As of March 7, 2024, the detailed submission and analysis of our research findings to a scientific journal has not yet been completed.

The dataset was expanded on 23rd September 2024 to include SPSS statistical analysis data, a heatmap, and buffer zone analysis around the Health Development Offices (HDOs) created in QGIS software.

Short Description of Data Analysis and Attached Files (datasets):

Our research utilised data from 2022, serving as the basis for statistical standardisation. The 2022 Hungarian census provided an objective basis for our analysis, with age group data available at the county level from the Hungarian Central Statistical Office (KSH) website. The 2022 demographic data provided an accurate picture compared to the data available from the 2023 microcensus. The used calculation is based on our standardisation of the 2022 data. For xlsx files, we used MS Excel 2019 (version: 1808, build: 10406.20006) with the SOLVER add-in.

Hungarian Central Statistical Office served as the data source for population by age group, county, and regions: https://www.ksh.hu/stadat_files/nep/hu/nep0035.html, (accessed 04 Jan. 2024.) with data recorded in MS Excel in the Data_of_demography.xlsx file.

In 2022, 108 Health Development Offices (HDOs) were operational, and it's noteworthy that no developments have occurred in this area since 2022. The availability of these offices and the demographic data from the Central Statistical Office in Hungary are considered public interest data, freely usable for research purposes without requiring permission.

The contact details for the Health Development Offices were sourced from the following page (Hungarian National Population Centre (NNK)): https://www.nnk.gov.hu/index.php/efi (n=107). The Semmelweis University Health Development Centre was not listed by NNK, hence it was separately recorded as the 108th HDO. More information about the office can be found here: https://semmelweis.hu/egeszsegfejlesztes/en/ (n=1). (accessed 05 Dec. 2023.)

Geocoordinates were determined using Google Maps (N=108): https://www.google.com/maps. (accessed 02 Jan. 2024.) Recording of geocoordinates (latitude and longitude according to WGS 84 standard), address data (postal code, town name, street, and house number), and the name of each HDO was carried out in the: Geo_coordinates_and_names_of_Hungarian_Health_Development_Offices.csv file.

The foundational software for geospatial modelling and display (QGIS 3.34), an open-source software, can be downloaded from:

https://qgis.org/en/site/forusers/download.html. (accessed 04 Jan. 2024.)

The HDOs_GeoCoordinates.gpkg QGIS project file contains Hungary's administrative map and the recorded addresses of the HDOs from the

Geo_coordinates_and_names_of_Hungarian_Health_Development_Offices.csv file,

imported via .csv file.

The OpenStreetMap tileset is directly accessible from www.openstreetmap.org in QGIS. (accessed 04 Jan. 2024.)

The Hungarian county administrative boundaries were downloaded from the following website: https://data2.openstreetmap.hu/hatarok/index.php?admin=6 (accessed 04 Jan. 2024.)

HDO_Buffers.gpkg is a QGIS project file that includes the administrative map of Hungary, the county boundaries, as well as the HDO offices and their corresponding buffer zones with a radius of 7.5 km.

Heatmap.gpkg is a QGIS project file that includes the administrative map of Hungary, the county boundaries, as well as the HDO offices and their corresponding heatmap (Kernel Density Estimation).

A brief description of the statistical formulas applied is included in the Statistical_formulas.pdf.

Recording of our base data for statistical concentration and diversification measurement was done using MS Excel 2019 (version: 1808, build: 10406.20006) in .xlsx format.

• Aggregated number of HDOs by county: Number_of_HDOs.xlsx
• Standardised data (Number of HDOs per 100,000 residents): Standardized_data.xlsx
• Calculation of the Lorenz curve: Lorenz_curve.xlsx
• Calculation of the Gini index: Gini_Index.xlsx
• Calculation of the LQ index: LQ_Index.xlsx
• Calculation of the Herfindahl-Hirschman Index: Herfindahl_Hirschman_Index.xlsx
• Calculation of the Entropy index: Entropy_Index.xlsx
• Regression and correlation analysis calculation: Regression_correlation.xlsx

Using the SPSS 29.0.1.0 program, we performed the following statistical calculations with the databases Data_HDOs_population_without_outliers.sav and Data_HDOs_population.sav:

• Regression curve estimation with elderly population and number of HDOs, excluding outlier values (Types of analyzed equations: Linear, Logarithmic, Inverse, Quadratic, Cubic, Compound, Power, S, Growth, Exponential, Logistic, with summary and ANOVA analysis table): Curve_estimation_elderly_without_outlier.spv
• Pearson correlation table between the total population, elderly population, and number of HDOs per county, excluding outlier values such as Budapest and Pest County: Pearson_Correlation_populations_HDOs_number_without_outliers.spv.
• Dot diagram including total population and number of HDOs per county, excluding outlier values such as Budapest and Pest Counties: Dot_HDO_total_population_without_outliers.spv.
• Dot diagram including elderly (64<) population and number of HDOs per county, excluding outlier values such as Budapest and Pest Counties: Dot_HDO_elderly_population_without_outliers.spv
• Regression curve estimation with total population and number of HDOs, excluding outlier values (Types of analyzed equations: Linear, Logarithmic, Inverse, Quadratic, Cubic, Compound, Power, S, Growth, Exponential, Logistic, with summary and ANOVA analysis table): Curve_estimation_without_outlier.spv
• Dot diagram including elderly (64<) population and number of HDOs per county: Dot_HDO_elderly_population.spv
• Dot diagram including total population and number of HDOs per county: Dot_HDO_total_population.spv
• Pearson correlation table between the total population, elderly population, and number of HDOs per county: Pearson_Correlation_populations_HDOs_number.spv
• Regression curve estimation with total population and number of HDOs, (Types of analyzed equations: Linear, Logarithmic, Inverse, Quadratic, Cubic, Compound, Power, S, Growth, Exponential, Logistic, with summary and ANOVA analysis table): Curve_estimation_total_population.spv

For easier readability, the files have been provided in both SPV and PDF formats.

The translation of these supplementary files into English was completed on 23rd Sept. 2024.

If you have any further questions regarding the dataset, please contact the corresponding author: domjan.peter@phd.semmelweis.hu

The Residential Schools Locations Dataset in Geodatabase format (IRS_Locations.gbd) contains a feature layer "IRS_Locations" that contains the locations (latitude and longitude) of Residential Schools and student hostels operated by the federal government in Canada. All the residential schools and hostels that are listed in the Residential Schools Settlement Agreement are included in this dataset, as well as several Industrial schools and residential schools that were not part of the IRRSA. This version of the dataset doesn’t include the five schools under the Newfoundland and Labrador Residential Schools Settlement Agreement. The original school location data was created by the Truth and Reconciliation Commission, and was provided to the researcher (Rosa Orlandini) by the National Centre for Truth and Reconciliation in April 2017. The dataset was created by Rosa Orlandini, and builds upon and enhances the previous work of the Truth and Reconcilation Commission, Morgan Hite (creator of the Atlas of Indian Residential Schools in Canada that was produced for the Tk'emlups First Nation and Justice for Day Scholar's Initiative, and Stephanie Pyne (project lead for the Residential Schools Interactive Map). Each individual school location in this dataset is attributed either to RSIM, Morgan Hite, NCTR or Rosa Orlandini. Many schools/hostels had several locations throughout the history of the institution. If the school/hostel moved from its’ original location to another property, then the school is considered to have two unique locations in this dataset,the original location and the new location. For example, Lejac Indian Residential School had two locations while it was operating, Stuart Lake and Fraser Lake. If a new school building was constructed on the same property as the original school building, it isn't considered to be a new location, as is the case of Girouard Indian Residential School.When the precise location is known, the coordinates of the main building are provided, and when the precise location of the building isn’t known, an approximate location is provided. For each residential school institution location, the following information is provided: official names, alternative name, dates of operation, religious affiliation, latitude and longitude coordinates, community location, Indigenous community name, contributor (of the location coordinates), school/institution photo (when available), location point precision, type of school (hostel or residential school) and list of references used to determine the location of the main buildings or sites. Access Instructions: there are 47 files in this data package. Please download the entire data package by selecting all the 47 files and click on download. Two files will be downloaded, IRS_Locations.gbd.zip and IRS_LocFields.csv. Uncompress the IRS_Locations.gbd.zip. Use QGIS, ArcGIS Pro, and ArcMap to open the feature layer IRS_Locations that is contained within the IRS_Locations.gbd data package. The feature layer is in WGS 1984 coordinate system. There is also detailed file level metadata included in this feature layer file. The IRS_locations.csv provides the full description of the fields and codes used in this dataset.

The repository contains a dataset derived from the characterization of lignocellulosic residues from agricultural activities in the state of Zacatecas, Mexico, with a focus on their potential valorization for activated carbon production. The information is organized in folders and files in Excel and QGIS-compatible formats, enabling both statistical analysis and spatial representation. The repository structure includes: QGIS Data folder: vector and raster files in QGIS-compatible formats, representing land use distribution, municipal and hydrological boundaries, and thematic maps of vegetation cover and crop areas. Coordinates by Municipality folder: an Excel file containing the geographic coordinates of municipalities where agricultural residues were collected and characterized. Quantitative Analysis folder: Excel files with data on harvested area, production volume, yields, and estimated residue generation by crop. Physicochemical characterization files: tables with experimental results on cellulose, hemicellulose, lignin, ash, and nutrient content (nitrates and phosphates) obtained under standardized methodologies. Valorization tables: consolidated information on the conversion potential of residues to activated carbon (kg AC/ton of residue), residue types, and possible applications.

Here is an image of the overall municipal tax rate (foncier bati + habitation, for municipalities and inter-municipalities). http://physaphae.noip.me/Img/2015_Rate_54" alt="Local tax rate 54 of 2015" title="Local tax rate 54 of 2015">

Given that it is at the departmental mesh, it is not useful to include the departmental rate, and national... That would not be part of the comparison.

To do it again yourself you will need: - QQGIS software (Free: https://www.qgis.org/en/site/forusers/download.html), - a qgs file of your department (http://www.actualitix.com/shapefiles-des-departements-de-france.html) - an export of tax rates (https://www.data.gouv.fr/en/datasets/local taxes/)

Procedure: Install QGIS Open your department's .qgs

Add columns - Right click property on the main layer - Go to the fields menu (on the left) - Add (via the pencil) the desired columns (here municipal tax rate, intercommunal built land and housing) - These are reals of a precision 2, and a length 4 - Register

Insert data: - Right click on the layer "Open attribute table" - Select all - Copy - Paste into excel (or openOffice calcs) - Put the ad hoc formulas in excel (SUM.SI.ENS to recover the rate) - Save the desired tab in CSV DOS with the new values - In QGIS > Menu > Layer > Add a delimited text layer - Import the CSV

Present the data: - To simplify I advise you to make one layer per rate, and layers are. Thus rots you in three clicks take out the image of the desired rate - For each layer (or rate) - Right click properties on the csv layer - Labels to add the name of the city and the desired rate - Style for coloring in fct of a csv field

Print the data in pdf: - To print, you need to define a print template - In the menu choose new print dialler - choose the format (a department in A0 is rather readable) - Add vas legend, ladder, and other - Print and voila...

🛰️ Geolocated Equipment Losses Dataset (WarSpotting API)

This dataset contains structured and geolocated records of military equipment losses collected via the WarSpotting.net API. Each entry includes details such as equipment type, model, status, nearest location, coordinates (where available), visual documentation, and source attribution.

It is ideal for spatial analysis, geospatial clustering (e.g., with H3), temporal trends, and visualization projects focused on equipment loss patterns over time.

🧾 Source & Collection Method

The dataset was generated using a custom Python script that systematically queried the WarSpotting public API from February 24, 2022 to June 8, 2025, collecting and flattening JSON data into an Excel file. The script handled pagination, cleaned the source data, and formatted each record for tabular use.

# Example API endpoint called per day:
https://ukr.warspotting.net/api/losses/russia/YYYY-MM-DD

Records were collected with a short delay between days to avoid overloading the server.

📄 Columns Included

🗃 Format

The dataset is provided in Excel (.xlsx) format and is ready for direct use in data science workflows including:

• Jupyter Notebooks
• Pandas / Python scripts
• Excel pivoting and sorting
• Geospatial tools (QGIS, Kepler.gl, Looker Studio, etc.)

🔧 Reproducibility

The dataset was created using the following Python packages:

pip install requests openpyxl

The full script used to collect the data is available on GitHub.

This collection consists of geospatial data layers and summary data at the country and country sub-division levels that are part of USAID's Demographic Health Survey Spatial Data Repository. This collection includes geographically-linked health and demographic data from the DHS Program and the U.S. Census Bureau for mapping in a geographic information system (GIS). The data includes indicators related to: fertility, family planning, maternal and child health, gender, HIV/AIDS, literacy, malaria, nutrition, and sanitation. Each set of files is associated with a specific health survey for a given year for over 90 different countries that were part of the following surveys:Demographic Health Survey (DHS)Malaria Indicator Survey (MIS)Service Provisions Assessment (SPA)Other qualitative surveys (OTH)Individual files are named with identifiers that indicate: country, survey year, survey, and in some cases the name of a variable or indicator. A list of the two-letter country codes is included in a CSV file.Datasets are subdivided into the following folders:Survey boundaries: polygon shapefiles of administrative subdivision boundaries for countries used in specific surveys. Indicator data: polygon shapefiles and geodatabases of countries and subdivisions with 25 of the most common health indicators collected in the DHS. Estimates generated from survey data.Modeled surfaces: geospatial raster files that represent gridded population and health indicators generated from survey data, for several countries.Geospatial covariates: CSV files that link survey cluster locations to ancillary data (known as covariates) that contain data on topics including population, climate, and environmental factors.Population estimates: spreadsheets and polygon shapefiles for countries and subdivisions with 5-year age/sex group population estimates and projections for 2000-2020 from the US Census Bureau, for designated countries in the PEPFAR program.Workshop materials: a tutorial with sample data for learning how to map health data using DHS SDR datasets with QGIS. Documentation that is specific to each dataset is included in the subfolders, and a methodological summary for all of the datasets is included in the root folder as an HTML file. File-level metadata is available for most files. Countries for which data included in the repository include: Afghanistan, Albania, Angola, Armenia, Azerbaijan, Bangladesh, Benin, Bolivia, Botswana, Brazil, Burkina Faso, Burundi, Cape Verde, Cambodia, Cameroon, Central African Republic, Chad, Colombia, Comoros, Congo, Congo (Democratic Republic of the), Cote d'Ivoire, Dominican Republic, Ecuador, Egypt, El Salvador, Equatorial Guinea, Eritrea, Eswatini (Swaziland), Ethiopia, Gabon, Gambia, Ghana, Guatemala, Guinea, Guyana, Haiti, Honduras, India, Indonesia, Jordan, Kazakhstan, Kenya, Kyrgyzstan, Lesotho, Liberia, Madagascar, Malawi, Maldives, Mali, Mauritania, Mexico, Moldova, Morocco, Mozambique, Myanmar, Namibia, Nepal, Nicaragua, Niger, Nigeria, Pakistan, Papua New Guinea, Paraguay, Peru, Philippines, Russia, Rwanda, Samoa, Sao Tome and Principe, Senegal, Sierra Leone, South Africa, Sri Lanka, Sudan, Tajikistan, Tanzania, Thailand, Timor-Leste, Togo, Trinidad and Tobago, Tunisia, Turkey, Turkmenistan, Uganda, Ukraine, Uzbekistan, Viet Nam, Yemen, Zambia, Zimbabwe

This is a full-day training, developed by UNEP CMB, to introduce participants to the basics of GIS, how to import points from Excel to a GIS, and how to make maps with QGIS, MapX and Tableau. It prioritizes the use of free and open software.

Sidewalks in Chicago. To view or use these shapefiles, compression software, such as 7-Zip, and special GIS software, such as ESRI ArcGIS or QGIS, are required. To download this file, right-click the "Download" link above and choose "Save link as." Once unzipped, the .dbf file may be opened in any spreadsheet program, such as Microsoft Excel, and identifies the address associated with each sidewalk polygon where possible. Note this is a draft file and may be updated periodically.

Ecco un'immagine dell'aliquota fiscale comunale complessiva (foncier bati + abitazione, per comuni e intercomuni). http://physaphae.noip.me/Img/2015_Rate_54" alt="Tasso d'imposta locale 54 del 2015" title="Tasso d'imposta locale 54 del 2015">

Dato che è alla maglia dipartimentale, non è utile includere la tariffa dipartimentale e la tariffa nazionale. Questo non farebbe parte del paragone.

Per farlo di nuovo da soli avrete bisogno di: - Software QQGIS (gratuito: https://www.qgis.org/it/site/forusers/download.html), - un file qgs del vostro dipartimento (http://www.actualitix.com/shapefiles-des-departements-de-france.html) - un'esportazione di aliquote d'imposta (https://www.data.gouv.fr/en/datasets/local taxes/)

Procedura: Installare QGIS Apri il .qgs del tuo dipartimento

Aggiungi colonne - Proprietà con il tasto destro del mouse sul livello principale - Vai al menu dei campi (a sinistra) - Aggiungere (tramite la matita) le colonne desiderate (qui aliquota fiscale comunale, terreni edificati intercomunitari e abitazioni) - Questi sono reali di una precisione 2, e una lunghezza 4 - Registrazione

Inserire i dati: - Fare clic con il pulsante destro del mouse sul livello "Apri tabella degli attributi" - Seleziona tutto - Copia - Incollare in excel (o openOffice calcs) - Mettere le formule ad hoc in excel (SUM.SI.ENS per recuperare il tasso) - Salvare la scheda desiderata in CSV DOS con i nuovi valori - In QGIS > Menu > Livello > Aggiungi un livello di testo delimitato - Importare il CSV

Presentare i dati: - Per semplificare vi consiglio di fare un livello per tasso, e i livelli sono. Così si marcisce in tre clic tirare fuori l'immagine della velocità desiderata - Per ogni strato (o tasso) - Proprietà del clic destro sul livello csv - Etichette per aggiungere il nome della città e la tariffa desiderata - Stile per la colorazione in fct di un campo csv

Stampa i dati in pdf: - Per stampare, è necessario definire un modello di stampa - Nel menu scegliere il nuovo dialler di stampa - scegliere il formato (un dipartimento in A0 è piuttosto leggibile) - Aggiungi vas legend, ladder e altro - Stampa e voilà...

This repository contains the final outputs from the global Foodscape mapping exercise. In this project we aimed to identify broad homologues of foodscape classes, comparable in a minimum set of biophysical and management characteristics, would help to design possible interventions and leverage points for more sustainable agriculture.

Provided are maps in spatial geotiff format (.tif) which can be opened in any typical GIS software such as ArcGIC or QGIS. The Resolution is 0.5' degree (WGS 84 or longitude-latitude projection). Both the foodscape map (Foodscapes_combinedGEOTIFF_final.tif) and a reclassified intensity map (Foodscapes_combinedGEOTIFF_intensity.tif) are provided. Accompanied with the tif files are .clr and .qml files, both of which provide layout information on colours used for each code combination in the global maps. The .qml file will be automatically loaded when opening the layer in QGIS. In addition, in the Microsoft Excel sheet "Foodscapes_combinedLEGEND_final.xlsx" a legend with qualitative description and label of each class is provided.

If you use this layer in any way, please cite this repository and the describing preprint.

Survey results are available in two seperate formats. The .csv output contains all non-spatial data from the main survey form, and can be loaded in spreadsheet programs such as Microsoft Excel. The spatial content of the survey is available as a zipped collection of one or more shapefiles. These files can be opened in GIS applications such as ArcGISor QGIS. Please note, only completed survey responses are exported. Those still in draft will be excluded.Output columns in both the CSV and shapefile formats are named based on the exportidspecified in the form field configuration. If you are looking to analyze spatial data from the shapefiles based on attributes collected in the main response form, you can join fields from the CSV file with spatial features by joining on the RESPONSE_ID field.

Related article: Bergroth, C., Järv, O., Tenkanen, H., Manninen, M., Toivonen, T., 2022. A 24-hour population distribution dataset based on mobile phone data from Helsinki Metropolitan Area, Finland. Scientific Data 9, 39.

In this dataset:

We present temporally dynamic population distribution data from the Helsinki Metropolitan Area, Finland, at the level of 250 m by 250 m statistical grid cells. Three hourly population distribution datasets are provided for regular workdays (Mon – Thu), Saturdays and Sundays. The data are based on aggregated mobile phone data collected by the biggest mobile network operator in Finland. Mobile phone data are assigned to statistical grid cells using an advanced dasymetric interpolation method based on ancillary data about land cover, buildings and a time use survey. The data were validated by comparing population register data from Statistics Finland for night-time hours and a daytime workplace registry. The resulting 24-hour population data can be used to reveal the temporal dynamics of the city and examine population variations relevant to for instance spatial accessibility analyses, crisis management and planning.

Please cite this dataset as:

Bergroth, C., Järv, O., Tenkanen, H., Manninen, M., Toivonen, T., 2022. A 24-hour population distribution dataset based on mobile phone data from Helsinki Metropolitan Area, Finland. Scientific Data 9, 39. https://doi.org/10.1038/s41597-021-01113-4

Organization of data

The dataset is packaged into a single Zipfile Helsinki_dynpop_matrix.zip which contains following files:

HMA_Dynamic_population_24H_workdays.csv represents the dynamic population for average workday in the study area.

HMA_Dynamic_population_24H_sat.csv represents the dynamic population for average saturday in the study area.

HMA_Dynamic_population_24H_sun.csv represents the dynamic population for average sunday in the study area.

target_zones_grid250m_EPSG3067.geojson represents the statistical grid in ETRS89/ETRS-TM35FIN projection that can be used to visualize the data on a map using e.g. QGIS.

Column names

YKR_ID : a unique identifier for each statistical grid cell (n=13,231). The identifier is compatible with the statistical YKR grid cell data by Statistics Finland and Finnish Environment Institute.

H0, H1 ... H23 : Each field represents the proportional distribution of the total population in the study area between grid cells during a one-hour period. In total, 24 fields are formatted as “Hx”, where x stands for the hour of the day (values ranging from 0-23). For example, H0 stands for the first hour of the day: 00:00 - 00:59. The sum of all cell values for each field equals to 100 (i.e. 100% of total population for each one-hour period)

In order to visualize the data on a map, the result tables can be joined with the target_zones_grid250m_EPSG3067.geojson data. The data can be joined by using the field YKR_ID as a common key between the datasets.

License Creative Commons Attribution 4.0 International.

Related datasets

Järv, Olle; Tenkanen, Henrikki & Toivonen, Tuuli. (2017). Multi-temporal function-based dasymetric interpolation tool for mobile phone data. Zenodo. https://doi.org/10.5281/zenodo.252612

Tenkanen, Henrikki, & Toivonen, Tuuli. (2019). Helsinki Region Travel Time Matrix [Data set]. Zenodo. http://doi.org/10.5281/zenodo.3247564

Zde je obrázek celkové obecní daně (stavební farma + bydlení). http://physaphae.noip.me/Img/TaxeMoy_Ncy_FoncHab_2014.jpeg%20%E2%80%9EPr%C5%AFm%C4%9Brn%C3%A1%20da%C5%88%20na%20aktivum%20Nancy%202014%E2%80%9C" alt="Průměrná daň na aktivum Nancy 2014">

Chcete-li to udělat znovu sami, budete potřebovat: QGIS software (Zdarma:https://www.qgis.org/en/site/forusers/download.html),

soubor qgs vašeho oddělení (http://www.actualitix.com/shapefiles-des-departements-de-france.html) export daňových sazeb (https://www.data.gouv.fr/en/datasets/local taxes/ > Municipal and inter-municipal data > Your Department > Local direct tax data 2014 (XLS format) ) - údaje (většina dnů INSEE zde 2012 http://www.insee.fr/en/themes/detail.asp?reg_id=99&ref_id=base-cc-emploi-pop-active-2012)

Postup: - zpracujte svá data ve vaší oblíbené tabulce (Excel nebo OpenOffice Calc) integrací dat daní a INSEE, abyste získali čísla, která se vám zdají odhalující Instalovat QGIS Otevřete .qgs svého oddělení

Přidat sloupce - Vlastnost pravým tlačítkem myši v hlavní vrstvě - Přejděte do menu polí (vlevo) - Přidejte (tužkou) požadované sloupce (zde průměrnou daň z bydlení na aktivum, průměrnou daň z nemovitosti na aktivum a součet obou) Toto jsou reálná čísla s přesností 2 a délkou 6. Registrovat Vložte údaje: - Klikněte pravým tlačítkem na vrstvu "Otevřít tabulku atributů" - Vybrat vše - Kopírovat - Vložit do excelu (nebo openOffice kalkulačky) - Vložte vzorce ad hoc do Excelu (SUM.SI.ENS pro obnovení rychlosti) - Uložení požadované záložky v CSV DOSu s novými hodnotami

• V QGIS > Menu > Vrstva > Přidání oddělené textové vrstvy Importovat CSV Uveďte údaje: Pro zjednodušení vám radím vytvořit jednu vrstvu na rychlost, a vrstvy jsou. Tak vám hnije ve třech kliknutích vyjmout obraz požadované rychlosti
• Pro každou vrstvu (nebo rychlost)
• Vlastnosti kliknutí pravým tlačítkem myši ve vrstvě csv
• Štítky pro přidání názvu města a požadované rychlosti
• Styl pro barvení ve fct csv pole Tisk dat v pdf:

• Chcete-li tisknout, musíte definovat šablonu tisku

• V nabídce zvolte nový vytáčeč tisku - vyberte formát (oddělení v A0 je poměrně čitelné) Přidat vas legendu, žebřík a další Tisk a voila...

Pozn.: Tato metoda vytváří úchylky:

• v případě, že INSEE nemá číslo nebo čísla, která se od té doby hodně posunula

• předpokládáme, že daně platí pouze aktiva (což je spravedlivé, ale ne 100%)

This dataset shows the results of mapping the connectivity of key values (natural heritage, indigenous heritage, social and historic and economic) of the Great Barrier Reef with its neighbouring regions (Torres Strait, Coral Sea and Great Sandy Strait). The purpose of this mapping process was to identify values that need joint management across multiple regions. It contains a spreadsheet containing the connection information obtained from expert elicitation, all maps derived from this information and all GIS files needed to recreate these maps. This dataset contains the connection strength for 59 attributes of the values between 7 regions (GBR Far Northern, GBR Cairns-Cooktown, GBR Whitsunday-Townsville, GBR Mackay-Capricorn, Torres Strait, Coral Sea and Great Sandy Strait) based on expert opinion. Each connection is assessed based on its strength, mechanism and confidence. Where a connection was known to not exist between two regions then this was also explicitly recorded. A video tutorial on this dataset and its maps is available from https://vimeo.com/335053846.

Methods:

The information for the connectivity maps was gathered from experts (~30) during a 3-day workshop in August 2017. Experts were provided with a template containing a map of Queensland and the neighbouring seas, with an overlay of the regions of interest to assess the connectivity. These were Torres Strait, GBR:Far North Queensland, GBR:Cairns to Cooktown, GBC: Townsville to Whitsundays, GBR: Mackay to Capricorn Bunkers and Great Sandy Strait (which includes Hervey bay). A range of reference maps showing locations of the values were provided, where this information could be obtained. As well as the map the template provided 7x7 table for filling in the connectivity strength and connection type between all combinations of these regions. The experts self-organised into groups to discuss and complete the template for each attribute to be mapped. Each expert was asked to estimate the strength of connection between each region as well as the connection mechanism and their confidence in the information. Due to the limited workshop time the experts were asked to focus on initially recording the connections between the GBR and its neighbouring regions and not to worry about the internal connections in the GBR, or long-distance connections along the Queensland coast. In the second half of the workshop the experts were asked to review the maps created and expand on the connections to include those internal to the GBR. After the workshop an initial set of maps were produced and reviewed by the project team and a range of issues were identified and resolved. Additional connectivity maps for some attributes were prepared after the workshop by the subject experts within the project team. The data gathered from these templates was translated into a spreadsheet, then processing into the graphic maps using QGIS to present the connectivity information. The following are the value attributes where their connectivity was mapped: Seagrass meadows: pan-regional species (e.g. Halophila spp. and Halodule spp.) Seagrass meadows: tropical/sub-tropical (Cymodocea serrulata, Syringodium isoetifolium) Seagrass meadows: tropical (Thalassia, Cymodocea, Thalassodendron, Enhalus, Rotundata) Seagrass meadows: Zostera muelleri Mangroves & saltmarsh Hard corals Crustose coralline algae Macroalgae Crown of thorns starfish larval flow Acropora larval flow Casuarina equisetifolia & Pandanus tectorius Argusia argentia Pisonia grandis: cay vegetation Inter-reef gardens (sponges + gorgonians) (Incomplete) Halimeda Upwellings Pelagic foraging seabirds Inshore and offshore foraging seabirds Migratory shorebirds Ornate rock lobster Yellowfin tuna Black marlin Spanish mackerel Tiger shark Grey nurse shark Humpback whales Dugongs Green turtles Hawksbill turtles Loggerhead turtles Flatback turtles Longfin & Shortfin Eels Red-spot king prawn Brown tiger prawn Eastern king prawns Great White Shark Sandfish (H. scabra) Black teatfish (H. whitmaei) Location of sea country Tangible cultural resources Location of place attachment Location of historic shipwrecks Location of places of social significance Location of commercial fishing activity Location of recreational use Location of tourism destinations Australian blacktip shark (C. tilstoni) Barramundi Common black tip shark (C. limbatus) Dogtooth tuna Grey mackerel Mud crab Coral trout (Plectropomus laevis) Coral trout (Plectropomus leopardus) Red throat emperor Reef manta Saucer scallop (Ylistrum balloti) Bull shark Grey reef shark

Limitations of the data:

The connectivity information in this dataset is only rough in nature, capturing the interconnections between 7 regions. The connectivity data is based on expert elicitation and so is limited by the knowledge of the experts that were available for the workshop. In most cases the experts had sufficient knowledge to create robust maps. There were however some cases where the knowledge of the participants was limited, or the available scientific knowledge on the topic was limited (particularly for the ‘inter-reefal gardens’ attribute) or the exact meaning of the value attribute was poorly understood or could not be agreed up on (particularly for the social and indigenous heritage maps). This information was noted with the maps. These connectivity maps should be considered as an initial assessment of the connections between each of the regions and should not be used as authoritative maps without consulting with additional sources of information. Each of the connectivity links between regions was recorded with a level of confidence, however these were self-reported, and each assessment was performed relatively quickly, with little time for reflection or review of all the available evidence. It is likely that in many cases the experts tended to have a bias to mark links with strong confidence. During subsequent revisions of some maps there were substantial corrections and adjustments even for connections with a strong confidence, indicating that there could be significant errors in the maps where the experts were not available for subsequent revisions. Each of the maps were reviewed by several project team members with broad general knowledge. Not all connection combinations were captured in this process due to the limited expert time available. A focus was made on capturing the connections between the GBR and its neighbouring regions. Where additional time was available the connections within 4 regions in the GBR was also captured. The connectivity maps only show connections between immediately neighbouring regions, not far connections such as between Torres Strait and Great Sandy Strait. In some cases the connection information for longer distances was recorded from the experts but not used in the mapping process. The coastline polygon and the region boundaries in the maps are not spatially accurate. They were simplified to make the maps more diagrammatic. This was done to reduce the chance of misinterpreting the connection arrows on the map as being spatially explicit.

Format:

This dataset is made up of a spreadsheet that contains all the connectivity information recorded from the expert elicitation and all the GIS files needed to recreate the generated maps.

original/GBR_NESP-TWQ-3-3-3_Seascape-connectivity_Master_v2018-09-05.xlsx: ‘Values connectivity’: This sheet contains the raw connectivity codes transcribed from the templates produced prepared by the subject experts. This is the master copy of the connection information. Subsequent sheets in the spreadsheet are derived using formulas from this table. 1-Vertical-data: This is a transformation of the ‘Values connectivity’ sheet so that each source and destination connection is represented as a single row. This also has the connection mechanism codes split into individual columns to allow easier processing in the map generation. This sheet pulls in the spatial information for the arrows on the maps (‘LinkGeom’ attribute) or crosses that represent no connections (‘NoLinkGeom’) using lookup tables from the ‘Arrow-Geom-LUT’ and ‘NoConnection-Geom-LUT’ sheets. 2.Point-extract: This contains all the ‘no connection’ points from the ‘Values connectivity’ dataset. This was saved as working/ GBR_NESP-TWQ-3-3-3_Seascape-connectivity_no-con-pt.csv and used by the QGIS maps to draw all the crosses on the maps. This table is created by copy and pasting (values only) the ‘1-Vertical-data’ sheet when the ‘NoLinkGeom’ attribute is used to filter out all line features, by unchecking blank rows in the ‘NoLinkGeom’ filter. 2.Line-extract: This contains all the ‘connections’ between regions from the ‘Values connectivity’ dataset. This was saved as working/GBR_NESP-TWQ-3-3-3_Seascape-connectivity_arrows.csv and used by the QGIS maps to draw all the arrows on the maps. This table is created by copy and pasting (values only) the ‘1-Vertical-data’ sheet when the ‘LinkGeom’ attribute is used to filter out all point features, by unchecking blank rows in the ‘LinkGeom’ filter. Map-Atlas-Settings: This contains the metadata for each of the maps generated by QGIS. This sheet was exported as working/GBR_NESP-TWQ-3-3-3_Seascape-connectivity_map-atlas-settings.csv and used by QGIS to drive its Atlas feature to generate one map per row of this table. The AttribID is used to enable and disable the appropriate connections on the map being generated. The WKT attribute (Well Known Text) determines the bounding box of the map to be generated and the other attributes are used to display text on the map. map-image-metadata: This table contains metadata descriptions for each of the value attribute maps. This metadata was exported as a CSV and saved into the final generated JPEG maps using the eAtlas Image Metadata Editor Application

Master Thesis: Environmental ManagementRegulations of Human Activities & Protection Levels in Marine Protected Areas of the United Kingdomby Elsa SimA detailed breakdown of the assessment of 391 MPAs across seven activities and results from this study can be found in this folder. The folder consists of: (1) a QGIS project containing shapefiles of MPAs with associated protection levels, human activities, and general attributes; (2) an Excel spreadsheet of the raw data to assess the 391 UK MPAs; and (3) an Excel spreadsheet of consolidated tables used for analysing the results.Instructions:Open a new GIS file and insert geopackages of MPAs and boundaries included in the download to see spatially explicit data of UK MPAs.