buck appgeo
DESCRIPTION
TRANSCRIPT
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 1
GeCo In the Rockies
GIS/Non-GIS Data Interoperability
Business
Data
Other
Spatial
Data
GIS Data
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 2
Data400 Fredrick Law Olmsted Projects
12094, Elmira School (9/4), [Elmira?], NY00458, Woods, L. G., [Unknown], 00606, Town of West Chester, [unknown], 12057, Lee, C. (5/7), [Unknown], 03073, Birmingham Realty Company, Birmingham, AL03075, Fulenwider, A. L., Birmingham, AL03089, Rushton Park, Birmingham, AL03322, Huntington College, Montgomery, AL03540, Birmingham, AL City Plan, Birmingham, AL03541, Birmingham City Plan, Birmingham, AL03542, Avondale Park, Birmingham, AL03543, Underwood Park, Birmingham, AL03544, Ensley Park, Birmingham, AL03545, Woodrow Wilson Park, Birmingham, AL03546, Green Springs Park, Birmingham, AL03567, Willcox, James S., Montgomery, AL03569, Ball, Fred S., Montgomery, AL03571, Alabama Polytechnic Institute, Auburn, AL03572, Wilson, Albert F., Montgomery, AL03573, Jones, Henry C., Montgomery, AL03574, Thorington, Jack, Montgomery, AL03575, Montgomery Country Club, Montgomery, AL03576, Baldwin, A. M., Montgomery, AL03913, Corey Land Company, Corey, AL05530, Mobile Alabama Parks, Mobile, AL05906, Barton, E. M. et al., Walker County, AL06109, Yates, Mrs. E.A., Shade Mountain, AL06877, Birmingham Chamber of Commerce, Birmingham, AL07093, Alabama State Normal School, Troy, AL07509, Erving, Hampton, Mobile, AL07837, Montgomery Subdivision, Montgomery, AL07857, Montgomery High School, Montgomery, AL07960, Alabama State Capitol, Montgomery, AL07961, Montgomery State Normal School, Montgomery, AL07962, Troy State Normal School, Troy, AL07963, Jacksonville State Normal School, Jacksonville, AL07964, Livingston Normal School, Livingston, AL07965, Florence AL State Normal School, Florence, AL07966, Alabama Agricultural and Mechanical (A & M) College, Huntsville, AL07967, University of Alabama, Tuscaloosa, AL07968, Montevallo Women's College, Montevallo, AL07969, Auburn Polytechnic Institute, Auburn, AL07970, Alabama (general), , AL07971, Capitol Heights Jr. High School, Montgomery, AL07972, Court Street Widening, Montgomery, AL07973, Montgomery County Board of Educ. Admin. Bldg., Montgomery, AL09272, Jordan, Ann Game Preserve Inc., Kellyton, AL09387, Oak Park, Montgomery, AL09613, Dauphin Island, Mobile County, AL09724, Howard College, Birmingham, AL09755, Birmingham Medical Center, Birmingham, AL09786, Pittman, J. D., Birmingham, AL09800, Vestavia Gardens, Birmingham, AL09804, Judson College, Marion, AL09805, Florence Alabama High School, Florence, AL09811, Vestavia Hills Golf & Riding Club, Birmingham, AL09815, Decatur High School, Decatur, AL09816, Decatur Elementary School, Decatur, AL09862, Alabama Educational Foundation, Indian Springs, AL09950, Vestavia Hills Shopping Center, Birmingham, AL10032, Lyman Ward Military Academy, Camp Hill, AL10120, Mobile Baptist College, Mobile, AL03752, Doupe, J. Lonsdale, Calgary, AB03952, Bridgeland, Calgary, AB04055, Lonnquist-Mason Company, Letheridge, AB05092, Mount Royal, South, Calgary, AB05259, Calgary Golf and Country Club, Calgary, AB05525, Calgary Alberta City Planning Commission, Calgary, AB08078, Grand Canyon, Grand Canyon, AZ08246, Marshall, F. E., Phoenix, AZ01244, Hot Springs Reservation, Hot Springs, AR05460, Little Rock Arkansas Parkways Association, Little Rock, AR07448, University of Arkansas, Booneville, AR03276, Uplands, The, Victoria, BC03419, Dunsmeir, Lord, Victoria, BC05381, Marpole, C. M., Vancouver, BC05815, Rogers, B. T., Victoria, BC05902, University of British Columbia, Vancouver, BC09273, British Pacific Properties Ltd., Vancouver, BC09348, British Pacific Properties Ltd., Vancouver, BC09400, Taylor, Austin C., West Vancouver, BC09401, Taylor, A. J. T., West Vancouver, BC09402, Taylor, A. J. T. - Kew Beach House, Vancouver, BC09403, Taylor, A. J. T. - Glen Eagles, West Vancouver, BC09461, Aubeneu, Henry, Vancouver, BC09661, British Pacific Development Company, West Vancouver, BC09666, Taylor, A. J. T., West Vancouver, BC00291, Golden Gate Park, San Francisco, CA01032, Stanford, Leland Jr. University, Stanford, CA01140, Sharon Mausoleum, San Francisco, CA01328, Town of Alessandro, San Bernardino, CA01809, Save the Redwoods League, Berkeley, CA02046, Goodhue, Bertram, Santa Barbara, CA02047, University of California, Berkeley, CA02394, Santa Catalina, Santa Catalina, CA02899, Calaveras Big Trees, , CA
03370, San Diego, San Diego, CA03683, F. L. Olmsted - Gill House, San Francisco, CA03684, Olmsted, F. L. House, Palo Alto, CA04051, Balboa Park, San Diego, CA05219, Beverly-Arnaz Land Company, Los Angeles, CA05260, Lovdal Manor, Sacramento, CA05280, Sacramento Park System, Sacramento, CA05351, Sharon, Frederick W., Menlo Park, CA05352, Marston, G. W., San Diego, CA05354, Dominguez Estate, Los Angeles, CA05370, Los Angeles Park System, Los Angeles, CA05371, Agricultural Fair Park, Los Angeles, CA05372, City Plan Commission, Los Angeles, CA05373, Los Angeles Traffic, Los Angeles, CA05374, East Side Organization, Los Angeles, CA05380, Panama-Pacific NY State Bldg. Exposition, San Francisco, CA05390, Riverside Park System, Riverside, CA05391, Fairmount Park, Riverside, CA05410, Redlands California Park System, Redlands, CA05435, Union High School, Ventura County, CA05487, Cravens, John S., Pasadena, CA05488, Thacher School, Nordhoff, CA05489, Ventura County Building, Ventura, CA05491, Los Angeles Investment Company, Los Angeles, CA05658, Westgate Park Land Company, Berkeley, CA05830, Cowles, W. H., Santa Barbara, CA05883, McDuffie, Duncan, Berkeley, CA05886, Merritt, Dr. Ema, San Francisco, CA05887, Arlington Heights, Santa Barbara, CA05945, Lake Shore Highlands, Oakland, CA05949, Spring Valley Water Company, San Francisco, CA05950, Palos Verdes, Palos Verdes, CA05994, Harris, N. W., Pasadena, CA05995, Study for Sloat Boulevard and Corbett Avenue Junction, Berkeley, CA06087, Tompkins, P. T., Berkeley, CA06090, Berkeley City Planning Committee, Berkeley, CA06091, Berkeley City Planning Commission, Berkeley, CA06092, Berkeley Civic Art Commission, Berkeley, CA06093, Berkeley Metropolitan Park System, Oakland, CA06147, Moore, W. M. Subdivision, San Diego, CA06157, Bath Square, Berkeley Springs, CA06212, McDuffie, Sophie B., Berkeley, CA06257, Burlingame City California Garden City, Burlingame, CA06338, San Francisco Exposition Site Subdivision, San Francisco, CA06356, Pittsburg, Pittsburg, CA06467, San Jose City Plan, San Jose, CA06485, Monterey Boulevard, San Francisco, CA06600, Oakland Municipal Building, Oakland, CA06878, National Cemetery Association, Los Angeles, CA07048, Mead, William, Hollywood, CA07085, McDuffie, Duncan, Carmel, CA08000, Edwin Jones subdivision near Los Angeles, Los Angeles, CA08001, Bear Lake Subdivision, Los Angeles, CA08002, Pacific Palisades, Los Angeles, CA08003, McCloud River Club, McCloud, CA08004, Bluff Park, Long Beach, CA08005, Patterson, R.L. (Subdivision), San Carlos, CA08006, Recreation Park, Monrovia, CA08008, Santa Cruz Park, Long Beach, CA08009, Bluff Park, Long Beach, CA08010, City of Long Beach, Long Beach, CA08011, Long Beach Hospital, Long Beach, CA08020, Jacks, Lee Miss, Monterey, CA08021, Lowe, Mrs. Edward Jr., Berkeley, CA08022, Monterey Peninsula Regional Plan, Monterey, CA08023, Vanderlip, Palos Verdes, CA08024, Robbins, Mrs., San Pedro, CA08025, Yeoman's Association, , CA08026, Swift, Henry Jr., Berkeley, CA08027, Webster, E. E., Redondo Beach, CA08028, Santa Barbara, City of, Santa Barbara, CA08029, Santa Barbara High School, Santa Barbara, CA08030, Santa Barbara City Hall Garden, Santa Barbara, CA08031, Santa Barbara Plaza, Santa Barbara, CA08034, Santa Barbara, Santa Barbara, CA08035, Mills College, Oakland, CA08036, Benmar Hills, Burbank, CA08038, Hayter, R., Hollywood, CA08039, Warren, T. W., Pasadena, CA08041, Schipkowsky, Rudolph, Los Angeles, CA08042, Campbell, Ella, Los Angeles, CA08044, Cameron, A.E., Palos Verdes, CA08045, Alta San Raphael Co., Pasadena, CA08046, Olmsted, F. L., Palos Verdes, CA08049, Jacks, Margaret, Monterey, CA08050, Galbreath, George W., San Bernardino, CA08051, Malaga Cove School, Palos Verdes, CA08056, Nelson, William P., Montecito, CA08058, Barrett,W. R., Palos Verdes, CA08060, Benedict, H. E., Palos Verdes, CA08061, Harden, E.W., Palos Verdes, CA08062, Gard, E.W., Palos Verdes, CA08063, Portugese Beach Club, Palos Verdes, CA08064, Monterey General Parks, Monterey, CA08066, Alta San Raphael Co., Pasadena, CA08069, Bowles, P. E., Oakland, CA
08070, Schreiber, Mrs. Oliver, Palos Verdes, CA08071, Bloch, J. L. Dr., Palos Verdes, CA08072, California State Park Commission, Del Norte, CA08072, Columbia, California, Columbia, CA08076, Burbank Civic Center, Burbank, CA08079, McDuffie, William, Montecito, CA08080, West Rancho Aguajito, West Rancho Aguajito, CA08081, Parkford, E. A., Santa Barbara, CA08082, Bryant, Mrs. Ernest Albert, Long Beach, CA08083, Point Lobos, Point Lobos, CA08084, Clark, Walter G., Los Angeles, CA08085, Bixby, Frederick Mrs., Long Beach, CA08086, Buchanan, James E., Redondo Beach, CA08087, Redondo Union High School, Redondo Beach, CA08088, Woods, Paul M., Palos Verdes, CA08089, Haggarty, J.J., Palos Verdes, CA08093, Vista Valmonte Hotel, Palm Springs, CA08094, Palm Springs Golf Course, Palm Springs, CA08095, Jacks, Margaret, Monterey, CA08096, Sutherland, W. M., Palos Verdes, CA08097, Meadow Club of Tamalpais, Tamalpais, CA08098, Dibblee, Benjamin Harrison, Ross, CA08099, Yosemite National Park, , CA08100, Los Angeles County - General, Los Angeles, CA08101, Hollywood - Palos Verdes Boulevard, Hollywood, CA08102, Angeles-Mesa Parkway, Los Angeles, CA08103, Los Angeles City and County Parkway, Los Angeles, CA08200, Humboldt Redwood State Park, , CA08201, Hobart Estate, Lake Tahoe, CA08202, Leimert Park, Los Angeles, CA08203, Hassler, Robert H. Polo Field, Serena, CA08204, Yosemite National Park, , CA08205, Nutting, E.M., Hollywood, CA08206, Riverside Municipal Auditorium and Soldiers Memorial, Riverside, CA08209, Hollins, Marion Miss, Santa Cruz, CA08210, Lane, Mr. and Mrs. Fulton, Palos Verdes, CA08211, Beverly Hills - Roxbury Drive Playground, Beverly Hills, CA08212, La Cienega Playground, Beverly Hills, CA08216, Morro Bay Vista, Morro Bay, CA08219, Stein, Dr. Otto J., Palos Verdes, CA08220, Smith, Dr. Ralph, Claremont, CA08222, O'Melveny, Harry W., Beverly Hills, CA08223, Hart, Mrs. Alden L., Palos Verdes, CA08225, Schwedtman, F. Charles, Palos Verdes, CA08226, Raleigh, W.W., Palos Verdes, CA08229, Levinson, E.D., Palos Verdes, CA08232, Pioneer Park, Burbank, CA08233, Allison, D. C., Bel Air, CA08235, Burbank United Airport, Burbank, CA08236, Buena Vista Avenue Improvement, Riverside, CA08237, Palos Verdes Library, Palos Verdes, CA08238, Miraleste School, Palos Verdes, CA08239, Rancho Santa Ana Botanic Gardens, Long Beach, CA08240, Redondo Parks, Redondo, CA08241, Redondo Beach, City of, (Oil Leases), Redondo Beach, CA08244, Edwards, L. T., Los Cerritos, CA08248, Chamberlain, Selah Mrs., San Mateo, CA08249, Livermore, Norman B., Ross, CA08250, Mount Tamalpais Boys School, San Rafael, CA08251, Samuels, Mrs. Homer, Palos Verdes, CA08252, Phillips, J. Norman, Palos Verdes, CA08253, Jergins, A. T., Long Beach, CA08254, California Club, Los Angeles, CA08255, Midwick Country Club, Montebello Park, CA08256, Sub-station for Edison Co., Palos Verdes, CA08257, Pismo Beach Sales Co., Pismo Beach, CA08258, Hammond, Mrs. L. C., San Mateo, CA08259, Rancho Los Alamitos Mesa, Long Beach, CA08260, Malibu Park, Los Angeles, CA08262, O'Melveny, H. W., Los Angeles, CA08263, University of California, , CA08264, Orrick, W. H., Pebble Beach, CA08265, McNulty, J. A., Los Angeles, CA08266, International House, Berkeley, CA08267, Kings River Canyon, Sequoia National Forest, CA08268, Hillside Gardens, Los Angeles, CA08269, Southern California Homes Gardens, Southgate, CA08270, Good Hope Clinic Garden, Los Angeles, CA08271, Monterey Terrace Homes Gardens, Monterey, CA08272, Bryant, Susannah Bixby, San Marino, CA08273, Sherman Oaks Subdivision, San Fernando Valley, CA08274, Imperial Western Tract, Los Angeles, CA08275, Cabrillo Exposition, Los Angeles, CA08300, Del Norte Coast Park, Del Norte County, CA08301, Santa Monica State Park, Santa Monica, CA08302, Hiouchi Park, Del Norte County, CA08303, Prairie Creek Redwood Park, Humboldt County, CA08304, Humboldt Lagoons, Humboldt County, CA08305, Hickey Grove, Mendocino County, CA08306, Dimmick Park, Mendocino County, CA08307, Van Damme Beach Park, Mendocino County, CA08308, Fort Ross Park, Sonoma County, CA08309, Mt. Tamalpais Park, Marin County, CA08310, McArthur - Burney Falls Park, Shasta County, CA08311, General Bidwell Park, Butte County, CA08312, Sonoma Mission Park, Sonoma County, CA
08313, Mt. Diablo Park, Contra Costa County, CA08314, Marshall's Monument, El Dorado County, CA08315, Donner Monument, Donner County, CA08316, Lake Tahoe Fish Hatchery Park, Placer County, CA08317, Lake Tahoe Bliss Memorial and Rubicon Point Park, Placer County, CA08318, Calaveras Big Tree Region, Calaveras County, CA08319, California Redwood Park, Santa Cruz County, CA08320, Sunset-Seacliffe Beaches Park, Santa Cruz County, CA08321, Custom House - Old Theater, Monterey County, CA08322, Morro Strand, San Luis Obispo County, CA08323, Tule Elk Reserve, Kern County, CA08324, Carpinteria Beach, Santa Barbara County, CA08325, Pio Pico Mansion, Whittier, CA08326, Manhattan Beach Park, Los Angeles County, CA08327, Doheny Beach Park, Orange County, CA08328, San Clemente Beach Park, Orange County, CA08329, Mt. San Jacinto Park, Riverside County, CA08330, San Pasqual Battlefield, San Diego County, CA08331, Mission Bay Park, San Diego County, CA08332, Silver Strand Park, San Diego County, CA08333, Huntington Beach & Newport Bay, , CA08334, Mill Creek Redwoods, , CA08335, Master Plan for Redwoods - Save the Redwood League, , CA08336, Calaveras Big Trees and Surroundings, Tuolumne County, CA09478, Park Hills, Berkeley, CA09685, Mountain View Cemetery, Oakland, CA10609, Keyes, James, Laguna Beach, CA12011, San Francisco Parks (1/1), San Francisco, CA12014, California, College (1/4), Berkeley, CA12097, Howard, George P. (9/7), San Francisco, CA12107, Mills, Darius Ogden (10/7), San Francisco, CA12118, Mountain View Cemetery (11/8), Oakland, CA12301, Yosemite Valley, Mariposa (30/1), , CA00127, Estes Park, Estes Park, CO01091, Lake Wauconda, Perry Park, CO01206, Denver and Lookout Mountain Resort, Denver, CO03300, Boulder, Colorado Improvement Association, Boulder, CO03301, Seventeenth Street Subway, Boulder, CO03302, Boulder Creek and Vicinity, Boulder Creek, CO03303, Newlands Park, Boulder, CO03304, Lovers Hill, Boulder, CO03362, Palmer, Gen. William J., Colorado Springs, CO03429, Colorado, University of, Boulder, CO03473, McHarg, J. A., Boulder, CO03474, Colorado State University, Colorado Springs, CO03475, Gilbert, Dr. O. M., Boulder, CO03480, Denver Colorado Civic Center, Denver, CO03607, Depew, Mrs. Grace Goodyear, Colorado Springs, CO05052, Colorado Springs City Plan, Colorado Springs, CO05580, Denver Parks, Denver, CO05581, Denver Civic Center, Denver, CO05582, Mountain Park, Denver, CO05583, Williams Street Parkway, Denver, CO05584, Seventh Avenue Boulevard, Denver, CO05585, Marion Street Parkway, Denver, CO05586, City Park, Denver, CO05587, Berkley Park, Denver, CO05588, Washington Park, Denver, CO05589, Rocky Mountain National Park, Denver, CO05590, Curtis Park, Denver, CO05591, Cheeseman Park, Denver, CO05592, Platte River Park, Denver, CO05593, Barnum Park, Denver, CO05594, Block 8, Denver, CO05595, Thirty-eighth Street Playground, Denver, CO05596, Sloan & Coopers Lake, Denver, CO05597, Welton Street Playground, Denver, CO05599, Clayton, George W. College, Denver, CO05600, Denver City Plan, Denver, CO05860, Colorado Springs, Colorado Springs, CO05876, Lookout Mountain Property, Denver, CO06451, Broadmoor Hotel, Colorado Springs, CO06453, Penrose, Spencer, Colorado Springs, CO07160, Burns, A. Martin, Colorado Springs, CO07268, Stewart, Philip B., Colorado Springs, CO08007, Cusack, [Thomas?], Cascade, CO08052, Penrose, Spencer, Colorado Springs, CO08053, Broadmoor Polo Club, Colorado Springs, CO08054, Broadmoor Heights, Colorado Springs, CO09626, Colorado River Basin Recreational Survey, , CO00023, DeZeng, Richard L., Middletown, CT00024, Maynard, Effingham Mrs., Ridgefield, CT00035, Wadsworth, C. S., Middletown, CT00041, Olmsted, A.H, Hartford, CT00050, Kingsbury, T. J. Jr., New Haven, CT00196, Cheney, Anne W., South Manchester, CT00235, Westminster School, Simsbury, CT00283, Hubbard Park, Meriden, CT00301, Curtis, George M., Meriden, CT00314, Curtis Memorial Library, Meriden, CT00332, Wood, C. B. Mrs., Simsbury, CT00350, Dodge, A. M., Simsbury, CT00417, Guthrie, Charles S., New London, CT00600, New Britain - Proposed Park, New Britain, CT00601, Trinity College, Hartford, CT00613, State House, Hartford, CT
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 3
Context4000 Fredrick Law Olmsted Projects
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 4
Data &Context:A Story
http://www.olmstedonline.org/
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 5
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 6
Interoperability VS. Interoperability
• Open GIS Consortium (OGC) Mission:
“To advance the development and use of international standards and supporting services that promote geospatial interoperability. To accomplish this mission, OGC serves as the global forum for the collaboration of geospatial data /
solution providers and users.”
– Through standards, such as WMS, WFS
• Today’s topic is about data interoperability
– How to share data across systems/standards
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 7
Business Processes Need Business Data
data: factual information (as measurements or statistics)used as a basis for reasoning, discussion, or calculation
noun plural but singular or plural in construction, often attributive
-- Merriam-Webster
http://premium.wpmudev.org/blog/author/joefoley/
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 8
We have a data rich environment• Spatial Data
– CADD data– GIS data– Survey data
• Tabular Data– Descriptive attribute data– Business data– Resource-related data
• Documents– Equipment specifications– Design documents– Utility tie cards
• Photos and Videos– Street views– Building facades– Walkthroughs
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 9
Types of non-referenced data
• Business Data in Relational Databases
– Accessible via direct database connections – Read-only access is sufficient, safe, and secure– Near-real-time or real-time possible without duplication– Linked by matching ID numbers
• Commercial data in proprietary systems
– Requires API expertise
• Computer –Aided Design and Drafting (CADD)
– Project focused; may require aggregation– Older CADD and pre-CADD drawings only as scans– A valuable source for asset/inventory data
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 1 0
Identify Context
• Goals define the context
• Holistic visualization enables analysis & decision making
• Everything has a place
Charles Minard, 1869Steven Redmond qvdesign.wordpress.com
Vladimir Volkov PetrovichThe Patriotic War of 1812, Part 1
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 1 1
Develop Geospatial Concept
• Geoenable non-spatial applications
– “Map it” buttons
– Integrated/non-integrated mapping viewer
Bring GIS to the data
• Geoenable non-spatial data
– Use shared ID numbers & tabular Joins
– Create bounding boxes/point features
– Geocoding
Bring the data to GIS
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 1 2
Bring GIS to the Data
Click
Minnesota DOT Real Estate application is the data maintenance and search tool
Tabular• Manage legacy
o Applicationso Processes
• Perform updates• ID #s• Workflow
• Conduct searches
Map It!
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 1 3
Bring GIS to the Data
Geoenabled• Thematic maps• Multiple sources• Documents/sketches
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 1 4
Bring Data to GIS
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 1 5
Map Viewers Display Integrated Data
Business Data
Business Data
Business Data
Business Data
GeospatialData
GeospatialData
GeospatialData
GeospatialData
Data processinghappens
behind the scenes
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 1 6
Data Commonalities
• Ownership [It’s my data]
– Legal governance– Responsible for content– Has ability to delegate
• Authoritative source
– Reliable, authentic, impartial– Recognized by experts within the field
• Stewardship
– Data manager– Issue resolution across sources– Quality control– Publisher
• Lifecycle
– Think wheel, not river
Data Differences
CADD Objects
• Multiple levels in one file
• Levels differentiate objects
• Cells & tags
• Annotation is unique object
• Points, lines, AND polygons
• Paper space objects
• Drawing with lines
GIS Features
• Separate feature classes
• Single feature per class
• Attributes
• Label is feature data
• Points, lines, OR polygons
• Each feature geolocated
• Closed Polygons
• Integrated Topology
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 1 8
Scans Overwhelm
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 1 9
CADD Data Requires Processing
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 2 0
Retain Source InfoDrawing Area Attributes
PK OBJECTID
pin
source_file
source_path
source_type
source_date
method
quality
projection
offset
unit_of_resolution
units_master
units_sub
accuracy
resolution
plan_scale
SHAPE
SHAPE_LENGTH
SHAPE_AREA
vtrans_row.gdb
features
areas
project
drawing
bridge_point
bridge_line
control_point
control_line
drainage_point
drainage_line
landscape_point
landscape_line
mapping_point
mapping_line
other_point
other_line
pavement_point
pavement_line
roadway_point
roadway_line
Feature Attributes
PK OBJECTID
SHAPE
pin
object_modified_date
source_file
source_path
source_level_number
source_level_description
source_level_name
level_number
level_name
level_description
annotation_label
cell_name
tag_name
tag_description
tag_x
style
color
weight
SHAPE_LENGTH (lines only)
Drawing Areas
Feature Class
Attributes
Common Features
Feature Class
Attributes
Project Area Attributes
PK OBJECTID
pin
project_completion_date
Project Areas
Feature Class
Attributes
Feature Level Metadata
Create Backdrop Features
Level to Feature Mapping & Filtering
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 2 1
What is the Business Objective?
Project Areas
Plats
VTrans ROW Map Viewer
ROWGeospatial
Data
VTrans
DGNDGN
DGNDGN
DGN DGN
CADD to GIS
Conversion
VermontBase Map
Data
PPMS
For SelectedProject:
PPMS &Artemis Attributes
Project #,Project Description,
Project History,
CADD DGN filename & location,
Etc.
Scan
Scan
Artemis
ArtemisProject View
ArtemisProject View
PPMS UIPPMS UI
OnBase
Muni Parcel Data
Linear Referencing
Road Centerlines
Town Boundaries
Ortho Imagery
Utility
ACQ.
OnBaseDoc Mgmt
OnBaseDoc Mgmt
Sell-off
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 2 2
• You have to understand the data
– English, Metric– Scans, tiffs– Survey points or ROW lines– Quality & accuracy
• Data mgmt. best practices provide structure – On-going, scalable, repeatable, documented
• Workflows– The operations and methods performed on data
• Lifecycle– The stages of the data as it flows
Interoperability is not a one time thing
It’s really about the Process
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 2 3
Scalability
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 2 4
Develop Repeatable Models
• Interop Extension• FME models• Python scripts• Bentley Map
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 2 5
Conceptualize Process
FME
ROWGeospatial
Data
Process Geometry
Georeference Images
Convert Objects to Features
Create Features from
Image
MicroStationDGN file
Scan
Features
Georef.Scan
Archive JP2
Georeferenced
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 2 6
Establish Workflow
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 2 7
Data Workflow
• Operations
– Creation, Extract, Transform, Load
– Validate, Quality Control
– Maintenance Updates
– End-of-live Archiving
– Correction points
– Pilot projects
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 2 8
Understand Lifecycle
Collect
Maintain
Publish
ValidateTransform
Catalog
Archive
Retire
Analyze
Analyze
Integrate
Refresh
Produce
Consume
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 2 9
Remember the Goal
• Every situation is unique
• Answer this: What is the desired outcome/goal?
• Repeatable & scalable solutions involve defining best practices
It’s usually about the Data
It’s also about the Technology
It’s ALWAYS about the Process
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 3 0
Manage Change
• Source data probably not ready for GIS as-is
• Process changes may be necessary & disruptive
• New consumers increase visibility & scrutiny
• New use cases highlight new requirements
– Format: lines versus polygons
– Outdated status: proposed becomes as-built
– Project versus enterprise
• Authoritative source versus stewardship
© 2 0 1 4 A p p l i e d G e o g r a p h i c s , I n c . S l i d e 3 1
Accomplish the Goal