Database Reference
In-Depth Information
Designing the geodatabase schema
Before we start creating the geodatabase, we need to design a template that includes the
tables, fields, and data types for the Bestaurants project. This template is called the
geodatabase schema.
Note
A schema is a metadata template that describes the tables, fields, and field types in a partic-
ular database.
So, let's design the logical schema for the Bestaurants project. We will start with a very
simple design where we create the basic atom dataset in the geodatabase, the feature class.
Note
The feature class is one of the basic objects in a geodatabase. This object class is a table
with a
shape
attribute, which could be a point, line, or a polygon.
According to the case study, we need to create a geodatabase that accommodates diners,
cafes, restaurants, bars, and lounges. So, we can create each one of them in a separate fea-
ture class, and then we need to give appropriate fields for each feature class. Take a few
moments to answer these questions: what feature classes will you include in the geodata-
base? What attributes will you use for each class? What are the data types for these attrib-
utes? Take a look at the following table:
Feature class
Field
Field type
NAME
Text
WEBSITE Text
Diners
RATING Short Integer
SHAPE
Geometry
