Difference between revisions of "Visualizing Multi-Temporal Data with Time Manager"
From CUOSGwiki
Jump to navigationJump to search| Line 1: | Line 1: | ||
| − | ==Introduction== |
||
| − | This is a 10 minute walk through |
||
| − | ==Requirements== |
||
| − | * [http://mapbox.com/tilemill/ TileMill] |
||
| − | * [http://hub.qgis.org/projects/quantum-gis/wiki/Download QGIS] |
||
| − | * [http://plugins.qgis.org/plugins/timemanager/ Time Manager] |
||
| − | * [http://www.libreoffice.org/download/ LibreOffice] |
||
| − | ==Getting |
+ | ==Getting Data== |
| − | * Proceed to [https://data.seattle.gov/ data.seattle.gov] |
||
| − | * Search "GIS" |
||
| − | |||
| − | ==Getting Started (Time Manager)== |
||
| − | {| border="1" cellpadding="5" cellspacing="0" align="center" |
||
| − | |+'''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 |
+ | ===Getting CSV data=== |
* Proceed to [https://data.seattle.gov/ data.seattle.gov] |
* Proceed to [https://data.seattle.gov/ data.seattle.gov] |
||
* Search and open [https://data.seattle.gov/Public-Safety/Seattle-Real-Time-Fire-911-Calls/kzjm-xkqj Seattle Real Time Fire 911 Calls] |
* Search and open [https://data.seattle.gov/Public-Safety/Seattle-Real-Time-Fire-911-Calls/kzjm-xkqj Seattle Real Time Fire 911 Calls] |
||
| Line 27: | Line 8: | ||
* Download a copy of this dataset in [https://data.seattle.gov/api/views/kzjm-xkqj/rows.xlsx?accessType=DOWNLOAD XLSX] format |
* Download a copy of this dataset in [https://data.seattle.gov/api/views/kzjm-xkqj/rows.xlsx?accessType=DOWNLOAD XLSX] format |
||
| − | === |
+ | ===Getting Vector data== |
| + | |||
| + | ==Preparation of Data== |
||
| + | |||
| + | ===Spreadsheet=== |
||
* Import to Libreoffice or Openoffice or Microsoft Excel |
* Import to Libreoffice or Openoffice or Microsoft Excel |
||
| Line 41: | Line 26: | ||
* Change format to the following: YYYY-MM-DD HH:MM:SS |
* Change format to the following: YYYY-MM-DD HH:MM:SS |
||
* Save file in CSV format. |
* Save file in CSV format. |
||
| − | |- |
||
| − | |} |
||
| − | |||
| − | ==Loading data to QGSIS== |
||
| − | ===Create new project of QGIS=== |
||
| − | ===Base Map=== |
||
| − | ===Load CSV file=== |
||
| − | ===Save as ESRI shapefile=== |
||
| + | ==Importing Data== |
||
| − | == |
+ | ===Importing a spreadsheet === |
| + | * Start QGIS and click "Layer" on the toolbar. A drop down menu will appear. |
||
| + | * Click "Add Delimited Text Layer". |
||
| + | * Browse to location of your CSV file. |
||
| + | * Click on the "OK" button. |
||
| + | * Right click on the imported spreadsheet on the Layers panel. A drop down menu will appear. |
||
| + | * Click "Save As" |
||
| + | * Format should be "ESRI shapefile" |
||
| + | * CRS should be "WGS84" |
||
| + | * "Add saved file to map" should be enabled. |
||
| + | * Save file to a desired location. |
||
| + | * Click on the "OK" button. |
||
| + | ===Importing a vector polyline/polygon=== |
||
| − | ==Visualization in QGIS== |
||
| + | * Start QGIS and click "Layer" on the toolbar. A dropdown menu will appear. |
||
| − | ==Designing in TileMill== |
||
| + | * Click "Add Vector Layer". |
||
| + | * Browse to location of your WGS84 projected "shp" file. |
||
| + | * Click on the "Open" button. |
||
Revision as of 13:05, 17 December 2012
Contents
Getting Data
Getting CSV data
- Proceed to data.seattle.gov
- Search and open Seattle Real Time Fire 911 Calls
- Hover over and click Export
- Download a copy of this dataset in XLSX format
=Getting Vector data
Preparation of Data
Spreadsheet
- 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.
Importing Data
Importing a spreadsheet
- Start QGIS and click "Layer" on the toolbar. A drop down menu will appear.
- Click "Add Delimited Text Layer".
- Browse to location of your CSV file.
- Click on the "OK" button.
- Right click on the imported spreadsheet on the Layers panel. A drop down menu will appear.
- Click "Save As"
- Format should be "ESRI shapefile"
- CRS should be "WGS84"
- "Add saved file to map" should be enabled.
- Save file to a desired location.
- Click on the "OK" button.
Importing a vector polyline/polygon
- Start QGIS and click "Layer" on the toolbar. A dropdown menu will appear.
- Click "Add Vector Layer".
- Browse to location of your WGS84 projected "shp" file.
- Click on the "Open" button.
