Tag Info

New answers tagged

0

You could have all of your connections previously established. When you want to run the script as "SDE" you could then establish your workspace using the connection file as "SDE". If you wanted to run the script as "DATA" you could then establish your workspace using the connection file as "DATA". That would be an effective way to utilize different ...


1

The answer which I found yesterday, and PolyGeo referenced in his comment above, was to use the full path to the sde instead of the relative path. I still don't understand why the IDLE GUI/shell can't use the relative path when the ArcMap python window can.


2

Situations requiring edit sessions: Feature classes participating in a topology Feature classes participating in a geometric network Versioned datasets in ArcSDE geodatabases Some object and feature classes with class extensions I'd say you need to start an edit session, and save the edits before you do the append. The Editor class allows use of ...


2

Yes, you will need to use the external procedure agent if you want to access the XML columns in the SDE.GDB_ITEMS_VW views. By default, the XML columns in the GDB_* tables are stored using ESRI's XML implementation. The functionality to convert these to a CLOB is included in the ST_Geometry library, which is accessed using the external procedure agent. ...


0

Give this a read - Editing The ArcGIS Web APIs provide simple feature editing. The features must come from an ArcSDE geodatabase. This geodatabase can be licensed for either workgroup or enterprise use and does not have to be versioned.


2

You may use ListWorkspaces method (once you make the connection) to list the existing databases within SDE: Lists all of the workspaces within the set workspace. Search conditions can be specified for the workspace name and workspace type to limit the list that is returned. workspaces = arcpy.ListWorkspaces("*", "SDE") for workspace in ...


0

Look into this. I think this will solve your problem. http://arcscripts.esri.com/details.asp?dbid=15501


0

Thanks a lot Vince for you kind support an valuable information. However, the problem was that he st_geometry had not been correctly installed at the time I ran the Create Enterprise Geodatabase Tool. I had to fix the exproc file so as during the creation of the geodatabase, the st_geometry to be properly installed. The absence of St_geometry made my ...


1

I don't think you can enable attachments more than once per feature class. The easiest way would be to have different feature classes for which attachments you want visible through the feature service.


0

It turns out the MXD was just corrupt. I remade my mxd and everything worked fine. There were only lines and points.


1

ArcGIS is very sensitive to database names. You cannot restore data unless the database name is identical. You will need to use Feature Class to Feature Class or a copy/paste, or any of the other ways to copy data with Desktop or ArcPy (the list of options can be daunting). All transfers should be done as the data owner(s), not as the administrative 'sde' ...


0

First of all,let me apologize if my post had any misleading,maybe it implied that SDE does not apply Uncommitted read for its transaction isolation level.As I found using SQLServer profiler(after a lot of traces),I found even SDE applies "Commited Read" when query to its repository,but using profiler,I didn't find any command issued by SDE related to ...


0

Save the syntax below to a file with a .sql extension (ie: C:\TEMP\get_table_privs.sql). Then log into SQL*Plus as the owner of the table you want to see the privileges for and execute the script. Hope this helps. -ST ------------------------- -- GET_TABLE_PRIVS.SQL -- ------------------------- select table_name from sde.layers where owner = USER union ...


2

I think your proposed solution may be too complicated. I don't think there really is any such thing as a "non-spatial database". In my view, there's just data, some of which happens to have geometry, and some of which doesn't happen to have direct relationship to geometry (in the end, most data is at least somewhat spatial). Best practice for integration ...


0

The problem was that I was not completing the geodatabase administrator field since it says that it is optional. When I provided one, it worked properly.


2

It looks like EZConnect can't connect for whatever reason (3a works/3b doesn't). You can try adding "ezconnect" to NAMES.DIRECTORY_PATH in the sqlnet.ora file. Hopefully that will make 3b from @Albert Godfrind's answer work. The LDAP connection may fail from QGIS because you have something like the Oracle Instant Client somewhere in the path before your ...


1

You will need the sys password of that Oracle instance in order to run the create enterprise geodatabase. If you have another user with dba privileges you can run this to change the password: alter user sys identified by NEWPASSWORD; If you have a database administrator in your organization, they should have the sys password. Optionally, if you have an ...


0

The easiest way would be to enable editor tracking. You would be able to see what was edited, who edited it, what day and time it was edited. Editor tracking creates four new columns, however. The other way would be to write a database trigger to populate a column or table any time a insert or update is made on the feature class. You could populate the ...


1

Right click the layer and select "Properties..." to open the "Layer Properties" window. Select the "Source" tab and check to see if the "Geometry Type:" is "Multipoint" or a similar type of geometry. If so than there will be multiple points/polygons that correspond to one record and will result in the behavior you describe.


2

Those sort of issues can be hard to track. My approach would be to remove QGIS and SDE from the picture and make sure the connection works with plain Oracle tools. That will also help your IT support debug the issue. 1) Do: $ tnsping <tns_name> Does this work ? Or does it fail the same way 2) Do: $ tnsping ...


0

You are better off using a version scenario for the developers. Going off what Vince stated I don't think it's possible to use your mentioned workflow. It would have to either be separate instances or some sort of version workflow/replication.


1

You can't have a service point at a different instance (or even user) depending on the connected user, but you could configure a proxy to point at different services. This would require N, N+1, or N+2 services for each logical service (depending on whether you have test and production requirements as well). You'd probably be better off with personal USER ...


1

Look into this article. It explains how to apply schema changes with replicas and sync those changes back to the parent. http://resources.arcgis.com/en/help/main/10.1/index.html#//003n000000t2000000



Top 50 recent answers are included