AndreaBozzo/ceres-open-data-index huggingface dataset:
Employee Compensation

<strong>A. SUMMARY</strong>
The San Francisco Controller's Office maintains a database of the salary and benefits paid to City employees since fiscal year 2013.  

<strong>B. HOW THE DATASET IS CREATED</strong>
This data is summarized and presented on the Employee Compensation report hosted at http://openbook.sfgov.org, and is also available in this dataset in CSV format.

<strong>C. UPDATE PROCESS</strong>
New data is added on a bi-annual basis when available for each fiscal and calendar year.

<strong>D. HOW TO USE THIS DATASET</strong>
Before using please first review the following two resources:
<li>Data Dictionary - Can be found in 'About this dataset' section after click 'Show More'
<li><u><a href="https://sfdigitalservices.gitbook.io/dataset-explainers/employee-compensation-faq">Employee Compensation FAQ</a></u>

Tags: benefits, compensation, employee, fte, open-book, openbook, salaries, salary, sfopenbook, spending, staffing
Organization: City of San Francisco
Active Entertainment Permits

<strong>A. SUMMARY</strong>
This dataset is  list of all active entertainment permits granted by the San Francisco Entertainment Commission. 

<strong>B. HOW THE DATASET IS CREATED</strong>
After a new permit applicant has completed the necessary processes and has been granted a Place of Entertainment permit by the San Francisco Entertainment Commission, the business and permit information is logged and tracked through this dataset. 

<strong>C. UPDATE PROCESS</strong>
Newly granted permits are manually input by EC staff as they are received. This dataset is updated automatically by DataSF daily

<strong>D. HOW TO USE THIS DATASET</strong>
This dataset contains information on seven entertainment permits:

POE - Place of Entertainment
LLP - Limited Live Performance
MAD - Mechanical Amusement Device
EHP - Extended Hours Premises
BP - Billiard or Pool Tables
DHK - Dance Hall
FPAS - Fixed Place Amplified Sound

Additionally, the data is geocoded -- adding latitude and longitude -- so the information can be plotted out on a map.

Organization: City of San Francisco
Temp Street Closure Intersections

<strong>A. SUMMARY</strong>
This dataset contains a list of intersections impacted by upcoming and current street closures occurring as a result of the Shared Spaces program, certain special events, and some construction work. This dataset only includes street closures permitted by the San Francisco Municipal Transportation Agency (SFMTA). It doesn’t include street closures managed by other City departments such as Public Works or the Police Department.

<strong>B. HOW THE DATASET IS CREATED</strong>
The data is exported from the Street Closure Salesforce database which is maintained by the SFMTA ISCOTT unit and converted to the geometry of streets and intersections based on closed street extent descriptions.

<strong>C. UPDATE PROCESS</strong>
Database is updated constantly. This report is issued daily.

<strong>D. HOW TO USE THIS DATASET</strong>
Please be aware that this dataset only contains temporary street closure events that are permitted (“status = permitted”).

This dataset contains various types of street closures. If you are looking for a particular type please use the TYPE field to select the appropriate closure type (Ex. type = Shared Space).

<strong>E. RELATED DATASETS</strong>
<li>For street segments affected by temporary street closures (rather than the intersection points provided here), please see the 
<u><a href="https://data.sfgov.org/d/8x25-yybr">Temporary Street Closures</a></u> dataset. </li>
<li>For street closures in the WZDx standard format, see the   
<u><a href="https://data.sfgov.org/d/4ftp-yz2f">Temporary Street Closures in the Work Zone Data Exchange (WZDx) Format</a></u> dataset. </li>

Organization: City of San Francisco
Bicycle Loop Counters

<strong>A. SUMMARY </strong>
Point features that represent the location of proposed, active, and non-functioning bicycle loop counters in San Francisco

<strong>B. METHODOLOGY  </strong>
N/A

<strong>C. UPDATE FREQUENCY  </strong>
Annually

Tags: bicycle-counter, bicycle-loop-counter, bike-counter, bike-loop, loop-counter
Organization: City of San Francisco
Petitions to the Rent Board

