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

2
votes
2answers
489 views

How to copy selected features from one sde to another using ArcObjects?

Assuming I have two SDEs or other datasources with the same datamodel. One contains features the other one is empty. In ArcMap I have layers from both datasources in my table of contents. Now I would ...
0
votes
1answer
480 views

How to resolve ArcGIS for Desktop Error (SDE has lost its connection with underlying DBMS[ORA-03114:not connected ORACLE])? [duplicate]

How to resolve this issue when user leaves the system idle for one hour and again trying to connect Database, It encounters the Connection error message and then user should close the ArcGIS and ...
4
votes
2answers
418 views

Why to use Add Attachments (Data Management) and not Hyperlink field?

Why should I use Add Attachments and not a hyperlinked field? What are the advantages in case of a lot of layers with a lot of attachments at the GDB? What are the best way to manage attachments for a ...
2
votes
1answer
133 views

Add feature to replica

I create one-way replica from one geodatabase to another. After that, i add new feature class in parent geodatabase. Is it possible to include new feature class in replica, but i don't want to ...
2
votes
3answers
2k views

Can Geodatabase files from ArcMap be imported and used in Qgis?

I'm looking into Qgis and am doing some tests, but one thing I need to be able to do is use geodatabase files from ArcMap and ArcPad. Is that something that can be done and with relative ease? I ...
4
votes
4answers
631 views

How to process large shapefiles faster in ArcGIS for Desktop?

I have huge line and polygon shapefiles that I want to edit with some geoprocessing tasks (clip, buffer, erase,...). Altough my computer is not that slow, I am annoyed of waiting up to 15 hours for ...
1
vote
0answers
92 views

Import related CSVs to geodatabase without losing foreign key relationships

For various reasons I understand it is poor practice to rely upon OBJECTID fields to relate different tables together using a relationship class. Therefore, I have a series of several tables related ...
0
votes
0answers
113 views

How to edit the PGDB data in QGIS

I have a small query regarding the Q-GIS software. I hope someone in the know would be able to answer them. I am using 1.9.0-Master q gis. My datasets are inside a ESRI personal Geodatabase. I am ...
1
vote
1answer
166 views

Enabling Geodatabase from ArcMap 10.1

I have created a sde schema in my postgresql database , I check all the priviliedges and everything. I also put the st_geometry.so in lib path of postgresql 9.1.3 installed on the server. I have ...
4
votes
1answer
108 views

How many geodatabases per ArcGIS Server license?

I need to create and authorize a new ESRI ArcGIS enterprise geodatabase. Our organization has an existing ArcGIS Server license that has already authorized one ESRI ArcGIS enterprise geodatabase. Will ...
1
vote
0answers
70 views

Is there tutorial available for PostGIS setup in ArcSDE 10.1 geodatabase on Linux?

Is there any tutorial for Set up PostGIS in an ArcSDE 10.1 geodatabase on Linux? There is one in tutorial arcgis 9 for ArcGIS version 9, but I couldn't find any for ArcGIS 10.1.
1
vote
1answer
304 views

How to address Geodatabase must be enabled as geodatabase admin user error? [closed]

I am trying to use "enable Enterprise Geodatabase" but I am getting the following error: "Geodatabase must be enabled as geodatabase admin user.Failed to execute " I am using postgresql 9.1.3 ...
3
votes
1answer
229 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
2answers
1k views

“Create Enterprise Geodatabase” errors

I am trying to use " Create Enterprise Geodatabase" option in arcmap 10.1: I am getting two following errors: You must copy the latest ST_GEOMETRY and dependent libraries to the PostgreSQL ...
2
votes
0answers
201 views

GeoDatabase topology and rules with a *.rul file

I have been working for some time on a solution to a problem much like this question. I have several layers that I want to resolve together. I have them all in topology (geodatabase) and have been ...
0
votes
1answer
112 views

Create Layer editing/Analysis in an ArcGIS web map application using Javascript API

I want to make an ArcGIS web map application in which user can select different layers of the published map (data of the layer in Postrgresql) and do some analysis based on layer data.import data to ...
1
vote
0answers
255 views

where to copy ST_geometry.so on Linux server?

I run PostgreSQL 9.2 on an Ubuntu server. Through ArcCatalog 10.1 I can connect to the database (although it is empty right now). When trying to "Enable Enterprise Geodatabase" I get the following ...
0
votes
0answers
118 views

How do I open the GeoDB files on NaturalEarthData's site without ArcGIS?

