[uMap] UMAP and CSV delimiter

[Fabrizio Carrai]

SOLVED. The solution was not in the URL format, but in a query of one layer:

SELECT * WHERE L = ''

That was producing the error message on the delimiter.

Thanks for the support received!

---
Fabrizio






2017-08-05 15:31 GMT+02:00 Fabrizio Carrai <fabrizio.carrai at gmail.com>:

> You examples is good, so I would follow it. My map has four layers each
> accessing the Google sheet using a URL query. Here is one of the four:
>
> https://spreadsheets.google.com/tq?tqx=out:csv&key=1QWF87P6FsllTp2_NMG_
> eRmsJo6aUCB5Sxccf2zlYQUE&tq=select%20*%20where%20L%20like%
> 20%27Direct%25%27
>
> How can I add the query "SELECT * WHERE L LIKE 'Direct%' to your working
> example ?
>
> https://docs.google.com/spreadsheets/d/1s4pe1Gb3_LIQXOu_ikNx
> Eg0iOCJuwYWlPBLtLk2RAvQ/pub?gid=0&single=true&output=csv
>
> I found this [1] but I don't understand how to add this to your example...
>
> Thanks
> Fabrizio
>
>
> [1] https://stackoverflow.com/questions/22695365/query-
> google-spreadsheet-with-url-parameters
>
>
> 2017-08-01 19:07 GMT+02:00 aborruso <aborruso at gmail.com>:
>
>> Ciao Fabrizio,
>> did you solve your first problem?
>>
>>
>> Fabrizio Carrai wrote
>> > As Andrew said, "lat" and "long" works fine as well, but I followed your
>> > suggestion anyhow. In your copy you access the Google Sheet through
>> > docs.google.com/spreadsheet and some parameters, but I need to query
>> the
>> > CSV table with a "SELECT". Do you know if I can use a SELECT as
>> parameters
>> > ? I'm finding no useful info.
>>
>> Do you want to make a query via URL, or to do this query in the sheet and
>> than expose this query output to uMap. Please give us some more details
>>
>>
>>
>>
>> --
>> View this message in context: http://umap-discussions-about-
>> umap-project.2359850.n4.nabble.com/Re-uMap-UMAP-and-CSV-
>> delimiter-tp59p69.html
>> Sent from the Umap -- Discussions about uMap project mailing list archive
>> at Nabble.com.
>>
>> _______________________________________________
>> Umap mailing list
>> Umap at openstreetmap.org
>> https://lists.openstreetmap.org/listinfo/umap
>>
>
>
>
> --
> *Fabrizio*
>



-- 
*Fabrizio*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/umap/attachments/20170805/5ece5435/attachment.htm>