Latest Contributions by LindseyWinn

I have a list of addresses I've successfully geocoded, but the Address Type only yields a result of "Address". I have no variation in Address Type, which makes me hesitant to believe it's correct. I've tried two different locators (Street_Addresses_US and Composite_US) and both have the same output. Does anyone know why I don't have any variation in my Address Type field (i.e. Intersection, Postal, StreetAddr, etc)? Thank you! ... View more

Looking at the projection “NAD_1983_2011_California_Teale_Albers” and I wondered if projections are ever updated? What do the dates mean? Google isn’t coming through for me, but I know this community does! 😄 ... View more

Hello again! I'm trying to find the duplicates in one shapefile using the Intersect tool. It works great, but I'd love to know how to get it to tell me WHICH unique ID is the one that it intersects with. The selected features in the picture are the ones that are duplicates, but I'm not sure how to transfer over to Excel so I can show which ID is the duplicate.  I'd like my final example to look like this: UniqueID      Duplicate Value ID      Duplicate Value ID 2 9216               9366                              9490 Really, I'd only need the first duplicate value returned if that's easier. Anyone know how to accomplish this? Thanks so much! ... View more

Hello! I'm trying to manually resize the layout (not data frame) in the layout view in ArcMap. Is this possible? See image - I want to manually adjust the outermost left and right of the entire image but the only options I'm seeing are preset sizes. I need to get the same amount of space on all outermost parts of the shapefile, if that makes sense. Is this possible, or am I only allowed to pick from the map layouts that ArcMap has set up? For example, I want to change the width to 8.0 instead of 8.5 in my second example. Is this possible? Thanks! ... View more

Hi there,   I’ve been searching for a building footprint shapefile for the following cities, but haven’t had any luck: Cleveland, Dallas, Kansas City, Las Vegas, Phoenix, Providence, San Diego, Seattle  I’ve tried to find one for the entire US, and know Microsoft came out with that data, but I haven’t seen it in shapefile form. Does anyone know where I could find this shapefile (either the entire US or those specific cities)?   Thanks so much! ... View more

Hello, When I run the OD Cost Matrix tool (or Closest Facility), there are sometime records that are on a "non-traversable network." Is there a way to return more results for those missing records? What do you do when those pop up for you? Thanks! ... View more

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? ... View more

Are there any Excel pivot table experts out there? Example: 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 I assume I need to use a pivot table, but can’t figure out how to get it onto the second column.  You win if you can tell me how to do this!  ... View more