Latest Contributions by DanielAmrine

‎04-27-2021

When exporting maps, keep the resolution down and size down. I know if you increase the size and resolution it becomes buggy. It also doesn't matter what kind of hardware you have. #BUG-000138628 Exports of large layouts displaying raster data have unexpected performance delays in processing. They have closed it (unfortunately).

‎07-31-2020

Thank you Joe, I will test this today. I couldn't remember how to make the list.

‎07-31-2020

sorry about that, I guess the best way to describe it is to generate the list of field names and then strip them down to dates only, or at least shorter.

‎07-30-2020

I used pivot table to place dates as individual fields(columns) but pivot table attaches the name of the original field to each new pivoted column. There are hundreds of these columns and i need can't change the name one by one.

‎11-12-2019

Clint, I have one similar to this" https://www.bestbuy.com/site/asus-2-in-1-15-6-4k-ultra-hd-touch-screen-laptop-intel-core-i7-16gb-memory-nvidia-geforce-g… It was $1800 when i bought mine 2 years ago. It works well and runs everything ESRI has to offer, plus sketchup and other memory intensive software. I did have to take it back to best buy because the hard drive failed within the first week of owning it. But having the touchscreen and being able to use it like a tablet is really useful.

‎03-18-2016

Dan Patterson, This is very helpful in knowing there are tools to calculate these! I guess the next step is how do you take the values from a column in the attribute table and write them to the format you have shown [n, n+1, etc...] is this an array? I did find some code that wrote the values of two fields in a dictionary and then you could do a "vlookup" kind of deal (drawing from EXCEL) to insert the value of one field and have it print the value of the "lookup field". This still doesn't solve how to add an numbered "ID" field based on the ascending sort of the values. For example I could use model builder to get the row count of each shape file...and then use that to calculate the Q1, Q2, and Q3...and then with the dictionaries I could use python to use the calculated values to pull the appropriate value from the target field. in a shape file with 380 records the Q2 or P_50 would equal (n+1)*0.5 or 190.5 so I would have to pull the target value at 190 and add it to the target value at 191 and divide by 2. This would give me the median target value. You round down and take the next value when n is even. That's essentially the workflow and I could do it in Excel pretty quickly but I'd have to do it for each individual shape file after exporting each individual table! so it all boils down to having the target value field and then another field with a sequential number field based on the ascending sort. Unfortunately ESRI made everything dependent on the "FID" field so all of their autoInctrements are based on this field regardless of how the table is sorted. Dan Amrine

‎03-18-2016

I hope the answer does not require Geostatistical Analyst! To calculate these statistical values you have to first sort the values by ascending order. Q2 is the mean or the total number of values divided by two and it gives you the position of the value in terms of n. so if you had 100 values then median is the (value at position 50) plus the (value at position 51) divided by 2. If you had 101 values the median would be the value at position 51. I have several hundred shape files with values that I want to apply this calculation to. I would like to use a combination of python and model builder to calculate these, calculate and upper and lower "fence" and then find the values that are above and below these "fences". I had the work flow all worked out! until I tried to create a new sequential number field based on the ascending sort. I found this code: def autoIncrement(start=0,step=1): i=start while 1: yield i i+=step incrementCursor = arcpy.UpdateCursor(table_name) #There is no guarantee of order here incrementer = autoIncrement(10,2) for row in incrementCursor: row.setValue(field, incrementer.next()) #Note use of next method incrementCursor.updateRow(row) I changed table_name to "Name of shape file" with target field I changed field to 'name of the field' in said shape file selected the column in the open attribute table When I pressed enter at the end of (row) it just went down one line..I pressed it again and it went back to >>> none of the rows were updated. I thought the cursor is what you have selected in your map document. so I need to 1. Tell each shape file to sort the target values in ascending order (used sort tool with iterater in model builder) 2. create a script that populates a new field with sequential numbers based on the new sort. Any help on this is much appreciated! Dan

‎03-18-2016

Unfortunately both PA and WV (where I live) are heavily forested so finding actual outcrops requires many hours in the field. I know that Cooper's rock state park in WV has both outcrops and large boulders strung out along the ridges and this makes some great snake habitat. There is a trail to Raven Rock ( an outcrop along the ridge ) and the utility company cut back all the trees along some high voltage lines. The rattle snakes love this part of the trail! Also I would recommend looking for "leaf off" imagery and then starting with that at a similar scale to the attached image. Some state geologists in PA may have personal layers about outcrops...or at least a good personal knowledge of where they are...but in this region of the country I don't think outcrop polygons have been drawn!

‎01-15-2016

Xander, that worked perfectly! All except where the text begins with a number such as: 70 RANCH USX BB 09-99HZ 3D 16N-21HZ the script copied the entire string into the field that used the "1" selection...which makes perfect sense. since it found the first number and printed everything past it. There are only a few records that start with a number so i can fix it easily. The difference between mine and the calc file you sent is you had a single " at the end of the final returns. I had used ' ' I'm assuming there's a way to tell the script to split it at the first second or third number....by adding a [1]...etc... somewhere in line 6? Now it's more of trying to understand how the script actually works.

‎01-15-2016

Xander et al... This is the code i entered into the code block: def SplitAtDigit(a,index): try: found = False for i in range(len(a)): if a.isdigit(): b = [a.strip() for a in [a[:i], a] found = True break if found: return b[index] else: if index ==0: return a else: return ' ' except: return ' ' and then: SplitAtDigit( !field!,0) unfortunately all it does is copy one field into the new field without splitting the original text string. i have compared this with what you posted many times and it took me several tries to get the indentation right. i know from the table you posted it worked for you, so I son't understand why it isn't working for me. All fields i'm using are text fields and i don't see anything else that would keep this from working. the only other problem i can think of is that some of strings in the original text column have multiple spaces before the first number. Let me know if there is anything jumping out at you in this block of code. Dan

‎01-15-2016

I apologize I should of started a new post but i don't think people would have seen or replied to it as quickly if i had done that! Thank you all for the ideas. I realize now i will have to do one field at a time if i use the calculator. Thank you Xander for laying it out like you did....it was very helpful. Dan

‎01-14-2016

Edit (by Xander Bakker): the original question was placed at this thread: Extracting an integer from a string field but I decided to branch it to a new thread. I have a similar situation... For Example: s ="POWERS 1C-23HZ" and some are like s2 = RATTLER4C-34HZ I would like to tell python to find the first number in each field and then split the field at the same location at the first number. so.... Field 1 = RATTLER Field 2 = 4C-34HZ derived from the string above: s2 I would like to use the field calculator to do this. I know you can use this to split on the space: !field! = s.split(' ')[0] I did this in the field calculator expression box and it works but only on the strings with a space where I need to break it. Any help is much appreciated! Dan A. Message was edited by: Xander Bakker. Post branched to new Thread

‎12-10-2015

That's a major issue with Pro. It is dependent on your network connection so in my case our network is very slow sometimes so it may take a while. Also 800 feet is not very far at some scales, you may have to zoom in to see the relief. I would exaggerate it by 100 times so it goes from viewing an 800ft hill to 80,000ft! I also zoomed out really far until I could see the raster. pro is buggy nut worth it so good luck Dan

‎12-10-2015

The trick in "tricking" pro to display something other than elevation as an elevation raster is the use of vertical exaggeration. You can right click on the Layers_3d under contents and set a new ground surface. You can then navigate to the said raster and use this as a "layer" to drape the raster on. The right click on the raster layer itself and then set the elevation to the custom surface you made. then...Bingo! you have a raster set to values of BOE. but remember if you have 1,000,000 BOE it's going to draw a point at 1,000,000 ft or meters depending on your coordinate system. so i would convert it to MM boe or billion depending on the area. This is a map of BOE of the Clinton in Ohio all from public data. The red is <= 151,342 BOE you could also multiply the BOE by a factor like 0.001 to adjust the values but make sure you apply it to both the custom surface and the raster. Hope this helps! Dan

‎05-08-2015

All, I am using Data Driven Pages and it still "wanders" as the data frame rotates from page to page. I have set the anchor point to the center but it still changes position. Dan

Online Status	Offline
Date Last Visited	‎04-26-2021 06:12 PM

My Ideas

Latest Contributions by DanielAmrine

Re: ArcGIS Pro Export Map Issue

Re: I need to iterate through field(column) names in a table and change them.

Re: I need to iterate through field(column) names in a table and change them.

I need to iterate through field(column) names in a table and change them.

Re: ArcGIS Pro for GIS Student

Re: How can you calculate Q1,Q2,Q3, and IQR using ESRI?

How can you calculate Q1,Q2,Q3, and IQR using ESRI?

Re: Rock formations

Re: Split field on first number

Re: Split field on first number

Re: Split field on first number

Split field on first number

Re: Displaying a raster of rate in 3D in ArcGIS PRO

Re: Displaying a raster of rate in 3D in ArcGIS PRO

Re: North arrow won't stay centered when data frame rotation changes

Re: Displaying a raster of rate in 3D in ArcGIS PR...

Re: Displaying a raster of rate in 3D in ArcGIS PR...

Re: Calculating statistical correlation between fe...

this is a code from VBA...since ESRI now abandoned...

Re: Embarrass River Flood Damage