POST
|
Geocoding results are not dynamic since the output is a feature class. The only type of outputs that are dynamic in this matter are event layers. You will need to re-geocode the addresses after the updates have been applied and overwrite the feature class. I would recommend running a script to do this at a given time(s) during the day.
... View more
04-27-2011
10:26 AM
|
0
|
0
|
282
|
POST
|
Personal Geodatabases are based off of the Microsoft Access framework. In Access, TIME is a reserved word: http://office.microsoft.com/en-us/access-help/access-2007-reserved-words-and-symbols-HA010030643.aspx
... View more
04-27-2011
10:09 AM
|
0
|
0
|
236
|
POST
|
I took the following course and it was a huge help: http://training.esri.com/gateway/index.cfm?fa=catalog.courseDetail&CourseID=50121644_10.x
... View more
04-27-2011
08:09 AM
|
0
|
0
|
508
|
POST
|
You can only kill direct connections with the 'sdemon -o kill' command at version 10. If you are at version 10, you will need to grant a couple other user permissions to the SDE user in order to kill direct connections: ALTER SYSTEM SELECT_CATALOG_ROLE http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/User_permissions_for_geodatabases_in_Oracle/002n0000002v000000/ If you are not at 10 you can still delete direct connections, but this must be done by deleting them through the 'sde.process_information' table. I always recommend creating a database backup before editing/modifying any repository table.
... View more
04-27-2011
07:59 AM
|
0
|
0
|
317
|
POST
|
Here is a great article that provides steps on compressing a database to state 0: http://resources.arcgis.com/content/kbase?fa=articleShow&d=29160
... View more
04-20-2011
09:33 AM
|
0
|
0
|
660
|
POST
|
When editing a versioned feature class, the edits are stored in the delta (A & D) tables. The edits will not be moved to the base table until you perform a compress. http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002q0000007v000000.htm http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00270000001v000000.htm When you register a feature class as versioned, you have the option to 'Move Edits to Base'. If this option is checked, the edits are automatically moved to the base table once the edits are saved. However, you must be editing the SDE.Default version. This option will not work for child versions.
... View more
04-20-2011
06:40 AM
|
1
|
1
|
660
|
POST
|
You could manually create an empty MXD called 'Test.mxd'. Then you can use python to add all the layer files from the directory, update the description, and delete MXD when you're finished. Ex: import arcpy, os
from arcpy import env
arcpy.env.overwriteOutput = True
env.workspace = "<lyr file workspace>"
mxd = arcpy.mapping.MapDocument(r"C:\temp\Test.mxd")
df = arcpy.mapping.ListDataFrames(mxd, "*")[0]
listFiles = arcpy.ListFiles("*.lyr")
for file in listFiles:
addLayer = arcpy.mapping.Layer(file)
arcpy.mapping.AddLayer(df, addLayer)
arcpy.RefreshTOC()
arcpy.RefreshActiveView()
for lyr in arcpy.mapping.ListLayers(mxd):
lyr.description = "N/A"
lyr.saveACopy(str(lyr))
del mxd
os.remove(<'PathToMXD>')
... View more
04-19-2011
04:13 AM
|
0
|
0
|
570
|
POST
|
I just wanted to note that an aux.xml can exist when statistics do not. For example, the aux.xml will also be used as a pointer to the pyramid file. This is explained here: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//009t00000027000000.htm You may want to go along the lines Niklas mentioned. Ex: try:
arcpy.GetRasterProperties_management(input, "STD")
print "Statistics exist"
except arcpy.ExecuteError:
arcpy.CalculateStatistics_management(input)
print "Statistics were calculated"
... View more
04-19-2011
03:21 AM
|
0
|
0
|
904
|
POST
|
I believe Heather's solution is correct. Here is a script that you can use to delete empty feature classes just in case: import arcpy
from arcpy import env
env.workspace = r"C:\Temp\Test.gdb"
listFCs = arcpy.ListFeatureClasses("*")
for fc in listFCs:
count1 = str(arcpy.GetCount_management(fc))
if count1 == "0":
arcpy.Delete_management(fc) You can easily turn this into a tool by changing 'env.workspace' to: env.workspace = arcpy.GetParameterAsText(0) Then import the script into ArcToolbox and set an input under the Parameters tab within the Properties.
... View more
04-18-2011
08:00 AM
|
1
|
1
|
1076
|
POST
|
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
04-18-2011
07:09 AM
|
0
|
0
|
497
|
POST
|
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
04-08-2011
12:22 PM
|
0
|
0
|
918
|
POST
|
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
04-08-2011
09:32 AM
|
0
|
0
|
918
|
POST
|
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
04-08-2011
04:23 AM
|
0
|
0
|
302
|
POST
|
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
04-08-2011
02:47 AM
|
0
|
0
|
424
|
POST
|
I found you can use field alias' with the following widget: http://www.arcgis.com/home/item.html?id=4ec33120c9ea4d019fddf722fc34ea3c
... View more
04-05-2011
05:59 AM
|
0
|
0
|
258
|
Title | Kudos | Posted |
---|---|---|
3 | Thursday | |
2 | Thursday | |
1 | 2 weeks ago | |
2 | Thursday | |
1 | 07-26-2024 04:14 AM |
Online Status |
Online
|
Date Last Visited |
6 hours ago
|