An Overview of Spatial Data and GIS for the DBA

Learn insights into managing spatial data in your database
3.6 (10 ratings)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
104 students enrolled
Instructed by Gil Scholl Development / Databases
$19
$25
24% off
Take This Course
  • Lectures 11
  • Length 1 hour
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2014 English

Course Description

Managing a spatial database, or as some vendors call it, a geodatabase, requires some insight into spatial data, the collection of the data, different datatypes used to store the data, and the ultimate display of the data. This course is meant to give you more common ground with the GIS Professional, to do the best job of managing spatial data as a DBA, and see some differences in how spatial data is managed. The philosophy that is presented is that if you know something about the data, you will do a much better job of managing it as a DBA. So, in the introduction, a few examples are given about how spatial data is created.

The DBA will have a better understanding why they should have some knowledge of coordinate systems. Some questions are provided to help you pick a coordinate system type to use, or understand why a certain coordinate system is currently being used. Some examples are provided for what different types of coordinate systems are used for in the real world.

Participants are provided enough information to understand the basics of different types of geometries and datatypes that are used to store the spatial data. An introduction is given into the strategy of spatial data sharing in organizations.

A section on operational considerations provides several overview lectures of subjects to think about.

First, a lecture provides insight into how spatial data might be managed by one or all of three scenarios that have been experienced. A high level view of versioned spatial data and editing is then provided to show how ArcSDE operates. Since this class is an overview, only one editing Vendor situation is presented at a high level. The participant is provided some performance considerations that need to be thought about for spatial data operations. Each Vendor’s scenarios might be somewhat different, but these are ones that the instructor has experienced.

The participant is given a few high level examples of integrated GIS systems, to broaden the thinking of where GIS might fit into your overall operation.

A lecture was designed to give participants an introduction into adding spatial capability to their database. Several questions are provided to help the DBA hone in on the requirements for the spatial data operations. Each database Vendor has their own specifics for spatial data, but this specific lecture will give the general path to making this happen.

Participants learn the steps to create a spatially enabled table with a geometry column.

  • Picking the coordinate system
  • Defining the spatial metadata
  • Inserting the metadata
  • Creating the spatial index
  • Inserting the data including the spatial data
  • Running the stats

What are the requirements?

  • DBA experience

What am I going to get from this course?

  • Understand where spatial data comes from
  • Learn about coordinate systems used with spatial data
  • Understand how spatial data is being stored
  • Learn about the different geometry types in spatial data
  • Learn 3 methods to approach managing spatial data
  • Understand adding spatial data capability to a table

What is the target audience?

  • DBA's who are currently or will be managing spatial data in their databases
  • Database Administrators, or Developers with that knowledge
  • This is not a beginning database administrator course

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Overview Questions
05:38

High level view of spatial data, how it is collected, what is GIS, and how spatial data is different from tabular data

Section 2: Coordinate Systems
06:48

An intro to coordinate systems, their purpose, types, and uses, and needs of your Client

Coord1
1 question
03:42

An introduction to Projected vs: Geographic(geodetic) coordinate systems and their applications in real world use

projvsgeod
1 question
03:07

An introduction to the Open Geospatial Consortium (OGC) and the data sharing goal

OGC1
1 question
Section 3: Geometry Types, Datatypes
04:36

Provides basics of spatial data geometry types and some considerations.

05:57

A high level overview of spatial datatypes by database Vendor, and a decision process to chose the spatial datatype to use

spdatatype1
1 question
Section 4: Operational Considerations
04:26

Learn the 3 scenarios you will encounter as you work with managing spatial data, SQL tools, Gray area, and GIS tools

3scenarios
1 question
3scenarios2
1 question
3scenario3
1 question
03:39

Better understand the high level view of editing in an ArcSDE versioned environment. You will also get a sense of what is happening behind the scenes with system tables and Add and Delete tables.

06:03

Understand where Hardware/Software, database parameter settings, spatial indexes, statistics, and query tuning fit into performance considerations.

Perform1
1 question
Perform2
1 question
03:35

Broaden your view from a spatial database to a full integrated GIS

04:46

Basic steps to enable spatial field in your database table

AddCap1
1 question
AddCap2
1 question

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Gil Scholl, Sr Database Administrator, Tyler Technologies, Inc.

Gil Scholl currently is a Sr Database Administrator at Tyler Technologies, Inc.. He is a Certified Oracle Professional (OCP) with a focus on the DBA role and especially spatial DBA role. His career has covered several industries including Geotechnical and Environmental Engineering, Energy industry as a reservoir engineer, and as a DBA now with spatial data emphasis. Maps have been a part of his life ever since getting his pilot's license in high school. He currently works across several industries and organizations as a consultant, including military, federal, local and state governments, energy industry, and aviation. Gil was the primary DBA in a “top 10 US airport" GIS system doing design, implementation, and operation management.

His philosophy is that “if you know something about the data", you will do a much better job of managing it as a DBA. He came through his growth as a DBA prior to adding the spatial emphasis. He sees that there is a great need for bridging the gap between the GIS Professional and the DBA to make the most out of the spatial data that organizations have. That is why he is presenting this course.

Ready to start learning?
Take This Course