Unable to perform join raster-table ArcGIS 10.3

[ArchaeoRG]

I am trying to replicate some results from a publication. There, one of the datasets they use is WISE30sec map (available for download here: https://www.isric.org/explore/wise-databases). My problem is that even tough they state the following:

"The zip file includes a raster GIS file (WISE30sec) as well as a range of soil attribute data files (see Appendix 3 of the documentation). Using ArcGIS® or similar, users may join the raster data to the derived soil properties files, as managed the MSAccess® database (WISE30sec.mdb). Linkage is through the map unit code or grid cell identifier (NEWSUID) of the raster set and the NEWSUID of the various soil attribute data files."

I am unable to perform the above-mentioned join as I fail to find the grid cell identifier (NEWSUID) when using the Add Join function. ArcMap only shows the fields "ObjectID", "Value" and "Count" and none of them coincides with values shown at the tables I am trying to access. I have tried to copy raster and build attribute table but it didn't work. Also, when I put it in R, I cannot see these attributes that the raster is supposed to have.

Thank you in advance

[cdma...@gisinecology.com]

HI,

I'm not familiar with these data sets, but there should be two possible
solutions.

The first is to use the 'Extract Raster To Points' tool in ArcGIS (or if
you are using QGIS, the Point Sampling Tool tool). This will allow you
to extract values from a raster data layer to a point or a feature data
layer based on their spatial relationships (meaning that you don't need
for have ay common fields with shared values).

The other option would be to convert your raster data layer into a point
data layer as this will allow you to create an attribute table from it.
This can be done using the Convert Raster To Points tool (in ArcGIS) or
using one of the raster to points tools in QGIS (there are a number of
options for this).

If neither of these optoins work out for you, post back on this thread
and I can see what else I can suggest.

All the best,

Colin

On 2020-02-19 18:50, ArchaeoRG wrote:
> I am trying to replicate some results from a publication. There, one
> of the datasets they use is WISE30sec map (available for download
> here: https://www.isric.org/explore/wise-databases). My problem is
> that even tough they state the following:
>

> _"The zip file includes a raster GIS file (WISE30sec) as well as a

> range of soil attribute data files (see Appendix 3 of the
> documentation). Using ArcGIS® or similar, users may join the raster
> data to the derived soil properties files, as managed the MSAccess®
> database (WISE30sec.mdb). Linkage is through the map unit code or grid
> cell identifier (NEWSUID) of the raster set and the NEWSUID of the

> various soil attribute data files."_

>
> I am unable to perform the above-mentioned join as I fail to find the
> grid cell identifier (NEWSUID) when using the Add Join function.
> ArcMap only shows the fields "ObjectID", "Value" and "Count" and none
> of them coincides with values shown at the tables I am trying to
> access. I have tried to copy raster and build attribute table but it
> didn't work. Also, when I put it in R, I cannot see these attributes
> that the raster is supposed to have.
>
> Thank you in advance
>

> --
> --
> ======================================================================
> You received this message because you are subscribed to the "GIS In
> Ecology Forum" discussion group
> (http://www.gisinecology.com/GIS_in_Ecology_forum.htm).
>
> To control how often you get emails from this group, go to
> http://groups.google.com/group/gis-in-ecology-forum/subscribe (you
> will need to log on to get to this page).
>
> To post to this group, either log onto the group's home page or send
> an email to
> gis-in-eco...@googlegroups.com.
>
> The rules for posting to this group can be found here:
> http://groups.google.com/group/gis-in-ecology-forum/browse_thread/thread/df31a0822742203f#.
>
> To unsubscribe from this group, email:
> gis-in-ecology-f...@googlegroups.com
>
> All information on this forum is provided on an 'as is' basis. GIS In
> Ecology is not responsible for checking the accuracy or suitability of
> any posting or response.
> ======================================================================
> ---
> You received this message because you are subscribed to the Google
> Groups "GIS In Ecology Forum" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to gis-in-ecology-f...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/gis-in-ecology-forum/44aaf78a-e4dc-4bec-b9eb-32e6f18724b9%40googlegroups.com
> [1].
>
>
> Links:
> ------
> [1]
> https://groups.google.com/d/msgid/gis-in-ecology-forum/44aaf78a-e4dc-4bec-b9eb-32e6f18724b9%40googlegroups.com?utm_medium=email&utm_source=footer