bwsurvey-data.sql

--  Bedrock weatering survey database project
--  Contributers: Andrew Kuhlken, Coden Stark, Luca Viarengo
--  This SQL file inserts all of our data (a subset of the total research data) into our tables.

--  data taken from Google Sheets from summer research. These files were converted into CSV files and scraped
--  in python to extract the information for the tables. Photo data had to be copied by hand due to the format
--  of the photos in the original sheet.
USE bwsurvey;

INSERT INTO Researcher (ID, Name)
VALUES (1, "Lyman Persico"),
       (2, "Nick Bader");

INSERT INTO Researcher (ID, Name, GradYear, FirstAdvisor, SecondAdvisor)
VALUES (3, "Coden Stark", 2024, 1, 2),
       (4, "Harsh Chopra", 2024, 2, 1),
       (5, "Cameryn Greenough", 2024, 2, 1),
       (6, "Megan Driggers", 2023, 2, 1),
       (7, "Rebecca Patterson", 2025, 2, 1);

-- photo data consists of link to a google drive shared between people who have worked on this research project.
-- links are only open to people who are on the shared drive, so they'll probably show up as inaccessible.
INSERT INTO Photo (ID, Type, Date, ImageLink)
VALUES (1, "field", "2023-06-06", "https://drive.google.com/file/d/1WEYwIKuqBSKJBRI3YGyXNx6WNleKFNVP/view"),
    (2, "field", "2023-06-06", "https://drive.google.com/file/d/1WO6pOWkiIuvn6c3k17xQrYJL2-Go7u3Z/view"),
    (3, "field", "2023-06-06", "https://drive.google.com/file/d/1yW6-dURSnEV7YBYpwaJmhvW6RqPfzSF-/view"),
    (4, "field", "2023-06-06", "https://drive.google.com/file/d/1uDUVCfuEPDa3NG8BQAiO-5wQfRPrU9lO/view"),
    (5, "field", "2023-06-06", "https://drive.google.com/file/d/1dveOQrN4kfRIVr0bmmmI32M5-ZmD0Irs/view"),
    (6, "field", "2023-06-06", "https://drive.google.com/file/d/19PlY64uzAzY7GYw05hLTriKOpeRW-YzG/view"),
    (7, "field", "2023-06-28", "https://drive.google.com/file/d/1Z1N2C4euDcmP8i3WFkTA0SEegDm7NL0u/view"),
    (8, "field", "2023-06-28", "https://drive.google.com/file/d/1Z4Js7IhZDVLjOc6Eo5KHgH23xRIi2EqH/view"),
    (9, "field", "2023-06-07", "https://drive.google.com/file/d/17CZcyVEnSF6x4ywACmc1ixV3SXcBX2ID/view"),
    (10, "field", "2023-06-07", "https://drive.google.com/file/d/1idj-Iuo3D4jrqwJpiZ9K2ISnDeqsA0Jt/view"),
    (11, "field", "2023-06-07", "https://drive.google.com/file/d/17dU8brWrsqhoRWl9_tqrX9qCAjIaFAmn/view"),
    (12, "field", "2023-06-07", "https://drive.google.com/file/d/1jOZFmJjzKCMub6A7uqUwtuNv97eon2f1/view"),
    (13, "field", "2023-06-07", "https://drive.google.com/file/d/14r6Kn6_iVZv0DZoXY_TiIgoyWcIZDzbC/view"),
    (14, "field", "2023-06-07", "https://drive.google.com/file/d/1MY_1i5r3PDK2bnNxS0btG9E22x3HwmTT/view"),
    (15, "field", "2023-06-07", "https://drive.google.com/file/d/1cwRiSpl4qg-QjeFU0rF2BO5RHN1TdNc0/view"),
    (16, "field", "2023-06-07", "https://drive.google.com/file/d/1Iinmj5DXVg6NA6UE9SluKiMQ_kQWMOFw/view"),
    (17, "field", "2023-06-12", "https://drive.google.com/file/d/1Tx970CsRjrMRZUUpBxQcYv-tjYx9EdIp/view"),
    (18, "field", "2023-06-12", "https://drive.google.com/file/d/1Z4yTgKVjSedIla2gpBkgE-nBp-6cf75p/view"),
    (19, "field", "2023-06-12", "https://drive.google.com/file/d/1kJB2vue1RRKMfWJVRjOwickfaCzg5Ogi/view"),
    (20, "field", "2023-06-12", "https://drive.google.com/file/d/16jFQKL9pvSZc9XPEv2-1CxMotzbttYQC/view"),
    (21, "field", "2023-06-12", "https://drive.google.com/file/d/1WoU-DIX9DVwnO9RDTBSkuV6g-6ZVzzZv/view"),
    (22, "field", "2023-06-13", "https://drive.google.com/file/d/1oaa1yDtrIA7mc_afdjN6fjZ6rFexi4TH/view"),
    (23, "field", "2023-06-13", "https://drive.google.com/file/d/10Ve2lun7tk4sCPFJoRz8Cph_2NCXkyel/view"),
    (24, "field", "2023-06-13", "https://drive.google.com/file/d/1Bvo32ClFOY-g3ToEjvqmKCBmGPB8AlPC/view"),
    (25, "field", "2023-06-13", "https://drive.google.com/file/d/10PjQ32QxV9vovR0ZctiXul83agnS1Enq/view"),
    (26, "field", "2023-06-13", "https://drive.google.com/file/d/107xzeFhHtp62H-FsCAoE8zB4ctmkyAMb/view"),
    (27, "field", "2023-06-13", "https://drive.google.com/file/d/1AtCx-gM8tB4yoN3thqv5eWO86vLu5Y61/view"),
    (28, "field", "2023-06-15", "https://drive.google.com/file/d/1nEgFTfZIw_083t1dyFJlp34jKgE_AzdY/view"),
    (29, "field", "2023-06-15", "https://drive.google.com/file/d/1CtsRkK7S__mlq3mW_MaciMiKnEY_-v27/view"),
    (30, "field", "2023-06-15", "https://drive.google.com/file/d/1tviAptLDvkFXGk6hY7EtjhrB3eJkSAPW/view"),
    (31, "field", "2023-06-15", "https://drive.google.com/file/d/1288s85R_-mtzLCcmCusmnbmS3UNIvIY9/view"),
    (32, "field", "2023-06-15", "https://drive.google.com/file/d/1uhhyo2OrLEZSzQ0kFTd13YLr2Z_5lUmo/view"),
    (33, "field", "2023-06-15", "https://drive.google.com/file/d/1frKc5XInPfbjF9XYH1av3RkOYQodw-S5/view"),
    (34, "field", "2023-06-15", "https://drive.google.com/file/d/1aWWqvoy3O9BXNgCWrX0a5Ue5UvEkCHiX/view"),
    (35, "field", "2023-06-15", "https://drive.google.com/file/d/1CFe5MrX_te86DvK259yE5VRIwJxjMWSq/view"),
    (36, "field", "2023-06-15", "https://drive.google.com/file/d/1SqbSUNaJrD7ZfG7YmymCLLFKNZpvq74-/view"),
    (37, "field", "2023-06-15", "https://drive.google.com/file/d/1I3FkmDi8iyiKB6WXjakDmOF5ZfWbnDlt/view"),
    (38, "field", "2023-07-05", "https://drive.google.com/file/d/1FuidwYLFV90pYGAVl_Cz0Ws315ktGipt/view"),
    (39, "field", "2023-07-05", "https://drive.google.com/file/d/1Fgy2qgv7F2eC7Hg9bhYnQh97hWCVs7MN/view"),
    (40, "field", "2023-07-05", "https://drive.google.com/file/d/1n0imLNchmNOHN7IgGIUZbw4wJ_sa8rwJ/view"),
    (41, "field", "2023-07-05", "https://drive.google.com/file/d/16TEhSUhJ_Eol_Inj5L5sxFbzvSR9IUh_/view"),
    (42, "field", "2023-07-05", "https://drive.google.com/file/d/1HMMrfa09Dp81jo_3Dl_-XMzoeFgrP5Oz/view"),
    (43, "field", "2023-07-05", "https://drive.google.com/file/d/1FMoTFMGQhqqJShzm5GFbzwssYZGMqxif/view"),
    (44, "field", "2023-07-05", "https://drive.google.com/file/d/1PaxyQR-dfE9yS1dLewCt3-V98dG45zjW/view"),
    (45, "field", "2023-07-05", "https://drive.google.com/file/d/1PQ7QKXyaPZt-mgiKduPyT6pJRYo_0b1D/view"),
    (46, "field", "2023-07-05", "https://drive.google.com/file/d/1XhQpPxNSpEhmcydvCf0xXCZgi6Osek5-/view"),
    (47, "field", "2023-07-05", "https://drive.google.com/file/d/1mY3cNnjUdx6OsXbCDIWnYkBsfkbl4qaO/view"),
    (48, "field", "2023-07-05", "https://drive.google.com/file/d/1U2QPkysg7yB_CSitBJSSM4WK_xtiD0CI/view"),
    (49, "field", "2023-07-05", "https://drive.google.com/file/d/14X11iOhi2MBEAWCyqKKmAoB37CmGH0sA/view"),
    (50, "field", "2023-07-05", "https://drive.google.com/file/d/1mXry9cSeiot5TN-GNlLDlFrHNAOqZfJD/view"),
    (51, "field", "2023-07-05", "https://drive.google.com/file/d/1mcyORggev-Bpm0klZfnN5G5txVEbQWaQ/view"),
    (52, "field", "2023-07-05", "https://drive.google.com/file/d/1HhedNKSpkTzPDHbEoN9R30VZsCCHrp4N/view"),
    (53, "field", "2023-06-19", "https://drive.google.com/file/d/1I4LPrIWUllU52HNblEq-CSFFXJQaKxQq/view"),
    (54, "field", "2023-06-19", "https://drive.google.com/file/d/1wSNfI5PkBhsEqVdHqbI7P81QPX53O5he/view"),
    (55, "field", "2023-06-19", "https://drive.google.com/file/d/1zj--QJ82fOdiHujSh0FqOCJupLPbc6ta/view"),
    (56, "field", "2023-06-19", "https://drive.google.com/file/d/15eap8fHfhXAI4oO0TEhsnEgyOEbpWe74/view"),
    (57, "field", "2023-06-19", "https://drive.google.com/file/d/1vf3LLWxqGgaDt1nmMN1taM7rzWKbfrhM/view"),
    (58, "field", "2023-06-19", "https://drive.google.com/file/d/1aWAWpVNpVs2BvQGhmbxrt5KeBoha5oEC/view"),
    (59, "field", "2023-06-20", "https://drive.google.com/file/d/1-jPPZkunqcEJ39BQF7F-ParHwFVYrrP8/view"),
    (60, "field", "2023-06-20", "https://drive.google.com/file/d/1-eQJPl8Qz0Z9FebHZULwVC3HHP2YlRLj/view"),
    (61, "field", "2023-06-20", "https://drive.google.com/file/d/1-Xnv3PILQqJVoAmP2xAtA-o6qmaOH_dA/view"),
    (62, "field", "2023-06-20", "https://drive.google.com/file/d/1-HJMpCiBMVHijZEy2GBieXhn0TSq7-di/view"),
    (63, "field", "2023-06-20", "https://drive.google.com/file/d/1-ETlQtuZmm4z7yYZ5eA6wjNZQA2-jBqK/view"),
    (64, "field", "2023-06-20", "https://drive.google.com/file/d/1-CIGQs8QOP7MhLumnL-YmSWpY3iWCyTZ/view"),
    (65, "field", "2023-06-20", "https://drive.google.com/file/d/1-9sCp8vK71OCl1ZGGZdlOXQ9bhC0F1RB/view"),
    (66, "field", "2023-06-20", "https://drive.google.com/file/d/1-6vK3Ah5pJxB7hAzir_yrcabPhPAjrFN/view"),
    (67, "field", "2023-06-20", "https://drive.google.com/file/d/1-6IpCBgOBQDA7XhMISBskDWKgiL7PQVM/view"),
    (68, "field", "2023-06-20", "https://drive.google.com/file/d/1-49BDiSX6wjtBjHO-c776MKUNT2GaxDP/view"),
    (69, "field", "2023-06-20", "https://drive.google.com/file/d/1fmdUJyB4ETvQyobe2RdHf-I2WlG5pqHR/view"),
    (70, "field", "2023-06-20", "https://drive.google.com/file/d/1zydQInITRP7Zs2rcYbUKLXF9su_3Jm60/view"),
    (71, "field", "2023-06-20", "https://drive.google.com/file/d/1zxFK1qRytVAa60xRuvPTAuIdN1Rmwv8r/view"),
    (72, "field", "2023-06-21", "https://drive.google.com/file/d/1ljoLn13oabZg_iKb3vAQIIJubZDABYAH/view"),
    (73, "field", "2023-06-21", "https://drive.google.com/file/d/1NAhUc8tUhmfvWQHs-PXXo4rnk6iqRfWZ/view"),
    (74, "field", "2023-06-21", "https://drive.google.com/file/d/1uJnpNGdoQMkuKYcXGN_VfvcZF9Z2NeJH/view"),
    (75, "field", "2023-06-21", "https://drive.google.com/file/d/18gXzW8FGletE1geAWKHTQ53Propv8U7d/view"),
    (76, "field", "2023-06-21", "https://drive.google.com/file/d/1JDyQ5uz7x2bE1PDNJRpDCwfu1kj7IxjA/view"),
    (77, "field", "2023-06-21", "https://drive.google.com/file/d/1W0Dzd5-SInlWXTwWZQ0MxhkLZT0nQ_Ff/view"),
    (78, "field", "2023-06-21", "https://drive.google.com/file/d/1ovwMD86UMJDLRvP5XWAa8ccp6xJs6L2h/view"),
    (79, "field", "2023-06-27", "https://drive.google.com/file/d/1TRp8sbFbFIFpSMvFvJNNkoXbAGgc9khf/view"),
    (80, "field", "2023-06-27", "https://drive.google.com/file/d/1kpOPT2jc-L3NsBglcS2Wv2lvRaX-qq3d/view"),
    (81, "field", "2023-06-27", "https://drive.google.com/file/d/1MZtNccEyDM9CbOJa0l62Pfp0P6r0m393/view"),
    (82, "field", "2023-06-27", "https://drive.google.com/file/d/17zNGtUy2J_dAwmjvx-kGR2i66pp-ZO7m/view"),
    (83, "field", "2023-06-27", "https://drive.google.com/file/d/1RmwflwF9lM36zYZtEAOT_pS62z3kYA-3/view"),
    (84, "field", "2023-06-27", "https://drive.google.com/file/d/1wUpCk9T8AA-3XgJaTC1NiKgxyB_t1qZ2/view"),
    (85, "field", "2023-06-27", "https://drive.google.com/file/d/12BIFoLD5wn8iFD3JzUATdAQ3va9Qc5k4/view"),
    (86, "field", "2023-06-27", "https://drive.google.com/file/d/11O4rE0n2fZvGoSPCaHEqmIM8XSVcNbPq/view"),
    (87, "field", "2023-06-27", "https://drive.google.com/file/d/1iROyExz1IIi6N8_9iPkUo0BbXIza4CKJ/view"),
    (88, "field", "2023-06-27", "https://drive.google.com/file/d/1ygXLZk_jpwTpbU-LSADuLwB7fDgiUYuc/view"),
    (89, "field", "2023-06-27", "https://drive.google.com/file/d/1rQIoSJuzCbGE0U-kvRFtm5Pto2rFJaCC/view"),
    (90, "field", "2023-06-27", "https://drive.google.com/file/d/1ajzyewVYnIrv94g3gEO2JTUK0CiB_RUQ/view"),
    (91, "field", "2023-06-27", "https://drive.google.com/file/d/1pNy9JNgv3VmzSHGQYaWtq73lrkshVf9o/view"),
    (92, "field", "2023-06-27", "https://drive.google.com/file/d/1QzNiVVaEiWG7oKxvL_si6TCHTQCxQpQx/view"),
    (93, "field", "2023-06-27", "https://drive.google.com/file/d/12G7gjYuAG46EwLynvGoJzw-IkvbPBR9S/view"),
    (94, "field", "2023-06-28", "https://drive.google.com/file/d/16fJ-G4LrxGYI2Vz-NsAXydBKEjKkKUgy/view"),
    (95, "field", "2023-06-28", "https://drive.google.com/file/d/16eYne6Uy82o9SBegqq3FJuSoWX06eA3G/view"),
    (96, "field", "2023-06-28", "https://drive.google.com/file/d/16bv_HzpTWsxRntmMqGWVxxImiexhuaWr/view"),
    (97, "field", "2023-06-28", "https://drive.google.com/file/d/16YIMyZpajqBwWjpSlwXER33msmf-Hs5G/view"),
    (98, "field", "2023-06-28", "https://drive.google.com/file/d/16B3EBD7qaoHkY-LOHgSnNmYrsOaTv12M/view"),
    (99, "field", "2023-06-28", "https://drive.google.com/file/d/16AVv4eIh5QKZStHLuu34QpqKKkdE6jCw/view"),
    (100, "field", "2023-06-28", "https://drive.google.com/file/d/16456sVAHy_sMvoFezjsi58m8YV73IFf5/view"),
    (101, "field", "2023-06-28", "https://drive.google.com/file/d/160BV4lv4xoR0Skqdp-5395OBzJLg-5Yq/view"),
    (102, "field", "2023-06-28", "https://drive.google.com/file/d/15tvrlgdrc_xcI5O883H0WPENsKdVY58y/view"),
    (103, "field", "2023-06-28", "https://drive.google.com/file/d/15qcuCpXpOQ4NPhgx9Ez5zUjJpTE1Y2Db/view"),
    (104, "field", "2023-06-28", "https://drive.google.com/file/d/15qNtbGQIlyvTc-p2hNMnSL_-V1c2sWj9/view"),
    (105, "field", "2023-06-28", "https://drive.google.com/file/d/15kqQgisMiMazFHuDDRdEtuKQx4-3zqjK/view"),
    (106, "field", "2023-06-30", "https://drive.google.com/file/d/1DqUObgpNNe3cSAsUTN-h2b7JqFcPpvUF/view"),
    (107, "field", "2023-06-30", "https://drive.google.com/file/d/1DpjUK3qqYMfsFLo2OXZ256G3HraAngVG/view"),
    (108, "field", "2023-06-30", "https://drive.google.com/file/d/1Dmj4K2ZdGjGzOkzWKWUAwz8EzRD6XmQk/view"),
    (109, "field", "2023-06-30", "https://drive.google.com/file/d/1DUVOie52uvNyvUnu8ZxBG5ORAhO6CpKe/view"),
    (110, "field", "2023-06-30", "https://drive.google.com/file/d/1DOH2nmUnPZ5qlGkyqlLG9Dl2MPs9YvZL/view"),
    (111, "field", "2023-06-30", "https://drive.google.com/file/d/1IIkle9iqliXnEa1L7BcTvT-kNF0-ptpk/view"),
    (112, "field", "2023-06-30", "https://drive.google.com/file/d/1DB_SBHqjkbAG229fjgAlDDUrJokQoTdf/view"),
    (113, "field", "2023-06-30", "https://drive.google.com/file/d/1D9m9oXQIbzQFZgQ-XZsE6e2aXyGYraiL/view"),
    (114, "field", "2023-06-30", "https://drive.google.com/file/d/1D695Wp8L6mG82nB2lie9AwvpKapQXF1v/view"),
    (115, "field", "2023-06-30", "https://drive.google.com/file/d/1D99eRzF1iGbTcbZTty05bnM5UPf3Wvt3/view"),
    (116, "field", "2023-07-03", "https://drive.google.com/file/d/1H8Hrb4tW245trhc9S4Uqk1w2OYgaEqFj/view"),
    (117, "field", "2023-07-03", "https://drive.google.com/file/d/1mfUl1b2mC3XwQiEB2uwKEJ82XpTD1BQX/view"),
    (118, "field", "2023-07-03", "https://drive.google.com/file/d/19htw_3BiQPsDv7mzYxC5KsZ_ohciK0PS/view"),
    (119, "field", "2023-07-03", "https://drive.google.com/file/d/1tWj9g_Qq5sIoTeBHSTDAbfkP9Kv9_4Hm/view"),
    (120, "field", "2023-07-03", "https://drive.google.com/file/d/16F0K82myjs11WOMBhCt-Hk5ked0aOjO1/view"),
    (121, "field", "2023-07-03", "https://drive.google.com/file/d/1vbshG4CiiZqSJq80yRMaqzq_2YtcKljE/view"),
    (122, "field", "2023-07-03", "https://drive.google.com/file/d/1eG66E2OYCLEu17KefclPQFBsk-iyjd_5/view"),
    (123, "field", "2023-07-03", "https://drive.google.com/file/d/1K68vJEYM90SkCNZeg6mNS-mLP6Hw97sZ/view"),
    (124, "field", "2023-07-03", "https://drive.google.com/file/d/1ta44cCTbuea4p9qCDKu7IHohgz4Je1S4/view"),
    (125, "field", "2023-07-06", "https://drive.google.com/file/d/1HKZJ_HNQkzqR1n5G264-yMuw4onUh8hY/view"),
    (126, "field", "2023-07-06", "https://drive.google.com/file/d/1HFnzoTlywWOVMTyXxDTNEJEHXCsfLZzQ/view"),
    (127, "field", "2023-07-06", "https://drive.google.com/file/d/1HBI5hwMEaIS0SzeKQ4YRlvb0-GplLbno/view"),
    (128, "field", "2023-07-06", "https://drive.google.com/file/d/1H6taTCwrXyAJvEz9-a3m87qgNE5pZfQb/view"),
    (129, "field", "2023-07-06", "https://drive.google.com/file/d/1H5iWOGtVW3WvPhW8IQRZF_32pTwMK540/view"),
    (130, "field", "2023-07-06", "https://drive.google.com/file/d/1H329uY_e6WdTPJYw60de0Z5JoDSwiU1q/view"),
    (131, "field", "2023-07-06", "https://drive.google.com/file/d/1H1YSrHyrk9DbmF_cwr4beWHe87E_cNXo/view"),
    (132, "field", "2023-07-06", "https://drive.google.com/file/d/1Gz6WCXYjWz4_tmDdrUK7oJE0OuSg5XWW/view"),
    (133, "field", "2023-07-06", "https://drive.google.com/file/d/1Gu9AyaHkVFmHs8ZTFh0UpzIPI30Fd-Jf/view"),
    (134, "field", "2023-07-06", "https://drive.google.com/file/d/1GtaYIRX2kyymaAlemrh-4iPi7dbS5R4_/view"),
    (135, "field", "2023-07-06", "https://drive.google.com/file/d/1dZS1-m7d_MS29NqSbb4mThY48oR8RvdZ/view"),
    (136, "field", "2023-07-06", "https://drive.google.com/file/d/1ClAW8nSlajDw1NFt-HWDmB7MTxfb4Gk9/view"),
    (137, "outcrop", "2023-06-06", "https://drive.google.com/file/d/1e6oqFGG20XrUFg3fxLRvL5R0HLyU1tkZ/view"),
    (138, "outcrop", "2023-06-07", "https://drive.google.com/file/d/1r86OIhyLPPxoQ9CeS-r8ai8rrboKRCXD/view"),
    (139, "outcrop", "2023-06-12", "https://drive.google.com/file/d/1cv-zAtPcNwFgmx0QUe3K7n_U7zLZvRUM/view"),
    (140, "outcrop", "2023-06-13", "https://drive.google.com/file/d/1TtS3WR5sRWV-Oq6N3nArfb9Zb52ummyn/view"),
    (141, "outcrop", "2023-06-15", "https://drive.google.com/file/d/1cmEIWMe_cSH_yVbo8ZWitLEUpDcUDx1i/view"),
    (142, "outcrop", "2023-07-05", "https://drive.google.com/file/d/1qsOrgkjVIArL3RG6Q0GDZWNf_FB2caLa/view"),
    (143, "outcrop", "2023-06-19", "https://drive.google.com/file/d/1lDvdIhxRECoikHf68xjoLoVwfCjD1Txf/view"),
    (144, "outcrop", "2023-06-20", "https://drive.google.com/file/d/1rLgRo_5_rm-lfxkncI2rpkhOLcntlB1K/view"),
    (145, "outcrop", "2023-06-21", "https://drive.google.com/file/d/1A81ZIpi6tNic5ObCz3XbBHwsAYmncml7/view"),
    (146, "outcrop", "2023-06-27", "https://drive.google.com/file/d/1zjTZ1Z3Tk_3aF6IcIFRlocDJJpEUCX8u/view"),
    (148, "outcrop", "2023-06-30", "https://drive.google.com/file/d/1eF1GRgb-W4MA9TpZ8l5iPUoOHGmRpckm/view"),
    (149, "outcrop", "2023-07-03", "https://drive.google.com/file/d/1jhNCPJDd8K1fvMyAIx6hmHtz9p5FWyPG/view"),
    (150, "outcrop", "2023-07-06", "https://drive.google.com/file/d/1gTWoKD8-c83VGM-JyzIc-zvQQeZAzX-H/view"),
    (151, "thin section", NULL, "https://drive.google.com/file/d/1fPL4bf3DNlzqlMHHIq2Tasv92hrJE_VL/view"),
    (152, "thin section", NULL, "https://drive.google.com/file/d/1Rc3O-5Tec0X7R_fvSIv7Ioa06FZN73f3/view"),
    (153, "thin section", NULL, "https://drive.google.com/file/d/1OAF8LXPEk3NYQ49bVrR9CLGbn7DBL80R/view"),
    (154, "thin section", NULL, "https://drive.google.com/file/d/1WVS4W-a5ONCzh_g1h5M7HArhqXgs3Ksk/view"),
    (155, "thin section", NULL, "https://drive.google.com/file/d/1OvjSsmDeE0W0ziVOigqBAO0hN0IlbXmp/view"), -- WC1-8
    (156, "thin section", NULL, "https://drive.google.com/file/d/1Y8p8DK_rbT3Sp-Z-5fFVw1kobQDvT7JR/view"), -- gic1-6
    (157, "thin section", NULL, "https://drive.google.com/file/d/1MAC-hWsxuigecDEYy5Do7vudvHZfvRQu/view"), -- gic1-11
    (158, "thin section", NULL, "https://drive.google.com/file/d/19igfxNqixXdbSqv1g8-Z71THZdc8tMld/view"), -- gic1-12
    (159, "thin section", NULL, "https://drive.google.com/file/d/1Z7iXlHll84w5NvwusmfePlKJh02cdltT/view"), -- gic1-14
    (160, "thin section", NULL, "https://drive.google.com/file/d/1k2hy080RGpAmfJEgPsQokJEiLJtX9cfe/view"), -- gic1-18
    (161, "thin section", NULL, "https://drive.google.com/file/d/1oAqepb8mA9u9hETK5INz57i1_SFyhBFy/view"), -- gic1-19
    (162, "thin section", NULL, "https://drive.google.com/file/d/1nQ6zwMe9ymvuxAzr2tzPzoI6_cxcjmN4/view"), -- gic2-8
    (163, "thin section", NULL, "https://drive.google.com/file/d/1qoDGaF3qiw380MZlv-fONbybgad2Pp__/view"), -- gic2-10
    (164, "thin section", NULL, "https://drive.google.com/file/d/1EToCOgM-Bxt7NuuzGYQ8PNmvxMl8hUWw/view"), -- gic2-11
    (165, "thin section", NULL, "https://drive.google.com/file/d/1IbBqya17XYr2UP2zJQ0A0Jt8C_JT4bQR/view"), -- gic2-12
    (166, "thin section", NULL, "https://drive.google.com/file/d/1AWPdtk_2NE0MctCDIryxSmFsw3-719ds/view"), -- gic2-13
    (167, "thin section", NULL, "https://drive.google.com/file/d/1WUlcOmljt9JnV88MCUi_yuBgWeXzvTzE/view"), -- IHD1-4
    (168, "thin section", NULL, "https://drive.google.com/file/d/1HmsmmaJFZs55UaWOS2fOD9XxDWFPLGG_/view"), -- IHD1-7
    (169, "thin section", NULL, "https://drive.google.com/file/d/1QzWhtQ7frCRUa8aaLSyJdjHfYBIoZIFD/view"), -- IHD1-8
    (170, "thin section", NULL, "https://drive.google.com/file/d/1ZUB50DcMc1sIpCX0inIc70Y-dKf0zw9M/view"), -- IHD1-11
    (171, "thin section", NULL, "https://drive.google.com/file/d/1nokkzcj8Wg3U2E42SftCmZ8RMTRloPap/view"), -- IHD1-12
    (172, "thin section", NULL, "https://drive.google.com/file/d/1v6mEFFS3GGPqqzWE2ZaYh7OM-Yj_AQYy/view"), -- IHD1-13
    (173, "thin section", NULL, "https://drive.google.com/file/d/1LS39gX22Qz8bDSZonMnzKjnqAe-NMjB0/view"), -- IHD1-18
    (174, "thin section", NULL, "https://drive.google.com/file/d/1gJYKCfVc52f4wUsaRHDNn-b7649wBhRB/view"), -- IHD1-19
    (175, "thin section", NULL, "https://drive.google.com/file/d/1Ok_jTo0LhcByrZDqsKu3t_VZ1JuWDNdW/view"), -- IHD1-20
    (176, "thin section", NULL, "https://drive.google.com/file/d/1V4Bou5JlJbZ3zvaH1eVfTgi91GK9PjPj/view"), --  KID1-1
    (177, "thin section", NULL, "https://drive.google.com/file/d/1n_Bo6GJa8EF7JV7ZXRbvRL6dhpK8JjmF/view"), --  KID1-6
    (178, "thin section", NULL, "https://drive.google.com/file/d/1H7ZCTyrTAOkFXRUZWX1ZUA2CeiTCIUCB/view"), --  KID1-8
    (179, "thin section", NULL, "https://drive.google.com/file/d/1jYwjujZ_lRQJOTdHp45fEqQO6GJA95_l/view"), --  KID1-12
    (180, "thin section", NULL, "https://drive.google.com/file/d/1s29Pw_PDhfUyRTQyRx0fU1gmD-6dYtSw/view"), --  KID1-17
    (181, "thin section", NULL, "https://drive.google.com/file/d/1DAP_xwSNO4OG64SesTpti_ScN501pEiR/view"), --  WC1-3
    (182, "thin section", NULL, "https://drive.google.com/file/d/1MKxh4zsgXqJKBj5yBw-NLj3PXCnEIR-i/view"), --  WC1-4
    (183, "thin section", NULL, "https://drive.google.com/file/d/1KQzH5fEMQA4JEOEm7YVafZGiztKk2pAE/view"), --  WC1-5
    (184, "thin section", NULL, "https://drive.google.com/file/d/102qrFoOgUxzoviDsFw9pi0Ih4Bw1S_cW/view"); --  WC1-7
    

