Tag Info

New answers tagged

1

Every set of coordinates stored inside SDE.ST_GEOMETRY is stored as a compressed array of 8-byte long integers. The IEEE floating-point to integer conversion is performed by subtracting the coordinate reference X_OFFSET (or Y_OFFSET, or Z_OFFSET, or M_OFFSET) and multiplying by the XYUNITS (or Z_SCALE or M_SCALE). The process is reversed when querying for ...


0

There are several underlying related tables in SDE that have a chance of not being updated properly if the table delete happened nontraditionally. The most likely cause of this issue is that the table name is persisting in the table registry even though the table has been deleted from SDE. First, run a SELECT * on [database].[schema].[SDE_table_registry]. ...


4

.sde files are files that store database connection information. Each of the connections in the image below are from saved .sde files: They store information such as the instance name, the user you are connecting as and whether the connection uses database or windows authentication. You may have some .sde files that are no longer used from an old install ...


2

Well, a *.sde file is a SDE connection file. It basically saves all the connection properties for connecting to a SDE geodatabase. It saves things like database, version, username, password (optionally), etc... This is commonly used to connect to SDE geodatabases, especially in enterprise level implementations of ArcGIS Server technology. You can read ...


1

I had the same issue and was able to solve it. If You have large number of layers or domains with many values then service may reach "Maximum Number of Coded Domains" parameter maximum value. Go to "ArcGIS server manager" "Edit service" (the one with missing domains) Open "Parameters" settings "Properties" table find the "Maximum Number of Coded Domains" ...


0

I realize this is a old thread, but @Baskinomics is right, ROK Technologies does host ArcGIS Server map services. Full Disclosure..I work at ROK. Monthly fees are reasonable, and not based on a credit system - all are flat fee. Dont want to turn this into a plug, just letting you know that we do in fact do it.


0

Update will update if the key exists, or insert if it doesn't. I think that the error you are seeing when you say 'exists=no' is sensible, so you want to set it as 'exists=yes' and sort out the problem of why it's inserting rather than updating. Have you added the attribute to your writer of the key that you are using to update on? And if so, have you ...


1

I reckon you've got your reader configured wrong. Start with a fresh reader, and don't write anything yet, but add an inspector. Check that you're getting features in. Once you are definitely getting features in, then set up the rest of your logic. I assume you'll already know this, but if you want to update only particular attributes, you'll need to set ...


1

All of our rasters are saved as either TIFF or Mr. Sid formats on a separate server from the rest of our ArcGIS infrastructure. These are read-only for everyone but the staff who manage the files. It also makes it possible for people who do not use ArcGIS to be able to pull these images in to their software. We do have a ArcSDE database just for the ...


1

We store our data in tiff (or bigtif) with compression because it can handle very large images and you can read it (+ its its internal metadata) with most softwares. I don't like to store images inside of a database because of the size (even if thesize limits have been largely improved), and use som .vrt to extract/combine the valuable information from your ...


0

Based on the answers and comments here is a snippet of what I ended up doing: dataList = [ ###list of variables defined above### ] env.workspace = warehouse warehouseList = arcpy.ListFeatureClasses("*", "", "") print "Created Lists \n" print "Loop through warehouse List.... \n" try: for warehouseList in dataList: ...


0

As you said you could either do something with Describe or with ListFeatureclasses. Describe option to check if the referenced path is a table or not, based on the fact that every feature class has an attribute featureType, whereas tables don't: d = arcpy.Describe(warehouse + meters) if hasattr(d, 'featureType'): # feature class ...


0

Now, I know why the lookup tables did not show up in the attribute table or why after closing ArcCatalog the domains associations were gone. The feature class was not Register with Geodatabase. It was listed in ArcCatalog as an SDE Feature class, but you need to register it explicitly. By doing that, everything works fine.


-1

Web Services... SOA - Service Oriented Architecture http://en.wikipedia.org/wiki/Service-oriented_architecture


2

ArcGIS has supported 64-bit Oracle 11g since 9.3.1. In fact, ArcGIS Server has been exclusively 64-bit since 10.1 was released (Desktop continues to be 32-bit, so that might be the cause of this confusion). Configuring the SDE.ST_GEOMETRY custom datatype for use with Oracle 11g clients other than ArcGIS requires up to four steps: Installing the datatype ...


3

Geodatabase corruption is difficult to resolve even when you've been using it for several years. When you add in ancient hardware, unsupported database software, and long-retired ArcGIS versions, you're approaching an intractable problem. I can say this: You will not solve this by using command-line tools. The corruption is in a place where they do not ...


0

I know this is answered but I just ran up against the same thing and in searching found this esri KB article that outlines nearly the same procedure as above but also what to look for to compare if you have errant versions. The article is specifically looking for replications that were deleted but not properly dropped from the database. Which is exactly what ...


1

Close ArcGIS and ArcCatalog. In Oracle 11g, the sequence of your non-spatial table, if registered with the Geodatabase, will be created by SDE under a name similar to this one: 'R5834' If you go to the tab 'Other Users' in SQL Developer, go to the user SDE and then open the table TABLE_REGISTRY, you should be able to see the table registered with the ...


0

There are no known issues of performance degradation with upgrading to SQL SERVER 2008 R2. In the recent times the only bug that I can think of is [NIM082657:When working with an SQL Server 2012 geodatabase and Geometry or Geography type data, ArcMap drawing performance is slower than it was using SQL Server 2008. This affects all rendering and editing ...


0

The error is not very clear, but definitely not related to the number of users connecting to the database. (In such cases you get error - Unable to connect to database. Maximum number of connections to instance exceeded). I error message mentions STATE_ID, considering this I would recommend you to COMPRESS the database once (it is okay to compress even ...



Top 50 recent answers are included