Reader small image

You're reading from  Learning ArcGIS Geodatabases

Product typeBook
Published inJun 2014
Publisher
ISBN-139781783988648
Edition1st Edition
Right arrow
Author (1)
Hussein Nasser
Hussein Nasser
author image
Hussein Nasser

Hussein Nasser is an Esri award-winning senior GIS solution architect working in the GIS field since 2006. He is the author of three books in the ArcGIS technology: Administering ArcGIS for Server, Learning ArcGIS Geodatabases, and Building Web Applications with ArcGIS, all by Packt Publishing. In 2007, he won the first place at the annual ArcGIS Server Code Challenge, conducted at the Esri Developer Summit in Palm Springs, California. In 2014, he started the IGeometry YouTube channel, where he periodically publishes educational GIS videos.
Read more about Hussein Nasser

Right arrow

Working with object tables and relations


A question was raised during the Bestaurants workshop review: what if I want to write multiple reviews for a given restaurant or diner? Does the geodatabase support that? The answer is no. We have a single review field for each feature. We can add another field called REVIEW2, for instance, but it is infeasible as we will end up with a very rigid geodatabase design. It is not an elegant solution to the multiple reviews problem. It seems that we can't work out a solution for this with the skills we have acquired so far while working with feature classes. We need a new tool that can help us tackle this. Here is where object tables come into the picture.

Note

An object table is a table in the geodatabase that stores only the records without geometry.

Tables are extremely useful, and yes, we can create them in the geodatabase too! However, how can we use tables to solve the multiple reviews problem? For each restaurant, diner, and so on, there might be multiple...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Learning ArcGIS Geodatabases
Published in: Jun 2014Publisher: ISBN-13: 9781783988648

Author (1)

author image
Hussein Nasser

Hussein Nasser is an Esri award-winning senior GIS solution architect working in the GIS field since 2006. He is the author of three books in the ArcGIS technology: Administering ArcGIS for Server, Learning ArcGIS Geodatabases, and Building Web Applications with ArcGIS, all by Packt Publishing. In 2007, he won the first place at the annual ArcGIS Server Code Challenge, conducted at the Esri Developer Summit in Palm Springs, California. In 2014, he started the IGeometry YouTube channel, where he periodically publishes educational GIS videos.
Read more about Hussein Nasser