INSERT INTO SamplePhoto (SampleID, PhotoID)
VALUES (1, 1),
    (2, 2),
    (3, 3),
    (4, 3),
    (5, 3),
    (6, 3),
    (7, 3),
    (8, 3),
    (9, 3),
    (10,4),
    (11,4),
    (12,5),
    (13,5),
    (14,6),
    (15,6),
    (16,7),
    (17,8),
    (18,9),
    (19,10),
    (20,11),
    (25,12),
    (26,13),
    (27,14),
    (28,15),
    (29,16),
    (33,17),
    (35,18),
    (37,19),
    (38,20),
    (40,21),
    (42,22),
    (49,23),
    (50,24),
    (51,24),
    (52,25),
    (53,26),
    (60,27),
    (61,28),
    (62,29),
    (63,29),
    (64,30),
    (65,31),
    (66,32),
    (67,33),
    (68,34),
    (69,35),
    (70,36), 
    (73,37),
    (74,38),
    (75,39),
    (76,40),
    (77,41),
    (78,42),
    (79,43),
    (80,44),
    (81,45),
    (82,46),
    (83,47),
    (84,48),
    (85,49),
    (86,50),
    (87,50),
    (89,51),
    (90,52),
    (91,53),
    (93,54),
    (94,55),
    (96,56),
    (97,57),
    (98,58),
    (99,59),
    (100,60),
    (101,61),
    (102,62),
    (103,63),
    (104,64),
    (105,65),
    (106,66),
    (107,67),
    (108,68),
    (109,69),
    (110,70),
    (111,71),
    (112,72),
    (113,73),
    (114,74),
    (115,75),
    (117,76),
    (118,77),
    (119,78),
    (121,79),
    (122,80),
    (123,81),
    (124,82),
    (125,83),
    (126,84),
    (127,85),
    (128,85),
    (129,86),
    (130,87),
    (131,88),
    (132,88),
    (134,89),
    (135,90),
    (136,91),
    (137,92),
    (138,93),
    (142,94),
    (143,95),
    (144,96),
    (145,97),
    (146,98),
    (147,99),
    (148,100),
    (149,101),
    (150,102),
    (151,103),
    (152,104),
    (153,105),
    (154,106),
    (155,107),
    (156,108),
    (157,109),
    (158,110),
    (159,111),
    (160,112),
    (161,113),
    (162,114),
    (163,115),
    (164,116),
    (165,117),
    (166,118),
    (167,119),
    (168,120),
    (169,121),
    (170,122),
    (171,123),
    (172,124),
    (173,125),
    (174,126),
    (175,127),
    (176,128),
    (177,129),
    (178,130),
    (179,131),
    (180,132),
    (181,133),
    (182,134),
    (183,135),
    (184,135),
    (185,136),
    (5,151),
    (14,152),
    (17,153),
    (16,154),
    (98,155),
    (47,156),
    (52,157),
    (53,158),
    (55,159),
    (59,160),
    (60,161),
    (68,162),
    (70,163),
    (71,164),
    (72,165),
    (73,166),
    (125,167),
    (128,168),
    (129,169),
    (132,170),
    (133,171),
    (134,172),
    (139,173),
    (140,174),
    (141,175),
    (18,176),
    (23,177),
    (25,178),
    (29,179),
    (114,181),
    (115,182),
    (118,183),
    (119,184);


--  Below are insert statments generated by datascraping.py

INSERT INTO Outcrop (ID, Description, Location, 3Dmodel, OrthophotoID) 
    VALUES ("SG6","Small tributary of Spring Gulch on NortAUTO_INCREMENTh Side of Spring Gulch on a south-facing slope. 1st order drainage. Hillslope continuously mantled in thin colluvium with sparse exposures of bedrock. Colluvium ranges in thickness from 30 cm to 80 cm from bottom of site to top. The site is approximately 10 meters from bottom of drainage. Backslope of hillslope; slope shape is linear. Frenchman Springs overlain by Umatilla basalt.",Point(-118.913026, 46.0077),"https://cloud.pix4d.com/dataset/1540228/model?shareToken=b20c98de-6000-41c2-a213-67660ebdbd9c", 137), 
    ("KID1","Along the Kennewick Main Channel (irrigation canal) in the roadcut (channelcut?). On a northwest facing slope with Pomona, Ice Harbor, and Elephant Mountain basalts. The hillslope below the outcrop is covered in sagebrush and talus slopes of Ice Harbor (?) basalt. In the outcrop, the overlying basalt is likely Ice Harbor, the lower basalt is likely Elephant Mountain, and a soil is present between them.",Point(-119.274435, 46.181069),"https://cloud.pix4d.com/dataset/1555260/model?shareToken=0ed39edc-7a57-420a-a2cb-5b8f9b1d6683", 138), 
    ("MFQ1","An active quarry south of Milton Freewater, OR. Mapped as a contact between the Umatilla and Frenchman Springs basalts. There's significant modern soil development on top of the Umatilla flow. The site itself is at the north end of the quarry and is found on the west facing slope. The basalt is not very weathered and is largely competent. Beneath the site is a significant slope of talus and other fine sediment.",Point(-118.395846, 45.869212),"https://cloud.pix4d.com/dataset/1544866/model?shareToken=16a8214e-9b75-4b3c-865c-b9372968aa1e", 139), 
    ("GIC1","Downriver from the Ice Harbor Dam on the east side of the Snake River. Northwest facing hill slope. Solid columnar basalt with significant weathering at surface exposed as a cliff-face. The contact between flows is right above the base of the cliff, although there is a clay-rich layer below the presumed contact that may represent another contact within Ice Harbor flows. The first identified contact appears platy above, with columnar cooked/lithified aggregates below.",Point(-118.913513, 46.241402),"https://cloud.pix4d.com/dataset/1547504/model?shareToken=c8dc2387-3eea-4b96-9c68-524039fb1bb4", 140), 
    ("GIC2","Downriver from the Ice Harbor Dam, but closer to the dam than GIC1. On the east side of the Snake River. NNW facing hillslope. Outcrop was elevated, at top of slope covered with talus and vegetation. Contact from GIC1 is exposed at about 2 meters above standing point on slope, contact with ash is at about 1.5 meters.",Point(-118.913181, 46.24155),"https://cloud.pix4d.com/dataset/1548806/model?shareToken=5b9ff26c-40f3-4911-9998-0dca47e64161", 141), 
    ("WC1","Road cut making a WNW hillslope along Webber Canyon road. Modern soil and vegetation above, then overlying basalt (crumbly + unstable fractured), then paleosol with clasts. Basalt below, likely Pomona, is buried in colluvium and angular talus (especially after basalt falls from layer above) with clayey mud below forming a slope towards the road.",Point(-119.457662, 46.185472),"https://cloud.pix4d.com/dataset/1552894/model?shareToken=f3cbe09b-4a2a-4af9-aeae-add5f30da3cd", 143), 
    ("WC2","Slightly further north than WC1 but along the same roadcut facing WNW. To the left of the site was thick layers of modern carbonate between the modern soil and basalt below. Modern soil with grass and sagebrush is above the outcrop, then crumbly basalt mixed with a finer sediment matrix and roots. Below basalt is a gley colored wavy layer like the smaller area at top of columnar structure layer in WC1. It has clasts and appears to be part of a flame structure maybe. Under the blue is a columnar ped(?) layer before going into Pomona basalt float with finer soil as the matrix. The lowest layer is solid Pomona basalt, and underneath is just talus and finer sediment that slopes down to the road.",Point(-119.457419, 46.185941),"https://cloud.pix4d.com/dataset/1552901/model?shareToken=21005617-a4c3-4d99-9f6b-9184e10156c3", 144), 
    ("WC3","Opposite hillslope from WC1 and WC2 on the ESE facing hillslope. Slope is mostly covered with colluvium and grass with some exposed Elephant Mountain and Pomona basalts. Site was a contact between EM and Pomona, with both found exposed at the surface of the slope nearby. Apparant soil development between the two flows when colluvium was cleared away.",Point(-119.458592, 46.185901),"https://cloud.pix4d.com/dataset/1554158/model?shareToken=1a9c4780-0dc4-4362-8593-24d196fcfbdd", 145), 
    ("IHD1","On northwest facing slope on a cliff to the northeast of the Ice Harbor dam and the Indian Monument. Along the Snake River, the outcrop is NE of the Goose Island Cliff (GIC) sites. The cliff itself can be access via a roadgrade that decends from the Indian Monument parking area and consists of cliffs of columnar and more rubbly basalt (the top cliff with a radial structure on southern end that's interpreted to be a lava tube), colluvium, loess, and vegetation. The outcrop is immediately below the top set of columnar basal and is a long vertical trench that reaches down to the basalt below.",Point(-118.8755, 46.246063),"https://cloud.pix4d.com/dataset/1560657/model?shareToken=52b4ff24-1dac-45fe-acc6-7fbe1ae3f63d", 146), 
    ("SGQ1","Exposed cliffs of columnar Umatilla basalt along entrance road to Spring Gulch, east of the SG sites. Above the cliff is a field with about a meter of loess, modern soil, and grass. It's a southeast facing hill slope where the cliff wall is unstable/separating from base and there's spheroidally rounded talus beneath. The base of the outcrop has been flattened by people for quarrying purposes.",Point(-118.898303, 46.005325),"", NULL), 
    ("TC1","Southeast facing hillslope. Contact between Grande Ronde basalt flows (N2 and R2) with a modern soil developed on top. While the contact itself is part of a basalt cliff, the outcrop is part of a larger hillslope. Upslope of the outcrop are basalt columns sticking out of the grass (at least 10m above). The outcrop is at the base of a drainage from the slope above, and the upper surface of the upper basalt tilts downward to the left (toward the drainage). There's a very thin modern soil directly above the upper basalt with lots of grass. Below the top flow is red rubbly vesicular basalt facies. The lower basalt is very vesicular and fractured.",Point(-118.046308, 45.982907),"https://cloud.pix4d.com/dataset/1564700/model?shareToken=9e7d8756-e91d-4b26-92d1-f214257211c2", 148), 
    ("TC2","An outcrop showing the development of a modern soil on top of the Grande Ronde basalts. It's at a bend on the road with another road diverting off just below. The outcrop is on a west facing hillslope/roadcut with shurbs and grass in a variably thick soil above basalt. The soil had lots of roots and is above spheroidally weathered basalt clasts. Buried in the talus and fine grained weathered basalt is more basalt that is crumbly and more priable(?) than what it's below. The outcrop is about 2 meters above the road surface and is near the top of the sloped surface.",Point(-118.016742, 45.942744),"https://cloud.pix4d.com/dataset/1564758/model?shareToken=a9b84936-4717-463f-a41b-b25e68224b1e", 149), 
    ("BM1","Basalt cliffs exposed in a roadcut along the road to Jubilee Lake. Down the road from the outlook/pull out where Dylan worked on BM2. It's a south facing hillslope with a contact between the upper Lookingglass Basalt (rubbly and columnar) and the lower Grande Ronde N2 (vesicular and fractured). Between the two basalt flows is a very red layer with core stones and paleosoil. Above the upper Lookingglass basalt is a shallow slope with grass and shrubs. Below the outcrop is a talus pile with basalt clasts of various sizes. The Frenchman Springs basalt is also visible on the same hillslope, exposed near the top of the slope to the right of the outcrop.",Point(-118.046241, 45.775223),"https://cloud.pix4d.com/dataset/1566671/model?shareToken=5a4804b0-423e-4da5-9b06-7f88eb21dfdb", 142),
    ("WEH1","On old paved road off of Oregon HW 204, the Weston-Elgin Highway. The contact between Grande Ronde N2 (lower) and Lookingglass (upper) is exposed in a roadcut along the highway, but is closer to road level (about 2 meters up) around the corner in the outcrop. Between the two basalt layers is a very red layer with vesicular basalt and red clay-y to more solid material. The Lookingglass is unburied and visible all along the roadcut, but the contact and lower N2 basalt was mostly buried. Below the outcrop is a mix of fine grained sediment and basalt talus. It's a southeast facing hillslope.",Point(-118.119597, 45.787658),"https://cloud.pix4d.com/dataset/1568965/model?shareToken=bab13421-5184-4829-9484-b88aa678391f", 150);


--  Need to fix first column to work with table:
INSERT INTO StratLayer (OutcropID, LayerNumber, Description, TopDepth, BottomDepth)
VALUES ("SG6",1,"A-horizon. Frequent fine roots, very slight darkening, greyer in color, less gravel, dominated by sands and silts", 72, 69),
    ("SG6",2,"C1 horizon. Silty sandy C, rock fragments of basalt up to 3cm in width. Angular, fine to very fine roots.", 69, 60),
    ("SG6",3,"C2 horizon. Lower boundary is abrupt and irregular, coarse-fragmented horizon with clasts up to 5cm, deposition of CaCO3 rinds on bottom of basalt clasts", 60, 47),
    ("SG6",4,"Relatively unweathered Umatilla basalt. Fractured, not very vesicular. Max joint distance 20cm in the veritcal direction and horizontal fractures are 1-5cm apart.", 47, 0),
    ("SG6",5,"'cooked layer,' top of Frenchman Sorings basalt. Surface with white top of layer that did not fizz when HCl was applied. Manganese oxides present. Thin horizontal fractures with bright red streaks of presumably cooked minerals. Upper contact us abrupt and wavy.", 0, -8),
    ("SG6",6,"Upper contact is smooth and clear. 'pebble layer' verticle fractures spaced every 3-5mm that are filled with yellowish greenis redistributed sillicas or clays. Series of horizontal fractures that are very fine, mm in spacing. Pebbly material is dark brown-dark red in color, little evidence of primary minerals present. Bigger pebbles on bottom of layer, smaller pebbles near top of layer. Lower contact is abrupt and irregular. ", -8, -29),
    ("SG6",7,"more competant spheroidally weathered vesicular basalt. Vesicles are filled with powdery oxides. Likely Fe and Mn oxides. This basalt is heavily weathered to a purple-ish color.Sugary/powdery crystalline material in vesicles, flaky yellowish powder, red infillings. Silica crust.", -29, -70),
    ("SG6",8,"abrupt and wavy upper boundary. Model layer, ledge/step former. Vesicular, up to 1cm in size, less weathered, more resistant than overlying layer. Less infillings of orangey material. White material fizzes with HCl, likely accumulation of CaCO3.", -70, -79),
    ("SG6",9,"more resistant, deeply weathered basalt with lots of colors. Reddish and orange indicating mire intensely weathered between cores of basalt. Less weathered basalt still has vesicles completely filled with material that looks like clays, representing intense weathering of basalt and little primary minerals present.", -79, -100),
    ("SG6",10,"deeply weathered basalt with more resistant corestone-- interiors of corestones behave more like rock and less like sapprolite. Entire layer graded top dowb from more to less weathered. Cores at bottom are darker and less weathered, most vesicles filled . Pervasive vertical and horizontal joints filled with CaCO3 corresponding to its position near modern colluvium. Between corestone: black-green-grey fine-grained matrix, can break apart with fingers, no distrinct basalt clasts. Stage 4 saprolite? Deeply weathered with some primary vesicles present.", -100, -155),
    ("SG6",11,"More weathered bedrock, 45 cm thick. Slightly vesicular basalt, thuds with hammer. Vesicled filled with reddish or yellowish material. Chemical alteration present. Corestones are 5 to 25 cm wide.", -155, -200),
    ("SG6",12,"vesicles and CaCO3 decreasing as you go down the layer. Very unweathered. light reddening on fractured surfaces.", -200, -250);

INSERT INTO StratLayer (OutcropID, LayerNumber, Description, TopDepth, BottomDepth)
    VALUES ("KID1",1,"Interior of the Ice Harbor (?) basalt, weathered. Jointed, not vesicular.",300,20),
    ("KID1",2,"Base of Ice Harbor (?) basalt. Platey with horizontal fracturing. Upper boundary is wavey and abrupt.",20,0),
    ("KID1",3,"Cooked sediment below base of Ice Harbor basalt. Upper contact is abrupt and smooth. Sediment is homogenous with no visible aggregation. Grain size is fine grained (silt to clay) with some potential fine sand grains. Color is mostly grey with some occasionally lighter portions.",0,"-7.5"),
    ("KID1",4,"Sediment between Ice Harbor (?) and Elephant Mountain (?) basalts, below cooked sediment. Upper contact is wavey and abrupt. Vertical cracks visible on the surface along the entire layer. Aggregates are present but small (sub-centimeter in width), could be A (?) or B (?) horizon. Grain size is fine grained. Potentially modeled or has larger grains of differing color (fine grained sand).",-7,-37),
    ("KID1",5,"Lowermost layer of sediment above the Elephant Mountain (?) basalt. Upper contact is gradual and smooth. Bt horizon (clay rich) with vertical cracks along height of layer visible from the surface. Blocky to subprismatic aggregates (longer than wide). Aggregates range in size, over cm wide, 3-5 cm tall.",-37,-64),
    ("KID1",6,"Uppermost Elephant Mountain (?) basalt. Platy and heavily vesicular. Upper boundary is smooth and wavey. Horizontally fractured. Mostly competent but some surface crumbled when brushed. The surface of the basalt was red, and the vesicles were mostly empty.  ",-64,-84),
    ("KID1",7,"Interior of Elephant Mountain (?). Upper boundary clear and wavey. Lower boundary not visible. Massive, reddened, vesicular. Vesicles are larger and more prevalent at the top of the layer.",-84,-220),
    ("KID1",8,"Stream channel deposits with all abrupt bounds. Contains heavily weathered vessicular basalt (Elephant Mountain float?) of significantly varied sizes. Lower boundary is with layer 5.",0,-64);

