Difference between revisions of "Visualizing Multi-Temporal Data with Time Manager"
From CUOSGwiki
Jump to navigationJump to search| Line 12: | Line 12: | ||
* 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. |
* 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 |
* Hover over and click Export |
||
| − | * Download a copy of this dataset in |
+ | * Download a copy of this dataset in [https://data.seattle.gov/api/views/kzjm-xkqj/rows.xlsx?accessType=DOWNLOAD XLSX] format |
| + | |||
===Data preparation=== |
===Data preparation=== |
||
* Import to Libreoffice or Openoffice or Microsoft Excel |
* Import to Libreoffice or Openoffice or Microsoft Excel |
||
Revision as of 22:07, 12 December 2012
Contents
Introduction
This is a 10 minute walk through
Requirements
Getting Started (Spreadsheet Data)
Getting the data
- Proceed to data.seattle.gov
- Open 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 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 (Vector Data)
Getting Started (Time Manager)
Installing Time Manager Plugin
Loading data to QGSIS
Create new project of QGIS
Base Map
Load CSV file
Save as ESRI shapefile
===Create a heatmap===
