INSERT INTO SPECIES3 VALUES (SEQ_SPECIES.nextval, 'hemionus', 'Odocoileus');
INSERT INTO COMMON_NAME3 VALUES ('Mule deer', SEQ_SPECIES.currval);
INSERT INTO ANIMAL3 VALUES ('Bambi', 'adult', 'female', '>40 lbs', 'brown fur and black eyes. Has some white patches of fur underneath the chin, the interior ear, below the knees of all four legs, and the tail', 'long red scar on left hind leg', SEQ_SPECIES.currval);
INSERT INTO HABITAT3 VALUES ('Creek', NULL, 'Rocks and small pebbles', 'Small winding creek', 'One small creek with many winding turns');
INSERT INTO LOCATION3 VALUES ('Creek', '007BC', -122.136601, 037.000256);
INSERT INTO INTERACTION3 VALUES (SEQ_INTERACTION.nextval,'I tried to approach the cute little deer.', 'The deer looked up, saw me, then ran away.');
INSERT INTO SIGHTING3 VALUES (SEQ_SIGHTING.nextval, TO_DATE('02-JUL-14 5:30 P.M.','DD-MM-YY HH:MI P.M.'), 'alice_1_bambie.jpg', 'This female mule deer was quietly drinking from the creek when I approached from the other side. I made too much noise as I approached her, and she ran off.', 015, 'Sunny', 'Drinking from a creek', 'Bambi', SEQ_INTERACTION.currval, 'Alice', '007BC');


INSERT INTO SPECIES3 VALUES (SEQ_SPECIES.nextval, 'arizonae', 'Sigmodon');
INSERT INTO COMMON_NAME3 VALUES ('Arizona Cotton Rat', SEQ_SPECIES.currval);
INSERT INTO ANIMAL3 VALUES ('Nicodemus', 'youth', 'unknown', '<1 lb', 'brownish fur, with white tummy and grey feet; long scaly tail', 'long red scar on left hind leg', SEQ_SPECIES.currval);
INSERT INTO HABITAT3 VALUES ('Grassland', 'Grasses, weeds', 'Moist, grassy soil', 'Flat land with tall grasses and weeds', 'One small puddle');
INSERT INTO LOCATION3 VALUES ('Grassland', '198DB', -122.138232, 37.029794);
INSERT INTO SIGHTING3 VALUES (SEQ_SIGHTING.nextval, TO_DATE('02-JUL-14 9:18 A.M.','DD-MM-YY HH:MI A.M.'), 'NULL', 'This cute little rodent was sitting on its hind legs, eating insects.', 018, 'sunny', 'next to puddle', 'Nicodemus', SEQ_INTERACTION.currval, 'Justin', '198DB');


INSERT INTO SPECIES3 VALUES (SEQ_SPECIES.nextval, 'suspectum Cope', 'Heloderma');
INSERT INTO COMMON_NAME3 VALUES ('Gila monster', SEQ_SPECIES.currval);
INSERT INTO ANIMAL3 VALUES ('Gigi', 'adult', 'unknown', '5-10 lbs', 'black body with pink patches of coloration all over', 'missing part of tail', SEQ_SPECIES.currval);
INSERT INTO HABITAT3 VALUES ('Oak woodlands', NULL,'Contains wet dirt and small rocks', 'Small winding stream', 'Small stream');
INSERT INTO LOCATION3 VALUES ('Oak woodlands', '176HC', -122.138146, 037.030411);
INSERT INTO SIGHTING3 VALUES (SEQ_SIGHTING.nextval, TO_DATE('18-JUL-14 9:37 A.M.','DD-MM-YY HH:MI A.M.'), 'kathy_1_gigi.jpg', 'This large lizard was sunning itself in front of a burrow at the base of a rocky foothill. Every time the clouds came out, the lizard moved a bit to position itself in the sun. Once I saw it, I ran!', 010, 'Partly cloudy', 'In front of a burrow', 'Gigi', NULL, 'Kathy', '176HC');


INSERT INTO SPECIES3 VALUES (SEQ_SPECIES.nextval, 'rivularis', 'Taricha');
INSERT INTO COMMON_NAME3 VALUES ('Red-bellied newt', SEQ_SPECIES.currval);
INSERT INTO ANIMAL3 VALUES ('Nora Newt', 'adult', 'female', '<1 lb', 'black, slimy coloring on top, with bright red belly', 'brown stripes near eyes', SEQ_SPECIES.currval);
INSERT INTO LOCATION3 VALUES ('Oak woodlands', '189FB', -122.138919, 37.030257);
INSERT INTO SIGHTING3 VALUES (SEQ_SIGHTING.nextval, TO_DATE('21-AUG-14 12:30 P.M.','DD-MM-YY HH:MI P.M.'), 'Nora_newt_1.jpg', 'This beautiful newt was lying on at the bed of a stream, enjoying the rain.', 012, 'Rainy', 'At the bed of a creek', 'Nora Newt', NULL, 'Cinderella', '189FB');



