tpe-doit / taipei-city-dashboard Goto Github PK

View Code? Open in Web Editor NEW

115.0 3.0 345.0 1.07 GB

The Open-Source Repository of Taipei City Dashboard. Try it out by clicking the link below!

Home Page: https://citydashboard.taipei

License: Other

HTML 0.11% Vue 19.82% JavaScript 16.13% CSS 0.42% Go 10.03% PLpgSQL 23.21% Dockerfile 0.09% Python 30.19%

city-dashboard taipei-city-government taipei-urban-intelligence-center

taipei-city-dashboard's Introduction

Taipei City Dashboard

Introduction

Taipei City Dashboard is a data visualization platform developed by Taipei Urban Intelligence Center (TUIC).

Our main goal is to create a comprehensive data visualization tool to assist in Taipei City policy decisions. This was achieved through the first version of the Taipei City Dashboard, which displayed a mix of internal and open data, seamlessly blending statistical and geographical data.

Fast forward to mid-2023, as Taipei City’s open data ecosystem matured and expanded, our vision gradually expanded as well. We aimed not only to aid policy decisions but also to keep citizens informed about the important statistics of their city. Given the effectiveness of this tool, we also hoped to publicize the codebase for this project so that any relevant organization could easily create a similar data visualization tool of their own.

Our dashboard, made yours.

Based on the above vision, we decided to begin development on Taipei City Dashboard 2.0. Unlike its predecessor, Taipei City Dashboard 2.0 will be a public platform instead of an internal tool. The codebase for Taipei City Dashboard will also be open-sourced, inviting all interested parties to participate in the development of this platform.

We have since released Taipei City Dashboard 2.0 to the general public. From now on, you will be able to suggest features and changes to Taipei City Dashboard and develop the platform alongside us. We are excited for you to join Taipei City Dashboard’s journey!

Please refer to the docs for the Chinese Version (and click on the "switch languages" icon in the top right corner).

Official Site | License | Code of Conduct | Contribution Guide

Quick Start

Please refer to the Docs for the quick start guide.

Documentation

Check out the complete documentation for Taipei City Dashboard here.

Contributors

Many thanks to the contributors to this project!

taipei-city-dashboard's People

Contributors

Stargazers

Watchers

Forkers

syho2000 godspeedhuang mbakpur123 harshvi-nimavat jackllll1312 jhh11 ann125697 tiggerjeff3669 leonarwiz jjwang1118 rakechen-0307 dimanthag himtaipei yoshikigo tabooization123 zsu0915 cnyang toma-l c0d1r andrewyeee taipeintuh yurychang tan9 wuyuchuan617 walkerhsu wayneyellow tsaichiehhuang anne030303 smanhuang kevinyang2229 im-kinuko james60415 chun-cheng m4xshen sw-willie-wu jerrylin0202 kouki-55 huxxhu laudantstolam kilinw lin-rexter leo-zhen12 playthepai jhtnt petrus1732 yunru122 tvava59 uuuuse milktea712073 hyouka0904 kjwen310 xinred lai10297000 huangyyuuu yufangshen 11044126 str367 uier yunyenwang wizzyleo chenjoachim digigov jason810496 u9951064 shangyenlee annie0168 andrewchiull shixiang0222 yiting-224 rythamexc zoeeyyyy shineve peterxcli mengtiennn zachchiu peicheng0413 idkname4048228 jiklm code-fest-ivy-and-her-gang tzuuuu nekosgr93 haotien91 wx1006 hyy0529 krimacn franklee0516 jacy1225 vnaticzhock yooo0415 zhixian714 skyhong2002 re4388 kyliechien pinjhih poikladevv88 taipei-codefest-chlll bigpigking gracecheng0329 chunghwatelecom frank-hp-chang

taipei-city-dashboard's Issues

[Enhancement] Edit Update Time Labels

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

Make the "not live data" thing more obvious and various tweaks to existing chart types.

Describe alternatives you've considered

N/A

Additional context

Internal Issue. No Outside Contribution Required.

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Bug] Revise All Timestamps to ISO 8601

Describe the bug

Some timestamps are not in the correct format.

To Reproduce

N/A

Expected behavior

N/A

Screenshots

N/A

Environment Info

N/A

Additional context

