Name: Certificate of Occupancy

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:occupancy_certificates))] [[ArcGIS](https://detroitmi.maps.arcgis.com/home/item.html?id=0b5291df3d1c4b3693af5d4ca508030b&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.OCCUPANCY_CERTIFICATES)]

Open in: [Superset)] [ArcGIS] or [Request format]
Open in: [Superset)] or [Request format]
A Certificate of Occupancy (C of O) is the permission to occupy a building or space based on approved permits. The application is submitted to BSEED along with all permits associated with the project. The building permit applicant or licensed professional would apply for the C of O, not necessarily the property owner. The purpose of tracking this information is to verify that the completed project has been approved for occupancy.

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: -9271027.49694718
YMin: 5200350.5492324
XMax: -9229699.13411476
YMax: 5228591.2284474
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)
• task_status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• issued_date (type: esriFieldTypeDateOnly, alias: Issued Date, SQL Type: sqlTypeDate, nullable: true, editable: true)
• permit_type (type: esriFieldTypeString, alias: Permit Type, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• construction_type (type: esriFieldTypeString, alias: Construction Type, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• use_group (type: esriFieldTypeString, alias: Use Group, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• current_use_type (type: esriFieldTypeString, alias: Current Use Type, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• proposed_use_type (type: esriFieldTypeString, alias: Proposed Use Type, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• zoning_designation (type: esriFieldTypeString, alias: Zoning Designation, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• num_stories (type: esriFieldTypeDouble, alias: Stories, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• num_units (type: esriFieldTypeDouble, alias: Units, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• work_description (type: esriFieldTypeString, alias: Work Description, SQL Type: sqlTypeNVarchar, length: 726, 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: 9/30/2025 1:58:56 AM

Schema Last Edit Date: 9/30/2025 1:58:56 AM

Data Last Edit Date: 9/30/2025 1:58:56 AM

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