INSERT INTO StratLayer (OutcropID, LayerNumber, Description, TopDepth, BottomDepth)
    VALUES ("MFQ1",1,"criptobiotic crust on outer layer of modern soil. Loess at thickest part of outcrop is >90-45 cm above contact. Cracks from repeated wet-dry cycles. Mostly horizontal cracks, some vertical. Lower boundary is wavy and clear.",90,45),
    ("MFQ1",2,"calcrete without basalt clasts present. Calcrete chunks ranges from 10 cm to 2cm in width. Calcrete clasts are sub-angular, wider than they are tall, suspended in loess matrix. Stage 4 carbonate. Lower boundary is wavy and clear.",45,25),
    ("MFQ1",3,"Basalt clasts coated in CaCO3, relatively unweathered on the inside. Fractured bits of Umatilla flow also suspended in loess matrix. Basalt is brownish red in color. Lower contact is wavy and clear.",25,15),
    ("MFQ1",4,"Basalt clasts become smaller in this layer, 2cm to sub-cm in width. Angular clasts with no vesicles present. CaCO3 and loess matrix more cemented in this layer than overlying layer. CaCO3 is less crumbly and less fractured. CaCO3 is platy and layered across the outcrop. Farther down you go and the closer to the underlying basalt you get, the more layered the platy carbonate becomes. Lower contact is wavy and abrupt. ",15,0),
    ("MFQ1",5,"angular basalt clasts lifted from rest of bedrock by loess and dust collecting in rock fractures. Aeolian material/accretuinary soil development and carbonate precipitating down. More vertical than horizontal fractures. Basalt clasts are 2X8cm rectangular with no vesicles and very unweathered. Thinly layered carbonate/ soil (?) on bottom of clasts. ",0,"-22.5"),
    ("MFQ1",6,"unweathered bedrock with no vesicles or carbonate. Vertical fractures present, few horizontal. Less advanced fracturing as basalt from layer 5. Dark grey/brown. Light iron-banding present. Upper contact is abrupt and wavy.",-25,-200);

INSERT INTO StratLayer (OutcropID, LayerNumber, Description, TopDepth, BottomDepth)
    VALUES ("GIC1",1,"Interior of an Ice Harbor basalt flow (assumed to be Goose Island). Maybe 2.5 to 3.5 meters in thickness. Basalt is non-vesicular with spheroidal weathering. Forms vague columns, vertical fracturing is more obvious and prevalent (at large scales) than horizontal fracturing. It has a lot of lichen on its exposed surfaces and has an oxidized surface that varies in color from red/yellow/greenish grey. It pings when hit with a rock hammer, which suggests the rock is more oxidized than weathered.",400,115),
    ("GIC1",2,"Basalt layer beneath overhang of overlying basalt. It gives variable pings when hit with a rock hammer, suggesting variable intensity in weathering. Highly vesicular consisting of very small vesicles that are slightly larger at top of layer. The very top of the layer, where it meets with the layer above, has a flaky appearance like that of a weathering rind. The layer is red/orange/grey in color, and some of the flaky sections are more red that their surroundings. The upper contact is wavy and abrupt, and the lower contact is irregular and abrupt. The layer isn't present across the entire area but is present within this site. The vesicular basalt (not flaky section) was too hard to easily sample by breaking with a rock hammer.",115,85),
    ("GIC1",3,"Flow bottom breccia? Extremely variable layer with multiple unique features repeated throughout. Consistently platy basalt surrounding angular to spheroidally weathered basalt clasts (7cm tall and wide at middle basalt layer). Highly fractured basalt with some spheroidal weathering. Platy element of the layer is significantly more wavy on the left side of the outcrop. Small vesicles are present in some of the basalt clasts and crumbly bits. The basalt clasts are fiarly consistently darker (red/dark grey) than the crumbly bits. Because of the crumbly bits, the layer has more horizontal than vertical fracturing.",85,43),
    ("GIC1",4,"Repeated layers of thin fractured basalt (horizontal and platy) and blockier basalt layers. Color is more white in the blocky layer, more red in the platy layer. The platy layer is very crumbly and hard to remove as a solid chunk. The lowest element of the layer is solid blocky basalt with spheroidal weathering. The blocky layers appear more like basalt at the base, but look more like concrete in layers above (vesicular, 4cm basalt on the left side of the site, smaller on the right). Upper bound is abrupt and wavy, lower bound is clear and wavy.",43,18),
    ("GIC1",5,"Lightly weathered 15-30cm between vertical fractures. Lots of tiny vesicles. Sub-angular basalt clasts. Some white coating on basalt. Basalt in this layer varies in color from light grey to dark grey/brown. Lower boundary is clear and wavy.",18,0),
    ("GIC1",6,"Fine grained red sediment at very top of layer right at the contact. Large Prismatic aggregates that range in color from dark grey to red. 25cm in length, 10 cm in width. Some are significantly smaller down to a couple cm and get larger towards the right end of the outcrop. These peds are strongly columnar.",0,-39),
    ("GIC1",7,"very red and besicular basalt with light yellow-white streaks on some faces. More vertical fractures than horizontal. Carbonate precipitation/accumulation. Manganese and iron oxides present. Moderately to loghtly weathered overall in this layer. ",-39,-54),
    ("GIC1",8,"pebbly layer, some larger weathered angular clasts in a fine grained weathered basalt matrix mixed with modern sediment/dirt accumulation. Easily breakeble, not very competent. More modern dirt/soil(?) accumulation on left side of outcrop.",-54,-62),
    ("GIC1",9,"very vesicular basalt that is moderately weathered. Light grey in color with some red. Vesicles are larger at the top of the layer but generally small-moderately sized, <2.5 cm in width. More vertical than horizontal fractures. ",-62,-76),
    ("GIC1",10,"minutely layered clays with small basalt fragments at top which are angular and sparse. Outer layer is more brown and clay-rich. Once scraped away on inner, a more dense layer was revealed. Thin white bands within layer, possibly clay or condensed ash, can scrape with a trowel but dense. More horizontal than vertical cracks. Overall kind of blocky texture. Upper boundary is abrupt and smooth, lower boundary is also abrupt and smooth.",-76,-88),
    ("GIC1",11,"Vesicular basalt, bottom flow, likely martindale. More vesicles at the top than at the bottom of exposed basalt. Lighter grey at the top. No vesicles are filled. Red and purpley oxides on rock races, likely iron and manganese oxides. Moderately weathered variably in fractures and am able to dig the basalt out with a trowel, especially in areas where fine-grained white material is present. The whole layer is weathered at the surface and able to be dug out with a trowel, down to the bottom of the outcrop. STill slightly vesicular at the bottom but less-so than the top. ",-88,-143);

INSERT INTO StratLayer (OutcropID, LayerNumber, Description, TopDepth, BottomDepth)
    VALUES ("GIC2",1,"More solid basalt, some spheroidally weathered columns. White material precipitating down, likely modern CaCO3. lLeast weathered rocks exposed in outcrop. Suspected Goose Island flow above upper Martindale (Indian monument) overlying lower Martindale. No vesicles present. Overall color is red to dark grey/brown. Not very weathered, very pingy when hit with a rock hammer. Bottom contact is clear and smooth. ",250,52),
    ("GIC2",2,"Platy layer, more horizontal than vertical fractures, brown/dark grey, white material accumulating in the joints, as well as modern brown sediment. Not very vesicular from what we can see. Potential flow bottom breccia? Bottom contact is clear to gradual, variable across contact, and wavy. ",52,37),
    ("GIC2",3,"Basalt clasts have similar fracturing pattern, still slightly platy with lots of tiny vesicles that are more squished at the bottom of the layer. Variable in size. Variable degrees of weathering throughout layer. Mre vertical fractures in this layer than overlying layer. Color is dark grey to dark brown, some light-brown to yellowish oxidation on some faces in this layer. Some crumbly basalt in middle of layer. SOme vesicles filled with yellow material. Pahoehoe texture on bottom part of layer.",37,0),
    ("GIC2",4,"The contact! Light grey at the top, grey-blueish in the middle which grades down to red oxides at the bottom. Very vesicular, looks like cooked, oxidezed soil. Below the contact is the columnar peds/aggregates which are dark grey to black and covered in yellow material/secondary minerals. Right side of outcrop their structure becomes blockier and less columnar, widths become more equant. Some very crumbly white layer/material. present. Within the aggregated are large, suspended vesicular basalt clasts ripped up from underlying flowtop. Clasts are sub-angular to rounded. Some more vesicular than others. Some vesicles in selected basalt clasts filled with same yellow material covering aggregates. ",0,-51),
    ("GIC2",5,"reddened vesicular basalt below aggregates. Lots of vesicles ranging in size. Some fractures, more vertical than horiizontal. Vesicles coated with white and yellow secondary clays and oxides. Plagioclase crystals present. Very fine grained basalt with few phenocrysts. Not very weathered, still pretty resistant. Blasted/weathered primary minerals that were weathered to a different mineral.",-51,-82),
    ("GIC2",6,"Upper contact is wavy and abrupt, lower contact is irregular and abrupt. White super fine grained solidified/lightly lithified ash. Top of ash has embedded vesicular, unweathered but broken basalt clasts with unfilled vesicles. Pebbly texture on top. Texture becomes smoother halfway through layer. Right side of outcrop is an ash overhang where lower boundary extends beneath surface, greater than -185cm. Tiny angular ripped up basalt clasts embedded within ash layer. ",-82,-145),
    ("GIC2",7,"upper contact is irregular and abrupt, lower contact is irregular and abrupt. Vesicular, lots of yellow and red oxides. Some vesicles are filled with secondary yellow and white minerals. Still resistant, more vertical than horizontal fractures. Modern yellow powdery material on the outside/underside of ash layer.",-145,-185);

INSERT INTO StratLayer (OutcropID, LayerNumber, Description, TopDepth, BottomDepth)
    VALUES ("WC1",1,"Suspected elephant mountain flow, not super weathered but highly fractured, basically brecciated and not vesicular. Some iron banding but other than than I don't see much secondary mineral accumulation/precipitation. Very thin modern soil at very top where plants are growing. Modern dirt/loess covering most of upper rock faces that we could not reach to clean off. Lower boundary is wavy and clear. ",390,90),
    ("WC1",2,"Fractured flow bottom of potential elephant mountain. pervasive vertical and horizontal fractures, more horizontal than vertical. Lower boundary at outcrop is abrupt and clear. No vesicles, dark grey, brown, red, greenish in color. Few oxides, no secondary mineralization, pretty unweathered appearance overall. Very pingy when hit with a rock hammer. ",90,0),
    ("WC1",3,"Lower boundary is abrupt and irregular. Upper part of layer there are columnar aggregates/structures with small angular and unweathered basalt clasts in them. Blueish grey in color with light yellow/orange mineralization on the outside. white material also present in joints/cracks. Large vesicular clasts suspended within this paleosol. Clasts range from 10cm to 38cm in diameter. Soil development present beneath clasts and on sides of them, likely floating due to loess and dust accumulating in joints and pushing chunks of vesicular basalt from upper suspected pomona flow up and away from bedrock. Most floating clasts are angular, some are rounded and less vesicular. Clasts towards upper layer have same mineral coating and coloring as the structures. ",0,-68),
    ("WC1",4,"Vesicular flowtop of suspected pomona flow. fractured but not as fractured as elephant mountain. Vesicles are bigger towards the top. Blocky fractures, equal amount of vertical and horizontal fractures. Little secondary mineral accumulation, some dark yellow mionerals filling vesicles, evidence of Diagenetic processes. Some iron banding present. Most vesicles unfilled, but a lot of them have a yellow coating. Potentionally common opal? ",-68,-100);

INSERT INTO StratLayer (OutcropID, LayerNumber, Description, TopDepth, BottomDepth)
    VALUES ("WC2",1,"Modern soil seen from a distance, could not get that close to it because of its position on a steep unstable slope. It is dark brown in color and abou a foot deep. Can't see any distinct horizons from where I'm standing. ",200,168),
    ("WC2",2,"Suspected elephant mountain flow that is auto-brecciated and highly fractured, very vesicular, and fragmanets are very angular. Color is dark grey to dark brown. Upper boundary is smooth and clear while lower boundary is abrupt and irregular. Pahoehoe present in this layer indicating it is a flowtop",168,30),
    ("WC2",3,"Right side of boundary exposes evenly spaced columnar structures with yellowish whitish mineral accumulation, columnar structure potentially from how it cooled. Overall color of this layer is a blue-grey gley. Wen broken off the columns behave more like mildly weathered basalt than soil. Columnar structure stop 12cm down before transitioning into a blocky texture. Just like blue section from WC1. Large sub-rounded vesicular clasts suspended within blueish layer, ranging from 12cm to 22cm in width. Potentially some kind of rip-up from top of underlying pomona flow. ",30,0),
    ("WC2",4,"Upper contact is wavy and abrupt. Arguably gradual in some sports along the outcrop. Structure of blueish sediments is more elongated and prismatic with more white, yellow, greenish mineral precipitation on it. Pervasive vertical and horizontal fractures, more vertical than horizontal. At he bottom of the layer there are a couple of large, lifted, angular vesicular pieces of pomiona. Lower contact is wavy and gradual. More fractured at base of this layer.",0,-45),
    ("WC2",5,"Transitional layer. More frequent large vesicular clasts of pomona, 18 to 40cm in width. Structures in this layer are smaller, more blocky, less columnar than overlying layer. still very fractured. more white mineral coating these structures than overlying layer and less gley color at the surface than overlying layer. Lower contact is gradual and wavy.",45,-70),
    ("WC2",6,"More vesicular basalt clasts that are lifted. pretty fine-grained wettish sediment between clasts. yellow, white, and light brown overall in color. The white material specifically veins throughout the profile, potentially carbonate from being near the surface. Occasional black and yellow spots of material within this layer. This clay-like material boundaries all the lifted clasts in this layer. less weathered vesicular basalt clasts, angular, found occasionally within clay material. ",70,-105),
    ("WC2",7,"Pomona basalt, pervasively fractured bith vertically and horizontally. Not very vesicular, some modern carbinate veins on outermost basalt. Similar amount of vertical and horizontal fractures. Basalt is fractured but otherwise appears to be pretty unweathered. Light to dark grey in color. Inconsistently vesicular lower down in exposed pomona. ",105,-200);

INSERT INTO StratLayer (OutcropID, LayerNumber, Description, TopDepth, BottomDepth)
    VALUES ("WC3",1,"Modern soil on top of crumbly Elephant Mountain basalt. No obvious soil horizons, lots of grass growing. most visible soil covered with cryptobiotic crust. Fine grained, likely loess dominated. slopes downward, not a cliff so it's hard to gauge actual depth. Lower boundary appears to be wavy and clear but it's hard to tell because of slope and instability of the layers on either side of the boundary.",100,90),
    ("WC3",2,"Highly fractured, more horizontally than vertically, non-vesicular basalt, expected to be Elephant Mountain based on Rockd map. Pockets/areas of more platy to blocky structure distributed throughout layer. Surface has some dark blue to orange oxidation but the exposed surface of the basalt is mostly tan to grey/blue. Largest solid basalt pieces (non-fractured) are a max of 24cm with most being around 10cm. Filling/coating the inside of the fractures are oxides (green, purple/blue, orange) that have accumulated. top half of layer was not buried and has some evidence of spheroidal weathering. lower half of layer was partially buried and is more angular. ",90,0),
    ("WC3",3,"Upper boundary abrupt and wavy. lower boundary is gradual and wavy. Pebbly structure of dark grey/blue color. Orange to yellow material found inbetween every pebble structure near the top of the layer close to the contact (where there's more pebbles that are crumbly/easy to remove). Yellow material lower in the layer is confined to vertical veins. between the veins, the bluish material appears more columnar than above, has no orange/yellow between structures, but still crumbles at surface. At the contact itself, there's some modern soil.",0,-40),
    ("WC3",4,"Mostly the same as the layer above. Slightly lighter in color (lighter grey to slightly gley color) with a more cohesive structure (no columnar/pebbly structure that crumbles easily). Less obvious vertical fractures. very fine grained. Lacks the orange/yellow material that was abundant in the layer above. Lower boundary is abrupt and wavy. Feels more like a soil than layer above, feels clay-like when scraped with a trowel. Has some larger chunks of more solid basalt saprolite.",-40,"-52.5"),
    ("WC3",5,"Depth varies throughout outcrop, depends on highest basalt from Pomona layer below. Found right above the very top of the bedrock and below layers 3 and 4 that look more like soil. Lower boundary is abrupt and wavy where it meets with basalt. Very base of layer has green, yellow, tan very fine grained minerals at surface of basalt. Lower half also has weathered basalt clasts covered with clay, non-vesicular. More crumbly appearance at top with larger seeming grains (although they disintigrate with force). Top is mostly dark grey with white streaks (crumbles to almost salt + pepper appearance). Behaves more like a soil than overlying saprolite.","-52.5",-67),
    ("WC3",6,"Vesicular basalt, suspected Pomona. Some upper vesicles coated with orange and white material. Surface of the dug out top of flow appears tan to white in color. Vertical faces  that were not buried are more reddish in color, vary from pink to red/orange. Top is fractured with variable ping when hit with rock hammer (very top has dull thud while base of exposed Pomona in scan had good ping), suggests varied degrees of weathering throughout basalt. Some parts of the top on the left have clay material at surface that can be scratched off with trowel.",-67,-400);

INSERT INTO StratLayer (OutcropID, LayerNumber, Description, TopDepth, BottomDepth)
    VALUES ("IHD1",1,"Columnar basalt that becomes less obviously structured higher in the layer. Bluish grey in color. Platy at the lower boundary with some clasts detaching and being mostly in place but suspended in fine grained sediment. Top surfaces with infrequent fractures, covered with lichen, spheroidally weathered.",400,0),
    ("IHD1",2,"Upper boundary is clear and wavy, lower boundary is clear and wavy. Characterized by red color in sediment between basalt clasts. Basalt is spheroidally weathered with a dike present cutting through the left of the layer (and the layer below). The red sediment layer is pebbly with some larger weathered basalt clasts. Some of the sediment is grey in color. Rounded basalt clasts range from about 8 to 11 cm in width. White at bottom of clasts likely to be modern carbonates. ",0,-20),
    ("IHD1",3,"It's almost a shelf-forming layer, where the layer covers more area vertically than horizontally. Characterized by white, stratified layer within the basalt (carbonate? ash?). Basalt is dark blue in color with some limited red oxidation. More 'solid'? basalt. Very vesicular with yellow mineral filling vesicles. The surface of the basalt is uneven. Has a glassy look on fresh surface, massive, nonfractured. ",-20,-25),
    ("IHD1",4,"Characterized by yellow sediment layer visible to the left of the dike. While the yellow is present in the layer above, it's only visible at the surface through layer 4. The yellow sediment is less fine grained than the red sediment, and while it crumbles, there's some larger grains that don't break apart. Yellow sediment also had red grains of varying sizes (maybe chunks of weathered basalt). There's also vesicular basalt like the layer above that's present through the upper 3/4th-ish of the layer. Base of layer is made up of vent facies, very vesicular basalt to fine grained bedrock scoria. The scoria had yellow sediment/mineral at the surface.",-25,-60),
    ("IHD1",5,"Partially shelf forming scoria. Different texture than the massive bedrock scoria from the layer above. Surface of the rock is very light colored (white to tan) about 10 cm below the top of the layer. Above that point is slightly darker (light grey) and more platy. The whole layer has a very dark interior of scoria with vesicular grains visible under hand lens. No obvious fractures. The base of the scoria grades into a dark grey clay (the color change is abrupt but the change in texture is gradual). Upper boundary is abrupt and smooth. Lower boundary is gradual and smooth.",-60,-90),
    ("IHD1",6,"Grey to gley colored clay rich layer. Uniform color through most of the layer (with the exception of red clast) and easy to scrape with trowel. The clast in the layer was below the surface/completely buried in grey sediment and is rust red, about 7cm in length. It's mostly fine grained/clay with the exception of some larger resistant grains. The lower boundary is gradual and clear.",-90,-130),
    ("IHD1",7,"Upper boundary gradual. Under the surface is light colored. Sediment is fine grained, but the white colored material is coarser grained than the gley colored material above. The layer has areas of beige, light/dark grey, and greenish colors that grade into each other. Some white spots are harder/more solid, maybe CaCO3 (didn't test fizz). Harder white grains are about a cm in width and are sparce. The layer also forms a shelf, and the surface of the shelf has fewer white spots but more lighter grey spots that are less solid.",-130,-173),
    ("IHD1",8,"Ash layer. Upper boundary diffuse and wavy. Made up of white ashy material with beige bands crossing each other within the white layer. The white material also has roots in it, could be modern. There's dark red spots present throughout the layer that could be oxidized angular basalt. The white ash is mildly stratified. Moving down the layer, the color changes from majority beige to majority white. More common lower in the layer are dark stringers of maybe basalt scoria ash. These stringers are about a cm in width and are horizontal. They're more soild than the surrounding ash and cannot easily be dug with a trowel.",-173,-208),
    ("IHD1",9,"Vesicular basalt at the top of the lower unit. Super vesicular, fairly small vesicles (sub cm) but very common. Some of the vesicles are coated in greenish/yellow material on the inside. Super pingy when hit with rock hammer. Fractured both horizontally and vertically. Overall color is a light grey but there's also dark blue oxides and light blue precipitated minerals in vesicles. The top of the unit forms a shelf, but it's very fractured and uneven.",-208,-241),
    ("IHD1",10,"Upper boundary is gradual and wavy. Layer is same basalt as above (lower unit) and has consistent horizontal and vertical fractures. The main difference from the layer above is the vesicles, which are larger and less frequent as we move further down the layer. Vesicles get up to about 2cm.",-241,-300);

INSERT INTO StratLayer (OutcropID, LayerNumber, Description, TopDepth, BottomDepth)
    VALUES ("SGQ1",1,"A' soil horizon with grass above. Fine grained with visible sub-cm sized aggregates found around/attached to roots. Because we are on a slope towards the cliff, the sample was taken from a higher elevation and further back on the slope.",85,70),
    ("SGQ1",2,"Upper and lower boundaries are gradual and smooth. Bw horizon (weak/weathered). Fewer roots than above. Less abundant but slightly larger aggregates (still sub-cm, 1/2 cm at the largest) groups around roots. Loess/tan color, but slightly lighter/more white than the A horizon above.",70,48),
    ("SGQ1",3,"Bk horizon, lowest horizon of the soil above basalt. Lighter in color than soil above. Harder to dig out, so more firm/concreted. Roots less common but still prevalent. Occasional aggregates around roots, larger than above (1 to 2 1/2 cm in width). Lower boundary abrupt and wavy. No difference in grain size from the layers above. May have some cm size carbonate clasts at the very base of the layer.",48,0),
    ("SGQ1",4,"Unweathered Umatilla basalt, mostly exposed at the surface due to human quarry activities. From the top, appears like a basalt breccia with carbonate matrix. No carbonate at the top, but abundant below clasts and on sides of some. Basalt clasts are mostly angular but with some more rounded clasts. Very surface of basalt clasts has some dark blue oxides and almost occasionally pitted surface appearance but the interior is dark grey, unweathered, and nonvesicular. Going down the cliff, there's more unweathered basalt with a variety of basalt facies present.",0,-654);

