|
POST
|
Hi Alexander, There is no way to do this using Arcpy and I would caution doing this in the DBMS using DBMS tools as you need to know exactly what tables need privileges to be applied. The Change Privileges tool was implemented at a time when ArcMap/ArcCatalog context menus only allowed you to apply View (select) or Edit (insert, update, delete) privileges and unfortunately was not updated at 10.1 when we replaced the privileges dialog to allow you to set these individually for non-versioned data. This is the first time we have had a customer request for this specific functionality to be scripted and have therefore not put effort into developing this functionality. I would suggest entering this on ideas.arcgis.com to see if you can get other members of the community to support this. With enough demand I think this would be a good idea to move forward on. Russell
... View more
10-29-2014
01:51 PM
|
0
|
0
|
1328
|
|
POST
|
The WITH GRANT option is only available from the database using database level tools. I would not recommend using this privilege to manage privileges for data in an enterprise geodatabase, especially when data is contained in a feature dataset. There are many cases (too many to list) where an ArcGIS dataset is not just one table but many tables in the underlying DBMS. If you use database tools to manage privileges on these datasets and happen to miss one of the underlying tables you will run into issues reading and writing this data. This can lead to data corruption and a lot of sadness. Please stick to managing privileges for datasets with Esri tools. The recommended approach to this is to load data using a 'headless' user. This user could be a database user or an OS authenticated user that isn't associated to someone specific in your organization. Loading data as this user will allow you to manage privileges using this user. Hope this helps, Russell
... View more
10-24-2014
03:39 PM
|
1
|
0
|
1505
|
|
POST
|
The only thing I can think of is that you did not choose the relative paths option when creating the script tool that is in your model.
... View more
10-23-2014
05:56 PM
|
1
|
1
|
849
|
|
POST
|
I cannot directly answer your question because I am personally not familliar with all of the local government maps/apps and if they rely on editor tracking fields. I would suggest that rather than using the 'Manage > Enable editor tracking' option to enable editor tracking that you use either the GP tool or go to the properties page for the dataset. Using either of these options allows you to specify an already existing field to use for any of the four editor tracking fields. You could point to the existing LASTUPDATE and LASTEDITOR and use these instead. Hope this helps, Russell
... View more
10-22-2014
12:57 PM
|
2
|
3
|
1227
|
|
POST
|
When your data is archive enabled the timestamps on your data are used to determine what the current representation of your data is. We do not actually delete the records, rather we 'mark' them as deleted by setting a timestamp to the current moment. I would strongly caution against running delete queries in SQL before running your report. Rather I would suggest that you use the archive view to access your data or alter your Excel report to only query data that is current (gdb_to_date field = 12/31/9999). Below are some links to some of the help documentation on accessing your data via SQL. SQL Access to enterprise geodatabase data. What is an archive view The archive process - see the paragraph "Enabling archiving on nonversioned data" Hope this helps, Russell
... View more
10-22-2014
12:51 PM
|
0
|
0
|
1246
|
|
POST
|
Hi Matt, You can update the extent of your feature class by opening the properties of the feature class in ArcCatalog or the Catalog window in ArcMap and going to the 'feature extent' tab. On this tab you can see the extent of your feature class and there should be a button enabled that allows you to recalculate the extent. You will need to be connected as the owner of the data in order for this button to be enabled. After clicking this button you should see a new extent that is based off of the extent of your data. Russell
... View more
10-22-2014
12:27 PM
|
0
|
1
|
5514
|
|
POST
|
Hi Clara, I just sent you a message with my email address.
... View more
10-22-2014
09:09 AM
|
0
|
0
|
1654
|
|
POST
|
Hi Clara, I am glad to hear that you are on your way and things are working as expected. I tried a simple test on my end to try to reproduce this issue but was unsuccessful. Were you viewing the records in Oracle or in ArcGIS? If using Oracle tools to view the data you may not have seen the edits in the table because they would be stored in the delta tables. I would like to track down the cause of this issue, are you able to send me the version of desktop and geodatabase that you are working with? Thanks, Russell
... View more
10-21-2014
01:02 PM
|
0
|
2
|
1654
|
|
POST
|
We should support the ability to enable editor tracking on columns that already have data in them. Can you tell me more about exactly what you had in the column before you attempted to enable editor tracking. I assume you are using a string/text field, can you confirm? You mention that you used the properties page to enable editor tracking, can you please confirm this? Did you try with the enable editor tracking geoprocessing tool? Can you let me know what version of Desktop, Geodatabase, and Oracle you are using? Is your data registered as versioned? I tried to replicate the issue you are describing and in my case everything worked as you desired.
... View more
10-20-2014
05:26 PM
|
0
|
5
|
1654
|
|
POST
|
Hi Clara, Are you working with hosted feature services, either ArcGIS online or Portal for ArcGIS (with datastore)? Russell
... View more
10-20-2014
04:13 PM
|
0
|
7
|
1654
|
|
POST
|
The Rebuild Indexes tool will rebuild indexes on two different 'types' of tables in your geodatabase. In the case of the rebuild indexes tool we have separated the tables into 'data tables' and 'system tables'. Data tables are the tables that you get returned when you run any of the list functions (like what you are doing in your script). System tables are those used by the geodatabase internally (states, state_lineages table for example). Within the tool there is a parameter 'include_system' with options 'SYSTEM' and 'NO_SYSTEM'. When you choose 'SYSTEM' you need to be connected as the geodatabase administrator, because only the geodatabase administrator has privileges to update indexes on these tables. In some cases you may want to only update the system table indexes. You can do this by running the tool and providing the 'SYSTEM' parameter and NOT providing any other datasets in the in_datasets list. If you try to run the tool using 'NO_SYSTEM' and NOT providing any other datasets in the in_datasets list the tool will fail. It appears that since you are using the SYSTEM parameter the tool is executing properly. Through Python we do not find all of the datasets that your user owns and automatically update indexes, you need to provide the list. To answer your side question, when using geoprocessing/python the permissions are coming from the .sde connection file. In the case that you are using Operating System Authentication in your .sde connection file the permissions will then come from the OS user who is running the script.
... View more
10-16-2014
11:24 AM
|
1
|
2
|
1574
|
|
POST
|
You do not need to be working in an enterprise (SDE) geodatabase to schedule scripts to run. This can be accomplished via the windows task scheduler on Windows or a cron job on Linux. Below are two links for how to do this on Windows. Skip to 44:30 in this video to see how to use the task scheduler to call a python script: Administer Your Enterprise Geodatabase through Python | Esri Video Also, there is a blog post on this here: Scheduling a Python script or model to run at a prescribed time | ArcGIS Blog
... View more
08-25-2014
02:09 PM
|
2
|
0
|
1209
|
|
POST
|
Geodatabases on the SQL Express platform were traditionally managed solely through ArcCatalog. This was done to provide an easy user experience to the geodatabase admin. Through ArcCatalog there were options for adding users, backing up and restoring the database. There were also options for viewing and managing user privileges. We provided what we felt was a few (suitable and easy to understand for SQL Express admins/users) roles that admins could use to administer privileges. These are the roles that you were asking about. We did not however, provide an option for creating new roles. With enterprise geodatabases on SQL Server we do not limit what roles you want to use and do not make any assumptions about the roles you want to create. This gives more flexibility to admins who want more discreet or more general roles for their organization. These admins typically configure and manage their geodatabases using a combination of SQL Server Management Studio as well as ArcCatalog.
... View more
08-25-2014
09:36 AM
|
1
|
0
|
2172
|
|
POST
|
These roles should be created when using SQL Express workgroup or desktop geodatabases. However if you are using enterprise geodatabases these roles are not created. Types of geodatabases: Geodatabase | Multiuser Geodatabase
... View more
08-22-2014
09:48 AM
|
3
|
2
|
2172
|
|
POST
|
William's answer is correct. We use the same codepath with Copy_management as we do with right-click 'Copy' - right click 'Paste' (or control+C, control+V). This maintains things like domains/relationships etc, it is actually making a copy of the data and its other related data and pasting it. Feature class to feature class is essentially an export of the data. This only copies what you specify in the tool. Copy preserves geodatabase maintained values such as OID or GlobalID while exporting data will not maintain these values.
... View more
08-20-2014
11:38 AM
|
1
|
0
|
2606
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | Wednesday | |
| 4 | 05-21-2025 08:31 AM | |
| 3 | 05-20-2025 12:14 PM | |
| 1 | 08-29-2013 08:26 AM | |
| 1 | 08-20-2014 11:38 AM |
| Online Status |
Offline
|
| Date Last Visited |
Wednesday
|