[uMap] UMAP and CSV delimiter

[Fabrizio Carrai]

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_ikN
xEg0iOCJuwYWlPBLtLk2RAvQ/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*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/umap/attachments/20170805/2f18513c/attachment.htm>