1

I have 30+ events of data collection for each GPS location (previous person on project has simply added new rows for each data collection period). When I import the excel file (via CSV format), each location therefore has 30+ gps points stacked on top of one another. How can I get a single GPS point to reference 30+ entries without also having 30+ repeated spots on the map?

enter image description here

Improve this question
3
  • I would fix this in excel stackoverflow.com/questions/13307927/…. It gets a bit more complicated trying to get the unique over 3 columns but it's just an extension of the formula in that answer.
    – Michael Stimson
    Commented Jul 29, 2015 at 0:36
  • Still not quite what I am looking for. I need to hang on to the associated data for each repeated location (each entry is a separate event).
    – laureltron
    Commented Jul 29, 2015 at 3:50
  • Almost all GIS data is one shape to one record, if you want 30 point records you need 30 points... that's just the way it is. You can relate your data such that one geometry references multiple rows in an aspatial table like gis.stackexchange.com/questions/137711/… that way you 'see' only one point but can query all the related rows.
    – Michael Stimson
    Commented Jul 29, 2015 at 3:53

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.