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 updatesTitle: NM Food Retailers, 2022 - Microsoft Excel VersionItem Type: Microsoft ExcelSummary: Food Retailers by type (mobile, restaurant, etc.), as a Microsoft Excel fileNotes: Prepared by: Link uploaded by EMcRae_NMCDCSource: NM Environment Dept. - sent directlyFeature Service: https://nmcdc.maps.arcgis.com/home/item.html?id=fdf6b9eeb01d4cd8bbc32d5b7da16f62UID: 7, 8, 38, 70Data Requested: Food trucks, Local cottage industry (commercial kitchens, etc), Food retailers, Grocery Stores - location, size, typeMethod of Acquisition: Contact made with NM Environment Dept. Date Acquired: May of 2022Priority rank as Identified in 2022 (scale of 1 being the highest priority, to 11 being the lowest priority): 9, 7, 11, 6Tags: PENDING_ Title New Mexico Food Retailers 2022 - NMFoodRetailers2022

Summary List of licensed food retailers with categories as of April 2022

Notes

Source New Mexico Environment Department

Prepared by EMcRae_NMCDC

Feature Service https://nmcdc.maps.arcgis.com/home/item.html?id=69d62107fa3d49a18acb87a8a584ca03

Alias Definition

Name Name

License License Number

Status Status

Street1 Street 1

Street2 Street 2

City City

State State

Zip Zip

Retail Food Establishment (Retail)

Mobile Mobile Food Establisment

MobType MobileType

MobSup Mobile Support Unit

ServArea Servicing Area (Commissary)

FullServ Full Service Restaurant

Restrnt Restaurant

Deli Deli

Seafood Seafood Market

Meat Meat Market

ConvStore Convenience Store

Daycare Day Care

SchFood School Food Program

Bar Bar

Coffee Coffee Shop

Catering Catering Operation

Concess Concession Stand/Snack Bar

Snack Institution

Bakery Bakery

Grocery Market (Grocery)

Other Other

Lat Latitude

Long Longitude

AccScore Accuracy Score

AccType Accuracy Type

Number Number

Street Street

UnitType Unit Type

UnitNum Unit Number

GCCity City

GCState State

GCCounty County

GCZip Zip

GCCountry Country

GCSource Source

Mapping of deicing material storage facilities in the Lake Champlain Basin was conducted during the late fall and winter of 2022-23. 126 towns were initially selected for mapping (some divisions within the GIS towns data are unincorporated “gores”). Using the list of towns, town clerk contact information was obtained from the Vermont Secretary of State’s website, which maintains a database of contact information for each town.Each town was contacted to request information about their deicing material storage locations and methods. Email and telephone scripts were developed to briefly introduce the project and ask questions about the address of any deicing material storage locations in the town, type of materials stored at each site, duration of time each site has been used, whether materials on site are covered, and the type of surface the materials are stored on, if any. Data were entered into a geospatial database application (Fulcrum). Information was gathered there and exported as ArcGIS file geodatabases and Comma Separated Values (CSV) files for use in Microsoft Excel. Data were collected for 118 towns out of the original 126 on the list (92%). Forty-three (43) towns reported that they are storing multiple materials types at their facilities. Four (4) towns have multiple sites where they store material (Dorset, Pawlet, Morristown, and Castleton). Of these, three (3) store multiple materials at one or both of their sites (Pawlet, Morristown, and Castleton). Where towns have multiple materials or locations, the record information from the overall town identifier is linked to the material stored using a unique ‘one-to-many’ identifier. Locations of deicing material facilities, as shown in the database, were based on the addresses or location descriptions provided by town staff members and was verified only using the most recent aerial imagery (typically later than 2018 for all towns). Locations have not been field verified, nor have site conditions and infrastructure or other information provided by town staff.Dataset instructions:The dataset for Deicing Material Storage Facilities contains two layers – the ‘parent’ records titled ‘salt_storage’ and the ‘child’ records titled ‘salt_storage_record’ with attributes for each salt storage site. This represents a ‘one-to-many’ data structure. To see the attributes for each salt storage site, the user needs to Relate the data. The relationship can be accomplished in GIS software. The Relate needs to be built on the following fields:‘salt_storage’: ‘fulcrum_id’‘salt_storage_record: ‘fulcrum_parent_id’This will create a one-to-many relationship between the geographic locations and the attributes for each salt storage site.

