Map of Metro Station Information

Application Scenario

Based on the general map, the map of metro station information can display the subway route map and station information of Beijing through latitude and longitude.

When the cursor hovers over a station, the first and last bus times of the station are displayed. When clicking the corresponding station, you can see its Exit and Info catalogue. Click the catalogue to see related information about the station, as shown in the following figure.

Implementation Method

Customize the point style, and add hyperlinks to display pop-up pages in the point map.

Data Preparation

Choose File > New General Report in the upper left corner of the designer, and create a dataset ds1. The database query statement is as follows:

SELECT distinct cname,lot-0.006 as lot,lat-0.006 as lat,stationinfo FROM station;

The first and last bus times of each station are recorded in ds1 separately, as shown in the following figure.

Note:

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

EN_station.xlsx

Chart Insertion

1. Create a general report Beijing Subway Station Information Main Table.cpt, merge required cells, click the Insert Chart icon on the toolbar above, select Point Map, and click OK, as shown in the following figure. 

2. Create a map named Beijing Subway Station Information - Exit Information.cpt, add a database query ds1, and the database query statement is as follows:

SELECT cname,exitname,addr FROM exitinfo WHERE cname ='${dz}';

Drag the fields into the template, and the following figure shows the style.

Note:

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

Note: 

Set the first row as Repeat Title Row.

Data Binding

Bind the data of Beijing Subway Station Information Main Table to the map, select the map, choose Cell Element > Data, select Lat/Long for Geographic Info, set Series Name to First/Last Bus, and select First for Summary, as shown in the following figure.

Style Setting of the Main Chart

1. Choose Type > Point Map, set GIS layer as needed, with Beijing as the center, as shown in the following figure.

2. Choose Style > Series, select Series as Color Section, and select Custom Image as Point Style, as shown in the following figure.

Hyperlink Setting of the Main Chart

Exit Information Setting

1. Choose Special Effect > Interaction > Hyperlink, click the Add Hyperlink icon, and add a Web Report hyperlink, as shown in the following figure.

2. Select Beijing Subway Station Information - Exit Information.cpt and add a parameter dz, as shown in the following figure.

Effect Display

PC

Save the template and click Pagination Preview. The following figure shows the effect.

Mobile Terminal

The report can be previewed on both the DataAnalyst app and the HTML5 terminal. 

Click to download the example template.

MapExit.cpt

Map-BeijingStationMain.frm