<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor=white lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal style='margin-left:.5in'><strong><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Person A is linked to New York City, Person B is linked to New York City, therefore Person A is linked to Person B.</span></strong><o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'> <o:p></o:p></p><p class=MsoNormal style='margin-left:.5in'><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Yes, however Person A and B also have 50 other locations that need to be checked against each other. The data might say NY, NYC, or NY City or New York, NY and other variations, geocoding allows for the different ways a locations is represented I do not want to rely on how others spell their locations and I need to share them on a map.</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Isn’t that relatively easy to fix by creating a new field, and assigning the correct attribute by location, namely nyc or whatever name you choose?<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Wouldn’t that make things much easier<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Jake<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext'> qgis-user-bounces@lists.osgeo.org [mailto:qgis-user-bounces@lists.osgeo.org] <b>On Behalf Of </b>Lee Hachadoorian<br><b>Sent:</b> Monday, November 18, 2013 1:10 AM<br><b>To:</b> Sasa Sullivan; qgis-user@lists.osgeo.org<br><b>Subject:</b> Re: [Qgis-user] Joining with Multiple Locations per Person<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><div><p class=MsoNormal>On 11/17/2013 03:34 PM, Sasa Sullivan wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><div><div><p class=MsoNormal>Hi Lee, <o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Hopefully I can be a bit clearer here, if not please do not hesitate to let me know, either on this post or to my email, I have tried to search online and the help functions for similar questions and responses before I posted to this board. Your questions/statements in bold text.<o:p></o:p></p><div><p class=MsoNormal><o:p> </o:p></p></div><div><div><p class=MsoNormal><strong><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>But I could be misunderstanding your intention. Some more detail would be helpful.</span></strong><o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>The people concerned have been matched to each other via DNA, their mission is to find the most recent common ancestors, this by looking at genealogical data which consists of surnames and locations. I don't want to include the questions about DNA as that is another matter and once I can find answers to this question I can probably answer that one myself.</span><o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><p class=MsoNormal><strong><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>What is a record in you data?</span></strong><o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>A record consists of one person with multiple geographical locations and surnames who need to find a common location(s)/surname(s) with other people who also have multiple geographical locations and surnames (some small groups of people are linked to each other as well). There is never just one surname and/or location per person</span><o:p></o:p></p></div></div></div></div></div></div></div></blockquote><p class=MsoNormal><br>This seems to be outside the "standard" GIS model where an entity has one location (really one geometry) and a fixed number of clearly defined attribute columns. Your entities have a variable number of locations, and perhaps a variable number of attribute columns (the surnames) as well. Possibly this has some similarity to an animal tracking model, where each animal has multiple timepoints, and you might ask where two animals crossed paths. But I am not very familiar with this field and don't know how easy it would be to implement in QGIS or any other tool.<br><br><br><o:p></o:p></p><div><div><div><div><div><div><div><p class=MsoNormal> <o:p></o:p></p></div><div><p class=MsoNormal><strong><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>What location data do you have per person?</span></strong><o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Each person's location numbers are varied, from four minimum to close to a hundred</span><o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><p class=MsoNormal><strong><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>At a guess, this is something that can be done without any spatial data, i.e.</span></strong><o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Geocoding will work best as it does not rely on spellings with are too varied</span><o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><p class=MsoNormal><strong><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Person A is linked to New York City, Person B is linked to New York City, therefore Person A is linked to Person B.</span></strong><o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Yes, however Person A and B also have 50 other locations that need to be checked against each other. The data might say NY, NYC, or NY City or New York, NY and other variations, geocoding allows for the different ways a locations is represented I do not want to rely on how others spell their locations and I need to share them on a map.</span><o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Initially the people are linked to each other on one or more chromosomes, I can sort that in Excel. There might be another type of programs that can handle my questions however I do not know of any names, then I can transfer the results into QGIS.</span><o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><p class=MsoNormal><strong><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>This is something I would tend to do in pure SQL.</span></strong><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'> </span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>I do not know much about programming, beyond what someone directs me to do and was hoping the query functions of QGIS would handle what I was asking, if this were a one to one comparison I could do it in Excel or a database program, ultimately I need to put the information on a map</span><o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Thank you so much for responding, I don't know of a beginners list to ask these questions. As I write this perhaps I can geocode and let Excel query the latitude and longitude for my matches.</span><o:p></o:p></p></div></div></div></div></div></div></div><p class=MsoNormal><br>Possibly the geocoder outputs some other identifying field like a standardized name, code, or some unique ID. In which case you could search for matches on that field, rather than lat-long. <br><br>One thing that might make this easier is to think of a person_ancestry_locations table with a person ID and a location (standardized name or code) field, where each person has one record for each location they are associated with. <br><br>But I can't think of a way to do this in QGIS that isn't incredibly contorted. I would probably just use QGIS for the final mapping of common locations.<br><br>Best,<br>--Lee <o:p></o:p></p><pre>-- <o:p></o:p></pre><pre>Lee Hachadoorian<o:p></o:p></pre><pre>Assistant Professor in Geography, Dartmouth College<o:p></o:p></pre><pre><a href="http://freecity.commons.gc.cuny.edu">http://freecity.commons.gc.cuny.edu</a><o:p></o:p></pre></div></body></html>