Questions tagged [esri-geodatabase]

Esri geodatabase is a database schema designed by ESRI for managing feature classes, versioning, topology, networks, terrains and other Esri application specific storage requirements.

Filter by
Sorted by
Tagged with
8
votes
3answers
1k views

Can primary keys and foreign keys be used in versioned geodatabases?

I've been brushing up on relational database design theory, and I keep coming across primary keys (PKs) and foreign keys (FKs). PKs and FKs are said to be pillars of relational database design and ...
3
votes
2answers
646 views

Batch copy a geodatabase

I'm trying to write a batch command (Windows 10) that will copy an ArcGIS geodatabase to a new folder. I know this may seem like bad practice but it is part of a much larger project creation process ...
1
vote
3answers
333 views

Merge shapefiles into geodatabase in ArcPy

I am trying to merge a number of shapefiles with the following code: import arcpy, os, datetime #Set working directory cd = r"C:\Users\..." arcpy.env.workspace = cd os.chdir(cd) arcpy.env....
6
votes
4answers
1k views

Does the OBJECTID in an Oracle Geodatabase table have a primary key constraint, by default?

Tables that are created in Oracle using ArcGIS Desktop are given an OBJECTID field by default. The OBJECTID field is assigned a unique not-nullable index. Does the OBJECTID in an Oracle Geodatabase ...
1
vote
0answers
860 views

FileGDBAPI.dll not registering in Windows 7 x64 [duplicate]

