building_permits
None
nan
[{'name': 'record_id', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Record ID', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Unique identifier used to track this permit within BSEED\'s Accela database.","fieldValueType":"uniqueIdentifier"}'}, {'name': 'street_num', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Street Number', 'sqlType': 'sqlTypeNVarchar', 'length': 2147483647, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Street number of the property address where the permit was issued.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'street_dir', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Street Direction', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Street direction of the property address where the permit was issued.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'street_name', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Street Name', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Street name of the property address where the permit was issued.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'street_type', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Street Type', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Street type for the property address where the permit was issued.","fieldValueType":"locationOrPlaceName"}'}, {'name': 'submitted_date', 'type': 'esriFieldTypeDate', 'actualType': 'datetime2', 'alias': 'Date Submitted', 'sqlType': 'sqlTypeTimestamp2', 'length': 8, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Date the application was received. Applications are submitted to BSEED by property owners or licensed professionals.","fieldValueType":"dateAndTime"}', 'precision': 1}, {'name': 'issued_date', 'type': 'esriFieldTypeDate', 'actualType': 'datetime2', 'alias': 'Date Issued', 'sqlType': 'sqlTypeTimestamp2', 'length': 8, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Date the permit was issued. The permit is issued when the permit application is approved. Permits are issued by BSEED staff.","fieldValueType":"dateAndTime"}', 'precision': 1}, {'name': 'days_to_complete', 'type': 'esriFieldTypeInteger', 'actualType': 'int', 'alias': 'Days to Complete', 'sqlType': 'sqlTypeInteger', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Number of days the permit holder was given to complete activities articulated in the permit. The permit holder is generally given 6 months to complete the permit work and more time if there are consistent inspection activities.","fieldValueType":"countOrAmount"}'}, {'name': 'status', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Permit Status', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Current status of the permit. All records provided here have a status of Issued.","fieldValueType":"typeOrCategory"}'}, {'name': 'amount', 'type': 'esriFieldTypeDouble', 'actualType': 'float', 'alias': 'Permit Payment Amount', 'sqlType': 'sqlTypeFloat', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"This is the amount the permit applicant was required to pay for the permit.","fieldValueType":"currency"}'}, {'name': 'current_legal_use', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Building Legal Use', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"The building\'s current Type of Use. It is defined by the Michigan Building Code in conjunction with the City of Detroit Zoning Ordinance.","fieldValueType":"typeOrCategory"}'}, {'name': 'stories', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Stories', 'sqlType': 'sqlTypeNVarchar', 'length': 256, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Stories is the total number of floors in the building. Permits may be issued for individual floors or groups of floors.","fieldValueType":"measurement"}'}, {'name': 'zoning_district', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Zoning Code', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"The type of zoning district where the building is located. The City of Detroit Zoning Ordinance is written by the City Planning Commission and approved by City Council.","fieldValueType":"typeOrCategory"}'}, {'name': 'proposed_use', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Proposed Use', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"The Type of Use that the permit applicant proposed for the relevant building space after the permitted work is completed. The Type of Use is defined by the Michigan Building Code in conjunction with the City of Detroit Zoning Ordinance.","fieldValueType":"typeOrCategory"}'}, {'name': 'type_of_construction', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Type of Construction', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"The Type of Use that the permit applicant proposed for the relevant building space after the permitted work is completed. The Type of Use is defined by the Michigan Building Code in conjunction with the City of Detroit Zoning Ordinance.","fieldValueType":"typeOrCategory"}'}, {'name': 'permit_type', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Permit Type', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"The category of building permit that was issued.","fieldValueType":"typeOrCategory"}'}, {'name': 'description_of_work', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Description of Work', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Notes and further specifications about the building permit. They may contain details about the location information, related grants, or related building permits.","fieldValueType":"description"}'}, {'name': 'contractor_est_cost', 'type': 'esriFieldTypeDouble', 'actualType': 'float', 'alias': 'Contractor Estimated Cost', 'sqlType': 'sqlTypeFloat', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Cost estimated by contractor, when included in permit application.","fieldValueType":"currency"}'}, {'name': 'department_est_cost', 'type': 'esriFieldTypeDouble', 'actualType': 'float', 'alias': 'Department Estimated Cost', 'sqlType': 'sqlTypeFloat', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Cost estimate calculated by BSEED using the Michigan Bureau of Construction Codes (BCC) Square Footage Cost Table. Department Estimated Cost is used to determine permit fees when Contractor Estimated Cost is less than the cost estimate that is based on the BCC Square Footage Cost Table.","fieldValueType":"currency"}'}, {'name': 'parcel_id', 'type': 'esriFieldTypeString', 'actualType': 'nvarchar', 'alias': 'Parcel ID', 'sqlType': 'sqlTypeNVarchar', 'length': 4000, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Unique number used to track the parcel of land the building is located on. Parcel IDs are assigned by the Office of the Assessor.","fieldValueType":"uniqueIdentifier"}'}, {'name': 'lat', 'type': 'esriFieldTypeDouble', 'actualType': 'float', 'alias': 'Latitude', 'sqlType': 'sqlTypeFloat', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Geographic coordinate of the address of the structure for which the building permit was issued.","fieldValueType":"coordinate"}'}, {'name': 'lon', 'type': 'esriFieldTypeDouble', 'actualType': 'float', 'alias': 'Longitude', 'sqlType': 'sqlTypeFloat', 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Geographic coordinate of the address of the structure for which the building permit was issued.","fieldValueType":"coordinate"}'}, {'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 number used to identify the physical address of the location for which a building permit was issued. Address IDs are assigned when an address is geocoded using Detroit\'s Base Units.","fieldValueType":"uniqueIdentifier"}'}, {'name': 'open_to_elements', 'type': 'esriFieldTypeString', 'alias': 'Open to Elements?', 'sqlType': 'sqlTypeOther', 'length': 256, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Has the structure been open to the elements for more than one month in the last 3 years?","fieldValueType":""}'}, {'name': 'missing_portions', 'type': 'esriFieldTypeString', 'alias': 'Missing Portions?', 'sqlType': 'sqlTypeOther', 'length': 256, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Are the structure(s) missing windows, doors, or any portion of the roof?","fieldValueType":""}'}, {'name': 'purchased_from_dlba', 'type': 'esriFieldTypeString', 'alias': 'Purchased From DLBA?', 'sqlType': 'sqlTypeOther', 'length': 256, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Was the property purchased from the Detroit Land Bank Authority?","fieldValueType":""}'}, {'name': 'dlba_compliance', 'type': 'esriFieldTypeString', 'alias': 'DLBA Compliant?', 'sqlType': 'sqlTypeOther', 'length': 256, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Is the property currently in the DLBA compliance process?","fieldValueType":""}'}, {'name': 'change_in_units', 'type': 'esriFieldTypeString', 'alias': 'Change in Units?', 'sqlType': 'sqlTypeOther', 'length': 256, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Will this permit change the number of residential units?","fieldValueType":""}'}, {'name': 'vacant', 'type': 'esriFieldTypeString', 'alias': 'Vacant?', 'sqlType': 'sqlTypeOther', 'length': 256, 'nullable': True, 'editable': True, 'domain': None, 'defaultValue': None, 'description': '{"value":"Is the property currently vacant?","fieldValueType":""}'}]
[{'name': 'PK__BUILDING__9A6192919C5C0A84', 'fields': 'ObjectId', 'isAscending': True, 'isUnique': True, 'description': 'clustered, unique, primary key', 'indexType': 'Attribute'}, {'name': 'user_45103.BUILDING_PERMITS_2023_BUILDING_PERMITS_2023_Shape_sidx', 'fields': 'Shape', 'isAscending': False, 'isUnique': False, 'description': 'Shape Index', 'indexType': 'Spatial'}, {'name': 'issued_date_Index', 'fields': 'issued_date', 'isAscending': True, 'isUnique': False, 'description': 'issued_date_Index', 'indexType': 'Attribute'}, {'name': 'contractor_est_cost_Index', 'fields': 'contractor_est_cost', 'isAscending': True, 'isUnique': False, 'description': 'contractor_est_cost_Index', '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': {'record_id': None, 'street_num': None, 'street_dir': None, 'street_name': None, 'street_type': None, 'submitted_date': None, 'issued_date': None, 'days_to_complete': None, 'status': None, 'amount': None, 'current_legal_use': None, 'stories': None, 'zoning_district': None, 'proposed_use': None, 'type_of_construction': None, 'permit_type': None, 'description_of_work': None, 'contractor_est_cost': None, 'department_est_cost': None, 'parcel_id': None, 'lat': None, 'lon': None, 'address_id': None, 'open_to_elements': None, 'missing_portions': None, 'purchased_from_dlba': None, 'dlba_compliance': None, 'change_in_units': None, 'vacant': None}}}]