Latest Contributions by DarrenWiens2

1.) Copy layer (in table of contents) 2.) Paste layer (in table of contents) 3.) Symbolize copies as needed ... View more

1.) Bring Excel spreadsheet and Zip feature class into ArcMap 2.) Join the spreadsheet to the feature class based on the zip code attribute that should be in both tables ... View more

Aha, I stand corrected - was looking at "measure_offset" in Create Routes, not "offset_field" in Make Route Event Layer. Looks like it should work. ... View more

Add an offset field and calculate it to 12 or -12 (experiment) and make the summary table a new line event table with the offset field option set. The lines will follow the road between the two point measures with a 12 ft offset. This will offset the line forward or back 12 feet along the road, not left or right, correct? I believe the OP wants a sidewalk line, at least that's what I was picturing. ... View more

The way to do this automatically in ArcGIS is to use Network Analyst (see the first example). The manual option is to trace the existing street centreline. Offsetting the line is a separate question, but I believe you should be able to do it by doing a Copy Parallel on the desired centreline. ... View more

You may want to consider that story maps and their data must be public*, which means you should probably steer away from industry data and associated privacy issues. *from what I can tell - I could be wrong. ... View more

There are literally hundreds of ideas on the story maps website. ... View more

you should probably convert the coordinates to decimal degrees first In fact, you must convert to decimal degrees (or another number-only format) first. The dropdown lists only populate for numeric fields. When you bring Excel spreasheets into ArcMap, it assumes the datatype for each field. Since your lat/longs are in D/M/S it sees non-numeric characters, so it must be text. As a side note, you must remove special characters and spaces from spreadsheet column names before importing into ArcMap. ... View more

Similarly, you can get XMin, Ymax, etc. from the Describe Dataset Extent object: import arcpy # Create a Describe object from the shapefile # desc = arcpy.Describe("C:/data/centerlines.shp") # Print dataset properties # print "Dataset Type: " + desc.datasetType extent = desc.Extent print "Extent:" print "  %s: %f, %s: %f, %s: %f, %s: %f" % ("XMin", extent.XMax, "XMax", extent.XMax,                                             "YMin", extent.YMin, "YMax", extent.YMax) print "MExtent: " + desc.MExtent print "ZExtent: " + desc.ZExtent SR = desc.spatialReference print SR.name ... View more

You can add ET GeoWizards tools to your model by adding the toolbox to ArcMap, found in: C:\Program Files (x86)\ET SpatialTechniques\ET GeoWizards 10.2 for ArcGIS 10.1 (OR WHEREVER YOUR ET_GW RESIDES) ...add dragging the tool into your model. edit: I have the full version of ET GeoWizards, so no guarantees that this works in the free version. ... View more

In PythonWin, the line numbers are always "on", but the margins annoyingly default to push them off-screen. Bring them back by: View->Options->Editor Tab->Line Numbers (Margins Widths) = 10. ... View more

You can control Excel from Python using win32com.client. import win32com.client xlApp = win32com.client.Dispatch("Excel.Application") #Open Excel xlWb = xlApp.Workbooks.Open(PATH_TO_WORKBOOK) #Open a workbook - change the path xlApp.ActiveWorkbook.SaveAs(PATH_TO_NEW_CSV_FILE, FileFormat=24) #Save to csv - FileFormat=24 means .csv xlApp.ActiveWorkbook.Close(SaveChanges=0) #Close Workbook xlApp.Quit() #Close Excel ... View more