INSERT INTO StratLayer (OutcropID, LayerNumber, Description, TopDepth, BottomDepth)
    VALUES ("TC1",1,"(+)1.5m to contact overlying basalt, vertically fractured.Kind of columnar in how it fractures. Sparse vesicles towards bottom of flow, some are squished. All are sub-cm in width. Some spheroidically weathered clasts exposed out of surface/top of flow. Overall color is dark brown, some greys and mild oxidation. Lower boundary is abrupt and wave. More horizontal/ platy fracturing towards bottom of contact",150,0),
    ("TC1",2,"0 to (-112) cm upper layer is very vescicular basalt, borederline scoria. Basalt is very red and some vesicles are filled with yellow and white minerals that also fill fractures. Vesicles gradually increase in size and quantity throughout the upper layer. The whoile layer is highly fractured.Yellow/white materials prevelant on the right side of the outcrop. No soil develoipment. Large clasts of vesicular basalt that are less oxidized and less weathered than surrounding red basalt. Layer grades down from being mostly grey to mostly red in color. Some dark red/ purple oxides lower in layer",0,-112),
    ("TC1",3,"(-) 112 to > 300cm. Fractured, vesicular lower basalt. Likely R2 flow of Grande Ronde. Very vesicular at top, more competent and less fractures starting around a meter down. Upper layer is crumbly with vesicles ranging in size. Same amount of vesicles as layer 2 but more vesicular than Layer 1. Equal amount of vertical and horizontal fractures. Overall this layer is much less red and vesicles were unfilled but some were coated with yellow/green mineralization.",-112,-300);

INSERT INTO StratLayer (OutcropID, LayerNumber, Description, TopDepth, BottomDepth)
    VALUES ("TC2",1,"A' soil horizon? Very fine grained soil, dominated by loess. the layer has a lot of roots. ped structures are present clumped around roots, small and angular structures. It's darker than the soil layers below.",28,23),
    ("TC2",2,"Fine grained modern soil with consitituent sediment coming from transported loess and weathered basalt the soil developed on top of. Average grain size is larger than layer above due to presence of weathered basalt. Roots present but slightly less common than the layer above. Less cohesive than layers above and below. Upper and lower boundaries are wavy and clear. Peds are more prevalent than the layer above, but are a wider variety of sizes (both larger and smaller than above).",23,13),
    ("TC2",3,"Coarsest grained layer of the modern soil, still a mix of loess and weathered basalt, but more basalt than above. fewest number of roots, but they're still present. Fewer and smaller peds, but they're still blocky and found around roots. Has charcoal of varying sizes (up to >10cm) at base of layer.",13,0),
    ("TC2",4,"Very fractured, spheroidally weathered basalt. Spheres are vesicular, but nothing else in the layer (rinds, fractured areas) is. Vesicles are unfilled. Kind of pingy when hit with a rock hammer, but some of the dampening might be because the layer itself isn't very soild. There appears to be little oxidation or secondary mineralization on the surface of the basalt. The basalt is mostly light grey in color, but there's some orange and black minerals on the outer surface. The entire surface appears fractured, though the fractures are equally horizontal and vertical. The upper boundary is wavy and abrupt. The lower boundary is wavy and clear.",0,-50),
    ("TC2",5,"Super vesicular, rubbly + crumbly basalt. Dark blue manganese oxides present, though the majority of the layer, when dry, is a similar light grey as the layer above. There's some yellow/orange coloring at the surface. Most vesicles at the surface are empty (almost no filling or coating), but very few have orangy mineral within them. The vesicular-ness of the layer varies as there's pockets of bigger/more prevalent vesicles in areas higher up in the layer. It's crumbly, though the surface exposed at the outcrop is more solid than the material of similar appearance that was removed. The less vesicular areas were often more crumbly. The lower boundary is wavy and clear. Some of the interior vesicles are filled. To the left of the vesicular/rubbly majority of the layer, there's a more massive, horizontally fractured basalt pieces.",-50,-105),
    ("TC2",6,"Reddened layer between basalt flows, likely the same contact between Grande Ronde N2 and R2 that was identified and described at TC1. Wavy streaks (nearly cm in width) of red appear at the surface of the layer, and are more often horizontal than vertical. Overall, the layer is more soild and harder to remove than the rubble above. The red in the streaks appeared to be clay or at least extremely fine grained. ",-105,-130);

INSERT INTO StratLayer (OutcropID, LayerNumber, Description, TopDepth, BottomDepth)
    VALUES ("BM1",1,"Lookingglass Basalt. Rubbly closer to the contact (up to 10-20cm above), but more resistant and columnar above that. The contact between the basalt and the red layer below is irregular and abrupt. Columnar portion is largely nonvesicular, and the more rubbly portion is significantly less vesicular than basalt layer below. The surface is grey/green/blue in color with some sections of reddening. Closer to the contact, the reddening of the surface appears more red while it appears more purple moving up and away from the contact. It's spheroifally weathered, massive, and has more vertical than horizontal fractures.",300,0),
    ("BM1",2,"Very red cooked top of soil developed on top of the N2 basalt. Non-vesicular, but fractured, crumbly, and very angular. It's super fine grained and gets blockier/more resistant/massive closer to the contact with the overlying Lookingglass basalt. Within the blocky structures, there's some black flecks at the surface, both angular and rounded but flush with surface, mm scale. There's also white/yellow oxides at the surface. The lower bound is clear and gradual. The uppermost portion of the layer looks similar to the soil + basalt contact at WC1 and WC2.",0,-10),
    ("BM1",3,"Very large and reddened basalt core stone, spheroidally weathered with concentric rinds extending out throughout the layer. The surface is reddened with yellow minerals in the vesicles. surface is bluish, with areas that vary from orange/red to red/purple in a streaky pattern. There's some green at the surface in sections. the center of the core is very vesicular, but it becomes less obvious in the concentric layers moving out. Vesicles are of a variety of sizes and frequencies. Some of the interior vesicles are coated with white. Beneath the middle of the corestone, the concentric rinds appear more red/orange and crumbly/finer grained. Most of the basalt in the layer gives a dull ping when struck with rock hammer.",-10,-121),
    ("BM1",4,"Grey vesicular basalt. Upper boundary clear and gradual. The bottom of the layer above is also basalt, very similar in color and texture, but has a platy structure. Highly fractured but no obvious preferred orientation (horizonal, vertical, and diagonal). Some of the larger fractures are filled with a grey material that's more red higher in the layer and more blue lower in the layer. Largest fracture is horizontal, about 50cm below the upper boundary of the layer. On the outcrop, the filled fractures get up to about 3cm in width, but to the left, some are >10cm. Vesicles appear empty at surface. More oxides on the surface of the basalt around the fractures (red, green/yellow).",-121,-300),
    ("BM1",5,"Same elevation and location in the strat column as the top of Layer 3. Resistant and more vertical, probably cooked paleosol. Very red, though slightly more grey/less vibrant than the layers below. Pencil-like structures at the top, with 1-3 cm between vertical fractures. There's black and yellow oxides on the surface. ",0,-18),
    ("BM1",6,"red material, pebbly but resistant (the surface crumbles). The surface crumbles when hit and fractures finely, making it hard to sample. Pebbles aren't original basalt, they're more rust red in color and glossy, non-vesicular. very fine grained. Maybe baked oxidized soil.",-18,-40),
    ("BM1",7,"potentially weathered C horizon based on grain size, location, and texture. Probably not because the grains don't look like basalt, look like the grains above as they're red, fine grained, resistant, smooth, and shiny. Lots of yellow mineral like the layer above. Resistant but crumbles into pebble sized clasts/chunks when struck. Coarser grained pebbles than the layer above.",-40,-47);

INSERT INTO StratLayer (OutcropID, LayerNumber, Description, TopDepth, BottomDepth)
    VALUES ("WEH1",1,"Lookingglass Basalt. Upper 3/4ths of the layer is platy with abundant horizontal fractures and less common vertical fractures that have between ~30 to ~5 cm between them. The lower portion is rubbly in appearance from jointing. The surface of the basalt is a modest brown/red color (along fractured surfaces), and the interior looks unweathered blue/black. There's pockets of small flattened vesicles near the contact of variable size, mostly sub cm. THe basalt is mostly angular. Right above the contact with the lower layer is a darker color, closer to black. It follows the red layer, so it's abrupt and wavy.",100,0),
    ("WEH1",2,"Very top of the reddened sediment(?) layer without any vesicular basalt clasts. Variable thickness throughout layer. Lower boundary is clear and wavy. The layer consists of fine grained red sediment. Some areas are vertically fractured, but only where the material is more resistant/platy and less like wet clay. In the platy areas, fractures are coated with black oxide material. ",0,-4),
    ("WEH1",3,"Very vesicular basalt cores with red material like layer above acting as a matrix and filling larger fractures. Basalt clasts at the top are smaller (~10 cm) and more reddened at the surface. Over the entire layer, vesicles trend towards being smaller at the top, larger when lower in layer. Some of the vesicles at the top are also filled with the red material, but most are either completely empty or coated with yellow. Color varies from red/purple grey to yellow grey depending on the size of the basalt clast and its depth in the layer. Bottom boundary is wavy and clear with the red sediment grading into a light grey over about 3 cm. ",-4,-70),
    ("WEH1",4,"Highly vesicular basalt, similar in appearance to some of the clasts above. variable ping throughout layer, but more pingy moving down. Grey/purple to grey/red at the surface, purple associated with more vesicular areas and red more common lower in the layer. Varied resistance, lower in layer is more resistant, surface of the upper crumbles when struck with hammer. The basalt is mostly blocky in appearance. Vesicles vary in size and abundance, but largest get up to 3cm.",-70,-300),
    ("WEH1",5,"In the separate cleaned outcrop to the left, where the top layer of red below contact is larger. Even the layer below has fewer and smaller basalt clasts (up to 20cm). The top reddened layer appears like soil aggregates (2-3 cm across) and blocky. More grey/purple than red at the top. Clayey. Top 2 cm or two appear more indurated, potentially cooked by the overlying Lookingglass flow. ",0,-15);


