<div dir="ltr"><div>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:</div><div><br></div><div><a href="https://spreadsheets.google.com/tq?tqx=out:csv&key=1QWF87P6FsllTp2_NMG_eRmsJo6aUCB5Sxccf2zlYQUE&tq=select%20*%20where%20L%20like%20%27Direct%25%27">https://spreadsheets.google.com/tq?tqx=out:csv&key=1QWF87P6FsllTp2_NMG_eRmsJo6aUCB5Sxccf2zlYQUE&tq=select%20*%20where%20L%20like%20%27Direct%25%27</a><br></div><div><br></div><div>How can I add the query "SELECT * WHERE L LIKE 'Direct%' to your working example ?</div><div><br></div><div><a href="https://docs.google.com/spreadsheets/d/1s4pe1Gb3_LIQXOu_ikNxEg0iOCJuwYWlPBLtLk2RAvQ/pub?gid=0&single=true&output=csv" rel="noreferrer" target="_blank" style="font-size:12.8px">https://docs.google.com/sprea<wbr>dsheets/d/1s4pe1Gb3_LIQXOu_ikN<wbr>xEg0iOCJuwYWlPBLtLk2RAvQ/pub?<wbr>gid=0&single=true&output=csv</a><br></div><div><br></div><div>I found this [1] but I don't understand how to add this to your example...</div><div><br></div><div>Thanks</div><div>Fabrizio</div><div><br></div><div><br></div><div>[1] <a href="https://stackoverflow.com/questions/22695365/query-google-spreadsheet-with-url-parameters">https://stackoverflow.com/questions/22695365/query-google-spreadsheet-with-url-parameters</a></div><div><br></div><div class="gmail_extra"><br><div class="gmail_quote">2017-08-01 19:07 GMT+02:00 aborruso <span dir="ltr"><<a href="mailto:aborruso@gmail.com" target="_blank">aborruso@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Ciao Fabrizio,<br>
did you solve your first problem?<br>
<br>
<br>
Fabrizio Carrai wrote<br>
<span class="gmail-">> As Andrew said, "lat" and "long" works fine as well, but I followed your<br>
> suggestion anyhow. In your copy you access the Google Sheet through<br>
> <a href="http://docs.google.com/spreadsheet" rel="noreferrer" target="_blank">docs.google.com/spreadsheet</a> and some parameters, but I need to query the<br>
> CSV table with a "SELECT". Do you know if I can use a SELECT as parameters<br>
> ? I'm finding no useful info.<br>
<br>
</span>Do you want to make a query via URL, or to do this query in the sheet and<br>
than expose this query output to uMap. Please give us some more details<br>
<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://umap-discussions-about-umap-project.2359850.n4.nabble.com/Re-uMap-UMAP-and-CSV-delimiter-tp59p69.html" rel="noreferrer" target="_blank">http://umap-discussions-about-<wbr>umap-project.2359850.n4.<wbr>nabble.com/Re-uMap-UMAP-and-<wbr>CSV-delimiter-tp59p69.html</a><br>
<div class="gmail-HOEnZb"><div class="gmail-h5">Sent from the Umap -- Discussions about uMap project mailing list archive at Nabble.com.<br>
<br>
______________________________<wbr>_________________<br>
Umap mailing list<br>
<a href="mailto:Umap@openstreetmap.org">Umap@openstreetmap.org</a><br>
<a href="https://lists.openstreetmap.org/listinfo/umap" rel="noreferrer" target="_blank">https://lists.openstreetmap.<wbr>org/listinfo/umap</a><br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><div dir="ltr"><div style="font-family:arial;font-size:small"><i>Fabrizio</i><br></div></div></div>
</div></div>