arcpy.da.SearchCursor spatialReference

Question

I am trying to get XY coordinate ouput in decimal degrees (NAD_1983_StatePlane_California_VI_FIPS_0406_Feet) but I get the following (6307536.064266056, 1984263.0718122125). From the following script section pertaining to spatial reference search cursor,does anything appear to be the reason why I get my current results ? import csv,os,arcpy os.chdir(r'S:\abc) #Set path location of Excel (CSV) file (r'S:\GIS\Projects\abc) #Set Excel variables ofile = open('Coordinates.csv','w') writer = csv.writer(ofile) fc = "ESC_MS4structures selection" desc = arcpy.Describe(fc) field = ["FACILITYID","SHAPE@XY"] sr=desc.spatialReference cursor = arcpy.da.SearchCursor(fc,field,None,sr) for row in cursor: print (u'{0}, {1}'.format(row[0], row[1])) writer.writerows(cursor) #Close Excel (CSV) file ofile.close() os.startfile (r'S:\abc\Coordinates.csv')‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

DevinUnderwood2 · Answer

I was able to write to excel. I just created a variable from the results and passed it to the writer, it gets too confusing on modifying syntax to accommodate the writer. with arcpy.da.SearchCursor(fc,['SHAPE@','FACILITYID'],spatial_reference=sr) as cursor: for row in cursor: wgs = '4326' # Coordinate System WGS 1984 WKID is '4326' toolresults = row[1], ('{0}, {1}'.format(row[0].projectAs(wgs).centroid.Y, row[0].projectAs(wgs).centroid.X,row)) writer.writerow (toolresults)‍‍‍‍‍

DevinUnderwood2 · Answer

Perfect for print out. Almost there, now just write to csv file FACILITYID 423 -117.079916464, 33.108904151 #Set Excel variables headers = "FaciliyID","X","Y" ofile = open('Coordinates.csv','w') writer = csv.writer(ofile) writer.writerow(["FACLITYID", "X", "Y"]) fc = "ESC_MS4structures selection" ##field = ["FACILITYID"] with arcpy.da.SearchCursor(fc,['SHAPE@','FACILITYID'],spatial_reference=sr) as cursor: for row in cursor: wgs = '4326' print "FACILITYID", row[1], ('{0}, {1}'.format(row[0].projectAs(wgs).centroid.X, row[0].projectAs(wgs).centroid.Y,row)) writer.writerow row([1],('{0}, {1}'.format(row[0].projectAs(wgs).centroid.X, row[0].projectAs(wgs).centroid.Y,row))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

DarrenWiens2 · Answer

The second parameter in the SearchCursor can either be a single field or a list of fields. In your case, you're calling the individual rows 'row', so row[0] is the first field, row[1] is the second field, and so on. with arcpy.da.SearchCursor(fc,['SHAPE@','FACILITYID'],spatial_reference=sr) as cursor: ^ row[0] would hold the shape, row[1] holds facility ID.