Learning ArcGIS Geodatabases
5/5
()
About this ebook
This book is aimed at geospatial developers who want to work with ArcGIS geodatabases as well as manage them. Having knowledge of building a geodatabase from scratch isn't a must; Learning ArcGIS Geodatabases is ideal for those who want to use ArcGIS geodatabase for the first time, or for those who want to migrate from their existing legacy database to a geodatabase.
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 from Hussein Nasser
Building Web Applications with ArcGIS Rating: 5 out of 5 stars5/5ArcGIS By Example Rating: 1 out of 5 stars1/5Administering ArcGIS for Server Rating: 0 out of 5 stars0 ratings
Related to Learning ArcGIS Geodatabases
Related ebooks
Spatial Analytics with ArcGIS Rating: 0 out of 5 stars0 ratingsThe GIS 20: Essential Skills Rating: 4 out of 5 stars4/5Focus on Geodatabases in ArcGIS Pro Rating: 4 out of 5 stars4/5Making Spatial Decisions Using ArcGIS Pro: A Workbook Rating: 5 out of 5 stars5/5ArcPy and ArcGIS - Second Edition Rating: 5 out of 5 stars5/5Practical GIS Rating: 0 out of 5 stars0 ratingsAdvanced Python Scripting for ArcGIS Pro Rating: 4 out of 5 stars4/5Lining Up Data in ArcGIS: A Guide to Map Projections Rating: 4 out of 5 stars4/5GIS Tutorial for ArcGIS Pro 2.8 Rating: 5 out of 5 stars5/5Getting to Know ArcGIS Pro 2.8 Rating: 3 out of 5 stars3/5QGIS By Example Rating: 3 out of 5 stars3/5Developing Mobile Web ArcGIS Applications Rating: 0 out of 5 stars0 ratingsAn Introduction to Spatial Data Analysis: Remote Sensing and GIS with Open Source Software Rating: 0 out of 5 stars0 ratingsUnderstanding GIS: An ArcGIS® Pro Project Workbook Rating: 0 out of 5 stars0 ratingsMapbox Cookbook Rating: 0 out of 5 stars0 ratingsArcGIS Web Development Rating: 0 out of 5 stars0 ratingsMapping by Design: A Guide to ArcGIS Maps for Adobe Creative Cloud Rating: 0 out of 5 stars0 ratingsGeoServer Cookbook Rating: 0 out of 5 stars0 ratingsInstructional Guide for The ArcGIS Book Rating: 1 out of 5 stars1/5Modern Policing Using ArcGIS Pro Rating: 0 out of 5 stars0 ratingsGetting to Know ArcGIS Desktop 10.8 Rating: 4 out of 5 stars4/5Learning ArcGIS Runtime SDK for .NET Rating: 0 out of 5 stars0 ratingsLearning Geospatial Analysis with Python - Second Edition Rating: 0 out of 5 stars0 ratingsLeaflet.js Essentials Rating: 4 out of 5 stars4/5Mastering PostGIS Rating: 0 out of 5 stars0 ratingsGIS Jump Start for Health Professionals Rating: 0 out of 5 stars0 ratingsGeospatial Development By Example with Python Rating: 5 out of 5 stars5/5Building Mapping Applications with QGIS Rating: 0 out of 5 stars0 ratingsGetting to Know ArcGIS Pro 3.2 Rating: 0 out of 5 stars0 ratingsGIS Tutorial for ArcGIS Pro 3.1 Rating: 0 out of 5 stars0 ratings
Databases For You
Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5COMPUTER SCIENCE FOR ROOKIES Rating: 0 out of 5 stars0 ratingsPractical Data Analysis Rating: 4 out of 5 stars4/5Mastering Veeam Backup & Replication.: Design and deploy a secure and resilient Veeam 12 platform using best practices Rating: 0 out of 5 stars0 ratingsAccess 2019 For Dummies Rating: 0 out of 5 stars0 ratingsLearn SQL Server Administration in a Month of Lunches Rating: 3 out of 5 stars3/5Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries Rating: 0 out of 5 stars0 ratingsLearn Git in a Month of Lunches Rating: 0 out of 5 stars0 ratingsLearn SQL in 24 Hours Rating: 5 out of 5 stars5/5Blockchain Basics: A Non-Technical Introduction in 25 Steps Rating: 4 out of 5 stars4/5Access for Beginners: Access Essentials, #1 Rating: 0 out of 5 stars0 ratingsPython Projects for Everyone Rating: 0 out of 5 stars0 ratingsGo in Action Rating: 5 out of 5 stars5/5Learn Data Analysis with Python: Lessons in Coding Rating: 0 out of 5 stars0 ratingsData Science Strategy For Dummies Rating: 0 out of 5 stars0 ratingsSQL Server: Tips and Tricks - 2 Rating: 4 out of 5 stars4/5Managing Data Using Excel Rating: 5 out of 5 stars5/5Tableau Cookbook – Recipes for Data Visualization Rating: 0 out of 5 stars0 ratingsExcel 2021 Rating: 4 out of 5 stars4/5Access 2016 For Dummies Rating: 0 out of 5 stars0 ratingsServerless Architectures on AWS, Second Edition Rating: 5 out of 5 stars5/5CompTIA DataSys+ Study Guide: Exam DS0-001 Rating: 0 out of 5 stars0 ratingsLearning Oracle 12c: A PL/SQL Approach Rating: 0 out of 5 stars0 ratingsTroubleshooting PostgreSQL Rating: 5 out of 5 stars5/5Azure SQL Revealed: A Guide to the Cloud for SQL Server Professionals Rating: 0 out of 5 stars0 ratingsChessBase Complete: 2019 Supplement Covering ChessBase 13, 14 & 15 Rating: 0 out of 5 stars0 ratings
Reviews for Learning ArcGIS Geodatabases
3 ratings0 reviews
Book preview
Learning ArcGIS Geodatabases - Hussein Nasser
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
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
Cover image by Pratyush Mohanta (<[email protected]>)
Credits
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
About the Author
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 technology with ArcGIS for Server, which was not implemented back then. His eight-year career as a GIS architect at the leading Middle Eastern engineering company Khatib & Alami involved implementing various utility GIS systems based on the Esri technology across the Middle East. After this, Hussein decided to move to a more focused environment at Electricity and Water Authority, Bahrain, his homeland, where he could channel his expertise to develop a robust GIS utility solution and fully integrate it with the e-government project, which would help Bahrain march towards the smart grid. Beyond GIS, Hussein is fascinated by acute research topics. Among the papers he is currently working on are The Human API: A Software Interface to Prevent Cancer, Global Economic Crisis and Natural Disasters Quantum Detector, and the Stock Market and the Moon Phases.
To Nada: May all our dreams come true.
About the Reviewers
Hani M. Basheer is a GIS expert and Oracle certified professional DBA. He graduated in the year 2001 as a surveying engineer with a technical postgraduate diploma in Esri GIS. He has over 15 years of experience in the field of Geographic Information Systems (GIS), Esri products.
Throughout his career, he has worked on several enterprise GIS projects in Egypt and Saudi Arabia; he worked with the Egypt SDI project, which is a project to establish a GIS system for the NARSS and EMRA authorities in Egypt. He moved to Saudi Arabia in 2007 to work with a leading GIS company, FarsiGeoTech, which deals with many GIS projects. Hani moved to National Water Company in 2010 to establish a GIS unit, GIS model, geodatabase, and GIS application to manage the water and waste water utility networks of Jeddah city.
Hani has over 10 years of experience as a technical trainer for GIS products. During this period, he has delivered many successful training sessions in the Middle East to different sectors such as petroleum, mining, education, electricity, and municipalities.
Throughout his career, he has worked with most Esri products. He worked with Oracle databases and earned four DBA OCPs. He has also worked with SAN storage, GPS, and GPS CORS systems.
He really liked this book. While reviewing, he found it interesting enough to complete it from start to end. He also felt that the writer succeeded in providing knowledge to the readers in an easy way. He guarantees the readers that they will get the best out of their GIS career by reading this book.
I would like to thank my wife, Wegdan, for her love and support. I also want to acknowledge my loving family, who are always there for me.
Frank Donnelly is a Geospatial Data Librarian at Baruch College, City University of New York, where he assists students and faculty with finding and processing data and using GIS. He holds master's degrees in both Geography and Library and Information Science. He has been using GIS for over 15 years and has extensive experience working with the US Census data. He has built several spatial databases using ArcGIS personal geodatabases and open source SpatiaLite, including a geodatabase for studying New York City neighborhoods, which is freely available on his college's website. He has recently published papers on the geography of public libraries in the United States and the use of the US Census Bureau's American Community Survey for research.
Venkatesh Merwade is an associate professor at the Lyles School of Civil Engineering, Purdue University. His research and teaching interests include solving water resources issues by using GIS, computer modeling, and hydrologic information systems. His online tutorials, which are available at his website for free, on GIS applications and hydraulic and hydrologic modeling are used by students, researchers, and practitioners around the world to address water resource issues. He has co-authored two chapters in Arc Hydro: GIS for Water Resources, Esri Press; one chapter in GIS, Spatial Analysis, and Modeling, Esri Press; and one chapter in Gravel Bed Rivers 7: Developments in Earth Surface Processes, Wiley.
www.PacktPub.com
Support files, eBooks, discount offers, and more
You might want to visit www.PacktPub.com for support files and downloads related to your book.
Did you know that Packt offers eBook versions of every book published, with PDF and