Wildlife Species Inventory - Survey Observation Points - Ungulates - Publicly Available
0 views (0 recent)
Published by the Ministry of Environment and Climate Change Strategy - Knowledge ManagementLicensed under Access Only
Data and Resources
-
BC Geographic Warehouse Custom Downloadother
-
WMS getCapabilities requestwms
For use in viewers such as ESRI tools Click here for information on how to...
-
KML Network Linkkml
For use in viewers such as Google Earth Click here for information on how...
Additional Information
Purpose | The dataset was created to provide better information for wildlife management and the protection of biodiversity. The intent on having a central repository for species inventory data is to facilitate the storage and access of inventory data and results required to make informed management decisions. |
Data Quality | The data presented here only represent those which have been submitted to the Species Inventory (SPI) database and have been quality assured to meet Provincial data standards. This dataset does not represent all wildlife surveys that have been conducted in the Province of BC. |
Lineage Statement | All source data reside in the Species Inventory (SPI) database managed by the Ministry of Environment and Climate Change Strategy |
More Information
Contact Information
Name | Wildlife Species Inventory Mailbox (pointOfContact) |
SPI_Mail@gov.bc.ca | |
Organization | Ministry of Environment and Climate Change Strategy |
Sub-Organization | Knowledge Management |
Name | Jesse Patterson (businessExpert) |
jesse.patterson@gov.bc.ca | |
Organization | Ministry of Environment and Climate Change Strategy |
Sub-Organization | Knowledge Management |
Access & Security
Who can view this dataset? | Public |
Who can download this dataset? | Public |
Metadata Information
Record Published | 2021-01-13 |
Record Last Modified | 2021-02-24 |
Resource Status | onGoing |
Spatial Data | SDO_GEOMETRY |
Object Description
Object Name: WHSE_WILDLIFE_INVENTORY.SPI_SRVY_OBS_UNG_SV
Short Name: SRVOBSUNG
Comments: The Wildlife Species Inventory spatial view of survey observations of ungulates that originate from the Species Inventory (SPI) database. Spatial view of survey observations is split into the "Secured" layer and the "Publicly Available" layer. This is the publicly available layer. Survey observations are recorded on the Animal Observation forms, and may include information such as species, sex, age class, numbers of individuals, point locations, behaviours, and survey conditions. This is a point layer.
Column Name | Short Name | Data Type | Data Precision | Comments |
---|---|---|---|---|
SURVEY_OBSERVATION_ID | SRVY_BS_ID | NUMBER | 10 | A unique identifier for a survey observation in the SPI database as supplied by the business area which is used as the primary key. |
SECURED_IND | SCRD_ND | VARCHAR2 | 3 | A Yes/No indicating whether this record should be secured based on the provincial Species and Ecosystems Data and Information Security policy or not. |
PERSECUTION_OR_HARM_IND | PRSCTN_R_D | VARCHAR2 | 3 | A Yes/No indicating whether this record is secured due to Persecution or Harm reasons of the provincial Species and Ecosystems Data and Information Security policy. |
FEDERAL_OR_PROV_STATUTE_IND | FDRL_R_PRD | VARCHAR2 | 3 | A Yes/No indicating whether this record is secured due to Federal and Provincial Statute reasons of the provincial Species and Ecosystems Data and Information Security policy. |
GOVERNMENT_INTEREST_IND | GVRNMNT_ND | VARCHAR2 | 3 | A Yes/No indicating whether this record is secured due to Government Interest reasons of the provincial Species and Ecosystems Data and Information Security policy. |
PROPRIETARY_IND | PRPRTRY_ND | VARCHAR2 | 3 | A Yes/No indicating whether this record is secured due to Proprietary reasons of the provincial Species and Ecosystems Data and Information Security policy. |
SPI_PROJECT_ID | SP_PRJC_ID | NUMBER | 10 | The numeric identifier for an inventory project. |
PROJECT_NAME | PROJECT_NM | VARCHAR2 | 200 | The name of the species inventory project, e.g., 1976-ongoing - Roosevelt Elk - Census - Vancouver Island - West Coast Region. |
PROJECT_WEB_PAGE_URL | PRJCT_WB_L | VARCHAR2 | 255 | A link to a web page with information about the project, e.g., http://a100.gov.bc.ca/pub/siwe/details.do?projectId=655. |
REGION_CODE | REGION_CD | VARCHAR2 | 25 | A code indicating the region that has primary responsible for the project, e.g., 3. |
REGION_NAME | REGION_NM | VARCHAR2 | 200 | The name of the region that has primary responsible for the project, e.g., Thompson. |
STUDY_AREA_NAME | STDY_R_NM | VARCHAR2 | 100 | A descriptive name of the Study-Area, e.g., North Thompson Watershed. |
STUDY_AREA_ID | STDY_R_ID | NUMBER | 10 | A system-generated numerical identifier for a study area. |
POPULATION_UNIT_ECOTYPE | PPLTN_NT_E | VARCHAR2 | 50 | The ecotype of the species' population. (e.g., Caribou). An ecotype is a grouping of species' populations based on ecological conditions and behavioral adaptations. e.g., Caribou ecotypes include boreal, northern mountain, southern mountain (southern, northern, or central) |
POPULATION_UNIT_ID | PPLTN_N_ID | NUMBER | 10 | The numeric identifier indicating the species' population unit (e.g., 26). Population unit is a generic term for a provincially defined, geographically discrete population of a species. e.g., for grizzly bear they are called 'population units'; for caribou they are called 'herds'; for moose they are called 'game-management zones'. |
POPULATION_UNIT_NAME | PPLTN_NT_M | VARCHAR2 | 50 | The name of the species' population unit (e.g., Snake-Sahtaneh). Population unit is a generic term for a provincially defined, geographically discrete population of a species. e.g., for grizzly bear they are called 'population units'; for caribou they are called 'herds'; for moose they are called 'game-management zones'. |
POPULATION_UNIT_CODE | PPLTN_NT_D | VARCHAR2 | 25 | A code indicating the species' population unit (e.g., SnSa). Population unit is a generic term for a provincially defined, geographically discrete population of a species. e.g., for grizzly bear they are called ‘population units'; for caribou they are called 'herds'; for moose they are called 'game-management zones'. |
DESIGN_COMPONENT_LABEL | DSG_CPT_LB | VARCHAR2 | 50 | A unique label for each design component in a Project, e.g., Block 2, Transect 4, Sample Station 8, Grid Cell 23. |
DESIGN_COMPONENT_TYPE_CD | DSGN_CMPND | VARCHAR2 | 25 | A code indicating the type of design component, e.g., TRANSECT. |
DESIGN_COMPONENT_TYPE_DEFN_URL | DSG_CPT_RL | VARCHAR2 | 255 | A link to a full definition of the design component type. |
DESIGN_COMPONENT_ID | DSGN_CM_ID | NUMBER | 10 | A system-generated numerical identifier for a design component. |
PARENT_DESIGN_COMPONENT_LABEL | PRNT_DSGNL | VARCHAR2 | 50 | The label of the 'parent' design component; it is the label of the design component within which a design component is nested; it is the label of the design component that is one hierarchical level higher. If design components are not nested, this will be empty. |
PROJECT_LOCATION_DESCRIPTION | PRJCT_LCTN | VARCHAR2 | 2000 | A description of the project location with gazetted place names. |
SURVEY_ID | SURVEY_ID | NUMBER | 10 | A system-generated numerical identifier for a survey. |
SURVEY_NAME | SURVEY_NM | VARCHAR2 | 100 | The name of the survey as assigned by the project leader, e.g., 2006 Maxhamish Range Boreal Caribou Inventory. |
SURVEY_WEB_PAGE_URL | SRVY_WB_PL | VARCHAR2 | 255 | A link to a web page with information about the survey. |
SURVEY_METHOD | SRVY_MTHD | VARCHAR2 | 25 | A description of the methodology used to survey a species or species group, e.g., aerial late winter recruitment; aerial census ¿ SRB; mark-recapture. |
SURVEY_INTENSITY_CODE | SRVY_NTNSD | VARCHAR2 | 25 | A code indicating the level of species-presence information to be derived from the survey, e.g., PN. |
SURVEY_INTENSITY_NAME | SRVY_NTNSM | VARCHAR2 | 200 | The level of species-presence information to be derived from the survey, e.g., Presence/Not detected (possible). |
SURVEY_INTENSITY_DEFN_URL | SRVY_NTNSL | VARCHAR2 | 255 | A link to a full definition of the survey intensity. |
SURVEY_TARGET_SPECIES | SRVY_TRGTS | VARCHAR2 | 4000 | A comma-separated-values list of species codes representing the species that were targeted during this survey. |
OBSERVATION_DATETIME | OBSRVTN_DE | DATE | 7 | The date and time that a species was observed. |
OBSERVATION_YEAR | OBSRVTN_YR | NUMBER | 4 | The year, in 4-digit format, that a species was observed. |
OBSERVATION_MONTH | OBSRVTN_MH | NUMBER | 2 | The month (1 through 12) that a species was observed. |
OBSERVATION_DAY | OBSRVTN_DY | NUMBER | 2 | The day (1 through 31) that a species was observed. |
UTM_ZONE | UTM_ZONE | NUMBER | 4 | A segment of the Earth's surface 6 degrees of longitude in width. The zones are numbered eastward starting at the meridian 180 degrees from the prime meridian at Greenwich. There are five zones numbered 7 through 11 that cover British Columbia, e.g., Zone 10 with a central meridian at -123 degrees. |
UTM_EASTING | UTM_EAST | NUMBER | 6 | The distance in meters eastward to or from the central meridian of a UTM zone with a false easting of 500000 meters. |
UTM_NORTHING | UTM_NORTH | NUMBER | 7 | The distance in meters northward from the equator. |
LONGITUDE_DD | LNGTD_DD | NUMBER | 8 | The longitude coordinate of the observation in decimal degrees, e.g., -123.56921. |
LATITUDE_DD | LTTD_DD | NUMBER | 8 | The latitude coordinate of the observation in decimal degrees, e.g., 49.58947. |
GEOGRAPHIC_COORDINATE_SOURCE | GGRPHC_CRE | VARCHAR2 | 25 | The geographic point from which the geographic coordinates were derived. E.g. 'Study Area' indicates the coordinates were derived from the centroid of a study area. 'Design Component' indicates the coordinates were derived from the centroid of a design component. 'Survey Observation' indicates the coordinates were derived from a survey observation point. |
SPECIES_CODE | SPECIES_CD | VARCHAR2 | 35 | A standardized code used to identify a species or taxa, e.g., M-RATA. |
SPECIES_ENGLISH_NAME | SPCS_NGLSM | VARCHAR2 | 50 | The common English name of the species or taxon, e.g., Caribou. |
SPECIES_SCIENTIFIC_NAME | SPCS_SCNTM | VARCHAR2 | 150 | The standardized scientific name of the species or taxa, e.g., Rangifer tarandus. |
OBSERVED_NUMBER | OBSRVD_NMR | NUMBER | 5 | The number of individuals of all life stages. Alternatively, a count of 1 (one) may mean that details about numbers are recorded in other columns. For more information, see reports on the project's web page. |
SEX_CODE | SEX_CD | VARCHAR2 | 25 | A code indicating the sex of the individual, e.g., M. |
SEX_NAME | SEX_NM | VARCHAR2 | 200 | The sex of the individual, e.g., Male. |
SEX_DEFN_URL | SX_DFN_RL | VARCHAR2 | 255 | A link to a full definition of sex. |
LIFE_STAGE_CODE | LF_STG_CD | VARCHAR2 | 25 | A code indicating the life stage of the individual, e.g., A code indicating the life stage of the individual, e.g., A. |
LIFE_STAGE_NAME | LF_STG_NM | VARCHAR2 | 200 | The life stage of the individual, e.g., Adult. |
LIFE_STAGE_DEFN_URL | LF_STG_DFL | VARCHAR2 | 255 | A link to a full definition of life stage. |
FEMALES_ADULT | FMLS_DLT | NUMBER | 5 | The number of adult females. |
MALES_ADULT | MLS_DLT | NUMBER | 5 | The number of adult males. |
UNCLASSIFIED_SEX_ADULT | UNCLSSFD_T | NUMBER | 5 | The number of adults of unclassified sex. |
FEMALES_JUVENILE | FMLS_JVNLE | NUMBER | 5 | The number of juvenile females observed. |
MALES_JUVENILE | MLS_JVNLE | NUMBER | 5 | The number of juvenile males observed. |
UNCLASSIFIED_SEX_JUVENILE | UNCLSSFD_E | NUMBER | 5 | The number of juveniles of unclassified sex observed. |
FEMALES_YEARLING | FMLS_YRLNG | NUMBER | 5 | The number of yearling females. A yearling is an individual that is one year, or almost one year old; individual has lived through one winter season. |
MALES_YEARLING | MLS_YRLNG | NUMBER | 5 | The number of yearling males. A yearling is an individual that is one year, or almost one year old; individual has lived through one winter season. |
UNCLASSIFIED_SEX_YEARLINGS | UNCLSSFD_S | NUMBER | 5 | The number of yearlings of unclassified sex. A yearling is an individual that is one year, or almost one year old; individual has lived through one winter season. |
UNCLASSIFIED_SEX_YOUNG_OF_YEAR | UNCLSSFD_R | NUMBER | 5 | The number of Young of Year of unclassified sex. Young of Year are individuals less than one year old and have not yet lived through a winter season. |
UNCLASS_LIFE_STAGE_AND_SEX | UNCLSS_LFX | NUMBER | 5 | The number of individuals of unclassified life stage and unclassified sex. I.e. neither life stage nor sex is determined. |
MALES_ADULT_3_POINT_OR_FEWER | MLS_DLT_3R | NUMBER | 5 | The number of adult males with 3 points or fewer on one antler. |
MALES_ADULT_3_OR_4_POINTS | MLS_DLT_3S | NUMBER | 5 | The number of adult males with at least 3 or 4 points on one antler. |
MALES_ADULT_4_POINTS_OR_MORE | MLS_DLT_4E | NUMBER | 5 | The number of adult males with at least 4 points or more on one antler. |
MALES_ADULT_5_POINTS_OR_MORE | MLS_DLT_5E | NUMBER | 5 | The number of adult males with at least 5 points or more on one antler. |
MALES_ADULT_6_POINTS_OR_MORE | MLS_DLT_6E | NUMBER | 5 | The number of adult males having at least 6 points or more on one antler. |
MALES_ADULT_10_POINT_TRIPALM | MLS_DLT_1M | NUMBER | 5 | The number of bull MOOSE having at least one antler with a minimum of ten points (tines), including the tines on the brow palm. Tripalm means bull moose having at least one antler with a brow palm bearing three or more points (tines). The brow palm is separated from the main palm by the deepest antler bay. The deepest bay is the bay whose vertex (deepest location) is the shortest distance from the antler base, when measured along the surface of the antler. Tripalm means bull moose having at least one antler with a brow palm bearing three or more points (tines). The brow palm is separated from the main palm by the deepest antler bay. The deepest bay is the bay whose vertex (deepest location) is the shortest distance from the antler base, when measured along the surface of the antler. |
MALES_CLASS_ONE | MLS_CLSS_1 | NUMBER | 5 | The number of Class I male ungulates. |
MALES_CLASS_TWO | MLS_CLSS_O | NUMBER | 5 | The number of Class II male ungulates. |
MALES_CLASS_THREE | MLS_CLSS_3 | NUMBER | 5 | The number of class III ungulates. |
MALES_CLASS_FOUR | MLS_CLSS_4 | NUMBER | 5 | The number of class IV male ungulates. |
RAGHORNS_CLASS_ONE_OR_TWO | RGHRNS_CLO | NUMBER | 5 | The number of ELK (Rocky Mountain or Roosevelt) with either small or large antlers with 3 or 4 points, and/or small spindly 5 point antlers. |
MALES_CLASS_THREE_OR_FOUR | MLS_CLSS_R | NUMBER | 5 | The number of adult males with large 5 point antler, 6 or more point antler, heavy antlers, massive. |
MALES_MATURE | MLS_MTRE | NUMBER | 5 | The number of mature male ungulates. |
FEMALES_TWO_YEARS_OLD | FMLS_TW_YD | NUMBER | 5 | The number of 2 year old females. A 2-year-old is an individual that is two years, or almost two years old; individual has lived through two winter seasons. |
MALES_TWO_YEARS_OLD | MLS_TW_YRD | NUMBER | 5 | The number of 2 year old males. A 2-year-old is an individual that is two years, or almost two years old; individual has lived through two winter seasons. |
UNCLASSIFIED_SEX_TWO_YEARS_OLD | UNCLSSFD_D | NUMBER | 5 | The number of 2 year old individuals of unclassified sex. A 2-year-old is an individual that is two years, or almost two years old; individual has lived through two winter seasons. |
FEMALES_UNCLASS_LIFE_STAGE | FMLS_NCLSE | NUMBER | 5 | The number of females of unclassified life stage. |
MALES_UNCLASS_LIFE_STAGE | MLS_NCLSSE | NUMBER | 5 | The number of males of unclassified life stage. |
FEMALES_YEARLINGMALES_LAMBS | FMLS_YRLNS | NUMBER | 5 | The number of females, yearling males, and lambs. |
YEARLINGS_AND_EWES | YRLNGS_NDS | NUMBER | 5 | The number of yearlings, and ewes. |
ANIMAL_ID | ANIMAL_ID | VARCHAR2 | 100 | A unique identifier permanently assigned to an animal. e.g., W40 |
ANIMAL_ID_TEMPORARY_LABEL | ANML_D_TML | VARCHAR2 | 100 | A unique identification label assigned to track an individual animal detected more than once during the course of a Design Component Visit, e.g., T40. |
GROUP_LABEL | GRP_LBL | VARCHAR2 | 100 | A unique identification label assigned to track a group of animals detected more than once during the course of a Design Component Visit, e.g., G25. |
DETECTION_CODE | DTCTN_CD | VARCHAR2 | 25 | A code indicating the method or reason the individual, group, or sign was detected, e.g., CA. |
DETECTION_NAME | DTCTN_NM | VARCHAR2 | 200 | The method or reason the individual, group, or sign was detected, e.g., Call. |
DETECTION_DEFN_URL | DTCTN_DFNL | VARCHAR2 | 255 | A link to a full definition of detection. |
ACTIVITY_CODE | ACTVTY_CD | VARCHAR2 | 25 | A code indicating the activity of the animal when it was first detected or the activity that caused the sign, e.g., GR. |
ACTIVITY_NAME | ACTVTY_NM | VARCHAR2 | 200 | The activity of the animal when it was first detected or the activity that caused the sign, e.g., Grooming. |
ACTIVITY_DEFN_URL | ACTVTY_DFL | VARCHAR2 | 255 | A link to a full definition of activity. |
ACTIVITY_COUNT | ACTVTY_CNT | NUMBER | 5 | The number of animals doing the activity, or number of sign elements made by the activity. |
ACTIVITY_DESCRIPTION_CODE | ACTVTY_DSD | VARCHAR2 | 25 | A code indicating whether the animal was seen or heard, or indicating the probable age or season of the sign, e.g., S. |
ACTIVITY_DESCRIPTION_NAME | ACTVTY_DSM | VARCHAR2 | 200 | An indication of whether the animal was seen or heard, or indicating the probable age or season of the sign, e.g., Seen. |
ACTIVITY_DESCRIPTION_DEFN_URL | ACTVTY_DSL | VARCHAR2 | 255 | A link to a full definition of activity description. |
SIGN_COUNT | SIGN_COUNT | NUMBER | 5 | The number of sign. For more information, see reports on the project's web page. |
SIGN_SAMPLE_AGE_CODE | SGN_SMPL_D | VARCHAR2 | 25 | A code indicating the age of the sign or the age of the sample, e.g., W. |
SIGN_SAMPLE_AGE_NAME | SGN_SMPL_M | VARCHAR2 | 200 | The age of the sign or the age of the sample, e.g., Week. |
SIGN_SAMPLE_AGE_DEFN_URL | SGN_SMPL_L | VARCHAR2 | 255 | A link to a full definition of sign age or sample age. |
SIGN_CODE | SIGN_CD | VARCHAR2 | 25 | A code indicating the animal sign detected, e.g., HA. |
SIGN_NAME | SIGN_NM | VARCHAR2 | 200 | The animal sign detected, e.g., Hair. |
SIGN_DEFN_URL | SGN_DFN_RL | VARCHAR2 | 255 | A link to a full definition of sign. |
PELLET_GROUP_COUNT | PLLT_GRP_T | NUMBER | 5 | The total count of the number of pellet groups in a plot, for a given species. |
VEGETATION_COVER_PERCENT | VGTTN_CVRT | NUMBER | 3 | The percent of ground that is covered by average canopy cover that restricts species visibility. Measured within a 10 m radius of the individual or group detected. Any vegetation that blocks the observers' view is considered part of the canopy. |
SNOW_COVER_PERCENT | SNW_CVR_PT | NUMBER | 3 | The percent of the ground surface that is covered by snow. Measured within a 10 m radius of the individual or group detected. |
MACROHABITAT_CODE | MCRHBTT_CD | VARCHAR2 | 25 | A code indicating the macrohabitat feature the individual or group was found in association with., e.g., LA |
MACROHABITAT_NAME | MCRHBTT_NM | VARCHAR2 | 200 | The macrohabitat feature the individual or group was found in association with, e.g., Lake. |
MACROHABITAT_DEFN_URL | MCRHBTT_DL | VARCHAR2 | 255 | A link to a full definition of macrohabitat. |
SC_START_AIR_TEMPERATURE | SC_STRT_RE | NUMBER | 5 | The air temperature in degrees Celsius at the start of a visit to a design component. |
SC_START_WIND_SPEED_CD | SC_STRT_WD | VARCHAR2 | 25 | A code indicating the strength of the wind using the Beaufort Scale, at the start of a visit to a design component, e.g., 1. |
SC_START_WIND_SPEED_NAME | SC_STRT_WM | VARCHAR2 | 200 | The strength of the wind using the Beaufort Scale, at the start of a visit to a design component, e.g., Light Air. |
SC_START_WIND_SPEED_DEFN_URL | SC_STRT_WL | VARCHAR2 | 255 | A link to a full definition of wind speed. |
SC_START_CLOUD_COVER_CD | SC_STRT_CD | VARCHAR2 | 25 | A code indicating the cloud cover at the start of a visit to a design component, e.g., 1. |
SC_START_CLOUD_COVER_NAME | SC_STRT_CM | VARCHAR2 | 200 | The cloud cover at the start of a visit to a design component, e.g., Clear. |
SC_START_CLOUD_COVER_DEFN_URL | SC_STRT_CL | VARCHAR2 | 255 | A link to a full definition of cloud cover. |
SC_STRT_PRECIPITATION_CD | SC_STRT_PD | VARCHAR2 | 25 | A code indicating the precipitation occurring at the start of a visit to a design component, e.g., LR. |
SC_STRT_PRECIPITATION_NAME | SC_STRT_PM | VARCHAR2 | 200 | The precipitation occurring at the start of a visit to a design component, e.g., Light Rain. |
SC_STRT_PRECIPITATION_DEFN_URL | SC_STRT_PL | VARCHAR2 | 255 | A link to a full definition of precipitation. |
FIELD_OBSERVER_NAME | FLD_BSRVRM | VARCHAR2 | 80 | The name of the observer. |
PROJECT_COORDINATOR | PRJCT_CRDR | VARCHAR2 | 70 | The full name of the coordinator for this project. |
FUNDING_SOURCES | FNDNG_SRCS | VARCHAR2 | 255 | A list of a project's funding agencies and the funding agencies' identifiers for a project. Within a funding agency, the agencies' identifiers are separated by commas, e.g. 3A11-6, 4B64-8. Differing funding agencies are separated by pipes (i.e. |). A full example is "FIA: 2654013, 2773008 | FRBC: 208-KBM98411-716658, 208-KBM98511-716653" |
PROJECT_START_DATE | PRJCT_STRE | DATE | 7 | The date the project started. |
PROJECT_END_DATE | PRJCT_ND_E | DATE | 7 | The date the project ended. |
SURVEY_START_DATE | SRVY_STRTE | DATE | 7 | The date the survey started. |
SURVEY_OBSERVATION_NOTE | SRVY_BSRVE | VARCHAR2 | 2000 | Additional information regarding the survey observation. |
METHOD_TYPE_CD | MTHD_TYP_D | VARCHAR2 | 50 | A code indicating the species-method-type used for a survey. A species-method-type is a predefined group of data-fields useful for collecting data from surveys of a particular species, or group of species, using a particular survey method, e.g., Raptor Call Playback. |
VERSION_NO | VERSION_NO | NUMBER | 5 | The version number of the species-method-type used for a survey, e.g., 1.1. |
SHAPE | SHAPE | SDO_GEOMETRY | 64 | SHAPE is the column used to reference the spatial coordinates defining the feature. |
OBJECTID | OBJECTID | NUMBER | 38 | A column required by spatial layers that interact with ESRI ArcSDE. It is populated with unique values automatically by SDE. |
SE_ANNO_CAD_DATA | BLOB | 4000 | A binary column used by spatial tools to store annotation, curve features and CAD data when using the SDO_GEOMETRY storage data type. |