Metadata for Montana Food Establishments, 2013

- Identification Information
- Data Quality Information
- Spatial Data Organization Information
- Spatial Reference Information
- Entity and Attribute Information
- Distribution Information
- Metadata Reference Information
- FGDC XML Metadata

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