Mapping of deicing material storage facilities in the Lake Champlain Basin was conducted during the late fall and winter of 2022-23. 126 towns were initially selected for mapping (some divisions within the GIS towns data are unincorporated “gores”). Using the list of towns, town clerk contact information was obtained from the Vermont Secretary of State’s website, which maintains a database of contact information for each town.Each town was contacted to request information about their deicing material storage locations and methods. Email and telephone scripts were developed to briefly introduce the project and ask questions about the address of any deicing material storage locations in the town, type of materials stored at each site, duration of time each site has been used, whether materials on site are covered, and the type of surface the materials are stored on, if any. Data were entered into a geospatial database application (Fulcrum). Information was gathered there and exported as ArcGIS file geodatabases and Comma Separated Values (CSV) files for use in Microsoft Excel. Data were collected for 118 towns out of the original 126 on the list (92%). Forty-three (43) towns reported that they are storing multiple materials types at their facilities. Four (4) towns have multiple sites where they store material (Dorset, Pawlet, Morristown, and Castleton). Of these, three (3) store multiple materials at one or both of their sites (Pawlet, Morristown, and Castleton). Where towns have multiple materials or locations, the record information from the overall town identifier is linked to the material stored using a unique ‘one-to-many’ identifier. Locations of deicing material facilities, as shown in the database, were based on the addresses or _location descriptions provided by town staff members and was verified only using the most recent aerial imagery (typically later than 2018 for all towns). Locations have not been field verified, nor have site conditions and infrastructure or other information provided by town staff.Dataset instructions:The dataset for Deicing Material Storage Facilities contains two layers – the ‘parent’ records titled ‘salt_storage’ and the ‘child’ records titled ‘salt_storage_record’ with attributes for each salt storage site. This represents a ‘one-to-many’ data structure. To see the attributes for each salt storage site, the user needs to Relate the data. The relationship can be accomplished in GIS software. The Relate needs to be built on the following fields:‘salt_storage’: ‘fulcrum_id’‘salt_storage_record: ‘fulcrum_parent_id’This will create a one-to-many relationship between the geographic locations and the attributes for each salt storage site.

Mapping of deicing material storage facilities in the Lake Champlain Basin was conducted during the late fall and winter of 2022-23. 126 towns were initially selected for mapping (some divisions within the GIS towns data are unincorporated “gores”). Using the list of towns, town clerk contact information was obtained from the Vermont Secretary of State’s website, which maintains a database of contact information for each town.Each town was contacted to request information about their deicing material storage locations and methods. Email and telephone scripts were developed to briefly introduce the project and ask questions about the address of any deicing material storage locations in the town, type of materials stored at each site, duration of time each site has been used, whether materials on site are covered, and the type of surface the materials are stored on, if any. Data were entered into a geospatial database application (Fulcrum). Information was gathered there and exported as ArcGIS file geodatabases and Comma Separated Values (CSV) files for use in Microsoft Excel. Data were collected for 118 towns out of the original 126 on the list (92%). Forty-three (43) towns reported that they are storing multiple materials types at their facilities. Four (4) towns have multiple sites where they store material (Dorset, Pawlet, Morristown, and Castleton). Of these, three (3) store multiple materials at one or both of their sites (Pawlet, Morristown, and Castleton). Where towns have multiple materials or locations, the record information from the overall town identifier is linked to the material stored using a unique ‘one-to-many’ identifier. Locations of deicing material facilities, as shown in the database, were based on the addresses or location descriptions provided by town staff members and was verified only using the most recent aerial imagery (typically later than 2018 for all towns). Locations have not been field verified, nor have site conditions and infrastructure or other information provided by town staff.Dataset instructions:The dataset for Deicing Material Storage Facilities contains two layers – the ‘parent’ records titled ‘salt_storage’ and the ‘child’ records titled ‘salt_storage_record’ with attributes for each salt storage site. This represents a ‘one-to-many’ data structure. To see the attributes for each salt storage site, the user needs to Relate the data. The relationship can be accomplished in GIS software. The Relate needs to be built on the following fields:‘salt_storage’: ‘fulcrum_id’‘salt_storage_record: ‘fulcrum_parent_id’This will create a one-to-many relationship between the geographic locations and the attributes for each salt storage site.

