enriched_deployment¶
Info¶
Data contract for the Deployment table of the media domain of the Biocloud. Contains information about sensor deployments in the field, including location and temporal extent. - name: Deployment - version: 0.0.1 - status: active
Terms of Use¶
Purpose¶
Data contract for the Deployment table of the media domain of the Biocloud. Contains information about sensor deployments in the field, including location and temporal extent.
Servers¶
| Name | Type | Attributes |
|---|---|---|
| production | databricks | No description. • environment: production • roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}] • catalog: media_production • host: dbc-2030845a-6c3b.cloud.databricks.com • schema_: enriched |
| development | databricks | No description. • environment: development • roles: [{'role': 'Admins', 'description': 'Access to all the data and settings'}] • catalog: media_development • host: dbc-03ed8bbb-c0ec.cloud.databricks.com • schema_: enriched |
Schema¶
deployment¶
The deployment table contains information about sensor deployments. A deployment represents a specific sensor installed at a specific location for a specific time period. This table must be processed after the sensor table.
| Field | Type | Attributes |
|---|---|---|
| deployment_id | bigint | Biocloud generated identifier for the deployment. • primaryKey• primaryKeyPosition: 1 • required |
| sensor_golden_id | bigint | Foreign key to the sensor table, linking to the sensor device used in this deployment. |
| sensor_name | string | Name of the sensor used in this deployment. • examples: ['DIOPSIS-212', 'DIOPSIS-302'] |
| name | string | Name or identifier for this specific deployment. • examples: ['Site_A_Summer_2024', 'Urban_Park_Deploy_01'] |
| decimal_latitude | decimal(8, 5) | Latitude of deployment location in decimal degrees, using WGS84 datum. • examples: [52.0907, -3.7533] |
| decimal_longitude | decimal(8, 5) | Longitude of deployment location in decimal degrees, using WGS84 datum. • examples: [5.1214, -3.7533] |
| start_ts_utc | timestamp | UTC timestamp when the deployment started. |
| end_ts_utc | timestamp | UTC timestamp when the deployment ended. |
| sensor_orientation | string | Orientation of the sensor in the field. • examples: ['north', 'south', 'horizontal', 'vertical'] |
| screen_orientation | string | Placement orientation of screen if used. • examples: ['horizontal', 'vertical', 'tilted'] |
| sensor_height_m | decimal(10, 5) | Height of the sensor from the ground in meters. • examples: [1.5, 2.0, 0.5] |
| bait | boolean | Whether bait or attractant was used in this deployment. |
| screen_color | string | Color of screen if used (e.g., for insect attraction). • examples: ['white', 'yellow', 'blue'] |
| source_id | string | The ID of this record in the source system. • required |
| source | string | The name of the source system used to create this record in the table. • required• examples: ['diopsis', 'faunabit', 'diopsis_v1'] |
| emails_hashed | array | Hashed email addresses of users with permissions on this deployment. |
| ↳ items | string | No description. |
| inserted_ts_utc | timestamp | UTC timestamp when record was inserted. |
| updated_ts_utc | timestamp | UTC timestamp when record was last updated. |