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 19: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"