US-SF.BER (data source)

Property	Value
Identifiers	US-SF.BER (The ALEI prefix element is the ISO 3166-2 code for country and subdivision if applicable followed by the stop character <code>.</code>. This is followed by an acronym representing the register maintained by the administrative agency for the governing body of a nation, state, or community that assigned the identifier element. The prefix is assigned by ECCMA ALEI prefix), US_SF_BER (A technical identifier, unique in a certain context. Technical key)
Language-specific short name. Monolingual short name	Registered Business Locations - San Francisco (en)
Language-specific name. Monolingual name	Registered Business Locations - San Francisco (en)
An informal and short human-readable definition of a concept, in terms of a 'one-liner'. Short description	Registered Business Locations - San Francisco
The country a linked concept is active or generally relevant for. Country scope	US (United States of America)
Data access	Treasurer & Tax Collector’s Office, City and County of San Francisco (Provider or authority of a data source. Provider), website (URL that provides more information for a given concept. URL), API (URL that provides direct access to the data of a data source. Deep URL), FUZZY (Search type (data sources)<br/>Describes how data can be searched in a data source.<br/>IDENTIFIER: Data can be searched by business identifiers.<br/>INDEX: Data can be searched by business identifiers.<br/>FUZZY: Data can be searched by address and name attributes. Search type)
nonetheless, we continue to offer the most recent available data., The release status in terms of development progress or maturity.<br/><code>EMPTY</code> (0): No feature considered yet, just a rough idea.<br/><code>IDEA</code> (1): Just an idea, not yet designed in detail.<br/><code>DESIGN</code> (2): Software design ready, development not yet started.<br/><code>DEVELOPMENT</code> (3): Software development in progress.<br/><code>ALPHA</code> (4): First functional release, in terms of a Minimal Viable Product (MVP).<br/><code>BETA</code> (5): Tested by selected users.<br/><code>RC</code> (6): Release candidate, fully tested, not yet used in production by many customers.<br/><code>LIVE</code> (7): Used in production by customers, fully monitored and supported.<br/><code>DEPRECATED</code> (-1): End of life planned, but still available.<br/><code>EOL</code> (-2): End of life, historic service, no longer available.<br/><code>BROKEN</code> (-3): Service was used in production but is currently not available. However, CDQ tries to repair or reactivate it.<br/><code>DISCONTINUED</code> (-4): The data source has ceased providing updates Release status	LIVE, COPY (Documents how a data source is integrated into the CDL with respect to data gathering:<br/><code>REMOTE ACCESS</code>: Data is not stored on CDL side but queried ad-hoc from the data source (e.g. webservices)<br/><code>COPY</code>: Data is replicated on CDL side (usually already transformed into the target CDL data model)<br/><code>UNDEFINED</code>: not yet known Integration type)
Content	BUSINESS_PARTNER (Data source category<br/>Specifies the category of a data source in terms of the content.<br/>ADDRESS: The data source provides address reference data.<br/>BANK_ACCOUNT: The data source provides bank and bank account reference data.<br/>BENEFICIAL_OWNER: The data source provides information about beneficial owners of companies.<br/>BUSINESS_PARTNER: The data source provides master data about companies.<br/>CERTIFICATE: The data source provides information about business partner certifications.<br/>HEALTHCARE_ORGANIZATION: The data source provides information about HCOs.<br/>HEALTHCARE_PROFESSIONAL: The data source provides information about HCPs.<br/>INSOLVENCY: The data source provides information about insolvencies.<br/>SANCTION_AND_WATCHLIST: A data source that provides sanctioned or watched companies or persons. Data source category), 351,486 (Counts the number of company records available in the data source. Number of records) , 33 concepts, 0 terms
Legal classification	2020-01-01 (Date when a legal classification was approved (the last time). Legal approval), GOVERNMENTAL (Data ownership<br/>Categorizes legal right-holding by the type of the data owner, e.g. a private organization or a governmental authority.<br/>GOVERNMENTAL: The data source is owned by a governmental body, e.g., a federal, state, or municipal authority.<br/>PRIVATE: The data source is owned by a private body, e.g., a company or an association. Data ownership), OPEN (Data provision<br/>Categorizes restriction of data access, i.e., whether a data source provides "open" data or requires registration.<br/>FREE: Data is provided for free, but the data source requires registration, i.e., authentication when data is downloaded or queried.<br/>OPEN: Data is provided for free and unlimited access without registration or subscription.<br/>COMMERCIAL: Data is not provided for free, but users of the data source have to pay for downloading, querying, or using the data according to a commercial contract. Data provision), CDQ_CONTRACTED (Terms type<br/>A client or CDQ accepts the terms of use of a particular data source and the compliant use of its data.<br/>NO_TERMS: No specific terms of use are provided for a data source.<br/>STANDARD: A standard licence is used, further details are provided by license type information of the data source.<br/>EU_PUBLIC: The data source is provided by a governmental organization under EU law, i.e., from "within" a EU member country.<br/>EU_PRIVATE: The data source is provided by a private organization under EU law, i.e., from "within" a EU member country.<br/>CDQ_CONTRACTED: CDQ accepts the terms of a particular data source and the compliant use of its data.<br/>CLIENT_CONTRACTED: A client (i.e., the data end user) accepts the terms of a particular data source and the compliant use of its data. Terms type), https://opendatacommons.org/licenses/pddl/1-0/ (URL that provides more information on a license, e.g., of a data source. License URL)
Quota	250,000 (The default maximum quota for a data source. Maximum Quota (default)), MONTH (Quota reset<br/>The default reset period of a defined quota for a data source.<br/>DAY: The quota of the data source is reset daily.<br/>WEEK: The quota of the data source is reset weekly.<br/>MONTH: The quota of the data source is reset monthly.<br/>YEAR: The quota of the data source is reset yearly. Quota reset (default)), CDQ (Quota control<br/>The control of changing the maximum quota and reset period for a data source.<br/>CDQ: The quota of the data source can be higher than set by CDQ.<br/>CLIENT: The quota of the data source can be set higher than the default.<br/>CREDENTIAL_DEPENDENT: If a customer uses CDQ credentials to assess the data source then the quota can't be higher than the default, but if customers use their own credentials, then the quota can be increased. Quota control), NO (Quota enablement<br/>whether the quota management is turned on for a specific data source.<br/>YES: A quota is enabled for the data source.<br/>NO: The data source does not have an enabled quota. Quota enabled)
Linkage strategy	Linkage strategy for data source US-SF.BER and country US
Update monitoring	NO (Update monitor enablement<br/>whether the update monitoring is turned on for a specific data source.<br/>YES: An update monitor is enabled for the data source.<br/>NO: For the data source, no update monitor is enabled. Update monitoring enabled), Every Saturday at 3:20 am (Date and time when a data source is checked to find updates. Update frequency)

Managed business identifiers

Identifier	Technical name	Parent	Description	CDQ mapping
Business Account Number (US-SF.BER)	Business_Account_Number	entity (US-SF.BER)	Seven digit number assigned to registered business accounts	Identifier Value (CDQ)
Location Id (US-SF.BER)	Location_Id	entity (US-SF.BER)	Location Identification Number. Each DBA has a unique LIN for location specific tax filings	Identifier Value (CDQ)
UniqueID (US-SF.BER)	UniqueID	entity (US-SF.BER)	Unique formula: @Value(ttxid)-@Value(certificate_number)-@Value(naic_code)-@Value(location_start_date)	Identifier Value (CDQ)

Data model concepts

Concept	Technical name	Parent	Description	CDQ mapping
Analysis Neighborhoods (US-SF.BER)	Analysis_Neighborhoods	entity (US-SF.BER)
Business Account Number (US-SF.BER)	Business_Account_Number	entity (US-SF.BER)	Seven digit number assigned to registered business accounts	Identifier Value (CDQ)
Business Corridor (US-SF.BER)	Business_Corridor	entity (US-SF.BER)	The Business Corridor in which the the business location falls, if it is in one. Not all business locations are in a corridor.
Business End Date (US-SF.BER)	Business_End_Date	entity (US-SF.BER)	End date of the business
Business Location (US-SF.BER)	Business_Location	entity (US-SF.BER)	The latitude and longitude of the business location for mapping purposes.
Business Start Date (US-SF.BER)	Business_Start_Date	entity (US-SF.BER)	Start date of the business
City (US-SF.BER)	City	entity (US-SF.BER)	Business location city	Locality Value (CDQ)
Current Police Districts (US-SF.BER)	Current_Police_Districts	entity (US-SF.BER)
Current Supervisor Districts (US-SF.BER)	Current_Supervisor_Districts	entity (US-SF.BER)
DBA Name (US-SF.BER)	DBA_Name	entity (US-SF.BER)	Doing Business As Name or Location Name	Name Value (CDQ)
LIC Code (US-SF.BER)	LIC_Code	entity (US-SF.BER)	The LIC code (License code) of the business, if multiple, separated by spaces	Classification Code (CDQ)
LIC Code Description (US-SF.BER)	LIC_Code_Description	entity (US-SF.BER)	The LIC code (License code) description ("multiple" if there are multiple codes for a business)	Classification Value (CDQ)
Location End Date (US-SF.BER)	Location_End_Date	entity (US-SF.BER)	End date at the location
Location Id (US-SF.BER)	Location_Id	entity (US-SF.BER)	Location Identification Number. Each DBA has a unique LIN for location specific tax filings	Identifier Value (CDQ)
Location Start Date (US-SF.BER)	Location_Start_Date	entity (US-SF.BER)	Start date at the location
Mail Address (US-SF.BER)	Mail_Address	entity (US-SF.BER)	Address for mailing	Thoroughfare Value (CDQ)
Mail City (US-SF.BER)	Mail_City	entity (US-SF.BER)	Mailing address city	Locality Value (CDQ)
Mail State (US-SF.BER)	Mail_State	entity (US-SF.BER)	Mailing address zipcode	Administrative Area Iso Code (CDQ)
Mail Zipcode (US-SF.BER)	Mail_Zipcode	entity (US-SF.BER)	Mailing address state	Post Code Value (CDQ)
NAICS Code (US-SF.BER)	NAICS_Code	entity (US-SF.BER)	The North American Industry Classification System (NAICS) is a standard used by Federal statistical agencies for the purpose of collecting, analyzing and publishing statistical data related to the U.S. business economy. A subset of these are options on the business registration form used in the administration of the City and County's tax code. The registrant indicates the business activity on the City and County's tax registration forms. If multiple, separated by spaces.	Classification Code (CDQ)
NAICS Code Description (US-SF.BER)	NAICS_Code_Description	entity (US-SF.BER)	The NAICS code description (multiple if there are multiple codes indicated for the business).	Classification Value (CDQ)
Neighborhoods (US-SF.BER)	Neighborhoods	entity (US-SF.BER)
Neighborhoods - Analysis Boundaries (US-SF.BER)	Neighborhoods_-_Analysis_Boundaries	entity (US-SF.BER)	The Analysis Neighborhood in which the business location falls. Not applicable outside of San Francisco.	Locality Value (CDQ)
Ownership Name (US-SF.BER)	Ownership_Name	entity (US-SF.BER)	Business owner(s) name	Name Value (CDQ)
Parking Tax (US-SF.BER)	Parking_Tax	entity (US-SF.BER)	Whether or not this business pays the parking tax
SF Find Neighborhoods (US-SF.BER)	SF_Find_Neighborhoods	entity (US-SF.BER)
Source Zipcode (US-SF.BER)	Source_Zipcode	entity (US-SF.BER)	Business location zip code	Post Code Value (CDQ)
State (US-SF.BER)	State	entity (US-SF.BER)	Business location state	Administrative Area Iso Code (CDQ)
Street Address (US-SF.BER)	Street_Address	entity (US-SF.BER)	Business location street address	Thoroughfare Value (CDQ)
Supervisor District (US-SF.BER)	Supervisor_District	entity (US-SF.BER)	The Supervisor District in which the business location falls. Not applicable outside of San Francisco.	Locality Type (CDQ)
Transient Occupancy Tax (US-SF.BER)	Transient_Occupancy_Tax	entity (US-SF.BER)	Whether or not this business pays the transient occupancy tax
UniqueID (US-SF.BER)	UniqueID	entity (US-SF.BER)	Unique formula: @Value(ttxid)-@Value(certificate_number)-@Value(naic_code)-@Value(location_start_date)	Identifier Value (CDQ)
entity (US-SF.BER)	entity		An artificial record that wraps one record, i.e. a row in the data source file

Controlled vocabulary terms

No terms available for US-SF.BER