SmartRoadSense CSV

[Roberto Angeletti]

Hello,

I am trying to load SmartRoadSense CSV open data in SpatiaLlite:

http://smartroadsense.it/data/srs_data.zip

I would like to load them as "Virtual CSV", but SpatiaLite returns an error.

Instead, it is loaded correctly, using the standard CSV loader.

Somebody can help me to understand where I wrong ?

Thank you

Roberto

[a.fu...@lqt.it]

On Mon, 27 Apr 2015 10:04:19 +0200, Roberto Angeletti wrote:
> Hello,
>
> I am trying to load SmartRoadSense CSV open data in SpatiaLlite:
>

> http://smartroadsense.it/data/srs_data.zip [1]

>
> I would like to load them as "Virtual CSV", but SpatiaLite returns an
> error.
>
> Instead, it is loaded correctly, using the standard CSV loader.
>
> Somebody can help me to understand where I wrong ?
>

Hi Robero,

you are probably passing some wrong/inappropriate argument
while creating the VirtualText table.
I was able to create a perfectly working VirtualText
table following this approach:

after a quick visual inspection of the CSV file I've
verified that:
- it contains column names into the very first row;
and these names are enclosed within double quotes (")
- comma is used as the separator between values (,)
- the decimal separator is point (.)

using the GUI tool this layout matches the settings you
can see in the attached figure.
if you wish better to manually create the VirtualText
table this one is the appropriate SQL statement:

CREATE VIRTUAL TABLE srs_data USING VirtualText(
'srs_data.csv', 'CP1252', 1, POINT, DOUBLEQUOTE, ',');

bye Sandro