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

3
votes
1answer
293 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
385 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
140 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
147 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
86 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
382 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
79 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
95 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
300 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
40 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
1answer
128 views

Change sde connection parameters with ArcPy

I know you can create a database connection with Arcpy using the CreateDatabaseConnection_management function. I am wondering if anyone knows a way in which to change the parameters of that file. ...
1
vote
0answers
366 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
642 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
71 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
5k 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
256 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
88 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
223 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
5k 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
76 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
181 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
512 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
144 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
94 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
43 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
332 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
81 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
39 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
441 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
355 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
56 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
358 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. ...
1
vote
1answer
617 views

How to merge Shapefiles from multiple folders into Geodatabase Featureclass?

I have a question regarding the merge of a lot of folders, which has a lot subfolders, which has the shapefiles stored. I would like to merge all those in one geodatabase. So I thought to use a ...
3
votes
1answer
87 views

Opening a featureclass not being the owner of the data in SDE

How can you open a featureclass if you are not the schema owner but have been given privs to select or view the data? So given a name of a featureclass, say "STREETS" - how can I open this if I am ...
4
votes
1answer
117 views

Coded Value Domain is showing, but not Description?

I have a Domain that is working, but the issue is when I query on the feature. I need to be able to search on the Coded Description, not the Code Value. The attribute table is giving me the Coded ...
4
votes
1answer
56 views

Update value in domain and same should reflect in attribute field

I have a SDE GDB, where i have no. of domains created. we have created domain for state names, which is used by all feature classes to update their respective state name. Now i have discovered that ...
1
vote
1answer
96 views

Best practices for sharing feature classes between different geodatabases

We're starting to work on different projects. All of them have their own data and classes but some of them are common (ex. parcels, traffic, road definition, etc.). What are the best practices for ...
8
votes
1answer
422 views

How to apply schema changes on Esri geodatabase two-way replica set?

I have an Esri geodatabase two-way replica set. I need to update the schema on both databases in the replica set. Esri describes doing this using ArcGIS schema tools (compare/export/import replica ...
2
votes
2answers
304 views

Open Raster stored in ESRI V10.0 Geodatabase in QGIS V2.4

Is there a way to open a raster that is stored in ESRI V10.0 Geodatabase in QGIS V2.4. I can open the vector layer, but there does not seems to be a way to open a raster.