N/A

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Bug] Improvements Required in Package Handling and Function References about Dashboard

Describe the bug

Within the auth package, failure to delete related data from other associated tables prior to database deletion may result in unsuccessful deletions.
In the controller package, the functions DeleteDashboard and UpdateDashboard should be modified to reference functions within the auth package.

To Reproduce

N/A

Expected behavior

In the auth package, the deletion process should ensure that all related data from other associated tables is deleted prior to the main database deletion. This sequence of operations should result in successful deletions without leaving any orphaned data behind.
Within the controller package, the functions DeleteDashboard and UpdateDashboard should be updated to directly reference the corresponding functions within the auth package. This modification ensures consistency and proper integration between different components of the system.

Screenshots

N/A

Environment Info

Device: [e.g. MacBook Pro / iPhone 12]
OS: [e.g. iOS]
Browser [e.g. chrome, safari]

Additional context

N/A

[Enhancement] Revise User Permission Display Method

Please describe your feature request

Modify user privileges with the following Permission struct definition:

type Permission struct {
	GroupID int `json:"group_id"`
	RoleID  int `json:"role_id"`
}

Describe alternatives you've considered

N/A

Additional context

N/A

[Bug] Inconsistent Use of Taipei City Government Single Sign-On Parameters Between Frontend and Backend

Describe the bug

There exists inconsistency in the utilization of Taipei City Government single sign-on parameters between the frontend and backend.

To Reproduce

Steps to reproduce the behavior:

N/A

Expected behavior

Both frontend and backend containers should retrieve necessary parameters such as TAIPEIPASS_URL, TAIPEIPASS_SCOPE, ISSO_URL, ISSO_CLIENT_ID, and ISSO_CLIENT_SECRET from the .env file. Currently, the backend stores URLs in global/consts.go file, leading to inconsistency.

Screenshots

N/A

Environment Info

Device: [e.g. MacBook Pro / iPhone 12]
OS: [e.g. iOS]
Browser [e.g. chrome, safari]

Additional context

N/A

[Enhancement] Refactor Map Filter

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

Remove the need to pass a list of filter values
Support filtering by layers
Support filtering through multiple layers
Support Setting default filter
Support opting to filter using control buttons instead of the chart

Describe alternatives you've considered

N/A

Additional context

New map filter object:
{
mode: "byParam" / "byLayer",
buttonControls: false,
byLayer: {
default: ""
},
byParam: {
xAxis: "",
yAxis: ""
}
}

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Feature] SpeedometerChart

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

SpeedometerChart

A chart which looks like a speedometer. When the data change, the needle will automatically move

Describe alternatives you've considered

None

Additional context

None

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Feature] MixedColumnLineChart, BarChartWithGoal

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

MixedColumnLineChart - Combination column and line chart
BarChartWithGoal - Bar chart with goal marker

Describe alternatives you've considered

N/A

Additional context

N/A

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Bug] Remove Sensitive Data From "dispatch" Component

Describe the bug

Sensitive data removal request.

To Reproduce

N/A

Expected behavior

N/A

Screenshots

N/A

Environment Info

N/A

Additional context

N/A

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Bug] Website Crash During Map Layers Load

Describe the bug

For larger map layers, if the user closes the toggle before the map has finished loading and then toggles the map again, the site may crash.

To Reproduce

Steps to reproduce the behavior:

Click on toggle to open map (for 城市屋齡分佈、路燈分佈)
Close the toggle before the map loads
Open the map again

Expected behavior

The loading of a map layer should be paused if the toggle is closed.

Screenshots

N/A

Environment Info

Device: PC
OS: Windows
Browser: Chrome

Additional context

N/A

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Enhancement] Add Docker Quick Start

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

Add Docker Quick Start option for this project

Describe alternatives you've considered

N/A

Additional context

N/A

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Enhancement] UI Enhancements Before Taipei Codefest

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

Minor changes and enhancements to the dashboard UI.

Describe alternatives you've considered

N/A

Additional context

N/A

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Enhancement] Add Backend Code

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

Transition this repository into a full-stack application.

Describe alternatives you've considered

N/A

Additional context

N/A

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Component] 153 gynecology_clinic / 154 newborn_stats / 155 breastfeeding_room / 160 pm10_measurments

Please describe the proposed component(s)

153 gynecology_clinic

This component shows the distribution of gynecology clinics and hospitals.

154 newborn_stats

This component shows the population of children for each district and village. It also provides history data.

155 breastfeeding room

This component shows the distribution of breastfeeding rooms and their facilities with respect to districts.

160 pm10_measurments

This component shows the current value of pm10 from each weather stations and the isoline map.

Datasets to be used

Proposed Chart Types and Map Types

153

Voronoi #93

155

PolarAreaChart #92

160

Isoline map #93

Additional context

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Enhancement] Add More Link Labels and Edit YouBike Component Links

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

Add more label options for the "more info" popup and also update the links in the YouBike components.

Describe alternatives you've considered

N/A

Additional context

Internal Issue.

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Component] 01 Building License / 02 Garbage Collection Locations

Please describe the proposed component(s)

Building License: The number of approved user and building permits in Taipei by month.
Garbage Collection Locations: When and where garbage trucks in Taipei collect trash.

Datasets to be used

1-1. https://data.taipei/dataset/detail?id=0816f991-e6c8-4da0-a789-d022fee1462b
1-2. https://data.taipei/dataset/detail?id=d8834353-ff8e-4a6c-9730-a4d3541f2669
2. https://data.taipei/dataset/detail?id=6bb3304b-4f46-4bb0-8cd1-60c66dcd1cae

Proposed Chart Types and Map Types

TimelineSeparateChart, TimelineStackedChart / N.A
BarChart, RadarChart, DistrictChart / Circle

Additional context

Will include history data with this component
Will add map filtering to this component

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Bug] Remove "hello_taipei" And

Describe the bug

A clear and concise description of what the bug is.

To Reproduce

Steps to reproduce the behavior:

Go to '...'
Click on '....'
Scroll down to '....'
See error

Expected behavior

A clear and concise description of what you expected to happen.

Screenshots

If applicable, add screenshots to help explain your problem.

Environment Info

Device: [e.g. MacBook Pro / iPhone 12]
OS: [e.g. iOS]
Browser [e.g. chrome, safari]

Additional context

Add any other context about the problem here.

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Enhancement] Add HeatMapChart

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

Add the heatmap chart type which will support the 3D data type. Will use Apexchart's existing module.

Describe alternatives you've considered

N/A

Additional context

(Fill in "x" to check)

I would like to work on this issue myself if approved.

2-Add-ApexCharts

Remove Highcharts
Change component container layout
Add all previous chart types

[Enhancement] Remove Redundant Files & Minor Debugging

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

Remove redundant json and geojson files from the front-end and fix some minor errors and bugs.

Describe alternatives you've considered

N/A

Additional context

N/A

[Component] 163 Flood Simulate / 164 Condemned Building

Please describe the proposed component(s)

Flood Simulate: Display the simulated flooding volume from rainfall across all districts in the city.
Condemned Building: Display the location and area of approved reconstruction projects for condemned buildings in Taipei City.

Datasets to be used

Proposed Chart Types and Map Types

N/A

Additional context

N/A

(Fill in "x" to check)

I would like to work on this issue myself if approved.

1-Turn-Into-Static-Application

Remove User Authentication
Decide on component JSON format
Add components list JSON
Add component data JSON
Add map data JSON
Modify Add Dashboard / Delete Dashboard / Dashboard Settings / Add Components to static
Implement Map Functionality

[Enhancement] Implement Refresh JWT Token Feature for Updated Permissions to Take Effect in Database

Please describe your feature request

Add functionality to refresh JWT tokens to ensure updated permissions reflect in the database within the next five minutes.

Describe alternatives you've considered

N/A

Additional context

To minimize frequent database queries, user permissions should primarily rely on information stored within the token.

[Component] 1. YouBike Availability 2. YouBike Substitute Stations

Please describe the proposed component(s)

Display the average availability rate of each YouBike station over 1 month
Display the substitute stations for each YouBike station

Datasets to be used

TUIC Internal Research Results

Proposed Chart Types and Map Types

BarChart / CircleMap with map filtering enabled.
DonutChart / LineMap with map filtering enabled.

Additional context

Internal Issue. No outside contribution is required.

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Component]161、162

Please describe the proposed component(s)

161: 防洪與雨水設備:顯示全市防洪與雨水設備的面積和分佈位置
162: 透水鋪面:顯示全市透水性鋪面的面積和分佈位置

Datasets to be used

https://data.taipei/dataset/detail?id=5b277432-f534-4d09-a24c-d3f6b514e042

Proposed Chart Types and Map Types

Chart Types "treemap" and Map Types "fill、line" to attach to the component.

Additional context

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Component] YouBike Weekend Rider Behavior

Please describe the proposed component(s)

Display rider behavior of YouBike users during the weekends.

Datasets to be used

TUIC Internal Research Results

Proposed Chart Types and Map Types

HeatMapChart / ArcMap with map filtering enabled.

Additional context

Internal Issue. No outside contribution is required.

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[from-demo] 20240111 組件基本資訊有誤 - 160 | 懸浮微粒量測值

名稱為 "古亭" 的站點位置，標記在南港地區

Issue Opener: chewei

[Component] YouBike Weekday Rider Behavior

Please describe the proposed component(s)

Display rider behavior of YouBike users during weekdays.

Datasets to be used

TUIC Internal Research Results

Proposed Chart Types and Map Types

HeatMapChart / ArcMap with map filtering enabled.

Additional context

Internal Issue. No outside contribution is required.

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Component] 151 parental_leave

Please describe the proposed component(s)

This chart uses icons to show the percentage difference between two sets of data.

Datasets to be used

Links to Taipei Open Data and BLI data sources .

Proposed Chart Types and Map Types

N/A

Additional context

data json example:

chart_config :

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Enhancement] Component Info Page Optimization and Callback Page

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

Revise component info page per @Chu-c-git 's recommendations and create callback page for Taipei Pass.

Describe alternatives you've considered

N/A

Additional context

N/A

[Bug] Poor Mapbox Performance On Mobile

Describe the bug

When maps are rendered on mobile, oftentimes the application will run out of memory. This is probably due to our rendering most maps locally via geojsons as this is a static application.

In the internal version, most maps are rendered first on the server (geoserver) and served to the application as raster maps. This greatly improves the performance of Mapbox.

As Taipei City Dashboard 2.0 completes the open-source of its backend and database, this problem should go away as we will transition back to using raster maps.

However, we would still like to improve the performance of locally rendered maps and would welcome any community contribution on this matter.

To Reproduce

Steps to reproduce the behavior:

Go to maps on mobile
Open a slightly larger map
Blank screen (oom)

Expected behavior

Maps to be rendered properly.

Screenshots

N/A

Environment Info

Device: iPhones are known to have this issue. Android phones fare better. PCs are all fine to my knowledge.
OS: iOS
Browser: chrome, safari

Additional context

Geojsons are currently rendered as per the Mapbox docs. We are also in the process of cleaning existing geojsons. Contributions to this issue can attempt to streamline the map rendering process and see if that helps.

Contestants of Taipei Codefest 2023 do not have to worry about this issue as all demonstrations will be conducted via PC.

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Bug] Database Initialization Function Doesn't Verify Tables Existence

Describe the bug

The "init database" function lacks validation to verify whether the tables already exists before attempting initialization.

To Reproduce

Steps to reproduce the behavior:

Run docker-compose -f docker-compose-init.yaml up -d command again.

Expected behavior

Prior to executing the init function, check whether tables exist in the database. If present, log the occurrence and terminate the program. Otherwise, proceed with table creation and data insertion.
If the init command includes the -f parameter, delete all tables from the database and subsequently recreate tables along with data insertion.

Screenshots

N/A

Additional context

N/A

[Feature] Cluster Map

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

The map uses built-in cluser functions to visualize points in a circle layer as clusters.

Describe alternatives you've considered

I considered using heatmap instead of cluster.

Additional context

Add any other context or screenshots about the feature request here.

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Feature] Voronoi and Isoline Maps

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

Voronoi

Divide the area so that each point is in the same region as its nearest facility, such as a hospital.

Isoline

Use data from discrete points to approximate the data of any point.

Describe alternatives you've considered

None

Additional context

Voronoi

Isoline

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Enhancement] Create Admin Manager Pages

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

In preparation for connecting with TCD's back-end, create the necessary admin manager pages.

Describe alternatives you've considered

N/A

Additional context

N/A

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Enhancement] Remove Redundant Properties in All Geojsons

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

