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