Hi people, I have set up PostGIS on my server and i am able access the GIS layers posted on it using the hostname : localhost on the server itself. However when i try to access the PostGIS layer from another computer using the hostname : GIS-SERVER (Server name on our network) it can't access. A popup menu ask for credentials with an error message can not translate host name.
Any help would be much appreciated. Thanks, Nome On Wed, Jul 27, 2011 at 9:24 AM, <[email protected]> wrote: > 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: KML to GoogleEarth (percy langa) > 2. RE: QGIS -> MySQL -> Mapserver ?? (Chris Green) > 3. RE: QGIS -> MySQL -> Mapserver ?? (Saber Razmjooei) > 4. Deleting a column from attribute table (adamu eloji) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 27 Jul 2011 15:46:11 +0200 > From: percy langa <[email protected]> > Subject: Re: [Qgis-user] KML to GoogleEarth > To: [email protected] > Cc: [email protected], Walter Ludwick <[email protected]> > Message-ID: > <CAF3hcU58ySkP=lvgloumqbftho9tlpuzrasjcq-f6ffrgic...@mail.gmail.com> > Content-Type: text/plain; charset="iso-8859-1" > > Works for me >> Qgis 1.6 >> CRS: WGS84, EPSG:4326, 3452 > > Also try saving to GPS exchange format, then open in google earth. > > Cheers! > Percy > > On Wed, Jul 27, 2011 at 3:07 PM, Giovanni Manghi > <[email protected]>wrote: > >> Tha probably your shapefile is missing the .prj file, so when you load >> it into QGIS it will probably be given the wrong CRS. Change it manually >> then try again "save as..." and export in WGS84. >> >> cheers >> >> -- Giovanni -- >> >> On Wed, 2011-07-27 at 13:13 +0100, Walter Ludwick wrote: >> > Hey, Saber: Thanks for the quick reply and explicit instructions. >> > >> > It was easy to do, i gave it a try -but still the same condition results, >> alas (i.e. the KML saved, even using that WGS84 as CRS, is interpreted by >> Google Earth as a set of polygons that covers the entire globe). >> > >> > I'm going to keep flailing, trying whatever other CRS seems likely, but >> if there be any further ideas of things i might try, please don't hesitate >> to suggest! >> > >> > /w >> > >> > >> > On Jul 27, 2011, at 12:29 PM, Saber Razmjooei wrote: >> > >> > > The CRS you need is EPSG:4326 >> > > To find it easily, in search section change Authority to EPSG and >> search >> > > for ID. >> > > Type 4326 and highlight the line from Coordinate Reference System: >> > > WGS84 EPSG:4326 3452 >> > > Click OK. >> > > >> > > >> > > >> > >> As a complete n00b to this list -also very new to QGIS and GIS in >> general- >> > >> i am having a problem that is i hope trivial to solve, for one of you >> with >> > >> more experience! >> > >> >> > >> Essentially: to take a (vector) layer from QGIS and "save as..." KML, >> if i >> > >> pass that dialog with defaults selected, i get a .KML file that >> doesn't >> > >> make much sense to Google Earth -that is to say, Google Earth can read >> and >> > >> will display the polygons, perhaps even in the right shape, tho i >> cannot >> > >> be sure about that, because they display as lines that pretty much >> cover >> > >> the entire globe! >> > >> >> > >> The one thing i can see that i think might be related to this problem >> is, >> > >> the CRS (Co-ordinate Reference System) parameter, which appears in the >> > >> "Save as..." dialog box with "Original CRS" as the default >> parameter... >> > >> but then when i push the "browse" button, i am faced with an immense >> > >> number of possibilities from which to choose, about which i have no >> idea. >> > >> >> > >> Can anyone shed some light, and perhaps suggest a CRS that just might >> > >> work? The geography i am trying to describe is in coastal Portugal, if >> > >> that makes any difference... /w >> > >> >> > >> >> > >> _______________________________________________ >> > >> 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 >> >> >> _______________________________________________ >> 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/d7dd885f/attachment-0001.html > > ------------------------------ > > Message: 2 > Date: Wed, 27 Jul 2011 14:50:37 +0100 > From: "Chris Green" <[email protected]> > Subject: RE: [Qgis-user] QGIS -> MySQL -> Mapserver ?? > To: "'Saber Razmjooei'" <[email protected]> > Cc: [email protected] > Message-ID: <039301cc4c64$31fc9860$95f5c920$@[email protected]> > Content-Type: text/plain; charset="us-ascii" > > Saber > > Ogrinfo -summary on the MySQL table as saved by QGIS says: > > Layer name: geom_test > Geometry: Unknown (any) > Feature Count: 0 > Layer SRS WKT: > (unknown) > FID Column = id > Geometry Column = Geometry > > > Ogrinfo -summary on the table after running SELECT AsWKB(Geometry) says: > > Layer name: geom_test_converted > Geometry: Unknown (any) > Feature Count: 34 > Layer SRS WKT: > (unknown) > FID Column = id > Geometry Column = Geometry > > There is no projection in the layer, QGIS seems to assume that it is lat/lon > and then reprojects it to 900913, which is what I am using overall. > > Maybe the lack of projection in the data is confusing OGR....but I'm not > sure that if I apply projection to the layer via QGIS, it will get saved as > part of the MySQL data?? > > > Chris > > > > -----Original Message----- > From: Saber Razmjooei [mailto:[email protected]] > Sent: 27 July 2011 14:04 > To: Chris Green > Cc: [email protected] > Subject: RE: [Qgis-user] QGIS -> MySQL -> Mapserver ?? > > What does ogrinfo -al say about your geometry? Are those numbers located > in the right place? Just to make sure your layer projection is set > properly. > > >> Hi Saber >> >> I tried that, and the when the MySQL data is saved as an ESRI shapefile >> the shapefile opens correctly. >> >> I have been experimenting with converting the MySQL BLOB data. For example >> if I try >> >> SELECT AsText(Geometry) I get a line string which looks OK and could be >> used to create a line feature in MapServer using PHP Mapscript. Then when >> I try: >> >> SELECT AsWKB(Geometry) I get a new set of BLOBs which can be recognised by >> OGRinfo as features (progress!!!) but still not displayed by MapServer. >> >> My conclusion is that QGIS is using some internal format to store MySQL >> linestrings which is not properly understood by OGR. >> >> Any idea where I could find out any more on this? >> >> >> Chris >> >> >> >> -----Original Message----- >> From: Saber [mailto:[email protected]] >> Sent: 27 July 2011 10:55 >> To: Chris Green >> Cc: [email protected] >> Subject: RE: [Qgis-user] QGIS -> MySQL -> Mapserver ?? >> >> 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: 3 > Date: Wed, 27 Jul 2011 15:03:32 +0100 > From: "Saber Razmjooei" <[email protected]> > Subject: RE: [Qgis-user] QGIS -> MySQL -> Mapserver ?? > To: "Chris Green" <[email protected]> > Cc: [email protected] > Message-ID: > > <8f1479b5016f16ec694cce8d304c9e5e.squir...@www.webmail.lutraconsulting.co.uk> > > Content-Type: text/plain;charset=iso-8859-1 > > Chris > Have you checked this: > > 18.4.2.1. Creating Geometry Values Using WKT Functions > http://www.qijoo.com/FAPM/mysql/5.1/MySQL_51_en/ch18s04.html > > You can optionally use SRID in your query. > I am a bit out of my depth now as I have never used mysql spatial. > > > Hope that helps > Saber > > >> Saber >> >> Ogrinfo -summary on the MySQL table as saved by QGIS says: >> >> Layer name: geom_test >> Geometry: Unknown (any) >> Feature Count: 0 >> Layer SRS WKT: >> (unknown) >> FID Column = id >> Geometry Column = Geometry >> >> >> Ogrinfo -summary on the table after running SELECT AsWKB(Geometry) says: >> >> Layer name: geom_test_converted >> Geometry: Unknown (any) >> Feature Count: 34 >> Layer SRS WKT: >> (unknown) >> FID Column = id >> Geometry Column = Geometry >> >> There is no projection in the layer, QGIS seems to assume that it is >> lat/lon >> and then reprojects it to 900913, which is what I am using overall. >> >> Maybe the lack of projection in the data is confusing OGR....but I'm not >> sure that if I apply projection to the layer via QGIS, it will get saved >> as >> part of the MySQL data?? >> >> >> Chris >> >> >> >> -----Original Message----- >> From: Saber Razmjooei [mailto:[email protected]] >> Sent: 27 July 2011 14:04 >> To: Chris Green >> Cc: [email protected] >> Subject: RE: [Qgis-user] QGIS -> MySQL -> Mapserver ?? >> >> What does ogrinfo -al say about your geometry? Are those numbers located >> in the right place? Just to make sure your layer projection is set >> properly. >> >> >>> Hi Saber >>> >>> I tried that, and the when the MySQL data is saved as an ESRI shapefile >>> the shapefile opens correctly. >>> >>> I have been experimenting with converting the MySQL BLOB data. For >>> example >>> if I try >>> >>> SELECT AsText(Geometry) I get a line string which looks OK and could be >>> used to create a line feature in MapServer using PHP Mapscript. Then >>> when >>> I try: >>> >>> SELECT AsWKB(Geometry) I get a new set of BLOBs which can be recognised >>> by >>> OGRinfo as features (progress!!!) but still not displayed by MapServer. >>> >>> My conclusion is that QGIS is using some internal format to store MySQL >>> linestrings which is not properly understood by OGR. >>> >>> Any idea where I could find out any more on this? >>> >>> >>> Chris >>> >>> >>> >>> -----Original Message----- >>> From: Saber [mailto:[email protected]] >>> Sent: 27 July 2011 10:55 >>> To: Chris Green >>> Cc: [email protected] >>> Subject: RE: [Qgis-user] QGIS -> MySQL -> Mapserver ?? >>> >>> 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 08:19:23 -0700 (PDT) > From: adamu eloji <[email protected]> > Subject: [Qgis-user] Deleting a column from attribute table > To: [email protected] > Message-ID: > <[email protected]> > Content-Type: text/plain; charset="iso-8859-1" > > > > 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 > ***************************************** > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: > http://lists.osgeo.org/pipermail/qgis-user/attachments/20110727/2d5a5976/attachment.html > > ------------------------------ > > _______________________________________________ > Qgis-user mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/qgis-user > > > End of Qgis-user Digest, Vol 65, Issue 64 > ***************************************** > _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
