---
# System prepended metadata

title: 图传

---

# 图传

![](https://i.imgur.com/yanX3fs.png)
![](https://i.imgur.com/1l2nPf3.png)
![](https://i.imgur.com/ZYI2wN1.png)
![](https://i.imgur.com/H6Kbh6O.png)




![](https://i.imgur.com/M92JenP.png)

'輔大','關渡','小南門','大直','西湖','萬芳醫院','港墘','紅樹林','木柵','大安',

![](https://i.imgur.com/1jR4gVe.png)

'永寧','府中','忠孝新生','小碧潭','動物園','龍山寺','新店','anomaly_rate','圓山','板橋'


![](https://i.imgur.com/DZMnOvw.png)

![](https://i.imgur.com/jUHHCyg.png)

		WITH AVG_TABLE AS(
		WITH const AS (SELECT extract(EPOCH from {interval}::interval) gap)
		SELECT to_timestamp(floor((extract(EPOCH from date) / const.gap)) * const.gap)
		AT TIME ZONE 'UTC' as interval_alias,
		{grouped_columns} {mask}
		FROM {schema}.{tbl}, const
		{date_cond}
		GROUP BY interval_alias
		ORDER BY {sort})
		SELECT {columns} FROM AVG_TABLE
        
        
![](https://i.imgur.com/KV8Fk6s.png)

![](https://i.imgur.com/WlAPn8Y.png)


![](https://i.imgur.com/KXIgjS6.jpg)
![](https://i.imgur.com/FBYJYVC.png)


![](https://i.imgur.com/rGu63zu.png)


![](https://i.imgur.com/TkUjd9Y.png)


![](https://i.imgur.com/tSbmIDK.png)




![](https://i.imgur.com/0927nKk.png)



![](https://i.imgur.com/6UbmU1F.png)

![](https://i.imgur.com/rf6VCSs.png)


Discover events of interest from a global view


![](https://i.imgur.com/7lmmdwt.png)
