API Documentation

Programmatic access to San Bernardino County's Open Data resources

ATC Open Data API Platform

Our API provides programmatic access to public data resources including property tax information, tax rate area data, payment statistics, and public financial reports.

All API endpoints return JSON formatted responses and support standard query parameters for filtering, sorting, and pagination.

API Response Format

All API calls return JSON in the following structure:

{
  "success": true,
  "result": {
    // The actual data you requested
  },
  "help": "API documentation string"
}

CKAN Standard API

Dataset Search

Basic Search

Search all datasets:

https:///api/3/action/package_search

Search by title:

https:///api/3/action/package_search?q=title:finance

Advanced Filtering

Filter by multiple fields:

https:///api/3/action/package_search?fq=tags:"finance"+organization:"treasury"

Limit results and sort:

https:///api/3/action/package_search?q=budget&rows=10&sort=metadata_modified desc

Complex Query Examples

Datasets modified in last month with specific tag:

https:///api/3/action/package_search?fq=metadata_modified:[NOW-30DAY TO NOW]+tags:economy

Datasets from specific organization with format:

https:///api/3/action/package_search?fq=organization:finance-dept+res_format:CSV

Full-text search with multiple filters:

https:///api/3/action/package_search?q=budget&fq=tags:"2024"+res_format:JSON&sort=score desc

Dataset & Resource Access

Dataset Operations

Get dataset details:

https:///api/3/action/package_show?id=dataset-name

List all datasets:

https:///api/3/action/package_list

Resource Operations

Get resource details:

https:///api/3/action/resource_show?id=resource-id

Search resources:

https:///api/3/action/resource_search?query=name:data.csv

Organizations & Groups

Organization API

List all organizations:

https:///api/3/action/organization_list

Show organization details:

https:///api/3/action/organization_show?id=org-name&include_datasets=true

Group API

List all groups:

https:///api/3/action/group_list

Show group details:

https:///api/3/action/group_show?id=group-name&include_datasets=true

Tags & Categories

List all tags:

https:///api/3/action/tag_list

Search tags:

https:///api/3/action/tag_search?query=finance

Show tag details:

https:///api/3/action/tag_show?id=tag-name

ATC Data API — Multi-Format Dataset Access

Enhanced Dataset API — Access converted datasets with advanced querying, filtering, and multiple output formats (SQLite, JSON, XML).

Base URL Pattern

https:///atc-api/v1/{dataset-id}/{endpoint}

Dataset Information

/getDataDictionary

/getInfo

Data Access

/getData

File Downloads

SQLite (.db), JSON (.json), XML (.xml)

Query Parameters for /getData

Query parameters for the getData endpoint
Parameter	Type	Default	Description	Example
`fromRow`	Integer	0	Starting row for pagination	`fromRow=0`
`limit`	Integer	500	Maximum rows to return (1-500)	`limit=100`
`orderByColumn`	String	—	Column name for sorting	`orderByColumn=Roll_Yr`
`orderDirection`	String	ASC	Sort direction: ASC or DESC	`orderDirection=DESC`
`whereColumn`	String	—	Column name to filter by	`whereColumn=Roll_Yr`
`whereValue`	String	—	Value to filter by	`whereValue=2024`
`whereOperator`	String	equal	Comparison operator	`whereOperator=greaterThan`

Available Operators

equal — Equals (=)
notEqual — Not equals (!=)
greaterThan — Greater than (>)
lessThan — Less than (<)

greaterThanOrEqual — Greater than or equal (>=)
lessThanOrEqual — Less than or equal (<=)
IN — Value in list (comma-separated)
notIN — Value not in list

ATC Data API Examples

Get first 10 rows of a dataset:

https:///atc-api/v1/{dataset-id}/getData?fromRow=0&limit=10

Filter by year 2024:

https:///atc-api/v1/{dataset-id}/getData?whereColumn=Roll_Yr&whereValue=2024&whereOperator=equal

Filter values greater than 100000:

https:///atc-api/v1/{dataset-id}/getData?whereColumn=Total_Value&whereValue=100000&whereOperator=greaterThan

Filter multiple values (IN operator):

https:///atc-api/v1/{dataset-id}/getData?whereColumn=Roll_Yr&whereValue=2023,2024,2025&whereOperator=IN

Sort by Total Value (highest first):

https:///atc-api/v1/{dataset-id}/getData?orderByColumn=Total_Value&orderDirection=DESC

Sort by Account Number (ascending):

https:///atc-api/v1/{dataset-id}/getData?orderByColumn=Account_Number&orderDirection=ASC

Filter 2024 data, sort by value, paginate:

https:///atc-api/v1/{dataset-id}/getData?whereColumn=Roll_Yr&whereValue=2024&whereOperator=equal&orderByColumn=Total_Value&orderDirection=DESC&fromRow=0&limit=50

Get high-value properties (> $500,000):

https:///atc-api/v1/{dataset-id}/getData?whereColumn=Total_Assessed_Value_New&whereValue=500000&whereOperator=greaterThan&orderByColumn=Total_Assessed_Value_New&orderDirection=DESC

Get column information (data dictionary):

https:///atc-api/v1/{dataset-id}/getDataDictionary

Get dataset information and statistics:

https:///atc-api/v1/{dataset-id}/getInfo

For complete documentation, see the CKAN

Official CKAN API Documentation