Restaurant Inspections - Public Health - Seattle and King County

Metadata also available as - [Outline]

Frequently anticipated questions:


What does this data set describe?

Title:
Restaurant Inspections - Public Health - Seattle and King County
Abstract:
Food establishments that sell or serve food to the public must get an annual permit and be inspected by Public Health-Seattle and King County. These establishments include restaurants, food and espresso carts, coffee places, delis, the fresh food sections in grocery stores, temporary events where food is sold, and more. There are nearly 10,000 permitted food service establishments in Seattle and King County. The majority of these establishments have two unannounced inspections per year. While many of these food service establishments will automatically receive one special educational session on food safety annually, any restaurant may request a special educational session. The data in this layer is built from records obtained from:<http://info.kingcounty.gov/health/ehs/foodsafety/inspections/search.aspx>
Supplemental_Information:
<http://www5.kingcounty.gov/sdc/addl_doc/restaurantinspectionsupplementalinformation.htm>
  1. How should this data set be cited?

    County, King, 20101129, Restaurant Inspections - Public Health - Seattle and King County: King County, King County, WA.

    Online Links:

    Other_Citation_Details:
    <http://info.kingcounty.gov/health/ehs/foodsafety/inspections/search.aspx>

  2. What geographic area does the data set cover?

    West_Bounding_Coordinate: -122.553292
    East_Bounding_Coordinate: -121.088063
    North_Bounding_Coordinate: 48.425761
    South_Bounding_Coordinate: 47.154372

  3. What does it look like?

    <http://www5.kingcounty.gov/sdc/DataImages/restaurant_inspections.jpg> (JPG)
    JPG File of layer overlain on base of WA counties or local cities

  4. Does the data set describe conditions during a particular time period?

    Calendar_Date: 01-Mar-2021
    Currentness_Reference: publication date

  5. What is the general form of this data set?

    Geospatial_Data_Presentation_Form: vector digital data

  6. How does the data set represent geographic features?

    1. How are geographic features stored in the data set?

      This is a Vector data set. It contains the following vector data types (SDTS terminology):

      • Entity point (0)

    2. What coordinate system is used to represent geographic features?

      The map projection used is NAD 1983 HARN StatePlane Washington North FIPS 4601 Feet.

      Projection parameters:
      Standard_Parallel: 47.5
      Standard_Parallel: 48.73333333333333
      Longitude_of_Central_Meridian: -120.8333333333333
      Latitude_of_Projection_Origin: 47.0
      False_Easting: 1640416.666666667
      False_Northing: 0.0

      Planar coordinates are encoded using coordinate pair
      Abscissae (x-coordinates) are specified to the nearest 0.0003280833333333334
      Ordinates (y-coordinates) are specified to the nearest 0.0003280833333333334
      Planar coordinates are specified in foot_us

      The horizontal datum used is D North American 1983 HARN.
      The ellipsoid used is GRS 1980.
      The semi-major axis of the ellipsoid used is 6378137.0.
      The flattening of the ellipsoid used is 1/298.257222101.

  7. How does the data set describe geographic features?

    maint.DPH.restaurant_inspections_point
    Point attribute table (Source: ESRI)

    OBJECTID
    Internal feature number. (Source: ESRI)

    Sequential unique whole numbers that are automatically generated.

    FEATURE_ID
    Unique identifier for each record (Source: King County)

    Range of values
    Minimum:1
    Maximum:133827
    Resolution:1

    NAME
    Name of restaurant or other food facility (Source: Public Health - King County and Seattle)

    Uppercase alpha

    PROGRAM_IDENTIFIER
    Name of facility as program identifier (Source: Public Health - King County and Seattle)

    Uppercase alpha

    SEAT_CAP
    Size (seating capacity) when appropriate (Source: Public Health - King County and Seattle)

    ValueDefinition
    BakeryBakery
    Bed and BreakfastBed and Breakfast
    CatererCaterer
    Charitable OrgCharitable Organization
    Commissary for Mobile FSECommissary for Mobile FSE
    GroceryGrocery
    Limited Food ServicesLimited Food Services
    Meat/Sea FoodMeat and Seafood
    Mobile FSMobile FS
    School KitchenSchool Kitchen
    Seating 0-12Seating capacity up to 12
    Seating 13-50Seating capacity from 13 to 50
    Seating 51-150Seating Capacity from 51 to 150
    Seating 151-250Seating Capacity from 151 to 250
    Seating > 250Seating > 250

    RISK
    Risk category of facility when appropriate (Source: Public Health - King County and Seattle)

    ValueDefinition
    No risk infoNo Risk Information
    Risk Category ILow Risk - Cold holding - Limited food preparation. Requires one routine inspection per year.
    Risk Category IIMedium Risk - No Cook Step Food Preparation. One routine inspection per year and either 2nd inspection or education visit
    Risk Category IIIHigh Risk - Same day service or complex food preparation. Requires 2 routine inspections per year and one education visit
    Risk IMiscoded Risk Category 1
    Risk II&IIICombination Risk Category 1 and 3

    ADDRESS
    Full street address of facility (Source: Public Health - King County and Seattle)

    Address number and uppercase street name; non-standard abbreviations

    PHONE
    Area code and phone number of facility (Source: Public Health - King County and Seattle)

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

    LONGITUDE
    Longitude location of facility (Source: Public Health - King County and Seattle)

    Range of values
    Minimum:-999.99999000
    Maximum:0.00000000

    LATITUDE
    Latitude location of facility (Source: Public Health - King County and Seattle)

    Range of values
    Minimum:0.00000000
    Maximum:47.92691900

    ZIPCODE
    5 digit zipcode of facility (Source: Public Health - King County and Seattle)

    5 digits as string

    CITY
    City where facility is located (Source: Public Health - King County and Seattle)

    Mixed case full city name

    DATE_INSPECTION
    Date of inspection (Source: Public Health - King County and Seattle)

    Date/time as string in form 1/2/2006 12:00:00 AM

    BUS_NAME_INSPECTION
    Inspection record business name (Source: Public Health - King County and Seattle)

    Uppercase string

    TYPE_INSPECTION
    Type of inspection (Source: Public Health - King County and Seattle)

    ValueDefinition
    Consultation/Education - FieldDiscuss risk reduction while verifying proper food handling, food source, food storage, and general cleanliness
    Return InspectionReturn Inspection
    Routine Inspection/Field ReviewRoutine Inspection/Field Review

    SCORE_INSPECTION
    Inspection score (Source: Public Health - King County and Seattle)

    Number as string

    RESULT_INSPECTION
    Inspection result (Source: Public Health - King County and Seattle)

    ValueDefinition
    Baseline DataBaseline Data
    Catalog informationCatalog information
    Comparison dataComparison data
    CompleteComplete
    ConfirmedConfirmed
    ExemptExempt
    FailedFailed
    In ComplianceIn Compliance
    IncompleteIncomplete
    Limited InformationLimited Information
    Needs AssessmentNeeds Assessment
    No Longer At LocationNo Longer At Location
    Not AccessibleNot Accessible
    Not ApplicableNot Applicable
    Not ConfirmedNot Confirmed
    Not PermittedNot Permitted
    Not Ready For InspectionNot Ready For Inspection
    Out of BusinessOut of Business
    PositivePositive
    SatisfactorySatisfactory
    UnsatisfactoryUnsatisfactory

    CLOSE_BUS_INSPECTION
    Was business closed as result of inspection (Source: Public Health - King County and Seattle)

    ValueDefinition
    NBusiness not closed
    YBusiness closed

    VIOLATIONTYPE
    Violation type (Source: Public Health - King County and Seattle)

    ValueDefinition
    (no value)no value
    BLUEPrimarily maintenance and sanitation issues that are not likely to be the cause of a food borne illness.
    REDThose food handling practices that, when not done properly, are most likely to lead to food borne illnesses.

    VIOLATIONDESCR
    Description of violation (Source: Public Health - King County and Seattle)

    String

    VIOLATIONPOINTS
    Violation points (Source: Public Health - King County and Seattle)

    Number as string

    Shape
    Feature geometry. (Source: ESRI)

    Coordinates defining the features.

    RECORD_ID
    Record identifier if facility is a chain (Source: Public Health - King County and Seattle)

    Alpha numeric string

    FACILITY_NAME
    Facility name if a chain or housing a chain (Source: Public Health - King County and Seattle)

    Uppercase string; may be same as Chain Name or different

    CHAIN_NAME
    Name of chain if facility is a chain (Source: Public Health - King County and Seattle)

    Uppercase string; may be same as Facility Name or different

    CHAIN_ESTABLISHMENT
    Whether facility is chain or not (Source: Public Health - King County and Seattle)

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

    SITE_ADDRESS
    Full street address of chain home location (Source: Public Health - King County and Seattle)

    Address number and uppercase name; non-standard abbreviations

    Entity_and_Attribute_Overview:
    Attributes are derived directly from DPH Restaurant Inspections website. The DESCRIPTION attribute is evaluated to separate size information from risk information. Otherwise all attributes are stored as found on the DPH website.
    Entity_and_Attribute_Detail_Citation: None