Abstract

The dataset is a geodatabase focusing on the distribution of freshwater fish species in Northern Greece. The study area encompasses various lakes and rivers within the regions of Thrace, Eastern, Central, and Western Macedonia, and Epirus. It classifies fish species into three categories based on their conservation status according to the IUCN Red List: Critically Endangered, Endangered, and Vulnerable. The data analysis reveals that the study area is characterized by high fish diversity, particularly in certain ecosystems such as the Evros River, Strymonas River, Aliakmonas River, Axios River, Volvi Lake, Nestos River, and Prespa Lake. These ecosystems serve as important habitats for various fish species. Mapping of the dataset shows the geographic distribution of threatened fish species, indicating that Northern Greece is a hotspot for species facing extinction risks. Overall, the dataset provides valuable insights for researchers, policymakers, and conservationists in understanding the status of fish fauna in Northern Greece and developing strategies for the protection and preservation of these important ecosystems.

Methods

Data Collection: The dataset was collected through a combination of field surveys, literature reviews, and the compilation of existing data from various reliable sources. Here's an overview of how the dataset was collected and processed:

• Freshwater Fishes and Lampreys of Greece: An Annotated Checklist
• The Red Book of Endangered Animals of Greece
• The "Red List of Threatened Species"
• The study "Monitoring and Evaluation of the Conservation Status of Fish Fauna Species of Community Interest in Greece"
• The international online fish database FishBase

Data Digitization and Georeferencing: To create a comprehensive database, we digitized and georeferenced the collected data from various sources. This involved converting information from papers, reports, and surveys into digital formats and associating them with specific geographic coordinates. Georeferencing allowed us to map the distribution of fish species within the study area accurately.

Data Integration: The digitized and georeferenced data were then integrated into a unified geodatabase. The geodatabase is a central repository that contains both spatial and descriptive data, facilitating further analysis and interpretation of the dataset.

Data Analysis: We analyzed the collected data to assess the distribution of fish species in Northern Greece, evaluate their conservation status according to the IUCN Red List categories, and identify the threats they face in their respective ecosystems. The analysis involved spatial mapping to visualize the distribution patterns of threatened fish species.

Data Validation: To ensure the accuracy and reliability of the dataset, we cross-referenced the information from different sources and validated it against known facts about the species and their habitats. This process helped to eliminate any discrepancies or errors in the dataset.

Interpretation and Findings: Finally, we interpreted the analyzed data and derived key findings about the diversity and conservation status of freshwater fish species in Northern Greece. The results were presented in the research paper, along with maps and visualizations to communicate the spatial patterns effectively.

Overall, the dataset represents a comprehensive and well-processed collection of information about fish fauna in the study area. It combines both spatial and descriptive data, providing valuable insights for understanding the distribution and conservation needs of freshwater fish populations in Northern Greece.

Usage notes

The data included with the submission is stored in a geodatabase format, specifically an ESRI Geodatabase (.gdb). A geodatabase is a container that can hold various types of geospatial data, including feature classes, attribute tables, and raster datasets. It provides a structured and organized way to store and manage geographic information.

