Layers:

Layer: Food Permits (0)

Name: Food Permits

Display Field: inspection_cycle

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>Last Updated: May 31, 2019</SPAN></P><P><SPAN>Update Schedule: Nightly</SPAN></P><P><SPAN>The 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.</SPAN></P><P STYLE="text-indent:20;"><SPAN STYLE="font-weight:bold;">Health Compliance Contact Information:</SPAN></P><P STYLE="text-indent:20;"><SPAN>Web: https://www.mckinneytexas.org/218/Health-Compliance | Email: healthinfo@mckinneytexas.org</SPAN></P><P STYLE="text-indent:20;"><SPAN>Phone 8am - 5pm: 972-547-7440</SPAN></P><P><SPAN>This 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.</SPAN></P><P><SPAN>In addition to pdf attachments, the following data are captured:</SPAN></P><P STYLE="text-indent:20;"><SPAN>last inspection date, permit number, work class, permit status</SPAN></P><P STYLE="margin:1 1 1 20;"><SPAN>address, parcel number, description, average score, tending status</SPAN></P><P STYLE="margin:1 1 1 20;"><SPAN>total number of inspections, number of critical violations within last 4 inspection period</SPAN></P></DIV></DIV></DIV>

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: true

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: 2498514.61718522
YMin: 7097506.566800311
XMax: 2550977.1028112173
YMax: 7145122.017172888
Spatial Reference: 102738  (2276)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [170, 42, 91, 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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• last_inspection ( type: esriFieldTypeDate, alias: last_inspection, length: 8 )
• next_inspection ( type: esriFieldTypeDate, alias: next_inspection, length: 8 )
• inspection_cycle ( type: esriFieldTypeString, alias: inspection_cycle, length: 50 )
• link_number ( type: esriFieldTypeString, alias: link_number, length: 50 )
• WORK_CLASS ( type: esriFieldTypeString, alias: WORK_CLASS, length: 50 )
• PERMIT_STATUS ( type: esriFieldTypeString, alias: PERMIT_STATUS, length: 50 )
• ADDRESS_LINE1 ( type: esriFieldTypeString, alias: ADDRESS_LINE1, length: 736 )
• PARCELNUMBER ( type: esriFieldTypeString, alias: PARCELNUMBER, length: 50 )
• expiration_date ( type: esriFieldTypeDate, alias: expiration_date, length: 8 )
• description ( type: esriFieldTypeString, alias: description, length: 1073741822 )
• avg_score ( type: esriFieldTypeString, alias: avg_score, length: 10 )
• trend ( type: esriFieldTypeString, alias: trend, length: 50 )
• inspections ( type: esriFieldTypeInteger, alias: inspections )
• critical_violations ( type: esriFieldTypeInteger, alias: critical_violations )
• 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.HealthFoodSafety (0) -- Related To: Food Inspections (4)

Layer: Food Inspections (4)

Name: Food Inspections

Display Field: permitted_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN><SPAN>Last Updated: May 31, 2019</SPAN></SPAN></P><P><SPAN><SPAN>Update Schedule: Nightly</SPAN></SPAN></P><P><SPAN><SPAN>The 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.</SPAN></SPAN></P><P STYLE="text-indent:20;"><SPAN STYLE="font-weight:bold;">Health Compliance Contact Information:</SPAN></P><P STYLE="text-indent:20;"><SPAN><SPAN>Web: https://www.mckinneytexas.org/218/Health-Compliance | Email: healthinfo@mckinneytexas.org</SPAN></SPAN></P><P STYLE="text-indent:20;"><SPAN><SPAN>Phone 8am - 5pm: 972-547-7440</SPAN></SPAN></P><P><SPAN><SPAN>This 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.</SPAN></SPAN></P><P><SPAN><SPAN>In addition to pdf attachments, the following data are captured:</SPAN></SPAN></P><P STYLE="text-indent:20;"><SPAN><SPAN>last inspection date, permit number, work class, permit status</SPAN></SPAN></P><P STYLE="text-indent:20;"><SPAN><SPAN>address, parcel number, description, average score, tending status</SPAN></SPAN></P><P STYLE="text-indent:20;"><SPAN><SPAN>total number of inspections, number of critical violations within last 4 inspection period</SPAN></SPAN></P><P><SPAN /></P></DIV></DIV></DIV>

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 (0) -- Related To: Food Permits (0)