Skip to content

Instantly share code, notes, and snippets.

SOURCE SOURCE MATCHED
CREATE IS STREET TEAM ENUM
Vehicles table
CREATE TYPE FEEDBACK_TYPE as ENUM ('Positive','Neutral','Negative','Suggestion','From Partner');
CREATE TYPE STREET_TEAM_STATUS as ENUM ('Prospect',' Pending', 'Skip', 'Confirmed');
CREATE TABLE regions(
id SERIAL PRIMARY KEY,
region_name VARCHAR(255)
);
<!DOCTYPE html><html><head><meta charset="utf-8"><meta name="viewport" content="width=device-width, initial-scale=1"><style>body {
max-width: 980px;
border: 1px solid #ddd;
outline: 1300px solid #fff;
margin: 16px auto;
}
body .markdown-body
{
padding: 45px;

Background

Influx of new users of emergency food services.

  • One in three NYC households have lost a job in the last few months.
  • Food Pantries are reporting record numbers of new clients.
  • As stimulus funding runs out, more and more people will need to turn to emergency food.

Lots of resource collection and need mapping, but poor user experience.

##
# Host Database
#
# localhost is used to configure the loopback interface
# when the system is booting. Do not change this entry.
##
127.0.0.1 localhost
255.255.255.255 broadcasthost
::1 localhost
fe80::1%lo0 localhost

Lemontree is hiring a Product Manager

Tl;dr Lemontree, a new kind of startup non-profit, seeks a change-making Product Manager to help us solve big problems of all kinds.

Family Dinner Matters

At Lemontree, we sell family dinner. We believe in the power of sitting down together for a home cooked meal. We understand the magic of saying “here I made this” and connecting with loved ones.

Our product helps the more than a million moms, dads and kids across New York struggling with hunger set the table with pride and possibility. Every week, we deliver everything our customers need to create an amazing dinner for just three dollars a plate.

Lemontree needs your software chops to help us serve dinner

Background

👋 We're Lemontree, a new kind of non-profit that sells family dinner.

Every day, we show up at work and help low-income parents set the table with fresh produce and pride.

Our product looks like most meal-kits with everything a mom or dad needs to cook a delicious meal for just $2 per serving.

We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 18 columns, instead of 1 in line 9.
Name,Package size,Unit,Storage,Name + Unit,Default Supplier,Storage,Measured,Single Item Weight,Item Buffer,Conversion Factor,Supplier Unit,Notes,,Durability,,Conversions,
Acorn Squash,1,Whole,Dry,Acorn Squash - Whole,Rbest,Dry,Whole, ,0.25,1,Whole,,,3 - Durable,,1,Cup
Apple,1,Whole,Dry,Apple - Whole,Rbest,Dry,Whole, ,0.25,1,Whole,,,2 - Regular,,,
Avocado,1,Whole,Refrigerated,Avocado - Whole,Riviera,Refrigerated,Whole, ,0.15,1,Whole,Order PRO-Ripe,,1 - Fragile,,,
BBQ Sauce (12 g),1,Packet,Dry,BBQ Sauce (12 g) - Packet,Driscoll,Dry,Whole, ,0.15,1,Packet,,,,,,
Beef Broth (14.5 oz),1,Can,Dry,Beef Broth (14.5 oz) - Can,Driscoll,Dry,Whole, ,0.15,1,Can,,,,,,
Black Beans (15.50 oz),1,Can,Dry,Black Beans (15.50 oz) - Can,Driscoll,Dry,Whole, ,0.15,1,Can,,,,,,
Breadcrumbs,1,Cup,Dry,Breadcrumbs - Cup,Driscoll,Dry,Measured,4,0.25,0.25,Pounds,,,,,,
Broccoli (Head),1,Whole,Refrigerated,Broccoli (Head) - Whole,Riviera,Refrigerated,Whole,1,0.15,0.5,Bunches,Order ICELESS from Riviera get the 14 CT NOT the 18 CT box,,,,,
Bruss
We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 18 columns, instead of 1 in line 9.
Name,Package size,Unit,Storage,Name + Unit,Default Supplier,Storage,Measured,Single Item Weight,Item Buffer,Conversion Factor,Supplier Unit,Notes,,Durability,,Conversions,
Acorn Squash,1,Whole,Dry,Acorn Squash - Whole,Rbest,Dry,Whole, ,0.25,1,Whole,,,3 - Durable,,1,Cup
Apple,1,Whole,Dry,Apple - Whole,Rbest,Dry,Whole, ,0.25,1,Whole,,,2 - Regular,,,
Avocado,1,Whole,Refrigerated,Avocado - Whole,Riviera,Refrigerated,Whole, ,0.15,1,Whole,Order PRO-Ripe,,1 - Fragile,,,
BBQ Sauce (12 g),1,Packet,Dry,BBQ Sauce (12 g) - Packet,Driscoll,Dry,Whole, ,0.15,1,Packet,,,,,,
Beef Broth (14.5 oz),1,Can,Dry,Beef Broth (14.5 oz) - Can,Driscoll,Dry,Whole, ,0.15,1,Can,,,,,,
Black Beans (15.50 oz),1,Can,Dry,Black Beans (15.50 oz) - Can,Driscoll,Dry,Whole, ,0.15,1,Can,,,,,,
Breadcrumbs,1,Cup,Dry,Breadcrumbs - Cup,Driscoll,Dry,Measured,4,0.25,0.25,Pounds,,,,,,
Broccoli (Head),1,Whole,Refrigerated,Broccoli (Head) - Whole,Riviera,Refrigerated,Whole,1,0.15,0.5,Bunches,Order ICELESS from Riviera get the 14 CT NOT the 18 CT box,,,,,
Bruss
We can make this file beautiful and searchable if this error is corrected: It looks like row 10 should actually have 18 columns, instead of 1 in line 9.
Name,Package size,Unit,Storage,Name + Unit,Default Supplier,Storage,Measured,Single Item Weight,Item Buffer,Conversion Factor,Supplier Unit,Notes,,Durability,,Conversions,
Acorn Squash,1,Whole,Dry,Acorn Squash - Whole,Rbest,Dry,Whole, ,0.25,1,Whole,,,3 - Durable,,1,Cup
Apple,1,Whole,Dry,Apple - Whole,Rbest,Dry,Whole, ,0.25,1,Whole,,,2 - Regular,,,
Avocado,1,Whole,Refrigerated,Avocado - Whole,Riviera,Refrigerated,Whole, ,0.15,1,Whole,Order PRO-Ripe,,1 - Fragile,,,
BBQ Sauce (12 g),1,Packet,Dry,BBQ Sauce (12 g) - Packet,Driscoll,Dry,Whole, ,0.15,1,Packet,,,,,,
Beef Broth (14.5 oz),1,Can,Dry,Beef Broth (14.5 oz) - Can,Driscoll,Dry,Whole, ,0.15,1,Can,,,,,,
Black Beans (15.50 oz),1,Can,Dry,Black Beans (15.50 oz) - Can,Driscoll,Dry,Whole, ,0.15,1,Can,,,,,,
Breadcrumbs,1,Cup,Dry,Breadcrumbs - Cup,Driscoll,Dry,Measured,4,0.25,0.25,Pounds,,,,,,
Broccoli (Head),1,Whole,Refrigerated,Broccoli (Head) - Whole,Riviera,Refrigerated,Whole,1,0.15,0.5,Bunches,Order ICELESS from Riviera get the 14 CT NOT the 18 CT box,,,,,
Bruss