Learning ArcGIS Geodatabases
Table of Contents
Learning ArcGIS Geodatabases
Credits
About the Author
About the Reviewers
www.PacktPub.com
Support files, eBooks, discount offers, and more
Why subscribe?
Free access for Packt account holders
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Errata
Piracy
Questions
1. Authoring Geodatabases
Bestaurants, the best restaurants in Belize
Designing the geodatabase schema
Creating the geodatabase
The spatial reference
Creating the feature classes
Editing the geodatabase in ArcMap
Summary
2. Working with Geodatabase Datasets
Working with feature classes
Adding new attributes
Modifying the properties of the attributes
Domains
Subtypes
Working with object tables and relations
Working with annotations
Importing other datasets
Importing shape files
Importing the CAD files
Importing coverage classes
Summary
3. Modeling Geodatabases
The entity relationship diagram for Bestaurants
The flaws in the current geodatabase
The proposed geodatabase model
Implementing the proposed model
Authoring the geodatabase
Creating geodatabase datasets
Assigning domains to the feature class
Adding subtypes to the new feature class
Enabling attachments in the feature class
Testing the new geodatabase in ArcMap
Summary
4. Optimizing Geodatabases
Geodatabase indexing
Attribute indexing
Adding an attribute index
Spatial indexing
Adding a spatial index
Using indexes effectively
Geodatabase compression
Compressing a file geodatabase
Using compression effectively
Compacting
Compacting a file geodatabase
Using compacting effectively
Summary
5. Programming Geodatabases
Using Python scripting
Creating a geodatabase
Creating a feature class
Adding and deleting fields
Copying features
Backing up the Bestaurants_Web geodatabase
A list of arcpy commands
Using the model builder
Creating a model
Creating a feature class
Running the model
Summary
6. Enterprise Geodatabases
The benefits of the enterprise geodatabase
Setting up a Microsoft SQL Server Express geodatabase
System requirements
Installing SQL Server Express
Configuring SQL Server Express
Enabling TCP remote pipe
Enabling the firewall's database port
Connecting to the database
Connecting to the database from a remote machine
Creating an enterprise geodatabase
Working with an enterprise geodatabase
Adding users
Creating a connection to the enterprise geodatabase
Migrating a file geodatabase to an enterprise geodatabase
Assigning privileges
Summary
Index
Learning ArcGIS Geodatabases
Copyright © 2014 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.
First published: June 2014
Production reference: 1180614
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham B3 2PB, UK.
ISBN 978-1-78398-864-8
www.packtpub.com
Author
Hussein Nasser
Reviewers
Hani M. Basheer
Frank Donnelly
Venkatesh Merwade
Commissioning Editor
Kunal Parikh
Acquisition Editor
Subho Gupta
Content Development Editor
Akshay Nair
Technical Editor
Ankita Thakur
Copy Editors
Mradula Hegde
Dipti Kapadia
Stuti Srivastava
Project Coordinator
Sageer Parkar
Proofreader
Paul Hindle
Indexer
Rekha Nair
Graphics
Yuvraj Mannari
Production Coordinator
Shantanu Zagade
Cover Work
Shantanu Zagade
Hussein Nasser is an Esri award-winning senior GIS solution architect at Electricity and Water Authority, Bahrain. He was the first author to write about the ArcGIS for Server technology after its complete revamp in Version 10.1. In 2007, Hussein won the annual ArcGIS for Server Code Challenge conducted at the Esri Developer Summit in Palm Springs, California, for using the AJAX techn...