{
  "_id": "6accd2e5a14063b82c3a995c",
  "Type": "Package",
  "Package": "eurocontrol",
  "Title": "Helper functions for EUROCONTROL useRs",
  "Version": "0.1.25",
  "Authors@R": "c(\nperson(\"Enrico\", \"Spinielli\", , \"enrico.spinielli@eurocontrol.int\", role = c(\"aut\", \"cre\"),\ncomment = c(ORCID = \"0000-0001-8584-9131\")),\nperson(\"Quinten\", \"Goens\", , \"quinten.goens@eurocontrol.int\", role = \"aut\",\ncomment = c(ORCID = \"0000-0003-2187-1924\")),\nperson(\"EUROCONTROL\", role = c(\"cph\", \"fnd\"))\n)",
  "Maintainer": "Enrico Spinielli <enrico.spinielli@eurocontrol.int>",
  "Description": "The helper functions in this package are designed to make\nit easy, homogeneus and transparent to perform common tasks\nusually needed by data analysts and useRs in EUROCONTROL.",
  "License": "MIT + file LICENSE",
  "Encoding": "UTF-8",
  "LazyData": "true",
  "Roxygen": "list(markdown = TRUE)",
  "URL": "https://eurocontrol.github.io/eurocontrol/,\nhttps://github.com/eurocontrol/eurocontrol",
  "Config/roxygen2/version": "8.0.0",
  "Config/pak/sysreqs": "libicu-dev libx11-dev",
  "Repository": "https://euctrl-pru.r-universe.dev",
  "Date/Publication": "2026-06-26 19:03:07 UTC",
  "RemoteUrl": "https://github.com/eurocontrol/eurocontrol",
  "RemoteRef": "HEAD",
  "RemoteSha": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-10-12 12:26:56 UTC",
    "User": "root"
  },
  "Author": "Enrico Spinielli [aut, cre] (ORCID:\n<https://orcid.org/0000-0001-8584-9131>),\nQuinten Goens [aut] (ORCID: <https://orcid.org/0000-0003-2187-1924>),\nEUROCONTROL [cph, fnd]",
  "_user": "euctrl-pru",
  "_type": "src",
  "_file": "eurocontrol_0.1.25.tar.gz",
  "_fileid": "https://r2.ropensci.org/fcf102e6272277f96e43b5def54ea30cffabd527a17611a6d4f45558f3add52d",
  "_filesize": 340341,
  "_sha256": "fcf102e6272277f96e43b5def54ea30cffabd527a17611a6d4f45558f3add52d",
  "_expires": "2027-01-20T12:30:27.000Z",
  "_created": "2026-10-12T12:26:56.000Z",
  "_published": "2026-10-12T12:30:29.296Z",
  "_buildurl": "https://github.com/r-universe/euctrl-pru/actions/runs/38248646794",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_jobs": [
    {
      "job": 114810519506,
      "time": 167,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "11747336813"
    },
    {
      "job": 114810521196,
      "time": 137,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "11747631665"
    },
    {
      "job": 114810519234,
      "time": 109,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "11747801412"
    },
    {
      "job": 114810519163,
      "time": 108,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "11747916328"
    },
    {
      "job": 114809349241,
      "time": 195,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "11747471122"
    },
    {
      "job": 114810519174,
      "time": 99,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "11747561502"
    },
    {
      "job": 114810519400,
      "time": 115,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "11746966590"
    },
    {
      "job": 114810519937,
      "time": 85,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "11747726360"
    },
    {
      "job": 114810519218,
      "time": 67,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "11747376293"
    }
  ],
  "_upstream": "https://github.com/eurocontrol/eurocontrol",
  "_commit": {
    "id": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
    "author": "SPINIELLI Enrico <enrico.spinielli@eurocontrol.int>",
    "committer": "SPINIELLI Enrico <enrico.spinielli@eurocontrol.int>",
    "message": "extract AO/country per YEAN from NM\n",
    "time": 1782500587
  },
  "_maintainer": {
    "name": "Enrico Spinielli",
    "email": "enrico.spinielli@eurocontrol.int",
    "login": "espinielli",
    "mastodon": "@espinielli@mstdn.social",
    "bluesky": "@espinielli.eurosky.social",
    "linkedin": "in/espinielli",
    "orcid": "0000-0001-8584-9131",
    "description": "I am interested in dataviz and am looking forward to a world where human brains are freed from boring, repetitive, manual, click-copy-paste tasks.\n ",
    "uuid": 891692
  },
  "_distro": "resolute",
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 4.1.0",
      "role": "Depends"
    },
    {
      "package": "cli",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "role": "Imports"
    },
    {
      "package": "dbplyr",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "forcats",
      "role": "Imports"
    },
    {
      "package": "geosphere",
      "role": "Imports"
    },
    {
      "package": "lubridate",
      "role": "Imports"
    },
    {
      "package": "magrittr",
      "role": "Imports"
    },
    {
      "package": "readr",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "version": ">= 0.4.11",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "tibble",
      "role": "Imports"
    },
    {
      "package": "withr",
      "role": "Imports"
    },
    {
      "package": "arrow",
      "role": "Suggests"
    },
    {
      "package": "ROracle",
      "role": "Suggests"
    },
    {
      "package": "roxygen2",
      "role": "Suggests"
    },
    {
      "package": "sf",
      "role": "Suggests"
    }
  ],
  "_owner": "eurocontrol",
  "_selfowned": false,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-16",
      "n": 7
    },
    {
      "week": "2026-17",
      "n": 4
    },
    {
      "week": "2026-19",
      "n": 2
    },
    {
      "week": "2026-21",
      "n": 2
    },
    {
      "week": "2026-26",
      "n": 8
    }
  ],
  "_tags": [],
  "_stars": 1,
  "_contributors": [
    {
      "user": "espinielli",
      "count": 115,
      "uuid": 891692
    },
    {
      "user": "quinten-goens",
      "count": 10,
      "uuid": 9326424
    }
  ],
  "_userbio": {
    "uuid": 10348651,
    "type": "organization",
    "name": "Aviation Intelligence Unit - EUROCONTROL",
    "followers": 29,
    "description": "The Aviation Intelligence Unit / Performance Review Unit of EUROCONTROL."
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/eurocontrol"
  },
  "_devurl": "https://github.com/eurocontrol/eurocontrol",
  "_pkgdown": "https://eurocontrol.github.io/eurocontrol/",
  "_searchresults": 11,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/eurocontrol.html",
    "extra/manual.pdf",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE"
  ],
  "_cranurl": false,
  "_exports": [
    ":=",
    ".data",
    "acc_sf",
    "adrr_flights_tidy",
    "airlines_tbl",
    "airlines_tidy",
    "airports_oa",
    "airspace_profile_tbl",
    "airspace_profiles_tidy",
    "ansp_sf",
    "apdf_tbl",
    "apdf_tidy",
    "as_label",
    "as_name",
    "db_connection",
    "enquo",
    "enquos",
    "es_sf",
    "fir_sf",
    "flights_airspace_profiles_tidy",
    "flights_tbl",
    "flights_tidy",
    "generate_so6",
    "iata_season_for_date",
    "point_profile_tbl",
    "point_profiles_tidy",
    "season_iata"
  ],
  "_datasets": [
    {
      "name": "aircraft_model",
      "title": "ICAO's Manufacturer codes",
      "object": "aircraft_model",
      "class": [
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "model_full_name",
        "manufacturer_code",
        "designator",
        "last_updated"
      ],
      "rows": 7260,
      "table": true,
      "tojson": true
    },
    {
      "name": "aircraft_type",
      "title": "ICAO's Aircraft types",
      "object": "aircraft_type",
      "class": [
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "designator",
        "aircraft_description",
        "description",
        "wtc",
        "engine_count",
        "engine_type",
        "last_updated"
      ],
      "rows": 2612,
      "table": true,
      "tojson": true
    },
    {
      "name": "member_state",
      "title": "EUROCONTROL's Member States",
      "object": "member_state",
      "class": [
        "tbl_df",
        "tbl",
        "data.frame"
      ],
      "fields": [
        "name",
        "iso3c",
        "iso2c",
        "icao",
        "iso3n",
        "date",
        "status"
      ],
      "rows": 45,
      "table": true,
      "tojson": true
    }
  ],
  "_help": [
    {
      "page": "acc_sf",
      "title": "Retrieve ACC/OAC airspace geometries for a given AIRAC cycle",
      "topics": [
        "acc_sf"
      ]
    },
    {
      "page": "adrr_flights_tidy",
      "title": "Extract ADRR flight list in an interval of dates",
      "topics": [
        "adrr_flights_tidy"
      ]
    },
    {
      "page": "aircraft_model",
      "title": "ICAO's Manufacturer codes",
      "topics": [
        "aircraft_model"
      ]
    },
    {
      "page": "aircraft_type",
      "title": "ICAO's Aircraft types",
      "topics": [
        "aircraft_type"
      ]
    },
    {
      "page": "airlines_tbl",
      "title": "Return a reference to the Airlines table",
      "topics": [
        "airlines_tbl"
      ]
    },
    {
      "page": "airlines_tidy",
      "title": "Airline info including group affiliation",
      "topics": [
        "airlines_tidy"
      ]
    },
    {
      "page": "airports_oa",
      "title": "retrieve latest airport list from OurAirports",
      "topics": [
        "airports_oa"
      ]
    },
    {
      "page": "airspace_profile_tbl",
      "title": "Return a reference to the Airspace Profile table",
      "topics": [
        "airspace_profile_tbl"
      ]
    },
    {
      "page": "airspace_profiles_tidy",
      "title": "Provide all airspace profile segments intersecting an interval of interest",
      "topics": [
        "airspace_profiles_tidy"
      ]
    },
    {
      "page": "ansp_sf",
      "title": "Retrieve ACE ANSP airspace geometries for a given AIRAC cycle",
      "topics": [
        "ansp_sf"
      ]
    },
    {
      "page": "apdf_tbl",
      "title": "Return a reference to the Airport Operator Data Flow table",
      "topics": [
        "apdf_tbl"
      ]
    },
    {
      "page": "apdf_tidy",
      "title": "Extract a clean airport operator data flow list in an interval",
      "topics": [
        "apdf_tidy"
      ]
    },
    {
      "page": "db_connection",
      "title": "Provide a connection to the relevant Oracle database",
      "topics": [
        "db_connection"
      ]
    },
    {
      "page": "es_sf",
      "title": "Retrieve Elementary Sector airspace geometries for a given AIRAC cycle",
      "topics": [
        "es_sf"
      ]
    },
    {
      "page": "fir_sf",
      "title": "Retrieve FIR (Flight Information Region) airspace geometries for a given AIRAC cycle",
      "topics": [
        "fir_sf"
      ]
    },
    {
      "page": "flights_airspace_profiles_tidy",
      "title": "Extract the segments intersecting a set of airspace IDs in an interval of time and complement them with flight information",
      "topics": [
        "flights_airspace_profiles_tidy"
      ]
    },
    {
      "page": "flights_tbl",
      "title": "Return a reference to the Flights table",
      "topics": [
        "flights_tbl"
      ]
    },
    {
      "page": "flights_tidy",
      "title": "Extract a clean flights list in an interval",
      "topics": [
        "flights_tidy"
      ]
    },
    {
      "page": "generate_so6",
      "title": "Export trajectory profiles to SO6 format",
      "topics": [
        "generate_so6"
      ]
    },
    {
      "page": "iata_season_for_date",
      "title": "Return the corresponding IATA season for a date",
      "topics": [
        "iata_season_for_date"
      ]
    },
    {
      "page": "member_state",
      "title": "EUROCONTROL's Member States",
      "topics": [
        "member_state"
      ]
    },
    {
      "page": "point_profile_tbl",
      "title": "Return a reference to the Point Profile table",
      "topics": [
        "point_profile_tbl"
      ]
    },
    {
      "page": "point_profiles_tidy",
      "title": "Export point profile from NM trajectories",
      "concept": [
        "read/export"
      ],
      "topics": [
        "point_profiles_tidy"
      ]
    },
    {
      "page": "season_iata",
      "title": "return the interval for an IATA season",
      "topics": [
        "season_iata"
      ]
    }
  ],
  "_readme": "https://github.com/eurocontrol/eurocontrol/raw/HEAD/README.md",
  "_rundeps": [
    "bit",
    "bit64",
    "blob",
    "cli",
    "clipr",
    "cpp11",
    "crayon",
    "DBI",
    "dbplyr",
    "dplyr",
    "forcats",
    "generics",
    "geosphere",
    "glue",
    "hms",
    "lifecycle",
    "lubridate",
    "magrittr",
    "pillar",
    "pkgconfig",
    "prettyunits",
    "progress",
    "purrr",
    "R6",
    "Rcpp",
    "readr",
    "rlang",
    "stringi",
    "stringr",
    "tibble",
    "tidyr",
    "tidyselect",
    "timechange",
    "tzdb",
    "utf8",
    "vctrs",
    "vroom",
    "withr"
  ],
  "_score": 2.439332693830263,
  "_indexed": false,
  "_nocasepkg": "eurocontrol",
  "_universes": [
    "euctrl-pru"
  ],
  "_indexurl": "https://eurocontrol.r-universe.dev/eurocontrol",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.25",
      "date": "2026-10-12T12:29:49.000Z",
      "distro": "resolute",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "https://r2.ropensci.org/72c45afd43c524c593b72d6bb603e36be7adacc005a06777bbf0177db29cbc71",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/euctrl-pru/actions/runs/38248646794"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.1.25",
      "date": "2026-10-12T12:29:17.000Z",
      "distro": "resolute",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "https://r2.ropensci.org/f0c3094b86b72619c3a195fdc233c1cf246df4359490f40676200358a2e8621c",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/euctrl-pru/actions/runs/38248646794"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.25",
      "date": "2026-10-12T12:28:48.000Z",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "https://r2.ropensci.org/0c259f254dd024c4b2a887c83f67724968c37e5f41af23af473742c48df376b5",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/euctrl-pru/actions/runs/38248646794"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.1.25",
      "date": "2026-10-12T12:28:55.000Z",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "https://r2.ropensci.org/6cd57741858b86e8b2d76742a6e785c20cd4e0a3d9b001c68cfd7f11cda27b56",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/euctrl-pru/actions/runs/38248646794"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.25",
      "date": "2026-10-12T12:28:58.000Z",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "https://r2.ropensci.org/afc0d7609ee986f5435fbbbe69ceba803289df1111b946aedd61507c508beba1",
      "status": "success",
      "buildurl": "https://github.com/r-universe/euctrl-pru/actions/runs/38248646794"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.25",
      "date": "2026-10-12T12:28:46.000Z",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "https://r2.ropensci.org/53a20c5ea81c1a8d0ec2a6704d1a9b781d30003760120c7b8bd692eb43b02fac",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/euctrl-pru/actions/runs/38248646794"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.25",
      "date": "2026-10-12T12:28:16.000Z",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "https://r2.ropensci.org/f1981ea24e0f3c8e44a12154288cf2d9d55a5c122be9ff33ca2e1542cec5b0fd",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/euctrl-pru/actions/runs/38248646794"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.1.25",
      "date": "2026-10-12T12:28:03.000Z",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "https://r2.ropensci.org/7f8c9c1bca87306df4467ca2ea96101b9f699f07bbdf8a04fa9c8859a90b19a2",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/euctrl-pru/actions/runs/38248646794"
    }
  ]
}