CARTO User Manual

CARTO User Manual

Go back

Creating a tileset from a data observatory subscription

Context

In this tutorial we are going to showcase how to leverage the public data offering from our Data Observatory and use the data from a subscription to build an interactive dashboard in our map-making tool, Builder. In order to build this dashboard we are going to first create a tileset in order to be able to visualize a larger amount of data.

Steps To Reproduce

  1. Go to the CARTO signup page.

    • Click on Log in.
    • Enter your email address and password. You can also log in with your existing Google account by clicking Continue with Google.
    • Once you have entered your credentials: click Continue.

    Log in Email and password

  2. Go to Data Observatory section to access our Spatial Data Catalog.

    Menu features data observatory

    DO Spatial data catalog

  3. Browse the catalog to find the best spatial datasets to enrich your analysis. With the catalog filters you can explore the different datasets per country of coverage, category, type of license, data providers and placetypes.

    DO Spatial data catalog filters

  4. For this example we are going to look for a dataset in Canada with a public license. In particular we are going to select the dataset from Statistics Canada in the “Demographic” category named “Sociodemographics - Canada (Census Division).

    DO Spatial data catalog filtered

  5. If we select that dataset, we can then access it’s particular page with all associated metadata (summary, data schema and map preview)

    DO Spatial data catalog summary

    DO Spatial data catalog data

    DO Spatial data catalog map

  6. As this is a public dataset we can both access the free sample or directly subscribe to the dataset for free. In this case we are going to go ahead with the full subscription.

    DO Spatial data catalog confirm public subscription

  7. Once we confirm the subscription, we are going to have access to the data from its relevant section in the Data Explorer.

    DO access data

  8. We have a look at the structure of the dataset to identify what are the main variables we are interested to analyze. For example: c0001_t (Population, 2016), c0005_t (Private dwellings occupied by usual residents), and c1677_t (Average value of dwellings).

    DO view variables

  9. Now, we are going to click on Create button. Note that the table of this dataset is too large to be loaded entirely in Builder of map creation. For this reason, CARTO offers you two options, either to create a map and add this dataset with the dynamic tile generation or creating a tileset and then leverage this tileset for building your map.

    DO table too large

  1. Click on Create a tileset. This will open a new modal screen for you to manage the tileset creation process. The first step is to set the location and name of the output tileset in a directory within the CARTO Data Warehouse where the user has write permissions. Once you have completed this configuration, click on Save here.

    DO create tileset settings

  2. In the next step we should select the output zoom levels for which we want the tileset to work (which we are going to change to be between level 2 and level 10 for this example). We can also add a custom description to the tileset. Click on Continue.

    DO create tileset settings

  3. Now it is time to select which columns we want to include in the tileset. In this example we are going to select: c0001_t (Population, 2016), c0005_t (Private dwellings occupied by usual residents), and c1677_t (Average value of dwellings). After selecting the columns we click on Continue.

    DO create tileset attributes

  4. We confirm that the details are correct and click on Create.

    DO create tileset confirmation

  5. While the tileset creation process is running you can minimize the progress window and continue working in CARTO.

    DO create tileset processing panel

  6. Once the process has completed, we can click and access the tileset in the Data Explorer.

    DO processing panel view tileset

  7. In the Data Explorer, now that we have the tileset created, we click on Create Map.

    DO tileset created

  8. In the Builder interface, you will see that a new map has been created with the tileset as the source of data.

    DO map created from tileset

  9. We can change the name of the layer.

    DO map layer renamed

  10. We can access the layer styling options to work in our visualization by clicking on “Layer style”.

    DO map layer style

  11. We can for example style the layer based on the values of the Population field (c0001_t) and select the color palette and opacity that we want for our visualization.

    DO map fill color based on

  12. We can also style the stroke around each polygon.

    DO map stroke color and width

  13. Once we are happy with the style of our layer we click on Back.

    DO map layer styled

  14. Next we are going to add a series of widgets to interact with the data. For that, we go to the “Widgets” section. We are going to add both a Formula and Histogram widget base on the c0001_t. For the Formula widget we are going to select the operation “SUM” and modify the Formatting to be in the format “12.3k”. We rename the widget to “Total Population, 2016”.

    DO map formula widget

  15. We then add a new widget with the Histogram type based on also on the “c0001_t” field (i.e. Population, 2016). We leave the buckets to 6.

    DO map histogram widget

    DO map formula and histogram widgets

  16. We are now going to change the basemap. For that, we go to the “Base maps” section. We can change it for example to Google Maps in the Positron edition.

    DO map basemap google maps positron

  17. Finally we can click on Share and modify the privacy settings of our map. We can also make the map public, which can then be accessed online with an associated url.

    DO map public option

  18. Finally, we can visualize the result.