27

A very good discussion of whether to use ArcSDE or not can be found here. At 10.1 there is no need to install the ArcSDE software unless you need to run an ArcSDE service. If all of your users are making Direct Connections to the geodatabase then the ArcSDE installation is not necessary. As well, most of the functionality offered by ArcSDE commands is now ...


14

Which part of the script is actually taking up most of the time? There are about 5 other steps going on before you actually start deleting stuff. You might want to break your script down into bite-sized tests. For example, instead of creating a temporary connection file, listing a bunch of datasets, listing their contents, counting their records, and then ...


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: http://...


14

The ArcSDE APIs date from the earliest days of ArcSDE. It was how you interacted with the data stored in a RDBMS. This was before there were ArcToolbox tools or many ArcObjects classes and methods. Because of this, the ArcSDE APIs have almost no support for geodatabase objects beyond points,lines,polygons--no feature datasets, network datasets, etc. The ...


14

Create Layer From Selected Features DOES NOT create a DYNAMIC layer. The resulting layer is not dynamic at all. It is based on an FIDset. If you change the source data, the FIDs will change and your selection layer will break. There is no where clause in a selection layer. It is based on FIDset (the FIDs that were selected when you used 'Create layer ...


13

You need to be sure the SDE connection file you want to use is accessible by the user running the script, on the machine running the script. "Database Connections" is a shortcut to a folder under the current user profile, e.g.: %APPDATA%\ESRI\Desktop10.1\ArcCatalog. You do NOT have to use this shortcut! You can just as easily specify the full path to the ...


12

First off, yes you will definitely want to make sure your primary and foreign key fields are indexed on both tables. This lets the DBMS plan and execute queries against these fields much more efficiently. Secondly, you are calling SelectLayerByAttribute_management in a tight, nested loop (once per tree per treatment). This is highly inefficient, for several ...


12

Storing your data in a Spatial Database has several benefits over storing it in ArcSDE Geodatabase with a RDBMS Backend. These include: Your data can be accessed by other third party products freely. Your DBA is happier with it being a Pure Database storage, since they can apply all their normal DBA best practices on the database. You can apply Spatial SQL ...


11

One way of doing it: Close ArcGIS and ArcCatalog. In SQL Developer (Oracle 11g), the sequence of any Oracle table, if registered with the Geodatabase, will be created by SDE under a name similar to this one: 'R5834' If you click in SQL Developer onto the tab 'Other Users' and then onto the 'SDE' user, you should be able to see the table 'TABLE_REGISTRY'. ...


11

The best way I've understood how Create Layer from Selected Featuresis this reference that I came across Create a temporary layer to select features Creating a temporary layer allows you to do things, such as make selections, without affecting the original data source. This layer will not appear in the ArcCatalog contents, because it is created in-memory ...


10

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


10

I may be too late, but in case someone else comes across this forum for the same problem (as I did ;)). This is because you have to install the correct files for your client: http://resources.arcgis.com/en/help/main/10.1/index.html#/Setting_up_a_connection_to_PostgreSQL/002p0000003q000000/. It took me a while to figure this out as the ESRI online ...


10

There is a function on arcpy called ListVersions. Here's online help for it. >>> print (arcpy.ListVersions('bigiron.sde')) [u'BILLY.VersionOne', u'JOE.2B8E86', u'S.DEFAULT'] >>>


9

If upgrading to ArcGIS 10.1 (now released) is an option then I just found this in the What's New in ArcGIS 10.1 PDF: New tool to delete all rows from a table The TruncateTable geoprocessing tool in the Tables toolset can be used to delete all rows from a table or feature class. You should use the Truncate Table tool instead of the Delete Rows ...


9

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


9

Well, no one is gonna answering. Therefor based on my own tests, I guess I can provide some useful information in case anyone interested in sde attachments. Storage of any attachment in file server (IIS in my case) provides unbeatable export speeds, especially in case of facing concurrent requests. However, the performance issue in using URL method here is ...


