rob brook -- gathering gis.ppt · gathering gis what you need to know to play the game. robert...

Gathering GISWhat You Need to Know to Play the Game.

Robert BrookPipeline Industry Manager

Environmental Systems Research Institute

GeoGathering 2008GeoGathering 2008

Environmental Systems Research Institute

• The majority of GIS implementations do not realize their full potential because they ignore four basic

Why am I doing this presentation?

rules:• Rule 1 – Know why you are choosing GIS• Rule 2 – Know how you want to store your

data and whyR l 3 H l ith hi bl l


• Rule 3 – Have a plan….with achievable goals• Rule 4 – Treat it as a “real” project…involve IT.

Rule 1 – Know why you are choosing GIS


How do we Organize Data?

• Alphabetically?

• By Key Term?

• By Date?

• By Address?


• By Address?

• Into Categories?

Three Primary Mechanism

1. Alphanumerically2. Time3. Geographically


Three Primary Mechanism - One

1. Alphanumerically• Name - Bob Smith - http://smith.mn/bobsmith.html• Code - Project Number – B74Mentone-9• Type - 17,500 species of orchids• Categories• Keyword


Keyword• Etc.

Three Primary Mechanism - Two2. Time• History – December 7th 1941 (pearl harbor)

36 36 ‐‐BCBC‐‐ Earliest known Mayan inscription, Earliest known Mayan inscription, StelaStela 2 at 2 at ChiapaChiapa de de CorzoCorzo

43 43 ‐‐BCBC‐‐ Marcus Marcus TulliusTullius Cicero, Roman writer, gets his head & right hand chopped off by Mark Cicero, Roman writer, gets his head & right hand chopped off by Mark Antony's soldiersAntony's soldiers

185 Emperor Lo185 Emperor Lo‐‐Yang, Yang, ChinaChina sees supernova (MSH15sees supernova (MSH15‐‐52?)52?)

1944 General 1944 General RadescuRadescu forms Romanian governmentforms Romanian government1946 Fire at 1946 Fire at WinecoffWinecoff Hotel in Atlanta, kills 119Hotel in Atlanta, kills 1191949 Chang Kai1949 Chang Kai--shek flees to Taiwanshek flees to Taiwan1952 KKTV 1952 KKTV TV channelTV channel 11 in Colorado 11 in Colorado SpgsSpgs--Pueblo, CO (CBS) 1st broadcastPueblo, CO (CBS) 1st broadcast1953 Israel's PM Ben1953 Israel's PM Ben GureonGureon retires and WCCB TV channel 18 in Charlotte NC (IND/ABC) beginsretires and WCCB TV channel 18 in Charlotte NC (IND/ABC) begins broadcastingbroadcastingy (p )

• Date – December 7th283 St 283 St EutychianEutychian ends his reign as Catholic Popeends his reign as Catholic Pope

1787 Delaware becomes 1st state to ratify constitution1787 Delaware becomes 1st state to ratify constitution

1808 James Madison elected US pres/George Clinton vice1808 James Madison elected US pres/George Clinton vice‐‐prespres

1836 Martin Van Buren elected 8th president1836 Martin Van Buren elected 8th president

1842 NY Philharmonic's 1st 1842 NY Philharmonic's 1st concertconcert

1862 Battle of Hartsville, TN and Battle of Prairie Grove, AR1862 Battle of Hartsville, TN and Battle of Prairie Grove, AR

1868 Jesse James gang robs bank in Gallatin Missouri, kills 11868 Jesse James gang robs bank in Gallatin Missouri, kills 1

1872 HMS Challenger sets sail on 3«1872 HMS Challenger sets sail on 3«‐‐year world oceanographic year world oceanographic cruisecruise

1875 Natives Sons of the West organized1875 Natives Sons of the West organized

1876 NY 1876 NY MutualsMutuals & & PhilaPhila A's expelled from NL for not completing A's expelled from NL for not completing skedsked

1885 49th Congress (18851885 49th Congress (1885‐‐87) convenes87) convenes

1891 52nd Congress (1st to appropriate $1 billion) holds 1st session1891 52nd Congress (1st to appropriate $1 billion) holds 1st session

1896 A 1896 A CharloisCharlois discovers asteroid #423 discovers asteroid #423 DiotimaDiotima

