ESRI geodatabase is a particular database schema designed by ESRI for managing "layers", "versioning", "topology" and other ESRI application specific storage requirements.
17
votes
5answers
4k views
How to migrate GDB data into PostGIS without ESRI apps?
Can you tell me how I can load geodatabase data into PostGIS without having to install ESRI apps? The solution I found online talked about using ArcGIS to convert GDB to SHP and then importing SHP to ...
14
votes
1answer
1k views
What are Esri Geodatabases?
What are the various formats/storage technologies which fall under the name Esri Geodatabase?
What are the most important differences between them?
and (briefly) what are the mainstream means to ...
14
votes
7answers
4k 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 ...
14
votes
2answers
469 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 ...
13
votes
2answers
6k views
How to access file geodatabase in Qgis?
How does one access data from an Esri file geodatabase in Quantum GIS?
I've seen snippets of conversation that indicate it's possible with qgis 1.7+ and gdal 1.9+ but no clear recipe.
I recognize ...
12
votes
6answers
3k views
Bulk field rename in file geodatabase
I have a file geodatabase with several hundred feature classes in it.
Some feature classes have a field that got named incorrectly, and it got named "SCHEMA_FEATURECLASS_ENTITY" instead of just ...
12
votes
3answers
140 views
How to compare schemas from two File geodatabases?
We have template geodatabase, which we send out to our regional Data creators. They update these geodatabases and digitize all the data from their region in the predefined featureclasses.
Now that we ...
12
votes
1answer
226 views
How do you organize your geodata?
A geodatabase doesn't provide much flexibility in organizing your data hierarchically. All feature sets live either at the top level of the database, or one level down in feature datasets. A feature ...
11
votes
7answers
3k views
Versioning with ArcSDE - Is it possible to cancel or reject edits once they've been posted?
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 ...
11
votes
2answers
497 views
When is it safe to use ObjectIDs as keys in a relationship class?
I've always avoided using ObjectIDs when defining relationship classes. It is my understanding that some actions on a geodatabase will re-set objectIDs (like import/export). However I do see a lot ...
10
votes
5answers
421 views
Should I use File Geodatabase (*.gdb), Personal Geodatabase (*.mdb) or shapefiles?
I am a bit confused on the topic of databases. For me, this far, I have used databases as an easy way to keep all files together rather than having dozens of shapefiles all over the place. And it's ...
10
votes
4answers
2k views
Best practicies when employing a file geodatabase that is going to be used and edited by multiple users?
I have a file geodatabase that contains 3 feature classes in it and each feature class contains a lot of data that will be viewed and edited daily by 6 other users. I am looking for any advice from ...
10
votes
3answers
4k views
What is the difference between FID and OID
What is the main difference between OID and FID in ESRI software?
10
votes
4answers
630 views
Performance - using multiple file geodatabases as opposed to one
I'm trying to decide the best way to organize my data for an ArcEngine application. I am particularly interested in map display and query speed. Currently I have all of my data separated into separate ...
10
votes
5answers
2k views
What is the easiest way to copy a domain(and only the domain) between Esri geodatabases?
Sometimes I have the need to copy a domain(s) from one geodatabase to another (without the featureclass or table).
In the past, I have accomplished this in a few different ways, but each method is ...
10
votes
3answers
2k 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 ...
10
votes
2answers
462 views
Are personal geodatabases better suited for quickly querying indexed attributes than file geodatabases?
I'm preparing data for an ArcEngine application that queries the data to search for an address. Sometimes we search just on the street name field, just on the house number field, or both. When using ...
9
votes
2answers
2k views
manipulate file geodatabase like an access personal geodatabase?
Is there any way to interface with features, but more specifically their attributes, in a file geodatabase like you can in a personal geodatabase?
Frequently I will just open a personal geodatabase ...
9
votes
1answer
435 views
How to get the size of a file geodatabase feature class on disk?
Is there a simple way to determine the amount of hard drive space a feature class takes up? I feel like I'm missing something simple, but I don't recall a method that does so. You would think that ...
9
votes
2answers
2k views
How to import esri Personal Geodatabase (.mdb) to PostGIS on Linux
We have esri Personal Geodatabases that we need to import into PostGIS.
Ultimately, we'd like to allow people to upload an MDB on a web server, and have it import the layers into PostGIS.
On ...
9
votes
2answers
775 views
What is the proper way to backup an ESRI File Geodatabase that is published to ArcGIS Server?
I have an ESRI file geodatabase (v10) that is published to an arcgis server map service. When the service is running, the fGDB is locked. Do I need to stop the service to get a clean backup? Or, is ...
9
votes
1answer
318 views
Is it possible to maintain primary keys on versioned featureclasses without arcobjects code?
Since it is not a good idea to use ObjectIDs as primary keys in relationships, some other column will need to be used. Is it possible to use DBMS sequences to populate primary key columns in ...
8
votes
2answers
126 views
How to efficiently (programmatically) determine whether two datasets have / don't have identical content?
Given:
a geodatabase A that contains 100 datasets named a1 .. a100
a geodatabase B that contains 100 datasets named b1 .. b100
I want to programmatically (*) determine for each dataset pair (ai, ...
8
votes
1answer
301 views
What qualifications should an auditor have if they plan on auditing a GIS?
Background summary: Various systems are being audited and GIS is the next to be audited. The initial kick-off for the audit was a meeting between me and a single auditor. Initially, I thought it was ...
7
votes
3answers
3k views
How do I change the data source for all layers in an MXD?
I have an MXD. It connects to about 30 layers in one of our SDE databases. I want to change the SDE database they connect to. Is there a way to do this without having to right-click every layer and ...
7
votes
2answers
7k views
How do you create 9.3 version of a geodatabase in ArcMap 10?
Under the What's new for geodatabases in ArcGIS 10 Esri talks about an optional parameter that allows you to create a 9.3 GDB [GeoDataBase] in version 10. I can not find any other info. Any help on ...
7
votes
4answers
1k 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 ...
7
votes
3answers
2k views
How to import/export geographic information (gml or csv file) to geodatabase?
I am searching for C#/Java libraries that can import and export geographic information (gml/csv file formats) from and to geodatabases.
If not yet available, is there other way to do this task?
Any ...
7
votes
2answers
822 views
Automatic batch update a file geodatabase from shapefiles
Every week I need to update the same shapefiles that are used to produce up to date maps. The files are downloaded from 3 different web-servers.
The thing I want to do is to have a script that can ...
7
votes
2answers
642 views
FileGDB open API and tools based on it
As we know esri shared their library which makes it possible to work with FileGDB format without using ArcObjects. So the question is what kind of applications could be created in order to help GIS ...
7
votes
3answers
1k 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 ...
7
votes
1answer
236 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 ...
7
votes
2answers
2k views
Issues with large datasets
I am trying to run an Intersect process in arcgis 10 sp 3 with 2 file sets (aspect and slope) from up to a 1m DEM across an area of 65,000sq km. The aspect has 9,930,384 records and the slope has ...
7
votes
1answer
650 views
Is there a fast way to copy large raster datasets between File Geodatabases?
Why does it take so long to copy a large raster dataset from one file geodatabase to another? I can copy the entire database in windows explorer in minutes but copying a single raster in ArcCatalog ...
7
votes
2answers
220 views
.Net Solution Structure for ArcObjects and Geodatabase programming
OK - I understand that this is a bit subjective - but you're the best community forum I've got!
So, we are talking about starting a fresh customisation for ArcGIS or a Windows app using Engine.
I ...
7
votes
1answer
190 views
Differences between Raster Dataset, Raster Catalog, and Raster Mosaic
I have about 40 scanned, colorful Geology maps that are GeoTiffs. I want to bring them into an Esri FileGeodatabase to lower their size, combine them as one and display them with a mostly transparent ...
7
votes
1answer
558 views
How to create a 9.3 file geodatabase with ArcObjects SDK for ArcGIS 10?
In ArcGIS 10 I could use the Create File GDB geoprocessing tool to create a 9.3 file geodatabase or the Create Personal GDB geoprocessing tool to create a 9.3 personal geodatabase.
But I cant't find a ...
7
votes
3answers
286 views
Changing a coded Domain to no codes
If we have coded domains in the geodatabase model, what are any disadvantages to changing the codes to the Description. For example:
Existing Coded Domain:
Code, Description
1, Single Family ...
6
votes
2answers
731 views
Creating geodatabase from CSV using python
I have a file with weather data (daily) for multiple weather stations for multiple years. I am looking for some python script to automate the database creation process and its interpolation on a daily ...
6
votes
5answers
1k views
Running ARCgis 9.3.1 and 10.0 on the same machine
I have the full installation Media for 10 (9.3/SQL05 already loaded). And two editor licenses (one loaded and a new license file). What manner of wizardry is involved in getting around the conflict ...
6
votes
4answers
763 views
difference between Simple and Attributed relationship classes?
In the esri geodatabase, what is the difference between Simple and Attributed relationship classes?
6
votes
2answers
387 views
How is the default label field chosen by ArcMap?
I have 2 questions:
I know how to manually go to Layer Properties>Labels tab>Label Field and choose my label field. I also know that I could set up my primary label field and save the setting as a ...
6
votes
1answer
87 views
What are the differences between Append and load data in ArcGIS?
I confused about differences between Append tool in Arctoolbox and Load data in Geodatabase.
I think both of them are the same in the result feature class.Both of them use a default output feature ...
6
votes
3answers
103 views
How to mirror two geodatabases on the fly?
I'm new to arcgis and its applications.
We have the full suite of arcgis solutions (arcgis server, desktop, arcgis sde)
We have a requirement...
geodatabase (A & B)
A & B reside on 2 ...
6
votes
2answers
2k views
How to add feature class from ESRI personal geodatabase (.mdb) in QGIS
How do you add a feature class in a ESRI personal gdb in qgis. I understand this can be done through the option add vector layer and select geodatabase. But what after that ? It doesn't allow me to ...
6
votes
2answers
161 views
How can I reduce the size of my file geodatadase?
We're using file geodatabase for tax mapping. we save building photos and there are 6000 buildings. The size of this data 2GB. So loading the data takes a lot of time we are not unable to do work ...
6
votes
1answer
320 views
FME - Can I write back into my original file geodatabase
I have a gas pipeline network which I have stored in an File Geodatabase as polylines. I've created an FME workspace to split the pipelines at fittings (valves, reducers, tees, etc) which are stored ...
6
votes
1answer
308 views
How to programmatically determine the size of a feature class in a file geodatabase?
My answer to the question How to get the size of a file geodatabase feature class on disk? shows how one can enable a column in ArcCatalog showing the file size of FGDB feature classes in the contents ...
6
votes
1answer
136 views
How is IValidate.GetInvalidRules supposed to work?
we are currently trying to programmatically validate features against geodatabase-defined rules. This includes attribute rules as well as connectivity and relationship rules.
We have consulted the ...
6
votes
1answer
307 views
Can I update features in an SDE database from python without using an ArcEditor License?
I have a non spatial data set that I would like to keep sync'ed in SDE as a spatial set. So I would like to be able to insert, update, and delete without using one of my two ArcEditor licenses since ...
