Tag Info

New answers tagged

0

The other thing to watch is this: are the two shapes strictly identical, i.e with the exact same number of decimals ? When you query a geometry in Oracle with sqlplus, you will only see up to 10 characters (including sign and decimal separator), so you may not see all decimals. If you then do something like cut and paste the output to insert it into ...


1

The two area calculation sums are within 0.0638% of each other, which is pretty close. It looks like you are calculating the area of a geodesic polygons, which is a complicated problem, with several different algorithms, each with a slightly different result. I can point out the algorithms used for different versions of PostGIS, but the algorithm for Oracle ...


1

I believe what you're looking for can be for found in the SDE_XML_DOC# tables stored as ArcSDE XML (CLOB in Oracle in this case). Here's an example of the workflow for a feature class called "SDE.Test": SELECT NAME, DEFINITION, DOCUMENTATION FROM SDE.GDB_ITEMS WHERE NAME = 'SDE.Test'; NAME DEFINITION DOCUMENTATION SDE.Test 61 ...


2

An easier option than creating python addin would be to create a python script tool that uses various arcpy.GetParameterAsText(0) statements that relate to the Create Database Connection arguments, and then using conditional logic (if, else), is directed to open one of two map documents sourced to either test or production (already saved somewhere on your ...


1

Non-Arcpy If you don't want to go for arcpy, one solution is to create two separate Mxds. Right Click your original mxd in ArcCatalog and then click "Set Data Source...". In this way you can instantly create a new mxd file which points to your new connection file (e.g. ProductionDatabaseConnectionFile.sde). It takes about 10 seconds. If your original ...


1

In my situation, the problem was the order of deploying the changes. In a previous step, the dataset containing these feature classes was registered as versioned. Then the above 'arcpy.AddIndex_management' was called. If indexes are added before enabling versioning, all the feature classes are indexed without issue. And much more quickly as well.


2

There's no telling what actually happens behind the scenes. Maybe this thing executes one separate statement for finding the characteristics of each column of each table and forgets to close the corresponding cursors, i.e it leaks cursors. One simple test is to increase the maximum number of cursors per session. Best is to ask your DBA do to that, since it ...


1

Oracle Spatial comes with a collection of Java APIs, and one of them lets you read shapefiles. That API is documented here: http://docs.oracle.com/database/121/SPAJV/toc.htm. Look for the oracle.spatial.util package, specifically class ShapefileFeatureJGeom. It uses lower level classes that perform the actual reading of the shapefile (DBFReaderJGeom and ...


1

This is a simple operation in GeoTools, once you have read in the Shapefile you will have a FeatureCollection which you just need to write to an Oracle Datastore. I have an example of how to write a Database (mysql and postgis are the examples included) here.


1

Zoom-level depending mis-alignments are often caused by the OL client and the server having either slightly different zoom level definitions, or different maximum extent definitions. Try looking at the GWC preview (you can find it in the tile layers menu) and check its setup, then make sure your client does the same.


2

Your configuration is not the best candidate for an in-situ upgrade. Given the distance of four major ArcGIS releases (and more than a dozen minor releases), and three major Oracle releases, plus operating system compatibility issues, your most reliable migration path would be to: Use 9.2/9.3 Desktop to convert your 9.2 geodatabase tables to file ...


0

Probably it can be solved by using value map instead of value relation. But I didn't figure out how can be solved a situation with more than one conditions, because there is no expression builder.



Top 50 recent answers are included