1909 Leo Baekeland, Yonkers, NY, patents 1st thermosetting plastic1909 Leo Baekeland, Yonkers, NY, patents 1st thermosetting plastic

1912 Bust of Queen 1912 Bust of Queen NeferteteNefertete found in Elfound in El‐‐AmarnaAmarna, , EgyptEgypt and J H Metcalf discovers asteroid #737 and J H Metcalf discovers asteroid #737 ArequipaArequipa

1916 David Lloyd George replaces resigning H 1916 David Lloyd George replaces resigning H HH Asquith as British PMAsquith as British PM

1917 US becomes 13th country to declare war on 1917 US becomes 13th country to declare war on AustriaAustria during World War Iduring World War I

1920 USPD1920 USPD‐‐KPD parties merge into KPD parties merge into VereinigteVereinigte Communist Party of GermanyCommunist Party of Germany

1921 KWG1921 KWG AM in Stockton CA begins radio transmissionsAM in Stockton CA begins radio transmissions

1953 Israel s PM Ben1953 Israel s PM Ben--GureonGureon retires and WCCB TV channel 18 in Charlotte, NC (IND/ABC) begins retires and WCCB TV channel 18 in Charlotte, NC (IND/ABC) begins broadcastingbroadcasting1954 Japanese government of 1954 Japanese government of JoshidaJoshida, resigns and KCTS TV channel 9 in Seattle, WA (PBS) begins , resigns and KCTS TV channel 9 in Seattle, WA (PBS) begins broadcastingbroadcasting1956 Helen O'Connell joins Today Show panel1956 Helen O'Connell joins Today Show panel1958 1958 R¢muloR¢mulo B‚tancourtB‚tancourt elected pres of Venezuelaelected pres of Venezuela1960 Ivory Coast claims independence from France1960 Ivory Coast claims independence from France1964 1964 George HarrisonGeorge Harrison changes his company's name from changes his company's name from MornyorkMornyork to to HarrisongsHarrisongs1965 Pope Paul VI & Orthodox Patriarch 1965 Pope Paul VI & Orthodox Patriarch AthenagorasAthenagoras I simultaneously lift mutual excommunications that I simultaneously lift mutual excommunications that led to split of 2 churches in 1054led to split of 2 churches in 10541968 M Dodd returns a library books his Great grandfather took out in 1923 and Orbiting Astronomical 1968 M Dodd returns a library books his Great grandfather took out in 1923 and Orbiting Astronomical Observatory 2 launched into Earth orbit and Richard Dodd returns a library book his great Observatory 2 launched into Earth orbit and Richard Dodd returns a library book his great grandadgrandad took out in took out in 182318231971 Wings release their 1st 1971 Wings release their 1st albumalbum "Wild Life""Wild Life"1972 Apollo 17, last of Apollo Moon series, launched and 1972 Apollo 17, last of Apollo Moon series, launched and PhillipinePhillipine 1st lady Imelda Marcos stabbed & wounded 1st lady Imelda Marcos stabbed & wounded by an assailantby an assailant1973 Wings release "Band on the Run"1973 Wings release "Band on the Run"1975 10th Islander shut1975 10th Islander shut--out opponentout opponent--Glenn Glenn ReschResch 33--0 0 vsvs SabresSabres and P Wild discovers asteroid #2843and P Wild discovers asteroid #28431976 UN Security Council 1976 UN Security Council endorsesendorses Kurt Waldheim, secKurt Waldheim, sec--gen for 2nd 5 yr termgen for 2nd 5 yr term1977 Islander Billy Smith's 10th shut1977 Islander Billy Smith's 10th shut--out opponentout opponent--Black Hawks 4Black Hawks 4--001978 Islander's Mike 1978 Islander's Mike Bossy'sBossy's 1st career hat trick 1st career hat trick 1980 Purple Mountain Observatory discovers asteroid #34941980 Purple Mountain Observatory discovers asteroid #34941981 1981 SpainSpain becomes a member of the NATObecomes a member of the NATO1982 T Seki discovers asteroid #2961 1982 T Seki discovers asteroid #2961 KatsurahamaKatsurahama


1921 KWG1921 KWG‐‐AM in Stockton CA begins radio transmissionsAM in Stockton CA begins radio transmissions

