Latest Contributions by JakeSkinner

What service pack are you running for SQL Server 2005?  You can run the following query to find out: SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') ... View more

Try building pyramids using a direct connection.  You will just need to replace '-i' with 'sde:sqlserver:<server name>.  Also, make sure you are attempting to build pyramids with the raster dataset owner (GIS_ADMIN).  I would also specify '-1' for the -L option.  This will build all necessary pyramid levels.  Ex: sderaster -o pyramid -l HRES_COLOR_MRSID_MOSAIC_2010,RASTER -v 1 -L -1 -I bilinear -D RASTER -i sde:sqlserver:<server name> -u GIS_ADMIN -p ***** ... View more

What is the command line syntax you are using when you attempt to build pyramids?  Are you using an application server connection (ie 5151) or a direct connection? ... View more

Not the most elegant way, but I got the below code working.  Could be cleaned up a bit. rows = arcpy.UpdateCursor(input) for row in rows:     Xcoord = str(row.X)     Xcoord2 = Xcoord.split(".")     XDegrees = Xcoord2[0]     Xcoord3 = float("." + Xcoord2[1])     Xcoord4 = Xcoord3 * 60     Xcoord5 = str(Xcoord4)     Xcoord6 = Xcoord5.split(".")     XMinutes = Xcoord6[0]     Xcoord7 = float("." + Xcoord6[1])     Xcoord8 = Xcoord7 * 60     Xcoord9 = str(Xcoord8)     XSeconds = Xcoord9     DMS = XDegrees + " " + XMinutes + "' " + XSeconds + "''"     row.Lat = DMS     rows.updateRow(row) del row, rows You can duplicate the code and run it for the Longitude value. ... View more

Pyramids will consume approximately 1/3 of the raster dataset size.  If this raster dataset is 24 GBs, you're looking at another 7.2 GBs in storage you'll need. I would recommend running the 'sp_spaceused' command in SQL Server Management Studio to see how much unallocated space is available.  If the tool is still executing, re-execute this query a couple times and see if the unallocated space is shrinking.  If it is, this means pyramids are still being generated. If it is not, it may be your log file is full.  You can check this by executing one of the queries below: EXEC sp_helpdb RASTER DBCC SQLPERF(logspace) ... View more

What type of database are you using (ie SQL Server 2005, Oracle 10.2.0.3)? ... View more

Try the following: import arcgisscripting gp = arcgisscripting.create(9.3) input = "<shapefile>" rows = gp.UpdateCursor(input) row = rows.Next() while row:     TimeList = row.Start_Time.split(":")     row.Hour = TimeList[0]     rows.UpdateRow(row)     row = rows.Next() del row, rows ... View more

Here is the code I got to work at 10.  You should be able to replace 'arcpy' with 'gp' and this should work at 9.3. input = "<table/feature class>" rows = arcpy.UpdateCursor(input) for row in rows:     TimeList = row.Start_Time.split(":")     row.Hour = TimeList[0]     rows.updateRow(row) del row, rows ... View more

Here is an example on how to do this.  You will need to replace 'arcpy' with 'gp'. input = "<table/feature class>" rows = arcpy.SearchCursor(input) for row in rows:     TimeList = row.Start_Time.split(":")     rows2 = arcpy.UpdateCursor(input)     for row2 in rows2:         row2.Hour = TimeList[0]         rows2.updateRow(row2) The field 'Hour' is of type Text. ... View more

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

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

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

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

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

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