Name: Basic Business License

Display Field: AGENT_FIRST_NAME

Type: Table

Geometry Type: N/A

Description: In order to operate legally in District of Columbia, most businesses must get a Basic Business License (BBL) from the Department of Consumer and Regulatory Affairs (DCRA). The Basic Business License (BBL) program streamlines District of Columbia business licensing procedures. The BBL groups licenses by the type of business activity and regulatory approvals required. The dataset shows issued business licenses in the following categories: all housing licenses, motor vehicle sales, service and repair, and home improvement contractors. For more information, please visit https://dcra.dc.gov/node/140922

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
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: null

Fields:

• BILLING_ADDRESS ( type: esriFieldTypeString, alias: BILLING_ADDRESS, length: 200 )
• BILLING_ADDRESS_CITY_STATE_ZIP ( type: esriFieldTypeString, alias: BILLING_ADDRESS_CITY_STATE_ZIP, length: 200 )
• AGENT_ENTITY ( type: esriFieldTypeString, alias: AGENT_ENTITY, length: 200 )
• AGENT_FIRST_NAME ( type: esriFieldTypeString, alias: AGENT_FIRST_NAME, length: 200 )
• AGENT_LAST_NAME ( type: esriFieldTypeString, alias: AGENT_LAST_NAME, length: 200 )
• AGENT_MIDDLE_NAME ( type: esriFieldTypeString, alias: AGENT_MIDDLE_NAME, length: 15 )
• AGENT_PHONE ( type: esriFieldTypeString, alias: AGENT_PHONE, length: 15 )
• SITE_ADDRESS ( type: esriFieldTypeString, alias: SITE_ADDRESS, length: 200 )
• BBL_CITY_STATE_ZIP ( type: esriFieldTypeString, alias: BBL_CITY_STATE_ZIP, length: 200 )
• BILLING_NAME ( type: esriFieldTypeString, alias: BILLING_NAME, length: 200 )
• CUSTOMER_NUMBER ( type: esriFieldTypeString, alias: LICENSE_NUMBER, length: 30 )
• DC_ADDR_FLAG ( type: esriFieldTypeString, alias: DC_ADDR_FLAG, length: 1 )
• LICENSECATEGORY ( type: esriFieldTypeString, alias: LICENSECATEGORY, length: 60 )
• ENTITY_NAME ( type: esriFieldTypeString, alias: ENTITY_NAME, length: 200 )
• FIRST_NAME ( type: esriFieldTypeString, alias: FIRST_NAME, length: 100 )
• LAST_NAME ( type: esriFieldTypeString, alias: LAST_NAME, length: 100 )
• DCS_ADD_DATE ( type: esriFieldTypeDate, alias: DCS_ADD_DATE, length: 8 )
• LICENSE_END_DATE ( type: esriFieldTypeDate, alias: LICENSE_END_DATE, length: 8 )
• LICENSE_ISSUE_DATE ( type: esriFieldTypeDate, alias: LICENSE_ISSUE_DATE, length: 8 )
• LICENSE_START_DATE ( type: esriFieldTypeDate, alias: LICENSE_START_DATE, length: 8 )
• LICENSE_CATEGORY_TEXT ( type: esriFieldTypeString, alias: LICENSE_CATEGORY_TEXT, length: 60 )
• LICENSE_CATEGORY_CODE ( type: esriFieldTypeString, alias: LICENSE_CATEGORY_CODE, length: 10 )
• LICENSESTATUS ( type: esriFieldTypeString, alias: LICENSESTATUS, length: 30 )
• PHONE_NUMBER ( type: esriFieldTypeString, alias: PHONE_NUMBER, length: 15 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CITY ( type: esriFieldTypeString, alias: CITY, length: 100 )
• STATE ( type: esriFieldTypeString, alias: STATE, length: 5 )
• ZIP ( type: esriFieldTypeString, alias: ZIP, length: 20 )
• BBL_LICENSE_FACT_ID ( type: esriFieldTypeInteger, alias: BBL_LICENSE_FACT_ID )
• DCS_LAST_MOD_DTTM ( type: esriFieldTypeDate, alias: DCS_LAST_MOD_DTTM, length: 8 )
• LATITUDE ( type: esriFieldTypeDouble, alias: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: LONGITUDE )
• XCOORD ( type: esriFieldTypeDouble, alias: XCOORD )
• YCOORD ( type: esriFieldTypeDouble, alias: YCOORD )
• ZIPCODE ( type: esriFieldTypeInteger, alias: ZIPCODE )
• MARADDRESSREPOSITORYID ( type: esriFieldTypeDouble, alias: MARADDRESSREPOSITORYID )
• WARD ( type: esriFieldTypeString, alias: WARD, length: 5 )
• ANC ( type: esriFieldTypeString, alias: ANC, length: 10 )
• SMD ( type: esriFieldTypeString, alias: SMD, length: 20 )
• DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, length: 60 )
• PSA ( type: esriFieldTypeString, alias: PSA, length: 10 )
• NEIGHBORHOODCLUSTER ( type: esriFieldTypeString, alias: NEIGHBORHOODCLUSTER, length: 16 )
• BUSINESSIMPROVEMENTDISTRICT ( type: esriFieldTypeString, alias: BUSINESSIMPROVEMENTDISTRICT, length: 100 )
• MAINSTREET ( type: esriFieldTypeString, alias: MAINSTREET, length: 50 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata