boulderco.data.socrata.com
Open data portalsboulderco.data.socrata.com
Socrata open data portal at boulderco.data.socrata.com, publishing 8 public datasets from the publishing organisation.
Capabilities (5)
GET /v1/data/boulderco-data-socrata-com/catalog-search1 creditKeyword search over the datasets published on boulderco.data.socrata.com: each hit carries the dataset id, name, description, attribution, category, tags, column names and last update time, plus the total match count.
GET /v1/data/boulderco-data-socrata-com/dataset1 creditThe complete metadata document for one dataset: name, description, attribution, licence, category, tags, all column definitions with data types, and the table id used for queries.
GET /v1/data/boulderco-data-socrata-com/datasets1 creditA page of the portal's own dataset records (id, name, description, category, attribution, creation and update timestamps, view count) without the full column metadata.
GET /v1/data/boulderco-data-socrata-com/row-count1 creditOne number: how many rows the dataset currently holds, as a SoQL count aggregate.
GET /v1/data/boulderco-data-socrata-com/rows1 creditThe first 100 rows of a dataset as JSON objects keyed by field name. Column names are the API field names, so they can be used directly in a later SoQL query.
Response example
The shape of data from boulderco-data-socrata-com/catalog-search (Catalogue search). A sample, not live data.
Example truncated, full shape in JSON from the API.
{
"results": [
{
"resource": {
"name": "Zoning",
"id": "auh5-4iv8",
"resource_name": null,
"parent_fxf": [
"8dht-tstn"
],
"description": "Zoning map of the City of Boulder, CO",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "map",
"updatedAt": "2026-10-06T21:29:55.000Z",
"createdAt": "2020-08-25T20:18:53.000Z",
"metadata_updated_at": "2026-10-06T21:29:55.000Z",
"data_updated_at": "2026-08-06T03:30:15.000Z",
"page_views": {
"page_views_last_week": 0,
"page_views_last_month": 1,
"page_views_total": 559,
"page_views_last_week_log": 0,
"page_views_last_month_log": 1,
"page_views_total_log": 9.129283016944967
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 10,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "visualization_canvas_map",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2020-08-25T20:18:55.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "boulderco.data.socrata.com"
},
"permalink": "https://boulderco.data.socrata.com/d/auh5-4iv8",
"link": "https://boulderco.data.socrata.com/dataset/Zoning/auh5-4iv8",
"owner": {
"id": "xiq3-38kp",
"user_type": "interactive",
"display_name": "ArcGIS Connector"
},
"creator": {
"id": "xiq3-38kp",
"user_type": "interactive",
"display_name": "ArcGIS Connector"
}
},
{
"resource": {
"name": "Zoning",
"id": "b73p-5552",
"resource_name": null,
"parent_fxf": [],
"description": "Zoning map of the City of Boulder, CO",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-08-04T14:50:34.000Z",
"createdAt": "2020-08-25T20:18:49.000Z",
"metadata_updated_at": "2020-08-25T20:18:50.000Z",
"data_updated_at": "2026-08-04T14:50:34.000Z",
"page_views": {
"page_views_last_week": 1,
"page_views_last_month": 2,
"page_views_total": 190,
"page_views_last_week_log": 1,
"page_views_last_month_log": 1.5849625007211563,
"page_views_total_log": 7.577428828035749
},
"columns_name": [
"ZONING",
"OBJECTID",
"ZONINGDISTPURPOSE",
"the_geom",
"SHAPE.STArea()",
"ZNDESC",
"SHAPE.STLength()"
],
"columns_field_name": [
"zoning",
"objectid",
"zoningdistpurpose",
"the_geom",
"shape_starea",
"zndesc",
"shape_stlength"
],
"columns_datatype": [
"Text",
"Number",
"Text",
"MultiPolygon",
"Number",
"Text",
"Number"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
""
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{}
],
"download_count": 57,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2020-08-25T20Ask with this source
A prompt for your agent that names this source and how to call it through the crw MCP.
Catalogue search
Use boulderco.data.socrata.com (boulderco-data-socrata-com) from fastCRW Pergamon, capability "Catalogue search" (catalog-search). You want to find a dataset on this portal by keyword and do not know its four-by-four id. Example options: q=taxi, offset=0, order=page_views_total DESC. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "boulderco-data-socrata-com" and capability "catalog-search". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Dataset metadata
Use boulderco.data.socrata.com (boulderco-data-socrata-com) from fastCRW Pergamon, capability "Dataset metadata" (dataset). You already hold a dataset id and need its columns, licence or description before querying rows. Example options: id=rbks-cx92. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "boulderco-data-socrata-com" and capability "dataset". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Dataset inventory
Use boulderco.data.socrata.com (boulderco-data-socrata-com) from fastCRW Pergamon, capability "Dataset inventory" (datasets). You need to enumerate what this portal publishes, or page through its newest datasets. Example options: offset=0, order=createdAt, category=Transportation. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "boulderco-data-socrata-com" and capability "datasets". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Row count
Use boulderco.data.socrata.com (boulderco-data-socrata-com) from fastCRW Pergamon, capability "Row count" (row-count). You need to know how large a dataset is before downloading it, or want a cheap liveness check. Example options: id=rbks-cx92. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "boulderco-data-socrata-com" and capability "row-count". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Licence
The City of Boulder grants you a world-wide, royalty-free, non-exclusive license to use, modify, and distribute the datasets in all current and future media and formats for any lawful purpose. The City of Boulder Open Data Catalog provides open data licensed under the Creative Commons CC Zero license (CC0 1.0).
https://bouldercolorado.gov/services/open-dataAttribution
Display this wherever you show the data. It arrives on every response as provenance.attribution_text.
Source: boulderco.data.socrata.com. Dataset attribution as stated by each publishing agency.
Cache: up to 3600s
