[Qgis-user] [PROPOSAL] From srs.db to file-based CRS storage
Hi all, currently QGIS used srs.db to store projection definitions. But with this approach users can't reorganize CRS definitions as they want (always used predefined tree with predefined groups). This can be solved by switching to file-based storage of the CRS definitions as in latest ArcGIS versions or wxGIS. All CRS definitions are stored as files in WKT or SPR (preffered) format in subdirectories in some redefined folder and user can freely create new subdirectories and move files between them to organize CRS'es as he/she wants. Opinions, comments? Thanks -- Alexander Bruy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] [PROPOSAL] From srs.db to file-based CRS storage
Hi, srs.db is file-based already. You can easily edit and update it with any sqlite compatible db application, such as sqliteman, openoffice, qgis, firefox, etc. To me this is pretty much accessible already. Andreas On 01/30/2012 08:58 PM, Alexander Bruy wrote: Hi all, currently QGIS used srs.db to store projection definitions. But with this approach users can't reorganize CRS definitions as they want (always used predefined tree with predefined groups). This can be solved by switching to file-based storage of the CRS definitions as in latest ArcGIS versions or wxGIS. All CRS definitions are stored as files in WKT or SPR (preffered) format in subdirectories in some redefined folder and user can freely create new subdirectories and move files between them to organize CRS'es as he/she wants. Opinions, comments? Thanks ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] [PROPOSAL] From srs.db to file-based CRS storage
Hi Andreas, 2012/1/30 Andreas Neumann a.neum...@carto.net: srs.db is file-based already. You can easily edit and update it with any sqlite compatible db application, such as sqliteman, openoffice, qgis, firefox, etc. Working with sqlite requires SQL knowledge and database manager/editor, while moving and editing flat text files is much easier for ordinal users. -- Alexander Bruy ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] [PROPOSAL] From srs.db to file-based CRS storage
I am definitely not advocating for a switch to a different CRS database. I would guess that the SQLite solution performs better than proj.4 as well. On recommendation for improving performance in applications like MapServer that use proj.4 is to delete out the SRS definitions that you will never use... David. On Mon, Jan 30, 2012 at 3:07 PM, Andreas Neumann a.neum...@carto.net wrote: Well - in my opinion, if one really wants to edit CRS it would be best to document the process well in the manual and leave the CRS storage as is. 1. - one doesn't need to edit the definitions very often 2. - one needs to do it very carefully. CRS definitions are far more complex than SQL in my opinion. You really need to know what you do or your data will end up corrupted. 3. - SQLite databases are very accessible. Even QGIS can be used to open and edit the tables. SQLiteMan comes with every Linux distribution and also as a firefox plugin. 4. - with SQLite, the data is at least structure. With text-based formats you need to parse the format and you open doors for mistakes and unstructured data. 5. - if definitions are missing, people should contribute them to the project so others can use them as well. Just my two cents. Andreas On 01/30/2012 09:31 PM, Alexander Bruy wrote: Hi Andreas, 2012/1/30 Andreas Neumann a.neum...@carto.net: srs.db is file-based already. You can easily edit and update it with any sqlite compatible db application, such as sqliteman, openoffice, qgis, firefox, etc. Working with sqlite requires SQL knowledge and database manager/editor, while moving and editing flat text files is much easier for ordinal users. ___ 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
Re: [Qgis-user] [PROPOSAL] From srs.db to file-based CRS storage
Hi David I would guess that the SQLite solution performs better than proj.4 QGIS uses also the proj4 library to do coordinate transformations On recommendation for improving performance in applications like MapServer that use proj.4 is to delete out the SRS definitions that you will never use QGIS uses a CRS cache to lookup definitions by epsg value (avoids too many access to sqlite file, especially for QGIS server). Regards, Marco On 30.01.2012 22:17, David Fawcett wrote: I am definitely not advocating for a switch to a different CRS database. I would guess that the SQLite solution performs better than proj.4 as well. On recommendation for improving performance in applications like MapServer that use proj.4 is to delete out the SRS definitions that you will never use... David. On Mon, Jan 30, 2012 at 3:07 PM, Andreas Neumanna.neum...@carto.net wrote: Well - in my opinion, if one really wants to edit CRS it would be best to document the process well in the manual and leave the CRS storage as is. 1. - one doesn't need to edit the definitions very often 2. - one needs to do it very carefully. CRS definitions are far more complex than SQL in my opinion. You really need to know what you do or your data will end up corrupted. 3. - SQLite databases are very accessible. Even QGIS can be used to open and edit the tables. SQLiteMan comes with every Linux distribution and also as a firefox plugin. 4. - with SQLite, the data is at least structure. With text-based formats you need to parse the format and you open doors for mistakes and unstructured data. 5. - if definitions are missing, people should contribute them to the project so others can use them as well. Just my two cents. Andreas On 01/30/2012 09:31 PM, Alexander Bruy wrote: Hi Andreas, 2012/1/30 Andreas Neumanna.neum...@carto.net: srs.db is file-based already. You can easily edit and update it with any sqlite compatible db application, such as sqliteman, openoffice, qgis, firefox, etc. Working with sqlite requires SQL knowledge and database manager/editor, while moving and editing flat text files is much easier for ordinal users. ___ 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 -- Dr. Marco Hugentobler Sourcepole - Linux Open Source Solutions Churerstrasse 22, CH-8808 Pfäffikon SZ, Switzerland marco.hugentob...@sourcepole.ch http://www.sourcepole.ch Technical Advisor QGIS Project Steering Committee ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
