29:null 2a:["$","title",null,{"children":"A5.2 Static Viz | Columbia Dataviz | Observable"}] 2f:T26e8,map7 = { const container = yield htl.html`

`; const map = L.map(container, { minZoom: 14.5, maxZoom: 17.5, }); map.setView([40.80794694447276, -73.96214143872722], 16); L.tileLayer('https://{s}.basemaps.cartocdn.com/light_all/{z}/{x}/{y}@2x.png', { attribution: '© OpenStreetMap contributors' }).addTo(map); var phoneIcon = L.icon({ iconUrl: "https://cdn0.iconfinder.com/data/icons/map-locations-and-tourism/512/47-512.png", //iconUrl: FileAttachment("telephone.png").url(), iconSize: [21.12, 24.42], // size of the icon iconAnchor: [16, 37], // point of the icon which will correspond to marker's location popupAnchor: [-3, -30] // point from which the popup should open relative to the iconAnchor }); var gaurdIcon = L.icon({ iconUrl: "https://static.thenounproject.com/png/63811-200.png", //iconUrl: FileAttachment("telephone.png").url(), iconSize: [32, 37], // size of the icon iconAnchor: [16, 37], // point of the icon which will correspond to marker's location popupAnchor: [-3, -50] // point from which the popup should open relative to the iconAnchor }); L.geoJSON(columbia_university, { onEachFeature: function(feature, layer) { if (feature.properties && feature.properties.name) { layer.bindPopup(feature.properties.name); } } }).addTo(map); L.geoJSON(columbia_call_boxes, { onEachFeature: function(feature, layer) { L.marker([feature.geometry.coordinates[1],feature.geometry.coordinates[0]], {icon: phoneIcon}).addTo(map); } }) const crimeLayer = L.layerGroup().addTo(map); $: if (options2) { crimeLayer.clearLayers(); // Clear previous layers // Filter Clery crime data const filteredCleryData = data.filter(d => options2.includes(d.filterCat)); let finalFilteredCleryData = filteredCleryData; // Presume no time filter needed initially // Filter Campus crime data let filteredCampusCrimes = campusCrimes.filter(d => options2.includes(d.filterCat)); let finalFilteredCampusCrimes = filteredCampusCrimes; // Presume no time filter needed initially // Apply time filter only if both startTime and endTime are set if (startTime1 != null && endTime1 != null) { finalFilteredCleryData = filteredCleryData.filter(d => { const crimeTime = getHourFromTimeString(d.TIME); return crimeTime >= startTime1 && crimeTime <= endTime1; }); finalFilteredCampusCrimes = filteredCampusCrimes.filter(d => { const crimeTime = getHourFromTimeString(d.CMPLNT_FR_TM); return crimeTime >= startTime1 && crimeTime <= endTime1; }); } finalFilteredCleryData.forEach(d => {if (!isNaN(d.LATITUDE) && !isNaN(d.LONGITUDE)) { const color = colorScheme(d.filterCat); const jitterFactorOne = Math.random()*0.000154 const jitterFactorTwo = Math.random()*0.000154 const polygon = L.polygon([ [d.LATITUDE - 0.00015 + jitterFactorOne, d.LONGITUDE + jitterFactorTwo], [d.LATITUDE + jitterFactorOne, d.LONGITUDE - 0.000077 + jitterFactorTwo], [d.LATITUDE + jitterFactorOne, d.LONGITUDE + 0.000077 + jitterFactorTwo] ], { fillColor: color, color: color, weight: 1, opacity: 1, fillOpacity: 1 }).addTo(crimeLayer); L.circle([d.LATITUDE + 0.00001 + jitterFactorOne, d.LONGITUDE + jitterFactorTwo], { radius: 6.52, fillColor: color, color: color, weight: 1, opacity: 1, fillOpacity: 1 }).addTo(crimeLayer).bindPopup(`Description: ${d.DESCRIPTION}`).bindTooltip(`Clery Crime: ${d.CRIME}
Date: ${d.TIME.substring(0, d.TIME.indexOf(" "))}
Time: ${d.TIME.substring(d.TIME.indexOf(" "), d.TIME.length)}`); } }); finalFilteredCampusCrimes.forEach(d => {if (!isNaN(d.Latitude) && !isNaN(d.Longitude)) { const color = colorScheme(d.filterCat); const jitterFactorOne = Math.random()*0.000924 const jitterFactorTwo = Math.random()*0.000924 L.rectangle([ [parseFloat(d.Latitude) - 0.0000385 + jitterFactorOne, parseFloat(d.Longitude) - 0.0000385 + jitterFactorTwo], [parseFloat(d.Latitude) + 0.0000385 + jitterFactorOne, parseFloat(d.Longitude) + 0.0000385 + jitterFactorTwo] ], { fillColor: color, color: color, weight: 1, opacity: .5, fillOpacity: .5 }).addTo(crimeLayer).bindTooltip(`NYPD Crime: ${d.OFNS_DESC}
Date: ${d.CMPLNT_FR_DT}
Time: ${d.CMPLNT_FR_TM}`); } }); } // add each line manually so it has a set name var route = worseroute; var latlngs = []; for(const point of route) { latlngs.push([point.A,point.B]); } var worserouteLine = L.polyline(latlngs, { color: "purple", weight: 4, opacity: 0 }); worserouteLine.addTo(map).on('mouseover', function(e) { var layer = e.target; layer.setStyle({ weight: 6 })}).on('mouseout',function(e) { var layer = e.target; layer.setStyle({ weight: 4 }) }); route = routeSample; var latlngs = []; for(const point of route) { latlngs.push([point.A,point.B]); } var routeSampleLine = L.polyline(latlngs, { color: "purple", weight: 4, opacity: 0 }); routeSampleLine.addTo(map).on('mouseover', function(e) { var layer = e.target; layer.setStyle({ weight: 6 })}).on('mouseout',function(e) { var layer = e.target; layer.setStyle({ weight: 4 }) }); route = TCBroad; var latlngs = []; for(const point of route) { latlngs.push([point.A,point.B]); } var TCBroadLine = L.polyline(latlngs, { color: "purple", weight: 4, opacity: 0 }); TCBroadLine.addTo(map).on('mouseover', function(e) { var layer = e.target; layer.setStyle({ weight: 6 })}).on('mouseout',function(e) { var layer = e.target; layer.setStyle({ weight: 4 }) }); route = TCAm; var latlngs = []; for(const point of route) { latlngs.push([point.A,point.B]); } var TCAmLine = L.polyline(latlngs, { color: "purple", weight: 4, opacity: 0 }); TCAmLine.addTo(map).on('mouseover', function(e) { var layer = e.target; layer.setStyle({ weight: 6 })}).on('mouseout',function(e) { var layer = e.target; layer.setStyle({ weight: 4 }) }); if(paths=="Barnard to SIPA via 120th") { worserouteLine.setStyle({ opacity: 1 }); } else if(paths=="Barnard to SIPA via College Walk") { routeSampleLine.setStyle({ opacity: 1 }); } else if(paths=="Butler to TC via Broadway") { TCBroadLine.setStyle({ opacity: 1 }); } else if(paths== "Butler to TC via Amsterdam") { TCAmLine.setStyle({ opacity: 1 }); } var legend = L.control({position: 'topleft'}); legend.onAdd = function (map) { var div = L.DomUtil.create('div', 'info legend'); // set white background div.style.backgroundColor = 'white'; div.style.padding = '10px'; div.innerHTML += '

Legend

'; // Add the image and label to the legend div.innerHTML += '

Call Booth'+ '
'; // Add NYPD crime data div.innerHTML += '

' + '

' + 'NYPD Crime Incident' + '

'; // Add Clery Crime Data div.innerHTML += '

' + '' + ' Clery Crime Incidents' + '

'; // Add route to map div.innerHTML += '

' + '' + ' Route' + '

'; // Add color codes for (var i = 1; i < (crimes.length+1); i++) { //div.innerHTML += //' ' + crimes[i-1] + '
'; div.innerHTML += '

' + crimes[i-1] + '
'; } return div; }; legend.addTo(map); return container; } 30:T1308,// snake code L.Polyline.include({ // Hi-res timestamp indicating when the last calculations for vertices and // distance took place. _snakingTimestamp: 0, // How many rings and vertices we've already visited // Yeah, yeah, "rings" semantically only apply to polygons, but L.Polyline // internally uses that nomenclature. _snakingRings: 0, _snakingVertices: 0, // Distance to draw (in screen pixels) since the last vertex _snakingDistance: 0, // Flag _snaking: false, /// TODO: accept a 'map' parameter, fall back to addTo() in case /// performance.now is not available. snakeIn: function(){ if (this._snaking) { return; } if ( !('performance' in window) || !('now' in window.performance) || !this._map) { return; } this._snaking = true; this._snakingTime = performance.now(); this._snakingVertices = this._snakingRings = this._snakingDistance = 0; if (!this._snakeLatLngs) { this._snakeLatLngs = L.LineUtil.isFlat(this._latlngs) ? [ this._latlngs ] : this._latlngs ; } // Init with just the first (0th) vertex in a new ring // Twice because the first thing that this._snake is is chop the head. this._latlngs = [[ this._snakeLatLngs[0][0], this._snakeLatLngs[0][0] ]]; this._update(); this._snake(); this.fire('snakestart'); return this; }, _snake: function(){ var now = performance.now(); var diff = now - this._snakingTime; // In milliseconds var forward = diff * this.options.snakingSpeed / 1000; // In pixels this._snakingTime = now; // Chop the head from the previous frame this._latlngs[ this._snakingRings ].pop(); return this._snakeForward(forward); }, _snakeForward: function(forward) { // If polyline has been removed from the map stop _snakeForward if (!this._map) return; // Calculate distance from current vertex to next vertex var currPoint = this._map.latLngToContainerPoint( this._snakeLatLngs[ this._snakingRings ][ this._snakingVertices ]); var nextPoint = this._map.latLngToContainerPoint( this._snakeLatLngs[ this._snakingRings ][ this._snakingVertices + 1 ]); var distance = currPoint.distanceTo(nextPoint); // console.log('Distance to next point:', distance, '; Now at: ', this._snakingDistance, '; Must travel forward:', forward); // console.log('Vertices: ', this._latlngs); if (this._snakingDistance + forward > distance) { // Jump to next vertex this._snakingVertices++; this._latlngs[ this._snakingRings ].push( this._snakeLatLngs[ this._snakingRings ][ this._snakingVertices ] ); if (this._snakingVertices >= this._snakeLatLngs[ this._snakingRings ].length - 1 ) { if (this._snakingRings >= this._snakeLatLngs.length - 1 ) { return this._snakeEnd(); } else { this._snakingVertices = 0; this._snakingRings++; this._latlngs[ this._snakingRings ] = [ this._snakeLatLngs[ this._snakingRings ][ this._snakingVertices ] ]; } } this._snakingDistance -= distance; return this._snakeForward(forward); } this._snakingDistance += forward; var percent = this._snakingDistance / distance; var headPoint = nextPoint.multiplyBy(percent).add( currPoint.multiplyBy( 1 - percent ) ); // Put a new head in place. var headLatLng = this._map.containerPointToLatLng(headPoint); this._latlngs[ this._snakingRings ].push(headLatLng); this.setLatLngs(this._latlngs); this.fire('snake'); L.Util.requestAnimFrame(this._snake, this); }, _snakeEnd: function() { this.setLatLngs(this._snakeLatLngs); this._snaking = false; this.fire('snakeend'); } }); L.Polyline.mergeOptions({ snakingSpeed: 200 // In pixels/sec }); L.LayerGroup.include({ _snakingLayers: [], _snakingLayersDone: 0, snakeIn: function() { if ( !('performance' in window) || !('now' in window.performance) || !this._map || this._snaking) { return; } this._snaking = true; this._snakingLayers = []; this._snakingLayersDone = 0; var keys = Object.keys(this._layers); for (var i in keys) { var key = keys[i]; this._snakingLayers.push(this._layers[key]); } this.clearLayers(); this.fire('snakestart'); return this._snakeNext(); }, _snakeNext: function() { if (this._snakingLayersDone >= this._snakingLayers.length) { this.fire('snakeend'); this._snaking = false; return; } var currentLayer = this._snakingLayers[this._snakingLayersDone]; this._snakingLayersDone++; this.addLayer(currentLayer); if ('snakeIn' in currentLayer) { currentLayer.once('snakeend', function(){ setTimeout(this._snakeNext.bind(this), this.options.snakingPause); }, this); currentLayer.snakeIn(); } else { setTimeout(this._snakeNext.bind(this), this.options.snakingPause); } this.fire('snake'); return this; } }); L.LayerGroup.mergeOptions({ snakingPause: 200 });31:T42e,update_demo = { var width = 500, height = 400; var dataset = count; var xScale = d3.scaleBand() .domain(d3.range(dataset.length)) .rangeRound([0, width]) .padding(0.05); var yScale = d3.scaleLinear() .domain([0, d3.max(dataset)]) .range([0, height]); const svg = d3.select(DOM.svg(width, height)); svg.selectAll("rect") .data(dataset) .enter().append("rect") .attr("x", (d, i) => xScale(i)) .attr("y", d => height - yScale(d)) .attr("width", xScale.bandwidth()) .attr("height", d => yScale(d)) .attr("fill", "steelblue"); // This function is called by the cell that waits for the button click event svg.node().update = () => { // Update all rects with newly generated random values svg.selectAll("rect") .data(dataset.map(x => Math.random()*25)) .transition() // this and next 2 lines: optional animation .duration(800) .ease(d3.easeLinear) .attr("y", d => height - yScale(d)) .attr("height", d => yScale(d)); }; return svg.node(); }32:[{"id":"629e73bf5ec6c0de1d4d2aaf2575b8ef935246a788c92920d397da0b1ed794d04b3c59e6b51cc1dd884916374e7a457c5976c21f7f1f4a65715804c495e19ce6","href":"https://static.observableusercontent.com/files/629e73bf5ec6c0de1d4d2aaf2575b8ef935246a788c92920d397da0b1ed794d04b3c59e6b51cc1dd884916374e7a457c5976c21f7f1f4a65715804c495e19ce6","name":"WorseRoute.csv","type":"text/csv","lastModified":1715130380332.844,"size":146},{"id":"3ab3dd0a612c87af9dd8a36bfd7c590b1fc50c271ded7c81e9da11db1fa19cb5d939573435a6c8f66c3733eeb24dac1d484b634db237b686cce815cc951b767f","href":"https://static.observableusercontent.com/files/3ab3dd0a612c87af9dd8a36bfd7c590b1fc50c271ded7c81e9da11db1fa19cb5d939573435a6c8f66c3733eeb24dac1d484b634db237b686cce815cc951b767f","name":"CleryNewCats.csv","type":"text/csv","lastModified":1715130380332.844,"size":37797},{"id":"7cbe43dc67252e480db085019cf0d7f2cecda9f45c6c63418a99cb9f6b47dd7baf2497e0b82b5e30a25b099704d67f6ad6468773dfde174166d904876198f308","href":"https://static.observableusercontent.com/files/7cbe43dc67252e480db085019cf0d7f2cecda9f45c6c63418a99cb9f6b47dd7baf2497e0b82b5e30a25b099704d67f6ad6468773dfde174166d904876198f308","name":"ManhattanCrimesCampusRegion@1.csv","type":"text/csv","lastModified":1715130380332.844,"size":3223079},{"id":"27865eedd812bf517a04ab57deb5bb4f136bea39fa87ff9d0fb01f52db1613bb4b3e06c0c7606fc31c06868d02fbc14bfc18a2e57850d7987e3a006b8bda1d60","href":"https://static.observableusercontent.com/files/27865eedd812bf517a04ab57deb5bb4f136bea39fa87ff9d0fb01f52db1613bb4b3e06c0c7606fc31c06868d02fbc14bfc18a2e57850d7987e3a006b8bda1d60","name":"Columbia_Call_Boxes.geojson","type":"application/geo+json","lastModified":1715130380332.844,"size":3135},{"id":"2cdc7ec2878b231f0d84dd8066fce4bc1be6f53a3cbc037c4d22caec778d4750fea67d6cb84afa06972015b00947814771747dddb718e0c02f7bc5abaf4679af","href":"https://static.observableusercontent.com/files/2cdc7ec2878b231f0d84dd8066fce4bc1be6f53a3cbc037c4d22caec778d4750fea67d6cb84afa06972015b00947814771747dddb718e0c02f7bc5abaf4679af","name":"ManhattanCrimes.csv","type":"text/csv","lastModified":1715130380332.844,"size":43665010},{"id":"27018f416aac334f2bc70d68af4645b9e23b476ef4f0d35352a3419c712b0a07fd2843ab73b1861081d7a35bfc44ea9ba38d80558961b1bcc9875d3fc63c14e4","href":"https://static.observableusercontent.com/files/27018f416aac334f2bc70d68af4645b9e23b476ef4f0d35352a3419c712b0a07fd2843ab73b1861081d7a35bfc44ea9ba38d80558961b1bcc9875d3fc63c14e4","name":"ManhattanCrimesSmall.csv","type":"text/csv","lastModified":1715130380332.844,"size":4061},{"id":"e520361ad6470f9904c4af0c04201315e4eda865c51201360d741a6ee1a5712a5f2ca60179faa7edbc64e932b759840d89107a05eca1343c3fb3125c27e5b7fe","href":"https://static.observableusercontent.com/files/e520361ad6470f9904c4af0c04201315e4eda865c51201360d741a6ee1a5712a5f2ca60179faa7edbc64e932b759840d89107a05eca1343c3fb3125c27e5b7fe","name":"RouteSample.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1715130380332.844,"size":4847},{"id":"cbf818774f65e8e010bed490c752ff41235519d1f221b6551266b1c2acb3883829248c7441b775c93c5737c0283d8f5349452a677bf28d0eccda38de0061ee83","href":"https://static.observableusercontent.com/files/cbf818774f65e8e010bed490c752ff41235519d1f221b6551266b1c2acb3883829248c7441b775c93c5737c0283d8f5349452a677bf28d0eccda38de0061ee83","name":"Columbia_University.geojson","type":"application/geo+json","lastModified":1715130380332.844,"size":43346},{"id":"d092451f078f23beaf5b6a4d132b4220f1009c7e34cf095668635c7fce23421981e8acfd24554aeb9e9324bed67bb718dcc708bbf2da59be49685d0a8e31aa64","href":"https://static.observableusercontent.com/files/d092451f078f23beaf5b6a4d132b4220f1009c7e34cf095668635c7fce23421981e8acfd24554aeb9e9324bed67bb718dcc708bbf2da59be49685d0a8e31aa64","name":"routeTCAm@2.csv","type":"text/csv","lastModified":1715130380332.844,"size":239},{"id":"ee25df1c0923db68e139b3c8fe0c6bbe191f1df1db3fe40a8ab5d13d3b6d55e0f0d80a995ab7844fcba2f1cdeb331e7ba5360ad4b034bc0f189ef8a00dd1d46e","href":"https://static.observableusercontent.com/files/ee25df1c0923db68e139b3c8fe0c6bbe191f1df1db3fe40a8ab5d13d3b6d55e0f0d80a995ab7844fcba2f1cdeb331e7ba5360ad4b034bc0f189ef8a00dd1d46e","name":"routeTCBroad@2.csv","type":"text/csv","lastModified":1715130380332.844,"size":263},{"id":"887129689249f9d8406e7a2972c429bd0b11e9ca378faff2e30bd4e3428e10862ba9517ae41c0aa8aee6e2f2b17606d9684aff23d4fac44334aec2ec1f1f1442","href":"https://static.observableusercontent.com/files/887129689249f9d8406e7a2972c429bd0b11e9ca378faff2e30bd4e3428e10862ba9517ae41c0aa8aee6e2f2b17606d9684aff23d4fac44334aec2ec1f1f1442","name":"CrimeTypesCount - count.csv","type":"text/csv","lastModified":1715146145589.876,"size":278}] 2d:{"id":"eded893e6a1ba7f8","slug":null,"title":"A5.2 Static Viz","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2024-05-08T01:06:20.332Z","update_time":"$D2024-05-08T05:38:38.753Z","view_time":null,"first_public_time":"$D2024-05-08T01:06:20.332Z","fork":{"id":"466ecaaf9a8b7cb7","slug":null,"title":"A5.2 Static Viz","owner":{"id":"7a615336d5b186de","login":"columbia-dataviz","name":"Columbia Dataviz "}},"stars":0,"starred":false,"owner":{"type":"team","id":"7a615336d5b186de","login":"columbia-dataviz","name":"Columbia Dataviz ","avatar_url":"https://avatars-next.observableusercontent.com/bef00fdd2fde3755f8d242e6a6dd04e4535ae9d634d372ec959928e1d95fd9dc","tier":"pro_2024"},"version":883,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"f50110918d7a899f","login":"dalia-etessami","name":"Dalia Etessami","avatar_url":"https://avatars-next.observableusercontent.com/95347916fcfc0a23112a778d52a8775650c033a0749d237b629299b63cca2c89","tier":null}],"members":[{"type":"team","id":"7a615336d5b186de","login":"columbia-dataviz","name":"Columbia Dataviz ","avatar_url":"https://avatars-next.observableusercontent.com/bef00fdd2fde3755f8d242e6a6dd04e4535ae9d634d372ec959928e1d95fd9dc","tier":"pro_2024","role":"editor"},{"type":"individual","id":"f50110918d7a899f","login":"dalia-etessami","name":"Dalia Etessami","avatar_url":"https://avatars-next.observableusercontent.com/95347916fcfc0a23112a778d52a8775650c033a0749d237b629299b63cca2c89","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"A5.2 Static Viz","cells":[{"id":0,"value":"# A5.2
Static Viz","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":303,"value":"safetyQ = md`What does safety mean to you? (Select from the options below)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":306,"value":"viewof options3 = {\n const form = htl.html``;\n\n // This function updates the selections when either checkbox changes state.\n form.onchange = (event) => {\n selectedOptions = Array.from(form.querySelectorAll('input:checked')).map(el => el.value);\n };\n\n // Initialize selectedOptions with the current selections.\n let selectedOptions = Array.from(form.querySelectorAll('input:checked')).map(el => el.value);\n\n return form;\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":318,"value":"text = md`What time range you are interested in?`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":817,"value":"import {interval} from '@mootari/range-slider'","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":821,"value":"viewof time = interval([0, 24], {\n step: 1,\n value: [18, 23],\n label: 'Time Range',\n description: 'Choose a range of time to view crimes. Time counted as military time.',\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":826,"value":"startTime1 = time[0]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":840,"value":"endTime1 = time[1]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":324,"value":"timeChoice = md`

Selected Start Time: ${time[0]}:00, Selected End Time: ${time[1]}:00

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":309,"value":"textTwo = md`What does danger mean to you? (Select the crime categories that you consider dangerous)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":313,"value":"viewof options2 = {\n let selectedOptions = [];\n const checkboxState = Inputs.checkbox(crimes);\n checkboxState.addEventListener(\"change\", (event) => {\n selectedOptions = Array.from(checkboxState.querySelectorAll('input:checked')).map(el => el.value);\n return selectedOptions; // Ensure the selected options are returned for reactivity\n });\n\n return checkboxState;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":484,"value":"viewof paths = Inputs.select([\"Select a Route\",\"Barnard to SIPA via 120th\",\"Barnard to SIPA via College Walk\",\"Butler to TC via Amsterdam\",\"Butler to TC via Broadway\"], {multiple: false, label: \"Vizualize Routes\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":328,"value":"$2f","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":333,"value":"function normalizeCrimeType(crime) {\n if (crime === \"Attempted Robbery\") {\n return \"robbery\";\n } else if (crime === \"Motorcycle Theft\") {\n return \"motor vehicle theft\";\n } else if (crime === \"Burglary Pattern\") {\n return \"burglary\";\n } else {\n return crime; // Lowercase to match against the `options2` array\n }\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":399,"value":"function getHourFromTimeString(timeString) {\n const [time, meridian] = timeString.split(' ');\n let [hours, minutes] = time.split(':');\n hours = parseInt(hours, 10) + (meridian && meridian.toLowerCase() === 'pm' && hours !== '12' ? 12 : 0);\n hours = hours % 24; // Correct for midnight being '12:00 AM'\n return hours;\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":39,"value":"turf = require('https://npmcdn.com/@turf/turf/turf.min.js')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":32,"value":"html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":104,"value":"\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":244,"value":"workbook = FileAttachment(\"RouteSample.xlsx\").xlsx()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":246,"value":"routeSample = workbook.sheet(0, {\n headers: false,\n // range: \"A1:J10\"\n })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":241,"value":"worseroute = await FileAttachment(\"WorseRoute.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":500,"value":"TCBroad = FileAttachment(\"routeTCBroad@2.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":498,"value":"TCAm = FileAttachment(\"routeTCAm@2.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":55,"value":"","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"CleryNewCats.csv"},{"id":17,"value":"data = await FileAttachment(\"CleryNewCats.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":117,"value":"crimes = [\"Theft and Property Crimes\",\"Violent and Sex Crimes\",\"Fraud and Financial Crimes\",\"Drug and Substance-Related Crimes\",\"Miscellaneous Crimes\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":141,"value":"selectedData = data.map(function(element){\n const crime = element[\"CRIME\"];\n for (let i = 0; i index !== 1 && index !== 11);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":167,"value":"colorList = [\"#4e79a7\",\"#f28e2c\",\"#e15759\",\"#76b7b2\",\"#59a14f\",\"#edc949\",\"#af7aa1\",\"#ff9da7\",\"#9c755f\",\"#bab0ab\", \"#d16f9b\", \"#6f6dc7\"];","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":148,"value":"colorScheme = d3.scaleOrdinal(crimes, adjustedColorList);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":393,"value":"columbia_university.features = columbia_university.features.map(feature => {\n if (feature.geometry.type === \"Point\") {\n // Destructure the coordinates for easier access\n const [longitude, latitude] = feature.geometry.coordinates;\n // Define the size of the square, e.g., 0.0001 degrees which is roughly 11m\n const size = 0.0001;\n // Create a square polygon around the point\n feature.geometry = {\n type: \"Polygon\",\n // Define the square as an array of points (the last point should close the square by repeating the first point)\n coordinates: [[\n [longitude - size, latitude - size],\n [longitude - size, latitude + size],\n [longitude + size, latitude + size],\n [longitude + size, latitude - size],\n [longitude - size, latitude - size] // closing the polygon by repeating the first point\n ]]\n };\n // Keep the properties the same\n feature.properties = {...feature.properties};\n }\n return feature; // Return the updated feature\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":106,"value":"columbia_university = FileAttachment(\"Columbia_University.geojson\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":227,"value":"const timeInputContainer = document.createElement('div');\ntimeInputContainer.style.marginBottom = '10px'; // Add some space below the inputs\n\nconst startTimeInput = document.createElement('input');\nstartTimeInput.type = 'time';\nstartTimeInput.id = 'startTime';\nstartTimeInput.style.marginRight = '5px'; // Add some space between the inputs\n\nconst endTimeInput = document.createElement('input');\nendTimeInput.type = 'time';\nendTimeInput.id = 'endTime';\n\ntimeInputContainer.appendChild(startTimeInput);\ntimeInputContainer.appendChild(endTimeInput);\ncontainer.parentNode.insertBefore(timeInputContainer, container); // Insert the time inputs above the map container\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":250,"value":"columbia_call_boxes = FileAttachment(\"Columbia_Call_Boxes.geojson\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":261,"value":"smallCrimeData = FileAttachment(\"ManhattanCrimesSmall.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":259,"value":"cityCrimeData = FileAttachment(\"ManhattanCrimes.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":578,"value":"$30","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":268,"value":"campusCrimes = FileAttachment(\"ManhattanCrimesCampusRegion@1.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":856,"value":"count = await FileAttachment(\"CrimeTypesCount - count.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":862,"value":"Plot.plot({\n color: {\n legend: true\n },\n marks: [\n Plot.auto(count, {x: \"Type of Crime\", y: \"NYC Data\", color: \"Type of Crime\"})\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":875,"value":"viewof update_btn = Inputs.Button(\"update data values\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":879,"value":"$31","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":877,"value":"Inputs = require(\"@observablehq/inputs@0.7.8/dist/inputs.umd.min.js\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W32","stdlib":"1","titling":"auto"}} 2e:"$2d:body"