Latest Contributions by NeilAyres

Very good question, and no obvious answers. I will look forward to some more enlightened answers than mine. ... View more

A bit of advice, use it, don't use it. Get your data sorted first before performing analysis. What do you mean by "unprojected shapefile". Get it into a proper PCS first. Get your excel into a proper table (fgdb, pgdb etc) format first. This will confirm that header are correct and that variables are not a different type than you expect. Then perform your analysis. ... View more

Maybe I am misunderstanding the problem here. But if you want to add a couple of columns containing XY's for a different coord sys than the data itself just add the columns (double of course), change the coordinate system of the data frame to your desired output. Then right click on the column, pick the XY value, and choose "use cords sys of the data frame". Easy. ... View more

As I said before use the env.workspace to go inside your db. Then use arcpy.ListFeatureClasses() to see a list of the features available. This will give you the correct spelling of the feature you are trying to update including all the extra bits that are part of a sde feature (database name etc) Then you know what fc should be called. Once that be is established, try reading it first. ... View more

If you already have spatial data (shapefile) why don't you just import it into your db. Or use the copy features tool. If you want to use scripting to create and write geometries check out: CreateFeatureClasses : http://resources.arcgis.com/en/help/main/10.2/index.html#//00170000002p000000 da Cursors : http://resources.arcgis.com/en/help/main/10.2/index.html#//002z0000001q000000 Writing geometries : http://resources.arcgis.com/en/help/main/10.2/index.html#//002z0000001v000000 etc etc. ... View more

That is a fantastic resource. Thank you Simon. Been using the epsg dataset for years. But this is a very nice addition to the toolkit. ... View more

Once you are in and have the correct permissions you can do anything. So be careful! I normally do this in the Python ILDE, try - arcpy.ListTables() or arcpy.ListFeatureClasses() for example. There is plenty of code snippets in the help or on this site to get going with. What are you trying to do? ... View more

They are probably changed, you just don't see it. Open a brand new ArcMap session, add your Adindan based output. Add the original. When the warning comes up about different datums, just click Ok, ie ignore it. You should have 2 sets of points, displaced by approx. 280m. ... View more

if myList contains only 1 object ie len(myList) == 1 then join, split etc indeed any list function will interate through the individual components. So just check first if len(myList) > 1, before using ",".join(myList) ... View more

Set up the connection file using the usual tools in ArcCatalog. Then set a pointer to this in your python script. like : ConnectFile = "Path & name of my connection file.sde" arcpy.env.workspace = ConnectFile Then you are in.... ... View more

Been messing with the xlwt module, writing a data table to excel. During the course of this I discovered the enumerate function. worksheet write needs a column pointer. This seemed to be an easy way to get it. An example : tbl = "Table to export" fldOb = arcpy.ListFields(tbl) FieldNames = [f.name for f in fldOb] # set up excel output outXL = tbl + ".xls" wb = xlwt.Workbook() # add first sheet SheetNum = 1 ws = wb.add_sheet("Data_" + str(SheetNum)) # first row in sheet, header line r = 0 [ws.write(r, c, head) for c, head in list(enumerate(FieldNames))] with arcpy.da.SearchCursor(tbl, FieldNames) as cur:     for row in cur:         # if row limit is reached, increment and insert another sheet         if r > 65534:             SheetNum += 1             ws = wb.add_sheet("Data_" + str(SheetNum))             r = 0             [ws.write(r, c, head) for c, head in list(enumerate(FieldNames))]         r += 1           [ws.write(r, c, val) for c, val in list(enumerate(row))] wb.save(outXL) del wb Can someone format this for me please.... ... View more

Chris, in what way was your attempt to import the data "unsuccessful".... What did you try? What is the structure of the text, csv, tab separated. There is an Excel to Table tool in the Toolbox (Conversion tools / Excel). If the files are not gigantic, then you could use the text importing dialogs in Access and create a feature from that. Create Events will also allow you to point to a text file directly. I think you need to tell us exactly what you have tried so far, and what the data actually looks like if you want someone to help. ... View more

And you could replace that if month == ... With if month in ['11','12','01','02','03'] : ... View more

Quite large point files can be built into tin models deirectly. From there to a raster visualization is easy. If you have very large datasets then terrains might be the answer. http://resources.arcgis.com/en/help/main/10.2/#/What_is_a_terrain_dataset/005v00000002000000/ http://resources.arcgis.com/en/help/main/10.2/#/What_is_a_TIN_surface/006000000001000000/ ... View more