Tag: Geodatabase

Preparing a map for editing: Assembling the data to edit

It’s a good idea to spend a little time preparing your map for editing. You’ll be a lot more productive and save clicks if you set up your map and data before you really get in and make edits. This post is part of a series on the subject.

Choosing where to store your data
ArcGIS allows you to create and edit several kinds of data. You can edit feature data stored in geodatabases and shapefiles, as well as various tabular formats. When gathering your data in preparation for a geographic information system (GIS) project, make sure all the data you want to edit is stored in the same workspace, which is a single geodatabase or a folder of shapefiles, since you can only edit one workspace at a time. If you are still using shapefiles, consider migrating to a geodatabase, such as a file geodatabase, which provides more functionality and storage capacity with as much speed and simplicity as shapefiles. You can use the geoprocessing tools for importing and exporting data, as well as often simply copying and pasting feature classes in the Catalog tree, to get data into a geodatabase.
With the Catalog window now embedded in ArcMap, you can perform data management tasks and access your data without having to open the separate ArcCatalog application. This is useful in itself, but a few additional settings can make your use of the Catalog window even more productive. For example, the directory where you save a map document is tagged as the Home location and is always promoted to the top of the Catalog window when that map is open. Therefore, if you put the geodatabase in the same folder as the map document you are working on, you can quickly find your data in the Home location without having to navigate through the whole folder tree. Doing this also keeps your GIS project better organized since all the data, maps, and other supporting materials are in the same place. In addition, you can set your geodatabase as the map’s default geodatabase (right-click it in the Catalog window and click Make Default Geodatabase) so any outputs will be saved in that location automatically.

Choosing the projection for your data
As you compile your data, you need to consider the projections. First, you should make sure the feature classes that you will be editing all have the same coordinate system. In addition, if you have data in a geographic coordinate system, you may want to change to an appropriate local projection. This will improve accuracy when editing and make it easier to enter lengths and other measurements since values are specified in the map units of the coordinate system by default. For example, if your map uses the geographic coordinate system of WGS 1984, when you are editing, ArcMap interprets any entered values as decimal degrees because those are the map units for that coordinate system. So when you type 100 for the length of a segment, as shown below, ArcMap interprets that as 100 degrees and will likely present you with a series of error messages. On the other hand, with a projected coordinate system, the map units will be in a more useful unit, such as meters or feet. Also, a projected coordinate system is flexible because it allows you to specify distances in units other than the map units by including an abbreviation with the value; you can only enter values in the coordinate system’s map units (typically, decimal degrees, as just discussed) when working with a geographic coordinate system.

The coordinate systems of the layers also need to match the coordinate system of the data frame. If the coordinate systems of the data frame and layers are different, the layers will be projected on the fly to the coordinate system of the data frame. Projecting on the fly can be problematic because it may cause unexpected alignment issues when making edits. For example, when editing, you may digitize some lines that look like they connect to other lines. While the lines appear to be snapped to edges when projecting on the fly, the lines may be dangling when you display them in their native projection. In addition, you cannot perform shared editing of coincident features through a map topology for layers that are being projected on the fly. 

To avoid all these issues, make sure you are not projecting on the fly while editing. When you have an empty data frame, it automatically takes on the coordinate system of the first layer added to it. To change the data frame’s coordinate system, right-click the data frame name in the table of contents, click Properties, then click the Coordinate System tab. In the Select a coordinate system box, you can quickly set the coordinate system of the data frame to match that of a layer in it by clicking the Layers folder and navigating to the coordinate system listed underneath one of the layer names. Since the coordinate system of the data frame and the layers will now match, the layers will not be projected on the fly.

