{
  "_id": "6a3ee3f7a319ef94144940dc",
  "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://eurocontrol.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-06-26 20:38:15 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]",
  "MD5sum": "06a41bd8cfdb831e2da0b1193ace7103",
  "_user": "eurocontrol",
  "_type": "src",
  "_file": "eurocontrol_0.1.25.tar.gz",
  "_fileid": "8d62f34419ebbe2019f7cc8ea5ae294b54be4b7cac62f58aa1c216949ed0c2c8",
  "_filesize": 343325,
  "_sha256": "8d62f34419ebbe2019f7cc8ea5ae294b54be4b7cac62f58aa1c216949ed0c2c8",
  "_created": "2026-06-26T20:38:15.000Z",
  "_published": "2026-06-26T20:41:27.747Z",
  "_distro": "resolute",
  "_jobs": [
    {
      "job": 83746025567,
      "time": 150,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "7915947819"
    },
    {
      "job": 83746025557,
      "time": 132,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "7915942036"
    },
    {
      "job": 83746025579,
      "time": 100,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "7915931637"
    },
    {
      "job": 83746025563,
      "time": 94,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "7915929587"
    },
    {
      "job": 83745487459,
      "time": 201,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "7915900071"
    },
    {
      "job": 83746025572,
      "time": 157,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7915948694"
    },
    {
      "job": 83746025583,
      "time": 120,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "7915938097"
    },
    {
      "job": 83746025594,
      "time": 101,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "7915931714"
    },
    {
      "job": 83746025590,
      "time": 112,
      "config": "windows-release",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "7915935421"
    }
  ],
  "_buildurl": "https://github.com/r-universe/eurocontrol/actions/runs/28263775557",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_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
  },
  "_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": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2025-36",
      "n": 2
    },
    {
      "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": 73102027,
    "type": "organization",
    "name": "EUROCONTROL",
    "followers": 13,
    "description": "EUROCONTROL, the European Organisation for the Safety of Air Navigation"
  },
  "_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": 10,
  "_rbuild": "4.6.1",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/eurocontrol.html",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "LICENSE",
    "manual.pdf"
  ],
  "_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.4771212547196626,
  "_indexed": true,
  "_nocasepkg": "eurocontrol",
  "_universes": [
    "eurocontrol",
    "espinielli"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.25",
      "date": "2026-06-26T20:40:43.000Z",
      "distro": "resolute",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "47b8afee1b6ebe5976200ea7cdd3fd5f4aeeed2fc0defbcb8fa2e8063516bf67",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/eurocontrol/actions/runs/28263775557"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.1.25",
      "date": "2026-06-26T20:40:26.000Z",
      "distro": "resolute",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "7a564a7ca633adfb6c4df6487ea8bead8688788eb3948c3ce040ecfb91dc72df",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/eurocontrol/actions/runs/28263775557"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.25",
      "date": "2026-06-26T20:39:57.000Z",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "044919025ae005f34cbe245ce78540665916187f2b9f3bf094b2b54f1e05d869",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/eurocontrol/actions/runs/28263775557"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.1.25",
      "date": "2026-06-26T20:39:53.000Z",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "a945d87ef69b1f9d7681cc33c7ed0232868840319f2d23fe83596a195cb2abcd",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/eurocontrol/actions/runs/28263775557"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.25",
      "date": "2026-06-26T20:41:03.000Z",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "fc0d18d71a09d37fec9b3a5afce32981c6231cc407a7a3529159eb1b508409fc",
      "status": "success",
      "buildurl": "https://github.com/r-universe/eurocontrol/actions/runs/28263775557"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.25",
      "date": "2026-06-26T20:40:06.000Z",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "6b03e784a2970a68e1523fc389b7c2f259f5e8a24ddf58eeccdad00c06021d90",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/eurocontrol/actions/runs/28263775557"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.25",
      "date": "2026-06-26T20:39:50.000Z",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "97f03baddf77112e1c7ad278c67c8868c8327e57fe67aa978919ce26d0fbffd6",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/eurocontrol/actions/runs/28263775557"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.1.25",
      "date": "2026-06-26T20:40:00.000Z",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "ff617eaf9571c5d5a6e61b358ccf39fc1a462d9cd6fe9239b56cede920e2f68e",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/eurocontrol/actions/runs/28263775557"
    }
  ]
}