--  Samples:
INSERT INTO Sample (ID, Name, OutcropID, ResearcherID, Type, Depth, Description, Color, Date, CoarseFraction, FineFraction, LayerNumber)
    VALUES (1,"RP-23-SG6-1","SG6",7,"Rock Clast ",54,"Clast from C2 horizon w/ calcium carbonate coating (due to weathering/leeching in modern day soil)","7.5YR 5-2","2023-06-06",NULL,NULL,3),
    (2,"RP23-SG6-2","SG6",7,"Basalt Clast",23,"Mostly unweathered Umatilla basalt clast from R horizon","10YR 5-1","2023-06-06",NULL,NULL,4),
    (3,"RP23-SG6-3","SG6",7,"Baked Soil",-3,"From cooked layer, not quite sure what this represents (could be cooked soil), crumbly, lots of mineral grains","10YR 4-1","2023-06-06",NULL,NULL,5),
    (4,"RP23-SG6-4","SG6",7,"Pebbly/Powdery Sample",-19,"Pebbly, has small dark brown/red pebbles (about 1-3 cm in diameter) and yellow/green kryptocrystalline material. ","7.5YR 4-2","2023-06-06",NULL,NULL,6),
    (5,"RP23-SG6-5","SG6",7,"Basalt Clast",-44,"Basalt clast that is highly weathered and very vesicular, vesicles are filled with iron and magnesium oxides, ","basalt: 10YR 5-1 yellow: 5Y 6-6","2023-06-06",NULL,NULL,7),
    (6,"RP23-SG6-6","SG6",7,"Basalt Chunk",-76,"Sample is taken from a basalt core within layer 8, has moderate weathering, and vesicles filled with primarily yellow powder","2.5Y 4-1","2023-06-06",NULL,NULL,8),
    (7,"RP23-SG6-7","SG6",7,"Powdery Unknown Mineral",-76,"Sample is from the vesicles of previous sample (RP23-SG6-6), yellow powdery minerals ","not enough sample","2023-06-06",NULL,NULL,8),
    (8,"RP23-SG6-8","SG6",7,"Highly fractured basalt under contact",-87,"Intensively weathered basalt, very less original primary minerals remain","7.5YR 5-4","2023-06-06",328,124,9),
    (9,"RP23-SG6-9","SG6",7,"Loose Material",-115,"Layer grades down towards less weathering, reddish on top, black on bottom. Pervassive joints vertically and horizontally ","10YR 3-1","2023-06-06",NULL,NULL,10),
    (10,"RP23-SG6-10","SG6",7,"Basalt Corestone",-115,"Layer grades down towards less weathering, reddish on top, black on bottom. Pervassive joints vertically and horizontally ","10YR 5-2","2023-06-06",NULL,NULL,10),
    (11,"RP23-SG6-11","SG6",7,"Basalt Corestone",-140,"Layer grades down towards less weathering, reddish on top, black on bottom. Pervassive joints vertically and horizontally ","7.5YR 5-2","2023-06-06",NULL,NULL,10),
    (12,"RP23-SG6-12","SG6",7,"Matrix Material ",-171,"Very weathered material from layer 11 that surrounds the ghost-cores, matrix was very crumbly","7.5YR 7-1","2023-06-06",NULL,NULL,11),
    (13,"RP23-SG6-13","SG6",7,"Basalt Corestone",-167,"Basalt ghost core, moderate weathering, vesicular","7.5YR 2.5-1","2023-06-06",NULL,NULL,11),
    (14,"RP23-SG6-14","SG6",7,"Drill-Core of Basalt",-230,"Core from the top of rock, going down into the bedrock, slightly more weathered that sample below (RP23-SG6-15)","2.5Y 5-1","2023-06-06",NULL,NULL,12),
    (15,"RP23-SG6-15","SG6",7,"Drill Core of Basalt ",-245,"Core from the side of bedrock, going in horizontally, slightly less weathered, may be better for further examination than sample above (RP23-SG6-14)","2.5Y 5-1","2023-06-06",NULL,NULL,12),
    (16,"NB23-SG6-1","SG6",7,"thin section",-90,NULL,"na","2023-06-28",NULL,NULL,9),
    (17,"NB23-SG6-2","SG6",7,"thin section",-22,NULL,"na","2023-06-28",NULL,NULL,6),
    (18,"CG23-KID1-1","KID1",5,"Basalt Clast, XRF",60,"Basalt clast from area of high fractured/jointed flow, we believe this is from Ice Harbor","Exterior: 10YR 5/3 interior: 2.5Y 3/1","2023-06-07",NULL,NULL,1),
    (19,"CG23-KID1-2","KID1",5,"Basalt Piece ",5,"Piece of basalt from more platy area directly above contact","2.5Y 5/4","2023-06-07",NULL,NULL,2),
    (20,"CG23-KID1-3","KID1",5,"Baked zone",-3.5,"Sample from the cooked looking area of darker soil ","Gley 1 4/N","2023-06-07",NULL,NULL,3),
    (21,"CG23-KID1-4","KID1",5,"Soil Sample, XRF",-22.5,"Sample of fine grained (silty-fine sand) size soil, has some small aggregates and some modeling present","2.5Y 6/2","2023-06-07",NULL,NULL,4),
    (22,"CG23-KID1-5","KID1",5,"Soil Sample ",-50.5,"Sample from bottom of layer 5, blocky aggregate? ","2.5Y 6/2","2023-06-07",NULL,NULL,5),
    (23,"CG23-KID1-6","KID1",5,"Aggregates for Thin Sections ",-32,"Aggregates, about 1 cm tall, and sub centimeter in diameter taken from soil between basalt flows, fine grained (silty-fine sand)  in size, aggregates have been seran wrapped for point of taking thin sections, ",NULL,"2023-06-07",NULL,NULL,4),
    (24,"CG23-KID1-7","KID1",5,"Aggregates for Thin Sections ",-50.5,"Aggregates, about 3-5 cm in length (vertically) and 1 -2 cm in width were taken, sample is seran wrapped for the point of taking thin sections, these aggregates are larger than those in the above sample (CG23-KID1-6) and there shape may indicate presence of clay ",NULL,"2023-06-07",NULL,NULL,5),
    (25,"CG23-KID1-8","KID1",5,"Basalt Clast, XRF",-47,"Vesicular Basalt Clast from the intersecting layer (Layer 8) that cuts through layers 3-5)","2.5Y 4/1","2023-06-07",NULL,NULL,8),
    (26,"CG23-KID1-9","KID1",5,"Crumbly Matrix ",NULL,"Matrix of the intersecting layer (Layer 8) that surrounds the basalt clast sampled above (CG23-KID1-8)","Gley 1 4/N","2023-06-07",NULL,NULL,8),
    (27,"CG23-KID1-10","KID1",5,"Vesicular basalt, XRF",-86,"Top of Layer 7, 3 chunks of highly vesicular basalt","Gley 1 3/N","2023-06-07",NULL,NULL,7),
    (28,"CG23-KID1-11","KID1",5,"Basalt Clast, XRD, thin section ",-144,"Middle of Layer 7, Chunk of basalt taken from bedrock basalt of what we believe to be Elephant Mt. slightly less vesicular than the below sample (CG23-KID1-12)","5Y 4/1","2023-06-07",NULL,NULL,7),
    (29,"CG23-KID1-12","KID1",5,"Basalt Clast",-248,"Bottom of what we can see of  Layer 7 Moderately weathered basalt clast (we think this is Elephant Mt.) very vesicular, was difficult to find an unweathered surface here","10YR 4/1","2023-06-07",NULL,NULL,7),
    (30,"LP-KID1-1","KID1",1,"Basalt Clast",2000,"Basalt clast from top of the slope, likely from a different flow that the top basalt at the outcrop.",NULL,"2023-06-07",NULL,NULL,0),
    (31,"CS23-MFQ1-1","MFQ1",3,"Basalt clast",25,"Basalt clast within calcrete layers. Likely to be Umatilla.","2.5Y 8-1","2023-06-12",NULL,NULL,3),
    (32,"CS23-MFQ1-2","MFQ1",3,"Basalt sample, XRF",-2.5,"Basalt chunks from the underlying unit being separated from the unit by CaCO3 accumulating beneath the fractured clasts. Uniform vertical fractures.","102.5Y 8-1","2023-06-12",NULL,NULL,5),
    (33,"CS23-MFQ1-3","MFQ1",3,"Basalt Clast",-25,"From mostly unweathered bedrock, not vesicular","10YR 6-2","2023-06-12",NULL,NULL,6),
    (34,"CS23-MFQ1-4","MFQ1",3,"Basalt clast, XRF",-35,"From bottom of Layer 6, bedrock","7.5YR 4-2","2023-06-12",NULL,NULL,6),
    (35,"CS23-MFQ1-5","MFQ1",3,"Basalt Clast",-100,"From south of the contact","7.5YR 4-2","2023-06-12",NULL,NULL,NULL),
    (36,"CS23-MFQ1-6","MFQ1",3,"Carbonate Clast",50,"Clast was originally suspended in Loess Matrix, some clasts nearby had stalagtite like features","10YR 8-2","2023-06-12",NULL,NULL,2),
    (37,"CS23-MFQ1-7","MFQ1",3,"Loess Sample",90,"Sample may have some krypto-biotic crust/grass or modern soil present","2.5Y 6-3","2023-06-12",NULL,NULL,1),
    (38,"CS23-MFQ1-8","MFQ1",3,"Carbonate Clast",20,NULL,"5Y 8-1","2023-06-12",NULL,NULL,3),
    (39,"CS23-MFQ1-9","MFQ1",3,"Matrix of Layer 3 ",20,NULL,"2.5Y 8-1","2023-06-12",NULL,NULL,3),
    (40,"CS23-MFQ1-10","MFQ1",3,"Loess+Carbonate Matrix",7.5,"this loess sample has cemented around the basalt clasts in layer 4, matrix is crumbly in some areas but somewhat solidified","2.5Y 8-1","2023-06-12",NULL,NULL,4),
    (41,"CS23-MFQ1-11","MFQ1",3,"Basalt Clasts, XRF",15,"these clasts are much smaller than those above and below, suspended in loess","5YR 4-1","2023-06-12",NULL,NULL,4),
    (42,"RP23-GIC1-1","GIC1",7,"Basalt flakes",110,"this Basalt was very crumbly, and surrounded larger clasts (almost looked like a large weathering rind)","10YR 5/1","2023-06-13",NULL,NULL,2),
    (43,"RP23-GIC1-2","GIC1",7,"Basalt material, XRD",50,"More of platy/crumbly basalt ","2.5Y 5/2","2023-06-13",NULL,NULL,3),
    (44,"RP23-GIC1-3","GIC1",7,"Basalt clast",50,"solid basalt clast","5Y 2.5/1","2023-06-13",NULL,NULL,3),
    (45,"RP23-GIC1-4","GIC1",7,"Basalt sample",67,"basalt clasts were suspended in crumbly material from layer 3, vesicular  ","2.5Y 7/1","2023-06-13",NULL,NULL,3),
    (46,"RP23-GIC1-5","GIC1",7,"Basalt Clast, XRD",28,"basalt from lower in layer 4","10YR 4/2","2023-06-13",NULL,NULL,4),
    (47,"RP23-GIC1-6","GIC1",7,"Platy Layer, thin section ",28,"Crumbly and colorful layer from above basalt clasts in Layer 4, identity unknow, appears clay-y","7.5YR 3/2","2023-06-13",NULL,NULL,4),
    (48,"RP23-GIC1-7","GIC1",7,"Basalt Clast",37,"Grey basalt from the uppermost section of blocky basalt in the layer","10YR 7/1","2023-06-13",NULL,NULL,4),
    (49,"RP23-GIC1-8","GIC1",7,"Basalt Clast",9,"lots of small vesicles, mild weathering ","5Y 4/1","2023-06-13",NULL,NULL,5),
    (50,"RP23-GIC1-9","GIC1",7,"red sediment/mineral, XRD",5,"Very fine grained red powder, maybe iron oxides? this accumulated right at contact","7.5YR 3/4","2023-06-13",NULL,NULL,6),
    (51,"RP23-GIC1-10","GIC1",7,"Basalt Clast w/ red coating",0,"Clast from the contact w/red powdery stuff on underside ","red: 5YR 4/6 cream: 7.5YR 8/2","2023-06-13",NULL,NULL,5),
    (52,"RP23-GIC1-11","GIC1",7,"aggregate, XRD, thin section",-23.5,"Lithified columnar aggregates.","10YR 3/1","2023-06-13",NULL,NULL,6),
    (53,"RP23-GIC1-12","GIC1",7,"vesicular basalt, thin section",-52,"vesicular basalt from layer 7","10YR 3/1","2023-06-13",NULL,NULL,7),
    (54,"RP23-GIC1-13","GIC1",7," sediments and potential clays, XRD",-58,"interior of layer 8, dark clays and potential ash deposit above lower martindale.","10YR 4/2","2023-06-13",NULL,NULL,8),
    (55,"RP23-GIC1-14","GIC1",7,"basalt",-74.5,"vesicular basalt chunk from layer 9","10YR 4/1","2023-06-13",NULL,NULL,9),
    (56,"RP23-GIC1-15","GIC1",7,"clay material",-82,"clay material from layer 10, taken from whole height of layer","2.5Y 4/3","2023-06-14",NULL,86,10),
    (57,"RP23-GIC1-16","GIC1",7,"vesicular basalt",-88,"vesicular basalt chunk from top of bottom flow, martindale(?), very thuddy when hit with hammer.","10YR 5/4","2023-06-14",NULL,NULL,11),
    (58,"RP23-GIC1-17","GIC1",7,"basalt clast,",-113,"Basalt clast from middle of layer 11, below pseudohorizon","10YR 6/4","2023-06-14",NULL,NULL,11),
    (59,"RP23-GIC1-18","GIC1",7,"Basalt chunk, XRD",-140,"Basalt clast from bottom of layer 11","black: 2.5Y 3/1 oxides: 2.5Y 5/6","2023-06-14",NULL,NULL,11),
    (60,"RP23-GIC1-19","GIC1",7,"clay material for thin section",-82,"clay material for thin section :)","NA","2023-06-15",NULL,NULL,10),
    (61,"HC23-GIC2-1","GIC2",4,"Basalt sample",34.5,"Top of layer 3, crumbly vesicular basalt with yellow material present in vesicles. Ice Harbor, Goose Island (?).","2.5Y 6/1","2023-06-15",NULL,NULL,3),
    (62,"HC23-GIC2-2","GIC2",4,"Basalt sample, XRF",3.5,"Base of layer 3, comparatively solid and blocky. Right above the contact. Ice Harbor, Goose Island (?).","2.5Y 6/1","2023-06-15",NULL,NULL,3),
    (63,"HC23-GIC2-3","GIC2",4,"Basalt sample",-2,"Material from the contact, potentially showing the cooked top of the lower soil. It has a color gradient, with the light grey end pointing upward and the red pointing down to the contact.","10YR 5/1","2023-06-15",NULL,NULL,4),
    (64,"HC23-GIC2-4","GIC2",4,"Ash/Soil crumbles, XRF, thin section?",-39,"White crumbly layer, ash/soil (?) from the base of layer 4. Black flecks are visible under hand lens. Hard to collect as it's soild but crumbly.","Interior: Gley 3/N exterior: 2.5Y 8/3","2023-06-15",NULL,NULL,4),
    (65,"HC23-GIC2-5","GIC2",4,"Aggregates",-30,"Blocky ped aggregates, rocky.","5Y 4/1","2023-06-15",NULL,NULL,4),
    (66,"HC23-GIC2-6","GIC2",4,"Basalt clasts, XRF",-15,"Basalt clasts within the columnar aggregates of layer 4. Sample represents smaller clasts, but a variety of sizes can be found at the site. Ice Harbor, Indian Monument (?).","2.5Y 5/1","2023-06-15",NULL,NULL,4),
    (67,"HC23-GIC2-7","GIC2",4,"Basalt clasts",-78,"Competent but crumbly vesicular basalt between aggregates and ash. Evidence of diagenesis found within red color on freshly broken surfaces of interior. Ice Harbor, Indian Monument (?).","2.5Y 2.5/1","2023-06-15",NULL,NULL,5),
    (68,"HC23-GIC2-8","GIC2",4,"Ash sample, thin section",-86,"Top of the ash in layer 6. Pebbly texture with some small basalt clasts scattered throughout. Potentially cooked (?).","10YR 7/3","2023-06-15",NULL,NULL,6),
    (69,"HC23-GIC2-9","GIC2",4,"Ash chunk, XRF",-145,"Base of ash in layer 6, just above basalt of layer 7. More solid and competent than ash higher up in the layer (HC23-GIC2-8).","2.5Y 7/1","2023-06-15",NULL,NULL,6),
    (70,"HC23-GIC2-10","GIC2",4,"Basalt clasts, XRF, thin section",-180,"Basalt from base of visible layer 7. Easily removable as the clasts had been fractured. Ice Harbor, Martindale (?).","5Y 4/2","2023-06-15",NULL,NULL,7),
    (71,"HC23-GIC2-11","GIC2",4,"Aggregate for thin section",-40,"Ped/aggregate sample for thin section.",NULL,"2023-06-15",NULL,NULL,4),
    (72,"HC23-GIC2-12","GIC2",4,"Contact for thin section",-2,"A sample of rock taken from the contact (between layers 3 and 4) to thin section.",NULL,"2023-06-15",NULL,NULL,4),
    (73,"HC23-GIC2-13","GIC2",4,"Basalt for thin section",-60,"Big rock with minimal lichen/obvious intense surface weathering for thin section.","5Y 4/1","2023-06-15",NULL,NULL,5),
    (74,"CS23-BM1-1","BM1",3,"basalt sample",85,"mostly nonvesicular basalt, from lookingglass basalts.",NULL,"2023-07-05",NULL,NULL,1),
    (75,"CS23-BM1-2","BM1",3,"sediment sample",-5,"red cooked sediment material from the whole layer (immediately below the contact). very solid and hard to remove and collect.",NULL,"2023-07-05",148,58,2),
    (76,"CS23-BM1-3","BM1",3,"basalt clast, thin section ",5,"flow bottom basalt, removed by hand. taken from directly above the contact, where the contact itself is lower.",NULL,"2023-07-05",NULL,NULL,1),
    (77,"CS23-BM1-4","BM1",3,"basalt sample",-65,"basalt taken from the concentric rind around spheroidally weathered corestone in reddened layer. Sample is where trowel is pointing in picture.",NULL,"2023-07-05",NULL,NULL,3),
    (78,"CS23-BM1-5","BM1",3,"basalt sample",-62,"vesicular basalt corestone. sample hammered out from the surface.",NULL,"2023-07-05",NULL,NULL,3),
    (79,"CS23-BM1-6","BM1",3,"sediment sample, xrf",-62,"matrix of the layer outside of the corestone. to the left of where most samples were taken.",NULL,"2023-07-05",NULL,82112,3),
    (80,"CS23-BM1-7","BM1",3,"basalt clast",-129,"vesicular top of the N2 basalt.",NULL,"2023-07-05",NULL,NULL,4),
    (81,"CS23-BM1-8","BM1",3,"basalt clast",-242,"basalt clast from base of scanned outcrop, the least weathered. pulled from surface by hand along fractures.",NULL,"2023-07-05",NULL,NULL,4),
    (82,"CS23-BM1-9","BM1",3,"basalt clast",-189,"oxide covered basalt taken from along the fracture.",NULL,"2023-07-05",NULL,NULL,4),
    (83,"CS23-BM1-10","BM1",3,"fracture filling material, xrf",-171,"material filling fracture along basalt shelf. varies in color throughout fractures in layer from pink-ish to blue-ish grey.",NULL,"2023-07-06",NULL,NULL,4),
    (84,"CS23-BM1-11","BM1",3,"pencil structures",-9,"red pencil structures, vertical just below contact. 1 to 3 cm in width.",NULL,"2023-07-06",NULL,NULL,5),
    (85,"CS23-BM1-12","BM1",3,"sediment sample",-20,"finer grained pebbles. very red. fairly resistant and fractures finely, making it hard to remove.",NULL,"2023-07-06",NULL,NULL,6),
    (86,"CS23-BM1-13","BM1",3,"sediment sample, xrf",-48.5,"crumbly layer of larger red pebbles.",NULL,"2023-07-06",NULL,NULL,7),
    (87,"CS23-BM1-14","BM1",3,"sediment sample for thin section (if intact)",-50,"larger intact chunk of coarser grained red pebbley material collected with CS23-BM1-13.",NULL,"2023-07-06",NULL,NULL,7),
    (88,"CS23-BM1-15","BM1",3,"basalt sample, thin section",-57,"very weathered top of the vesicular N2 basalt",NULL,"2023-07-06",NULL,NULL,4),
    (89,"CS23-BM1-16","BM1",3,"basalt clast",NULL,"less vesicular, lower in layer N2 basalt.",NULL,"2023-07-06",NULL,NULL,4),
    (90,"CS23-BM1-17","BM1",3,"basalt clast, thin section ",NULL,"vesicular, higher in layer (but still below outcrop) N2 basalt.",NULL,"2023-07-06",NULL,NULL,4),
    (91,"CG23-WC1-1","WC1",5,"Basalt clast, XRF",135,"In-place but fragmented basalt chunk.","10YR 5-3","2023-06-19",NULL,NULL,1),
    (92,"CG23-WC1-2","WC1",5,"Basalt clast",40,"fractured basalt from weak + unstable rock face. probably elephant mountain.","5Y 4-2","2023-06-19",NULL,NULL,2),
    (93,"CG23-WC1-3","WC1",5,"Ped for thin section",-5,"a sample of columnar aggregate from layer 3 for thin section. top of layer.",NULL,"2023-06-19",NULL,NULL,3),
    (94,"CG23-WC1-4","WC1",5,"Ped for thin section",-15,"a sample of columnar aggregate from layer 3 for thin section. middle of layer.",NULL,"2023-06-19",NULL,NULL,3),
    (95,"CG23-WC1-5","WC1",5,"Ped for thin section",-40,"a sample of columnar aggregate from layer 3 for thin section. Base of layer.",NULL,"2023-06-19",NULL,NULL,3),
    (96,"CG23-WC1-6","WC1",5,"Basalt clast",-15,"basalt clast from within layer 3, suspended within ped structures.","GLEY1 5-N","2023-06-19",NULL,NULL,3),
    (97,"CG23-WC1-7","WC1",5,"Paleosol sample, XRF",-10,"Gley colored soil, different structure than the columnar aggregates. More massive in appearance, but still crumbly.","2.5Y 5-2","2023-06-19",NULL,NULL,3),
    (98,"CG23-WC1-8","WC1",5,"Basalt clast, XRF",-65,"Fractured top of layer 4, likely to be Pomona basalt. Broken into collectable pieces by observed rock fall (scary).","2.5Y 4-1","2023-06-19",NULL,NULL,4),
    (99,"CS23-WC2-1","WC2",3,"basalt clast, XRF",95,"Basalt clasts from autobrecciated section of Elephant Mountain basalt. Vesicular.","7.5YR 4/2","2023-06-20",NULL,NULL,2),
    (100,"CS23-WC2-2","WC2",3,"basalt clast",25,"basalt clast from blue-colored paleosediment layer. Rounded.","Gley 1 4/N","2023-06-20",NULL,NULL,3),
    (101,"CS23-WC2-3","WC2",3,"columnar structure for thin section",40,"columnar structure (ped-esque) from the top of the layer for thin section. Formed from cooking? Same as CS23-WC2-7.",NULL,"2023-06-20",NULL,NULL,3),
    (102,"CS23-WC2-4","WC2",3,"Platy structure for thin section",50,"platy structure from between basalt clasts in right side of the layer, for thin section.",NULL,"2023-06-20",NULL,NULL,3),
    (103,"CS23-WC2-5","WC2",3,"non-basalt crumbles for thin section",11,"crumbly sample of material from layer. Collected from a loose surface on the left side of the outcrop, for thin section.",NULL,"2023-06-20",NULL,NULL,3),
    (104,"CS23-WC2-6","WC2",3,"non-basalt crumbles",30,"same as CS23-WC2-6, blue blocky material. crumbled off of surface by hand.","Gley 1 5/N","2023-06-20",NULL,NULL,3),
    (105,"CS23-WC2-7","WC2",3,"structure sample, XRF",45,"columnar structure from the top right of the layer. potentially formed from cooking? little fingers","Gley 1 4/N","2023-06-20",NULL,NULL,3),
    (106,"CS23-WC2-8","WC2",3,"soil? structure sample",-10,"ped-like structure nearest to contact, similar in appearance to ped layer from WC1. was pulled and collected by hand.","Gley 1 4/N","2023-06-20",NULL,NULL,4),
    (107,"CS23-WC2-9","WC2",3,"basalt clast",-45,"Vesicular Pomona basalt clast making up the float clasts. Was already fractured, sample is less than half of the original clast.","5Y 7/1","2023-06-20",NULL,NULL,5),
    (108,"CS23-WC2-10","WC2",3,"soil? structure sample, XRF",-35,"Blocky and crumbles into tiny (sub 1/2cm) pieces. found between float clasts ","5Y 8/1","2023-06-20",NULL,NULL,5),
    (109,"CS23-WC2-11","WC2",3,"soil sample, XRF",-75,"clay soil sample from between float clasts, taken via trowel. has some less weathered (angular) basalt clasts within, further from surface.","2.5Y 5/3","2023-06-20",66,82,6),
    (110,"CS23-WC2-12","WC2",3,"basalt clast",-135,"Lower flow (pomona) basalt clast from the top of the layer. Removed by hand.","2.5Y 3/1","2023-06-20",NULL,NULL,7),
    (111,"CS23-WC2-13","WC2",3,"basalt clast, XRD",-235,"Lower flow (pomona) basalt clast from the bottom of the layer. Was right at surface level and had to be removed with rock hammer.","2.5Y 5/1","2023-06-20",NULL,NULL,7),
    (112,"HC23-WC3-1","WC3",4,"basalt clast",65,"suspected Elephant Mountain basalt clast. Rounded (from spheroidal weathering), from the top of the layer.","Outside: 10YR 6/2 Inside: 10YR 3/1","2023-06-21",NULL,NULL,2),
    (113,"HC23-WC3-2","WC3",4,"basalt clast, XRF",8,"Blocky basalt clast from the base of the Elephant Mountain. Just above contact. Easily removed by hand.","10YR 3/1","2023-06-21",NULL,NULL,2),
    (114,"HC23-WC3-3","WC3",4,"soil? sample, XRF",-25,"pebbly black/grey blue material with orange to yellow mineral coatings around structures. was still wet from SunJoe so it looked darker than it was. Hard to collect with trowel, probably clay-rich. some green color present on dug out surfaces.","2.5Y 3/1","2023-06-21",NULL,NULL,3),
    (115,"HC23-WC3-4","WC3",4,"soil? material",-45,"soil? sample from base of layer 4. some came off in chunkys. likely has clay. larger chunks in the sample appear to be basalt saprolite, more solid but still crumble under force.","2.5Y 3/1","2023-06-21",NULL,NULL,4),
    (116,"HC23-WC3-5","WC3",4,"soil? sample",-60,"layer 5 material, varies from clay to slightly larger dark grey chunks that crumble under force. has roots, so some part of it may be modern...","2.5Y 4/1","2023-06-21",NULL,NULL,5),
    (117,"HC23-WC3-6","WC3",4,"basalt clasts for thin section, XRF?",-60,"basalt clasts from base of layer 5. right above the top of the Pomona but completely surrounded by the clay of the layer. Surface of samples covered with clay, unclear if it's accumulated from surroundings or from weathering of the surface of the clast.","5Y 5/1","2023-06-21",NULL,NULL,5),
    (118,"HC23-WC3-7","WC3",4,"basalt sample",-70,"more weathered basalt from the top of the Pomona directly below the clay from layer 5. Has clay texture at surface, can be scratched with trowel. Area of clast going deeper into the basalt was fractured and filled with layer of light colored material (some should still be on the clast).","5Y 5/1","2023-06-21",NULL,NULL,6),
    (119,"HC23-WC3-8","WC3",4,"basalt clast, XRF",-75,"Basalt clast from the top of the Pomona flow. previously buried by colluvium and clay. fractured and removable by hand. (where we thought the scorpion had gone).","2.5Y 5/2","2023-06-21",NULL,NULL,6),
    (120,"HC23-WC3-9","WC3",4,"basalt clast, XRF",-200,"From area of Pomona exposed lower down to the right of the scanned area. Vesicular, from larger fractured chunk with mudcracked appearance.","2.5Y 3/1","2023-06-21",NULL,NULL,6),
    (121,"CG23-IHD1-1","IHD1",5,"Basalt clast",10,"basalt clast from soil matrix. detached but appears mostly in-place.","2.5Y 2.5/1","2023-06-27",NULL,NULL,1),
    (122,"CG23-IHD1-2","IHD1",5,"sediment sample",-10,"red sediment sample taken from around basalt clasts, collected with trowel. Small sample, 2.2 is likely the same material but from a different location.","10YR 4/4","2023-06-27",NULL,NULL,2),
    (123,"CG23-IHD1-2.2","IHD1",5,"sediment sample",-20,"red sediment sample collected with trowel. was to the left of the dike, had roots.",NULL,"2023-06-27",NULL,62,2),
    (124,"CG23-IHD1-3","IHD1",5,"basalt clast",-12,"spheroidally weathered basalt clast from layer.","2.5Y 5/2","2023-06-27",NULL,NULL,2),
    (125,"CG23-IHD1-4","IHD1",5,"basalt clast",-25,"vesicular basalt clast, fractured and disconnected but held in place by basalt on either side.","2.5 Y 5/3","2023-06-27",NULL,NULL,3),
    (126,"CG23-IHD1-5","IHD1",5,"sediment sample, XRF",-42.5,"yellow sediment sample from below dike, has some larger basalt clasts where it was taken from (might be some in the sample)","2.5Y 6/6","2023-06-27",NULL,26,4),
    (127,"CG23-IHD1-6","IHD1",5,"basalt clast",-40,"base of vesicular basalt above bedrock scoria.","10YR 2/1","2023-06-27",NULL,NULL,4),
    (128,"CG23-IHD1-7","IHD1",5,"scoria sample, thin section",-60,"base of scoria bedrock/base of layer","2.5Y 2.5/1 but a little darker","2023-06-27",NULL,NULL,4),
    (129,"CG23-IHD1-8","IHD1",5,"scoria sample",-60,"platy scoria chunk from top of layer.","2.5 Y 2.5/1","2023-06-27",NULL,NULL,5),
    (130,"CG23-IHD1-9","IHD1",5,"scoria sample",-90,"scoria from the bottom of layer 5, before/in its graditation to clay.","2.5Y 3/2","2023-06-27",NULL,NULL,5),
    (131,"CG23-IHD1-10","IHD1",5,"sediment sample, XRF",-111,"from shelf, same material as CG23-IHD1-19. no visible soil structure, easily dug out with trowel (clay rich).","10YR 5/2","2023-06-27",NULL,NULL,6),
    (132,"CG23-IHD1-11","IHD1",5,"weathered basalt? sample, XRF, thin section",-111,"from shelf, red potato shaped clast in grey sediment matrix. almost like a ghost core. buried, more competent than surrounding sediment.","10YR 6/2","2023-06-27",NULL,NULL,6),
    (133,"CG23-IHD1-12","IHD1",5,"sediment sample",-134,"beige/light colored sediment from layer","10YR 7/2","2023-06-27",NULL,NULL,7),
    (134,"CG23-IHD1-13","IHD1",5,"ash sample, XRF",-190.5,"sample of white material from ash layer.","10YR 9/1 white page","2023-06-27",NULL,NULL,8),
    (135,"CG23-IHD1-14","IHD1",5,"basalt clast",-215,"vesicular basalt clast, previously buried. right at shelf former","5Y 6/1","2023-06-27",NULL,NULL,9),
    (136,"CG23-IHD1-15","IHD1",5,"basalt clast",-316,"basalt sample from middle of the layer","10YR 6/1","2023-06-27",NULL,NULL,10),
    (137,"CG23-IHD1-16","IHD1",5,"basalt clast",-383,"basalt sample from lowest in layer.","10YR 4/1","2023-06-27",NULL,NULL,10),
    (138,"CG23-IHD1-17","IHD1",5,"basalt clast",-241,"basalt sample from highest up in the layer","2.5Y 2.5/1","2023-06-27",NULL,NULL,10),
    (139,"CG23-IHD1-18","IHD1",5,"basalt clast, XRF",-795,"basalt from exposed layer way down below trench.","2.5 Y 2.5/1","2023-06-27",NULL,NULL,10),
    (140,"CG23-IHD1-19","IHD1",5,"basalt clast",150,"unweathered TIM basalt",NULL,"2023-06-27",NULL,NULL,1),
    (141,"CG23-IHD1-20","IHD1",5,"sediment for thin section",-111,"grey clay taken from shelf for thin section.",NULL,"2023-06-27",NULL,NULL,6),
    (142,"CS23-SGQ1-1","SGQ1",3,"soil sample",90,"sample of the modern A horizon, taken from just below grass layer about 10 cm behind the outcrop surface.","2.5Y 5/3","2023-06-28",NULL,NULL,1),
    (143,"CS23-SGQ1-2","SGQ1",3,"soil sample",57,"Bw horizon from modern soil. has more structure than samples above.","2.5Y 5/3","2023-06-28",NULL,NULL,2),
    (144,"CS23-SGQ1-3","SGQ1",3,"soil sample",10,"Bk horizon from modern soil. lighter in color and more soild than layer above. There's some larger pieces of carbonate within the sample, taken from lower in the layer.","2.5Y 5/3","2023-06-28",NULL,NULL,3),
    (145,"CS23-SGQ1-4","SGQ1",3,"basalt clasts, XRF",-4,"Basalt clasts taken from the carbonate layer at the very top of the layer, right at contact with the soil. Both angular and rounded clasts of very nonweathered basalt.","5Y 5/1","2023-06-28",NULL,NULL,4),
    (146,"CS23-SGQ1-5","SGQ1",3,"basalt/carbonate clast",-15,"basalt and carbonate sample taken from the very top of the cliff face.","10YR 4/1","2023-06-28",NULL,NULL,4),
    (147,"CS23-SGQ1-6","SGQ1",3,"basalt/carbonate clast",-25,"basalt and carbonate sample taken from slightly lower than previous sample, not much observable difference.","10YR 4/2","2023-06-28",NULL,NULL,4),
    (148,"CS23-SGQ1-7","SGQ1",3,"basalt/carbonate clast",-35,"basalt and carbonate sample taken from lower in the layer than the previous two.","10YR 4/1","2023-06-28",NULL,NULL,4),
    (149,"CS23-SGQ1-8","SGQ1",3,"basalt/carbonate clast",-50,"basalt and carbonate sample taken from the top of cliff face, the lowest that could safely be reached from the top. more of the same as previous samples.","10YR 3/1","2023-06-28",NULL,NULL,4),
    (150,"CS23-SGQ1-9","SGQ1",3,"basalt clast, XRF",-280,"basalt from the middle of the cliff face, above the talus pile. Umatilla.","10YR 4/2","2023-06-28",NULL,NULL,4),
    (151,"CS23-SGQ1-10","SGQ1",3,"basalt clast",-362,"basalt from the middle of the cliff face, above the talus pile but lower than previous. Umatilla.","5YR 3/1","2023-06-28",NULL,NULL,4),
    (152,"CS23-SGQ1-11","SGQ1",3,"basalt clast, XRF",-489,"basalt from just above the talus pile on the cliff face above talus pile. Umatilla. Very angular.","7.5YR 4/2","2023-06-28",NULL,NULL,4),
    (153,"CS23-SGQ1-12","SGQ1",3,"basalt clast, thin section (up to profs)",-319,"basalt clasts from the colluvium to the left of the cliff face (paleochannel). we shouldn't mix the basalt pieces as there's a chance they're from different flows.","10YR 5/2","2023-06-28",NULL,NULL,4),
    (154,"HC23-TC1-1","TC1",4,"Basalt clast, xrf",45,"Unweathered basalt clast from upper unit","7.5YR 4-3","2023-06-30",NULL,NULL,1),
    (155,"HC23-TC1-2","TC1",4,"Basalt clast",22.5,"Unweathered basalt clast from bottom of layer 1","2.5Y 4-1","2023-06-30",NULL,NULL,1),
    (156,"HC23-TC1-3","TC1",4,"Crumbly material",1.5,"Crumbly material at contact","10YR 3-2","2023-06-30",NULL,NULL,1),
    (157,"HC23-TC1-4","TC1",4,"Basalt clast, thin section ",-30,"Less weathered vesicular basalt darker gray but still reddened, some vesicles filled with yellow mineralization","Red: 2.5YR 5-6 Grey: 2.5Y 3-2","2023-06-30",NULL,NULL,2),
    (158,"HC23-TC1-5","TC1",4,"Basalt clast, xrf",-65,"Basalt clast with yellow mineralization","2.5Y 6-6","2023-06-30",NULL,NULL,2),
    (159,"HC23-TC1-6","TC1",4,"Basalt clast",-117,"Red priable and vesicular basalt","10R 5-6","2023-06-30",NULL,NULL,2),
    (160,"HC23-TC1-7","TC1",4,"weathered Basalt clast",-150,"Purplish basalt, highly weathered, between rock and sapprolite ","2.5YR 4-3","2023-06-30",NULL,NULL,2),
    (161,"HC23-TC1-8","TC1",4,"Basalt clast",-117,"Basalt from top of layer, lighter in color than the upper basalt","5YR 5-2","2023-06-30",NULL,NULL,3),
    (162,"HC23-TC1-9","TC1",4,"Basalt clast",-199,"Vesicular basalt from the middle of layer 3 ","5YR 4-1","2023-06-30",NULL,NULL,3),
    (163,"HC23-TC1-10","TC1",4,"Basalt clast",-325,"Basalt clast from lowest exposed part of the outcrop, from the lower left side of the outcrop is outside the Pix 4D scan. Sparse but large vesicels","5YR 4-2","2023-06-30",NULL,NULL,3),
    (164,"CG23-TC2-1","TC2",5,"soil sample",25.5,"A horizon soil sample, mostly loess with peds and roots.","10YR 4-3","2023-07-03",NULL,NULL,1),
    (165,"CG23-TC2-2","TC2",5,"soil sample",18,"Soil sample with lots of roots and wood/charcoal fragments.","10YR 3-2","2023-07-03",NULL,NULL,2),
    (166,"CG23-TC2-3","TC2",5,"basalt clasts, xrf",18,"basalt clasts, about 4cm in width on average, found within the soil in layer.","7.5YR 5-4","2023-07-03",NULL,NULL,2),
    (167,"CG23-TC2-4","TC2",5,"soil sample",6.5,"soil sample from whole layer, structure supported by roots.","10YR 4-3","2023-07-03",NULL,144,3),
    (168,"CG23-TC2-5","TC2",5,"charcoal, radiocarbon dating",10,"big ol' hunk of charcoal from the very base of the layer, right above basalt. was mostly buried.","NA","2023-07-03",NULL,NULL,3),
    (169,"CG23-TC2-6","TC2",5,"basalt clast",-45,"spheroidally weathered basalt clast.","Grey: 2.5Y 5-2 Weathered: 7.5YR 5-4","2023-07-03",NULL,NULL,4),
    (170,"CG23-TC2-7","TC2",5,"basalt clast",-10,"fractured top of the basalt layer.","2.5Y 4-1","2023-07-03",NULL,NULL,4),
    (171,"CG23-TC2-8","TC2",5,"basalt sample",-73,"crumbly basalt from the middle of the layer. mushes more than it breaks when struck (maybe b/c clay, maybe b/c wet?). some was dug out, some pulled from surface. there's orange material in the vesicles.","10YR 5-4","2023-07-03",NULL,NULL,5),
    (172,"CG23-TC2-9","TC2",5,"basalt (?) material",-100,"dark black material from surface of lower basalt clasts in layer above contact with lower basalt flow. also has orange material.",NULL,"2023-07-03",NULL,NULL,5),
    (173,"HC23-WEH1-1","WEH1",4,"basalt sample",70,"middle of lookingglass basalt, platy clast taken from surface. unwedged by hand.","10YR 5-4","2023-07-06",NULL,NULL,1),
    (174,"HC23-WEH1-2","WEH1",4,"basalt sample",30,"lower middle of lookingglass basalt. blocky clasts between platy basalt and rubblely basalt","10YR 4-2","2023-07-06",NULL,NULL,1),
    (175,"HC23-WEH1-3","WEH1",4,"sediment sample, xrf",-3,"platy red, likely cooked, sediment from right below contact. noteable lack of obvious visible basalt clasts.","2.5YR 4-6","2023-07-06",NULL,NULL,2),
    (176,"HC23-WEH1-4","WEH1",4,"basalt sample",-7,"vesicular basalt from the top of layer, as close to contact as possible. vesicular and crumbly. surrounded by red material.","5YR 4-4","2023-07-06",NULL,NULL,3),
    (177,"HC23-WEH1-5","WEH1",4,"basalt sample",-52,"vesicular basalt from larger clast lower in the layer (towards center of ~30cm width core). below surface, large amounts of green/yellow oxide mineral accumulation. also reddened basalt.","2.5YR 5-4","2023-07-06",NULL,NULL,3),
    (178,"HC23-WEH1-6","WEH1",4,"sediment sample",-60,"red material at the very base of layer. some parts of it were easy to remove with trowel (like clay) while other parts (moving to the right) were more solid/resistant, came out in chunks.","2.5YR 4-8","2023-07-06",NULL,NULL,3),
    (179,"HC23-WEH1-7","WEH1",4,"sediment sample, xrf",-45,"likely same material as HC23-WEH1-6 but from higher up in the layer, right below clast.","2.5YR 4-8","2023-07-06",NULL,NULL,3),
    (180,"HC23-WEH1-8","WEH1",4,"basalt sample",-122,"lowest basalt exposed in the outcrop, from the N2. red with large vesicles. taken from beneath exposed surface.","Black: 7.5YR 2.5-1 Red: 2.5YR 4-4","2023-07-06",NULL,NULL,4),
    (181,"HC23-WEH1-9","WEH1",4,"basalt sample, xrf, thin section",-92,"basalt from the middle of the exposed N2. As high as possible with it being soild (above it has basalt that simply crumbles off at surface, more priable).","5YR 5-3","2023-07-06",NULL,NULL,4),
    (182,"HC23-WEH1-10","WEH1",4,"oxides + basalt",-92,"fracture filling material with the bordering heavily oxidized basalt. based on ping test, the basalt by the fracture isn't as weathered as it appeared.","2.5YR 5-4","2023-07-06",NULL,NULL,4),
    (183,"HC23-WEH1-11","WEH1",4,"sediment sample",-12.5,"dark red material from right outcrop. layer had no basalt clasts.","2.5YR 4-8","2023-07-06",NULL,NULL,5),
    (184,"HC23-WEH1-12","WEH1",4,"sediment sample (for thin section)",-12.5,"dark red material from right outcrop, same as HC23-WEH1-11. Larger piece for thin section. Original orientation is recorded with arrow pointing up.",NULL,"2023-07-06",NULL,NULL,5),
    (185,"HC23-WEH1-13","WEH1",4,"sediment sample, xrf",-50,"red material from between the basalt clasts in the right outcrop. basalt clasts were smaller and less frequent than main outcrop.","10R 4-6","2023-07-06",NULL,NULL,4);