Starting an edit session
When you are finally ready to edit your data, turn on the Editor toolbar (if it’s not already displayed), click the Editor menu, then click Start Editing. This begins an edit session, which you will end when you are done. When you start an edit session on a geodatabase workspace, you have the ability to edit all the feature classes and tables in that geodatabase at the same time. With an edit session on a shapefile folder workspace, you can edit all the shapefiles that are stored in that directory.
If you start editing in a map that contains data from more than one workspace, you are prompted to choose the workspace you want to edit. On the dialog box, click a layer at the top to select its workspace source at the bottom of the window (notice that the database symbols change color), or click a workspace at the bottom of the window to view the layers in it at the top. Once you have picked the workspace, click OK to start the edit session. Later, if you need to edit data in the other workspace, stop editing, then start a new edit session and choose that workspace. Keep in mind that you can also right-click a layer in the table of contents, point to Edit Features, then click Start Editing, which automatically starts an edit session on the entire workspace containing that layer.

Once you choose the workspace to edit, sometimes you may see another dialog box appear about problems that ArcMap encountered when you started editing. This dialog box will list the layers that are being projected on the fly, as well as any other issues such as missing licensing, layers that cannot be edited because they are read-only or inside a basemap layer, and so on. You can double-click each message to open a help topic with more information.

For more on the Catalog window, projection considerations, and edit sessions in ArcGIS 10, see the following:
What’s new for accessing your data in ArcGIS 10
About editing data in a different projection (projecting on the fly)
About edit sessions

Posted in Editing | Tagged , , , , , , , , | Comments Off

Creating an earlier version of a file or personal geodatabase

When moving to a new release of ArcGIS, it’s common for an organization to migrate some of their users to the new release, while leaving others at the current release. One example of where this is necessary is in a distributed environment, it’s not always possible for the users who are off-site to upgrade to the latest release of ArcGIS at the same time as the central office.

This has always posed a problem when it came time to share data between users at different releases of ArcGIS.  When the geodatabase is upgraded to the latest release, as with ArcGIS 10, it’s not always possible for previous releases of ArcGIS to connect to and use those geodatabases. We’ve made a few changes at the 10 release which we think will help users in this scenario.

The Create File GDB and Create Personal GDB geoprocessing tools in the Data Management toolbox have been augmented to include an optional parameter that allows you to specify which version of the geodatabase you want to create. You can create a version 10, 9.3, or 9.2 release file or personal geodatabase. You can also create a version 9.1 release personal geodatabase. 

Being able to create an older release geodatabase from an ArcGIS 10 client allows you to more easily share data with people or agencies who are using older releases of ArcGIS. You can copy the data from a geodatabase in a current release and paste it into a geodatabase you create to be from a previous release. And, since ArcGIS 10 can access and edit these geodatabases, you can continue to use them without upgrading. You can also easily integrate these tools into Models and Python Scripts that will allow you to automate data extraction.

Posted in Geodata | Tagged , , | 4 Comments

Using CASE tools in ArcGIS 10

So ya, this is a post about using CASE tools at ArcGIS 10 (CASE tools are a separate set up that you can access from your media disc or download from the customer care site). But before I get into that let me just say that, while CASE tools are still supported at ArcGIS 10, I personally think that a better place to start building a geodatabase schema, or a GIS in general, is to begin with one (or a combination) of the following:

  • Look at some predefined maps, such as those created by the Local Government team on ArcGIS.com. Load these into ArcGIS, study how they are built, read the associated documentation, see how you can use your data with these maps and applications, then try building your own.
  • Download a template from the resource centers to pour your data into, such as those found on the Electric and Gas or Defense and Intelligence sites.
  • Download one of the industry-specific Data Models from the resource center and adapt your data to it or adapt it to your data.

Ok, that’s my spiel. But yes, another method for building your geodatabase schema is to use CASE tools. Continue reading

Posted in Geodata | Tagged , , | 20 Comments

Creating Multiple Geodatabases Within a Single Oracle Instance

You can create multiple ArcSDE geodatabases within a single Oracle instance. First you create a geodatabase in the SDE user’s schema. This is referred to as the master sde geodatabase. The master sde geodatabase contains the ST_Geometry type, its subtypes and functions, and the system tables the ST_Geometry type uses, such as ST_SPATIAL_REFERENCES.