9

It's sometimes confusing, but it's really a matter of perspective. See this diagram (from this topic) for a reference: This is an example of five relationships (and three different cardinalities). One-to-many: Parcels are related to the ParcelToOwner table in a one-to-many relationship; one parcel may have many owners (partial ownership). Many-to-one: The ...


9

Two billion features, plus or minus (2^31-2 legal rowid values). I've only loaded 80m personally, but a colleague used my tools to load 680m in Oracle, SQL-Server, and PostgreSQL servers, side by side. That said, the effective useful limit is a lot closer to 20-50 million features. Tables loaded over time are extremely vulnerable to the effects of spatial ...


9

A google on "ArcGIS READ_COMMITTED_SNAPSHOT ALLOW_SNAPSHOT_ISOLATION" returned a "What's new in ArcMap" 10.4 documentation reference. In the Geodata section it states (third bullet, emphasis mine): Beginning with ArcGIS 10.4, geodatabases in SQL Server require the SQL Server database options READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION be set ...


8

Please have a look at the Copy Rows geoprocessing tool. The code can be as simple as the following: import arcpy arcpy.CopyRows_management("C:/data/vegtable.csv", "C:/output/output.gdb/vegtable")


8

I sat in on a PostgreSQL/ArcSDE presentation (link1, link2) at this weeks Esri conference and they talked a little about this. They Esri product engineer said (at least I interpreted what she said) that: ArcGIS 10.1 only supports PostGIS 1.5 ArcGIS 10.1 service pack 1 will support simple geometry features from PostGIS 2.0, but not advanced postgis features ...


8

There are some very good reasons to use a ArcSDE Server Engine, the first being the load. When you utilize a ArcSDE Server Service you are taking the bulk of that data load off the database server and queuing it versus relying on just your local machine to store all that temp data. One thing you will see especially with a MSSQL server when you make your ...


8

I was asked this question today ("How do I identify if a featureclass has curves) and was given some arcpy code suggestions. Modify the following code as you see fit (a flag variable instead of a message for example) geometries = arcpy.CopyFeatures_management("inputFeatures", arcpy.Geometry()) import json for g in geometries: j = json.loads(g.JSON) ...


8

I know this post is a little old but I though I would share my answer since I was faced with the same issue. The following script SHOULD copy all tables, feature classes and relationships not in a dataset and also will copy over all datasets including the feature classes, topology, etc within the dataset. It will skip over any errors durring the copy adn ...


8

I think you may be going about this the wrong way. You should probably create a new feature class, specifying all the spatial reference properties that you want, and importing the fields from your source class. Then load the data from your source class to your destination class. You aren't going to be able to just change those values without actually ...


8

The Features tab of the Find tool will do this if you add every feature class in the File Geodatabase to a map. For example, if you are trying to find Afghanistan on a map of the world, you can enter Afghanistan or just Afgh in the Find tool, and you'll get a list of the features from layers in your map that contain that search string in any of ...


8

ArcSDE uses 'struct tm' to pass date fields, so it certainly has the range to support the information. I suspect, however, that you're not using the supported date type (TIMESTAMP WITHOUT ZONE), which is causing the date to get mangled.


8

Right-click on the Feature Class in question using ArcCatalog or Catalog window in ArcMap. View the Feature Class Properties. Under the General tab there is a Versioning section which will contain your answer. Example when option to move to base is checked:


8

The most important thing 9.x users need to know is that ArcSDE no longer exists. There had been no fundamental changes to the ArcSDE API since 9.0, when XML, INT64, UUID, CLOB, NSTRING and NCLOB types were added. Since then, the only changes have been Projection Engine mods to support newer projections and vertical datums. The API itself is now deprecated ...


8

It is a way to maintain object identity since the standard geodatabase objectids are not preserved after an export/import cycle. It enables you to uniquely identify your features across the entire database. That should help understand why features like replication rely on this.


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