41:null 42:["$","title",null,{"children":"Traffic Accidents in Chattanooga | ktln | Observable"}] 48:T61c,

${filteredData.length.toLocaleString(undefined)}

incidents

${parseInt(((filteredData.length / processedData.length)*100)).toLocaleString(undefined)}% of total dataset

${ fatalitiesInFilteredDataset.length.toLocaleString(undefined) }

fatalities

${parseInt(((fatalitiesInFilteredDataset.length / filteredData.length)*100)).toLocaleString(undefined)}% of matching incidents

${ injuriesInFilteredDataset.length.toLocaleString(undefined) }

injuries

${parseInt(((injuriesInFilteredDataset.length / filteredData.length)*100)).toLocaleString(undefined)}% of matching incidents

${ duiInFilteredDataset.length.toLocaleString(undefined) }

involvings drugs/alcohol

${parseInt(((duiInFilteredDataset.length / filteredData.length)*100)).toLocaleString(undefined)}% of matching incidents

49:Tad8,heatmap = { const container = yield htl.html`

`; await leafletHeat; const map = L.map(container).setView([35.1, -85.2], 11); let osmLayer = L.tileLayer('https://{s}.basemaps.cartocdn.com/light_all/{z}/{x}/{y}@2x.png', { attribution: '© OpenStreetMap contributors' }).addTo(map); let size = filteredData.length; // For heatmap display scaling function calculateBlur(datasetSize, minSize = 10, maxSize = 100000, minBlur = 2, maxBlur = 8) { const clampedSize = Math.max(minSize, Math.min(maxSize, datasetSize)); // Linear interpolation for blur return minBlur + ((clampedSize - minSize) / (maxSize - minSize)) * (maxBlur - minBlur); } let blur = calculateBlur(size); // Heatmap data const heatmapData = getLatLngsFromDataset(filteredData); const heatLayer = L.heatLayer(heatmapData, { radius: 6, blur, maxZoom: 15, // gradient: { // 0.4: 'blue', // 0.65: 'lime', // 1: 'red' // } }).addTo(map); // const heatLayer = initializeHeatmap(map, heatmapData, { // radius: 6, // blur, // maxZoom: 15, // gradient: { // 0.4: 'blue', // 0.65: 'lime', // 1: 'red' // } // }); // Point layer // Add points as a geoJSON layer const pointLayer = L.geoJSON(filteredDataGeoJSON, { pointToLayer: (feature, latlng) => { return L.circleMarker(latlng, { radius: 5, fillColor: "red", color: "white", weight: 1, opacity: 1, fillOpacity: 0.8 }); }, onEachFeature: (feature, layer) => { // Popup let incidentDate = DateTime.fromJSDate(feature.properties.incident_date).setLocale("en-US").toLocaleString(DateTime.DATETIME_MED); layer.bindPopup(` Location: ${feature.properties.street || "N/A"}
Accident Type: ${feature.properties.accident_type || "N/A"}
Date: ${ incidentDate } `); } }); if (size < 50) { togglePointLayerOnly(); } function togglePointLayerOnly() { if (map.hasLayer(heatLayer)) { // map.removeLayer(heatLayer); } if (!map.hasLayer(pointLayer)) { map.addLayer(pointLayer); } } function toggleHeatLayerOnly() { if (map.hasLayer(pointLayer)) { map.removeLayer(pointLayer); } if (!map.hasLayer(heatLayer)) { // map.addLayer(heatLayer); } } // Toggle layers based on zoom const zoomThreshold = 16; // Define zoom to switch between layers map.on("zoomend", () => { if (size >= 50) { if (map.getZoom() >= zoomThreshold) { togglePointLayerOnly(); } else { toggleHeatLayerOnly(); } } }); return map; }4a:T67d,Inputs.table(filteredData, { columns: [ "incident_date", "street", "accident_type", "collision_type", "total_vehicles_involved", "weather_code", "light_conditions", "involves_hit_and_run", "involves_fatality", "involves_med_transport", "involves_truck", "involves_pedestrian", "involves_bicycle", "involves_drugs", "involves_alcohol" ], header: { incident_date: "Date", street: "Street Address", accident_type: "Type of Accident", collision_type: "Collision Details", total_vehicles_involved: "Total Vehicles Involved", weather_code: "Weather", light_conditions: "Lighting", involves_hit_and_run: "Hit and Run?", involves_fatality: "Fatality?", involves_med_transport: "Medical Transport?", involves_truck: "Truck Involvement?", involves_pedestrian: "Pedestrian Involvement?", involves_bicycle: "Bicycle Involvement?", involves_drugs: "Drug Involvement?", involves_alcohol: "Alcohol Involvement?", }, format: { incident_date: (x) => DateTime.fromJSDate(x).setLocale("en-US").toLocaleString(DateTime.DATETIME_MED), involves_hit_and_run: x => x === true ? "Yes" : "No", involves_fatality: x => x === true ? "Yes" : "No", involves_med_transport: x => x === true ? "Yes" : "No", involves_truck: x => x === true ? "Yes" : "No", involves_pedestrian: x => x === true ? "Yes" : "No", involves_bicycle: x => x === true ? "Yes" : "No", involves_drugs: x => x === true ? "Yes" : "No", involves_alcohol: x => x === true ? "Yes" : "No", Year: d3.format("d") // format as "1960" rather than "1,960" } })4b:T6e5,async function processDataFromXML(entries) { return entries .filter((entry) => { const properties = entry?.content.properties; return properties?.__id?.content; }) .map((entry) => { const properties = entry?.content.properties; return { id: properties?.__id?.content, incident_date: properties?.incident_date?.content, street: properties?.street?.content || "", alt_street: properties?.alt_street?.content || "", city: properties?.city?.content || "", location: properties?.location_wkt?.content || null, accident_type: properties?.accident_type?.content || "", collision_type: properties?.collision_type?.content || "", total_vehicles_involved: properties?.total_vehicles_involved?.content || 0, weather_code: properties?.weather_code?.content ? properties.weather_code.content.split(",").map((s) => s.trim()) : [], light_conditions: properties?.light_condition?.content || "", involves_hit_and_run: simplifyBooleanValue(properties?.hit_and_run?.content), involves_fatality: simplifyBooleanValue(properties?.involved_fatal_injury?.content), involves_med_transport: simplifyBooleanValue(properties?.involved_medical_transport?.content), involves_truck: simplifyBooleanValue(properties?.involved_placarded_truck?.content), involves_pedestrian: simplifyBooleanValue(properties?.pedestrian_involved?.content), involves_bicycle: simplifyBooleanValue(properties?.bicycle_involved?.content), involves_drugs: simplifyBooleanValue(properties?.drug_involved?.content), involves_alcohol: simplifyBooleanValue(properties?.alcohol_involved?.content), }; }); }4c:T5d7,async function processDataFromCSV(entries) { return entries .filter((entry) => entry["Incident Number"]) .map((entry) => ({ id: entry["Incident Number"], incident_date: new Date(entry["Incident Date"]), street: entry["Street"] || "", alt_street: entry["Alt Street"] || "", city: entry["City"] || "", lat: entry["Latitude"] || "", lng: entry["Longitude"] || "", location: entry["Location WKT"] || "", accident_type: entry["Accident Type"] || "", collision_type: entry["Collision Type"] || "", total_vehicles_involved: parseInt(entry["Total Vehicles Involved"], 10) || 0, weather_code: entry["Weather Code"] ? entry["Weather Code"].split(",").map((s) => s.trim()) : [], light_conditions: entry["Light Condition"] || "", involves_hit_and_run: simplifyBooleanValue(entry["Hit and Run"]), involves_fatality: simplifyBooleanValue(entry["Involved Fatal Injury"]), involves_med_transport: simplifyBooleanValue(entry["Involved Medical Transport"]), involves_truck: simplifyBooleanValue(entry["Involved Placarded Truck"]), involves_pedestrian: simplifyBooleanValue(entry["Pedestrian Involved"]), involves_bicycle: simplifyBooleanValue(entry["Bicycle Involved"]), involves_drugs: simplifyBooleanValue(entry["Drug Involved"]), involves_alcohol: simplifyBooleanValue(entry["Alcohol Involved"]), }) ); }4d:T550,function applyFilters(data, filters) { return (data.filter(entry => { const matchesAccidentTypes = filters.accidentType.includes("Any") || filters.accidentType.includes(entry.accident_type); const matchesWeatherCodes = filters.weatherCodes.includes("Any") || entry.weather_code.some((condition) => filters.weatherCodes.includes(condition)); const incidentDate = new Date(entry.incident_date); const matchesDateRange = incidentDate >= filters.startDate && incidentDate <= filters.endDate; const matchesBooleanFilters = filters.booleanFilters.length === 0 || // If no boolean filters are applied, return true filters.booleanFilters.some((filter) => { if (filter === "hitAndRun") return entry.involves_hit_and_run; if (filter === "fatality") return entry.involves_fatality; if (filter === "medTransport") return entry.involves_med_transport; if (filter === "truck") return entry.involves_truck; if (filter === "pedestrian") return entry.involves_pedestrian; if (filter === "bicycles") return entry.involves_bicycle; if (filter === "drugsAlcohol") return entry.involves_drugs || entry.involves_alcohol; return false; }); return matchesAccidentTypes && matchesWeatherCodes && matchesDateRange && matchesBooleanFilters; })); }4e:[{"id":"7ef0678b13c8424397c370f83024e8d364d8e3648e2a437a2a920a229a0ed145b853d92c78de3a8cb9d303667a52406be6326a038864fe6ebfe1de50d101da30","href":"https://static.observableusercontent.com/files/7ef0678b13c8424397c370f83024e8d364d8e3648e2a437a2a920a229a0ed145b853d92c78de3a8cb9d303667a52406be6326a038864fe6ebfe1de50d101da30","name":"Vehicle_Incidents_20250103.csv","type":"text/csv","lastModified":1735936924939.463,"size":24655135},{"id":"b892aa1d6b7811b7c7e0eff680576e17f642dce8e66260335da6b30b3fb1e5c6a7acc0644943feaaa038d3b225c3fdcf8744a6e81e14fbbf68f2defc9f640ff1","href":"https://static.observableusercontent.com/files/b892aa1d6b7811b7c7e0eff680576e17f642dce8e66260335da6b30b3fb1e5c6a7acc0644943feaaa038d3b225c3fdcf8744a6e81e14fbbf68f2defc9f640ff1","name":"Vehicle_Incidents_20250112.csv","type":"text/csv","lastModified":1736691155077.924,"size":24719236}] 46:{"id":"758bee5abdb97ede","slug":"chattanooga-traffic-incidents","title":"Traffic Accidents in Chattanooga","thumbnail":"9488684ba8f41a2503f8ed4e495957efa58d7c3a656ad69ca0ba2ae49b93c1e2","access_level":"public","create_time":"$D2025-01-03T15:15:20.171Z","update_time":"$D2025-01-12T14:12:41.563Z","view_time":null,"first_public_time":"$D2025-01-03T15:15:20.171Z","has_unpublished_edits":null,"fork":{"id":"ee9e4fb45c009de1","slug":"search-table","title":"Search + Table","owner":{"id":"f35c755083683fe5","login":"observablehq","name":"Observable"}},"stars":0,"starred":false,"owner":{"type":"team","id":"710c91fe4ceb0f05","login":"ktln","name":"ktln","avatar_url":"https://avatars-next.observableusercontent.com/e417359f621c4c4d39a2b9b886f4e90fd34794f631d60284f0edf9cc817baebb","tier":"starter_2024","bio":"","following":false},"version":832,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"d088ce3b15faef39","login":"ktln","name":"ktln","avatar_url":"https://avatars-next.observableusercontent.com/e417359f621c4c4d39a2b9b886f4e90fd34794f631d60284f0edf9cc817baebb","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"d088ce3b15faef39","login":"ktln","name":"ktln","avatar_url":"https://avatars-next.observableusercontent.com/e417359f621c4c4d39a2b9b886f4e90fd34794f631d60284f0edf9cc817baebb","tier":null,"role":"editor"},{"type":"team","id":"710c91fe4ceb0f05","login":"ktln","name":"ktln","avatar_url":"https://avatars-next.observableusercontent.com/e417359f621c4c4d39a2b9b886f4e90fd34794f631d60284f0edf9cc817baebb","tier":"starter_2024","role":"viewer"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Traffic Accidents in Chattanooga","cells":[{"id":4,"value":"# Traffic Accidents in Chattanooga\n\nUsing data provided by the [Chattanooga OpenData project](https://www.chattadata.org). \n\n#### About this dataset\nData is pulled from Chattanooga PD's RMS system. OpenData records start in 2018. Starting in 2023, CPD stopped proactively responding to crashes where there are no injuries, under $1,500 damage, and all involved parties have insurance, unless specifically requested to respond by a motorist.\n\nThis data was last refreshed on January 3, 2025.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":675,"value":"## Filter traffic incidents by criteria\nBy default, all incidents across the entire data range are showing.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":761,"value":"viewof startDate = Inputs.date({\n label: \"Start Date\",\n min: minDate,\n max: maxDate,\n value: new Date(minDate),\n description: \"The earliest date is 01/01/2018.\"\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":349,"value":"viewof endDate = Inputs.date({\n label: \"End Date\",\n min: minDate,\n max: maxDate,\n value: new Date(maxDate),\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":354,"value":"viewof selectedAccidentType = Inputs.select(\n [\"Any\", ...uniqueAccidentTypes], \n {\n value: \"Any\",\n label: \"Select an accident type\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":419,"value":"viewof selectedWeatherCodes = Inputs.select(\n [\"Any\", ...uniqueWeatherCodes], \n {\n value: \"Any\",\n label: \"Select weather conditions\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":547,"value":"viewof selectedBooleanFilters = Inputs.checkbox(\n new Map([\n [\"Hit and Run\", \"hitAndRun\"], \n [\"Fatality\", \"fatality\"], \n [\"Medical Transport\", \"medTransport\"], \n [\"Placarded Truck\", \"truck\"],\n [\"Pedestrians\", \"pedestrian\"],\n [\"Bicycles\", \"bicycles\"],\n [\"Drug or Alcohol\", \"drugsAlcohol\"]\n ]), {\n label: \"Only show incident if it involves:\", \n value: [\"\"]\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":722,"value":"$48","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":673,"value":"## Matching Incidents by Location\nZoom in to the street level to view precise incident points.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":617,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":681,"value":"## Table of Matching Incidents","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":7,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":755,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":94,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":86,"value":"# Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":232,"value":"## Document Setup","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":687,"value":"#### Leaflet and Map Visualizations","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":218,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":221,"value":"L = require('leaflet@latest')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":609,"value":"// leafletHeat = require('leaflet.heat@0.2.0/dist/leaflet-heat.js').catch(() => window[\"simpleheat\"])\nleafletHeat = require('leaflet.heat@0.2.0/dist/leaflet-heat.js').catch(() => window[\"simpleheat\"]).then(() => {\n if (!L.heatLayer) {\n throw new Error(\"Leaflet.heat couldn't register correctly :(\");\n }\n return L.heatLayer;\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":237,"value":"function initializeHeatmap(map, heatmapData, props) {\n if (!L.heatLayer) {\n throw new Error(\"Leaflet.heat isn't ready!\");\n }\n const heatLayer = L.heatLayer(heatmapData, props);\n}\n\n//heatLayer = (L, require('leaflet.heat').catch(() => L.heatLayer))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":604,"value":"markerCluster = require(\"https://cdnjs.cloudflare.com/ajax/libs/leaflet.markercluster/1.5.3/leaflet.markercluster.js\");","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":689,"value":"#### Luxon and Datetime Management","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":457,"value":"luxon = require('luxon@3.5.0/build/amd/luxon.js')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":466,"value":"DateTime = luxon.DateTime","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":483,"value":"local = DateTime.local()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":235,"value":"d3 = require('d3')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"parser = new DOMParser()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":226,"value":"### Data Imports","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":508,"value":"data = FileAttachment(\"Vehicle_Incidents_20250112.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"// data = fetchAllData(\"https://www.chattadata.org/OData.svc/nvdi-c4tt\");","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":116,"value":"processedData = await processDataFromCSV(data);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":352,"value":"filteredData = applyFilters(processedData, {\n accidentType: selectedAccidentType,\n weatherCodes: selectedWeatherCodes,\n startDate: totalStartDate.toJSDate(),\n endDate: totalEndDate.toJSDate(),\n booleanFilters: selectedBooleanFilters,\n});","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":574,"value":"filteredDataGeoJSON = geoJSONfromDataset(filteredData)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":570,"value":"function geoJSONfromDataset(processedData) {\n const features = processedData\n .map((entry) => {\n const lat = parseFloat(entry.lat);\n const lng = parseFloat(entry.lng);\n \n if (isNaN(lat) || isNaN(lng) || lat < -90 || lat > 90 || lng < -180 || lng > 180) {\n console.warn(`Invalid coordinates: lat=${lat}, lng=${lng}`);\n return null;\n }\n return {\n type: \"Feature\",\n geometry: {\n type: \"Point\",\n coordinates: [lng, lat],\n },\n properties: { ...entry, }\n }\n })\n // Filter out null values from the map step\n .filter((feature) => feature !== null);\n \n return {\n type: \"FeatureCollection\",\n features: features,\n };\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":619,"value":"function getLatLngsFromDataset(processedData) {\n return processedData\n .filter((entry) => entry.lat && entry.lng)\n .map((entry) => {\n const lat = parseFloat(entry.lat);\n const lng = parseFloat(entry.lng);\n \n if (isNaN(lat) || isNaN(lng) || lat < -90 || lat > 90 || lng < -180 || lng > 180) {\n console.warn(`Invalid coordinates: lat=${lat}, lng=${lng}`);\n return null;\n }\n\n return [lat, lng];\n })\n // Filter out null values from the map step\n .filter((feature) => feature !== null);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":166,"value":"#### Helpers for Imports","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":28,"value":"// Ripped from @visnup/xml-to-json\nfunction domToJSON(node) {\n let obj = Object.create(null);\n if (node.children.length === 0 && node.innerHTML) {\n obj.content = node.innerHTML;\n }\n\n const counts = childCounts(node);\n\n for (const child of node.children) {\n const { localName } = child;\n if (counts[localName] > 1) {\n (obj[localName] = obj[localName] || []).push(domToJSON(child));\n } else {\n obj[localName] = domToJSON(child);\n }\n }\n\n let attrs = node.attributes;\n if (attrs) {\n for (let i = attrs.length - 1; i >= 0; i--) {\n obj[attrs[i].name] = attrs[i].value;\n }\n }\n\n return obj;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"childCounts = (node) => {\n const counts = {};\n for (const {localName} of node.children)\n counts[localName] = (counts[localName] || 0) + 1;\n return counts;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"xmlToJSON = (src) => domToJSON(parser.parseFromString(src, \"application/xml\"))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":71,"value":"async function fetchAllData(url) {\n let allEntries = []; // To store all entries\n let nextUrl = url; // Start with the initial URL\n\n while (nextUrl) {\n const response = await fetch(nextUrl).then((res) => res.text());\n const jsonData = xmlToJSON(response); // Convert XML to JSON\n const currentEntries = jsonData.feed.entry;\n\n allEntries = allEntries.concat(currentEntries); // Add current entries to the list\n\n // Check for the 'next' link in the response\n let links = jsonData.feed.link || [];\n if (!Array.isArray(links)) {\n links = [links]; // Convert to an array if it's a single object\n }\n const nextLink = links.find((link) => link.rel === \"next\");\n nextUrl = nextLink ? nextLink.href : null; // Get the URL for the next page, if it exists\n\n }\n\n return allEntries;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":168,"value":"### Schemas and Data Processing","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":109,"value":"$4b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":515,"value":"$4c","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":251,"value":"// This dataset stores boolean values as \"Yes\", \"No\", true, false and empty, so this function simplifies to booleans.\nfunction simplifyBooleanValue(value) {\n if (value.toLowerCase() == \"no\" || value.toLowerCase() == \"false\") {\n return false;\n } else if (value.toLowerCase() == \"yes\" || value.toLowerCase() == \"true\") {\n return true;\n } else {\n return false;\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":791,"value":"### Helper functions for data processing","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":335,"value":"minDate = d3.min(processedData, d => d.incident_date)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":345,"value":"maxDate = d3.max(processedData, d => d.incident_date)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":356,"value":"uniqueAccidentTypes = [...new Set(processedData.map(entry => entry.accident_type)) ].sort()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":393,"value":"uniqueCollisionTypes = [...new Set(processedData.map(entry => entry.collision_type))].sort()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":395,"value":"uniqueWeatherCodes = [...new Set(processedData.flatMap(entry => entry.weather_code))].sort()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":401,"value":"uniqueLightConditions = [...new Set(processedData.map(entry => entry.light_conditions))].sort()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":445,"value":"totalStartDate = DateTime.fromJSDate(startDate).startOf(\"day\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":447,"value":"totalEndDate = DateTime.fromJSDate(endDate).endOf(\"day\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":793,"value":"fatalitiesInFilteredDataset = filteredData.filter(entry => entry.involves_fatality)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":801,"value":"duiInFilteredDataset = filteredData.filter(entry => (entry.involves_drugs || entry.involves_alcohol))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":806,"value":"injuriesInFilteredDataset = filteredData.filter(entry => (entry.accident_type == \"Suspected Minor Injury\" || entry.accident_type == \"Suspected Major Injury\"))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":409,"value":"$4d","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":126,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":96,"value":"## Debug Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":128,"value":"Because nothing ever goes right :(","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":131,"value":"### Schema Inspection","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":637,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":639,"value":"## Not in use","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":199,"value":"pointMap = {\n const container = yield htl.html`

`;\n const map = L.map(container).setView([35.1, -85.2], 11);\n let osmLayer = L.tileLayer('https://{s}.basemaps.cartocdn.com/light_all/{z}/{x}/{y}@2x.png', {\n attribution: '© OpenStreetMap contributors'\n }).addTo(map);\n\n // Add points as a geoJSON layer\n L.geoJSON(filteredDataGeoJSON, {\n pointToLayer: (feature, latlng) => {\n return L.circleMarker(latlng, {\n radius: 5,\n fillColor: \"red\",\n color: \"white\",\n weight: 1,\n opacity: 1,\n fillOpacity: 0.8\n });\n },\n onEachFeature: (feature, layer) => {\n // Popup\n layer.bindPopup(`\n Coordinates: ${feature.geometry.coordinates.join(\", \")}
\n Accident Type: ${feature.properties.accident_type || \"N/A\"}
\n Date: ${feature.properties.incident_date || \"N/A\"}\n `);\n }\n }).addTo(map);\n\n return map;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":613,"value":"clusterMap = {\n const container = yield htl.html`

`;\n const map = L.map(container).setView([35.1, -85.2], 11);\n let osmLayer = L.tileLayer('https://{s}.basemaps.cartocdn.com/light_all/{z}/{x}/{y}@2x.png', {\n attribution: '© OpenStreetMap contributors'\n }).addTo(map);\n const geoJSONData = geoJSONfromDataset(filteredData);\n\n // Cluster markers\n const markers = L.markerClusterGroup()\n\n L.geoJSON(geoJSONData, {\n pointToLayer: (feature, latlng) => L.marker(latlng),\n onEachFeature: (feature, layer) => {\n layer.bindPopup(`\n Coordinates: ${feature.geometry.coordinates.join(\", \")}
\n Accident Type: ${feature.properties.accident_type || \"N/A\"}
\n Date: ${feature.properties.incident_date || \"N/A\"}\n `);\n },\n }).addTo(markers);\n\n markers.addTo(map);\n\n return map;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":242,"value":"processedData","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"}],"files":"$W4e","stdlib":"1"}} 47:"$46:body"