topic From Point to Gird, fishnet does not work in Geoprocessing Questions

From Point to Gird, fishnet does not work

CB — Tue, 30 May 2017 17:36:17 GMT

Dear all,

I am done; I have spent half the day trying to figure out how how to get my point data to grid data. The data I use give information on sedimentary thickness for the entire world. However, the dataset is in point form. To merge it with other data (point data) I want to turn it into a grid.

I tried Fishnet but stating the number of rows and columns does not work, because the cells take such forms that the original points do not lie in the middle any longer. Stating the size of the cells also does not work, because Fishnet wants it in meters, but the original data gives the information in decimal degrees.

I also tried Grid Index Features. That seemed to work nicely, as I can state the size in dec. degrees. However, the original points are now at the corners of the cells and not in the middle where they belong.

I have attached the file with the data.

Please help me with this problem. It can't be that difficult but it is driving me to despair.

Thanks a lot, folks.

Re: From Point to Gird, fishnet does not work

DarrenWiens2 — Tue, 30 May 2017 17:42:55 GMT

Try setting the origin coordinate in Grid Index Features.

Re: From Point to Gird, fishnet does not work

JayantaPoddar — Tue, 30 May 2017 19:11:35 GMT

You could do the following.

1. Add the Point Feature Class (FC) in a blank MXD.

2. Using the Point FC, perform a Point to Raster geoprocessing. Cell_Size=1

3. Perform a Create FishNet using the above Raster as template. See screenshot below for the rest of the parameters.

4. The grids are created as desired.

Re: From Point to Gird, fishnet does not work

CB — Wed, 31 May 2017 10:00:50 GMT

Thanks a lot! Tried with setting the origin coordinate in Grid Index Features, changing them by half a decimal degree and it worked like a charm. The resulting grid does not have the information on sedimentary thickness. This should not be a problem; a simple spatial join should work. But for some reason I cannot join the points to the grid.

I have worked with an older ArcGIS version in the past (three years ago) and it worked well. But somehow I cannot make it work here. This is the error I get:

ERROR 999999: Error executing function.
Invalid SQL syntax[near "IN": syntax error]
Failed to execute (SpatialJoin).

Target is the grid

Join Features the points

I use one to one join, keeping all features, merge rule first, and match option intersect

what I don't know what to do with is everything within Output Fields, Source, and Properties

To be honest, I don't recall joining being that complicated in the old days

Any help would be much appreciated once again!

Btw.: I receive the same error when trying to joing my oil fields (points) to the grid with a one to many join.

Re: From Point to Gird, fishnet does not work

DanPatterson_Retired — Wed, 31 May 2017 10:11:25 GMT

everything is in the same coordinate system I presume? and when you mean older version, what version of arcmap are you using or are you using PRO it isn't obvious since you have posted this in GeoNet help... which is about getting help about geonet and not specific to https://community.esri.com/community/gis/analysis/geoprocessing?sr=search&searchId=5dbfe366-b5d0-4175-a199-2551d6fb5a63&searchIndex=0‌ or https://community.esri.com/community/gis/applications/arcgis-pro?sr=search&searchId=7991aac9-1110-4b3e-83e2-37c7bf09f81d&searchIndex=0‌ or https://community.esri.com/community/gis/managing-data?sr=search&searchId=524ae128-b4c5-4740-9c8a-3853f986484b&searchIndex=0‌ for instance

Re: From Point to Gird, fishnet does not work

CB — Wed, 31 May 2017 10:31:23 GMT

I am sorry, as you know I am a complete novice. Let me clarify:

I am using the trial version of ArcGIS Pro. I should also have access to ArcMap, but right now I am just using Pro. As it is the trial version, this should be the latest avaible.

Three years ago was the last time I used ArcGIS. So a) I forgot most of the few things I knew back then and b) the interface looked quite a bit different.

As I created the grid from the point dataset it pretty much has to be the same coordinate system doesn't it? Can I check this somehow?

However, I just noticed something strange: When I click on a point - sedimentary or oilfield - it does not give me any information on that point. It just gives me the variable names, but no values for the variables. It just repeats the varible name where a value should be. So instead of "sedimentary 1.3" it says "sedimentary sedimentary". But when I open the attribute tables of the layers the info is there..

Edit: apparently ArcMap is NOT included in the trial version

Re: From Point to Gird, fishnet does not work

CB — Wed, 31 May 2017 16:02:17 GMT

Hi, thanks I just tried that too and it works somehow. I get a very nice image for the raster and I also get a proper fishnet. But I cannot attach the value of the cells in the raster to the fishnet. I also cannot use the raster to join my oilfield data (which is the reason I am doing all this). Can you tell me what I am doing wrong?

Re: From Point to Gird, fishnet does not work

DanPatterson_Retired — Wed, 31 May 2017 16:21:37 GMT

see you other thread

Re: From Point to Gird, fishnet does not work

JayantaPoddar — Wed, 31 May 2017 18:35:39 GMT

I am able to do the spatial join without any issue. Moreover, I am not getting the option of Merge Rule in the tool.

using ArcMap 10.5 (Analysis toolbox > Overlay toolset > Spatial Join).

Re: From Point to Gird, fishnet does not work

CB — Thu, 01 Jun 2017 11:12:27 GMT

I don't have access to ArcMap at the moment; I hope this will change soon. For the moment I am limited to ArcGIS Pro.

I helped myself with Raster to Polygon, but unfortunately this is not a solution as I need information for each seperate cell.

Re: From Point to Gird, fishnet does not work

EziMolley — Fri, 02 Jun 2017 12:57:24 GMT

Hi CB,

I can see that there are multiple ways to do this.

You can get the same result by following these steps.

1. Add the point FC into the ArcMap. Make sure you select WGS 84 as Coordinate System of Input Coordinates.

2. Then use the Fishnet tool. The trick is that you would need to redefine the AOI; that is reshaping the bounding box. That way your point data extent would allow the polygon grids to have the point data as center point. See screenshot below.

3. You can check “Create Label Points “if you want. But in this case, it’s unnecessary.

Result:

4. Once you have the fishnet, you can use the Join data geoprocessing tool to combine both attribute table -- the point data and the newly created polygon grid data-- (make sure you select “Join data from another layer based on spatial location”. This would allow you to create a new polygon dataset with all the point data attribute.

Right-click the Fishnet polygon layer in the TOC and select the Point Feature layer. In this example, the "SedThickness" is the point feature class.

Final result is:

Note: You can follow the same process in ArcGIS Pro, no problem.