dummy-data.sql

TRUNCATE "SpeciesTrip", "Trips", "Destinations", "SightingSpecies", "Sightings", "Locations", "Species" RESTART IDENTITY;

INSERT INTO "Species" ("Id", "Name", "PhotoUrl", "Description", "EndangeredStatus") 
VALUES
	(
		2,
		'Orca',
		'https://upload.wikimedia.org/wikipedia/commons/3/37/Killerwhales_jumping.jpg',
		'The killer whale or orca (Orcinus orca) is a toothed whale belonging to the oceanic dolphin family, of which it is the largest member. It is recognizable by its black-and-white patterned body. A cosmopolitan species, killer whales can be found in all of the world''s oceans in a variety of marine environments, from Arctic and Antarctic regions to tropical seas; they are absent only from the Baltic and Black seas, and some areas of the Arctic Ocean.',
		'Data Deficient'
	),
	(
		4,
		'Blue whale',
		'https://upload.wikimedia.org/wikipedia/commons/1/1c/Anim1754_-_Flickr_-_NOAA_Photo_Library.jpg',
		'The blue whale (Balaenoptera musculus) is a marine mammal belonging to the baleen whale parvorder Mysticeti. Reaching a maximum confirmed length of 29.9 metres (98 ft) and weighing up to 199 tonnes (196 long tons; 219 short tons), it is the largest animal known to have ever existed. The blue whale''s long and slender body can be various shades of greyish-blue dorsally and somewhat lighter underneath.',
		'Endangered'
	),
	(
		1,
		'Humpback whale',
		'https://upload.wikimedia.org/wikipedia/commons/6/61/Humpback_Whale_underwater_shot.jpg',
		'The humpback whale (Megaptera novaeangliae) is a species of baleen whale. It is one of the larger rorqual species, with adults ranging in length from 12–16 m (39–52 ft) and weighing around 25–30 t (28–33 short tons). The humpback has a distinctive body shape, with long pectoral fins and a knobbly head. It is known for breaching and other distinctive surface behaviors, making it popular with whale watchers. Males produce a complex song lasting 10 to 20 minutes, which they repeat for hours at a time. All the males in a group will produce the same song, which is different each season. Its purpose is not clear, though it may help induce estrus in females.',
		'Least Concern'
	),
	(
		3,
		'Finback whale',
		'https://upload.wikimedia.org/wikipedia/commons/thumb/c/ce/Finhval_%281%29.jpg/1920px-Finhval_%281%29.jpg',
		'The fin whale (Balaenoptera physalus), also known as finback whale or common rorqual and formerly known as herring whale or razorback whale, is a cetacean belonging to the parvorder of baleen whales. It is the second-longest species of cetacean on Earth after the blue whale. The largest reportedly grow to 27.3 m (89.6 ft) long with a maximum confirmed length of 25.9 m (85 ft), a maximum recorded weight of nearly 74 tonnes (73 long tons; 82 short tons), and a maximum estimated weight of around 114 tonnes (112 long tons; 126 short tons). American naturalist Roy Chapman Andrews called the fin whale "the greyhound of the sea ... for its beautiful, slender body is built like a racing yacht and the animal can surpass the speed of the fastest ocean steamship."',
		'Vulnerable'
	),
	(
		5,
		'Grey whale',
		'https://upload.wikimedia.org/wikipedia/commons/thumb/0/00/Ballena_gris_adulta_con_su_ballenato.jpg/1920px-Ballena_gris_adulta_con_su_ballenato.jpg',
		'The gray whale (Eschrichtius robustus), also known as the grey whale, gray back whale, Pacific gray whale, or California gray whale, is a baleen whale that migrates between feeding and breeding grounds yearly. It reaches a length of 14.9 meters (49 ft), a weight of up to 41 tonnes (90,000 lb) and lives between 55 and 70 years, although one female was estimated to be 75–80 years of age. The common name of the whale comes from the gray patches and white mottling on its dark skin. Gray whales were once called devil fish because of their fighting behavior when hunted. The gray whale is the sole living species in the genus Eschrichtius. It was formerly thought to be the sole living genus in the family Eschrichtiidae, but more recent evidence classifies members of that family in the family Balaenopteridae. This mammal is descended from filter-feeding whales that appeared during the Neogene.',
		'Least Concern'
	),
	(
		6,
		'Sperm whale',
		'https://upload.wikimedia.org/wikipedia/commons/thumb/b/b1/Mother_and_baby_sperm_whale.jpg/1920px-Mother_and_baby_sperm_whale.jpg',
		'The sperm whale or cachalot (Physeter macrocephalus) is the largest of the toothed whales and the largest toothed predator. It is the only living member of the genus Physeter and one of three extant species in the sperm whale family, along with the pygmy sperm whale and dwarf sperm whale of the genus Kogia.',
		'Vulnerable'
	),
	(
		7,
		'Narwhal',
		'https://files.worldwildlife.org/wwfcmsprod/images/HERO_Narwhals_Canada/magazine_hero/2l0u305168_Medium_WW248926.jpg',
		'The narwhal or narwhale (Monodon monoceros) is a medium-sized toothed whale that possesses a large "tusk" from a protruding canine tooth. It lives year-round in the Arctic waters around Greenland, Canada, and Russia. It is one of two living species of whale in the family Monodontidae, along with the beluga whale. The narwhal males are distinguished by a long, straight, helical tusk, which is an elongated upper left canine. The narwhal was one of many species described by Carl Linnaeus in his publication Systema Naturae in 1758.',
		'Least Concern'
	),
	(
		8,
		'Bowhead whale',
		'https://upload.wikimedia.org/wikipedia/commons/c/c9/Bowheads42.jpg',
		'The bowhead whale (Balaena mysticetus) is a species of baleen whale belonging to the family Balaenidae and the only living representative of the genus Balaena. They are the only baleen whale endemic to the Arctic and subarctic waters, and are named after their characteristic massive triangular skull, which they use to break through Arctic ice. Other common names of the species are the Greenland right whale or Arctic whale. American whalemen called them the steeple-top, polar whale, or Russia or Russian whale.',
		'Least Concern'
	),
	(
		9,
		'Beluga whale',
		'https://upload.wikimedia.org/wikipedia/commons/thumb/e/e8/Oceanogr%C3%A0fic_29102004.jpg/1920px-Oceanogr%C3%A0fic_29102004.jpg',
		'The beluga whale (/bɪˈluːɡə/) (Delphinapterus leucas) is an Arctic and sub-Arctic cetacean. It is one of two members of the family Monodontidae, along with the narwhal, and the only member of the genus Delphinapterus. It is also known as the white whale, as it is the only cetacean to regularly occur with this colour; the sea canary, due to its high-pitched calls; and the melonhead, though that more commonly refers to the melon-headed whale, which is an oceanic dolphin.',
		'Least Concern'
	),
	(
		11,
		'Minke whale',
		'https://upload.wikimedia.org/wikipedia/commons/d/d9/Minke_Whale_%28NOAA%29.jpg',
		'The minke whale /ˈmɪnki/, or lesser rorqual, is a species complex of baleen whale. The name is a partial translation of Norwegian minkehval, possibly after a Norwegian whaler named Meincke, who mistook a northern minke whale for a blue whale.',
		'Least Concern'
	),
	(
		12,
		'Pilot whale',
		'https://upload.wikimedia.org/wikipedia/commons/thumb/e/e2/Pilot_whale.jpg/1920px-Pilot_whale.jpg',
		'Pilot whales are cetaceans belonging to the genus Globicephala. The two extant species are the long-finned pilot whale (G. melas) and the short-finned pilot whale (G. macrorhynchus). The two are not readily distinguishable at sea, and analysis of the skulls is the best way to distinguish between the species. Between the two species, they range nearly worldwide, with long-finned pilot whales living in colder waters and short-finned pilot whales living in tropical and subtropical waters. Pilot whales are among the largest of the oceanic dolphins, exceeded in size only by the orca. They and other large members of the dolphin family are also known as blackfish.',
		'Least Concern'
	),
	(
		10,
		'Southern right whale',
		'https://upload.wikimedia.org/wikipedia/commons/c/c2/Southern_right_whale6.jpg',
		'The southern right whale (Eubalaena australis) is a baleen whale, one of three species classified as right whales belonging to the genus Eubalaena. Southern right whales inhabit oceans south of the Equator, between the latitudes of 20° and 60° south.',
		'Least Concern'
	)
;

INSERT INTO "Locations" ("Id", "Name", "Description", "Latitude", "Longitude")
VALUES
	(
		1,
		'Cambridge',
		'An unlikely spot for seeing whales, the river Cam plays host to a veritable menagerie of cetacea throughout the year.',
		'52.205278',
		'0.119167'
	),
	(
		2,
		'Mount Everest',
		'One of the remotest places on the planet is actually visited regularly by a pod of baleen whales - at least according to those few who have made it to the top!',
		'27.988056',
		'86.925278'
	),
	(
		3,
		'Eurasian Pole of Inaccessibility (Xinjiang, China)',
		'The EPIA, in China''s Xinjiang region, is the point on earth furthest from the ocean, which makes it extra interesting that a family of blue whales (Earth''s largest animal) has settled here!',
		'46.283333',
		'86.666667'
	),
	(
		4,
		'The North Pole',
		'Santa recently enlisted the help of nearly 5000 dolphins to help him with the toy packaging. Their flippers are surprisingly dextrous!',
		'90',
		'0'
	)
;

INSERT INTO "Sightings" ("Id", "Date", "Email", "LocationId", "PhotoUrl", "Status")
VALUES
	(
		1,
		'2021-10-21',
		'Tim.Leach@softwire.com',
		1,
		'https://i.imgur.com/lDfOB6Y.png',
		0
	),
	(
		2,
		'2021-01-21',
		'Tim.Leach@softwire.com',
		2,
		'https://upload.wikimedia.org/wikipedia/commons/3/37/Killerwhales_jumping.jpg',
		0
	),
  (
		3,
		'2021-01-15',
		'Tim.Leach@softwire.com',
		3,
		'https://www.whalingmuseum.org/wp-content/uploads/2020/09/Hero.jpg',
		0
	),
  (
		4,
		'2021-02-05',
		'Tim.Leach@softwire.com',
		4,
		'https://static.independent.co.uk/s3fs-public/thumbnails/image/2019/12/02/11/isle-of-harris-whale-stranded.jpg?width=1200',
		0
	),
  (
		5,
		'2021-02-06',
		'Tim.Leach@softwire.com',
		1,
		'https://imgs.mongabay.com/wp-content/uploads/sites/20/2021/05/14113707/banner-pygmy-blue-whale.jpg',
		0
	),
  (
		6,
		'2021-03-12',
		'Tim.Leach@softwire.com',
		2,
		'https://images.squarespace-cdn.com/content/v1/53055e70e4b0bc83a97c7ed1/1594126381907-0XJCILU7QSVTPNPVOE21/header-baleen-whales.jpg',
		0
	),
  (
		7,
		'2021-03-15',
		'Tim.Leach@softwire.com',
		3,
		'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTtFXYt27ha7_F00Hwsre9BmXq7m2niwPukVQ&usqp=CAU',
		0
	),
  (
		8,
		'2021-03-21',
		'Tim.Leach@softwire.com',
		4,
		'https://images.squarespace-cdn.com/content/v1/5ac99982ee175958d8ac113c/1623685645021-65O5VEZRJ0BJH0X3FL65/karim-iliya-baby-whale-natgeo-underwater.jpg',
		0
	),
    (
		9,
		'2021-04-01',
		'Tim.Leach@softwire.com',
		1,
    'https://files.worldwildlife.org/wwfcmsprod/images/HERO_Narwhals_Canada/magazine_hero/2l0u305168_Medium_WW248926.jpg',
		0
	),
  (
		10,
		'2021-04-02',
		'Tim.Leach@softwire.com',
		2,
		'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRWv3Tgr0hOUDgmRTyjhsHNBRTw5WoOnhFh9g&usqp=CAU',
		0
	),
  (
		11,
		'2021-04-13',
		'Tim.Leach@softwire.com',
		3,
		'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcS6PtMh3VUDudXb_OmTGPPsiQ-tAbzFblBO3A&usqp=CAU',
		0
	),
  (
		12,
		'2021-04-20',
		'Tim.Leach@softwire.com',
		4,
		'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcRf1hE-cOToaIs3uCQmjSNSN0Au64SIufaHsA&usqp=CAU',
		0
	),
    (
		13,
		'2021-04-21',
		'Tim.Leach@softwire.com',
		1,
		'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcSD9K7nOPJbBNXN4O6H-nYphave1w4C2FJZQg&usqp=CAU',
		0
	),
  (
		14,
		'2021-04-29',
		'Tim.Leach@softwire.com',
		2,
		'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTtWdR_Cl-qSF2BcOsc4MdhSzHNIlil4uvzEA&usqp=CAU',
		0
	),
  (
		15,
		'2021-05-01',
		'Tim.Leach@softwire.com',
		3,
		'data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAoHCBUVFRgVFRUYGBgYGBgYGBgYGBgYGBgYGBgZGRgYGBgcIS4lHB4rIRgYJjomKy80NTU1GiQ7QDszPy42NTEBDAwMEA8QGhISHzEhJCE0NDQ0NDE0NDQxNDQ0NDE0NDQ0NDE0NDQ0NDQ0NDQ0NDQ0NDQ0NDQ0NDQ0NDQ0NDQ0NP/AABEIAJ8BPgMBIgACEQEDEQH/xAAbAAACAwEBAQAAAAAAAAAAAAACAwEEBQYAB//EADsQAAIBAgQEBAMHAwMEAwAAAAECEQAhAwQSMQVBUWEicYGRMqGxBhNCUsHR8GJy4RSS8RUjwuIzgrL/xAAZAQEBAQEBAQAAAAAAAAAAAAAAAQIDBAX/xAAiEQEBAQEAAQQCAwEAAAAAAAAAARECEgMhMUETUQRhcTL/2gAMAwEAAhEDEQA/ALiuKcr2iTHQG3tXile+77Vt89Y+/LCGdjyvf9aczIygaCABcxE+ot/xVMJRLI2qOk6/Yc1lFJhSY5aom973qlicOcfh+V/atEva6z61L5oNPiZLAQNJWARyG3Ww+ponsz8JdIIYlWGwIsfPpV7I46zDgwRAPQ8j3pWsn8St2YfwVcyVhddKkwT8Snftb/FGubNaeFw4lfC2/IjUD61ay+VdSA0DoVMeoBtSsLPELChGvEhtNuulrg3pi8QLbrpEdf8A1N9/apdeieK0MNiPFJjYkCfXcT/LVWxMFNyAD1kg+vitz5VewgrKLX6g3+gq0JA2PvWW3P5jg6PbUfNpMdxePWs7G4BoE6wADYjwn1jf3rqswxCyOXQRt5Vz2ZXBd/i0sN1MxPlyo1Gc/BHxBIJY28X3iEzveRPzqvi8MZCA6RAgSSLCTfTIJk/FvWnhuiNJZkJsPCTPsQIr2fzrkfHr77Ef7LDyNWUrOweFK0AFQZ3LxHoyzVbivDXRXUySSBJuDAMQ5kAdpBvWhgcWiAwLADYkR2nVaasP9oF2IYLtaDBnf5/Oto4PEw/fmOnkZvSXQkXO2wvtzg/zeu+bMZd5bS2KYiGRG0235E2mIaowchliCTlzP9ShAPQsSKDgcPC1D4lUj8xIB7fDA9SKsKjs+p58UkkRebkyJHeugzuHgAkfcIFEjUrsTPWQAT5Ggy2NlluraCLbltVogrpMig1Ps5h5YhUMEte+pXDDTCqwMRM29egGznuFYJQoqBX0mDLXa/MmD1iK5hXwiZAWxuyhhzJ2O3tFaGHx4oFRHU2MeIk3M3IPpUprlOKZVkIBkEFuYPTaPL5Ck4zhEKPhnWSCSwOoLuAu0Tf5VrZ/jC4j/glWkC6+K19W0+Ec+VZeY4icR4dhMyWI1z6x4vU1YlBl8QqJCBR1iT+82NWhm33VG07amhR37Cs0cTcW8JFuVoG0REVYy+AcWxDOxMqJvzmFEnp7UZrd4ZnHdSHfDCiPCi63tyB2HvPnVXiL4SwYdgCY1+ITubSBNW8jlThqCcNAtjLysx0JZe21a+Hng6/9pMHkN5i+9wR3qM33cxhcRdkdUwhoWXdgPEiEgEBjOkcgOZPOlZXNYYLOA5efCGCOmmROqV3ibwd+VdFjcKF2dEclTMK2gRtGgiDF5i1Zw4SmwdQ7Ext92F6l5n0j3qud5wWW4oAzsE0gsx8GoEg/CrvOoqIgARtParq8Vw4thmRsWb2soFUMzkSnh++RwACdJaBFgIYCTfl1qMvlMErL4+k8lCM58ybAfOmHnfiG5njEnwgL2qg+aDTqPK14v1qviYY07knUbGI0wLzMk9uUd6AIvMA3t5c+flVcuutN+8H5j/ury4g31T60k6fyj51GpenyrblVoZkdRRjGqicS/wAJ9ooTjf0tRzsdiKJnHNaEGhc1zdtWcrihSfCbiBBWfmDTHw1IJ0MD8r7yIqgHpiYhB/Ywb71Gp19HvgKF1C+07W7Rv60rSnr5T86JsXtM9ZH/AOTVhUQoBI1He5nygiKLm/CsMNDM6ZN9ovPKBAryoR8NoMi4/wDI+fvTGytwquDNwdt+RnnVZsFwbMD52G196HvD8bNWIKibbf0iOp+VIGcsQPr/ADvRtiEC4i0dZ6wd68rgTEwwgmATHaRI3v50XVnJY5/C6jtJWfUiPnXQ5bOvABVm7jmPL/NcnhYN5B87bT2NdDw7iWlQrKpA25eY7VK78dRo4hJEpY9LR62g+4rKx+Fo3ifD0t1UmO8xMe1bmC6OJEq3MAz9dxRMhAO0dY+RHKs47SueTgSEW1HpcETO9xNUc7wMKs6YI/FpEHpsfrXX4LQShWI9j0j5+1ezA5bz6iquvnL5U9fkR7RQpkjqVTAkgGTAiYgxf5V12LlEYzoFzaZE9wJj5VH/AEvDDBoCmfigGOfWPetajkeK5UfeFU0KoIEAtAMX+K/Lnz6UWW4YWVoxdMbaUEeIi9rx4hzm1dU3DB4iwDBiTJEkyL2Igeh50xcFEWAh22AEGB+YCamq4nMZZkSYRlUiSUWbm0vJkW2HKq2ZyTuC8YPKNL4akWtARpNhXbYmFhsNBEMTtOoEzIEEau2/vXO5zJ4iE6EQHotzH9ouLdZqxK5zAyMmGcASQSIa8gWvHPckCx6UOZy6ppJ1sCsmwW/a9xbetLEybxJLSTMAaV3I2J+lNcfeqyuSX0+EzyUnwAadyCTvaO9VGCMwg2Uj6+h5fKpfPuNxbqRJ9610+z+IcNnUjwzqVtKtAkExMkTNZLYDs1xPc/vRKE4LxqCKwI1EAK5AiSWCzp9adkOIhCCBpYGQVt9bVs4JLIMI4xCQIWSqKb2Mi/8AmsvN8MRGA1EkiRphrHy257we1GWzw7iOo3COW3bEJaLzcsYrZxcV8MKMVAqk2K4jCw/pBmL9Kw+CZJAwI0SDqnEaBIgxFq6DM5RmM4iYbC8EJiuFnmoNj1gH3qIp5zMo4gJpncnWR/cfDLHvWUrlGVwiEKNOlgYJg+JlJlt56bV5s2cJ2+5JSdwBGxt4STBt1qrmMdnOp1JMRM7+kGrI5ddQGOqk6i0knUVQBQJJlQTty2HPtQPhgMQQ4v8AD07XvUF+ie5j5xXl+8M/BYExqH71pwvVeZE5K099q9oX8g+f70oh+QX3mih/6fcVpzv+jUgbCKLUetIh/wCn3Feh+i+9GbDvvDUa6rkP0X3rxV+i+9EdbXqgJUgVzdY8aiaKKjTRUBxTExSNr+360ITtUjDos9lhMeReBG0+GPLlH70eLiByJY2tJANhtcG9VgtGE/kUb8ll8DUsK0C0iWImwmIt/mquJkmH7jan4aVt5Hh8gO5MHYA39TyqV0558mBhYDbb1pZXh+IYGkgH/j3raR1WRABWLBZN/PntselKTiyyQST2IKke9ZtdufSwjD4ayj4wknY728t9xV1MYBbnVEi4jzsazsbiyLs4cEwBpuPIgyao4vFygJ0zJgCbgcthzrPl747Tn2b+HmQzBVWN48RWbX2tXnxUFnBUdZkAjkDXJ/8AV2cgQABc72q6+bLL4yYjwgGWaxIJEWG1zWsTHT4ZwyDpYedBi4SkqZUx+Kx+VczlsUldciAY0kn5mnvxJwJAW3exHbVb/itYy6Z8MW2jvaq2Plla8beUW/nWuTxOOvJBIBn51c4fxIuYJ/n8IFTFV+IYTI+oA7/hlIBBiAIuJF+xqrmcZ1JhAhXTN9bQbNzgzzB61b4hhoXkEr8OxEgCbgc+XtQ5bAIbUGGL/SW0tyiJvNuXTeriAynFX0w2Gz28M6gbCLgWI/amJiu0Rgkk3JLz12tqFh15Ued4iUID4Sg3gNLW5nxGfWKqtxB4JcsVINtGob3UybD/ABQ1bzGErKCyJhixJ1LqnuSZ27TasTNZbA1AJpdiROplRCJvDkzO3Ic6XmSGG7gzawMgDrJv6U9sr4P/AIibbsGJJMfDpEdd/nVjNrO4kNDhQhQRsdLqf7XWAaJsVWcFUVQBdRqIJ6nn6VYVcUgqoZUP4QWAB/tJ2NXcgzorAMIvYAsJO0AggD2ozapYHxFwi2vpKyo9GO3nRZrOu3hL6l6TpUdgJgD0q14rjW8EXAkTA2IuIp2WR0+HURvYsBt5VWLXP4gEbezR9BQnB1yefJRAm0bAgCuhxMFnaXOogGAw1R5ajb2qMJSt38YAunwKRykg7doo43Nct/pXBkIwIuDJtHORUDCcT4SsiDykdDW3m01E6VVOQUGwHmTJntFKw8GJ1AG97tHybvWnPpkBD0NE2CehrV0tJ0qoBG0n9ed6JUAF1BPIy37xzqsZGNoJ5GhKHoa1ThknYQNwCxn5zUYyT8ICjzajOMsYbflNDoPetfRe6jvDP5/noMQkGVAHLc/rPSheW2FqdNSK8K5to01OmpFFRdDpr2mir1DUAUSioohQ1bylvFBMEbCYvvsenzr2Z4swYlmWABYNZekFTcmdreVqQc0qIZE3nkBYdevbzrm8/m8AAnQJJtq1ibEEiOVx3rlu3Hv9PJzL+2wnHmBITxBhcEOWk8hck8v4Kq4magamKqLFgRH+3cAA2v7c65p8+xn7tdI2EjaTJ3Jp/D+Hvit43AEydVhO3IdB2FMv26/40G4kNcoA43Eqq/8A1PXaZp2WLswLncW589gBsf8AFBh4OGhizkAyZETO8xcVVz/EbaUmD8R2nsO31rc5kurtxq5jiKIABDONm3VB0HU/IedU04s4YPMtO/eaw1DNtS2LbkkERA9evLrWkrsDi4rkElF/MviBMgi5FL/0hBnXJmdre0/OqORxGxLkidzE8z19603QqpJkxeOfeujDncznNTkjrFrTHPz51YyfEygN+YkTBtcelvpWfmsNkJm8knV1nnas7ExKxR0me4yHYMB0J8+f6VYynGEJbUCoJkc46g9q5E41ScWg7luJK40MFYAkCb+oYelKYEgFWtGw3Hn2rjlzRGxqxg8RdTM0wdHiZ9golj4Ta94iLVeyeeOkQ29t/cEe1c9gcRVxDgQOnK/SrmtVEqPIjmOvnaq51tpjCbge1X8u6R8K+1c7g5mRB5e9XUzAAjn8jUZtbq4qflA9BXmcdB7CsX/VEWNGua70xy66xosw6Cq+KFPIVXOYpbY1XHHrobItAcMdTfvSziUJxKuOfkJsFag4Y6n3pbYlAcSqnkZoA2keVD92tAXoS9DyO0DqfegOGtK114vQ8mnNTNL1VM1zWUwGpmlTUzQ02a9NL1UQaho5qQaCaflcPUb7C58h0o3xL1chuDlNaODMFYAHM+dc7n+GgAgAyskBouSReSbC5N4PrXUHiKg6YAVJJsfCYIA2ib+dc/ncw+K5VBMk3k+EGYk/oO8VM+30OJ484ovlAg1bCB/b3udqdk0IW/hUncAaiD0B+vfnSlwl1BJ1ODAduRFvAoketzXRZHhaEgs95AAIBBI3O948jtTrrHWTWGuRZzCiBta0jYSedXsD7N8yD9P+a6vL4TAypUchJJbT2UC2/rTWdwRpYObKfyi/Xlz67CufkuOXzP2c0rdGB6gjT62sPOOdZacHJfTEyYFr7TNpHXnyrrc/ml1EszLAMqhPiA6d9rx0pRwHEsllJDBWABU8zK3J5XqeVl1r2rluK8IxMGBESQAAefKlcDygxdYLsjAbLJLEnmBc+VbOf4isHDZJZvGYuZBIhiSIAbpXJ8QlXlDBO0HaOtdOer0x1JFjEGkthPEqxWxm4qjmOGT8NVlfUTLjzJ+nWnZfiAHhYz3v+tbZVnyhXcVXxcC1dbwnL4eYlQ4VwJAIkNVB+HMxdUQkrJYC8BdzbpU1Mcs4IqVxSLEVoYmX7Uh8v2qskpiHlW3kMx4Y37de471kJgkVZwm00St9yxOoR6bGLTRK5pvA3VyFbmbHua6vC4Ijrex61L1ieOuY++2rzYsbVd4lwlsMxyOx5GsfFBUkGtSuHfK6uLU66pK9EMStPF1fdaL0Jeq/3lQXoxp5xKEvSC9QXoacXoddJ1V7VQO11BelTXporaBotVLmo1Vg04NUMaXqqC9F00NRBqr6qnXQ1ZBrVwMqxwmixKsZ5xBiBWH95SX46+AryRqZpS0COcfyalj1fxuufL3ex1ZULYznDQmSI8b3mFB9PEdu9c/n+KliEwxCDZR9SeZ7msviXE3xWJZ5k+YmqeDmCrSIMGj3Sx9L+zumAzovwzLXAUWMAevnXS4CpJexIiFlm02gQDYc65L7N5/WgC6QSIk9pt/N71t4KFGBEQTeBCMTvCAHz+lq5W3XWZjZXGbddK9oJ+a7He1JCYhLEFQJlRcEm12P8O9Z+PjvOpJEWmNO/Mi3vyqcpju7C5gExDAl46yJG+0VKS4p8TwcR3H/AGkcA/FJJHU3I/nO1Xsrm20S3i0mFBF+3a38JomxVDag8xIiwAHfcz3tWamaYMSEO/TSdz+AwZ3i0kCKQVftNlGA++WQ5Vjp5XswjcXIMxXGAvp1sdRJJvuDXeZvDfFGp4F4TUNjNyQZ3t4uVhO9cH9q8qcFw4EAiCAAp2jaSDtv1866cdZcY6+GVjZsJeV5j8wLDYjzqj/rNRJmDyEb32qnivrMCQovG5JpuDhusGLmYFuhkyfLfyrfyzq9g5phcEgz5e1dX9m4dSwxWXE5aWgqBuep3rmcNUiys7fiPwqgmLsdz2p6scM6lYqR8JnxHlb8vrSQ112cQ4IZ2CujQsMIYFvxKRsZHzrJxsfDKDwkNMNcaT3HMHtearYuI+KScQlGAEAAxIgG0+UkbWrPmTe4sLb3MW71bDWm2D0qviIRXlzDYTapuZtFxyIKn1EVXbN6j0nlUZrUyGa0EV9H4TxIOk7ERb6x1r5O78xVzLcZdBAYg8iPpWbzpOsfU8940ZDvBI8xtXAZrEk1n4XHsSZ1mex/TnSzmSxmedXmOXqVfD1Ieqa4lGHro8HfytB6nXVYPU6qOZ+qo1UnVU6qGG6qmaUGqdVFM1VM0rVU6qDZ1V7VVfVXtVRjT9deL0jVUF6hp+uva6r6qjVQ1Y1VVzuCrqVbb5g9RRaqEvRZ1Zdjkc/wnESSBrXqN47jcGs4mB6z513TGq2YyqP8Sg9+fuL1Mejj+TZ8k/ZzjCAhWABFg23La2xPzrrcHNqws9z0LKfaOc+V964HM8Hi+GY7H9DUZbO5nCIDKzqD57d1M8qzeXq59fnr7fSEzpQeG7fmKlyAZ8QE+Ietu9C2ZRkgkEyeqkAc7E3PfrXG5fjWqbMm9tBGokm5m0wSJ3rZXi6aSAixa9ywv4pfmO0db1i8u09Sft0AXDYlCFsIJhDbkoAPh9eU2rHOEiOShKEEwmuA17wJtaD3n0qqnFlRfwAQfCeUkQwH4m5+U7SazH4nAmCBYTJnXudJ/CSDPS1PFr8kdFm+IoqgxYSZDhpN5k9487Vxf2u4krppJBMqVgRIvMddxft50ji/GgLE694JknmDLnqedctnMYuSx58htbvV55xL1pTuQbGKbgZ0gyf1NUmNCGra/LcTixWdPPedjVjL51YLsdTna1l/q7mubZxNpjvep+8PKrpjoX4y5BUsTJJ6C9jbnNLTODnMe3zrB1mpGIamjonzUqGLGQYHkBP1+tIfMy0zYTHlM/qazVzJjYbAf5qBimqw2MLNnb+Cm4uLBnofnWMr05Hqs2tjCYbzveI29auYT1kZZr1q6It0o4+puLSPTFeqitRq9aeSrYeiD1WDVOqjKzrr2ukB6INQOD0WqkBqINQO11Iekhq8DQa5ah1UotXprLOG6qgvSi1CWoYbqrxekF6gvQw/XQnEpJehL1Uw0vQF6WXoC9DDC9AWpZell6BpelYgB3FCXoC9RZb9JZF6bdzby6UnGw1b4hJmSZMnzPOjLUtmqNzrr9lPlkIgqv8AtFVMXhmGfwx5E1eLUBNGue+p8VlPwdOTEecGquLwg8mB85FbhNLepjtz63c+3Ovw1hyHof3pZybjka6BhQkUdZ/I6c+cFh+E+xqNNb8VBQHlRr8/9MNanRWyMJeg9hRaRRPzf0xwtMRq0GwFPKhbKjlV0/JK9lcSDWuuNqudzWEhKm9XcHGmtJ8tKaINUJdaXNV5u+cPDUQeq4ajDUc8PD0Qaq4ejDUDtVEGpINSDQPDUWqkBqkNQahaoLUBahLVlMMLVBalaqEtRMMLVBallqEtRcMLUJall6AvQw0vS2egL0DPRMGXoS9KZ6EvQwwtQlqWWoS1Fw0tQFqAtQk0awRahJqC1AWqNSCLUDGoLUJNRZEGhNSTQk0aemvTUGomipNTNBNTNDBTU0E1M0MC+GDSwmk9qfNCRVizqxeyuYBWKJqzlBG1XcviTY1rWvbqCmpBrzrQA1XHrnDQ1EGpINEDRjDw1SGpINEDRDQ1FNKDVIag0pqC1AWoS1ZB6qEtQFqgtQEWoS1CzUDNRBlqAtQM1CWoCZqAtUE0BNFwRah1VBoSaNYmagmoJqCaLiZqC1CTQlqi4ItQE0JaoJqLIkmoJoSaGaNYImhJqJoSaLIImomhJr00XEzUg0M16gKakGgmvA0MMmpBoAaKaJYIUVADUg1dRawMWbGjxEqpVrL4mqxrTX/UwAoga84g0INHKwYNEDS5qQaJhoNTqpINHqqpj//Z',
		0
	),
  (
		16,
		'2021-05-05',
		'Tim.Leach@softwire.com',
		4,
		'data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAoHCBUVFBcVFRUYFxcZGh0aHBoaGh4eIx4eIh0gIB0jGRoeIiwjIx0pIB0aJDYoKS0vMzMzICI4PjgwPSwyMy8BCwsLDw4PGRISHTIgICAyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMv/AABEIAJsBRAMBIgACEQEDEQH/xAAbAAACAwEBAQAAAAAAAAAAAAADBAECBQAGB//EAD8QAAECBAQEBAUBBgUEAwEAAAECEQADITEEEkFRBSJhcRMygZGhscHR8EIGI1JicuEUFYKS8TOissIWQ9IH/8QAFwEBAQEBAAAAAAAAAAAAAAAAAAECA//EAB4RAQEBAAIDAQEBAAAAAAAAAAARAQIhEjFBYVED/9oADAMBAAIRAxEAPwDaC9miql61+EAAJ0+P2jgo9PeOjmbzxxX2hYdh84sDu3u0CjEg3Ajsw0+sCUodvztFPFG5gUw+7+kSFtTmgHifjtEKLXPxEQplCxsfUNHLywoJoOvx/s0So9SPb6wKYyJL2/OsSmUnQCE0rarKPen2iqZtPX8cxSmly0CrV7wyjhxUHcAEUBU2bs8ZK11v8ftAVyVkvnUG707OYJW//lx6N1Jp6mIVw+lFAt6xgIlqDjxFkm5d/jE5FixWT/U0IeX41zhFJNU1u7AfKGZMov8AYxiyZyqkqUOud/f8vG/gcS7A69B7gxNXjteP/wD6PLzeAlywKlEakkMG3oFa69aX/ZPhZQDMSrMFy1pG4IIFU3Yklt4H+1k5RxktKFFwgMCeVnJOd6MwFDSojQ4LiPDVntLXVaAXaoFDrcHSm8Z10xuYaXlSB8PnpvF1JUNuhP8AxGlNw1Xb/jvsxga8No3ekMSMtUxW19viz0iqBMJpqzJLDSr9S1I0Uy06ktS0N4bDh9g1W367Xi1IzJEghJK0kqFKqNrUSLGoMQmWsGmZtj00FrvGstCUuMoBqHNXOnNvrC6zMy+QagOTUXpW/pvAhVaDlvXbXraFAtQ8wIsRQ1fTvGslGYhx+kXDM8AmIS9DTsR8DAhFM9eYhSUgaEO/qDSOmYlVgn3ZvhBypH8Q/PjECW9iKB6lvreChJnDaIKug9P+IsuXu353icjWgKmaBt6xeWp6u46RxiqFpUrKCCeh+e0AQpOjRznb5feLLwy01KTTWpHS1IgrIuC8BCVteOzA2+f3iCs7RKC4/sYC2Ua/GLKPaIBiEqDOPz3gLU/DER2fv8Y6Axio6An1+5ic29PX+0XUnb5GISRqR7f3jTAakRQyxq/u31hgpHSOSltoELJlV09x9oKEiCfmkQU+sCArA0SDHAnoPT6mDt1gZSfysCKFT9fQf8RD7BXw+QguXufSIUg9R8Pk0EgeT+Vvr7xGQvpFijUlvURCQk6k+v2gRDvT7/KKgpFHFPy0EJTa/R6xVeUaH3b5wVUrpr60iiJbnqe1fztFkLToHG7kxyMSpJBSAzuXFfSCNbBcH1mEIA019rfWNQZUBkaihN9r7R5ibx6rHM5NmekccfNmLCEOByg8pLA/xFiAGVs4a+sNxrj+MfiB8bF8jFJWwNWBYBJCr6Kr17Q/hOHqRMSlSeZ1JNDQkClb0Ytq/WHxwyWDmlvmGUAqfTzZUpLPrtTSNiTPV5s2YJ8xUArK/lJUHYG99XvGNbxrYSqU60b730izJDmobR7+nvCS8cJakiYwKq2IGrkKZnd7/CCLzJO4rzAseri+8AwmWDWld7j+8HkIy0Z676dYrLT/ABEuT+P1hxIHXuYITxMg0GhHbUQFCActD7dS7ghhpa1405qMyQAWULH7wjJSvOAQzFw1mbod/aASmoObKKEmhO9dfj6QgvDTN1EnfSv/AJX949WDoRTUPGBxLh6wVqCuS4Iu+Z6mpYAkaQTSMzCrZ/ETR9qfDpAk4Ug5jNSA1XZvWlKQp4ZWSM6l1pzJFQdKA19YAvAykqvTa/xB2aNM09NxktD/ALyWojQV+QhX/NH37JD+9PtEIwyP4WG5EN4bBKmKySwh2dlEpp7Q6OyqcSqxSn1b5AvGvwvh+dsyEpSoOAjlamgUbFu3aGsF+zaaGYC4P8VEkEMxqxjZRJqecqDMBaldd3iVcz+hyJYJKQXAGoqBWh1B7wzisOhYAWnM1jqB9YyccFZalijMzm4Ng4/LxSRxXOlaTVSCaFnDCjh4Rp2J4SQSUrBeocN6dYzVoIvRtocRxGXNQUrTkUDTmFxXU1ELTqFhVO5/GiAKFvY12N4suaAatHEVt6xJRv8AERRYEx0C8Lqfc/eOgEMnaJSiK54nxBFZcmX3/PWJY7n2+0QFjrHIWC/2gIIjkns/eLgxy0/lICpf8ERXeLhHT4ROWAEoHaIYXYwQo7/naOCAN/cwIE/5SIPv2c/ACCqT3Edl1f5QAsvT0aICSNovNUgeYpHeM3G8dky+WpLsSEsi1Odx1fK7NAaS5JD1BapdgfjV+wjGxXGZaZnhknlZ8oCnLhgSbJO7vWg1hZfGlTTzBS1u4Eug/wBxZx1AMDRgX55jSk1ACQFHqxUfMT0D6vAiMHxCZ4g8GUHUTzTXKlPskcxIHSPUoE4HnQF+GVEEpIc5HcBJDpIJ9AzNHh5/FZMkKEsKWvylyXapoS48wS6aBn1AheZ+2U81IQCzDMomnS3s8GnoJ4mJR4hMxARmSChw+bXRz/VUUreL4yemX4ZCgppeZQ5mBUouFA6WetWvt5qVx/ETMwStBKqkJQ5P+4ufQ/SKTJ8xakJyKCyoUtQbsxY1USTv3gPo2BxSVsUmalMtInBAIKQ6SgozOSTmBIBAowpWBzuLqBTNyLSjnzEc4QAaZtBq46VtGDwNSDOASkhctToWFkApfKseU0IUG2YRtLxQCFCYkZwmqGKXOmVvMlnL63BLRnVet4fi0zJacqgpQDHKXDilC9bPDaMRlNY8TwTistBR4SQASBMlKGQ1/XLqQVVHLQs5ZTAR6heKC1NSwBOZjYmwvb6hxDBoHGE0DCKoxn8V4x8QWVlT+HrEonKHKr3+ojeYzXpJc0Lp3i02SCGIcfhtGXgc4qfTr2jVlYhKqVfV4zuLjExHARnzCaoA1IKUP6Fn0MAPB0pJUVqIqxCRStApiI38UmgYaivzisrlDNcbX6vAjCPC5ZTmS5UOh/Hh3CySk0QUjo22os8MrWQXltWrG/XpAJuPaxIOxrFEz5xlod7kjsbwzhcSlYBJYszWd9YtKmhSWDHd/tCvgILGWQC9Ul2PQj7RBTi8stRxudrs/wDeMFVDzeb2PpHplzwAAtx6U6197xi42SxcEEF6h79djECqiDQ5fhE20H56xxlvU1+kclPr84CRv8vtEp94rX81jnMBZz+COgbx0UZSpgpb3iVLGwB7PCWVdgsJ7B4umWR5phX0p9IrIyV9W9B9Yqtetj1hSYgEgplp7r+0UXilAUTnL/oSwH+o39IJWgvMQ4vp/wAwscaZZAVVRsBdvfvGYvHknkll9SFH4lq9oLIwq1AuUpe7I+f9zFTyvozN4it+QgvViRTuAc3xiJWKmqcq8OmrqYf6Tf3hM4aXK8y/T+wghxaUhkFJHUD2szwS79ABnImFaZj1cuTlPQ0bWwt0jVRxcOApOn6cx+DQsWICicpNgX/7QPoIUVmuo8twCqp1oILnTYRxuWFB5cxQ1YfUm0L4zjJLgKloFAA6SrqaGh09Osefnq8QOpWRAqQmg6VNzeKYXDSnaq3tdzttTXaEXN08gGYoqylR/iVmL+qrAbJEK4+ZKQpPifvJgsmXZPqWZ/WBYzieU+FKR3y2fqReAplEF5kwIGuUV+8FNHiSghTJTLABscyh3JGX3Se0YGIXOnnMcxZIDB2bS1HN3P2EaSpgWjKmWrK/KkHmX1UG7b/WEsahRCcykS0tRIIf1Nzc3iNKzpSUJyyykqepcMH0AckkUhAJZtHD9/XWr16RKwlL1q7BqlhV4FkcV5aE1LUFRQb7NtEDMtbbM2oJruGptcQ/ITNAzIWnKxPms7/pLXbQbPGIgg2c6OdPSHcPNUkMFhOnlqzCtA7X9i8Bo4FcxMzMQoFJKipJPsQdKGgJ1j0WKxy1yxKViZRWySCtOUjLXlm5MljWzl9o8fLxIUwUQcpUCSwzJNGLMSaO5L1vQN6FWHTMl5JRSuVK8pUjmS4OdlUJG2hyuCGiK1sA4SEzJPjAnKVSloXd0qLAZ8vMS1iwuHjTwsxEubllK8WU2eXnmEqFH8MpXUBRYpoa0YFyMjheGTMVl8iqMpCmTYBLqcMQzVpe+huL4ZUtXiTJaZqAVICkpQGA0WlLJVdi9KB3uYPWzOI5JaiZQSamtHa9QPM7aipg6VgqWkAJAqHd3/V/SNK3eukIS56VSwpWVQ3UXcMCkHUgggNU0JJJuXDYgiY60lOZagC4qkmtBYs9CBUPpFzSNdM/KgsX6HQt+VgkjHgkF9NtR0jKnAuwUpQFiRo9Ab6Mb7xCp4QQbJ176hiL69I0j1UjECYh6QsVVYu6dKWdnA2cRTCrCkgpYG/pakAKlliQ2oKm6sw7g17xlVcWXIKGHcwjOlqzBgb16AfTWDYzFJIBIqO8JKUClRQpRyh1JFwCwdmfaLnJNw7LUoLZJc7P8x9O0CxOImX8NQB10fu8IYnD+HV1FdfKpiD/AAk6GJlzcScmclMuYWzEOkVbmW5PcsRvChyZxCYfIXA8wN3B9jTbeBrmrLmgB6CKy8UlEtlIzzMreIXWHPoxABy20eEUTg1dCC/NcfynTpEDi5jBzbXSkdhpiFkDMahwUsXLsAQ4I1hBaisPLWlnIqSASKkOAS9trw14jhOchyHoXB6gsGigypTFn60/vA1IMCnrXTJlIOprTocwr1+cHn4qXkogguGUlRLdwaEQA8x/P+YmFpuKqc8xObXlH3joJcYX+NmFmQhHVSn/ANrt9Yk5y4zBzrlYD4AE+sSFs7JU/wDEUgfIRyZiifOW2NPcD6tFZiUSCocyivsWB/2gfMxcZE3AQ3UQGaJh8oJBp6dKj4QMcOUQ6sobd/lAXXjRZACurU+QELzsRMWMrn/SwHwqY5a5Eu6ypWyav9IqMas0lSgnRzU/aKzrpfDmYlQHT7vEz8XLQQAkK7UbtpCy8NOJqG3JYe8CXh0oqtYP8oNYHeejJm+IXAo1/Vr/AEbaBrkAakZqOfpSneBz8asjKgFFBqR9KflYTUsuecLNHFT9NIKMJgU6U8stN7VO5J1o0KzJxJdICUrDZgXJDVauxY+o0aJnlXhnOCLMGa/58RCwkzFEJSDlclz5XNFEAgJAYJvXlFbAFEwspKaqalQAQS17AsB32gCJwXMKgmgs9R6s3tBVimRIdILzFdQSSlIGjuTpa0Bmr8MDJYm5Ierny/wtSxF+0GyuJxC1heXMU5wl1GhJemWzuAaCgfpAkOP+rLMu7KXnTzZW11zZT0Y6UjX4XPyLCVugID9yWFQz66bHSPTpmg10boYmZWd2PATJAS2atEl0gnkNiHyu70fpURVc9eQAlVGYFYIYpATkRckMKpsAARHtsbgETQHcKHlKR5RrbUts+rx4nELUg5SeZIUhTsHqqztRinQdobkXNqBOUh3AJByipdxcki56de0QuaxLpqDYl67aimoPaKJlkhxl2PNqdx1YV1rFVqBLMS2tg5qyRbdhrWlgIownD9KVjZ1D4BhXoKxucPUqZMQxEpb5Cs7WrV1KdJNakgO8YSMOT5qDd3ejihb8pvGvw7h4EyUtM1KOZwpRWkuCCRZmcEXapcxFeh8eZh5iFKRmCTm/dpCeXLkmMC7lJD8zhwmoeHZCSQRKIRLXnCgpNSXHlSU8qlVUwKhQmtYcMwKlLKMq0kgpPiZgCSDlAJIBAcZTloEiods3E4UCoCCSxBuS5JDOPMkJU1XYAlrxBuYVIGHlAKdAuWIozasRSln07ZfEOIKUoS5OUzUKJSFEDNzHOgEkhyN9FL1aHp05SsOPCIQpKVKS1gUs4Au75w76+keKk4pc0nxEmhJGYVAJJLEs5r/xDE5bHu8P+0kpCUnKsKHmzM7jQl2amrPCGJ/aDxSOR0nM5BLppoAklm1t7R5eesFg6jQGrnuxcljDvDpCSpOdfhueVZylLityQAe9DaNxz8tr0a+MDKkypsyjEpUjKoAkOktyggZudBNWeHeCYlMwLPiLmTMrBK1AKQwckV5ki72pVtBJ49LXlRMkZyCCVysqnNQtggulKmBy1Fy1WjK4rJlhfiS1JlKJzDMoyyHf9BcN2iLfrZxc6YmotuCH+I+8LSsiy6Corq7hSHDuQSrWmhZwKRnSlYlAEx1TQaDL+8D92b1BMdKkjEKP79SVtWURkIPRqGu3aC16JCiQlUtYUk1KSghXUVIqLVGkGxi5iAWXlALOCMpPf7QzwiapEiWJgClJCglW6SGSpRI59X5tRCc0lJJCSpJagY1aoAOnqewiNYhKSEgkEKNSGYNoWJfeB+Jd1AjZq+rROZK9FJO1R7AwhipAKgRMrbzhHyS594YGVz2QypakgsoFVQQSwOYOAH3pD5QkOEKK0vyq3DD2LuG6CsZOG4rKR+7WuXSzLUW3qR9YZkLlrUQhYKNUpdKtzlINaPAzTKJIGqi9WJJHo7+0BmplgOpDglvIS3dhaKCWs5gmaSkEeGJlCkOXSTQkVFenWBS1TUnKxL1e6f8ASakHvSAovDYdRfJf+VvgaxEaKCoh6joxjoUjGCFakN1eFcSuWitz/U3yBMWIKrEtskU9YunCyx/9eZXcCKETjJq6SwR2+5i/+ELfvFsdAVH5CGZ3iaDKNkwn4Cg5CUjcqIb2isxQYSUk0dar2I+MGzrDAFMvsylRypOcVmEgaJBA+EJT0M4SQkaqJqfi7QSGJhl1Eye51c/QNAimQlyCD/OTT0hFWHlDzFR9x8kxZZSlLolhI/iUCT6PUxRebPkqoEzFdUpZ/c/SBf4pSPKgSk7qAKj2cBzAROWQ48TKLlSsif7+8AyLWbZdMxDDvmJf4wHTp5PlKlLNcyqs7WGhvuzPFFSiADNmEKLECpJG/wAIlQQMqUHMoliQbkszqcNc1dvaArQp3WlhtbvU371tAjllgpRdTjMCq6Wa4J2IpzBi94TxLBjcAtr5mBUxfyh23r2MNLXUjMQk6BmGh1YguoaPeBy5ALMCVblIUw1KRqwFnr5WiNJmuAWYJZzqSMzMVd2t30hvhXExLT4a7AqIL9mBtRyavraF/wDCKKiVSyEuElL1AJc5FUzKTS4YkmtyTJ4dMcMwNAMzKDB0klKgGqHqHetDWHZ1r0cniMvLmCklID026g1jyXE5qpkxc3wyny0KSWLUzWc/QRoSOGZCFFVQGADkV73F6RYI8zqddwGq3pceusXbrPGMILCgSaEJcpS9Q9Q+hfT1vEhASylMkEEMxLnpV3PKKUvq8XxXJlVVSiVKrYhs1BfUNWrmOxKwQ2RKFMSNzVnBq9QTWwBjLZJSyVMKg1+LVAL30vDqJBGUKGUkMSpKTQCgCW1qHDk16xBlZkrTLylJJbQ5QSHSTWuVq13FmeQiWpKSrxKMmodwQwLFQFMqQQCmouTSA9L+z85GaWGTWWFqOXLlZ2BlJcJcl6CygwFgTiPjS5nMslCmOV3YKJyilCNU9xtC/AUyELRMTiJZGTwlJUlSOWhQQt8oUUhIdx5WYG29xfCYY4blKnylglaW08wYhgwJZtN3iKw5GPKly5aliWUhUsOknMSSUg1fKVco2Y9iLiGFlyyCpOaWQMi0EBKruUlRL9nLFw5YGHOKolmWPEltMMtJzMWFKhTaOSxPXrCfDeFTCGSWz18ylJNNMpFaAA1OkXGd7KIxHlCUOwOV26m72ufrGiOLJcqly+UXlrdVAWFRWnXpC6uHzJSkTSCUpU1yCCm45mqH0+hh5EmUiYmaRmkzHBB0zFiQU2UC7PYi1IrPZnDYaVNQJslRlLzATEAMEFSilNXrmozAehhjDSVKlmXjMxlhZyOkDnIZXOHVmAqxvUbxljg8xPilKza4spOZJ5gHdPdg4BekaWEQvEBaVKKJiQzNRamKgsA2zJDkOB+oOYLBeHTJ2HCpaGXKKgoCxFakFwQpgBXML0qYrg5SRP8AEKQCAohKgACSC4IPKoXLFhTSK8P4jzS0TQWD5jarVUkM13NaOe7tzciVLRNIRMoFJOqmewflfMxZjR3pEXDEiWnw+R0pBbwyfKSA+V/KD0o/qYmROZ0KXXQsAr1FQe4p0hmVgsqQVkrHMXASGZmq6qEBTPqw1hZaSSVKLByXCQzPViWBZxEaBVJmglpnL2B+bmCyiHAmKSuod06Udjb4QFeBWk5swIIL+ahsHDkM/r1iuWYKg8o8wAZj1cb9YIcxXD5SySlKS9QSkEt13LXhORLXLKkgJyLIcAKT5XAa4FFGxFzHSMQqUc2ZQffNqPhTsIOvFS1UUgqe3IT6gtSCoQsBRR4igSXAUBToFEVB2JPSDZJjeZJ6soU6sbvrAJeFlkkJQpBu6QUv6hhB5JqoHOgjRQACuxH3EALwZm6vRQb/ALqx0GONmCnhFXUFFfdjHQHn8RLBNRMmdAD/AOxA9o4SGFJaU9VFL+wBh0IrRPqw+8SpBs7P6RUJeHur0Smg9SwgSwDYudMxHwAAHxh7wzo79T9I7wVAOSpjsKe5eKM8y/4itX8unsWiqkrNAnIn+oD/AMa/GNJckEa+whSZw99B+dGrCkJTGS4BVXZbP6klXyhNGEmLU4SUjfMfmSY2kYIJFB9PdhEqkHWg9C/u8KkY87CEalR/qUr2ufZoWVJBLZTe2VL9HKiY3l4YCjD0DnsdI6bw8kOAG9AYpGBMluPIU9qe4DOW6QnNkkVysaHQqOpdywHS5e0ekl8JINAzv+VpF5mCQlIzc0x9dO+WCvLowoBNSzkhBILCrZno99ne1YXKAFCgcgMC+ob4d79I9SvhwWP0Xexbp5qb7xC8IlyGl5QNEh96EN3t94QZScemqTVqPRvcAJo5rSzwaXOc5UVcJf8A3A1Ogcv89YuMCFKzBBIvUJu9OZRep1G5JhdbCYoOXUfKW0vlfqfNXfpCseI6yb1ANQ5Bqa1I9oGsOfqdtfpTpo1VV8RMyYSpWV7DK1VZSzM93slrgULwDF42ZKmKSUoUOVSXCVBiKFJbuCNxDeS5xRjeGiYBkUE5SaHc9rWFLUG0Zs/Brl+dAypOZ0+VVk+ZrEVYilaBy+vK4yhaymcjIX5loLM4o6S4/Okak6QuWErzBUlVpt0jTmuQqvlIro8TrWpuPISp2Ul1cy2BJ0chyWoNXH8rQWbilFXiDc3FxQXASCzoLMNwxURGlOTLWCCGCrtTMAXrpQ1rCeIwKSAUKAP8wzauLk9B2FXcvn0BonoHPkSAFBOUKU6myhLDNbKa7kX2+hzMEDLkUNJQXlW2bKScpJTQvVumkeFwHDVGZzKSEvYA1A6UZ2s7BzHsJXEZaEnIs5iQAwcKNGqKuKMAGpowERW6JScRhypKQZspTuVEkJLhRQAQojKCSAdG1g3BJMpKPEC0FsqilYCkpcKdkggl+UgncFyaR53h+IxSGyEstalDJlOewUMrE6J6cpLAjNGnLwxJ8RKAJjupKHIN/MkAkq1I7Xq1QzxJcqbKWCnwlFboWgqd6upQAN6hW9NgRgo4ROCVAKStLPUc3dIUantfYxvf4mfVS5cspHMSlISBqczJAQwTQqAHMHLWGnFyy5QhDluUOqhtcuKC9RcQpCU7PLlygFBSkp5lILhRABGlKEBzrSjOdHh4E/CrVMQQqWoswAUpJSp2N3qRR6PSpcowwAKiUomJ5ikqdQBOWoPLXm5XNiQzRmnBnImW5JCiuWp1oYgkZUlPUCpNCmlHhQ5wmYcxlmWy2ZCByZgzkpoQSHSwIL5r7r4/hU2f4ZRmVlRXMjndyDmUwSXIUwBp2gsuaolpqRMTUqCVBWwDqZwfNuC9bmNjhoISpn50nzFlNlKRcM4cB2r1aFCWAl4hgmYlMtKwEHMTmKgqhJFlDQa1LGsaGHlT5awjKqYhySzEAAtfM5pegtroxLLpSmqssxJS4y0Zmzalq/DpDc/ME51BTAkuhwWejkaVPxgpHifmAlihfMMpcMzs1RQv2STGdj8NVAOYi+dKlEpLsQ4FE0saGHZEsMQVEkFbLSQCSpJHMkADQNWnWFMRxQKyy1JmSjQhRTR9Q97uPnALLlIAOappoXPcAXiklICgUgp1opaSP9Kmh6UkAm8xSqpdmfTNvux3i3EsUhCM0zItkkt6h2JDBmNaNSAQxKiKkkh3zFVv9xp7wIn9QmONCFBh8ajvCqeJCYwWlHIoEkMgt5VcyQzB92td4visVhQoo8MFAUU1dw13dy1A21qQqzWijFMNT1yCJhaVw7DLcghn6/aOggq1ywAEse6T92gYmjQV9G9oGpJAqO0VTWlPgYoOcRS7HsG/t8YH/iCGNPjFvAP6gQN2oIjKgX59mVT1gKrxT6DrT5CKma5Zmi6Qm5T03hdaE6Agai/tSCJJbygE/wAzsO2nxjkLCiMwSOpp7cxihRRgB7P9L+kCVht3/wBv0YQBpkwGykODuB8wYUm4gA1SSdCCFP7EH4RYoULV7f3FoGlJd2IO4Le4b82gHsNNZJKnYWGVvQOHhDELUxyv2I69xBPBmByM4D1zOB9B8YokzFkgEOTZx8GeFGesrBVzrBejgAexct2ELTCqqgpgSeZ1M+rlIYM20aeJwJWo51Fgzg29VODpoYXRhyhRUM/iJq76Pe1atS14KTn4g3BJJSCVU8jipSmjgvXV6mLcRlzQpI8R0kOVBI0YFyAQS9GBIBYR6GRIRNmETFlE1xykOFFLUUCwDU8r2Vo8CxWAmpUykuqxYIALO53JI1odb1MHmpy15c5KjykALV5VEhilIALsxL07tGNxKTNUkBdkOHuoOQ+YM9G2j2uG4SVFlylNmcEpIBdiS7M1qF7da6a+DhICGTsAQqppWpp3FLRfY+Sqmn+Ggq3MWZ6VskOTuHDmsO4Hi8yUkpQo5SxymoOpfTYEf8R6f9pf2WAl+IgpRMCCVIskjKRozKAB7tUVjxy5CkkHK+UjYigLvpQZXpb3jI9nwrh+G4ilTKTh58tBLV8NYDWSKoLMOWmrbp4z9mcXLIK5Sly1UEyUc6CND4iXCRvnY9ow+FEy5iVAl9w72qLtqPy/o5XGcRhlBcmapINaGhF6ix9Ym61CuB4KVl0rSal0lQBFNFGhD7dI9Lwvg8sS1omKYqDHKkEslvLpcOS7F946R+1UqeR4iEpWfMuWAknqoDlV6h/aN9PDVpQkywZu62UElDVBaj1694Ym5FOGYWVIBl+IlaTVIGZJJ6nMW1DvS1ocXh5ZmhUtaQhhmYpSSwqVJZnF6X7xIwcwgpEtwwqkjZ3OUW9+rwtieFzMudCFigdLUonTmckkWa8aRbGoRLmDlWtQSQFBa6gqJDVDO463vGccUErCxLyEGrqIUG7jeveCj95lZC5RAq1CS/2O2kFKpodKVr61c+xUN2Z9ICGzJABKUq82YpUDqK+YW6/CL4ThstJOXOhVXUlRTRwWZKm/Sm3tSLYbDsQlawH/AJFXfpXM9PvGhw/CSlci1kkFgWyubgAkPALTsJJOfKQGsA4LPaXlAsQTvU94rgcfKkfuy4US9Ei7NzUu2ughmbhZaFB8javRlUIBc1G7B2NtYGvhBKqmU1icxUX3IofeAcXi0goVkSC29x/KQOtu0N4LixqcjuCSA5p/S1b6VoYz5kqWgFKkEhxYkDagOprV4oiZIQnMJZKg485DtcEChP40UaBlS38RBKUqNUEWOjFnAHQG1IHxUpQkKBZbsLunYgCpAGz30hBC5ZYiZ4Tl8pc9Lb2LjeGU4qWLqSpiRm6tVi19RtEGQZsxQXLl0VfxFJIADhwovWtKMzBrsfMftBLCUpKZi1zc5BzoGRqhSQUgnzKDpJPXePa5sMFJyIXRkljyXo+avT1jsTiJRB5TQEKSWANagpykXIGnYtBXz5eFmqzy0kqTykpSVHMo0JatebqKnaNTBcBm5gSEJr5lcrgDQAPpoI9X/ivDSDKlSgCHL0YPQEfqNdKRKeLTCcwTLYgcgS4/1ehoQTUQmF1mHg5p+9lJpZ//ANVjo2pfGFN50p6KV4ZH+lIIPej7COgjDTOBASwfuK+x+USWDnlHR6+ghIBJL5cxLVb5sYvlQL3trftCqbQqX5lzAG0yu/bV/SBzsWj/AOtLn+YtToEl/jAFLSzMlhT+zesRQh6DVqHrCkHTiwC4QT/qqPgxgCp+VRygkaZ1LceiVMe7QNc0OK5fcP2L/KJBsxeJSLqx0xg0tAOpFabORF04pYLgFRuxLN25T84VSkfxtWlG199IqQLUYBxT5QpB14+YonMmWRdy4budTFU4pSeYM722HrT89IoiUSCorDAgVy7W3+d4Q4fP8VBmELRXkregroIlWNSdiieYkuT7afpo3pFFTQR+kl3ZhQfn1hdGFFCcxNw6nvcPF5coIHlC+hff7euukKkMoxSEk5hXQkDQ6UvbW3eGP8SlYCqkAOQkWuHcih6fN4nEy8MZaCgrRMA5pdSAWqQQAGJ2A1pWiyOV1JUX00JqXJUC72/vFpGoEAhS0FXMxVlpU7Ak0N6HbpB0zczOQRrnBveiX2DuatSMmVxCYDykFQ/iLMf1kFta/DtBEcSKs3iAdAC7knUUYXNO0CNtOLDJSkkH9IIYHQMB1YMAfW0YOO/aACYEzJMxCWouWRMQbMWSxAqP0vWLpxspI/6aD3qNnYv6/WAcS4jhpyMs1IIH8CapLM+ZNr/eAy+N8ZlzZYlSio8xKlMQANQHAdRY1G9LuPP8S4FPlgzPCUEhnYFwEkcxTtb3cgVbblJky1oWiWMqBTMVKV0yuoAMQGob+27/APL0pSM8pUw1bKGJBIcMoM3q9LGA+bowwBJVlazJe7sFCh70ApYWZggMBMKnA5gnK1SDlNQKgZmYGx3I0uMoE+b4kqUZSMgdLAOa5iQksbjQMwMMrw6CQpw47WAplrqFAbg6jWK80ZGUuFMSARylO25FwxtrH0v9msW+HT4iyCkCmrUIerga0EeflcOkFYPjIAD5hkJbfLZrF3uNBHozxTDpl+GCVAFqpuMxL1Fau1SfgIfT4cTi5iyHXMDGxJT6kuT+CH5c5S6CY7EBjN3Aenszx51HG5aktzIag/df1DkLsLByG94Ij9opYS2ZrkrTSznloQ9KsOt41UjXXiCDlXLWSCXOVRfSigCX7dN4lICSM0tQoOa9QDUg1J+0Zw47JDla1LavMCG0oBc1+GjNBR+1SEkpCQQwFgxHVjT4bwpGmjiAYJCV8wYk8g35QxPoxEKq4smWtSFYU6O6hlJahDAgCj+veMef+1QJU2YC4IAFN7HRg5pS9YBO/aHxHCnYvQ11oWYhnuSRCkTjpsydMUtRyqUASnKGASlgyXuwjOUhTcwUO2Zyw9AfaGp3GEhykOepDb6k7asdtBEI4szvLsbW363r/aMrAsHjEJKSZaydEkULVV8NO1dYZm8RCuQJmMebfmVehejddqVMQeJqdvDqWYFRDuwcG6vj96q4uoKGVIBIoSsaM2hcesANE2a+VEulSEsWZzQg2LAwKdiZ5AHhkFLVSG7GlH5hW9oKrjBvkSGUxOatBszEsC1QegFTZPHgE1yhbuAVOxpTKeY0q8FAWZpAGUqep1qHYKcAEsdLPBBjZyQGQsKH6iCFOOxt7WiEcYmJJLIIOWiApWtbNcPQB+7tEzOMzHoUsx0IuHFVEVABJYGggGZeNnqmAGWpSWAyqCiGuRYENXy17wZGOmt/01IB1CSQQ3K4V6B3LVfrkJ4vMzAAoKS9avQdUuq4sfbW8vjEws5WWDksLVBd2Gpq5sexI2krllyuWol7pygejl7vHRif5/MFHVSnl/tHQVnnjCnbMLeYtQuBqPppo8QOKzC9cz2Ds71vl/8AE+kJ2SpWoF+7RSaGUE6begiVWgnia9FFKdjlDBqvS/p7RP8AmK3POHBDChDVuwd/s4AtGYpTDOKEpPb9I8tv1HTWIznMany/+0KQ/wD5hNuFlmvm6/w0G96wRWKmBKnU1Broo0IBY3pftGUZpLV/M0HlVJexUKWGmgpFRoLxU1KilyDSmpDXZzc17axT/HTNVkijkMaU1DOeopetIUl1UX0Spv8AaTXewv13MDkqz5yqpBp052+RaCn04xVT4htuaXuA1RYinzgSsap6TBUHU1sQwZ23gc3lKgLA9zc6mug9oiQgHwQQ4N3r+pqPalKQDeGxSncrJYgsHszh6uaJFwdIEvGkuXFP6gHLEuRoOr+jwIoGa1wPnA8KHBJqaCsZqfhleIJrnpuU0qzUDHq8SJndRKQ75mckC4VuAa6aOwhXGTCkIalF6D+EH51hnEGhVqyP/XS0L3FnVdlUKZi7n5GxINhfVg8crEOEgqe4dk6P6Ak7/wDK0n/qDuPoPrDGETzIOpKX6ueb3esaT5Vkzki6m/VYDXqzAfTs9UqOUM+Ui9MprSp0sKv0h3GyUhZYMym+BikyQl0U/Qk3P8Q/PQbCAVSpRD5FhOVibA1qCRWw6AARZlFgASLlypwWqzGu7NXpqLGICVKIcep/HrBJU0pkiYCys1/Xa0cP9OfLNzMduHDjvG6lSFKS6CVCpFSCDQ2I1AFxVhEJBIFwoFNLGtydGqHdx3cQbCT1KGYliolRKQEubPytWNKeAUyywsmwAe92vbWOl1jcxlKRQ1Ia4cgbHqS7FxtFfFBLmpdJAKkkNYAAMHsw9LRoSUAghtB3o5ob/pHtFMNKScqCAUsaH+je+kaZIzmVsqlXCnBAo3QkCp1OhvwIDkUOoCSD3DFmZg5d3IhpR5T+awVBp2I+cKQoaqUE01AF2uASX7uSPjVeYg8wPh5crF0hNHepIIqSdBRL1100LO+g+f8AeLTFcyuhPyau9A1YqazpKCwYqUOhFiS1E0P5tBMhGprQskCr0cpFdHNvnDRoARQ7wLErIU7/AKX9a1+EFLozhRCpZIP60zLCjEoULdUlg0XVLc3NScqixCSa1ZJNeXQ+rwbErP7wvV0/M/Ye0KCerMrmNt/5X+kSkGTh8ilJzqKVAhSfFUUkuD+tQsQetr1ER4IctLTlNCG81TQBmanXW8RK8qjqEEg7HNeIE0ve2X5AfSFRbOMoYJcuk81w4/TYioSL6RcIID5OwDjXsfQ7RVc1RAcmuZ+vl+8EWs1rYlI7OotFWK+AQp0lRtWjHTzAP6gH/upYYZTJUSa3zFLUrUBk1p7PEBZrX9IPrld/iYwBxGanMy7BLUBa51HSA314VQcOWDKDBi+Zw/t/LWtWi/8AhQcvNlBBJLZnL2PXu9jWE0zCZSlPUEf+O1ouLn+l/hARMwhcsgKG5KnPfKGeJjpgrHQR/9k=',
		0
	),
  (
		17,
		'2021-05-26',
		'Tim.Leach@softwire.com',
		1,
		'https://images.fineartamerica.com/images-medium-large-5/dolphins-hunting-mackerel-science-photo-library.jpg',
		0
	),
  (
		18,
		'2021-06-14',
		'Tim.Leach@softwire.com',
		2,
		'https://aambpublicoceanservice.blob.core.windows.net/oceanserviceprod/news/june14/smarter-charters.jpg',
		0
	),
	(
		19,
		'2021-06-21',
		'Tim.Leach@softwire.com',
		3,
		'https://static.wikia.nocookie.net/parody/images/9/97/438742.jpg/revision/latest?cb=20151126213056',
		0
	)
;

INSERT INTO "SightingSpecies" ("SightingsId", "SpeciesId")
VALUES
	(1, 4)
;

INSERT INTO "Destinations" ("Id", "Name", "PhotoUrl")
VALUES
	(1, 'Iceland', 'https://touristjourney.com/wp-content/uploads/2020/07/How-to-See-the-Northern-Lights-in-Iceland-scaled.jpg'),
	(2, 'Hawaii', 'https://i.ytimg.com/vi/HpXpETYWoxQ/maxresdefault.jpg'),
	(4, 'Norway', 'https://www.commonwealthfund.org/sites/default/files/styles/countries_hero_desktop/public/country_image_Norway.jpg?h=89acf671&itok=muwVkuoV'),
	(6, 'New Zealand', 'https://www.wendywutours.co.uk/resource/upload/2051/banner.jpg.webp'),
	(7, 'Chile', 'https://img.tpt.cloud/nextavenue/uploads/2018/01/3-Ways-to-See-Chile-_45649801.inside.1200x776.jpg'),
	(8, 'Argentina', 'https://cdn.britannica.com/06/155506-050-BD7DD149/Iguazu-Falls-Argentina-Brazil.jpg'),
	(9, 'British Columbia', 'https://www.completenorthamerica.com/cnacms/wp-content/uploads/2018/07/BritishColumbia-1280x720-min.jpg'),
	(10, 'Oregon', 'https://natureconservancy-h.assetsadobe.com/is/image/content/dam/tnc/nature/en/photos/Gary_Grossman_Rowena_Crest_hero_Oregon.jpg?crop=0,93,1600,880&wid=4000&hei=2200&scl=0.4'),
	(11, 'The Azores', 'https://i.assetzen.net/i/xHyHJ2vioG7G/w:1920/h:/q:70.jpg'),
	(12, 'Greenland', 'https://res.cloudinary.com/wilderness-travel/image/upload/c_scale,dpr_3.0,fl_progressive,w_500/f_auto,q_auto/v1/trips/europe/greenland/expedition-to-greenland/2-slide-greenland-iceberg-snow-pano'),
	(13, 'California', 'https://d1q0twczwkl2ie.cloudfront.net/wp-content/uploads/2019/03/huntington-beach-pier.jpg'),
	(14, 'Nunavut & Manitoba', 'https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQaCpmaqIJzj5bXlAJSnMzJtU6R2n-YwG6ouA&usqp=CAU'),
	(15, 'Quebec', 'https://process.images.nathab.com/A6dTpd53SmIg0pBfJJhgAz/resize=width:1920/quality=value:70/cache=expiry:31536000/https://www.nathab.com/uploaded-files/carousels/TRIPS/Whales-Nature-Trails-Quebec/shutterstock_1218628507.jpg'),
	(16, 'New England', 'https://lp-cms-production.imgix.net/2019-06/f3d1aeb8adfade0dba3cdeb6f3d2408f-new-england.jpg'),
	(17, 'Alaska', 'https://frontier-canada.co.uk/wp-content/uploads/2018/09/alaska-katmai-bear-hump1920x1080.jpg'),
	(18, 'South Africa', 'https://www.limitlesstravel.org/assets/TourTemplate/South-African-Safari-2021/Group-of-giraffes-in-a-National-Park.-Sunlight-landscape.-small.jpg'),
	(5, 'Mexico', 'https://www.beyondtheordinary.co.uk/wp-content/uploads/2019/06/Calakmul-Mexico-Jungle-Pyramid.jpeg'),
	(3, 'Australia', 'https://static.onecms.io/wp-content/uploads/sites/28/2020/04/21/lucky-bay-beach-australia-kangaroos-AUSVRDAYS0420.jpg')
;

INSERT INTO "Trips" ("Month", "DestinationId")
VALUES
	(0, 1),
	(1, 1),
	(2, 1),
	(3, 1),
	(4, 1),
	(5, 1),
	(6, 1),
	(7, 1),
	(8, 1),
	(9, 1),
	(10, 1),
	(11, 1),
	(3, 2),
	(4, 2),
	(5, 2),
	(6, 2),
	(7, 2),
	(8, 2),
	(9, 2),
	(10, 2),
	(11, 2),
	(1, 3),
	(2, 3),
	(3, 3),
	(4, 3),
	(5, 3),
	(6, 3),
	(7, 3),
	(8, 3),
	(9, 3),
	(10, 3),
	(11, 3),
	(0, 3),
	(2, 12),
	(3, 12),
	(4, 12),
	(6, 12),
	(7, 12),
	(8, 12),
	(0, 4),
	(1, 4),
	(2, 4),
	(3, 4),
	(4, 4),
	(5, 4),
	(6, 4),
	(7, 4),
	(8, 4),
	(9, 4),
	(11, 4),
	(10, 4),
	(0, 5),
	(1, 5),
	(2, 5),
	(3, 5),
	(12, 5),
	(11, 5),
	(0, 6),
	(1, 6),
	(2, 6),
	(3, 6),
	(4, 6),
	(5, 6),
	(6, 6),
	(7, 6),
	(8, 6),
	(9, 6),
	(10, 6),
	(11, 6),
	(1, 7),
	(2, 7),
	(3, 7),
	(4, 7),
	(6, 7),
	(7, 7),
	(8, 7),
	(12, 7),
	(0, 7),
	(11, 7),
	(0, 8),
	(1, 8),
	(2, 8),
	(3, 8),
	(4, 8),
	(5, 8),
	(6, 8),
	(7, 8),
	(8, 8),
	(11, 8),
	(10, 8),
	(1, 9),
	(2, 9),
	(3, 9),
	(4, 9),
	(5, 9),
	(6, 9),
	(7, 9),
	(8, 9),
	(2, 10),
	(3, 10),
	(4, 10),
	(5, 10),
	(6, 10),
	(7, 10),
	(8, 10),
	(9, 10),
	(0, 11),
	(1, 11),
	(2, 11),
	(3, 11),
	(4, 11),
	(5, 11),
	(6, 11),
	(7, 11),
	(8, 11),
	(9, 11),
	(10, 11),
	(11, 11),
	(1, 13),
	(2, 13),
	(3, 13),
	(4, 13),
	(5, 13),
	(6, 13),
	(7, 13),
	(8, 13),
	(9, 13),
	(10, 13),
	(11, 13),
	(0, 13),
	(4, 14),
	(5, 14),
	(6, 14),
	(7, 14),
	(8, 14),
	(4, 15),
	(5, 15),
	(6, 15),
	(7, 15),
	(8, 15),
	(9, 15),
	(6, 16),
	(7, 16),
	(8, 16),
	(0, 17),
	(1, 17),
	(2, 17),
	(3, 17),
	(4, 17),
	(5, 17),
	(6, 17),
	(7, 17),
	(8, 17),
	(9, 17),
	(10, 17),
	(11, 17),
	(6, 18),
	(7, 18),
	(8, 18),
	(9, 18)
