<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="GENERATOR" content="MSHTML 8.00.6001.19088">
</head>
<body>
<div><font size="2" face="Arial"><span class="726285806-30082011">Hi,</span></font></div>
<div><font size="2" face="Arial"><span class="726285806-30082011"></span></font> </div>
<div><font size="2" face="Arial"><span class="726285806-30082011">I am trying to classify a Spatialite layer but if I select the VARCHAR type attribute to be used for classification and press the Classify button in Layer Properties - Style dialog the value
list does not appear. I can classify the layer manually by creating classes with Add class button and writing the values by hand. If I convert the Spatialite layer into shapefile and use that in QGIS then the automatic classification works. I used ogr2ogr
for conversion as </span></font></div>
<div><font size="2" face="Arial"><span class="726285806-30082011">> ogr2ogr -f "ESRI Shapefile" -sql "select * from osm_line where highway in not null" highways.shp berlin.sqlite</span></font></div>
<div><font size="2" face="Arial"><span class="726285806-30082011"></span></font> </div>
<div><font size="2" face="Arial"><span class="726285806-30082011">I am using QGIS 1.8.0-Trunk r339d800 installed with Osgeo4W on Windows XP. My test database can be downloaded from
<a href="http://188.64.1.61/tiedostot/berlin_2011_08_25.zip">http://188.64.1.61/tiedostot/berlin_2011_08_25.zip</a>. Database contains OpenStreerMap data of Berlin converted first into PostGIS with osm2pgsql and then to Spatialite with ogr2ogr. The QGIS layer
I was trying to classify is the osm_line layer filtered with sql="highway" NOT null. Classification method is Unique value with the old symbology and Categorized with the new symbology. Neither of them show me the attribute value list.</span></font></div>
<div><font size="2" face="Arial"><span class="726285806-30082011"></span></font> </div>
<div><font size="2" face="Arial"><span class="726285806-30082011">Regards,</span></font></div>
<div><font size="2" face="Arial"><span class="726285806-30082011"></span></font> </div>
<div><font size="2" face="Arial"><span class="726285806-30082011">-Jukka Rahkonen-</span></font></div>
</body>
</html>