Restaurant_Establishments
None
nan
[{'name': 'establishment_id', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Establishment Id', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Unique identifier for the food service establishment.","fieldValueType":""}'}, {'name': 'name', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Name', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Name of the food service establishment.","fieldValueType":""}'}, {'name': 'address', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Address', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Street address of the food service establishment, which is the physical location in the case of brick and mortar establishments, and administrative address in the case of mobile food service establishments. Mobile food service establishments may have addresses outside Detroit.","fieldValueType":""}'}, {'name': 'zip_code', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Zip Code', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Zip code for the food service establishment.","fieldValueType":""}'}, {'name': 'owner', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Owner', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Name of the person or organization that owns the food service establishment.","fieldValueType":""}'}, {'name': 'license_number', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'License Number', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Numeric or alphanumeric license number for the food service establishment.","fieldValueType":""}'}, {'name': 'license_type', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'License Type', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Type of food service license issued to the establishment by the Detroit Health Department.","fieldValueType":""}'}, {'name': 'most_recent_license_date', 'type': 'esriFieldTypeDate', 'actualType': 'datetime2', 'alias': 'Most Recent License Date', 'sqlType': 'sqlTypeTimestamp2', 'length': 8, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Date the most recent license was obtained by the food service establishment. Licenses expire annually on April 30th except in the case of temporary licenses.","fieldValueType":""}', 'precision': 1}, {'name': 'establishment_type', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Establishment Type', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Type of establishment inspected.","fieldValueType":""}'}, {'name': 'status', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Status', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Status of the inspected establishment.","fieldValueType":""}'}, {'name': 'restaurant_complexity_level', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Restaurant Complexity Level', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Complexity of the food service establishment as determined by food items served or prepared, food processes performed, and the number of meals or people served.","fieldValueType":""}'}, {'name': 'review_frequency_in_days', 'type': 'esriFieldTypeInteger', 'actualType': 'int', 'alias': 'Review Frequency in Days', 'sqlType': 'sqlTypeInteger', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Planned interval schedule for inspections. Varies based on the complexity level of the establishment and other factors.","fieldValueType":""}'}, {'name': 'address_id', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Address Id', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Unique numeric identifier associated with the establihsment\'s address. Address IDs are assigned when an address is geocoded using Detroit\'s Base Units.","fieldValueType":""}'}, {'name': 'lat', 'type': 'esriFieldTypeDouble', 'actualType': 'float', 'alias': 'Latitude', 'sqlType': 'sqlTypeFloat', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Latitudinal coordinate for food service establishment\'s address.","fieldValueType":""}'}, {'name': 'lon', 'type': 'esriFieldTypeDouble', 'actualType': 'float', 'alias': 'Longitude', 'sqlType': 'sqlTypeFloat', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Longitudinal coordinate for food service establishment\'s address.","fieldValueType":""}'}, {'name': 'ObjectId', 'type': 'esriFieldTypeOID', 'actualType': 'int', 'alias': 'ObjectId', 'sqlType': 'sqlTypeInteger', 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}]
[{'name': 'PK__RESTAURA__9A6192917F19E2AC', 'fields': 'ObjectId', 'isAscending': True, 'isUnique': True, 'description': 'clustered, unique, primary key', 'indexType': 'Attribute'}, {'name': 'user_45103.RESTAURANT_ESTABLISHMENTS_RESTAURANT_ESTABLISHMENTS2_Shape_sidx', 'fields': 'Shape', 'isAscending': False, 'isUnique': False, 'description': 'Shape Index', 'indexType': 'Spatial'}, {'name': 'idxdv_address_id_0', 'fields': 'address_id', 'isAscending': True, 'isUnique': False, 'description': '', 'indexType': 'Attribute'}]
nan
{'renderer': {'type': 'simple', 'symbol': {'type': 'esriPMS', 'url': 'RedSphere.png', 'imageData': 'iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAAB3VJREFUeF7tmPlTlEcexnve94U5mANQbgQSbgiHXHINlxpRIBpRI6wHorLERUmIisKCQWM8cqigESVQS1Kx1piNi4mW2YpbcZONrilE140RCTcy3DDAcL/zbJP8CYPDL+9Ufau7uqb7eZ7P+/a8PS8hwkcgIBAQCAgEBAICAYGAQEAgIBAQCAgEBAICAYGAQEAgIBAQCDx/AoowKXFMUhD3lQrioZaQRVRS+fxl51eBTZUTdZ41U1Rox13/0JF9csGJ05Qv4jSz/YPWohtvLmSKN5iTGGqTm1+rc6weICOBRbZs1UVnrv87T1PUeovxyNsUP9P6n5cpHtCxu24cbrmwKLdj+osWiqrVKhI0xzbmZ7m1SpJ+1pFpvE2DPvGTomOxAoNLLKGLscZYvB10cbYYjrJCb7A5mrxleOBqim+cWJRakZY0JfnD/LieI9V1MrKtwokbrAtU4Vm0A3TJnphJD4B+RxD0u0LA7w7FTE4oprOCMbklEGNrfdGf4IqnQTb4wc0MFTYibZqM7JgjO8ZdJkpMln/sKu16pHZGb7IfptIWg389DPp9kcChWODoMuDdBOhL1JgpisbUvghM7AqFbtNiaFP80RLnhbuBdqi0N+1dbUpWGde9gWpuhFi95yL7sS7BA93JAb+Fn8mh4QujgPeTgb9kAZf3Apd2A+fXQ38yHjOHozB1IAJjOSEY2RSIwVUv4dd4X9wJccGHNrJ7CYQ4GGjLeNNfM+dyvgpzQstKf3pbB2A6m97uBRE0/Ergcxr8hyqg7hrwn0vAtRIKIRX6Y2pMl0RhIj8co9nBGFrvh55l3ngU7YObng7IVnFvGS+BYUpmHziY/Ls2zgP9SX50by/G9N5w6I+ogYvpwK1SoOlHQNsGfWcd9Peqof88B/rTyzF9hAIopAByQzC0JQB9ST5oVnvhnt+LOGsprvUhxNIwa0aY7cGR6Cp7tr8+whkjawIxkRWC6YJI6N+lAKq3Qf/Tx+B77oGfaQc/8hB8w2Xwtw9Bf3kzZspXY/JIDEbfpAB2BKLvVV90Jvjgoac9vpRxE8kciTVCBMMkNirJ7k/tRHyjtxwjKV4Yp3t/6s+R4E+/DH3N6+BrS8E314Dvvg2+/Sb4hxfBf5sP/up2TF3ZhonK1zD6dhwGdwail26DzqgX8MRKiq9ZBpkSkmeYOyPM3m9Jjl+1Z9D8AgNtlAq6bZ70qsZi+q+bwV/7I/hbB8D/dAr8Axq89iz474p/G5++koHJy1sx/lkGdBc2YjA3HF0rHNHuboomuQj/5DgclIvOGCGCYRKFFuTMV7YUAD3VDQaLMfyqBcZORGPy01QKYSNm/rYV/Nd/Av9NHvgbueBrsjDzRQamKKDxT9Kgq1iLkbIUDOSHoiNcgnYHgnYZi+9ZExSbiSoMc2eE2flKcuJLa4KGRQz6/U0wlGaP0feiMH4uFpMXEjBVlYjp6lWY+SSZtim0kulYMiYuJEJXuhTDJ9UYPByOvoIwdCxfgE4bAo0Jh39xLAoVpMwIEQyTyFCQvGpLon9sJ0K3J4OBDDcMH1dj9FQsxkrjMPFRPCbOx2GyfLal9VEcxstioTulxjAFNfROJPqLl6Bnfyg6V7ugz5yBhuHwrZjBdiU5YJg7I8wOpifAKoVIW7uQ3rpOBH2b3ekVjYT2WCRG3o+mIGKgO0OrlIaebU/HYOQDNbQnojB4NJyGD0NPfjA0bwTRE6Q7hsUcWhkWN8yZqSQlWWGECAZLmJfJmbrvVSI8taK37xpbdB/wQW8xPee/8xIGjvlj8IQ/hk4G0JbWcX8MHPVDX4kveoq8ocn3xLM33NCZRcPHOGJYZIKfpQyq7JjHS6yJjcHujLHADgkpuC7h8F8zEVqXSNC2awE69lqhs8AamkO26HrbDt2H7dBVQov2NcW26CiwQtu+BWjdY4n2nZboTbfCmKcCnRyDO/YmyLPnDlHvjDH8G6zhS9/wlEnYR7X00fWrFYuWdVI0ZpuhcbcczW/R2qdAcz6t/bRov4mONeaaoYl+p22rHF0bVNAmKtBvweIXGxNcfFH8eNlC4m6wMWMusEnKpn5hyo48pj9gLe4SNG9QoGGLAk8z5XiaJUd99u8122/IpBA2K9BGg2vWWKAvRYVeLzEa7E1R422m2+MsSTem97nSYnfKyN6/mzATv7AUgqcMrUnmaFlLX3ysM0fj+t/b5lQLtK22QEfyAmiSLKFZpUJ7kBRPXKW4HqCYynWVHKSG2LkyZex1uO1mZM9lKem9Tx9jjY5iNEYo0bKMhn7ZAu0r6H5PpLXCAq0rKJClSjSGynE/QIkrQYqBPe6S2X+AJsY2Ped6iWZk6RlL0c2r5szofRsO9R5S1IfQLRCpQL1aifoYFerpsbkuTImaUJXuXIDiH6/Ys8vm3Mg8L2i20YqsO7fItKLcSXyn0kXccclVqv3MS6at9JU/Ox+ouns+SF6Z4cSupz7l8+z1ucs7LF1AQjOdxfGZzmx8Iu1TRcfnrioICAQEAgIBgYBAQCAgEBAICAQEAgIBgYBAQCAgEBAICAQEAv8H44b/6ZiGvGAAAAAASUVORK5CYII=', 'contentType': 'image/png', 'width': 15, 'height': 15}}}
[]
[{'name': 'New Feature', 'description': '', 'drawingTool': 'esriFeatureEditToolPoint', 'prototype': {'attributes': {'establishment_id': None, 'name': None, 'address': None, 'zip_code': None, 'owner': None, 'license_number': None, 'license_type': None, 'most_recent_license_date': None, 'establishment_type': None, 'status': None, 'restaurant_complexity_level': None, 'review_frequency_in_days': None, 'address_id': None, 'lat': None, 'lon': None}}}]