Latest Contributions by DarrenWiens2

Some options within ArcGIS are: - convert your Excel(s) to table(s), then process as usual - work directly with your Excel sheets, using the xlrd library (import xlrd) packaged with ArcGIS - this is how ESRI accesses Excel within geoprocessing tools (look for yourself in: c:\program files (x86)\arcgis\desktop10.2\ArcToolbox\Scripts\ExcelToTable.py) ... View more

You may be interested in Region Group/Set Null/Nibble, as outlined here: Generalizing classified output by removing small isolated regions—ArcGIS Help | ArcGIS for Desktop ... View more

The file loads for me, too (10.2.2). I'm confused by this: "Conversion from CAD to Geodatabase using that tool, and then adding a projection with the "project" tool. " The CAD file comes in an unknown CRS. You do have the option to define a CRS in the CAD to Geodatabase tool, however you don't mention using it. So, the output feature class in the geodatabase should still be unknown. The project tool should (correctly) not allow you to run it, since the CRS in the input feature class is unknown. Did you mean "Define Projection" tool, rather than "Project", or have you defined the CAD CRS at some other point? The take home point: you need to know and define the CRS somewhere along the line. ... View more

Can you open the xls in Excel? Verify the file is not corrupt. ... View more

I'm not a GPX expert, but I'd guess that the <trk> tag indicates track, so a polyline, or maybe polygon, but not waypoint. The tool itself should know what datatype to create. Can't you wait until after the tool has completed to see what it created? ... View more

This might sound silly, but is the shapefile you're editing a point or polygon shapefile? Of course, you can only add points to a point shapefile, and polygons to a polygon shapefile. ... View more

You can do this by setting the label font size to the largest desired size, specifying "Reduce font size", and deselect "Overrun feature". ... View more

Use the Project tool to convert your decimal degree data to a projected coordinate system. It will then have the unit of the coordinate reference system (feet or meters or other, depending on which coordinate reference system you choose). ... View more

At the very basic level, I would really like to see the spatial distribution of the events. I was hoping that I could therefore keep each attribute as a separate layer, and click layers on and off depending on the analysis and question I have to explore data with. Your description makes me wonder if you need to edit the point cloud, at all. Once you create your surface from the point cloud, you would simply overlay your events as feature class (point or polygon). ... View more

Store the growing string in a variable, then write it to the element. Untested: my_string = "" for row in sc:          if elm.name == "Report":              print "Stops "+str(row.Stop_Number)+": "+row.Stop_Status+"\n"              my_string += "Stops "+str(row.Stop_Number)+": "+row.Stop_Status+"\n" elm.text = my_string ... View more

Where exactly is the number in "MOR-Q"? Does this have what you call a number, or is there no number for this one? ... View more

Oh, that's probably a function of integer/integer=integer. If you change one to float it should return a float (float/integer=float and integer/float=float): def my_function(numerator, denominator):        if denominator == 0:          return -99      else:        return float(numerator)/denominator  ... View more

You need to rephrase your question to be as stupid as a computer. You're not looking for "numbers", you're looking for something that meets a set of rules that you've made up. For example, "if the road label contains a hyphen, I only want the characters after the hyphen" >>> string = 'JEF-83N' ... if '-' in string: ...     road_number = string.split('-')[1] ... print road_number ... 83N ...or "if the road label contains a period, I only want the characters before the period" >>> string = '2000.B' ... if '.' in string: ...    road_number = string.split('.')[0] ... print road_number ... 2000 ^ I assume in your example "2000. B  to 200" you meant 2000. ... View more