{
  "_id": "6ab4e65c3d719c1f8409711e",
  "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-09-24 08:55:17 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": "eurocontrol",
  "_type": "src",
  "_file": "eurocontrol_0.1.25.tar.gz",
  "_fileid": "https://r2.ropensci.org/004f7f824bd1100fab4c75ffe03e11521def33c66bba806aa1ed6c874150a1c5",
  "_filesize": 342279,
  "_sha256": "004f7f824bd1100fab4c75ffe03e11521def33c66bba806aa1ed6c874150a1c5",
  "_expires": "2027-01-02T08:59:06.000Z",
  "_created": "2026-09-24T08:55:17.000Z",
  "_published": "2026-09-24T08:59:08.042Z",
  "_jobs": [
    {
      "job": 107563301983,
      "time": 167,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "10798739031"
    },
    {
      "job": 107563301976,
      "time": 187,
      "config": "linux-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "10799550166"
    },
    {
      "job": 107563301907,
      "time": 193,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "10799431270"
    },
    {
      "job": 107563301867,
      "time": 171,
      "config": "macos-release-arm64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "10798991655"
    },
    {
      "job": 107562169943,
      "time": 212,
      "config": "source",
      "r": "4.6.1",
      "check": "OK",
      "artifact": "10798683835"
    },
    {
      "job": 107563301881,
      "time": 117,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "10798856922"
    },
    {
      "job": 107563302021,
      "time": 89,
      "config": "windows-devel-x86_64",
      "r": "4.7.0",
      "check": "NOTE",
      "artifact": "10799330765"
    },
    {
      "job": 107563301912,
      "time": 84,
      "config": "windows-oldrel-x86_64",
      "r": "4.5.3",
      "check": "NOTE",
      "artifact": "10798962730"
    },
    {
      "job": 107563301957,
      "time": 84,
      "config": "windows-release-x86_64",
      "r": "4.6.1",
      "check": "NOTE",
      "artifact": "10799136330"
    }
  ],
  "_host": "GitHub-Actions",
  "_buildurl": "https://github.com/r-universe/eurocontrol/actions/runs/35977722615",
  "_status": "success",
  "_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": true,
  "_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": 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": 13,
  "_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.5118833609788744,
  "_indexed": true,
  "_nocasepkg": "eurocontrol",
  "_universes": [
    "eurocontrol",
    "espinielli"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.1.25",
      "date": "2026-09-24T08:58:01.000Z",
      "distro": "resolute",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "https://r2.ropensci.org/589e3e38ddbab6a8a98725d797b1eca724dd05433522a3e6e5be5568c5f10381",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/eurocontrol/actions/runs/35977722615"
    },
    {
      "r": "4.6.1",
      "os": "linux",
      "version": "0.1.25",
      "date": "2026-09-24T08:58:19.000Z",
      "distro": "resolute",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "https://r2.ropensci.org/d9de58a89f6c0bd90cba377631799951312814145f06bd526e022b5386499da5",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/eurocontrol/actions/runs/35977722615"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.1.25",
      "date": "2026-09-24T08:58:05.000Z",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "https://r2.ropensci.org/9212b7c5b0c4a252086bfc06a53f7d4d21de19109bd5468ede94f77569e769a5",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/eurocontrol/actions/runs/35977722615"
    },
    {
      "r": "4.6.1",
      "os": "mac",
      "version": "0.1.25",
      "date": "2026-09-24T08:57:28.000Z",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "https://r2.ropensci.org/dd7d62c4a8a0dd729520ae6e36d46cd0b3765e8b766c5e372384de81812a80e7",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/eurocontrol/actions/runs/35977722615"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.1.25",
      "date": "2026-09-24T08:57:30.000Z",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "https://r2.ropensci.org/6bd9fbcd462859cc53ab2e927edd09fd0c89817e551dd3895a02ec1145954103",
      "status": "success",
      "buildurl": "https://github.com/r-universe/eurocontrol/actions/runs/35977722615"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.1.25",
      "date": "2026-09-24T08:56:43.000Z",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "https://r2.ropensci.org/6095d056bfe122f578bb456b5416a4320c6c4022db3dae20ea2c22b27c9132a8",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/eurocontrol/actions/runs/35977722615"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.1.25",
      "date": "2026-09-24T08:56:33.000Z",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "https://r2.ropensci.org/fb1d6cd2b3d50ff0d7127ac190cb1ad1b40d0c20e89bdbb4b44edb845e737a2b",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/eurocontrol/actions/runs/35977722615"
    },
    {
      "r": "4.6.1",
      "os": "win",
      "version": "0.1.25",
      "date": "2026-09-24T08:56:37.000Z",
      "commit": "09186a4ad9e1ee70484fa5a723572667b44bdda4",
      "fileid": "https://r2.ropensci.org/b543a1e9eebd367a7507717d5f84fcf972a8b0e6e3c85570e0435dc74b94c33c",
      "status": "success",
      "check": "NOTE",
      "buildurl": "https://github.com/r-universe/eurocontrol/actions/runs/35977722615"
    }
  ]
}