Montana Food Infrastructure File List
Gerry Daumiller
Web Files SQL Tables
The master tables for the database are in the DigitalAtlas database in SQL server on mslhlnblade08. In anticipation of the eventual shutdown of blade08, I copied the tables to the Food_Establishment.gdb geodatabase on May 6, 2015. I did not make a separate copy of the Food_Establishments table -- all of the information from it is in the Establishment_Locations layer. Contract Folder Files

Data Fields

Food_Establishments

Functions – Functions that have been assigned to establishments Food_Function_Locations – This query gives the location and establishment information of all the records in the Functions table. It is included here because the way the query is written in the SQL Server database doesn't work for Microsoft Access. The following query does work in Access.
     SELECT Food_Establishments.Establishment, Food_Establishments.Address,
            Food_Establishments.City, Food_Establishments.ZIP, Functions.Code AS Function_Code,
            Function_Codes.Type_ AS Function_Name, Functions.ID AS Function_ID,
            Food_Establishments.Status AS Explanation,
            Food_Establishments.ID_Num AS Establishment_ID, Food_Establishments.County,
            Food_Establishments.Latitude, Food_Establishments.Longitude
     FROM ((Functions INNER JOIN Food_Establishments ON Functions.ID_Num = Food_Establishments.ID_Num)
            INNER JOIN Function_Codes ON Functions.Code = Function_Codes.Code)
            INNER JOIN Food_Status ON Food_Establishments.Status = Food_Status.StatusID
     WHERE ((Not (Food_Establishments.Latitude) Is Null))