New answers tagged

5

A google on "ArcGIS READ_COMMITTED_SNAPSHOT ALLOW_SNAPSHOT_ISOLATION" returned a "What's new in ArcMap" 10.4 documentation reference. In the Geodata section it states (third bullet, emphasis mine): Beginning with ArcGIS 10.4, geodatabases in SQL Server require the SQL Server database options READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION be ...


0

As alexGIS already said, it would be easiest to create a replica between your SDE database and your local backup fileGDB Make sure that your SDE database is versioned and all feature classes have a GlobalID. If you want to work with a fileGDB check-in/ check-out replicas is the right choise: ...


0

Might I suggest adding an additional process to your model like Delete, so as to remove the shapefile after you have successfully appended it? That way, at any given moment only new shapefiles will be in your workspace when you run the model. Since you are using Pathfinder Office you can at any time recreate the shapefiles if needed


1

This Python script will append shapefiles modified since yesterday to a target fc (I'm not sure if this is what you are after): import arcpy, os, datetime #workspaces workspace = r'D:\Kartdata\tk_riks_Sweref_99_TM_shape\terrang' targetfc = r'D:\Kartdata\test123.shp' #Function that return modification date of files def modification_date(filename): t = ...


1

In my case the table we were inserting into was not registered with the geodatabase and was never going to be registered. Adding a primary key and identity column resolved this issue for us.


2

Use sde:sqlserver:mymachinename for your server instance arcpy.ArcSDESQLExecute(server='mymachinename', instance='sde:sqlserver:mymachinename', database='mydbname', user='myuser',password='mypass') This makes your Direct Connect work rather than using an SDE service instance. I recall this happening a couple of versions ago when we were moving from SDE ...


3

The sde.ST_GEOMETRY type itself is typeless (it doesn't care if multiple topology classes exist). However, ArcGIS for Desktop and Server do care, and won't permit multiple topology classes. When geometry is created by PostGIS in PostgreSQL, the topology class is registered via an explicit AddGeometryColumn request. sde.ST_GEOMETRY does not have an ...


0

Once compressed, all the rows in the A&Don tables will be moved to the base table and the A&Ds will be empty. Building statistics at this point will cause the query optimizer to not be able to optimize the A&Ds (because they are empty). Meaning that even as they fill up during the day as people are editing, the statistics are still configured to ...


4

An Esri SRID is not the same thing as a coordinate reference ID. Esri uses an integer compression algorithm to improve geometry performance, and the spatial reference parameters provide the rules for this compression (there's a whole whitepaper on how coordinate references are implemented). The SRIDs are therefore site-specific versions of the metadata ...


0

So, I was working in both the ArcGis GUI and arcpy scripting and accidentally found somewhat of a hacky solution. I tried creating sessions and was looking to execute the script from within the GUI's python window. In experimenting there, I found that the session appeared in the same list as versions when connecting to the Oracle DB. So, if I connect to a ...


3

The short answer is yes. A view is basically a stored query. A couple of general things you can try to speed up you database performance. Make sure all your join fields are indexed Make sure the database statistics are refreshed If you data is versioned are you using ESRI multi versioned views as part of you views? If your data is versioned make sure you ...


0

Why not use GDAL/OGR? You should be able to convert directly from your sde database to sql server. Here are some links that might help: This one should give you the syntax for your sql server connection: https://alastaira.wordpress.com/ogr2ogr-patterns-for-sql-server/ This helps with the syntax for your sde connection: How to migrate data from ArcSDE to ...


1

If you have ArcGIS now, you should use the FME Workbench found in the Data Interoperability Extension to 'read' your SDE data and 'write' it as SQL Server Spatial. Or, get a trial version and migrate all your data over before the trial runs out. In terms of the domains, If there is an opposite of 'table to domain', use that, and again use FME to load the ...


0

The answer was quite simple: do additional joins. SELECT EVENT_ID, ROAD_ID, Event_Status_Description, Strategy_Description, Activity_Description FROM ((TEMP_OWNER.ROADS LEFT OUTER JOIN (SELECT EXTRACTVALUE(CodedValues.COLUMN_VALUE, 'CodedValue/Code') AS Event_Status_Code, ...


1

For the record: Enterprise geodatabase libraries were available for both 32-bit and 64-bit servers at 10.0, and have shipped exclusively 64-bit since ArcGIS 10.1. There has never been a "32-bit bottleneck" in ArcSDE client applications (as of the time of the original post, the increased 64-bit instruction size actually slowed performance, though modern ...


3

ArcGIS doesn't like fieldnames with spaces, or any other non-alphanumeric character for that matter (other than the underscore _) The Esri FAQ What characters should not be used in ArcGIS for field names and table names? says Eliminate any characters that are not alphanumeric character or an underscore. Do not start field or table names with an ...



Top 50 recent answers are included