2b:null 2c:["$","title",null,{"children":"Poultry Processing Consolidation | Dylan | Observable"}] 31:T9d4,corpDeckGL = { const COLORS = { cargill: [245, 66, 66, 100], two_plant: [237, 218, 7, 100], three_plant: [7, 237, 103, 100], four_plant: [7, 168, 237, 100], plant_color: [255,255,255], farmColor: [140, 3, 252] } // container.innerHTML = ''; const mapLayer = new deck.GeoJsonLayer({ data: stateCorpMonopsony, pickable: true, getFillColor: function(dataRow) { switch(dataRow.properties.parent_corporation){ case "Cargill": return COLORS.cargill case 2: return COLORS.two_plant case 3: return COLORS.three_plant case 4: return COLORS.four_plant default: return [140,140,140] } } }) const plantLayer = new deck.IconLayer({ id: 'icon-layer', data: poultryPlants, iconAtlas: 'https://raw.githubusercontent.com/visgl/deck.gl-data/master/website/icon-atlas.png', iconMapping: { marker: {x: 0, y: 0, width: 128, height: 128, mask: true} }, getIcon: d => 'marker', getPosition: d => d.geometry.coordinates, getSize: d => 35, getColor: d => COLORS.plant_color, pickable: true, onHover }) const farmLayer = new deck.IconLayer({ id: 'icon-layer', data: filteredFarms, pickable: true, iconAtlas: 'https://raw.githubusercontent.com/visgl/deck.gl-data/master/website/icon-atlas.png', iconMapping: { marker: {x: 0, y: 0, width: 128, height: 128, mask: true} }, getIcon: d => 'marker', getPosition: d => d.geometry.coordinates, getSize: d => 15, getColor: d => COLORS.farmColor }) return new deck.DeckGL({ // The HTML container to render into container: container, // Mapbox settings // set `map: false` to turn off Mapbox base map map: mapboxgl, // This token is for demo-purpose only and rotated regularly. Get your token at https://www.mapbox.com mapboxApiAccessToken: 'pk.eyJ1IjoidWJlcmRhdGEiLCJhIjoiY2pudzRtaWloMDAzcTN2bzN1aXdxZHB5bSJ9.2bkj3IiRC8wj3jLThvDGdA', mapStyle: 'mapbox://styles/mapbox/dark-v9', // Viewport settings longitude: -90.9712, latitude: 40.7831, zoom: 3.5, pitch: 0, bearing: -0, pickingRadius: 200, layers: [ mapLayer, plantLayer, farmLayer ], // this doesn't work? controller: true, getTooltip: ({object}) => object && object.properties["Parent Corporation"] }) }32:T7cf,deckgl = { const mapLayer = new deck.GeoJsonLayer({ data: filteredAreas, pickable: true, getFillColor: function(dataRow) { return COLORS[dataRow.properties.plant_access] } }) const plantLayer = new deck.IconLayer({ id: 'icon-layer', data: poultryPlants, pickable: true, iconAtlas: 'https://raw.githubusercontent.com/visgl/deck.gl-data/master/website/icon-atlas.png', iconMapping: { marker: {x: 0, y: 0, width: 128, height: 128, mask: true} }, getIcon: d => 'marker', getPosition: d => d.geometry.coordinates, getSize: d => 35, getColor: d => COLORS.plant_color }) const farmLayer = new deck.IconLayer({ id: 'icon-layer', data: filteredFarms, pickable: true, iconAtlas: 'https://raw.githubusercontent.com/visgl/deck.gl-data/master/website/icon-atlas.png', iconMapping: { marker: {x: 0, y: 0, width: 128, height: 128, mask: true} }, getIcon: d => 'marker', getPosition: d => d.geometry.coordinates, getSize: d => 15, getColor: d => COLORS.farmColor }) return new deck.DeckGL({ // The HTML container to render into container: container, // Mapbox settings // set `map: false` to turn off Mapbox base map map: mapboxgl, // This token is for demo-purpose only and rotated regularly. Get your token at https://www.mapbox.com mapboxApiAccessToken: 'pk.eyJ1IjoidWJlcmRhdGEiLCJhIjoiY2pudzRtaWloMDAzcTN2bzN1aXdxZHB5bSJ9.2bkj3IiRC8wj3jLThvDGdA', mapStyle: 'mapbox://styles/mapbox/dark-v9', // Viewport settings longitude: currentLatLonZoom.longitude, latitude: currentLatLonZoom.latitude, zoom: currentLatLonZoom.zoom, pitch: 0, bearing: -0, layers: [ mapLayer, plantLayer, farmLayer ], // this doesn't work? controller: true, getTooltip: ({object}) => object && object.properties["Parent Corporation"] }) }33:[{"id":"ecfee664d96a36c3d714d3739303b49bc55f1cef4af1a682b06de23d3d6cc450de9dd1ec16de3a6edfdbc996f80855cb22dc067c3a9329ae530907eba97bb767","href":"https://static.observableusercontent.com/files/ecfee664d96a36c3d714d3739303b49bc55f1cef4af1a682b06de23d3d6cc450de9dd1ec16de3a6edfdbc996f80855cb22dc067c3a9329ae530907eba97bb767","name":"all_states@3.geojson","type":"application/geo+json","lastModified":1686080910659.293,"size":1802657},{"id":"c18f0d00c208d5dfedaa4d2b14d28332f4a636c71ecf497250ec5878c29055ba9aaa1bb934e6bc5d8d2b45a5bcae417126d45e3a6eafc55d01dc0e0118caba69","href":"https://static.observableusercontent.com/files/c18f0d00c208d5dfedaa4d2b14d28332f4a636c71ecf497250ec5878c29055ba9aaa1bb934e6bc5d8d2b45a5bcae417126d45e3a6eafc55d01dc0e0118caba69","name":"poultry_plants_with_sales@1.csv","type":"text/csv","lastModified":1686080910659.293,"size":28439},{"id":"09a30526c40bb0dd596b53278fcedb2feb9cb57f9981d3e131e2c17d1cb9839f71ad4ba881273b8e7e7b17f3c2dd5d59d5a8cb7f47761311676fbcb698c0b253","href":"https://static.observableusercontent.com/files/09a30526c40bb0dd596b53278fcedb2feb9cb57f9981d3e131e2c17d1cb9839f71ad4ba881273b8e7e7b17f3c2dd5d59d5a8cb7f47761311676fbcb698c0b253","name":"counterglow_geojson@1.geojson","type":"application/geo+json","lastModified":1686080910659.293,"size":537116},{"id":"dd784726d39792c1968efd5152a78656a7daa705d8cebffea82431ff0a246262ff7a5dbd2d8c6f2043b6c044c196b674699733bc19c0641b80b85ce174d17778","href":"https://static.observableusercontent.com/files/dd784726d39792c1968efd5152a78656a7daa705d8cebffea82431ff0a246262ff7a5dbd2d8c6f2043b6c044c196b674699733bc19c0641b80b85ce174d17778","name":"all_states_with_parent_corp@1.geojson","type":"application/geo+json","lastModified":1686080910659.293,"size":1234270}] 2f:{"id":"8e27e610ae867071","slug":null,"title":"Poultry Processing Consolidation","thumbnail":"7d7b7203a5e8607dbf000e649160fa9d97f31f200a6279e9ae4c87f1bd829038","access_level":"public","create_time":"$D2023-06-06T19:48:30.659Z","update_time":"$D2023-06-06T20:04:31.102Z","view_time":null,"first_public_time":"$D2023-06-06T19:48:30.659Z","has_unpublished_edits":null,"fork":{"id":"44a2b375d2323057","slug":null,"title":"Poultry Processing Consolidation","owner":{"id":"1030259fb8673e79","login":"rafi-usa","name":"RAFI-USA"}},"stars":0,"starred":false,"owner":{"type":"team","id":"02a75d28143bf487","login":"nofurtherinformation","name":"Dylan","avatar_url":"https://avatars-next.observableusercontent.com/a494170e1e25c8f92f54468c30fecf4bcf81095a7268e37af8e633e7fd8d22ba","tier":"starter_2024"},"version":707,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"54c23d6cacd69e20","login":"nofurtherinformation","name":"Dylan","avatar_url":"https://avatars-next.observableusercontent.com/a494170e1e25c8f92f54468c30fecf4bcf81095a7268e37af8e633e7fd8d22ba","tier":null}],"members":[{"type":"individual","id":"54c23d6cacd69e20","login":"nofurtherinformation","name":"Dylan","avatar_url":"https://avatars-next.observableusercontent.com/a494170e1e25c8f92f54468c30fecf4bcf81095a7268e37af8e633e7fd8d22ba","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Poultry Processing Consolidation","cells":[{"id":0,"value":"# Poultry Processing Consolidation","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":99,"value":"viewof selectedStates = Inputs.checkbox(allState, {label: \"Selected States\", value: allState})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":510,"value":"Select the states you wish to visualize in the menu above.\n\nLegend:\n- White markers indicate poultry processing plants\n- Red area indicates access to only one poultry processing plant\n- Yellow area indicates access to two poultry processing plants\n- Green area indicates access to three poultry processing plants\n- Blue area indicates access to 4+ poultry processing plants\n\nThe Herfindahl-Hirschman Index (HHI) and percent of area captured are dynamically calculated for all of the selected states.\n\nThe sales table displays the aggregate sales by parent corporation (per 2022 Infogroup) in the selected area.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":41,"value":"container = html `

\n ${Object.entries(COLORS).map(([key, {label,color}]) => html`

\n${label}

`)}\n

`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":649,"value":"coporations = [\n 'Pepsi',\n 'Not Pepsi',\n 'Not Pepsi 2',\n 'Not Pepsi 3',\n 'Not Pepsi 4',\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":644,"value":"numCorporations = coporations.length","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":636,"value":"colors = colorbrewer.Set3[numCorporations]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":647,"value":"colorPalette = coporations.map((corp, i) => ({\n label: corp,\n color: colors[i]\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":632,"value":"COLORS","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":656,"value":"turf = require('@turf/turf')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":666,"value":"currentGeojson = ({\n type: \"FeatureCollection\",\n features: filteredAreas\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":663,"value":"bbox = turf.bbox(currentGeojson)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":671,"value":"width = container.getBoundingClientRect().width","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":679,"value":"height = container.getBoundingClientRect().height","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":683,"value":"fittedViewport = new deck.WebMercatorViewport({width, height})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":687,"value":"currentLatLonZoom = fittedViewport.fitBounds([[bbox[2],bbox[3]],[bbox[0],bbox[1]]], {width, height})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":582,"value":"tooltip = container.querySelector(\"#tooltip\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":571,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":578,"value":"onHover = {\n return function(info) {\n const {x, y, object} = info;\n console.log(x,y,object)\n if (object) {\n tooltip.style.top = `${y}px`;\n tooltip.style.left = `${x}px`;\n tooltip.innerHTML = `\n

Average Property Value

\n \n `;\n } else { \n tooltip.innerHTML = '';\n }\n };\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":602,"value":"html `\n\n(Stylesheets)`","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":476,"value":"calculatedHHI = {\n let totalSales = Object.values(companySalesFiltered).reduce((acc,val) => acc + val)\n return Object.values(companySalesFiltered).reduce((acc, val) => acc + Math.pow(val * 100/totalSales,2),0)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"Inputs.table(calculatedData)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":557,"value":"Inputs.table(farmCountFiltered)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":493,"value":"Inputs.table(companySalesTable)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":425,"value":"#### Calculate Data Based Upon Map Filtering","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":406,"value":"companySalesFiltered = {\n // build dictionary for each company in the area\n let companySales = {}\n for (let i=0; i < allCompanies.length; i++) {\n companySales[allCompanies[i]] = 0\n }\n\n for (let i=0; i < filteredPlants.length; i++) {\n let salesVolume = filteredPlants[i].properties[\"Sales Volume (Location)\"]\n if (!Number.isNaN(salesVolume)) {\n companySales[filteredPlants[i].properties[\"Parent Corporation\"]] += salesVolume\n }\n }\n\n // filter NaN values and return dictionary\n return Object.entries(companySales).reduce((filtered, [key, value]) => {\n if (!Number.isNaN(value)) {\n filtered[key] = value\n }\n return filtered\n }, {})\n} ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":488,"value":"companySalesTable = {\n return Object.entries(companySalesFiltered).map(([company, sales]) => ({company, sales}))\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":551,"value":"farmCountFiltered = {\n // build dictionary for each company in the area\n let farmCounts = {\n 1: 0,\n 2: 0,\n 3: 0,\n 4: 0\n }\n\n let totalFarms = filteredFarms.length\n \n for (let i=0; i < totalFarms; i++) {\n farmCounts[filteredFarms[i].properties.plant_access] += 1\n }\n\n let percentCaptured = {}\n \n Object.keys(farmCounts).forEach(key => {\n percentCaptured[key] = farmCounts[key]/totalFarms\n })\n\n let farmsTable = Object.entries(percentCaptured).map(([plantAccess, percentFarms]) => ({plantAccess, percentFarms}))\n\n return farmsTable\n} ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":565,"value":"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":126,"value":"calculatedData = {\n let areas = {\n 1: 0,\n 2: 0,\n 3: 0,\n 4: 0\n }\n\n for (let i=0; i < filteredAreas.length; i++) {\n areas[filteredAreas[i].properties.plant_access] += filteredAreas[i].properties.area\n }\n\n let totalArea = Object.values(areas).reduce((acc, val) => acc + val, 0)\n\n let percentArea = {}\n Object.keys(areas).forEach(key => {\n percentArea[key] = areas[key]/totalArea\n })\n\n let areasTable = Object.entries(percentArea).map(([plantAccess, percentArea]) => ({plantAccess, percentArea}))\n\n return areasTable\n} ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":422,"value":"#### Build DeckGL Map","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":611,"value":" COLORS = ({\n 1:{color: [245, 66, 66, 100], label: 'One Plant'},\n 2:{color: [237, 218, 7, 100], label: 'Two Plant'},\n 3:{color: [7, 237, 103, 100], label: 'etc'},\n 4:{color: [7, 168, 237, 100], label: 'etc'},\n plant_color:{color: [255,255,255,255], label: 'Plant'},\n farmColor:{color: [140, 3, 252,255], label: 'Farm'}\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"$32","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":525,"value":"// tooltip experiment\n\n/*\ndeckTooltip = new deck.DeckGL({\n canvas: 'deck-canvas',\n initialViewState: {longitude: -122.45, latitude: 37.78, zoom: 12},\n controller: true,\n layers: [\n new deck.layers.ScatterplotLayer({\n data: [\n {position: [-122.45, 37.78], message: 'Hover over me'}\n ],\n getPosition: d => d.position,\n getRadius: 1000,\n getFillColor: [255, 255, 0],\n // Enable picking\n pickable: true\n })\n ],\n getTooltip: ({object}) => object && object.message\n});\n*/","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":431,"value":"### Load and Filter State Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":346,"value":"stateMonopsony = FileAttachment(\"all_states@3.geojson\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":263,"value":"filteredAreas = stateMonopsony.features.filter(\n row => {\n if (selectedStates.includes(row.properties.state)) {\n return true\n } else { \n return false\n }\n })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":"allState = stateMonopsony.features.map(feature => feature.properties.state).filter((value, index, array) => array.indexOf(value) === index) ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":433,"value":"allCompanies = filteredPlants.map(plant => plant.properties[\"Parent Corporation\"]).filter((value, index, array) => array.indexOf(value) === index)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":417,"value":"#### Load Packages","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":638,"value":"colorbrewer = require('colorbrewer') ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"mapboxgl = require('mapbox-gl@~0.50.0/dist/mapbox-gl.js')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"d3 = require('d3')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"deck = require('deck.gl@6.2.3/deckgl.min.js')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":146,"value":"geo = require(\"geotoolbox@latest\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":411,"value":"#### Load Plants Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":391,"value":"poultry_plants_with_sales = await FileAttachment(\"poultry_plants_with_sales@1.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"poultry_plants_with_sales","database":"$undefined"},{"id":397,"value":"plantsGeoSales = geo.coords2geo(poultry_plants_with_sales, { lat: \"latitude\", lng: \"longitude\" })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":189,"value":"poultryPlants = plantsGeoSales.features.filter(\n row => {\n if (row.properties[\"Animals Processed\"] === \"Chicken\" && row.properties.Size === \"Large\") {\n return true\n }\n else {\n return false\n }\n }\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":435,"value":"filteredPlants = poultryPlants.filter(\n row => {\n if (selectedStates.includes(row.properties.State)) {\n return true\n } else { \n return false\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":541,"value":"farms = FileAttachment(\"counterglow_geojson@1.geojson\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":545,"value":"filteredFarms = farms.features.filter(\n row => {\n if (selectedStates.includes(row.properties.state)) {\n return true\n } else { \n return false\n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":568,"value":"stateCorpMonopsony = FileAttachment(\"all_states_with_parent_corp@1.geojson\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 30:"$2f:body"