ckan_query: Function to pull data using SQL from CKAN

In childpovertyactionlab/CPAL: Custom Package for the Child Poverty Action Lab

Function to pull data using SQL from CKAN

Description

ckan_query allows users to pull data using a custom SQL query, with the option of adding geometry if present in the dataset. This function returns either a dataframe or a list including metadata and records.

Usage

ckan_query(sql_query, geometry = FALSE, nested = FALSE)

Arguments

sql_query	A string SQL query
geometry	Boolean indicating if dataframe contains geometry or not. If TRUE, function returns a geometry object ready for mapping
nested	Boolean indicating if function will return list including metadata and records. If FALSE, only records are returned

childpovertyactionlab/CPAL documentation built on Feb. 23, 2025, 8:19 a.m.