Latest Contributions by JakeSkinner

Also, you should note the following with Mosaic Datasets in SDE.  When the ArcGIS client connects to SDE as the database user it will only have read privileges to the mosaic dataset overviews.  The overviews, by default, are stored in the SDE geodatabase.  Once you zoom into a large enough scale you will be accessing the raw imagery on disk.  Therefore, the windows user from the ArcGIS client will need read privileges to the imagery. ... View more

I think there may be a bug with the mapping.findAndReplaceWorkspacePaths function.  I've been running some tests with ArcGIS 10 SP1 and cannot seem to get this to work.  For example, I tried a simple test and the paths would not update: import arcpy mxd = arcpy.mapping.MapDocument(r"C:\Temp\Fires.mxd") mxd.findAndReplaceWorkspacePaths(r"C:\TEMP\test.gdb", r"C:\Temp\Python_Test.gdb") mxd.saveACopy(r"C:\Temp\Project2.mxd") del mxd I would recommend escalating this matter to tech support. ... View more

Try using the replaceWorkspaces function: import os, arcpy folder = r"C:\TEMP" for (path, dirs, files) in os.walk(folder):     for file in files:         if file.endswith(".mxd"):                 mxd_path = os.path.join(path, file)                 mapdoc = arcpy.mapping.MapDocument(mxd_path)                 mapdoc.replaceWorkspaces(r"C:\DATA\Philadelphia.gdb", "FILEGDB_WORKSPACE",                                          r"Database Connections\SQL - VECTOR@VECTOR.sde", "SDE_WORKSPACE")                 mapdoc.save() del mxd_path del mapdoc                 ... View more

Here is an example on how to add the layer file to your current MXD: import arcpy from arcpy import mapping mxd = mapping.MapDocument("CURRENT") df = mapping.ListDataFrames(mxd, "Layers")[0] addLayer = arcpy.mapping.Layer(r"C:\DATA\PA_DEM.lyr") mapping.AddLayer(df, addLayer) arcpy.RefreshTOC() arcpy.RefreshActiveView() Here is an example on how to add the layer file to a particular group layer in your current MXD: import arcpy from arcpy import mapping mxd = mapping.MapDocument("CURRENT") df = mapping.ListDataFrames(mxd, "Layers")[0] targetGroupLayer = mapping.ListLayers(mxd, "L00 (147,748K)", df)[0] addLayer = mapping.Layer(r"C:\DATA\PA_DEM.lyr") mapping.AddLayerToGroup(df, targetGroupLayer, addLayer, "BOTTOM") arcpy.RefreshTOC() arcpy.RefreshActiveView() ... View more

I believe that I am trying to do something similar in Arcsde 10.  I am trying to use a stand alone table with updated property ownership changes lined to parcel account numbers.  Would a "relate" know to replace certain attribute fields with the data from the stand alone table?   Is this something that would require a script?  I'm not very versed in scripting yet but wouldn't mind giving it a shot. The relate will only link the feature class to the stand alone table using a primary and foreign key so when you select a parcel, you can see all the related information in the stand alone table. Are you looking to have attributes in the feature class update from the related table attributes? ... View more

I found you can use field alias' with the following widget: http://www.arcgis.com/home/item.html?id=4ec33120c9ea4d019fddf722fc34ea3c ... View more

This looks to be a bug with the ListLayoutElements function.  The "SHEET*" wildcard should be returning the text elements that begin with "SHEET".  I would recommend reporting this to tech support so they can document this bug.  I haven't been able to find a workaround yet, but I'll keep looking a little bit longer. ... View more

You will need to add 'arcpy.RefreshActiveView()' at the end of your code.  Try the following: import arcpy mxd = arcpy.mapping.MapDocument(r"CURRENT") for elm in arcpy.mapping.ListLayoutElements(mxd, "TEXT_ELEMENT", "*SHEET*"):     if elm.type == "TEXT_ELEMENT":         elm.text = "SHEET 7001" arcpy.RefreshActiveView()       Note:  I also had to add an '*' in front of SHEET for the wildcard to work correctly. ... View more

With the relate, if you add the service to ArcMap and use the identify tool you can drill down to the related dbf table.  I have not tested this with a web application though. ... View more

Currently, there doesn't appear to be a way to convert labels to an annotation feature class using python.  However, there has been an enhancement request logged for this functionality: NIM003923 'Create Featureclass' tool should have an options to create Annotation or Dimension classes, to match ArcCatalog's New Feature Class functionality. ... View more

Yes, this will work.  What you will have to do is set up a relate in ArcMap.  However, you need to have matching records in the feature class that match that of the DBF table.  For example, a parcel ID number.  The field names do not have to be the same, but the values do. You can create the relate by right-clicking on the feature class in ArcMap > Joins and Relate > Relate.  After the relate is created, save the map document and then publish it to ArcGIS Server.  As the DBF table is updated with the application, the service will automatically reflect these changes. Note:  this relationship is only maintained in this map document.  If you add the feature class to another map document, you will have to recreate the relate. ... View more

I would recommend using a different storage type, such as ST_GEOMETRY, if you are not querying the data outside of ArcGIS or if no other application is dependent on this data type.  Or you can query the Area and Length through SQL*PLUS: http://resources.arcgis.com/content/kbase?fa=articleShow&d=27329 ... View more

1.  Can you try creating the mosaic dataset as a different user other DBO?  For example, create a user called 'test' in SQL Server Management Studio and grant the following permissions: CONNECT CREATE TABLE CREATE FUNCTION CREATE PROCEDURE http://resources.arcgis.com/content/kbase?fa=articleShow&d=34639 Connect as the 'test' user in ArcCatalog and try to create the mosaic dataset. 2.  Was this database upgraded from a previous version of SQL Server?  If so, check to make sure the compatibility level is set to 100 by opening SQL Server Management Studio > right-click on database > Properties > Options. ... View more

Unless your Enterprise Geodatabase is really maintained well, building the map services from File GDBs stored locally on the server is your fastest option for drawing speeds.  When using an Enterprise Geodatabase it is constantly receiving queries which will take slightly longer compared to the file based File Geodatabase.  Here are some advantages of using the Enterprise Geodatabase and when you may want to migrate to one: 1.  Multi-user editing 2.  Archiving 3.  Replication 4.  Additional security 5.  Centrailized location for data ... View more