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:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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:

• BILLING_ADDRESS ( type: esriFieldTypeString, alias: Billing Address, editable: true, nullable: true, length: 200, defaultValue: null, modelName: BILLING_ADDRESS )
• BILLING_ADDRESS_CITY_STATE_ZIP ( type: esriFieldTypeString, alias: Billing Address City, State, Zip, editable: true, nullable: true, length: 200, defaultValue: null, modelName: BILLING_ADDRESS_CITY_STATE_ZIP )
• AGENT_ENTITY ( type: esriFieldTypeString, alias: Agent Entity, editable: true, nullable: true, length: 200, defaultValue: null, modelName: AGENT_ENTITY )
• AGENT_FIRST_NAME ( type: esriFieldTypeString, alias: Agent First Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: AGENT_FIRST_NAME )
• AGENT_LAST_NAME ( type: esriFieldTypeString, alias: Agent Last Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: AGENT_LAST_NAME )
• AGENT_MIDDLE_NAME ( type: esriFieldTypeString, alias: Agent Middle Name, editable: true, nullable: true, length: 15, defaultValue: null, modelName: AGENT_MIDDLE_NAME )
• AGENT_PHONE ( type: esriFieldTypeString, alias: Agent Phone, editable: true, nullable: true, length: 15, defaultValue: null, modelName: AGENT_PHONE )
• SITE_ADDRESS ( type: esriFieldTypeString, alias: Site Address, editable: true, nullable: true, length: 200, defaultValue: null, modelName: SITE_ADDRESS )
• BBL_CITY_STATE_ZIP ( type: esriFieldTypeString, alias: BBL City, State, Zip, editable: true, nullable: true, length: 200, defaultValue: null, modelName: BBL_CITY_STATE_ZIP )
• BILLING_NAME ( type: esriFieldTypeString, alias: Billing Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: BILLING_NAME )
• CUSTOMER_NUMBER ( type: esriFieldTypeString, alias: Customer Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CUSTOMER_NUMBER )
• DC_ADDR_FLAG ( type: esriFieldTypeString, alias: DC Address Flag, editable: true, nullable: true, length: 1, defaultValue: null, modelName: DC_ADDR_FLAG )
• LICENSECATEGORY ( type: esriFieldTypeString, alias: License Category, editable: true, nullable: true, length: 60, defaultValue: null, modelName: LICENSECATEGORY )
• ENTITY_NAME ( type: esriFieldTypeString, alias: Entity Name, editable: true, nullable: true, length: 200, defaultValue: null, modelName: ENTITY_NAME )
• FIRST_NAME ( type: esriFieldTypeString, alias: First Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FIRST_NAME )
• LAST_NAME ( type: esriFieldTypeString, alias: Last Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LAST_NAME )
• DCS_ADD_DATE ( type: esriFieldTypeDate, alias: DCS Add Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DCS_ADD_DATE )
• LICENSE_END_DATE ( type: esriFieldTypeDate, alias: License End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LICENSE_END_DATE )
• LICENSE_ISSUE_DATE ( type: esriFieldTypeDate, alias: License Issue Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LICENSE_ISSUE_DATE )
• LICENSE_START_DATE ( type: esriFieldTypeDate, alias: License Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LICENSE_START_DATE )
• LICENSE_CATEGORY_TEXT ( type: esriFieldTypeString, alias: License Category Text, editable: true, nullable: true, length: 60, defaultValue: null, modelName: LICENSE_CATEGORY_TEXT )
• LICENSE_CATEGORY_CODE ( type: esriFieldTypeString, alias: License Category Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LICENSE_CATEGORY_CODE )
• LICENSESTATUS ( type: esriFieldTypeString, alias: License Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LICENSESTATUS )
• PHONE_NUMBER ( type: esriFieldTypeString, alias: Phone Number, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PHONE_NUMBER )
• CITY ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CITY )
• STATE ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 5, defaultValue: null, modelName: STATE )
• ZIP ( type: esriFieldTypeString, alias: Zip, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ZIP )
• BBL_LICENSE_FACT_ID ( type: esriFieldTypeInteger, alias: BBL License Fact Identifier, editable: true, nullable: true, defaultValue: null, modelName: BBL_LICENSE_FACT_ID )
• LATITUDE ( type: esriFieldTypeDouble, alias: Latitudude, editable: true, nullable: true, defaultValue: null, modelName: LATITUDE )
• LONGITUDE ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: LONGITUDE )
• XCOORD ( type: esriFieldTypeDouble, alias: X Coordinate, editable: true, nullable: true, defaultValue: null, modelName: XCOORD )
• YCOORD ( type: esriFieldTypeDouble, alias: Y Coordinate, editable: true, nullable: true, defaultValue: null, modelName: YCOORD )
• ZIPCODE ( type: esriFieldTypeInteger, alias: Zip Code, editable: true, nullable: true, defaultValue: null, modelName: ZIPCODE )
• MARADDRESSREPOSITORYID ( type: esriFieldTypeDouble, alias: Master Address Repository Identifier, editable: true, nullable: true, defaultValue: null, modelName: MARADDRESSREPOSITORYID )
• WARD ( type: esriFieldTypeString, alias: Ward, editable: true, nullable: true, length: 5, defaultValue: null, modelName: WARD )
• ANC ( type: esriFieldTypeString, alias: Advisory Neighborhood Commission, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ANC )
• SMD ( type: esriFieldTypeString, alias: Single Member District, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SMD )
• DISTRICT ( type: esriFieldTypeString, alias: District, editable: true, nullable: true, length: 60, defaultValue: null, modelName: DISTRICT )
• PSA ( type: esriFieldTypeString, alias: Police Service Area, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PSA )
• NEIGHBORHOODCLUSTER ( type: esriFieldTypeString, alias: Neighborhood Cluster, editable: true, nullable: true, length: 16, defaultValue: null, modelName: NEIGHBORHOODCLUSTER )
• BUSINESSIMPROVEMENTDISTRICT ( type: esriFieldTypeString, alias: Business Improvement District, editable: true, nullable: true, length: 100, defaultValue: null, modelName: BUSINESSIMPROVEMENTDISTRICT )
• MAINSTREET ( type: esriFieldTypeString, alias: Main Street, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAINSTREET )
• DCS_LAST_MOD_DTTM ( type: esriFieldTypeDate, alias: Last Modified Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DCS_LAST_MOD_DTTM )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Basic Business License
  Description:
  Prototype:
  DCS_LAST_MOD_DTTM: null
  BILLING_ADDRESS: null
  BILLING_ADDRESS_CITY_STATE_ZIP: null
  AGENT_ENTITY: null
  AGENT_FIRST_NAME: null
  AGENT_LAST_NAME: null
  AGENT_MIDDLE_NAME: null
  AGENT_PHONE: null
  SITE_ADDRESS: null
  BBL_CITY_STATE_ZIP: null
  BILLING_NAME: null
  CUSTOMER_NUMBER: null
  DC_ADDR_FLAG: null
  LICENSECATEGORY: null
  ENTITY_NAME: null
  FIRST_NAME: null
  LAST_NAME: null
  DCS_ADD_DATE: null
  LICENSE_END_DATE: null
  LICENSE_ISSUE_DATE: null
  LICENSE_START_DATE: null
  LICENSE_CATEGORY_TEXT: null
  LICENSE_CATEGORY_CODE: null
  LICENSESTATUS: null
  PHONE_NUMBER: null
  CITY: null
  STATE: null
  ZIP: null
  BBL_LICENSE_FACT_ID: null
  LATITUDE: null
  LONGITUDE: null
  XCOORD: null
  YCOORD: null
  ZIPCODE: null
  MARADDRESSREPOSITORYID: null
  WARD: null
  ANC: null
  SMD: null
  DISTRICT: null
  PSA: null
  NEIGHBORHOODCLUSTER: null
  BUSINESSIMPROVEMENTDISTRICT: null
  MAINSTREET: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

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