Tag Info

New answers tagged

0

It is possible but not easy. you should write custom ArcObject code to disable any tool or command that exports feature data. And off course you should manage users with a custom user manager application to set their permissions (enable/disable feature export)


3

Set up Enterprise Geodatabase The Create Enterprise Geodatabase tool creates a database, storage locations, and a database user to be used as the geodatabase administrator and owner of the geodatabase depending on the database management system (DBMS) used. It grants the geodatabase administrator privileges required to create a geodatabase, then ...


0

Came across this recently. This has solved the issue of deleting all of the features in a .sde connection. If you only want to clear specific features, you can use .remove() on the featureClasses list, or create your own list. arcpy.env.workspace = r'path to sde connection of the sde database' featureClasses = arcpy.ListFeatureClasses() for fc in ...


0

I've mitigated this issue by: Put the port number in the name of the connection file as soon as its created. Add a view that will report system info--the view will be visible in ArcCatalog, so you can see which port you are connected on: CREATE VIEW public.vw_sysinfo AS SELECT inet_server_port() AS inet_server_port, current_database() AS ...


2

The best way to handle this in ModelBuilder is to use the Iterate Feature Classes tool. It will find all the feature classes in the specified workspace (such as SDE geodatabase) and create an iterable list which you can then process with the Copy Features GP tool. The Copy Features will all the feature classes one by one, and you shouldn't care if any ...


1

The easiest way is to use "Iterate Feature Classes" tool in Model Builder. You can access it from: Insert > Iterators > Feature Classes If you want to copy all feature classes, leave WildCard and Feature Type parameters empty, and just set the Workspace.


0

I've run into the same problem: "workspace already in transaction mode". I had Microsoft SQL Server database connected to ArcCatalog as SDE. And decision in my case was just to change type of column "timestamp" of target table to "image".


0

Make your user the Owner(DBO) of the database and test. If it works then there is something wrong with your user and it exactly what it says. The Schema name and the user names need to match. If you use the SQL tools and dig in to the User and Schema sections you will see that they don't match. Your Schema will probably say dbo and your user is something ...


0

Some things to look in to Check that your SDE DB connection is using the GISADMIN credentials. Check that your Geometric Network was added to the SDE DB using the GISADMIN account.


0

I have cobbled this Python code together from bits around the interweb and it works just fine for me in my win7, Python2.7, arcgis 10.2, Oracle 11g environment. It does CopyDatasets, CopyFeatureClasses, CopyTables from an existing SDE to a new GDB. While it may have some unnecessary modules at "# import modules" i use this as a template and dont mind the ...


2

As an alternative to pymssql, you might consider using the arcpy.ArcSDESQLExecute class to execute your SQL statements. Something along the lines of (simplest form and untested): import arcpy sde = r"Database Connections\Connection-to-SDE.sde" sde_conn = arcpy.ArcSDESQLExecute(sde) sql = """CREATE TABLE tempIntersect_withNATA (ZIP varchar(max), ...


2

When you add feature classes into ArcMap map document they become layers. You can define which fields will be visible for the layer in the Layer Properties window or directly in the Attribute table window. It is hard to guess, but they might have re-added feature classes and the settings they had for layers were updated. Esri help page: Setting whether ...


1

There is a link you can look regarding your first question: https://geonet.esri.com/thread/45017



Top 50 recent answers are included