fastCRW Pergamon
Government · US
data.bayareametro.gov
data.bayareametro.gov
Socrata open data portal at data.bayareametro.gov, publishing 3423 public datasets from the publishing organisation, led by the Environment category.
Showing the catalogue
GET /v1/data/data-bayareametro-gov/catalog-search1Request
Full-text query over dataset names and descriptions.
Zero-based offset into the results; step by 20 to page.
1 credit⌘ ↵
Code follows the fields above
curl "https://api.fastcrw.com/v1/data/data-bayareametro-gov/catalog-search?offset=0" \ -H "Authorization: Bearer $FASTCRW_API_KEY"
2Response example
A sample shape. Press Run to see live data from data.bayareametro.gov.
JSON
{
"results": [
{
"resource": {
"name": "Vital Signs: Life Expectancy – by ZIP Code",
"id": "xym8-u3kc",
"resource_name": null,
"parent_fxf": [],
"description": "VITAL SIGNS INDICATOR\r\nLife Expectancy (EQ6)\r\n\r\nFULL MEASURE NAME\r\nLife Expectancy\r\n\r\nLAST UPDATED\r\nApril 2017\r\n\r\nDESCRIPTION\r\nLife expectancy refers to the average number of years a newborn is expected to live if mortality patterns remain the same. The measure reflects the mortality rate across a population for a point in time.\r\n\r\nDATA SOURCE\r\nState of California, Department of Health: Death Records\r\n(1990-2013)\r\nNo link\r\n\r\nCalifornia Department of Finance: Population Estimates\r\nAnnual Intercensal Population Estimates (1990-2010)\r\nTable P-2: County Population by Age (2010-2013)\r\nhttp://www.dof.ca.gov/Forecasting/Demographics/Estimates/\r\n\r\nU.S. Census Bureau: Decennial Census\r\nZCTA Population (2000-2010)\r\nhttp://factfinder.census.gov\r\n\r\nU.S. Census Bureau: American Community Survey\r\n5-Year Population Estimates (2013)\r\nhttp://factfinder.census.gov\r\n\r\nCONTACT INFORMATION\r\nvitalsigns.info@mtc.ca.gov\r\n\r\nMETHODOLOGY NOTES (across all datasets for this indicator)\r\nLife expectancy is commonly used as a measure of the health of a population. Life expectancy does not reflect how long any given individual is expected to live; rather, it is an artificial measure that captures an aspect of the mortality rates across a population that can be compared across time and populations. More information about the determinants of life expectancy that may lead to differences in life expectancy between neighborhoods can be found in the Bay Area Regional Health Inequities Initiative (BARHII) Health Inequities in the Bay Area report at http://www.barhii.org/wp-content/uploads/2015/09/barhii_hiba.pdf. Vital Signs measures life expectancy at birth (as opposed to cohort life expectancy). A statistical model was used to estimate life expectancy for Bay Area counties and ZIP Codes based on current life tables which require both age and mortality data. A life table is a table which shows, for each age, the survivorship of a people from a certain population.\r\n\r\nCurrent life tables were created usi…",
"attribution": "State of California, Department of Health: Death Records",
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2018-07-06T18:05:06.000Z",
"createdAt": "2017-03-22T22:34:39.000Z",
"metadata_updated_at": "2018-07-06T18:05:06.000Z",
"data_updated_at": "2017-04-12T20:02:47.000Z",
"page_views": {
"page_views_last_week": 13,
"page_views_last_month": 42,
"page_views_total": 4970,
"page_views_last_week_log": 3.8073549220576037,
"page_views_last_month_log": 5.426264754702098,
"page_views_total_log": 12.27932038794261
},
"columns_name": [
"Life Expectancy",
"Year",
"Zipcode"
],
"columns_field_name": [
"life_expectancy",
"year",
"zipcode"
],
"columns_datatype": [
"Number",
"Number",
"Text"
],
"columns_description": [
"",
"",
""
],
"columns_format": [
{
"precisionStyle": "standard",
"noCommas": "false",
"precision": "2",
"align": "right"
},
{
"precisionStyle": "standard",
"noCommas": "true",
"align": "right"
},
{}
],
"download_count": 336,
"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": "2017-04-12T20:03:45.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [
"vital signs"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.bayareametro.gov"
},
"permalink": "https://data.bayareametro.gov/d/xym8-u3kc",
"link": "https://data.bayareametro.gov/dataset/Vital-Signs-Life-Expectancy-by-ZIP-Code/xym8-u3kc",
"owner": {
"id": "wg3i-tdm6",
"user_type": "interactive",
"display_name": "Raleigh McCoy"
},
"creator": {
"id": "wg3i-tdm6",
"user_type": "interactive",
"display_name": "Raleigh McCoy"
}
},
{
"resource": {
"name": "Projections 2040 by Jurisdiction",
"id": "grqz-amra",
"resource_name": null,
"parent_fxf": [],
"description": "Forecasts for Year 2010 through 2040 containing values for Households by Inc. Quartile; Households; Jobs; Population by Gender, Age; Units; Employed Residents; Population by Age; Population for jurisdictions in the nine county San Francisco Bay Area region.",
"attribution": "Association of Bay Area Governments",
"attribution_link": "https://abag.ca.gov/planning/research/forecasts.html",
"contact_email": null,
"type": "dataset",
"updatedAt": "2019-05-01T23:00:49.000Z",
"createdAt": "2018-12-26T22:58:22.000Z",
"metadata_updated_at": "2019-05-01T23:00:42.000Z",
"data_updated_at": "2019-05-01T23:00:49.000Z",
"page_views": {
"page_views_last_week": 5,
"page_views_last_month": 24,
"page_views_total": 3362,
"page_views_last_week_log": 2.584962500721156,
"page_views_last_month_log": 4.643856189774724,
"page_views_total_log": 11.715533063526584
},
"columns_name": [
"Source",
"Value",
"Category",
"Sort_Order",
"County",
"Year",
"Jurisdiction",
"Variable"
],
"columns_field_name": [
"source",
"value",
"category",
"sort_order",
"county",
"year",
"jurisdiction",
"variable"
],
"columns_datatype": [
"Text",
"Number",
"Text",
"Number",
"Text",
"Text",
"Text",
"Text"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
""
],
"columns_format": [
{},
{
"precision": "2"
},
{},
{},
{},
{},
{},
{}
],
"download_count": 470,
"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": "2019-01-11T20:08:29.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Demography",
"domain_tags": [
"plan bay area 2040",
"forecasts",
"projections"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.bayareametro.gov",
"license": "Creative Commons 1.0 Universal (Public Domain Dedication)"
},
"permalink": "https://data.bayareametro.gov/d/grqz-amra",
"link": "https://data.bayareametro.gov/Demography/Projections-2040-by-Jurisdiction/grqz-amra",
"owner": {
"id": "43ws-93gp",
"user_type": "interactive",
"display_name": "Aksel"
},
"creator": {
"id": "43ws-93gp",
"user_type": "interactive",
"display_name": "Aksel"
}
},
{
"resource": {
"name": "Basis Master Data Management",
"id": "2cj2-jfbr",
"resource_name": null,
"parent_fxf": [],
"description": "This list identifies data that has been collected for the Bay Area Spatial Information System platform. These datasets support MTC's Analytical Services and Long range Planning efforts and drive decision making and policy development across the agency. The data is managed by the Data & Visualization Team, with assistance from key staff that have been identified as Data Stewards in various units across the agency. Data is stored and managed within MTC's Enterprise Data Lake, and disseminated through the Socrata Connected Government Cloud as a Service (DaaS).",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2021-02-11T23:02:27.000Z",
"createdAt": "2019-05-15T18:53:12.000Z",
"metadata_updated_at": "2021-02-11T23:02:27.000Z",
"data_updated_at": "2021-02-11T23:02:17.000Z",
"page_views": {
"page_views_last_week": 8,
"page_views_last_month": 17,
"page_views_total": 2714,
"page_views_last_week_log": 3.1699250014423126,
"page_views_last_month_log": 4.169925001442312,
"page_views_total_log": 11.406736482691723
},
"columns_name": [
"Update Frequency",
"basisID",
"Jurisdiction Contact",
"Description",
"Unit of Analysis",
"Format",
"In Review",
"Publishing Status",
"Principal Use",
"Data Steward",
"… 17 more items"
],
"columns_field_name": [
"update_frequency",
"basisid",
"jurisdiction_contact",
"description",
"unit_of_analysis",
"format",
"in_review",
"publishing_status",
"principal_use",
"data_steward",
"… 17 more items"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Checkbox",
"Text",
"Text",
"Text",
"… 17 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"Flag signifying whether dataset is under review or not.",
"",
"",
"",
"… 17 more items"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
"… 17 more items"
],
"download_count": 284,
"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": "2021-02-11T23:02:27.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [
"mdm",
"basis"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.bayareametro.gov"
},
"permalink": "https://data.bayareametro.gov/d/2cj2-jfbr",
"link": "https://data.bayareametro.gov/dataset/Basis-Master-Data-Management/2cj2-jfbr",
"owner": {
"id": "cjsz-ha45",
"user_type": "interactive",
"display_name": "jspencer"
},
"creator": {
"id": "cjsz-ha45",
"user_type": "interactive",
"display_name": "jspencer"
}
},
{
"resource": {
"name": "earthquake_deaggregation_region",
"id": "f7m4-hw82",
"resource_name": null,
"parent_fxf": [
"rzg3-64st"
],
"description": "gis.hazrd.earthquake_deaggregation_region",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "map",
"updatedAt": "2026-10-06T20:27:29.000Z",
"createdAt": "2023-11-16T03:30:23.000Z",
"metadata_updated_at": "2026-10-06T20:27:29.000Z",
"data_updated_at": "2024-07-16T02:52:14.000Z",
"page_views": {
"page_views_last_week": 35,
"page_views_last_month": 79,
"page_views_total": 2570,
"page_views_last_week_log": 5.169925001442312,
"page_views_last_month_log": 6.321928094887362,
"page_views_total_log": 11.328113894833656
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 0,
"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": "2023-11-16T03:30:24.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.bayareametro.gov"
},
"permalink": "https://data.bayareametro.gov/d/f7m4-hw82",
"link": "https://data.bayareametro.gov/dataset/earthquake_deaggregation_region/f7m4-hw82",
"owner": {
"id": "gmr7-ynpt",
"user_type": "interactive",
"display_name": "Kearey Smith"
},
"creator": {
"id": "gmr7-ynpt",
"user_type": "interactive",
"display_name": "Kearey Smith"
}
},
{
"resource": {
"name": "Bay Area Census - Households - 2010",
"id": "xh6n-ybth",
"resource_name": null,
"parent_fxf": [],
"description": "Draft dataset for Bay Area Census website prototype. Includes census 2010 households data. Households by marriage, family, and ownership status, as well as householder sex and size.",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2024-10-19T17:07:53.000Z",
"createdAt": "2024-10-18T23:02:50.000Z",
"metadata_updated_at": "2024-10-19T17:07:52.000Z",
"data_updated_at": "2024-10-19T17:07:53.000Z",
"page_views": {
"page_views_last_week": 1,
"page_views_last_month": 3,
"page_views_total": 2474,
"page_views_last_week_log": 1,
"page_views_last_month_log": 2,
"page_views_total_log": 11.273212809854336
},
"columns_name": [
"Five",
"Three",
"Owner, husband-wife",
"Owner, non-family",
"Owned with a mortgage or a loan",
"Seven Plus",
"Six",
"Four",
"Two",
"One",
"… 10 more items"
],
"columns_field_name": [
"five",
"three",
"owner_husband_wife",
"owner_non_family",
"owned_with_a_mortgage_or",
"seven_plus",
"six",
"four",
"two",
"one",
"… 10 more items"
],
"columns_datatype": [
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"… 10 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 10 more items"
],
"columns_format": [
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
"… 10 more items"
],
"download_count": 22,
"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": "2024-10-18T23:04:04.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Demography",
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.bayareametro.gov"
},
"permalink": "https://data.bayareametro.gov/d/xh6n-ybth",
"link": "https://data.bayareametro.gov/Demography/Bay-Area-Census-Households-2010/xh6n-ybth",
"owner": {
"id": "rk9g-f4it",
"user_type": "interactive",
"display_name": "Joshua Croff"
},
"creator": {
"id": "rk9g-f4it",
"user_type": "interactive",
"display_name": "Joshua Croff"
}
},
{
"resource": {
"name": "Bay Area Census - Population - 2010 (Draft)",
"id": "nerw-7fgs",
"resource_name": null,
"parent_fxf": [],
"description": "Draft dataset for Bay Area Census website prototype. Includes census 2010 population breakdown by age, sex and race.",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2024-09-07T18:41:22.000Z",
"createdAt": "2024-09-07T18:37:33.000Z",
"metadata_updated_at": "2024-09-07T18:41:22.000Z",
"data_updated_at": "2024-09-07T18:41:10.000Z",
"page_views": {
"page_views_last_week": 0,
"page_views_last_month": 2,
"page_views_total": 2405,
"page_views_last_week_log": 0,
"page_views_last_month_log": 1.5849625007211563,
"page_views_total_log": 11.232420927176076
},
"columns_name": [
"Share Total 15 to 17",
"Total 40 to 44",
"Total 50 to 54",
"Total 60 to 61",
"Total 62 to 64",
"Total 65 to 66",
"Total 67 to 69",
"Total 70 to 74",
"Total 75 to 79",
"Total 80 to 84",
"… 156 more items"
],
"columns_field_name": [
"share_total_15_to_17",
"total_40_to_44",
"total_50_to_54",
"total_60_to_61",
"total_62_to_64",
"total_65_to_66",
"total_67_to_69",
"total_70_to_74",
"total_75_to_79",
"total_80_to_84",
"… 156 more items"
],
"columns_datatype": [
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"… 156 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 156 more items"
],
"columns_format": [
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
"… 156 more items"
],
"download_count": 45,
"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": "2024-09-07T18:41:22.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.bayareametro.gov"
},
"permalink": "https://data.bayareametro.gov/d/nerw-7fgs",
"link": "https://data.bayareametro.gov/dataset/Bay-Area-Census-Population-2010-Draft-/nerw-7fgs",
"owner": {
"id": "33wu-e648",
"user_type": "interactive",
"display_name": "Michael Ziyambi"
},
"creator": {
"id": "33wu-e648",
"user_type": "interactive",
"display_name": "Michael Ziyambi"
}
},
{
"resource": {
"name": "HCD Annual Progress Report - Permits (2023)",
"id": "47gz-f4yn",
"resource_name": null,
"parent_fxf": [
"cpvv-azba"
],
"description": "This dataset contains permitted housing projects collected by the California Department of Housing and Community Development (HCD) in 2023 as part of the Regional Housing Needs Allocation (RHNA) Cycle 6 Annual Progress Report (APR) process. The dataset has been de-duplicated, meaning only records where the APR year matches the permit issue year are included. Permits submitted in future APRs have been removed.\n\nData were downloaded on December 3, 2023, and represent a snapshot of the APR source dataset, enriched with additional attributes to support regional housing and land use work.\n\nJurisdictions submit updated APRs to HCD annually on April 1 and may submit corrections at any time throughout the year. As a result, discrepancies in reported unit counts may exist between this dataset and the data available on HCD’s website.\n\nFor the most up-to-date data, refer to: https://www.hcd.ca.gov/planning-and-community-development/housing-element-implementation-and-apr-dashboard",
"attribution": "California Housing and Community Development",
"attribution_link": "https://data.ca.gov/dataset/housing-element-annual-progress-report-apr-data-by-jurisdiction-and-year/resource/fe505d9b-8c36-42ba-ba30-08bc4f34e022",
"contact_email": null,
"type": "filter",
"updatedAt": "2025-03-19T23:51:15.000Z",
"createdAt": "2025-03-19T23:12:38.000Z",
"metadata_updated_at": "2025-03-19T23:51:15.000Z",
"data_updated_at": "2025-03-19T17:45:04.000Z",
"page_views": {
"page_views_last_week": 9,
"page_views_last_month": 47,
"page_views_total": 2345,
"page_views_last_week_log": 3.3219280948873626,
"page_views_last_month_log": 5.584962500721157,
"page_views_total_log": 11.19598729802851
},
"columns_name": [
"MTC_WKT",
"DEM_DES_UNITS",
"INFILL_UNITS",
"APPROVE_SB35",
"YEAR",
"DENSITY_BONUS_NUMBER_OTHER_INCENTIVES",
"MTC_PERMIT",
"MTC_PERMIT_DATE",
"MTC_ADDRESS_FULL",
"MTC_GEOCODE_ADDRESS",
"… 42 more items"
],
"columns_field_name": [
"mtc_wkt",
"dem_des_units",
"infill_units",
"approve_sb35",
"year",
"density_bonus_number_other_incentives",
"mtc_permit",
"mtc_permit_date",
"mtc_address_full",
"mtc_geocode_address",
"… 42 more items"
],
"columns_datatype": [
"Point",
"Number",
"Text",
"Text",
"Number",
"Number",
"Checkbox",
"Calendar date",
"Text",
"Text",
"… 42 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 42 more items"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
"… 42 more items"
],
"download_count": 36,
"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": "2025-03-19T23:12:58.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Development",
"domain_tags": [
"mdm",
"permit",
"housing",
"hcd"
],
"domain_metadata": [
{
"key": "Data-Management_Format",
"value": "geo"
}
]
},
"metadata": {
"domain": "data.bayareametro.gov"
},
"permalink": "https://data.bayareametro.gov/d/47gz-f4yn",
"link": "https://data.bayareametro.gov/Development/HCD-Annual-Progress-Report-Permits-2023-/47gz-f4yn",
"owner": {
"id": "rk9g-f4it",
"user_type": "interactive",
"display_name": "Joshua Croff"
},
"creator": {
"id": "rk9g-f4it",
"user_type": "interactive",
"display_name": "Joshua Croff"
}
},
{
"resource": {
"name": "HCD Annual Progress Report - Permits (2014 - 2022)",
"id": "xegb-bunf",
"resource_name": null,
"parent_fxf": [
"pbci-k8ps"
],
"description": "This dataset contains housing permit projects collected by MTC/ABAG from 2014-2017 and permit data collected by California Housing and Community Development between 2018-2022. The HCD features are de-duplicated, meaning the APR year and permit Issue year are equal, so permits submitted as part of future year APRs were removed.",
"attribution": "California Housing and Community Development",
"attribution_link": "https://data.ca.gov/dataset/housing-element-annual-progress-report-apr-data-by-jurisdiction-and-year/resource/fe505d9b-8c36-42ba-ba30-08bc4f34e022",
"contact_email": null,
"type": "filter",
"updatedAt": "2025-03-18T22:55:29.000Z",
"createdAt": "2023-12-12T21:34:28.000Z",
"metadata_updated_at": "2025-03-18T22:55:29.000Z",
"data_updated_at": "2025-03-18T22:35:17.000Z",
"page_views": {
"page_views_last_week": 21,
"page_views_last_month": 64,
"page_views_total": 2342,
"page_views_last_week_log": 4.459431618637297,
"page_views_last_month_log": 6.022367813028454,
"page_views_total_log": 11.194141238863136
},
"columns_name": [
"BP_ISSUE_DT1",
"INFILL_UNITS",
"DR_TYPE",
"NO_FA_DR",
"NOTES",
"DENSITY_BONUS_INCENTIVES",
"DENSITY_BONUS_NUMBER_OTHER_INCENTIVES",
"DENSITY_BONUS_TOTAL",
"DEM_DES_UNITS_OWN_RENT",
"DEM_OR_DES_UNITS",
"… 42 more items"
],
"columns_field_name": [
"bp_issue_dt1",
"infill_units",
"dr_type",
"no_fa_dr",
"notes",
"density_bonus_incentives",
"density_bonus_number_other_incentives",
"density_bonus_total",
"dem_des_units_own_rent",
"dem_or_des_units",
"… 42 more items"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Number",
"Number",
"Text",
"Text",
"… 42 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 42 more items"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
"… 42 more items"
],
"download_count": 88,
"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": "2023-12-12T21:36:08.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Development",
"domain_tags": [
"hcd",
"permit",
"mdm",
"housing"
],
"domain_metadata": [
{
"key": "Data-Management_Format",
"value": "geo"
},
{
"key": "Data-Management_Documentation-Link",
"value": "https://github.com/BayAreaMetro/DataServices/tree/master/Project-Documentation/hcd"
}
]
},
"metadata": {
"domain": "data.bayareametro.gov"
},
"permalink": "https://data.bayareametro.gov/d/xegb-bunf",
"link": "https://data.bayareametro.gov/Development/HCD-Annual-Progress-Report-Permits-2014-2022-/xegb-bunf",
"owner": {
"id": "rk9g-f4it",
"user_type": "interactive",
"display_name": "Joshua Croff"
},
"creator": {
"id": "rk9g-f4it",
"user_type": "interactive",
"display_name": "Joshua Croff"
}
},
{
"resource": {
"name": "Plan Bay Area 2050 Transportation Project List",
"id": "y7ka-jksz",
"resource_name": null,
"parent_fxf": [],
"description": "Final Transportation Project List for Plan Bay Area 2050, the long-range plan for the nine-county San Francisco Bay Area. For more information, see planbayarea.org",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2021-10-20T22:52:03.000Z",
"createdAt": "2021-10-13T16:30:45.000Z",
"metadata_updated_at": "2021-10-20T22:52:03.000Z",
"data_updated_at": "2021-10-20T22:51:57.000Z",
"page_views": {
"page_views_last_week": 12,
"page_views_last_month": 26,
"page_views_total": 2092,
"page_views_last_week_log": 3.700439718141092,
"page_views_last_month_log": 4.754887502163469,
"page_views_total_log": 11.031356596255709
},
"columns_name": [
"Open Period",
"county",
"Scope",
"Funding (millions, YOE)",
"RTPID",
"Title",
"Plan Strategy"
],
"columns_field_name": [
"open_period",
"county",
"scope",
"funding_millions_yoe",
"rtpid",
"title",
"plan_strategy"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Number",
"Text",
"Text",
"Text"
],
"columns_description": [
"Estimated opening date range, 2021-2035 or 2036-2050. Programs that have elements with opening dates in both ranges are shown as Various",
"County where component projects would be implemented. A value of Various indicates that investments could span multiple counties. A value of Regional indicates investment could span all Bay Area counties. ",
"Program description",
"Program funding, in millions of inflation-adjusted year-of-expenditure dollars. Funding includes both capital and operations and maintenance costs",
"Regional Transportation Plan identification number",
"Program name",
"Corresponding Transportation or Environment Element strategy"
],
"columns_format": [
{},
{},
{},
{
"precisionStyle": "currency",
"currencyStyle": "USD"
},
{},
{},
{}
],
"download_count": 448,
"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": "2021-10-20T22:52:03.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Projects",
"domain_tags": [
"plan bay area 2050"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.bayareametro.gov"
},
"permalink": "https://data.bayareametro.gov/d/y7ka-jksz",
"link": "https://data.bayareametro.gov/Projects/Plan-Bay-Area-2050-Transportation-Project-List/y7ka-jksz",
"owner": {
"id": "33wu-e648",
"user_type": "interactive",
"display_name": "Michael Ziyambi"
},
"creator": {
"id": "33wu-e648",
"user_type": "interactive",
"display_name": "Michael Ziyambi"
}
},
{
"resource": {
"name": "CEQA Roadway Screening Tool - Cancer Risk",
"id": "kz4a-ueki",
"resource_name": null,
"parent_fxf": [],
"description": "This dataset (raster file (.tif), Cancer Risk, per million) provides the basis for the CEQA Roadway Screening Tool and is designed to assist project sponsors in conducting cumulative cancer risk and hazard analyses as part of their California Environmental Quality Act (CEQA) environmental review for proposed land use projects.\n\nPlease see attached README for additional details and disclaimer. Please review this document in detail before using the dataset.",
"attribution": "BAAQMD",
"attribution_link": null,
"contact_email": null,
"type": "file",
"updatedAt": "2022-12-08T20:29:14.000Z",
"createdAt": "2022-10-12T20:15:58.000Z",
"metadata_updated_at": "2022-12-08T20:29:14.000Z",
"data_updated_at": "2022-10-12T20:15:58.000Z",
"page_views": {
"page_views_last_week": 10,
"page_views_last_month": 86,
"page_views_total": 2090,
"page_views_last_week_log": 3.4594316186372978,
"page_views_last_month_log": 6.442943495848729,
"page_views_total_log": 11.029977346589579
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 399,
"provenance": "official",
"lens_view_type": "blobby",
"lens_display_type": "blob",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": "image/tiff",
"hide_from_data_json": false,
"publication_date": "2022-12-08T20:29:14.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Environment",
"domain_tags": [
"baaqmd",
"baaqmd-opendata"
],
"domain_metadata": [
{
"key": "Data-Management_ArcGIS-Online-Link",
"value": "url"
},
{
"key": "Data-Management_Documentation-Link",
"value": "See attached README"
},
{
"key": "Data-Management_Format",
"value": "geo"
},
{
"key": "Data-Management_Geographic-Location",
"value": "AD_Region - Bay Area"
},
{
"key": "Data-Management_Unit-of-Analysis",
"value": "Cancer Risk (per million)"
}
]
},
"metadata": {
"domain": "data.bayareametro.gov"
},
"permalink": "https://data.bayareametro.gov/d/kz4a-ueki",
"link": "https://data.bayareametro.gov/Environment/CEQA-Roadway-Screening-Tool-Cancer-Risk/kz4a-ueki",
"owner": {
"id": "s37r-2aca",
"user_type": "interactive",
"display_name": "Nick Tang"
},
"creator": {
"id": "s37r-2aca",
"user_type": "interactive",
"display_name": "Nick Tang"
}
},
"… 10 more items"
],
"resultSetSize": 3423,
"timings": {
"serviceMillis": 33,
"searchMillis": [
18,
5
]
},
"warnings": []
}Attribution: Source: data.bayareametro.gov. Dataset attribution as stated by each publishing agency.
Licence: Datasets on this portal declare the licence "Creative Commons 1.0 Universal (Public Domain Dedication)" in their Socrata metadata; the portal publishes no separate API licence and different datasets may carry different terms. Quoted as found in the portal's own catalogue.
Ask with this source
A prompt for your agent that names this source and how to call it through the crw MCP.
Catalogue search
Use data.bayareametro.gov (data-bayareametro-gov) 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 "data-bayareametro-gov" 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 data.bayareametro.gov (data-bayareametro-gov) 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=jgs2-s3bg. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-bayareametro-gov" 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 data.bayareametro.gov (data-bayareametro-gov) 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 "data-bayareametro-gov" 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 data.bayareametro.gov (data-bayareametro-gov) 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=jgs2-s3bg. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-bayareametro-gov" 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>