ESRI geodatabase is a particular database schema designed by ESRI for managing "layers", "versioning", "topology" and other ESRI application specific storage requirements.
5
votes
1answer
159 views
Changes in synchronized replica not shown in ArcMap or ArcCatalog without refreshing
I am synchronizing a one-way replica in ArcEditor using Python. I tried adding RefreshActiveView and RefreshCatalog to the code, but I still need to refresh the synchronized database to see the ...
3
votes
1answer
73 views
Running Regular Queries Through ArcSDE
Working on an .net arcobjects app that's connecting to a Geodatabase (Oracle) through ArcSDE. I make a bunch of edits inside a EditSession but the data I am touching have a bunch of foreign Key ...
2
votes
1answer
66 views
Setting up file geodatabase API
Can someone point me to a guide for setting up the file geodatabase API? I'm using Visual Studio Express 2012.
I can deal with writing and debugging the code - I just can't seem to figure out how to ...
2
votes
1answer
26 views
Importing labels for check in/out from an SDE to file geodatabase
I am working on a large project where I am using the ArcMap 10 'distributed geodatabase' feature to check out a file geodatabase from our SDE file. I have tried several ways to avoid having to ...
2
votes
1answer
591 views
How to edit a given version of geodatabase?
I have a versioned geodatabase. Any of that versions are used only by one user. So then user called "XXX" has a version called "XXX". So then now I want to make a changes on given version, but when I ...
1
vote
1answer
727 views
How to open a file geodatabase with tables and relationships in QGIS?
How can I open or connect to an ESRI file geodatabase in QGIS? I don't want to only see the features (shapes), I want to make sure that tables and relationships are opened correctly, too.
Thanks in ...
0
votes
1answer
17 views
Migrating Lines to ArcGIS polyline
I'm trying to import geometry lines from Oracle Spatial database to ArcGIS enterprise geodatabase.
and some data will cause the error.
Its says not enough points for feature class, but when I look ...
0
votes
1answer
28 views
Global DEM and country borders
I am trying to split up the world into 2 categories based on elevation (below 2000m and above 2000m) while still including a country identifier. So in the end, I would like to have 2 types of units ...
5
votes
0answers
97 views
Why do file geodatabase and SDE readers produce different fme_geometry types?
I have one very simple workbench that I am running against both SDE (9.3) and FGDB (10.0) sources.
I noticed two different fme_geometry values for same type of objects.
For the first one, i.e SDE ...
5
votes
0answers
149 views
Plugin Workspace: when to close an OleDbDataReader?
I'm developing a plugin workspace for ArcGIS. Internally, the plugin uses an OleDBconnection. All of the sample code I see seems to stress the importance of closing and disposing the connection.
...
5
votes
0answers
117 views
Applying schema changes on a 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 ...
4
votes
0answers
53 views
Importing existing data model into geodatabase
How can I integrate an existing ArcGIS datamodel like Arc Marine into my geodatabase? I dont have schematics in my ArcGIS 9.3.1.
4
votes
0answers
195 views
mdb geodatabases in QGIS for MAC
Good afternoon,
I've been unsuccessfully looking for a way to add data from a .mdb geodatabase into QGIS for mac.
Using the add vector layer, .mdb is not available in the filetypes, and in the ...
4
votes
0answers
48 views
How to split Relationship Class privileges between different users while maintaining referential integrity?
I am using a relationship class to maintain a one-to-many relationship between material sites (under Engineering's purview) and the material sites' sample status and content (under Materials' ...
4
votes
0answers
246 views
Creating a VB.net Dataset in Visual Studio 2010 from an SDE Geodatabase
I am building an ArcMap Addin that contains several Windows Forms with controls that need to be bound to a database. I am trying to decide whether or not to use a native SQL Server Database or an SDE ...
3
votes
0answers
30 views
One-to-many relationship classe(s)/table(s) used for monitoring
I realize that this may be a bit simplistic for this blog, so I apologize in advance. However, for someone with a working knowledge of ArcGIS, I've had issues figuring this out on my own.
I have a ...
3
votes
0answers
226 views
Error opening feature class from SDE (which can be opened in another application)
We're using ArcGis 10.1 with ArcSDE 9.3.1 on Oracle 10g.
I've got 2 layers that cannot be opened or modified with ArcCatalog or ArcMap (but they show up in the list. Everything worked just fine ...
3
votes
0answers
394 views
How to load data programmatically from shapefile into feature class (geodatabase)?
Can some Genuis here help me programmatically (using python and comtypes) load shapefile data in to an existing geodatabase (feature class). The attributes of the shapefile has to match with the ...
3
votes
0answers
47 views
ESRI Maps with Ravis Visual graph
How can we integrate ARCGIS maps with Ravis Birds eye's Visualgraph ?
My intension is to place the ravis visual graph over the map and the nodes of the visual graph must be placed on their specific ...
3
votes
0answers
139 views
SDE Topology dirty areas don't go away
Just looking for an explanation on SDE Topology dirty areas that don't go away. My workflow involves editing a version of SDE data, then once finished I use the Validate Topology in Current Extent ...
2
votes
0answers
28 views
AutoCAD map server's text to ArcGIS Annotation - SAFE FME
autocade
Software: SAFE FME
Geodatabase - enterprise geodatabase
we have autocad data stored in oracle database and wishes to port them over to ArcGIS Annotation (text).
We are unable to do so just ...
2
votes
0answers
25 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 ...
2
votes
0answers
64 views
Can I use an Update cursor with a versioned feature class which has attachments in ArcObjects .NET
I have a problem with my code (C# ArcObjects 10.1). We are trying to update and insert 10 - 15 rows at a time into a feature class hosted in ArcSDE 10.1 on SQL Server 2008 R2.
We have a feature class ...
2
votes
0answers
74 views
How to copy a feature class within the same GDB
I'm trying to copy/clone a feature class within the same file gdb using C#.
I've figured out that this won't work with IDataset or IFeatureDataset.
So far I only found IGeoDBDataTransfer.Transfer but ...
2
votes
0answers
65 views
Problem looking at tables within ESRI geodatbase
I installed the most recent OSGeo4W with QGIS 1.8.0 and GDAL 1.9.2 on my Windows 7 PC.
I can load an ESRI geodatabase (.gdb file) and I can get the window
"Select vector layers to add".
When I click ...
2
votes
0answers
180 views
Create ESRI ArcSDE Connection File (.sde) using Python/ArcPy at the ArcView license level?
Is there an alternative way to create ArcSDE connections in ArcGIS 10.0 using Python at the ArcView license level? I need to create 4 separate connection files for a MXD SDE data source re-point tool. ...
2
votes
0answers
212 views
How to get WKT from SHAPE column in the ArcSDE geodatabase?
I have an ArcSDE geodatabase running on top of SQL Server 2008. A table for a feature layer was added from ArcCatalog. The SHAPE column is a type of int which was automatically converted from ...
2
votes
0answers
863 views
IFeatureWorkspace.CreateFeatureClass() error
I am trying to read a csv file straight into a set of new feature classes within a new file geodatabase, but I am getting the following stack trace when it fails:
Attempted to read or write ...
1
vote
0answers
30 views
How can I import data from an Oracle datapump into an empty Oracle SDE Geodatabase?
I have a SDE Geodatabase that contains empty layers created using ArcCatalog.
I'd like to import data into those layers from a datapump of an Oracle database that has the same structure as the empty ...
1
vote
0answers
34 views
Can i use self join in a table of feature class(ArcGIS - ArcInfo)?
I read an article about self join (pros and cons) in databases. It was very interesting for me and raised a question about self join in Geodatabases. I surfed on the internet but I couldn't find any ...
1
vote
0answers
24 views
How do I link an existing install of GDAL to FileGDB in Linux?
The distribution I use (CentOS) only has GDAL 1.8 available through elgis. I've downloaded the FileGDB API from ESRI and I'd like to be able to link it after an install. How can I do this?
1
vote
0answers
28 views
How do I prevent Arcmap from verifying SQL expressions when using a plugin dataset?
I've written a plugin workspace for ArcGIS.
I'm able to compose a where clause containing syntax that my implementation of IPluginDatasetHelper understands, assign it to IQueryFilter.Whereclause, and ...
1
vote
0answers
45 views
ogr2ogr Convert to FileGeoDatabase FGDB_BULK_LOAD YES makes no difference
I am trying to export a lot of data from a PostGIS database to a FileGeoDatabase.
The command I used to use was
ogr2ogr -progress -append -f "FileGDB" -gt 66536 -sql "SELECT * FROM line" ...
1
vote
0answers
72 views
Automatic attribution of one layer from another based on spatial relationship?
I have two layers with a 1:many relationship. Working within ArcMap, I'd like to have that relationship somehow formalized so that when I add a new feature to the child layer, it automatically gets ...
1
vote
0answers
91 views
Clipping .mdb in place and schema locks
I have an .mdb with a feature class that I want to clip in place - that is, I want to clip it with another polygon, and then store the results back in the original .mdb. I am doing this with arcpy. My ...
1
vote
0answers
107 views
Replicate ESRI ArcSDE Geodatabases in Google Earth Enterprise Fusion
Can we setup an automatic replication of an ArcSDE geodatabase into a Google Earth Enterprise Fusion periodically - weekly/monthly? The replication needs to be performed one way - from ArcSDE to ...
1
vote
0answers
62 views
How to protect my application ESRI FGDB data from authorized access using other applications?
I have ArcObjects app which uses file geodatabase for storing data and performing CRUD operations. This file geodatabase needs to be protected from reading data in other applications such as ArcMap, ...
1
vote
0answers
234 views
SQL sub query syntax does not work on versioned tables without base option- Modified
My original question asked why the where clause below, which includes a sub query, would not work on an SDE database but the same query against a file geodatabase would work. I had thought the ...
1
vote
0answers
211 views
ArcSDE geodatabase for non-spatial data
I have a table stored in an SDE geodatabase for all point features with an additional GEOMETRY_ID. A few non-spatial data tables are stored in an ordinary MS SQL Server database. They can be joined by ...
1
vote
0answers
115 views
Opening File GDB in Samba throws exception - but only in VS2010 debug mode
I'm accessing a file geodatabase through a mapped network drive pointing to a unix machine running Samba.
When I start the app from within VS2010, I get a COM exception when I attempt to open the ...
1
vote
0answers
208 views
Does anyone know a script to make annotation & point data remain constant regardless of scale
I have a series of maps to create for a project (30+ maps). The maps will be at varying scales (roughly between 1:1000 and 1:6000). I have a geodatabase containing various annotation and point ...
1
vote
0answers
249 views
Exporting layer selection to a file GDB
I have over sixty layers in a map. These are all grouped by categories. I am trying to figure out the best way to export all the layers for a given selection to a file geodatabase and also maintain ...
1
vote
0answers
268 views
Intersecting with Geodatabase.ISpatialFilter - no results
I'm trying to intersect two layers and get resulting features with the following code I've written:
ESRI.ArcGIS.Geodatabase.ISpatialFilter spatialFilter = new ...
1
vote
0answers
231 views
topology rules for structuring topology data to get line feature as topoparent in topology graph
i Created topology graph of a polygon feature and i copied geometry of topology edges into line feature class,and topology nodes into point feature class
i created topology layer containing ...
1
vote
0answers
430 views
ESRI: ADF + Geodatabase
I'm a .NET Develop. I'm using ESRI / ADF and I have a problem whit some methods of Geodatabase. On the beginning of development I needed connect on GeoDB and execute queries. On this moment I got this ...
0
votes
0answers
15 views
Oracle Feature Class Couldn't Displayed
I got problem on displaying feature class in Oracle, which successfully imported from file geodatabase using Append (Data Management) Tools, my experiment on copying it to Postgre no problem on ...
0
votes
0answers
42 views
copying and pasting files - geodatabase
I have been sent a zipped folder containing files in a geodatabase format. To view them in ArcMap I've created a new file outside
ArcCatalog with the extension .gdb and copied the unzipped files into ...
0
votes
0answers
34 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 ...
0
votes
0answers
19 views
A procedure imported by 'Esri.FileGDBAPI.DLL' could not be loaded
I'm having issues getting my Esri.FileGDBAPI.DLL to work. I have the other two files, FileGDBAPI.dll, FileGDBAPID.dll in my bin folder. I can only add the Esri dll to my references, the other two I ...
0
votes
0answers
56 views
How to Export a Geodatabase with Subtypes and Domains to Microsoft Access Without Losing Information?
I want to export a geodatabase file with all subtypes and domains values to open in Microsoft Access without losing any information.
