ESRI geodatabase is a particular database schema designed by ESRI for managing "layers", "versioning", "topology" and other ESRI application specific storage requirements.

learn more… | top users | synonyms

8
votes
2answers
1k views

What does an asterisk (*) mean when shown beside a field name in the attribute table?

What does an asterisk (*) mean when shown beside a field name in the attribute table? I would think those are reserved field names but they are not.
5
votes
5answers
3k views

Can I copy an entire geodatabase with relationship classes and domains and reproject all feature classes from wgs84 to state plane?

I have an SDE geodatabase with several feature classes, tables, relationship classes, and domains. All the feature classes are currently in WGS84 coordinate system. I need an exact copy of the ...
7
votes
2answers
1k views

Is there a performance hit from using a Feature Dataset?

I vaguely remember being taught not to use a Feature Dataset to make things "look neat" in the database, and that the Feature Dataset should only be used when there was some sort of spatial ...
1
vote
0answers
48 views

ArcPad Fill Northing, Easting, Elevation

How do you get ArcPad to fill out the fields for Northing, Easting and Elevation of a point that was created/measured using the GPS on a handheld unit? The fields for are part of the geodatabase but ...
0
votes
3answers
725 views

Network Analyst not working

I have network analyst installed as an extension in my arcGIS 9.3, but it just does not work!!! when I go to ArcCatalog, the option of new network data set also does not appear... :( I have to do this ...
0
votes
0answers
51 views

Change Privileges tool does not work against feature dataset containing a network dataset

I'm trying to change the privileges on a feature dataset that contains a topology and network dataset using the ChangePrivileges geoprocessing tool. This works if I run the command manually from the ...
1
vote
1answer
101 views

Coded Geodatabase Domain Values behaving oddly with special characters in the description field

I am setting up Geodatabase Domains for my Fire Hydrant layer. The Domain restricts the "Type" of Fire Hydrant to a designated list of Brand Names. I'm running into an issue where some of my coded ...
0
votes
0answers
52 views

Looking for succesful implementaion of PPDM in form of geodatabase

I am have difficulties in implementing spatial version of Professional Petroleum Data Management (PPDM) for our GIS database. Does anyone have a reference to a sucessful case of implementing PPDM in ...
3
votes
1answer
308 views

Triggers for delta tables

I have been facing an issue to capture the delta updates on SDE. We have written triggers on A and D tables to capture the delta updates(to capture the version name based on state id's), however I ...
2
votes
1answer
387 views

Is PPDM Lite still available as a Geodatabase template?

I have been looking for a Geodatabase template that conforms to the PPDM Lite standard and believe that one was previously available here. However, that page no longer exists and no Geodatabase ...
1
vote
2answers
166 views

How to get a search cursor on a particular version in arcpy

I have a versioned database in ArcGIS and I am wondering how can I tell arcpy what version to query. The closest I have got to an answer has been building a particular connection file that specifies ...
8
votes
4answers
5k views

ArcGIS fails to import all records from huge CSV file to file geodatabase table despite being within FGDB table size limits

I'm using ArcGIS 10.0 on Windows 7 64-bit with 4GB of RAM. I have some very large tables in CSV format to import to ArcGIS, they all have about 30 fields, upwards of 5 million records per table (a ...
0
votes
0answers
33 views

Deploy SD file to production environment

I have created map service using an oracle 11g geodatabase. I have created the SD file which knows the exact location of my table "myPlaces". (IP of my XE, credential etc) Now I have to send the SD ...
1
vote
1answer
179 views

findAndReplaceWorkspacePaths does not work for sde files so as to change datasouce (geodatabase)

I manage to change my datasouce by right clicking on an mxd file and choosing a different sde database connection file as shown in the following image. However When I try to do this using arcpy ...
6
votes
3answers
2k views

What are convenient uml tools to create geodatabase models?

I used to model databases with Microsoft Office Visio, then export the model to xml and import geodatabase schema to GDB with ArcGIS tools. Since Microsoft no longer support Visio export to xml, what ...
15
votes
2answers
2k views

What is the best practice for data management? [duplicate]

I have always been curious how other folks are storing their spatial data. Outside of an enterprise environment where much data is stored in enterprise geodatabases, is it better to store data per ...
4
votes
1answer
87 views

Deleting geodatabases that are more than one week old?

I am using ArcGIS Desktop 10.0 and Python 2.6.6 and am trying to make an update script to copy the geodatabase to a backup folder with the date as part of the name, got that to work. Then export ...
0
votes
2answers
424 views

How to explain why a particular ArcSDE state does not compress?

I am maintaining an ArcSDE database and would like to avoid killing connections to ArcSDE in order to run the compress operation. Our versioning workflow is very simple. Everyone edits the DEFAULT ...
2
votes
1answer
81 views

Where are the Block and Lot fields in the ESRI Local Government Information Model Geodatabase Schema?

I am looking at the ESRI Local Government Information Model (LGIM) geodatabase schema and I cannot find the Feature Class that holds the parcels' Block and Lot information. Do you know which Feature ...
1
vote
2answers
116 views

How to change field defined as REQUIRED to NON_REQUIRED in ArcGIS Geodatabase

I have created some feature classes in a geodatabase and also some fields using this sample code: arcpy.AddField_management("schools", "ref_ID", "LONG", 9, "", "", "refcode", "NULLABLE", "REQUIRED") ...
1
vote
2answers
309 views

Bulk grant privileges to multiple tables at once in ArcGIS 10.1 Desktop

I am able to grant multiple privileges (SELECT, INSERT, UPDATE, DELETE) to multiple Users/Roles to one single Table each time on an Enterprise Geodatabase from ArcCatalog 10.1. That's done by Manage ...
0
votes
0answers
6 views

Filter pointcollection in geocoords set

i'm working with .Net v3.5 and ArcGis 9 and i must say i'm pretty newbie with this. I have an application with different layers, one of them is used to draw the world using WGS84 coords, what i'm ...
1
vote
0answers
41 views

Update enterprise database from shapefile data?

Where I work we recently moved our GIS data from GDB databases to an enterprise SQL database. We primarily use ArcGIS 10.2 to edit and maintain our internal data but we also receive ancillary data ...
1
vote
0answers
397 views

Unable to create object class extension COM component?

I'm getting the error: Unable to create object class extension COM component in ArcMap 10.2 when trying to open feature classes from old geodatabases. I'm also getting "error repairing the ...
7
votes
3answers
700 views

How to access a Feature service hosted on arcgis.com which is shared only with particular groups or organization

In my C# application, I am trying to access a Feature service which is hosted on arcgis.com. The feature service is shared only with a group or organization and is NOT public. How can I access this ...
3
votes
1answer
40 views

Apply ArcGIS Field Calculator on New Records

I'm using the Field Calculator in ArcMap 10.1 to populate a field with a string version of an existing integer field. This is working correctly on existing data. I am looking for a way to have ...
0
votes
0answers
73 views

Converting Labels to Annotations in ArcGIS for Desktop says coordinates or measures are out of bounds?

Am converting Labels to Annotations in ArcMap 10.1. However an error messages pops up with this message. The coordinates or measures are out of bounds. Text = RUSHOZI The coordinates or measures are ...
7
votes
1answer
6k views

Export all coded value domains from a geodatabase

On the ESRI-L mailing list this morning there was a question about how to see or export all the coded value domains for a geodatabase. The goal is to present the content of the domains in a tabular ...
10
votes
4answers
6k views

Character encoding support in geodatabases and shapefiles

I've got several geodatabases that include feature classes with Greek letters in a lot of the attributes. When I try exporting a feature class as a shapefile from ArcCatalog, the attributes are ...
2
votes
1answer
275 views

Error when creating enterprise geodatabase

I'm trying to create an enterprise geodatabase. My problem is when I try to create a corporate geodatabase. The error is: Cannot connect to database because the database client software failed ...
8
votes
2answers
1k views

To Use or Not to Use Relationship Classes?

I am building a government database from a massive amount of data. Now I am following the standard approach of the ESRI Local Government Data Model, but modified to fits the needs and wants of a ...
2
votes
3answers
2k views

Creating unique IDs for file geodatabase using ArcGIS for Desktop?

I use ArcEditor licence level, ArcGIS 10.0 version, and we're talking about a file geodatabase. I have several feature classes (electric energy domain) and I want to connect them using relationship ...
1
vote
1answer
90 views

Generating Attachment Match Table in Enterprise Geodatabase?

I've created a file geodatabase, imported a dataset, enabled attachments, generated an attachment match table and then added attachments. Everything worked perfectly and quickly. When I tried the ...
1
vote
2answers
239 views

Create an enterprise geodatabase - Administrator username and password are required

I am trying to create an enterprise geodatabase in oracle 11g, using the create enterprise geodatabase tool in arcmap 10.2. I have properly installed the oracle client needed and I am able to create ...
1
vote
2answers
54 views

Acrgis 10.2.2 make a specific query with IF

I'am using Arcgis 10.2.2 with a geodatabase stored in a file, i'am not using arcgis server. I want to do a specific query in it. I want to do a query which look like that : SELECT *, ...
14
votes
4answers
6k views

What is the difference between Coverage, Shapefiles and Geodatabases in ArcGIS?

I was wondering about the difference in spatial data storage methodology used by Coverages, Shapefiles and Geodatabases in ArcGIS. Coverage was the initial format, followed by Shape Files and now ...
1
vote
1answer
79 views

Cannot Register Database

I want to publish a database to ArcGIS Server. When I try and register the database, I get this error: Can anyone help me? I am using ArcGIS Server and Desktop 10.2 with Microsoft SQL Server 2008. ...
4
votes
2answers
190 views

What is the significance of the SDE lineage length?

ORA-55378 left a great answer to my question: Does a high number of SDE_state_lineages slow performance? But, I realized I don't really understand what lineage length means and how it affects ...
3
votes
2answers
529 views

Tuning Esri Geodatabase on Oracle Spatial (SDO_Geometry) performance?

We are storing data in a Geodatabase on Oracle 11g using Oracle Spatial with SDO_Geometry, and then consuming that using ArcGIS server 10.2.1. The performance is very slow, because we are talking ...
5
votes
1answer
151 views

Implementing INSPIRE Metadata with Geodatabase

I would like to begin by saying that I have never implemented INSPIRE metadata with my spatial datasets before. I am undertaking a project which requires my geodatabase metadata to be in the standards ...
4
votes
3answers
6k views

How do I upload a Featureclass to a Geodatabase in C#?

All, I have a featureclass with Arcobjects that came from a Shape file and I wish to import it into a geodatabase. I have the geodatabase connection, I just don't know how to load the feature class ...
1
vote
1answer
99 views

Replicate Geodatabase and append to main SDE database

I have my ArcSDE GDB on SQL Server 2005. This we are maintaining at our end at head office. Now we have installed ArcGIS editor license to regional offices. GIS technicians at regional offices can't ...
1
vote
0answers
45 views

Displaying gSSURGO data from a geodatabase

Can someone walk me through the steps necessary to display data from one of the "outer" tables in the geodatabases available through gSSURGO? For instance, what joins do I need to perform to get ...
4
votes
1answer
352 views

Connection property set error on registering PostgreSQL geodatabase with ArcGIS for Server?

We're in the middle of a migrating process. We've imported a geodatabase on a new Linux machine and we're trying to publish some map services to this new ArcGIS Server (that resides on the same ...
2
votes
2answers
88 views

vb.net arcobjects determine whether arcmap is in editing session

I have a vb.net arcmap addin which provide a function to validate geodb topology. But there is a problem, when I am not in editing session and use the function, arcmap will crash. In this case I ...
0
votes
0answers
41 views

Is there an ADO.NET 2.0 driver for the ESRI file geodatabase?

I am trying to make a connection to a file geodatabase to issue some SQL queries. I don't need any spatial functionality, we're just trying to get data out of tables. The application making the ...
4
votes
1answer
488 views

Does a high number of SDE_state_lineages slow performance?

In our SDE database, the SDE_state_lineages table has around 200,000 records, the SDE_states has around 900, and our SDE_versions table has around 1,300 records. We've been having performance issues ...
1
vote
1answer
387 views

arcgis geodatabase replica between different versions

We have 2 geodatabase corresponding to 2 systems. There is a replica between these 2 geodatabase all use version 10. Recently there is a version upgrade in the parent geodatabase. It will be upgraded ...
2
votes
2answers
57 views

Combining edits from multiple Geodatabases into a Master Geodatabase

Is there a way to automate combining edits from multiple, single project geodatabases into a master geodatabase based off the date the edits were made without creating duplicated of the same project ...
3
votes
2answers
376 views

Importing Feature Class to Oracle SDE Geodatabase Simplifies Features

I recently imported a feature class from a File Geodatabase to an Oracle SDE Geodatabase. The features of the two feature classes now look drastically different despite not having any edits made. ...