how to supercharge your location data and reporting & analysis
TRANSCRIPT
How to Supercharge Your Location Data Reporting & Analysis
Create stylish reports based on data from ALL of your systems
What is reporting?
- merging data- presentation / styling- data summary-
PDF Example: City of Lloydminster
Goals:● Simplify● Automate ● Produce Large Scale Maps
Transformers: PDFPageFormatter, PDFStylerThanks to:
Richard BennettGIS Manager
City of Lloydminster
PDF Example - La Rioja
Orthophoto Map:● Incredibly Detailed● Use of Inset Maps, Annotation and Grids● Easily Updated Thanks to:
Ana García de Vicuña Ruiz de ArgandoñaGobierno de La Rioja – Spain
PDF Example: Topographic Map
MapnikRasterizer:● Qualitative Representation● Utilize Multiple Data Sources● Highly Detailed
Mapnik Mastery Webinar
Thanks to:Dmitri Bagh
Safe Software
Avenza MAPublisher®
FME Auto™data transformation to… cartographic design and publishing
• Use the format and transformer support of FME • Apply Adobe Illustrator strokes, fills, symbols and graphic styles• Automated labelling• Create Grids and Graticules• Automatic export to Geospatial PDF with control of feature
attributes
www.avenza.com/mapublisher/fme-auto
AUTOMATION
DATA FME MAPublisherGeospatial PDF Maps
FME AUTO
Data Sourced from the LINZ Data Service http://data.linz.govt.nzand licensed by LINZ for re-use under the Creative Commons Attribution 3.0 New Zealand licence.
Avenza MAPublisher FME Auto
Thanks to:Marc Graham
Avenza
Spreadsheet operations in FME.
- Statistics- Transpose- Pivot/crosstab
Note to Stephanie - simple graphics here: a summation symbol, a rotation symbol (Transpose) and a pivot symbol
Examples at: FMEpedia.com
Does everyone use Excel?
Excel Templates:
● Automate Data Updates● Utilize Powerful Excel Tools:
○ Pivot Tables○ Charts
Precipitation: British Columbia 1940-2012
Integrating demographics data, areas-of-interest, geocoding to generate comprehensive reports
Tetrad SiteWise plug-in
Thanks to:Sig IsaacTetrad
Tetrad SiteWise plug-in for FME
Market analysis, site evaluation and reporting:● Fast data retrieval of demographic data● Demographic data from the industry’s leading providers● Drivetime analysis● Detailed reports:
○ Excel or PDF
Simple HTML ReportsData Validation Automation on FME Server
FMEpedia:Upload & Validate
Report on the results
FME & Tableau @ UMass-Amherst
Tableau helps people see and understand data.
...but you have to load the data...
Student population distributionRoom Capacity vs. Class Enrolment
Alexander Stepanov GIS Architect
A&F Administrative SystemsUniversity of Massachusetts Amherst
FME & TableauTeaching / Instruction / Operations happen in Buildings …
How we can approach reporting on building use?
Combine location data with building data information
Default Tableau map
UMass-Amherst GIS map
FME & Tableau
Building Footprints in Tableau.
FME can import building footprints as an id, point sequence, lat, long
Now it’s ready to be connected with data tables and to run analytics
FME & TableauFME used to convert Building Footprints to centroids.
Tableau visualization: Student distribution at 10am on Thursday.Room Capacity vs. Class Enrolment
Merging Data - WC Finder
Brian PontMark StoakesSafe Software Inc.