Portal de Dados Abertos da Cidade de São Paulo
dados.prefeitura.sp.gov.br
Open Data portal of the city of São Paulo, SP, in Brazil
GET /v1/data/dados-prefeitura-sp-gov-br/dataset1Request
The dataset's URL slug (its `name`) or its UUID. Both are accepted.
curl "https://api.fastcrw.com/v1/data/dados-prefeitura-sp-gov-br/dataset?id=manutencao-e-conservacao-de-galerias" \ -H "Authorization: Bearer $FASTCRW_API_KEY"
2Response example
A sample shape. Press Run to see live data from Portal de Dados Abertos da Cidade de São Paulo.
{
"help": "https://dados.prefeitura.sp.gov.br/api/3/action/help_show?name=package_show",
"success": true,
"result": {
"license_title": "Creative Commons Atribuição",
"maintainer": "",
"relationships_as_object": [],
"private": false,
"maintainer_email": "",
"num_tags": 3,
"id": "e239e5f2-cbcc-4535-8555-e49649af578a",
"metadata_created": "2026-10-21T13:24:21.229930",
"metadata_modified": "2026-10-21T13:33:37.910128",
"author": "",
"author_email": "guaianases@smsub.prefeitura.sp.gov.br",
"state": "active",
"version": "",
"creator_user_id": "707a3021-70d6-4700-b08b-a6ccd1a3ec62",
"type": "dataset",
"resources": [
{
"mimetype": "text/csv",
"cache_url": null,
"hash": "",
"description": "Informações sobre manutenção e conservação de galerias no território de Guaianases e Lajeado realizada em Janeiro.",
"name": "JANEIRO.csv",
"format": "CSV",
"url": "https://dados.prefeitura.sp.gov.br/dataset/e239e5f2-cbcc-4535-8555-e49649af578a/resource/db5360b3-4f69-4f68-a6eb-cecb06335621/download/janeiro.csv",
"datastore_active": false,
"cache_last_updated": null,
"package_id": "e239e5f2-cbcc-4535-8555-e49649af578a",
"created": "2026-10-21T13:25:29.807230",
"state": "active",
"mimetype_inner": null,
"last_modified": "2026-10-21T13:25:29.742536",
"position": 0,
"revision_id": "eba0246b-92bb-4d6b-a732-431042ea3ed9",
"url_type": "upload",
"id": "db5360b3-4f69-4f68-a6eb-cecb06335621",
"resource_type": null,
"size": 389
},
{
"mimetype": "application/pdf",
"cache_url": null,
"hash": "",
"description": "Informações sobre manutenção e conservação de galerias no território de Guaianases e Lajeado realizada em Janeiro",
"name": "JANEIRO.pdf",
"format": "PDF",
"url": "https://dados.prefeitura.sp.gov.br/dataset/e239e5f2-cbcc-4535-8555-e49649af578a/resource/7d1ef555-925e-4bbb-9c5b-04b2598bcc4c/download/janeiro.pdf",
"datastore_active": false,
"cache_last_updated": null,
"package_id": "e239e5f2-cbcc-4535-8555-e49649af578a",
"created": "2026-10-21T13:29:30.232533",
"state": "active",
"mimetype_inner": null,
"last_modified": "2026-10-21T13:29:30.131356",
"position": 1,
"revision_id": "724e3e74-fbcf-47fa-8fc7-c2dc47e262a6",
"url_type": "upload",
"id": "7d1ef555-925e-4bbb-9c5b-04b2598bcc4c",
"resource_type": null,
"size": 34784
},
{
"mimetype": "text/csv",
"cache_url": null,
"hash": "",
"description": "Informações sobre manutenção e conservação de galerias no território de Guaianases e Lajeado realizada em Fevereiro.",
"name": "FEVEREIRO.csv",
"format": "CSV",
"url": "https://dados.prefeitura.sp.gov.br/dataset/e239e5f2-cbcc-4535-8555-e49649af578a/resource/83bbd31b-6847-4fec-aa23-983223b84913/download/fevereiro.csv",
"datastore_active": false,
"cache_last_updated": null,
"package_id": "e239e5f2-cbcc-4535-8555-e49649af578a",
"created": "2026-10-21T13:26:13.233873",
"state": "active",
"mimetype_inner": null,
"last_modified": "2026-10-21T13:26:13.162020",
"position": 2,
"revision_id": "724e3e74-fbcf-47fa-8fc7-c2dc47e262a6",
"url_type": "upload",
"id": "83bbd31b-6847-4fec-aa23-983223b84913",
"resource_type": null,
"size": 389
},
{
"mimetype": "application/pdf",
"cache_url": null,
"hash": "",
"description": "Informações sobre manutenção e conservação de galerias no território de Guaianases e Lajeado realizada em Fevereiro",
"name": "FEVEREIRO.pdf",
"format": "PDF",
"url": "https://dados.prefeitura.sp.gov.br/dataset/e239e5f2-cbcc-4535-8555-e49649af578a/resource/b6511a63-0c53-406e-b655-797186d34389/download/fevereiro.pdf",
"datastore_active": false,
"cache_last_updated": null,
"package_id": "e239e5f2-cbcc-4535-8555-e49649af578a",
"created": "2026-10-21T13:30:00.528361",
"state": "active",
"mimetype_inner": null,
"last_modified": "2026-10-21T13:30:00.402670",
"position": 3,
"revision_id": "724e3e74-fbcf-47fa-8fc7-c2dc47e262a6",
"url_type": "upload",
"id": "b6511a63-0c53-406e-b655-797186d34389",
"resource_type": null,
"size": 34610
},
{
"mimetype": "text/csv",
"cache_url": null,
"hash": "",
"description": "Informações sobre manutenção e conservação de galerias no território de Guaianases e Lajeado realizada em Março.",
"name": "MARÇO.csv",
"format": "CSV",
"url": "https://dados.prefeitura.sp.gov.br/dataset/e239e5f2-cbcc-4535-8555-e49649af578a/resource/d8d81446-367f-42ff-8a6d-9e3b246f8a8d/download/marco.csv",
"datastore_active": false,
"cache_last_updated": null,
"package_id": "e239e5f2-cbcc-4535-8555-e49649af578a",
"created": "2026-10-21T13:26:28.492897",
"state": "active",
"mimetype_inner": null,
"last_modified": "2026-10-21T13:26:28.421429",
"position": 4,
"revision_id": "724e3e74-fbcf-47fa-8fc7-c2dc47e262a6",
"url_type": "upload",
"id": "d8d81446-367f-42ff-8a6d-9e3b246f8a8d",
"resource_type": null,
"size": 389
},
{
"mimetype": "application/pdf",
"cache_url": null,
"hash": "",
"description": "Informações sobre manutenção e conservação de galerias no território de Guaianases e Lajeado realizada em Março",
"name": "MARÇO.pdf",
"format": "PDF",
"url": "https://dados.prefeitura.sp.gov.br/dataset/e239e5f2-cbcc-4535-8555-e49649af578a/resource/b3ca6555-0dcf-4061-97ec-02636cb68436/download/marco.pdf",
"datastore_active": false,
"cache_last_updated": null,
"package_id": "e239e5f2-cbcc-4535-8555-e49649af578a",
"created": "2026-10-21T13:30:15.166374",
"state": "active",
"mimetype_inner": null,
"last_modified": "2026-10-21T13:30:15.040941",
"position": 5,
"revision_id": "724e3e74-fbcf-47fa-8fc7-c2dc47e262a6",
"url_type": "upload",
"id": "b3ca6555-0dcf-4061-97ec-02636cb68436",
"resource_type": null,
"size": 34432
},
{
"mimetype": "text/csv",
"cache_url": null,
"hash": "",
"description": "Informações sobre manutenção e conservação de galerias no território de Guaianases e Lajeado realizada em Abril.",
"name": "ABRIL.csv",
"format": "CSV",
"url": "https://dados.prefeitura.sp.gov.br/dataset/e239e5f2-cbcc-4535-8555-e49649af578a/resource/faeeb9c0-4055-47ca-ae19-ff3d56971967/download/abril.csv",
"datastore_active": false,
"cache_last_updated": null,
"package_id": "e239e5f2-cbcc-4535-8555-e49649af578a",
"created": "2026-10-21T13:26:40.892393",
"state": "active",
"mimetype_inner": null,
"last_modified": "2026-10-21T13:26:40.816501",
"position": 6,
"revision_id": "724e3e74-fbcf-47fa-8fc7-c2dc47e262a6",
"url_type": "upload",
"id": "faeeb9c0-4055-47ca-ae19-ff3d56971967",
"resource_type": null,
"size": 387
},
{
"mimetype": "application/pdf",
"cache_url": null,
"hash": "",
"description": "Informações sobre manutenção e conservação de galerias no território de Guaianases e Lajeado realizada em Abril",
"name": "ABRIL.pdf",
"format": "PDF",
"url": "https://dados.prefeitura.sp.gov.br/dataset/e239e5f2-cbcc-4535-8555-e49649af578a/resource/9f5f04c9-9df9-4b26-923d-cc89fab9b629/download/abril.pdf",
"datastore_active": false,
"cache_last_updated": null,
"package_id": "e239e5f2-cbcc-4535-8555-e49649af578a",
"created": "2026-10-21T13:30:27.242288",
"state": "active",
"mimetype_inner": null,
"last_modified": "2026-10-21T13:30:27.140888",
"position": 7,
"revision_id": "724e3e74-fbcf-47fa-8fc7-c2dc47e262a6",
"url_type": "upload",
"id": "9f5f04c9-9df9-4b26-923d-cc89fab9b629",
"resource_type": null,
"size": 34127
},
{
"mimetype": "text/csv",
"cache_url": null,
"hash": "",
"description": "Informações sobre manutenção e conservação de galerias no território de Guaianases e Lajeado realizada em Maio.",
"name": "MAIO.csv",
"format": "CSV",
"url": "https://dados.prefeitura.sp.gov.br/dataset/e239e5f2-cbcc-4535-8555-e49649af578a/resource/8098f9a8-f5b6-4fae-ad57-63b4516833be/download/maio.csv",
"datastore_active": false,
"cache_last_updated": null,
"package_id": "e239e5f2-cbcc-4535-8555-e49649af578a",
"created": "2026-10-21T13:26:54.331245",
"state": "active",
"mimetype_inner": null,
"last_modified": "2026-10-21T13:26:54.251314",
"position": 8,
"revision_id": "724e3e74-fbcf-47fa-8fc7-c2dc47e262a6",
"url_type": "upload",
"id": "8098f9a8-f5b6-4fae-ad57-63b4516833be",
"resource_type": null,
"size": 387
},
{
"mimetype": "application/pdf",
"cache_url": null,
"hash": "",
"description": "Informações sobre manutenção e conservação de galerias no território de Guaianases e Lajeado realizada em Maio",
"name": "MAIO.pdf",
"format": "PDF",
"url": "https://dados.prefeitura.sp.gov.br/dataset/e239e5f2-cbcc-4535-8555-e49649af578a/resource/8ff32b54-4b95-44f4-bafd-0fa110485f20/download/maio.pdf",
"datastore_active": false,
"cache_last_updated": null,
"package_id": "e239e5f2-cbcc-4535-8555-e49649af578a",
"created": "2026-10-21T13:30:38.901856",
"state": "active",
"mimetype_inner": null,
"last_modified": "2026-10-21T13:30:38.747204",
"position": 9,
"revision_id": "724e3e74-fbcf-47fa-8fc7-c2dc47e262a6",
"url_type": "upload",
"id": "8ff32b54-4b95-44f4-bafd-0fa110485f20",
"resource_type": null,
"size": 34601
},
"… 10 more items"
],
"num_resources": 20,
"tags": [
{
"vocabulary_id": null,
"state": "active",
"display_name": "conservação",
"id": "cb087887-56ef-43dc-8bb1-015b92a3783a",
"name": "conservação"
},
{
"vocabulary_id": null,
"state": "active",
"display_name": "galerias",
"id": "dd55eaa7-92d1-4a5e-a0c6-96696d019934",
"name": "galerias"
},
{
"vocabulary_id": null,
"state": "active",
"display_name": "manutenção",
"id": "bf105344-91e7-4840-80e5-0060f4bdd204",
"name": "manutenção"
}
],
"groups": [],
"license_id": "cc-by",
"relationships_as_subject": [],
"organization": {
"description": "Território administrativo (Distritos): Guaianases, Lajeado",
"created": "2017-05-15T19:05:44.153690",
"title": "Subprefeitura Guaianases",
"name": "prefeitura-regional-guaianases",
"is_organization": true,
"state": "active",
"image_url": "2025-08-27-180248.334476SUBPREFGuaianasesHorizontal.png",
"revision_id": "3482c009-a9a8-4fe0-a01d-b88018fe4e06",
"type": "organization",
"id": "f47f193b-c7a2-494b-8eb7-f0adbcff7346",
"approval_status": "approved"
},
"name": "manutencao-e-conservacao-de-galerias",
"isopen": true,
"url": "",
"notes": "Última Atualização: 21/10/2026 (atualização mensal)\r\n\r\nEsta base de dados reúne as informações relativas às ações de manutenção, limpeza, desobstrução e conservação da rede de galerias pluviais no território de Guaianases e Lajeado. Seu objetivo principal é monitorar, registrar e planejar as intervenções no sistema de drenagem urbana da região, garantindo o escoamento adequado das águas da chuva, prevenindo alagamentos e preservando a infraestrutura pública.\r\n\r\nCanal de Contato: guaianases@smsub.prefeitura.sp.gov.br",
"owner_org": "f47f193b-c7a2-494b-8eb7-f0adbcff7346",
"extras": [],
"license_url": "http://www.opendefinition.org/licenses/cc-by",
"title": "Manutenção e conservação de galerias",
"revision_id": "98dc4597-c899-434e-afad-8b437e8626f5"
}
}Attribution: Source: Portal de Dados Abertos da Cidade de São Paulo (Município de São Paulo (City of São Paulo, SP, Brazil)). Data published by the portal's contributing organisations.
Licence: Dataset records on this portal declare the licence "Creative Commons Atribuição" (http://www.opendefinition.org/licenses/cc-by). This is the licence the publishing organisations attach to their own datasets; the portal itself states no separate API licence. Quoted as found in the portal's own dataset metadata.
Ask with this source
A prompt for your agent that names this source and how to call it through the crw MCP.
Dataset detail
Use Portal de Dados Abertos da Cidade de São Paulo (dados-prefeitura-sp-gov-br) from fastCRW Pergamon, capability "Dataset detail" (dataset). You already have a dataset name or UUID from a search and need its resources, licence or full description. Example options: id=manutencao-e-conservacao-de-galerias. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "dados-prefeitura-sp-gov-br" 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>
All dataset names
Use Portal de Dados Abertos da Cidade de São Paulo (dados-prefeitura-sp-gov-br) from fastCRW Pergamon, capability "All dataset names" (dataset-names). You want the complete inventory of dataset ids to iterate over, rather than a scored search page. Example options: limit=100, offset=0. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "dados-prefeitura-sp-gov-br" and capability "dataset-names". 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 search
Use Portal de Dados Abertos da Cidade de São Paulo (dados-prefeitura-sp-gov-br) from fastCRW Pergamon, capability "Dataset search" (datasets). You want to find datasets on this portal by keyword, filter, or recency, and you do not already know a dataset id. Example options: q=statistika, fq=res_format:CSV, sort=metadata_modified desc. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "dados-prefeitura-sp-gov-br" 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>
Dataset title autocomplete
Use Portal de Dados Abertos da Cidade de São Paulo (dados-prefeitura-sp-gov-br) from fastCRW Pergamon, capability "Dataset title autocomplete" (dataset-suggest). You are resolving a partly-remembered dataset title into an id and do not want full search payloads. Example options: q=manute, limit=10. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "dados-prefeitura-sp-gov-br" and capability "dataset-suggest". 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>