Creating and visualizing tilesets
The CARTO Workspace offers a user interface that you can use to create tilesets. The option Create a tileset is available in the Data Explorer section from the Connections tab. To create a tileset from your data, select an available connection and click on a specific table (database/project(s), schemas/datasets and tables) from the collapsible tree.
To check that your account has access to the Tiler, try running this query:
Once you are all set getting access to the Tiler, creating a tileset is as easy as opening your Redshift console and running a query. In this case, we are going to create a simple tileset (see Tileset procedures) from a couple of joined tables: one containing demographic information for Spain at the census section level, the other containing the geometries of the census sections.
The result will be a tileset with the geometry and the total population (
t1_1variable) per census section:
USE DATABASE <analytics_toolbox_db>;
'SELECT g.geom g.do_area, d.t1_1 FROM carto-do-public-data.esp_ine.geography_esp_censussection_2011 g
LEFT JOIN carto-do-public-data.esp_ine.demographics_sociodemographics_esp_censussection_2011_yearly_2011 d
ON (d.geoid = g.geoid)',
The CARTO Workspace offers access to the Data Explorer, where you will be able to preview your tilesets, and Builder, CARTO’s state-of-the-art map making tool, where you will be able to style them, include them in your visualizations and share them.
The Data Explorer offers a preview of your tilesets and displays their associated details and metadata, such as their size, number of records and statistics regarding the tile sizes per zoom level. Please refer to this page for more information regarding the Data Explorer.
You can include tilesets as layers in your maps created with Builder. To do so, you have two options:
- use the Create map option from the tileset preview page in the Data Explorer (see previous screenshot). This action will create a new map with your tileset as a its only layer.
- adding a layer to an existing map.
For the latter option, you simply need to follow these simple steps:
- 1.Click on the Add source from button in Builder, that can be found at the bottom left of the screen.
- 2.Choose the Redshift connection from where your tileset is accessible.
- 3.Browse your projects and datasets until you find your tileset in the data explorer tree.
- 4.Select your tileset. Your tileset will then be added as a layer.