TMap

a drilldownable thematic map visual with linked polygon layers
for Power BI

Download Visuals

Version What is new Release date
TMap 2.5
  • Added uploading shape file as additional datasources for linked polygon layers
  • Added uploading GeoJSON file as additional datasources for linked polygon layers
Released on Nov. 16, 2024.
TMap 2.4
  • Added 10 built-in boundary data as additional datasources for linked polygon layers
    1. World Administrative Boundaries
    2. Australia States
    3. Brazil States
    4. Canada Provinces
    5. France Regions
    6. Germany States
    7. India States
    8. Japan Prefectures
    9. UK Countries
    10. US States
  • Improved methods for calculating the center of polygons for labelling
Released on Oct. 20, 2024.
TMap 2.2
  • Combine symbol and choropleth map into one map to create symbol choropleth map
  • Combine chart and choropleth map into one map to create chart choropleth map
  • Improved display of number for percent format and human readable form
Released on Sept. 15, 2024.
Multi-pane Card 1.2
  • Data can be sorted by a specified column
  • Provided option to convert numbers to a human readable string
  • Numbers can be displayed in formats such as percentage and main currency symbols
Released on April 21, 2024.

Most of the features are free. For the features needed additional purchases, a watermark "Free Trial" and/or a banner with a link to upgrade your license will appear on the visual.

If you decide to purchase them, you can buy them for using in the environments that support license management or license enforcement such as Power BI service via Microsoft AppSource. if you want to use them in the environments that don't support license management or license enforcement such as Power BI report server, please contact: sales@mylocs.ca

Download Boundary Data in WKT Format

Data Description
World Administrative Boundaries Converted from Natural Earth's ne_110m_admin_0_countries dataset.
Canada Provincial Boundaries Converted from the OpenStreetMap dataset.
US State Boundaries Converted from the US Census Bureau’s cb_2018_us_state_20m dataset.
US County Boundaries Converted from the US Census Bureau’s cb_2021_us_county_20m dataset.
City of Toronto Ward Boundaries Converted from City Wards dataset in City of Toronto's Open Data Portal.

These data are free to use, but we don't guarantee their quality and accuracy. Natural Earth's data is in the public domain, please find its Terms of use. OpenStreetMap data is licensed under the Open Data Commons Open Database License (ODbL). You can find the US Census Bureau’s open data policy from here. City of Toronto's open data policy can be found from here.

How to Convert a Shape File into Well-Known Text (WKT) Format

1. Load shape file into SQL Server

SQL Server Spatial Tool is a convenient tool to load a shape file into SQL Server database. It can be download from here. You can also use OSGeo4W Shell in QGIS to load a shape file into MS SQL Server, please see details from Alastair's blog.

2. Convert the geography column into Well-Known Text (WKT)

"STAsText" function in SQL server can be used to convert a geography column into Well-Known Text (WKT).

GeoColumn.STAsText()

3. Reduce the length of Well-Known Text (WKT)

Reducing the number of points in a polygon can improve performance for the TMap Visual. The syntax of the function "Reduce" in SQL server is as below:

GeoColumn.Reduce(tolerance)

The parameter "tolerance" must be a positive number. The larger the "tolerance" is, the more points will be reduced. We recommend that the length of Well-Known Text (WKT) is less than 10,000. Please note that reducing too many points will make a polygon becomimg point, linestring or geometrycollection.