Latest Contributions by BobNoyes

Thanks for your response. We have been doing the steps outlined in link. Even though it says nothing needs to be uninstalled the web adapters actually need to be uninstalled and reinstalled which, for some reason, seems to also remove content folders. We just rolled it back and are looking at giving it another shot.  ... View more

Cool mangos! I will check this out, thanks! ... View more

Gold star for you! I was wondering about the file geodatabase vs SDE and was considering trying it with the FGDB. You motivated me. I set up a feature dataset in wgs 84 since I was having errors with the projection portion of the script, even after Dan's reminder to type in a complete path (doh!). Here is what I came up with: #Set variable out_fc = "E:\STAGING\Taxlots_staging.gdb\Staging\Taxlots_TEST_DeleteME" #latLonRef = "E:\Coordinate_System\World\WGS 1984.prj" #set workspace arcpy . env . workspace = r "E:\STAGING\Taxlots_staging.gdb\Staging" #Step 1: populate Latitude field arcpy . AddGeometryAttributes_management ( out_fc , "CENTROID_INSIDE" , "" , "" , "" ) print "Step 1 complete" #Step 2: Rename INSIDE_X to Longitude arcpy . AlterField_management ( out_fc , "INSIDE_X" , "Longitude" , "Longitude" ) print "Step 2 complete" #Step 3: Rename INSIDE_Y to Latitude arcpy . AlterField_management ( out_fc , "INSIDE_Y" , "Latitude" , "Latitude" ) print "Step 3 complete" ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ Thanks for your help!! ... View more

Okay, I am feeling a bit dense here.... It might be obvious that I am not a programmer 🙂 but using the syntax for the Add Geometry Tool I get: import arcpy #Set variable out_fc = "Database Connections/jocoA_Staging.sde/jocoA_Staging.DBO.Assessor/jocoA_Staging.DBO.Taxlots_TEST_DeleteME" latLonRef = "Coordinate Systems\Geographic Coordinate Systems\World\WGS 1984.prj" #set workspace arcpy . env . workspace = "Database Connections/jocoA_Staging.sde/jocoA_Staging.DBO.Assessor/jocoA_Staging.DBO.Taxlots_TEST_DeleteME" #populate Latitude field arcpy . AddGeometryAttributes_management ( "Latitude" , "CENTROID_INSIDE" , "" , "" , latLonRef ) print "Step complete" ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ As you might guess I get an error: Runtime error  Traceback (most recent call last):   File "<string>", line 22, in <module>   File "c:\program files (x86)\arcgis\desktop10.2\arcpy\arcpy\management.py", line 2170, in AddGeometryAttributes     raise e ExecuteError: ERROR 000622: Failed to execute (Add Geometry Attributes). Parameters are not valid. ERROR 000628: Cannot set input into parameter Coordinate_System. Two (perhaps more) things come to mind: 1) env.workspace to a feature class may not be copacetic and 2) I am not calling the latitude field correctly.  The original way I had this coded worked fine when ran separately but in the script with the other components it would get the lock error.  What am I missing? ... View more

Thanks for responding! The code in lines 48-67 was from the old configuration I put together and I am not sure how to rewrite it to just calculate the Latitude and longitude fields. My goal is to do in the script what I would do if I right clicked on that field in the attribute table and ran the calculate geometry tool for the x and y coordinates using the wgs84 coordinate system. Nothing fancy. I think your add geometry attributes suggestion looks like just the thing! I will give it a shot. Bob Noyes GIS Analyst Josephine County 541-474-5244 GIS Webpage<http://www.co.josephine.or.us/SectionIndex.asp?SectionID=129> rnoyes@co.josephine.or.us<mailto:rnoyes@co.josephine.or.us> “A road map always tells you everything, except how to refold it<http://thinkexist.com/quotation/a_road_map_always_tells_you_everything_except_how/156219.html>” unknown ... View more

