Thursday, September 9, 2010

sensr.net cameras from 31 timezones


I noticed we got a new camera from Jakarta recently. This made me curious as to where our cameras are located. When a user adds a camera to sensr.net, they can set the timezone. This allows us to show nice daily views of what's happening on their camera, as shown above.

I ran the following SQL command and you can see that we currently cover 31 time zones, including our new friend in Jakarta. Nice!


mysql> select distinct( time_zone ) from cameras
order by time_zone;
+-----------------------------+
| time_zone |
+-----------------------------+
| Abu Dhabi |
| Alaska |
| Amsterdam |
| Arizona |
| Bangkok |
| Berlin |
| Bern |
| Brasilia |
| Canberra |
| Casablanca |
| Central Time (US & Canada) |
| Chennai |
| Eastern Time (US & Canada) |
| Hanoi |
| Harare |
| Hawaii |
| Jakarta |
| Krasnoyarsk |
| Kuala Lumpur |
| Kyev |
| Lisbon |
| London |
| Minsk |
| Mountain Time (US & Canada) |
| Pacific Time (US & Canada) |
| Paris |
| Riyadh |
| Rome |
| Singapore |
| St. Petersburg |
| UTC |
+-----------------------------+
31 rows in set (0.00 sec)

Post a Comment