After the master geodatabase is created, any user who has the proper permissions to do so can create a geodatabase in his or her own schema. A table in the master geodatabase, called INSTANCES, keeps track of all the geodatabases that exist in the schemas of other users. Continue reading

Posted in Geodata | Tagged , , , | 2 Comments

UC2010 Geodatabase Essentials Presentations

Well another UC has quickly come and gone and we’re still a little dizzy from the whirlwind.

Check out user conference Pictures, Plenary/Keynote videos, and that interesting Keynote idea 19.20.21

Continue reading

Posted in Geodata | Tagged , , | Leave a comment

Modeling Our World – New Geodatabase Book Available from ESRI Press

For the past year and a half Mike Zeiler has been toiling away at a new version of his Modeling Our World book. Brent, Craig and I helped with the content and overall direction of the book over that timeframe and trust me, writing a book is no small feat.

The full range of geodatabase topics is represented within the pages starting from the origins of the geodatabase and what it is and delving into all of the geographic datasets that you work with inside the geodatabase to model the complexities of our world. In brilliant Zeiler form, the concepts of the book are beautifully expressed through colorful and thoughtful graphics and illustrations.

As each chapter was completed it was reviewed by the respective experts here on the development teams at ESRI’s campus in Redlands. Needless to say a lot of people put a lot of time into collaborating on this book and we are satisfied that the book delivers “a complete survey of the geodatabase information model”.

Finally, all of our efforts have come to fruition and the book is published – Modeling Our World: The ESRI Guide to Geodatabase Concepts.  It is a wealth of knowledge about everything that is the geodatabase. The book is available at the Spatial Outlet here at the User Conference so pick it up if you’re here in San Diego (It is also available from ESRI Press and Amazon).

If you’re lucky you may see Mike wondering the halls of the San Diego convention center this week. When you see him, be sure to congratulate him on a job well done.

Posted in Geodata | Tagged , | 2 Comments

Geodatabase Demo Theatres @ UC2010

Members of the geodatabase team will be presenting numerous topics in the demo theatre within our showcase area during the week at UC2010. Demo theatres are a little more hands on than your typical tech workshop and are a good chance to see live demos of specific areas of the software. A little less formal, a little more intimate, a good chance to ask questions, you should check them out. See if you’re interested in any of the topics below.

Demo Theater Schedule

Tuesday, July 13, 2010
10:00 AM   -   11:00 AM          File Geodatabase Overview
11:00 AM   -   Noon                Leveraging Relationship Classes in the Geodatabase
Noon          -   1:00 PM           Using ArcGIS for AutoCAD
1:00 PM     -   2:00 PM            Georeferencing Image and Raster Data in ArcGIS
2:00 PM     -   3:00 PM            Best Practices for Editing in ArcGIS 10
3:00 PM     -   4:00 PM            Geodatabase Overview
4:00 PM     -   5:00 PM            Configuring Industry specific GDB validation checks using the ArcGIS Data Reviewer
5:00 PM     -   6:00 PM            Geodatabase Archiving Overview

Wednesday, July 14, 2010
9:00 AM     -   10:00 AM          An Introduction to Using the ArcGIS Data Reviewer for GDB Quality Control
10:00 AM   -   11:00 AM          Metadata Processes and Solutions
11:00 AM   -   Noon                Creating Mosaic Datasets
Noon          -   1:00 PM           Managing Distributed Workflows and Workforces
1:00 PM     -   2:00 PM            Working with Spatial Type Data Using Structured Query Language (SQL)
2:00 PM     -   3:00 PM            Migrating Data to the Geodatabase
3:00 PM     -   4:00 PM            Working with Geodata Services
4:00 PM     -   5:00 PM            Introduction to Query Layers
5:00 PM     -   6:00 PM            Best Practices for Editing in ArcGIS 10

