2 function Add-Address(){
4 [string]$addressFile = "Addresses.csv"
5 [string]$outFile= "Address_Details.csv"
7 $addressList = Get-Content $addressFile | ConvertFrom-Csv
8 $details = Get-Content $outFile| ConvertFrom-Csv
10 $addressList | ForEach-Object {
11 if($details -NotContains $_.Address)
13 $details.Address = $_.Address
14 $details.SqFt = $_.SqFt
15 $details.Cost = $_.Cost
18 $details | Export-Csv -NoTypeInformation -Path $outFile
19 Write-Host "Updated $outFile"
23 function Add-AddressLocations(){
25 [string]$outFile= "Address_Details.csv"
27 $details = Get-Content $outFile| ConvertFrom-Csv
29 $details | ForEach-Object {
32 $posit = Get-MapCoords -Address $_.Address
37 $details | Export-Csv -NoTypeInformation -Path $outFile
38 Write-Host "Updated $outFile"
42 function Add-TravelTimes() {
44 [string]$outFile= "Address_Details.csv"
46 $details = Get-Content $outFile| ConvertFrom-Csv
50 $fuzzyUrl = "https://atlas.microsoft.com/search/fuzzy/json?&api-version=1.0&subscription-key={Your-Azure-Maps-Subscription-key}&language=en-US&query=pizza"
52 function Get-MapAddress() {
56 $subKey = $env:AzMapsSubKey
57 $addyUrl = "https://atlas.microsoft.com/search/address/json?&subscription-key=$subKey&api-version=1.0&language=en-US&query=$address"
58 $result = Invoke-WebRequest $addyUrl
59 if($result.StatusCode -Eq 200){
60 return $result.Content | ConvertFrom-Json
62 return $result.StatusDescription
65 function Get-MapCoords() {
69 $subKey = $env:AzMapsSubKey
70 $result = Get-MapAddress -Address $address
71 return $result.results.entryPoints[0].position
74 function Get-MapTravelPlan() {
76 [string]$from_address,
79 $subKey = $env:AzMapsSubKey
80 $pos1 = Get-MapCoords -Address $from_address
84 $pos2 = Get-MapCoords -Address $to_address
88 $query = "$lat1,$($lon1):$lat2,$lon2"
90 $travelUrl = "https://atlas.microsoft.com/route/directions/json?subscription-key=$subKey&api-version=1.0&query=$query&travelMode=car&traffic=true&departAt=2025-03-29T08:00:20&computeTravelTimeFor=all"
91 $result = Invoke-WebRequest $travelUrl
92 if($result.StatusCode -Eq 200){
93 $content = $result.Content | ConvertFrom-Json
94 if($content.formatVersion -Ne "0.0.12"){
95 Write-Warning "BEWARE Format has updated! BEWARE"
97 return $content.routes
99 return $result.StatusDescription
103 function Get-MapTravelMinutes() {
105 [string]$from_address,
108 $routes = Get-MapTravelPlan -from_address $from_address -to_address $to_address
109 $seconds = $routes.summary.travelTimeInSeconds