Hot answers tagged arcsde-10.0
5
As for me I would recommend choosing python scripting for this task (arcpy).
Here are some ideas:
Use ListDatasets for getting all datasets.
Use ListFeatureClasses for getting all featureclasses.
Use SearchCursor for querying data.
Take a look at Describe function - it also can be very usefull for some tasks.
UPDATE:
Have found after posting: @Aragon ...
4
An approach that I have used successfully and seems to perform pretty well in FME is to create three columns in the "master" feature class on SDE:
A field containing the feature's original OID (or other unique ID).
(Optional) A field containing the feature's original feature class name (used if you have multiple source feature classes going into the ...
4
Create your own primary key field (like 'id') - if using Oracle Spatial 11g then see the best practices for Oracle Locator and Spatial (11g)
Particularly important
Metadata, tolerance and coordinate systems
Every SDO_GEOMETRY column in a table requires an entry in the Oracle Locator metadata
dictionary, USER_SDO_GEOM_METADATA. The metadata entry includes ...
3
You can export the schema:
Copying a geodatabase schema using Extract Data Wizard in ArcMap
http://help.arcgis.com/en/arcgisserver/10.0/help/arcgis_server_dotnet_help/index.html#/Copying_a_geodatabase_schema_using_the_Extract_Data_Wizard_in_ArcMap/0093000000t1000000/
Alternately use the Geodatabase Designer/Diagrammer
...
3
The GeoDatabase abstraction (not ArcSDE) keeps track of extent of each FeatureClass. Use the Extent property in GeoDataset. One thing to keep in mind, is that this Geometry grows out (increases) but does not shrink. So even if you clip half of the features, the GeoDataset Extent will always show it's biggest state. The only time it gets rebuild is if ...
2
If your data is not versioned (or you've compressed and updated the base tables),
you could just use SQL to query out the IDs.
For a manual, one-time-only, type of query, I've used this SQL query (ORACLE) to generate a second SQL query. You could replace the COUNT(*) as ROWCOUNT with a COMPKEY and add additional where clause conditions (you will probably ...
2
Provided you have an existing R2 cluster...
Create a domain service account and give it "Log on as a service" on each node.
Open port 5151 in the Firewall of each node for the SDE service.
Install ArcSDE on both nodes. ( Do not Run post- install on second node!)
Run the Post Install wizard and select complete.
Use the cluster sql name\instance to create the ...
2
The steps I would take to develop this functionality is:
Use the ESRI libraries to connect to a Geodatabase (SDE/File/Personal), because the library will provide you with the abstraction between formats
Use the ESRI libraries to produce a list of all the feature classes in the datasource.
Use the Extents of each feature class to test if there is an ...
2
you can check out SearchCursor method here. only one thing is that build an SQL expression instead of where_clause. Query expressions is the same as standard SQL expressions in ArcGIS too. it is similar to Select By Attributes dialog box. you can write your own tool by looking at the following code
Summary
The SearchCursor function establishes a ...
2
A quick search of the ArcGIS help site turned up a couple of items that might be of use to you.
These are all located under the ArcObjects SDK 10 for Microsoft .NET Framework.
The first item discusses Listening to Versioned Events
The next item discusses Reconciling versions
The general arguments for each of these include specifying the source version and ...
2
You need to register your view and spatial column in SDE.
There are two good help topics regarding this question:
Example: Creating a spatial view in SQL Server using SQL and registering it
Example: Creating a spatial view in SQL Server using the sdetable command
2
You put sequence value into :new.address_id (use the correct column name instead of address_id) and let the insert command do its work:
create trigger A746_insert_trigger
before insert on SDE.A746
for each row
begin
select address_seq.nextval into :new.address_id from dual;
end;
/
Comment: your code is not complete so maybe you need something ...
2
I was working with SDE connection files today. You can search C: for .sde files, or in Win 7 you can find them in C:\%userprofile%\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\
But the layer definition will store connection info in the mxd as well. See this forum post.
In any case, like the others say, it sounds like you should change the sde password. ...
2
I have found a solution to breaking the dependence on path to the .sde connection file using ArcPy and the following method.
This way works:
lyr.replaceDataSource(sdeConn, "SDE_WORKSPACE", lyr.datasetName, False)
table.replaceDataSource(sdeConn, "SDE_WORKSPACE", lyr.datasetName, False)
You can rename or delete the connection file after the MXD has been ...
2
The new feature outside the extent should not be showing up in the child replicas.
Their new features should be limited to the extent of their original selection. The delete is actually behaving correctly, as the message for the delete should not be transmitted to the children since it is outside their extent. The add is behaving incorrectly.
2
You might consider exporting your development database to a file geodatabase first (XML workspace export/import would work fine). Then if you have a connection to your production SQL Server database from the ArcGIS Desktop, you could set a Python script or a model with ModelBuilder that would truncate all the rows (in 10.0, the tool is Delete Rows) in all of ...
1
Try disabling archiving before you delete anything. When you disable archiving, you should get a message that gives you an option to keep or discard the history (the _H table). If you keep it, then it becomes a regular ol' feature class. The _H tables track the history of changes to the default version, as you make edits to a feature class that has archiving ...
1
If you're using Windows, there's an ArcSDE Service post install that can create the necessary SDE schema objects in your database. You will need to have ArcSDE installed somewhere, and a suitable license to deploy to the SDE schema. You don't need to create / run an ArcSDE service, though.
You can also manually create the schema:
...
1
It all depends on the license level of your ArcGIS server.
From: Types of geodatabases
ArcGIS Server Workgroup also includes ArcSDE support for SQL Server
Express. With this level of ArcSDE, you can use SQL Server Express for
up to 10 simultaneous Windows desktop users and editors (users of
ArcView, ArcEditor, ArcInfo, a custom ArcGIS Engine ...
1
ArcSDE is in the running for some of the most useless, least helpful error codes I've ever seen.
I'm not sure your link will help much here as they're using sdeimport - you're simply registering.
You may however wish to try this thread:
http://forums.esri.com/Thread.asp?c=2&f=59&t=61938
This thread may also help:
...
1
I don't have a SQL Server instance to test with but try the LEFT or RIGHT functions, e.g.:
To get the first character:
LEFT(CAST(MP AS CHARACTER(12)), 1) = '7'
To get the last character:
RIGHT(CAST(MP AS CHARACTER(12)), 1) = '7'
1
We had a similar problem a few weeks ago - as Fezter said, you will need to unregister your dataset as versioned. The resource centre lists the steps here. A word of caution - make sure that all of your versions have been reconciled and posted against default, and not just to your QA version or anything in between. We learnt this the hard way!
1
You can also enable the arcmap search indexing (note performance hit).
The usability for me is begining to outweigh the performance loss.
1
You need to use ArcObjects to modify aliases as they aren't exposed to the python API.
How to change feature class and field aliases in bulk? has a 3 methods for changing the field aliases at the feature class level. One using arcobjects via dot net, one using arcobjects using python via an unsupported backdoor, and the third through geoprocessing, but this ...
1
You need a GP service on the server and the SDE connection needs to be on the server, as well. The script that the tool in the GP Service uses will need to be told where to find the SDE conn file i.e. \\servername\folder\folder\your_sde_connection_file.sde\SDEfeatureclass
Assuming you are a user with permission to be on the server. I would not use the SOC ...
Only top voted, non community-wiki answers of a minimum length are eligible
