|
POST
|
You can use python to script the resourcing of all your map documents. Updating and fixing data sources with arcpy.mapping—Help | ArcGIS for Desktop A simple example would be... import arcpy
mxd = arcpy.mapping.MapDocument(r"C:\ResourceMe.mxd")
for lyr in arcpy.mapping.ListLayers(mxd):
if lyr.isRasterLayer:
print lyr.dataSource
wsp = lyr.workspacePath
ds = lyr.datasetName
lyr.replaceDataSource(r"C:\Users\userprofile\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\DirectConnect.sde", "SDE_WORKSPACE", ds, False)
lyr.name = ds
else:
mxd.findAndReplaceWorkspacePaths(r"C:\Users\userprofile\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\AppSvr10.sde",r"C:\Users\userprofile\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\DirectConnect.sde", False)
mxd.saveACopy(r"C:\ResourceMe1.mxd")
del mxd
print complete
... View more
02-23-2018
03:25 PM
|
1
|
2
|
2637
|
|
POST
|
Could you create a feature class with the spatial data and a relatable field, then use a relationship class to relate the feature class to the tabular data? As far as the standalone table, I do not know of a supported way to add a spatial column to an existing table with existing data that is also registered as versioned (even utilizing SQL for this will be tricky, and unsupported from an Esri perspective). Benefits of relationship classes—Help | ArcGIS for Desktop
... View more
02-23-2018
03:21 PM
|
0
|
0
|
959
|
|
POST
|
Will you need all four users to edit the same data at the same time? You may need to utilize enterprise geodatabases. You could even take advantage of the Desktop license which utilizes SQL Server Express as the RDBMS...it's free Using this method will provide you out of the box administrative tools to back up your geodatabase, add users and manage permissions that more robust organizations might usually do via a SQL Server database administrator, using applications like Microsoft SQL Server Management Studio. Create a desktop or workgroup geodatabase—Database Server (Desktop) installation guide | ArcGIS Desktop Once you have your geodatabase created, whether you choose enterprise or file geodatabases, you can just copy and paste the old data into the new location. Copy and paste will keep your Esri maintained values the same (for example, object ids). Import/export tools will recalculate those values to be sequential (so if you have objectids as primary or foreign keys in relationship classes you don't want them recalculated). Once the data is imported into your new geodatabase you will just set any functionality needed, for example, in an enterprise geodatabase you will need to register the data as versioned after the data transfer in order to allow for multi-user editing. I hope this helps!
... View more
02-23-2018
01:57 PM
|
0
|
0
|
1128
|
|
POST
|
When you upgrade to Win10, please test and let me know if you still see the slowness. If one of your coworkers already on 10 can upgrade their Esri version to 10.6 that would give us a good comparison as well. Keep me posted.
... View more
02-23-2018
09:59 AM
|
0
|
1
|
2056
|
|
POST
|
James, Do you happen to have ArcDesktop installed on an OS other than Windows 7 to test? I am noticing a pattern here with the OS being Windows 7. Internally I am doing some research and have brought this forum up to my development liaison. -TM
... View more
02-23-2018
09:36 AM
|
0
|
3
|
2056
|
|
POST
|
Does this slowness also happen for you in ArcGIS Pro?
... View more
02-22-2018
02:42 PM
|
0
|
7
|
2623
|
|
POST
|
If this is still an issue for all of you then please report this to Esri Support Services, 888-377-4575. The case should be created and owned by an analyst who works on enterprise geodatabase editing issues. Please provide them the version of Esri products, RDBMS and version, and operating system each are on (if they are not local to each other). If you have confirmed tests in 10.5 do NOT produce performance problems, then include those patterns.
... View more
02-22-2018
01:58 PM
|
0
|
0
|
2056
|
|
POST
|
Skyler Dewey...Are you also on Windows 7? And per the statement below, what exact workflow did you use to "repath the source"? " I have been able to edit slowly by repathing the source but that seems to be the only thing that worked for me."
... View more
02-09-2018
11:23 AM
|
0
|
1
|
2859
|
|
POST
|
What operating system are all of you using to run ArcDesktop?
... View more
02-09-2018
09:10 AM
|
0
|
8
|
2859
|
|
POST
|
Can you make sure that your user is still associated with the dbo schema? This can be confirmed in SQL Server Management Studio.
... View more
02-08-2018
11:01 AM
|
0
|
0
|
8811
|
|
POST
|
Check the geoprocessing metadata in the GDB_ITEMS table. When geoprocesses are ran on enterprise data, the process metadata is stored in the GDB_ITEMS table. Over time this can build up. Here is an article on how to do delete the metadata. How To: Delete geoprocessing history from a geodatabase
... View more
02-08-2018
10:10 AM
|
1
|
0
|
1136
|
|
POST
|
This is a SQL Server geodatabase? In the error the object you are trying to alter is GIS_Essex_power.dbo.sw_cubicle.Test_report ^I can't tell if the owner is 'dbo' or 'sw_cubicle'. SQL Server fully qualified naming conventions are database.schema.object What is the full name of your database, schema and object. Are there periods in any of these names? Have you ever been able to alter this object?
... View more
02-08-2018
10:06 AM
|
1
|
0
|
8811
|
|
POST
|
I see this issue occurs in both Collector AND web maps in AGOL. Where is the data sourced from? Is it a hosted feature service, or is it in an enterprise geodatabase registered with Server, etc.? Can you add the data from that source database to ArcMap, and edit? If you CAN edit the source data in ArcMap, then it makes me think it is the feature service... Is it only inserts that cause this issue? Can you update or delete existing features? Does this feature service have all the necessary capabilities, i.e., Create,update, delete. Are geometry updates allowed on this feature service?
... View more
02-08-2018
09:54 AM
|
0
|
2
|
2780
|
|
POST
|
Since you are in an enterprise environment, you can check other factors that may affect performance: 1. Are you editing data that is registered as versioned? ...Have the versions been reconciled, posted and deleted when no longer in use? ...When was the last compress ran, and how successful was it? 2. Have you tried rebuilding indexes and statistics on the data? Five Best Practices for Maintaining an ArcSDE Geodatabase | ArcGIS Blog If you still have ArcDesktop 10.5.1 installed somewhere, and you test the same workflows on the same data, do you see the performance is still slow?
... View more
02-08-2018
09:04 AM
|
2
|
1
|
6249
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 01-26-2016 02:45 AM | |
| 1 | 03-05-2015 06:09 AM | |
| 1 | 03-09-2018 09:01 AM | |
| 1 | 03-08-2018 08:53 AM | |
| 1 | 10-24-2017 11:14 AM |
| Online Status |
Offline
|
| Date Last Visited |
11-11-2020
02:24 AM
|