Detroit_Business_Certification_Register
None
nan
[{'name': 'business_name', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Business Name', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Name of the certified business.","fieldValueType":"nameOrTitle"}'}, {'name': 'business_street_address', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Business Street Address', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Street address of the certified business.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'business_city', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'City', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"City of the certified business.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'business_state', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'State', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"State of the certified business.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'business_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 of the certified business.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'detroit_based_business', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Detroit Based Business (DBB)', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Criteria for certification: 1) Business has a location in City 2) Business has paid City taxes for that location for the previous year 3) Business has physical resources and employees sufficient to provide services 4) Applicant discloses the number of Detroit Resident Employees.","fieldValueType":"binary"}'}, {'name': 'detroit_headquartered_business', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Detroit Headquartered Business (DHB)', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Criteria for certification: 1) Meets requirements of Detroit Based Business (DBB); 2) Has an office within the City of Detroit that serves as the administrative center where the chief executive officer and highest level management staff perform at least fifty-one (51%) percent of their management function.","fieldValueType":"binary"}'}, {'name': 'detroit_small_business', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Detroit Small Business (DSB)', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Criteria for certification: 1) Meets requirements of Detroit Based Business (DBB);  2) Has been in existence and operating for at least one (1) year prior to the date of the application; 3) Does not meet the definition of a micro business concern as defined; 4) Able to provide (3) years for tax information to meet ordinance definition.","fieldValueType":"binary"}'}, {'name': 'detroit_start_up', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Detroit Start Up (DSU)', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"A business located in the City that has been in business less than (2) years.","fieldValueType":"binary"}'}, {'name': 'detroit_resident_based_business', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Detroit Resident Based Business (DRB)', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Any business which employs a minimum of four (4) employees at least fifty-one (51%) percent which are City residents.","fieldValueType":"binary"}'}, {'name': 'detroit_based_micro_business', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Detroit Based Micro Business (DBMB)', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"1) Meets requirements of DBB 2) Annual gross receipts less than $1 million and no more than 15 employees 3) Has an office within the City of Detroit that serves as the administrative center where the chief executive officer and highest level management staff perform at least fifty-one (51%) percent of their management function 4) A business which is an affiliate or subsidiary of an entity that is not eligible for registration as a micro business concern shall not be registered as a micro business concern.","fieldValueType":"binary"}'}, {'name': 'woman_owned_business_enterprise', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Woman Owned Business Enterprise (WBE)', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Must have at least 51% woman ownership.","fieldValueType":"binary"}'}, {'name': 'minority_owned_business_enterpr', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Minority Owned Business Enterprise (MBE)', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Must have at least 51% minority ownership.","fieldValueType":"binary"}'}, {'name': 'industry_type', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Industry Type', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"The general type of good or service provided by this business.","fieldValueType":"typeOrCategory"}'}, {'name': 'business_category_1', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Other Business Category', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"List of any additional categories not provided in Industry Type.","fieldValueType":"typeOrCategory"}'}, {'name': 'business_category_2', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'business_category_2', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"The specific type of good or service provided by this business, if applicable.","fieldValueType":""}'}, {'name': 'nigp_code', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'NIGP Code', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"National Institute of Government Purchasing (NIGP) industry-standard codes chosen by the applicant to describe this business.","fieldValueType":"typeOrCategory"}'}, {'name': 'authorized_contact_first_name', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Contact First Name', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"First name of the business contact person.","fieldValueType":"nameOrTitle"}'}, {'name': 'authorized_contact_last_name', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Contact Last Name', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Last name of the business contact person.","fieldValueType":"nameOrTitle"}'}, {'name': 'business_phone_number', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Business Phone Number', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Phone number of the business.","fieldValueType":"phoneNumber"}'}, {'name': 'business_website', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Business Website', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Website of the business, if available.","fieldValueType":"description"}'}, {'name': 'certifications', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Certification List', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"List of active certifications provided to this business by CRIO.","fieldValueType":"typeOrCategory"}'}, {'name': 'ObjectId', 'type': 'esriFieldTypeOID', 'actualType': 'int', 'alias': 'ObjectId', 'sqlType': 'sqlTypeInteger', 'nullable': False, 'editable': False, 'domain': None, 'defaultValue': None}, {'name': 'address_id', 'type': 'esriFieldTypeString', 'alias': 'Address ID', 'sqlType': 'sqlTypeOther', 'length': 256, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Unique numeric identifier associated with the business address. Available for Detroit addresses only. Address IDs are assigned when an address is geocoded using Detroit\'s Base Units.","fieldValueType":"uniqueIdentifier"}'}]
[{'name': 'PK__DETROIT___9A6192916FB7AC7D', 'fields': 'ObjectId', 'isAscending': True, 'isUnique': True, 'description': 'clustered, unique, primary key', 'indexType': 'Attribute'}, {'name': 'user_45103.DETROIT_BUSINESS_CERTIFICATION_REGISTER_DETROIT_BUSINESS_CERTIFICATION_REGISTER_Shape_sidx', 'fields': 'Shape', 'isAscending': False, 'isUnique': False, 'description': 'Shape Index', 'indexType': 'Spatial'}]
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': {'business_name': None, 'business_street_address': None, 'business_city': None, 'business_state': None, 'business_zip_code': None, 'detroit_based_business': None, 'detroit_headquartered_business': None, 'detroit_small_business': None, 'detroit_start_up': None, 'detroit_resident_based_business': None, 'detroit_based_micro_business': None, 'woman_owned_business_enterprise': None, 'minority_owned_business_enterpr': None, 'industry_type': None, 'business_category_1': None, 'business_category_2': None, 'nigp_code': None, 'authorized_contact_first_name': None, 'authorized_contact_last_name': None, 'business_phone_number': None, 'business_website': None, 'certifications': None, 'address_id': None}}}]