read.socrata: Get a full Socrata data set as an R data frame
In RSocrata: Download or Upload 'Socrata' Data Sets

View source: R/RSocrata.R

read.socrata

R Documentation

Get a full Socrata data set as an R data frame

Description

Manages throttling and POSIX date-time conversions

Usage

read.socrata(
  url,
  app_token = NULL,
  email = NULL,
  password = NULL,
  stringsAsFactors = FALSE
)

Arguments

`url`	- A Socrata resource URL, or a Socrata "human-friendly" URL, or Socrata Open Data Application Program Interface (SODA) query requesting a comma-separated download format (.csv suffix), May include SoQL parameters, but is assumed to not include a SODA offset parameter
`app_token`	- a string; SODA API token used to query the data portal https://dev.socrata.com/consumers/getting-started.html
`email`	- Optional. The email to the Socrata account with read access to the dataset
`password`	- Optional. The password associated with the email to the Socrata account
`stringsAsFactors`	- Optional. Should character columns be converted to factor (TRUE or FALSE)?

Value

an R data frame with POSIX dates

Author(s)

Hugh J. Devlin, Ph. D. Hugh.Devlin@cityofchicago.org

Examples

## Not run: 
# Human-readable URL:
url <- "https://soda.demo.socrata.com/dataset/USGS-Earthquakes-for-2012-11-01-API/4334-bgaj"
df <- read.socrata(url)
# SoDA URL:
df <- read.socrata("https://soda.demo.socrata.com/resource/4334-bgaj.csv")
# Download private dataset
socrataEmail <- Sys.getenv("SOCRATA_EMAIL", "mark.silverberg+soda.demo@socrata.com")
socrataPassword <- Sys.getenv("SOCRATA_PASSWORD", "7vFDsGFDUG")
privateResourceToReadCsvUrl <- "https://soda.demo.socrata.com/resource/a9g2-feh2.csv" # dataset
read.socrata(url = privateResourceToReadCsvUrl, email = socrataEmail, password = socrataPassword)
# Using an API key to read datasets (reduces throttling)
token <- "ew2rEMuESuzWPqMkyPfOSGJgE"
df <- read.socrata("https://soda.demo.socrata.com/resource/4334-bgaj.csv", 
                   app_token = token)
nrow(df)
closeAllConnections()

## End(Not run)

RSocrata documentation built on Aug. 31, 2023, 9:07 a.m.