Introduction

About 2 weeks ago I found San Francisco’s open data website, on it was this dataset containing 70 murals along with information about their artist and Cultural District. I used SF Mural Arts as a source for the names of some of the murals.

I’ve uploaded all the files I used for this project here. I used a spreadsheet to track my progress, the file is called “StreetSmArts_Murals_progress.ods”. You can find way IDs in column Q and notes in column S. This legend explains what each colour used in the spreadsheet means and how many murals belong in each category.

Tagging Schemes

There weren’t any tags for some of the information in this dataset so I came up with some new tags in the process.

Cultural Districts

Some of these murals are within certain Cultural Districts, which from what I’ve read on their websites are basically just a fancier version of neighborhoods that organize events to celebrate the culture of those within the district.

You can find the tags for each individual Cultural District in the file “cultural_district_tags.odt”.

cultural_district= - Used to tag the Cultural District’s name

cultural_district:website= - Used to tag the Cultural District’s website

cultural_district:email= - Used to tag the Cultural District’s email

cultural_district:wikipedia= - Used to tag the Cultural District’s Wikipedia page

cultural_district:wikidata= - Used to tag the Cultural District’s Wikidata item identifier

Supervisor Districts

The majority of the murals in the SOMA Pilipinas Cultural District also fall under a “supervisor district” by the name of Leather & LGBTQ Cultural District. I’m not sure what a supervisor district does and Leather & LGBTQ is the only supervisor district in the dataset. I decided to use a similar tagging scheme as the cultural districts.

You can find the tags for each individual Supervisor District in the file “supervisor_district_tags.odt”.

supervisor_district= Used to tag the Supervisor District’s name

supervisor_district:website= Used to tag the Supervisor District’s website

supervisor_district:email= Used to tag the Supervisor District’s email

supervisor_district:wikipedia= Used to tag the Supervisor District’s Wikipedia page

supervisor_district:wikidata= Used to tag the Supervisor District’s Wikidata item identifier

Artists

I feel like I went a bit too far with the artist tags, I tagged the artists’ social media so people can find and support their art more easily. But whether this data is relevant to OSM is debatable. If any of you feel like these tags should be removed please reach out to me by sending me a message or leaving a comment.

You can find the tags for each individual artist in the file “artist_tags.odt”.

artist_name= Used to tag the artist’s name

artist_alias= Used to tag the artist’s alias

artist:website= Used to tag the artist’s website

artist:website_2= Used to tag the artist’s second website

artist:wikipedia= Used to tag the artist’s Wikipedia page

artist:wikidata= Used to tag the artist’s Wikidata item identifier

artist:facebook= Used to tag the artist’s Facebook page

artist:flickr= Used to tag the artist’s Flickr page

artist:instagram= Used to tag the artist’s Instagram account

artist:tumblr= Used to tag the artist’s Tumblr account

artist:twitter= Used to tag the artist’s Twitter account

artist:youtube= Used to tag the artist’s Youtube account

Conclusion

This was both the most fun and the most frustrating mapping project I’ve completed so far. I did about 4 passes through the dataset before I was confident I got every detail right. I’m very happy to have finished this project.

Please feel free to reach out to me if you believe I’ve made a mistake somewhere along the way, I’m always open to learn and correct mistakes! :)