{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 1,
 "name": "Basic Business License - Last 30 Days",
 "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 Licensing and Consumer Protection (DLCP). 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.",
 "copyrightText": "Department of Licensing and Consumer Protection",
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "ENTITYNAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "CUSTOMERNUMBER",
   "type": "esriFieldTypeString",
   "alias": "Customer Number",
   "length": 30,
   "domain": null
  },
  {
   "name": "LICENSESTATUS",
   "type": "esriFieldTypeString",
   "alias": "License Status",
   "length": 50,
   "domain": null
  },
  {
   "name": "LICENSETYPE",
   "type": "esriFieldTypeString",
   "alias": "License Type",
   "length": 30,
   "domain": null
  },
  {
   "name": "LICENSESUBTYPE",
   "type": "esriFieldTypeString",
   "alias": "License Subtype",
   "length": 50,
   "domain": null
  },
  {
   "name": "LICENSESTATUSDATE",
   "type": "esriFieldTypeDate",
   "alias": "License Status Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "LICENSESTARTDATE",
   "type": "esriFieldTypeDate",
   "alias": "License Start Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "LICENSEENDDATE",
   "type": "esriFieldTypeDate",
   "alias": "Licensed End Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "INITIALISSUEDATE",
   "type": "esriFieldTypeDate",
   "alias": "Initial Issue Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "PRIMARYACTIVITY",
   "type": "esriFieldTypeString",
   "alias": "Primary Activity",
   "length": 50,
   "domain": null
  },
  {
   "name": "BUSINESSACTIVITY",
   "type": "esriFieldTypeString",
   "alias": "Business Activity",
   "length": 50,
   "domain": null
  },
  {
   "name": "PREMISEADDRESS",
   "type": "esriFieldTypeString",
   "alias": "Premise Address",
   "length": 200,
   "domain": null
  },
  {
   "name": "PREMISEINDC",
   "type": "esriFieldTypeString",
   "alias": "Premise In DC",
   "length": 5,
   "domain": null
  },
  {
   "name": "ENTITYNAME",
   "type": "esriFieldTypeString",
   "alias": "Entity Name",
   "length": 200,
   "domain": null
  },
  {
   "name": "ENTITYTRADENAME",
   "type": "esriFieldTypeString",
   "alias": "Entity Trade Name",
   "length": 300,
   "domain": null
  },
  {
   "name": "ENTITYTYPE",
   "type": "esriFieldTypeString",
   "alias": "Entity Type",
   "length": 100,
   "domain": null
  },
  {
   "name": "BUSINESSOWNERFIRSTNAME",
   "type": "esriFieldTypeString",
   "alias": "Busines Owner First Name",
   "length": 50,
   "domain": null
  },
  {
   "name": "BUSINESSOWNERLASTNAME",
   "type": "esriFieldTypeString",
   "alias": "Business Owner Last Name",
   "length": 80,
   "domain": null
  },
  {
   "name": "BUSINESSOWNERMIDDLENAME",
   "type": "esriFieldTypeString",
   "alias": "Busines Owner MIddle Name",
   "length": 50,
   "domain": null
  },
  {
   "name": "BUSINESSOWNERADDRESS",
   "type": "esriFieldTypeString",
   "alias": "Busines Owner Address",
   "length": 200,
   "domain": null
  },
  {
   "name": "BILLINGADDRESS",
   "type": "esriFieldTypeString",
   "alias": "Billing Address",
   "length": 200,
   "domain": null
  },
  {
   "name": "BILLINGENTITY",
   "type": "esriFieldTypeString",
   "alias": "Billing Entity",
   "length": 200,
   "domain": null
  },
  {
   "name": "AGENTFIRSTNAME",
   "type": "esriFieldTypeString",
   "alias": "Agent First Name",
   "length": 60,
   "domain": null
  },
  {
   "name": "AGENTLASTNAME",
   "type": "esriFieldTypeString",
   "alias": "Agent Last Name",
   "length": 60,
   "domain": null
  },
  {
   "name": "AGENTMIDDLENAME",
   "type": "esriFieldTypeString",
   "alias": "Agent Middle Name",
   "length": 30,
   "domain": null
  },
  {
   "name": "AGENTENTITY",
   "type": "esriFieldTypeString",
   "alias": "Agent Entity",
   "length": 200,
   "domain": null
  },
  {
   "name": "DATAREFRESHEDON",
   "type": "esriFieldTypeDate",
   "alias": "Data Refreshed On",
   "length": 8,
   "domain": null
  },
  {
   "name": "WARD",
   "type": "esriFieldTypeString",
   "alias": "Ward",
   "length": 10,
   "domain": null
  },
  {
   "name": "ANC",
   "type": "esriFieldTypeString",
   "alias": "Advisory Neighborhood Commission",
   "length": 20,
   "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": "MAR_ID",
   "type": "esriFieldTypeDouble",
   "alias": "Master Address Repository Identifier",
   "domain": null
  },
  {
   "name": "SSL",
   "type": "esriFieldTypeString",
   "alias": "Square, Suffix, Lot",
   "length": 300,
   "domain": null
  },
  {
   "name": "LATITUDE",
   "type": "esriFieldTypeDouble",
   "alias": "Latitude",
   "domain": null
  },
  {
   "name": "LONGITUDE",
   "type": "esriFieldTypeDouble",
   "alias": "Longitude",
   "domain": null
  },
  {
   "name": "X_COORDINATE",
   "type": "esriFieldTypeDouble",
   "alias": "X Coordinate",
   "domain": null
  },
  {
   "name": "Y_COORDINATE",
   "type": "esriFieldTypeDouble",
   "alias": "Y Coordinate",
   "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": "LICENSEENDDATE",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "BBL_FEED_IX2",
   "fields": "INITIALISSUEDATE",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "BBL_FEED_IX3",
   "fields": "LICENSESTARTDATE",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "BBL_FEED_IX4",
   "fields": "ENTITYNAME,BILLINGENTITY",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "BBL_FEED_IX5",
   "fields": "PREMISEADDRESS",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "BBL_FEED_IX6",
   "fields": "MAR_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "BBL_FEED_IX7",
   "fields": "MAR_ID,LICENSEENDDATE,CUSTOMERNUMBER",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "R54673_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_54673",
   "fields": "GLOBALID",
   "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,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": {
  "timeZone": "Eastern Standard Time",
  "timeZoneIANA": "America/New_York",
  "respectsDaylightSaving": true
 },
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 }
}