Lists intersecting Supervisor Districts and ZIP Codes for City and County of San Francisco.

Note: This is an archive of filings from 2016-2018. Filings submitted starting in 2019 are available via the following public access site: https://netfile.com/lobbyistpub/#/sfo-exp

An expenditure lobbyist is an individual or entity that spends $2,500 or more in a calendar month to solicit, request, or urge others to communicate directly with a City officer in order to influence local legislative or administrative action. City officers covered by this rule generally include elected City officials, members of City boards and commissions, and City department heads.

Examples of spending that counts toward the $2,500 registration threshold include public relations, media relations, advertising, public outreach, research, investigation, reports, analysis, and studies to the extent those activities are used to solicit, request or urge other persons to communicate directly with a City officer.

Examples of spending that does not count toward the $2,500 registration threshold include: payments made to a registered “contact” lobbyist who directly contacts City officers; payments made to an organization for membership dues; payments made by an organization to distribute communications to its members; payments made by a news media organization to develop and distribute its publications; and payments made by a client to a representative to appear on the client’s behalf in a legal proceeding before a City agency or department; salary paid by employer to employee for activities to solicit, request, or urge others to communicate directly with an officer of the City in order to influence a matter of local legislative or administrative action.

Each expenditure lobbyist must register by filing a registration form with the Ethics Commission no later than five business days after qualifying as such, and prior to making any additional payments to influence local legislative or administrative action.

Each registered expenditure lobbyist must file monthly reports with the Ethics Commission by the fifteenth day of the month following the calendar month covered by the report. For example, a report covering activity in the month of February must be filed by March 15. Deadlines falling on a weekend or holiday are extended to the next business day. Please note the monthly disclosures are different than the registration requirements.

Cases created since 7/1/2008 with location information

Mobile Food Facility Permits including name of vendor, location, type of food sold and status of permit.

Fire Calls-For-Service includes all fire units responses to calls. Each record includes the call number, incident number, address, unit identifier, call type, and disposition. All relevant time intervals are also included. Because this dataset is based on responses, and since most calls involved multiple units, there are multiple records for each call number. Addresses are associated with a block number, intersection or call box , not a specific address,

A. SUMMARY
This dataset contains COVID-19 positive confirmed cases aggregated by several different geographic areas and by day. COVID-19 cases are mapped to the residence of the individual and shown on the date the positive test was collected. In addition, 2016-2020 American Community Survey (ACS) population estimates are included to calculate the cumulative rate per 10,000 residents.

Dataset covers cases going back to 3/2/2020 when testing began. This data may not be immediately available for recently reported cases and data will change to reflect as information becomes available. Data updated daily.

Geographic areas summarized are:
1. Analysis Neighborhoods
2. Census Tracts
3. Census Zip Code Tabulation Areas

B. HOW THE DATASET IS CREATED
Addresses from the COVID-19 case data are geocoded by the San Francisco Department of Public Health (SFDPH). Those addresses are spatially joined to the geographic areas. Counts are generated based on the number of address points that match each geographic area for a given date.

The 2016-2020 American Community Survey (ACS) population estimates provided by the Census are used to create a cumulative rate which is equal to ([cumulative count up to that date] / [acs_population]) * 10000) representing the number of total cases per 10,000 residents (as of the specified date).

COVID-19 case data undergo quality assurance and other data verification processes and are continually updated to maximize completeness and accuracy of information. This means data may change for previous days as information is updated.

C. UPDATE PROCESS
Geographic analysis is scripted by SFDPH staff and synced to this dataset daily at 05:00 Pacific Time.

D. HOW TO USE THIS DATASET
San Francisco population estimates for geographic regions can be found in a view based on the San Francisco Population and Demographic Census dataset. These population estimates are from the 2016-2020 5-year American Community Survey (ACS).

This dataset can be used to track the spread of COVID-19 throughout the city, in a variety of geographic areas. Note that the new cases column in the data represents the number of new cases confirmed in a certain area on the specified day, while the cumulative cases column is the cumulative total of cases in a certain area as of the specified date.

