наполнение, анализ...
"" is a rock type with DB number 64.
"2DACITE" is a rock type with DB number 90.
"ABSAROKITE" is a rock type with DB number 191.
"ABSAROKITE SHOSHONITE" is a rock type with DB number 255.
"ADAKITE" is a rock type with DB number 221.
"ALK-BASALT" is a rock type with DB number 47.
"ALK. BASALT" is a rock type with DB number 48.
"ALK-OL-BASALT" is a rock type with DB number 33.
"ALK-OL.-BASALT" is a rock type with DB number 46.
"ALK.-OL.BASALT" is a rock type with DB number 44.
"ALK.-OL.-BASALT" is a rock type with DB number 45.
"ALK-OL-BASALTE" is a rock type with DB number 37.
"AMPHIBOLITE" is a rock type with DB number 10.
"AMPHIBPLITE" is a rock type with DB number 65.
"ANALCITITE" is a rock type with DB number 123.
"ANALCITITE, OLIVINE" is a rock type with DB number 359.
"ANAMESITE" is a rock type with DB number 370.
"ANDESIBASALT" is a rock type with DB number 67.
"ANDESI-BASALT" is a rock type with DB number 70.
"ANDESI-BASALTIC" is a rock type with DB number 190.
"ANDESIDACITE" is a rock type with DB number 75.
"ANDESITE" is a rock type with DB number 17.
"ANDESITE, ALKALINE" is a rock type with DB number 312.
"ANDESITE, AUGITE" is a rock type with DB number 377.
"ANDESITE,BASALTIC" is a rock type with DB number 189.
"ANDESITE, BASALTIC" is a rock type with DB number 141.
"ANDESITE, BASALTIC, CALC-ALKALINE" is a rock type with DB number 256.
"ANDESITE, CALC-ALKALINE" is a rock type with DB number 236.
"ANDESITE/DACITE" is a rock type with DB number 380.
"ANDESITE, HIGH-AL" is a rock type with DB number 495.
"ANDESITE, HORNBLENDE" is a rock type with DB number 486.
"ANDESITE, HYPERSTHENE" is a rock type with DB number 498.
"ANDESITE, HYPERSTHENE-AUGITE" is a rock type with DB number 144.
"ANDESITE, LABRADORITE-AUGITE" is a rock type with DB number 490.
"ANDESITE, LOW-AL" is a rock type with DB number 494.
"ANDESITE, LOW-TI" is a rock type with DB number 177.
"ANDESITE, MAGNESIAN" is a rock type with DB number 499.
"ANDESITE, OLIVINE" is a rock type with DB number 186.
"ANDESITE, THOLEIITIC" is a rock type with DB number 213.
"ANKARAMITE" is a rock type with DB number 116.
"ANKARAMITE, BASANITIC" is a rock type with DB number 293.
"ANKARAMITE, OLIVINE-AUGITE" is a rock type with DB number 460.
"ANKARATRITE" is a rock type with DB number 342.
"ANKARATRITE, ANALCIME" is a rock type with DB number 366.
"ANKARATRITE, KALSILIT, PHLOGOPITE" is a rock type with DB number 187.
"ANORTOSITE" is a rock type with DB number 91.
"ASH" is a rock type with DB number 92.
"B" is a rock type with DB number 193.
"B, ANDESITE," is a rock type with DB number 192.
"BASALT" is a rock type with DB number 13.
"BASALT, ALKALINE" is a rock type with DB number 131.
"BASALT, ALKALINE, FLOW" is a rock type with DB number 426.
"BASALT, ALKALINE, OLIVINE" is a rock type with DB number 139.
"BASALT, ALKALINE TO TRANSITIONAL" is a rock type with DB number 142.
"BASALT, ALKALINE, TRANSITIONAL" is a rock type with DB number 348.
"BASALT-ALKALI OLIVINE" is a rock type with DB number 42.
"BASALT ALK.-OL." is a rock type with DB number 25.
"BASALT-ALK.-OL." is a rock type with DB number 28.
"BASALT-ALK.OLIVINE" is a rock type with DB number 30.
"BASALT, AMPHIBOLE" is a rock type with DB number 321.
"BASALT, AMPHIBOLE-PLAGIOCLASE" is a rock type with DB number 469.
"BASALT, AMPHIBOLE-PYROXENE" is a rock type with DB number 456.
"BASALT, AMPHIBOLE-PYROXENE, SOME OLIVINE" is a rock type with DB number 457.
"BASALT, AMPHIBOLITIC" is a rock type with DB number 334.
"BASALT, ANDESINE" is a rock type with DB number 489.
"BASALT, ANDESITIC" is a rock type with DB number 145.
"BASALT, ANKARAMITIC" is a rock type with DB number 352.
"BASALT, APHYRIC" is a rock type with DB number 399.
"BASALT, AUGITE" is a rock type with DB number 420.
"BASALT, AUGITE-AMPHIBOLE" is a rock type with DB number 465.
"BASALT, AUGITE-OLIVINE" is a rock type with DB number 415.
"BASALT, AUGITE-PLAGIOCLASE" is a rock type with DB number 419.
"BASALT BASALT, THOLEIITIC" is a rock type with DB number 269.
"BASALT, BASANITIC" is a rock type with DB number 295.
"BASALT, CALC-ALKALINE" is a rock type with DB number 174.
"BASALT, CALC-ALKALINE, HIGH-NB" is a rock type with DB number 175.
"BASALT, CALC-ALKALINE, TRANSITIONAL" is a rock type with DB number 497.
"BASALT, CLINOPYROXENE" is a rock type with DB number 454.
"BASALT, CLINOPYROXENE-OLIVINE" is a rock type with DB number 461.
"BASALT, DOLERITIC" is a rock type with DB number 421.
"BASALTE" is a rock type with DB number 34.
"BASALT, FELDSPAR" is a rock type with DB number 502.
"BASALT, FELDSPARPHYRIC" is a rock type with DB number 147.
"BASALT, FE-TI" is a rock type with DB number 500.
"BASALT, HIGH-AL" is a rock type with DB number 485.
"BASALT, HIGH FE-TI" is a rock type with DB number 391.
"BASALT, HIGH-MG" is a rock type with DB number 402.
"BASALT, HIGH-NB" is a rock type with DB number 176.
"BASALT, HIGH-TI" is a rock type with DB number 179.
"BASALT, HORNBLENDE" is a rock type with DB number 501.
"BASALT, HYPERSTHENE" is a rock type with DB number 276.
"BASALTIC ANDESITES" is a rock type with DB number 182.
"BASALTIC, LAVA" is a rock type with DB number 503.
"BASALT, INTERMEDIATE TO RHYOLITE" is a rock type with DB number 392.
"BASALT KOMATIITE" is a rock type with DB number 266.
"BASALT, KOMATIITIC" is a rock type with DB number 194.
"BASALT, KOMATIITIC KOMATIITE" is a rock type with DB number 270.
"BASALT, KOMATIITIC THOLEIITE" is a rock type with DB number 272.
"BASALT, LABRADORITE" is a rock type with DB number 146.
"BASALT, LABRADORITIC" is a rock type with DB number 319.
"BASALT, LOW-AL" is a rock type with DB number 488.
"BASALT, LOW-TI" is a rock type with DB number 178.
"BASALT, MAGNESIAN" is a rock type with DB number 199.
"BASALT, MUGEARITIC" is a rock type with DB number 479.
"BASALT, NEPHELINE" is a rock type with DB number 290.
"BASALT, NEPHELINE (TANNBUSCHITE)" is a rock type with DB number 363.
"BASALT, NEPHELINITIC" is a rock type with DB number 149.
"BASALT-OLIVINE" is a rock type with DB number 40.
"BASALT, OLIVINE" is a rock type with DB number 129.
"BASALT, OLIVINE-AMPHIBOLE" is a rock type with DB number 463.
"BASALT, OLIVINE-ANKARAMITIC" is a rock type with DB number 294.
"BASALT, OLIVINE-AUGITE" is a rock type with DB number 412.
"BASALT, OLIVINE, AUGITE" is a rock type with DB number 351.
"BASALT, OLIVINE-AUGITE-PLAGIOCLASE" is a rock type with DB number 417.
"BASALT, OLIVINE-CLINOPYROXENE" is a rock type with DB number 455.
"BASALT, OLIVINE, DOLERITIC" is a rock type with DB number 416.
"BASALT, OLIVINE-HORNBLENDE" is a rock type with DB number 487.
"BASALT, OLIVINE-HYPERSTHENE" is a rock type with DB number 491.
"BASALT, OLIVINE KOMATIITE" is a rock type with DB number 267.
"BASALT, OLIVINE-PLAGIOCLASE" is a rock type with DB number 450.
"BASALT, OLIVINE (POOR)" is a rock type with DB number 344.
"BASALT, OLIVINE-POOR" is a rock type with DB number 325.
"BASALT, OLIVINE-PYROXENE" is a rock type with DB number 353.
"BASALT, OLIVINE,SOME AMPHIBOLE" is a rock type with DB number 458.
"BASALT, PICRITIC" is a rock type with DB number 148.
"BASALT, PLAGIOCLASE" is a rock type with DB number 153.
"BASALT, PLAGIOCLASE-AMPHIBOLE" is a rock type with DB number 470.
"BASALT, PLAGIOCLASE-AUGITE" is a rock type with DB number 414.
"BASALT, PLAGIOCLASE-AUGITE, ANKARAMITIC" is a rock type with DB number 449.
"BASALT, PLAGIOCLASE-AUGITE-OLIVINE" is a rock type with DB number 418.
"BASALT, PLAGIOCLASE-CLINOPYROXENE" is a rock type with DB number 459.
"BASALT, PLAGIOCLASE-OLIVINE" is a rock type with DB number 466.
"BASALT, PYROXENE" is a rock type with DB number 231.
"BASALT, PYROXENE-AMPHIBOLE" is a rock type with DB number 446.
"BASALT, PYROXENE-OLIVINE" is a rock type with DB number 343.
"BASALT, PYROXENE-OLIVINE-AMPHIBOLE" is a rock type with DB number 451.
"BASALT, PYROXENE-OLIVINE-PLAGIOCLASE" is a rock type with DB number 452.
"BASALT, PYROXENE-PLAGIOCLASE" is a rock type with DB number 471.
"BASALT, SUBALKALINE" is a rock type with DB number 284.
"BASALT, TEPHRITIC" is a rock type with DB number 428.
"BASALT THOLEIITE" is a rock type with DB number 271.
"BASALT THOLEIITIC" is a rock type with DB number 39.
"BASALT-THOLEIITIC" is a rock type with DB number 43.
"BASALT, THOLEIITIC" is a rock type with DB number 143.
"BASALT, THOLEIITIC, ALKALI-RICH" is a rock type with DB number 398.
"BASALT, THOLEIITIC BASALT" is a rock type with DB number 274.
"BASALT, THOLEIITIC, OLIVINE" is a rock type with DB number 159.
"BASALT, THOLEIITIC, TRANSITIONAL" is a rock type with DB number 507.
"BASALT, TRACHYDOLERITIC" is a rock type with DB number 354.
"BASALT, TRACHYTIC" is a rock type with DB number 180.
"BASALT, TRANSITIONAL" is a rock type with DB number 135.
"BASALT, TRANSITIONAL, PICRITE" is a rock type with DB number 315.
"BASALT, TRANSITIONAL TO OCEANITE" is a rock type with DB number 320.
"BASALT, XENOLITH" is a rock type with DB number 496.
"BASALT/XENOLITH MIXTURE" is a rock type with DB number 379.
"BASANITE" is a rock type with DB number 24.
"BASANITE, ANALCIME" is a rock type with DB number 337.
"BASANITE, ANKARAMITIC" is a rock type with DB number 332.
"BASANITE, CLINOPYROXENE" is a rock type with DB number 423.
"BASANITE, GABBROID" is a rock type with DB number 472.
"BASANITE, LIMBURGITIC" is a rock type with DB number 309.
"BASANITE, NEPHELINE" is a rock type with DB number 286.
"BASANITE, NOSEAN" is a rock type with DB number 437.
"BASANITE, OLIVINE" is a rock type with DB number 280.
"BASANITE, OLIVINE-CLINOPYROXENE" is a rock type with DB number 281.
"BASANITE/PHONOLITE" is a rock type with DB number 435.
"BASANITE, PLAGIOCLASE" is a rock type with DB number 132.
"BASANITE, PYROXENE-OLIVINE" is a rock type with DB number 473.
"BASANITOID" is a rock type with DB number 41.
"BASANITOID, LIMBURGITIC" is a rock type with DB number 333.
"BENMOREITE" is a rock type with DB number 20.
"BENMOREITE, NEPHELINE" is a rock type with DB number 278.
"BENMORITE" is a rock type with DB number 50.
"BERENGITE" is a rock type with DB number 505.
"BLIKALONSDALUR" is a rock type with DB number 385.
"BONINITE" is a rock type with DB number 204.
"BRANDUR" is a rock type with DB number 387.
"BREIDDALUR" is a rock type with DB number 383.
"BURFELLSHRAUN" is a rock type with DB number 386.
"CALC-ALKALINE ROCK" is a rock type with DB number 258.
"CARBONATE ROCK, SILICEOUS" is a rock type with DB number 260.
"CLASS" is a rock type with DB number 483.
"CLINOPEROXENITE" is a rock type with DB number 56.
"CLINOPYROXENITE" is a rock type with DB number 54.
"CLINOPYROXENITE, AMPHIBOLITE" is a rock type with DB number 201.
"COMENDITE" is a rock type with DB number 170.
"COMENDITE, OBSIDIAN" is a rock type with DB number 330.
"COMENDITE/TRACHYTE, COMENDITIC" is a rock type with DB number 404.
"DACITE" is a rock type with DB number 71.
"DACITE, ADAKITIC" is a rock type with DB number 211.
"DACITE-ANDESITE" is a rock type with DB number 93.
"DACITE, ANDESITIC" is a rock type with DB number 397.
"DACITE, CALC-ALKALINE" is a rock type with DB number 238.
"DACITE, CUMMINGTONITE" is a rock type with DB number 396.
"DACITE, GLASSY" is a rock type with DB number 184.
"DACITE, HORNBLENDE" is a rock type with DB number 183.
"DACITE, LABRADORITE" is a rock type with DB number 493.
"DACITE, OBSIDIAN" is a rock type with DB number 381.
"DACITE RHYODACITE" is a rock type with DB number 207.
"DACITE-RHYOLITE" is a rock type with DB number 382.
"DACITE, THOLEIITIC" is a rock type with DB number 232.
"DACITE, THOLEIITIC TO CALC-ALKALINE" is a rock type with DB number 210.
"DACITE, XENOLITH" is a rock type with DB number 390.
"DIABASE" is a rock type with DB number 59.
"DIABASE, QUARTZ" is a rock type with DB number 492.
"DIABASE-SPILITIC" is a rock type with DB number 95.
"DIABASETUFF" is a rock type with DB number 102.
"DIABAZE" is a rock type with DB number 97.
"DIORITE" is a rock type with DB number 11.
"DIORITE-QUARTZ" is a rock type with DB number 104.
"DIORITE, QUARTZ" is a rock type with DB number 254.
"DOLERITE" is a rock type with DB number 15.
"DOLERITE, OLIVINE" is a rock type with DB number 314.
"DOLERITIC-BASALT" is a rock type with DB number 36.
"DUNITE" is a rock type with DB number 8.
"EHAWAIITE" is a rock type with DB number 35.
"ELDGJA" is a rock type with DB number 384.
"ELLIDAEY" is a rock type with DB number 388.
"ESSEXITE" is a rock type with DB number 32.
"ETINDITE" is a rock type with DB number 125.
"EUTAXITE" is a rock type with DB number 476.
"FELDSPAR, SEPARATED" is a rock type with DB number 443.
"FELSIC ROCK" is a rock type with DB number 225.
"FELSITE" is a rock type with DB number 89.
"FERROBASALT" is a rock type with DB number 128.
"FORTUNITE" is a rock type with DB number 87.
"GABBRO" is a rock type with DB number 4.
"GABBRO, AMPHIBOLE" is a rock type with DB number 200.
"GABBRODIORITE" is a rock type with DB number 9.
"GABBRO, META" is a rock type with DB number 251.
"GABBRONORITE" is a rock type with DB number 57.
"GABBRO-PERIDOTITE" is a rock type with DB number 107.
"GABBRO, PYROXENITIC" is a rock type with DB number 252.
"GABBRO-QUARTZ" is a rock type with DB number 108.
"GABBRO, QUARTZ" is a rock type with DB number 239.
"GABBRO, SYENO" is a rock type with DB number 224.
"GAUTEITE" is a rock type with DB number 362.
"GLASS" is a rock type with DB number 51.
"GLENMUIRITE" is a rock type with DB number 338.
"GRANITE" is a rock type with DB number 62.
"GRANITE, GARNET-MUSCOVITE" is a rock type with DB number 218.
"GRANITE, TWO-MICA" is a rock type with DB number 226.
"GRANITOID" is a rock type with DB number 215.
"GRANOALKALI" is a rock type with DB number 69.
"GRANODIORITE" is a rock type with DB number 60.
"GRANODIORITE, BIOTITE" is a rock type with DB number 247.
"GRANODIORITE, BIOTITE-SERICITE" is a rock type with DB number 240.
"GRANODIORITE, MUSCOVITE" is a rock type with DB number 249.
"GRAZINITE" is a rock type with DB number 365.
"GREENSTONE, BASALTIC" is a rock type with DB number 197.
"GREENSTONE, THOLEIITIC" is a rock type with DB number 196.
"HARZBURGITE" is a rock type with DB number 106.
"HAWAIITE" is a rock type with DB number 27.
"HAWAIITE, BASALTIC" is a rock type with DB number 289.
"HAWAIITE-DOLERITE" is a rock type with DB number 84.
"HAWAIITE, HYPERSTHENE" is a rock type with DB number 277.
"HAWAIITE, MAFIC" is a rock type with DB number 157.
"HAWAIITE/MUGEARITE" is a rock type with DB number 152.
"HAWAIITE, NEPHELINE" is a rock type with DB number 275.
"HAWAIITE, TRANSITIONAL TO MUGEARITE" is a rock type with DB number 349.
"HEIMAEY" is a rock type with DB number 389.
"HOLE 430A" is a rock type with DB number 136.
"HOLE 432A" is a rock type with DB number 137.
"HORNBLENDITE" is a rock type with DB number 53.
"HYALOCLACTITE" is a rock type with DB number 484.
"HYALOCLASTITE" is a rock type with DB number 482.
"HYALOTRACHYTE" is a rock type with DB number 14.
"ICELANDITE" is a rock type with DB number 127.
"ICELANDITE, TRACHYTIC" is a rock type with DB number 329.
"IGNIMBRITE" is a rock type with DB number 81.
"IGNIMBRITE, BENMOREITIC" is a rock type with DB number 316.
"IRON FORMATION" is a rock type with DB number 261.
"KAULAITE" is a rock type with DB number 52.
"KERATOPHYRE" is a rock type with DB number 99.
"KERATOPHYRE-QUARTZ" is a rock type with DB number 100.
"KOMATIITE" is a rock type with DB number 7.
"KOMATIITE BASALT" is a rock type with DB number 268.
"KOMATIITE, BASALTIC" is a rock type with DB number 198.
"KOMATIITE, GABBROIC" is a rock type with DB number 214.
"KOMATIITE NOT GIVEN" is a rock type with DB number 265.
"KOMATIITE, PERIDOTITIC" is a rock type with DB number 195.
"KOMATIITE, PYROXENITIC" is a rock type with DB number 209.
"KOMATIITE THOLEIITE" is a rock type with DB number 273.
"LAVA" is a rock type with DB number 78.
"LEUCITITE" is a rock type with DB number 85.
"LEUCOGRANITE, BIOTITE" is a rock type with DB number 227.
"LEUCOGRANITE, MUSCOVITE" is a rock type with DB number 228.
"LHERZOLITE" is a rock type with DB number 3.
"LIMBURGITE" is a rock type with DB number 38.
"LINOSAITE" is a rock type with DB number 161.
"LIPARITE" is a rock type with DB number 94.
"LUSCLADITE" is a rock type with DB number 126.
"MAFIC ROCK" is a rock type with DB number 253.
"MAFIC TO ACIDIC ROCK" is a rock type with DB number 259.
"MAFIC TO INTERMEDIATE ROCK" is a rock type with DB number 257.
"MAFRAITE" is a rock type with DB number 373.
"MELANEPHELINITE, OLIVINE" is a rock type with DB number 288.
"MELANOBASALT" is a rock type with DB number 162.
"MELILITITE" is a rock type with DB number 154.
"MELILITITE, NEPHELINE" is a rock type with DB number 155.
"MELILITITE, OLIVINE" is a rock type with DB number 427.
"METABASALT" is a rock type with DB number 322.
"METADOLERITE" is a rock type with DB number 411.
"METATRACHYTE" is a rock type with DB number 453.
"METAVOLCANIC ROCK" is a rock type with DB number 424.
"MICRO-DIORITE" is a rock type with DB number 103.
"MONCHIQUITE" is a rock type with DB number 364.
"MONZODIORITE" is a rock type with DB number 68.
"MONZODIORITE, BIOTITE-HORNBLENDE-PLAGIOCLASE" is a rock type with DB number 241.
"MONZODIORITE, HORNBLENDE-PLAGIOCLASE-QUARTZ" is a rock type with DB number 242.
"MONZODIORITE, HORNBLENDE-QUARTZ" is a rock type with DB number 244.
"MONZOGABBRO" is a rock type with DB number 109.
"MONZOGRANITE, BIOTITE" is a rock type with DB number 248.
"MONZOGRANITE, BIOTITE-MUSCOVITE" is a rock type with DB number 206.
"MONZOGRANITE, MUSCOVITE" is a rock type with DB number 250.
"MONZOGRANITE, MUSCOVITE-GARNET" is a rock type with DB number 205.
"MONZONITE" is a rock type with DB number 223.
"MUGEARITE" is a rock type with DB number 22.
"MUGEARITE, NEPHELINE" is a rock type with DB number 158.
"MUGEARITE, TRANSITIONAL TO BENMOREITE" is a rock type with DB number 356.
"MURITE" is a rock type with DB number 124.
"NEPHELINITE" is a rock type with DB number 115.
"NEPHELINITE, HAUYNE" is a rock type with DB number 442.
"NEPHELINITE, HAUYNE-MELILITE-OLIVINE" is a rock type with DB number 433.
"NEPHELINITE, MAFIC" is a rock type with DB number 339.
"NEPHELINITE, MELILITE" is a rock type with DB number 156.
"NEPHELINITE, OLIVINE" is a rock type with DB number 122.
"NEPHELINITE, PHONOLITIC" is a rock type with DB number 341.
"NOPIT" is a rock type with DB number 66.
"NORITE" is a rock type with DB number 58.
"NOT GIVEN" is a rock type with DB number 173.
"NOT GIVEN KOMATIITE, BASALTIC" is a rock type with DB number 263.
"OBSIDIAN" is a rock type with DB number 130.
"OBSIDIAN, COMENDITIC" is a rock type with DB number 323.
"OBSIDIAN, PANTELLERITIC" is a rock type with DB number 403.
"OBSIDIAN, PHONOLITIC" is a rock type with DB number 478.
"OBSIDIAN, RHYOLITIC" is a rock type with DB number 395.
"OBSIDIAN, TRACHYTIC" is a rock type with DB number 371.
"OCEANITE" is a rock type with DB number 151.
"OL.BASALT" is a rock type with DB number 29.
"OL. BASALT" is a rock type with DB number 23.
"OL.-BASALT" is a rock type with DB number 26.
"OL. BASALTE" is a rock type with DB number 31.
"OLIVINE" is a rock type with DB number 18.
"ONZODIORITE" is a rock type with DB number 110.
"ORDANCHITE" is a rock type with DB number 425.
"PALAGONITE" is a rock type with DB number 163.
"PANTELLERITE" is a rock type with DB number 171.
"PANTELLERITE, IGNIMBRITIC" is a rock type with DB number 431.
"PANTELLERITE/TRACHYTE" is a rock type with DB number 410.
"PANTELLERITE/TRACHYTE, COMENDITIC" is a rock type with DB number 405.
"PANTELLERITE, TRACHYTIC" is a rock type with DB number 409.
"PEGMATITE" is a rock type with DB number 229.
"PERIDOTIT" is a rock type with DB number 481.
"PERIDOTITE" is a rock type with DB number 1.
"PHONOLITE" is a rock type with DB number 117.
"PHONOLITE, AGPAITIC" is a rock type with DB number 306.
"PHONOLITE, HAUYNE" is a rock type with DB number 432.
"PHONOLITE, IGNIMBRITE" is a rock type with DB number 480.
"PHONOLITE, MAFIC" is a rock type with DB number 447.
"PHONOLITE, NEPHELINE" is a rock type with DB number 134.
"PHONOLITE, NEPHELINE-HAUYNE" is a rock type with DB number 436.
"PHONOLITE, NOSEAN" is a rock type with DB number 360.
"PHONOLITE, PERALKALINE" is a rock type with DB number 279.
"PHONOLITE, PLAGIOCLASE" is a rock type with DB number 475.
"PHONOLITE, SODALITE" is a rock type with DB number 302.
"PHONOLITE, TEPHRITIC" is a rock type with DB number 336.
"PHONOLITE, TRACHYTIC" is a rock type with DB number 355.
"PHONOLITIC" is a rock type with DB number 120.
"PHONOTEPHRITE" is a rock type with DB number 282.
"PICRITE" is a rock type with DB number 121.
"PICRITE, FERRO" is a rock type with DB number 203.
"PICRITE, FERRO NOT GIVEN" is a rock type with DB number 264.
"PICROBASALT" is a rock type with DB number 164.
"PLAGIOGRANITE" is a rock type with DB number 63.
"PORPHYRY" is a rock type with DB number 98.
"PORPHYRY-QUARTZ" is a rock type with DB number 101.
"PYROXENITE" is a rock type with DB number 2.
"RHYODACITE" is a rock type with DB number 76.
"RHYOLITE" is a rock type with DB number 73.
"RHYOLITE, ALKALI, IGNIMBRITIC" is a rock type with DB number 430.
"RHYOLITE, ALKALINE" is a rock type with DB number 350.
"RHYOLITE, ALKALINE, OBSIDIAN" is a rock type with DB number 401.
"RHYOLITE/BASALT" is a rock type with DB number 374.
"RHYOLITE, CALC-ALKALINE" is a rock type with DB number 233.
"RHYOLITE, OBSIDIAN" is a rock type with DB number 376.
"RHYOLITE (OLD)" is a rock type with DB number 393.
"RHYOLITE, SODA" is a rock type with DB number 440.
"RHYOLITE, THOLEIITIC" is a rock type with DB number 237.
"RHYOLITE, TRACHYTIC" is a rock type with DB number 438.
"RHYOLITE, TRANSITIONAL" is a rock type with DB number 212.
"RHYOLITE, XENOLITH" is a rock type with DB number 378.
"RHYOLITE (YOUNG)" is a rock type with DB number 394.
"RYODACITE" is a rock type with DB number 88.
"RYOLITE" is a rock type with DB number 72.
"SANIDINITE" is a rock type with DB number 372.
"SANIDINITE, HORNBLENDE-AEGIRINE" is a rock type with DB number 358.
"SANIDINITE, NA" is a rock type with DB number 368.
"SCHIST, BIOTITE-PLAGIOCLASE-ACTINOLITE" is a rock type with DB number 243.
"SCHIST, PLAGIOCLASE-HORNBLENDE" is a rock type with DB number 245.
"SCORIA" is a rock type with DB number 185.
"SERPENTINITE" is a rock type with DB number 105.
"SHOSHINITE" is a rock type with DB number 285.
"SHOSHONITE" is a rock type with DB number 113.
"SPILITE" is a rock type with DB number 96.
"SYENITE" is a rock type with DB number 61.
"SYENITE, ALKALI FELDSPAR SYENITE, QUARTZ" is a rock type with DB number 220.
"SYENITE MONZONITE GRANITE" is a rock type with DB number 219.
"SYENODIORITE" is a rock type with DB number 111.
"TACHYLYTE" is a rock type with DB number 138.
"TACHYLYTE, PHONOLITIC" is a rock type with DB number 462.
"TAHITITE" is a rock type with DB number 166.
"TEPHRIPHONOLITE" is a rock type with DB number 305.
"TEPHRITE" is a rock type with DB number 119.
"TEPHRITE, ANALCIME" is a rock type with DB number 140.
"TEPHRITE, HAUYNE" is a rock type with DB number 441.
"TEPHRITE, PHONOLITIC" is a rock type with DB number 331.
"TEPHRITE, PYROXENE" is a rock type with DB number 434.
"TEPHRITOID" is a rock type with DB number 74.
"TESCHENITE" is a rock type with DB number 504.
"THLICTC. BASALT" is a rock type with DB number 49.
"THOLEIITE" is a rock type with DB number 114.
"THOLEIITE BASALT" is a rock type with DB number 262.
"THOLEIITE, FERRO" is a rock type with DB number 234.
"THOLEIITE, OLIVINE" is a rock type with DB number 150.
"THOLEIITE, PICRITIC" is a rock type with DB number 172.
"THOLEIITE, QUARTZ" is a rock type with DB number 375.
"THOLEIITE, TRANSITIONAL" is a rock type with DB number 235.
"TINGUAITE" is a rock type with DB number 361.
"TONALITE" is a rock type with DB number 208.
"TONALITE, BIOTITE" is a rock type with DB number 246.
"TONALITE GRANODIORITE GRANITE QUARTZ MONZONITE" is a rock type with DB number 217.
"TONALITE TRONDHJEMITE GRANODIORITE" is a rock type with DB number 216.
"TRACHIBASALT" is a rock type with DB number 21.
"TRACHITE" is a rock type with DB number 19.
"TRACHYANDESITE" is a rock type with DB number 80.
"TRACHYANDESITE, BASALTIC" is a rock type with DB number 307.
"TRACHYANDESITE, HORNBLENDE" is a rock type with DB number 299.
"TRACHYANDESITE, OLIVINE" is a rock type with DB number 298.
"TRACHYANDESITE, SUBALKALINE, OLIVINE (DOREITE)" is a rock type with DB number 297.
"TRACHYANDESITE (TAHITITE)" is a rock type with DB number 429.
"TRACHYBASALT" is a rock type with DB number 79.
"TRACHYBASALT, AMPHIBOLE" is a rock type with DB number 464.
"TRACHYBASALT, HORNBLENDE" is a rock type with DB number 188.
"TRACHYBASALT, OLIVINE" is a rock type with DB number 296.
"TRACHYBASALT, PLAGIOCLASE" is a rock type with DB number 413.
"TRACHYBASALT, POTASSIC" is a rock type with DB number 283.
"TRACHYBASANITE" is a rock type with DB number 477.
"TRACHYBASANITE, PYROXENE" is a rock type with DB number 474.
"TRACHYDIABASE" is a rock type with DB number 118.
"TRACHYDOLERITE" is a rock type with DB number 327.
"TRACHYPHONOLITE" is a rock type with DB number 165.
"TRACHYRHYOLITE" is a rock type with DB number 444.
"TRACHYRHYOLITE, ALKALINE" is a rock type with DB number 439.
"TRACHYT" is a rock type with DB number 86.
"TRACHYTBASALT" is a rock type with DB number 181.
"TRACHYTDOLERIT" is a rock type with DB number 506.
"TRACHYTE" is a rock type with DB number 77.
"TRACHYTE, ACMITE-AUGITE" is a rock type with DB number 300.
"TRACHYTE, AEGIRINE-AUGITE" is a rock type with DB number 301.
"TRACHYTE, AEGIRINE-AUGITE, SODALITE" is a rock type with DB number 345.
"TRACHYTE, AEGIRINE-RIEBECKITE" is a rock type with DB number 326.
"TRACHYTE-ALKALI" is a rock type with DB number 83.
"TRACHYTE, ALKALI, BIOTITE-BEARING" is a rock type with DB number 346.
"TRACHYTE, ALKALINE" is a rock type with DB number 308.
"TRACHYTEANDESITE" is a rock type with DB number 82.
"TRACHYTE, AUGITE" is a rock type with DB number 328.
"TRACHYTE, BIOTITE" is a rock type with DB number 340.
"TRACHYTE/COMENDITE" is a rock type with DB number 324.
"TRACHYTE, COMENDITIC" is a rock type with DB number 313.
"TRACHYTE, COMENDITIC, IGNIMBRITIC" is a rock type with DB number 357.
"TRACHYTE, COMENDITIC/PANTELLERITE" is a rock type with DB number 406.
"TRACHYTE, COMENDITIC/TRACHYTE" is a rock type with DB number 407.
"TRACHYTE, EUTAXITIC" is a rock type with DB number 467.
"TRACHYTE, HAUYNE" is a rock type with DB number 468.
"TRACHYTE, HORNBLENDE" is a rock type with DB number 292.
"TRACHYTE, IGNIMBRITIC" is a rock type with DB number 367.
"TRACHYTE, KATAPHORITE" is a rock type with DB number 369.
"TRACHYTE, MAFIC" is a rock type with DB number 445.
"TRACHYTE, MUGEARITIC" is a rock type with DB number 160.
"TRACHYTE, NEPHELINE" is a rock type with DB number 335.
"TRACHYTE, NEPHELINE-BEARING" is a rock type with DB number 287.
"TRACHYTE, OLIVINE" is a rock type with DB number 347.
"TRACHYTE, PANTELLERITIC" is a rock type with DB number 303.
"TRACHYTE, PERALKALINE" is a rock type with DB number 448.
"TRACHYTE, PHONOLITE, NEPHELINE" is a rock type with DB number 311.
"TRACHYTE, PHONOLITIC" is a rock type with DB number 318.
"TRACHYTE, QUARTZ" is a rock type with DB number 304.
"TRACHYTE, QUARTZITIC" is a rock type with DB number 317.
"TRACHYTE/RHYOLITE" is a rock type with DB number 169.
"TRACHYTE, RHYOLITE, QUARTZ" is a rock type with DB number 310.
"TRACHYTE, SANIDINE" is a rock type with DB number 291.
"TRACHYTE, SANIDINE-AEGIRINE" is a rock type with DB number 133.
"TRACHYTE, SODALITE" is a rock type with DB number 168.
"TRACHYTE/TRACHYTE, COMENDITIC" is a rock type with DB number 408.
"TRISTANITE" is a rock type with DB number 230.
"TROCTOLITE" is a rock type with DB number 12.
"TRONDHJEMITE" is a rock type with DB number 112.
"TRONDHJEMITE TONALITE" is a rock type with DB number 202.
"TUFF" is a rock type with DB number 16.
"ULTRAMAFIC ROCK" is a rock type with DB number 222.
"VOLCANITE, OLIGOCLASE-RICH" is a rock type with DB number 422.
"WEBSTERITE" is a rock type with DB number 5.
"WEHRLITE" is a rock type with DB number 6.
"WERLITE" is a rock type with DB number 55.
"XENOLITH" is a rock type with DB number 400.
"YAMASKITE" is a rock type with DB number 167.
выдача psql -d geo -f rocks.sql -t -A -F "">rocks.txt
выборки
select name, id from rocks order by name;
select name, 'is a type of rock.' from rocks order by name;
!!!В имени породы встречается "-".
Кроме имён пород встречается:
-пустая строка
-"not given"
-class
-and
-or
-to
пустая строка (id=64) - использование:
select id from measurements
where rock_id=64 and status=3
order by id;
== таких 157, а без status - 210.
"not given" (id=173) - использование:
select id from measurements
where rock_id=173 and status=3
order by id;
== таких 354
select m.id as mid, b.id as bid, b.title from measurements m, bibliography b
where rock_id=64 and status=3 and m.bibl_id=b.id
order by id;
== у многих из этих образцов название статьи - NULL!
select name, id from rocks where name like '% %' order by name;
== очень полезно:
select name, id from rocks where name like '%-%' order by name;
=
- сейчас технически мы встретим образцы не привязанные ни к какой породе и статье.