{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Food Permits", "type": "Feature Layer", "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", "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": 7097437.023960397, "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": "R22978_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S18009_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "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 }