Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.
Sign up to join this community
I have a data set that contains intersection data. Each intersection node has up to 6 links which is identified by IN_LINK and OUT_LINK attributes. I want to create a new dataset that includes the intersection node value (NODE) and all of its accompanying links as a single record.
[NODE] [LINK_1] [LINK_2] etc...
5465 45687 9831 etc...
How would I code this in python?
From your screenshot I see you are using ArcGIS. I do not know if you have the required Info/Advanced license, but there is a Pivot Table tool that may do what you want. It can flatten one-to-many relationships in a table, and unlike the two related questions below, it actually creates new attribute fields for each of the values instead of writing them all to a single field. There are Python code samples, including stand-alone script, at the linked help page.
If you don't have access to the Pivot Table tool, or want to do it without relying on that, there are two questions with slightly different approach answers that partially solve the problem already here on GIS.SE:
Both provide code/script solutions, but both also write the values to a single field. If you want separate attributes, you would have to add some code that would then add the necessary number of new fields and split the values from the single field to their individual ones.
5465 45687 9831from the attached table. For example, where did ***87 and ***1 come from?