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

Abstract:
This layer contains records for establishments in Montana whose function(s) (Such as "beef producer", "grocery store", "restaurant") in the food production and delivery process has been established. Where an establishement has multiple functions, there are multiple records for it in the layer. The data were created by cross-referencing the establishments in the Establishment_Locations layer with all of their functions in the Functions table.

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.

There is one record for each function or product provided by each establishment, so one establishment may appear several times in the layer, once for each function or product that it provides. The layer 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


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: Function_Locations
Entity type definition: Attributes of Function_Locations

Attribute label: OBJECTID
Attribute definition: Internal feature number

Attribute label: Shape
Attribute definition: Feature geometry

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

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: Function_Code
Attribute definition:
Code for an establishment function. The codes are heirarchical. The first two digits refer to a general class of products or functions, the second two digits refer to a sub-category, and the last two digits are more specific. Project editors were instructed to be specific as possible and to not enter both a general class and a more specific instance of that class for the same establishment, but they did not always follow these instructions.


Attribute
Value
Definition of
Attribute Value
100000 Producer (farm/ranch)
100100 Produce (vegetables, fruit)
100101 Vegetables
100102 Fruit
100103 Tree Fruit
100200 Dairy
100300 Eggs
100400 Poultry (chickens, turkeys, ducks)
100500 Livestock
100501 Cattle
100502 Hogs
100503 Sheep/Lambs
100504 Other (Bison, Goats, etc)
100700 Fish/aquaculture
100800 Nursery (bedding plants for transplanting)
101100 Cereal grains
101200 Oilseeds
101300 Pulses
101400 Apiary/Honey
200000 Feedlot
300000 Food Manufacturer
300100 Flour miller
300200 Oilseed processor
300300 Pulse processor
300400 Sugar processor
300500 Co-packer (custom processing of others' products)
300600 Produce processor (fruit and vegetables, preserves, salsa)
300700 Dairy processor (milk, butter, cheese, yogurt, ice cream)
300701 Grade A dairy products
300702 Grade B dairy products
300800 Poultry plant, exempt
300801 Poultry plant, State-inspected
300900 Meat processor
300901 Custom exempt
300902 State inspected
300903 Federally inspected
300904 Slaughter
300905 Packing/processing
300906 Red meat
301000 Confectionery/Syrup/Jam
301100 Bakery
301200 Beverages
301201 Beer/Wine
301202 Fruit juice
301203 Other Beverages
301300 Other (snacks, supplements, etc.)
400000 Wholesale Food Distributor
400100 Broker
400200 Transporters/Freight hauler
500000 Retail Food Distributor
500100 Farmers Market
500200 CSA
500300 Farm Stands/U-Pick
500400 Grocer
500401 Montana independent or chain
500402 National/regional supermarket chain
500500 Convenience Store
500600 Food Service
500601 Restaurant, hotel, Bed and Breakfast, guest ranch
500602 Institutional cafeteria/food service
500603 School K-12
500604 College/university
500605 Early childhood care/educ.
500606 Retirement/nursing home
500607 Hospital
500608 Prison/jail
500609 Caterer
500610 Bar
500700 Charitable Outlet (food pantry/bank)
600000 Non-Food
600100 Flowers

Attribute label: Function_Name
Attribute definition: Name of the function


Attribute
Value
Definition of
Attribute Value
Producer (farm/ranch) -
Produce (vegetables, fruit) -
Vegetables -
Fruit -
Tree Fruit -
Dairy -
Eggs -
Poultry (chickens, turkeys, ducks) -
Livestock -
Cattle -
Hogs -
Sheep/Lambs -
Other (Bison, Goats, etc) -
Fish/aquaculture -
Nursery (bedding plants for transplanting) -
Cereal grains -
Oilseeds -
Pulses -
Apiary/Honey -
Feedlot -
Food Manufacturer -
Flour miller -
Oilseed processor -
Pulse processor -
Sugar processor -
Co-packer (custom processing of others' products) -
Produce processor (fruit and vegetables, preserves, salsa) -
Dairy processor (milk, butter, cheese, yogurt, ice cream) -
Grade A dairy products -
Grade B dairy products -
Poultry plant, exempt -
Poultry plant, State-inspected -
Meat processor -
Custom exempt -
State inspected -
Federally inspected -
Slaughter -
Packing/processing -
Red meat -
Confectionery/Syrup/Jam -
Bakery -
Beverages -
Beer/Wine -
Fruit juice -
Other Beverages -
Other (snacks, supplements, etc.) -
Wholesale Food Distributor -
Broker -
Transporters/Freight hauler -
Retail Food Distributor -
Farmers Market -
CSA -
Farm Stands/U-Pick -
Grocer -
Montana independent or chain -
National/regional supermarket chain -
Convenience Store -
Food Service -
Restaurant, hotel, Bed and Breakfast, guest ranch -
Institutional cafeteria/food service -
School K-12 -
College/university -
Early childhood care/educ. -
Retirement/nursing home -
Hospital -
Prison/jail -
Caterer -
Bar -
Charitable Outlet (food pantry/bank) -
Non-Food -
Flowers -

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


Attribute
Value
Definition of
Attribute Value
Not examined yet -
Examined, status not known -
Does not buy local food or sell locally-produced food to local establishments -
Buys local food or sells food to local establishments -
Possibly buys local food or sells food to local establishments -
Known to be a type of business we are not working on -

Attribute label: Function_ID
Attribute definition: Establishment/Function ID number from the Functions table

Attribute label: Establishment_ID
Attribute definition: Establishment ID number

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

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

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

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