On 11/16/2013 07:27 PM, Sasa Sullivan wrote:
I am looking for a process for genealogy, to join one person to
multiple people whose ancestors hail from many different geographical
locations in order to query the program for those who live in close
proximity to each other (each person involved has multiple locations
actually). Is this possible, as my spreadsheet has many columns with
different locations, must I make a separate line item for each
location? I would also need a way to query the results as I am only
vaguely familiar with the query function from a community college
course I took a few years back, the class used Arcgis and not QGIS. I
am working with QGIS version 2.0.1 but will adjust to earlier versions
if I had a instructions or a tutorial.
Sasa
This request is a little vague. What is a record in you data? One
person? What location data do you have per person? At a guess, this is
something that can be done without any spatial data, i.e. Person A is
linked to New York City, Person B is linked to New York City, therefore
Person A is linked to Person B. Even if New York City has a spatial
representation associated with it, the join operation would go much
faster if you did it as an attribute join (by the name or code
representing the location) rather than a spatial join. This is something
I would tend to do in pure SQL.
But I could be misunderstanding your intention. Some more detail would
be helpful.
Best,
--Lee
--
Lee Hachadoorian
Assistant Professor in Geography, Dartmouth College
http://freecity.commons.gc.cuny.edu
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
