24 votes
Accepted

What is the difference between Coverage, Shapefiles and Geodatabases in ArcGIS?

This is such a great question. Coverages, Shapefile and Geodatabases are fundamentally different geospatial data stores from an implementation standpoint as well as from a philosophical one. I'll try ...
user avatar
24 votes
Accepted

What does an asterisk (*) mean when shown beside a field name in the attribute table?

It means that the field is indexed. You can change the character used to indicate whether a field is indexed under the Table Options > Appearance menu:
user avatar
  • 12k
15 votes
Accepted

ArcGIS Server License Update - Additional steps for Enterprise GeoDatabase?

Finally I've updated my ArcGIS Server instance (including GeoEvent Extension and Enterprise GeoDatabase) to the new license successfully. Find below my performed steps to complete the update-process: ...
user avatar
  • 710
14 votes

Listing all Feature datasets and feature classes from single Geodatabase into CSV

I think you should research/ask about writing to a CSV file separately at StackOverflow because the technique you are using to do that is pure Python rather than ArcPy. For the remainder I think this ...
user avatar
  • 63.8k
12 votes

What is the difference between Coverage, Shapefiles and Geodatabases in ArcGIS?

Most of the information can be found in Esri Help and some search, so I've just compiled some good reads. How coverages are stored? Since it is a proprietary format, you won't find any technical ...
user avatar
10 votes

What does an asterisk (*) mean when shown beside a field name in the attribute table?

The asterisk means that the field has an index. A Shapefile does not have any indexed fields by default, you need to add them. A GeoDatabase Featureclass always has a spatial index on the Shape field ...
user avatar
  • 38.9k
9 votes
Accepted

Search if field exists in feature class

I would prefer a list comprehension instead of string operations (like accepted answer). In my opinion, this is more readable and pythonic. Furthermore, the list comprehension approach could be ...
user avatar
  • 1,250
9 votes

Fixing Script Error Invalid Pointer from ArcGIS Geoprocessing Tools?

I just solved this problem. What you need to do is the following: In Windows go to: Control Panel -> Programs -> Uninstall a program. Then right click on "ArcGIS for Desktop" -> Select "Uninstall/...
user avatar
  • 916
8 votes

To Use or Not to Use Relationship Classes?

Think about the bigger picture - GIS data is just a means to an end for most people, especially when it comes to government entities. My experience has been that relationship classes are primarily ...
user avatar
  • 319
8 votes
Accepted

ArcGIS Attribute Subdomain?

I think what you are actually trying/wanting to do is create subtypes as shown in the graphic here. You can then apply domains by subtype. In your example type would be a domain of plastic and metal,...
user avatar
  • 15.5k
8 votes

What is the difference between Coverage, Shapefiles and Geodatabases in ArcGIS?

The primary difference between these formats is the way that features relate to geometries. Back in the heyday of coverages, the coding language was FORTRAN, which meant fixed buffer sizes in COMMON ...
user avatar
  • 18.9k
8 votes
Accepted

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

After you supplied the error, I noticed you didn't use a colon at the end of line 10. You should replace lines 10 and 11 with the following lines. for fc in filtered: if arcpy.Exists(fc): arcpy....
user avatar
  • 4,449
8 votes
Accepted

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

The mod keyword is not recognised by SQL Server. For modulo function, you'll need to reformat the expression like so: contour % 50 = 0
user avatar
  • 21.3k
7 votes
Accepted

Does a high number of SDE_state_lineages slow performance?

The answer is yes that the number of rows in the sde_state_lineages table directly impacts performance of the geodatabase. 200k rows is not considered "alot" but that is relative to your available ...
user avatar
  • 816
7 votes

Opening Raster stored in Esri Geodatabase using QGIS

QGIS doesn't support ESRI Geodatabase raster. The only solution is to open the database in ArcGIS an export the raster GeoTiff. Right click in arcCatalog, Export/Raster to different Format... Then ...
user avatar
  • 3,455