1924 German election (SPD wins)1924 German election (SPD wins)

1926 K 1926 K ReinmuthReinmuth discovers asteroid #1078 discovers asteroid #1078 MenthaMentha

1929 Leo 1929 Leo DiegelDiegel wins PGA golf tournamentwins PGA golf tournament

1932 1st gyro1932 1st gyro‐‐stabilized vessel to cross Atlantic arrives in NYstabilized vessel to cross Atlantic arrives in NY

1934 Wiley Post discovers jet stream1934 Wiley Post discovers jet stream

1935 Winnipeg Blue Bombers become 1st western team to win Grey 1935 Winnipeg Blue Bombers become 1st western team to win Grey CupCup1937 Dutch Minister 1937 Dutch Minister RommeRomme proclaims married women are forbidden to work and Russian chess proclaims married women are forbidden to work and Russian chess player player AljechinAljechin recaptures world title from Max recaptures world title from Max EuweEuwe

1938 W9XZY broadcasts facsimile of St Louis Post1938 W9XZY broadcasts facsimile of St Louis Post‐‐Dispatch by radioDispatch by radio

1941 German siege of 1941 German siege of TobroekTobroek after 8 months ends and Japanese attack after 8 months ends and Japanese attack Pearl HarborPearl Harbor (a date that will (a date that will live in infamy) and live in infamy) and NachtNacht & & NebelNebel ErlassErlass, resistance fighter sent to concentration camps 1st , resistance fighter sent to concentration camps 1st Japanese submarine sunk by a US ship (USS Ward)Japanese submarine sunk by a US ship (USS Ward)

1983 2 jets collided at Madrid Airport killing 931983 2 jets collided at Madrid Airport killing 931985 Atlantis returns to 1985 Atlantis returns to Kennedy Space CenterKennedy Space Center via Kelly AFB and Bo Jackson of Auburn wins Heisman Trophyvia Kelly AFB and Bo Jackson of Auburn wins Heisman Trophy1986 Pres Jean1986 Pres Jean--Claude Duvalier flees Claude Duvalier flees Ha‹tiHa‹ti1987 43 die in Pacific Southwest 1987 43 die in Pacific Southwest AirlineAirline crash in crash in CalifCalif (man shot pilots) and Gorbachev arrives in US for a (man shot pilots) and Gorbachev arrives in US for a summit meetingsummit meeting1988 25,000 killed by an earthquake in Armenian SSR (6.9) and Armenian SSR rocked by earthquake, 8 on 1988 25,000 killed by an earthquake in Armenian SSR (6.9) and Armenian SSR rocked by earthquake, 8 on Richter scale (55,000 die) and Gorbachev announces 10% unilateral Soviet troop reductions at UN and Mikhail Richter scale (55,000 die) and Gorbachev announces 10% unilateral Soviet troop reductions at UN and Mikhail Gorbachev cheered by Wall St crowds upon arrival in NYCGorbachev cheered by Wall St crowds upon arrival in NYCand NY Islanders fire Simpson, and NY Islanders fire Simpson, ArbourArbour new coachnew coach1990 Iraqi 1990 Iraqi parlimentparliment endorses Saddam's decision to free hostages and Ted Turner & endorses Saddam's decision to free hostages and Ted Turner & Jane FondaJane Fonda announce announce their engagementtheir engagement1992 Galileo spacecraft passes North Pole of Moon (Peary Crater)1992 Galileo spacecraft passes North Pole of Moon (Peary Crater)1995 Galileo spacecraft arrives on Jupiter1995 Galileo spacecraft arrives on Jupiter19461946 "Fireproof" "Fireproof" WinecoffWinecoff hotelhotel turns into oven, baking 119 in fire.turns into oven, baking 119 in fire.

Three Primary Mechanism2. Time• History – December 7th 1941 (pearl harbor)y (p )• Date – December 7th

• Transactions • Houses – Canada 476,063 a year (1,305 a day)

• 33 million people

• Global Population 6 8 billion


• Global Population 6.8 billion • 102,000,000 houses in a year• 279,500 a day

Three Primary Mechanism3. Geography• Address• Lat, Long or projected• Map position


GIS Fuses them together

++


Rule 2 – Know how you want to store your data and why


