[Qgis-developer] Re: Built-in functions in Spatialite is not working in Spatialite Manager and Custom Query plugin.

[Ricardo Filipe Soares Garcia da]

Hi Noli

I can run your query in both plugins without any problem.
Maybe the real problem lies elsewhere.

I have been using using ubuntu almost exclusively lately, with
packages from the ubuntugis repository. So I really haven't had a
chance to test these things out on diferent OS/software versions. I
was expecting everything to work OK though.

What are your system specs?
Do you have the pyspatialite python module installed?

Can anyone else reproduce Noli's error?


On Fri, Dec 17, 2010 at 11:08 AM, Noli Sicad <nsicad at gmail.com> wrote:
> Hi,
>
> It seems that Built-in functions in Spatialite is not working in
> Spatialite Manager and Custom Query plugin.
>
> This query (below) is working in spatialite. However not in Spatialite
> Manager and Custom query plugin. See the results in spatialite
> terminal result.
>
> Select PK_UID, Area(Geometry) as Area, Glength(Geometry) as Perimeter
> from Regions where Name = 'VENETO';
>
>
> spatialite> Select PK_UID, Area(Geometry) as Area, Glength(Geometry)
> as Perimeter from Regions where Name = 'VENETO';
> 1|646397.805154562|3767.27751498312
> 2|1290337.68600099|6293.47638232552
> 3|8784619.91935909|26500.3924111861
> 4|530524.678980947|3393.68314026964
> 12|438895.715023518|3113.64992438381
> 13|1080844.97356853|4257.52369736528
> 27|631684.999314845|3312.26243379054
> 28|697028.860538453|3883.34841424143
> 29|1643348.74578464|7902.1272961186
> 30|2059950.71955425|9280.26957054055
> 31|3475156.56185258|8530.46975877753
> 32|2837714.23986262|11833.608036565
> 33|760252.960525573|3456.43315003721
> 34|3548959.66717082|10910.225574648
> 35|633458.679342464|3350.58352770575
> 36|732165.134682328|4345.32619131389
> 37|663225.180475533|3885.78466328978
> 38|918705.089251876|4344.70107002211
> 39|552058.274254918|4035.57280567915
> 40|1054773.22809702|5408.63784325175
> 41|1330499.79153974|6117.34545132715
> 42|1400447.12052478|6740.60779784617
> 43|464557.224632263|3508.45482974964
> 44|723247.97768569|3599.45282522162
> 45|651748.85301292|3801.78008569203
> 46|548118.492645741|3712.45734461941
> 47|488050.567765743|3177.6569314083
> 48|752451.875753649|3537.1586256791
> 49|6069461.72734681|23020.9974671427
> 50|9739.59230065346|719.590296605301
> 108|18045728269.4635|1202815.64345084
> spatialite>
>
> Thanks.
>
> Noli
>



-- 
___________________________ ___ __
Ricardo Garcia Silva