;

INSERT INTO "SpeciesTrip" ("SpeciesId", "TripsMonth", "TripsDestinationId")
VALUES
  (1, 0, 5),
  (1, 1, 5),
  (1, 2, 5),
  (1, 10, 1),
  (1, 11, 1),
  (1, 0, 1),
  (1, 1, 1),
  (1, 2, 1),
  (4, 5, 1),
  (4, 6, 1),
  (4, 8, 1),
  (4, 9, 1),
  (3, 5, 1),
  (3, 6, 1),
  (3, 7, 1),
  (3, 8, 1),
  (3, 9, 1),
  (11, 3, 1),
  (11, 4, 1),
  (11, 5, 1),
  (11, 6, 1),
  (11, 7, 1),
  (11, 8, 1),
  (11, 9, 1),
  (6, 10, 1),
  (6, 11, 1),
  (6, 0, 1),
  (6, 1, 1),
  (6, 2, 1),
  (2, 10, 1),
  (2, 11, 1),
  (2, 0, 1),
  (2, 1, 1),
  (2, 2, 1),
  (2, 3, 1),
  (9, 0, 1),
  (9, 1, 1),
  (9, 2, 1),
  (9, 3, 1),
  (9, 4, 1),
  (9, 5, 1),
  (9, 6, 1),
  (9, 7, 1),
  (9, 8, 1),
  (9, 9, 1),
  (9, 10, 1),
  (9, 11, 1),
  (7, 0, 1),
  (7, 1, 1),
  (7, 2, 1),
  (7, 3, 1),
  (7, 4, 1),
  (7, 5, 1),
  (7, 6, 1),
  (7, 7, 1),
  (7, 8, 1),
  (7, 9, 1),
  (7, 10, 1),
  (7, 11, 1),
  (8, 0, 1),
  (8, 1, 1),
  (8, 2, 1),
  (8, 3, 1),
  (8, 4, 1),
  (8, 5, 1),
  (8, 6, 1),
  (8, 7, 1),
  (8, 8, 1),
  (8, 9, 1),
  (8, 10, 1),
  (8, 11, 1),
  (1, 3, 2),
  (1, 4, 2),
  (1, 5, 2),
  (1, 6, 2),
  (1, 7, 2),
  (1, 8, 2),
  (1, 9, 2),
  (1, 10, 2),
  (1, 5, 3),
  (1, 6, 3),
  (1, 9, 3),
  (1, 10, 3),
  (10, 5, 3),
  (10, 6, 3),
  (10, 7, 3),
  (10, 8, 3),
  (10, 9, 3),
  (10, 10, 3),
  (4, 10, 3),
  (4, 11, 3),
  (4, 0, 3),
  (4, 1, 3),
  (4, 2, 3),
  (4, 3, 3),
  (4, 4, 3),
  (2, 1, 3),
  (2, 2, 3),
  (2, 3, 3),
  (8, 2, 12),
  (8, 3, 12),
  (8, 4, 12),
  (2, 6, 12),
  (2, 7, 12),
  (2, 8, 12),
  (11, 6, 12),
  (11, 7, 12),
  (11, 8, 12),
  (7, 2, 12),
  (7, 3, 12),
  (7, 4, 12),
  (9, 2, 12),
  (9, 3, 12),
  (9, 4, 12),
  (3, 6, 12),
  (3, 7, 12),
  (3, 8, 12),
  (6, 0, 4),
  (6, 1, 4),
  (6, 2, 4),
  (6, 3, 4),
  (6, 4, 4),
  (6, 5, 4),
  (6, 6, 4),
  (6, 7, 4),
  (6, 8, 4),
  (6, 9, 4),
  (6, 10, 4),
  (6, 11, 4),
  (2, 10, 4),
  (2, 11, 4),
  (2, 0, 4),
  (1, 9, 4),
  (1, 10, 4),
  (1, 11, 4),
  (1, 0, 4),
  (5, 0, 5),
  (5, 1, 5),
  (5, 2, 5),
  (5, 11, 5),
  (1, 11, 5),
  (3, 11, 5),
  (3, 0, 5),
  (3, 1, 5),
  (3, 2, 5),
  (4, 11, 5),
  (4, 0, 5),
  (4, 1, 5),
  (4, 2, 5),
  (6, 0, 6),
  (6, 1, 6),
  (6, 2, 6),
  (6, 3, 6),
  (6, 4, 6),
  (6, 5, 6),
  (6, 6, 6),
  (6, 7, 6),
  (6, 8, 6),
  (6, 9, 6),
  (6, 10, 6),
  (6, 11, 6),
  (2, 1, 7),
  (2, 2, 7),
  (2, 3, 7),
  (2, 4, 7),
  (3, 6, 7),
  (3, 7, 7),
  (3, 8, 7),
  (4, 11, 7),
  (4, 0, 7),
  (4, 1, 7),
  (4, 2, 7),
  (4, 3, 7),
  (2, 1, 8),
  (2, 2, 8),
  (2, 3, 8),
  (2, 4, 8),
  (10, 6, 8),
  (10, 7, 8),
  (10, 8, 8),
  (4, 11, 8),
  (4, 0, 8),
  (4, 1, 8),
  (4, 2, 8),
  (4, 3, 8),
  (2, 4, 9),
  (2, 5, 9),
  (2, 6, 9),
  (2, 7, 9),
  (2, 8, 9),
  (5, 1, 9),
  (5, 2, 9),
  (5, 3, 9),
  (5, 4, 9),
  (11, 5, 9),
  (11, 6, 9),
  (11, 7, 9),
  (2, 3, 10),
  (5, 2, 10),
  (5, 3, 10),
  (5, 4, 10),
  (5, 5, 10),
  (5, 6, 10),
  (5, 7, 10),
  (5, 8, 10),
  (5, 9, 10),
  (4, 3, 11),
  (4, 4, 11),
  (3, 3, 11),
  (3, 4, 11),
  (3, 5, 11),
  (3, 6, 11),
  (3, 7, 11),
  (3, 8, 11),
  (3, 9, 11),
  (6, 0, 11),
  (6, 1, 11),
  (6, 2, 11),
  (6, 3, 11),
  (6, 5, 11),
  (6, 6, 11),
  (6, 7, 11),
  (6, 8, 11),
  (6, 9, 11),
  (6, 10, 11),
  (6, 11, 11),
  (12, 0, 11),
  (12, 1, 11),
  (12, 2, 11),
  (12, 3, 11),
  (12, 4, 11),
  (12, 5, 11),
  (12, 6, 11),
  (12, 7, 11),
  (12, 8, 11),
  (12, 9, 11),
  (12, 10, 11),
  (12, 11, 11),
  (5, 10, 13),
  (5, 11, 13),
  (5, 0, 13),
  (5, 1, 13),
  (4, 5, 13),
  (4, 6, 13),
  (4, 7, 13),
  (4, 8, 13),
  (4, 9, 13),
  (4, 10, 13),
  (1, 3, 13),
  (1, 4, 13),
  (1, 5, 13),
  (1, 6, 13),
  (1, 7, 13),
  (1, 8, 13),
  (1, 9, 13),
  (1, 10, 13),
  (1, 11, 13),
  (9, 4, 14),
  (9, 5, 14),
  (9, 6, 14),
  (9, 7, 14),
  (9, 8, 14),
  (8, 4, 14),
  (8, 5, 14),
  (8, 6, 14),
  (8, 7, 14),
  (8, 8, 14),
  (7, 4, 14),
  (7, 5, 14),
  (7, 6, 14),
  (7, 7, 14),
  (7, 8, 14),
  (1, 5, 15),
  (1, 6, 15),
  (3, 6, 15),
  (3, 7, 15),
  (3, 8, 15),
  (3, 9, 15),
  (11, 4, 15),
  (11, 5, 15),
  (11, 6, 15),
  (11, 7, 15),
  (11, 8, 15),
  (11, 9, 15),
  (4, 4, 15),
  (4, 5, 15),
  (4, 6, 15),
  (1, 8, 16),
  (1, 6, 16),
  (1, 7, 16),
  (3, 8, 16),
  (3, 6, 16),
  (3, 7, 16),
  (4, 8, 16),
  (4, 6, 16),
  (4, 7, 16),
  (1, 4, 17),
  (1, 5, 17),
  (1, 6, 17),
  (1, 7, 17),
  (1, 8, 17),
  (5, 5, 17),
  (5, 6, 17),
  (5, 7, 17),
  (2, 0, 17),
  (2, 1, 17),
  (2, 2, 17),
  (2, 3, 17),
  (2, 4, 17),
  (2, 5, 17),
  (2, 6, 17),
  (2, 7, 17),
  (2, 8, 17),
  (2, 9, 17),
  (2, 10, 17),
  (2, 11, 17),
  (6, 6, 18),
  (7, 7, 18),
  (8, 8, 18),
  (9, 9, 18)
;