Privacy rules in effect
To protect privacy, certain rules are in effect:
1. Any area with a cumulative case count less than 10 are dropped for all days the cumulative count was less than 10. These will be null values.
2. Once an area has a cumulative case count of 10 or greater, that area will have a new row of case data every day following.
3. Cases are dropped altogether for areas where acs_population < 1000
4. Deaths data are not included in this dataset for privacy reasons. The low COVID-19 death rate in San Francisco, along with other publicly available information on deaths, means that deaths data by geography and day is too granular and potentially risky. Read more in our privacy guidelines

Rate suppression in effect where counts lower than 20
Rates are not calculated unless the cumulative case count is greater than or equal to 20. Rates are generally unstable at small numbers, so we avoid calculating them directly. We advise you to apply the same approach as this is best practice in epidemiology.

A note on Census ZIP Code Tabulation Areas (ZCTAs)
ZIP Code Tabulation Areas are spec

The San Francisco Controller's Office maintains a database of spending and revenue data sourced from it's citywide financial system. This data is presented on the Spending and Revenue report hosted at http://openbook.sfgov.org, and is also available in this dataset in CSV format. New data is added on a weekly basis, and is available from fiscal year 2000 forward.

Neighborhood notification boundaries created by the Department of City Planning. These boundaries are designed solely for the Planning Department's neighborhood notifications where neighborhood groups are notified about certain types of developments in their area. An Excel spreadsheet of Neighborhood Groups contact details can be downloaded from this page: http://sf-planning.org/index.aspx?page=1654 There are alternative neighborhood boundaries available (which include a larger number of neighborhoods) here (Mayors Office): https://data.sfgov.org/d/pty2-tcw4 and here (Realtors): https://data.sfgov.org/d/5gzd-g9ns

In preparation for the San Francisco Urban Forest Plan (2013), the Planning Department performed an Urban Tree Canopy (UTC) Analysis using aerial imagery and additional data sets to determine a canopy estimate for the City & County of San Francisco. This analysis estimated San Francisco's tree canopy at 13.7%. This number supersedes a 2007 canopy estimate of 11.9% (USDA Forest Service, 2007). Given the differing methodologies used to arrive at these two numbers it is difficult to draw conclusions regarding urban forest growth or decline based on a comparison. The current analysis establishes a baseline and methodology from which future canopy analyses can be conducted and compared over subsequent years to track San Francisco's urban forest growth or decline over time. See the attachment under About for more on the methodology.

A. SUMMARY
Data on daily hospital bed use and available capacity at San Francisco acute care hospitals from April 2020 onward. Long Term Care facilities (like Laguna Honda and Kentfield) are not included in this data as acute care patients cannot be admitted to these facilities.
B. HOW THE DATASET IS CREATED
This hospital capacity information is based on data that all SF acute care hospitals report to the San Francisco Department of Public Health.
C. UPDATE PROCESS
Updates automatically at 05:00 Pacific Time each day. Redundant runs are scheduled at 07:00 and 09:00 in case of pipeline failure. This data is on a 4-day lag to account for the time needed to complete and validate data from all SF acute care hospitals.
D. HOW TO USE THIS DATASET
This data provides visibility into current occupancy levels and use of San Francisco acute care hospitals and potential ability to accommodate anticipated surges of COVID patients.
Data includes current census of COVID-19 patients (including both confirmed cases and suspected COVID patients) and other patients in acute care hospitals, shown in the “Status” column. The “Status” column also includes all available beds.
This daily census information is stratified by type of bed (acute care, intensive care, and surge) in the “Bed Type” column. Acute care beds treat patients with illnesses and injuries including recovery from surgeries. Intensive care (ICU) beds are for sicker patients in need of critical and life support services that can include the use of a ventilator. Surge beds are the additional beds that can be made available to handle an influx of COVID-19 patients; surge beds are differentiated between acute care surge beds and ICU surge beds.
Note: The current census of COVID patients shown here may not always match the hospitalizations data (https://data.sfgov.org/COVID-19/COVID-19-Hospitalizations/nxjg-bhem), as that data includes all hospitals and long term care facilities. As described above, those long term care facilities are not included here as they don’t have the capacity to take in additional acute care patients and therefore aren’t included in capacity measures.