carto-find-spatial-data

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

carto-find-spatial-data

The CARTO Data Observatory (DO) is a catalog of curated external spatial datasets — demographics, points of interest, environmental data, mobility, financial — that you can subscribe to and have materialized into your own data warehouse. Instead of the user hunting down a US census shapefile, this skill answers: "what's already curated in the DO that would help here?"

This skill covers discovery and subscription. Once subscribed, the data lives in the user's warehouse and is queryable like any other table — see

carto-query-datawarehouse

**CARTO Data Observatory（DO）**是一个经过精心整理的外部空间数据集目录，涵盖人口统计、兴趣点、环境数据、移动数据、金融数据等类别。您可以订阅这些数据集，并将其实例化到自己的数据仓库中。无需用户自行寻找美国人口普查shapefile，该技能可以回答：“DO中已整理好哪些可用数据能满足需求？”

本技能涵盖发现与订阅功能。订阅完成后，数据将存储在用户的仓库中，可像其他表一样进行查询——详情请查看

carto-query-datawarehouse

。

When to use this skill

何时使用本技能

The user asks for "demographics", "points of interest", "boundaries", "mobility data", "weather", or any other category of external spatial data.
The user has internal data and wants to enrich it with external context (e.g., spatial-join their stores against census tracts).
The user is exploring what's available before committing to a paid subscription.

If the user already has the dataset in their warehouse, jump to

carto-explore-datawarehouse

instead — DO is for sourcing new external data.

用户询问“人口统计数据”“兴趣点”“边界数据”“移动数据”“天气数据”或其他类别的外部空间数据时。
用户拥有内部数据，希望通过外部信息对其进行丰富（例如，将门店数据与人口普查区域进行空间连接）时。
用户在决定付费订阅前，想要探索可用资源时。

如果用户仓库中已存在目标数据集，请直接使用

carto-explore-datawarehouse

——DO用于获取新的外部数据。

Quick reference

快速参考

bash

undefined

bash

undefined

Discover what's available — by keyword

carto do search --keyword "census" --json carto do search --keyword "weather" --country usa --json

Inspect a specific dataset

carto do get <dataset-id> --json

List your active subscriptions

carto do subscriptions list --json

Subscribe (writes to a connection in your org)

carto do subscribe <dataset-id>
--connection carto_dw
--destination my_project.do.census_tracts


> The exact `carto do` subcommand surface is evolving — `search`, `get`, `subscribe`, `subscriptions` are the stable verbs. Check `carto do --help` if a flag isn't recognized.

carto do subscribe <dataset-id>
--connection carto_dw
--destination my_project.do.census_tracts


> `carto do`子命令的具体功能仍在迭代中——`search`、`get`、`subscribe`、`subscriptions`是稳定可用的命令。如果某一参数不被识别，请查看`carto do --help`。

What's in this skill

本技能包含的内容

Topic	Reference
Discovery: searching, filtering, evaluating datasets	references/data-observatory.md
Subscribing: paid vs free, materialization, refresh, costs	references/subscribe.md

主题	参考文档
发现：搜索、筛选、评估数据集	references/data-observatory.md
订阅：免费与付费、实例化、刷新、成本	references/subscribe.md

Always-on guidance

通用指导

Free vs paid: many DO datasets are free (US Census, OpenStreetMap-derived, NaturalEarth). Premium datasets (Spatial.ai, Mastercard, AirSage, etc.) require a CARTO subscription contract —
```
carto do get
```
shows the licensing and pricing tier.
Subscription lands data into the user's warehouse. It's not a remote view — actual rows are written to a destination table the user pays warehouse storage for. Plan destination naming accordingly.
Spatial extension required. DO datasets often include H3 cells / geometry types that depend on CARTO's spatial extension being installed in the destination warehouse. If subscribing fails with "function not found", check that the spatial extension is installed — see
```
carto-manage-platform
```
.
Don't recommend a DO dataset without
carto do get
first. The dataset's metadata reveals coverage (US-only, EU-only, global), update cadence (monthly, yearly, real-time), and licensing — all critical to whether it actually fits the user's question.
DO is external; named sources are internal. Don't confuse the two. Named sources (covered in
```
carto-explore-datawarehouse/references/named-sources.md
```
) are the user's saved queries; DO is the curated catalog of third-party data.

免费与付费：许多DO数据集是免费的（如美国人口普查数据、基于OpenStreetMap的衍生数据、NaturalEarth数据）。高级数据集（如Spatial.ai、Mastercard、AirSage等）需要CARTO订阅合约——
```
carto do get
```
命令会显示许可信息和定价层级。
订阅后数据将存入用户仓库。这并非远程视图——实际数据行将写入用户指定的目标表，用户需支付仓库存储费用。请合理规划目标表的命名。
需要安装空间扩展。DO数据集通常包含H3单元格/几何类型，依赖于目标仓库中已安装CARTO的空间扩展。如果订阅时出现“函数未找到”的错误，请检查是否已安装空间扩展——详情请查看
```
carto-manage-platform
```
。
推荐DO数据集前务必先执行
carto do get
。数据集的元数据会揭示覆盖范围（仅限美国、仅限欧盟、全球）、更新频率（月度、年度、实时）和许可信息——这些都是判断该数据集是否真正符合用户需求的关键信息。
DO是外部资源；命名源是内部资源。请勿混淆二者。命名源（详见
```
carto-explore-datawarehouse/references/named-sources.md
```
）是用户保存的查询；DO是第三方数据的 curated 目录。