View In:   ArcGIS Online Map Viewer

Name: Certificate of Occupancy

Display Field: PERMIT_NUMBER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: All applicants for a Basic Business License operating from a commercial location in the District of Columbia must provide a Certificate of Occupancy (C of O) for the premise address from which the business activity is conducted in order to demonstrate the activity does not conflict with building and zoning codes. A certificate of occupancy is needed to occupy any structure other than a single family dwelling. To include the following uses: two family flat, apartment house and all commercial uses.

Copyright Text: https://dcra.dc.gov

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -8584054.590014953
YMin: 4694964.964886367
XMax: -8561573.705005934
YMax: 4720267.512365764
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [89, 0, 128, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• PERMIT_NUMBER ( type: esriFieldTypeString, alias: Certificate of Occupancy Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PERMIT_NUMBER )
• ISSUE_DATE ( type: esriFieldTypeDate, alias: Date certificate issued, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ISSUE_DATE )
• ADDRESS ( type: esriFieldTypeString, alias: Address of property, editable: true, nullable: true, length: 200, defaultValue: null, modelName: ADDRESS )
• WARD ( type: esriFieldTypeString, alias: Ward as of 2022, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WARD )
• DESCRIPTION_OF_OCCUPANCY ( type: esriFieldTypeString, alias: Type of business occupying the property, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: DESCRIPTION_OF_OCCUPANCY )
• PERMISSION_GRANTED_TO ( type: esriFieldTypeString, alias: Business name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: PERMISSION_GRANTED_TO )
• TRADING_AS ( type: esriFieldTypeString, alias: Trade Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: TRADING_AS )
• OCCUPANCY_LOAD ( type: esriFieldTypeString, alias: Capacity of the establishment or number of units (if apartment building), editable: true, nullable: true, length: 200, defaultValue: null, modelName: OCCUPANCY_LOAD )
• PROPERTY_OWNER ( type: esriFieldTypeString, alias: Full name of property owner, editable: true, nullable: true, length: 200, defaultValue: null, modelName: PROPERTY_OWNER )
• OWNER_ADDRESS ( type: esriFieldTypeString, alias: Address of the property owner which may be different than the property address., editable: true, nullable: true, length: 200, defaultValue: null, modelName: OWNER_ADDRESS )
• B_Z_A_NUMBER ( type: esriFieldTypeString, alias: Board of Zoning Adjustment number order associated with the HOP, editable: true, nullable: true, length: 50, defaultValue: null, modelName: B_Z_A_NUMBER )
• APPROVED_BUILDING_CODE_USE ( type: esriFieldTypeString, alias: Type of business authorized to occupy the property, editable: true, nullable: true, length: 200, defaultValue: null, modelName: APPROVED_BUILDING_CODE_USE )
• APPROVED_ZONING_USE ( type: esriFieldTypeString, alias: Approved Zoning Use, editable: true, nullable: true, length: 200, defaultValue: null, modelName: APPROVED_ZONING_USE )
• APPLICATION_COMMENTS ( type: esriFieldTypeString, alias: Application Comments, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: APPLICATION_COMMENTS )
• EXPIRATION_DATE ( type: esriFieldTypeDate, alias: Certificate of Occupancy expiration date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EXPIRATION_DATE )
• MAR_ID ( type: esriFieldTypeDouble, alias: Master Address Repository Identifier, editable: true, nullable: true, defaultValue: null, modelName: MAR_ID )
• X_COORDINATE ( type: esriFieldTypeDouble, alias: X Coordinate, editable: true, nullable: true, defaultValue: null, modelName: X_COORDINATE )
• Y_COORDINATE ( type: esriFieldTypeDouble, alias: Y Coordinate, editable: true, nullable: true, defaultValue: null, modelName: Y_COORDINATE )
• LATITUDE ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• DCS_LAST_MOD_DTTM ( type: esriFieldTypeDate, alias: Database Last Modified Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DCS_LAST_MOD_DTTM )
• FLOORS_OCCUPIED ( type: esriFieldTypeString, alias: Floors Occupied, editable: true, nullable: true, length: 200, defaultValue: null, modelName: FLOORS_OCCUPIED )
• ZONE ( type: esriFieldTypeString, alias: Zone, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ZONE )
• SSL ( type: esriFieldTypeString, alias: Square, Suffix, Lot, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SSL )
• APPROVED_ZONING_GENERAL_USE ( type: esriFieldTypeString, alias: Approved Zoning General Use, editable: true, nullable: true, length: 60, defaultValue: null, modelName: APPROVED_ZONING_GENERAL_USE )
• OCCUPIED_SQ_FOOTAGE ( type: esriFieldTypeDouble, alias: Occupied Square Footage, editable: true, nullable: true, defaultValue: null, modelName: OCCUPIED_SQ_FOOTAGE )
• APPROVED_COFO ( type: esriFieldTypeString, alias: Approved Certificate of Occupancy, editable: true, nullable: true, length: 60, defaultValue: null, modelName: APPROVED_COFO )
• OCCPNT_TOT_NUM_OF_DWELL_UNITS ( type: esriFieldTypeString, alias: Occupant Total Number of Dwelling Units, editable: true, nullable: true, length: 80, defaultValue: null, modelName: OCCPNT_TOT_NUM_OF_DWELL_UNITS )
• TOTAL_FEE ( type: esriFieldTypeDouble, alias: Total Fee, editable: true, nullable: true, defaultValue: null, modelName: TOTAL_FEE )
• PERMITNUMBERS ( type: esriFieldTypeString, alias: Permit Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PERMITNUMBERS )
• CONDITIONAL_RESTRICTION ( type: esriFieldTypeString, alias: Conditional Restriction, editable: true, nullable: true, length: 200, defaultValue: null, modelName: CONDITIONAL_RESTRICTION )
• APPROVED_BUILD_CODE_USE_OTHER ( type: esriFieldTypeString, alias: Approved Building Code Use Other, editable: true, nullable: true, length: 20, defaultValue: null, modelName: APPROVED_BUILD_CODE_USE_OTHER )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Certificate of Occupancy
  Description:
  Prototype:
  CONDITIONAL_RESTRICTION: null
  PERMIT_NUMBER: null
  ISSUE_DATE: null
  ADDRESS: null
  WARD: null
  DESCRIPTION_OF_OCCUPANCY: null
  PERMISSION_GRANTED_TO: null
  TRADING_AS: null
  OCCUPANCY_LOAD: null
  PROPERTY_OWNER: null
  OWNER_ADDRESS: null
  B_Z_A_NUMBER: null
  APPROVED_BUILDING_CODE_USE: null
  APPROVED_ZONING_USE: null
  APPLICATION_COMMENTS: null
  EXPIRATION_DATE: null
  MAR_ID: null
  X_COORDINATE: null
  Y_COORDINATE: null
  LATITUDE: null
  LONGITUDE: null
  DCS_LAST_MOD_DTTM: null
  FLOORS_OCCUPIED: null
  ZONE: null
  SSL: null
  APPROVED_ZONING_GENERAL_USE: null
  OCCUPIED_SQ_FOOTAGE: null
  APPROVED_COFO: null
  OCCPNT_TOT_NUM_OF_DWELL_UNITS: null
  TOTAL_FEE: null
  PERMITNUMBERS: null
  APPROVED_BUILD_CODE_USE_OTHER: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata