{"id":51,"date":"2022-08-24T10:51:34","date_gmt":"2022-08-24T10:51:34","guid":{"rendered":"https:\/\/themeger.shop\/wordpress\/katen\/personal-alt\/?p=51"},"modified":"2023-10-14T10:18:16","modified_gmt":"2023-10-14T08:18:16","slug":"15-unheard-ways-to-achieve-greater-walker","status":"publish","type":"post","link":"https:\/\/www.mutlu.ch\/?p=51","title":{"rendered":"Kusto Detective Agency: Chall #4"},"content":{"rendered":"\n

Hello. I have been watching you, and I am pretty impressed with your abilities of hacking and cracking little crimes.
Want to play big? Here is a prime puzzle for you. Find what it means and prove yourself worthy.<\/em><\/p>\n\n\n\n

20INznpGzmkmK2NlZ0JILtO4OoYhOoYUB0OrOoTl5mJ3KgXrB0[8LTSSXUYhzUY8vmkyKUYevUYrDgYNK07yaf7soC3kKgMlOtHkLt[kZEclBtkyOoYwvtJGK2YevUY[v65iLtkeLEOhvtNlBtpizoY[v65yLdOkLEOhvtNlDn5lB07lOtJIDmllzmJ4vf7soCpiLdYIK0[eK27soleqO6keDpYp2CeH5d\\F\\fN6aQT6aQL[aQcUaQc[aQ57aQ5[aQDG<\/p>\n\n\n\n

Start by grabbing Prime Numbers from
https:\/\/kustodetectiveagency.blob.core.windows.net\/prime-numbers\/prime-numbers.csv.gz<\/a> and educate yourself on Special Prime numbers (https:\/\/www.geeksforgeeks.org\/special-prime-numbers<\/a>), this should get you to
https:\/\/aka.ms\/{Largest special prime under 100M}<\/strong><\/em><\/p>\n\n\n\n

Once you get this done \u2013 you will get the next hint.<\/em><\/p>\n\n\n\n

Cheers,
El Puente.<\/em><\/p>\n\n\n\n

<\/p>\n\n\n\n

Questions: What does the puzzle means?<\/p>\n\n\n\n\n\n\n\n

<\/p>\n\n\n\n

Chall #4 Solution<\/h3>\n\n\n\n

Create the prime number table and import the data to your cluster:<\/p>\n\n\n\n

.execute database script <|\n.create-merge table PrimeNumbers (PrimeNumber: int)\n.ingest async into table PrimeNumbers (@'https:\/\/kustodetectiveagency.blob.core.windows.net\/prime-numbers\/prime-numbers.csv.gz')<\/code><\/pre>\n\n\n\n
Now you can calculate the prime number and generate the URL<\/p>\n\n\n\n
let SpecialPrimeNumberCandidates = PrimeNumbers\n| sort by PrimeNumber asc \n| project PrimeNumber = toint(1 + PrimeNumber +  prev(PrimeNumber)), Number1= prev(PrimeNumber), Number2 = PrimeNumber\n| where PrimeNumber < 100000000;\nSpecialPrimeNumberCandidates\n| join kind=inner PrimeNumbers on PrimeNumber\n| top 1 by PrimeNumber desc \n| project url = strcat(\"https:\/\/aka.ms\/\", tostring(PrimeNumber))<\/code><\/pre>\n\n\n\n
 you have now the URL : The URL is https:\/\/aka.ms\/99999517
<\/p>\n\n\n\n
Visiting this URL you will get below hints<\/p>\n\n\n\n
Well done, my friend. It’s time to meet. Let’s go for a virtual sTREEt tour… Across the Big Apple city, there is a special place with Turkish Hazelnut and four Schubert Chokecherries within 66-meters radius area. Go ‘out’ and look for me there, near the smallest American Linden tree (within the same area). Find me and the bottom line: my key message to you. Cheers, El Puente.<\/em><\/p>\n\n\n\n
PS: You know what to do with the following:<\/em><\/p>\n\n\n\n\n\n\n\n
.execute database script <|\n\/\/ The data below is from https:\/\/data.cityofnewyork.us\/Environment\/2015-Street-Tree-Census-Tree-Data\/uvpi-gqnh \n\/\/ The size of the tree can be derived using 'tree_dbh' (tree diameter) column.\n.create-merge table nyc_trees \n       (tree_id:int, block_id:int, created_at:datetime, tree_dbh:int, stump_diam:int, \ncurb_loc:string, status:string, health:string, spc_latin:string, spc_common:string, steward:string,\nguards:string, sidewalk:string, user_type:string, problems:string, root_stone:string, root_grate:string,\nroot_other:string, trunk_wire:string, trnk_light:string, trnk_other:string, brch_light:string, brch_shoe:string,\nbrch_other:string, address:string, postcode:int, zip_city:string, community_board:int, borocode:int, borough:string,\ncncldist:int, st_assem:int, st_senate:int, nta:string, nta_name:string, boro_ct:string, ['state']:string,\nlatitude:real, longitude:real, x_sp:real, y_sp:real, council_district:int, census_tract:int, ['bin']:int, bbl:long)\nwith (docstring = \"2015 NYC Tree Census\")\n.ingest async into table nyc_trees ('https:\/\/kustodetectiveagency.blob.core.windows.net\/el-puente\/1.csv.gz')\n.ingest async into table nyc_trees ('https:\/\/kustodetectiveagency.blob.core.windows.net\/el-puente\/2.csv.gz')\n.ingest async into table nyc_trees ('https:\/\/kustodetectiveagency.blob.core.windows.net\/el-puente\/3.csv.gz')\n\/\/ Get a virtual tour link with Latitude\/Longitude coordinates\n.create-or-alter function with (docstring = \"Virtual tour starts here\", skipvalidation = \"true\") VirtualTourLink(lat:real, lon:real) { \n\tprint Link=strcat('https:\/\/www.google.com\/maps\/@', lat, ',', lon, ',4a,75y,32.0h,79.0t\/data=!3m7!1e1!3m5!1s-1P!2e0!5s20191101T000000!7i16384!8i8192')\n}\n\/\/ Decrypt message helper function. Usage: print Message=Decrypt(message, key)\n.create-or-alter function with \n  (docstring = \"Use this function to decrypt messages\")\n  Decrypt(_message:string, _key:string) { \n    let S = (_key:string) {let r = array_concat(range(48, 57, 1), range(65, 92, 1), range(97, 122, 1)); \n    toscalar(print l=r, key=to_utf8(hash_sha256(_key)) | mv-expand l to typeof(int), key to typeof(int) | order by key asc | summarize make_string(make_list(l)))};\n    let cypher1 = S(tolower(_key)); let cypher2 = S(toupper(_key)); coalesce(base64_decode_tostring(translate(cypher1, cypher2, _message)), \"Failure: wrong key\")\n}<\/code><\/pre>\n\n\n\n
Query to calculate the possible location:<\/p>\n\n\n\n
let Schubert = nyc_trees\n| where spc_common has \"'Schubert' chokecherry\"\n| project tree_id, block_id, spc_common, latitude, longitude, h3_cell=geo_point_to_h3cell(longitude, latitude,10);\nlet Turkish = nyc_trees\n| where spc_common has \"Turkish Hazelnut\"\n| project tree_id, block_id, spc_common, latitude, longitude,h3_cell=geo_point_to_h3cell(longitude, latitude,10);\nlet PossibleLocations = Turkish\n| join kind=inner  (Schubert) on h3_cell\n| summarize count() by tree_id, latitude, longitude,h3_cell\n| where count_ == 4;\nlet Linden = nyc_trees\n| where spc_common has \"American linden\"\n| project tree_id, block_id, spc_common, latitude, longitude, tree_dbh,h3_cell=geo_point_to_h3cell(longitude, latitude,10)\n| where h3_cell==\"8a2a100dec9ffff\";\nPossibleLocations\n| join kind=inner Linden on h3_cell\n| top 1 by tree_dbh asc\n| project latitude=latitude1, longitude=longitude1<\/code><\/pre>\n\n\n\n
<\/code><\/pre>\n\n\n\n
\n
\"\"<\/figure>\n<\/figure>\n\n\n\n
Conclusion<\/h3>\n\n\n\n