[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_154":155,"_156":157},"routes/_app.x.$handle.$name",{"_95":94,"_32":45,"_103":85,"_27":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":25,"_118":119,"_120":25,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":31,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",8,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","get-adjacencies.tsx","latestPath","fileId","4419d2ae-3185-11f0-a4f5-569c3dd06744","name","fileType","script","content","// Combined School District and Zip Code Finder\n// This script combines two operations:\n// 1. Find zip codes associated with a school district name and state\n// 2. For each zip code, find associated school districts\n// The result is a comprehensive list of school districts in the area\n\nimport axios from \"https://esm.sh/axios@1.6.2\";\n\n// Replace with your actual Google API key\nconst API_KEY = \"AIzaSyAIX0yjFgh_4N6qiyrdSSZCSTevG-S6RC8\";\n\n// ---------------------------------\n// Part 1: District to Zip Functions\n// ---------------------------------\n\n// Function to geocode a school district (get its coordinates and zip code)\nasync function geocodeSchoolDistrict(districtName, state) {\n try {\n const response = await axios.get(\"https://maps.googleapis.com/maps/api/geocode/json\", {\n params: {\n address: `${districtName} School District, ${state}`,\n key: API_KEY,\n },\n });\n\n if (response.data.status !== \"OK\") {\n throw new Error(`Geocoding failed with status: ${response.data.status}`);\n }\n\n const result = response.data.results[0];\n const location = result.geometry.location;\n\n // Extract zip code from address components\n let zipCode = null;\n for (const component of result.address_components) {\n if (component.types.includes(\"postal_code\")) {\n zipCode = component.short_name;\n break;\n }\n }\n\n return {\n formattedAddress: result.formatted_address,\n lat: location.lat,\n lng: location.lng,\n zipCode,\n };\n } catch (error) {\n console.error(\"Error geocoding school district:\", error.message);\n throw error;\n }\n}\n\n// Function to find zip codes within a radius using reverse geocoding\nasync function findZipCodesInRadius(lat, lng, radiusMiles) {\n const zipCodes = new Set();\n const points = generatePointsInRadius(lat, lng, radiusMiles);\n\n console.log(`Searching for zip codes within ${radiusMiles} miles...`);\n\n for (const point of points) {\n try {\n const response = await axios.get(\"https://maps.googleapis.com/maps/api/geocode/json\", {\n params: {\n latlng: `${point.lat},${point.lng}`,\n key: API_KEY,\n result_type: \"postal_code\",\n },\n });\n\n if (response.data.status === \"OK\") {\n for (const result of response.data.results) {\n for (const component of result.address_components) {\n if (component.types.includes(\"postal_code\")) {\n zipCodes.add(component.short_name);\n break;\n }\n }\n }\n }\n } catch (error) {\n console.error(`Error reverse geocoding point (${point.lat}, ${point.lng}):`, error.message);\n }\n }\n\n return Array.from(zipCodes);\n}\n\n// Helper function to generate points within a radius\nfunction generatePointsInRadius(centerLat, centerLng, radiusMiles) {\n const points = [];\n const numPoints = 8; // Number of points around the circle\n\n // Add center point\n points.push({ lat: centerLat, lng: centerLng });\n\n // Add points around the perimeter\n for (let i = 0; i < numPoints; i++) {\n const angle = (i / numPoints) * 2 * Math.PI;\n const dx = radiusMiles * Math.cos(angle) / 69.1; // Approximate miles per degree latitude\n const dy = radiusMiles * Math.sin(angle) / (69.1 * Math.cos(centerLat * (Math.PI / 180))); // Adjust for longitude\n\n points.push({\n lat: centerLat + dx,\n lng: centerLng + dy,\n });\n }\n\n return points;\n}\n\n// Main function to find zip codes for a school district\nasync function findZipCodesForSchoolDistrict(districtName, state, radiusMiles = 5) {\n try {\n console.log(`Looking up \"${districtName} School District\" in ${state}...`);\n\n // Step 1: Geocode the school district\n const districtInfo = await geocodeSchoolDistrict(districtName, state);\n\n console.log(`Found: ${districtInfo.formattedAddress}`);\n console.log(`Location: ${districtInfo.lat}, ${districtInfo.lng}`);\n console.log(`District Zip Code: ${districtInfo.zipCode || \"Not found\"}`);\n\n // Step 2: Find zip codes within the radius\n const nearbyZipCodes = await findZipCodesInRadius(\n districtInfo.lat,\n districtInfo.lng,\n radiusMiles,\n );\n\n // Add the district's own zip code if it was found\n if (districtInfo.zipCode && !nearbyZipCodes.includes(districtInfo.zipCode)) {\n nearbyZipCodes.unshift(districtInfo.zipCode);\n }\n\n console.log(\n `\\nFound ${nearbyZipCodes.length} zip codes within ${radiusMiles} miles of ${districtName} School District:`,\n );\n console.log(nearbyZipCodes.join(\", \"));\n\n return {\n districtInfo,\n nearbyZipCodes,\n };\n } catch (error) {\n console.error(\"Process failed:\", error.message);\n return { districtInfo: null, nearbyZipCodes: [] };\n }\n}\n\n// ---------------------------------\n// Part 2: Zip to District Functions\n// ---------------------------------\n\n// Geocodes a zip code to get its location\nasync function geocodeZipCode(zipCode) {\n try {\n const response = await axios.get(\"https://maps.googleapis.com/maps/api/geocode/json\", {\n params: {\n address: zipCode,\n key: API_KEY,\n },\n });\n\n if (response.data.status !== \"OK\" || response.data.results.length === 0) {\n console.error(`Geocoding failed with status: ${response.data.status}`);\n return null;\n }\n\n const result = response.data.results[0];\n const location = result.geometry.location;\n\n // Verify this is actually a postal code result\n let isPostalCode = false;\n for (const component of result.address_components) {\n if (component.types.includes(\"postal_code\")) {\n isPostalCode = true;\n break;\n }\n }\n\n if (!isPostalCode) {\n console.warn(\"The geocoded result may not be a valid postal code.\");\n }\n\n return {\n formattedAddress: result.formatted_address,\n lat: location.lat,\n lng: location.lng,\n bounds: result.geometry.bounds,\n viewport: result.geometry.viewport,\n };\n } catch (error) {\n console.error(\"Error geocoding zip code:\", error.message);\n return null;\n }\n}\n\n// Finds school districts near the given coordinates\nasync function findNearbySchoolDistricts(lat, lng) {\n try {\n // Use text search with keywords to find school districts\n const response = await axios.get(\"https://maps.googleapis.com/maps/api/place/textsearch/json\", {\n params: {\n query: \"school district\",\n location: `${lat},${lng}`,\n radius: 10000, // 10km radius\n key: API_KEY,\n },\n });\n\n if (response.data.status !== \"OK\") {\n console.warn(`Places search failed with status: ${response.data.status}`);\n return [];\n }\n\n // Filter results to only include likely school districts\n const districtResults = response.data.results.filter(place => {\n const name = place.name.toLowerCase();\n return (\n (name.includes(\"school district\")\n || name.includes(\"unified\")\n || name.includes(\"elementary district\")\n || name.includes(\"high school district\"))\n && !name.includes(\"office\") // Filter out district offices\n );\n });\n\n return districtResults.map(district => ({\n name: district.name,\n address: district.formatted_address,\n placeId: district.place_id,\n location: district.geometry.location,\n }));\n } catch (error) {\n console.error(\"Error finding nearby school districts:\", error.message);\n return [];\n }\n}\n\n// Alternative method to find school districts using reverse geocoding\nasync function findDistrictsByReverseGeocoding(lat, lng) {\n try {\n const response = await axios.get(\"https://maps.googleapis.com/maps/api/geocode/json\", {\n params: {\n latlng: `${lat},${lng}`,\n result_type: \"administrative_area_level_2|administrative_area_level_3\",\n key: API_KEY,\n },\n });\n\n if (response.data.status !== \"OK\") {\n return [];\n }\n\n return response.data.results.map(result => ({\n name: result.address_components[0].long_name,\n address: result.formatted_address,\n types: result.types,\n addressComponents: result.address_components,\n }));\n } catch (error) {\n console.error(\"Error in reverse geocoding:\", error.message);\n return [];\n }\n}\n\n// Enhance school district data with additional details\nasync function enhanceSchoolDistrictData(districts) {\n if (districts.length === 0) {\n return [];\n }\n\n // For each district, get additional details using the Place Details API\n const enhancedDistricts = await Promise.all(districts.map(async district => {\n if (!district.placeId) return district;\n\n try {\n const detailsResponse = await axios.get(\"https://maps.googleapis.com/maps/api/place/details/json\", {\n params: {\n place_id: district.placeId,\n fields: \"name,formatted_address,geometry,website,formatted_phone_number\",\n key: API_KEY,\n },\n });\n\n if (detailsResponse.data.status === \"OK\") {\n const details = detailsResponse.data.result;\n return {\n ...district,\n website: details.website || \"Not available\",\n phone: details.formatted_phone_number || \"Not available\",\n };\n }\n\n return district;\n } catch (error) {\n console.error(`Error enhancing district data for ${district.name}:`, error.message);\n return district;\n }\n }));\n\n return enhancedDistricts;\n}\n\n// Find school districts associated with a zip code\nasync function findSchoolDistrictsByZipCode(zipCode) {\n try {\n console.log(`\\nSearching for school districts in zip code: ${zipCode}`);\n\n // Step 1: Geocode the zip code to get its location\n const zipCodeInfo = await geocodeZipCode(zipCode);\n\n if (!zipCodeInfo) {\n console.warn(`Could not geocode zip code: ${zipCode}`);\n return [];\n }\n\n console.log(`Found location: ${zipCodeInfo.formattedAddress}`);\n\n // Step 2: Find school districts using the location\n const schoolDistricts = await findNearbySchoolDistricts(zipCodeInfo.lat, zipCodeInfo.lng);\n\n // Step 3: Enhance the school district data\n const enhancedDistricts = await enhanceSchoolDistrictData(schoolDistricts);\n\n if (enhancedDistricts.length === 0) {\n console.log(`No school districts found for zip code ${zipCode} using Places API.`);\n // Try reverse geocoding as a fallback\n const adminAreas = await findDistrictsByReverseGeocoding(zipCodeInfo.lat, zipCodeInfo.lng);\n if (adminAreas.length > 0) {\n console.log(`Found ${adminAreas.length} potential administrative areas.`);\n return adminAreas;\n }\n } else {\n console.log(`Found ${enhancedDistricts.length} school districts for zip code ${zipCode}.`);\n }\n\n return enhancedDistricts;\n } catch (error) {\n console.error(`Error finding school districts for zip code ${zipCode}:`, error.message);\n return [];\n }\n}\n\n// ---------------------------------\n// Part 3: Combined Functionality\n// ---------------------------------\n\n// Function to combine the two processes\nasync function findRelatedSchoolDistricts(districtName, state, radiusMiles = 5) {\n try {\n console.log(`=================================================`);\n console.log(`STARTING COMPREHENSIVE SCHOOL DISTRICT SEARCH`);\n console.log(`=================================================`);\n console.log(`Looking for all school districts related to \"${districtName}\" in ${state}...`);\n console.log(`=================================================\\n`);\n\n // Step 1: Find zip codes for the specified school district\n console.log(`STEP 1: Finding zip codes for the district and within ${radiusMiles} miles`);\n console.log(`-------------------------------------------------`);\n const { districtInfo, nearbyZipCodes } = await findZipCodesForSchoolDistrict(districtName, state, radiusMiles);\n\n if (!districtInfo || nearbyZipCodes.length === 0) {\n console.error(`Could not find the specified school district or any nearby zip codes.`);\n return [];\n }\n\n // Step 2: For each zip code, find associated school districts\n console.log(`\\nSTEP 2: Finding school districts for each zip code`);\n console.log(`-------------------------------------------------`);\n\n const allDistricts = [];\n for (const zipCode of nearbyZipCodes) {\n const districtsForZip = await findSchoolDistrictsByZipCode(zipCode);\n allDistricts.push(...districtsForZip);\n }\n\n // Step 3: Remove duplicates and create a unique list of districts\n console.log(`\\nSTEP 3: Creating a unique list of all related school districts`);\n console.log(`-------------------------------------------------`);\n\n const uniqueDistricts = removeDuplicateDistricts(allDistricts);\n\n // Print summary\n console.log(`\\n=================================================`);\n console.log(`SEARCH SUMMARY`);\n console.log(`=================================================`);\n console.log(`Original District: ${districtName}, ${state}`);\n console.log(`Zip Codes Searched: ${nearbyZipCodes.length}`);\n console.log(`Total Districts Found: ${allDistricts.length}`);\n console.log(`Unique Districts: ${uniqueDistricts.length}`);\n console.log(`=================================================\\n`);\n\n // Print the detailed results\n console.log(`DETAILED RESULTS - ALL RELATED SCHOOL DISTRICTS:`);\n console.log(`-------------------------------------------------`);\n if (uniqueDistricts.length > 0) {\n uniqueDistricts.forEach((district, index) => {\n console.log(`\\n${index + 1}. ${district.name}`);\n console.log(` Address: ${district.address || \"Not available\"}`);\n if (district.website) console.log(` Website: ${district.website}`);\n if (district.phone) console.log(` Phone: ${district.phone}`);\n });\n } else {\n console.log(\"No school districts found.\");\n }\n\n return uniqueDistricts;\n } catch (error) {\n console.error(\"Error in combined search:\", error.message);\n return [];\n }\n}\n\n// Helper function to remove duplicate districts based on name and address\nfunction removeDuplicateDistricts(districts) {\n const uniqueMap = new Map();\n\n districts.forEach(district => {\n // Create a unique key for each district\n const key = district.name;\n\n // Only add if not already in the map or if it has more information\n if (!uniqueMap.has(key) || hasMoreInfo(district, uniqueMap.get(key))) {\n uniqueMap.set(key, district);\n }\n });\n\n return Array.from(uniqueMap.values());\n}\n\n// Helper function to determine if a district has more information than another\nfunction hasMoreInfo(district1, district2) {\n // Count number of non-empty fields\n const countInfo = (d) => {\n let count = 0;\n if (d.website && d.website !== \"Not available\") count++;\n if (d.phone && d.phone !== \"Not available\") count++;\n if (d.address) count++;\n return count;\n };\n\n return countInfo(district1) > countInfo(district2);\n}\n\n// ---------------------------------\n// Main Script Execution\n// ---------------------------------\n\n// Check if this script is being run directly\nif (require.main === module) {\n const args = process.argv.slice(2);\n\n if (args.length < 2) {\n console.log(\"Usage: node combined-district-finder.js \\\"District Name\\\" State [radiusMiles]\");\n console.log(\"Example: node combined-district-finder.js \\\"Palo Alto Unified\\\" CA 5\");\n process.exit(1);\n }\n\n const districtName = args[0];\n const state = args[1];\n const radiusMiles = args.length > 2 ? Number(args[2]) : 5;\n\n findRelatedSchoolDistricts(districtName, state, radiusMiles);\n}\n\n// Export functions for use in other modules\nmodule.exports = {\n findRelatedSchoolDistricts,\n findZipCodesForSchoolDistrict,\n findSchoolDistrictsByZipCode,\n geocodeSchoolDistrict,\n geocodeZipCode,\n findNearbySchoolDistricts,\n findDistrictsByReverseGeocoding,\n};","// Combined School District and Zip Code Finder\n// This script combines two operations:\n// 1. Find zip codes associated with a school district name and state\n// 2. For each zip code, find associated school districts\n// The result is a comprehensive list of school districts in the area\n\nimport axios from \"https://esm.sh/axios@1.6.2\";\n\n// Get your API key from environment variables\nconst API_KEY = Deno.env.get(\"GOOGLE_API_KEY\");\n\n// Types for our data structures\ninterface DistrictInfo {\n formattedAddress: string;\n lat: number;\n lng: number;\n zipCode?: string;\n}\n\ninterface ZipCodeResult {\n districtInfo: DistrictInfo | null;\n nearbyZipCodes: string[];\n}\n\ninterface SchoolDistrict {\n name: string;\n address?: string;\n placeId?: string;\n location?: {\n lat: number;\n lng: number;\n };\n website?: string;\n phone?: string;\n types?: string[];\n addressComponents?: any[];\n}\n\n// ---------------------------------\n// Part 1: District to Zip Functions\n// ---------------------------------\n\n// Function to geocode a school district (get its coordinates and zip code)\nasync function geocodeSchoolDistrict(districtName: string, state: string): Promise {\n try {\n const response = await axios.get(\"https://maps.googleapis.com/maps/api/geocode/json\", {\n params: {\n address: `${districtName} School District, ${state}`,\n key: API_KEY,\n },\n });\n\n if (response.data.status !== \"OK\") {\n throw new Error(`Geocoding failed with status: ${response.data.status}`);\n }\n\n const result = response.data.results[0];\n const location = result.geometry.location;\n\n // Extract zip code from address components\n let zipCode = null;\n for (const component of result.address_components) {\n if (component.types.includes(\"postal_code\")) {\n zipCode = component.short_name;\n break;\n }\n }\n\n return {\n formattedAddress: result.formatted_address,\n lat: location.lat,\n lng: location.lng,\n zipCode,\n };\n } catch (error) {\n console.error(\"Error geocoding school district:\", error.message);\n throw error;\n }\n}\n\n// Function to find zip codes within a radius using reverse geocoding\nasync function findZipCodesInRadius(lat: number, lng: number, radiusMiles: number): Promise {\n const zipCodes = new Set();\n const points = generatePointsInRadius(lat, lng, radiusMiles);\n\n console.log(`Searching for zip codes within ${radiusMiles} miles...`);\n\n for (const point of points) {\n try {\n const response = await axios.get(\"https://maps.googleapis.com/maps/api/geocode/json\", {\n params: {\n latlng: `${point.lat},${point.lng}`,\n key: API_KEY,\n result_type: \"postal_code\",\n },\n });\n\n if (response.data.status === \"OK\") {\n for (const result of response.data.results) {\n for (const component of result.address_components) {\n if (component.types.includes(\"postal_code\")) {\n zipCodes.add(component.short_name);\n break;\n }\n }\n }\n }\n } catch (error) {\n console.error(`Error reverse geocoding point (${point.lat}, ${point.lng}):`, error.message);\n }\n }\n\n return Array.from(zipCodes);\n}\n\n// Helper function to generate points within a radius\nfunction generatePointsInRadius(centerLat: number, centerLng: number, radiusMiles: number) {\n const points = [];\n const numPoints = 8; // Number of points around the circle\n\n // Add center point\n points.push({ lat: centerLat, lng: centerLng });\n\n // Add points around the perimeter\n for (let i = 0; i < numPoints; i++) {\n const angle = (i / numPoints) * 2 * Math.PI;\n const dx = radiusMiles * Math.cos(angle) / 69.1; // Approximate miles per degree latitude\n const dy = radiusMiles * Math.sin(angle) / (69.1 * Math.cos(centerLat * (Math.PI / 180))); // Adjust for longitude\n\n points.push({\n lat: centerLat + dx,\n lng: centerLng + dy,\n });\n }\n\n return points;\n}\n\n// Main function to find zip codes for a school district\nasync function findZipCodesForSchoolDistrict(districtName: string, state: string, radiusMiles = 5): Promise {\n try {\n console.log(`Looking up \"${districtName} School District\" in ${state}...`);\n\n // Step 1: Geocode the school district\n const districtInfo = await geocodeSchoolDistrict(districtName, state);\n\n console.log(`Found: ${districtInfo.formattedAddress}`);\n console.log(`Location: ${districtInfo.lat}, ${districtInfo.lng}`);\n console.log(`District Zip Code: ${districtInfo.zipCode || \"Not found\"}`);\n\n // Step 2: Find zip codes within the radius\n const nearbyZipCodes = await findZipCodesInRadius(\n districtInfo.lat,\n districtInfo.lng,\n radiusMiles,\n );\n\n // Add the district's own zip code if it was found\n if (districtInfo.zipCode && !nearbyZipCodes.includes(districtInfo.zipCode)) {\n nearbyZipCodes.unshift(districtInfo.zipCode);\n }\n\n console.log(\n `\\nFound ${nearbyZipCodes.length} zip codes within ${radiusMiles} miles of ${districtName} School District:`,\n );\n console.log(nearbyZipCodes.join(\", \"));\n\n return {\n districtInfo,\n nearbyZipCodes,\n };\n } catch (error) {\n console.error(\"Process failed:\", error.message);\n return { districtInfo: null, nearbyZipCodes: [] };\n }\n}\n\n// ---------------------------------\n// Part 2: Zip to District Functions\n// ---------------------------------\n\n// Geocodes a zip code to get its location\nasync function geocodeZipCode(zipCode: string) {\n try {\n const response = await axios.get(\"https://maps.googleapis.com/maps/api/geocode/json\", {\n params: {\n address: zipCode,\n key: API_KEY,\n },\n });\n\n if (response.data.status !== \"OK\" || response.data.results.length === 0) {\n console.error(`Geocoding failed with status: ${response.data.status}`);\n return null;\n }\n\n const result = response.data.results[0];\n const location = result.geometry.location;\n\n // Verify this is actually a postal code result\n let isPostalCode = false;\n for (const component of result.address_components) {\n if (component.types.includes(\"postal_code\")) {\n isPostalCode = true;\n break;\n }\n }\n\n if (!isPostalCode) {\n console.warn(\"The geocoded result may not be a valid postal code.\");\n }\n\n return {\n formattedAddress: result.formatted_address,\n lat: location.lat,\n lng: location.lng,\n bounds: result.geometry.bounds,\n viewport: result.geometry.viewport,\n };\n } catch (error) {\n console.error(\"Error geocoding zip code:\", error.message);\n return null;\n }\n}\n\n// Finds school districts near the given coordinates\nasync function findNearbySchoolDistricts(lat: number, lng: number): Promise {\n try {\n // Use text search with keywords to find school districts\n const response = await axios.get(\"https://maps.googleapis.com/maps/api/place/textsearch/json\", {\n params: {\n query: \"school district\",\n location: `${lat},${lng}`,\n radius: 10000, // 10km radius\n key: API_KEY,\n },\n });\n\n if (response.data.status !== \"OK\") {\n console.warn(`Places search failed with status: ${response.data.status}`);\n return [];\n }\n\n // Filter results to only include likely school districts\n const districtResults = response.data.results.filter(place => {\n const name = place.name.toLowerCase();\n return (\n (name.includes(\"school district\")\n || name.includes(\"unified\")\n || name.includes(\"elementary district\")\n || name.includes(\"high school district\"))\n && !name.includes(\"office\") // Filter out district offices\n );\n });\n\n return districtResults.map(district => ({\n name: district.name,\n address: district.formatted_address,\n placeId: district.place_id,\n location: district.geometry.location,\n }));\n } catch (error) {\n console.error(\"Error finding nearby school districts:\", error.message);\n return [];\n }\n}\n\n// Alternative method to find school districts using reverse geocoding\nasync function findDistrictsByReverseGeocoding(lat: number, lng: number): Promise {\n try {\n const response = await axios.get(\"https://maps.googleapis.com/maps/api/geocode/json\", {\n params: {\n latlng: `${lat},${lng}`,\n result_type: \"administrative_area_level_2|administrative_area_level_3\",\n key: API_KEY,\n },\n });\n\n if (response.data.status !== \"OK\") {\n return [];\n }\n\n return response.data.results.map(result => ({\n name: result.address_components[0].long_name,\n address: result.formatted_address,\n types: result.types,\n addressComponents: result.address_components,\n }));\n } catch (error) {\n console.error(\"Error in reverse geocoding:\", error.message);\n return [];\n }\n}\n\n// Enhance school district data with additional details\nasync function enhanceSchoolDistrictData(districts: SchoolDistrict[]): Promise {\n if (districts.length === 0) {\n return [];\n }\n\n // For each district, get additional details using the Place Details API\n const enhancedDistricts = await Promise.all(districts.map(async district => {\n if (!district.placeId) return district;\n\n try {\n const detailsResponse = await axios.get(\"https://maps.googleapis.com/maps/api/place/details/json\", {\n params: {\n place_id: district.placeId,\n fields: \"name,formatted_address,geometry,website,formatted_phone_number\",\n key: API_KEY,\n },\n });\n\n if (detailsResponse.data.status === \"OK\") {\n const details = detailsResponse.data.result;\n return {\n ...district,\n website: details.website || \"Not available\",\n phone: details.formatted_phone_number || \"Not available\",\n };\n }\n\n return district;\n } catch (error) {\n console.error(`Error enhancing district data for ${district.name}:`, error.message);\n return district;\n }\n }));\n\n return enhancedDistricts;\n}\n\n// Find school districts associated with a zip code\nasync function findSchoolDistrictsByZipCode(zipCode: string): Promise {\n try {\n console.log(`\\nSearching for school districts in zip code: ${zipCode}`);\n\n // Step 1: Geocode the zip code to get its location\n const zipCodeInfo = await geocodeZipCode(zipCode);\n\n if (!zipCodeInfo) {\n console.warn(`Could not geocode zip code: ${zipCode}`);\n return [];\n }\n\n console.log(`Found location: ${zipCodeInfo.formattedAddress}`);\n\n // Step 2: Find school districts using the location\n const schoolDistricts = await findNearbySchoolDistricts(zipCodeInfo.lat, zipCodeInfo.lng);\n\n // Step 3: Enhance the school district data\n const enhancedDistricts = await enhanceSchoolDistrictData(schoolDistricts);\n\n if (enhancedDistricts.length === 0) {\n console.log(`No school districts found for zip code ${zipCode} using Places API.`);\n // Try reverse geocoding as a fallback\n const adminAreas = await findDistrictsByReverseGeocoding(zipCodeInfo.lat, zipCodeInfo.lng);\n if (adminAreas.length > 0) {\n console.log(`Found ${adminAreas.length} potential administrative areas.`);\n return adminAreas;\n }\n } else {\n console.log(`Found ${enhancedDistricts.length} school districts for zip code ${zipCode}.`);\n }\n\n return enhancedDistricts;\n } catch (error) {\n console.error(`Error finding school districts for zip code ${zipCode}:`, error.message);\n return [];\n }\n}\n\n// ---------------------------------\n// Part 3: Combined Functionality\n// ---------------------------------\n\n// Function to combine the two processes\nasync function findRelatedSchoolDistricts(districtName: string, state: string, radiusMiles = 5): Promise {\n try {\n console.log(`=================================================`);\n console.log(`STARTING COMPREHENSIVE SCHOOL DISTRICT SEARCH`);\n console.log(`=================================================`);\n console.log(`Looking for all school districts related to \"${districtName}\" in ${state}...`);\n console.log(`=================================================\\n`);\n\n // Step 1: Find zip codes for the specified school district\n console.log(`STEP 1: Finding zip codes for the district and within ${radiusMiles} miles`);\n console.log(`-------------------------------------------------`);\n const { districtInfo, nearbyZipCodes } = await findZipCodesForSchoolDistrict(districtName, state, radiusMiles);\n\n if (!districtInfo || nearbyZipCodes.length === 0) {\n console.error(`Could not find the specified school district or any nearby zip codes.`);\n return [];\n }\n\n // Step 2: For each zip code, find associated school districts\n console.log(`\\nSTEP 2: Finding school districts for each zip code`);\n console.log(`-------------------------------------------------`);\n\n const allDistricts = [];\n for (const zipCode of nearbyZipCodes) {\n const districtsForZip = await findSchoolDistrictsByZipCode(zipCode);\n allDistricts.push(...districtsForZip);\n }\n\n // Step 3: Remove duplicates and create a unique list of districts\n console.log(`\\nSTEP 3: Creating a unique list of all related school districts`);\n console.log(`-------------------------------------------------`);\n\n const uniqueDistricts = removeDuplicateDistricts(allDistricts);\n\n // Print summary\n console.log(`\\n=================================================`);\n console.log(`SEARCH SUMMARY`);\n console.log(`=================================================`);\n console.log(`Original District: ${districtName}, ${state}`);\n console.log(`Zip Codes Searched: ${nearbyZipCodes.length}`);\n console.log(`Total Districts Found: ${allDistricts.length}`);\n console.log(`Unique Districts: ${uniqueDistricts.length}`);\n console.log(`=================================================\\n`);\n\n // Print the detailed results\n console.log(`DETAILED RESULTS - ALL RELATED SCHOOL DISTRICTS:`);\n console.log(`-------------------------------------------------`);\n if (uniqueDistricts.length > 0) {\n uniqueDistricts.forEach((district, index) => {\n console.log(`\\n${index + 1}. ${district.name}`);\n console.log(` Address: ${district.address || \"Not available\"}`);\n if (district.website) console.log(` Website: ${district.website}`);\n if (district.phone) console.log(` Phone: ${district.phone}`);\n });\n } else {\n console.log(\"No school districts found.\");\n }\n\n return uniqueDistricts;\n } catch (error) {\n console.error(\"Error in combined search:\", error.message);\n return [];\n }\n}\n\n// Helper function to remove duplicate districts based on name and address\nfunction removeDuplicateDistricts(districts: SchoolDistrict[]): SchoolDistrict[] {\n const uniqueMap = new Map();\n\n districts.forEach(district => {\n // Create a unique key for each district\n const key = district.name;\n\n // Only add if not already in the map or if it has more information\n if (!uniqueMap.has(key) || hasMoreInfo(district, uniqueMap.get(key)!)) {\n uniqueMap.set(key, district);\n }\n });\n\n return Array.from(uniqueMap.values());\n}\n\n// Helper function to determine if a district has more information than another\nfunction hasMoreInfo(district1: SchoolDistrict, district2: SchoolDistrict): boolean {\n // Count number of non-empty fields\n const countInfo = (d: SchoolDistrict) => {\n let count = 0;\n if (d.website && d.website !== \"Not available\") count++;\n if (d.phone && d.phone !== \"Not available\") count++;\n if (d.address) count++;\n return count;\n };\n\n return countInfo(district1) > countInfo(district2);\n}\n\n// ---------------------------------\n// HTTP Handler for Val Town\n// ---------------------------------\n\n// This is the main entry point for HTTP requests in Val Town\nexport default async function(req: Request): Promise {\n try {\n // Parse the URL to get query parameters\n const url = new URL(req.url);\n const districtName = url.searchParams.get(\"district\");\n const state = url.searchParams.get(\"state\");\n const radiusMilesParam = url.searchParams.get(\"radius\");\n const radiusMiles = radiusMilesParam ? Number(radiusMilesParam) : 5;\n \n // Check if required parameters are provided\n if (!districtName || !state) {\n return new Response(\n JSON.stringify({\n error: \"Missing required parameters\",\n usage: \"?district=DistrictName&state=StateAbbreviation&radius=5\"\n }),\n { \n status: 400,\n headers: { \"Content-Type\": \"application/json\" }\n }\n );\n }\n \n // Check if API key is available\n if (!API_KEY) {\n return new Response(\n JSON.stringify({ error: \"API key not configured\" }),\n { \n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n }\n );\n }\n \n // Execute the search\n const results = await findRelatedSchoolDistricts(districtName, state, radiusMiles);\n \n // Return the results as JSON\n return new Response(\n JSON.stringify({\n query: {\n district: districtName,\n state: state,\n radiusMiles: radiusMiles\n },\n results: results\n }),\n { \n headers: { \"Content-Type\": \"application/json\" }\n }\n );\n } catch (error) {\n // Handle any errors\n console.error(\"Error processing request:\", error);\n return new Response(\n JSON.stringify({ error: \"An error occurred processing your request\" }),\n { \n status: 500,\n headers: { \"Content-Type\": \"application/json\" }\n }\n );\n }\n}","createdAt",["D",1747311476317],"branchVersion","branchId","bd85c718-30bf-11f0-8ba1-569c3dd06744","id","bd857c68-30bf-11f0-8ba1-569c3dd06744","test",["D",1747226052499],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","9f5b2c99-966e-4045-8d52-ec0106bbec23","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","d187c0c4-be62-436b-95a1-8e9a7449c340","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"isOwned",62,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","sawyeraltman","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ybndOSkVHc0U0QnJqZkRma3pwMW9KSm44b3QifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":150,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":-5,"_53":-5,"_18":54,"_55":31,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":151,"_79":152,"_81":153,"_83":25},"tree",[145],"files",[145],"counts",{"_133":61,"_134":135,"_136":61,"_137":138,"_139":140},"contents",[125],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":25,"_38":129,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_27":132},"a217188e-3186-11f0-86b7-569c3dd06744","parentId","latest",["D",1747311476317],7,"label",[28],"pulls","branches",1,"forks","envVars",{"_141":143,"_144":61},"connections",{"_141":61,"_142":61},"count","unfilledCount",2,"emptyCount",{"_43":126,"_32":28,"_30":31,"_127":-5,"_41":42,"_40":14,"_128":25,"_38":146,"_13":130,"_33":34,"_35":37,"_24":25,"_131":-5,"_147":148,"_27":149},["D",1747311476317],"children",[],[28],["D",1747226052499],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":54,"_99":100,"_101":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":45,"_93":94},"ctx",{"_77":-5,"_122":187,"_188":189,"_190":191,"_192":25,"_193":25,"_194":25,"_195":57,"_196":-5,"_197":-7,"_198":-7,"_199":61,"_200":25,"_201":25,"_202":-5,"_203":25,"_204":25,"_205":25,"_206":-5},"ENV",{"_158":159,"_160":161,"_162":85,"_163":164,"_165":166,"_167":168,"_169":170,"_171":172,"_173":174,"_175":176,"_177":178,"_179":180,"_181":182,"_183":184,"_185":186},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v8