<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=utf-8">
<meta name="Generator" content="Microsoft Word 15 (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:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
color:black;
mso-fareast-language:EN-US;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;
mso-fareast-language:EN-CA;}
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;
font-family:"Calibri",sans-serif;
color:windowtext;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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-CA" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="color:windowtext">Thank you for the response Brent.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext">If I have any further questions, I will let you know.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext">Thank you,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext;mso-fareast-language:EN-CA">Samuel Lacrampe, P.Eng., INCE<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext;mso-fareast-language:EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="color:windowtext;mso-fareast-language:EN-CA">Patching Associates Acoustical Engineering (PAAE) |<b>
</b><a href="http://www.patchingassociates.com/"><span style="color:windowtext">www.patchingassociates.com</span></a><b><o:p></o:p></b></span></p>
<p class="MsoNormal"><span style="color:windowtext;mso-fareast-language:EN-CA">#20, 2150 - 29<sup>th</sup> Street NE, Calgary, Alberta, Canada T1Y 7G4<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext;mso-fareast-language:EN-CA">Direct: 1.403.730.7289 | Cell: 1.403.797.1854 | Toll Free: 1.888.465.5882 Ext. 7000 | Fax: 1.403.516.0544<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext;mso-fareast-language:EN-CA">Harmony. We help create spaces that people value.<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;color:windowtext;mso-fareast-language:EN-CA"><o:p> </o:p></span></b></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:7.0pt;color:windowtext;mso-fareast-language:EN-CA">Please consider the environment before printing this email. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:7.0pt;color:windowtext;mso-fareast-language:EN-CA">CONFIDENTIALITY NOTICE: This communication is confidential and may contain proprietary information for the exclusive use of the intended recipient. Any use, distribution
or copying of this transmission, other than by the intended recipient, is strictly prohibited. If you are not the intended recipient, please notify the sender and delete all copies.</span><span style="color:windowtext;mso-fareast-language:EN-CA"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext;mso-fareast-language:EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:windowtext"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="color:windowtext;mso-fareast-language:EN-CA">From:</span></b><span lang="EN-US" style="color:windowtext;mso-fareast-language:EN-CA"> Brent Fraser [mailto:bfraser@geoanalytic.com]
<br>
<b>Sent:</b> 22-Feb-17 15:52<br>
<b>To:</b> Samuel Lacrampe <slacrampe@patchingassociates.com>; qgis-user@lists.osgeo.org<br>
<b>Subject:</b> Re: [Qgis-user] Using QGIS as a spacial database<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p>Samuel,<span style="font-size:12.0pt;mso-fareast-language:EN-CA"><o:p></o:p></span></p>
<p> QGIS is more of a GIS viewing and analysis tool than a geospatial datastore (although I guess QGIS project files could be considered as at least storing references to geospatial data). I would recommend reconsidering using PostGIS as a geospatial datastore.<o:p></o:p></p>
<p> If that is not possible, you might be able to store geospatial data as blobs in your Ajera database (if it has that capability), and retrieve them using an ODBC connection, But you would still have to write a QGIS plugin to decode the blobs. Or you could
just use PostGIS. SQLite+Spatialite is another database option, and while this file-base database is easier to set up than a full blown client/server database, it has limitations with respect to size and multi use.<o:p></o:p></p>
<p>If you want to discuss it further, feel free to email me directly.<o:p></o:p></p>
<pre>Best Regards,<o:p></o:p></pre>
<pre>Brent Fraser<o:p></o:p></pre>
<pre>GeoAnalytic Inc<o:p></o:p></pre>
<pre>Calgary, Alberta, Canada<o:p></o:p></pre>
<div>
<p class="MsoNormal">On 2/22/2017 11:14 AM, Samuel Lacrampe wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">Hello,<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">My company is trying to obtain a GIS software to use as a database for our spatial technical data. I thought of QGIS, but without having to install additional database programs such as PostGIS.<o:p></o:p></p>
<p class="MsoNormal">I don’t want to obtain another database program because we already use one called Ajera, which is a regular (non-spatial) database program.
<o:p></o:p></p>
<p class="MsoNormal">The technical data I want to store on QGIS would be information that can be used on the software called CadnaA. Examples are: points, lines, area, 3D objects, images, photos, contour maps etc. The limitation with CadnaA is that it can only
contain about 1000 objects are once, which is enough for a single project model, but not enough for us to store data from many projects. My thought is that QGIS could serve as the “middle database” to store all the spatial information, which could then be
transferred into CadnaA as needed for analysis purposes. <o:p></o:p></p>
<p class="MsoNormal">Is QGIS alone, without the use of further database programs such as PostGIS, adequate for this?<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">I hope my question is clear enough.<o:p></o:p></p>
<p class="MsoNormal">Thank you,<o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-CA">Samuel Lacrampe, P.Eng., INCE</span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-CA"> </span><o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-CA">Patching Associates Acoustical Engineering (PAAE) |<b>
</b><a href="http://www.patchingassociates.com/"><span style="color:windowtext">www.patchingassociates.com</span></a></span><o:p></o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-CA">#20, 2150 - 29<sup>th</sup> Street NE, Calgary, Alberta, Canada T1Y 7G4</span><o:p></o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-CA">Direct: 1.403.730.7289 | Cell: 1.403.797.1854 | Toll Free: 1.888.465.5882 Ext. 7000 | Fax: 1.403.516.0544</span><o:p></o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-CA">Harmony. We help create spaces that people value.</span><o:p></o:p></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt;mso-fareast-language:EN-CA"> </span></b><o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:7.0pt;mso-fareast-language:EN-CA">Please consider the environment before printing this email. </span><o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:7.0pt;mso-fareast-language:EN-CA">CONFIDENTIALITY NOTICE: This communication is confidential and may contain proprietary information for the exclusive use of the intended recipient. Any use, distribution or copying
of this transmission, other than by the intended recipient, is strictly prohibited. If you are not the intended recipient, please notify the sender and delete all copies.</span><o:p></o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-CA"> </span><o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:EN-CA"><br>
<br>
<br>
<o:p></o:p></span></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>Qgis-user mailing list<o:p></o:p></pre>
<pre><a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><o:p></o:p></pre>
<pre>List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></pre>
<pre>Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;mso-fareast-language:EN-CA"><o:p> </o:p></span></p>
</div>
</body>
</html>