I'm trying to use the admin1 dataset from the NaturalEarthData website. The site offers this data as both shapefiles and GeoDB. The shapefile attribute data is apparently encoded in Windows-1252 and a ...
1
vote
0answers
121 views

ESRI Versioning: A table doesn't match base table schema

ArcGIS 10.1 sp1 with Oracle 11g I've got a versioned feature class that I have discovered has a base table with a different schema than the corresponding A table. (A + registration_id from ...
0
votes
1answer
219 views

Converting Excel Table to Geodatabase with Repeating Numbers Results in all Zeroes

I'm trying to convert an Excel file to a DBF file. I understand how to do it correctly using the Table to Table tool. However I am having an issue where a column of repeating numbers (labeled ZoneNum) ...
2
votes
0answers
276 views

Copy Domain and Subtype from File Geodatabase

Is there a way to copy the domain from one Dataset to another? I have a series of layers in Dataset A and I want to split the layers in to tiles using the Intersect tool; saving them in Dataset B. ...
4
votes
1answer
86 views

What is the relative popularity of ESRI GDB files vs GDB over RDBMS for custom web apps?

Our organization is interested in knowing the frequency with which people who are using ESRI geodatabases choose GDB files over GDB in relational databases for serving web applications. Opinions and ...
4
votes
3answers
1k views

Using PostgreSQL with ArcGIS

Have mercy ... with Stackexcachange I'm not yet so familiar, so this is initially somewhat opaque. I try to do my best to organize this thread as well as possible. Recently I've started to get WFS ...
3
votes
0answers
154 views

QGIS does not read ESRI Geodatabase correctly

I have a geodatabase from the EPA that does not seem to me reading correctly with Quantum GIS. When I open the attribute table the first two columns have the same data. The first column is CERCLA_ID ...
1
vote
2answers
1k views

ArcSDE 10: How to read/write to Oracle with ST_GEOMETRY using Java

I found the following in the deprecation plan of ArcGIS 10.2: ArcGIS 10.2 will be the last major release to support the ArcSDE SDK with the ArcSDE C and Java APIs. Today many other options are ...
3
votes
1answer
2k views

ArcSDE 10.2: How to enable and create Geodatabase in Oracle without ArcGIS Desktop

Since there is no Post Installation Wizard anymore in ArcSDE 10.2 - how can i enable und create a geodatabase in oracle without ArcGIS Desktop? We have only an EDN description for ArcGIS Server/SDE, ...
1
vote
1answer
284 views

Migration from .gdb to .mdb - how to change automaticly all querys at MXD from “ ” to [ ]?

after migration from File Geodatabase (.gdb) to Personal Geodatabase (.mdb) - how to change automatically all field names at query definitions at the MXD from " " to [ ] What's else is important ...
1
vote
0answers
124 views

CREATE Script for Enterprise Geodatabase?

I have an ArcGIS For Desktop license, and we have a PostgreSQL 9.2/PostGIS 2 database server running in our network. We currently use Query Layers to add the PostgreSQL data to ArcMap sessions. We ...
0
votes
2answers
329 views

How to convert shp to PostGIS dump?

Given a file my_file.shp such those from Gadm e.g. US administrative divisions, where the coordinate reference system is latitude/longitude with WGS84 datum. Input could actually be: Shapefile, ...
1
vote
1answer
97 views

How can I convert files from a county government to shapefiles?

I work for a company that creates software for multiple listing services and real estate agents. We're expanding our coverage area into a new market, and I've been given some files for two different ...
6
votes
1answer
419 views

Is this possible with ArcGIS using replication?

I work for a telecom company dealing with fiber management. We have a sister company south of us who we share some fiber and fiber equipment with. Both of us will be using ArcSDE databases. We want ...
2
votes
2answers
66 views

How to begin creating a linear referenced gdb with NHD

Our legacy fish distribution data contains data by reaches. Reaches are arbitrary locations on streams, eg. reach 1, 2, 3. Each reach's from-to are known, but not by x,y coords. An example is 'brown ...
1
vote
0answers
237 views

Replicas: Synchronize changes for individual feature class (not entire replica)

I have two ArcSDE databases, running with a two-way replica.One serves our interactive mapping website which gives certain users the ability to update, add points, edit attributes, etc. Then we have ...
2
votes
1answer
166 views

Cartographic Representation: how to use different rule for different polygon?

