Layers:
Name: Active Commercial Certificates of Compliance
Display Field:
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: Open in: [[Superset](https://superset.detroitmi.gov/tablemodelview/list/?filters=(schema:(label:dbt_mart_buildings,value:dbt_mart_buildings),table_name:active_commercial_compliance_certificates))] [[ArcGIS](https://detroitmi.maps.arcgis.com/home/item.html?id=3b86d3a64db640e5b14e9c3f889d3def&view=table&sortOrder=desc&sortField=defaultFSOrder&sublayer=0#data)] or [[Request format](https://app.smartsheet.com/b/form/7208d06cf7aa4b5780a579e0a38d20de?I want to=Request an automated report, dashboard or data visualization&Relevant data=snowflake.MODELS_PROD.DBT_MART_BUILDINGS.ACTIVE_COMMERCIAL_COMPLIANCE_CERTIFICATES)]
Open in: [Superset)] [ArcGIS] or [Request format]
A Certificate of Compliance is issued by the Buildings, Safety, Engineering, and Environmental Department (BSEED) for commercial properties within the City of Detroit that have met all life safety and code requirements. Once obtained, a Commercial Certificate of Compliance is valid for two years from date of issuance. A Certificate of Compliance must be obtained for all commercial buildings and structures in the City of Detroit, whether active or vacant. All inspections and processes are conducted in accordance with the provisions of the City of Detroit Property Maintenance Code, Chapter 8 of the Detroit City Code and the City of Detroit Zoning Ordinance, Chapter 50 of the Detroit City Code. This data set is limited to currently valid Certificates of Compliance.
For more information, please see the BSEED Commercial Certificates of Compliance webpage.
Copyright Text:
Min. Scale: 0
Max. Scale: 0
Default Visibility: true
Max Record Count: 1000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: -9271421.73492382
YMin: 5200350.5492324
XMax: -9229569.43696348
YMax: 5228622.45778312
Spatial Reference: 102100 (3857)
Drawing Info:
{"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}}}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: ObjectId
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- record_id (type: esriFieldTypeString, alias: Record ID, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- issued_date (type: esriFieldTypeDateOnly, alias: Issued Date, SQL Type: sqlTypeDate, nullable: true, editable: true)
- expired_date (type: esriFieldTypeDateOnly, alias: Expiration Date, SQL Type: sqlTypeDate, nullable: true, editable: true)
- num_days_until_expired (type: esriFieldTypeDouble, alias: Days Until Expiration, SQL Type: sqlTypeFloat, nullable: true, editable: true)
- neighborhood (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- council_district (type: esriFieldTypeString, alias: Council District, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
- zip_code (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeNVarchar, length: 2147483647, nullable: true, editable: true)
- street_number (type: esriFieldTypeDouble, alias: Street Number, SQL Type: sqlTypeFloat, nullable: true, editable: true)
- street_prefix (type: esriFieldTypeString, alias: Street Prefix, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- street_name (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- street_type (type: esriFieldTypeString, alias: Street Type, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- parcel_id (type: esriFieldTypeString, alias: Parcel ID, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
- address_id (type: esriFieldTypeDouble, alias: Address ID, SQL Type: sqlTypeFloat, nullable: true, editable: true)
- longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeFloat, nullable: true, editable: true)
- latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeFloat, nullable: true, editable: true)
- ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
Templates:
Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 7/28/2025 1:53:50 AM
Schema Last Edit Date: 7/28/2025 1:53:50 AM
Data Last Edit Date: 7/28/2025 1:53:50 AM