GEOGRAPHIC INFORMATION

Montana Food Establishments, 2013

Data Provider Montana State Library
Date 01/01/2011 - 07/19/2013
Content Type Offline Data
Abstract This layer was designed to contain records for establishments in Montana that serve or produce food. The primary sources of records were a spreadsheet provided by the Montana Department of Public Health and Human Services that listed all of the establishments in Montana that have licenses to serve or sell food, and lists of establishments engaged in local commerce provided by the Montana Alternative Energy Resources Organization (AERO). The data were available from May 2012 through December 2015 as an ArcGIS Online map published by the State Library.The coordinate locations of the records come from a variety of sources. The primary method for geo-locating the records was automatic geocoding of their addresses. Most of the establishments that have been identified as being engaged in local commerce have had their locations examined by hand and the locations have been adjusted to try to place them on the correct building identifiable on aerial photos. The layer has attribute fields that specify how the locations were established.Some of the establishments have a latitude and longitude coordinate of -1.0,1.0. These are establishments whose locations could not be determined.The layer is stored in the Web Mercator coordinate system to improve peformance with ArcGIS Online. Desktop GIS software typically cannot portray data in this coordinate system at the correct map scale. The data should be projected to a coordinate system appropriate for use in Montana before being used with desktop GIS software.
Purpose These data were produced to support a project to map all of the establishments in Montana that engage in local commerce, that sell or process locally-produced food, or that are food producers that sell their food to local processors, retail outlets, or customers. The data contain every establishment in Montana that has a license to sell food and all food producers the project participants knew of that were engaged in local commerce. The layer is intended to be used with a related table that cross-references between the establishments and the functions (Such as "beef producer", "grocery store", "restaurant") that the establishments provide. The ID_Num field is the link to the Functions table. The Functions table in the same geodatabase contains the ID_Num field and a Code field. The Code field refers to function or product names in the Function_Codes table in the geodatabase. There is one record for each function or product provided by each establishment, so one establishment may appear several times in the table, once for each function or product that it provides. The Function_Locations layer in the geodatabase is produced by linking the Functions table to the Establishment_Locations feature class table. To re-create the Function_Locations layer, the geodatabase tables must be moved to a database with full support for SQL queries and the following query must be run. This will create an table whose latitude and longitude fields may be used to create an event layer that may be exported as a GIS layer. SELECT Establishment_Locations.Establishment, Establishment_Locations.Address, Establishment_Locations.City, Establishment_Locations.ZIP, Functions.Code AS Function_Code, Function_Codes.Type_ AS Function_Name, Food_Status_Codes.Explanation AS Status, Functions.ID AS Function_ID, Establishment_Locations.ID_Num AS Establishment_ID, Establishment_Locations.County, Establishment_Locations.Latitude, Establishment_Locations.Longitude FROM Functions INNER JOIN Function_Codes ON Function_Codes.Code = Functions.Code INNER JOIN Establishment_Locations ON Functions.ID_Num = Establishment_Locations.ID_Num INNER JOIN Food_Status_Codes ON Establishment_Locations.Status = Food_Status_Code.StatusID WHERE (NOT (Establishment_Locations.Latitude IS NULL))
Supplemental Information
This layer is stored in the Web Mercator coordinate system to improve peformance with ArcGIS Online. Desktop GIS software typically cannot portray data in this coordinate system at the correct map scale. The data should be projected to a coordinate system appropriate for use in Montana before being used with desktop GIS software. The Montana State Library provides this product/service for informational purposes only. The Library did not produce it for, nor is it suitable for legal, engineering, or surveying purposes. Consumers of this information should review or consult the primary data and information sources to ascertain the viability of the information for their purposes. The Library provides these data in good faith but does not represent or warrant its accuracy, adequacy, or completeness. In no event shall the Library be liable for any incorrect results or analysis; any direct, indirect, special, or consequential damages to any party; or any lost profits arising out of or in connection with the use or the inability to use the data or the services provided. The Library makes these data and services available as a convenience to the public, and for no other purpose. The Library reserves the right to change or revise published data and/or services at any time.
Distributor Montana State Library
PO Box 201800
Helena, MT 59620-1800
Telephone: 406-444-5354
TDD/TTY: Montana Relay 711
Fax:
Email: geoinfo@mt.gov
Distribution liability The Montana State Library provides this product/service for informational purposes only. The Library did not produce it for, nor is it suitable for legal, engineering, or surveying purposes. Consumers of this information should review or consult the primary data and information sources to ascertain the viability of the information for their purposes. The Library provides these data in good faith but does not represent or warrant its accuracy, adequacy, or completeness. In no event shall the Library be liable for any incorrect results or analysis; any direct, indirect, special, or consequential damages to any party; or any lost profits arising out of or in connection with the use or the inability to use the data or the services provided. The Library makes these data and services available as a convenience to the public, and for no other purpose. The Library reserves the right to change or revise published data and/or services at any time.
View Metadata
View Metadata (XML)
Metadata date 11/17/2015