zenful maps with sqlkampro.org/2012_conf_presentations/2c/opengis_basanta.pdfsteve krug don't...
TRANSCRIPT
![Page 1: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/1.jpg)
Zenful Maps with SQLMatthew Basanta
Paul Vidal
![Page 2: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/2.jpg)
Get out your smartphonehttp://goo.gl/LvNQL
Just go to the website, don't do anything yet
Introductions
● Matthew Basanta● Paul Vidal
![Page 3: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/3.jpg)
Overview● Designing for Simplicity● ArcGIS for Server● Alternative GIS servers● Intro to the SQL spatial standards● A Few Examples
![Page 4: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/4.jpg)
Frustrations● GIS is data● A map is part of the answer but it is not the
answer● Maps are charts. Charts are simply ways of
displaying data. Maps are just one of those ways.
● We need to step out of our boxes and focus on results
![Page 5: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/5.jpg)
Solutions● Better, Simpler Design● Re-focus Products on Users● User Interface and Experience That
Functions as People Really Use Them● More Accessible Infrastructure
![Page 6: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/6.jpg)
Simplehttp://twitter.com/http://pintrest.com/http://craigslist.com/http://wikipedia.org/http://www.messagesforjapan.com/messages/map/
![Page 7: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/7.jpg)
Datahttp://www.digitalpodge.co.uk/2009/http://www.nytimes.com/interactive/2009/03/10/us/20090310-immigration-explorer.html
![Page 8: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/8.jpg)
TermsUsabilityUser ExperienceChoice Architects
![Page 9: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/9.jpg)
TemptationWe must have more..● One more button● One more layer● "It would be perfect if.."
Data Collection● More data isn't necessarily better
![Page 10: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/10.jpg)
Evolution
IMS Sites WebADF Flex JavaScript(Widgets)
![Page 11: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/11.jpg)
SimplicitySteve Krug
Don't Make Me Think
![Page 12: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/12.jpg)
SimplicityBarry Schwartz
The Paradox of Choice
![Page 13: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/13.jpg)
SimplicityCass Sunstein and Richard Thaler
Nudge
*
![Page 14: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/14.jpg)
SimplicityGerald Edelman
Wider than the Sky
![Page 15: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/15.jpg)
FamiliarFamiliar Design is Smart Design● Imitation is Good for Everyone
○ Also known as, it's ok to steal.. a little bit.
![Page 16: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/16.jpg)
ConceptsSimpleIntuitiveLogicalPracticalFocusedCall to ActionProvides FeedbackForgiving
![Page 17: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/17.jpg)
Take Home's1. Focus on Purpose
a. Navigationb. Spatial Relationshipsc. Points of Interest
2. Drop the Legend3. Show Temporal Data (when possible)
![Page 18: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/18.jpg)
HowWeb Application's Goals and Purpose● This should drive everything
Barriers to Production● Cost● Effort● Time
![Page 19: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/19.jpg)
ArcGIS for Server● PROs
○ Highly abstracted○ Ubiquitous○ Easy to use for basic
application○ Powerful○ Interface with
ArcGIS for desktop○ Paid support
● CONs○ Resource intensive○ Expensive○ Difficult to
customize○ Slow○ Use restricted○ Must use with
ArcGIS products
![Page 20: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/20.jpg)
Alternatives● Database server
○ Microsoft SQL Server (Free -- $$$$)■ Simple
○ PostgreSQL with PostGIS (Free)■ Very Powerful■ Complex
○ MySQL Spatial (Free)■ Simple■ Low featured (data collection/display only)
○ Many others
![Page 21: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/21.jpg)
So what can we do?● Actions
○ Intersect○ Union○ Difference○ Buffer○ Distance○ Count○ Measure○ Envelope
● Shapes○ Point○ LineString○ Polygon○ MultiPoint○ MultiLineString○ MultiPolygon○ GeometryCollection
![Page 22: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/22.jpg)
How can we do it?● Requires a little more thinking● Not as abstracted
○ Stored as binary○ Manipulated as text
● All the tools are there○ Just takes a little more thought
● May take more than one function
![Page 23: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/23.jpg)
Well known textPOINT(-83.39 38.19)
LINESTRING(-88.63 37.23, -82.41 37.34, -82.18 37.65)
POLYGON((-84.64 38.59, -84.09 38.99, -84.12 39.36, -83.41 38.91, -84.64 38.59))
MULTIPOINT((-88.63 37.23)(-82.41 37.34))
MULTILINESTRING((-88.63 37.23, -82.41 37.34), (-82.18 37.65, -83.41 38.91))
MULTIPOLYGON((-84.64 38.59, -84.09 38.99, -84.12 39.36, -83.41 38.91, -84.64 38.59))
![Page 24: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/24.jpg)
Identify example● Create temporary point at selected lat/long● Measure distance from point to features● If distance equals zero, that's the one!
CREATE PROCEDURE [dbo].[identify] (@lat float,@lng float
)ASBEGIN
DECLARE @g GEOGRAPHY;SET @g = geography::STGeomFromText('POINT(' + @lng + ' ' + @lat + ')', 4326);
SELECT * FROM geotestWHERE [dbo].[geotest].[geo].STDistance(@g) = 0;
END
![Page 25: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/25.jpg)
SQL is not scaryDefinition querySelect by attributes Both use SQL
![Page 26: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/26.jpg)
What does it look like?
![Page 27: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/27.jpg)
Examples● Microsoft SQL Server 2010 Express (free)
○ Open source alternative -- PostgreSQL/PostGIS● Google Maps Javascript API
○ Open source alternative -- Open Street Maps● Microsoft IIS/.NET (server)
○ Open source alternative -- Apache/PHP
![Page 28: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/28.jpg)
Data display/IdentificationKentucky Counties
![Page 29: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/29.jpg)
Draw shapes
![Page 30: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/30.jpg)
View in ArcMapWho didn't follow directions?
![Page 31: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/31.jpg)
Let's go to this websitehttp://goo.gl/LvNQL
● Click or tap the screen to add points
● Add two or three points around Kentucky
![Page 32: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/32.jpg)
View our crowdsourced data
![Page 33: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/33.jpg)
A working example
![Page 34: Zenful Maps with SQLkampro.org/2012_conf_presentations/2C/OpenGIS_Basanta.pdfSteve Krug Don't Make Me Think. Simplicity Barry Schwartz The Paradox of Choice. Simplicity Cass Sunstein](https://reader034.vdocuments.us/reader034/viewer/2022052103/603d571422a344523d44ff09/html5/thumbnails/34.jpg)
Wrapping up● We hope this has created interest in
alternatives for web based mapping applications
● Any Questions?