saratoga | A HTTP API Framework | REST library

You may do so using the following code on the template by using the keyvalue pipe:

To make a little go a long way, do the following:

1. Create a new series for each column and pass the regex pattern \W+ to str.replace()
2. use str.lower()
3. create replace lists to normalize drive to dr, avenue to ave, etc.

First thing to note: You've made things more difficult for yourself, choosing property names with spaces in them.

Now, onto the query issue: the properties in question, when using $where, need to be preceded by this. And you won't be able to use dot-notation like this.Current City because of the space. You'll need to use brackets (e.g. this['Current City'].

So your query needs to be something like:

I think the working directory is not /home/user/Desktop/ when the code runs in cron. Add a line at the beginning of the code: os.chdir("/home/user/Desktop/")

You could add 2 data-attribute to your buttons, one with img src and other with the target div, like this:

It seems that VALUES, esp. in conjunction with /, confuses the Blazegraph's query optimizer in that case.

Use UNION instead of VALUES:

data contains the object that results from parsing the JSON response.

Since $.getJSON is asynchronous, you can't use the variables that are set in the callback outside it. You need to call map.setView() in the callback.

Here is a minimal working solution (excluding imports) using a sample DataFrame for you using a smaller grid of 2x3. You can simply extend it to your actual grid and real data. The important lines which are used for setting the title are highlighted by a comment

If you just want an array containing the fields that you have coded in your loop, you should just code them into your query. I'm not sure what you are doing with the $aa in your array, but you have it there so I'm including it in my last example.

SQL APPROACH:

Note: The $aa will be missing.