Latest Contributions by JakeSkinner

By default, when replicating tables the 'Check Out' for the table is set to Schema Only rather than 'All Records'.  You will need to go into the advanced options when creating the replica (screen1.png).  Then you can set the 'Check Out' to 'All Records' (screen2.png). ... View more

Hi Billy, You will just need to wrap the field name in quotations within the UpdateCursor function.  Ex: rows = arcpy.UpdateCursor(outshp,"", "", "fname", "") for row in rows:     isyear = 1     row.fname = isyear     rows.updateRow(row) del row del rows Also, you can preserve the indentation of your code by using the code tags (# symbol). ... View more

Hi Ryan, In ArcCatalog right-click on the database > Connection Properties.  Check the 'Service'.  Does it say something similar to: sde:sqlserver:<server> If so, you are using a Direct Connection to the database.  More information, such as when you want to use a direct connection, can be found here.  Direct Connections are usually the preferred connection method. ... View more

Hi Ryan, It doesn't appear that PIL support JPEG2000 as you mentioned.  You'll notice that if you right-click on the .jp2 in ArcCatalog > Properties the Compression type is still JPEG rather than JPG2000.  It appears this module better compresses imagery than ArcGIS, explaining while the new file is smaller in size.  I would keep the extension .jpg (rather than .jp2) and see if you still receive the error. ... View more

Hi Pavel, Are you using ArcGIS 10?  If so, I would recommend using a mosaic dataset rather than a raster catalog.  Mosaic Datasets are much more efficient and provide additional functionality. ... View more

Hi Paul, I believe you will need to make a feature layer before executing the SelectbyLocation function.  Example: arcpy.MakeFeatureLayer_management(addflumlayer, "FLUM") arcpy.MakeFeatureLayer_management(addzcaselayer, "ZoningCases") arcpy.SelectLayerByLocation_management("FLUM","WITHIN_A_DISTANCE","ZoningCases","2000 Feet","NEW_SELECTION") arcpy.MakeFeatureLayer_management("FLUM", "FLUM_New") ... View more

Go to 'C:\Program Files (x86)\ArcGIS\Desktop10.0\Utilities' and double-click the AdvancedArcMapSettings.exe.  Click on the 'Raster' tab and set the 'Maximum number of attribute table entries' to a larger number. ... View more

Hi Bart, The underscores within the projection name is what's causing the problem.  Change: spRef = r"C:\Program Files (x86)\ArcGIS\Desktop10.0\Coordinate Systems\Projected Coordinate Systems\State Plane\NAD 1983 (US Feet)\NAD_1983_StatePlane_California_IV_FIPS_0404_Feet (US Feet).prj" to: spRef = r"C:\Program Files (x86)\ArcGIS\Desktop10.0\Coordinate Systems\Projected Coordinate Systems\State Plane\NAD 1983 (US Feet)\NAD 1983 StatePlane California IV FIPS 0404 (US Feet).prj" and it should work. ... View more

I see that you are querying a Northing and Easting field from the SQL view.  The easiest way would be to create a table, rather than a feature class, and include these field values along with the others.  Then you can create an XY Event layer using these two fields.  Once this is created, you can convert the event layer to a feature class using the Feature Class to Feature Class tool. ... View more

Hi Bart, Looking at your code it doesn't appear that you insert geometry any where, only attribute information.  This would explain why you can see the attribute information, but no spatial data. ... View more

Yes, that is correct. ... View more

Hi Robert, Thanks for the response.  I tried that, and I also tried: date '2011-12-14 00:00:00' Both return 'Unable to return query operation'. ... View more

It appears there may be something wrong with your geodatabase.  Was the geodatabase created with ArcGIS, or Microsoft Access?  Do you need to use an Access database, or would you be able to use a File Geodatabase?  Try creating a File Geodatabase, and copy the data from the Access database to the File Geodatabase using ArcCatalog (right-click > copy, right-click > paste).  Then try executing your code.  Also, if you want to update only the NULL values, you will need to change your code slightly: import arcpy from arcpy import env env.workspace = "d:/Ideprojects/Defworkspace/DefGDB.mdb" cur = arcpy.UpdateCursor("fdmag") fields = arcpy.ListFields("fdmag") for row in cur:     for field in fields:         if field.name == "REPORT_DATE":             # Save the current report date             svrpt = row.getValue(field.name)         if field.name == "INCIDENT_DT":             if row.getValue(field.name) != None:                 print "value stays"             else:                 row.setValue(field.name,svrpt)                 cur.updateRow(row) del row del cur ... View more

I would recommend doing this through geodatabase replication.  At 10, you have the option to replicate feature classes based on a selection or definition query.  You could replicate features in region X to another geodatabase and delegate read/edit privileges to a specific user for this feature class.  You could then replicate both regions Y and Z to another feature class and delegate the same user just read privileges.  So you would have one feature class of region X that the user can edit, and another feature class of regions Y and Z that the user can only view.  You could also create a spatial view for regions Y and Z instead of using replication.  Spatial views are not editable, but you can grant the user view privileges. ... View more