Travel Time to Nearest Grocery, Gym, FiDi, Roblox, and Samsara in SF

\n setOrigin(e.target.value)}\n placeholder=\"Enter your location in San Francisco\"\n required\n />\n \n \n {results.length > 0 && (\n <>\n

Full Results

Copy individual rows to paste into spreadsheets

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n {results.map((result, index) => (\n \n \n \n \n \n \n \n \n \n \n \n \n \n ))}\n \n

Origin	Neighborhood	Nearest Grocery Store	Grocery Drive Time	Nearest Gym	Gym Drive Time	FiDi Transit	Roblox Transit	Samsara Transit	Copy	Action
{result.origin}	{result.neighborhood}	{result.grocery.name}	{result.grocery.drivingTime}	{result.gym.name}	{result.gym.drivingTime}	{result.fidi.drivingTime}	{result.roblox.drivingTime}	{result.samsara.transitTime}

\n\n

For Notion Input

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n {results.map((result, index) => (\n \n \n \n \n \n \n \n \n \n ))}\n \n

Neighborhood	Grocery Drive Time	Nearest Gym	FiDi Transit	Roblox Transit	Samsara Transit	Copy

{result.neighborhood}	{result.grocery.drivingTime}	{result.gym.drivingTime}	{result.fidi.drivingTime}	{result.roblox.drivingTime}	{result.samsara.transitTime}

\n\n

For Notion Input

Copy individual rows to paste into Notion tables

\n \n \n \n \n \n \n \n \n \n \n \n \n \n {results.map((result, index) => (\n \n \n \n \n \n \n \n \n \n ))}\n \n

Neighborhood	Grocery Drive Time	Nearest Gym	FiDi Transit	Roblox Transit	Samsara Transit	Copy
{result.neighborhood}	{result.grocery.drivingTime}	{result.gym.drivingTime}	{result.fidi.drivingTime}	{result.roblox.drivingTime}	{result.samsara.transitTime}

\n \n )}\n {error &&

Error: {error}

}\n

