WOVO.org
World Organization of Volcano Observatories
A Commission of the International Association of Volcanology and Chemistry of the Earth's Interior (IAVCEI )Main menu
Search
Latest News
- Meteorology and Volcanology - areas of cooperation 19-Apr-10 14:19
- Information for 'State' volcano observatories providing services to aviation 05-Apr-10 15:15
- Workshop on Remote Sensing and GIS Modeling on Volcanoes 05-Apr-10 14:49
- October 2009 17-Oct-09 08:01
- News from IAVCEI 2008 20-Oct-08 13:12
- New feeds of volcanic information at the GVP 12-Mar-08 08:07
- Paper on health-pertinent ash estimation 10-Jan-08 09:55
- Publication of pamphlets on health hazard 10-Jan-08 09:47
- WOVO at IAVCEI 2008 20-Dec-07 09:21
Volcanic Activity Report
Random Picture
Common Tables
| COMMON TABLES | ||||
| Attribute | Attribute Name | Description | Format | Units |
| Bibliographic Table | ||||
| cb_id | reference ID | An identifier for linking with other tables | mediumint | |
| cb_auth | Authors/Editors | The authors or editors | text | |
| cb_year | Publication yr | The publication year | text | |
| cb_title | Title | The title of the paper or book. | text | |
| cb_journ | Journal | The name of the journal | text | |
| cb_vol | Volume | The journal volume | text | |
| cb_page | Pages | The page numbers | text | |
| cb_pub | Publisher | The name of the publisher (book only) | text | |
| cb_loaddate | Load date | The date this row was entered | datetime | |
| cc_id_load | Data loader ID | The id linking to the person who entered this row of data | mediumint | |
| Standard Instrument Table | ||||
| ci_id | ID | An identifier for linking with other tables | mediumint | |
| ci_name | name | The name of the instrument | text | |
| ci_type | type | The type of instrument | text | |
| ci_man | manufacturer | The manufacturer of the instrument | text | |
| ci_mod | model | The model of the instrument. | text | |
| ci_pres | resolution | Typical instrumental measuring precision | xxx.xxx | units |
| ci_units | measured units | The units the instrument measures. | text | |
| ci_sigt | signal to noise | An instrument specific signal to noise ratio. | xxx | |
| ci_desc | description | Description of instrument | varchar(255) | |
| ci_comm | comments | Comments on the instrument | varchar(255) | |
| cc_id | Contact ID | An identifier for linking with the person or group of people who use this instrument. | mediumint | |
| ci_loaddate | Load date | The date this row was entered | datetime | |
| cc_id_load | Data loader ID | The id linking to the person who entered this row of data | mediumint | |
| Standard Contact Table | ||||
| cc_id | ID | An identifier for linking with other tables | mediumint | |
| cc_fname | first name | First name | text | |
| cc_lname | last name | Last name | text | |
| cc_obs | observatory | The name of the observatory or company | text | |
| cc_add1 | address1 | First line of the address | text | |
| cc_add2 | address2 | Second line of the address | text | |
| cc_city | city | City | text | |
| cc_stat | state | State | text | |
| cc_coun | Country | Country | text | |
| cc_post | postal code | postal code | text | |
| cc_web | web address | web address | text | |
| cc_email | text | |||
| cc_phon | phone | Primary phone number | text | |
| cc_phon2 | phone 2 | Secondary phone number | text | |
| cc_fax | fax | Fax | text | |
| cc_usrname | username | A username for logging into the system (not required for read only access) | text | |
| cc_pwd | pwd | A password for logging into the system (not required for read only access) | text | |
| cc_regdate | register date | The date the information was originally entered | datetime | |
| cc_comm | comments | comments | text | |
| Network Table | ||||
| cn_id | network id | An identifier for linking with other tables | mediumint | |
| cn_name | network name | The name of the network | text | |
| vd_vol_id | volcano id | An identifier for linking with the volcano table. | mediumint | |
| cn_type | network type | Network type, e.g., seismic, gravity, diffuse CO2, etc | text | |
| cn_area | area | The volcano and/or area covered by the network. | varchar(100) | |
| cn_map | network map | Observatory map of network | image | |
| cn_desc | description | A description of the network | varchar(255) | |
| cn_comm | comments | Comments about the network | varchar(255) | |
| cn_loaddate | Load date | The date this row was entered | datetime | |
| cc_id_load | Data loader ID | The id linking to the person who entered this row of data | mediumint | |
| Satellite Table | ||||
| cs_id | satellite id | An identifier for linking with other tables | mediumint | |
| cs_name | satellite name | The name of the satellite | text | |
| cs_desc | satellite description | A description of the satellite | memo | |
| cs_comm | comments | Comments about the satellite | memo | |
| cs_loaddate | Load date | The date this row was entered | datetime | |
| cc_id_load | Data loader ID | The id linking to the person who entered this row of data | mediumint | |
| InstrumentStation Relationship Table | Relates multiple instruments at multiple stations; need one for every station table | |||
| jj_inst_id | instrumentstation id | An identifier for linking with other tables | mediumint | |
| ci_id | instrument id | An identifier for linking with the instrument table | integer | |
| station id | An identifier for linking with the station table | integer | ||
| jj_inst_est | install date | The date the instrument was installed at the station | datetime | |
| ii_inst_dest | instrument stop date | The date the instrument ceased operation at the station | datetime | |
| jj_inst_loaddate | Load date | The date this row was entered | datetime | |
| cc_id_load | Data loader ID | The id linking to the person who entered this row of data | mediumint | |
| VolcanoNetwork Relationship Table | ||||
| jj_volnet_id | volcano-network id | An identifier for linking with other tables | mediumint | |
| vd_vol_id | volcano id | An identifier for linking with the volcano table. | mediumint | |
| cn_id | network id | An identifier for linking with the network table. | mediumint | |
| sn_net_id | seismic network id | An identifier for linking with the seismic network table. | mediumint | |
| jj_volnet_loaddate | Load date | The date this row was entered | datetime | |
| cc_id_load | Data loader ID | The id linking to the person who entered this row of data | mediumint | |
Last Updated on 1/12/2004
By chris newhall