Ecosyste.ms: Issues

An open API service for providing issue and pull request metadata for open source projects.

GitHub / GlobalFishingWatch/pipe-events issues and pull requests

#107 - Truncates the data when filtering incremental fishing merged results

Pull Request - State: closed - Opened by smpiano 20 days ago - 2 comments

#106 - PIPELINE-2387. Fishing events. Import data for fishing events less re…

Pull Request - State: closed - Opened by aperdizs about 2 months ago

#105 - Adds creation of the restricted view

Pull Request - State: closed - Opened by smpiano 3 months ago - 1 comment

#104 - Daily and night fishing events incremental implementation by Chris

Pull Request - State: closed - Opened by smpiano 4 months ago - 4 comments

#103 - Master

Pull Request - State: closed - Opened by rrequero 4 months ago

#102 - VV-650 implemented v2 of port visits with pipe3

Pull Request - State: closed - Opened by rrequero 4 months ago - 1 comment

#101 - Update project

Pull Request - State: closed - Opened by smpiano 4 months ago - 1 comment

#100 - API-938. Pull shipname from vessel source instead of segmen info tabl…

Pull Request - State: closed - Opened by aperdizs 6 months ago - 1 comment

#99 - API-938. Pull shipname from vessel source instead of segmen info tabl…

Pull Request - State: closed - Opened by aperdizs 6 months ago - 1 comment

#98 - Api 854 implement changes for pipe 2 5

Pull Request - State: closed - Opened by aperdizs 8 months ago - 1 comment

#97 - API-854. fishing vessels. Adapt the process to generate fishing event…

Pull Request - State: closed - Opened by aperdizs 8 months ago - 1 comment

#96 - PIPELINE-1934. Add clean_segs condition to the queries

Pull Request - State: closed - Opened by aperdizs 9 months ago

#95 - Implement descriptions and schema for pipe 3 tables and views

Pull Request - State: closed - Opened by aperdizs 11 months ago

#94 - API-774 set not_matching_relevant_public_authorization instead of una…

Pull Request - State: closed - Opened by aperdizs about 1 year ago

#93 - Fix query to import fishing events for 2012

Pull Request - State: closed - Opened by aperdizs over 1 year ago

#92 - API-643 rename authorization objects for fishing and encounters v2

Pull Request - State: closed - Opened by aperdizs over 1 year ago

#91 - PIPELINE-1539 update fishing events bug where fishing events missing

Pull Request - State: closed - Opened by aperdizs over 1 year ago

#90 - fix duplicate in join with all_vessels_byyear_v2 table

Pull Request - State: closed - Opened by rrequero over 1 year ago

#89 - fix duplicated fishing events

Pull Request - State: closed - Opened by rrequero over 1 year ago

#88 - Use new docker image base. Remove unnecesary dependencies

Pull Request - State: closed - Opened by aperdizs over 1 year ago

#86 - PIPELINE-1278 Add flag and shiptype for port visit events

Pull Request - State: closed - Opened by aperdizs almost 2 years ago

#85 - API-538 fix typo

Pull Request - State: closed - Opened by rrequero almost 2 years ago

#84 - API-538 add vessel flag in loitering events

Pull Request - State: closed - Opened by rrequero almost 2 years ago

#81 - PIPELINE-1221 calculate fishing events with intersection with track

Pull Request - State: closed - Opened by rrequero almost 2 years ago

#80 - API-489 the authorizations in encounters were overwritten. Use the pr…

Pull Request - State: closed - Opened by aperdizs almost 2 years ago

#79 - API-430 add column seg_id in encounters

Pull Request - State: closed - Opened by rrequero about 2 years ago

#78 - ENG-366 update simple generation

Pull Request - State: closed - Opened by rrequero about 2 years ago

#77 - ENG-366 set partition as month for events tables

Pull Request - State: closed - Opened by rrequero about 2 years ago

#76 - PIPELINE-1019 add new regions added in pipe-regions

Pull Request - State: closed - Opened by rrequero about 2 years ago

#75 - PIPELINE-1019 add new regions in events

Pull Request - State: closed - Opened by rrequero about 2 years ago

#74 - replace append to replace in destination queries