Many geojsons have redundant properties that are never used. It is estimated that hundreds of megabytes of space could be freed up if the redundant properties are removed.

Describe alternatives you've considered

N/A

Additional context

Use python to write an automated script to clean all geojsons at once.

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Bug] Remove "hello_taipei" And "public_safety" Components

Describe the bug

Remove components that use internal data

To Reproduce

N/A

Expected behavior

N/A

Screenshots

N/A

Environment Info

N/A

Additional context

N/A

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Component] 152 residential safety

Please describe the proposed component(s)

residential safety

Datasets to be used

Links to Taipei Open Data sources.

Proposed Chart Types and Map Types

Chart Types

ColumnChart
BarPercentChart

Map Types

fill-extrusion-color

Additional context

Add any other context here.

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Enhancement] Remove /public/mapData .gitignore

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

After cleaning all geojsons within the application, all file sizes are under GitHub's 100MB size limit.

Describe alternatives you've considered

N/A

Additional context

N/A

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Component] 1. YouBike Status in 250x250m Grids 2. YouBike Potential Demand

Please describe the proposed component(s)

Whether YouBike has already placed stations in a grid square and if they potentially can in the future.
Determining the potential demand of grid squares that are eligible but currently don't have YouBike stations.

Datasets to be used

Links to Taipei Open Data sources.

Proposed Chart Types and Map Types

TreemapChart / FillMap with map filtering enabled
BarPercentChart, ColumnChart / FillExtrusionMap with map filtering enabled

Additional context

Add any other context here.

(Fill in "x" to check)

I would like to work on this issue myself if approved.

3-Add-Filter-Add-Timeline

Add map filter function
Add at least 10 more components
Add timeline function

[Enhancement] Add Map Filtering For Heatmap Chart

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

Add map filtering for heatmap charts.

Describe alternatives you've considered

N/A

Additional context

N/A

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Enhancement] Popups On Component Tags

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

Tags have often been confused as buttons. A solution was found on Agoda where a small info box will popup when a tag is hovered over, resolving the confusion once and for all.

Describe alternatives you've considered

N/A

Additional context

N/A

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Enhancement] Add More Info to Mapview

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

Allow users to access more info dialog in the mapview page as well.

Describe alternatives you've considered

N/A

Additional context

N/A

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Enhancement] Add Component Icons

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

Add component icons to the application

Describe alternatives you've considered

No alternatives are present.

Additional context

N/A

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Enhancement] Modify Project Setup for Improved Development Workflow

Please describe your feature request

The goal is to establish a standardized developer environment that all team members can easily adopt. This includes setting up, and configurations across all development machines.

Describe alternatives you've considered

N/A

Additional context

N/A

[Component] 156 maternity_hospitals

Please describe the proposed component(s)

156 maternity_hospitals

this component shows the hospitals that provide maternity services

Datasets to be used

https://data.taipei/dataset/detail?id=9ee72240-f9b3-42a7-bcbe-e1bb1a28a2dc
https://data.taipei/dataset/detail?id=a14dd58c-ecef-480c-b574-889ecfa631c3

Proposed Chart Types and Map Types

None

Additional context

Add any other context here.

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Feature] PolarAreaChart

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

A chart similar to bar chart, but is on polar coordinates and supports sorting.

Describe alternatives you've considered

None

Additional context

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Enhancement] Add Arc Map Type

Type

Application Functionalities
New Chart Type
New Map Type
Other

Please describe your feature request

In addition to 2D lines, 3D arcs may provide a clearer representation of paths that intersect. This map type would support lines with only two points and render curves of varying heights and curvatures based on distance. A new package, "Threebox" needs to be added to render the curves. An example is shown below.

Describe alternatives you've considered

N/A

Additional context

(Fill in "x" to check)

I would like to work on this issue myself if approved.

[Component] Edit YouBike Components Per DOT Discussion

Please describe the proposed component(s)

Affected Components:

60 - youbike_availability
142 - youbike_weekend
143 - youbike_weekday
144 - youbike_avail_pct
145 - youbike_sub_stn
146 - youbike_grid
147 - youbike_demand

Datasets to be used

No Change.

Proposed Chart Types and Map Types

No Change.

Additional context

N/A

(Fill in "x" to check)

I would like to work on this issue myself if approved.