Difference between revisions of "Visualizing Multi-Temporal Data with Time Manager"
From CUOSGwiki
Jump to navigationJump to search| Line 43: | Line 43: | ||
|- |
|- |
||
|} |
|} |
||
| − | |||
| − | ==Getting Started (Spreadsheet Data)== |
||
| − | [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. |
||
| − | |||
| − | ===Loading data to QGIS and Time Manager |
||
| − | |||
==Loading data to QGSIS== |
==Loading data to QGSIS== |
||
Revision as of 20:21, 15 December 2012
Contents
Introduction
This is a 10 minute walk through
Requirements
Getting Started (Vector Data)
- Proceed to data.seattle.gov
- Search "GIS"
Getting Started (Time Manager)
| Vector Data (Base Map) | Spreadsheet Data |
|---|---|
| Coming Soon | Video Demo
Getting the data
Data preparation
LibreOffice Calc/OpenOffice Calc
Microsoft Excel
|
