An Introduction to GIS for Developers - Part 2: GIS Data
An Introduction to GIS for developers Part 2: GIS Data Canserina Kurnia & Tom Shippee
Agenda •
GIS data types
•
Leveraging attributes
•
Getting locations from tabular data
•
Power of the Geodatabase
ArcGIS a complete platform “discover, use, make & share”
Content Mgmt ArcGIS Online/Portal
Apps and applications
Back office GIS Services infrastructure ArcGIS Server
GIS Content & Analysis ArcGIS Desktop
Content and services
Getting the information out… Provides Geospatial Capabilities Across the Entire Organization
•
Mapping
•
Analysis
•
Visualization
Managers Knowledge Workers
Citizens Deployed Users
Enterprise Integration
Professional GIS
. . . A Framework For Sharing, and Collaboration
Getting the information in… Breaks down barriers to communication & collaboration
. . . Anyone can gain access to the information they need
Exploring GIS as a Platform
Data Fundamentals
Functionality
Sharing
GIS Data types Vectors & rasters
Commonly used data in ArcGIS Data type
Description
Address
• Descriptive locations • Street address, zip code, county, state
CAD
• Computer Aided Design • Engineering and design drawings
Elevation
• Height or depth in relation to reference surface such as mean sea level • Many supported raster and vector formats
Geodatabase
• Native format for ArcGIS • Storage of features, tables, and behaviors in a relational database
Imagery
• Aerial photos or satellite images • Many supported raster formats
CSV, GPX, GeoRSS
• Coordinate values stores in a file • streaming location as part of a Web feed
Shapefile
• Simple format for storing point, line, and area features
Temporal
• Time or date information for geographic locations
X,Y or X,Y,Z
• Coordinate values • May include elevation, or Z values
Managing GIS Data
What is a geodatabase? •
ArcGIS native data structure
Why use a geodatabase? Rules and relationships Datasets Data integrity
Scale users
Geodatabase
Advanced datasets
Scale storage
Geoprocessing and geocoding Integrate with other databases
Working with versioned data • Publish public version (DEFAULT)
Parks
• Next version of the data (QA)
Parks
Data versioning scenarios
•
Controlled data release
•
What if modeling & planning
•
Public
Analyst
(e.g., disaster management)
Public
Flood
Project staging
Farmland
Residential
Replication enables efficient data copies
Source
Multiuser geodatabase
Data Change Set
Target
Leveraging attributes Combining text & geometry
Spatial tables •
Records correspond to features
•
ObjectID and Shape fields
Nonspatial tables •
No record-feature correspondence
•
No Shape field
•
May have OID field
Table Join •
Symbolize countries based on UN data
Spatial table has no UN data
JOIN
A
Nonspatial table has UN data
Table Relates •
Support one-to-many and many-to-many relationships between records
Spatial table Nonspatial table
Getting locations from non-spatial data Geocoding addresses, zip codes, etc.
Adding x,y data •
May exist in non-spatial tables Address
Zip
latitude
longitude
1 Battery Park Plaza
10004
40.70317
-74.0145
2 Broadway
10004
40.70407
-74.0131
110 Pearl Street
10005
40.70447
-74.0094
55 Broad Street
10004
40.70512
-74.0114
GPS locations of Starbucks
…displayed as point layer
Geocoding •
•
Get locations from addresses Create point features
NAME
ADDRESS
J. Maloney
310 East Andreas Road
K. Hickman
105 Maple Street
E. Palmer
3109 Bell Square West
Location Analytics •
Esri Maps for -
IBM Cognos
-
Microsoft Office
-
Microsoft Sharepoint
-
MicroStrategy
-
Microsoft Dynamics CRM
-
SAP Business Objects
-
Salesforce (coming soon)
Geodata Behaviors Domains, relationships & topology
Attribute editing validation •
Data validation basics -
Data type
-
Default value
•
Domains control input values for a single field
•
Subtypes classification enables power editing
Topology and geometry edit validation •
Spatial relationship models
•
Topology rules control data integrity
San Francisco is contained by California I-80 connects San Francisco and New York New York is adjacent to the Atlantic Ocean
Q&A Thank you for attending… Online Survey: http://www.esri.com/events/devsummit/session-rater Canserina Kurnia ([email protected]) Thomas Shippee ([email protected])
Agenda •
GIS data types
•
Leveraging attributes
•
Getting locations from tabular data
•
Power of the Geodatabase
ArcGIS a complete platform “discover, use, make & share”
Content Mgmt ArcGIS Online/Portal
Apps and applications
Back office GIS Services infrastructure ArcGIS Server
GIS Content & Analysis ArcGIS Desktop
Content and services
Getting the information out… Provides Geospatial Capabilities Across the Entire Organization
•
Mapping
•
Analysis
•
Visualization
Managers Knowledge Workers
Citizens Deployed Users
Enterprise Integration
Professional GIS
. . . A Framework For Sharing, and Collaboration
Getting the information in… Breaks down barriers to communication & collaboration
. . . Anyone can gain access to the information they need
Exploring GIS as a Platform
Data Fundamentals
Functionality
Sharing
GIS Data types Vectors & rasters
Commonly used data in ArcGIS Data type
Description
Address
• Descriptive locations • Street address, zip code, county, state
CAD
• Computer Aided Design • Engineering and design drawings
Elevation
• Height or depth in relation to reference surface such as mean sea level • Many supported raster and vector formats
Geodatabase
• Native format for ArcGIS • Storage of features, tables, and behaviors in a relational database
Imagery
• Aerial photos or satellite images • Many supported raster formats
CSV, GPX, GeoRSS
• Coordinate values stores in a file • streaming location as part of a Web feed
Shapefile
• Simple format for storing point, line, and area features
Temporal
• Time or date information for geographic locations
X,Y or X,Y,Z
• Coordinate values • May include elevation, or Z values
Managing GIS Data
What is a geodatabase? •
ArcGIS native data structure
Why use a geodatabase? Rules and relationships Datasets Data integrity
Scale users
Geodatabase
Advanced datasets
Scale storage
Geoprocessing and geocoding Integrate with other databases
Working with versioned data • Publish public version (DEFAULT)
Parks
• Next version of the data (QA)
Parks
Data versioning scenarios
•
Controlled data release
•
What if modeling & planning
•
Public
Analyst
(e.g., disaster management)
Public
Flood
Project staging
Farmland
Residential
Replication enables efficient data copies
Source
Multiuser geodatabase
Data Change Set
Target
Leveraging attributes Combining text & geometry
Spatial tables •
Records correspond to features
•
ObjectID and Shape fields
Nonspatial tables •
No record-feature correspondence
•
No Shape field
•
May have OID field
Table Join •
Symbolize countries based on UN data
Spatial table has no UN data
JOIN
A
Nonspatial table has UN data
Table Relates •
Support one-to-many and many-to-many relationships between records
Spatial table Nonspatial table
Getting locations from non-spatial data Geocoding addresses, zip codes, etc.
Adding x,y data •
May exist in non-spatial tables Address
Zip
latitude
longitude
1 Battery Park Plaza
10004
40.70317
-74.0145
2 Broadway
10004
40.70407
-74.0131
110 Pearl Street
10005
40.70447
-74.0094
55 Broad Street
10004
40.70512
-74.0114
GPS locations of Starbucks
…displayed as point layer
Geocoding •
•
Get locations from addresses Create point features
NAME
ADDRESS
J. Maloney
310 East Andreas Road
K. Hickman
105 Maple Street
E. Palmer
3109 Bell Square West
Location Analytics •
Esri Maps for -
IBM Cognos
-
Microsoft Office
-
Microsoft Sharepoint
-
MicroStrategy
-
Microsoft Dynamics CRM
-
SAP Business Objects
-
Salesforce (coming soon)
Geodata Behaviors Domains, relationships & topology
Attribute editing validation •
Data validation basics -
Data type
-
Default value
•
Domains control input values for a single field
•
Subtypes classification enables power editing
Topology and geometry edit validation •
Spatial relationship models
•
Topology rules control data integrity
San Francisco is contained by California I-80 connects San Francisco and New York New York is adjacent to the Atlantic Ocean
Q&A Thank you for attending… Online Survey: http://www.esri.com/events/devsummit/session-rater Canserina Kurnia ([email protected]) Thomas Shippee ([email protected])
