Latest Contributions by CCWeedcontrol

Here is one I have used but the layer has to be in the same folder.   project = arcpy.mp.ArcGISProject('CURRENT') layer1 = project.listMaps()[0] lyr = layer1.listLayers('HOMES')[0] arcpy.env.workspace = os.path.dirname(project.filePath) wp = os.path.dirname(project.filePath) #lyr1 = project.listLayers("SUBJECT_PROPERTY")[0] try: cp = lyr.connectionProperties cp['connection_info']['database'] = wp cp['dataset'] = 'HOMES2.shp' lyr.updateConnectionProperties(lyr.connectionProperties, cp) except: pass   ... View more

Wow that is pretty involved unfortunately I am not an supper advanced python scripture but I do appreciate the the code. I was thinking more along creating points for each polygon and then doing a spatial join back to the polygons and using  the x,y spatial location to order/sort them to a specific order then how using a field calculator counter to update the attributes. I have been able to create points for each polygon and spatially joining them back to the polygons but lack creating the complexity of the field calculator. ... View more

Thank you for the reply and suggestion but i am not sure how to incorporate your suggestion. ... View more

I was able to achieve creating the blocks with the following below but would be nice if could have populate the attributes based on a formula and this is beyond me. I attached the sections in case anyone wants to help out.   import arcpy, os arcpy.env.overwriteOutput = True def CreateFishnetsForFeats(shp, out, cell_x=0, cell_y=0, n_rows=0, n_cols=0): # Create file gdb to store data gdb = str(arcpy.CreateFileGDB_management(out, 'Fishnets.gdb').getOutput(0)) # spatial reference arcpy.env.outputCoordinateSystem = arcpy.Describe(shp).spatialReference # Loop thru rows of input polygons with arcpy.da.SearchCursor(shp, ['SHAPE@', 'OID@']) as rows: for row in rows: ext = row[0].extent st = '%f %f' %(ext.XMin, ext.YMin) ort = '%f %f' %(ext.XMin, ext.YMax) # Create fishnet outFn = os.path.join(gdb, 'fish_{0}'.format(row[1])) arcpy.CreateFishnet_management(outFn, st, ort, cell_x,cell_y, n_rows, n_cols, labels='NO_LABELS',template = ext, geometry_type='POLYGON') # set workspace to new gdb arcpy.env.workspace = gdb fishnets = arcpy.ListFeatureClasses() targ = fishnets[0] for i, fish in enumerate(fishnets): # Add field for original polygon ID fid = fish.split('_')[1] arcpy.AddField_management(fish, 'POLY_ID', 'LONG') with arcpy.da.UpdateCursor(fish, ['POLY_ID']) as rows: for row in rows: row[0] = fid rows.updateRow(row) # append fishnets into one feature class if i > 0: arcpy.Append_management([fish], targ, 'NO_TEST') arcpy.Delete_management(fish) print (*'Appended: {0}'.format(fish)) print ('Done') return if __name__ == '__main__': polys = r'C:\Temp\SectionGrid\SectionsCopy.shp' loc = r'C:\TEMP' CreateFishnetsForFeats(polys, loc, 0, 0, 9, 9) ... View more

Surely I am not the only one that has need to do this and I was hopping there would be something automated since what you describe would be time consuming but I appreciate the suggestion. ... View more

I have been messing the fishnet tool for a while and can't produce what i need. I am thinking that some how each section length & high has to be calculated then divided evenly by 9 times? ... View more

This would be used as an addressing grid. The blue lines would be a whole section. Range - address range, increase from right to left and south to north. I guess I just need each sections to be broken into just 9 sections not 100. The increase from right to left is just a 1000 of possible addresses. Hopefully that helps. ... View more

Not sure why I didn't think of that big give away "field is not nullable." ... View more

I get "There was a failure during processing". Error 999999 & the field is not nullable. Some rows do have zero if both fields. ... View more

Ya I could have done it that way but I want to know who to do it through field calculator. ... View more

The first time I was using 2.y python, which worked yesterday but today nothing happens when I run the script, no error no output .xlsx.and I didn't change anything, I am lost on this one. So i decided to try it on 3.6 so in 3.6 I have to add from importlib import reload  and comment out sys.setdefaultencoding('Cp1252') but in doing so I get the same error, on line 17 'utf8' codec can't decode byte 0xc3 in position 0: invalid continuation byte. Thoughts? mport pyodbc import pandas as pd import os from importlib import reload reload(sys) #sys.setdefaultencoding('Cp1252') cnxn = pyodbc.connect("Driver={SQL Server};" "Server=***;" "Database=***;" "uid=***;pwd=***") cursor = cnxn.cursor() script = """ SELECT * FROM ***.*** """ df = pd.read_sql(script, cnxn) writer = pd.ExcelWriter(r'C:\Temp\export.xlsx') df.to_excel(writer, sheet_name ='Sheet1', encoding='utf-8') writer.save()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more