About this Dataset

Municipal Transportation Agency Board Resolutions

The SFMTA Board of Directors provides policy oversight for the safe and efficient transportation of goods and people in San Francisco in accordance with the San Francisco Charter and the Transit First Policy. This includes the San Francisco Municipal Railway (Muni), automobiles and trucks, taxis, bicycling and walking. The SFMTA Board of Directors also serves as members of the San Francisco Parking Authority.

The Board votes on various items that are captured in the official minutes of each meeting. The map represents the individual items voted on at each board meeting that could be associated with a location either via a block range or intersection. Data are extracted voluntarily by a third-party XTreet (https://xtreet.org) from the PDF minutes. As such, there may be errors or omissions. Also note that data lags minutes as they are transcribed in bulk through a combination of automated and manual processing. The data is provided as is. If you are in need of the accurate accounting of the meetings, please refer to the minutes available at https://www.sfmta.com/about-sfmta/organization/divisions-and-units/board-directors
Organization: City of San Francisco
Last updated: 2020-11-10T16:57:00.691668

Tables

Table 1

@usgov.city_of_san_francisco_municipal_transportation_agency__3c361fb9.table_1

1 MB
14,533 rows
52 columns

CREATE TABLE table_1 (
  "date" TIMESTAMP,
  "resolution_numbers" VARCHAR,
  "minutes_item" DOUBLE,
  "resolution_letter" VARCHAR,
  "letter_sequence" DOUBLE,
  "action" VARCHAR,
  "category" VARCHAR,
  "type" VARCHAR,
  "description" VARCHAR,
  "street_name" VARCHAR,
  "from_address" VARCHAR,
  "to_address" VARCHAR,
  "cross_street" VARCHAR,
  "side" VARCHAR,
  "from_feet" VARCHAR,
  "to_feet" VARCHAR,
  "hour" VARCHAR,
  "start_time" VARCHAR,
  "end_time" VARCHAR,
  "day" VARCHAR,
  "permits" VARCHAR,
  "week_1" VARCHAR,
  "week_2" VARCHAR,
  "week_3" DOUBLE,
  "week_4" VARCHAR,
  "week_5" VARCHAR,
  "order_number" VARCHAR,
  "project_id" VARCHAR,
  "project_name" VARCHAR,
  "project_status" VARCHAR,
  "project_update" VARCHAR,
  "project_link" VARCHAR,
  "pdf" VARCHAR,
  "video" VARCHAR,
  "mp3" VARCHAR,
  "supervisor_district" DOUBLE,
  "neighborhooods_analysis_boundaries" VARCHAR  -- Neighborhooods - Analysis Boundaries,
  "neighborhoods_realtor_boundaries" VARCHAR  -- Neighborhoods - Realtor Boundaries,
  "neighborhoods_sffind_boundaries" VARCHAR  -- Neighborhoods - SFFind Boundaries,
  "geocoder_confidence" DOUBLE,
  "location" VARCHAR,
  "neighborhoods_2" DOUBLE,
  "sf_find_neighborhoods_2" DOUBLE,
  "current_police_districts_2" DOUBLE,
  "current_supervisor_districts_2" DOUBLE,
  "analysis_neighborhoods_2" DOUBLE,
  "delete_neighborhoods_from_fyvs_ahh9_2" DOUBLE  -- DELETE - Neighborhoods From Fyvs Ahh9–2,
  "delete_sf_find_neighborhoods_2" DOUBLE  -- DELETE - SF Find Neighborhoods 2,
  "delete_supervisor_districts_2" DOUBLE  -- DELETE - Supervisor Districts 2,
  "delete_current_police_districts_2" DOUBLE  -- DELETE - Current Police Districts 2,
  "delete_fire_prevention_districts_2" DOUBLE  -- DELETE - Fire Prevention Districts 2,
  "delete_zip_codes_2" DOUBLE  -- DELETE - Zip Codes 2
);