Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About DarrenWiens2
DarrenWiens2
MVP Alum
since
07-04-2014
07-15-2023
3199
Posts created
71
Kudos given
345
Solutions
1920
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(0 Idea Submissions)Latest Contributions by DarrenWiens2
|
POST
|
This is a surprisingly complicated question. The short answer is that ArcGIS can calculate distances in several different ways depending on things like which tool you use and which projection (if any) your dataset(s) are in, and it will calculate the distance how you tell it to do so. As a starting point, here is a blog post comparing geodesic to euclidean distances (both of which can be computed in ArcGIS), but there are many, many resources out there devoted to this topic. Also, see this link, which will you start you on your journey through the help pages: How proximity tools calculate distance—Help | ArcGIS for Desktop
... View more
10-31-2016
03:19 PM
|
0
|
0
|
1004
|
|
POST
|
Have you tried turning the unwanted fields off? Right-click the field name in the attribute table and choose 'Turn Field Off'. More methods for turning fields off here.
... View more
10-31-2016
03:00 PM
|
2
|
1
|
1332
|
|
POST
|
Just to get this discussion started, how is your idea different from what already happens when you click the 'i' tool? It shows the information from the attribute table for that polygon. I don't see how your idea is different from that.
... View more
10-31-2016
02:17 PM
|
2
|
3
|
1332
|
|
POST
|
Can you check that your active annotation target is displayed? Check the active annotation target on the Drawing toolbar -> Drawing menu -> Active Annotation Target. Check the displayed annotation layers on Data Frame properties -> Annotation Groups. You can add annotation to an annotation group that isn't displayed, which will make it disappear after you've added it. edit: I'm not sure why, but even though an undisplayed active annotation target is selected in layout view, the annotation is displayed. Where is layout annotation stored?
... View more
10-31-2016
11:15 AM
|
3
|
1
|
4009
|
|
POST
|
Probably the easiest way to do this is to first select the values that you want to change to 'mf'. The SQL to select these rows would be: field1 = 'multi family' OR field1 = 'multi familty <10' ...or you could use: field1 IN ('multi family','multi family <10') Then, run field calculator to make field2 for those rows equal "mf" - field calculator only operates on selected records if there is a selection. You could also run a custom function in the field calculator that evaluates whether field1 = 'multi family' or 'multi family <10', but it's a little more complicated.
... View more
10-28-2016
01:18 PM
|
0
|
2
|
1926
|
|
POST
|
You can set the type but ArcGIS also checks to make sure it makes sense. For example, you can set a column of numbers in Excel to text and it will import as text, but if you set a column of text to number in Excel, it will import as text into ArcGIS because you can't have non-numerical characters in a numerical field within ArcGIS.
... View more
10-28-2016
11:23 AM
|
1
|
1
|
1280
|
|
POST
|
I think you can condense most of your steps by reading all the intersection points into a dictionary (with key = a combination of the lat/long coordinates, value = intersection name) and using a da.UpdateCursor to read the line geometries' firstPoint and lastPoint to find and populate the line table with values from the dictionary: fc = 'trails' # trail FC
fc_sr = arcpy.Describe(fc).spatialReference # trail FC CRS
pts = 'intersections' # intersection feature class
pt_sr = arcpy.Describe(pts).spatialReference # intersection FC CRS
pt_attribute = 'FID' # the field to transfer
# make dictionary where {int(x)int(y):attribute}
pt_dict = {str(int(row[0].centroid.X))+str(int(row[0].centroid.Y)):row[1] for row in arcpy.da.SearchCursor(pts, ['SHAPE@',pt_attribute], spatial_reference=pt_sr)}
with arcpy.da.UpdateCursor(fc,['SHAPE@','START','END'], spatial_reference=fc_sr) as cursor:
for row in cursor: # loop through trails
fp = row[0].projectAs(pt_sr).firstPoint # get firstPoint in coordinates same as points
lp = row[0].projectAs(pt_sr).lastPoint # get lastPoint in coordinates same as points
row[1] = pt_dict[str(int(fp.X))+str(int(fp.Y))] # find matching intersection to firstPoint and return value
row[2] = pt_dict[str(int(lp.X))+str(int(lp.Y))] # find matching intersection to lastPoint and return value
cursor.updateRow(row) # update values edit: the above works nicely with projected coordinates because, depending on your data, you're not likely to have multiple points in the same 1m x 1m (or 1' x 1') square. You are much more likely to have multiple points in the same 1 degree x 1 degree square, so for lat/long, you would have to either project, or do some work to multiply the coordinates by some factor (e.g. 1 million) to make unique coordinate keys.
... View more
10-28-2016
11:21 AM
|
3
|
1
|
4426
|
|
POST
|
Look into "pipeline alignment sheets". There are lots of examples out there, and lots of third party tools that will generate them for you.
... View more
10-28-2016
09:19 AM
|
0
|
0
|
1997
|
|
POST
|
Here's how you can flip lines with basic license: >>> fc = 'lines'
... with arcpy.da.UpdateCursor(fc,'SHAPE@') as cursor:
... for row in cursor:
... new_part_arr = arcpy.Array()
... for part in row[0]:
... new_pnt_arr = arcpy.Array()
... for pnt in part:
... new_pnt_arr.insert(0,pnt)
... new_part_arr.insert(0,new_pnt_arr)
... row[0] = arcpy.Polyline(new_part_arr)
... cursor.updateRow(row)
... View more
10-27-2016
04:48 PM
|
2
|
0
|
6060
|
|
POST
|
I don't quite get what you're trying to do. Can you give a simple example showing exactly what you want the result to be? I think what you're trying to do is: 1.) Select the rows where field1 = 'multi-family' AND multifamily < 10: Selecting records in a table by attributes—Help | ArcGIS for Desktop 2.) Calculate "MF" into field2: Fundamentals of field calculations—Help | ArcGIS for Desktop
... View more
10-27-2016
01:58 PM
|
0
|
5
|
1926
|
|
POST
|
"540+00" is interpreted by ArcGIS as a string no matter what you tell Excel the format is, because it contains a non-numerical character. ArcGIS will interpret "54000" as a number, so you can either change it in Excel or import it as a string into ArcGIS and change it as Dan suggests.
... View more
10-27-2016
12:59 PM
|
1
|
0
|
4631
|
|
POST
|
Just curious, if you sort the date field in the attribute table, does it sort how you would expect, or like Oct. 2, Nov. 2., Oct. 3, Nov. 3, etc.?
... View more
10-26-2016
11:10 AM
|
0
|
2
|
1821
|
|
POST
|
Hmmm... shapefiles definitely don't support the time component of date/time, but I would have guessed that it could parse out the date component. Either try exporting the CSV point data as a GDB feature class (which do support date/time) or parse out the date in Excel and try again, exporting to shapefile. edit: on second read, does the date/time not show in CSV file when you bring it into ArcMap?
... View more
10-26-2016
11:04 AM
|
0
|
0
|
3290
|
|
POST
|
The field names must be good for all columns, not just the misbehaving one. In any case, see here for more: Formatting a table in Microsoft Excel for use in ArcGIS—Help | ArcGIS for Desktop
... View more
10-26-2016
10:34 AM
|
1
|
0
|
3290
|
|
POST
|
Lots of potential problems, but most common is spaces or other special characters in field names. Remove them in Excel and try again.
... View more
10-26-2016
10:23 AM
|
0
|
0
|
3290
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 08-30-2013 02:22 PM | |
| 1 | 04-12-2011 11:19 AM | |
| 1 | 09-17-2021 09:43 AM | |
| 1 | 04-04-2012 12:05 PM | |
| 2 | 07-16-2020 11:31 AM |
Activity Feed
- Got a Kudo for Re: How to intersect two rasters. 02-20-2025 12:31 PM
- Got a Kudo for Re: How to intersect two rasters. 02-20-2025 11:47 AM
- Got a Kudo for Re: Len Query in File Geodatabase. 11-01-2024 04:36 PM
- Got a Kudo for Re: Is it possible to set address locator properties via arcpy?. 10-23-2024 09:36 AM
- Got a Kudo for Re: Convert .tif to .jpeg. 09-18-2024 04:40 PM
- Got a Kudo for Re: Calculate Field - VB - Conditional If,elseif statement... not working?!. 07-22-2024 02:11 PM
- Got a Kudo for Re: Newly split polygons not labeling. 04-05-2024 10:28 AM
- Got a Kudo for Re: Select/Delete Polygons that are surrounded by other Polygons. 11-02-2023 04:01 PM
- Got a Kudo for Re: How do I creating a basemap using my own *.PNG or *.TIFF files?. 10-25-2023 11:31 AM
- Got a Kudo for Re: Layer to KML - why some polygons not showing up in Google Earth?. 09-24-2023 10:23 PM
- Got a Kudo for Re: Splitting seperate but merged polygons. 09-07-2023 05:08 PM
- Got a Kudo for Re: How to label mixed cases when the data originally in all caps?. 06-26-2023 04:50 AM
- Got a Kudo for Re: Splitting seperate but merged polygons. 06-14-2023 10:16 AM
- Got a Kudo for Re: Concatenating Strings with Field Calculator and Python - dealing with NULLS. 05-01-2023 09:15 AM
- Got a Kudo for Re: Make Extent Indicator Larger. 03-18-2023 01:07 PM
- Got a Kudo for Re: In ArcMap data view, the textbox disappears after hitting the <ENTER> key.. 01-17-2023 09:08 AM
- Got a Kudo for Re: Make rasters have the same number of columns and rows. 01-15-2023 08:38 AM
- Got a Kudo for Re: cursor error. 01-02-2023 07:56 AM
- Got a Kudo for Re: Move point locations. 11-30-2022 09:43 AM
- Got a Kudo for Re: how do I change date format in labels. 10-26-2022 11:27 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
07-15-2023
12:11 AM
|