topic Assign attributes in Spatial Data Science Questions

Assign attributes

SatyanarayanaNarmala — Tue, 19 Jul 2016 06:10:50 GMT

Hi, i have a view in postgres view comprising of X Y coordinates (Non-spatial) and a polygon layer(spatial). i need to assign the polygon attributes to the XY table under which the coordinates are falling without any intermediate stages like creating a point feature class from the view.

Re: Assign attributes

NeilAyres — Tue, 19 Jul 2016 06:13:42 GMT

You can make an XY event layer from the XY table in ArcMap, which is sort of like a temporary feature class.

Then a spatial join between the points and the polygons should enable you to calculate the attributes from one to the other.

Re: Assign attributes

SatyanarayanaNarmala — Tue, 19 Jul 2016 06:19:39 GMT

Can i do it directly, with out any intermediate stage such as converting the XY event theme to point then spatial join.

Re: Assign attributes

NeilAyres — Tue, 19 Jul 2016 06:33:47 GMT

Well, I do not know what your db is, but if it is a spatially enabled database, there will be ways to create a temporary geometry from the points then do some overlay inside the db in SQL. But I am not an expert in that.

But you will need some form of geometry both sides to use any sort of spatial query.

Re: Assign attributes

RebeccaStrauch__GISP — Tue, 19 Jul 2016 15:18:20 GMT

I don't know anything about postgres, but if you are just trying to add the polygon fields to the point file...and assuming they have some type of common field between the two tables, and/or you can add a common field, and/or, they all are in on polygon, you may want to look at Join Field—Help | ArcGIS for Desktop

That is a lot of assumptions, but without having some intermediate step to make the XY coordinates become spatially aware, you would have to do a lot more work, and most likely some type of python or other program. There may be tools that already automate that (i.e., creating the temp spatial, join, and then wipe our the temp file), but I don't know of one off hand.