> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-fbfa8bee.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> 了解如何将 OpenCelliD 数据加载到 ClickHouse 中、将 Apache Superset 连接到 ClickHouse，并基于这些数据构建仪表板

# 使用蜂窝基站数据集的地理数据

export const Image = ({img, alt, size}) => {
  return <Frame>
      <img src={img} alt={alt} />
    </Frame>;
};

<div id="goal">
  ## 目标
</div>

本指南将介绍如何：

* 将 OpenCelliD 数据加载到 ClickHouse
* 将 Apache Superset 连接到 ClickHouse
* 基于数据集中的数据构建仪表板

下面是本指南中创建的仪表板预览：

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/qvDh3oxLPI7c74wx/images/getting-started/example-datasets/superset-cell-tower-dashboard.png?fit=max&auto=format&n=qvDh3oxLPI7c74wx&q=85&s=82f088a1a38421eca04f6e525e5687fb" size="md" alt="mcc 204 中按制式划分的蜂窝基站仪表板" width="1103" height="1014" data-path="images/getting-started/example-datasets/superset-cell-tower-dashboard.png" />

<div id="get-the-dataset">
  ## 获取数据集
</div>

该数据集来自 [OpenCelliD](https://www.opencellid.org/)——全球最大的蜂窝基站开放数据库。

截至 2021 年，该数据集包含全球超过 4000 万条蜂窝基站 (GSM、LTE、UMTS 等) 记录，以及对应的地理坐标和元数据 (国家代码、网络等) 。

OpenCelliD Project 采用 Creative Commons Attribution-ShareAlike 4.0 International License 许可，我们依据相同许可条款重新分发该数据集的一个快照。该数据集的最新版本可在登录后下载。

<Tabs>
  <Tab title="ClickHouse Cloud">
    ### 加载样本数据

    ClickHouse Cloud 提供了一种从 S3 加载此数据集的一键方式。登录你的 ClickHouse Cloud 组织，或在 [ClickHouse.cloud](https://clickhouse.cloud) 创建免费试用账户。

    选择你的服务，然后依次点击 `Data sources` -> `Predefined sample data`。

    <Image size="md" img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/Qke-GQkmVyWEhvPu/images/_snippets/cloud-service-actions-menu.png?fit=max&auto=format&n=Qke-GQkmVyWEhvPu&q=85&s=780afeb475813fd9b3036b9c82c255c0" alt="ClickHouse Cloud 服务操作菜单，显示“Data sources”和“Predefined sample data”选项" border width="3836" height="2138" data-path="images/_snippets/cloud-service-actions-menu.png" />

    在 **Sample data** 选项卡中选择 **Cell Towers** 数据集，然后点击 **Load data**：

    <Image img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/Qke-GQkmVyWEhvPu/images/_snippets/cloud-load-data-sample.png?fit=max&auto=format&n=Qke-GQkmVyWEhvPu&q=85&s=d9ca69cdeabec8e5495a9a0c7ac51fac" size="md" alt="加载蜂窝基站数据集" width="3838" height="2146" data-path="images/_snippets/cloud-load-data-sample.png" />

    ### 查看 cell\_towers 表的 schema

    ```sql theme={null}
    DESCRIBE TABLE cell_towers
    ```

    <Tip>
      **SQL 控制台**

      如果您需要 SQL 客户端连接，您的 ClickHouse Cloud 服务提供了一个关联的 Web 版 SQL 控制台；展开下方的 **连接到 SQL 控制台** 了解详情。
    </Tip>

    <Accordion title="连接到 SQL 控制台">
      在您的 ClickHouse Cloud 服务列表中，点击某个服务。

      <Image img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/Qke-GQkmVyWEhvPu/images/_snippets/cloud-connect-to-sql-console.png?fit=max&auto=format&n=Qke-GQkmVyWEhvPu&q=85&s=33d2fb558133f51f77174a0b40692422" alt="连接到 SQL 控制台" size="lg" force border width="3840" height="2160" data-path="images/_snippets/cloud-connect-to-sql-console.png" />

      这会将您跳转到 SQL 控制台。

      <Image img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/Qke-GQkmVyWEhvPu/images/_snippets/createservice8.png?fit=max&auto=format&n=Qke-GQkmVyWEhvPu&q=85&s=615c1e0180500dd356157d6ec2aa2c8c" alt="SQL 控制台" size="lg" force border width="3200" height="1800" data-path="images/_snippets/createservice8.png" />
    </Accordion>

    这是 `DESCRIBE` 的输出。在本指南后续部分中，我们将说明这些字段类型的选择原因。

    ```response theme={null}
    ┌─name──────────┬─type──────────────────────────────────────────────────────────────────┬
    │ radio         │ Enum8('' = 0, 'CDMA' = 1, 'GSM' = 2, 'LTE' = 3, 'NR' = 4, 'UMTS' = 5) │
    │ mcc           │ UInt16                                                                │
    │ net           │ UInt16                                                                │
    │ area          │ UInt16                                                                │
    │ cell          │ UInt64                                                                │
    │ unit          │ Int16                                                                 │
    │ lon           │ Float64                                                               │
    │ lat           │ Float64                                                               │
    │ range         │ UInt32                                                                │
    │ samples       │ UInt32                                                                │
    │ changeable    │ UInt8                                                                 │
    │ created       │ DateTime                                                              │
    │ updated       │ DateTime                                                              │
    │ averageSignal │ UInt8                                                                 │
    └───────────────┴───────────────────────────────────────────────────────────────────────┴
    ```
  </Tab>

  <Tab title="自管理">
    1. 创建表：

    ```sql theme={null}
    CREATE TABLE cell_towers
    (
        radio Enum8('' = 0, 'CDMA' = 1, 'GSM' = 2, 'LTE' = 3, 'NR' = 4, 'UMTS' = 5),
        mcc UInt16,
        net UInt16,
        area UInt16,
        cell UInt64,
        unit Int16,
        lon Float64,
        lat Float64,
        range UInt32,
        samples UInt32,
        changeable UInt8,
        created DateTime,
        updated DateTime,
        averageSignal UInt8
    )
    ENGINE = MergeTree ORDER BY (radio, mcc, net, created);
    ```

    2. 从公共 S3 bucket 导入数据集 (686 MB) ：

    ```sql theme={null}
    INSERT INTO cell_towers SELECT * FROM s3('https://datasets-documentation.s3.amazonaws.com/cell_towers/cell_towers.csv.xz', 'CSVWithNames')
    ```
  </Tab>
</Tabs>

<div id="examples">
  ## 运行几个示例查询
</div>

1. 按类型统计的蜂窝基站数量：

```sql theme={null}
SELECT radio, count() AS c FROM cell_towers GROUP BY radio ORDER BY c DESC
```

```response theme={null}
┌─radio─┬────────c─┐
│ UMTS  │ 20686487 │
│ LTE   │ 12101148 │
│ GSM   │  9931304 │
│ CDMA  │   556344 │
│ NR    │      867 │
└───────┴──────────┘

5 rows in set. Elapsed: 0.011 sec. Processed 43.28 million rows, 43.28 MB (3.83 billion rows/s., 3.83 GB/s.)
```

2. 按[移动国家代码 (MCC)](https://en.wikipedia.org/wiki/Mobile_country_code)分类的蜂窝基站：

```sql theme={null}
SELECT mcc, count() FROM cell_towers GROUP BY mcc ORDER BY count() DESC LIMIT 10
```

```response theme={null}
┌─mcc─┬─count()─┐
│ 310 │ 5024650 │
│ 262 │ 2622423 │
│ 250 │ 1953176 │
│ 208 │ 1891187 │
│ 724 │ 1836150 │
│ 404 │ 1729151 │
│ 234 │ 1618924 │
│ 510 │ 1353998 │
│ 440 │ 1343355 │
│ 311 │ 1332798 │
└─────┴─────────┘

10 rows in set. Elapsed: 0.019 sec. Processed 43.28 million rows, 86.55 MB (2.33 billion rows/s., 4.65 GB/s.)
```

根据上述查询和 [MCC 列表](https://en.wikipedia.org/wiki/Mobile_country_code)，蜂窝基站数量最多的国家是：美国、德国和俄罗斯。

你可能需要在 ClickHouse 中创建一个[字典](/zh/reference/statements/create/dictionary)来解析这些值。

<div id="use-case">
  ## 用例：整合地理数据
</div>

使用 [`pointInPolygon`](/zh/reference/functions/regular-functions/geo/coordinates#pointinpolygon) 函数。

1. 创建一个用于存储 Polygon 的表：

<Tabs>
  <Tab title="ClickHouse Cloud">
    ```sql theme={null}
    CREATE TABLE moscow (polygon Array(Tuple(Float64, Float64)))
    ORDER BY polygon;
    ```
  </Tab>

  <Tab title="自管理">
    ```sql theme={null}
    CREATE TEMPORARY TABLE
    moscow (polygon Array(Tuple(Float64, Float64)));
    ```
  </Tab>
</Tabs>

2. 这是莫斯科的大致边界 (不包括“新莫斯科”) ：

```sql theme={null}
INSERT INTO moscow VALUES ([(37.84172564285271, 55.78000432402266),
(37.8381207618713, 55.775874525970494), (37.83979446823122, 55.775626746008065), (37.84243326983639, 55.77446586811748), (37.84262672750849, 55.771974101091104), (37.84153238623039, 55.77114545193181), (37.841124690460184, 55.76722010265554),
(37.84239076983644, 55.76654891107098), (37.842283558197025, 55.76258709833121), (37.8421759312134, 55.758073999993734), (37.84198330422974, 55.75381499999371), (37.8416827275085, 55.749277102484484), (37.84157576190186, 55.74794544108413),
(37.83897929098507, 55.74525257875241), (37.83739676451868, 55.74404373042019), (37.838732481460525, 55.74298009816793), (37.841183997352545, 55.743060321833575), (37.84097476190185, 55.73938799999373), (37.84048155819702, 55.73570799999372),
(37.840095812164286, 55.73228210777237), (37.83983814285274, 55.73080491981639), (37.83846476321406, 55.729799917464675), (37.83835745269769, 55.72919751082619), (37.838636380279524, 55.72859509486539), (37.8395161005249, 55.727705075632784),
(37.83897964285276, 55.722727886185154), (37.83862557539366, 55.72034817326636), (37.83559735744853, 55.71944437307499), (37.835370708803126, 55.71831419154461), (37.83738169402022, 55.71765218986692), (37.83823396494291, 55.71691750159089),
(37.838056931213345, 55.71547311301385), (37.836812846557606, 55.71221445615604), (37.83522525396725, 55.709331054395555), (37.83269301586908, 55.70953687463627), (37.829667367706236, 55.70903403789297), (37.83311126588435, 55.70552351822608),
(37.83058993121339, 55.70041317726053), (37.82983872750851, 55.69883771404813), (37.82934501586913, 55.69718947487017), (37.828926414016685, 55.69504441658371), (37.82876530422971, 55.69287499999378), (37.82894754100031, 55.690759754047335),
(37.827697554878185, 55.68951421135665), (37.82447346292115, 55.68965045405069), (37.83136543914793, 55.68322046195302), (37.833554015869154, 55.67814012759211), (37.83544184655761, 55.67295011628339), (37.837480388885474, 55.6672498719639),
(37.838960677246064, 55.66316274139358), (37.83926093121332, 55.66046999999383), (37.839025050262435, 55.65869897264431), (37.83670784390257, 55.65794084879904), (37.835656529083245, 55.65694309303843), (37.83704060449217, 55.65689306460552),
(37.83696819873806, 55.65550363526252), (37.83760389616388, 55.65487847246661), (37.83687972750851, 55.65356745541324), (37.83515216004943, 55.65155951234079), (37.83312418518067, 55.64979413590619), (37.82801726983639, 55.64640836412121),
(37.820614174591, 55.64164525405531), (37.818908190475426, 55.6421883258084), (37.81717543386075, 55.64112490388471), (37.81690987037274, 55.63916106913107), (37.815099354492155, 55.637925371757085), (37.808769150787356, 55.633798276884455),
(37.80100123544311, 55.62873670012244), (37.79598013491824, 55.62554336109055), (37.78634567724606, 55.62033499605651), (37.78334147619623, 55.618768681480326), (37.77746201055901, 55.619855533402706), (37.77527329626457, 55.61909966711279),
(37.77801986242668, 55.618770300976294), (37.778212973541216, 55.617257701952106), (37.77784818518065, 55.61574504433011), (37.77016867724609, 55.61148576294007), (37.760191219573976, 55.60599579539028), (37.75338926983641, 55.60227892751446),
(37.746329965606634, 55.59920577639331), (37.73939925396728, 55.59631430313617), (37.73273665739439, 55.5935318803559), (37.7299954450912, 55.59350760316188), (37.7268679946899, 55.59469840523759), (37.72626726983634, 55.59229549697373),
(37.7262673598022, 55.59081598950582), (37.71897193121335, 55.5877595845419), (37.70871550793456, 55.58393177431724), (37.700497489410374, 55.580917323756644), (37.69204305026244, 55.57778089778455), (37.68544477378839, 55.57815154690915),
(37.68391050793454, 55.57472945079756), (37.678803592590306, 55.57328235936491), (37.6743402539673, 55.57255251445782), (37.66813862698363, 55.57216388774464), (37.617927457672096, 55.57505691895805), (37.60443099999999, 55.5757737568051),
(37.599683515869145, 55.57749105910326), (37.59754177842709, 55.57796291823627), (37.59625834786988, 55.57906686095235), (37.59501783265684, 55.57746616444403), (37.593090671936025, 55.57671634534502), (37.587018007904, 55.577944600233785),
(37.578692203704804, 55.57982895000019), (37.57327546607398, 55.58116294118248), (37.57385012109279, 55.581550362779), (37.57399562266922, 55.5820107079112), (37.5735356072979, 55.58226289171689), (37.57290393054962, 55.582393529795155),
(37.57037722355653, 55.581919415056234), (37.5592298306885, 55.584471614867844), (37.54189249206543, 55.58867650795186), (37.5297256269836, 55.59158133551745), (37.517837865081766, 55.59443656218868), (37.51200186508174, 55.59635625174229),
(37.506808949737554, 55.59907823904434), (37.49820432275389, 55.6062944994944), (37.494406071441674, 55.60967103463367), (37.494760001358024, 55.61066689753365), (37.49397137107085, 55.61220931698269), (37.49016528606031, 55.613417718449064),
(37.48773249206542, 55.61530616333343), (37.47921386508177, 55.622640129112334), (37.470652153442394, 55.62993723476164), (37.46273446298218, 55.6368075123157), (37.46350692265317, 55.64068225239439), (37.46050283203121, 55.640794546982576),
(37.457627470916734, 55.64118904154646), (37.450718034393326, 55.64690488145138), (37.44239252645875, 55.65397824729769), (37.434587576721185, 55.66053543155961), (37.43582144975277, 55.661693766520735), (37.43576786245721, 55.662755031737014),
(37.430982915344174, 55.664610641628116), (37.428547447097685, 55.66778515273695), (37.42945134592044, 55.668633314343566), (37.42859571562949, 55.66948145750025), (37.4262836402282, 55.670813882451405), (37.418709037048295, 55.6811141674414),
(37.41922139651101, 55.68235377885389), (37.419218771842885, 55.68359335082235), (37.417196501327446, 55.684375235224735), (37.41607020370478, 55.68540557585352), (37.415640857147146, 55.68686637150793), (37.414632153442334, 55.68903015131686),
(37.413344899475064, 55.690896881757396), (37.41171432275391, 55.69264232162232), (37.40948282275393, 55.69455101638112), (37.40703674603271, 55.69638690385348), (37.39607169577025, 55.70451821283731), (37.38952706878662, 55.70942491932811),
(37.387778313491815, 55.71149057784176), (37.39049275399779, 55.71419814298992), (37.385557272491454, 55.7155489617061), (37.38388335714726, 55.71849856042102), (37.378368238098155, 55.7292763261685), (37.37763597123337, 55.730845879211614),
(37.37890062088197, 55.73167906388319), (37.37750451918789, 55.734703664681774), (37.375610832015965, 55.734851959522246), (37.3723813571472, 55.74105626086403), (37.37014935714723, 55.746115620904355), (37.36944173016362, 55.750883999993725),
(37.36975304365541, 55.76335905525834), (37.37244070571134, 55.76432079697595), (37.3724259757175, 55.76636979670426), (37.369922155757884, 55.76735417953104), (37.369892695770275, 55.76823419316575), (37.370214730163575, 55.782312184391266),
(37.370493611114505, 55.78436801120489), (37.37120164550783, 55.78596427165359), (37.37284851456452, 55.7874378183096), (37.37608325135799, 55.7886695054807), (37.3764587460632, 55.78947647305964), (37.37530000265506, 55.79146512926804),
(37.38235915344241, 55.79899647809345), (37.384344043655396, 55.80113596939471), (37.38594269577028, 55.80322699999366), (37.38711208598329, 55.804919036911976), (37.3880239841309, 55.806610999993666), (37.38928977249147, 55.81001864976979),
(37.39038389947512, 55.81348641242801), (37.39235781481933, 55.81983538336746), (37.393709457672124, 55.82417822811877), (37.394685720901464, 55.82792275755836), (37.39557615344238, 55.830447148154136), (37.39844478226658, 55.83167107969975),
(37.40019761214057, 55.83151823557964), (37.400398790382326, 55.83264967594742), (37.39659544313046, 55.83322180909622), (37.39667059524539, 55.83402792148566), (37.39682089947515, 55.83638877400216), (37.39643489154053, 55.83861656112751),
(37.3955338994751, 55.84072348043264), (37.392680272491454, 55.84502158126453), (37.39241188227847, 55.84659117913199), (37.392529730163616, 55.84816071336481), (37.39486835714723, 55.85288092980303), (37.39873052645878, 55.859893456073635),
(37.40272161111449, 55.86441833633205), (37.40697072750854, 55.867579567544375), (37.410007082016016, 55.868369880337), (37.4120992989502, 55.86920843741314), (37.412668021163924, 55.87055369615854), (37.41482461111453, 55.87170587948249),
(37.41862266137694, 55.873183961039565), (37.42413732540892, 55.874879126654704), (37.4312182698669, 55.875614937236705), (37.43111093783558, 55.8762723478417), (37.43332105622856, 55.87706546369396), (37.43385747619623, 55.87790681284802),
(37.441303050262405, 55.88027084462084), (37.44747234260555, 55.87942070143253), (37.44716141796871, 55.88072960917233), (37.44769797085568, 55.88121221323979), (37.45204320500181, 55.882080694420715), (37.45673176190186, 55.882346110794586),
(37.463383999999984, 55.88252729504517), (37.46682797486874, 55.88294937719063), (37.470014457672086, 55.88361266759345), (37.47751410450743, 55.88546991372396), (37.47860317658232, 55.88534929207307), (37.48165826025772, 55.882563306475106),
(37.48316434442331, 55.8815803226785), (37.483831555817645, 55.882427612793315), (37.483182967125686, 55.88372791409729), (37.483092277908824, 55.88495581062434), (37.4855716508179, 55.8875561994203), (37.486440636245746, 55.887827444039566),
(37.49014203439328, 55.88897899871799), (37.493210285705544, 55.890208937135604), (37.497512451065035, 55.891342397444696), (37.49780744510645, 55.89174030252967), (37.49940333499519, 55.89239745507079), (37.50018383334346, 55.89339220941865),
(37.52421672750851, 55.903869074155224), (37.52977457672118, 55.90564076517974), (37.53503220370484, 55.90661661218259), (37.54042858064267, 55.90714113744566), (37.54320461007303, 55.905645048442985), (37.545686966066306, 55.906608607018505),
(37.54743976120755, 55.90788552162358), (37.55796999999999, 55.90901557907218), (37.572711542327866, 55.91059395704873), (37.57942799999998, 55.91073854155573), (37.58502865872187, 55.91009969268444), (37.58739968913264, 55.90794809960554),
(37.59131567193598, 55.908713267595054), (37.612687423278814, 55.902866854295375), (37.62348079629517, 55.90041967242986), (37.635797880950896, 55.898141151686396), (37.649487626983664, 55.89639275532968), (37.65619302513125, 55.89572360207488),
(37.66294133862307, 55.895295577183965), (37.66874564418033, 55.89505457604897), (37.67375601586915, 55.89254677027454), (37.67744661901856, 55.8947775867987), (37.688347, 55.89450045676125), (37.69480554232789, 55.89422926332761),
(37.70107096560668, 55.89322256101114), (37.705962965606716, 55.891763491662616), (37.711885134918205, 55.889110234998974), (37.71682005026245, 55.886577568759876), (37.7199315476074, 55.88458159806678), (37.72234560316464, 55.882281005794134),
(37.72364385977171, 55.8809452036196), (37.725371142837474, 55.8809722706006), (37.727870902099546, 55.88037213862385), (37.73394330422971, 55.877941504088696), (37.745339592590376, 55.87208120378722), (37.75525267724611, 55.86703807949492),
(37.76919976190188, 55.859821640197474), (37.827835219574, 55.82962968399116), (37.83341438888553, 55.82575289922351), (37.83652584655761, 55.82188784027888), (37.83809213491821, 55.81612575504693), (37.83605359521481, 55.81460347077685),
(37.83632178569025, 55.81276696067908), (37.838623105812026, 55.811486181656385), (37.83912198147584, 55.807329380532785), (37.839079078033414, 55.80510270463816), (37.83965844708251, 55.79940712529036), (37.840581150787344, 55.79131399999368),
(37.84172564285271, 55.78000432402266)]);
```

3. 查看莫斯科有多少个蜂窝基站：

```sql theme={null}
SELECT count() FROM cell_towers
WHERE pointInPolygon((lon, lat), (SELECT * FROM moscow))
```

```response theme={null}
┌─count()─┐
│  310463 │
└─────────┘

1 rows in set. Elapsed: 0.067 sec. Processed 43.28 million rows, 692.42 MB (645.83 million rows/s., 10.33 GB/s.)
```

<div id="review-of-the-schema">
  ## 查看 schema
</div>

在 Superset 中构建可视化之前，先了解一下要用到的列。这个数据集主要提供全球移动蜂窝基站的位置 (经度和纬度) 以及制式。列说明可在[社区论坛](https://community.opencellid.org/t/documenting-the-columns-in-the-downloadable-cells-database-csv/186)中找到。下面介绍将在这些可视化中用到的列。

以下是摘自 OpenCelliD 论坛的列说明：

| Column | Description              |
| ------ | ------------------------ |
| radio  | 技术代际：CDMA、GSM、UMTS、5G NR |
| mcc    | 移动国家代码：`204` 代表荷兰        |
| lon    | 经度：与纬度一起表示基站的大致位置        |
| lat    | 纬度：与经度一起表示基站的大致位置        |

<Tip>
  **mcc**

  要查找你的 MCC，请参阅[移动网络代码](https://en.wikipedia.org/wiki/Mobile_country_code)，并使用 **Mobile country code** 列中的三位数字。
</Tip>

此表的 schema 在设计时兼顾了磁盘上的紧凑存储和查询速度。

* `radio` 数据存储为 `Enum8` (`UInt8`) ，而不是字符串。
* `mcc` (即 Mobile country code) 存储为 `UInt16`，因为其取值范围已知为 1 - 999。
* `lon` 和 `lat` 的类型均为 `Float64`。

本指南中的查询和可视化都不会用到其他字段，但如果你感兴趣，可以查看上方链接的论坛说明。

<div id="build-visualizations-with-apache-superset">
  ## 使用 Apache Superset 构建可视化
</div>

使用 Docker 运行 Superset 很方便。如果你已经在运行 Superset，只需通过 `pip install clickhouse-connect` 添加 ClickHouse Connect 即可。如果你还需要安装 Superset，请直接打开下方的 **在 Docker 中启动 Apache Superset**。

<Accordion title="在 Docker 中启动 Apache Superset">
  Superset 提供了[使用 Docker Compose 在本地安装 Superset](https://superset.apache.org/docs/installation/installing-superset-using-docker-compose/)的说明。从 GitHub 检出 Apache Superset 仓库后，你可以运行最新的开发代码，也可以运行特定标签对应的版本。我们建议使用 2.0.0 版本，因为这是最新一个未标记为 `pre-release` 的发布版本。

  在运行 `docker compose` 之前，需要先完成以下几项任务：

  1. 添加官方 ClickHouse Connect 驱动程序
  2. 获取一个 Mapbox API key，并将其添加为环境变量 (可选)
  3. 指定要运行的 Superset 版本

  <Tip>
    以下命令应在 GitHub 仓库 `superset` 的顶层目录中运行。
  </Tip>

  ## 官方 ClickHouse Connect 驱动程序

  要让 ClickHouse Connect 驱动程序在 Superset 部署中可用，请将其添加到本地 requirements 文件中：

  ```bash theme={null}
  echo "clickhouse-connect" >> ./docker/requirements-local.txt
  ```

  ## Mapbox

  这是可选项。即使没有 Mapbox API key，你仍然可以在 Superset 中绘制位置数据，但界面会提示你应添加一个 key，并且地图背景图像会缺失 (你只能看到数据点，看不到地图底图) 。如果你想使用它，Mapbox 提供了免费层级。

  指南中让你创建的一些示例可视化会使用位置数据，例如经度和纬度。Superset 内置了对 Mapbox 地图的支持。要使用 Mapbox 可视化功能，你需要一个 Mapbox API key。注册 [Mapbox 免费层级](https://account.mapbox.com/auth/signup/)，并生成一个 API key。

  让 Superset 可以使用该 API key：

  ```bash theme={null}
  echo "MAPBOX_API_KEY=pk.SAMPLE-Use-your-key-instead" >> docker/.env-non-dev
  ```

  ## 部署 Superset 2.0.0 版本

  要部署 2.0.0 发布版本，请运行：

  ```bash theme={null}
  git checkout 2.0.0
  TAG=2.0.0 docker-compose -f docker-compose-non-dev.yml pull
  TAG=2.0.0 docker-compose -f docker-compose-non-dev.yml up
  ```
</Accordion>

要使用 OpenCelliD 数据集构建 Superset 仪表板，你需要：

* 将你的 ClickHouse 服务添加为 Superset **数据库**
* 将 **cell\_towers** 表添加为 Superset **数据集**
* 创建一些 **图表**
* 将这些图表添加到 **仪表板**

<div id="add-your-clickhouse-service-as-a-superset-database">
  ### 将您的 ClickHouse 服务添加为 Superset 数据库
</div>

要通过 HTTP(S) 连接到 ClickHouse，你需要以下信息：

| Parameter(s)              | Description                                |
| ------------------------- | ------------------------------------------ |
| `HOST` and `PORT`         | 通常，使用 TLS 时端口为 8443；不使用 TLS 时端口为 8123。     |
| `DATABASE NAME`           | 默认情况下，存在一个名为 `default` 的数据库。请使用你要连接的数据库名称。 |
| `USERNAME` and `PASSWORD` | 默认情况下，用户名为 `default`。请根据你的使用场景使用相应的用户名。    |

你的 ClickHouse Cloud 服务的连接信息可在 ClickHouse Cloud 控制台中查看。
选择一个服务，然后点击 **Connect**：

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/Qke-GQkmVyWEhvPu/images/_snippets/cloud-connect-button.png?fit=max&auto=format&n=Qke-GQkmVyWEhvPu&q=85&s=a41d53ce6c46ccccb2855331a8dcc841" size="md" alt="ClickHouse Cloud 服务连接按钮" border width="998" height="932" data-path="images/_snippets/cloud-connect-button.png" />

选择 **HTTPS**。连接信息会显示在示例 `curl` 命令中。

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/Qke-GQkmVyWEhvPu/images/_snippets/connection-details-https.png?fit=max&auto=format&n=Qke-GQkmVyWEhvPu&q=85&s=0377c34215bd524b359c0d20dd96bed3" size="md" alt="ClickHouse Cloud HTTPS 连接信息" border width="1320" height="1184" data-path="images/_snippets/connection-details-https.png" />

如果你使用的是自管理 ClickHouse，则连接信息由你的 ClickHouse 管理员配置。

在 Superset 中，添加数据库时，先选择数据库类型，然后填写连接详情。打开 Superset，找到 **+**，在菜单中依次选择 **Data** 和 **Connect database**。

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/qvDh3oxLPI7c74wx/images/getting-started/example-datasets/superset-add.png?fit=max&auto=format&n=qvDh3oxLPI7c74wx&q=85&s=2244140412c206de10ecfb897814ec0a" size="md" alt="添加数据库" width="636" height="264" data-path="images/getting-started/example-datasets/superset-add.png" />

从列表中选择 **ClickHouse Connect**：

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/qvDh3oxLPI7c74wx/images/getting-started/example-datasets/superset-choose-a-database.png?fit=max&auto=format&n=qvDh3oxLPI7c74wx&q=85&s=6e95308cbf2388e8f52636ec8e54d328" size="md" alt="选择 ClickHouse Connect 作为数据库类型" width="594" height="751" data-path="images/getting-started/example-datasets/superset-choose-a-database.png" />

<Note>
  如果选项中没有 **ClickHouse Connect**，则需要先安装它。安装命令为 `pip install clickhouse-connect`，更多信息可[参见此处](https://pypi.org/project/clickhouse-connect/)。
</Note>

<div id="add-your-connection-details">
  #### 添加连接信息
</div>

<Tip>
  连接到 ClickHouse Cloud 或其他强制使用 SSL 的 ClickHouse 系统时，请确保已开启 **SSL**。
</Tip>

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/qvDh3oxLPI7c74wx/images/getting-started/example-datasets/superset-connect-a-database.png?fit=max&auto=format&n=qvDh3oxLPI7c74wx&q=85&s=71b05fd5b6a36e09650c29ab268e73f0" size="md" alt="将 ClickHouse 添加为 Superset 数据源" width="604" height="983" data-path="images/getting-started/example-datasets/superset-connect-a-database.png" />

<div id="add-the-table-cell_towers-as-a-superset-dataset">
  ### 将表 **cell\_towers** 添加为 Superset **数据集**
</div>

在 Superset 中，**数据集** 对应数据库中的一张表。点击“添加数据集”，然后选择你的 ClickHouse 服务、包含该表的数据库 (`default`) 以及 `cell_towers` 表：

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/qvDh3oxLPI7c74wx/images/getting-started/example-datasets/superset-add-dataset.png?fit=max&auto=format&n=qvDh3oxLPI7c74wx&q=85&s=c867b69cda60e2153b41a9106f36a99a" size="md" alt="将 cell_towers 表添加为数据集" width="715" height="825" data-path="images/getting-started/example-datasets/superset-add-dataset.png" />

<div id="create-some-charts">
  ### 创建几个**图表**
</div>

在 Superset 中添加图表时，需要指定数据集 (`cell_towers`) 和图表类型。由于 OpenCelliD 数据集提供了蜂窝基站的经纬度坐标，我们将创建一个 **Map** 图表。**deck.gL Scatterplot** 类型非常适合这个数据集，因为它能很好地在地图上呈现高密度数据点。

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/qvDh3oxLPI7c74wx/images/getting-started/example-datasets/superset-create-map.png?fit=max&auto=format&n=qvDh3oxLPI7c74wx&q=85&s=c7bc376b2097579b09c9eb58c47c07f9" size="md" alt="在 Superset 中创建地图" width="965" height="928" data-path="images/getting-started/example-datasets/superset-create-map.png" />

<div id="specify-the-query-used-for-the-map">
  #### 指定地图使用的查询
</div>

deck.gl 的 Scatterplot 需要经度和纬度，也可以对查询应用一个或多个过滤器。在本例中应用了两个过滤器：一个用于筛选使用 UMTS 制式的蜂窝基站，另一个用于筛选分配给荷兰的移动国家代码。

字段 `lon` 和 `lat` 分别包含经度和纬度：

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/qvDh3oxLPI7c74wx/images/getting-started/example-datasets/superset-lon-lat.png?fit=max&auto=format&n=qvDh3oxLPI7c74wx&q=85&s=823a4c6d4cf75f6041ab2f88a420e144" size="md" alt="指定经度和纬度字段" width="436" height="454" data-path="images/getting-started/example-datasets/superset-lon-lat.png" />

添加一个 `mcc` = `204` 的过滤器 (或替换为其他任意 `mcc` 值) ：

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/qvDh3oxLPI7c74wx/images/getting-started/example-datasets/superset-mcc-204.png?fit=max&auto=format&n=qvDh3oxLPI7c74wx&q=85&s=e06c12698813557c305264e0cd8bac14" size="md" alt="按 MCC 204 过滤" width="421" height="370" data-path="images/getting-started/example-datasets/superset-mcc-204.png" />

添加一个 `radio` = `'UMTS'` 的过滤器 (或替换为其他任意 `radio` 值，可在 `DESCRIBE TABLE cell_towers` 的输出中查看可选值) ：

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/qvDh3oxLPI7c74wx/images/getting-started/example-datasets/superset-radio-umts.png?fit=max&auto=format&n=qvDh3oxLPI7c74wx&q=85&s=e143ae895b0536eb9ca85265e2428e3a" size="md" alt="按 radio 等于 UMTS 过滤" width="424" height="361" data-path="images/getting-started/example-datasets/superset-radio-umts.png" />

这是对 `radio = 'UMTS'` 和 `mcc = 204` 进行过滤时的完整图表配置：

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/qvDh3oxLPI7c74wx/images/getting-started/example-datasets/superset-umts-netherlands.png?fit=max&auto=format&n=qvDh3oxLPI7c74wx&q=85&s=b46a1b83507d63806c404ca5e878fe9f" size="md" alt="MCC 204 中 UMTS 制式的图表" width="395" height="872" data-path="images/getting-started/example-datasets/superset-umts-netherlands.png" />

点击 **UPDATE CHART** 以生成可视化结果。

<div id="add-the-charts-to-a-dashboard">
  ### 将图表添加到**仪表板**
</div>

此截图显示了采用 LTE、UMTS 和 GSM 制式的蜂窝基站位置。所有图表的创建方式都相同，然后再添加到同一个仪表板中。

<Image img="https://mintcdn.com/private-7c7dfe99-mintlify-fbfa8bee/qvDh3oxLPI7c74wx/images/getting-started/example-datasets/superset-cell-tower-dashboard.png?fit=max&auto=format&n=qvDh3oxLPI7c74wx&q=85&s=82f088a1a38421eca04f6e525e5687fb" size="md" alt="mcc 204 中按无线制式划分的蜂窝基站仪表板" width="1103" height="1014" data-path="images/getting-started/example-datasets/superset-cell-tower-dashboard.png" />

<Tip>
  这些数据也可以在 [Playground](https://sql.clickhouse.com) 中进行交互式查询。

  这个[示例](https://sql.clickhouse.com?query_id=UV8M4MAGS2PWAUOAYAAARM)甚至会自动为你填充用户名和查询语句。

  虽然你不能在 Playground 中创建表，但可以运行所有查询，甚至还可以使用 Superset (调整主机名和端口号即可) 。
</Tip>