Petitions may be filed for a variety of reasons, most commonly to have the Rent Board determine the rent. Some of the other common petition filing grounds include: decrease in housing services, unlawful rent increase, failure to repair and maintain, roommate proportional share of the rent, general obligation bond passthrough challenge, utility passthrough challenge, water revenue bond passthrough challenge, violation of the Residential Hotel Visitor Policy, capital improvement passthroughs, operating and maintenance expense increases, extension of time (to perform capital improvement work), comparable rents, intent to withdraw (Ellis), utility passthrough petition and worksheet, Costa-Hawkins determination, Rules and Regulations §1.21, hardship applications, and Alternative Dispute Resolution (ADR). Petitions are also accepted on “other” grounds. For more information, please see: https://www.sf.gov/landlord-petitions-and-passthroughs and https://www.sf.gov/tenant-petitions

Tags: rent-control
Organization: City of San Francisco
Department of Public Works Active Parcel History

<strong>Note:</strong> These are the Department of Public Works Basemap Parcels, not the Assessor-Recorder's Taxable Parcels. See "How to use this dataset" for more information.

<strong>A. SUMMARY</strong>
Parcels are defined areas of land, demarcated by boundaries to visualize distinct and legal parcels of real property. Occasionally, parcels are divided or combined, and a new parcel can be created. This dataset connects current parcels in San Francisco to historical parcels that are associated with it.

<strong>B. HOW THE DATASET IS CREATED</strong>
This dataset utilizes the  <u><a href="https://data.sfgov.org/Geographic-Locations-and-Boundaries/Parcel-Change-Log/nqyt-nfmd/about_data">parcel change log</a></u> to find associated parcels through an iterative process. 

<strong>C. UPDATE PROCESS</strong>
This dataset will be refreshed daily, though the data may not change every day. 

<strong>D. HOW TO USE THIS DATASET</strong>
The City and County of San Francisco has two related but distinct parcel databases. The first is managed by the Department of Public Works, is created by surveyors, and is used in the Department of Public Works basemap. Public Works parcels are used to identify very precisely where private properties end and where public City property begins (e.g. sidewalks, roads, rights of way, etc.). The second is managed by the Assessor-Recorder's Office. Assessor parcels are defined by Revenue and Taxation code and Property Tax law. The Assessor-Recorder uses official maps defined under Revenue and Taxation code section 325 in the creation of assessor parcels and are used to identify taxable property. Each of the Assessor's parcels have an Assessor's Parcel Number (APN) which is used  by other departments including but not limited to Tax Collector for tax collection, DBI for permitting, and other use cases. 

Though most parcels are the same between Public Works and the Assessor’s Office, they are not a perfect match. APN's are retired and activated within the timeline parameters of tax years (July – June) based on tax roll state requirements, which means there can be a lag between the Public Works parcel changing and the associated APN being updated.  Public Works’ City Basemap identifies legal parcels defined by California Code Subdivision Map Act and Assessor-Recorder’s parcels identify taxable parcel boundaries defined by Revenue and Taxation Code. 

Use this dataset to identify historical parcels from the Public Works Basemap that are associated with an active Public Works basemap parcel. <strong>This dataset is not a history of the Assessor-Recorder's Parcels</strong>.


<strong>E. RELATED DATASETS</strong>
<li> <u><a href="https://data.sfgov.org/Geographic-Locations-and-Boundaries/Parcel-Change-Log/nqyt-nfmd/about_data">Parcel Change Log</a></u></li><li><u><a href="https://data.sfgov.org/Geographic-Locations-and-Boundaries/Parcels-Active-and-Retired/acdm-wktn/about_data">Parcels - Active and Retired</a></u></li>

Organization: City of San Francisco
Privately Owned Public Open Spaces

Privately-owned public open spaces (POPOS) are publicly accessible spaces in forms of plazas, terraces, atriums, small parks, and even snippets which are provided and maintained by private developers. In San Francisco, POPOS mostly appear in the Downtown office district area. Prior to 1985, developers provided POPOS under three general circumstances: voluntarily, in exchange for a density bonus, or as a condition of approval. The 1985 Downtown Plan created the first systemic requirements for developers to provide publicly accessible open space as a part of projects in C-3 Districts. The goal was to “provide in the downtown quality open space in sufficient quantity and variety to meet the needs of downtown workers, residents and visitors.” (See Planning Code Section 138 for regulations). Since then, project sponsors for residential projects may provide POPOS instead of their required open spaces in the Downtown Residential (DTR) and Eastern Neighborhoods (Section 135 of the Planning Code). Learn more at http://sf-planning.org/privately-owned-public-open-space-and-public-art-popos

