Import-Module "$env:psmodules\dash.psm1"
Import-Module $env:PSModules\file_management.psm1
Import-Module "$env:psmodules\fix_vpn.psm1"
+Import-Module $env:PSModules\house_shopping.psm1
# Let's face it, I'm about to cd into my source directory
if((Get-Location).Path -eq $HOME){ cd $env:src }
--- /dev/null
+{\r
+ "extensionsGallery": {\r
+ "serviceUrl": "https://marketplace.visualstudio.com/_apis/public/gallery",\r
+ "itemUrl": "https://marketplace.visualstudio.com/items",\r
+ "cacheUrl": "https://vscode.blob.core.windows.net/gallery/index",\r
+ "controlUrl": ""\r
+ }\r
+ }
\ No newline at end of file
--- /dev/null
+Windows Registry Editor Version 5.00\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{0b0ba2e3-405f-415e-a6ee-cad625207853}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{0b2baaeb-0042-4dca-aa4d-3ee8648d03e5}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{20338b7b-531c-4aad-8011-f5b3db2123ec}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{24ccb8a6-c45a-477d-b940-3382b9225668}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{292108be-88ab-4f33-9a26-7748e62e37ad}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{36011842-dccc-40fe-aa3d-6177ea401788}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{3D1D4EA2-1D8C-418a-BFF8-F18370157B55}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{3f2a72a7-99fa-4ddb-a5a8-c604edf61d6b}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{3f98a740-839c-4af7-8c36-5badfb33d5fd}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{4dcafe13-e6a7-4c28-be02-ca8c2126280d}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{4F01EBC5-2385-41f2-A28E-2C5C91FB56E0}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{503a4e73-1734-441a-8eab-01b3f3861156}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{51294DA1-D7B1-485b-9E9A-17CFFE33E187}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{524ddb2b-2a4f-43b8-b8fe-e91ef9d8ba69}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{59BD6DD1-5CEC-4d7e-9AD2-ECC64154418D}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{5c4f28b5-f869-4e84-8e60-f11db97c5cc7}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{5f4eab9a-6833-4f61-899d-31cf46979d49}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{5fa96407-7e77-483c-ac93-691d05850de8}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{631958a6-ad0f-4035-a745-28ac066dc6ed}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{654a1b99-8a4b-4e7b-a4e1-46378ad77a61}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{672ECD7E-AF04-4399-875C-0290845B6247}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{71689ac1-cc88-45d0-8a22-2943c3e7dfb3}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{71D642A9-F2B1-42cd-AD92-EB9300C7CC0A}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{7d49d726-3c21-4f05-99aa-fdc2c9474656}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{7F2F5B96-FF74-41da-AFD8-1C78A5F3AEA2}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{7fde1a1e-8b31-49a5-93b8-6be14cfa4943}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{834d8a44-0974-4ed6-866e-f203d80b3810}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{885a186e-a440-4ada-812b-db871b942259}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{8faf9629-1980-46ff-8023-9dceab9c3ee3}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{921C636D-9FC8-40d7-899E-0845DCD03010}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{94d6ddcc-4a68-4175-a374-bd584a510b78}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{978e0ed7-92d6-4cec-9b59-3135b9c49ccf}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{982725ee-6f47-479e-b447-812bfa7d2e8f}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{B337FD00-9DD5-4635-A6D4-DA33FD102B7A}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{b3690e58-e961-423b-b687-386ebfd83239}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{c1f8339f-f312-4c97-b1c6-ecdf5910c5c0}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{C4D98F09-6124-4fe0-9942-826416082DA9}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{CD0FC69B-71E2-46e5-9690-5BCD9F57AAB3}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{da3f6866-35fe-4229-821a-26553a67fc18}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{db2a5d8f-06e6-4007-aba6-af877d526ea6}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{DD61BD66-70E8-48dd-9655-65C5E1AAC2D1}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{de2b70ec-9bf7-4a93-bd3d-243f7881d492}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{e053a11a-dced-4515-8c4e-d51ba917517b}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{ea25fbd7-3bf7-409e-b97f-3352240903f4}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{ef87b4cb-f2ce-4785-8658-4ca6c63e38c6}]\r
+"Mode"=dword:00000004\r
+\r
+[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Shell\Bags\AllFolders\Shell\{fbb3477e-c9e4-4b3b-a2ba-d3f5d3cd46f9}]\r
+"Mode"=dword:00000004\r
\r
+## Use\r
+\r
+\r
+Call `Add-Addresses` to copy records from `Addresses.csv` to `Address_Ddetails.csv`.\r
+\r
+Call `Add-AddressLocations` to fetch latitude and longitude for all addresses in `Address_Details.csv`.\r
\r
## Reference\r
\r
\r
-function Get-TravelTimes() {\r
+function Add-Addresses(){\r
+ Param(\r
+ [string]$addressFile = "Addresses.csv",\r
+ [string]$outFile= "Address_Details.csv"\r
+ )\r
+ Copy-Item $outFile "$outFile.backup"\r
+ $addressList = Get-Content $addressFile | ConvertFrom-Csv\r
+ $details = Get-Content $outFile| ConvertFrom-Csv\r
+\r
+ $results = [System.Collections.ArrayList]@()\r
+ $known = [System.Collections.ArrayList]@()\r
+\r
+ $details | ForEach-Object {\r
+ $idx = $results.Add($_)\r
+ $known.Add($_.Address)\r
+ }\r
+ $addressList | ForEach-Object {\r
+ if($known -NotContains $_.Address)\r
+ {\r
+ $idx = $results.Add($_)\r
+ $idx = Write-Host "Aadded " + $_.Address\r
+ }\r
+ }\r
+ $results | Format-Table\r
+ $answer = Read-Host -Prompt "Write updated file? y/N"\r
+ if($answer -Eq "y") {\r
+ $results | Export-Csv -NoTypeInformation -Path $outFile\r
+ Write-Host "Updated $outFile"\r
+ }\r
+}\r
+\r
+\r
+function Add-AddressLocations(){\r
+ Param(\r
+ [string]$outFile= "Address_Details.csv"\r
+ )\r
+ Copy-Item $outFile "$outFile.backup"\r
+ $details = Get-Content $outFile| ConvertFrom-Csv\r
\r
+ $results = [System.Collections.ArrayList]@()\r
+\r
+ $details | ForEach-Object {\r
+ $updated = $_\r
+ if($_.lat -Eq $null)\r
+ {\r
+ Write-Host "Looking up position of " $_.Address\r
+ $coords= Get-MapCoords -Address $_.Address\r
+ $coords | Format-List\r
+ $updated.lat = $coords.lat\r
+ $updated.lon = $coords.lon\r
+ $updated | Format-List\r
+ }\r
+ $idx = $results.Add($updated)\r
+ }\r
+ $results | Select-Object Address, lat, lon | Format-List\r
+ $answer = Read-Host -Prompt "Write updated file? y/N"\r
+ if($answer -Eq "y") {\r
+ $results | Export-Csv -NoTypeInformation -Path $outFile\r
+ Write-Host "Updated $outFile"\r
+ }\r
+}\r
+\r
+\r
+function Add-TravelTimes() {\r
+ Param(\r
+ [string]$outFile= "Address_Details.csv"\r
+ )\r
+ $details = Get-Content $outFile| ConvertFrom-Csv\r
\r
}\r
\r
$fuzzyUrl = "https://atlas.microsoft.com/search/fuzzy/json?&api-version=1.0&subscription-key={Your-Azure-Maps-Subscription-key}&language=en-US&query=pizza"\r
\r
+function Invoke-SubKeyCheck {\r
+ if($env:AzMapsSubKey -Eq $null) {\r
+ Write-Error "Please set env:AzMapsSubKey"\r
+ Exit\r
+ }\r
+}\r
+\r
function Get-MapAddress() {\r
param(\r
[string]$address\r
)\r
+ Invoke-SubKeyCheck\r
$subKey = $env:AzMapsSubKey\r
$addyUrl = "https://atlas.microsoft.com/search/address/json?&subscription-key=$subKey&api-version=1.0&language=en-US&query=$address"\r
$result = Invoke-WebRequest $addyUrl\r
param(\r
[string]$address\r
)\r
+ Invoke-SubKeyCheck\r
$subKey = $env:AzMapsSubKey\r
$result = Get-MapAddress -Address $address\r
return $result.results.entryPoints[0].position\r
[string]$from_address,\r
[string]$to_address\r
)\r
+ Invoke-SubKeyCheck\r
$subKey = $env:AzMapsSubKey\r
$pos1 = Get-MapCoords -Address $from_address\r
$lat1 = $pos1.lat\r