<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Samuel,</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.</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.</p>
<p>If you want to discuss it further, feel free to email me
directly.<br>
</p>
<pre class="moz-signature" cols="72">Best Regards,
Brent Fraser
GeoAnalytic Inc
Calgary, Alberta, Canada
</pre>
<div class="moz-cite-prefix">On 2/22/2017 11:14 AM, Samuel Lacrampe
wrote:<br>
</div>
<blockquote
cite="mid:cd303227b7154942b52ff372afc9bb69@C060EX004.patchingassociates.local"
type="cite">
<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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@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]-->
<div class="WordSection1">
<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 style="mso-fareast-language:EN-CA"
lang="EN-US">Samuel Lacrampe, P.Eng., INCE<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-CA"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-CA"
lang="EN-US">Patching Associates Acoustical Engineering
(PAAE) |<b>
</b><a moz-do-not-send="true"
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="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="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="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;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;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;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="mso-fareast-language:EN-CA"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-CA"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
</body>
</html>