{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Food Permits", "type": "Feature Layer", "description": "

Last Updated: May 31, 2019<\/SPAN><\/P>

Update Schedule: Nightly<\/SPAN><\/P>

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>

Health Compliance Contact Information:<\/SPAN><\/P>

Web: https://www.mckinneytexas.org/218/Health-Compliance | Email: healthinfo@mckinneytexas.org<\/SPAN><\/P>

Phone 8am - 5pm: 972-547-7440<\/SPAN><\/P>

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>

In addition to pdf attachments, the following data are captured:<\/SPAN><\/P>

last inspection date, permit number, work class, permit status<\/SPAN><\/P>

address, parcel number, description, average score, tending status<\/SPAN><\/P>

total number of inspections, number of critical violations within last 4 inspection period<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "City of McKinney GIS, Development Services, Code Services, Health Compliance Team\njcarmona@mckinneytexas.org; healthinfo@mckinneytexas.org\nhttps://mckinneygis-mck.opendata.arcgis.com/", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 170, 42, 91, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2498514.61718522, "ymin": 7097506.566800311, "xmax": 2550977.1028112173, "ymax": 7145122.017172888, "spatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalid", "fieldName": "GLOBALID", "isEnabled": false }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "editable": false, "nullable": false, "length": 4, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "editable": true, "nullable": false, "length": 250, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "editable": true, "nullable": false, "length": 150, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "editable": true, "nullable": false, "length": 4, "domain": null } ], "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "inspection_cycle", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "last_inspection", "type": "esriFieldTypeDate", "alias": "last_inspection", "length": 8, "domain": null }, { "name": "next_inspection", "type": "esriFieldTypeDate", "alias": "next_inspection", "length": 8, "domain": null }, { "name": "inspection_cycle", "type": "esriFieldTypeString", "alias": "inspection_cycle", "length": 50, "domain": null }, { "name": "link_number", "type": "esriFieldTypeString", "alias": "link_number", "length": 50, "domain": null }, { "name": "WORK_CLASS", "type": "esriFieldTypeString", "alias": "WORK_CLASS", "length": 50, "domain": null }, { "name": "PERMIT_STATUS", "type": "esriFieldTypeString", "alias": "PERMIT_STATUS", "length": 50, "domain": null }, { "name": "ADDRESS_LINE1", "type": "esriFieldTypeString", "alias": "ADDRESS_LINE1", "length": 736, "domain": null }, { "name": "PARCELNUMBER", "type": "esriFieldTypeString", "alias": "PARCELNUMBER", "length": 50, "domain": null }, { "name": "expiration_date", "type": "esriFieldTypeDate", "alias": "expiration_date", "length": 8, "domain": null }, { "name": "description", "type": "esriFieldTypeString", "alias": "description", "length": 1073741822, "domain": null }, { "name": "avg_score", "type": "esriFieldTypeString", "alias": "avg_score", "length": 10, "domain": null }, { "name": "trend", "type": "esriFieldTypeString", "alias": "trend", "length": 50, "domain": null }, { "name": "inspections", "type": "esriFieldTypeInteger", "alias": "inspections", "domain": null }, { "name": "critical_violations", "type": "esriFieldTypeInteger", "alias": "critical_violations", "domain": null }, { "name": "POINT_X", "type": "esriFieldTypeString", "alias": "POINT_X", "length": 20, "domain": null }, { "name": "POINT_Y", "type": "esriFieldTypeString", "alias": "POINT_Y", "length": 20, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R28586_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S22455_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "energov.SDE.HealthFoodSafety", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "link_number", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 4, "name": "Food Inspections", "type": "Feature Layer", "description": "

Last Updated: May 31, 2019<\/SPAN><\/SPAN><\/P>

Update Schedule: Nightly<\/SPAN><\/SPAN><\/P>

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>

Health Compliance Contact Information:<\/SPAN><\/P>

Web: https://www.mckinneytexas.org/218/Health-Compliance | Email: healthinfo@mckinneytexas.org<\/SPAN><\/SPAN><\/P>

Phone 8am - 5pm: 972-547-7440<\/SPAN><\/SPAN><\/P>

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>

In addition to pdf attachments, the following data are captured:<\/SPAN><\/SPAN><\/P>

last inspection date, permit number, work class, permit status<\/SPAN><\/SPAN><\/P>

address, parcel number, description, average score, tending status<\/SPAN><\/SPAN><\/P>

total number of inspections, number of critical violations within last 4 inspection period<\/SPAN><\/SPAN><\/P>