\n View Source\n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\n\nif (typeof document !== \"undefined\") {\n client();\n}\n\nexport default async function server(request: Request): Promise {\n console.log(\"Received request:\", request.url);\n const url = new URL(request.url);\n \n if (url.pathname === \"/getSavedResults\") {\n try {\n const { blob } = await import(\"https://esm.town/v/std/blob\");\n const savedResults = await blob.getJSON(\"savedResults\") || [];\n return new Response(JSON.stringify(savedResults), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (error) {\n console.error(\"Error fetching saved results:\", error);\n return new Response(JSON.stringify({ error: \"Failed to fetch saved results\" }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n }\n\n if (url.pathname === \"/deleteResult\") {\n if (request.method !== \"DELETE\") {\n return new Response(JSON.stringify({ error: \"Method not allowed\" }), {\n status: 405,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n const index = parseInt(url.searchParams.get(\"index\"));\n if (isNaN(index)) {\n return new Response(JSON.stringify({ error: \"Invalid index\" }), {\n status: 400,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n try {\n const { blob } = await import(\"https://esm.town/v/std/blob\");\n const savedResults = await blob.getJSON(\"savedResults\") || [];\n savedResults.splice(index, 1);\n await blob.setJSON(\"savedResults\", savedResults);\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (error) {\n console.error(\"Error deleting result:\", error);\n return new Response(JSON.stringify({ error: \"Failed to delete result\" }), {\n status: 500,\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n }\n\n if (url.pathname === \"/calculate\") {\n const origin = url.searchParams.get(\"origin\");\n console.log(\"Calculating for origin:\", origin);\n \n if (!origin) {\n console.error(\"Origin is missing\");\n return new Response(JSON.stringify({ error: \"Origin is required\" }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n const apiKey = Deno.env.get(\"GOOGLE_MAPS_API_KEY\");\n if (!apiKey) {\n console.error(\"API key is missing\");\n return new Response(JSON.stringify({ error: \"API key is not configured\" }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n try {\n console.log(\"Importing blob module\");\n const { blob } = await import(\"https://esm.town/v/std/blob\");\n \n console.log(\"Fetching grocery and gym data\");\n const groceries = await blob.getJSON(\"SF_Grocery\");\n const gyms = await blob.getJSON(\"SF_Gyms\");\n console.log(`Fetched ${groceries.length} groceries and ${gyms.length} gyms`);\n\n console.log(\"Finding nearest grocery\");\n const nearestGrocery = await findNearest(origin, groceries, apiKey);\n console.log(\"Nearest grocery:\", nearestGrocery);\n\n console.log(\"Finding nearest gym\");\n const nearestGym = await findNearest(origin, gyms, apiKey);\n console.log(\"Nearest gym:\", nearestGym);\n\n console.log(\"Calculating driving time to FiDi\");\n const fidiDestination = \"548 Market St, San Francisco, CA 94104\";\n const fidiDrivingTime = await getDrivingTime(origin, fidiDestination, apiKey);\n console.log(\"FiDi driving time:\", fidiDrivingTime);\n\n console.log(\"Calculating driving time to Roblox\");\n const robloxDestination = \"910 Park Pl Ste 300, San Mateo, CA 94403\";\n const robloxDrivingTime = await getDrivingTime(origin, robloxDestination, apiKey, \"09:00:00\", \"Tuesday\");\n console.log(\"Roblox driving time:\", robloxDrivingTime);\n\n console.log(\"Calculating transit time to Samsara\");\n const samsaraDestination = \"1 De Haro St, San Francisco, CA 94103\";\n const samsaraTransitTime = await getTransitTime(origin, samsaraDestination, apiKey);\n console.log(\"Samsara transit time:\", samsaraTransitTime);\n\n console.log(\"Extracting ZIP code and looking up neighborhood\");\n const zipCode = await getZipCode(origin, apiKey);\n const neighborhoodZipMap = await blob.getJSON(\"SF_Neighborhood_ZIP\");\n const neighborhood = neighborhoodZipMap[zipCode] || \"Unknown\";\n console.log(\"Neighborhood:\", neighborhood);\n\n const result = {\n origin: origin,\n neighborhood: neighborhood,\n grocery: nearestGrocery,\n gym: nearestGym,\n fidi: { drivingTime: fidiDrivingTime },\n roblox: { drivingTime: robloxDrivingTime },\n samsara: { transitTime: samsaraTransitTime }\n };\n console.log(\"Final result:\", result);\n\n // Save the result to the blob\n const savedResults = await blob.getJSON(\"savedResults\") || [];\n savedResults.push(result);\n await blob.setJSON(\"savedResults\", savedResults);\n\n return new Response(JSON.stringify(result), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n } catch (error) {\n console.error(\"Error in server function:\", error);\n return new Response(JSON.stringify({ error: \"An error occurred while calculating travel times\", details: error.message }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n }\n\n console.log(\"Serving HTML\");\n return new Response(`\n \n \n Travel Time to Nearest Grocery, Gym, FiDi, Roblox, and Samsara in SF\n \n \n \n

\n \n \n \n `, {\n headers: { \"Content-Type\": \"text/html\" },\n });\n}\n\nasync function findNearest(origin: string, locations: any[], apiKey: string): Promise {\n console.log(`Finding nearest location among ${locations.length} options`);\n const batchSize = 25; // Google Maps API typically allows up to 25 destinations per request\n let nearestLocation = null;\n let shortestTime = Infinity;\n\n for (let i = 0; i < locations.length; i += batchSize) {\n const batch = locations.slice(i, i + batchSize);\n const destinations = batch.map(location => `${location.gps.lat},${location.gps.lng}`).join('|');\n const distanceMatrixUrl = `https://maps.googleapis.com/maps/api/distancematrix/json?origins=${encodeURIComponent(origin)}&destinations=${encodeURIComponent(destinations)}&mode=driving&key=${apiKey}`;\n \n console.log(`Fetching from Distance Matrix API for batch ${i / batchSize + 1}`);\n const response = await fetch(distanceMatrixUrl);\n const data = await response.json();\n console.log(\"Distance Matrix API response status:\", data.status);\n\n if (data.status !== \"OK\") {\n console.error(\"Distance Matrix API failed:\", data);\n throw new Error(`Distance Matrix API failed. Status: ${data.status}`);\n }\n\n data.rows[0].elements.forEach((element, index) => {\n console.log(`Location ${i + index}: status=${element.status}, duration=${element.duration?.value}`);\n if (element.status === \"OK\" && element.duration.value < shortestTime) {\n shortestTime = element.duration.value;\n nearestLocation = {\n name: batch[index].name,\n address: batch[index].address,\n drivingTime: element.duration.text\n };\n }\n });\n }\n\n if (!nearestLocation) {\n throw new Error(\"No valid locations found\");\n }\n\n console.log(\"Nearest location:\", nearestLocation);\n return nearestLocation;\n}\n\nasync function getDrivingTime(origin: string, destination: string, apiKey: string, arrivalTime?: string, arrivalDay?: string): Promise {\n let directionsUrl = `https://maps.googleapis.com/maps/api/directions/json?origin=${encodeURIComponent(origin)}&destination=${encodeURIComponent(destination)}&mode=driving&key=${apiKey}`;\n \n if (arrivalTime && arrivalDay) {\n const nextTuesday = getNextDayOfWeek(new Date(), arrivalDay);\n nextTuesday.setHours(parseInt(arrivalTime.split(':')[0]), parseInt(arrivalTime.split(':')[1]), 0, 0);\n directionsUrl += `&arrival_time=${Math.floor(nextTuesday.getTime() / 1000)}`;\n }\n\n const directionsResponse = await fetch(directionsUrl);\n const directionsData = await directionsResponse.json();\n\n if (directionsData.status === \"OK\") {\n const route = directionsData.routes[0];\n const leg = route.legs[0];\n return leg.duration.text;\n } else {\n throw new Error(`Unable to calculate driving time. Status: ${directionsData.status}`);\n }\n}\n\nasync function getTransitTime(origin: string, destination: string, apiKey: string): Promise {\n const directionsUrl = `https://maps.googleapis.com/maps/api/directions/json?origin=${encodeURIComponent(origin)}&destination=${encodeURIComponent(destination)}&mode=transit&key=${apiKey}`;\n\n const directionsResponse = await fetch(directionsUrl);\n const directionsData = await directionsResponse.json();\n\n if (directionsData.status === \"OK\") {\n const route = directionsData.routes[0];\n const leg = route.legs[0];\n return leg.duration.text;\n } else {\n throw new Error(`Unable to calculate transit time. Status: ${directionsData.status}`);\n }\n}\n\nasync function getZipCode(address: string, apiKey: string): Promise {\n const geocodeUrl = `https://maps.googleapis.com/maps/api/geocode/json?address=${encodeURIComponent(address)}&key=${apiKey}`;\n const response = await fetch(geocodeUrl);\n const data = await response.json();\n\n if (data.status === \"OK\") {\n const zipCode = data.results[0].address_components.find(\n (component) => component.types.includes(\"postal_code\")\n )?.long_name;\n return zipCode || \"Unknown\";\n } else {\n throw new Error(`Unable to get ZIP code. Status: ${data.status}`);\n }\n}\n\nfunction getNextDayOfWeek(date: Date, dayOfWeek: string): Date {\n const days = ['sunday', 'monday', 'tuesday', 'wednesday', 'thursday', 'friday', 'saturday'];\n const targetDay = days.indexOf(dayOfWeek.toLowerCase());\n const currentDay = date.getDay();\n const daysToAdd = (targetDay + 7 - currentDay) % 7;\n date.setDate(date.getDate() + daysToAdd);\n return date;\n}\n\nconst css = `\nbody {\n font-family: Arial, sans-serif;\n max-width: 800px;\n margin: 0 auto;\n padding: 20px;\n}\ninput, button {\n margin: 10px 0;\n padding: 5px;\n}\ntable {\n width: 100%;\n border-collapse: collapse;\n margin-top: 20px;\n}\nth, td {\n border: 1px solid #ddd;\n padding: 8px;\n text-align: left;\n}\nth {\n background-color: #f2f2f2;\n}\n`;","deleted","label",[98],"permalink","https://www.val.town/x/shapedlines/frozenSapphireIguana/code/main.tsx","extension","actionData","errors"]