<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><DIV> </DIV>
<DIV> </DIV>
<DIV>Dear All,</DIV>
<DIV> </DIV>
<DIV> As a novice in QGIS, i created a column on an attribute which i dont want any more, pls can any experience person tell me how to delete the column.</DIV>
<DIV>Thanks</DIV>
<DIV>El-Oji</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><BR><BR>--- On <B>Wed, 7/27/11, qgis-user-request@lists.osgeo.org <I><qgis-user-request@lists.osgeo.org></I></B> wrote:<BR></DIV>
<BLOCKQUOTE style="BORDER-LEFT: rgb(16,16,255) 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px"><BR>From: qgis-user-request@lists.osgeo.org <qgis-user-request@lists.osgeo.org><BR>Subject: Qgis-user Digest, Vol 65, Issue 61<BR>To: qgis-user@lists.osgeo.org<BR>Date: Wednesday, July 27, 2011, 11:14 AM<BR><BR>
<DIV class=plainMail>Send Qgis-user mailing list submissions to<BR> <A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=qgis-user@lists.osgeo.org" ymailto="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</A><BR><BR>To subscribe or unsubscribe via the World Wide Web, visit<BR> <A href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target=_blank>http://lists.osgeo.org/mailman/listinfo/qgis-user</A><BR>or, via email, send a message with subject or body 'help' to<BR> <A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=qgis-user-request@lists.osgeo.org" ymailto="mailto:qgis-user-request@lists.osgeo.org">qgis-user-request@lists.osgeo.org</A><BR><BR>You can reach the person managing the list at<BR> <A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=qgis-user-owner@lists.osgeo.org"
ymailto="mailto:qgis-user-owner@lists.osgeo.org">qgis-user-owner@lists.osgeo.org</A><BR><BR>When replying, please edit your Subject line so it is more specific<BR>than "Re: Contents of Qgis-user digest..."<BR><BR><BR>Today's Topics:<BR><BR> 1. Re: object labels (Andreas Neumann)<BR> 2. RE: QGIS -> MySQL -> Mapserver ?? (Chris Green)<BR> 3. RE: QGIS -> MySQL -> Mapserver ?? (Saber)<BR> 4. DTclassifier is released (Maxim Dubinin)<BR><BR><BR>----------------------------------------------------------------------<BR><BR>Message: 1<BR>Date: Wed, 27 Jul 2011 11:00:01 +0200<BR>From: Andreas Neumann <<A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=a.neumann@carto.net" ymailto="mailto:a.neumann@carto.net">a.neumann@carto.net</A>><BR>Subject: Re: [Qgis-user] object labels<BR>To: <<A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=qgis-user@lists.osgeo.org"
ymailto="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</A>><BR>Message-ID: <<A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=2634cc5e1e8f0d3a1c3ecba07210ba79@carto.net" ymailto="mailto:2634cc5e1e8f0d3a1c3ecba07210ba79@carto.net">2634cc5e1e8f0d3a1c3ecba07210ba79@carto.net</A>><BR>Content-Type: text/plain; charset=UTF-8; format=flowed<BR><BR>Hi,<BR><BR>Currently, you have to create a new column. I usually create a view in <BR>Postgis for this purpose.<BR><BR>It is in on the wishlist that one can create a "virtual" column - not <BR>only for labeling, but also for map tips and perhaps symbolization. <BR>Until then you have to do it yourself.<BR><BR>Andreas<BR><BR>On Tue, 26 Jul 2011 22:51:34 +0200, Torsten Lange wrote:<BR>> Hi,<BR>><BR>> Is there a way just to print - lets say - the first four letters of a<BR>> objects<BR>> name? Or must I create a new row for that?<BR>><BR>> Thank you, Torsten<BR>>
_______________________________________________<BR>> Qgis-user mailing list<BR>> <A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=Qgis-user@lists.osgeo.org" ymailto="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</A><BR>> <A href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target=_blank>http://lists.osgeo.org/mailman/listinfo/qgis-user</A><BR><BR>-- <BR>--<BR>Andreas Neumann<BR>Böschacherstrasse 10A<BR>8624 Grüt (Gossau ZH)<BR>Switzerland<BR><BR><BR>------------------------------<BR><BR>Message: 2<BR>Date: Wed, 27 Jul 2011 10:00:27 +0100<BR>From: "Chris Green" <<A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=chris.green@ibstv.co.uk" ymailto="mailto:chris.green@ibstv.co.uk">chris.green@ibstv.co.uk</A>><BR>Subject: RE: [Qgis-user] QGIS -> MySQL -> Mapserver ??<BR>To: "'Saber Razmjooei'" <<A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=razmjooeis@faunalia.co.uk"
ymailto="mailto:razmjooeis@faunalia.co.uk">razmjooeis@faunalia.co.uk</A>><BR>Cc: <A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=qgis-user@lists.osgeo.org" ymailto="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</A><BR>Message-ID: <02a401cc4c3b$a25fa3a0$e71eeae0$@<A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=green@ibstv.co.uk" ymailto="mailto:green@ibstv.co.uk">green@ibstv.co.uk</A>><BR>Content-Type: text/plain; charset="us-ascii"<BR><BR>Hi Saber <BR><BR><BR><BR>Thanks for the suggestion. When I run ogrinfo -formats I see that MySQL is<BR>included, so that is not the problem.<BR><BR>It seems that the issue is about the way that I created and store the line<BR>data, because I have tried with some point data and I don't have this<BR>problem - I can create, save, and display points with QGIS and then both OGR<BR>and MapServer are OK. But with line data it is different.<BR><BR><BR><BR>I can only assume that QGIS is
sending the line data to MySQL in a format<BR>that QGIS recognises when the data is retrieved, but which is not recognised<BR>by OGR / MapServer.<BR><BR><BR><BR>Going to PostGIS would have to be a last resort, I have a lot of effort<BR>invested in MySQL ..<BR><BR><BR><BR><BR><BR><BR><BR>Chris <BR><BR><BR><BR>From: Saber Razmjooei [mailto:<A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=razmjooeis@faunalia.co.uk" ymailto="mailto:razmjooeis@faunalia.co.uk">razmjooeis@faunalia.co.uk</A>] <BR>Sent: 27 July 2011 09:35<BR>To: Chris Green<BR>Cc: <A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=qgis-user@lists.osgeo.org" ymailto="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</A><BR>Subject: Re: [Qgis-user] QGIS -> MySQL -> Mapserver ??<BR><BR><BR><BR>Chris<BR><BR>I presume your ogr can handle mysql if you can open it in QGIS. But to<BR>confirm could you run:<BR><BR>ogrinfo --formats<BR><BR><BR><BR><BR>from terminal and check if
you have <BR><BR>-> "MSSQLSpatial" (read/write)<BR><BR>Is your database large? Have you considered using PostGIS?<BR><BR>Cheers<BR>Saber<BR><BR><BR>On 27/07/11 07:45, Chris Green wrote: <BR><BR><BR><BR>Hi QGIS users<BR><BR><BR><BR>I have a problem getting Mapserver to display vector line features which I<BR>created with QGIS and saved as spatial objects in MySQL...I asked for some<BR>advice on this from the Mapserver forum yesterday but had no responses,<BR>perhaps someone in this forum has some experience to offer?<BR><BR><BR><BR>As explained in the question below, I can create line features in QGIS, save<BR>them in a MySQL table, and recall and display them with QGIS without any<BR>problem. But the same features do not appear to be recognised by OGRInfo or<BR>by Mapserver. The line features are saved as BLOB data in a MySQL MyISAM<BR>table in a column which is defined as type 'geometry'. MySQL can create a<BR>spatial index of these
features.<BR><BR><BR><BR>The table is accessed by QGIS as a database layer via the 'Add Vector Layer'<BR>dialogue. I am using QGIS 1.7. <BR><BR><BR><BR>It's not really a QGIS problem, but I spent all day wrestling with this<BR>yesterday but have not solved it. Any suggestions?<BR><BR><BR><BR><BR><BR><BR><BR>Chris<BR><BR><BR><BR>############################################################################<BR>### <BR><BR><BR><BR><BR><BR>I'm having some trouble with an OGR connection to a MySQL database. The data<BR>I'm trying to access was created using QGIS as a line layer and saved in a<BR>MySQL table as a BLOB in a geometry column. I can access and properly<BR>display this line data using QGIS, but not so far via Mapserver - nothing is<BR>drawn and I can't see any error.<BR><BR><BR><BR>I am using Mapserver 6.0 and my mapfile is very similar to the example in<BR>theMapserver / MYSQL
documentation:<BR><BR><BR><BR>LAYER<BR><BR> NAME "testLine" <BR><BR> TYPE LINE<BR><BR> STATUS DEFAULT<BR><BR> CONNECTIONTYPE OGR<BR><BR> CONNECTION "mysql:testDB,user=admin,password=password,port=3306" <BR><BR> DATA "SELECT Geometry from testLine"<BR><BR> CLASS<BR><BR> STYLE <BR><BR> COLOR 0 0 0<BR><BR> WIDTH 2 <BR><BR> END # style<BR><BR> END # class<BR><BR>END #
layer<BR><BR><BR><BR><BR><BR><BR><BR>If I look at the MySQL table using OGRinfo I see the following:<BR><BR><BR><BR>Layer name: testLine<BR><BR>Geometry: Unknown (any)<BR><BR>Feature Count: 0<BR><BR>Layer SRS WKT: <BR><BR>(unknown)<BR><BR>FID Coumn = id<BR><BR>Geometry Column = Geometry<BR><BR><BR><BR><BR><BR>The issue seems to be that OGRInfo and therefore MapServer does not<BR>recognise any features in the table, but QGIS using access to the same table<BR>finds and displays the features.<BR><BR><BR><BR><BR><BR>Anyone have any ideas what I am doing wrong?<BR><BR><BR><BR><BR><BR>Chris<BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR>_______________________________________________<BR>Qgis-user mailing list<BR><A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=Qgis-user@lists.osgeo.org" ymailto="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</A><BR><A href="http://lists.osgeo.org/mailman/listinfo/qgis-user"
target=_blank>http://lists.osgeo.org/mailman/listinfo/qgis-user</A><BR><BR><BR><BR>-------------- next part --------------<BR>An HTML attachment was scrubbed...<BR>URL: <A href="http://lists.osgeo.org/pipermail/qgis-user/attachments/20110727/414a5aee/attachment-0001.html" target=_blank>http://lists.osgeo.org/pipermail/qgis-user/attachments/20110727/414a5aee/attachment-0001.html</A><BR><BR>------------------------------<BR><BR>Message: 3<BR>Date: Wed, 27 Jul 2011 10:55:20 +0100<BR>From: Saber <<A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=razmjooeis@faunalia.co.uk" ymailto="mailto:razmjooeis@faunalia.co.uk">razmjooeis@faunalia.co.uk</A>><BR>Subject: RE: [Qgis-user] QGIS -> MySQL -> Mapserver ??<BR>To: Chris Green <<A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=chris.green@ibstv.co.uk" ymailto="mailto:chris.green@ibstv.co.uk">chris.green@ibstv.co.uk</A>><BR>Cc: <A
href="http://us.mc1147.mail.yahoo.com/mc/compose?to=qgis-user@lists.osgeo.org" ymailto="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</A><BR>Message-ID: <<A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=05cdp715sy1xrat8ywciguee.1311760349356@email.android.com" ymailto="mailto:05cdp715sy1xrat8ywciguee.1311760349356@email.android.com">05cdp715sy1xrat8ywciguee.1311760349356@email.android.com</A>><BR>Content-Type: text/plain; charset=utf-8<BR><BR>As a test, worth converting the mysql vector to shapefile to see if the vector is shown properly.<BR><BR>Also checking webserver logs report for mapsever requests of the MySQL vector might help.<BR><BR>Chris Green <<A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=chris.green@ibstv.co.uk" ymailto="mailto:chris.green@ibstv.co.uk">chris.green@ibstv.co.uk</A>> wrote:<BR><BR>>Hi Saber <BR>><BR>> <BR>><BR>>Thanks for the suggestion. When I run ogrinfo -formats I see
that MySQL is<BR>>included, so that is not the problem.<BR>><BR>>It seems that the issue is about the way that I created and store the line<BR>>data, because I have tried with some point data and I don't have this<BR>>problem - I can create, save, and display points with QGIS and then both OGR<BR>>and MapServer are OK. But with line data it is different.<BR>><BR>> <BR>><BR>>I can only assume that QGIS is sending the line data to MySQL in a format<BR>>that QGIS recognises when the data is retrieved, but which is not recognised<BR>>by OGR / MapServer.<BR>><BR>> <BR>><BR>>Going to PostGIS would have to be a last resort, I have a lot of effort<BR>>invested in MySQL ..<BR>><BR>> <BR>><BR>> <BR>><BR>> <BR>><BR>>Chris <BR>><BR>> <BR>><BR>>From: Saber Razmjooei [mailto:<A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=razmjooeis@faunalia.co.uk"
ymailto="mailto:razmjooeis@faunalia.co.uk">razmjooeis@faunalia.co.uk</A>] <BR>>Sent: 27 July 2011 09:35<BR>>To: Chris Green<BR>>Cc: <A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=qgis-user@lists.osgeo.org" ymailto="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</A><BR>>Subject: Re: [Qgis-user] QGIS -> MySQL -> Mapserver ??<BR>><BR>> <BR>><BR>>Chris<BR>><BR>>I presume your ogr can handle mysql if you can open it in QGIS. But to<BR>>confirm could you run:<BR>><BR>>ogrinfo --formats<BR>> <BR>> <BR>> <BR>><BR>>from terminal and check if you have <BR>><BR>>-> "MSSQLSpatial" (read/write)<BR>><BR>>Is your database large? Have you considered using PostGIS?<BR>><BR>>Cheers<BR>>Saber<BR>><BR>><BR>>On 27/07/11 07:45, Chris Green wrote: <BR>><BR>> <BR>> <BR>>Hi QGIS users<BR>> <BR>> <BR>> <BR>>I have a problem getting Mapserver
to display vector line features which I<BR>>created with QGIS and saved as spatial objects in MySQL...I asked for some<BR>>advice on this from the Mapserver forum yesterday but had no responses,<BR>>perhaps someone in this forum has some experience to offer?<BR>> <BR>> <BR>> <BR>>As explained in the question below, I can create line features in QGIS, save<BR>>them in a MySQL table, and recall and display them with QGIS without any<BR>>problem. But the same features do not appear to be recognised by OGRInfo or<BR>>by Mapserver. The line features are saved as BLOB data in a MySQL MyISAM<BR>>table in a column which is defined as type 'geometry'. MySQL can create a<BR>>spatial index of these features.<BR>> <BR>> <BR>> <BR>>The table is accessed by QGIS as a database layer via the 'Add Vector Layer'<BR>>dialogue. I am using QGIS 1.7. <BR>> <BR>> <BR>> <BR>>It's not really a QGIS
problem, but I spent all day wrestling with this<BR>>yesterday but have not solved it. Any suggestions?<BR>> <BR>> <BR>> <BR>> <BR>> <BR>> <BR>> <BR>>Chris<BR>> <BR>> <BR>> <BR>>############################################################################<BR>>### <BR>> <BR>> <BR>> <BR>> <BR>> <BR>>I'm having some trouble with an OGR connection to a MySQL database. The data<BR>>I'm trying to access was created using QGIS as a line layer and saved in a<BR>>MySQL table as a BLOB in a geometry column. I can access and properly<BR>>display this line data using QGIS, but not so far via Mapserver - nothing is<BR>>drawn and I can't see any error.<BR>> <BR>> <BR>> <BR>>I am using Mapserver 6.0 and my mapfile is very similar to the example in<BR>>theMapserver / MYSQL documentation:<BR>> <BR>> <BR>> <BR>>LAYER<BR>> <BR>>
NAME "testLine" <BR>> <BR>> TYPE LINE<BR>> <BR>> STATUS DEFAULT<BR>> <BR>> CONNECTIONTYPE OGR<BR>> <BR>> CONNECTION "mysql:testDB,user=admin,password=password,port=3306" <BR>> <BR>> DATA "SELECT Geometry from testLine"<BR>> <BR>> CLASS<BR>> <BR>> STYLE <BR>> <BR>> COLOR 0 0 0<BR>> <BR>> WIDTH 2 <BR>> <BR>> END # style<BR>> <BR>>
END # class<BR>> <BR>>END # layer<BR>> <BR>> <BR>> <BR>> <BR>> <BR>> <BR>> <BR>>If I look at the MySQL table using OGRinfo I see the following:<BR>> <BR>> <BR>> <BR>>Layer name: testLine<BR>> <BR>>Geometry: Unknown (any)<BR>> <BR>>Feature Count: 0<BR>> <BR>>Layer SRS WKT: <BR>> <BR>>(unknown)<BR>> <BR>>FID Coumn = id<BR>> <BR>>Geometry Column = Geometry<BR>> <BR>> <BR>> <BR>> <BR>> <BR>>The issue seems to be that OGRInfo and therefore MapServer does not<BR>>recognise any features in the table, but QGIS using access to the same table<BR>>finds and displays the features.<BR>> <BR>> <BR>> <BR>> <BR>> <BR>>Anyone have any ideas what I am doing wrong?<BR>> <BR>> <BR>> <BR>> <BR>> <BR>>Chris<BR>> <BR>> <BR>> <BR>> <BR>> <BR>> <BR>> <BR>> <BR>> <BR>> <BR>> <BR>>
<BR>>_______________________________________________<BR>>Qgis-user mailing list<BR>><A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=Qgis-user@lists.osgeo.org" ymailto="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</A><BR>><A href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target=_blank>http://lists.osgeo.org/mailman/listinfo/qgis-user</A><BR>><BR>> <BR>><BR><BR>------------------------------<BR><BR>Message: 4<BR>Date: Wed, 27 Jul 2011 14:09:39 +0400<BR>From: Maxim Dubinin <<A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=sim@gis-lab.info" ymailto="mailto:sim@gis-lab.info">sim@gis-lab.info</A>><BR>Subject: [Qgis-user] DTclassifier is released<BR>To: <A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=qgis-developer@lists.osgeo.org" ymailto="mailto:qgis-developer@lists.osgeo.org">qgis-developer@lists.osgeo.org</A><BR>Cc: <A
href="http://us.mc1147.mail.yahoo.com/mc/compose?to=qgis-user@lists.osgeo.org" ymailto="mailto:qgis-user@lists.osgeo.org">qgis-user@lists.osgeo.org</A><BR>Message-ID: <<A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=77239752.20110727140939@gis-lab.info" ymailto="mailto:77239752.20110727140939@gis-lab.info">77239752.20110727140939@gis-lab.info</A>><BR>Content-Type: text/plain; charset=us-ascii<BR><BR>Hi all,<BR><BR>To follow up on our demonstration in Lisbon.<BR><BR>We are happy to release our new plugin for streamlined remote sensing<BR>data classification in QGIS [0]. Initially the plugin was<BR>developed to provide easy to use tool to monitor forest cover<BR>change, but it can be used to classify any type of targets.<BR><BR>Main features:<BR>- all-in-one, with this plugin only QGIS is needed for all
steps of<BR>classification;<BR>- decision trees, the plugin is using computer vision library OpenCV to<BR>implement modern classification algorithm typically not available in<BR>other software packages (both OS and proprietory);<BR>- performance, another nice feature of OpenCV is that it is<BR>very fast;<BR>- multiple input rasters and multiple training layers;<BR><BR>Description, examples and sample data:<BR>EN: <A href="http://gis-lab.info/qa/dtclassifier-eng.html" target=_blank>http://gis-lab.info/qa/dtclassifier-eng.html</A><BR>RU: <A href="http://gis-lab.info/qa/dtclassifier.html" target=_blank>http://gis-lab.info/qa/dtclassifier.html</A><BR><BR>Right now the windows binaries and source code are available.<BR><BR>---------<BR>Maxim<BR><BR>[0] <A href="http://www.nextgis.ru/projects/dtclassifier"
target=_blank>http://www.nextgis.ru/projects/dtclassifier</A><BR><BR><BR><BR>------------------------------<BR><BR>_______________________________________________<BR>Qgis-user mailing list<BR><A href="http://us.mc1147.mail.yahoo.com/mc/compose?to=Qgis-user@lists.osgeo.org" ymailto="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</A><BR><A href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target=_blank>http://lists.osgeo.org/mailman/listinfo/qgis-user</A><BR><BR><BR>End of Qgis-user Digest, Vol 65, Issue 61<BR>*****************************************<BR></DIV></BLOCKQUOTE></td></tr></table>