+У:скорее всего это вид материала горной породы/образца. так про брекчию говорится что она может быть сложена из одной или нескольких горных пород (см.).
"" is an eruption type with DB number 7.
"?" is an eruption type with DB number 8.
"49.8" is an eruption type with DB number 84.
"AB" is an eruption type with DB number 18.
"AGGLOMERATE" is an eruption type with DB number 46.
"AJ" is an eruption type with DB number 10.
"APHANITIC" is an eruption type with DB number 27.
"ASH" is an eruption type with DB number 14.
"BEACH COBBLE" is an eruption type with DB number 45.
"BLOCK" is an eruption type with DB number 52.
"BLOCK IN BRECCIA" is an eruption type with DB number 53.
"BLOCK IN TUFF" is an eruption type with DB number 51.
"BLOCK LAVA" is an eruption type with DB number 13.
"BOMB" is an eruption type with DB number 33.
"BOULDER" is an eruption type with DB number 30.
"BRECCIA" is an eruption type with DB number 40.
"DIKE" is an eruption type with DB number 31.
"DOME" is an eruption type with DB number 23.
"DYKE" is an eruption type with DB number 47.
"EJECTA" is an eruption type with DB number 37.
"EXTRUSIVE" is an eruption type with DB number 15.
"FLOOR OF KEANAKAKOI CRATER" is an eruption type with DB number 58.
"FLOW" is an eruption type with DB number 2.
"FLOW BRECCIA" is an eruption type with DB number 41.
"FLOW BRECCIA" is an eruption type with DB number 39.
"GL" is an eruption type with DB number 82.
"HEIHEIAHULU FLOW" is an eruption type with DB number 68.
"HILO DRILL HOLE, HSDP" is an eruption type with DB number 78.
"HONUAULA CRATER" is an eruption type with DB number 74.
"IGNIMBRITE" is an eruption type with DB number 22.
"IKI" is an eruption type with DB number 77.
"IKI CRATER" is an eruption type with DB number 65.
"IKI CRATER, SOUTH WALL" is an eruption type with DB number 66.
"IKI ERUPTION" is an eruption type with DB number 64.
"IKI LAVA LAKE" is an eruption type with DB number 57.
"INTRUSION" is an eruption type with DB number 49.
"INTRUSIVE" is an eruption type with DB number 1.
"JONIKA FLOW" is an eruption type with DB number 70.
"KALALEHA FLOW" is an eruption type with DB number 79.
"KALIU CRATER" is an eruption type with DB number 73.
"KAPOHO ERUPTION" is an eruption type with DB number 59.
"KAPOHO ERUPTION PUU KEA CONE" is an eruption type with DB number 60.
"KAUELAU FLOW 3-14-55" is an eruption type with DB number 63.
"KAUMUKI FLOW" is an eruption type with DB number 69.
"LACCOLITH" is an eruption type with DB number 16.
"LAVA" is an eruption type with DB number 34.
"LAVA FLOW" is an eruption type with DB number 50.
"MAKAOPUHI CRATER, EAST PIT" is an eruption type with DB number 62.
"MAKAOPUHI LAVA LAKE" is an eruption type with DB number 56.
"MASSIVE" is an eruption type with DB number 26.
"MAUNA ULU" is an eruption type with DB number 55.
"MEGACRYST-RICH" is an eruption type with DB number 29.
"NEAR CAPE KUMUKAHI" is an eruption type with DB number 75.
"NECR" is an eruption type with DB number 4.
"NORTHEAST OF NAPAU CRATER" is an eruption type with DB number 67.
"NORTH WALL OF MAKAOPUHI CRATER" is an eruption type with DB number 71.
"PAHOA-KALAPANA ROAD" is an eruption type with DB number 80.
"PILLOW" is an eruption type with DB number 32.
"PILLOW, MN-COATED" is an eruption type with DB number 35.
"PROTRUSION" is an eruption type with DB number 48.
"PUMICE" is an eruption type with DB number 21.
"PUULENA CRATER" is an eruption type with DB number 72.
"PUU OO(-KUPAIANAHA)" is an eruption type with DB number 76.
"PYROCLASTIC" is an eruption type with DB number 25.
"QUAT" is an eruption type with DB number 5.
"SILL" is an eruption type with DB number 11.
"SOUTH WALL OF MAKAOPUHI CRATER" is an eruption type with DB number 61.
"STOCK" is an eruption type with DB number 12.
"STREAM COBBLE" is an eruption type with DB number 44.
"SUMMIT" is an eruption type with DB number 54.
"TUFF" is an eruption type with DB number 24.
"TUFF BRECCIA" is an eruption type with DB number 38.
"TUNNEL" is an eruption type with DB number 36.
"ULTRABASIC" is an eruption type with DB number 42.
"VARIOLITIC" is an eruption type with DB number 28.
"VEIN" is an eruption type with DB number 6.
"VENT T, BLOWHOLE CONE" is an eruption type with DB number 81.
"WR" is an eruption type with DB number 83.
"XENOLITH" is an eruption type with DB number 17.
"XENOLITHIC" is an eruption type with DB number 19.
скорее всего термин: eruption type
select name, id from erupttypes order by name;
select '"', name, '"', 'is an eruption type with DB number ' as NLS1, id, '.' as dot from erupttypes order by name;
select m.id, an.name, b.title, b.journal from measurements as m,
psql -d geo -f erupttypes.sql -t -A -F "">erupttypes.txt
полнота связи: select count(*) from measurements where erupttype is null; -- 26.08.08 = 0.
НО в таблице существует значение ""!!!
24 запис(ь/и/ей)