<\/P><\/DIV><\/DIV><\/DIV>", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "City of McKinney GIS, Development Services, Code Services, Health Compliance Team\njcarmona@mckinneytexas.org; healthinfo@mckinneytexas.org\nhttps://mckinneygis-mck.opendata.arcgis.com/", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSMS", "style": "esriSMSCircle", "color": [ 40, 40, 163, 255 ], "size": 4, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": 2498364.946880892, "ymin": 7097772.258526146, "xmax": 2550977.1028112173, "ymax": 7145122.017172888, "spatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3048.0060960121928, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "permitted_name", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "inspection_number", "type": "esriFieldTypeString", "alias": "inspection_number", "length": 50, "domain": null }, { "name": "requested_date", "type": "esriFieldTypeDate", "alias": "requested_date", "length": 8, "domain": null }, { "name": "actual_start_date", "type": "esriFieldTypeDate", "alias": "actual_start_date", "length": 8, "domain": null }, { "name": "actual_end_date", "type": "esriFieldTypeDate", "alias": "actual_end_date", "length": 8, "domain": null }, { "name": "link_number", "type": "esriFieldTypeString", "alias": "link_number", "length": 50, "domain": null }, { "name": "link_type", "type": "esriFieldTypeString", "alias": "link_type", "length": 50, "domain": null }, { "name": "permitted_name", "type": "esriFieldTypeString", "alias": "permitted_name", "length": 1073741822, "domain": null }, { "name": "date_entered", "type": "esriFieldTypeDate", "alias": "date_entered", "length": 8, "domain": null }, { "name": "comments", "type": "esriFieldTypeString", "alias": "comments", "length": 1073741822, "domain": null }, { "name": "status", "type": "esriFieldTypeString", "alias": "status", "length": 50, "domain": null }, { "name": "inspection_type", "type": "esriFieldTypeString", "alias": "inspection_type", "length": 50, "domain": null }, { "name": "inspector_name", "type": "esriFieldTypeString", "alias": "inspector_name", "length": 62, "domain": null }, { "name": "main_address", "type": "esriFieldTypeString", "alias": "main_address", "length": 736, "domain": null }, { "name": "main_address2", "type": "esriFieldTypeString", "alias": "main_address2", "length": 736, "domain": null }, { "name": "main_parcel_no", "type": "esriFieldTypeString", "alias": "main_parcel_no", "length": 50, "domain": null }, { "name": "temp_cooling_time", "type": "esriFieldTypeInteger", "alias": "temp_cooling_time", "domain": null }, { "name": "temp_cold_holding", "type": "esriFieldTypeInteger", "alias": "temp_cold_holding", "domain": null }, { "name": "temp_hot_holding", "type": "esriFieldTypeInteger", "alias": "temp_hot_holding", "domain": null }, { "name": "temp_cooking_time", "type": "esriFieldTypeInteger", "alias": "temp_cooking_time", "domain": null }, { "name": "reheating_procedure", "type": "esriFieldTypeInteger", "alias": "reheating_procedure", "domain": null }, { "name": "time_as_health_control", "type": "esriFieldTypeInteger", "alias": "time_as_health_control", "domain": null }, { "name": "approved_source", "type": "esriFieldTypeInteger", "alias": "approved_source", "domain": null }, { "name": "food_received_at_temp", "type": "esriFieldTypeInteger", "alias": "food_received_at_temp", "domain": null }, { "name": "food_separated_protected", "type": "esriFieldTypeInteger", "alias": "food_separated_protected", "domain": null }, { "name": "food_surfaces_returnables", "type": "esriFieldTypeInteger", "alias": "food_surfaces_returnables", "domain": null }, { "name": "condition_of", "type": "esriFieldTypeInteger", "alias": "condition_of", "domain": null }, { "name": "knowledge_and_reporting", "type": "esriFieldTypeInteger", "alias": "knowledge_and_reporting", "domain": null }, { "name": "proper_restriction_exclusion", "type": "esriFieldTypeInteger", "alias": "proper_restriction_exclusion", "domain": null }, { "name": "hands_clean_washed", "type": "esriFieldTypeInteger", "alias": "hands_clean_washed", "domain": null }, { "name": "no_bare_hands", "type": "esriFieldTypeInteger", "alias": "no_bare_hands", "domain": null }, { "name": "pastuerized_foods", "type": "esriFieldTypeInteger", "alias": "pastuerized_foods", "domain": null }, { "name": "food_additives", "type": "esriFieldTypeInteger", "alias": "food_additives", "domain": null }, { "name": "toxic_substances", "type": "esriFieldTypeInteger", "alias": "toxic_substances", "domain": null }, { "name": "approved_water_source", "type": "esriFieldTypeInteger", "alias": "approved_water_source", "domain": null }, { "name": "approved_sewage", "type": "esriFieldTypeInteger", "alias": "approved_sewage", "domain": null }, { "name": "certified_food_manager", "type": "esriFieldTypeInteger", "alias": "certified_food_manager", "domain": null }, { "name": "food_handler_cards", "type": "esriFieldTypeInteger", "alias": "food_handler_cards", "domain": null }, { "name": "available_hot_cold_water", "type": "esriFieldTypeInteger", "alias": "available_hot_cold_water", "domain": null }, { "name": "available_records", "type": "esriFieldTypeInteger", "alias": "available_records", "domain": null }, { "name": "compliance_with_variance", "type": "esriFieldTypeInteger", "alias": "compliance_with_variance", "domain": null }, { "name": "consumer_advisories", "type": "esriFieldTypeInteger", "alias": "consumer_advisories", "domain": null }, { "name": "proper_cooling_method", "type": "esriFieldTypeInteger", "alias": "proper_cooling_method", "domain": null }, { "name": "proper_date_marking", "type": "esriFieldTypeInteger", "alias": "proper_date_marking", "domain": null }, { "name": "thermometers_accurate", "type": "esriFieldTypeInteger", "alias": "thermometers_accurate", "domain": null }, { "name": "food_establishment_permit", "type": "esriFieldTypeInteger", "alias": "food_establishment_permit", "domain": null }, { "name": "handwashing_facilities", "type": "esriFieldTypeInteger", "alias": "handwashing_facilities", "domain": null }, { "name": "cleanable_surfaces", "type": "esriFieldTypeInteger", "alias": "cleanable_surfaces", "domain": null }, { "name": "warewashing_facilities", "type": "esriFieldTypeInteger", "alias": "warewashing_facilities", "domain": null }, { "name": "no_insect_contamination", "type": "esriFieldTypeInteger", "alias": "no_insect_contamination", "domain": null }, { "name": "personal_cleanliness", "type": "esriFieldTypeInteger", "alias": "personal_cleanliness", "domain": null }, { "name": "wiping_cloths", "type": "esriFieldTypeInteger", "alias": "wiping_cloths", "domain": null }, { "name": "environmental_contamination", "type": "esriFieldTypeInteger", "alias": "environmental_contamination", "domain": null }, { "name": "approved_thawing", "type": "esriFieldTypeInteger", "alias": "approved_thawing", "domain": null }, { "name": "utensils_and_linens", "type": "esriFieldTypeInteger", "alias": "utensils_and_linens", "domain": null }, { "name": "single_service_use", "type": "esriFieldTypeInteger", "alias": "single_service_use", "domain": null }, { "name": "original_container_labeling", "type": "esriFieldTypeInteger", "alias": "original_container_labeling", "domain": null }, { "name": "nonfood_surfaces_clean", "type": "esriFieldTypeInteger", "alias": "nonfood_surfaces_clean", "domain": null }, { "name": "adequate_ventilation_lighting", "type": "esriFieldTypeInteger", "alias": "adequate_ventilation_lighting", "domain": null }, { "name": "garbage_and_refuse", "type": "esriFieldTypeInteger", "alias": "garbage_and_refuse", "domain": null }, { "name": "physical_facilities_maintained", "type": "esriFieldTypeInteger", "alias": "physical_facilities_maintained", "domain": null }, { "name": "toilet_facilities", "type": "esriFieldTypeInteger", "alias": "toilet_facilities", "domain": null }, { "name": "other_violations", "type": "esriFieldTypeInteger", "alias": "other_violations", "domain": null }, { "name": "total_score", "type": "esriFieldTypeInteger", "alias": "total_score", "domain": null }, { "name": "purpose_of_inspection", "type": "esriFieldTypeString", "alias": "purpose_of_inspection", "length": 50, "domain": null }, { "name": "bare_hand_approved", "type": "esriFieldTypeString", "alias": "bare_hand_approved", "length": 50, "domain": null }, { "name": "custom_comments", "type": "esriFieldTypeString", "alias": "custom_comments", "length": 1073741822, "domain": null }, { "name": "sanitized_ppm", "type": "esriFieldTypeString", "alias": "sanitized_ppm", "length": 50, "domain": null }, { "name": "attach_guid", "type": "esriFieldTypeString", "alias": "attach_guid", "length": 36, "domain": null }, { "name": "attach_filename", "type": "esriFieldTypeString", "alias": "attach_filename", "length": 260, "domain": null }, { "name": "attach_filepath", "type": "esriFieldTypeString", "alias": "attach_filepath", "length": 1073741822, "domain": null }, { "name": "attach_fullpath", "type": "esriFieldTypeString", "alias": "attach_fullpath", "length": 1073741822, "domain": null }, { "name": "POINT_X", "type": "esriFieldTypeString", "alias": "POINT_X", "length": 20, "domain": null }, { "name": "POINT_Y", "type": "esriFieldTypeString", "alias": "POINT_Y", "length": 20, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R28555_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S22428_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "energov.SDE.HealthFoodPermits", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "link_number", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": false, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true } ], "tables": [] }