Spatial Data Catalog

Internal feature number.

Sequential unique whole numbers that are automatically generated.

Unique identifier for each record

1 to 133827 by 1

Unique identifier from ADDRESS_POINT database

1-7 digit value as text or '0000000' if unknown

Coded Value Domain lookup value

350 - Food facility

Name of restaurant or other food facility

Uppercase alpha

Abbreviated name for feature

Mixed text

Size (seating capacity) when appropriate

Bakery - Bakery

Bed and Breakfast - Bed and Breakfast

Catering Operation - Caterer

Non-Profit Institution - Charitable Organization

Mobile Food Service - Commissary for Mobile FSE

Grocery - Grocery

Limited Food Services - Limited Food Services

Meat/Sea Food - Meat and Seafood

Mobile FS - Mobile FS

School Kitchen - School Kitchen

Seating 0-12 - Seating capacity up to 12

Seating 13-50 - Seating capacity from 13 to 50

Seating 51-150 - Seating Capacity from 51 to 150

Seating 151-250 - Seating Capacity from 151 to 250

Seating > 250 - Seating > 250

Risk category of facility when appropriate

No risk info - No Risk Information

I - Low Risk - Cold holding - Limited food preparation. Requires one routine inspection per year.

II - Medium Risk - No Cook Step Food Preparation. One routine inspection per year and either 2nd inspection or education visit

III - High Risk - Same day service or complex food preparation. Requires 2 routine inspections per year and one education visit

Risk II&III - Combination Risk Category 1 and 3

Full street address of facility

Address number and uppercase street name; non-standard abbreviations

Area code and phone number of facility

NULL or form (###) ###-####

5 digit zipcode of facility

5 digits as string

City where facility is located

Mixed case full city name

Feature geometry.

Coordinates defining the features.

Record identifier if facility is a chain

Alpha numeric string

Facility name if a chain or housing a chain

Uppercase string; may be same as Chain Name or different

Name of chain if facility is a chain

Uppercase string; may be same as Facility Name or different

Whether facility is chain or not

Either NULL (not a chain) or Y (Yes)

Full street address of chain home location

Address number and uppercase name; non-standard abbreviations

Updated with current information from RESTAURANT_INSPECTIONS_POINT. Per standard script - AddNewCommonInterestFeatures.py

Data records where downloaded from http://info.kingcounty.gov/health/ehs/foodsafety/inspections/search.aspx Individual alpha record sets were appended and reformatted for delimiter conformance. Python scripts were used to assemble data tables, join information about restaurant chain, and create a spatial featureclass from tabular coordinate data. Data is loaded directly from the DPH database except in that the DESCRIPTION field which contains both Seating Capacity and Risk information is broken (parsed) into two separate fields: SEAT_CAP and RISK. Frequency analysis is used to create unique list of Program Identifier (facility name) with associated attributes that is passed to the Common Interest project area for uploading to tables to create new records in COMMON_INTEREST_POINT and a new FOOD_FACILITY featureclass. This process is performed three times a year - April, August and December - unless documented otherwise with a unique process step.

A frequency table is created from the RESTAURANT_INSPECTIONS_POINT database. This unique list is then joined with restaurant chain information and the composite table is then exported to a csv file in a schema compatible with COMMON_INTEREST_POINT. This list is loaded to COMMON_INTEREST_POINT and the associated COMMON_INTEREST_FF (business table attributes). Standard COMMON INTEREST routines are run to create the child featureclass, FOOD_FACILITIES_POINT.