SF OpenData Parking Meter Data

SF OpenData Parking Meter Data

This is an R Markdown Notebook. When you execute code within the notebook, the results appear beneath the code.

Try executing this chunk by clicking the Run button within the chunk or by placing your cursor inside it and pressing Ctrl+Shift+Enter.

Add a new chunk by clicking the Insert Chunk button on the toolbar or by pressing Ctrl+Alt+I.

When you save the notebook, an HTML file containing the code and output will be saved alongside it (click the Preview button or press Ctrl+Shift+K to preview the HTML file).

Where are the Parking meters in San Fransisco?

To find data on the SF OpenData website you can click on one of the 10 topics provided or you can search. To find data about Parking meters in SF, search on Parking meters. The first result should be a link to the Parking meters dataset.

The SF OpenData website now has maps. You need to create an account of the website to save you plots. Here is a link to a map that I made of Where are the Parking meters?

Now we are going to use the provided API to download the data into R.

Loading libraries…

Note the the location columns have been read in as char values. These should be numeric. First we will transform them into numeric columns. We will change smart_mete to a factor, which will let us color the map with two colors. Note that sapply is used to check the classes of the columns in the dataframe.

                  ms_id              streetname              smart_mete              ms_spaceid 
            "character"             "character"                "factor"             "character" 
             meter_type              street_num               cap_color              jurisdicti 
            "character"             "character"             "character"             "character" 
                post_id              sfparkarea              on_off_str       location.latitude 
            "character"             "character"             "character"               "numeric" 
location.needs_recoding      location.longitude                  osp_id                ratearea 
            "character"               "numeric"             "character"             "character" 
             street_seg              activesens 
            "character"             "character" 

To simplify the dataframe we will take a subset of the columns of the original dataframe: type, latitude, and longitude. We will simplify the names of the variables/columns.

     type  latitude longitude 
 "factor" "numeric" "numeric" 

Now using the package ggmap we get a map and then plot the locations of the Parking meters on the map.

Map from URL : http://maps.googleapis.com/maps/api/staticmap?center=San+Fransisco&zoom=13&size=640x640&scale=2&maptype=terrain&sensor=false
Information from URL : http://maps.googleapis.com/maps/api/geocode/json?address=San%20Fransisco&sensor=false
Map from URL : http://tile.stamen.com/toner/13/1309/3165.png
cannot remove file '3f4c07b1d4643b079aa082775de467cb.rds', reason 'No such file or directory'Map from URL : http://tile.stamen.com/toner/13/1310/3165.png
cannot remove file '52a39668b3aaa2aeed79dc8186cc76f2.rds', reason 'No such file or directory'Map from URL : http://tile.stamen.com/toner/13/1311/3165.png
cannot remove file '6a183fc6f69abba493f517990595f819.rds', reason 'No such file or directory'Map from URL : http://tile.stamen.com/toner/13/1309/3166.png
cannot remove file '87d8f1936dd8cde98b6c914920edb442.rds', reason 'No such file or directory'Map from URL : http://tile.stamen.com/toner/13/1310/3166.png
cannot remove file '3bc6e364204e455419e3002d779a8034.rds', reason 'No such file or directory'Map from URL : http://tile.stamen.com/toner/13/1311/3166.png
cannot remove file 'ef6929c0cb97d758c41df55bb5ff1ed3.rds', reason 'No such file or directory'Map from URL : http://tile.stamen.com/toner/13/1309/3167.png
cannot remove file '9c5d24dff0fed2a98c356f1e6d4856bc.rds', reason 'No such file or directory'Map from URL : http://tile.stamen.com/toner/13/1310/3167.png
cannot remove file 'e67d1cb2911d0693313d752712b76cf3.rds', reason 'No such file or directory'Map from URL : http://tile.stamen.com/toner/13/1311/3167.png
cannot remove file 'abad561f1ba64a153465eaffe659d715.rds', reason 'No such file or directory'

Subsetting.