Tags: open-space, popos
Organization: City of San Francisco
Form 700 Schedule A2 - Investments, Income, and Assets of Business Entities/Trusts

This dataset is updated weekly. For more up-to-date filings, refer to the "View Filed Statements" or "Search Within Statements" links on the <a href="https://sfethics.org/disclosures/city-officer-disclosure/statement-of-economic-interests-city-officer-disclosure">Ethics Commission webpage</a>.

Investments, income, and assets of business entities/trusts where ownership interest is 10% or greater. Business entities (including certain independent contracting), sole proprietorships, partnerships, LLCs, corporations, and trusts.
Link to Form 700 overview: http://www.fppc.ca.gov/Form700.html
In this dataset the fields "address" and "realProperty_parcelAddress" are redacted.
This dataset contains records from Schedule A2 across electronic Form 700 filings with the SFEC since January 1, 2014.  To see all the data from a specific filing, you should search all the datasets listed
<a href="https://sfethics.org/disclosures/city-officer-disclosure/statement-of-economic-interests-city-officer-disclosure/data-statement-of-economic-interests">on this page</a> and filter by the filingId of the specific filing.

Prior to the start of e-filing for all in 2022, elected officials, department heads, and members of boards and Commissions filed the Form 700 with the Ethics Commission; designated employees filed the Form 700 on paper with their department's designated filing officer.

Tags: ethics, form-700, schedules, sei, statement-of-economic-interests
Organization: City of San Francisco
Historic Districts

A. SUMMARY
Historic districts in San Francisco. These include districts listed in Articles 10 and 11 of the San Francisco Planning Code and districts listed or eligible for listing in the California Register of Historical Resources and/or the National Register of Historic Places (links below).

B. HOW THE DATASET IS CREATED
District boundaries have been mapped by the San Francisco Planning Department. 

C. UPDATE PROCESS
The data is updated several times a year when new historic districts are approved by the Historic Preservation Commission, or when historic districts are listed or found to be eligible for listing in the California Register of Historical Resources and/or the National Register of Historic Places.  This dataset syncs with the Planning Department's database very night, so any edits to that primary data source are reflected in this dataset the following morning.

D. HOW TO USE THIS DATASET
For further information:
<u><a href="https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-27871">Article 10</a></u>
<u><a href="https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_planning/0-0-0-28705">Article 11</a></u>
<u><a href="https://govt.westlaw.com/calregs/Browse/Home/California/CaliforniaCodeofRegulations?guid=IFEF7DFD0D48511DEBC02831C6D6C108E&originationContext=documenttoc&transitionType=Default&contextData=(sc.Default)">California Register of Historical Resources</a></u>
<u><a href="https://www.ecfr.gov/current/title-36/chapter-I/part-60">National Register of Historic Places</a></u>

Tags: districts, historic, preservation
Organization: City of San Francisco
Zoning Map - Special Use Districts

Special Use Districts (SUDs) are a component of the San Francisco Zoning Map.  SUD controls are outlined in Article 2 of the San Francisco Planning Code:
http://library.amlegal.com/nxt/gateway.dll/California/planning/article2usedistricts?f=templates$fn=default.htm$3.0$vid=amlegal:sanfrancisco_ca$anc=JD_Article2

The official San Francisco zoning map is here:
https://experience.arcgis.com/experience/573d02b43b7b46e381df04b7f225da95

Tags: development, planning, sud, zoning
Organization: City of San Francisco
Cultural Districts

<strong>A. SUMMARY</strong>
The San Francisco Board of Supervisors has recognized several cultural districts that are distinguished by unique social and historical associations and living traditions. While they have physical boundaries, the districts are primarily identified by the activities that occur within them, including commerce, services, arts, events, and social practices. While a cultural heritage district does not currently hold any regulatory controls, the recognition has spurred community efforts facilitated by the Planning Department and the Mayor's Office of Economic and Workforce Development to develop strategies for sustaining the living culture of these places

More information: https://sfplanning.org/cultural-heritage

Tags: gis, historic, preservation
Organization: City of San Francisco
Illegal Dumping Open Reports

<p><span style='font-size:11.0pt; color:#4C4C4C; background:white;'>This represents a weekly extract from
the Motorola CSR application of all open reports of illegal dumping.</span></p>

