Bad biostats in database

There are a number of records in the Canonn database with clearly bad data (i.e. impossible parameters). This data is visible in the Canonn - Surface Biology Google sheet.

I reckon the best action would be to delete these records from the system.

This first one is a result of there being three known bodies with name "2MASS J03292155+3121104" and at some point in the import the biological sample has been correlated with the wrong system.

I have flown out there and re-scanned both bodies and the problem still exists in the Google sheet.

[{
    "Report Date": 1631038621000,
    "Name": "Bacterium Acies - Magenta",
    "Journal Name": "$Codex_Ent_Bacterial_04_Polonium_Name;",
    "EntryId": 2320403,
    "Cmdr": "TheProRockPL",
    "Region": "Inner Orion Spur",
    "System": "2MASS J03292155+3121104",
    "Id64": 5063630988321,
    "Primary Star": "M (Red dwarf) Star",
    "Local Star": "M (Red dwarf) Star",
    "Body": "2MASS J03292155+3121104 5",
    "BodyType": "Icy body",
    "Atmosphere": "Thick Methane-rich",
    "Pressure": 2704.0494251172,
    "Volcanism": "Minor Carbon Dioxide Geysers",
    "Gravity": 0.7300688284,
    "Temperature": 367.431915,
    "Distance To Arrival": 277.211195
}]

These next entries have the biological recorded against the star, not a body. I don't think flying out there and re-scanning is going to help, it'll just add extra records for these biologicals against the correct body.

