View In:   ArcGIS Online Map Viewer

Name: Certificate Of Occupancy Points

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: Department of Buildings

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.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:
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 200, defaultValue: null, modelName: ADDRESS )
• B_Z_A_NUMBER ( type: esriFieldTypeString, alias: B_Z_A_NUMBER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: B_Z_A_NUMBER )
• MAR_ID ( type: esriFieldTypeDouble, alias: MAR_ID, editable: true, nullable: true, defaultValue: null, modelName: MAR_ID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• PERMIT_NUMBER ( type: esriFieldTypeString, alias: Permit Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PERMIT_NUMBER )
• ISSUE_DATE ( type: esriFieldTypeDate, alias: Issue Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ISSUE_DATE )
• WARD ( type: esriFieldTypeString, alias: Ward, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WARD )
• DESCRIPTION_OF_OCCUPANCY ( type: esriFieldTypeString, alias: Description of Occupancy, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: DESCRIPTION_OF_OCCUPANCY )
• PERMISSION_GRANTED_TO ( type: esriFieldTypeString, alias: Permission Granted To, editable: true, nullable: true, length: 200, defaultValue: null, modelName: PERMISSION_GRANTED_TO )
• TRADING_AS ( type: esriFieldTypeString, alias: Trading As, editable: true, nullable: true, length: 200, defaultValue: null, modelName: TRADING_AS )
• FLOORS_OCCUPIED ( type: esriFieldTypeString, alias: Floors Occupied, editable: true, nullable: true, length: 200, defaultValue: null, modelName: FLOORS_OCCUPIED )
• OCCUPANCY_LOAD ( type: esriFieldTypeString, alias: Occupancy Load, editable: true, nullable: true, length: 200, defaultValue: null, modelName: OCCUPANCY_LOAD )
• PROPERTY_OWNER ( type: esriFieldTypeString, alias: Property Owner, editable: true, nullable: true, length: 200, defaultValue: null, modelName: PROPERTY_OWNER )
• OWNER_ADDRESS ( type: esriFieldTypeString, alias: Owner Address, editable: true, nullable: true, length: 200, defaultValue: null, modelName: OWNER_ADDRESS )
• APPROVED_BUILDING_CODE_USE ( type: esriFieldTypeString, alias: Approved Building Code Use, 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 )
• EXPIRATION_DATE ( type: esriFieldTypeDate, alias: Expiration Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EXPIRATION_DATE )
• 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 )
• APPLICATION_COMMENTS ( type: esriFieldTypeString, alias: Application Comments, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: APPLICATION_COMMENTS )
• ZONE ( type: esriFieldTypeString, alias: ZONE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ZONE )
• SSL ( type: esriFieldTypeString, alias: SSL, 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_SQ_FOOTAGE, editable: true, nullable: true, defaultValue: null, modelName: OCCUPIED_SQ_FOOTAGE )
• APPROVED_COFO ( type: esriFieldTypeString, alias: APPROVED_COFO, editable: true, nullable: true, length: 60, defaultValue: null, modelName: APPROVED_COFO )
• OCCPNT_TOT_NUM_OF_DWELL_UNITS ( type: esriFieldTypeString, alias: OCCPNT_TOT_NUM_OF_DWELL_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: PERMITNUMBERS, 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_BUILD_CODE_USE_OTHER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: APPROVED_BUILD_CODE_USE_OTHER )

Templates:

• Name: Certificate Of Occupancy Points
  Description:
  Prototype:
  CONDITIONAL_RESTRICTION: null
  ADDRESS: null
  B_Z_A_NUMBER: null
  MAR_ID: null
  PERMIT_NUMBER: null
  ISSUE_DATE: null
  WARD: null
  DESCRIPTION_OF_OCCUPANCY: null
  PERMISSION_GRANTED_TO: null
  TRADING_AS: null
  FLOORS_OCCUPIED: null
  OCCUPANCY_LOAD: null
  PROPERTY_OWNER: null
  OWNER_ADDRESS: null
  APPROVED_BUILDING_CODE_USE: null
  APPROVED_ZONING_USE: null
  EXPIRATION_DATE: null
  X_COORDINATE: null
  Y_COORDINATE: null
  LATITUDE: null
  LONGITUDE: null
  DCS_LAST_MOD_DTTM: null
  APPLICATION_COMMENTS: 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