wk | Lightweight Well-Known Geometry Parsing | Map library

I've been trying to make this work for hours, it seems like everything is in order but I cant make it work

Hopefully, maybe someone can point me in the right direction, do you see any issues with this code?

The relevant part is the last function on the first file

and for the second file, all just after the form components

I'm desperate :(

This is the code I'm using

code.gs

...

I have a macro that I use in Excel 2010 to loop through some xls files, extracting the data from each into a xlsm file. There should be about 195,000 rows from across all of the xls files, but after running it I end up with closer to 90,000. If I run it on only a few of the files at once I get the correct number so it seems to be something to do with the volume I'm trying to incorporate, but I understand that an xlsm can handle up to a million rows so that shouldn't be a problem, should it?. I've split the source files into batches in the past but I'd rather avoid doing that if possible. Ultimately, I'm trying to compile a csv to import into a SQL database. If anybody has any suggestions, I'd be very grateful.

Thanks.

PS I've asked about this before a month or so ago but as I'd totally misdiagnosed the issue and was asking about the wrong thing, I'm writing a fresh question so that I don't set people off on the wrong track. I was rightly chastised for not including enough code last time. This is the subroutine which extracts the data:

...

Is it possible to create a weakref of a pydantic model ?

...

Let me start by saying that I am somewhat new to SQL/Snowflake and have been putting together queries for roughly 2 months. Some of my query language may not be ideal and I fully understand if there's a better, more efficient way to execute this query. Any and all input is appreciated. Also, this particular query is being developed in Snowflake.

My current query is pulling customer volumes by department and date based on a 45 day window with a 24 day lookback from current date and a 21 day look forward based on scheduled appointments. Each date is grouped based on where it falls within that 45 day window: current week (today through next 7 days), Week 1 (forward-looking days 8-14), and Week 2 (forward-looking days 15-21). I have been working to try and build out a comparison column that, for any date that lands within either the Week 1 or Week 2 group, will pull in prior period volumes from either 14 days prior (Week 1) or 21 days prior (Week 2) but am getting nowhere. Is there a best-practice for this type of column? Generic example of the current output is attached. Please note that the 'Prior Wk' column in the sample output was manually populated in an effort to illustrate the way this column should ideally work.

I have tried several different iterations of count(case...) similar to that listed below; however, the 'Prior Wk' column returns the count of encounters/scheduled encounters for the same day rather than those that occurred 14 or 21 days ago.

...

I have the query below that assigns a station volume based on the volume processed that week. Station sizes are based by looking at 4 data points throughout the year. This is because station fluctuate in volume throughout the year for example, they may have small volume in one quarter, but large in another. The goal is to assign a size to a station that will best suite it the entire year. The sql below gets together the four data points that will be needed to evaluate what size a station_size will be applied. There are multiple combinations of volume possibilities that can take place over the year which is why they are stored in a separate table. I have a separate table called "station_sizes" that provides the logic for what the station size will be based on the volume taken from the four point in time.

For example if a station processes small volume in wk 14 and small volume in wk27 and standard volume in wk 40 and small volume in wk 47 then they would be a ds small station size. There are 1000s of scenarios in the station_size table.

I want the final output to be the excerpt from the query output + station_size. The station size will be pulled from the station_size table.

I need to know how to have the query below reference the station size table so that it can identify for each year group is wk_16= xyz.. and wk_26 =xyz.. and wk_39 = xyz.. and wk_43 =xyz then it will pull in the size logic form the station size table.

For the ar section in the query. I want the logic to be if a station has "Yes" for AR at a minimum it needs to be a standard station size. I am not sure if I did that peice right. I am fine if its bigger than that but no smaller.

...

Good morning, I am newish to SQL and would really appreciate some help. I am using the following query but do not want the "ar" column or second occurrence of the "station_ref column". When I try to remove it in the group by area it I get an area saying it "not in aggregate function". Also I am trying to link this output with another table named "station_sizes" where based on wk # it assigns a size to a station. For example if a station is small at wk 20 and standard at wk 48 then it will be a standard size. The station_size table outlines 100s of different scenarios and what size a station will be.Refer below for what the table looks like.Can you please help.Thanks!

...

I have a table that is currently in the following format

ID Title CreatedOn 1 Test 1 2021-04-26 08:00:00 2 Test 2 2021-04-26 10:00:00 3 Test 3 2021-04-27 09:00:00 4 Test 4 2021-04-28 14:00:00 5 Test 5 2021-04-28 16:00:00 6 Test 6 2021-04-28 12:00:00 7 Test 7 2021-04-29 13:00:00 8 Test 8 2021-04-30 06:00:00 9 Test 9 2021-05-17 10:00:00 10 Test 10 2021-05-18 19:00:00 11 Test 11 2021-05-18 23:00:00 12 Test 12 2021-05-19 16:00:00 13 Test 13 2021-05-20 07:00:00 14 Test 14 2021-05-21 14:00:00 15 Test 15 2021-05-21 10:00:00 16 Test 16 2021-04-30 10:00:00

What I would like to do is a query that would tell me how many requests have been Monday to Friday per hour. So aggregate all the data into just rows of Monday to Friday.

So the query should return

Day Hour Count Monday 08:00 1 Monday 10:00 2 Tuesday 10:00 1 Tuesday 19:00 1 Tuesday 23:00 1 Wednesday 14:00 1 Wednesday 16:00 2 Wednesday 12:00 1

etc.. How do I achieve this?

So far I have the following

...

I'm trying to replace backslashes (from this polyline) with double backslashes.

My Script:

...

I'm trying to build a chess game in Python using tkinter for graphics. I've created a grid that is 8x8 (rows and columns) and placed Tiles there (which is a type of button). It all works great, until you fill an entire row with chess pieces, then the entire row dissappears. And I have no idea why.

When filling entire row except one: https://gyazo.com/865aed481e4a84c5e9e8918695410006

When filling entire row: https://gyazo.com/acf48c9790335ba11913b6017d2652c3

As you can see, the entire row of buttons dissappear^

Here's my code:

Code for the Tile class (inherits tkinter button)

...