Re: [Qgis-user] Swiss Knife. (ogr2ogr GUI and more)
Hi Peter, On Mon, 09. Feb 2009 at 10:06:42 +0100, Peter Bange wrote: > I am doing my best to get people in my organization use Q-gis in > combination with a postgres/postgis database. I found out that not > many GIS specialists are familiar with (relational) databases. Some of > my collegues use ArcGIS, others MapInfo. All the data are stored as > shape and tab files. To help them get used to storing (all) their data > in a database I developed a tool. I have nick named it Swiss Knife, > you can do a number of different things with it: > [...] Sounds very interesting. > The tool is written in REALbasic, I generate executables for Mac and > Windows, did not try it for Linux but that should not be difficult. I suppose that's the language you are most familiar with. Otherwise this is probably not the best choice for QGIS - as you can't reuse stuff from QGIS. The PostGIS table manager plugin for instance can provide graphical previews of PostGIS tables. Most of the features you describe, would probably be a good extension for that plugin. And there also is the ogr2ogr converter plugin. BTW the history/changelog part is also something addressed elsewhere (PostGIS Historisierung [1]; I don't know if there is a English version of this) - no plugin yet. Is that the same concept? > I have no intention of making this tool for sale or something, just help > to promote Qgis. Anyone interested ? It is in a beta stage, but it is > starting to gain speed ... Is this going to be a free project? Do you have a link? Jürgen [1] http://gis.hsr.ch/wiki/images/4/44/Postgis_historisierung.pdf -- Jürgen E. Fischer norBIT GmbH Tel. +49-4931-918175-20 Dipl.-Inf. (FH) Rheinstraße 13Fax. +49-4931-918175-50 Software Engineer D-26506 Norden http://www.norbit.de -- norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH Rheinstrasse 13, 26506 Norden GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502 ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Swiss Knife. (ogr2ogr GUI and more)
Peter Bange ha scritto: > I am doing my best to get people in my organization use Q-gis in combination > with a postgres/postgis database. I found out that not many GIS specialists > are familiar with (relational) databases. Some of my collegues use ArcGIS, > others MapInfo. All the data are stored as shape and tab files. To help them > get used to storing (all) their data in a database I developed a tool. I have > nick named it Swiss Knife, you can do a number of different things with it: > The tool is written in REALbasic, I generate executables for Mac and Windows, > did not try it for Linux but that should not be difficult. I have no > intention of making this tool for sale or something, just help to promote > Qgis. Anyone interested ? It is in a beta stage, but it is starting to gain > speed ... Pity it's not in python, as other similar plugins for qgis. This will make integration with main qgis more difficult, I believe. All the best. pc -- Paolo Cavallini, see: * http://www.faunalia.it/pc * ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
[Qgis-user] Swiss Knife. (ogr2ogr GUI and more)
Hi There, I am doing my best to get people in my organization use Q-gis in combination with a postgres/postgis database. I found out that not many GIS specialists are familiar with (relational) databases. Some of my collegues use ArcGIS, others MapInfo. All the data are stored as shape and tab files. To help them get used to storing (all) their data in a database I developed a tool. I have nick named it Swiss Knife, you can do a number of different things with it: - You can store Q-gis projects in the database - There is a meta-system to store and search information on all the tables you add or change - It allows to redirect information from a number of tables to one single table - It allows you to generate a trigger on tables that will make postgres keep a log of all changes - It generates pgSQLcode that will generate a view on this table and its log that will reconstruct historical situations - It offers a GUI around ogr2ogr that makes conversion between formats easyer - When you generate shape files etc. from a postgis table, you can lock the records exported. This allows integeration of the database with ArcGIS, MapInfo users etc. (I prefer Qgis, but ...), these records can then be read, but not changed by others - When reimporting such shape etc. files again into the database the records are unlocked for edit by others - It can transform a simple ascii rasterfile to a table with square polygons (vectorization) - There is a tool that helps generating vieuws for use with Qgis (can ensure a unique key) - There is a little trick to help adding texts in Qgis easier, it could be expanded - You can create copies of GIS tables The tool is written in REALbasic, I generate executables for Mac and Windows, did not try it for Linux but that should not be difficult. I have no intention of making this tool for sale or something, just help to promote Qgis. Anyone interested ? It is in a beta stage, but it is starting to gain speed ... It needs some tables to run, I will supply these to anyone who wants them. There is also a first draft of a user manual. Peter Bange ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user