I installed GDAL via wheel (32 bit). Added it to my system path. Also added an environment variable GDAL_DRIVER_PATH pointing at my gdalplugins folder (on my system, C:\Python27\ArcGIS10.4\Lib\site-...
4
votes
2answers
315 views

Refresh linear referencing layer that's based on a database view, without closing ArcMap

Background: I have a linear referencing event layer that was created using the Make Route Event Layer geo-processing tool. The Input Route Features are in a standard feature class, but the Input ...
1
vote
0answers
86 views

ArcCatalog import geodatabase xml schema: domain name conflict

I've exported a geodb xml schema "A" with ArcCatalog from a file geodatabase in order to import it into a sde geodb in Oracle. I've created a geodatabase with the "create enterprise geodatabase tool" ...
3
votes
2answers
85 views

Seeking 3rd party / API way to access exported ArcGIS/Esri style information?

I am writing a GIS app that allows import of various file formats, and I want to include an importer for data coming out of ArcGIS. My understanding was that Geodatabase was the default format for ...
0
votes
1answer
229 views

Does Esri Geodatabase contain style information?

I've downloaded the C++ API SDK for reading/writing Geodatabases from: http://appsforms.esri.com/products/download/ I don't know much about this file format and how it relates to ArcGIS's internal ...
4
votes
1answer
1k views

FME How to read multiple CSV files from many folders and write to GDP tables by folder

I have 13000+ CSV files, all containing around 13000 rows. These CSV files are arranged in 146 different folders. All CSV files have the same schema with ; as separator. These CSV files contain about ...
2
votes
2answers
475 views

Converting data from geodatabase to latitude and longitude format

I am computer science student with no experience in Geographic information systems. I am trying to convert a geodatabse National land cover database to a latitude and longitude format. This database ...
1
vote
0answers
52 views

What's the best way to represent a Year field in Enterprise Geodatabase & Web AppBuilder?

I have a Fiscal Year Start field in a Feature Class which is shared as a Feature Service in a Web Map > Web Mapping Application (built with Web AppBuilder) workflow. The field must only contain 4-...
3
votes
4answers
3k views

List of all fields and their domains for each table using SQL (table name, field name, domain name)

I'm trying to list all fields (in all tables in an Oracle geodatabase) and the coded value domains that they use. +------------+------------+-------------+ | table_name | field_name | domain_name | +-...
2
votes
1answer
291 views

Cleanly recreate 10.3 enterprise geodatabase in Oracle 12c

Recently I created an enterprise geodatabase on a virgin Oracle 12c instance, using ArcCatalog. I eventually dropped the SDE schema and attempted to recreate the enterprise geodatabase. Now I get the ...
6
votes
1answer
2k views

What does the shape_length field of a polygon represent?

I have some irregularly shaped polygons existing within an Esri geodatabase. What does the 'shape_length' field represent geometrically? i.e. Does it represent the furthest distance between two points?...
6
votes
1answer
6k views

Using the MOD expression on an SQL Feature Class is not possible?

I use the MOD expression quite frequently in my definition queries in ESRI to extract fields that are divisible by a specific vale for example: MOD( [contour], 50) = 0 OR contour = MOD(0, 50) ...
5
votes
1answer
1k views

What is Diffrent Between Version & Replica In ArcGIS Geodatabase

I know Versioning allows multiple editors to alter the same data in an enterprise or workgroup geodatabase without duplicating data and Geodatabase replica allows creates copies of data across two or ...
1
vote
0answers
209 views

Feature class' default domain for a field is still locked to an older domain

I have a field within a feature class that I had assigned a coded text domain to, but then created a different coded text domain with updated information that I then pointed to as my new domain ...
0
votes
1answer
258 views

Using enterprise geodatabase with ArcGIS Online?

I need to create an online map using ArcGIS Online. The data is stored in an enterprise geodatabase. Can I add the data to a map directly from the geodatabase? If not, what's the best way to ...
2
votes
1answer
447 views

Getting EPSG from Feature Classes of Geodatabase?

Where can I find the EPSG code of a Feature Class?
3
votes
1answer
854 views

What are the options for accessing Oracle geodatabase data using full-blown SQL?

In ArcGIS Dektop, I can use SQL expressions to query enterprise geodatabase data (expressions are essentially the WHERE clause in a query). I'd like to do more than this. I want to use the full ...
0
votes
2answers
2k views

Reducing number of point features considering minimal distance and spatial distribution [closed]

I have a certain number of generated node features using FME 2016. They are coming as output of one FME workbench and actually representing characteristic points of underground cables. Total number of ...
1
vote
0answers
97 views

Why does an empty, non-spatial table get flagged as Is_Simple=False in an SQL query?

I've created an empty table in an Oracle geodatabase. It was created in ArcCatalog by using the catalog tree >> New >> Table tool. The table is registered with the geodatabase and is not registered as ...
2
votes
1answer
826 views

Schema Locks Grayed Out

Schema locks are not showing up in the Oracle Instance when viewed using ArcCatalog. Data is being using in different applications but for some reason I'm not able to view the locks as the data owner/...
4
votes
1answer
334 views

Reading ESRI Geodatabase Metadata with QGIS

I have used the ArcMap tool to create a geodatabase in an Postgres/PostGIS database and have loaded a feature class and an XML file that contains metadata for the feature class into the geodatabase ...
1
vote
1answer
578 views

Create a table that is not registered with the geodatabase

I am doing some testing that requires having a Oracle table that is not registered with the geodatabase. For instance, Adding an Incrementing ID Field can only be performed on a table that is not ...
1
vote
0answers
84 views

Create a Map scale for Geodesic circles

I need some guidance. I'm using an ESRI Base Map with Web Mercator projection(Wkid - 102110) in an web application using JavaScript. I'm drawing geodesic circles on the Base Map for a given radius ...
1
vote
0answers
796 views

Slow SDE Feature Class Performance

I've been experiencing slower than usual performance (noticeably slow time to draw as well as query, compared to similar feature classes) with a specific feature class in my organizations enterprise ...
3
votes
1answer
328 views

Not getting all decimal places when converting numbers to string (ArcObjects with VB .Net)

I would like to build some queries in my addin from layers in my map. I am having problems with double numeric types. esriFieldTypeDouble has 14 - 18 decimal places or more depending on the database ...
3
votes
1answer
171 views

Where are replicas stored in the Geodatabase?

I'm trying to verify that "unregistering" a replica from the Manage replicas dialog does, in fact, delete the replica. I looked for a table pertaining to replicas, but all I see is GDB_REPLICALOG. I ...
3
votes
1answer
744 views

Get domain descriptions for multiple fields using SQL

How can I get domain descriptions for multiple fields using SQL? I have successfully used the Oracle SQL in this ESRI document: Resolving domain codes to description values using SQL. But how do I do ...
1
vote
1answer
791 views

Using Editor tools in Arcpy script

I would like to create a custom merge tool that merges 2 polygons within 1 feature class together. I want to have a tool that merges 2 polygons and adds up a specific attribute. Is there any way to ...
0
votes
1answer
100 views

ESRI oracle multi editor schemas

Solution: The limitations of the Esri + Oracle (per 12c) were the cause. 12c Oracle will allow for Multi-Tenant DB, allowing us to have multiple SDE GeoDB as we need. This will meeting the need for ...
1
vote
1answer
434 views

How can I delete an ITable?

I have created an ITable but I need to be able to delete it if it already exists. How can I delete an ITable? This is the code that I have so far which checks for an existing ITable. public static ...
0
votes
1answer
325 views

How can I convert a DataTable to a GeoDatabaseTable

I have a DataTable full of "stops" and I want to convert it into a table that can be GeoCoded. However, I am getting an error when I try to execute it. The Message: Error HRESULT E_FAIL has been ...
1
vote
0answers
332 views

What is difference between version 2.10 & 2.14 in FileGDB driver support in QGIS? GDB version is 10.2.2

Problem is with QGIS Desktop 2.14.0. I need to edit a FileGDB in QGIS. I have followed the instructions shown in this thread and have added the option "ESRI FileGDB". But after I choose the ...
0
votes
0answers
101 views

Dynamically Create a Foreign Key for Relationship Classes

May be a relativity novice question but my research has turned up no direct answer. I have a feature class of land owner parcels that I would like to preserve its schema. I would like to add fields ...
1
vote
1answer
169 views

M-N relationship class in geodatabase with existing linking table?

I have a parcel database with an M-N relationship (Parcels to Deeds). I have already created and populated a linking table. We have also set up two relationship classes in the geodatabase for the two ...
1
vote
1answer
632 views

Geodatabase topology and geometric network on the same data

I know that I can't have a topology and geometric network on the same data in the same dataset in ArcSDE. But is there any solution how to do this? I need geometric network for generating diagrams via ...
0
votes
1answer
251 views

Copying database view into an enterprise geodatabase?

Say I have DatabaseA, which isn't structured in a way that allows me to reference it as a geodatabase in ArcGIS. Fields have to be renamed, geometry added, etc. etc. Now, it seems to me that what I ...
4
votes
1answer
8k views

Deleting feature classes from a geodatabase using arcpy.ListFeatureClasses()

Following up on Using FeatureClassToFeatureClass from list to concatenated list? The error I get is "Parsing error SyntaxError: invalid syntax (line 10)". Using the methods from above I am unable to ...
2
votes
0answers
454 views

Geodatabase performance and Archiving [closed]

We have SDE (10.3) running on SQL Server (SQL Server 2012 on Windows Server 2012 R2) Over time we've noticed our GIS performance degrade, and can have good days and bad days. We run versioned ...
2
votes
1answer
699 views

Link Excel Table to Access/Arcmap Personal Geodatabase Table

My overall goal: My coworkers have an excel table which they update/use frequently. The table is not in a format that arcmap can decipher. Therefore, I've created a locked sheet (in the format I ...
1
vote
1answer
1k views

Exporting photo from geodatabase

I have a lot of photos in the geodatabase, I want to export the photos to a file. How do I export the photos from geodatabse? What tools are used?
1
vote
1answer
1k views

How to change Linear Units

I have an ESRI feature class whose coordinates are 38.263, -122.672 Meters. When I load it into a data frame that uses the GCS_NAD_1983_NSRS2007 datum and the ...
-1
votes
2answers
885 views

Latitude / Longitude Polygon from New Zealand Geodatabase or Shapefile? [closed]

I have access to ESRI Geodatabase and Shapefile: http://www.stats.govt.nz/browse_for_stats/Maps_and_geography/Geographic-areas/digital-boundary-files.aspx. What I need is to somehow get the polygons ...
0
votes
1answer
69 views

Connecting table and feature class in ArcGIS for Desktop?

I have a polygon feature class inside of my geodatabase, and I want to attach attributes from some tables that resides in a separate database. Is there any way to do this that would maintain the ...
0
votes
3answers
4k views

Conversion from shapefile to geodatabase feature class in ARCGIS

I have converted feature class from a geodatabase to shapefile, and after that I have updated some polygons in shapefile. Now I want to get back to the same feature class or a fress/new feature class ...
0
votes
0answers
153 views

Mass ArcPy GDB Load

Looking for a best practice for loading mass quantities of data into an Oracle GDB using ArcPy. I'm attempting to load ~10 million records of Polygon and Point shape data into a GDB (~5M per table). ...
0
votes
1answer
665 views

Determine whether table is registered in geodatabase with ArcObjects

In ArcCatalog we can register a table in the GeoDatabase using the tables context menu. Now i'm trying to find a way with ArcObjects, to detect whether an ITable is already registered, is this even ...

1 2 3
4
5
13