POST
|
Joshua, Thank you for this great answer, and thank you Ian and Johannes as well. I created this model as a workaround but it is cumbersome and has to be "Reset" each time. I also had to remove the natural neighbor because every time i tried to run the model it said the "Z value" field was missing even though i double checked the input and the field was there populated with the correct values. Not sure why this happened. I copied your code into the Python Window, but when i call function I'm not clear on how to add the table, in field, and outfield. This is the results i'm getting. I understand the concept of the code but I'm missing the correct syntax. >>> normalizeField('MSBNC_PHIN',!VAL!,!NORM!) Parsing error <type 'exceptions.SyntaxError'>: invalid syntax (line 1) >>> normalizeField('MSBNC_PHIN',[!VAL!],[!NORM!]) Parsing error <type 'exceptions.SyntaxError'>: invalid syntax (line 1) >>> normalizeField('MSBNC_PHIN',(!VAL!),(!NORM!)) Parsing error <type 'exceptions.SyntaxError'>: invalid syntax (line 1) >>> normalizeField <function normalizeField at 0x1E98BFB0> >>> normalizeField('MSBNC_PHIN',[!VAL!,!NORM!]) Parsing error <type 'exceptions.SyntaxError'>: invalid syntax (line 1) Thanks Again! Dan
... View more
09-23-2014
12:06 PM
|
0
|
6
|
2775
|
POST
|
GEONET, Essentially i want to normalize the Value field (VAL) in a series of point layers using an expression in python or VBscript. I have spent all morning browsing "The Web" for examples and all i can find are long expressions using the code block and that involves building a list of the values and selecting the highest or lowest. The equation is (x-min(x))/(max(x)-min(x)).... In the python expression I tried FieldB = (!VAL! - min([!VAL!]))/(max([!VAL!])-min([!VAL!])) this returned ERROR 000539: Error Running expression:(38.891808-min([38.891808]))/(max([38.891808]) etc... It's reading the value from the field rather than the actual minimum which is 3.285462 I also tried FieldB = min([!VAL!]) and it returned the values for each record rather than actual minimum value in each record. I would really love to have the ability to run a single expression on each of these layers rather than summarizing each individual table and then plugging the values in by hand. This requires going through each layer individually and this will be extremely time consuming and it seems like there should be a smarter way. Any help on this is much appreciated! Dan
... View more
09-23-2014
07:33 AM
|
0
|
18
|
7579
|
POST
|
All, The following model works fine in ArcMAP 10.0 But when I run it in ArcMAP 10.2.2 I get the following error: ERROR 000601: Cannot delete C:\Users\Monkey\Desktop\GIS_PROJECTS\Balanced\Atacosta_Prod_Scratch.gdb\. May be locked by another application. Failed to execute (Copy Features). I deleted the old database created a new one, I've closed and reopened the map but nothing seems to lift this block! This is really frustrating since there is nothing else accessing the database...at least nothing obvious.
... View more
09-18-2014
08:01 PM
|
0
|
0
|
2732
|
POST
|
David, Where can i find the normalization criteria for Kriging? Is that the histogram and zscores? Thanks, Dan
... View more
09-18-2014
10:13 AM
|
0
|
1
|
821
|
POST
|
Dan and David, I appreciate your answers, I used the dissolve tool on the contours and that solved the labeling problem. As for the grid cells, I think by using "Spline by Barrier" it created those cells along the barrier. It is meant for lines inside the data and not as a "clipping" tool. I think that's the problem. I am going to use natural neighbor and then clip the raster to see if those same zig zags disappear. Both your answers are correct and helped! But i can only mark one as "Correct". I guess my next question is when you have continuous numeric data such as Sub Surface values for a formation in a well...essentially the surface elevation - measured depth, what is the best gridding algorithm to use? I'm tying to contstruct a "Smooth" surface below the surface of the earth. The topo tools don't work since they use the Hydrology tools, or use flow to construct valleys... Thanks!
... View more
09-11-2014
11:02 AM
|
0
|
3
|
821
|
POST
|
Is there a tool that will eliminate these "Artifacts" along the edge of a grid? I used "spline by barrier" to generate the grid then I had to clip the grid to get rid of the "No Data". These cells are left over and when I contour it adds these small clusters which wreaks havoc on my labeling! Is there a better tool for gridding continuous numerical data? Should i decrease my cell size? (current is 200m). Only way i can think of is to select each "Artifact" from the table of the contour layer and delete them. This is extremely time consuming on over 50 grids, so any help would be much appreciated!
... View more
09-09-2014
08:32 AM
|
0
|
6
|
4596
|
DOC
|
Not to Complicated and right to the point. Well done.
... View more
07-28-2014
06:24 AM
|
1
|
0
|
811
|
POST
|
Jeffery, I just downloaded your paper and i'm looking forward to reading it! I've spent the last six years working as a mapping and geoscience technician in the Marcellus field. However my company had to go through some cuts and now i'm working on projects all over the country in terms of exploration. The difficulty comes in correlating the data on a one to one relationship rather than subtracting the means from X and Y, multiplying them together, summing them and then dividing by the product of the X and Y standard deviations. Then dividing the result by the total number of values and subtracting by 1. That is the core of the process I used I just didn't Sum them since there where only 2 values (an X and Y) for each well. For the grids I tried leaving out the sum but obviously it didn't work. My goal is to derive a correlation coefficient for each well in terms of the correlated data sets. My main goal is to see if there are any spatial relationships to the correlation of these different values. Essentially we want to find out what kind of data will determine the success of an oil and gas reservoir by using any means possible! I also tried copying and pasting your code into R and, I'm such a noob, I have no idea on how to fix the code so it will run. I will work on that! Thank you for taking the time to reply!
... View more
07-23-2014
12:44 PM
|
0
|
0
|
1419
|
POST
|
My challenge is correlating magnetic (total magnetic intensity, rated to pole, and several passes),gravity (bouguer anomaly, several passes) and depth to oil and gas production data. I used a "Statistics for Dummy" book to find the correlation equation and then used a combination of excel and arcmap to map and correlate values for 652 wells. The problem i'm having is the correlation coefficient is supposed to fall within -1.0 to 1.0 but each grid ranges from -8.5 to 8.5 or so, i can see the trend but I want it to fit within -1 to 1. i hope that provides some good context! Thanks! Dan
... View more
07-23-2014
11:08 AM
|
0
|
2
|
1419
|
POST
|
I am in a similar situation but I would like to reclassify my raster data into a correlation range of -1 to 1. I know I can classify my original raster and use the re-class tool, but I would prefer to use the raster calculator to do this so I can preserve the "Shape" of my raster. I tried the (x-min(x))/(max(x)-min(x)) and it normalized to 0-1. Thanks for your help! Dan
... View more
07-23-2014
07:50 AM
|
0
|
3
|
1419
|
POST
|
Thomas, Did this code work as you planned it? If so did you incorporate it as a script tool in a model, use field calculator, run it using the "Python" window in ArcMap, or as a standalone python script? I've been trying to learn scripting as well but I am confused on the best place to incorporate it into the working MXD. Thanks!, Dan Amrine
... View more
07-23-2014
07:25 AM
|
0
|
1
|
191
|
POST
|
Daniel, You want your final product to look like the PDF you attached? The post is unclear on what you are aiming for. From you post the quickest approach would be to dived your data into quarters, and then grid each quarter. That would be the initial step. You could also use Classification (under Symbology -> Classified) to customize the classes so they only show specific value ranges. If you wanted to highlight areas with revenue higher than 10,000$/day you would place a class at 10,000 and it would dived the data into areas below 10,000 and areas greater than 10,000. I would also look into the 2 wells that produced 120K/day in 2012, they seem out of place and don't match the wells around them. Check the data behind it and make sure it is valid. In my experience with Oil and Gas and making maps for the Non-GIS users in the company I have learned that simplicity is the best way to help them understand your map. You have to ask if it is worth separating it into quarters when the maps you attached tell a good story.
... View more
07-23-2014
07:08 AM
|
0
|
0
|
249
|
POST
|
All, I have generated several correlation coefficient grids using a combination of Excel and ArcMap. How do I clip all the grids to fit within -1 and 1? I know I can go through grid by grid and either exclude the erroneous values or use classify, but how can i do it on multiple grids at once? There is no obvious way to save the classification and load it in a different grid's symbology. Thanks! Dan
... View more
07-18-2014
10:55 AM
|
0
|
0
|
2200
|
POST
|
This is great i will test it ASAP, Thank you for your response! Dan
... View more
12-04-2013
04:24 AM
|
0
|
0
|
373
|
POST
|
Sorry I am not offering a solution! I am getting the same error trying to clip simple rectanlges with a buffer i generated. it worked just fine yesterday doing the same exact process with just a different Input Feature. I've checked geometry, they are both feature classes from the same database. I'm running ESRi 10.0 Build 4400 service pack 5 ArcInfo License on Windows 7 ESRI please respond!!! Dan Update: I exported all the files from feature classes to shape-files and saved it a folder outside of the databse. This worked just fine. So Corrupted database?
... View more
12-04-2013
04:10 AM
|
0
|
1
|
409
|
Title | Kudos | Posted |
---|---|---|
2 | 12-10-2015 10:24 AM | |
1 | 12-10-2015 01:10 PM | |
2 | 03-16-2015 12:57 PM | |
1 | 06-05-2013 05:18 AM | |
1 | 07-28-2014 06:24 AM |
Online Status |
Offline
|
Date Last Visited |
04-26-2021
06:12 PM
|