Tag Info

New answers tagged

0

If you want to select features from a specific table, use the Select By Attributes tool. Your where clause would be: column1 = column2


0

File geodatabases, unlike enterpise geodatabases, are not built on top of a RDBMS. Nor are they implemenred inside Access like personal geodatabases. This gives them a performance advantage, but comes at the cost of a rudimentary SQL implementation. If IF doesn't work inside the column list, you'll need to find a different way to manifest this recoding.


0

Here's what I did to resolve the issue (using arcpy in ArcGIS 10.0) - This assumes the following: FGDB - C:\gisdata\Test.gdb Feature Class - C:\gisdata\Test.gdb\bldg You can modify your paths and object names in the code and paste it into the python window in ArcCatalog. sr = arcpy.Describe(r'C:\gisdata\Test.gdb\bldg').spatialReference ...


0

You need to increase the max number of connections allowed to the geodatabase. This can be achieved by altering the max number of connections row in the SDE.server_config table. There is a SDE command for doing this if you are uncomfortable modifying that value directly in the geodatabase. sdeconfig -o alter ...


0

You will have to create a database connection as your desired user with the matching schema. Any data loaded or created will use the schema of your connected user. This same idea applies if you want a user other than SDE or DBO to own the repository.


0

Having a large number of lineages definitely impacts performance. Every database query will be aware of each and every lineage. Effecting overall performance between ArcGIS and the geodatabase. This can be resolved by running a compress more frequently to shrink the lineage length and remove unreferenced states. This KB article describes the impact of a ...


0

I will submit what I did to enhance the performance. I followed the procedure describe in the book "Pro Oracle Spatial" http://www.oracle.com/technetwork/database/options/spatial/pro-oracle-spatial11g-094119.html in Chapter 14, on clustering the data. The idea is to cluster and physically restore your data depending on a criteria, or spatial indexing areas ...


0

Make sure you are hitting the spatial index. Query the Oracle execution plan and make sure a full table scan isn't being executed. Also, make sure the geometry is valid and the metadata is valid. These can both be done by using GeoRaptor in SQL developer.


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


2

In addition to the reasons you already account for, you can: Check the states table for unclosed (open) states. Check the versions table to see if perhaps a replica version or transactional version points to one of the blocking states (the states that will not compress). Identify the lineage the blocking state(s) participate in for further querying. Run ...


5

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 topological relationships (imagine editing a parcel boundary). But this awareness exists only within a single coverage - if you want to model the relationships ...


8

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


9

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 ...


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 ...


0

I have sample code using append geoprocessing for copying feature selection to other geodatabase. Geoprocessor GP = new Geoprocessor(); SelectLayerByAttribute SelectByAttribute = new SelectLayerByAttribute(); SelectByAttribute.in_layer_or_view = "Digit"; SelectByAttribute.selection_type = "NEW_SELECTION"; ...


0

Open ArcCatalog or windows explorer and navigate to the folder that contains your geodatabase that you want feature classes/anything else to import to, and go to the properties, click on security table and select the current user and grant it full permissions, Now retry importing the feature class and it shall work, remember all feature classes in a feature ...


2

If your choice of terminology is accurate, then you generated a Geodatabase Replica to ship to the regional office. The replica generation process includes a named version which ends up receiving the regional edits once returned. Importantly, there are specific requirements to use the replica in a disconnected state. (Be sure to review the geodatabase ...


5

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 ...


1

After Jay's help, I have successfully check when arcmap is in editing session, the code is as floows: Dim editorUid As New UID() editorUid.Value = "esriEditor.Editor" m_editor = TryCast(My.ArcMap.Application.FindExtensionByCLSID(editorUid), IEditor3) m_editEvents = TryCast(m_editor, IEditEvents_Event) If m_editor.EditState = ...


3

You can check for the EditState on the editor extension.


2

You probably need to change the pg_hba.conf file to enable for remote connections. Then you need to register the db with ArcGIS server. In ArcGIS server you will go to the Site tab, and choose datastore. Copy your sde connection file to the sever and point to that connection file.



Top 50 recent answers are included