I have about 20 raster datasets that I want to use in a regression model. In order to do so I am trying to create a polygon shapefile where the value from each raster dataset is included in its own attribute field. So far I have created a shapefile consisting of a grid of squares that directly overlays my raster datasets (the cells in both line up correctly). I have also created a point shapefile for each raster dataset (using extract values to points), with the ID for each point corresponding to the correct cell in the grid shapefile. The issue I am having is that, although the shapefiles have different names, the attribute field I need is called "RASTERVALU" in all of them.
I'm really not sure how to get the values from the point shapefiles into the grid shapefile. I have tried the following:
Spatial Join. Took approximately 5 hours to process one shapefile (I have 20 to do) and the new field heading was still called RASTERVALU, meaning I wouldn't be able to distinguish between the different rasters in the attribute table. I tried changing the Alias in properties, but again this didn't save when I restarted ArcMap.
Join. The second RASTERVALU field added to the original shapefile's attribute table, but this disappeared when I re-started ArcMap (i.e. it didn't seem to save what I'd done).
Merge. I tried merging my point shapefiles to create one point shapefile with all attributes (as an attempt to get slightly further down the line!). The new shapefile only had one column called RASTERVALU - I was expecting 20.
I've also looked into changing the field names for my point shapefiles, but this does not seem to be possible.
I'm working with an Info license on 9.3. Any help would be very gratefully received! Thanks, Kate.
