topic Re: Exporting the cross validation file in ArcGIS GeoStatistical Analyst Questions

Exporting the cross validation file

MusfiraJamil — Sat, 29 Dec 2018 19:43:54 GMT

Hi, Is there a way to export excel file for the cross validation process (indicated below in the image) only. Export option that is available at the bottom exports the interpolated values at the unsampled locations. However, I only need measured and predicted values at the sampled locations in order to calculate coefficient of determination (r2) for the kriged map.

Re: Exporting the cross validation file

SteveLynch — Mon, 31 Dec 2018 12:55:09 GMT

The "Export Result Table" button creates a feature class of the cross validation results at the sampled locations.

You can also use the CrossValidation geoprocessing tool to creates results at sampled and unsampled locations.

Also see more details here.

-Steve

Re: Exporting the cross validation file

MusfiraJamil — Tue, 01 Jan 2019 07:25:41 GMT

Hi Steve,

Thanks for the reply. I am interested to export the table indicated in the image above. However, "Export result table" option available at the bottom of the crossvalidation window in geostatistical wizard creates result table for sampled and unsampled locations. However, I only need results for sampled points.

Any help in this regard would be appreciated.

Thanks,

Re: Exporting the cross validation file

SteveLynch — Tue, 01 Jan 2019 21:21:08 GMT

Musfira

I'm confused.

The values in the Wizard are the sampled points.

-Steve

Re: Exporting the cross validation file

MusfiraJamil — Wed, 02 Jan 2019 04:07:01 GMT

We have sampled 82 datapoints. However, "export result table" option generates file for 30,000 interpolated values. I only need predicted and measured values for the sampled dataset to calculate R2. How do I get that file?

Re: Exporting the cross validation file

SteveLynch — Wed, 02 Jan 2019 13:25:36 GMT

You are doing cokriging.

- how many datasets?

- how many features in each dataset?

- format of the datasets, eg., shapefile, fgdb, raster, ...?

- what version of ArcGIS are you using?

-Steve

Re: Exporting the cross validation file

EricKrause — Wed, 02 Jan 2019 15:51:32 GMT

Hi Musfira,

The number of points that come out of the Export Result button should be equal to the number of rows in the cross validation table in the Geostatistical Wizard. I don't know any reason they would be different. I can also see in your table that all Source ID values are -1, which is also strange.

As Steve asked, what format are the points that you used in the wizard? Shapefile, file geodatabase, something else?

Regardless, you should try clicking Finish then OK in the wizard to create a geostatistical layer in your map. Then use the Cross Validation geoprocessing tool with the layer. The optional feature class output from the tool produces the same feature class as the Export button in the Wizard. Using the geoprocessing tool instead of the Export button may give what you are expecting.

Re: Exporting the cross validation file

MusfiraJamil — Fri, 04 Jan 2019 20:06:19 GMT

Hi Steve,

I am cokriging soil fertility as a function of different terrain covariates, and I have two datasets (soil fertility profile, and terrain covariates). Soil fertility profile has 6 fertility parameter, while LIDAR data has 5 terrain covariates. I have condensed both datasets into a single csv file, and I am using ArcGIS 10.5.1

Re: Exporting the cross validation file

SteveLynch — Fri, 04 Jan 2019 20:10:57 GMT

Musfira

So how many rows are there in each .csv file and/or dataset (i.e. soil fertility profile, and terrain covariates)?

Please also include a screenshot of the "Method Report", i.e. the last dialog that appears before the Wizard closes.

-Steve

Re: Exporting the cross validation file

MusfiraJamil — Fri, 04 Jan 2019 20:16:41 GMT

82 datapoints in soil fertilty profile, and 230,234 datapoints in terrain covariate dataset.

Re: Exporting the cross validation file

SteveLynch — Fri, 04 Jan 2019 21:00:30 GMT

Please also include a screenshot of the "Method Report", i.e. the last dialog that appears before the Wizard closes, viz.,

Re: Exporting the cross validation file

MusfiraJamil — Fri, 04 Jan 2019 21:40:24 GMT

Attached is the screenshot of dataset from my 2nd site. It's the same as my 1st site, with exception of 56 sampled data points instead of 82. Number of terrain covariates is around 156000. However, I just notice that the number of records for both datasets is showing up as 56. So, maybe combining the two datasets is causing the issue.

Re: Exporting the cross validation file

MusfiraJamil — Fri, 04 Jan 2019 21:48:27 GMT

Hi Eric,

Thanks for the reply. That is exactly my understanding that the number of records in the exported excel file should be equal to the number of records in the cross validation file. However, it's not the case. Maybe combining both datasets into single csv file is causing the issue.

I think, I will input the two datasets as two csv files, instead of one. It might solve the exporting issue, as well as the source ID one.