Access Overpass Turbo with Google Apps Script?

Question

I would like to use Google Apps Scripts to import data from an Overpass Turbo request into a Google sheet. The QL request is something like this:

( node (user:"greenmtdave") (6.960464727056788,79.86112117767334,6.9797191061459305,79.88375902175903); way (user:"greenmtdave") (6.960464727056788,79.86112117767334,6.9797191061459305,79.88375902175903); relation (user:"greenmtdave") (6.960464727056788,79.86112117767334,6.9797191061459305,79.88375902175903); node._(changed:"2016-05-15T07:00:00Z","2016-06-6T07:01:00Z"); ); out count;

Note the use of the "out count" option, which does not seem to work if using the QL request in HTTP, so I presume I need to use XML format, but I don't know if the Google Apps Scripts class URLFetchApp supports this. I'm not much of a coder, so I can't figure this out.

Answer 1

2

Just to wrap this up, I finally did figure out how to write a Google Apps Script to bring data from OSM into a spreadsheet. Could use some expert help to clean it up, do error checking, and make it more user friendly, so feel free to contact me at dwlitke@comcast.net if you are interested.

permanent link

answered 17 Jun '16, 21:13

greenmtdave
181●3●4●12
accept rate: 0%

Feel free to post it here. Or a link to GitHub or some other platform where you might host your script.

(17 Jun '16, 21:29) scai ♦

How do I post it here without exceeding the character count? I tried using the Code Sample button, but that did some strange things to the formatting.

(17 Jun '16, 21:38) greenmtdave

just post in your answer text ("edit" link) and indent each code line by at least 4 spaces or 1 tab (a text editor helps). If you want to preview, use https://daringfireball.net/projects/markdown/dingus since our live preview here is insufficient. Or just past the code and someone else fill fix the formatting for you.

(18 Jun '16, 00:12) aseerel4c26 ♦

Answer 2

function startHere(){
  // input variables
  var OSMUserNameCol = "A";
  var totalObjectsCol = "B";
  var startRow = 2; 
  var lastRow = 3;

  var sheet = SpreadsheetApp.getActiveSheet();

  // Fetch the range of cells
  var dataRange1 = sheet.getRange(OSMUserNameCol + startRow + ":" + OSMUserNameCol + lastRow);
  var dataRange2 = sheet.getRange(totalObjectsCol + startRow + ":" + totalObjectsCol + lastRow);

  // Fetch values for each row in the Range.
  var data1 = dataRange1.getValues();
  var data2 = dataRange2.getValues();

  for (var i = 0; i < data1.length; ++i) {
    var row1 = data1[i];
    var row2 = data2[i];

    //Build API request parameters
    var rawXML = '<osm-script>'
       +'<query into="_" type="node"><user into="_" name="' + row1 + '" type="node" uid=""/>'
       +'<bbox-query e="81.11206" into="_" n="7.95451" s="6.72325" w="79.66323"/></query>'
       +'<query into="_" type="node"><item set="_"/><changed into="_" since="2016-05-23T00:00:00Z" until="2016-06-12T00:00:00Z"/>'
       +'</query><union into="_"><item set="_"/><recurse from="_" into="_" type="up"/></union>'
       +'<print e="" from="_" geometry="skeleton" limit="" mode="count" n="" order="id" s="" w=""/>'
       +'</osm-script>';
    var url = 'http://overpass-api.de/api/interpreter';
    var options =
     {
       "method" : "post",
       "payload" : rawXML
     };

   //Fetch count data
   var countData = UrlFetchApp.fetch(url, options).getContentText();
   var total = countData.substring(countData.indexOf("count total=") + 13, countData.indexOf("nodes") - 2);
   sheet.getRange(totalObjectsCol + (startRow + i)).setValue(total);
   SpreadsheetApp.flush();
  }
}

Access Overpass Turbo with Google Apps Script?

Follow this question

Related questions