Hot answers tagged

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


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


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


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


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


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.


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


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



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