<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=iso-8859-1"><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";}
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";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;}
@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 lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Lee<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I understood your point, and I agree with it. It is not only that we want to have something presentable soon (that’s one good point) but also that when we use a database design some not so computer savvy people may be throwing the towel. So starting with a simple table design (csv) would be easier for some. And as we get more experience and more complex in the design than we still can easily switch to a database design. I think it would also be good to maintain a version with just excel files, (xlsx) in addition to database files because many don’t have and don’t know database software.<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>J<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 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"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Lee [mailto:muellerl@gmail.com] <br><b>Sent:</b> Sunday, June 02, 2013 4:07 PM<br><b>To:</b> Jake Maier<br><b>Cc:</b> ForestryTools List<br><b>Subject:</b> Re: [ForestryTools] database/ early design<o:p></o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal style='margin-bottom:12.0pt'>To clarify, my thoughts are not targetted towards the long-term use/feasibility of using tables/csv verses database. In the long term, databases will be necessary to handle more complex data for a variety of users. That said, I do think it is important we get something usable going as soon as possible to attract further interest. In this sense, I wondered if we'd be able to short-cut around some of the database design for the time being by using simple joins between table data and spatial data.<o:p></o:p></p></div><p class=MsoNormal>In this case, I'm in no way an expert. It just might be worth discussion.<o:p></o:p></p></div><div><p class=MsoNormal><br clear=all><o:p></o:p></p><div><p class=MsoNormal><br>--<br>All the best,<br>Lee<br>ISA Certified Arborist MI-4148A<br>Registered Forester #46043<o:p></o:p></p></div><p class=MsoNormal style='margin-bottom:12.0pt'><o:p> </o:p></p><div><p class=MsoNormal>On Fri, May 31, 2013 at 7:02 PM, Jake Maier <<a href="mailto:j.m@jmforestry.com" target="_blank">j.m@jmforestry.com</a>> wrote:<o:p></o:p></p><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hi Lee and Abdoul.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>I think a simple table is easier if it’s a simple relationship between the spatial and the tabular data. If the relationships are complex and changes often depending on the particular situation, then a database is quicker and easier.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Thanks for your good work.</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>My 2 ct</span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Jake </span><o:p></o:p></p><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'> </span><o:p></o:p></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> <a href="mailto:forestrytools-bounces@lists.osgeo.org" target="_blank">forestrytools-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:forestrytools-bounces@lists.osgeo.org" target="_blank">forestrytools-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Abdoul O. Dia<br><b>Sent:</b> Friday, May 31, 2013 3:03 PM<br><b>To:</b> <a href="mailto:forestrytools@lists.osgeo.org" target="_blank">forestrytools@lists.osgeo.org</a><br><b>Subject:</b> Re: [ForestryTools] database/ early design</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Hi Lee,<br><br>This could be a way to start and test it. But we need to keep in mind that we'll need to handle external files (e.g. csv) and to manage spatial data (e.g.: vectors). The relationship between the external and spatial data should be kept some how so we can attribute to every single point or polygone in a shapefile its related data from the field. In this case I think using a database would be easier. What others think?<br><br>Abdoul<br><br><br>Le 2013-05-30 18:20, Lee a écrit :<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><div><div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'>To not flood the other string with a new topic, here's a new email:<o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'>I had a long drive the other day, which gave me a good chance to think things over regarding the database structure. Specifically, my current "narrative" I put on the forestry tools wiki calls for just loading external CSVs to do easy analysis, rather than porting into a database.<o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'>How do you feel about establishing initial functionality with simple tables, opposed to database structure? Once we get an initial release out and develop some interest, we could add more complex database support.<o:p></o:p></p></div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>I'm not sold either way, I just thought it might be worth discussion. I'm not sure what's simpler and more useful from a starting location.<br><br>Thoughts?<o:p></o:p></p><div><div><div><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><br>--<br>All the best,<br>Lee<br>ISA Certified Arborist MI-4148A<br>Registered Forester #46043<o:p></o:p></p></div></div></div></div></div></div><p class=MsoNormal style='mso-margin-top-alt:auto;margin-bottom:12.0pt'><br><br><o:p></o:p></p><pre>_______________________________________________<o:p></o:p></pre><pre>Forestrytools mailing list<o:p></o:p></pre><pre><a href="mailto:Forestrytools@lists.osgeo.org" target="_blank">Forestrytools@lists.osgeo.org</a><o:p></o:p></pre><pre><a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/forestrytools" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/forestrytools</a><o:p></o:p></pre></blockquote><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p></div></div></div></div><p class=MsoNormal style='margin-bottom:12.0pt'><br>_______________________________________________<br>Forestrytools mailing list<br><a href="mailto:Forestrytools@lists.osgeo.org">Forestrytools@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/forestrytools" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/forestrytools</a><o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p></div></div></body></html>