Re: [Qgis-user] style files
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. On 18/02/2016 22:15, Alex M wrote: 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: 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 wrote: On 02/18/2016 12:44 PM, Kyle T. Kouri wrote: Hello all, I have a spatial lite db file that has 15 tables in it. I am trying to figure out a way to create style files for each table and then when ever I open this 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 files with the same tables (different data) for each of the national parks in the 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 load all the .qml or .sld files. Kyle Todd Kouri This is the closest thing I know of https://pvanb.wordpress.com/2014/05/15/saving-layer-styles-to-your-spatialite-database/ 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 Kyle Todd Kouri ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user -- *_Richard McDonnell_* *GIS Specialist PgD GIS AssocSCSI* *OPW FRM Data Management* *52 Stephens Green, Dublin 2.* TEL: 01 6476543 OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart OPW - Looking to the future - Caring for the past *** Email Disclaimer: http://www.opw.ie/en/disclaimer/ ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] style files
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: > 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 wrote: >> > On 02/18/2016 12:44 PM, Kyle T. Kouri wrote: >>> Hello all, >>> I have a spatial lite db file that has 15 tables in it. I am trying to >> figure >>> out a way to create style files for each table and then when ever I open >> this >>> 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 >> files >>> with the same tables (different data) for each of the national >> parks in the >>> 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 >> load >>> all the .qml or .sld files. >>> >>> Kyle Todd Kouri >>> >>> >> >> This is the closest thing I know of >> https://pvanb.wordpress.com/2014/05/15/saving-layer-styles-to-your-spatialite-database/ >> 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 >> >> >> >> > > Kyle Todd Kouri > > > ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] style files
On 02/18/2016 12:44 PM, Kyle T. Kouri wrote: > Hello all, > I have a spatial lite db file that has 15 tables in it. I am trying to figure > out a way to create style files for each table and then when ever I open this > 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 files > with the same tables (different data) for each of the national parks in the > 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 load > all the .qml or .sld files. > > Kyle Todd Kouri > > This is the closest thing I know of https://pvanb.wordpress.com/2014/05/15/saving-layer-styles-to-your-spatialite-database/ 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 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] style files
Hello all, I have a spatial lite db file that has 15 tables in it. I am trying to figure out a way to create style files for each table and then when ever I open this 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 files with the same tables (different data) for each of the national parks in the 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 load all the .qml or .sld files. Kyle Todd Kouri ___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Style files
Hello Priscilla, there is a plugin that will enable you to open MapInfo .wor files in QGIS. MapInfo styles are a double faced beast, features could be styled inside the .tab file, but themes are added in the wor(kspace). Both are well documented, OGR (a part of GDAL -- www.gdal.org -- which is the library that QGIS uses to access files) can read and pass styling to QGIS, and wor files are mostly converted into QGIS projects by the OpenWOR plugin ( https://plugins.qgis.org/plugins/openwor/). MapInfo workspaces are anyway fairly easy to mimic "by hand", reading the layers needed and their styling (wor is a text file with a list of layers and commands). Color description is somehow an obstacle, but if your workspaces are not well converted, I should dig in my old documents to find out what you need. Even other "closed" GIS programs are not so closed: lyr files are text as well, and GeoMedia geoworkspaces are or could be saved as xml. QGIS handles styles very well by means of QT, using QML (an open but specialized XML), and also by SLD (more widely used and OGC standard). It can save styles besides files or inside a database, providing something very similar to .lyr files in ArcGIS. Beware that styles saved with projects override those saved into the database, so potential conflicts may arise. c On Thu, Sep 18, 2014 at 11:09:51 +, Priscilla Maisie < adwoa.mai...@gmail.com> wrote: > To: qgis-user@lists.osgeo.org > Subject: [Qgis-user] Style files > Message-ID: > < > cajleq3q5vya4kt_t2qewg4axy5243_xepsf0dmvms0jns3w...@mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > Hi, I'm a new qgis user n I need to get some style files for geological > structures, and diverse line styles which are currently not in qgis. Has > can I convert esri and MapInfo style files into a format I can upload into > qgis. > > Please help. -- > -- Carlo A. Bertelli Charta servizi e sistemi per il territorio e la storia ambientale srl Dipendenze del palazzo Doria, vc. alla Chiesa della Maddalena 9/2 16124 Genova (Italy) tel. +39(0)10 2475439 fax +39(0)10 2475439 gsm:+39 393 1590711 e-mail: berte...@charta.acme.com http://www.charta.acme.com -- ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Style files
Hello priscilla, If you are able to save them in the open and standard SLD file format, you will be able to open it in qgis (and many other applications). Otherwise, I'm afraid that esri and mapinfo files are "closeded" and therefore not readable by qgis (and many other applications). Alexandre Neto Em 18/09/2014 12:10, "Priscilla Maisie" escreveu: > Hi, I'm a new qgis user n I need to get some style files for geological > structures, and diverse line styles which are currently not in qgis. Has > can I convert esri and MapInfo style files into a format I can upload into > qgis. > > Please help. > > ___ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-user > ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Style files
Hi, I'm a new qgis user n I need to get some style files for geological structures, and diverse line styles which are currently not in qgis. Has can I convert esri and MapInfo style files into a format I can upload into qgis. Please help. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user