Transcript GIS Database Issues

Database Issues
Barry Biediger
Utah Automated
Geographic Reference
Center (AGRC)
October 28, 2004
Overview
• Some GIS basics
• How the database can be accessed
• Submitting data
What is GIS?
GIS = Geographic Information System
• System for
management,
analysis,
modeling, and
visualization of
geospatial data.
• Integrates diverse
data and models
in a map-based
context.
facilities
transport
topography
geology
wells
Location X
Wetlands
Geology
Utilities
Streets
Population
Property Boundaries
Pipelines
Streams
Counties
Point Sources
GIS Facilitates
Data Integration
- Location can be used as the
central organizing principle for
data from multiple databases
-Questions can be asked of the
data in 2 ways:
1)What is at location X?
2)At what locations does some
condition exist?
Slope or Aspect
Aerial Imagery
What is AT or NEAR
Location X?
How a GIS Database Works
Items in a traditional database are linked
to a geographic representation of their real
world location in the form of:
- points
- lines
- polygons
Vector Data
- grid cells
Raster Data
Accessing the Database
agrc.utah.gov
servers
File based
download
Shapefiles/
GDBs
Oracle/SDE
Direct database
connection with
ArcGIS
Internet Map
Server
Spatial Data
Tabular
Data
Oracle client,
Access, Excel
What is AT or NEAR
Location X?
ArcIMS Prototype Site
Some basic
exploratory
analysis tools are
included on the
ArcIMS site.
The user needs only
a moderately fast
internet connection.
http://utstdp-ims.state.ut.us/website/co2wc
Connecting Directly to the SDE Database
Those users with
ArcGIS 9.0 can
connect directly to the
database and work
with the data layers
directly(read only)
Contact Barry
Biediger
[email protected]
for the connection
parameters and
details.
File Download
If there is enough
need, an ftp site can
be set up where users
can download the GIS
data layers in
Geodatabase or
Shapefile formats.
Alternatively, AGRC
can send data layers
to users as they
request them.
Submitting data to the database
• Any common GIS format can be submitted
•
•
•
•
Shapefiles
Geodatabases
Coverages
Any other format readable by ArcGIS
• Flat files (e.g. Excel spreadsheets) with
coordinates for point features.
Metadata (Data Describing Data)
• Metadata is crucial for the credibility and
understandability of the data.
• At a minimum, these items need to be provided to
AGRC when submitting data:
–
–
–
–
Description
Source
Scale
Definition of attributes
• Projection information is absolutely necessary.
Questions, Comments
• AGRC Contacts:
Dennis Goreham, 801-538-3163
[email protected]
Barry Biediger, 801-537-9078
[email protected]
• AGRC website:
– http://agrc.utah.gov