I create a file geodatabase to hold a polygon of the land boundary. What I would like to set up the RULE to separate colors. I had to split the polygons into 2 separate polygons and change the ID to ...
2
votes
1answer
57 views

Can I make an ESRI checkout replica from a checkout replica?

If I create a checkout from a clients geodatabase, can I then turn around and put that replica on our ArcGIS Server and create a couple replicas from it? So, then, our replicas would be synced to the ...
2
votes
1answer
239 views

How can you tell if a RDBMS is an ArcSDE Geodatabase?

I want to know if there is any way I can query the RDBMS to determine whether it is an ArcSDE Geodatabase, or if I have to do it through ArcObjects. I am wondering if it would be enough to check if ...
4
votes
2answers
613 views

Execute SQL in File Geodatabase

Is there a way to execute SQL queries on file geodatabase from Python? I'm looking for the same functionality provided by arcpy.ArcSDESQLExecute for SDE databases. Thanks,
2
votes
1answer
131 views

Renaming shapefiles with prefix while running arcpy.FeatureClassToGeodatabase?

I'm fairly new to the arcpy world. I am trying to create a script in 10.0 that will load a dataset (file geodatabase) into ArcSDE and rename the feature classes with a prefix, i.e. San_Diego_Bay -> ...
2
votes
0answers
353 views

Publish ESRI Feature Services from spatial view on ArcGIS Server 10.1

I have a feature class layer and a handful of non spatial plain tables in a 10.1 SDE geodatabase on MS SQL Server. What I want to achieve is to publish a feature service from ArcGIS Server so as for ...
2
votes
0answers
228 views

ArcPy x64 - Create Enterprise Geodatabase in SQL Server Fails

I'm using ArcGIS Desktop Standard 10.1 SP1 on Windows 7 SP1 x64. SQL Server Native Client 11.0 is installed for both 32 bit and 64 bit. I've also got SQL Server 2012 x64 installed (client tools and ...
1
vote
1answer
190 views

How to Change the schema of SDE dataset in Connected environment

We continuously use to receive changes in Schema ( field +/-, domain changes etc ) for our Utility dataset.. Since we have swicthed to a multiuser Geodatabase ( ArcSDE on Oracle ) , we would like to ...
1
vote
0answers
37 views

ArcGIS importing from file geodatabase A to B without stopping service

I have file geodatabase B which is use by arcgis server as a data store and on a schedule interval I need to import new data from file geodatabase A. geodatabase need to be wiped and accept the ...
2
votes
4answers
1k views

Export to a Shapefile and maintain Domain Coded Values

I maintain a complex parcel fabric that uses coded value domains for a few fields. These are short integer fields with values from 1 - 6. These values represent say 1:Integrated Registered Survey ...
6
votes
2answers
172 views

Survey Data to GIS database

This is a General Question on a possible workflow for Survey Data directly to ArcGIS In most GIS/Survey workflows there is a field collection team and backoffice GIS team. When the availability of ...
-2
votes
1answer
59 views

Editing problem [closed]

I am working in ArcGis 10.0 , when i am selected Sketch tools for digitization like road feature after digitize single for second digitize for feature required a select again create feature road for ...
3
votes
2answers
462 views

How to add data to relationship table in ArcGIS 10.1 database design?

I have created 2 tables HORSE and VENDOR and a relationship table VENDOR_HORSE With the foreign key in Horse being the Primary key in VENDOR (VendorID) and the foreign key in VENDOR being the primary ...
1
vote
2answers
7k views

How to open a map from gdb?

A librarian has helped me create some maps, and I need to open them. He is off work at the moment and I am in a rush for this. I have downloaded ArcGIS and he says I can open this with arcMAP. He has ...
4
votes
0answers
988 views

How to open a ESRI geodatabase in QGIS (Ubuntu)?

So far I have found instructions on stack exchange but they are for windows. And so far the information I have found is for windows. I currently have Ubuntu 13.04 Raring tail. I am using qgis 1.8. I ...
4
votes
2answers
786 views

How to Make a File Geodatabase Unlockable

I have several replica File Geodatabase's on my server. I publish maps to be viewed by other departments in ArcReader. These ArcReader pmf's use the replica Geodatabase's on the server. I need to ...
3
votes
2answers
318 views

Explicitly locking a file geodatabase

I need to lock a file geodatabase (or only a single Mosaic dataset) at the beginning of a python script (and release it in the end).. I looked and looked and couldn't find any explicit arcpy command ...