calculate stats from points
energy
Global Mapper UserTrusted User
I have too many boreholes(point features) and their attributes like top-base value of borehole, thickness,interbedded value, date,calory value,humidity,ash..... so
How can I calculate total-sum value or average according to the attributes, like total depth of boreholes or average of coal thickness.
I am using 13.2
How can I calculate total-sum value or average according to the attributes, like total depth of boreholes or average of coal thickness.
I am using 13.2
Comments
-
There isn't a way to directly add those up in Global Mapper. You would need to export to a CSV file, then bring that into Excel and do whatever operations you need on the columns of interest.
Thanks,
Mike
Global Mapper Guru
gmsupport@bluemarblegeo.com
http://www.bluemarblegeo.com/ -
is it hard to add in "calc attr" or right click or "search vector data" as basically
-
It wouldn't be particular difficult, particularly in the Search Vector Data dialog, to add some support for calculating and reporting statistics for selected features. Perhaps minimum, maximum, and average values and maybe even most commonly occurring or count of each type.
Thanks,
Mike
Global Mapper Guru
gmsupport@bluemarblegeo.com
http://www.bluemarblegeo.com/ -
That would be great?? , when I click the title of attributes in search vector data dialog ,I can find the max and min values but for avarage, total values(any attributes)...it is more difficult
-
I'll get something adding for simple statistics on individual columns when searching and let you know when it's available.
Thanks,
Mike
Global Mapper Guru
gmsupport@bluemarblegeo.com
http://www.bluemarblegeo.com/ -
I have added a new option so you can right-click on a column value (not the header) in the search vector dialog and have a new option to calculate the STATS of all values for that column in the result set. This should report the min, max, average, and standard deviation of all of the numeric values.
I have placed a new build at http://www.bluemarblegeo.com/downloads/global-mapper/global_mapper14.zip with the latest changes for you to try. Simply download that file and extract the contents into your existing v14.xx installation folder to give it a try. If you are using the 64-bit v14 version there is a new build at http://www.bluemarblegeo.com/downloads/global-mapper/global_mapper14_64bit.zip .
Thanks,
Mike
Global Mapper Guru
gmsupport@bluemarblegeo.com
http://www.bluemarblegeo.com/
Categories
- 12.7K All Categories
- 5.6K Features Discussion
- 342 Downloading Imagery
- 1.3K Elevation Data
- 380 Georeferencing Imagery Discussion
- 628 GM Script Language
- 53 User Scripts
- 113 GPS Features
- 414 Projection Questions
- 819 Raster Data
- 1.3K Vector Data
- 6.6K Support
- 177 Announcement and News
- 908 Bug Report
- 558 SDK
- 1.2K Suggestion Box
- 3.7K Technical Support
- 562 Other Discussion
- 129 GIS Data Sources
- 27 Global Mapper Showcase
- 233 How I use Global Mapper
- 107 Global Mapper Forum Website