Name: Food Inspections

Display Field: permitted_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Last Updated: May 31, 2019Update Schedule: NightlyThe Health Compliance Team is located within Code Services, a Department of the Development Services Division in the City of McKinney. Health Compliance is tasked with permitting and inspecting food establishments, swimming pools, and is responsible for disease vector control.Health Compliance Contact Information:Web: https://www.mckinneytexas.org/218/Health-Compliance | Email: healthinfo@mckinneytexas.orgPhone 8am - 5pm: 972-547-7440This point layer documents all permitted food establishments, an aggregation of attributes from the four most recent inspections, and all food inspection sheets as pdf attachments. This data is extracted from the Energov system on a nightly basis.In addition to pdf attachments, the following data are captured:last inspection date, permit number, work class, permit statusaddress, parcel number, description, average score, tending statustotal number of inspections, number of critical violations within last 4 inspection period

Copyright Text: City of McKinney GIS, Development Services, Code Services, Health Compliance Team jcarmona@mckinneytexas.org; healthinfo@mckinneytexas.org https://mckinneygis-mck.opendata.arcgis.com/

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 2498364.946880892
YMin: 7097772.258526146
XMax: 2550977.1028112173
YMax: 7145122.017172888
Spatial Reference: 102738  (2276)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [40, 40, 163, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• inspection_number ( type: esriFieldTypeString, alias: inspection_number, length: 50 )
• requested_date ( type: esriFieldTypeDate, alias: requested_date, length: 8 )
• actual_start_date ( type: esriFieldTypeDate, alias: actual_start_date, length: 8 )
• actual_end_date ( type: esriFieldTypeDate, alias: actual_end_date, length: 8 )
• link_number ( type: esriFieldTypeString, alias: link_number, length: 50 )
• link_type ( type: esriFieldTypeString, alias: link_type, length: 50 )
• permitted_name ( type: esriFieldTypeString, alias: permitted_name, length: 1073741822 )
• date_entered ( type: esriFieldTypeDate, alias: date_entered, length: 8 )
• comments ( type: esriFieldTypeString, alias: comments, length: 1073741822 )
• status ( type: esriFieldTypeString, alias: status, length: 50 )
• inspection_type ( type: esriFieldTypeString, alias: inspection_type, length: 50 )
• inspector_name ( type: esriFieldTypeString, alias: inspector_name, length: 62 )
• main_address ( type: esriFieldTypeString, alias: main_address, length: 736 )
• main_address2 ( type: esriFieldTypeString, alias: main_address2, length: 736 )
• main_parcel_no ( type: esriFieldTypeString, alias: main_parcel_no, length: 50 )
• temp_cooling_time ( type: esriFieldTypeInteger, alias: temp_cooling_time )
• temp_cold_holding ( type: esriFieldTypeInteger, alias: temp_cold_holding )
• temp_hot_holding ( type: esriFieldTypeInteger, alias: temp_hot_holding )
• temp_cooking_time ( type: esriFieldTypeInteger, alias: temp_cooking_time )
• reheating_procedure ( type: esriFieldTypeInteger, alias: reheating_procedure )
• time_as_health_control ( type: esriFieldTypeInteger, alias: time_as_health_control )
• approved_source ( type: esriFieldTypeInteger, alias: approved_source )
• food_received_at_temp ( type: esriFieldTypeInteger, alias: food_received_at_temp )
• food_separated_protected ( type: esriFieldTypeInteger, alias: food_separated_protected )
• food_surfaces_returnables ( type: esriFieldTypeInteger, alias: food_surfaces_returnables )
• condition_of ( type: esriFieldTypeInteger, alias: condition_of )
• knowledge_and_reporting ( type: esriFieldTypeInteger, alias: knowledge_and_reporting )
• proper_restriction_exclusion ( type: esriFieldTypeInteger, alias: proper_restriction_exclusion )
• hands_clean_washed ( type: esriFieldTypeInteger, alias: hands_clean_washed )
• no_bare_hands ( type: esriFieldTypeInteger, alias: no_bare_hands )
• pastuerized_foods ( type: esriFieldTypeInteger, alias: pastuerized_foods )
• food_additives ( type: esriFieldTypeInteger, alias: food_additives )
• toxic_substances ( type: esriFieldTypeInteger, alias: toxic_substances )
• approved_water_source ( type: esriFieldTypeInteger, alias: approved_water_source )
• approved_sewage ( type: esriFieldTypeInteger, alias: approved_sewage )
• certified_food_manager ( type: esriFieldTypeInteger, alias: certified_food_manager )
• food_handler_cards ( type: esriFieldTypeInteger, alias: food_handler_cards )
• available_hot_cold_water ( type: esriFieldTypeInteger, alias: available_hot_cold_water )
• available_records ( type: esriFieldTypeInteger, alias: available_records )
• compliance_with_variance ( type: esriFieldTypeInteger, alias: compliance_with_variance )
• consumer_advisories ( type: esriFieldTypeInteger, alias: consumer_advisories )
• proper_cooling_method ( type: esriFieldTypeInteger, alias: proper_cooling_method )
• proper_date_marking ( type: esriFieldTypeInteger, alias: proper_date_marking )
• thermometers_accurate ( type: esriFieldTypeInteger, alias: thermometers_accurate )
• food_establishment_permit ( type: esriFieldTypeInteger, alias: food_establishment_permit )
• handwashing_facilities ( type: esriFieldTypeInteger, alias: handwashing_facilities )
• cleanable_surfaces ( type: esriFieldTypeInteger, alias: cleanable_surfaces )
• warewashing_facilities ( type: esriFieldTypeInteger, alias: warewashing_facilities )
• no_insect_contamination ( type: esriFieldTypeInteger, alias: no_insect_contamination )
• personal_cleanliness ( type: esriFieldTypeInteger, alias: personal_cleanliness )
• wiping_cloths ( type: esriFieldTypeInteger, alias: wiping_cloths )
• environmental_contamination ( type: esriFieldTypeInteger, alias: environmental_contamination )
• approved_thawing ( type: esriFieldTypeInteger, alias: approved_thawing )
• utensils_and_linens ( type: esriFieldTypeInteger, alias: utensils_and_linens )
• single_service_use ( type: esriFieldTypeInteger, alias: single_service_use )
• original_container_labeling ( type: esriFieldTypeInteger, alias: original_container_labeling )
• nonfood_surfaces_clean ( type: esriFieldTypeInteger, alias: nonfood_surfaces_clean )
• adequate_ventilation_lighting ( type: esriFieldTypeInteger, alias: adequate_ventilation_lighting )
• garbage_and_refuse ( type: esriFieldTypeInteger, alias: garbage_and_refuse )
• physical_facilities_maintained ( type: esriFieldTypeInteger, alias: physical_facilities_maintained )
• toilet_facilities ( type: esriFieldTypeInteger, alias: toilet_facilities )
• other_violations ( type: esriFieldTypeInteger, alias: other_violations )
• total_score ( type: esriFieldTypeInteger, alias: total_score )
• purpose_of_inspection ( type: esriFieldTypeString, alias: purpose_of_inspection, length: 50 )
• bare_hand_approved ( type: esriFieldTypeString, alias: bare_hand_approved, length: 50 )
• custom_comments ( type: esriFieldTypeString, alias: custom_comments, length: 1073741822 )
• sanitized_ppm ( type: esriFieldTypeString, alias: sanitized_ppm, length: 50 )
• attach_guid ( type: esriFieldTypeString, alias: attach_guid, length: 36 )
• attach_filename ( type: esriFieldTypeString, alias: attach_filename, length: 260 )
• attach_filepath ( type: esriFieldTypeString, alias: attach_filepath, length: 1073741822 )
• attach_fullpath ( type: esriFieldTypeString, alias: attach_fullpath, length: 1073741822 )
• POINT_X ( type: esriFieldTypeString, alias: POINT_X, length: 20 )
• POINT_Y ( type: esriFieldTypeString, alias: POINT_Y, length: 20 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )

Relationships:

• energov.SDE.HealthFoodPermits (1) -- Related To: Food Permits (0)
• energov.SDE.HealthFoodPermits (3) -- Related To: Mobile & Temporary Food Vendors (1)
• energov.SDE.HealthFoodPermits (5) -- Related To: Trades Day & Farmers Market (2)
• energov.SDE.HealthFoodPermits (7) -- Related To: Schools & Daycares (3)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata