Metadata for Montana Food Establishments, 2013
Identification Information:
Citation:
Originator: Montana State Library
Publication date: 07/19/2013
Title: Montana Food Establishments, 2013
Publisher: Montana State Library

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 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))

Time period of content:
Beginning date: 01/01/2011
Ending date: 07/19/2013
Currentness reference: Ground Condition
Access constraints: None
Use constraints:
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.
Point of contact:
Montana State Library
PO Box 201800
Helena, MT 59620-1800


Telephone: 406-444-5354
TDD/TTY telephone: 406-444-4799
E-Mail: geoinfo@mt.gov


Back to Top

Data Quality Information:
Completeness report:
This layer contains all establishments that had a license to sell or process food from the Montana Department of Health and Human Services. It contains various establishments that grow food, but none of the sources is a comprehensive database and the layer contains a very small subset of all the farms and ranches in Montana which were known to the project participants.


Lineage:

Process step:
Between Sep 9 2011 and October 24 2011 I familiarized myself with the project and with the data NRCS and MSU had initially provided. During this time, we received a spreadsheet from DPHHS listing all of the establishments in Montana that have licenses to serve food.

On October 17 the project partners met and talked about ideas for how GIS could help them. We decided to do a pilot project to map the locations and functions of all the businesses in Lake, Missoula, Ravalli, Flathead, and Sanders counties.

Between November 11 and November 14 I combined all the establishments from the various tables and layers into a single table, tried to identify duplicate records, and added fields to the table to track which tables each record came from. On November 14 the partners met and created a list of function codes that could be assigned to each establishment and agreed that the records for the 5-county pilot project would be divided between the participants. I would send them each a pair of spreadsheets to record the functions of each business. I sent out the spreadsheets on November 18.

By November 28 I had all of the spreadsheets back and entered the data in the Functions table. Between then and December 1 I ran the establishment database through the Montana address matching service to create a spatial layer, worked on mapping locations of the un-matched records, especially in Lake County, and made the maps of the function locations for the 5 Valleys meeting in Arlee on December 2.

We received a litte bit more data at the Arlee meeting and I entered it into the database. The partners met on December 15 and decided I would create a web application for the partners to use to input functions for the establishment database and that this would be available around the state for knowledgeable people to update. The application was finished on January 12 and Login IDs and instructions for participants were sent out on about the 20th.

On January 19 I worked out a way to let an person work with Google Earth to specify locations for the establishments that failed their address-matching. An intern received instructions for this on February 1. I received 183 records from the intern between February 22 and 28, at which point she said she had completed her assigned 20 hours of work.

AERO sent me spreadsheets with between 150 and 200 establishments on March 5. On March 6, I compared the establishment names in the spreadsheets to the existing records in the database and made some corrections to the existing data where I thought the new data looked correct. For each new record in the new table, I assigned a new establishment ID. I set the status equal to 2 for all the records and one of the table columns to "Aero_20120305", except where all 6 columns were already full. The spreadsheet contained a list of function codes for each record, and I added these to the functions table.

AERO sent more spreadsheets on March 14 and April 2 and I added them to the database. Several records were updated via the web form between March 15 and April 5. On April 6 I ran all the new records through the ITSD geocoding service and added the results to the main SQL server table.

AERO decided to have a volunteer locate more establishments whose address matching had failed, with priority on records that had been identified as being engaged in local commerce and secondary priority on records from the JSU tables that did not have good locations. On April 9 I prepared two tables containing 260 priority and 283 secondary records and delivered them to AERO.

AERO worked out a method for loading this data into Google Fusion Tables and saving the address-matched locations as kml files. We had a lot of trouble getting Google Earth to actually save the latitude and longitude coordinates into the kml file instead of just the addresses, but I think I eventually got all the locations, finishing around April 30. The volunteer did NOT try to find any of the establishments on the air photo, she just worked to find better addresses for records that didn't get geocoded. Google geocoded a lot more addresses than the ESRI locators did.

In May 2012 AERO sent a few more data updates. On about June 6 time I loaded the database into an ArcGIS Server service and developed an on-line map of the database at arcgis.com to allow anyone to browse the database. The current location of this map is here or it may be found by going to http://www/arcgis.com/home and searching for "Montana food infrastructure".

In June AERO provided a few more database updates and had someone use the on-line forms to update certain things, such as all the Hutterite Colonies. They asked me to make sure we had good locations for all the colonies, and that all the colonies were in there. I spent quite a lot of time on this, using http://www.cedrontech.com/hutterite.aspx?idx=MT as a source.

In early July I made some database updates requested by AERO.

On September 18 I made database updates requested by AERO.
Back to Top

