New answers tagged arcsde
0
You must add a field of data type "AutoNumber" to be able to do some functions on the table. I usually name the field "OBJECTID".
0
Spatial databases have been growing in demand in the last few years which drew major databases like Oracle and MSSQL to develop their own Spatial functions and data types in their native products (i.e SDO_GEOMETRY and SpatialData)..
These packages allow you to store and query geographic data and answer much of the requirements a common GIS system asks for.
...
0
A couple of thoughts and comments..
First off, for a direct connect setup you shouldn't need or use the -s parameter. Your connection is wholly defined by the -i service parameter.
Second, I find it highly suspicious that you say things work differently when running the commands locally on the database server vs. remotely. That indicates to me that the ...
0
Try changing the -i parameter to just "5100" (or whatever your server is) instead of "sde:...."
6
I'm guessing you may have general performance issues such as labeling, layer scale rendering, transparencies..etc. If you have ArcGIS for Server license you may try using the Analyze button on the Service Editor to test a map document for these performance warnings.
Service Editor helps you identify potential performance bottlenecks
and errors that ...
0
I found my own solution:
I discovered, i can use the GP-tool XSLTransform from the toolbox conversion/metadata to write to HTML.
With some simple python i can now traverse my database an publish it to my webserver.
I also wrote some extra code to generate a sort of index-page as well.
For example:
With this tool i can convert a the metadata of a single ...
0
http://geocat.net/bridge is an easy tool to convert ArcSDE-metadata to iso19139-inspire metadata, and optionally publish it to http://geonetwork-opensource.org
Other options in bridge are publishing data from ArcMap to geoserver/mapserver.
You also might want to have a look at http://www.esri.nl/geosticker
0
According to the updated help, you need to use arcpy.ClearWorkspaceCache_management()
You can use the following code:
import arcpy
from arcpy import env
env.workspace = "c:/connectionFiles/Connection to gpserver.sde"
arcpy.ClearWorkspaceCache_management()
This answer has been derived from OP's comment on the question.
1
In many situations, a dirty area in you parent version will be present in your child version after you reconcile. Additionally, in some situations reconciling can generate new dirty areas that aren't present in either version.
ArcGIS help:
http://resources.arcgis.com/en/help/main/10.1/index.html#/Dirty_areas_in_versioned_feature_classes/00620000000q000000/
...
0
You can execute sql statements in the same connection, but arbitrary selections become more difficult. You can take a look at the IWorkspace::ExecuteSql method for DDL or DML. Selections have to be done through either a query layer or a QueryDef.
0
See this article: "A common question that I see in Desktop Support is “Why is ArcMap performing so slowly?”"
http://blogs.esri.com/esri/supportcenter/2012/06/07/troubleshooting-slow-performance-in-arcgis-desktop/
1
First of all: No, SDE does not have any built in feature of event triggered processing. As far as I know you can probably do something working with the CASE Tools where you can implement your own types of featureclasses with their own behaviour, but that means ArcObjects programming.
I think database triggers can be used for this, and this wouldn't be too ...
0
You need to commit the changes to the datastore. You'll need some code like:
if (featureSource instanceof SimpleFeatureStore) {
SimpleFeatureStore featureStore = (SimpleFeatureStore) featureSource;
featureStore.setTransaction(transaction);
try {
featureStore.addFeatures(collection);
transaction.commit();
...
3
You don't necessarily have to set up your database as an SDE Geodatabase at all. At ArcGIS 10.1 ArcGIS can read and write SQL Server and PostGIS (among others) native databases. That means that you could set up your database in one of the RDBMS's supported by open source packages and ArcGIS (personally I would say either MS SQL Server or PostGIS) and ...
14
You can use a native PostGIS database as an SDE data store.
http://resources.arcgis.com/en/help/main/10.1/index.html#//002p0000006v000000
That link describes the basic setup to register a native PostGIS table with SDE. The drawback is that ESRI only supports a narrow range of Postgres and PostGIS versions, here's the list of what they support:
...
2
This is a three-step process. You'll need to use ArcMap for the two steps to configure your project, but once your project is configured you can use this configuration as many times as you need to.
First create your mxd with your data in it and zoom to the region you want to check out. Once your project is configured you will only check out data in this ...
2
The ArcSDE administrative user (sdeuser) account is responsible for the administration of the following:
ArcSDE geodatabase system tables, triggers, and procedures
The ArcSDE service
Versions
The ArcSDE administrator owns all the ArcSDE geodatabase system files, directories, and tables. For this reason, the ArcSDE administrative account must be ...
1
You do not want SDE owning the data. You also do not want your table spaces to be intertwined with your SDE table spaces (database administration and performance side of house). It can make upgrades and other data manipulation more complex. Also, when you log in as SDE you have elevated privileges which means you may accidentally run an action that would ...
0
I don't think there is a really good answer to this but ...
This is an existing ArcGIS Idea that I would encourage you to vote for because it sounds like your question.
Hierarchical field behaviour can be programmed into Geoprocessing tool dialogs using Tool Validation.
There is another ArcGIS Idea (mine) related to this for Validation of Hierarchical ...
Top 50 recent answers are included
