31:T587, **[Green The Bid](https://www.greenthebid.earth/)**’s Global Production Map is designed to provide some insight into the sustainability options available in various international production markets. Green The Bid’s desire is that productions use this tool at the planning and bidding stage for a snapshot of the sustainability profile of every country they are considering for the shoot. In doing so, environmental costs become a factor to be weighed alongside creative, budget and logistical considerations. Using survey information provided by over 40 production houses worldwide (so far), we collaborated with **[Scope3](https://www.scope3.com/)** to create a map that shows a quick overview of sustainability in each market with a detailed elaboration below. Multiple locations can be compared simultaneously across the key areas of sustainable practices including EV charging availability, non-meat food options, the availability of renewable electricity sources, and hydration options. Below is a quick key to explain the data included: Each country’s resources are rated on a scale of one to three, with three being the highest/best sustainability rating. 1 = ⬤ ◯ ◯
2 = ⬤ ⬤ ◯
3 = ⬤ ⬤ ⬤ Details are listed below and include, for example, hard to recycle materials, breakdowns of grid energy sources, and lists of hydration options available in each selected region.32:Tc06,viewof summaryTable = Inputs.table(newData, { rows: 50, columns: ["country", "catering", "energy", "transport", "waste", "water"], header: { country: "Country", catering: "Catering", energy: "Grid Energy", transport: "Transport", waste: "Waste", water: "Water" }, format: { country: (x) => htl.html`${x}`, catering: (x) => htl.html`

${_.range(x[0].score).map( (item) => htl.html`⬤ ` )}${_.range(3 - x[0].score).map( (item) => htl.html`◯ ` )}
${x[0].text}

${ x[1].data ? htl.html`⚠ ${x[1].text}` : htl.html` ` }

`, energy: (x) => htl.html`

${ x[0].data ? htl.html`★ ${x[0].text}` : htl.html`⬤ Fossil Fuel Only` }

`, transport: (x) => htl.html`

${_.range(x[2].score).map( (item) => htl.html`⬤ ` )}${_.range(3 - x[2].score).map( (item) => htl.html`◯ ` )}
${x[2].text}

${_.range(x[1].score).map( (item) => htl.html`⬤ ` )}${_.range(3 - x[1].score).map( (item) => htl.html`◯ ` )}
${x[1].text}

`, waste: (x) => htl.html`

${_.range(x[0].score).map( (item) => htl.html`⬤ ` )}${_.range(3 - x[0].score).map( (item) => htl.html`◯ ` )}
${x[0].text}

${htl.html`⚠ Hardest to recycle items`}
${htl.html`

- ${item}

`, water: (x) => htl.html`

${_.range(x[0].score).map( (item) => htl.html`⬤ ` )}${_.range(3 - x[0].score).map( (item) => htl.html`◯ ` )}
${x[0].text}

` }, width: { Country: 80, ev_charging_location: 180, ev_charging_sound_stage: 200 }, align: { imps_percentile: "left", gco2pm_percentile: "left", perf_percentile: "left" } })33:T470,viewof cateringTable = Inputs.table( catering.filter((obj) => selCountries.includes(obj.Country)), { rows: 50, columns: ["Country", "preordering", "catering", "serveware", "leftover"], header: { Country: "Country", preordering: "Preordering Meals", catering: "Catering Available", serveware: "Serve-ware Options", leftover: "Leftover Usage" }, format: { preordering: (x) => x === "Yes" ? htl.html`

${x}

` : x, catering: (x) => htl.html`

- ${item}

`, serveware: (x) => htl.html`

- ${item}

`, leftover: (x) => htl.html`

- ${item}

` }, width: { Country: 100, preordering: 180 }, align: { imps_percentile: "left", gco2pm_percentile: "left", perf_percentile: "left" } } )34:T5c0,viewof energyTable = Inputs.table( energy.filter((obj) => selCountries.includes(obj.Country)), { rows: 50, columns: [ "Country", "power", "energySource", "ev_charging_location", "ev_charging_sound_stage" ], header: { Country: "Country", power: "Power Source", energySource: "Energy Source", ev_charging_location: "EV Charging at Location", ev_charging_sound_stage: "EV Charging at Sound Stages" }, format: { power: (x) => htl.html`

- ${item}

`, energySource: (x) => htl.html`

- ${item}

`, ev_charging_location: (x) => x > 3 ? htl.html`

${x}

` : x < 3 ? htl.html`

${x}

` : x, ev_charging_sound_stage: (x) => x > 3 ? htl.html`

${x}

` : x < 3 ? htl.html`

${x}

` : x }, width: { Country: 100, ev_charging_location: 240, ev_charging_sound_stage: 280 }, align: { imps_percentile: "left", gco2pm_percentile: "left", perf_percentile: "left" } } )35:T4ed,viewof wasteTable = Inputs.table( waste.filter((obj) => selCountries.includes(obj.Country)), { rows: 50, columns: [ "Country", "utilities", "waste_separation", "recycle_in_market", "difficult_recycle" ], header: { Country: "Country", utilities: "Public recycling utilities availabile", waste_separation: "Waste separation available", recycle_in_market: "Recyclable items in market", difficult_recycle: "Difficult to recycle" }, format: { utilities: (x) => htl.html`

- ${item}

`, waste_separation: (x) => htl.html`

- ${item}

`, recycle_in_market: (x) => htl.html`

- ${item}

`, difficult_recycle: (x) => htl.html`

- ${item}

` }, width: { Country: 100, utilities: 310, waste_separation: 270, recycle_in_market: 270 }, align: { Country: "left" } } )36:Tb39,newData = selCountries.map((obj) => { console.log(obj); const cateringArr = [ { id: "catering", text: "Catering Options", data: catering .filter((item) => item.Country === obj)[0] .catering.split(", ") || "", score: Score( catering.filter((item) => item.Country === obj)[0].catering.split(", ") .length ) }, { id: "landfill", text: "Leftover to Landfill", data: catering .filter((item) => item.Country === obj)[0] .leftover.toLowerCase() .includes("landfill") } ]; const energyArr = [ { id: "energy", text: "Includes Renewables", data: energy .filter((item) => item.Country === obj)[0] .energySource.toLowerCase() .includes("renewable") } ]; const transportArr = [ { id: "energy", text: "Electric Available", data: transport .filter((item) => item.Country === obj)[0] .energy_source.toLowerCase() .includes("electric") }, { id: "ev_location", text: "EV Charging Location Availability", data: energy.filter((item) => item.Country === obj)[0] .ev_charging_location, score: energy.filter((item) => item.Country === obj)[0].ev_charging_location < 3 ? 1 : energy.filter((item) => item.Country === obj)[0] .ev_charging_location === 3 ? 2 : 3 }, { id: "transport", text: "Alternative Transport Solutions", data: transport .filter((item) => item.Country === obj)[0] .minimize_transport.split(", "), score: Score( transport .filter((item) => item.Country === obj)[0] .minimize_transport.split(", ").length ) } ]; const wasteArr = [ { id: "recycle_items", text: "Recycling", data: waste .filter((item) => item.Country === obj)[0] .recycle_in_market.split(", "), score: Score( waste .filter((item) => item.Country === obj)[0] .recycle_in_market.split(", ").length ) }, { id: "recycle_items", text: "Recycling Difficulty", data: waste .filter((item) => item.Country === obj)[0] .difficult_recycle.split(", ") } ]; const waterArr = [ { id: "water", text: "Sustainable Water Options", data: water .filter((item) => item.Country === obj)[0] .water_offerings.split(", "), score: Score( water .filter((item) => item.Country === obj)[0] .water_offerings.split(", ").length ) } ]; return { country: obj, catering: cateringArr, energy: energyArr, transport: transportArr, waste: wasteArr, water: waterArr }; })37:[{"id":"f4afb2d49f0b38843f6d74521b33d41f371246e1acd674ed78016dca816cb1d262b7c54b95d395a4dad7fba5d58ed19db2944698360d19483399c79565806794","href":"https://static.observableusercontent.com/files/f4afb2d49f0b38843f6d74521b33d41f371246e1acd674ed78016dca816cb1d262b7c54b95d395a4dad7fba5d58ed19db2944698360d19483399c79565806794","name":"countries-50m.json","type":"application/json","lastModified":1690791170713.143,"size":756420},{"id":"1905ee75856c09a74e5ed59b022ccd28721b716fb6d3c198e18b29fd99d556b8f7e6cfa98ef123d18f38727e212d12d60e2091d4fd97cefe89d0d9ee9303cde5","href":"https://static.observableusercontent.com/files/1905ee75856c09a74e5ed59b022ccd28721b716fb6d3c198e18b29fd99d556b8f7e6cfa98ef123d18f38727e212d12d60e2091d4fd97cefe89d0d9ee9303cde5","name":"transposedGTB.csv","type":"text/csv","lastModified":1690880850717.898,"size":20180},{"id":"4efd671660a4eef3d44e4d92c21086026b26892340508372f1a53af18e04b172b649c983458a694e3792ac92c19cab0c5c3dc09afc961d973c4df7825807d3f6","href":"https://static.observableusercontent.com/files/4efd671660a4eef3d44e4d92c21086026b26892340508372f1a53af18e04b172b649c983458a694e3792ac92c19cab0c5c3dc09afc961d973c4df7825807d3f6","name":"water_layer.csv","type":"text/csv","lastModified":1691600787800.526,"size":3231},{"id":"f42c8e820913ff5c14189b416deb51363956381246d5dcf1c82b9a77303a40927c9b111a28cc5f2ec042df87d823524a1162a0ed4f0bbf2731fcd53858b0bc58","href":"https://static.observableusercontent.com/files/f42c8e820913ff5c14189b416deb51363956381246d5dcf1c82b9a77303a40927c9b111a28cc5f2ec042df87d823524a1162a0ed4f0bbf2731fcd53858b0bc58","name":"waste_layer.csv","type":"text/csv","lastModified":1691600771772.644,"size":5512},{"id":"4b93ded702fddbe2fcf17700dba6218562c5eef1203306968d5a393b65cb5dcac948ac6f09b4a72b49aacdc0d2da29953d21d205c97f02f1a88732f1ed51947f","href":"https://static.observableusercontent.com/files/4b93ded702fddbe2fcf17700dba6218562c5eef1203306968d5a393b65cb5dcac948ac6f09b4a72b49aacdc0d2da29953d21d205c97f02f1a88732f1ed51947f","name":"transport_layer.csv","type":"text/csv","lastModified":1691600759680.646,"size":2450},{"id":"972790bc570868d4fc7f4779e6c18df9fed4d2495a85a3bde4db8eb299ac3843fd332d2f69c56616ef5bdfd18fabb8d6d65a7e80c9857a7b91070b5bab02cd51","href":"https://static.observableusercontent.com/files/972790bc570868d4fc7f4779e6c18df9fed4d2495a85a3bde4db8eb299ac3843fd332d2f69c56616ef5bdfd18fabb8d6d65a7e80c9857a7b91070b5bab02cd51","name":"energy_layer.csv","type":"text/csv","lastModified":1691600746206.268,"size":2909},{"id":"f005aad6eeccf15871d066c890468f9c2f586de00511be0ab6cba327744837bf7fc6390746990137ce393d05cc567b3fa8d9dc2d81cbb750590ffb9412d59aa0","href":"https://static.observableusercontent.com/files/f005aad6eeccf15871d066c890468f9c2f586de00511be0ab6cba327744837bf7fc6390746990137ce393d05cc567b3fa8d9dc2d81cbb750590ffb9412d59aa0","name":"catering_layer.csv","type":"text/csv","lastModified":1691600733117.138,"size":6901}] 2f:{"title":"Creative Production: Global Sustainability Map","cells":[{"id":0,"value":"# Creative Production: Global Sustainability Map\n##### Powered by Green The Bid","pinned":false,"hidden":false,"mode":"md"},{"id":602,"value":"$31","pinned":false,"hidden":false,"mode":"md"},{"id":11,"value":"Plot.plot({\n projection: \"equal-earth\",\n width,\n height: width / 2,\n // color: {\n // scheme: \"YlGnBu\",\n // unknown: \"#ccc\",\n // label: \"Healthy life expectancy (years)\",\n // legend: true\n // },\n marks: [\n Plot.sphere({ fill: \"white\", stroke: \"darkgrey\" }),\n Plot.geo(countries, {\n fill: (d) =>\n selCountries.includes(d.properties.name)\n ? \"green\"\n : availCountries.includes(d.properties.name)\n ? \"#333\"\n : \"lightgrey\"\n }),\n Plot.geo(countrymesh, { stroke: \"white\" })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":59,"value":"viewof selCountries = multiAutoSelect({\n width,\n options: availCountries,\n placeholder: \"Select some countries\",\n value: [\"Italy\", \"Turkey\", \"South Africa\"],\n label: \"\"\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":607,"value":"Note: This is a beta version of the map as it currently has a limited number of responses in each market (in some instances only one production company respondent per market). We are keen to work with Green The Bid’s many global members to continue to build out the dataset to be as comprehensive as possible, so that it reflects the current capacity for sustainable production in each of the markets, with the ability to be updated as markets are able to respond to more sustainable production needs and demand.","pinned":false,"hidden":false,"mode":"html"},{"id":316,"value":"$32","pinned":false,"hidden":false,"mode":"ojs"},{"id":401,"value":"---\n# In Depth","pinned":false,"hidden":false,"mode":"md"},{"id":185,"value":"## Catering","pinned":false,"hidden":false,"mode":"md"},{"id":93,"value":"$33","pinned":false,"hidden":false,"mode":"ojs"},{"id":210,"value":"## Energy","pinned":false,"hidden":false,"mode":"md"},{"id":205,"value":"$34","pinned":false,"hidden":false,"mode":"ojs"},{"id":236,"value":"## Transport","pinned":false,"hidden":false,"mode":"md"},{"id":229,"value":"viewof transportTable = Inputs.table(\n transport.filter((obj) => selCountries.includes(obj.Country)),\n {\n rows: 50,\n columns: [\"Country\", \"energy_source\", \"minimize_transport\"],\n header: {\n Country: \"Country\",\n energy_source: \"Main Energy Sources\",\n minimize_transport: \"Measures used to minimize transport to set\"\n },\n format: {\n energy_source: (x) =>\n htl.html`

- ${item}

`,\n minimize_transport: (x) =>\n htl.html`

- ${item}

`\n },\n width: {\n Country: 100\n },\n align: {\n Country: \"left\"\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":257,"value":"## Waste","pinned":false,"hidden":false,"mode":"md"},{"id":244,"value":"$35","pinned":false,"hidden":false,"mode":"ojs"},{"id":259,"value":"## Water ","pinned":false,"hidden":false,"mode":"md"},{"id":572,"value":"viewof waterTable = Inputs.table(\n water.filter((obj) => selCountries.includes(obj.Country)),\n {\n rows: 50,\n columns: [\"Country\", \"water_offerings\"],\n header: {\n Country: \"Country\",\n water_offerings: \"Main Energy Sources\"\n },\n format: {\n water_offerings: (x) =>\n htl.html`

- ${item}

`\n },\n width: {\n Country: 100\n },\n align: {\n Country: \"left\"\n }\n }\n)","pinned":false,"hidden":false,"mode":"ojs"},{"id":7,"value":"
\n
\n
\n
\n
\n
\n
\n
\n
\n
","pinned":false,"hidden":false,"mode":"html"},{"id":5,"value":"### Data","pinned":false,"hidden":false,"mode":"md"},{"id":13,"value":"world = FileAttachment(\"countries-50m.json\").json()","pinned":false,"hidden":false,"mode":"ojs"},{"id":16,"value":"countries = topojson.feature(world, world.objects.countries)","pinned":false,"hidden":false,"mode":"ojs"},{"id":19,"value":"countrymesh = topojson.mesh(world, world.objects.countries, (a, b) => a !== b)","pinned":false,"hidden":false,"mode":"ojs"},{"id":465,"value":"// defining a scoring function\nfunction Score(length) {\n if (length === 0) {\n return 0;\n } else if (length < 2) {\n return 1;\n } else if (length < 4) {\n return 2;\n } else {\n return 3;\n }\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":287,"value":"$36","pinned":false,"hidden":false,"mode":"ojs"},{"id":122,"value":"transposedgtb = await FileAttachment(\"transposedGTB.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":32,"value":"catering = await FileAttachment(\"catering_layer.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":195,"value":"energy = await FileAttachment(\"energy_layer.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":198,"value":"transport = await FileAttachment(\"transport_layer.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":200,"value":"waste = await FileAttachment(\"waste_layer.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":202,"value":"water = await FileAttachment(\"water_layer.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":47,"value":"availCountries = catering.map((obj) => {\n if (obj.Country === \"UK\") {\n return \"United Kingdom\";\n } else if (obj.Country === \"UAE\") {\n return \"United Arab Emirates\";\n } else if (obj.Country === \"Czech Republic\") {\n return \"Czechia\";\n } else if (obj.Country === \"Phillipines\") {\n return \"Philippines\";\n } else {\n return obj.Country;\n }\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":51,"value":"### Imports","pinned":false,"hidden":false,"mode":"md"},{"id":53,"value":"import { multiAutoSelect } from \"@john-guerra/multi-auto-select\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":382,"value":"_ = require(\"lodash@4\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":416,"value":"import { style as faStyle, fa } from \"@airbornemint/fontawesome\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":578,"value":"function getFlagEmoji(countryCode) {\n const codePoints = countryCode\n .toUpperCase()\n .split(\"\")\n .map((char) => 127397 + char.charCodeAt());\n return String.fromCodePoint(...codePoints);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":424,"value":"faStyle({ regular: true, solid: true, brands: true })","pinned":false,"hidden":false,"mode":"ojs"},{"id":486,"value":"","pinned":false,"hidden":false,"mode":"html"}],"files":"$W37","stdlib":"1","titling":"auto"}