We’ve released a new version of RSocrata with two new, big features. You can now upload data to Socrata using the new “write.socrata()” function. If you have a dataframe ready to go in R, and you’ve already setup a corresponding schema in Socrata, you can use your Socrata credentials to upload the data directly from R. This is a superb addition if you want to use R to upload datasets to your data portal. Our team has used our own ETL framework to work with our portal, but others may feel more comfortable using R to do the same thing.


For instance, Stuart Gano used the beta version to download calls for ambulances, create a statistical forecast of upcoming call volumes for upcoming months, and then use RSocrata to upload those estimates to a data portal.

Powered by Socrata

Second, you can now download private, non-public data from Socrata portals. While Socrata is intended to publish public data, there is an option to keep data private. If you want to download that private data using the “read.socrata()” function, you may use your Socrata credentials to complete that task.

These are a couple of great features that were added by the open source community. There have been dozens of contributions to City of Chicago open source projects, which have helped our team and also helped others who use this software. Thanks to all of those who have contributed to this project, especially John Malc and Mark Silverberg.

If you’re interested in other open source projects by the city, take a look at http://chicago.github.io for a list of active projects.

Feature image modified from “R Graffiti” by David Goehring and licensed under Creative Commons Attribution 2.0 Generic (CC BY 2.0).

Tagged with →  
Share →