Data ModelsOption 1 – Geometric Network• Advantages – GIS centric, simple, providesAdvantages GIS centric, simple, provides

connectivity, allows for tracing, strong highly tested internationally enabled utility applications

• Disadvantages – model/template doesn’t i t d ’t i t t ll ith i ti


exist, doesn’t integrate well with existing regulatory and integrity solutions.

Data ModelsOption 2 – PODS• Advantages – standards driven, simple g p

pipeline hierarchy, very detailed “complete” model, strong organization, numerous vendors.

• Disadvantages – relational model that requires proprietary spatialization not GIS


requires proprietary spatialization, not GIS centric or optimized , implemented in its entirety.

Data ModelsOption 3 – APDM• Advantages – GIS centric, template withAdvantages GIS centric, template with

best practices, ESRI optimized, full market service, direct mobile solution, multiple vendors, SOA ready, and highly mobile.

• Disadvantages –template assumes high l l f d t di l ti hi h


level of understanding, relationship heavy, and massive flexibility

Data ModelsOption 4 – PODS Spatial• Advantages – Middle ground, hasAdvantages Middle ground, has

advantages of both PODS and APDM, geodatabase with standard information.

• Disadvantages – Not ready yet, not robustly tested need time to evolve limited


tested, need time to evolve, limited flexibility…extend not change

Real Solution• Pick a Model that matches your

organizations needs (object/relational, enterprise etc)

• Validate your need for a network or linear reference.

• If needed, replicate dataM k th K LR d t t ( t ti i ) i id t ith th


• Make the Key LR dataset (station series) coincident with the appropriate pipelines in the geometric network. The geometry is coincident. Reduce the data redundancy carry only the necessary information.

Rule 3 – Have a PLAN and define your GOALS


A man and his wife, now in their sixties, are A man and his wife, now in their sixties, are celebrating their fortieth anniversary. On celebrating their fortieth anniversary. On the special day a fairy came to them and the special day a fairy came to them and said that because they had been so good, said that because they had been so good, each of them could have one wish. The wife each of them could have one wish. The wife wished for a cruise around the world later in wished for a cruise around the world later in the year with her husband….whoosh, the year with her husband….whoosh, immediately she the necessary tickets in immediately she the necessary tickets in her hand. The husband wished for a female her hand. The husband wished for a female


companion 30 years younger….whoosh, he companion 30 years younger….whoosh, he turned 90.turned 90.

• Familiar with Dr. Roger Tomlinson?

Creating a Plan


Thinking About GIS Thinking About GIS -- Geographic Geographic Information System Planning for ManagersInformation System Planning for Managers

Creating a Plan• Step 1 GIS – the whole picture

No GIS can be a success without the right No GIS can be a success without the right ggpeople being involved. A realpeople being involved. A real--world GIS is world GIS is actually a complex system of interrelated actually a complex system of interrelated parts, and at the center of the system is a parts, and at the center of the system is a smart person who understands the whole.smart person who understands the whole.


UsersUsers

Risk Profiling,Risk Profiling,InfrastructureInfrastructure

ProtectionProtection

Publish Compliance,Publish Compliance,Common OperatingCommon Operating

PicturePicture

Inspection,Inspection,Field Maintenance,Field Maintenance,

Leak DetectionLeak DetectionRoutingRouting

Public RelationsPublic RelationsMarketingMarketing

Enterprise Service Bus

CorpCorpServicesServices

ExternalExternalServicesServices

TrackingTrackingServicesServices GISGIS AssetAsset

ServicesServices

Spatial Asset System

ImageryImageryServicesServices

Real Real Time Time

ServicesServices


Web Services• Weather• Imagery• Demographic• Land Parcels• Environmental Areas

Pipeline CorporateServices• CRM• Financial• Supply Chain• Work Management• Legacy AM/FM• Fleet

Spatial Asset System• Designing/As-builts• Integrity Management• Engineering• Asset Management• Risk Assessment

Real Time Services• SCADA• Sensors• AMI

Creating a Plan• Step 1 GIS – the whole picture• Step 2 Consider the strategic purposeStep 2 Consider the strategic purpose

#$%!@*& SYSTEM!#$%!@*& SYSTEM!

Strategic Purpose is the guiding light. The Strategic Purpose is the guiding light. The system that gets implemented must be system that gets implemented must be

