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:

Name : ObjectId

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:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/20/2025 2:12:13 AM

Schema Last Edit Date: 7/20/2025 2:12:13 AM

Data Last Edit Date: 7/20/2025 2:12:13 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat