Latest Contributions by TravMoore

‎11-27-2012

Hi Caleb/Bill, I believe that you may be correct about the nulls representing mostly oceans, or bodies of water. However, I noticed that there aren't a great deal of rows covering the continents (for example, the number of rows covering South America is less than the actual number of points covering that continent). Antarctica, though, has a comparatively large amount of rows. Could there be a reason as to why? Now, if I wanted to select only the Antarctica rows in the resultant table (from the spatial join), for instance, how may I do this to calculate the annual average for Antarctica? As for Bill's suggestion, this had also been stated to me previously, as well. However, I have absolutely no idea where to begin in calculating weighted averages. I took a look at the link that Bill provided, but I quickly became lost, unfortunately. Is there a way to obtain detailed step-by-step in order to compute weighted averages? I am really interested in going through with this! Many thanks, ~Trav.~

‎11-27-2012

Hi Caleb/Srirama, Okay, I've done as was instructed with respect to "Spatial Join" and successfully acquired a new attribute table. I've tried joining the temperature point data (Target Feature) and "country name" or "Continent" (so, two attempts), based on the world map that I have (see attached file above) - however, under "Continent", for example, I noticed that for many rows, they say "<Null>". Some rows actually show the actual continents, but most are nulls. Is there a reason for that? Now, if I want to simply acquire the annual temperature means for, say, Antarctica, how may I do this using the attribute table? I understand that you had mentioned right-clicking on the "Continent" column, for example, and then select "Summarize" in the drop down menu. However, how may I only select the Antarctica rows, and then acquire an average based on those selected rows? Thanks again, and I apologize for the questions! ~Trav.~ Edit: Bill, thank you for your input. Would it be possible to show me a detailed procedure in doing this in ArcGIS? If so, I would greatly appreciate it!

‎11-22-2012

Hi Srirama, Thank you for your assistance on this, and I apologize if I am a little too meticulous! I will duly proceed with your (and Caleb's) instructions. Just to be safe, though, these procedures would apply to the world map that I have shown above (all of the layers that I am using are found in that image at the end of post #6, if it helps), correct? Sorry about the ongoing questions, but I would just like to make sure that I am on the right track. 🙂 Thank you for all of your help and patience. ~Trav.~

‎11-21-2012

Hi Caleb, Okay, that sounds fine, thank you! Just to be safe, though, I have included an image attachment in my previous message showing the map (and superimposed data points) that I am using. Did you happen to see it above? If so, does this map fit your explanation? You can enlarge the image to see the details for the world map and what is included. 🙂 Thanks again, ~Trav.~

‎11-21-2012

Thank you, Caleb and Srirama, for your good help on this! I will attempt what you both had suggested, but I guess that my only question is would the "Spatial Join" function work for the desired regions on a global map layer, or do I need to separately create other layers with the regions of interest? For example, if I were interested in the U.S., could I use the "Spatial Join" function directly for the global/world map layer that I already have, or do I need to create a U.S. layer separately, and then use "Spatial Join"? Also, how may I create separate "polygons" for specific regions? Many thanks, again, ~Trav.~ EDIT: I have attached a map to facilitate my question.[ATTACH=CONFIG]19463[/ATTACH]

‎11-21-2012

Thank you for your response, Dan! With the function that you had specified, "Select Layer by Location", this can be used to calculate statistics for individual regions on a global map layer, correct? Thanks again, ~Trav.~

‎11-20-2012

Hi Caleb, Thank you so much for your good assistance on this! I just wanted to know, however, if there are simple procedures to follow in conducting a spatial join? Thanks again, ~Trav.~

‎11-20-2012

Hi, I currently have a global map shapefile, superimposed by 8192 data points that show temperature changes (per degree Celsius of global warming) and degrees of latitude/longitude at those locations on the globe. So, for instance, an individual data point would say (when using the "Identify" function) at 180 West, 45 degrees North, the temperature change per degree Celsius global warming is 0.8 Celsius. Each of the 8192 points contain this sort of data. What I am attempting to do is simply calculate various averages for different regions by somehow combining the necessary points over those regions. For example, if I would like to calculate the average temperature change in the United States, how could I do this using the point data that covers the United States? Any assistance would be greatly appreciated! Patiently awaiting your response(s), ~Trav.~

‎11-20-2012

Hi, I currently have a global map shapefile, superimposed by 8192 data points that show temperature changes (per degree Celsius of global warming) and degrees of latitude/longitude at those locations on the globe. So, for instance, an individual data point would say (when using the "Identify" function) at 180 West, 45 degrees North, the temperature change per degree Celsius global warming is 0.8 Celsius. Each of the 8192 points contain this sort of data. What I am attempting to do is simply calculate various averages for different regions by somehow combining the necessary points over those regions. For example, if I would like to calculate the average temperature change in the United States, how could I do this using the point data that covers the United States? Any assistance would be greatly appreciated! Patiently awaiting your response(s), ~Trav.~

‎10-24-2012

Hi Dan Patterson, Wouldn't Arcmap be able to read it as a .csv file type? Or is it best to save it as a text file? Once the file is in ArcMap, what procedures should I follow? (Note that I do not have ArcMap/ArcGIS installed on my pc - I'm not sure if there are any trial versions available, though). Thanks, ~Trav.~ EDIT: The text file should be "tab delimited"?

‎10-24-2012

Hi Dan Patterson, Ok, I did as you instructed. What do you suggest I do with my newly modified Excel file? Thanks, ~Trav.~

‎10-24-2012

Hi SaultDon, Firstly, thank you very much for your response! I appreciate it tremendously! I am not sure if the file is available publicly, but I tried attaching the .csv file here, but it didn't seem to work properly. However, I have copied and pasted the data into a new Excel file (.xlsx format), and it is attached to this message. I hope this will help. 🙂 Also, I looked into this link, but I don't know if it is relevant: http://support.esri.com/en/knowledgebase/techarticles/detail/27589 And, unfortunately, I am not certain as to what the Spatial or 3D Analyst extension is. 😞 Once my replies are posted here, will you (or anyone else) be notified, SaultDon? Again, thank you for the response. ~Trav.~

‎10-23-2012

Hi there, I am a graduate student and am new to ArcGIS, as well as this site. As my research entails climate science, I recently discovered that the software could be a useful means for me to create a map displaying spatial variations in temperature at a global scale. I should note that I do have an Excel file containing the necessary data, and this file is organized into latitude/longitude coordinates. For example, column A displays Longitude (titled "lon"), and column B shows Latitude (titled "lat"). ***Please note that my longitude values range from 0 to 360, and for latitude, values range from -90 to 90. Given the nature of the latitude and longitude values, what projection would be most appropriate? Column C (titled Annual avg.) displays annual temperature changes per degree Celsius of global warming. Columns D and E show simimilar changes in temperatures but are more seasonal (these are not necessary). Please also note that this Excel file is already in .csv format, which, I believe, is a suitable format in ArcGIS. The idea is to create a shapefile in ArcGIS that displays the temperature changes per degree Celsius global warming using the Excel file. Once done, I would simply like to calculate specific regional averages based on these temperature changes. For instance, once the desired (raster) map is created, would it be possible to calculate the average temperature change over North America (or any specific region)? If so, how? I would greatly appreciate it if someone could guide me through the necessary steps involved in such a task/process! Any assistance would surely be valued immensely. Thank you, ~Trav.~

Online Status	Offline
Date Last Visited	‎11-11-2020 02:24 AM

My Ideas

Latest Contributions by TravMoore

Re: Calculating averages using point data: Desperate for assistance!!!!

Re: Calculating averages using point data: Desperate for assistance!!!!

Re: Calculating averages using point data: Desperate for assistance!!!!

Re: Calculating averages using point data: Desperate for assistance!!!!

Re: Calculating averages using point data: Desperate for assistance!!!!

Re: Calculating averages with point data: Deperate for assistance!!!!

Re: Calculating averages using point data: Desperate for assistance!!!!

Calculating averages using point data: Desperate for assistance!!!!

Calculating averages with point data: Deperate for assistance!!!!

Re: Creating a shapefile in ArcGIS

Re: Creating a shapefile in ArcGIS

Re: Creating a shapefile in ArcGIS

Creating a shapefile in ArcGIS