Thursday, July 15, 2010
9:00 AM     -   10:00 AM          ArcGIS Workflow Manager – Building Custom Workflow Steps
10:00 AM   -   11:00 AM          Tips and Tricks for Using the Parcel Editor
11:00 AM   -   Noon                Versioning and Conflict Management 101
Noon         -     1:00 PM          Using Image Analysis Window

Posted in Geodata | Tagged , | Leave a comment

Geodatabase Specialists @ the UC

Just under two weeks until the UC! Things are getting exciting around here.

If you’ve got some geodatabase related questions while you’re at the UC, swing by our geodatabase island in the showcase area and we’ll direct you to a specialist that can help.

Not all the specialists will be on the island all the time however, as we’ve all got presentations and meetings and other things going on as well. So if you’re having trouble tracking down the right person for a particular question be sure to swing by the island during the right Meet the Specialists time and talk to the guru for that specific area.

Meet the Specialists Schedule

Tuesday, July 13, 2010
10:00 AM   -   Noon                                  Replication; PostGreSQL
Noon         -   2:00 PM                              Oracle; Metadata
2:00 PM     -   4:00 PM                              Archiving; Documentation; Geodatabase Raster
4:00 PM     -   6:00 PM                              Geometric Network; Topologies; Image Server

Wednesday, July 14, 2010
10:00 AM   -   Noon                                   File GDB; Linear Referencing; Raster Display and Image Analysis Window
Noon         -   2:00 PM                               Map Projections; Relationship Classes
2:00 PM     -   4:00 PM                               SQL Server; Query Layers
4:00 PM     -   6:00 PM                               ArcGIS User Community Templates and Models; Geodatabase XML

Thursday, July 15, 2010
9:00 AM     -   11:00 AM                             DB2; Informix
11:00 AM   -   1:00 PM                               Versioning; Raster Processing

Posted in Geodata | Tagged , | Leave a comment

Geodatabase issue with synchronizing replicas

For all users of geodatabase replicas, make sure and checkout the Geodatabase team blog for information on an important issue and upcoming fix.

For more information see Knowledge Base Article 37896

 

Posted in Uncategorized | Tagged , , | Leave a comment

Geodatabase Tech Workshops @ the 2010 ESRI User Conference

The 2010 ESRI International User Conference is just a few weeks away and our team has been preparing technical workshops and demo theatres to present down at the San Diego convention center.

As usual, our team will have its own geodatabase island in the showcase area where team members will be available to answer any questions and talk about projects you’re working on.

The ESRI UC Insider is a good place to keep up to date on what’s happening at this year’s conference, so be sure to check that out.

Below is a list of the presentations the geodatabase team is offering at this year’s UC. Click the links to find out more about each session.

 

Tuesday, July 13, 2010

8:30 AM - 9:45 AM

Administration for Oracle – An Introduction 

Offering 1Room 4

 

Geodatabase Essentials Part 1 – An Introduction to the Geodatabase

Offering 1Room 6 C

 

Geometric Networks in the Geodatabase

Offering 1Room 3

 

Managing Metadata with ArcGIS 10

Offering 1 - Room 14 A

 

Public Utility Applications using ArcGIS

User Community Template SessionRoom 32 B

 

10:15 - 11:30 AM

Administration for Oracle – Advanced

Offering 1Room 4

 

Getting Started with Editing in ArcMap

Offering 1Room 2

 

12:00 PM - 1:00 PM

Administration for IBM Databases – An Introduction

Room 3

 

What’s New in the Geodatabase at ArcGIS 10

Offering 1Room 6 C

 

1:30 PM - 2:45 PM

Administration for SQL Server – An Introduction

Offering 1Room 4

 

Enterprise Geodatabase – Tips and Tricks

Offering 1Room 6 D

 

Topology in the Geodatabase 

Offering 1 – Room 6 C

 

Working with CAD Data in ArcGIS

Offering 1Room 3

 

GIS Design Methods

User Community Template SessionRoom 32 B

 

3:15 PM - 4:30 PM

Administration for PostgreSQL – An Introduction