<p style='background:white;'><span style='font-size:11.0pt; color:#4C4C4C; background:white;'>Illegal
dumping is any junk, garbage or debris is left on public property, including
roadsides, open streets, and paved alleys. The items most commonly reported are
TVs and computers, furniture, paints, solvents (and other potentially hazardous
liquids), tires, garbage, yard waste, and construction debris.</span></p><p style='background:white;'><span style='font-size:14.6667px;'>Data source:  UTIL.ILLEGAL_DUMPING_OPEN_REPORT</span></p><p style='background:white;'><span style='font-size:14.6667px;'>Attribute info:</span></p><p style='background:white;'></p><table border='0' cellpadding='0' cellspacing='0' style='border-collapse:collapse; width:637pt;' width='849'><tbody><tr height='20' style='height:15.0pt;'>
  <td height='20' style='height:15.0pt; width:66pt;' width='88'>SR_Number</td>
  <td style='border-left:none; width:119pt;' width='158'>Service Request Number</td>
  <td style='border-left:none; width:378pt;' width='504'>The unique record number of the service request</td><td style='border-left:none; width:74pt;' width='99'>text</td>
 </tr>
 <tr height='20' style='height:15.0pt;'>
  <td height='20' style='height:15.0pt; border-top:none;'>Created_Date</td>
  <td style='border-top:none; border-left:none; width:119pt;' width='158'>Created Date</td>
  <td style='border-top:none; border-left:none; width:378pt;' width='504'>The date the service request was created</td>
  <td style='border-top:none; border-left:none; width:74pt;' width='99'>date</td>
 </tr>
 <tr height='20' style='height:15.0pt;'>
  <td height='20' style='height:15.0pt; border-top:none;'>SR_Location</td>
  <td style='border-top:none; border-left:none; width:119pt;' width='158'>Location
  Display Name</td>
  <td style='border-top:none; border-left:none; width:378pt;' width='504'>The
  location of the service request (street address, intersection, or freeform
  text)</td>
  <td style='border-top:none; border-left:none; width:74pt;' width='99'>text</td>
 </tr></tbody></table><p style='background:white;'><span style='font-size:14.6667px;'></span></p><br /><table border='1' cellpadding='0' cellspacing='0' style='border-collapse:collapse; border:none;'><tbody>
</tbody></table>

Tags: debris, find-it-fix-it, garbage, illegal-dumping, seattle-gis-open-data, spu
Organization: City of Seattle
SDCI Development Sites - Non-Right-of-Way

<span style='font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif; font-size:16px;'>This is a view of the </span><a href='https://seattlecitygis.maps.arcgis.com/home/item.html?id=4eedf0a9a2d24b9da3547e73d142e1d2' style='color:rgb(0, 97, 155); text-decoration-line:none; font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif; font-size:16px;' target='_blank' rel='nofollow ugc noopener noreferrer'>SDCI Development Sites</a><span style='font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif; font-size:16px;'> hosted Feature Layer, filtered to only display sites that are designated as non-rights-of-way.</span><div style='font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif; font-size:16px;'><br /></div><div style='font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif; font-size:16px;'>Please reference the link above for the full details and refresh schedule.</div>

Tags: development-sites, devsites, sdci, seattle-gis-open-data
Organization: City of Seattle
Zoning Map - Height and Bulk Districts

The Height and Bulk Districts are a component of the Zoning Map which in turn is a key component of the San Francisco Planning Code. The official San Francisco zoning map is here:
https://experience.arcgis.com/experience/573d02b43b7b46e381df04b7f225da95

Tags: bulk, development, height, planning, zoning
Organization: City of San Francisco
Sheriff's Inspector General Cases and Resolutions

<strong>A. SUMMARY</strong>
This dataset contains public information on sheriff misconduct cases split up by unique allegations. This includes case numbers, dates of receipt, allegations made, investigation findings, issuance dates of findings, and case closure dates. Its purpose is to enhance transparency and accountability by providing accessible details about alleged misconduct to the public. By offering insights into the scope and outcomes of investigations, it enables citizens to stay informed.

<strong>B. HOW THE DATASET IS CREATED</strong>
The data set is created when a complaint is made to the Office of Sheriff’s Inspector General (OSIG). OSIG opens the case and date is developed through out the life of the case.

