Skip to content

Instantly share code, notes, and snippets.

Remote taxi data

Get the total monthly dollar amount for each month of 2023

SELECT 
  DATE_TRUNC('month', tpep_pickup_datetime::TIMESTAMP) AS pickup_month, 
  SUM(total_amount) as daily_total
FROM 
  nyc_taxi.taxi_single

On gradient.style, state is stored in the URL. Using this to have a closer look and borrow ideas.

https://gradient.style/#type=linear&space=oklab&linear_named_angle=to+right&linear_angle=90&stops=%7B%22kind%22%3A%22stop%22%2C%22color%22%3A%22oklch%2870%25+0.5+340%29%22%2C%22auto%22%3A%220%22%2C%22position1%22%3A%220%22%2C%22position2%22%3A%220%22%7D&stops=%7B%22kind%22%3A%22hint%22%2C%22auto%22%3A%2250%22%2C%22percentage%22%3A%2250%22%7D&stops=%7B%22kind%22%3A%22stop%22%2C%22color%22%3A%22oklch%2890%25+0.5+200%29%22%2C%22auto%22%3A%22100%22%2C%22position1%22%3A%22100%22%2C%22position2%22%3A%22100%22%7D
{
    "ancestorOrigins": {},
    "href": "https://gradient.style/#type=linear&space=oklab&linear_named_angle=to+right&linear_angle=90&stops=%7B%22kind%22%3A%22stop%22%2C%22color%22%3A%22oklch%2870%25+0.5+340%29%22%2C%22auto%22%3A%220%22%2C%22position1%22%3A%220%22%2C%22position2%22%3A%220%22%7D&stops=%7B%22kind%22%3A%22hint%22%2C%22auto%22%3A%2250%22%2C%22percentage%22%3A%2250%22%7D&stops=%7B%22ki

Steps Taken When Moving a Repo from Bitbucket to GitHub

  1. Created new repo via GH UI
  2. Changed remote URL of local repo from Bitbucket to GH, pushed to GH
git remote set-url origin [email protected]:Vergil-Inc/app-web.git
git push -u origin master
  1. Created new main branch in GH UI
const CATCH_ALL_ERR_MSG =
"We weren’t able to determine what the error was based on the server response.";
/**
* window.fetch does not throw an error for common HTTP errors; 404, 503, etc.
* Here we check its `ok` key to determine if there's n HTTP error.
* If so, throw an error so any users can `catch`.
*
* @param {Object} res - A Response object from fetch
*/

Issues when upgrading to MacOS Catalina 10.15

TL;DR: Uninstall the homebrew version of cocoapods, use the gem version instead

1. pod install failed

Error message was:

/usr/local/bin/pod: /usr/local/Cellar/cocoapods/1.8.4/libexec/bin/pod: /System/Library/Frameworks/Ruby.framework/Versions/2.3/usr/bin/ruby: bad interpreter: No such file or directory
/usr/local/bin/pod: line 2: /usr/local/Cellar/cocoapods/1.8.4/libexec/bin/pod: Undefined error: 0

Migrating tylergaw.com to Netlify

1. Deploy repo via Netlify dashboard

2. Set up with a spare domain to test redirects and subdomains before switching the primary domain

  • Add your favorite places to the map
  • Improve the map by filling in missing details
  • Rack up tokens as you discover new places
  • Compete with others for weekly jackpots

Map Style Creation Log

  • Start with a blank style. Why? Starting blank helps us include only the necessities. Every layer should have a clear purpose to help users accomplish a goal.
  • Set the color of the background layer. Why? So we don't have blanks on the map
  • Upload svg images uses as markers in symbol layers (specific to StreetCred's use)
  • Add a basic building block. Water. Available in the Mapbox Streets data source, water.

What do you need, to be able to see where you are?

  • Add something bright to lead the way. Parks. Available in the Mapbox Streets data source, landuse

Custom Locations Good for Testing the StreetCred App

StreetCred:

  • Lat: 40.705344401119035
  • Lon: -74.0130703901454

Lower Fidi 1:

  • Lat: 40.70678
  • Lon: -74.011651

Example of a MainApplication.java multidex app

This goes together with the reset of the steps in https://developer.android.com/studio/build/multidex.html

This is our MainApplication.java without all the third party packages we import and use.

The key things are to import the class:

import android.support.multidex.MultiDexApplication;