Who produced the data set?

  1. Who are the originators of the data set? (may include formal authors, digital compilers, and editors)

  2. Who also contributed to the data set?

  3. To whom should users address questions about the data?

    King County IT GIS Center/Client Services
    Attn: Mike Leathers
    Data Coordinator
    201 S Jackson St, Ste 225
    Seattle, WA 98104
    US

    206-477-4403 (voice)


Why was the data set created?

These inspections are made to assure that the food is being handled properly from preparation through serving. Inspectors observe kitchen workers' food handling practices, assure equipment is working properly, take food temperatures, inspect refrigerators and storage areas, assure water temperatures, and correct level and use of sanitizers. Any problem found is written up, and the manager is taught the correct procedure or method immediately.


How was the data set created?

  1. From what previous works were the data drawn?

  2. How were the data generated, processed, and modified?

    Date: 29-Nov-2010 (process 1 of 7)
    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.

    Person who carried out this activity:

    King County GIS Center
    Attn: constance carlson
    GIS Analyst

    constance.carlson@kingcounty.gov

    Date: 01-Dec-2015 (process 2 of 7)
    Change DATE_INSPECTION feld changed from a TEXT field to a Date field

    Person who carried out this activity:

    King County GIS Center
    Attn: constance carlson
    GIS Analyst

    constance.carlson@kingcounty.gov

    Date: 01-Feb-2018 (process 3 of 7)
    (1) Total Count of all individual download files: 262420 (2) Total count of all individual files aggregated: 262420 (3) Number of records that successfully loaded into restaurant inspections table:261718 (4) Number of records that failed to load into restaurant inspections table: 702 (5) Sum of successful and unsuccessful records: 262420 (6). Number of records in production featureclass (RESTAURANT_INSPECTIONS_POINT): 261718

    Person who carried out this activity:

    King County IT GIS Center
    Attn: Mike Leathers
    GIS Data Coordinator

    Date: 22-Aug-2018 (process 4 of 7)
    (1) Total Count of all individual download files: 262076 (2) Total count of all individual files aggregated: 262102 (3) Number of records that successfully loaded into restaurant inspections table:261515 (4) Number of records that failed to load into restaurant inspections table: 587 (5) Sum of successful and unsuccessful records: 262102 (6). Number of records in production featureclass (RESTAURANT_INSPECTIONS_POINT): 261515

    Date: 05-Dec-2018 (process 5 of 7)
    (1) Total Count of all individual download files: 265765 (2) Total count of all individual files aggregated: 265765 (3) Number of records that successfully loaded into restaurant inspections table:265192 (4) Number of records that failed to load into restaurant inspections table: 573 (5) Sum of successful and unsuccessful records: 265765 (6). Number of records in production featureclass (RESTAURANT_INSPECTIONS_POINT): 265192

    Date: 07-Oct-2019 (process 6 of 7)
    (1) Total Count of all individual download files: 269888 (2) Total count of all individual files aggregated: 269888 (3) Number of records that successfully loaded into restaurant inspections table:269289 (4) Number of records that failed to load into restaurant inspections table: 599 (5) Sum of successful and unsuccessful records: 269888 (6). Number of records in production featureclass (RESTAURANT_INSPECTIONS_POINT): 267522

    Date: 01-Mar-2021 (process 7 of 7)
    (1) Total Count of all individual download files: 253087 (2) Total count of all individual files aggregated: 253087 (3) Number of records that successfully loaded into restaurant inspections table:252066 (4) Number of records that failed to load into restaurant inspections table: 1021 (5) Sum of successful and unsuccessful records: 253087 (6). Number of records in production featureclass (RESTAURANT_INSPECTIONS_POINT): 252066

  3. What similar or related data should the user be aware of?


