San Francisco Historical Street Names Index [Updated]

I have recently migrated the San Francisco Historical Street Names Index away from Google Fusion Tables since the index, at the moment, lacks a spatial component. The data, however, is still available online as an interactive index through a simple Google Spreadsheet view. The spreadsheet allows users to filter, sort, and view the historical data in a much simpler and user-friendly way. You can view and interact with the updated online index here.

The illustrated guide below will show you how to filter and sort the ever-growing historical data set.

 

1. Select the Filter icon filtericon in the sub-menu and select Create new temporary filter view.

filter0a

 

2. The dark grey temporary filter view will appear, called “Temporary filter 1” by default. You can now select the filter/sort menu within each column. This filter/sort menu shows you all the unique data values that appear in your selected column.

filter1b

 

3. You can select or de-select any value to view (or hide) that value, or you can sort the values in your column alphabetically, A-Z or Z-A. You can also type a data value into the search box to see if that data appears in your column; select or de-select elements from there.

Click OK to view your data.

filter2

 

4. If you choose “Mission District,” your spreadsheet will be filtered to show all historical street names where Neighborhood(s) has a data value of “Mission District.” filter3

If you know of an old street name that is not currently in the index, I encourage you to send me an email here to help build the historical resource for other researchers. Please provide at least the (1) current street name, (2) historical street name, and (3) citation to this information. Thank you.

6 Comments

  • Greg May 21, 2017

    Glad you’re still working this.

    Has inspired me to look for similar for Los Angeles. Best so far is http://stevemorse.org/census/changes/LosAngelesChanges2.htm

    • chris May 21, 2017 Author

      Greg, thanks for checking it out. I’m actually building one for LA as well. I’ll publish once there’s enough data populated. Stay tuned!

      • Greg May 22, 2017

        I’ve already started one modeled on yours and I’d be happy to turn it over to you. 490 entries, mostly from http://stevemorse.org/census/changes/LosAngelesChanges2.htm with permission.

      • Greg May 22, 2017

        I’ve already started one modeled on yours and I’d be happy to turn it over to you. 490 entries, mostly from http://stevemorse.org/census/changes/LosAngelesChanges2.htm with permission ” for non-commercial purposes.”

        • chris May 26, 2017 Author

          Greg, I’d be happy to take it over. Send me a direct email on the “Contact” page and we can communicate from there.

  • Alan McConchie May 23, 2017

    Would be super cool to combine with this: http://sfstreets.noahveltman.com/

Comments are closed.

Top