{ "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": "R28625_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S22486_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 }