Spatial Data Organization Information:
Point and vector object information:
SDTS object type: Entity point
SDTS object count: 9663
Back to Top

Spatial Reference Information:
Horizontal coordinate system definition:
Map projection:
Map projection name: WGS 1984 Web Mercator Auxiliary Sphere
Map projection parameters:
WGS 1984 Web Mercator Auxiliary Sphere
Other projection's definition:
PROJCS["WGS_1984_Web_Mercator_Auxiliary_Sphere",GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Mercator_Auxiliary_Sphere"],PARAMETER["False_Easting",0.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",0.0],PARAMETER["Standard_Parallel_1",0.0],PARAMETER["Auxiliary_Sphere_Type",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",3857]]-20037700-3024110010000-10000010000-100000100000.0010.0010.001true1021003857
Planar distance units: meter
Geodetic model:
Horizontal datum name: D WGS 1984
Ellipsoid name: WGS 1984
Semi-major axis: 6378137.0
Denominator of flattening ratio: 298.257223563
Back to Top

Entity and Attribute Information:
Entity type label: Establishment_Locations
Entity type definition: Attributes of Establishment_Locations

Attribute label: OBJECTID
Attribute definition: Internal feature number

Attribute label: Shape
Attribute definition: Feature geometry

Attribute label: ID_Num
Attribute definition:
Establishment ID number. This field is used to link establishments to the table that lists the functions each establishment provides.

Attribute label: Establishment
Attribute definition: This is the name of the establishment.

Attribute label: Status
Attribute definition: Code for the local commerce status


Attribute
Value		 Definition of
Attribute Value
-1 No attempt has been made to determine the status of the establishment.
0 The data reviewer was unable to determine the status of the establishment.
1 The establishment does not buy local food or sell locally-produced food to local establishments or customers.
2 The establishment buys or sells locally-produced food.
3 The establishment possibly buys or sells locally-produced food.
4 The establishment is a type of business that was not to be examined in the study.

Attribute label: Address
Attribute definition: Street or mailing address

Attribute label: City
Attribute definition: City, part of the the mailing address

Attribute label: ZIP
Attribute definition: ZIP Code, part of the mailing address

Attribute label: County
Attribute definition: County that the establishment is in

Attribute label: Table1
Attribute definition:
Identifier of a source that provided information about the establishment.
This is the primary source of this record. Many establishments were available from several sources, and the additional sources are listed in the Table2 through Table6 fields.


Attribute
Value		 Definition of
Attribute Value
5 Valleys Summit Attendees of the 5 Valleys Summit meeting in Arlee on 12/2/2011.
AERO_MT Records provided by the Alternative Energy Resources Organization at the beginning of the project.
AERO Values that contain AERO refer to data that were provided at various times during the project by the Alternative Energy Resources Organization.
Abundant_MT Shapefile derived from the Abundant Montana member list and the Montana Cadastral database.
Cherry_Survey_Grocer Grocery stores from a survey of the Montana Cherry Growers
DPHHS_Food Montana Department of Public Health and Human Services list of licensed food establishments
DPHHS_Hotel Montana Department of Public Health and Human Services list of hotels with food serving licenses
DPHHS_Wholesale Montana Department of Public Health and Human Services list of licensed food wholesalers
FarmersMkt Shapefile of farmers markets, list assembled by AERO from Abundant Montana, Yummy MT, and Montana Department of Agriculture records. Locations were extracted from the Montana Cadastral database.
MSUAltFoodOutlet Alternate food outlet locations from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program.
MSUCharity Charitable organizations that distribute food, from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program.
MSUCommGarden Community gardens from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program.
MSUCommSupGard Community support gardens from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program.
MSUConvenienceStore Convenience stores from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program.
MSUFarmDirectWIC Farmers who sell directly to the Women, Infant, and Children Supplemental Nutrition Program, from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program.
MSUFarmersMkt Farmers markets from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program.
MSUGrocery Grocery stores from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program.
MSUPublicTrans Public transportation companies from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program.
MSUSchoolGarden School gardens from a shapefile provided by Montana State University. The data were created from a list of organizations by graduate students in the Sustainable Food and Bioenergy Systems program.
MT_CSA Community Supported Agriculture entities from Abundant Montana
MT_Canning_Processin Canning and processing plants provided by the Natural Resources Conservation Service
MT_Certified_Organic Certified organic producers from the Montana Organic Program
MT_Custom_Meat -
MT_Inspected_Meat -
MT_MPI_All_Meat Montana meat and poultry inspection bureau meat packing sites
MT_Meat_Depot -
MT_Poultry_Growers -
US_Inspected_Meat -
US_Organic_Producers National Organic Producers dataset from the U.S. Department of Agriculture.
Western_MT_Growers -
cedrontech.com This was a web site with a list of Montana Hutterite colonies.

Attribute label: Table2
Attribute definition:
Identifier of a source that provided information about the establishment

Attribute label: Table3
Attribute definition:
Identifier of a source that provided information about the establishment

Attribute label: Table4
Attribute definition:
Identifier of a source that provided information about the establishment

Attribute label: Table5
Attribute definition:
Identifier of a source that provided information about the establishment

Attribute label: Table6
Attribute definition:
Identifier of a source that provided information about the establishment

Attribute label: Edited_By
Attribute definition:
Code for the person who edited the record local commerce status or functions


Attribute
Value		 Definition of
Attribute Value
107 Gerry Daumiller
204 Nancy Matheson
301 Alison Harmon
302 Colin Waters
303 Kevin Moore
304 Karl Sutton
305 Mary Stein
306 Sandy Courtnage
310 Lyra Leigh-Nedbor
312 Alyssa Charney
313 Erin Janoso
314 Leah Grunzke

Attribute label: Edited_Date
Attribute definition: Date when the local commerce status or functions were edited

Attribute label: Loc_name
Attribute definition:
Name of the resource or person that the data location is from.

The value may be a combination of a person and a resource, or a date and a resource, or just a resource. Values that contain a month and day, such as "4-27 exact" were entered by Janet Hess-Herbert at AERO and contain information about which Google locater level was obtained. Janet also used Google address locations for records that have her name or Google and a match level in the field. Records that have a person's name, Cadastral, or NRIS in them were located by hand. These are mostly records for establishments which were known to participate in local commerce and for which good locations were not obtained from the MSU databases or from ESRI address-matching. If these values have question marks in them, they indicate that the person who entered them had a poor degree of confidence that they had identified the correct location.

If the value contains MSU, the location is from one of the Montana State University layers.

If the field is blank, no location is known for the record and its coordinate has been set to -1,1.

Records that were automatically located using the record street address and a geocoding service have the values listed in the enumerated domain.


Attribute
Value		 Definition of
Attribute Value
ESRIMTStreets The location is interpolated along a street segment in the ESRI street database whose address range matched the establishment address.
MTRoadsWAddrs The location is interpolated along a street segment in the Montana Transportation Framework database whose address range matched the establishment address.
MTStructures The location is the point location of a structure in the Montana Structures Framework whose address matched the establishment address.
MTZipCodes The location is on the centroid of the zip code indicated in the establishment address. No address in the locator databases matched the establishment address.

Attribute label: Score
Attribute definition:
0-100 quality of the address match with a locator. Records that only matched the ZIP code have a score of 100.

Attribute label: Match_type
Attribute definition: Unknown. The Match_type is always either blank, or "A".

Attribute label: Match_addr
Attribute definition:
Value from the locator address database that the locator used to place the location.

Attribute label: Table_ID
Attribute definition: ID number from the source table for the record

Attribute label: Owner
Attribute definition: Name of the establishment owner

Attribute label: Parent_ID_Num
Attribute definition:
Early in the project there was an effort to preserve the relationship between duplicate records. If the parent_id_num is not the same as the id_num, a duplicate record was deleted.

Attribute label: Latitude
Attribute definition: Latitude of the establishment location

Attribute label: Longitude
Attribute definition: Longitude of the establishment location

Attribute label: Loc_Class
Attribute definition: Classification of the method used to determine the location.


Attribute
Value		 Definition of
Attribute Value
Address The location is at a street address from the Montana Base Map Service Center ESRI geocoding service.
City Level The location is at a town centroid from the Google geocoding service.
Google The location is at a street address from the Google geocoding service.
Hand-Estimate The location was placed by hand, with the person who selected the location indicating lack of confidence that the correct location was known.
Hand-Placed The location was placed by hand and the person who selected the location was confident it was correct.
MSU The location came from an MSU spatial layer.
ZipCode The location is at a Zip Code centroid.
blank The location is unknown, with the coordinate set to -1,1.

Back to Top

Distribution Information:
Distributor:
Montana State Library
PO Box 201800
Helena, MT 59620-1800


Telephone: 406-444-5354
TDD/TTY telephone: 406-444-4799
E-Mail: geoinfo@mt.gov


Resource description: Offline Data


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.
Back to Top

Metadata Reference Information:
Metadata date: 11/17/2015
Metadata contact:
Gerry Daumiller
Montana State Library
PO Box 201800
Helena, MT 59620-1800


Telephone: 406-444-5354
TDD/TTY telephone: 406-444-4799
E-Mail: geoinfo@mt.gov


Back to Top