POST
|
Hi everyone, we recently set up a new ArcSDE 10.2 on a Posgres 9.2 Database and moved all our FeatureClasses (about 750) over from our Oracle based ArcSDE. However, establishing the connection now takes a couple of minutes to complete whereas when we were still in the testing phase (about 10 FeatureClasses) everything ran rather quickly, connections taking a few seconds to establish. So far we have analyzed that ArcGIS queries all FeatureClasses for the privilege to INSERT, UPDATE, DELETE and SELECT separately for each FeatureClass before finishing the connect. This seems to be the major time sink for us. Is there any way to speed this up or avoid this sort of query all along? After all it would technically suffice if this query was done per FeatureClass right before the action is performed rather than do this for all FeatureClasses beforehand. -Florian
... View more
08-29-2014
06:24 AM
|
0
|
9
|
5183
|
POST
|
Hi everyone, I'm looking for a service that holds information on all zip code areas worldwide. All I need is the zip code and the corresponding polygone, nothing else. I want to embed this in a MapService hosted on ArcGIS online. Does anyone know where I could find such a service? Thanks, Florian
... View more
10-29-2013
05:33 AM
|
0
|
0
|
329
|
POST
|
Hi, Is there a limit to the length of the JSON string when sending a POST request to the REST interface aof ArcGIS for Server's Printing Tools' "Export Web Map Task" ? I didn't find any documentation to any limitations so I presume only firewall limitations apply. But I need to make sure there are no such limits on ArcGIS for Server before starting to implement my application. The reason I ask is that I ran into a similar problem when using a FeatureService. In that case the JSON string got cut off by the REST interface after about 2000 features. The solution to this was rather simple: splitting the big request up into several smaller ones. However, the JSON for the "Export Web Map Task" can't be split up. So if there are any limitations to the JSON length, please let me know. So I can plan ahead and maybe look for alternative ways to implement my application. Thanks, Florian
... View more
04-16-2013
04:06 AM
|
0
|
2
|
4673
|
POST
|
Hi, I am facing the folling problem: We have a bunch of MXD files which contain some layers that reference a SDE as datasource. We are about to change our SDE-server. The new server is already running and contains the nessecary data. As we don't want to change each MXD individually I created some bash and python scripts that should do the job for us. I am using the function "findAndReplaceWorkspacePaths" to switch the .sde connection files. As I want to keep the original file I use "saveACopy" to create a new MXD-file with the new connection. However the new MXD-file seems corrupt since I can't open it with any ArcGIS Desktop tools (ArcMap, ArcCatalog MapPathEditor) yet I can publish the MXD as a Service on our ArcGIS Server 10.0 Basically I use the following two Scripts to change a MXD: Create the new SDE-connection file:
import arcpy
folderName = "/arcgisserver/geoserv/test"
fileName = "Connection_to_new_server.sde"
serverName = "SERVER-IP"
serviceName = "5151"
databaseName = ""
authType = "DATABASE_AUTH"
username = "user"
password = "pass"
saveUserInfo = "SAVE_USERNAME"
versionName = "SDE.DEFAULT"
saveVersionInfo = "SAVE_VERSION"
arcpy.CreateArcSDEConnectionFile_management (folderName, fileName, serverName, serviceName, databaseName, authType, username, password, saveUserInfo, versionName, saveVersionInfo)
Changing the MXD:
import arcpy
mapdoc_in = "/source/path/source.mxd"
mapdoc_out = "/target/path/target.mxd"
sde_src = "/home/user/Connection_to_old_server.sde"
sde_target = "/home/user/Connection_to_new_server.sde"
mxd = arcpy.mapping.MapDocument(mapdoc_in)
mxd.findAndReplaceWorkspacePaths(sde_src, sde_target)
mxd.saveACopy(mapdoc_out)
del(mxd)
exit()
When running the scripts no errors are promted. Could it be an encoding related problem? (different encoding on the server running the script and the user's PC that created the original MXD) regards -Florian ps: If I check the workspace paths of all the layers of the newly created MXD they all point correctly to the new server
[...]
MXD = arcpy.mapping.MapDocument(fullpath)
for lyr in arcpy.mapping.ListLayers(MXD):
if lyr.supports("workspacePath"):
source = lyr.workspacePath
print "%s -> %s" % (lyr, source)
del MXD
... View more
01-15-2013
06:35 AM
|
0
|
1
|
2182
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|