Package 'mtaOpenData'

Load Any MTA Open Data Dataset

Description

Downloads any MTA Open Data dataset given its Socrata JSON endpoint.

Usage

mta_any_dataset(
  json_link,
  limit = 10000,
  timeout_sec = 30,
  clean_names = TRUE,
  coerce_types = TRUE
)

Arguments

json_link	A Socrata dataset JSON endpoint URL (e.g., "https://data.ny.gov/resource/2ucp-7wg5.json").
limit	Number of rows to retrieve (default = 10,000).
timeout_sec	Request timeout in seconds (default = 30).
clean_names	Logical; if TRUE, convert column names to snake_case (default = TRUE).
coerce_types	Logical; if TRUE, attempt light type coercion (default = TRUE).

Value

A tibble containing the requested dataset.

Examples

# Examples that hit the live MTA Open Data API are guarded so CRAN checks
# do not fail when the network is unavailable or slow.
if (interactive() && curl::has_internet()) {
  endpoint <- "https://data.ny.gov/resource/2ucp-7wg5.json"
  out <- try(mta_any_dataset(endpoint, limit = 3), silent = TRUE)
  if (!inherits(out, "try-error")) {
    head(out)
  }
}

---

List datasets available in mtaOpenData

Description

Retrieves the current MTA Open Data catalog and returns datasets available for use with 'mta_pull_dataset()'.

Usage

mta_list_datasets()

Details

Keys are generated from dataset names using 'janitor::make_clean_names()'.

Value

A tibble of available datasets, including generated 'key', dataset 'uid', and dataset 'dataset_title'.

Examples

if (interactive() && curl::has_internet()) {
  mta_list_datasets()
}

---

Pull a MTA Open Data dataset from the MTA Open Data catalog

Description

Uses a dataset 'key' or 'open_dataset_id' from 'mta_list_datasets()' to pull data from MTA Open Data.

Usage

mta_pull_dataset(
  dataset,
  limit = 10000,
  filters = list(),
  date = NULL,
  from = NULL,
  to = NULL,
  date_field = NULL,
  where = NULL,
  order = NULL,
  timeout_sec = 30,
  clean_names = TRUE,
  coerce_types = TRUE
)

Arguments

dataset	A dataset key or open_dataset_id from 'mta_list_datasets()'.
limit	Number of rows to retrieve (default = 10,000).
filters	Optional named list of filters. Supports vectors (translated to IN()).
date	Optional single date (matches all times that day) using 'date_field'.
from	Optional start date (inclusive) using 'date_field'.
to	Optional end date (exclusive) using 'date_field'.
date_field	Optional date/datetime column to use with 'date', 'from', or 'to'. Must be supplied when 'date', 'from', or 'to' are used.
where	Optional raw SoQL WHERE clause. If 'date', 'from', or 'to' are provided, their conditions are AND-ed with this.
order	Optional SoQL ORDER BY clause.
timeout_sec	Request timeout in seconds (default = 30).
clean_names	Logical; if TRUE, convert column names to snake_case (default = TRUE).
coerce_types	Logical; if TRUE, attempt light type coercion (default = TRUE).

Details

Dataset keys are generated from dataset_title using 'janitor::make_clean_names()'. Because keys are derived from live catalog metadata, dataset open_dataset_ids are the more stable option.

Value

A tibble.

Examples

if (interactive() && curl::has_internet()) {
  # Pull by key
  mta_pull_dataset("mta_bus_stops", limit = 3)

  # Pull by open_dataset_id
  mta_pull_dataset("2ucp-7wg5", limit = 3)

  # Filters
  mta_pull_dataset("2ucp-7wg5", limit = 3, filters = list(route_id = "QM3"))

}

---