Pull Request - State: closed - Opened by rrequero over 2 years ago

#73 - API-395 standarize to have (at least) flag, vessel_id, type(vesselTyp…

Pull Request - State: closed - Opened by rrequero over 2 years ago

#72 - Fitler using start_time to avoid wrong data at midnight. VV-483

Pull Request - State: closed - Opened by aperdizs over 2 years ago

#71 - API-385 Update queries to use new regions tables

Pull Request - State: closed - Opened by rrequero over 2 years ago - 1 comment

#70 - use regions table of paul

Pull Request - State: closed - Opened by rrequero over 2 years ago

#69 - API-340 Include regions of paul to generate fishing and encounters ev…

Pull Request - State: closed - Opened by rrequero over 2 years ago

#68 - VV-392 add authorizations

Pull Request - State: closed - Opened by rrequero over 2 years ago

#67 - WIP: add authorizations in encounter events

Pull Request - State: closed - Opened by rrequero over 2 years ago

#66 - Use ST_X and ST_Y to extract lat/lon from GEOGRAPHY

Issue - State: open - Opened by tclavelle over 2 years ago

#65 - improve format_gridcode function to fix problem with values near of 0…

Pull Request - State: closed - Opened by rrequero over 2 years ago

#64 - Add is_fishing_vessel condition equal to true. API-236

Pull Request - State: closed - Opened by aperdizs almost 3 years ago

#63 - use all_vessels_by_year table

Pull Request - State: closed - Opened by rrequero almost 3 years ago

#62 - Update loitering events to avoid duplications for 2022 and using all …

Pull Request - State: closed - Opened by aperdizs almost 3 years ago

#61 - Update the code to use the all_vessels_byyear table. PIPELINE-768

Pull Request - State: closed - Opened by aperdizs almost 3 years ago

#60 - Set 2022 as year to classify fishing vessels. PIPELINE-768

Pull Request - State: closed - Opened by aperdizs almost 3 years ago

#59 - Reorder properties to avoid errors unioning tables. PIPELINE-768

Pull Request - State: closed - Opened by aperdizs almost 3 years ago

#58 - Extend fishing vessels table to classify vessels correctly. PIPELINE-768

Pull Request - State: closed - Opened by aperdizs almost 3 years ago

#57 - Feature/pipeline 605 adjust temporal window events

Pull Request - State: closed - Opened by aperdizs about 3 years ago

#56 - Feature/api 136 add vessel class to loitering events

Pull Request - State: closed - Opened by aperdizs about 3 years ago

#55 - Add new condition in the query to avoid losing other vessel info. API-67

Pull Request - State: closed - Opened by aperdizs over 3 years ago

#54 - Update the query to generate encounter events including the vessel cl…

Pull Request - State: closed - Opened by aperdizs over 3 years ago

#53 - Set seg_id as null and includes seg_ids for each vessel on event_vess…

Pull Request - State: closed - Opened by aperdizs over 3 years ago

#52 - PIPELINE-511: Adds noise filters to global loitering events

Pull Request - State: closed - Opened by andres-arana over 3 years ago

#51 - Include seg_id and count_points properties in encounters events. PIPE…

Pull Request - State: closed - Opened by aperdizs over 3 years ago

#50 - Update the process to import encounters using the new schema. PIPELIN…

Pull Request - State: closed - Opened by aperdizs over 3 years ago

#49 - Feature/pipeline 471 update the query and script to create encounters

Pull Request - State: closed - Opened by aperdizs over 3 years ago

#48 - Use OR instead of AND to generate fishing events correctly. PIPELINE-490

Pull Request - State: closed - Opened by aperdizs over 3 years ago

#47 - Feature/improve fishing events script

Pull Request - State: closed - Opened by aperdizs over 3 years ago

#46 - Feature/pipeline 472 add anchorage info to port visits

Pull Request - State: closed - Opened by aperdizs over 3 years ago

#45 - Update the query (fishing events) to improve the performance

Pull Request - State: closed - Opened by aperdizs over 3 years ago

#44 - PIPELINE-459: Latitude and longitude are mixed

Pull Request - State: closed - Opened by andres-arana over 3 years ago

#43 - PIPELINE-458: Various issues with published loitering events

Pull Request - State: closed - Opened by andres-arana over 3 years ago

#42 - Add the process to generate port visits events

Pull Request - State: closed - Opened by aperdizs over 3 years ago

#41 - Feature/ve 66 add loitering events

Pull Request - State: closed - Opened by aperdizs over 3 years ago

#40 - Feature/pipeline 18 upload fishing event

Pull Request - State: closed - Opened by aperdizs over 3 years ago

#39 - Pipeline 328/use psql import instead of copy

Pull Request - State: closed - Opened by aperdizs almost 4 years ago

#38 - Fishing event update 20210401

Pull Request - State: closed - Opened by tclavelle almost 4 years ago

#37 - Removes the gaps query that is deprecated

Pull Request - State: closed - Opened by smpiano about 4 years ago

#36 - Updates pipe-events to py3, pipe-tools:v3.1.1 and ujson:1.35

Pull Request - State: closed - Opened by smpiano almost 5 years ago

#35 - Adds carrier portal queries

Pull Request - State: closed - Opened by andres-arana about 5 years ago - 1 comment

#34 - Includes or not the publish to postgres using a flag

Pull Request - State: closed - Opened by smpiano over 5 years ago

#33 - improve encounter id

Pull Request - State: closed - Opened by bitsofbits over 5 years ago - 1 comment

#32 - Moves subdags to independent dags and inherits the base configuration

Pull Request - State: closed - Opened by smpiano over 5 years ago

#31 - Uses writerows and encodes each char of event_vessel

Pull Request - State: closed - Opened by smpiano over 5 years ago

#30 - CloudSQL

Pull Request - State: closed - Opened by andres-arana almost 6 years ago

#29 - Adds ssvid to embedded vessel information

Pull Request - State: closed - Opened by andres-arana almost 6 years ago

#28 - 926 fishing events shipname

Pull Request - State: closed - Opened by andres-arana almost 6 years ago

#27 - Supports airflow-gfw lib and pipe-tools v2.0.0

Pull Request - State: closed - Opened by smpiano almost 6 years ago

#26 - 943 postgres indices

Pull Request - State: closed - Opened by andres-arana about 6 years ago

#25 - Adds indices to commonly filtered postgres fields

Pull Request - State: closed - Opened by andres-arana about 6 years ago

#24 - 895 Merge events

Pull Request - State: closed - Opened by andres-arana about 6 years ago

#23 - Handle fishing events crossing the dateline

Pull Request - State: closed - Opened by pwoods25443 about 6 years ago

#22 - Event bbox does not handle crossing the anit-meridian

Issue - State: closed - Opened by pwoods25443 about 6 years ago

#21 - 862 - Adds mean position to the postgis import

Pull Request - State: closed - Opened by andres-arana about 6 years ago

#20 - Bugfix for fishing events

Pull Request - State: closed - Opened by pwoods25443 about 6 years ago - 1 comment

#19 - Add encountered vessel

Pull Request - State: closed - Opened by enriquetuya about 6 years ago

#17 - 862 postgis

Pull Request - State: closed - Opened by andres-arana about 6 years ago

#16 - Use best vessel id per segment for gap events

Pull Request - State: closed - Opened by pwoods25443 about 6 years ago

#15 - Refactor gap events to use "best" vessel id

Issue - State: closed - Opened by pwoods25443 about 6 years ago

#14 - Clean up short fishing events

Pull Request - State: closed - Opened by pwoods25443 over 6 years ago

#13 - Limit fishing events to only fishing vessels

Issue - State: open - Opened by pwoods25443 over 6 years ago - 1 comment

#12 - Merge or delete short fishing events

Issue - State: closed - Opened by pwoods25443 over 6 years ago

#11 - Ignore null fishing scores when determining fishing events

Issue - State: closed - Opened by pwoods25443 over 6 years ago

#10 - 871 - Fix variables on pipe events

Pull Request - State: closed - Opened by andres-arana over 6 years ago

#9 - Remove noise segment from fishing

Pull Request - State: closed - Opened by pwoods25443 over 6 years ago - 2 comments

#8 - Reduce noise in fishing events

Issue - State: closed - Opened by pwoods25443 over 6 years ago