You don't recruit designers, you earn them

James Lindenbaum

Meteor Classification

May 13th, 2013

I have been running some queries to classify the meteor types in the meteor visualisation data. I’m running the smallest groups first so that I can run one final ‘set empty classes to chondrite’ query at the end as they are by far the group with the biggest range of type codes in the table. The third of these queries felt distinctly middle-earthy, with all it ‘-ites’. I imagined this group of meteorite to be somewhat like the dwarves from ‘The Hobbit’.

UPDATE `type_lookup`
SET `Class` = 'Iron (Chemical Classification)'
WHERE `Type` LIKE 'Iron%'
UPDATE `type_lookup`
SET `Class` = 'Carbonaceous Chondrite'
WHERE `Type` LIKE 'C%'
UPDATE `type_lookup`
SET `Class` = 'Achondrite'
WHERE `Type` LIKE 'Eucrite%'
OR `Type` LIKE 'Howardite%'
OR `Type` LIKE 'Diogenite%'
OR `Type` LIKE 'Shergottite%'
OR `Type` LIKE 'Nakhilites%'
OR `Type` LIKE 'Chassigniteite%'
OR `Type` LIKE 'Lunar%'
OR `Type` LIKE 'Aubrite%'
OR `Type` LIKE 'Acapulcoite%'
OR `Type` LIKE 'Lodraniteite%'
OR `Type` LIKE 'Urellite%'
OR `Type` LIKE 'Angrite%'
OR `Type` LIKE 'Brachinite%'
OR `Type` LIKE 'Winonaite%'

Anyway, enough SQL for one night, the last two groups can wait till tomorrow night, I have flapjack about to come out of the oven.

Categories:
Web Design|MySQL