{
  "_id": "6a10bf2dacfb0bcc41cca6b0",
  "Type": "Package",
  "Package": "eurocontrol",
  "Title": "Helper functions for EUROCONTROL useRs",
  "Version": "0.1.24",
  "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-05-22 20:03:01 UTC",
  "RemoteUrl": "https://github.com/eurocontrol/eurocontrol",
  "RemoteRef": "HEAD",
  "RemoteSha": "84f5584ca009bd9717837fb2337e827c93ee31af",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-22 20:37:05 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": "60fe9649209513c804cbcd20425e6c00",
  "_user": "euctrl-pru",
  "_type": "src",
  "_file": "eurocontrol_0.1.24.tar.gz",
  "_fileid": "8baf233fd959e8543bcbcb0d2c2509a32137d3c562b7cf087794e3fa099b88bd",
  "_filesize": 303948,
  "_sha256": "8baf233fd959e8543bcbcb0d2c2509a32137d3c562b7cf087794e3fa099b88bd",
  "_created": "2026-05-22T20:37:05.000Z",
  "_published": "2026-05-22T20:40:12.976Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77458654939,
      "time": 148,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "ERROR",
      "artifact": "7169866742"
    },
    {
      "job": 77458654940,
      "time": 142,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "ERROR",
      "artifact": "7169865115"
    },
    {
      "job": 77458654945,
      "time": 122,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "ERROR",
      "artifact": "7169859267"
    },
    {
      "job": 77458654969,
      "time": 104,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "ERROR",
      "artifact": "7169854828"
    },
    {
      "job": 77458079661,
      "time": 244,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7169824789"
    },
    {
      "job": 77458654938,
      "time": 117,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7169858214"
    },
    {
      "job": 77458654953,
      "time": 138,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "ERROR",
      "artifact": "7169864510"
    },
    {
      "job": 77458654984,
      "time": 116,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "ERROR",
      "artifact": "7169858101"
    },
    {
      "job": 77458654971,
      "time": 152,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "ERROR",
      "artifact": "7169867838"
    }
  ],
  "_buildurl": "https://github.com/r-universe/euctrl-pru/actions/runs/26310587584",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/eurocontrol/eurocontrol",
  "_commit": {
    "id": "84f5584ca009bd9717837fb2337e827c93ee31af",
    "author": "SKY\\qgoens <quinten.goens@eurocontrol.int>",
    "committer": "SKY\\qgoens <quinten.goens@eurocontrol.int>",
    "message": "Merge branch 'main' of https://github.com/eurocontrol/eurocontrol\n",
    "time": 1779480181
  },
  "_maintainer": {
    "name": "Enrico Spinielli",
    "email": "enrico.spinielli@eurocontrol.int",
    "login": "espinielli",
    "mastodon": "@espinielli@mstdn.social",
    "bluesky": "@espinielli.bsky.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": "ROracle",
      "role": "Suggests"
    },
    {
      "package": "roxygen2",
      "role": "Suggests"
    },
    {
      "package": "sf",
      "role": "Suggests"
    }
  ],
  "_owner": "eurocontrol",
  "_selfowned": false,
  "_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
    }
  ],
  "_tags": [],
  "_stars": 1,
  "_contributors": [
    {
      "user": "espinielli",
      "count": 106,
      "uuid": 891692
    },
    {
      "user": "quinten-goens",
      "count": 10,
      "uuid": 9326424
    }
  ],
  "_userbio": {
    "uuid": 10348651,
    "type": "organization",
    "name": "Aviation Intelligence Unit - EUROCONTROL",
    "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": 10,
  "_rbuild": "4.6.0",
  "_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",
    "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": 10438,
      "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": 2719,
      "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 flights list for the airspace profile segments intersecting an interval of interest",
      "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.3979400086720375,
  "_indexed": false,
  "_nocasepkg": "eurocontrol",
  "_universes": [
    "euctrl-pru"
  ],
  "_indexurl": "https://eurocontrol.r-universe.dev/eurocontrol",
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.24",
      "date": "2026-05-22T20:39:30.000Z",
      "distro": "noble",
      "commit": "84f5584ca009bd9717837fb2337e827c93ee31af",
      "fileid": "d9b8456ea52e0167858af6a470e2abca485316e2871b71814abb3d9b4de2252b",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/euctrl-pru/actions/runs/26310587584"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.1.24",
      "date": "2026-05-22T20:39:24.000Z",
      "distro": "noble",
      "commit": "84f5584ca009bd9717837fb2337e827c93ee31af",
      "fileid": "ef90a3926bd99d7e3775eea17a0a57168bf386db712a1f18cfaee7079354b2c1",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/euctrl-pru/actions/runs/26310587584"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.24",
      "date": "2026-05-22T20:39:01.000Z",
      "commit": "84f5584ca009bd9717837fb2337e827c93ee31af",
      "fileid": "aaef34955f81f6e0903b160d8dee95787eb8ddc58c91e97833c9e7b3f1451bd9",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/euctrl-pru/actions/runs/26310587584"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.1.24",
      "date": "2026-05-22T20:38:52.000Z",
      "commit": "84f5584ca009bd9717837fb2337e827c93ee31af",
      "fileid": "a0abff9bed10c5814809359e53474548641087c6c34ae907c51b5d2b25126f12",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/euctrl-pru/actions/runs/26310587584"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.24",
      "date": "2026-05-22T20:39:22.000Z",
      "commit": "84f5584ca009bd9717837fb2337e827c93ee31af",
      "fileid": "799e93612d21b5904a11e92cb007d001bb89a1b94a073f531f74090f2413fa41",
      "status": "success",
      "buildurl": "https://github.com/r-universe/euctrl-pru/actions/runs/26310587584"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.24",
      "date": "2026-05-22T20:39:19.000Z",
      "commit": "84f5584ca009bd9717837fb2337e827c93ee31af",
      "fileid": "26ac91bcfbca2bbe0a9efebdb9db784fe9f56c2c2e04ded5abfcebad423a5493",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/euctrl-pru/actions/runs/26310587584"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.24",
      "date": "2026-05-22T20:38:56.000Z",
      "commit": "84f5584ca009bd9717837fb2337e827c93ee31af",
      "fileid": "c8021e4add9b18ae1ff8cb7004fa7bcadaaab4cf80f09fbd6a9465255fe11e74",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/euctrl-pru/actions/runs/26310587584"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.1.24",
      "date": "2026-05-22T20:39:30.000Z",
      "commit": "84f5584ca009bd9717837fb2337e827c93ee31af",
      "fileid": "70e2ab87bc96bcad8fedb06a6ec05382ec76700a745b740d653fe4b6af5195e3",
      "status": "failure",
      "check": "ERROR",
      "buildurl": "https://github.com/r-universe/euctrl-pru/actions/runs/26310587584"
    }
  ]
}