Your suggestion to create the fields first seem like a good plan so I have done that. However, since the script to calculate the lat and long for the polygon centroids was one I stole I am not quite sure how to revise it to read the created fields. Any ideas? import arcpy import os #Step 1: Copy S:\Common\Assessor\ArcGIS\Taxlots_TEST_DeleteME.shp to Joco A assessor #Set Variables in_data = "S:\Common\Assessor\ArcGIS\Taxlots_TEST_DeleteME.shp" out_database = "Database Connections/jocoA_Staging.sde/jocoA_Staging.DBO.Assessor" # Copy arcpy . FeatureClassToGeodatabase_conversion ( in_data , out_database ) print "Step 1: Copy complete." #Step 2: Add Situs fields #Set variables out_fc = "Database Connections/jocoA_Staging.sde/jocoA_Staging.DBO.Assessor/jocoA_Staging.DBO.Taxlots_TEST_DeleteME" # Step 2a: Create a new field - Situs_City (string, 25) arcpy . AddField_management ( out_fc , "Situs_City" , "TEXT" , "" , "" , "25" , "" , "" , "" ) print "Step 2a: Add Situs_City complete." # Create a new field - Situs_St (string, 2) arcpy . AddField_management ( out_fc , "Situs_St" , "TEXT" , "" , "" , "2" , "" , "" , "" ) print "Step 2b: Add Situs_St complete." # Create a new field - Situs_Zip (string, 10) arcpy . AddField_management ( out_fc , "Situs_Zip" , "TEXT" , "" , "" , "10" , "" , "" , "" ) print "Step 2c: Add Situs_Zip complete." print "Step 2: adding the Situs fields has been successful!" # Step 3a: add Latitude (double, 12, 8) arcpy . AddField_management ( out_fc , "Latitude" , "DOUBLE" , "12" , "8" , "" , "" , "" , "" ) print "Step 3a: Add Latitude is completed." # # Step 3b: add Longitude (double, 12, 8) arcpy . AddField_management ( out_fc , "Longitude" , "DOUBLE" , "12" , "8" , "" , "" , "" , "" ) print "Step 3b: Add Longitude is completed" print "Step 3: adding the Latitude and Longitude fields has been successful!" # # Step 4a: add GIS_Acres (double, 15, 4) arcpy . AddField_management ( out_fc , "GIS_Acres" , "DOUBLE" , "15" , "4" , "" , "" , "" , "" ) print "Step 4: Add GIS_Acres field completed." #Step 5: Calculate GIS_Acres arcpy . CalculateField_management ( out_fc , "GIS_Acres" , '!SHAPE.area@ACRES!' , "PYTHON_9.3" ) print "Step 5 Acres have been calculated." # Step 4: calculate Latitude and Longitude fields. latLonRef = "Coordinate Systems\Geographic Coordinate Systems\World\WGS 1984.prj" featureClassesList = out_fc . split ( ";" ) field_Type = "DOUBLE" field_precision_1 = 12 field_scale_1 = 8 for featureClass in featureClassesList : arcpy . AddMessage ( "Calculating XY coordinates for: " + featureClass ) arcpy . AddField_management ( featureClass , "Latitude" , field_Type , field_precision_1 , field_scale_1 ) arcpy . AddField_management ( featureClass , "Longitude" , field_Type , field_precision_1 , field_scale_1 ) rows = arcpy . da . UpdateCursor ( featureClass , "" , latLonRef ) for row in rows : feat = row . getValue ( "shape" ) cent = feat . centroid                 # To get the polygon area: cent = feat.area row . Latitude = cent . Y row . Longitude = cent . X rows . updateRow ( row )   #arcpy.AddMessage(str(lat) + ", " + str(lon)) print "Step 4: Add Lat and Long complete" print "Congratulations! You have completed adding and calculating the necessary fields to the Taxlots feature class. " ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ... View more

Upon further investigation, i.e., looking at the link you sent, that code if for point and I am trying to get the xy coordinates for polygon centroids. Bob Noyes GIS Analyst Josephine County 541-474-5244 GIS Webpage<http://www.co.josephine.or.us/SectionIndex.asp?SectionID=129> rnoyes@co.josephine.or.us<mailto:rnoyes@co.josephine.or.us> “A road map always tells you everything, except how to refold it<http://thinkexist.com/quotation/a_road_map_always_tells_you_everything_except_how/156219.html>” unknown ... View more