The SLGL dataHub is an in-development platform to access the digital twin of the bi-national St. Lawrence-Great Lakes region’s economic system. To enable the holistic examination of the dynamics of economic activity within this vital region, geospatial data on its trade, transportation and environmental systems are first being harmonized. Visualizations to investigate the dynamics of firm and industrial competitiveness will be made accessible across the four dimensions of our modèle de diamant de données, which are Global Value Chains, Economic Clusters, Economic Complexity and the Gravity Model.
The SLGL dataHub platform will soon be publicly accessible. Subscribe to our newsletter to be the first to know when it’s available.
*
Do your own analysis
For users looking to do their own analysis, access to the database underlying the SLGL dataHub can now be requested by following one of the methods listed below.
Our database currently integrates and harmonizes diverse datasets from the domains of trade and transportation, such as industry input-output tables, firm characteristics, transportation flows by mode, transport infrastructure and freight traffic at border crossings in the SLGL region. The centrepiece of our database is the industry input-output tables, which are uniquely reconstructed to operate at two levels of geographic resolution: first, at the country level, and second, between Canadian provinces and U.S. states within the SLGL region. This structure allows users to identify inter-industry flows between sub-national levels like Québec and New York, or even to other countries such as Germany.
Method 1
Apache Superset
Method 2
QGIS
Method 3
API access
Superset offers an intuitive drag-and-drop interface ideal for quickly setting up interactive dashboards. Explore our data using over 40 chart types, ranging from simple bar charts to geospatial maps.
Want to delve into more advanced geospatial analysis? Leverage our data to create maps and uncover insights using a comprehensive set of no-code analysis tools with QGIS.
Don’t want to be limited by the platform? Get API access to our database and gain the freedom to transform the data to suit your analysis. Ideal for users with extensive coding expertise.
Step 1
Clone Apache Superset on your machine.
Step 2
Install the database driver for our connector library. Once the driver is installed, navigate to Settings > Data: Database Connections to complete the setup for connecting to our SQL database. Contact us now to request access and get started!
Step 1
Install QGIS on your machine.
Step 2
Connect to our SQL database by entering the connection details in Database > DB Manager. Contact us now to request access and get started!
Step 1
Install R and R Studio on your machine.
Step 2
Install and load the httr2 package, then use your unique API key to connect to our SQL database. Contact us now to request access and get started!
Not sure where to start? Master data analysis and drive evidence-based decision-making with Geo Spatial Data Science for Global Studies. For an introduction to Superset, use this guide.
Users of the SLGL dataHub or its underlying database should reference the following position paper, which outlines our objectives in applying digital twin technology to study competitiveness and developing a digital twin of the St. Lawrence-Great Lakes region.
Forthcoming.