Difference between revisions of "Visualizing Multi-Temporal Data with Time Manager"

From CUOSGwiki
Jump to navigationJump to search
Line 12: Line 12:


==Getting Started (Time Manager)==
==Getting Started (Time Manager)==
{| border="1" cellpadding="5" cellspacing="0" align="center"
===Installing Time Manager Plugin===
|+'''Table 1. Data
|-
! style="color:#FFFFFF; background:#FF0AFF;" | Vector Data (Base Map)
! style="color:#FFFFFF; background:#FF0AFF;" | Spreadsheet Data
|-
| Coming Soon
| [http://youtu.be/rsT6yOSJzZQ Video Demo]

===Getting the data===
* Proceed to [https://data.seattle.gov/ data.seattle.gov]
* Open [https://data.seattle.gov/Public-Safety/Seattle-Real-Time-Fire-911-Calls/kzjm-xkqj Seattle Real Time Fire 911 Calls] under "Search & Browse Datasets and Views"; first link.
* Hover over and click Export
* Download a copy of this dataset in [https://data.seattle.gov/api/views/kzjm-xkqj/rows.xlsx?accessType=DOWNLOAD XLSX] format

===Data preparation===
* Import to Libreoffice or Openoffice or Microsoft Excel

====LibreOffice Calc/OpenOffice Calc====
* Right click on "datetime" column and proceed to "Format Cells".
* Find and click "User defined" in "Numbers" tab.
* Change format to the following: YYYY-MM-DD HH:MM:SS
* Save file in CSV format.

====Microsoft Excel====
* Right click on "datetime" column and proceed to "Format Cells".
* Find and click "Custom" in "Numbers" tab.
* Change format to the following: YYYY-MM-DD HH:MM:SS
* Save file in CSV format.
|-
|}

==Getting Started (Spreadsheet Data)==
==Getting Started (Spreadsheet Data)==
[http://youtu.be/rsT6yOSJzZQ Video Demo]
[http://youtu.be/rsT6yOSJzZQ Video Demo]

Revision as of 20:20, 15 December 2012

Introduction

This is a 10 minute walk through

Requirements

Getting Started (Vector Data)

Getting Started (Time Manager)

Table 1. Data
Vector Data (Base Map) Spreadsheet Data
Coming Soon Video Demo

Getting the data

Data preparation

  • Import to Libreoffice or Openoffice or Microsoft Excel

LibreOffice Calc/OpenOffice Calc

  • Right click on "datetime" column and proceed to "Format Cells".
  • Find and click "User defined" in "Numbers" tab.
  • Change format to the following: YYYY-MM-DD HH:MM:SS
  • Save file in CSV format.

Microsoft Excel

  • Right click on "datetime" column and proceed to "Format Cells".
  • Find and click "Custom" in "Numbers" tab.
  • Change format to the following: YYYY-MM-DD HH:MM:SS
  • Save file in CSV format.

Getting Started (Spreadsheet Data)

Video Demo

Getting the data

Data preparation

  • Import to Libreoffice or Openoffice or Microsoft Excel

LibreOffice Calc/OpenOffice Calc

  • Right click on "datetime" column and proceed to "Format Cells".
  • Find and click "User defined" in "Numbers" tab.
  • Change format to the following: YYYY-MM-DD HH:MM:SS
  • Save file in CSV format.

Microsoft Excel

  • Right click on "datetime" column and proceed to "Format Cells".
  • Find and click "Custom" in "Numbers" tab.
  • Change format to the following: YYYY-MM-DD HH:MM:SS
  • Save file in CSV format.

===Loading data to QGIS and Time Manager


Loading data to QGSIS

Create new project of QGIS

Base Map

Load CSV file

Save as ESRI shapefile

Designing a heatmap

Visualization in QGIS

Designing in TileMill

Retrieved from "https://dges.carleton.ca/CUOSGwiki/index.php?title=Visualizing_Multi-Temporal_Data_with_Time_Manager&oldid=2994"