Data Output Format

LindseyWinn — Mon, 29 Jul 2019 20:20:49 GMT

Is anyone familiar with wide vs. long format?

Example - I have 10 unique IDs (polygons). I intersect them with another polygon shapefile, and those records that intersect more than one polygon yields more than one row, but with the same unique ID (so I'd have 20 rows instead of 10, for example). Is there a way to get those into another column instead of an extra row?

Initial data:

ID School
1. Ball State University

Then I intersect with a city shapefile and it comes out like this:

ID       School                                  City
1.       Ball State University             Muncie
1.       Ball State University             New Castle

I have two records that have the same ID and school, but two different cities. I’d like for it to look like this (all on one line):

ID School City1 City2
1. Ball State University Muncie New Castle

Does this make sense? can this be fixed in ArcMap?

Re: Data Output Format

JosephCarter — Tue, 30 Jul 2019 18:00:17 GMT

Hey, Lindsay. Try using "Geoprocessing/Union" instead of intersect. . .See "Union (Analysis) in the help menu to get acquainted. Join all attributes.

Good luck!

Joe

topic Data Output Format in ArcGIS Mapping and Charting Questions

Data Output Format

Re: Data Output Format