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
357 views

mosaic raster to file geodatabase yields missing raster sections

Since upgrading to ArcGIS 10.1 (SP 1) from 10.0, I've been encountering an issue when running the arcpy.MosaicToNewRaster_management() tool with output to a file geodatabase. I'm principally working ...
1
vote
1answer
120 views

Oracle error when copying massive feature dataset

In ArcCatalog 10.1, when copying a feature dataset with roughly 3 million objects as well as a few thousand tables and relationship classes, my team is running into an 'Underlying DBMS error ...
1
vote
0answers
46 views

Use Hibernate with Oracle and Esri St_geometry type

Can anyone tell me whether I could use Hibernate with esri ST_GEOMETRY type? I have found that Hibernate Spatial does support SDO_Geometry, but nothing for ST_Geometry. I am using oracle 11g and ...
0
votes
1answer
160 views

How to edit feature in sqlserver geodatabase

I am using arcmap 10.2.1 and arcobject 10.2.1,I just want to conncet to a geodatabase and edit,add,delete a feature from a feature class using arcobject,I tried to connect to database and it works ...
0
votes
3answers
449 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
18 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
37 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 ...
5
votes
1answer
66 views

Modelbuilder Workspaces: Defaults to a folder, would like it to be a geodatabase

I'm having an issue with modelbuilder workspaces. I have created a simple model to clip a raster, run focal statistics on it, and create contours. I have a workspace variable as an input. If I run the ...
9
votes
5answers
6k views

How to reorder fields (permanently) in a file geodatabase

Using ArcGIS 10.0, is it possible to reorder the fields in a file geodatabase, and have the order persisted to the database? We considered exporting to XML, and writing a parser to change the field ...
13
votes
3answers
10k views

What is the difference between FID and OID

What is the main difference between OID and FID in ESRI software?
0
votes
0answers
19 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
257 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
352 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
50 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 ...
1
vote
1answer
233 views

ArcGIS 10.1 SDE database schema other than SDE or DBO

Just wondering if it's possible to apply a schema other than SDE or DBO to SDE feature or raster tables stored in an enterprise database on MS SQL Server 2008 R2. I have got a new customise schema ...
8
votes
4answers
4k 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 ...
2
votes
0answers
39 views

Database connection (SDE) failed after database was renamed

I created an enterprise geodatabase in SQL Server 2008 R2 with ArcCatalog (10.2). It was connected via an sde file in ArcCatalog then. Then I had to rename the database from SQL Server Management ...
0
votes
0answers
24 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
36 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 ...
14
votes
2answers
1k 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 ...
0
votes
2answers
87 views

Integrate geodatabase with other nonspatial databases in oracle 11g using ArcGis for Desktop 10.2

I have an oracle database namely xe which I have spatially enabled. using the Create Enterprise Geodatabase geoprocessing tool. The application I am going to implement has an already created ...
4
votes
1answer
70 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
130 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 ...
10
votes
3answers
3k views

Exporting arcgis features with attachments

Arcgis 10 features the new ability to add attachments to individual features to feature classes stored in a geodatabase. One use of this would be to add multiple pictures to a specific location, fire ...
2
votes
1answer
71 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
0answers
42 views

Assign a IGeometry to Feature.Shape

I'm trying insert a feature into a FeatureClass, but when I try to assign the geometry to featurebuffer the app return the next Error: The remote procedure call failed. (Exception from HRESULT: ...
1
vote
2answers
49 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
215 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
5 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
33 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
55 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
112 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 ...
6
votes
3answers
232 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
28 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
27 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 ...
2
votes
4answers
129 views

How to perform relational queries against an ArcSDE geodatabase using the ArcGIS API for JavaScript?

I have a geospatial database which contains both spatial and not-spatial tables I would like to publish my data on ArcGis for server and perform both simple and spatial queries. Also, foreign key ...
7
votes
1answer
4k 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
5k 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
79 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
37 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
82 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
49 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 *, ...
16
votes
8answers
10k views

ArcCatalog 10.0 complains that spatial references don't match between a feature dataset and a feature class that have the same coordinate system?

I have a feature dataset that is using the GCS_WGS_1984 as the geographic coordinate system. It includes a few feature classes. This feature dataset is itself in a file geodatabase that contains a ...
13
votes
4answers
2k 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
53 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
117 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
317 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 ...