Re: [Qgis-user] shp*join*csv real2string problem

2012-12-09 Thread magerlin
Hi It's pretty simple - if you just know it To define how Myfile.csv is read make a Myfile.csvt file (I guess the extra t means Template) and put it in the same folder as the csv file. It is a simple one line text file with one entry for every column in your csv file telling Qgis how to

Re: [Qgis-user] shp*join*csv real2string problem

2012-12-09 Thread Bernd Vogelgesang
Am 08.12.2012, 20:02 Uhr, schrieb Jürgen E. Fischer j...@norbit.de: Hi Bernd, On Sat, 08. Dec 2012 at 17:12:16 +0100, Bernd Vogelgesang wrote: Seems the excel import is version and/or platform dependent: In dev under linux mint, it doesn't work at all. Drag and drop produces blabla.xls is

[Qgis-user] Problem with qgis-web-client configuration

2012-12-09 Thread Otto Dassau
Hi, I installed qgis server version 1.8 using ubuntu precise. The WMS and WFS work, if I add them to QGIS. Now I would like to play with the qgis-web-client. I can see the web-client but the test maps Hello and Country are loading and loading ... but are not visible. I guess I missed something

Re: [Qgis-user] Problem with qgis-web-client configuration

2012-12-09 Thread Salvatore Larosa
Hi Otto, 2012/12/9 Otto Dassau das...@gbd-consult.de Hi, I installed qgis server version 1.8 using ubuntu precise. The WMS and WFS work, if I add them to QGIS. Now I would like to play with the qgis-web-client. I can see the web-client but the test maps Hello and Country are loading and

Re: [Qgis-user] Problem with qgis-web-client configuration

2012-12-09 Thread Salvatore Larosa
Hi, 2012/12/9 Otto Dassau das...@gbd-consult.de Hi Salvatore, Am Sun, 9 Dec 2012 16:13:07 +0100 schrieb Salvatore Larosa lrssv...@gmail.com: Hi Otto, 2012/12/9 Otto Dassau das...@gbd-consult.de Hi, I installed qgis server version 1.8 using ubuntu precise. The WMS and WFS

Re: [Qgis-user] Problem with qgis-web-client configuration

2012-12-09 Thread Andreas Neumann
Hi Otto, In the next upcoming weeks we will increasingly use the options in GetProjectSettings - which wouldn't work with GetCapabilities alone. Right now it doesn't make much difference, but it will in the future - esp. for metadata display or initial visible layers. Also, if you want to use

Re: [Qgis-user] Problem with qgis-web-client configuration

2012-12-09 Thread Otto Dassau
Hi Andreas, thanks, I added a small note to the repo, that useGetProjectSettings should be set to false for QGIS server versions = 1.8. Regards Otto Am Sun, 09 Dec 2012 17:13:52 +0100 schrieb Andreas Neumann a.neum...@carto.net: Hi Otto, In the next upcoming weeks we will increasingly use

[Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Donovan Cameron
I created a sqlite/spatialite db from the spatialite_gui and started to import a bunch of shapefiles. Some of the things I set were the CRS to EPSG:3005 BC Albers and the_geom as the name for the geometry field (type is set to auto...) Then in spatialite_gui I expanded each new table and built a

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Donovan Cameron
Not sure if it's helpful, but here is a list of installed spatialite/sqlite packages. I noticed there is two packages called libspatialite2 and sqlite2, are those causing conflicts or something? It looks like libspatialite2 is a (System Package) meaning it was installed during initial OS

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Donovan Cameron
Thanks alex, that's definitely helpful. I tried to install pyspatialite with easy_install and it tries to grab Best match: pyspatialite 3.0.1 which fails with a lot of errors... I can run through the tutorials from the spatialite page and this is the initial output, telling me I am using

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Donovan Cameron
Forgot to mention that tutorial link for reference: http://www.gaia-gis.it/gaia-sins/spatialite-tutorial-2.3.1.html#t3 On Sun, Dec 9, 2012 at 12:11 PM, Donovan Cameron sault@gmail.comwrote: Thanks alex, that's definitely helpful. I tried to install pyspatialite with easy_install and it

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Alex Mandel
The plugin requires pyspatialite but QGIS itself has the provider built in. SpatiaLite version ..: 4.0.0 Grab an older version of the Spatialite GUI (1.4 or 1.5) or figure out how to convert your db to the 3.x variant (I believe the release notes mention this is possible). The metadata table

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Donovan Cameron
I guess that confirms it then Alex. The QGIS 'about' window even says I have spatialite 4.0.0 installed. QGIS version 1.8.0-Lisboa QGIS code revision exported Compiled against Qt 4.8.1 Running against Qt 4.8.1 Compiled against GDAL/OGR 1.9.2 Running against GDAL/OGR 1.9.2 GEOS Version 3.3.6

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Donovan Cameron
I've been browsing the spec files for the qgis and spatialite packages from the GEO openSUSE repo. QGIS isn't actually requiring spatialite, like you said, it's built in. It's actually part of the requirements for spatialite-gui which explains why your suggestion of downgrading that package

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Donovan Cameron
As Alex suggested, converting to a v3 spatialite db was easy with the spatialite_convert tool. It's described on this page: https://www.gaia-gis.it/fossil/libspatialite/wiki?name=switching-to-4.0 And the command I issued was: cp spatialite.sqlite spatialite_v3.sqlite spatialite_convert -d

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Andre Joost
Am 09.12.2012 20:16, schrieb Alex Mandel: The plugin requires pyspatialite but QGIS itself has the provider built in. SpatiaLite version ..: 4.0.0 Grab an older version of the Spatialite GUI (1.4 or 1.5) or figure out how to convert your db to the 3.x variant (I believe the release notes

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Angelos Tzotsos
Hi Donovan, Yes, we upgraded spatialite to 4.0 a few days ago. I will talk with other maintainers on how to solve this issue. Having 2 versions of spatialite will probably make things worse, since many libraries compile against it. We would need to make a selection I am afraid. I am wondering

Re: [Qgis-user] Cannot add sqlite/spatialite layers to qgis (they come in as tables)

2012-12-09 Thread Micha Silver
The 4.0 version should come with a utility, spatialite_convert, to downgrade a database to be version 3.0 compatible. Worth a try. -- Micha Silver 052-366-5918 -Original message- From: Donovan Cameron sault@gmail.com To: qgis-user@lists.osgeo.org Sent: Sun, 09 Dec 2012, 21:23:11

[Qgis-user] Strange integer column value within SpatiaLite database

2012-12-09 Thread Pedro Venâncio
Hi, I found something strange with data in a table within a SpatiaLite database. As you can see in this image [1], viewing the table in QSpatiaLite, the column GEO_COD (integer) appears well. The same column, when viewed in the QGIS attribute table, appears with values ​totally different. Can