Data API

API Access

San Bernardino County Logo

ATC Open Data API Platform

Welcome to the San Bernardino County Treasurer-Tax Collector's Open Data API

Our API platform provides programmatic access to public data resources including:

  • Property tax information and payment records
  • Tax rate area data and historical trends
  • Payment statistics and regional analytics
  • Public financial reports and documents

This API enables developers, researchers, and the public to integrate county tax data into their applications while ensuring transparency and accessibility of public financial information.

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

Query Examples

Complex Search 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

API Response Format

All API calls return JSON in the following format:

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

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

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

Tag Operations

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

Get Data Dictionary:
/getDataDictionary

Get Dataset Info:
/getInfo

Data Access

Query Dataset:
/getData

File Downloads

Download Formats:
SQLite (.db), JSON (.json), XML (.xml)

Query Parameters for /getData
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 API Documentation