Room 6 C

 

Administration for SQL Server – Advanced

Offering 1Room 4

 

Managing Distributed Data with Geodatabase Replication

Offering 1Room 6 D

 

Using the ArcGIS for AutoCAD Plug-In Application

Offering 1Room 3

 

The Local Government Template at ArcGIS 10

User Community Template Session – Room 32 B

 

Wednesday, July 14, 2010

8:30 AM - 9:45 AM

Land Records Applications using ArcGIS

User Community Template SessionRoom 32 B

 

Fundamentals of ArcGIS: Maps, Geodatabases, Models, and How they work together

Offering 1 – Room 6 A

 

Editing with ArcGIS – Tips and Tricks

Offering 1Room 3

 

Geodatabase Editing Workflows

Offering 1Room 6 C

 

Geodatabase Essentials Part 2 – An Introduction to ArcSDE Geodatabases

Offering 1Room 4

 

10:15 - 11:30 AM

Emergency Management Applications using ArcGIS

User Community Template SessionRoom 17 A

 

Editing Parcels with ArcGIS

Offering 1Room 3

 

Using SQL and Spatial Data Types with the Geodatabase

Offering 1Room 4

 

12:00 PM - 1:00 PM

What’s New in the Geodatabase at ArcGIS 10

Offering 2Room 6 C

 

Working with ESRI’s Spatial Data Type for Oracle [Technical Briefing]

Room 4

 

1:30 PM - 2:45 PM

Administration for Oracle – An Introduction

Offering 2Room 4

 

ArcGIS Data Reviewer: An Introduction

Offering 1Room 15 B

 

Geodatabase Essentials Part 1 – An Introduction to the Geodatabase

Offering 2Room 6 C

 

Geometric Networks in the Geodatabase

Offering 2Room 3

 

Parcel Management at ArcGIS 10

User Community Template SessionRoom 32 B

 

3:15 PM - 4:30 PM

Enterprise Geodatabase Configuration, Upgrade, and Direct Connect Strategies

Offering 1 – Room 32 B

 

Administration for Oracle – Advanced

Offering 2Room 4

 

Managing Metadata with ArcGIS 10

Offering 2Room 14 A

 

Understanding the Concepts of the Parcel Fabric

Room 6 C

 

Working with CAD Data in ArcGIS

Offering 2Room 3

 

Thursday, July 15, 2010

8:30 AM - 9:45 AM

Administration for SQL Server – An Introduction

Offering 2Room 4

 

Enterprise Geodatabase – Tips and Tricks

Offering 2Room 6 D

 

Geodatabase Essentials Part 2 – An Introduction to ArcSDE Geodatabases

Offering 2Room 3

 

Getting Started with Editing in ArcMap

Offering 2Room 2

 

Topology in the Geodatabase

Offering 2Room 6 C

 

10:15 - 11:30 AM

Enterprise Geodatabase Configuration, Upgrade, and Direct Connect Strategies

Offering 2 – Room 32 B

 

Administration for SQL Server – Advanced

Offering 2Room 4

 

ArcGIS Data Reviewer: An Introduction

Offering 2Room 15 B

 

Editing with ArcGIS – Tips and Tricks

Offering 2Room 3

 

Managing Distributed Data with Geodatabase Replication

Offering 2Room 6 D

 

Using the ArcGIS for AutoCAD Plug-In Application

Offering 2Room 6 C

 

1:30 PM - 2:45 PM

Editing Parcels with ArcGIS

Offering 2Room 3

 

Geodatabase Editing Workflows

Offering 2Room 6 C

 

Using SQL and Spatial Data Types with the Geodatabase

Offering 2Room 4

 

Friday, July 16, 2010

9:00 AM - 10:15 AM

Editing with ArcGIS – Tips and Tricks

Offering 3Room 3

 

Geodatabase Essentials Part 1 – An Introduction to the Geodatabase

Offering 3Room 1 A/B

Posted in Geodata | Tagged , , | Leave a comment