To open and work with the geodatabase, you will need GIS software that supports ESRI Geodatabase formats. The primary software for accessing and manipulating ESRI Geodatabases is ESRI ArcGIS, which is a proprietary GIS software suite. However, there are open-source alternatives available that can also work with Geodatabase files.

Open-source software such as QGIS has support for reading and interacting with Geodatabase files. By using QGIS, you can access the data stored in the geodatabase and perform various geospatial analyses and visualizations. QGIS is a powerful and widely used open-source Geographic Information System that provides similar functionality to ESRI ArcGIS.

For tabular data within the geodatabase, you can export the tables as CSV files and open them with software like Microsoft Excel or the open-source alternative, LibreOffice Calc, for further analysis and manipulation.

Overall, the data provided in the submission is in a geodatabase format, and you can use ESRI ArcGIS or open-source alternatives like QGIS to access and work with the geospatial data it contains.

This point layer contains monthly summaries of daily temperatures (means, minimums, and maximums) and precipitation levels (sum, lowest, and highest) for the period January 1981 through December 2010 for weather stations in the Global Historical Climate Network Daily (GHCND). Data in this service were obtained from web services hosted by the Applied Climate Information System ( ACIS). ACIS staff curate the values for the U.S., including correcting erroneous values, reconciling data from stations that have been moved over their history, etc. The data were compiled at Esri from publicly available sources hosted and administered by NOAA. Because the ACIS data is updated and corrected on an ongoing basis, the date of collection for this layer was Jan 23, 2019. The following process was used to produce this dataset:Download the most current list of stations from ftp.ncdc.noaa.gov/pub/data/ghcn/daily/ghcnd-stations.txt. Import this into Microsoft Excel and save as CSV. In ArcGIS, import the CSV as a geodatabase table and use the XY Event layer tool to locate each point. Using a detailed U.S. boundary extract the points that fall within the 50 U.S. States, the District of Columbia, and Puerto Rico. Using Python with DA.UpdateCursor and urllib2 access the ACIS Web Services API to determine whether each station had at least 50 monthly values of temperature data for each station. Delete the other stations. Using Python add the necessary field names and acquire all monthly values for the remaining stations. Thus, there are stations that have some missing data. Using Python Add fields and convert the standard values to metric values so both would be present. Thus, there are four sets of monthly data in this dataset: Monthly means, mins, and maxes of daily temperatures - degrees Fahrenheit. Monthly mean of monthly sums of precipitation and the level of precipitation that was the minimum and maximum during the period 1981 to 2010 - mm. Temperatures in 3a. in degrees Celcius. Precipitation levels in 3b in Inches. After initially publishing these data in a different service, it was learned that more precise coordinates for station locations were available from the Enhanced Master Station History Report (EMSHR) published by NOAA NCDC. With the publication of this layer these most precise coordinates are used. A large subset of the EMSHR metadata is available via EMSHR Stations Locations and Metadata 1738 to Present. If your study area includes areas outside of the U.S., use the World Historical Climate - Monthly Averages for GHCN-D Stations 1981 - 2010 layer. The data in this layer come from the same source archive, however, they are not curated by the ACIS staff and may contain errors. Revision History: Initially Published: 23 Jan 2019 Updated 16 Apr 2019 - We learned more precise coordinates for station locations were available from the Enhanced Master Station History Report (EMSHR) published by NOAA NCDC. With the publication of this layer the geometry and attributes for 3,222 of 9,636 stations now have more precise coordinates. The schema was updated to include the NCDC station identifier and elevation fields for feet and meters are also included. A large subset of the EMSHR data is available via EMSHR Stations Locations and Metadata 1738 to Present. Cite as: Esri, 2019: U.S. Historical Climate - Monthly Averages for GHCN-D Stations for 1981 - 2010. ArcGIS Online, Accessed