--  SampleChemData
INSERT INTO SampleChemData (TestNum, SampleID, LabID, Date, SiO2, TiO2, Al2O3, FeO, MnO, MgO, CaO, Na2O, K2O, P2O5, Sum, LOI, SiO2n, TiO2n, Al2O3n, FeOn, MnOn, MgOn, CaOn, Na2On, K2On, P2O5n, Ni, Cr, Sc, V, Ba, Rb, Sr, Zr, Y, Nb, Ga, Cu, Zn, Pb, La, Ce, Th, Nd, U, SumTr, PrctTr, MinPlusTr, MajPlusTrOx, w_LOI, IfFerric, NiO, Cr2O3, Sc2O3, V2O3, BaO, Rb2O, SrO, ZrO2, Y2O3, Nb2O5, Ga2O3, CuO, ZnO, PbO, La2O3, CeO2, ThO2, Nd2O3, U2O3, SumTrOx, PrctTrOx)
    VALUES (1,173,"GAL-NB-165-1","2023-08-03",54.83,2.729,13.01,13.5,0.203,2.44,5.99,3.26,1.81,0.801,98.58,1.19,55.61,2.77,13.2,13.7,0.21,2.48,6.08,3.31,1.84,0.81,1,0,33,162,851,55,315,244,53,17.7,24,11,162,8,31,68,6,43,2,2086,0.21,98.79,98.84,100.03,101.53,0.9,0,50.4,238,950.6,59.8,372.9,329.4,66.9,25.3,32.5,14,201.3,9.2,36.4,84.2,6.5,50.2,1.7,2530,0.25),
    (1,183,"GAL-NB-165-2","2023-08-03",45.26,1.931,20.28,13.05,0.222,1.83,1.7,0.51,0.1,0.202,85.08,14.52,53.19,2.27,23.83,15.34,0.26,2.15,2,0.6,0.11,0.24,8,20,35,132,239,6,133,341,48,20.7,30,25,198,21,38,90,6,39,3,1434,0.14,85.23,85.27,99.78,101.23,10.7,29.7,54,193.5,267.1,6.4,156.8,460.3,61.2,29.6,40.6,31.5,246.1,22.3,44.7,111,7.2,45.6,3.5,1822,0.18),
    (1,177,"GAL-NB-165-3","2023-08-03",50.35,2.031,16.57,13.41,0.156,2.74,6.44,2.49,0.33,0.323,94.83,5.08,53.09,2.14,17.47,14.14,0.16,2.89,6.79,2.63,0.34,0.34,10,42,39,217,544,10,330,193,47,13,24,32,117,7,29,49,5,30,1,1740,0.17,95.01,95.05,100.13,101.62,13.4,61.1,60.6,319.6,607.1,11.1,389.8,260.3,59.8,18.6,32.6,40.4,146.1,7.8,33.5,60.5,5.8,35.2,0.7,2164,0.22),
    (1,178,"GAL-NB-165-4","2023-08-23",43.04,2.129,21.67,12.86,0.103,1.72,1.48,0.33,0.13,0.106,83.57,16.42,51.5,2.55,25.94,15.39,0.12,2.06,1.77,0.39,0.15,0.13,13,29,38,255,294,10,117,347,39,20.5,31,32,163,18,37,71,7,30,3,1554,0.16,83.72,83.77,100.19,101.62,16.3,42.2,57.9,375.4,328.8,10.4,138,468.7,49,29.3,41.1,40.6,202.4,19.7,43.2,87.6,8.3,35.2,3.1,1997,0.2),
    (1,180,"GAL-NB-165-5","2023-08-03",50.09,1.935,16,12.62,0.175,4.54,8.05,2.43,0.39,0.271,96.5,3.41,51.9,2,16.58,13.08,0.18,4.71,8.34,2.52,0.4,0.28,14,45,40,326,519,20,317,185,41,12.9,22,31,125,6,22,47,4,29,2,1808,0.18,96.68,96.73,100.14,101.54,17.5,65.6,61.5,479.2,579.3,22.2,374.8,249.6,52.5,18.5,30,38.2,156.1,7,26,57.4,4.8,34.2,1.9,2276,0.23),
    (1,99,"GAL-NB-165-6","2023-08-03",48.32,3.654,13.03,15.45,0.211,3.73,9.04,2.36,0.46,0.831,97.1,2.87,49.76,3.76,13.42,15.92,0.22,3.84,9.31,2.43,0.48,0.86,14,13,33,415,412,14,261,263,55,24.9,24,22,149,5,33,70,5,40,2,1854,0.19,97.28,97.33,100.2,101.92,17.8,19,50.7,610.3,459.8,15.3,308.1,355.2,70,35.6,32.1,27.5,185.8,5.9,38.8,85.5,5.5,46.2,2.7,2372,0.24),
    (1,100,"GAL-NB-165-7","2023-08-03",51.1,1.796,14.86,10.65,0.172,5.97,10.67,2.27,0.43,0.276,98.19,1.38,52.04,1.83,15.13,10.85,0.17,6.08,10.87,2.31,0.43,0.28,40,102,37,295,462,16,253,146,38,12.4,19,39,97,6,31,48,3,35,0,1680,0.17,98.36,98.4,99.79,100.97,51.3,149.1,56.5,434.7,515.4,18,298.9,197.8,47.8,17.7,25.7,48.2,120.4,6.1,36.9,58.8,3.5,41.3,0.2,2128,0.21),
    (1,104,"GAL-NB-165-8","2023-08-03",61.54,4.256,12.69,7.39,0.184,1.74,2.84,1.56,0.45,0.056,92.72,7.07,66.37,4.59,13.69,7.97,0.2,1.88,3.06,1.69,0.49,0.06,21,40,14,251,432,15,237,457,21,32.9,16,30,65,24,30,142,11,23,3,1864,0.19,92.9,92.95,100.03,100.85,27.3,58.5,22.2,368.9,481.9,16.3,280,616.8,27.2,47.1,20.9,37.1,81.2,26,34.8,174,12.2,27.1,3.6,2363,0.24),
    (1,106,"GAL-NB-165-9","2023-08-03",48.25,3.408,13.43,12.73,0.218,4.86,10.53,2.52,0.64,0.792,97.37,1.9,49.56,3.5,13.79,13.07,0.22,4.99,10.81,2.59,0.66,0.81,50,184,42,374,4460,14,354,280,56,26.6,25,45,160,9,34,80,2,45,1,6241,0.62,98,98.1,100.01,101.42,63.6,269.6,64,549.5,4979.6,14.9,418.7,378.1,71.1,38.1,33,56,198.7,9.3,40.4,98.8,2.8,52.3,1.4,7340,0.73),
    (1,107,"GAL-NB-165-10","2023-08-03",51.54,1.759,14.7,10.63,0.164,6.09,10.84,2.13,0.47,0.295,98.63,1.28,52.26,1.78,14.9,10.78,0.17,6.18,10.99,2.16,0.48,0.3,41,106,36,288,284,13,242,144,52,13,20,39,96,5,40,75,3,44,2,1543,0.15,98.79,98.83,100.11,101.29,51.6,155.5,54.9,423.8,316.8,14.5,285.9,194.8,66.4,18.6,26.4,48.6,119.2,5.7,47.3,92.1,3.6,51.2,1.9,1979,0.2),
    (1,108,"GAL-NB-165-11","2023-08-04",57.08,2.36,15.52,8.71,0.078,2.79,1.93,0.53,0.29,0.029,89.31,10.74,63.92,2.64,17.38,9.75,0.09,3.12,2.16,0.59,0.32,0.03,32,70,21,216,119,14,102,276,16,22.7,20,39,98,9,15,30,8,14,2,1124,0.11,89.42,89.45,100.19,101.16,40.5,102.7,32,318.1,133,15.7,120.5,372.4,20.4,32.5,26.5,49.1,122.3,9.5,17.2,37.1,9,16.7,2.4,1478,0.15),
    (1,109,"GAL-NB-165-12","2023-08-04",48.58,0.904,12.56,8.77,0.317,3.13,6.14,0.27,0.33,0.686,81.68,18.02,59.48,1.11,15.37,10.73,0.39,3.83,7.52,0.33,0.4,0.84,51,50,18,278,111,26,94,155,73,12.9,17,49,90,6,35,42,5,39,4,1158,0.12,81.8,81.83,99.86,100.83,65.5,73.4,27.6,408.9,124.1,28.1,110.7,209,93.1,18.4,23.3,61.8,112.3,6.8,41.2,51.5,5.9,45.8,4.8,1512,0.15),
    (1,110,"GAL-NB-165-13","2023-08-04",50.89,1.723,14.59,11.1,0.177,6.37,10.88,2.22,0.53,0.3,98.78,1.02,51.52,1.74,14.78,11.24,0.18,6.44,11.02,2.24,0.54,0.3,49,103,36,281,262,13,238,140,31,11.5,19,47,96,3,15,35,3,21,1,1404,0.14,98.92,98.96,99.98,101.22,62.3,149.9,55.1,413.7,292.4,14.2,281.6,188.9,39.1,16.4,24.9,59.1,119.2,3.2,18.1,42.9,3.5,24.9,1.1,1811,0.18),
    (1,140,"GAL-NB-165-15","2023-08-04",47.82,3.326,13.12,14.24,0.216,5.88,10.3,2.37,0.68,0.775,98.72,0.95,48.44,3.37,13.29,14.42,0.22,5.96,10.43,2.4,0.69,0.78,42,184,42,361,582,12,255,271,55,26.4,22,44,149,6,35,83,2,46,1,2218,0.22,98.95,99.01,99.95,101.54,53,269.3,64.3,531.7,649.5,13.5,301.8,366.6,69.6,37.7,29.6,55.7,185.3,6.1,41.6,101.6,1.9,53.4,0.7,2833,0.28),
    (1,123,"GAL-NB-165-16","2023-08-04",47.45,3.232,12.93,14.95,0.209,4.93,10.06,2.33,0.55,0.729,97.37,2.37,48.73,3.32,13.28,15.36,0.21,5.06,10.33,2.39,0.57,0.75,36,185,41,377,807,21,257,259,53,24.8,22,45,137,7,34,72,2,45,0,2426,0.24,97.61,97.68,100.05,101.71,46.1,270.3,63.2,554.8,901.2,22.6,304,350.1,67.6,35.4,29.2,55.8,170.9,7.6,40.2,88.2,2.4,52.7,0.5,3063,0.31),
    (1,124,"GAL-NB-165-17","2023-08-04",62.15,3.716,13.99,7.31,0.09,1.53,1.89,0.92,0.46,0.021,92.08,7.83,67.5,4.04,15.19,7.94,0.1,1.66,2.06,1,0.5,0.02,20,44,15,213,259,20,159,404,13,32.1,16,27,74,17,12,42,11,11,2,1393,0.14,92.22,92.26,100.09,100.9,25,64.3,23.7,313.2,289.6,21.8,188.2,545.2,15.9,46,21.9,33.6,92.6,18.7,14,52.1,12.9,13,2.5,1794,0.18),
    (1,125,"GAL-NB-165-18","2023-08-04",46.53,3.477,13.53,14.75,0.215,4.54,10.69,2.41,0.36,1.064,97.56,2.3,47.69,3.56,13.87,15.12,0.22,4.65,10.95,2.47,0.37,1.09,29,197,43,368,474,15,270,266,59,25.2,22,30,147,5,37,79,2,51,2,2122,0.21,97.78,97.84,100.14,101.77,37.5,288.2,65.7,542,529.5,16.3,319.8,358.7,74.9,36,29.7,37.4,183.4,5.8,43.4,96.8,2.2,59,2.1,2728,0.27),
    (1,126,"GAL-NB-165-19","2023-08-04",48.4,1.022,9.96,15.99,0.302,3.96,4.99,0.44,0.79,1.645,87.5,12.23,55.32,1.17,11.38,18.27,0.35,4.53,5.7,0.51,0.9,1.88,96,41,22,218,556,70,139,186,31,24.3,22,64,88,9,21,50,3,24,4,1667,0.17,87.67,87.71,99.94,101.71,121.6,59.3,34.5,321.3,620.3,76.2,164.8,250.7,40,34.7,29.3,80,109.4,9.3,24.6,61.1,3.6,27.6,4.8,2073,0.21),
    (1,127,"GAL-NB-165-20","2023-08-04",45.95,3.398,13.45,14.03,0.222,4.36,11.78,2.4,0.35,1.711,97.65,2.28,47.05,3.48,13.78,14.36,0.23,4.46,12.06,2.46,0.36,1.75,28,190,42,367,516,13,279,268,61,25.5,22,33,146,7,37,83,2,48,3,2171,0.22,97.87,97.93,100.21,101.77,35.7,277.5,63.7,540,576,14.5,329.7,362,77.7,36.5,29.5,41.5,182.3,8,43.7,101.5,2.2,56.1,3,2781,0.28),
    (1,129,"GAL-NB-165-21","2023-08-04",48.19,3.244,12.8,14.9,0.23,4.92,9.32,1.47,0.68,0.718,96.47,3.21,49.95,3.36,13.27,15.45,0.24,5.1,9.66,1.52,0.71,0.74,34,166,40,350,624,16,227,266,54,24.4,21,49,151,8,35,77,2,44,0,2188,0.22,96.69,96.75,99.96,101.61,43.3,241.9,61.7,514.3,696.3,17.7,268.6,359.2,69.2,34.8,27.6,61,187.7,8.3,41.5,95.1,2.2,51.8,0.5,2783,0.28),
    (1,130,"GAL-NB-165-22","2023-08-04",54.44,3.169,11.45,11.89,0.212,3.18,5.11,1.15,0.66,0.34,91.6,8.22,59.43,3.46,12.5,12.98,0.23,3.47,5.58,1.25,0.72,0.37,26,107,31,214,832,28,227,283,38,22.7,16,49,108,9,29,74,3,38,2,2137,0.21,91.81,91.86,100.08,101.4,33.7,155.8,48.2,315.4,928.4,30.5,268.2,382.6,47.9,32.5,21.8,61.3,134,9.3,34.4,91,3.9,44.4,2.5,2646,0.26),
    (1,131,"GAL-NB-165-23","2023-08-04",69.22,2.965,9.5,5.86,0.113,1.25,1.69,0.65,0.57,0.039,91.85,7.78,75.36,3.23,10.34,6.38,0.12,1.36,1.84,0.7,0.63,0.04,13,18,11,202,327,29,123,357,24,18.7,12,24,50,9,27,60,5,25,2,1337,0.13,91.98,92.02,99.8,100.45,16.1,26.6,17.5,297.8,365.1,31.9,145.4,481.7,31.1,26.8,15.9,29.8,62.4,9.8,31.5,73.1,5.8,29.4,2,1700,0.17),
    (1,132,"GAL-NB-165-24","2023-08-23",49.74,3.475,12.59,14.35,0.19,3.56,8.54,2.29,0.98,0.56,96.27,3.57,51.66,3.61,13.07,14.91,0.2,3.7,8.87,2.38,1.02,0.58,14,12,33,402,499,31,237,259,53,23.3,22,22,150,7,32,71,4,39,2,1913,0.19,96.46,96.51,100.08,101.68,18,17.3,50.6,591.3,557.3,33.5,280.8,350.5,67,33.3,29.4,27.9,186.3,7.2,37.6,86.7,4.8,45.6,2.7,2428,0.24),
    (1,133,"GAL-NB-165-25","2023-08-04",80.5,0.265,3.82,2.35,0.032,1.04,1.26,0.08,0.21,0.015,89.56,10.31,89.89,0.3,4.26,2.62,0.04,1.16,1.41,0.08,0.23,0.02,5,12,5,52,213,20,43,55,14,3.3,6,8,29,1,10,11,3,10,2,502,0.05,89.61,89.62,99.92,100.19,6.7,17.4,6.9,76.9,238.4,22.1,51.1,73.8,18.2,4.7,7.6,9.4,35.5,0.9,11.6,13.7,3.4,11.5,2.3,612,0.06),
    (1,134,"GAL-NB-165-26","2023-08-23",90.66,0.113,1.59,0.72,0.019,0.39,0.57,0.09,0.11,0.017,94.3,5.81,96.14,0.12,1.69,0.77,0.02,0.42,0.61,0.1,0.12,0.02,5,10,2,40,164,10,26,23,9,0.6,1,5,12,1,7,7,1,9,3,337,0.03,94.33,94.34,100.15,100.23,5.8,15.2,2.8,59.5,182.8,10.4,30.9,30.7,11.8,0.9,1.7,5.9,15.5,1.2,8.4,9.2,1.3,10.9,3.1,408,0.04),
    (1,135,"GAL-NB-165-27","2023-08-23",52.15,3.782,13.18,14.46,0.183,3.35,7.56,1.95,0.68,0.541,97.85,1.77,53.3,3.87,13.47,14.78,0.19,3.43,7.73,1.99,0.69,0.55,12,21,32,418,573,30,235,277,162,26.3,24,25,151,14,185,196,6,193,2,2584,0.26,98.1,98.17,99.94,101.55,15.5,30,49.7,615.6,640.2,32.4,278.1,374.1,205.2,37.6,32.8,31.1,188.3,15.4,217.2,241.2,7,225.2,2.1,3239,0.32),
    (1,136,"GAL-NB-165-28","2023-08-05",50.92,3.652,13.24,13.68,0.182,3.82,8.93,2.47,1.07,0.572,98.53,1.29,51.68,3.71,13.44,13.88,0.18,3.87,9.06,2.51,1.08,0.58,14,12,33,430,498,32,246,267,53,25,22,21,159,7,32,72,6,41,1,1971,0.2,98.72,98.78,100.07,101.59,17.4,17,50.7,631.9,555.6,35.5,291.2,360.3,66.7,35.8,29.9,26.8,198.3,7.1,37.4,89.1,6.9,47.9,1.3,2507,0.25),
    (1,137,"GAL-NB-165-29","2023-08-05",50.57,3.603,12.88,13.87,0.203,3.89,8.84,2.37,0.95,0.551,97.71,2.09,51.75,3.69,13.18,14.19,0.21,3.98,9.04,2.42,0.97,0.56,15,12,35,422,445,30,244,267,52,24,23,20,149,6,32,74,5,41,1,1897,0.19,97.9,97.96,100.05,101.59,19.1,16.9,53,621,497.1,32.5,288.9,360.9,65.7,34.4,31.5,25,186,6.9,37.5,90.4,5.4,47.5,0.9,2421,0.24),
    (1,138,"GAL-NB-165-30","2023-08-05",50.47,3.554,12.83,14.91,0.209,3.48,8.59,2.36,1.08,0.575,98.06,1.66,51.47,3.62,13.09,15.2,0.21,3.55,8.76,2.41,1.1,0.59,14,13,33,422,488,31,240,265,55,25.5,23,21,150,7,33,73,5,41,2,1942,0.19,98.26,98.31,99.97,101.63,17.4,19.1,49.9,621.3,544.8,34.1,284,358.2,70.2,36.5,31,25.8,186.7,7.7,39,89.4,5.8,48.3,2,2471,0.25),
    (1,139,"GAL-NB-165-31","2023-08-05",50.57,3.57,12.84,14.77,0.21,4.22,8.67,2.41,1.25,0.548,99.06,0.44,51.05,3.6,12.96,14.91,0.21,4.26,8.75,2.43,1.26,0.55,16,10,33,421,497,31,234,267,51,24.8,23,23,155,8,33,67,5,39,1,1940,0.19,99.26,99.31,99.75,101.39,20.2,14.4,51.3,619.4,554.9,34.4,276.9,360.9,65.1,35.5,30.7,29.1,193.1,8.4,38.3,82.4,5.8,46,1,2468,0.25),
    (1,1,"GAL-NB-165-32","2023-08-05",51.69,3.219,13.46,13.77,0.157,2.54,6.46,3.08,2.02,0.831,97.23,2.33,53.16,3.31,13.85,14.16,0.16,2.61,6.64,3.17,2.08,0.85,5,0,30,276,2828,44,287,426,49,21.2,23,14,127,10,43,84,6,46,1,4317,0.43,97.66,97.74,100.07,101.6,5.8,0,45.3,405.3,3157.1,48.5,339.4,574.9,62.2,30.4,30.8,17,158,10.7,49.9,103.3,6.5,53.5,1.2,5100,0.51),
    (1,2,"GAL-NB-165-33","2023-08-05",54.18,3.454,14.54,10,0.163,1.63,5.6,3.52,2.48,0.887,96.45,2.75,56.18,3.58,15.08,10.37,0.17,1.69,5.8,3.65,2.57,0.92,8,0,32,261,3099,51,311,466,47,22.9,25,13,144,11,42,91,7,47,2,4680,0.47,96.92,97,99.75,100.86,9.6,0,48.8,383.6,3459.7,55.3,368.3,629.2,59.1,32.8,33.7,16.8,179.8,12,49.7,112.4,7.7,54.9,2.3,5516,0.55),
    (1,3,"GAL-NB-165-34","2023-08-05",54.01,4.717,16.08,13.42,0.342,1.97,1.85,0.29,0.14,0.082,92.89,6.67,58.14,5.08,17.31,14.44,0.37,2.12,1.99,0.31,0.15,0.09,10,28,26,389,757,12,108,479,19,29,23,25,184,28,18,102,9,20,4,2270,0.23,93.12,93.18,99.85,101.34,12.6,40.9,39.1,572.5,845.5,13.2,128,646.6,24.5,41.5,30.8,31.1,229,30.6,20.8,125.7,9.7,23.6,4.2,2870,0.29),
    (1,4,"GAL-NB-165-35","2023-08-05",50.04,4.092,16.87,13.17,0.082,1.27,1.81,0.21,0.17,0.076,87.79,12.1,57,4.66,19.21,15,0.09,1.45,2.06,0.24,0.2,0.09,23,27,26,342,899,16,178,431,13,26.3,20,26,115,30,9,30,8,11,2,2231,0.22,88.01,88.06,100.17,101.63,29.5,39.4,39.8,503.8,1003.6,17.2,210,582.3,16.8,37.6,26.4,32,143.6,32.6,10.2,36.3,8.8,12.8,2.2,2785,0.28),
    (1,5,"GAL-NB-165-36","2023-08-05",48.51,3.936,16,13.29,0.252,1.73,5.68,2.49,0.43,0.773,93.08,6.69,52.11,4.23,17.2,14.27,0.27,1.86,6.1,2.67,0.46,0.83,10,18,42,467,681,16,363,257,218,20.6,26,27,147,9,122,214,6,130,3,2775,0.28,93.36,93.43,100.11,101.59,13,26.4,64.3,686.8,760.5,17,429.8,347.4,276.5,29.4,34.7,33.5,182.7,9.2,142.6,262.5,7.3,152,2.8,3478,0.35),
    (1,6,"GAL-NB-165-37","2023-08-05",49.26,3.229,13.77,14.75,0.178,3.58,8.11,2.41,0.5,0.62,96.4,3.26,51.09,3.35,14.29,15.3,0.18,3.71,8.41,2.5,0.51,0.64,11,17,38,455,564,18,334,214,119,16.6,23,24,150,8,88,157,5,91,2,2334,0.23,96.64,96.7,99.96,101.6,14.4,24.9,57.7,669,629.7,19.8,395.2,289.7,150.6,23.7,30.8,30.4,187.3,8.3,103,193.2,5.2,105.6,2,2941,0.29),
    (1,8,"GAL-NB-165-38","2023-08-05",49.06,2.026,14.82,13.02,0.064,2.93,2.77,0.15,0.13,0.079,85.03,14.74,57.7,2.38,17.42,15.31,0.08,3.44,3.25,0.17,0.16,0.09,13,14,28,293,161,14,100,216,106,14.2,24,23,80,6,83,187,5,84,3,1454,0.15,85.18,85.22,99.96,101.41,17.1,21.1,43.3,430.6,180.1,14.8,118.3,292,134.9,20.3,31.8,28.7,99.6,6.2,97,229.4,5.7,98,3.7,1873,0.19),
    (1,9,"GAL-NB-165-39","2023-08-05",51.89,2.684,15.91,13.15,0.046,3.13,1.87,0.23,0.18,0.046,89.13,10.66,58.21,3.01,17.85,14.76,0.05,3.52,2.1,0.26,0.2,0.05,14,14,25,320,189,20,113,249,95,18.1,23,22,74,7,57,106,5,56,2,1409,0.14,89.28,89.32,99.98,101.44,18,21.2,38.6,470.6,211.4,21.4,133.1,336.3,120.5,25.9,31.1,27.4,91.7,7.8,66.5,130.1,5.6,65.5,2.2,1825,0.18),
    (1,10,"GAL-NB-165-40","2023-08-05",47.91,4.465,16.48,13.53,0.104,1.69,4.47,2.19,0.42,0.567,91.83,7.71,52.17,4.86,17.95,14.74,0.11,1.84,4.87,2.38,0.46,0.62,9,20,43,534,527,14,320,277,144,22.5,26,20,149,13,65,81,6,69,2,2343,0.23,92.06,92.13,99.83,101.34,12,29.7,65.4,785.3,588.3,15.7,378.6,374.2,182.9,32.2,35.1,25.4,185.5,13.9,75.9,100.1,7.3,80.2,2.1,2990,0.3),
    (1,11,"GAL-NB-165-41","2023-08-05",48.01,3.896,15.87,14.26,0.092,1.67,4.61,2.16,0.48,0.804,91.85,7.92,52.27,4.24,17.28,15.52,0.1,1.82,5.02,2.35,0.52,0.87,10,19,40,487,583,17,311,254,239,20.8,26,21,167,10,103,145,5,97,3,2557,0.26,92.11,92.18,100.1,101.68,12.4,27.9,61,717,650.9,19.1,368.2,342.7,303.5,29.7,34.9,25.7,207.4,10.5,121,177.8,5.8,113.7,3.1,3232,0.32),
    (1,12,"GAL-NB-165-42","2023-08-05",47.56,3.677,15.6,15.43,0.154,1.86,5.46,2.08,0.44,0.526,92.78,7.04,51.26,3.96,16.81,16.63,0.17,2,5.89,2.24,0.48,0.57,17,20,33,406,608,13,311,228,142,18,26,18,206,8,85,201,4,91,3,2439,0.24,93.03,93.09,100.13,101.85,21.7,28.9,50.7,596.8,678.8,14.3,368.1,307.6,180.2,25.8,35.4,23.2,256.2,9,99.7,247.2,4.9,105.7,3.7,3058,0.31),
    (1,13,"GAL-NB-165-43","2023-08-05",50.07,3.231,13.7,14.48,0.207,3.16,8.15,2.39,0.68,0.73,96.79,2.84,51.73,3.34,14.15,14.96,0.21,3.26,8.42,2.47,0.7,0.75,12,19,38,427,670,16,324,213,92,16,23,21,151,6,75,144,4,81,2,2334,0.23,97.03,97.09,99.92,101.53,15.7,27.3,58,628.3,747.6,17.1,383.2,287.1,116.7,22.9,30.4,26.5,188.6,6.7,88.4,176.9,4.8,95,2.5,2924,0.29),
    (1,14,"GAL-NB-165-44","2023-08-05",50.44,3.126,13.34,13.91,0.236,3.56,8.33,2.57,0.98,0.608,97.11,2.51,51.94,3.22,13.74,14.33,0.24,3.67,8.58,2.64,1.01,0.63,15,19,37,448,571,34,320,207,46,15.5,22,19,150,7,23,59,4,34,1,2031,0.2,97.31,97.36,99.88,101.42,19,27.1,56.9,658.5,637.5,37.4,378.2,279.8,58.6,22.1,29.6,24.2,186.3,7.7,26.6,72.1,4.9,39.2,1.6,2567,0.26),
    (1,32,"GAL-NB-165-45","2023-08-05",53.51,2.74,13.34,12.46,0.201,2.6,6.35,3.18,2.41,0.966,97.76,1.56,54.74,2.8,13.65,12.74,0.21,2.66,6.49,3.26,2.46,0.99,7,0,26,184,3611,45,301,499,50,22.9,24,12,130,11,41,94,7,50,2,5117,0.51,98.27,98.36,99.92,101.3,8.5,0,40.3,270.2,4032.2,49.7,356.4,674.2,63.1,32.7,32,14.8,161.7,11.6,48.3,115.8,7.6,58.8,1.9,5980,0.6),
    (1,37,"GAL-NB-165-46","2023-08-05",57.78,0.871,12.19,4.88,0.09,2.07,8.64,1.97,1.89,0.204,90.6,9.22,63.78,0.96,13.46,5.39,0.1,2.29,9.54,2.17,2.09,0.22,23,49,13,101,646,68,334,293,29,14.4,15,24,69,14,38,71,10,33,1,1844,0.18,90.78,90.82,100.04,100.59,29.7,71.2,19.9,148.6,721.6,74.4,395,395.7,36.7,20.5,20.1,29.5,86.2,14.7,44.3,86.8,10.9,37.9,1.6,2245,0.22),
    (1,35,"GAL-NB-165-47","2023-08-06",54.01,2.742,13.34,12.65,0.203,2.68,6.36,3,2.57,0.957,98.52,1.1,54.82,2.78,13.54,12.84,0.21,2.72,6.46,3.05,2.61,0.97,8,0,27,185,3414,46,282,495,49,22.2,23,12,129,11,44,94,7,49,2,4897,0.49,99.01,99.09,100.19,101.59,9.8,0,41.2,272.4,3811.3,50.6,333.9,668.6,61.7,31.8,30.6,14.9,160.5,11.6,51.3,115.1,7.4,57,2.2,5732,0.57),
    (1,145,"GAL-NB-165-48","2023-08-06",54.52,2.591,13.63,11.51,0.194,2.24,6.22,3.15,2.8,1.076,97.93,1.57,55.67,2.65,13.91,11.76,0.2,2.29,6.35,3.21,2.86,1.1,6,0,25,145,3815,50,316,500,51,24,24,10,130,12,50,103,7,50,2,5321,0.53,98.47,98.55,100.13,101.41,7.8,0,38.7,213,4259.6,54.1,373.7,675,64.7,34.3,32,13.1,161.5,13.5,59,127.2,7.9,58.8,2.5,6196,0.62),
    (1,152,"GAL-NB-165-49","2023-08-06",54.3,2.553,13.44,11.82,0.135,2.1,5.71,3.35,2.77,1.059,97.23,2.2,55.85,2.63,13.82,12.16,0.14,2.15,5.87,3.45,2.84,1.09,7,0,25,148,3596,55,274,495,50,22.8,23,13,130,13,46,98,6,48,2,5052,0.51,97.73,97.82,100.02,101.33,9.2,0,38.2,217.9,4015.1,60.1,324.5,669.2,63.9,32.6,30.7,16.6,161.5,14.2,53.7,119.9,7,55.7,2,5892,0.59),
    (1,144,"GAL-NB-165-50","2023-08-06",62.29,1.051,12.18,5.63,0.097,2.27,5.88,2.14,1.98,0.239,93.76,5.89,66.43,1.12,12.99,6.01,0.1,2.42,6.27,2.29,2.11,0.26,23,49,15,126,646,72,326,348,32,15.7,15,21,75,14,39,78,9,33,4,1941,0.19,93.96,94,99.89,100.52,29.5,72,22.9,185.4,721.4,79.2,385,470.7,40.3,22.5,20.8,26.5,92.9,14.7,45.4,96,10.4,38.7,4.2,2378,0.24),
    (1,167,"GAL-NB-165-51","2023-08-06",43.52,1.936,15.82,12.63,0.342,1.89,3.43,1.48,0.8,0.474,82.32,17.62,52.87,2.35,19.21,15.34,0.42,2.29,4.17,1.8,0.98,0.58,17,29,28,255,600,47,202,187,23,12.8,25,32,180,11,16,51,5,20,1,1741,0.17,82.5,82.54,100.16,101.56,21.1,42.1,43.3,375.1,669.4,51.2,238.6,252.6,28.7,18.3,33.6,40.4,223.9,11.9,18.7,62.6,5.6,23.8,1.5,2163,0.22),
    (1,170,"GAL-NB-165-52","2023-08-06",50.27,2.092,14.97,13.03,0.193,4.68,8.21,2.37,0.57,0.314,96.69,3.13,51.99,2.16,15.48,13.48,0.2,4.84,8.49,2.46,0.59,0.32,16,24,40,356,513,14,307,169,34,12,22,31,131,6,22,34,4,24,0,1759,0.18,96.87,96.92,100.05,101.5,20.5,35.8,61,523.1,572.6,15.3,363.4,227.8,43,17.1,29.1,38.9,162.7,6.6,26.1,42.2,4.8,28.2,0,2218,0.22),
    (1,169,"GAL-NB-165-53","2023-08-06",52.21,2.016,14.44,12.23,0.19,4.61,8.8,2.78,0.86,0.307,98.44,1.35,53.04,2.05,14.66,12.43,0.19,4.68,8.94,2.82,0.87,0.31,13,24,38,348,498,20,340,167,43,12.7,21,29,128,6,20,42,3,29,2,1785,0.18,98.62,98.67,100.02,101.38,17,35.3,58,512.2,555.9,21.5,402.1,225.8,54.1,18.1,28.7,36.4,158.8,6.9,23.8,51.7,3.9,34.1,2.2,2246,0.22),
    (1,166,"GAL-NB-165-54","2023-08-23",48.58,2.228,15.93,13.69,0.189,4.02,6.63,2.14,0.55,0.33,94.29,5.35,51.53,2.36,16.9,14.51,0.2,4.26,7.03,2.27,0.58,0.35,16,25,42,340,675,14,258,176,27,11.3,25,32,141,6,16,29,4,20,1,1859,0.19,94.47,94.52,99.87,101.39,20.7,36.6,64.1,499.5,753.5,15.6,304.6,238.3,34.4,16.2,33.7,40,175.3,6.9,18.6,35.5,5,23.2,1.1,2323,0.23),
    (1,74,"GAL-NB-165-55","2023-08-06",54.67,2.69,12.92,13.19,0.239,2.79,6.76,3.21,1.73,0.796,98.99,0.71,55.23,2.72,13.06,13.32,0.24,2.82,6.83,3.24,1.75,0.8,6,0,32,156,915,43,331,240,54,17.8,22,13,161,9,32,68,6,40,2,2150,0.21,99.21,99.25,99.96,101.42,7.2,0,49.8,230.1,1022.1,47.5,391.5,324.2,69,25.5,29.6,16.1,200.1,10.1,37.5,83.2,6.7,46.9,2.3,2600,0.26),
    (1,78,"GAL-NB-165-56","2023-08-23",50.74,1.914,15.81,12.24,0.113,3.65,7.68,2.67,0.39,0.387,95.6,4.19,53.08,2,16.54,12.81,0.12,3.81,8.04,2.79,0.41,0.41,13,45,39,262,502,17,336,187,70,13.3,23,38,102,8,37,55,4,42,2,1794,0.18,95.78,95.82,100.01,101.37,16.5,65.1,59.6,385.5,560.5,18.5,397.7,252.6,89.2,19.1,31.3,46.9,126.5,8.6,43.3,67.2,4.5,48.6,2.3,2243,0.22),
    (1,79,"GAL-NB-165-57","2023-08-06",48.46,1.252,16.94,13.26,0.198,1.92,1.82,0.22,0.3,0.146,84.52,15.19,57.33,1.48,20.05,15.69,0.23,2.28,2.16,0.26,0.35,0.17,15,16,24,157,359,32,98,270,45,15.2,28,56,99,13,24,82,6,26,2,1366,0.14,84.65,84.69,99.88,101.35,19.7,23.8,36.4,230.5,400.6,35,115.5,364.4,56.5,21.8,37.3,69.8,123.2,14,28.3,100.5,6.8,30.8,2.6,1718,0.17),
    (1,81,"GAL-NB-165-58","2023-08-06",52.42,1.743,14.64,11.82,0.211,4.75,8.51,2.65,0.79,0.299,97.84,2.07,53.58,1.78,14.97,12.08,0.22,4.86,8.7,2.7,0.81,0.31,17,42,36,302,488,29,316,170,35,11.5,21,25,119,6,18,43,4,27,2,1709,0.17,98.01,98.06,100.13,101.44,21.7,60.8,54.8,443.8,544.7,31.3,374.2,229.8,44.1,16.5,28.4,31.4,147.9,6.2,21.2,53.1,4.1,30.9,1.9,2147,0.21),
    (1,84,"GAL-NB-165-59","2023-08-06",46.48,1.788,24.42,12.83,0.126,1.19,2.14,0.57,0.46,0.213,90.21,9.32,51.53,1.98,27.06,14.22,0.14,1.32,2.38,0.63,0.51,0.24,9,16,26,124,624,43,156,398,48,24.1,37,20,276,19,29,74,8,34,2,1969,0.2,90.41,90.46,99.78,101.2,11.9,24,39.6,182.3,696.9,47,185,538,60.8,34.5,49.9,24.6,343.6,20.7,34.6,90.4,9.5,40.1,2.5,2436,0.24),
    (1,85,"GAL-NB-165-60","2023-08-06",47.32,1.518,23.13,8.84,0.033,1,1.76,0.23,0.48,0.24,84.55,15.26,55.97,1.79,27.35,10.45,0.04,1.18,2.08,0.27,0.57,0.28,10,15,20,117,594,39,121,406,45,24.4,32,36,147,21,24,64,9,29,3,1757,0.18,84.73,84.77,100.03,101.01,12.9,21.4,31,172.2,663.2,42.3,143,548.4,57.1,35,43.6,44.9,183.3,22.6,27.6,78.7,10.3,34.3,3.7,2176,0.22),
    (1,86,"GAL-NB-165-61","2023-08-06",47.29,1.6,23.64,8.93,0.038,1.05,2.01,0.26,0.49,0.28,85.59,14.22,55.26,1.87,27.62,10.43,0.04,1.23,2.34,0.3,0.58,0.33,11,20,22,141,673,40,148,424,42,25,32,33,154,21,20,58,9,23,2,1898,0.19,85.78,85.82,100.04,101.03,13.8,29.8,33.8,206.9,751,43.5,174.9,572.7,53.3,35.8,43.4,41.9,191.9,22.8,23.3,70.9,10.7,26.6,2.3,2349,0.23),
    (1,89,"GAL-NB-165-62","2023-08-06",55.06,1.712,14.34,10.19,0.193,4.71,8.57,2.76,1.46,0.312,99.31,0.65,55.44,1.72,14.44,10.26,0.19,4.74,8.63,2.78,1.47,0.31,14,40,35,294,607,36,312,168,36,11.1,20,28,117,6,17,42,4,25,0,1815,0.18,99.49,99.54,100.19,101.32,18.3,59.2,53.6,432.7,678,39.2,369.1,227.3,45.3,15.8,27.5,35.2,146,6.2,20.5,51.7,4.6,29.4,0.4,2260,0.23),
    (1,18,"GAL-NB-165-63","2023-08-06",50.84,3.578,13.03,14.49,0.204,4.01,8.81,2.56,1.03,0.562,99.11,0.76,51.29,3.61,13.15,14.62,0.21,4.05,8.88,2.59,1.04,0.57,20,13,33,417,547,27,245,270,53,24.9,22,24,158,7,32,70,5,38,3,2008,0.2,99.31,99.37,100.12,101.73,25.4,19,50.1,614.1,610.5,29.3,290.2,364.8,66.7,35.6,30.2,30,196.1,7.9,37.8,85.7,6,43.9,2.9,2546,0.25),
    (1,30,"GAL-NB-165-64","2023-08-06",48.1,3.331,13.15,14.47,0.222,5.82,10.21,2.43,0.68,0.782,99.19,0.27,48.49,3.36,13.26,14.59,0.22,5.87,10.29,2.45,0.69,0.79,41,181,41,363,589,10,248,274,57,26.1,21,44,151,7,35,80,2,45,1,2215,0.22,99.41,99.47,99.74,101.35,52.6,265,62.3,533.4,657.2,11,293.2,369.4,72.1,37.3,28.9,55.4,187.9,7.3,41,98.8,2.8,52.2,0.6,2828,0.28),
    (1,21,"GAL-NB-165-65","2023-08-06",61.24,2.504,16.19,9.06,0.09,1.98,1.83,0.62,0.7,0.048,94.26,5.41,64.97,2.66,17.18,9.62,0.1,2.1,1.94,0.65,0.74,0.05,22,37,16,162,276,63,126,363,18,31.2,24,28,100,16,18,42,13,18,2,1376,0.14,94.4,94.44,99.85,100.85,28.6,53.4,25.3,238.5,308.3,68.6,149.3,489.9,23.2,44.6,31.9,35.4,124.5,17.2,21.1,51.3,15,20.7,2.6,1749,0.17),
    (1,22,"GAL-NB-165-66","2023-08-07",60.16,2.403,13.69,8.3,0.087,2.2,1.96,0.58,0.76,0.027,90.18,9.42,66.71,2.66,15.18,9.2,0.1,2.44,2.17,0.65,0.84,0.03,19,35,15,167,389,53,128,330,16,29.8,17,25,81,13,15,31,12,14,2,1390,0.14,90.32,90.36,99.78,100.7,24.7,50.7,22.6,244.9,434.5,57.6,152,445.1,19.7,42.6,23.5,30.8,100.3,13.7,18,38.3,13.3,16.4,2,1751,0.18),
    (1,25,"GAL-NB-165-67","2023-08-07",51.5,1.769,14.72,10.12,0.17,5.68,10.34,2.11,0.23,0.226,96.88,2.69,53.16,1.83,15.2,10.45,0.18,5.87,10.68,2.18,0.23,0.23,39,104,35,293,311,8,237,140,80,12.2,19,16,74,6,90,101,3,77,1,1648,0.16,97.04,97.09,99.78,100.9,49.4,152.1,53.5,431,347.6,8.5,280.7,189.2,102.1,17.5,25.2,20.4,91.9,6.8,105.3,124.2,3.6,90.4,1.4,2101,0.21),
    (1,26,"GAL-NB-165-68","2023-08-07",63.68,3.99,11.21,7.91,0.098,1.71,2.07,1.21,1.2,0.025,93.1,6.71,68.4,4.29,12.04,8.5,0.11,1.84,2.23,1.3,1.29,0.03,15,21,12,200,430,51,144,494,18,40.3,16,21,71,23,27,69,15,22,2,1689,0.17,93.27,93.32,100.02,100.9,19,30.7,17.8,294.2,479.7,55.7,170,667.2,22.6,57.7,21.4,26.1,88.2,24.6,31.2,84.5,17.1,25.6,2.1,2135,0.21),
    (1,28,"GAL-NB-165-69","2023-08-07",51.47,1.703,14.92,10.23,0.166,6.28,11.01,2.31,0.42,0.267,98.78,1.18,52.11,1.72,15.1,10.36,0.17,6.35,11.15,2.34,0.43,0.27,45,100,36,283,243,12,242,139,31,11.7,19,48,98,4,18,37,3,20,3,1393,0.14,98.92,98.96,100.15,101.28,57.2,146.3,55,415.9,271.3,12.9,285.8,187.5,39.8,16.7,25.3,59.5,121.6,4.8,21.6,46,3.9,23.9,2.9,1798,0.18),
    (1,29,"GAL-NB-165-70","2023-08-07",51.45,1.711,14.92,10.09,0.161,6.32,10.96,2.29,0.43,0.263,98.61,1.33,52.18,1.74,15.13,10.23,0.16,6.41,11.12,2.33,0.44,0.27,50,107,36,282,244,12,243,138,31,12.1,18,44,91,2,17,34,2,22,1,1387,0.14,98.75,98.79,100.12,101.24,63.1,155.9,55.6,415,272.8,13.6,287.2,187,39.1,17.3,24.1,55.4,113.7,2.5,19.6,41.3,2.8,25.4,0.9,1792,0.18),
    (1,61,"GAL-NB-165-71","2023-08-07",46.7,3.992,12.2,14.82,0.227,3.5,9.85,2.36,0.82,1.996,96.46,3.16,48.41,4.14,12.64,15.37,0.24,3.63,10.21,2.45,0.85,2.07,21,32,40,251,971,27,272,532,116,53.9,26,20,220,12,77,169,5,100,1,2946,0.29,96.75,96.82,99.99,101.63,26.5,46.7,61.9,369.4,1083.8,29.4,321.9,719.1,147.5,77.2,35.3,24.6,273.5,12.6,90.8,207.7,5.4,116.8,1.3,3651,0.37),
    (1,65,"GAL-NB-165-72","2023-08-07",50.51,7.622,11.16,16.16,0.246,2.24,3.32,0.83,0.6,0.448,93.15,6.54,54.22,8.18,11.99,17.35,0.26,2.41,3.57,0.9,0.65,0.48,28,107,33,426,633,27,167,436,51,45.2,17,23,139,10,33,103,4,44,2,2327,0.23,93.38,93.45,99.99,101.78,35.1,156,50.4,626.9,707.2,29,197.4,588.6,65.1,64.6,23.1,28.2,172.5,11.1,38.4,126.1,4.8,51.3,2.2,2978,0.3),
    (1,66,"GAL-NB-165-73","2023-08-07",48.21,3.747,13.34,13.93,0.225,4.52,9.78,2.33,0.72,0.948,97.75,1.69,49.32,3.83,13.65,14.25,0.23,4.62,10.01,2.38,0.74,0.97,32,113,41,393,860,18,272,317,69,31.9,23,28,154,8,45,104,4,57,1,2572,0.26,98.01,98.08,99.76,101.31,40.6,165.6,62.9,578,960.3,19.6,321.6,428,88.1,45.6,31.6,35.6,192.3,8.9,52.5,127.3,4.4,66.7,0.8,3230,0.32),
    (1,67,"GAL-NB-165-74","2023-08-07",48.68,3.633,13.22,13.87,0.193,4.25,9.81,2.3,0.67,0.862,97.49,2.29,49.93,3.73,13.56,14.23,0.2,4.36,10.06,2.36,0.69,0.88,26,117,40,378,806,22,269,312,65,30.5,22,35,157,8,45,99,3,57,2,2494,0.25,97.74,97.8,100.09,101.63,33.6,170.8,61.5,556.3,899.9,23.8,318.1,420.8,83.1,43.6,30.2,44.1,195,8.3,53.3,121.3,3.9,66.7,1.8,3136,0.31),
    (1,68,"GAL-NB-165-75","2023-08-07",64.96,1.641,9.3,8.47,0.105,2.78,4.14,0.9,0.9,0.332,93.52,6.32,69.46,1.75,9.95,9.05,0.11,2.97,4.43,0.96,0.96,0.36,20,55,21,192,527,38,149,253,49,20.6,14,42,91,8,41,79,6,44,3,1653,0.17,93.69,93.73,100.05,100.99,26.1,80.3,32.6,282.5,588.9,41.6,176.6,341.4,62,29.5,18.4,52.3,113.1,9,47.9,97.4,7,51.5,3,2061,0.21),
    (1,70,"GAL-NB-165-76","2023-08-07",47.87,3.426,13.47,13.51,0.219,4.6,10.76,2.33,0.51,0.811,97.5,2.17,49.1,3.51,13.81,13.86,0.22,4.71,11.03,2.39,0.53,0.83,29,188,42,374,480,14,263,276,59,26.7,22,39,150,6,35,79,3,47,1,2135,0.21,97.72,97.78,99.95,101.45,36.8,275.2,64.2,550.2,536.5,15.2,311.3,373.2,74.9,38.2,29.3,49.1,187.2,6.5,40.8,97.1,3,55.2,0.9,2745,0.27),
    (1,154,"GAL-NB-165-77","2023-08-07",56.29,2.06,13.77,11.53,0.17,3.32,6.65,3.31,1.74,0.349,99.18,0.77,56.75,2.08,13.88,11.63,0.17,3.35,6.7,3.34,1.75,0.35,11,7,31,353,713,51,309,195,38,13.4,22,24,126,8,27,54,5,28,1,2018,0.2,99.39,99.43,100.2,101.48,14.6,10.7,48.1,518.9,795.8,55.6,365.2,263.9,48.3,19.2,29,30.6,157.3,9.1,31.4,66.2,5.6,33.2,0.9,2504,0.25),
    (1,158,"GAL-NB-165-78","2023-08-07",52.88,1.928,14.87,11.22,0.129,3.36,7.91,2.74,0.64,0.445,96.12,3.66,55.01,2.01,15.47,11.67,0.13,3.5,8.23,2.85,0.67,0.46,19,43,41,298,513,13,333,166,58,12.7,20,57,121,5,24,42,4,30,1,1802,0.18,96.3,96.35,100.01,101.26,24.2,63.1,62.7,438.5,573.2,13.8,394,224.4,74.1,18.2,27.4,71.7,150.1,5.6,28,52.1,4,35,1.1,2261,0.23),
    (1,159,"GAL-NB-165-79","2023-08-07",49.73,2.159,16.22,13.23,0.155,2.62,6.97,2.79,0.28,0.323,94.46,5.11,52.64,2.29,17.17,14,0.16,2.77,7.38,2.95,0.3,0.34,22,53,44,297,490,4,342,181,32,13.7,24,56,118,8,18,38,3,25,1,1770,0.18,94.64,94.69,99.79,101.26,27.8,77.8,67.6,436.7,547.2,4.4,404.4,244.3,40.8,19.6,31.7,70.3,147.3,8.6,20.7,47.1,3.8,29.3,1.2,2231,0.22),
    (1,161,"GAL-NB-165-80","2023-08-07",50.54,1.969,15.27,12.45,0.172,4.13,9.1,2.77,0.35,0.329,97.08,2.79,52.06,2.03,15.73,12.82,0.18,4.26,9.38,2.85,0.36,0.34,21,46,42,338,369,9,351,167,43,11.9,22,60,120,5,20,42,3,27,2,1698,0.17,97.25,97.29,100.08,101.46,26.9,67.2,63.9,497.4,411.6,9.5,414.8,226,55.1,17.1,29.1,74.8,149.5,5.9,23.4,51.1,3.5,31.5,1.8,2160,0.22),
    (1,163,"GAL-NB-165-81","2023-08-07",52.23,1.818,14.05,11.94,0.188,4.79,8.93,2.68,0.9,0.306,97.84,1.82,53.39,1.86,14.36,12.2,0.19,4.9,9.12,2.74,0.92,0.31,20,41,39,351,447,24,330,154,37,12.1,21,65,115,5,14,40,3,26,2,1745,0.17,98.01,98.06,99.87,101.2,26,59.9,59.2,516.1,499.3,26.3,390.5,207.9,46.4,17.3,28.1,81.1,143.5,5,16.2,49.6,3.5,30.2,1.8,2208,0.22),
    (1,112,"GAL-NB-165-82","2023-08-07",49.91,3.663,13.3,13.91,0.192,3.97,8.61,2.49,0.85,0.574,97.45,2.08,51.21,3.76,13.64,14.27,0.2,4.07,8.83,2.55,0.87,0.59,20,11,34,416,565,15,255,274,55,25.9,23,27,170,7,37,72,5,41,2,2055,0.21,97.66,97.71,99.8,101.34,25.5,16.2,51.6,612.2,630.8,16.9,301.4,370,69.6,37.1,31.1,33.6,211.3,7.6,43,88.1,6.1,48.1,2.2,2602,0.26),
    (1,114,"GAL-NB-165-83","2023-08-08",52.8,3.184,17.9,10.13,0.143,2.09,1.47,0.39,0.1,0.057,88.26,11.62,59.83,3.61,20.28,11.48,0.16,2.36,1.66,0.44,0.11,0.06,29,52,20,187,252,6,94,413,21,34.4,23,106,72,18,27,72,13,22,3,1465,0.15,88.41,88.45,100.07,101.19,37.1,76.7,31.2,275,280.8,7.1,111.5,557.3,26.5,49.1,30.9,132.1,89.5,19.5,31.6,88.9,14.9,26.1,2.9,1889,0.19),
    (1,115,"GAL-NB-165-84","2023-08-08",53.31,4.844,15,10.29,0.095,2.2,1.24,0.31,0.18,0.041,87.51,12.49,60.92,5.54,17.14,11.76,0.11,2.51,1.42,0.36,0.2,0.05,27,50,19,248,200,10,78,517,18,46.9,22,62,89,14,17,56,17,22,3,1518,0.15,87.66,87.71,100.2,101.34,33.9,73.7,29.7,365.3,223.5,10.7,92.2,698.6,22.6,67,30.2,78,111.2,15.3,20,69.4,19.2,25.3,3.2,1989,0.2),
    (1,116,"GAL-NB-165-85","2023-08-08",48.98,3.537,13.34,9.72,0.109,2.49,7.51,0.31,0.14,0.051,86.18,13.66,56.83,4.1,15.48,11.27,0.13,2.89,8.71,0.36,0.16,0.06,28,57,22,230,180,7,97,345,24,29.4,18,43,103,9,19,36,9,19,2,1278,0.13,86.31,86.35,100.01,101.09,36.1,83.8,33.3,338,201.1,7.6,114.6,466.4,30.5,42.1,24.6,53.7,128.6,9.8,22.3,44.6,10.1,22.3,1.8,1671,0.17),
    (1,117,"GAL-NB-165-86","2023-08-08",49.29,1.948,16.2,11.46,0.127,5.13,7.61,1.55,0.35,0.255,93.91,5.98,52.48,2.07,17.25,12.2,0.14,5.46,8.1,1.65,0.37,0.27,54,125,40,274,472,11,181,157,56,13.6,19,26,85,6,102,138,2,112,1,1876,0.19,94.1,94.15,100.13,101.4,68.3,183,61.8,402.4,527.1,12.5,213.5,212.3,70.5,19.4,25.9,32.3,106.4,6.5,119.6,169.8,2.8,131.2,0.8,2366,0.24),
    (1,119,"GAL-NB-165-87","2023-08-08",49.05,1.749,15.34,11,0.139,5.82,9.58,1.87,0.2,0.274,95.02,4.94,51.62,1.84,16.14,11.58,0.15,6.12,10.08,1.97,0.21,0.29,49,114,37,273,290,7,221,140,49,12.4,19,38,87,4,60,88,2,63,0,1556,0.16,95.18,95.22,100.16,101.38,62.8,167.2,57.4,401.1,324.1,8.2,261.8,189.7,61.7,17.7,25.7,47.9,108.5,3.9,70.8,108.2,2.7,73,0.1,1992,0.2),
    (1,120,"GAL-NB-165-88","2023-08-08",49.95,1.756,14.9,11.16,0.165,5.8,10.94,2.2,0.25,0.313,97.44,2.27,51.26,1.8,15.29,11.46,0.17,5.95,11.23,2.26,0.26,0.32,46,106,37,283,225,6,243,142,31,12.6,20,54,99,4,19,36,3,23,1,1391,0.14,97.58,97.62,99.89,101.13,58.1,154.5,57.5,416.9,251.6,6.9,286.8,192.3,39.5,18,26.6,67.3,123.4,3.9,21.9,44.7,3.1,27.4,0.7,1801,0.18),
    (1,55,"GAL-NB-165-89","2023-08-08",47.76,3.557,13.67,13.42,0.225,4.52,10.57,2.35,0.44,0.906,97.41,2.15,49.03,3.65,14.04,13.78,0.23,4.64,10.85,2.41,0.45,0.93,27,187,42,385,541,11,273,275,69,27.3,22,31,140,7,39,85,2,55,0,2218,0.22,97.64,97.7,99.85,101.34,34.1,273.8,64.7,566.1,603.7,12.1,322.3,372.1,87.3,39,29.2,38.5,174.8,7.2,45.5,105,2.3,64.2,0.4,2842,0.28),
    (1,56,"GAL-NB-165-90","2023-08-08",42.46,1.052,8.79,12.49,0.874,3.94,10.46,0.19,0.53,0.172,80.95,19.01,52.45,1.3,10.85,15.43,1.08,4.86,12.92,0.24,0.65,0.21,41,63,22,170,612,31,111,181,40,12.7,15,52,99,6,25,40,3,31,4,1559,0.16,81.11,81.15,100.16,101.54,51.8,92.3,33.5,249.8,683.2,33.9,131.5,243.9,50.4,18.2,20.7,65.6,123.2,6.6,29.2,49.4,3,36.7,4.4,1927,0.19),
    (1,57,"GAL-NB-165-91","2023-08-08",46.94,3.612,14.41,13.57,0.154,3.83,9.05,2.35,0.39,0.868,95.18,4.37,49.32,3.79,15.14,14.26,0.16,4.03,9.51,2.47,0.41,0.91,31,204,42,346,519,13,292,273,59,27.3,24,26,142,6,37,83,2,51,2,2178,0.22,95.4,95.46,99.83,101.34,39.8,298.5,65,509.1,579,13.7,345,369.2,74.7,39.1,31.7,32.2,176.2,6.3,43.6,101.9,2.1,59.7,2.4,2789,0.28),
    (1,46,"GAL-NB-165-92","2023-08-08",46.62,3.998,12.18,14.79,0.228,3.46,9.89,2.36,0.81,1.997,96.33,3.31,48.39,4.15,12.64,15.35,0.24,3.59,10.27,2.45,0.84,2.07,18,29,41,249,970,26,271,530,115,52.8,26,22,218,11,77,173,4,101,0,2934,0.29,96.62,96.7,100.01,101.65,22.9,42.7,62.4,366.5,1082.9,28.8,320,716.1,145.7,75.5,34.5,27.1,271.8,11.8,90.1,213.1,4.5,117.7,0.5,3635,0.36),
    (1,52,"GAL-NB-165-93","2023-08-10",51.82,9.157,10.4,16.64,0.269,1.63,2.9,0.77,0.42,0.381,94.39,5.29,54.9,9.7,11.02,17.63,0.29,1.73,3.07,0.82,0.44,0.4,26,107,31,489,594,20,166,509,48,51.5,16,26,154,10,31,95,4,43,3,2423,0.24,94.63,94.7,99.99,101.84,32.9,156.1,47,718.9,663.5,21.7,196.6,687.6,60.8,73.7,22,32.5,191.4,11.3,36.2,117,4.3,49.6,3.8,3127,0.31),
    (1,53,"GAL-NB-165-94","2023-08-10",49.56,3.284,13.26,13.15,0.219,4.27,9.92,2.09,0.47,0.787,97.02,2.73,51.09,3.39,13.67,13.56,0.23,4.4,10.22,2.16,0.49,0.81,29,178,42,360,616,14,257,280,76,26,22,38,135,6,44,86,3,55,2,2268,0.23,97.24,97.31,100.03,101.49,37.5,259.5,63.7,529.4,687.9,15.6,304.3,377.6,96.2,37.2,29.1,47.3,168.4,6.9,51.1,105.6,3.5,64.3,2.5,2888,0.29),
    (1,54,"GAL-NB-165-95","2023-08-10",50.53,1.989,12.02,15.54,0.194,3.62,4.49,0.88,0.69,0.131,90.08,9.86,56.09,2.21,13.34,17.25,0.22,4.02,4.98,0.98,0.77,0.15,38,102,28,206,550,32,197,233,42,18.9,17,56,113,7,38,81,4,53,2,1816,0.18,90.26,90.31,100.17,101.9,47.8,148.4,43,302.7,613.5,35.4,232.5,314.1,53.6,27.1,22.2,70.2,140.7,8,44.5,99.1,4.7,62.1,2.4,2272,0.23),
    (1,59,"GAL-NB-165-96","2023-08-10",47.02,3.421,14.03,13.39,0.164,4.31,9.57,2.31,0.41,0.728,95.35,4.34,49.32,3.59,14.71,14.04,0.17,4.52,10.04,2.42,0.43,0.76,32,194,42,346,466,14,277,258,62,25.3,22,34,142,8,34,77,2,48,0,2084,0.21,95.56,95.61,99.96,101.44,40.7,283,64,509.3,520.2,15.4,327.9,348.5,79,36.2,30.1,42.9,176.8,8.3,39.5,95.2,2.4,56.3,0.5,2676,0.27),
    (2,183,"GAL-NB-165-2 ","2023-08-03",45.26,1.931,20.28,13.05,0.222,1.83,1.7,0.51,0.1,0.202,85.08,14.52,53.19,2.27,23.83,15.34,0.26,2.15,2,0.6,0.11,0.24,8,20,35,132,239,6,133,341,48,20.7,30,25,198,21,38,90,6,39,3,1434,0.14,85.23,85.27,99.78,101.23,10.7,29.7,54,193.5,267.1,6.4,156.8,460.3,61.2,29.6,40.6,31.5,246.1,22.3,44.7,111,7.2,45.6,3.5,1822,0.18),
    (3,183,"GAL-NB-165-2","2023-08-23",45.54,1.945,20.37,12.84,0.225,1.85,1.7,0.51,0.09,0.206,85.28,14.52,53.4,2.28,23.89,15.06,0.26,2.17,2,0.59,0.11,0.24,10,22,35,132,242,6,132,338,48,19.9,29,27,199,21,41,90,7,40,1,1440,0.14,85.42,85.46,99.98,101.4,13.2,32,54.2,193.6,270.3,6.7,156.7,456.9,60.9,28.5,39.2,33.9,247.3,22.2,48,110.5,7.4,47,1.5,1830,0.18),
    (2,133,"GAL-NB-165-25 ","2023-08-04",80.5,0.265,3.82,2.35,0.032,1.04,1.26,0.08,0.21,0.015,89.56,10.31,89.89,0.3,4.26,2.62,0.04,1.16,1.41,0.08,0.23,0.02,5,12,5,52,213,20,43,55,14,3.3,6,8,29,1,10,11,3,10,2,502,0.05,89.61,89.62,99.92,100.19,6.7,17.4,6.9,76.9,238.4,22.1,51.1,73.8,18.2,4.7,7.6,9.4,35.5,0.9,11.6,13.7,3.4,11.5,2.3,612,0.06),
    (3,133,"GAL-NB-165-25","2023-08-08",80.63,0.26,3.82,2.33,0.032,1.03,1.25,0.09,0.21,0.022,89.67,10.31,89.91,0.29,4.26,2.6,0.04,1.15,1.4,0.1,0.23,0.02,6,12,4,51,214,20,42,54,14,3.1,5,7,28,2,10,11,2,11,1,499,0.05,89.72,89.74,100.04,100.3,7.9,16.9,6.8,74.6,239.3,21.9,50.1,72.8,18.3,4.4,7.1,8.9,35.5,1.7,11.6,13.2,2.7,12.9,1,608,0.06),
    (2,145,"GAL-NB-165-48 ","2023-08-06",54.52,2.591,13.63,11.51,0.194,2.24,6.22,3.15,2.8,1.076,97.93,1.57,55.67,2.65,13.91,11.76,0.2,2.29,6.35,3.21,2.86,1.1,6,0,25,145,3815,50,316,500,51,24,24,10,130,12,50,103,7,50,2,5321,0.53,98.47,98.55,100.13,101.41,7.8,0,38.7,213,4259.6,54.1,373.7,675,64.7,34.3,32,13.1,161.5,13.5,59,127.2,7.9,58.8,2.5,6196,0.62),
    (3,145,"GAL-NB-165-48","2023-08-08",54.25,2.58,13.53,11.56,0.192,2.25,6.21,3.15,2.79,1.068,97.58,1.57,55.6,2.64,13.87,11.84,0.2,2.3,6.36,3.23,2.86,1.09,3,0,26,145,3784,49,316,498,50,23,24,11,133,12,49,101,7,52,2,5285,0.53,98.11,98.2,99.77,101.06,4.3,0,39.2,212.7,4225,53.6,373.3,673.3,63.9,32.9,32.1,13.9,165.3,12.8,57.9,123.9,7.8,60.8,2.1,6155,0.62),
    (2,61,"GAL-NB-165-71 ","2023-08-07",46.7,3.992,12.2,14.82,0.227,3.5,9.85,2.36,0.82,1.996,96.46,3.16,48.41,4.14,12.64,15.37,0.24,3.63,10.21,2.45,0.85,2.07,21,32,40,251,971,27,272,532,116,53.9,26,20,220,12,77,169,5,100,1,2946,0.29,96.75,96.82,99.99,101.63,26.5,46.7,61.9,369.4,1083.8,29.4,321.9,719.1,147.5,77.2,35.3,24.6,273.5,12.6,90.8,207.7,5.4,116.8,1.3,3651,0.37),
    (3,61,"GAL-NB-165-71","2023-08-08",46.78,3.893,12.13,14.14,0.243,3.33,10.67,2.44,1.02,1.947,96.59,3.16,48.43,4.03,12.55,14.64,0.25,3.45,11.05,2.52,1.06,2.02,24,30,41,243,1730,24,284,529,112,53.2,27,24,236,12,73,168,3,98,1,3712,0.37,96.97,97.05,100.21,101.78,29.9,43.9,62.3,357.2,1931.1,26.2,336.1,714.7,142.4,76.1,36.4,30.3,293.9,13.2,86.1,206.1,3.8,114.1,1.3,4505,0.45);