7 votes
Accepted

Implementing INSPIRE Metadata with Geodatabase

At ArcGIS 10.1 INSPIRE Metadata is supported in ArcMap/ArcCatalog There are also more information here on the Regulation of Metadata (including metadata on metadata) http://eur-lex.europa.eu/legal-...
user avatar
  • 48.6k
7 votes
Accepted

What is Diffrent Between Version & Replica In ArcGIS Geodatabase

Versioning is for editing in a multi-user environment. Replication is for replicating your data in a multi-database environment. They are two very different things. In a multi-user environment the ...
user avatar
  • 29.2k
6 votes

Differences between Raster Dataset, Raster Catalog, and Raster Mosaic

The differences between Raster Datasets, Mosaic Datasets, and Raster Catalogs are explained well on the Esri help page. At the bottom has a chart that breaks everything down and list pros and cons of ...
user avatar
6 votes
Accepted

What is the significance of the SDE lineage length?

A lineage length of 289 indicates 289 states participate in that lineage. If this is after a compress operation, this indicates there are 289 states that cannot be compressed together to collapse that ...
user avatar
  • 816
6 votes
Accepted

How to auto-fill domain or field?

Maybe a few pictures would help. A subtype field can be set to categorize the main types (rock, soil, debris); This would correlate to Field_1. Notice the desc field domain is set to rock. Each ...
user avatar
  • 1,392
6 votes

Parametrized queries for ArcGIS?

Out of the box, ArcGIS Server comes with two pieces of functionality you might explore: Feature services have ValidateSQL request available which can check your SQL query/statement. validateSQL ...
user avatar
5 votes

Reordering fields (permanently) in file geodatabase using ArcGIS Desktop?

If you don't have Visio for Diagramer- All of the other answers here breaks any joins. I found this to work well in my case: Export the schema for the whole db using Arccatalog (Export - XML) - I ...
user avatar
  • 51
5 votes
Accepted

Coded Value Domains in ArcMap

Yes, you can do this with arcpy. I usually use arcpy.da.ListDomains to iterate through the domains but in your case you just need to see if there are any domains assigned to a field in feature classes....
user avatar
5 votes
Accepted

Copy features between file geodatabase and ArcSde by using ArcObjects

As John has stated you probably have a lock on your database from the map service. If your feature class is not versioned and the features you are working with are not complex (i.e. they do not ...
user avatar
  • 2,994
5 votes
Accepted

vb.net arcobjects determine whether arcmap is in editing session

You can check for the EditState on the editor extension.
user avatar
  • 14.4k
5 votes

What is the difference between Coverage, Shapefiles and Geodatabases in ArcGIS?

One more difference between the formats is that a geodatabase can model relationships between feature classes. As Ragi noted, Coverages work really well for edits that require awareness of ...
user avatar
  • 20.5k
5 votes
Accepted

Unable to register gdb with the server due to sql server client incompatibility

I was having this same problem after upgrading everything to 10.3. I just dug this up from an old e-mail from ESRI Support. Here is the main part of the information in the e-mail. Regarding SQL ...
user avatar
  • 4,449
5 votes
Accepted

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

This is a pretty straightforward exercise in FME. You'll need to do the following: Load your CSVs using a dynamic reader (Single Merged Feature Type) and point to the whole folder where your CSVs ...
user avatar
  • 21.3k
5 votes

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

By default, yes, it normally is unless someone overrode that and designed the table differently. Is this an ArcSDE database? There may also be GlobalID fields that act as primary keys across ...
user avatar
  • 336
5 votes

Creating geodatabase (and st_geometry) in Oracle Express (XE) for home/personal use?

It is your plan to "add a sde.st_geometry user-defined type" that means you will need ArcGIS Server (of which ArcSDE is a component) licensed. If that is a mandatory requirement then your most cost ...
user avatar
  • 63.8k

Only top scored, non community-wiki answers of a minimum length are eligible