Developer API guide

Copy-ready endpoints from real source systems.

This guide turns the current CKAN datastore and ArcGIS selected-layer pull into practical API examples, source links, and a downloadable endpoint manifest.

Endpoint examples

CKAN datastore calls

ArcGIS REST calls

1,085,681

Rows/features represented

Endpoint manifest

The generated JSON export packages source URLs, request URLs, field lists, and row/feature counts for staff review or developer handoff.

Download endpoint manifest

Integration stance

Keep CKAN and ArcGIS as source systems of record.
Cache public bundles with timestamps and source URLs.
Expose direct API and download links on every dataset brief.
Use staff-reviewed summaries and tags, not hidden transformations.

CKAN datastore_search

San Jose Fire Incidents

95,838 rows with 15 fields surfaced in the current pull.

curl "https://data.sanjoseca.gov/api/3/action/datastore_search?resource_id=e465b97c-c209-412a-ba4d-cde03d655f44&limit=5"

Stoa page Official endpoint

CKAN datastore_search

Police-Calls-for-Service-Quarterly

70,731 rows with 15 fields surfaced in the current pull.

curl "https://data.sanjoseca.gov/api/3/action/datastore_search?resource_id=0c2871c4-18fd-4b34-88e9-8d0a2164d479&limit=5"

Stoa page Official endpoint

CKAN datastore_search

Last 60-180 days Planning Permits

465 rows with 17 fields surfaced in the current pull.

curl "https://data.sanjoseca.gov/api/3/action/datastore_search?resource_id=a6df12fb-ca4b-49e8-8cde-d444b112877b&limit=5"

Stoa page Official endpoint

CKAN datastore_search

Illegal Dumping Locations

205,139 rows with 25 fields surfaced in the current pull.

curl "https://data.sanjoseca.gov/api/3/action/datastore_search?resource_id=7f32d866-c22a-40c0-b4bb-bfa557cd0384&limit=5"

Stoa page Official endpoint

CKAN datastore_search

Affordable Rental Housing

244 rows with 37 fields surfaced in the current pull.

curl "https://data.sanjoseca.gov/api/3/action/datastore_search?resource_id=20a977f9-0946-410b-9cb6-35535d242c05&limit=5"

Stoa page Official endpoint

CKAN datastore_search

Bike Racks

1,066 rows with 18 fields surfaced in the current pull.

curl "https://data.sanjoseca.gov/api/3/action/datastore_search?resource_id=d545137d-4f71-402c-8bac-ebce442560a9&limit=5"

Stoa page Official endpoint

CKAN datastore_search

311 Service Request Data

88,756 rows with 10 fields surfaced in the current pull.

curl "https://data.sanjoseca.gov/api/3/action/datastore_search?resource_id=6399d341-880c-49eb-8cb6-5fb294bf48dc&limit=5"

Stoa page Official endpoint

ArcGIS REST query

Police Stations

0 records with 17 fields surfaced in the current pull.

curl "https://geo.sanjoseca.gov/server/rest/services/OPN/OPN_OpenDataService/MapServer/126/query?where=1%3D1&outFields=*&f=json&resultRecordCount=5"

Stoa page Official endpoint

Try it live

Build your own API query

Pick a dataset, choose the fields you want, and get a paste-ready CKAN datastore_search URL — then run it against the City’s live API right here.

Dataset Rows

Fields (all)

Request URL

Open in new tab

Endpoint inventory

Source	API type	Count	Fields	Endpoint
San Jose Fire Incidents	CKAN datastore_search	95,838 rows	15	Official request
Police-Calls-for-Service-Quarterly	CKAN datastore_search	70,731 rows	15	Official request
Last 60-180 days Planning Permits	CKAN datastore_search	465 rows	17	Official request
Illegal Dumping Locations	CKAN datastore_search	205,139 rows	25	Official request
Affordable Rental Housing	CKAN datastore_search	244 rows	37	Official request
Bike Racks	CKAN datastore_search	1,066 rows	18	Official request
311 Service Request Data	CKAN datastore_search	88,756 rows	10	Official request
Police Stations	ArcGIS REST query	0 records	17	Official request
Crash Locations Last Five Years	ArcGIS REST query	24,334 records	20	Official request
Heritage Trees	ArcGIS REST query	110 records	20	Official request
Street Trees	ArcGIS REST query	345,489 records	20	Official request
City Owned Traffic Signals	ArcGIS REST query	1,286 records	20	Official request
Pavement Projects Current	ArcGIS REST query	1,098 records	20	Official request
Illegal Dumping	ArcGIS REST query	240,519 records	20	Official request
Affordable Rental Housing	ArcGIS REST query	251 records	20	Official request
Downtown Parking Lots	ArcGIS REST query	88 records	20	Official request
Vision Zero Safety Corridors	ArcGIS REST query	31 records	15	Official request
Average Daily Traffic	ArcGIS REST query	2,399 records	19	Official request
Road Closures	ArcGIS REST query	7,837 records	20	Official request

BI & analytics tools

Feed Power BI, Tableau, and notebooks directly

Power BI / Tableau

Both tools consume these endpoints with no middleware. In Power BI use Get Data → Web with a datastore_search or ArcGIS query URL; in Tableau use a Web Data Connector or the JSON endpoint. Every row count on this page is a live, paste-ready source.

Python / R / notebooks

The same CKAN datastore_search and ArcGIS REST URLs return JSON for pandas.read_json / httr, and GeoJSON (f=geojson) for GeoPandas — so analysts can pull San José open data straight into a notebook.