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

0
votes
1answer
11 views

Precision loss when trying to select the latitude and logitude coordinates from an sde.ST_GEOMETRY using SDE.STX() and SDE.STY() functions

In an oracle 11g enterprise geodatabase I am trying the following: INSERT INTO MySTATION (STATION_ID, DB_VERSION_NU, CREATED_DT, MOD_DT, SHAPE) VALUES (1, 0, sysdate, sysdate, ...
3
votes
1answer
332 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 ...
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
23 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 ...
1
vote
1answer
92 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 ...
0
votes
0answers
11 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
24 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
1k 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 ...
0
votes
1answer
142 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 ...
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
70 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
63 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
106 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
69 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 ...
5
votes
5answers
4k views

How do I build a form within ArcMap?

I am building a file geodatabase using ArcGIS. The gdb is going to be distributed to dozens of 'stand alone' machines. End users are expected to populate the gdb with data. End users do have ArcGIS ...
1
vote
0answers
36 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
0answers
27 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 ...
1
vote
2answers
43 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
202 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
31 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
218 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 ...
1
vote
1answer
41 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
81 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
201 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
20 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
110 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 ...
4
votes
0answers
47 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 ...
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
65 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
981 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
31 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
69 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
48 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
9k 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
1k 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
50 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
105 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
274 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
76 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
5k 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 ...
8
votes
4answers
8k views

Trouble importing Feature Classes into Feature Datasets

I'm sure there must be a simple reason for this but I can't seem to be able to import a shp file or a feature class from another file or sde geodatabase into a Feature Dataset without getting an ...
1
vote
1answer
45 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 ...
17
votes
8answers
5k views

When Versioning with ArcSDE can posted edits be cancelled or rejected?

I am using ArcGIS 9.3.1 and attempting to work with an SDE geodatabase (with one polygon feature class) that has already been registered as versioned. I'm new to versioning and am still trying to ...
1
vote
0answers
19 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
149 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 ...