{ "currentVersion": 11.5, "cimVersion": "3.5.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 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", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDurableUrlForSyncModelNone": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "ENTITYNAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "CUSTOMERNUMBER", "type": "esriFieldTypeString", "alias": "Customer Number", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "CUSTOMERNUMBER" }, { "name": "LICENSESTATUS", "type": "esriFieldTypeString", "alias": "License Status", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LICENSESTATUS" }, { "name": "LICENSETYPE", "type": "esriFieldTypeString", "alias": "License Type", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "LICENSETYPE" }, { "name": "LICENSESUBTYPE", "type": "esriFieldTypeString", "alias": "License Subtype", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LICENSESUBTYPE" }, { "name": "LICENSESTATUSDATE", "type": "esriFieldTypeDate", "alias": "License Status Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LICENSESTATUSDATE" }, { "name": "LICENSESTARTDATE", "type": "esriFieldTypeDate", "alias": "License Start Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LICENSESTARTDATE" }, { "name": "LICENSEENDDATE", "type": "esriFieldTypeDate", "alias": "Licensed End Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LICENSEENDDATE" }, { "name": "INITIALISSUEDATE", "type": "esriFieldTypeDate", "alias": "Initial Issue Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "INITIALISSUEDATE" }, { "name": "PRIMARYACTIVITY", "type": "esriFieldTypeString", "alias": "Primary Activity", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "PRIMARYACTIVITY" }, { "name": "BUSINESSACTIVITY", "type": "esriFieldTypeString", "alias": "Business Activity", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BUSINESSACTIVITY" }, { "name": "PREMISEADDRESS", "type": "esriFieldTypeString", "alias": "Premise Address", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "PREMISEADDRESS" }, { "name": "PREMISEINDC", "type": "esriFieldTypeString", "alias": "Premise In DC", "domain": null, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "PREMISEINDC" }, { "name": "ENTITYNAME", "type": "esriFieldTypeString", "alias": "Entity Name", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "ENTITYNAME" }, { "name": "ENTITYTRADENAME", "type": "esriFieldTypeString", "alias": "Entity Trade Name", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "ENTITYTRADENAME" }, { "name": "ENTITYTYPE", "type": "esriFieldTypeString", "alias": "Entity Type", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ENTITYTYPE" }, { "name": "BUSINESSOWNERFIRSTNAME", "type": "esriFieldTypeString", "alias": "Busines Owner First Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BUSINESSOWNERFIRSTNAME" }, { "name": "BUSINESSOWNERLASTNAME", "type": "esriFieldTypeString", "alias": "Business Owner Last Name", "domain": null, "editable": true, "nullable": true, "length": 80, "defaultValue": null, "modelName": "BUSINESSOWNERLASTNAME" }, { "name": "BUSINESSOWNERMIDDLENAME", "type": "esriFieldTypeString", "alias": "Busines Owner MIddle Name", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "BUSINESSOWNERMIDDLENAME" }, { "name": "BUSINESSOWNERADDRESS", "type": "esriFieldTypeString", "alias": "Busines Owner Address", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "BUSINESSOWNERADDRESS" }, { "name": "BILLINGADDRESS", "type": "esriFieldTypeString", "alias": "Billing Address", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "BILLINGADDRESS" }, { "name": "BILLINGENTITY", "type": "esriFieldTypeString", "alias": "Billing Entity", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "BILLINGENTITY" }, { "name": "AGENTFIRSTNAME", "type": "esriFieldTypeString", "alias": "Agent First Name", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "AGENTFIRSTNAME" }, { "name": "AGENTLASTNAME", "type": "esriFieldTypeString", "alias": "Agent Last Name", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "AGENTLASTNAME" }, { "name": "AGENTMIDDLENAME", "type": "esriFieldTypeString", "alias": "Agent Middle Name", "domain": null, "editable": true, "nullable": true, "length": 30, "defaultValue": null, "modelName": "AGENTMIDDLENAME" }, { "name": "AGENTENTITY", "type": "esriFieldTypeString", "alias": "Agent Entity", "domain": null, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "AGENTENTITY" }, { "name": "DATAREFRESHEDON", "type": "esriFieldTypeDate", "alias": "Data Refreshed On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATAREFRESHEDON" }, { "name": "WARD", "type": "esriFieldTypeString", "alias": "Ward", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "WARD" }, { "name": "ANC", "type": "esriFieldTypeString", "alias": "Advisory Neighborhood Commission", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "ANC" }, { "name": "SMD", "type": "esriFieldTypeString", "alias": "Single Member District", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "SMD" }, { "name": "DISTRICT", "type": "esriFieldTypeString", "alias": "District", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "DISTRICT" }, { "name": "PSA", "type": "esriFieldTypeString", "alias": "Police Service Area", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "PSA" }, { "name": "NEIGHBORHOODCLUSTER", "type": "esriFieldTypeString", "alias": "Neighborhood Cluster", "domain": null, "editable": true, "nullable": true, "length": 16, "defaultValue": null, "modelName": "NEIGHBORHOODCLUSTER" }, { "name": "BUSINESSIMPROVEMENTDISTRICT", "type": "esriFieldTypeString", "alias": "Business Improvement District", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "BUSINESSIMPROVEMENTDISTRICT" }, { "name": "MAINSTREET", "type": "esriFieldTypeString", "alias": "Main Street", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MAINSTREET" }, { "name": "MAR_ID", "type": "esriFieldTypeDouble", "alias": "Master Address Repository Identifier", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MAR_ID" }, { "name": "SSL", "type": "esriFieldTypeString", "alias": "Square, Suffix, Lot", "domain": null, "editable": true, "nullable": true, "length": 300, "defaultValue": null, "modelName": "SSL" }, { "name": "LATITUDE", "type": "esriFieldTypeDouble", "alias": "Latitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LATITUDE" }, { "name": "LONGITUDE", "type": "esriFieldTypeDouble", "alias": "Longitude", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "LONGITUDE" }, { "name": "X_COORDINATE", "type": "esriFieldTypeDouble", "alias": "X Coordinate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "X_COORDINATE" }, { "name": "Y_COORDINATE", "type": "esriFieldTypeDouble", "alias": "Y Coordinate", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Y_COORDINATE" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" }, { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" } ], "indexes": [ { "name": "BBL_FEED_IX1", "isAscending": true, "isUnique": false, "description": "", "fields": "LICENSEENDDATE" }, { "name": "BBL_FEED_IX2", "isAscending": true, "isUnique": false, "description": "", "fields": "INITIALISSUEDATE" }, { "name": "BBL_FEED_IX3", "isAscending": true, "isUnique": false, "description": "", "fields": "LICENSESTARTDATE" }, { "name": "BBL_FEED_IX4", "isAscending": true, "isUnique": false, "description": "", "fields": "ENTITYNAME,BILLINGENTITY" }, { "name": "BBL_FEED_IX5", "isAscending": true, "isUnique": false, "description": "", "fields": "PREMISEADDRESS" }, { "name": "BBL_FEED_IX6", "isAscending": true, "isUnique": false, "description": "", "fields": "MAR_ID" }, { "name": "BBL_FEED_IX7", "isAscending": true, "isUnique": false, "description": "", "fields": "MAR_ID,LICENSEENDDATE,CUSTOMERNUMBER" }, { "name": "R54673_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" }, { "name": "UUID_54673", "isAscending": true, "isUnique": true, "description": "", "fields": "GLOBALID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Eastern Standard Time", "timeZoneIANA": "America/New_York", "respectsDaylightSaving": true }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "Basic Business License", "description": "", "prototype": { "attributes": { "Y_COORDINATE": null, "CUSTOMERNUMBER": null, "LICENSESTATUS": null, "LICENSETYPE": null, "LICENSESUBTYPE": null, "LICENSESTATUSDATE": null, "LICENSESTARTDATE": null, "LICENSEENDDATE": null, "INITIALISSUEDATE": null, "PRIMARYACTIVITY": null, "BUSINESSACTIVITY": null, "PREMISEADDRESS": null, "PREMISEINDC": null, "ENTITYNAME": null, "ENTITYTRADENAME": null, "ENTITYTYPE": null, "BUSINESSOWNERFIRSTNAME": null, "BUSINESSOWNERLASTNAME": null, "BUSINESSOWNERMIDDLENAME": null, "BUSINESSOWNERADDRESS": null, "BILLINGADDRESS": null, "BILLINGENTITY": null, "AGENTFIRSTNAME": null, "AGENTLASTNAME": null, "AGENTMIDDLENAME": null, "AGENTENTITY": null, "DATAREFRESHEDON": null, "WARD": null, "ANC": null, "SMD": null, "DISTRICT": null, "PSA": null, "NEIGHBORHOODCLUSTER": null, "BUSINESSIMPROVEMENTDISTRICT": null, "MAINSTREET": null, "MAR_ID": null, "SSL": null, "LATITUDE": null, "LONGITUDE": null, "X_COORDINATE": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Extract", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1 }