{
 "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": "Customer Number",
   "length": 30,
   "domain": null
  },
  {
   "name": "DC_ADDR_FLAG",
   "type": "esriFieldTypeString",
   "alias": "DC Address Flag",
   "length": 1,
   "domain": null
  },
  {
   "name": "LICENSECATEGORY",
   "type": "esriFieldTypeString",
   "alias": "License Category",
   "length": 60,
   "domain": null
  },
  {
   "name": "ENTITY_NAME",
   "type": "esriFieldTypeString",
   "alias": "Entity Name",
   "length": 200,
   "domain": null
  },
  {
   "name": "FIRST_NAME",
   "type": "esriFieldTypeString",
   "alias": "Frist 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": "License Status",
   "length": 30,
   "domain": null
  },
  {
   "name": "PHONE_NUMBER",
   "type": "esriFieldTypeString",
   "alias": "Phone Number",
   "length": 15,
   "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 Identifier",
   "domain": null
  },
  {
   "name": "LATITUDE",
   "type": "esriFieldTypeDouble",
   "alias": "Latitudude",
   "domain": null
  },
  {
   "name": "LONGITUDE",
   "type": "esriFieldTypeDouble",
   "alias": "Longitude",
   "domain": null
  },
  {
   "name": "XCOORD",
   "type": "esriFieldTypeDouble",
   "alias": "X Coordinate",
   "domain": null
  },
  {
   "name": "YCOORD",
   "type": "esriFieldTypeDouble",
   "alias": "Y Coordinate",
   "domain": null
  },
  {
   "name": "ZIPCODE",
   "type": "esriFieldTypeInteger",
   "alias": "Zip Code",
   "domain": null
  },
  {
   "name": "MARADDRESSREPOSITORYID",
   "type": "esriFieldTypeDouble",
   "alias": "Master Address Repository Identifier",
   "domain": null
  },
  {
   "name": "WARD",
   "type": "esriFieldTypeString",
   "alias": "Ward",
   "length": 5,
   "domain": null
  },
  {
   "name": "ANC",
   "type": "esriFieldTypeString",
   "alias": "Advisory Neighborhood Commission",
   "length": 10,
   "domain": null
  },
  {
   "name": "SMD",
   "type": "esriFieldTypeString",
   "alias": "Single Member District",
   "length": 20,
   "domain": null
  },
  {
   "name": "DISTRICT",
   "type": "esriFieldTypeString",
   "alias": "District",
   "length": 60,
   "domain": null
  },
  {
   "name": "PSA",
   "type": "esriFieldTypeString",
   "alias": "Police Service Area",
   "length": 10,
   "domain": null
  },
  {
   "name": "NEIGHBORHOODCLUSTER",
   "type": "esriFieldTypeString",
   "alias": "Neighborhood Cluster",
   "length": 16,
   "domain": null
  },
  {
   "name": "BUSINESSIMPROVEMENTDISTRICT",
   "type": "esriFieldTypeString",
   "alias": "Business Improvement District",
   "length": 100,
   "domain": null
  },
  {
   "name": "MAINSTREET",
   "type": "esriFieldTypeString",
   "alias": "Main Street",
   "length": 50,
   "domain": null
  },
  {
   "name": "DCS_LAST_MOD_DTTM",
   "type": "esriFieldTypeDate",
   "alias": "Last Modified Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "GLOBALID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GLOBALID",
   "length": 38,
   "domain": null
  },
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "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": ""
  },
  {
   "name": "UUID_8740",
   "fields": "GLOBALID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "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
 }
}