24

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 to summarize without going too deep into it. 1. Coverages: Coverages are interesting geospatial data structures. They concentrate on storing topology. So you ...


23

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:


15

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: Update your ArcGIS Server license (and extensions) by double-clicking on the license file, which will start the Software-Authorization wizard. Optionally you ...


14

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 should work (use a modification of your file geodatabase location where I have used C:\temp\test.gdb): import arcpy arcpy.env.workspace = r"C:\temp\test....


12

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 specifications on how the algorithms are implemented (unless @Vince will shed some light). Shapefiles came later on and were implemented as a standard which ...


10

Another way to search for feature classes, which may or may not be in a dataset is to use the walk function, as mentioned before. It requires only a workspace to search in (i.e. a folder containing hundreds of GDBs). import arcpy, os workspace = "Path/to/folder" search = "name_string_you_are_searching_for" feature_classes = [] for dirpath, dirnames, ...


10

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 and attribute index on the ObjectID.


9

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 extended by adding further functionality (str.lower(), like @RyanDalton did) very easy. def findField(fc, fi): fieldnames = [field.name for field in arcpy....


9

Here's code for the solution based on the accepted answer: #define the input table name tblIN = "LFA_WYKAZ" #define new feature class name fcOUT = "LFA" #define projection projection = "c:\Program Files\ArcGIS\Desktop10.0\Coordinate Systems\Projected Coordinate Systems\National Grids\Europe\ETRS 1989 Poland CS92.prj" #create empty polygon ...


9

This question has been converted to Community Wiki and wiki locked because it is an example of a question that seeks a list of answers and appears to be popular enough to protect it from closure. It should be treated as a special case and should not be viewed as the type of question that is encouraged on this, or any Stack Exchange site, but if ...


9

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/change". The ArcGIS Setup dialog will pop up. Chose the "Repair" option. After finishing the Repair procedures the ArcGIS will be working properly!


8

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 useful (and appropriate) when you need to incorporate non-spatial data with one:many relationships to your spatial data, especially if it is from an external ...


8

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, which in turn would be subtypes, and then metal would have a domain of yes/no for rusted, but plastic would have a domain of N/A or whatever other option. ...


8

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 blocks. The most restrictive of these was 500 vertices per line primitive ("arc"). This restriction introduced the concept of "pseudo-nodes" (places where ...


8

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.Delete_management(fc) Chances are you'd never have it try to delete one that doesn't exist but this way, it keeps deleting if it DOES find one that doesn't ...


8

The mod keyword is not recognised by SQL Server. For modulo function, you'll need to reformat the expression like so: contour % 50 = 0


7

Below the details of the process I used for converting a File GeoDataBase with Arabic fields into shapefiles with UTF-8 encoding that open happily in both QGIS and ArcMap showing both Arabic and English correctly (without using extensions to export or to read): The basic idea is: from the FGDB export a shapefile including a .dbf (in the wrong encoding), ...


7

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 resources and assuming there are no versioning issues that would require a diagnose/repair. Continue to compress often. From your naming conventions it looks like ...


7

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-content/en/ALL/;ELX_SESSIONID=Pxf1Jb7C6XMpQpplr1dBPSYRfQZnTvX49LXZX3JMVvWY127CZ5Qx!1783894010?uri=CELEX:32008R1205


7

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 versioning is used to enable handling of conflicts where two (or more) editors may have edited the same feature. It gives the abililty to choose the correct ...


6

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 all three types. http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Raster_data_organization/009t0000000n000000/


6

If you need just basic SQL access on something that is not a registered ArcSDE table, I recommend using a simple ODBC connection object rather than mucking about with the overhead of ArcPy. ArcPy adds so many objects which you likely do not need that it slows down what should be a quick and simple process. My personal choice is pyodbc which can be found at ...


6

There are a few ways to tackle this, but here's a pretty easy one. I'm going to assume you're using ArcGIS. This can be easily done without python. Have you looked at the Summary Statistics tool? You can run that on your Polling Station layer and join the resulting table back to the State feature class. Set the Statistics field to State and statistics ...


6

If you are using ArcGIS I would think an easy way to do this, without creating any intermediary products, would be to select each state in your states polygon (assuming you have multipart features) and then select by location the polling stations features. You can then get a count of how many features are selected and writing this value to your states ...


6

I think the easiest way to do this would simply be to use the Table to Domain GeoProcessing tool, which you could run directly within the software or call via arcpy. You can get details about the tool at http://resources.arcgis.com/en/help/main/10.1/index.html#//001700000025000000 but basically it assumes you have a table that in your case would have a ...


6

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 lineage without affecting the versioned table structure. A likely cause of this is that there are versions that directly reference those states. You can see ...


6

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 subtype can set a domain for the desc field. The soil subtype has the soil subtype for the desc field. You will need to make domains for acceptable values for ...


5

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 didnt export the data, schema only Use some online Pretty Print service to format the xml Open the XML file in a text editor and Reorder the fields as you like Re-...


5

In the first place, you need a certain place, or a container, for your temporal data produced by your scripts so you can store it somewhere before it will be fed to the second process. If there will be no need to store such temporal aka intermediate data, there is no need for using any workspace for storing the data. If you do need to store your data ...


5

Do you have the ESRI FGDB API set up so that ogr can access file geodatabases? If so, you can open the file geodatabase layers in QGIS 2.0 and use the database manager to import each layer into a PostGIS database. If you don't have the API you can't get to the data in the file geodatabase. It's easy to install on windows, just use the OSGeo4W installer. ...


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