{ "currentVersion": 11.2, "cimVersion": "3.2.0", "id": 0, "name": "Basic Business License", "type": "Table", "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", "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "AGENT_FIRST_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "BILLING_ADDRESS", "type": "esriFieldTypeString", "alias": "BILLING_ADDRESS", "length": 200, "domain": null }, { "name": "BILLING_ADDRESS_CITY_STATE_ZIP", "type": "esriFieldTypeString", "alias": "BILLING_ADDRESS_CITY_STATE_ZIP", "length": 200, "domain": null }, { "name": "AGENT_ENTITY", "type": "esriFieldTypeString", "alias": "AGENT_ENTITY", "length": 200, "domain": null }, { "name": "AGENT_FIRST_NAME", "type": "esriFieldTypeString", "alias": "AGENT_FIRST_NAME", "length": 200, "domain": null }, { "name": "AGENT_LAST_NAME", "type": "esriFieldTypeString", "alias": "AGENT_LAST_NAME", "length": 200, "domain": null }, { "name": "AGENT_MIDDLE_NAME", "type": "esriFieldTypeString", "alias": "AGENT_MIDDLE_NAME", "length": 15, "domain": null }, { "name": "AGENT_PHONE", "type": "esriFieldTypeString", "alias": "AGENT_PHONE", "length": 15, "domain": null }, { "name": "SITE_ADDRESS", "type": "esriFieldTypeString", "alias": "SITE_ADDRESS", "length": 200, "domain": null }, { "name": "BBL_CITY_STATE_ZIP", "type": "esriFieldTypeString", "alias": "BBL_CITY_STATE_ZIP", "length": 200, "domain": null }, { "name": "BILLING_NAME", "type": "esriFieldTypeString", "alias": "BILLING_NAME", "length": 200, "domain": null }, { "name": "CUSTOMER_NUMBER", "type": "esriFieldTypeString", "alias": "LICENSE_NUMBER", "length": 30, "domain": null }, { "name": "DC_ADDR_FLAG", "type": "esriFieldTypeString", "alias": "DC_ADDR_FLAG", "length": 1, "domain": null }, { "name": "LICENSECATEGORY", "type": "esriFieldTypeString", "alias": "LICENSECATEGORY", "length": 60, "domain": null }, { "name": "ENTITY_NAME", "type": "esriFieldTypeString", "alias": "ENTITY_NAME", "length": 200, "domain": null }, { "name": "FIRST_NAME", "type": "esriFieldTypeString", "alias": "FIRST_NAME", "length": 100, "domain": null }, { "name": "LAST_NAME", "type": "esriFieldTypeString", "alias": "LAST_NAME", "length": 100, "domain": null }, { "name": "DCS_ADD_DATE", "type": "esriFieldTypeDate", "alias": "DCS_ADD_DATE", "length": 8, "domain": null }, { "name": "LICENSE_END_DATE", "type": "esriFieldTypeDate", "alias": "LICENSE_END_DATE", "length": 8, "domain": null }, { "name": "LICENSE_ISSUE_DATE", "type": "esriFieldTypeDate", "alias": "LICENSE_ISSUE_DATE", "length": 8, "domain": null }, { "name": "LICENSE_START_DATE", "type": "esriFieldTypeDate", "alias": "LICENSE_START_DATE", "length": 8, "domain": null }, { "name": "LICENSE_CATEGORY_TEXT", "type": "esriFieldTypeString", "alias": "LICENSE_CATEGORY_TEXT", "length": 60, "domain": null }, { "name": "LICENSE_CATEGORY_CODE", "type": "esriFieldTypeString", "alias": "LICENSE_CATEGORY_CODE", "length": 10, "domain": null }, { "name": "LICENSESTATUS", "type": "esriFieldTypeString", "alias": "LICENSESTATUS", "length": 30, "domain": null }, { "name": "PHONE_NUMBER", "type": "esriFieldTypeString", "alias": "PHONE_NUMBER", "length": 15, "domain": null }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "CITY", "type": "esriFieldTypeString", "alias": "CITY", "length": 100, "domain": null }, { "name": "STATE", "type": "esriFieldTypeString", "alias": "STATE", "length": 5, "domain": null }, { "name": "ZIP", "type": "esriFieldTypeString", "alias": "ZIP", "length": 20, "domain": null }, { "name": "BBL_LICENSE_FACT_ID", "type": "esriFieldTypeInteger", "alias": "BBL_LICENSE_FACT_ID", "domain": null }, { "name": "DCS_LAST_MOD_DTTM", "type": "esriFieldTypeDate", "alias": "DCS_LAST_MOD_DTTM", "length": 8, "domain": null }, { "name": "LATITUDE", "type": "esriFieldTypeDouble", "alias": "LATITUDE", "domain": null }, { "name": "LONGITUDE", "type": "esriFieldTypeDouble", "alias": "LONGITUDE", "domain": null }, { "name": "XCOORD", "type": "esriFieldTypeDouble", "alias": "XCOORD", "domain": null }, { "name": "YCOORD", "type": "esriFieldTypeDouble", "alias": "YCOORD", "domain": null }, { "name": "ZIPCODE", "type": "esriFieldTypeInteger", "alias": "ZIPCODE", "domain": null }, { "name": "MARADDRESSREPOSITORYID", "type": "esriFieldTypeDouble", "alias": "MARADDRESSREPOSITORYID", "domain": null }, { "name": "WARD", "type": "esriFieldTypeString", "alias": "WARD", "length": 5, "domain": null }, { "name": "ANC", "type": "esriFieldTypeString", "alias": "ANC", "length": 10, "domain": null }, { "name": "SMD", "type": "esriFieldTypeString", "alias": "SMD", "length": 20, "domain": null }, { "name": "DISTRICT", "type": "esriFieldTypeString", "alias": "DISTRICT", "length": 60, "domain": null }, { "name": "PSA", "type": "esriFieldTypeString", "alias": "PSA", "length": 10, "domain": null }, { "name": "NEIGHBORHOODCLUSTER", "type": "esriFieldTypeString", "alias": "NEIGHBORHOODCLUSTER", "length": 16, "domain": null }, { "name": "BUSINESSIMPROVEMENTDISTRICT", "type": "esriFieldTypeString", "alias": "BUSINESSIMPROVEMENTDISTRICT", "length": 100, "domain": null }, { "name": "MAINSTREET", "type": "esriFieldTypeString", "alias": "MAINSTREET", "length": 50, "domain": null } ], "indexes": [ { "name": "BBL_FEED_IX1", "fields": "LICENSE_END_DATE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "BBL_FEED_IX2", "fields": "LICENSE_ISSUE_DATE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "BBL_FEED_IX3", "fields": "LICENSE_START_DATE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "BBL_FEED_IX4", "fields": "ENTITY_NAME,BILLING_NAME", "isAscending": true, "isUnique": false, "description": "" }, { "name": "BBL_FEED_IX5", "fields": "SITE_ADDRESS", "isAscending": true, "isUnique": false, "description": "" }, { "name": "BBL_FEED_IX6", "fields": "MARADDRESSREPOSITORYID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "BBL_FEED_IX7", "fields": "MARADDRESSREPOSITORYID,LICENSE_END_DATE,CUSTOMER_NUMBER", "isAscending": true, "isUnique": false, "description": "" }, { "name": "R8740_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 2000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true, "supportsCurrentUserQueries": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }