All notable changes to this project will be documented in this file.
The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.
- PIPELINE-328: Adds Dockerfile: Update google sdk version Refactor import to Postgres script to use import instead of the copy command DAGs: Configure the new parameters required Assets: Remove unnecessary properties and statements.
- GlobalFishingWatch/gfw-eng-tasks#206: removes the gaps query that it was marked as deprecated and are not in use.
- GlobalFishingWatch/gfw-eng-tasks#39: Adds support to python3.7 and pipe-tools:v3.1.1 and pin ujson:1.35
- Added the
SAFE.
in the BQ fishing event scripts since with some coordinates for VMS it was throwing theresults in precision loss of more than 1mm
error.
- 1125: Adds a flag to indicate if we want to publish the results on postgres.
- 33: Improved the id generation hash to be unique by including both of the vessel ids and the start and end times. Previous version used only one vessel id and start time.
- 1100: Adds Supports the handler of FlexibleOperator. Also moves the pipe-events subdags to independent dags. and converts each operator to a KubernetesPodOperator.
- 1070: Bugfixes ship names encoded to unicode.
- 1007: Restores the cloudsql configuration options and code since google just released a new version of their postgres offering which includes cloudsql. This requires new configuration options, check the README.md for more information
- 1005: Adds more vessel information embedded in the event. It now includes ssvid in addition to name and vessel id.
- 926: Adds basic information about related entities on events. For example, fishing events now include vessel name, ports contain the port label, and so on. Removes configuration options for cloudsql, since we are now using a custom postgres database. This requires new configuration options, see the README.md for more information.
- 926: Introduces yearly mode to the events pipe.
- GlobalFishingWatch/GFW-Tasks#991
- Migrates to use the new airflow-gfw library and use the pipe-tools v2.0.0
-
#944: Adds various indices to the postgis tables.
-
#895: Gaps and port events now come as a single event for each on-off / in-out raw combination.
-
#921: All event types are now imported to postgis.
-
#862: Implements postgres event publication. Requires new airflow variables:
pipe_events.postgres_instance
,pipe_events.postgres_connection_string
and onepostgres_table
variable for each event type subpipeline. See the README for more information. -
#18: Include the
encountered_vessel_id
in theevent_info
for encounters. -
#22: Fix a bug in fishing events where events crossing the dateline had the wrong min/max/avg for longitude
- Hotfixes fishing events that had a null
event_end
field when the event finished at the end of a given day.
- #828: Adds the
publication of the rest of the event types into this pipeline. Bump version
of pipe-tools to 0.2.0 Requires a new global airflow variable,
INFERENCE_BUFFER_DAYS
, which contains the number of days the fishing events might have to be updated in the past due to inference buffering. Changes the schema of the events table, removing some field duplication (bothtimestamp
andevent_start
meant the same) and adding a newevent_geography
column, which is a GIS column allowing geospatial queries.
- #5: Updates pipe-tools to v0.1.6. Fixes gap events when running monthly mode.
- Initial release