Skip to content

Latest commit

 

History

History
55 lines (37 loc) · 2.35 KB

UPDATING.md

File metadata and controls

55 lines (37 loc) · 2.35 KB
Raw

Updating data

Change update date

In index.html, change the text to the last updated date.

Adding new regions

  1. Open the file data/regions.json
  2. Add the new regions:
  • Use Google Search to find the coordinates
  • Look for the flag on wikipedia, copy the URL of the SVG image, it must star with https://upload.wikimedia.org/ and end with .svg

Region carbon footprint

The carbon data comes from the officially published GCP carbon data on GitHub

To update to the latest yearly data:

  1. Make sure the new yearly data is present in a new .csv file in the official repo
  2. Update index.js to point at this new CSV file.

Prices

Prices are currently based on the SKUs for Google Compute Engine E2 Instance Core.

To update to the latest pricing data:

  1. Open the Cloud Console
  2. Click Billing > Pricing
  3. Select "View all SKUs"
  4. Filter the table with:
  • Service ID:6F81-5844-456A
  • Product taxonomy:GCP > Compute > GCE > VMs On Demand > Cores: Per Core
  • SKU Description:E2 Instance Core
  1. Display the column Geo taxonomy regions.
  2. Select the table using your mouse, copy the selection. (Do not try to use the Download icon, it doesn't download the currently displayed data)
  3. Create a new Google Sheet, and paste the selection.
  4. Manually copy all prices into data/prices.json

TODO: instead of manually copying prices, export the sheet as CSV and parse the CSV (issue)

Alternatively, get the Google Compute Engine E2 Core prices from the documentation.

Countries

The list of countries and their coordinates is taken from this page, converted to JSON using this online tool.

Products