| Biotics Views Definitions Last Updated 11/04/04 | |||||||||||||||||||||
| A partial dictionary of views in the Biotics database. Not all views are listed here, but they will be added as time permits. | |||||||||||||||||||||
| View Name | Where Clause | Column Name | Column Select | Column Datatype | Null Option | Referenced Column | Referenced Column Name | ||||||||||||||
| BCD_EOR | EO.d_est_rep_accuracy_id =
D_EST_REP_ACCURACY.d_est_rep_accuracy_id (+)
AND EO.d_confidence_extent_id = D_CONFIDENCE_EXTENT.d_confidence_extent_id (+) AND EO.d_mj_spatial_rep_id = D_MJ_SPATIAL_REP.d_mj_spatial_rep_id (+ |
eo_id | NUMBER | NOT NULL | EO | eo_id | |||||||||||||||
| BCD_EOR | EO.d_est_rep_accuracy_id =
D_EST_REP_ACCURACY.d_est_rep_accuracy_id (+)
AND EO.d_confidence_extent_id = D_CONFIDENCE_EXTENT.d_confidence_extent_id (+) AND EO.d_mj_spatial_rep_id = D_MJ_SPATIAL_REP.d_mj_spatial_rep_id (+ |
shape_id | NUMBER(10) | NOT NULL | EO | shape_id | |||||||||||||||
| BCD_EOR | EO.d_est_rep_accuracy_id =
D_EST_REP_ACCURACY.d_est_rep_accuracy_id (+)
AND EO.d_confidence_extent_id = D_CONFIDENCE_EXTENT.d_confidence_extent_id (+) AND EO.d_mj_spatial_rep_id = D_MJ_SPATIAL_REP.d_mj_spatial_rep_id (+ |
data_sensitive_eo_ind | CHAR(1) | NOT NULL | EO | data_sensitive_eo_ind | |||||||||||||||
| BCD_EOR | EO.d_est_rep_accuracy_id =
D_EST_REP_ACCURACY.d_est_rep_accuracy_id (+)
AND EO.d_confidence_extent_id = D_CONFIDENCE_EXTENT.d_confidence_extent_id (+) AND EO.d_mj_spatial_rep_id = D_MJ_SPATIAL_REP.d_mj_spatial_rep_id (+ |
calc_rep_accuracy | NUMBER | NULL | EO | calc_rep_accuracy | |||||||||||||||
| BCD_EOR | EO.d_est_rep_accuracy_id =
D_EST_REP_ACCURACY.d_est_rep_accuracy_id (+)
AND EO.d_confidence_extent_id = D_CONFIDENCE_EXTENT.d_confidence_extent_id (+) AND EO.d_mj_spatial_rep_id = D_MJ_SPATIAL_REP.d_mj_spatial_rep_id (+ |
separation_com | VARCHAR2(1000) | NULL | EO | separation_com | |||||||||||||||
| BCD_EOR | EO.d_est_rep_accuracy_id =
D_EST_REP_ACCURACY.d_est_rep_accuracy_id (+)
AND EO.d_confidence_extent_id = D_CONFIDENCE_EXTENT.d_confidence_extent_id (+) AND EO.d_mj_spatial_rep_id = D_MJ_SPATIAL_REP.d_mj_spatial_rep_id (+ |
directions | VARCHAR2(2000) | NULL | EO | directions | |||||||||||||||
| BCD_EOR | EO.d_est_rep_accuracy_id =
D_EST_REP_ACCURACY.d_est_rep_accuracy_id (+)
AND EO.d_confidence_extent_id = D_CONFIDENCE_EXTENT.d_confidence_extent_id (+) AND EO.d_mj_spatial_rep_id = D_MJ_SPATIAL_REP.d_mj_spatial_rep_id (+ |
multi_juris_collab_com | VARCHAR2(1000) | NULL | EO | multi_juris_collab_com | |||||||||||||||
| BCD_EOR | EO.d_est_rep_accuracy_id =
D_EST_REP_ACCURACY.d_est_rep_accuracy_id (+)
AND EO.d_confidence_extent_id = D_CONFIDENCE_EXTENT.d_confidence_extent_id (+) AND EO.d_mj_spatial_rep_id = D_MJ_SPATIAL_REP.d_mj_spatial_rep_id (+ |
first_obs_date | VARCHAR2(50) | NULL | EO | first_obs_date | |||||||||||||||
| BCD_EOR | EO.d_est_rep_accuracy_id =
D_EST_REP_ACCURACY.d_est_rep_accuracy_id (+)
AND EO.d_confidence_extent_id = D_CONFIDENCE_EXTENT.d_confidence_extent_id (+) AND EO.d_mj_spatial_rep_id = D_MJ_SPATIAL_REP.d_mj_spatial_rep_id (+ |
last_obs_date | VARCHAR2(50) | NULL | EO | last_obs_date | |||||||||||||||
| BCD_EOR | EO.d_est_rep_accuracy_id =
D_EST_REP_ACCURACY.d_est_rep_accuracy_id (+)
AND EO.d_confidence_extent_id = D_CONFIDENCE_EXTENT.d_confidence_extent_id (+) AND EO.d_mj_spatial_rep_id = D_MJ_SPATIAL_REP.d_mj_spatial_rep_id (+ |
survey_date | VARCHAR2(120) | NULL | EO | survey_date | |||||||||||||||
| BCD_EOR | EO.d_est_rep_accuracy_id =
D_EST_REP_ACCURACY.d_est_rep_accuracy_id (+)
AND EO.d_confidence_extent_id = D_CONFIDENCE_EXTENT.d_confidence_extent_id (+) AND EO.d_mj_spatial_rep_id = D_MJ_SPATIAL_REP.d_mj_spatial_rep_id (+ |
est_rep_accuracy_desc | VARCHAR2(30) | NOT NULL | D_EST_REP_ACCURACY | est_rep_accuracy_desc | |||||||||||||||
| BCD_EOR | EO.d_est_rep_accuracy_id =
D_EST_REP_ACCURACY.d_est_rep_accuracy_id (+)
AND EO.d_confidence_extent_id = D_CONFIDENCE_EXTENT.d_confidence_extent_id (+) AND EO.d_mj_spatial_rep_id = D_MJ_SPATIAL_REP.d_mj_spatial_rep_id (+ |
confidence_extent_desc | VARCHAR2(60) | NOT NULL | D_CONFIDENCE_EXTENT | confidence_extent_desc | |||||||||||||||
| BCD_EOR | EO.d_est_rep_accuracy_id =
D_EST_REP_ACCURACY.d_est_rep_accuracy_id (+)
AND EO.d_confidence_extent_id = D_CONFIDENCE_EXTENT.d_confidence_extent_id (+) AND EO.d_mj_spatial_rep_id = D_MJ_SPATIAL_REP.d_mj_spatial_rep_id (+ |
mj_spatial_rep_desc | VARCHAR2(20) | NOT NULL | D_MJ_SPATIAL_REP | mj_spatial_rep_desc | |||||||||||||||
| BCD_EOR | EO.d_est_rep_accuracy_id =
D_EST_REP_ACCURACY.d_est_rep_accuracy_id (+)
AND EO.d_confidence_extent_id = D_CONFIDENCE_EXTENT.d_confidence_extent_id (+) AND EO.d_mj_spatial_rep_id = D_MJ_SPATIAL_REP.d_mj_spatial_rep_id (+ |
multi_jurisdictional_desc | VARCHAR2(20) | NOT NULL | D_MULTI_JURISDICTIONAL | multi_jurisdictional_desc | |||||||||||||||
| BCD_EOR | EO.d_est_rep_accuracy_id =
D_EST_REP_ACCURACY.d_est_rep_accuracy_id (+)
AND EO.d_confidence_extent_id = D_CONFIDENCE_EXTENT.d_confidence_extent_id (+) AND EO.d_mj_spatial_rep_id = D_MJ_SPATIAL_REP.d_mj_spatial_rep_id (+ |
basic_eo_rank_desc | VARCHAR2(60) | NOT NULL | D_BASIC_EO_RANK | basic_eo_rank_desc | |||||||||||||||
| BCD_ET | ELEMENT_GLOBAL.inactive_ind =
'N' AND ELEMENT_SUBNATIONAL.element_national_id = ELEMENT_NATIONAL.element_national_id AND ELEMENT_NATIONAL.element_global_id = ELEMENT_GLOBAL.element_global_id AND ELEMENT_GLOBAL.gname_id = |
elcode | char(10) | NULL | ELEMENT_GLOBAL | elcode_bcd | |||||||||||||||
| BCD_ET | ELEMENT_GLOBAL.inactive_ind =
'N' AND ELEMENT_SUBNATIONAL.element_national_id = ELEMENT_NATIONAL.element_national_id AND ELEMENT_NATIONAL.element_global_id = ELEMENT_GLOBAL.element_global_id AND ELEMENT_GLOBAL.gname_id = |
gname | VARCHAR2(250) | NOT NULL | SCIENTIFIC_NAME | scientific_name | |||||||||||||||
| BCD_ET | ELEMENT_GLOBAL.inactive_ind =
'N' AND ELEMENT_SUBNATIONAL.element_national_id = ELEMENT_NATIONAL.element_national_id AND ELEMENT_NATIONAL.element_global_id = ELEMENT_GLOBAL.element_global_id AND ELEMENT_GLOBAL.gname_id = |
gcomname | VARCHAR2(400) | NULL | ELEMENT_GLOBAL | g_primary_common_name | |||||||||||||||
| BCD_ET | ELEMENT_GLOBAL.inactive_ind =
'N' AND ELEMENT_SUBNATIONAL.element_national_id = ELEMENT_NATIONAL.element_national_id AND ELEMENT_NATIONAL.element_global_id = ELEMENT_GLOBAL.element_global_id AND ELEMENT_GLOBAL.gname_id = |
name_category_desc | VARCHAR2(60) | NOT NULL | D_NAME_CATEGORY | name_category_desc | |||||||||||||||
| BCD_ET | ELEMENT_GLOBAL.inactive_ind =
'N' AND ELEMENT_SUBNATIONAL.element_national_id = ELEMENT_NATIONAL.element_national_id AND ELEMENT_NATIONAL.element_global_id = ELEMENT_GLOBAL.element_global_id AND ELEMENT_GLOBAL.gname_id = |
g_rank | VARCHAR2(12) | NOT NULL | ELEMENT_GLOBAL | g_rank | |||||||||||||||
| BCD_ET | ELEMENT_GLOBAL.inactive_ind =
'N' AND ELEMENT_SUBNATIONAL.element_national_id = ELEMENT_NATIONAL.element_national_id AND ELEMENT_NATIONAL.element_global_id = ELEMENT_GLOBAL.element_global_id AND ELEMENT_GLOBAL.gname_id = |
element_subnational_id | NUMBER | NOT NULL | ELEMENT_SUBNATIONAL | element_subnational_id | |||||||||||||||
| BCD_ET | ELEMENT_GLOBAL.inactive_ind =
'N' AND ELEMENT_SUBNATIONAL.element_national_id = ELEMENT_NATIONAL.element_national_id AND ELEMENT_NATIONAL.element_global_id = ELEMENT_GLOBAL.element_global_id AND ELEMENT_GLOBAL.gname_id = |
sname | VARCHAR2(250) | NOT NULL | SCIENTIFIC_NAME | scientific_name | |||||||||||||||
| BCD_ET | ELEMENT_GLOBAL.inactive_ind =
'N' AND ELEMENT_SUBNATIONAL.element_national_id = ELEMENT_NATIONAL.element_national_id AND ELEMENT_NATIONAL.element_global_id = ELEMENT_GLOBAL.element_global_id AND ELEMENT_GLOBAL.gname_id = |
scomname | VARCHAR2(400) | NULL | ELEMENT_SUBNATIONAL | s_primary_common_name | |||||||||||||||
| BCD_ET | ELEMENT_GLOBAL.inactive_ind =
'N' AND ELEMENT_SUBNATIONAL.element_national_id = ELEMENT_NATIONAL.element_national_id AND ELEMENT_NATIONAL.element_global_id = ELEMENT_GLOBAL.element_global_id AND ELEMENT_GLOBAL.gname_id = |
s_rank | VARCHAR2(20) | NOT NULL | ELEMENT_SUBNATIONAL | s_rank | |||||||||||||||
| BCD_ET | ELEMENT_GLOBAL.inactive_ind =
'N' AND ELEMENT_SUBNATIONAL.element_national_id = ELEMENT_NATIONAL.element_national_id AND ELEMENT_NATIONAL.element_global_id = ELEMENT_GLOBAL.element_global_id AND ELEMENT_GLOBAL.gname_id = |
classification_status_desc | VARCHAR2(20) | NOT NULL | D_CLASSIFICATION_STATUS | classification_status_desc | |||||||||||||||
| BCD_ET | ELEMENT_GLOBAL.inactive_ind =
'N' AND ELEMENT_SUBNATIONAL.element_national_id = ELEMENT_NATIONAL.element_national_id AND ELEMENT_NATIONAL.element_global_id = ELEMENT_GLOBAL.element_global_id AND ELEMENT_GLOBAL.gname_id = |
eo_track_status_desc | VARCHAR2(50) | NOT NULL | D_EO_TRACK_STATUS | eo_track_status_desc | |||||||||||||||
| CONTACT_WL_VW | D_CONTACT_CATEGORY.D_CONTACT_CATEGORY_ID = CONTACT.D_CONTACT_CATEGORY_ID | ID | NUMBER | NOT NULL | CONTACT | contact_id | |||||||||||||||
| CONTACT_WL_VW | D_CONTACT_CATEGORY.D_CONTACT_CATEGORY_ID = CONTACT.D_CONTACT_CATEGORY_ID | CONTACT_CATEGORY_DESC | VARCHAR2(20) | NULL | D_CONTACT_CATEGORY | contact_category_desc | |||||||||||||||
| CONTACT_WL_VW | D_CONTACT_CATEGORY.D_CONTACT_CATEGORY_ID = CONTACT.D_CONTACT_CATEGORY_ID | INDIV_NAME | VARCHAR2(100) | NULL | CONTACT | indiv_name | |||||||||||||||
| CONTACT_WL_VW | D_CONTACT_CATEGORY.D_CONTACT_CATEGORY_ID = CONTACT.D_CONTACT_CATEGORY_ID | INST_NAME | VARCHAR2(100) | NULL | CONTACT | inst_name | |||||||||||||||
| D_CONC_FEAT_SPAT_UNCERTAINTY | conceptual_feature_type_id | NUMBER | NOT NULL | D_CONC_FEAT_LOC_UNCERT | d_conc_feature_type_id | ||||||||||||||||
| D_CONC_FEAT_SPAT_UNCERTAINTY | spatial_uncertainty_type_id | NUMBER | NOT NULL | D_CONC_FEAT_LOC_UNCERT | d_loc_uncertainty_type_id | ||||||||||||||||
| D_CONC_FEAT_SPAT_UNCERTAINTY | procedural_buffer_distance | NUMBER | NULL | D_CONC_FEAT_LOC_UNCERT | procedural_buffer_distance | ||||||||||||||||
| D_CONC_FEAT_SPAT_UNCERTAINTY | procedural_buffer_unit_id | NUMBER | NULL | D_CONC_FEAT_LOC_UNCERT | procedural_buffer_unit_id | ||||||||||||||||
| D_CONC_FEAT_SPAT_UNCERTAINTY | feature_code | NUMBER | NOT NULL | D_CONC_FEAT_LOC_UNCERT | feature_code | ||||||||||||||||
| D_CONCEPTUAL_FEATURE_TYPE | conceptual_feature_type_id | NUMBER | NOT NULL | D_CONC_FEATURE_TYPE | d_conc_feature_type_id | ||||||||||||||||
| D_CONCEPTUAL_FEATURE_TYPE | conceptual_feature_type_desc | VARCHAR2(10) | NOT NULL | D_CONC_FEATURE_TYPE | conc_feature_type_desc | ||||||||||||||||
| D_CONCEPTUAL_FEATURE_TYPE | display_order | NUMBER | NULL | D_CONC_FEATURE_TYPE | display_order | ||||||||||||||||
| D_COUNTY_VW | d_county_id | to_char(d_county_id) d_county_id | |||||||||||||||||||
| D_COUNTY_VW | county_cd | CHAR(6) | NOT NULL | D_COUNTY | county_cd | ||||||||||||||||
| D_COUNTY_VW | county_name | VARCHAR2(60) | NOT NULL | D_COUNTY | county_name | ||||||||||||||||
| D_COUNTY_VW | state_county_fips_cd | VARCHAR2(5) | NULL | D_COUNTY | state_county_fips_cd | ||||||||||||||||
| D_DISTANCE_CLASS | distance_class_id | NUMBER | NOT NULL | D_LOC_UNCERT_DIST_CLASS | d_loc_uncert_dist_class_id | ||||||||||||||||
| D_DISTANCE_CLASS | distance_unit_id | NUMBER | NULL | D_LOC_UNCERT_DIST_CLASS | d_unit_id | ||||||||||||||||
| D_DISTANCE_CLASS | distance_class_desc | VARCHAR2(30) | NOT NULL | D_LOC_UNCERT_DIST_CLASS | distance_class_desc | ||||||||||||||||
| D_DISTANCE_CLASS | distance_value | NUMBER | NULL | D_LOC_UNCERT_DIST_CLASS | distance_value | ||||||||||||||||
| D_DISTANCE_CLASS | display_order | NUMBER | NULL | D_LOC_UNCERT_DIST_CLASS | display_order | ||||||||||||||||
| D_LOCAL_JURISDICTION_VW | local_jurisdiction_desc | VARCHAR2(50) | NOT NULL | D_LOCAL_JURISDICTION | local_jurisdiction_desc | ||||||||||||||||
| D_LOCAL_JURISDICTION_VW | d_local_jurisdiction_id | to_char(d_local_jurisdiction_id) d_jurisdiction_id | |||||||||||||||||||
| D_MAPSHEET_VW | d_mapsheet_id | to_char(d_mapsheet_id) d_mapsheet_id | |||||||||||||||||||
| D_MAPSHEET_VW | mapsheet_cd | VARCHAR2(20) | NOT NULL | D_MAPSHEET | mapsheet_cd | ||||||||||||||||
| D_MAPSHEET_VW | mapsheet_name | VARCHAR2(50) | NOT NULL | D_MAPSHEET | mapsheet_name | ||||||||||||||||
| D_PHYS_PROVINCE_VW | d_phys_province_id | to_char(d_phys_province_id) d_phys_province_id | |||||||||||||||||||
| D_PHYS_PROVINCE_VW | phys_province_cd | VARCHAR2(5) | NOT NULL | D_PHYS_PROVINCE | phys_province_cd | ||||||||||||||||
| D_PHYS_PROVINCE_VW | phys_province_desc | VARCHAR2(50) | NOT NULL | D_PHYS_PROVINCE | phys_province_desc | ||||||||||||||||
| D_SPATIAL_UNCERTAINTY_TYPE | spatial_uncertainty_type_id | NUMBER | NOT NULL | D_LOC_UNCERTAINTY_TYPE | d_loc_uncertainty_type_id | ||||||||||||||||
| D_SPATIAL_UNCERTAINTY_TYPE | spatial_uncertainty_type_desc | VARCHAR2(30) | NOT NULL | D_LOC_UNCERTAINTY_TYPE | loc_uncertainty_type_desc | ||||||||||||||||
| D_SPATIAL_UNCERTAINTY_TYPE | distance_class_allowed | VARCHAR2(1) | NOT NULL | D_LOC_UNCERTAINTY_TYPE | distance_class_allowed | ||||||||||||||||
| D_SPATIAL_UNCERTAINTY_TYPE | display_order | NUMBER | NULL | D_LOC_UNCERTAINTY_TYPE | display_order | ||||||||||||||||
| D_UNIT_OF_MEASURE | unit_id | INTEGER | NULL | D_UNIT | d_unit_id | ||||||||||||||||
| D_UNIT_OF_MEASURE | unit_desc | VARCHAR2(30) | NOT NULL | D_UNIT | unit_desc | ||||||||||||||||
| D_UNIT_OF_MEASURE | unit_type | VARCHAR2(10) | NOT NULL | D_UNIT | unit_type | ||||||||||||||||
| D_UNIT_OF_MEASURE | unit_abbreviation | VARCHAR2(5) | NOT NULL | D_UNIT | unit_abbreviation | ||||||||||||||||
| D_UNIT_OF_MEASURE | unit_keyword | VARCHAR2(20) | NOT NULL | D_UNIT | unit_keyword | ||||||||||||||||
| D_UNIT_OF_MEASURE | display_order | NUMBER | NULL | D_UNIT | display_order | ||||||||||||||||
| D_WATERSHED_VW | d_watershed_id | to_char(d_watershed_id) d_watershed_id | |||||||||||||||||||
| D_WATERSHED_VW | watershed_cd | VARCHAR2(20) | NOT NULL | D_WATERSHED | watershed_cd | ||||||||||||||||
| D_WATERSHED_VW | watershed_desc | VARCHAR2(50) | NOT NULL | D_WATERSHED | watershed_desc | ||||||||||||||||
| ELEMENT_OCCURRENCE | feature_id | NUMBER(10) | NOT NULL | EO | shape_id | ||||||||||||||||
| ELEMENT_OCCURRENCE | element_subnational_id | NUMBER | NOT NULL | EO | element_subnational_id | ||||||||||||||||
| ELEMENT_OCCURRENCE | eo_num | NUMBER | NULL | EO | eo_num | ||||||||||||||||
| ELEMENT_OCCURRENCE | reference_point_x | NUMBER | NULL | EO | reference_point_x | ||||||||||||||||
| ELEMENT_OCCURRENCE | reference_point_y | NUMBER | NULL | EO | reference_point_y | ||||||||||||||||
| ELEMENT_OCCURRENCE | eo_rep_edited | CHAR(1) | NOT NULL | EO | eo_rep_edited_ind | ||||||||||||||||
| ELEMENT_OCCURRENCE | eo_rep_edited_com | VARCHAR2(1000) | NULL | EO | eo_rep_edited_com | ||||||||||||||||
| ELEMENT_OCCURRENCE | rec_create_user | VARCHAR2(30) | NOT NULL | EO | rec_create_user | ||||||||||||||||
| ELEMENT_OCCURRENCE | rec_last_mod_user | VARCHAR2(30) | NULL | EO | rec_last_mod_user | ||||||||||||||||
| ELEMENT_OCCURRENCE | parent_eo_id | NUMBER(10) | NULL | EO | principal_eo_shape_id | ||||||||||||||||
| ELEMENT_OCCURRENCE_SOURCE | eo_feature_id | NUMBER(10) | NOT NULL | EO_SOURCE_FEATURE | eo_shape_id | ||||||||||||||||
| ELEMENT_OCCURRENCE_SOURCE | source_feature_id | NUMBER(10) | NOT NULL | EO_SOURCE_FEATURE | source_feature_shape_id | ||||||||||||||||
| ELEMENT_OCCURRENCE_SOURCE | rec_create_user | VARCHAR2(30) | NOT NULL | EO_SOURCE_FEATURE | rec_create_user | ||||||||||||||||
| ELEMENT_OCCURRENCE_SOURCE | rec_last_mod_user | VARCHAR2(30) | NULL | EO_SOURCE_FEATURE | rec_last_mod_user | ||||||||||||||||
| ELGROUP_WL_VW | element_group.d_element_group_type_id = d_element_group_type.d_element_group_type_id | ID | element_group.element_group_id | ||||||||||||||||||
| ELGROUP_WL_VW | element_group.d_element_group_type_id = d_element_group_type.d_element_group_type_id | GROUP_NAME | element_group.element_group_name | ||||||||||||||||||
| ELGROUP_WL_VW | element_group.d_element_group_type_id = d_element_group_type.d_element_group_type_id | GROUP_TYPE | d_element_group_type.element_group_type_desc | ||||||||||||||||||
| EO_WL_VW | EO.ELEMENT_SUBNATIONAL_ID = ELEMENT_SUBNATIONAL.ELEMENT_SUBNATIONAL_ID AND ELEMENT_SUBNATIONAL.ELEMENT_NATIONAL_ID = ELEMENT_NATIONAL.ELEMENT_NATIONAL_ID AND ELEMENT_NATIONAL.ELEMENT_GLOBAL_ID = ELEMENT_GLOBAL.ELEMENT | ID | EO.EO_ID | ||||||||||||||||||
| EO_WL_VW | EO.ELEMENT_SUBNATIONAL_ID = ELEMENT_SUBNATIONAL.ELEMENT_SUBNATIONAL_ID AND ELEMENT_SUBNATIONAL.ELEMENT_NATIONAL_ID = ELEMENT_NATIONAL.ELEMENT_NATIONAL_ID AND ELEMENT_NATIONAL.ELEMENT_GLOBAL_ID = ELEMENT_GLOBAL.ELEMENT | ELCODE_BCD | ELEMENT_GLOBAL.ELCODE_BCD | ||||||||||||||||||
| EO_WL_VW | EO.ELEMENT_SUBNATIONAL_ID = ELEMENT_SUBNATIONAL.ELEMENT_SUBNATIONAL_ID AND ELEMENT_SUBNATIONAL.ELEMENT_NATIONAL_ID = ELEMENT_NATIONAL.ELEMENT_NATIONAL_ID AND ELEMENT_NATIONAL.ELEMENT_GLOBAL_ID = ELEMENT_GLOBAL.ELEMENT | EO_NUMBER | EO.EO_NUM | ||||||||||||||||||
| EO_WL_VW | EO.ELEMENT_SUBNATIONAL_ID = ELEMENT_SUBNATIONAL.ELEMENT_SUBNATIONAL_ID AND ELEMENT_SUBNATIONAL.ELEMENT_NATIONAL_ID = ELEMENT_NATIONAL.ELEMENT_NATIONAL_ID AND ELEMENT_NATIONAL.ELEMENT_GLOBAL_ID = ELEMENT_GLOBAL.ELEMENT | SUBNATIONAL_SCIENTIFIC_NAME | SCIENTIFIC_NAME.SCIENTIFIC_NAME | ||||||||||||||||||
| EO_WL_VW | EO.ELEMENT_SUBNATIONAL_ID = ELEMENT_SUBNATIONAL.ELEMENT_SUBNATIONAL_ID AND ELEMENT_SUBNATIONAL.ELEMENT_NATIONAL_ID = ELEMENT_NATIONAL.ELEMENT_NATIONAL_ID AND ELEMENT_NATIONAL.ELEMENT_GLOBAL_ID = ELEMENT_GLOBAL.ELEMENT | SUBNATIONAL_COMMON_NAME | ELEMENT_SUBNATIONAL.S_PRIMARY_COMMON_NAME | ||||||||||||||||||
| EO_WL_VW | EO.ELEMENT_SUBNATIONAL_ID = ELEMENT_SUBNATIONAL.ELEMENT_SUBNATIONAL_ID AND ELEMENT_SUBNATIONAL.ELEMENT_NATIONAL_ID = ELEMENT_NATIONAL.ELEMENT_NATIONAL_ID AND ELEMENT_NATIONAL.ELEMENT_GLOBAL_ID = ELEMENT_GLOBAL.ELEMENT | EO_RANK | D_BASIC_EO_RANK.DISPLAY_VALUE | ||||||||||||||||||
| EO_WL_VW | EO.ELEMENT_SUBNATIONAL_ID = ELEMENT_SUBNATIONAL.ELEMENT_SUBNATIONAL_ID AND ELEMENT_SUBNATIONAL.ELEMENT_NATIONAL_ID = ELEMENT_NATIONAL.ELEMENT_NATIONAL_ID AND ELEMENT_NATIONAL.ELEMENT_GLOBAL_ID = ELEMENT_GLOBAL.ELEMENT | SURVEY_SITE | (SELECT EO_SURVEY_SITE.SURVEY_SITE_NAME FROM eo_survey_site WHERE eo_survey_site.EO_ID = eo.eo_id AND (eo_survey_site.display_order = 1 OR (display_order IS NULL AND rownum = 1))) | ||||||||||||||||||
| EOCODE_VW | |||||||||||||||||||||
| FEATURE | feature_id | NUMBER(10) | NOT NULL | SHAPE | shape_id | ||||||||||||||||
| FEATURE | feature_code | NUMBER(10) | NULL | SHAPE | feature_code | ||||||||||||||||
| FEATURE | feature_type | VARCHAR2(10) | NULL | SHAPE | shape_type | ||||||||||||||||
| FEATURE | qc_status | VARCHAR(1) | NULL | SHAPE | map_qc_status | ||||||||||||||||
| FEATURE | has_shape_ind | CHAR(1) | NOT NULL | SHAPE | has_shape_ind | ||||||||||||||||
| FEATURE | mapped_by | VARCHAR2(20) | NULL | SHAPE | digital_mapping_by | ||||||||||||||||
| FEATURE | mappeddate | DATE | NULL | SHAPE | digital_mapping_date | ||||||||||||||||
| FEATURE | qc_done_by | VARCHAR2(20) | NULL | SHAPE | map_qc_by | ||||||||||||||||
| FEATURE | qc_remarks | VARCHAR2(1000) | NULL | SHAPE | qc_com | ||||||||||||||||
| FEATURE | deleted | VARCHAR2(1) | NOT NULL | SHAPE | deleted_ind | ||||||||||||||||
| FEATURE | rec_create_user | VARCHAR2(30) | NOT NULL | SHAPE | rec_create_user | ||||||||||||||||
| FEATURE | rec_last_mod_user | VARCHAR2(30) | NULL | SHAPE | rec_last_mod_user | ||||||||||||||||
| MANAGED_AREA | feature_id | NUMBER(10) | NOT NULL | MA | shape_id | ||||||||||||||||
| MANAGED_AREA | macode | VARCHAR2(17) | NULL | MA | macode_bcd | ||||||||||||||||
| MANAGED_AREA | ma_name | VARCHAR2(100) | NOT NULL | MA | managed_area_name | ||||||||||||||||
| MANAGED_AREA | rec_create_user | VARCHAR2(30) | NOT NULL | MA | rec_create_user | ||||||||||||||||
| MANAGED_AREA | rec_last_mod_user | VARCHAR2(30) | NULL | MA | rec_last_mod_user | ||||||||||||||||
| MANAGED_AREA_ELEMENT_VW | |||||||||||||||||||||
| MANAGED_AREA_WL_VW | ID | MA.MANAGED_AREA_ID | |||||||||||||||||||
| MANAGED_AREA_WL_VW | MANAGED_AREA_NAME | MA.MANAGED_AREA_NAME | |||||||||||||||||||
| MANAGED_AREA_WL_VW | MANAGED_AREA_TYPE | MA.MANAGED_AREA_TYPE | |||||||||||||||||||
| REFERENCE_WL_VW | ID | reference.reference_id | |||||||||||||||||||
| REFERENCE_WL_VW | reference_code | reference.reference_code | |||||||||||||||||||
| REFERENCE_WL_VW | FULL_CITATION | reference.full_citation | |||||||||||||||||||
| REFERENCE_WL_VW | SHELF_NOTE | reference.shelf_note | |||||||||||||||||||
| REFERENCE_WL_VW | SHORT_CITATION_YEAR | reference.short_citation_year | |||||||||||||||||||
| REFERENCE_WL_VW | SHORT_CITATION_TIEBREAKER | reference.short_citation_tiebreaker | |||||||||||||||||||
| REFERENCE_WL_VW | SHORT_CITATION_AUTHOR | reference.short_citation_author | |||||||||||||||||||
| SCIENTIFIC_SRCH_VW | SCIENTIFIC_NAME.D_CLASSIFICATION_LEVEL_ID = D_CLASSIFICATION_LEVEL.D_CLASSIFICATION_LEVEL_ID AND SCIENTIFIC_NAME.D_NAME_CATEGORY_ID = D_NAME_CATEGORY.D_NAME_CATEGORY_ID AND D_CLASSIFICATION_LEVEL.LOWER_LEVEL_IND = 'Y' | ID | SCIENTIFIC_NAME.SCIENTIFIC_NAME_ID | ||||||||||||||||||
| SCIENTIFIC_SRCH_VW | SCIENTIFIC_NAME.D_CLASSIFICATION_LEVEL_ID = D_CLASSIFICATION_LEVEL.D_CLASSIFICATION_LEVEL_ID AND SCIENTIFIC_NAME.D_NAME_CATEGORY_ID = D_NAME_CATEGORY.D_NAME_CATEGORY_ID AND D_CLASSIFICATION_LEVEL.LOWER_LEVEL_IND = 'Y' | SCIENTIFIC_NAME | SCIENTIFIC_NAME.SCIENTIFIC_NAME | ||||||||||||||||||
| SCIENTIFIC_SRCH_VW | SCIENTIFIC_NAME.D_CLASSIFICATION_LEVEL_ID = D_CLASSIFICATION_LEVEL.D_CLASSIFICATION_LEVEL_ID AND SCIENTIFIC_NAME.D_NAME_CATEGORY_ID = D_NAME_CATEGORY.D_NAME_CATEGORY_ID AND D_CLASSIFICATION_LEVEL.LOWER_LEVEL_IND = 'Y' | AUTHOR | SCIENTIFIC_NAME.AUTHOR_NAME | ||||||||||||||||||
| SCIENTIFIC_SRCH_VW | SCIENTIFIC_NAME.D_CLASSIFICATION_LEVEL_ID = D_CLASSIFICATION_LEVEL.D_CLASSIFICATION_LEVEL_ID AND SCIENTIFIC_NAME.D_NAME_CATEGORY_ID = D_NAME_CATEGORY.D_NAME_CATEGORY_ID AND D_CLASSIFICATION_LEVEL.LOWER_LEVEL_IND = 'Y' | NAME_TYPE | D_NAME_CATEGORY.NAME_TYPE_CD | ||||||||||||||||||
| SCIENTIFIC_SRCH_VW | SCIENTIFIC_NAME.D_CLASSIFICATION_LEVEL_ID = D_CLASSIFICATION_LEVEL.D_CLASSIFICATION_LEVEL_ID AND SCIENTIFIC_NAME.D_NAME_CATEGORY_ID = D_NAME_CATEGORY.D_NAME_CATEGORY_ID AND D_CLASSIFICATION_LEVEL.LOWER_LEVEL_IND = 'Y' | CATEGORY | D_NAME_CATEGORY.NAME_CATEGORY_DESC | ||||||||||||||||||
| SCIENTIFIC_SRCH_VW | SCIENTIFIC_NAME.D_CLASSIFICATION_LEVEL_ID = D_CLASSIFICATION_LEVEL.D_CLASSIFICATION_LEVEL_ID AND SCIENTIFIC_NAME.D_NAME_CATEGORY_ID = D_NAME_CATEGORY.D_NAME_CATEGORY_ID AND D_CLASSIFICATION_LEVEL.LOWER_LEVEL_IND = 'Y' | CLASSIFICATION_LEVEL | D_CLASSIFICATION_LEVEL.CLASSIFICATION_LEVEL_NAME | ||||||||||||||||||
| SCIENTIFIC_WL_VW | SCIENTIFIC_NAME.D_CLASSIFICATION_LEVEL_ID = D_CLASSIFICATION_LEVEL.D_CLASSIFICATION_LEVEL_ID AND SCIENTIFIC_NAME.D_NAME_CATEGORY_ID = D_NAME_CATEGORY.D_NAME_CATEGORY_ID AND D_CLASSIFICATION_LEVEL.LOWER_LEVEL_IND = 'Y' | ID | SCIENTIFIC_NAME.SCIENTIFIC_NAME_ID | ||||||||||||||||||
| SCIENTIFIC_WL_VW | SCIENTIFIC_NAME.D_CLASSIFICATION_LEVEL_ID = D_CLASSIFICATION_LEVEL.D_CLASSIFICATION_LEVEL_ID AND SCIENTIFIC_NAME.D_NAME_CATEGORY_ID = D_NAME_CATEGORY.D_NAME_CATEGORY_ID AND D_CLASSIFICATION_LEVEL.LOWER_LEVEL_IND = 'Y' | SCIENTIFIC_NAME | SCIENTIFIC_NAME.SCIENTIFIC_NAME | ||||||||||||||||||
| SCIENTIFIC_WL_VW | SCIENTIFIC_NAME.D_CLASSIFICATION_LEVEL_ID = D_CLASSIFICATION_LEVEL.D_CLASSIFICATION_LEVEL_ID AND SCIENTIFIC_NAME.D_NAME_CATEGORY_ID = D_NAME_CATEGORY.D_NAME_CATEGORY_ID AND D_CLASSIFICATION_LEVEL.LOWER_LEVEL_IND = 'Y' | AUTHOR | SCIENTIFIC_NAME.AUTHOR_NAME | ||||||||||||||||||
| SCIENTIFIC_WL_VW | SCIENTIFIC_NAME.D_CLASSIFICATION_LEVEL_ID = D_CLASSIFICATION_LEVEL.D_CLASSIFICATION_LEVEL_ID AND SCIENTIFIC_NAME.D_NAME_CATEGORY_ID = D_NAME_CATEGORY.D_NAME_CATEGORY_ID AND D_CLASSIFICATION_LEVEL.LOWER_LEVEL_IND = 'Y' | CATEGORY | D_NAME_CATEGORY.NAME_CATEGORY_DESC | ||||||||||||||||||
| SCIENTIFIC_WL_VW | SCIENTIFIC_NAME.D_CLASSIFICATION_LEVEL_ID = D_CLASSIFICATION_LEVEL.D_CLASSIFICATION_LEVEL_ID AND SCIENTIFIC_NAME.D_NAME_CATEGORY_ID = D_NAME_CATEGORY.D_NAME_CATEGORY_ID AND D_CLASSIFICATION_LEVEL.LOWER_LEVEL_IND = 'Y' | CLASSIFICATION_LEVEL | D_CLASSIFICATION_LEVEL.CLASSIFICATION_LEVEL_NAME | ||||||||||||||||||
| SITE | feature_id | NUMBER(10) | NOT NULL | CONSERVATION_SITE | shape_id | ||||||||||||||||
| SITE | sitecode | VARCHAR2(17) | NULL | CONSERVATION_SITE | sitecode_bcd | ||||||||||||||||
| SITE | site_name | VARCHAR2(150) | NOT NULL | CONSERVATION_SITE | site_name | ||||||||||||||||
| SITE | rec_create_user | VARCHAR2(30) | NOT NULL | CONSERVATION_SITE | rec_create_user | ||||||||||||||||
| SITE | rec_last_mod_user | VARCHAR2(30) | NULL | CONSERVATION_SITE | rec_last_mod_user | ||||||||||||||||
| SITE_WL_VW | SITE1.D_SITE_CLASS_ID = D_SITE_CLASS.D_SITE_CLASS_ID(+) AND SITE1.MACRO_SITE_ID = SITE2.CONSERVATION_SITE_ID(+) AND SITE1.SITE_RESP_SUBNATION_ID = SUBNATION.SUBNATION_ID(+) | ID | SITE1.CONSERVATION_SITE_ID | ||||||||||||||||||
| SITE_WL_VW | SITE1.D_SITE_CLASS_ID = D_SITE_CLASS.D_SITE_CLASS_ID(+) AND SITE1.MACRO_SITE_ID = SITE2.CONSERVATION_SITE_ID(+) AND SITE1.SITE_RESP_SUBNATION_ID = SUBNATION.SUBNATION_ID(+) | SITE_NAME | SITE1.SITE_NAME | ||||||||||||||||||
| SITE_WL_VW | SITE1.D_SITE_CLASS_ID = D_SITE_CLASS.D_SITE_CLASS_ID(+) AND SITE1.MACRO_SITE_ID = SITE2.CONSERVATION_SITE_ID(+) AND SITE1.SITE_RESP_SUBNATION_ID = SUBNATION.SUBNATION_ID(+) | SITE_CLASS | D_SITE_CLASS.SITE_CLASS_CD | ||||||||||||||||||
| SITE_WL_VW | SITE1.D_SITE_CLASS_ID = D_SITE_CLASS.D_SITE_CLASS_ID(+) AND SITE1.MACRO_SITE_ID = SITE2.CONSERVATION_SITE_ID(+) AND SITE1.SITE_RESP_SUBNATION_ID = SUBNATION.SUBNATION_ID(+) | MACRO_SITE_NAME | SITE2.SITE_NAME | ||||||||||||||||||
| SITE_WL_VW | SITE1.D_SITE_CLASS_ID = D_SITE_CLASS.D_SITE_CLASS_ID(+) AND SITE1.MACRO_SITE_ID = SITE2.CONSERVATION_SITE_ID(+) AND SITE1.SITE_RESP_SUBNATION_ID = SUBNATION.SUBNATION_ID(+) | SITE_RESPONSIBILITY | SUBNATION.SUBNATION_NAME | ||||||||||||||||||
| SOURCE | feature_id | NUMBER(10) | NOT NULL | SOURCE_FEATURE | shape_id | ||||||||||||||||
| SOURCE | element_subnational_id | NUMBER | NOT NULL | SOURCE_FEATURE | element_subnational_id | ||||||||||||||||
| SOURCE | source_name | VARCHAR2(60) | NULL | SOURCE_FEATURE | source_feature_descriptor | ||||||||||||||||
| SOURCE | spatial_uncertainty_type_id | NUMBER | NOT NULL | SOURCE_FEATURE | d_loc_uncertainty_type_id | ||||||||||||||||
| SOURCE | conceptual_feature_type_id | NUMBER | NOT NULL | SOURCE_FEATURE | d_conc_feature_type_id | ||||||||||||||||
| SOURCE | spatial_uncertainty_distance | NUMBER | NULL | SOURCE_FEATURE | loc_uncertainty_distance | ||||||||||||||||
| SOURCE | spatial_uncertainty_unit_id | NUMBER | NULL | SOURCE_FEATURE | loc_uncertainty_unit_id | ||||||||||||||||
| SOURCE | observed_area | NUMBER | NULL | SOURCE_FEATURE | obs_feature_area | ||||||||||||||||
| SOURCE | observed_area_unit_id | NUMBER | NULL | SOURCE_FEATURE | obs_feature_area_unit_id | ||||||||||||||||
| SOURCE | observed_length | NUMBER | NULL | SOURCE_FEATURE | obs_feature_length | ||||||||||||||||
| SOURCE | observed_length_unit_id | NUMBER | NULL | SOURCE_FEATURE | obs_feature_length_unit_id | ||||||||||||||||
| SOURCE | digitizing_base_id | NUMBER | NULL | SOURCE_FEATURE | d_digitizing_base_id | ||||||||||||||||
| SOURCE | digitizing_com | VARCHAR2(1000) | NULL | SOURCE_FEATURE | digitizing_com | ||||||||||||||||
| SOURCE | mapping_com | VARCHAR2(1000) | NULL | SOURCE_FEATURE | mapping_com | ||||||||||||||||
| SOURCE | independent_source_feature | CHAR(1) | NOT NULL | SOURCE_FEATURE | independent_source_feature_ind | ||||||||||||||||
| SOURCE | rec_create_user | VARCHAR2(30) | NOT NULL | SOURCE_FEATURE | rec_create_user | ||||||||||||||||
| SOURCE | rec_last_mod_user | VARCHAR2(30) | NULL | SOURCE_FEATURE | rec_last_mod_user | ||||||||||||||||
| SOURCE_FEATURE_WL_VW | SOURCE_FEATURE.D_CONC_FEATURE_TYPE_ID = D_CONC_FEATURE_TYPE.D_CONC_FEATURE_TYPE_ID AND SOURCE_FEATURE.D_LOC_UNCERTAINTY_TYPE_ID = D_LOC_UNCERTAINTY_TYPE.D_LOC_UNCERTAINTY_TYPE_ID AND SOURCE_FEATURE.LOC_UNCERTAINTY_UNIT | ID | SOURCE_FEATURE.SOURCE_FEATURE_ID | ||||||||||||||||||
| SOURCE_FEATURE_WL_VW | SOURCE_FEATURE.D_CONC_FEATURE_TYPE_ID = D_CONC_FEATURE_TYPE.D_CONC_FEATURE_TYPE_ID AND SOURCE_FEATURE.D_LOC_UNCERTAINTY_TYPE_ID = D_LOC_UNCERTAINTY_TYPE.D_LOC_UNCERTAINTY_TYPE_ID AND SOURCE_FEATURE.LOC_UNCERTAINTY_UNIT | SUBNATIONAL_SCIENTIFIC_NAME | SCIENTIFIC_NAME.SCIENTIFIC_NAME | ||||||||||||||||||
| SOURCE_FEATURE_WL_VW | SOURCE_FEATURE.D_CONC_FEATURE_TYPE_ID = D_CONC_FEATURE_TYPE.D_CONC_FEATURE_TYPE_ID AND SOURCE_FEATURE.D_LOC_UNCERTAINTY_TYPE_ID = D_LOC_UNCERTAINTY_TYPE.D_LOC_UNCERTAINTY_TYPE_ID AND SOURCE_FEATURE.LOC_UNCERTAINTY_UNIT | SOURCE_FEATURE_DESCRIPTOR | SOURCE_FEATURE.SOURCE_FEATURE_DESCRIPTOR | ||||||||||||||||||
| SOURCE_FEATURE_WL_VW | SOURCE_FEATURE.D_CONC_FEATURE_TYPE_ID = D_CONC_FEATURE_TYPE.D_CONC_FEATURE_TYPE_ID AND SOURCE_FEATURE.D_LOC_UNCERTAINTY_TYPE_ID = D_LOC_UNCERTAINTY_TYPE.D_LOC_UNCERTAINTY_TYPE_ID AND SOURCE_FEATURE.LOC_UNCERTAINTY_UNIT | SOURCE_FEATURE_LOCATOR | SOURCE_FEATURE.SOURCE_FEATURE_LOCATOR | ||||||||||||||||||
| SOURCE_FEATURE_WL_VW | SOURCE_FEATURE.D_CONC_FEATURE_TYPE_ID = D_CONC_FEATURE_TYPE.D_CONC_FEATURE_TYPE_ID AND SOURCE_FEATURE.D_LOC_UNCERTAINTY_TYPE_ID = D_LOC_UNCERTAINTY_TYPE.D_LOC_UNCERTAINTY_TYPE_ID AND SOURCE_FEATURE.LOC_UNCERTAINTY_UNIT | CONCEPTUAL_TYPE | D_CONC_FEATURE_TYPE.CONC_FEATURE_TYPE_DESC | ||||||||||||||||||
| SOURCE_FEATURE_WL_VW | SOURCE_FEATURE.D_CONC_FEATURE_TYPE_ID = D_CONC_FEATURE_TYPE.D_CONC_FEATURE_TYPE_ID AND SOURCE_FEATURE.D_LOC_UNCERTAINTY_TYPE_ID = D_LOC_UNCERTAINTY_TYPE.D_LOC_UNCERTAINTY_TYPE_ID AND SOURCE_FEATURE.LOC_UNCERTAINTY_UNIT | UNCERTAINTY_TYPE | D_LOC_UNCERTAINTY_TYPE.LOC_UNCERTAINTY_TYPE_DESC | ||||||||||||||||||
| SOURCE_FEATURE_WL_VW | SOURCE_FEATURE.D_CONC_FEATURE_TYPE_ID = D_CONC_FEATURE_TYPE.D_CONC_FEATURE_TYPE_ID AND SOURCE_FEATURE.D_LOC_UNCERTAINTY_TYPE_ID = D_LOC_UNCERTAINTY_TYPE.D_LOC_UNCERTAINTY_TYPE_ID AND SOURCE_FEATURE.LOC_UNCERTAINTY_UNIT | UNCERTAINTY_DISTANCE | SOURCE_FEATURE.LOC_UNCERTAINTY_DISTANCE | ||||||||||||||||||
| SOURCE_FEATURE_WL_VW | SOURCE_FEATURE.D_CONC_FEATURE_TYPE_ID = D_CONC_FEATURE_TYPE.D_CONC_FEATURE_TYPE_ID AND SOURCE_FEATURE.D_LOC_UNCERTAINTY_TYPE_ID = D_LOC_UNCERTAINTY_TYPE.D_LOC_UNCERTAINTY_TYPE_ID AND SOURCE_FEATURE.LOC_UNCERTAINTY_UNIT | UNIT_DESCRIPTION | D_UNIT.UNIT_DESC | ||||||||||||||||||
| SOURCE_FEATURE_WL_VW | SOURCE_FEATURE.D_CONC_FEATURE_TYPE_ID = D_CONC_FEATURE_TYPE.D_CONC_FEATURE_TYPE_ID AND SOURCE_FEATURE.D_LOC_UNCERTAINTY_TYPE_ID = D_LOC_UNCERTAINTY_TYPE.D_LOC_UNCERTAINTY_TYPE_ID AND SOURCE_FEATURE.LOC_UNCERTAINTY_UNIT | LOCATION_USE_CLASS | D_LOCATION_USE_CLASS.LOCATION_USE_CLASS_DESC | ||||||||||||||||||
| SOURCE_FEATURE_WL_VW | SOURCE_FEATURE.D_CONC_FEATURE_TYPE_ID = D_CONC_FEATURE_TYPE.D_CONC_FEATURE_TYPE_ID AND SOURCE_FEATURE.D_LOC_UNCERTAINTY_TYPE_ID = D_LOC_UNCERTAINTY_TYPE.D_LOC_UNCERTAINTY_TYPE_ID AND SOURCE_FEATURE.LOC_UNCERTAINTY_UNIT | ELEMENT_SUBNATIONAL_ID | SOURCE_FEATURE.ELEMENT_SUBNATIONAL_ID | ||||||||||||||||||