Map of Metro Station Information

1. Problem description

On the basis of the new chart, Beijing subway line map and station information are realized through longitude and latitude.

When the mouse is placed on the station point, it will prompt the first and last train time of the station point.When you click the corresponding station, the exit information will pop up. Click the directory to pop up the relevant information, as shown in the figure below:

2. Solutions

Use the point map to customize the point style, and use the hyperlink to display the pop-up page.

1. Data preparation

Create a new database to query DS1. The SQL statement is: SELECT distinct cname,lot-0.006 as lot,lat-0.006 as lat,stationinfo FROM station; recording the first and last bus time of each station, as shown in the figure below:

Note: The dataset station is in Chinese FRDemo, we need to export the dataset to excel and attach as a file.

EN_station.xlsx

2. Insert chart

1）Create the main table of Map-BeijingStationMain.frm of the new decision report map, and drag the map to the body component, as shown in the figure below:

2）Create MapExit.cpt which is Beijing subway station exit information, add database query DS1, SQL statements: select CNAME, exitname, addr from exitinfo where CNAME = '${DZ}'; 

Similarly, we need to export to excel and create one dataset with the station name as the passing parameter. Please refer to Excel Dataset for more details. 

EN_exit.xlsx

3. Binding data

1）Bind the data in the main table of Beijing metro station information in the map, and set the series name as the Start/End Time, as shown in the figure below:

2）The data of exit information information bound to the map is shown in the figure below:

4. Main table style design

1）Select type > map point, set the GIS layer as Mapbox, with the Longitude and Latitude:

2）Select style > series, point style and select custom image, as shown in the following figure:

5. Main table hyperlink settings

1）Select special effects > interaction > hyperlink, click Add button to add exit information, select MapExit.cpt and add parameter station, as shown in the figure below:

6. Effect preview 

Save the template and click pagination preview. The effect is as follows:

For completed templates, please refer to:

%fr_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\Chart\Map\MapExit.cpt

%fr_HOME%\webapps\webroot\WEB-INF\reportlets\doc-EN\Chart\Map\Map-BeijingStationMain.frm

Click to download the template:

MapExit.cpt

Map-BeijingStationMain.frm