<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<pre wrap="">Kyle,
My experience with spatial lite is limited, but When working with PostgreSQL (PostGIS), you can save the style to the database, not sure if this is only available in PostgreSQL.
Might I also suggest you send the QGIS Project File, this will keep all the styling for you, and as long as the other users open it in QGIS.
Regards,
Richard.
</pre>
<br>
<div class="moz-cite-prefix">On 18/02/2016 22:15, Alex M wrote:<br>
</div>
<blockquote cite="mid:56C6427F.4020803@wildintellect.com"
type="cite">
<pre wrap="">Please keep conversation on list.
So did you try saving 1 style per table to the db? I don't think there's
any benefit to the shapefile route. Now if you want to create the style
once, and then copy it for each table, that might be a little trickier
but probably possible with a little bit of crafty SQL. Or the manual
way, copy style - paste style - save style.
Thanks,
Alex
On 02/18/2016 02:13 PM, Kyle T. Kouri wrote:
</pre>
<blockquote type="cite">
<pre wrap="">So I have been experimenting for past few days. Save as default does not seem
to work with one file and multiple tables. But once i go to lets say a shape
file that has one table it works perfect. I think I am stuck at having a bunch
of shape files instead of one DB file with multiple tables.
On Thu, Feb 18, 2016 04:25 PM, Alex M <a class="moz-txt-link-rfc2396E" href="mailto:tech_dev@wildintellect.com"><tech_dev@wildintellect.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">
</pre>
</blockquote>
<pre wrap="">On 02/18/2016 12:44 PM, Kyle T. Kouri wrote:
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">Hello all,
I have a spatial lite db file that has 15 tables in it. I am trying to
</pre>
</blockquote>
<pre wrap="">figure
</pre>
<blockquote type="cite">
<pre wrap="">out a way to create style files for each table and then when ever I open
</pre>
</blockquote>
<pre wrap="">this
</pre>
<blockquote type="cite">
<pre wrap="">the styles are saved with it. Right now I have to open one at a a time for
each table in the spatial lite DB. My goal is to have multiple .sl3 db
</pre>
</blockquote>
<pre wrap="">files
</pre>
<blockquote type="cite">
<pre wrap="">with the same tables (different data) for each of the national
</pre>
</blockquote>
<pre wrap="">parks in the
</pre>
<blockquote type="cite">
<pre wrap="">USA. But when I send the data out people can just open up the .sl3 file in
QGIS and see the style the way I want set it. So they dont also have to
</pre>
</blockquote>
<pre wrap="">load
</pre>
<blockquote type="cite">
<pre wrap="">all the .qml or .sld files.
Kyle Todd Kouri
</pre>
</blockquote>
<pre wrap="">
This is the closest thing I know of
<a class="moz-txt-link-freetext" href="https://pvanb.wordpress.com/2014/05/15/saving-layer-styles-to-your-spatialite-database/">https://pvanb.wordpress.com/2014/05/15/saving-layer-styles-to-your-spatialite-database/</a>
I was wondering what would happen if you had multiple styles for the
same layer, and I think the Save as Default style box is the key there.
Otherwise I would save QGIS projects, and send the project file with the
data, and tell users to open the projects.
You could potentially write a plugin that does the autoloading of
associated styles and tables too.
Enjoy,
Alex
</pre>
</blockquote>
<pre wrap="">
Kyle Todd Kouri
</pre>
</blockquote>
<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="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<b><u>Richard McDonnell</u></b><br>
<b><small><small><small>GIS Specialist PgD GIS AssocSCSI</small></small></small></b><br>
<b><small>OPW FRM Data Management</small></b><br>
<b><small>52 Stephens Green, Dublin 2.</small></b><br>
<small><small>TEL: 01 6476543</small></small></div>
<!-- http://www.unicodetools.com/unicode/convert-to-html.php -->
<div style="font-family: Arial; font-size: 8pt;">
OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart<br/>
OPW - Looking to the future - Caring for the past<br/>
<a href="http://www.opw.ie/"><img height="76" width="494" src="http://www.opw.ie/en/media/opw-email-banner.png"/></a><br/>
Email Disclaimer: <a href="http://www.opw.ie/en/disclaimer/">http://www.opw.ie/en/disclaimer/</a>
</div>
</body>
</html>