Transcript Document

November 13th, 2012 2:30PM-4:00Pm
GIS IN GOVERNMENT AND
FINANCE
This ain’t your daddy’s map anymore
Expense
2500000
2000000
1500000
Expense
1000000
500000
0
From the Visual Teaching Alliance

FACT: Approximately 65% of the population are visual learners.

FACT: The brain processes visual information 60,000 X’s faster than text.

FACT: 90% of information that comes to the brain is visual.

FACT: 40% of all nerve fibers connected to the brain are linked to the retina.

FACT: Visual aids in the classroom improve learning by up to 400%.

FACT: Students who are twice exceptional (2e) are often visual learners.
Picture worth a thousand words…
Examples of Visuals

Verizon – “coverage” map
 “Which
is more” campaign
When does Visual not work?



When you use images not common to your audience
When the data being presented has too many
elements at one time
If doing a comparison and the difference is not
visually discernible
GIS - What is it?


Acronym – Geographic Information System (Graphical)
As Defined by ESRI - A geographic information system (GIS)
integrates hardware, software, and data for capturing,
managing, analyzing, and displaying all forms of
geographically referenced information. GIS allows us to
view, understand, question, interpret, and visualize data in
many ways that reveal relationships, patterns, and trends in
the form of maps, globes, reports, and charts. A GIS helps
you answer questions and solve problems by looking at your
data in a way that is quickly understood and easily shared.
GIS technology can be integrated into any enterprise
information system framework.
The Human Brain - Relational Database
What can GIS Do?




Help analyze large amounts of data
Present data in an easy to understand format
Marry non-contiguous or heterogeneous data
Create “visual impact”
Where can we use GIS?

Fixed Assets
 Identification

and quantification
Budgeting
 Revenue
forecasting/projecting
 Expense forecasting/projecting

Project Descriptions
 Special
Assessments
 CRA’s

Disaster Recovery
Special Notes of interest

GIS can graph also like Excel

GIS can route like a GPS for your car

GIS can produce schedules like Excel which can be
used for mail merge and other uses
GIS Terms for “Us”
Them





Layer
Data Point
Polygon
Join Set
Attribute
Us





Schedule
Address or PCN
Area or Shape
Lookup table or
Crosswalk
Format or Information
Fixed Assets
Remember GASB 34?
Add layers to the map with the data
you want in them…
Revenue Forecasting
And what if Amendment 4 passes?
Expense Forecasting
Project Descriptions
A little challenge…
Can I do GIS?
What do you know?

ERP?
Microsoft Excel?
Microsoft Word?
Microsoft PowerPoint?
Microsoft Access?
Bing Maps?

GIS?





Data “Joins” – Linking by common field
Joins – links to your data


Some joins are only temporary or on the “fly”
Some joins are persistent and used over and over
again
Questions?