Latest Contributions by JakeSkinner

Hi Trista, A multiversioned view is the same as a versioned view.  See the 'Legacy' note here. A versioned view is dynamic, however the table you created using the query I previously sent is static.  I tested to see if I could create a trigger on the A & D tables so that when the feature class is updated, the query: EXEC sde.set_current_version 'edit_1' select * into Airports_VW_Edit from Airports_VW is executed again.  This would make the 'Airports_VW_Edit' table, in this example, dynamic.  It worked for the most part but will not show the last edit.  I'll let you know if I am able to determine what is causing this. ... View more

Hi Chris, You can achieve this using an Update Cursor.  Cursors give you have the ability to set a working coordinate system.  Take a look at the 5th post here. ... View more

Hi Trista, Sorry, I was incorrect before.  You will actually have to set the version in SQL Server: http://resources.arcgis.com/en/help/main/10.1/index.html#/in_SQL_Server/006z0000000z000000/ What you could do is set the version, then write the results of your query to a new table.  Ex: EXEC sde.set_current_version 'edit_1' select * into Airports_VW_Edit from Airports_VW What the above codes does is sets the geodatabase to the version ("edit_1") I want to query.  Then it queries the versioned view ("Airports_VW") and writes the query to a new table ("Airports_VW_Edit").  You can then add the "Airports_VW_Edit" to Excel. ... View more

Hi Patrick, What version of ArcGIS are you using? Does the imagery reside in the same folder as the file geodatabase the raster catalog resides in? You stated that you tried the 'Repair Raster Catalog Paths' tool.  Are you receiving any errors when you execute this tool? ... View more

Make sure you are connected to the version you want to create the view for.  You can change the version by right-clicking on the geodatabase > Geodatabase Connection Properties. ... View more

Hello, I have receive a .gdb with 38 files inside, but I want to change the coordinate system of each shapefile. Is there a way to do it quickly or I need to change one at a time? Thank's You will most likely want to run the Project geoprocessing tool.  With geoprocessing tools, you can run them in batch by right-clicking on the tool > Batch.  Here is some more information: http://resources.arcgis.com/en/help/main/10.1/index.html#//00210000000w000000 ... View more

Hi Trista, First, create a versioned view of the feature class you need to add to excel.  Versioned views allow you to read or edit versioned data in a geodatabase table or feature class.  Here is some more information: http://resources.arcgis.com/en/help/main/10.1/index.html#//006z0000000q000000 http://resources.arcgis.com/en/help/main/10.1/index.html#//006z000000vr000000 After you create the versioned view you can add this to Excel.  Here is a helpful link I found: http://office.microsoft.com/en-us/excel-help/connect-to-import-sql-server-data-HA010217956.aspx ... View more

Okay - great. What "ArcTools" if any are you using to do that? I am using Calculate Field and writing an Expression saying to take this field from the table to put it into this field inside the feature class. For each field to do all 9600 features it takes a good 15 to 20 minutes. Is there something I am not doing right? Are you accessing the File Geodatabase over a network?  If so, can you copy the File Geodatabase to your local disk and see if performance is the same? ... View more

Hi Chris, What type of geodatabase are you using (i.e. ArcSDE for Oracle, File Geodatabase)? What version of ArcGIS are you running? ... View more

Hi Mody, You can download PythonWin from the following link: http://sourceforge.net/projects/pywin32/files/pywin32/Build%20217/ For ArcGIS 10.1, click on 'pywin32-217.win32-py2.7.exe' to begin the download. ... View more

Hi Dale, Your code appears correct.  What version of ArcGIS are you running? Also, try specifying the UNC path rather than the network drive.  Ex: addLayer = arcpy.mapping.Layer(r"\\<server name>\GIS 249\Wk02_Spatial  Analyst\Thursday\Learn01\VirtualCampus\LearnSA9\MapAlgebra\Piru.gdb\FirePer") ... View more

You could create a script that runs the 'Make Raster Layer' function for each raster.  If you have 'Add results of geoprocessing to the display" checked on within the Geoprocessing options, the raster layers will automatically be added to the current map document. arcpy.MakeRasterLayer_management("C:/DATA/RASTER/DEM/example", "example") arcpy.MakeRasterLayer_management("C:/DATA/RASTER/DEM/example2", "example2") ... View more

In ArcCatalog, go to Customize > ArcCatalog Options > Raster tab > Raster Layer tab.  What is your stretch and resampling set to there? Also, you can speed up the calculation of statistics by specifying a skip factor in the Calculate Statistics tool.  This will give you a generalization of the statistics. ... View more

Hi Greg, Try the following: arcpy.CalculateField_management(dataset, "FROM_X", !Shape!.firstPoint.X,"PYTHON_9.3","") Since you are calculating the value from the geometry, you will need to use the Shape field. Note:  Python is case sensitive. ... View more