How reliable are the data; what problems remain in the data set?

  1. How well have the observations been checked?

    No attribute accuracy analysis is performed beyond what is published to the DPH website

  2. How accurate are the geographic locations?

  3. How accurate are the heights or depths?

  4. Where are the gaps in the data? What is missing?

    All records available at DPH website are downloaded. Due to data quality and data formatting issues, not all records are successfully loaded into the database table.

  5. How consistent are the relationships among the observations, including topology?

    Each feature represents a report record for a dated inspection. Geographic location is provided by feature centroid point stored with the DPH record. Associated chain information is derived from a separate table, and only those records associated with a chain are populated for the chain attributes. Records that do not have a matching chain attribute have null records for chain information.


How can someone get a copy of the data set?

Are there legal restrictions on access or use of the data?

Access_Constraints: None
Use_Constraints:
King County data are made available with the understanding that they shall be used exclusively by the obtainer or his/her authorized agents. Digital products may not be reproduced or redistributed in any form or by any means without the express written authorization of King County.

  1. Who distributes the data set? (Distributor 1 of 1)

    KCGIS Center
    Attn: giscenter@kingcounty.gov
    Data Sales Coordinator
    201 S Jackson St, Suite 225
    Seattle, WA 98104
    US

    206-477-4403 (voice)

  2. What's the catalog number I need to order this data set?

    /plibrary2/pubsafe/shapes/point/restaurant_inspections.shp

  3. What legal disclaimers am I supposed to read?

    King County disclaims any warranty of use of any digital product or data beyond that for which it was designed.

  4. How can I download or order the data?


Who wrote the metadata?

Dates:
Last modified: 30-Sep-2021
To be reviewed: 01-Jun-2016
Metadata author:
KCGIS Center
Attn: Mike Leathers
GIS Data Coordinator
201 S Jackson St, Ste 225
Seattle, WA 98104
US

206-477-4403 (voice)
constance.carlson@kingcounty.gov

Metadata standard:
FGDC Content Standard for Digital Geospatial Metadata (FGDC-STD-001-1998)


Generated by mp version 2.9.12 on Sun Oct 17 11:56:34 2021