<strong>C. UPDATE PROCESS</strong>
The data is downloaded once a week from OSIG’s Case Management System.

<strong>D. HOW TO USE THIS DATASET</strong>
The dataset includes information on complaints received and closed in the current calendar year. Some cases will display received dates in previous years due to them being closed out in the current year. 

<strong>E. RELATED DATASETS</strong>
<li>  <u><a href="https://data.sfgov.org/City-Management-and-Ethics/Police-Accountability-Misconduct-Cases-and-Allegat/b4we-97wx/about_data">Police Accountability Misconduct Cases and Allegations
</a></u>

Organization: City of San Francisco
City Lands

<strong>A. SUMMARY</strong>
This data represents the boundaries of City-owned lands maintained in the City's Facility System of Record (FSR).  
Note: Not all lands are within the City and County proper. The City owns properties outside of its boundaries, including lands managed by SF Recreation and Parks, SF Public Utilities Commission, and other agencies.  
Certain lands are managed by following agencies which are not directly part of the City and County of San Francisco, but are included here for reference: <u><a href="https://sfha.org/">San Francisco Housing Authority (SFHA)</a></u>, <u><a href="https://sfocii.org/">San Francisco Office of Community Investment and Infrastructure (OCII)</a></u>, and <u><a href="https://www.ccsf.edu/">City College of San Francisco</a></u>.

<strong>B. HOW THE DATASET IS CREATED</strong>
The Enterprise GIS program in the Department of Technology is the technical custodian of the FSR. This team creates and maintains this dataset in conjunction with the Real Estate Division and the Capital Planning Program of the City Administrator’s Office, who act as the primary business data stewards for this data. 

<strong>C. UPDATE PROCESS</strong>
There are a handful of events that may trigger changes to this dataset:
1. The sale of a property
2. The leasing of a property
3. The purchase of a property
4. The change in jurisdiction of a property (e.g. from MTA to DPW)
5. The removal or improvement of the property
Each of these changes triggers a workflow that updates the FSR. The Real Estate Division and Capital Planning make updates on an ongoing basis. The full dataset is reviewed quarterly to ensure nothing is missing or needs to be corrected. 
Updates to the data, once approved, are immediately reflected in the internal system and are updated here in the open dataset on a monthly basis.

<strong>D. HOW TO USE THIS DATASET</strong>
See <u><a href="https://data.sfgov.org/d/8sce-d4fx">here</a></u> for an interactive map of all the City lands in this dataset. 
To track the facilities on City lands, join this dataset to the <u><a href="https://data.sfgov.org/d/nc68-ngbr">City Facilities</a></u> dataset using the land_id field. 
If you see an error in the data, you can submit a change request with the relevant information to dtis.helpdesk@sfgov.org. Please be as specific about the error as you can (including relevant land_id(s)). 

<strong>E. RELATED DATASETS</strong>
<u><a href="https://data.sfgov.org/d/nc68-ngbr">City Facilities</a></u>

Tags: fsr, land, property
Organization: City of San Francisco
Services for Children, Youth, and their Families

<strong>A. SUMMARY</strong>
San Francisco offers numerous events and activities tailored for children, youth, and families. However, finding and navigating the disparate sources of information can be a major challenge. Our415.org seeks to simplify this by consolidating all relevant details, ensuring that families can easily find what they need, when they need it. It also encourages discovery of new interests and things to do. This dataset includes data on services targeted for children, youth, and their families in San Francisco.

<strong>B. HOW THE DATASET IS CREATED</strong>
This dataset includes data collected from various sources including DCYF’s Contract Management System, Jotform, and data shares from various departments in the City.

<strong>C. UPDATE PROCESS</strong>
The dataset will be updated on a daily basis, reflecting changes to the source data.

<strong>D. HOW TO USE THIS DATASET</strong>
This dataset can be joined to the Organizations dataset (CHF-0012) using the ID field from the Organizations dataset and Organization ID field in the Services dataset.

<strong>E. RELATED DATASETS</strong>
<u><a href="https://data.sfgov.org/Economy-and-Community/Organizations-serving-Children-Youth-and-their-Fam/ddhd-yzyc/about_data">Organizations serving Children, Youth, and their Families</a></u>

Tags: our415
Organization: City of San Francisco