Important Update News

The RRUFF Project has been migrated to RRUFF.net. Please update your bookmarks immediately, if you have not done so.

The data on this website is already three years out of date, and the entire website will be taken offline before the end of the year.

We are grateful to NASA for the funding of this effort.
American Mineralogist Crystal Structure Database

The query is now

    select distinct Amc_Table.fileno from Amc_Table LEFT JOIN Amc_Author ON Amc_Table.fileno=Amc_Author.fileno LEFT JOIN atomic_data ON Amc_Table.fileno = atomic_data.fileno WHERE ( ( contents LIKE '%_database_code_amcsd%') AND ( contents LIKE '%0005443%') )

the size of the result array is 1

the size of the diff result array is 0

The total results from the merged set is 1

The total number of rows in result set is 1

The paginate value is 1

entering paginate loop

The total number to display on this page is 1 1 matching records for this search.

the file_query is
    Select fileno, contents, cifcontents, journalKey, Mineral from Amc_Table where fileno in ('06267.amc') order by fileno
 Fluor-uvite
  
MacDonald D J, Hawthorne F C
The Canadian Mineralogist 33 (1995) 849-858
The crystal chemistry of Si=Al substitution in tourmaline
Sample: T79
Locality: East Africa
_database_code_amcsd 0005443
15.958 15.958 7.180 90 90 120 R3m
atom      x      y      z  occ  Uiso
CaX       0      0  .8408 .769 .0129
NaX       0      0  .8408 .202 .0129
MgY  .06327 .93673  .4369 .926 .0058
TiY  .06327 .93673  .4369 .012 .0058
VY   .06327 .93673  .4369 .041 .0058
LiY  .06327 .93673  .4369 .018 .0058
CrY  .06327 .93673  .4369 .003 .0058
AlZ  .26165 .29795  .4529 .915 .0052
MgZ  .26165 .29795  .4529 .085 .0052
Si   .19041 .19213  .0660 .938 .0055
Al   .19041 .19213  .0660 .062 .0055
B    .89018 .10982  .6148      .0065
F1        0      0  .2922 .805 .0104
OH1       0      0  .2922 .195 .0104
O2   .93931 .06069  .5920      .0098
OH3  .13397 .86603  .5558      .0086
O4   .90784 .09216 -.0062      .0111
O5   .09094 .90906 -.0279      .0106
O6   .18682 .19610  .2892      .0081
O7   .28511 .28557 -.0156      .0088
O8   .27020 .20947  .6240      .0090


  Download AMC data (View Text File)
  Download CIF data (View Text File)
  Download diffraction data (View Text File)
  View JMOL 3-D Structure (permalink)

	 

	

					
				
				
				
				Download in:
				
				
				
				
				
                

                
				
				

                    Multiple datasets can be concatenated into a single downloadable file by selecting the datasets and then clicking 
                

                

                    Multiple datasets can be downloaded as individual files inside a ZIP archive by selecting the datasets and then clicking 
                

	Total number of retrieved datasets: 1

View in html, download in amc


Line 935: Select count from statistic where hostname='18-97-9-168.crawl.commoncrawl.org'
Line 943: Update statistic set count=count + '1' where hostname='18-97-9-168.crawl.commoncrawl.org'






Elapsed time is 5.2810289859772 seconds

Return to AMCSD Home Page


Array
(
    [ResultSet] => a:1:{i:0;s:9:"06267.amc";}
)