Aller au contenu principal

How to debug Superset OSMSIG

Requirements​

  • A postgresql instance
  • An accessible tileserver instance

Create database​

Create (or find) a database which contains entries with locations. For exemple you can create a fake database like this.

-- Step 1: Create the database if not already done
CREATE DATABASE superset_test;

-- Step 2: Connect to the superset_test database
\c superset_test;

-- Step 3: Create the table with the necessary columns (no geojson)
CREATE TABLE location_data (
id SERIAL PRIMARY KEY,             -- Automatically generated primary key
name VARCHAR(255) NOT NULL,         -- Name of the location
date DATE NOT NULL,                 -- Date of the location data
lat DOUBLE PRECISION,               -- Latitude as a double precision number
long DOUBLE PRECISION              -- Longitude as a double precision number
);

-- Step 4: Insert 5 European cities with their data (without geojson)

INSERT INTO location_data (name, date, lat, long)
VALUES
('Paris', '2025-04-02', 48.8566, 2.3522),  -- Paris, France
('Berlin', '2025-04-02', 52.5200, 13.4050),  -- Berlin, Germany
('Madrid', '2025-04-02', 40.4168, -3.7038),  -- Madrid, Spain
('Rome', '2025-04-02', 41.9028, 12.4964),  -- Rome, Italy
('Amsterdam', '2025-04-02', 52.3676, 4.9041); -- Amsterdam, Netherlands

Create a chart​

Now, create a Datasource connection and a corresponding Dataset.
Create a Map chart, like Deck.gl Arc, select corresponding lat and long.

Set OSM/ tileserver style url in corresponding input. Your map should displayed