aligned with the purpose of the aligned with the purpose of the organization as a whole.organization as a whole.


Creating a Plan• Step 1 GIS – the whole picture• Step 2 Consider the strategic purposeStep 2 Consider the strategic purpose• Step 3 Plan for the planning

Since the GIS planning process will take Since the GIS planning process will take time and resources, you need to get time and resources, you need to get approval and commitment early on.approval and commitment early on.


Creating a Plan• Step 1 GIS – the whole picture• Step 2 Consider the strategic purposeStep 2 Consider the strategic purpose• Step 3 Plan for the planning• Step 4 Conduct a technology seminar

Think of the technology seminar as a “town Think of the technology seminar as a “town hall” meeting between the GIS planning hall” meeting between the GIS planning


team and the potential users of the GIS.team and the potential users of the GIS.

Creating a Plan• Step 1 GIS – the whole picture• Step 2 Consider the strategic purposeStep 2 Consider the strategic purpose• Step 3 Plan for the planning• Step 4 Conduct a technology seminar• Step 5 Describe the information products

Know what you want to get out of it.Know what you want to get out of it.


y gy g

Creating a Plan• Step 6 Define the scope and goals

Scoping the system means defining the Scoping the system means defining the Scop g t e syste ea s de g t eScop g t e syste ea s de g t eactual data, hardware, software, and timingactual data, hardware, software, and timing


Creating a Plan• Step 6 Define the scope and goals• Step 7 Create a data designStep 7 Create a data design

The data landscape has changed The data landscape has changed dramatically with the advent of the Internet dramatically with the advent of the Internet

and the proliferation of commercial and the proliferation of commercial datasets. Developing a systematic datasets. Developing a systematic

procedure for safely navigating this procedure for safely navigating this


landscape is critical.landscape is critical.

Creating a Plan• Step 6 Define the scope and goals• Step 7 Create a data designStep 7 Create a data design• Step 8 Choose a data model

The new generation of objectThe new generation of object--oriented data oriented data models is ushering in a host of new GIS models is ushering in a host of new GIS

capabilities and should be considered for capabilities and should be considered for all new implementations Yet the relationalall new implementations Yet the relational


all new implementations. Yet the relational all new implementations. Yet the relational model is still relevant, and the savvy GIS model is still relevant, and the savvy GIS

manager will be conversant in both.manager will be conversant in both.

Creating a Plan• Step 6 Define the scope and goals• Step 7 Create a data designStep 7 Create a data design• Step 8 Choose a data model• Step 9 Determine the system requirements

Getting the system requirements right at Getting the system requirements right at the onset is what separates the adults from the onset is what separates the adults from

th hild i f l GIS l ith hild i f l GIS l i


the children in successful GIS planning.the children in successful GIS planning.

Creating a Plan• Step 6 Define the scope and goals• Step 7 Create a data designStep 7 Create a data design• Step 8 Choose a data model• Step 9 Determine the system requirements• Step 10 Consider cost-benefit, migration,

and risk analysis


yThe most critical aspect of doing a realistic costThe most critical aspect of doing a realistic cost--

benefit analysis is the commitment to include all the benefit analysis is the commitment to include all the costs that will be involved. Too often managers costs that will be involved. Too often managers gloss over the real costs only to regret it later.gloss over the real costs only to regret it later.

Creating a Plan• Step 6 Define the scope and goals• Step 7 Create a data designStep 7 Create a data design• Step 8 Choose a data model• Step 9 Determine the system requirements• Step 10 Consider cost-benefit, migration,

and risk analysis


y• Step 11 Plan the implementation

The implementation plan should illuminate The implementation plan should illuminate the road to success.the road to success.

Rule 4 – Treat it as a “real” project…involve IT.


• It is not a GIS implementation, it is an Enterprise IT project.• You require well defined work flows and business

A t t d d f ti i till d f ti

It’s a real project?

processes. Automated dysfunction is still dysfunction.• Achieve your user objectives• It is not a technical exercise. While it is technologically

complicated it will be more difficult to ensure that the needs are clear, politics are negotiated, and stakeholders are engaged.


Questions?Questions?


rob brook -- gathering gis.ppt · gathering gis what you need to know to play the game. robert...

Documents