topic Re: 'extract multi values to points' or 'sample' not work if the raster is in a geodatabase? in Data Management Questions

'extract multi values to points' or 'sample' not work if the raster is in a geodatabase?

GoldenJiang — Wed, 28 Sep 2016 02:01:31 GMT

I used 'extract multi values to points' or 'sample' to extract values from several rasters but I kept getting error 999999.

They work fine if I save the rasters under a folder rather than geodatabase.

'Extract values to points' can work even the raster is in geodatabase.

Just to confirm is that a tool bug or something?

Re: 'extract multi values to points' or 'sample' not work if the raster is in a geodatabase?

XanderBakker — Wed, 28 Sep 2016 02:25:42 GMT

I have used the Extract Multi Values to Points tool many times using rasters stored in a File Geodatabase without any problems. Are you sure the coordinate systems of the points and raster are the same? What version of ArcGIS are you using?

Re: 'extract multi values to points' or 'sample' not work if the raster is in a geodatabase?

GoldenJiang — Wed, 28 Sep 2016 02:32:51 GMT

Yes, I checked the coordinate system and they were the same. I use ArcGIS 10.4.

Re: 'extract multi values to points' or 'sample' not work if the raster is in a geodatabase?

XanderBakker — Wed, 28 Sep 2016 02:34:10 GMT

Is it possible to share some of your data to see what is happening?

Re: 'extract multi values to points' or 'sample' not work if the raster is in a geodatabase?

GoldenJiang — Wed, 28 Sep 2016 02:51:29 GMT

I uploaded one data file in Dropbox - ExtractValuesProblem This problem happens to every dataset of mine.

Re: 'extract multi values to points' or 'sample' not work if the raster is in a geodatabase?

XanderBakker — Wed, 28 Sep 2016 11:55:42 GMT

You are missing some files. There is no .shx file for the shapefile. If these are the only files you have, then this would be the reason for the processes to fail. If you have additional files you can zip them and simply attach them to this thread. To do this simply use the advanced editor, see link upper right corner when you are replying:

This will reveal the "Attach" link in the lower left corner:

It would also be better to include a raster as example, since if I have to generate them myself, they will be different from the ones you are using and I will likely not be able to reproduce the problem.

Re: 'extract multi values to points' or 'sample' not work if the raster is in a geodatabase?

GoldenJiang — Wed, 28 Sep 2016 21:45:10 GMT

Thanks, see if you can open them this time. Please let me know what you need further.

Re: 'extract multi values to points' or 'sample' not work if the raster is in a geodatabase?

XanderBakker — Wed, 28 Sep 2016 22:57:22 GMT

I can confirm that the reason for this problem is the fact that the point featureclass "fnet_label" does not have any coordinate system defined. Please always try to have the same projection for the data that will be used in a spatial analysis to avoid problems.

You should use the Define Projection tool to set the correct projection:

After that you can use the Extract Values or Extract Multi Values tools to extract the values from the raster:

... and it will run without problems:

And where the points are located on a pixel value that value will be extracted:

Re: 'extract multi values to points' or 'sample' not work if the raster is in a geodatabase?

GoldenJiang — Wed, 28 Sep 2016 23:03:57 GMT

Thanks, since the fishnet label are generated on a projected layer, I thought it must be projected as the same projection too.

Re: 'extract multi values to points' or 'sample' not work if the raster is in a geodatabase?

GoldenJiang — Wed, 05 Oct 2016 01:11:29 GMT

Sorry I am not sure if this is the correct answer. I do it again today but it turns out the same issue.

'fnet_label' has the same coordinate system as my raster. Here are screen shots:

Extract values to points works fine though ... ...

Re: 'extract multi values to points' or 'sample' not work if the raster is in a geodatabase?

DanPatterson_Retired — Wed, 05 Oct 2016 02:34:50 GMT

Cant help but notice you used the Define Projection tool... Defining it doesn't make it so, if it is in a different coordinate system to begin with. You only use Define Projection, when a file has no coordinate system or it is missing or you need to fix it. If it has a coordinate system, but it is not the one your want, then you use the project tool.

Thinks can go badly if this is done incorrectly.... for example

/blogs/dan_patterson/2016/09/07/define-projection-vs-project-a-visual-guide

Re: 'extract multi values to points' or 'sample' not work if the raster is in a geodatabase?

GoldenJiang — Wed, 05 Oct 2016 02:49:08 GMT

What confuses me is that the points and the raster are in the same coordinate system 'NZGD2000'. But 'extract multi values' tool runs ok when the raster is in a folder.

Re: 'extract multi values to points' or 'sample' not work if the raster is in a geodatabase?

DanPatterson_Retired — Wed, 05 Oct 2016 02:55:51 GMT

when you say raster... what format? esri grid? tif?. esri grids have naming requirements and limitations that some other formats don't have. As long as you are aware of those, then things are fine. If stuff works in a folder, put it there, you can always copy/export elsewhere once you have what you need. Isn't the important requirement that you get the result? Trying to micromanage all aspects of a gis workflow will drive you crazy. Get the job done, then worry about cleaning house and tidying up.

Re: 'extract multi values to points' or 'sample' not work if the raster is in a geodatabase?

GoldenJiang — Wed, 05 Oct 2016 03:02:51 GMT

I use 'polygon to raster' conversion to convert my files into raster. So it is in GRID.

Re: 'extract multi values to points' or 'sample' not work if the raster is in a geodatabase?

DanPatterson_Retired — Wed, 05 Oct 2016 03:12:15 GMT

that is good... so you have it saved to a folder with no spaces, doesn't begin with a number... the grid name is 8 characters or less, doesn't contain any spaces or begin with a number... good as well. Interesting cell size... 4.8*10-6. Obviously an unprojected raster since if it were in meters, then you have a cell width of about 5 micrometers. So I am guessing that it is about 5*10^-6 degrees. Is that about right? What geographic coordinate system is it defined as? and what are the results of a projection since you indicated that you were using projected data.

Re: 'extract multi values to points' or 'sample' not work if the raster is in a geodatabase?

GoldenJiang — Wed, 05 Oct 2016 21:35:11 GMT

Please find my last edited reply. The previous screen shot was the one that's working.

Re: 'extract multi values to points' or 'sample' not work if the raster is in a geodatabase?

DanPatterson_Retired — Wed, 05 Oct 2016 23:31:39 GMT

the previous screen shot with the cell size of 0.62 decimal degrees, (obviously unprojected data in a geographic coordinate system) seems reasonable and it comes as no surprise that it works. The second screen shot with the cell size of about 5 micrometers .... since it is apparently in a projected coordinate system... is wrong. Yes, glad you can confirm that. So I suspect that the Define Projection was used and the file was not actually physically projected and given the cell size and extent... a geodatabase won't let it in to be with the other files, since it by no means fits within the realm possible acceptable values. This may account for the reason that it can be saved to a folder, but isn't allowed into the geodatabase to reside with the other layers.