[{
    "Report Date": 1622635287000,
    "Name": "Bacterium Aurasus - Sage",
    "Journal Name": "$Codex_Ent_Bacterial_01_L_Name;",
    "EntryId": 2320108,
    "Cmdr": "Rayven N\\u00edunda",
    "Region": "The Formidine Rift",
    "System": "Dryau Aim NM-W d1-0",
    "Id64": 10024387987,
    "Primary Star": "G (White-Yellow) Star",
    "Local Star": "G (White-Yellow) Star",
    "Body": "Dryau Aim NM-W d1-0 A",
    "BodyType": "G (White-Yellow) Star",
    "Atmosphere": null,
    "Pressure": null,
    "Volcanism": null,
    "Gravity": null,
    "Temperature": 5781.0,
    "Distance To Arrival": 0.0
}, {
    "Report Date": 1622635301000,
    "Name": "Tussock Pennatis - Sage",
    "Journal Name": "$Codex_Ent_Tussocks_06_L_Name;",
    "EntryId": 2450605,
    "Cmdr": "Rayven N\\u00edunda",
    "Region": "The Formidine Rift",
    "System": "Dryau Aim NM-W d1-0",
    "Id64": 10024387987,
    "Primary Star": "G (White-Yellow) Star",
    "Local Star": "G (White-Yellow) Star",
    "Body": "Dryau Aim NM-W d1-0 A",
    "BodyType": "G (White-Yellow) Star",
    "Atmosphere": null,
    "Pressure": null,
    "Volcanism": null,
    "Gravity": null,
    "Temperature": 5781.0,
    "Distance To Arrival": 0.0
}, {
    "Report Date": 1621996346000,
    "Name": "Bacterium Alcyoneum - Sage",
    "Journal Name": "$Codex_Ent_Bacterial_06_L_Name;",
    "EntryId": 2320608,
    "Cmdr": "Rayven N\\u00edunda",
    "Region": "Elysian Shore",
    "System": "Hypheerld PI-I b56-4",
    "Id64": 9431613251553,
    "Primary Star": "M (Red dwarf) Star",
    "Local Star": "M (Red dwarf) Star",
    "Body": "Hypheerld PI-I b56-4 A",
    "BodyType": "M (Red dwarf) Star",
    "Atmosphere": null,
    "Pressure": null,
    "Volcanism": null,
    "Gravity": null,
    "Temperature": 2830.0,
    "Distance To Arrival": 0.0
}, {
    "Report Date": 1621993912000,
    "Name": "Fungoida Setisis - Peach",
    "Journal Name": "$Codex_Ent_Fungoids_01_Antimony_Name;",
    "EntryId": 2390105,
    "Cmdr": "Rayven N\\u00edunda",
    "Region": "Elysian Shore",
    "System": "Hypheerld PI-I b56-4",
    "Id64": 9431613251553,
    "Primary Star": "M (Red dwarf) Star",
    "Local Star": "M (Red dwarf) Star",
    "Body": "Hypheerld PI-I b56-4 A",
    "BodyType": "M (Red dwarf) Star",
    "Atmosphere": null,
    "Pressure": null,
    "Volcanism": null,
    "Gravity": null,
    "Temperature": 2830.0,
    "Distance To Arrival": 0.0
}, {
    "Report Date": 1621993456000,
    "Name": "Frutexa Metallicum - Teal",
    "Journal Name": "$Codex_Ent_Shrubs_03_L_Name;",
    "EntryId": 2440306,
    "Cmdr": "Rayven N\\u00edunda",
    "Region": "Elysian Shore",
    "System": "Hypheerld PI-I b56-4",
    "Id64": 9431613251553,
    "Primary Star": "M (Red dwarf) Star",
    "Local Star": "M (Red dwarf) Star",
    "Body": "Hypheerld PI-I b56-4 A",
    "BodyType": "M (Red dwarf) Star",
    "Atmosphere": null,
    "Pressure": null,
    "Volcanism": null,
    "Gravity": null,
    "Temperature": 2830.0,
    "Distance To Arrival": 0.0
}, {
    "Report Date": 1621995399000,
    "Name": "Tussock Divisa - Sage",
    "Journal Name": "$Codex_Ent_Tussocks_10_L_Name;",
    "EntryId": 2451005,
    "Cmdr": "Rayven N\\u00edunda",
    "Region": "Elysian Shore",
    "System": "Hypheerld PI-I b56-4",
    "Id64": 9431613251553,
    "Primary Star": "M (Red dwarf) Star",
    "Local Star": "M (Red dwarf) Star",
    "Body": "Hypheerld PI-I b56-4 A",
    "BodyType": "M (Red dwarf) Star",
    "Atmosphere": null,
    "Pressure": null,
    "Volcanism": null,
    "Gravity": null,
    "Temperature": 2830.0,
    "Distance To Arrival": 0.0
}, {
    "Report Date": 1622153401000,
    "Name": "Concha Aureolas - Grey",
    "Journal Name": "$Codex_Ent_Conchas_02_F_Name;",
    "EntryId": 2350203,
    "Cmdr": "Rayven N\\u00edunda",
    "Region": "The Formidine Rift",
    "System": "Schee Hypue NF-L d9-2",
    "Id64": 78173423187,
    "Primary Star": "F (White) Star",
    "Local Star": "F (White) Star",
    "Body": "Schee Hypue NF-L d9-2 A",
    "BodyType": "F (White) Star",
    "Atmosphere": null,
    "Pressure": null,
    "Volcanism": null,
    "Gravity": null,
    "Temperature": 6294.0,
    "Distance To Arrival": 0.0
}, {
    "Report Date": 1622154110000,
    "Name": "Osseus Spiralis - Turquoise",
    "Journal Name": "$Codex_Ent_Osseus_03_F_Name;",
    "EntryId": 2400303,
    "Cmdr": "Rayven N\\u00edunda",
    "Region": "The Formidine Rift",
    "System": "Schee Hypue NF-L d9-2",
    "Id64": 78173423187,
    "Primary Star": "F (White) Star",
    "Local Star": "F (White) Star",
    "Body": "Schee Hypue NF-L d9-2 A",
    "BodyType": "F (White) Star",
    "Atmosphere": null,
    "Pressure": null,
    "Volcanism": null,
    "Gravity": null,
    "Temperature": 6294.0,
    "Distance To Arrival": 0.0
}]

canonn-science / Canonn-GCloud

Bad biostats in database #2