Hello, I have been trying to find airports using the two R-packages osmdata and osmar. In the example below I am searching for an airport in a place called wahnheide, knowing, that there is an airport Flughafen Köln/Bonn. First, I am creating a bounding box with the function center_bbox and then querying the tag aeroway:aerodrome.
library(osmdata)
library(osmar)
wahnheide <- c(7.107108659486173, 50.8700493119623)
central_point <- wahnheide
bb <- center_bbox(central_point[1], central_point[2], 5000, 5000)
# aerodrome
q <- bb %>% opq (timeout = 25*100) %>% add_osm_feature(key = "aeroway", value = "aerodrome")
aerodrome <- sapply(osmdata_sf(q)$osm_points, function(x) iconv(x, from = "UTF-8", to = "UTF-8"))
The result I get is a table with four columns: osm_id, barrier, source and geometry, like attached below.
What I expect is something usable, like the name of the place, address, etc. Is it possitble to get this information modifying the query? or using the osm_ids?
aerodrome <- structure(c("53398845", "53398860", "53398865", "53403325", "53403328",
"90727693", "90727719", "90727721", "90727725", "90727726", "90727729",
"90727733", "90727745", "90727747", "90727749", "90727754", "90727758",
"90727760", "90727763", "90727765", "90727771", "90727773", "90727776",
"90727780", "303381016", "303381017", "303381018", "303381020",
"305577320", "338493431", "338493432", "388619605", "444984453",
"503256114", "503256131", "693414125", "975856241", "982585071",
"982585074", "982585099", "982585300", "982585318", "1256789186",
"1256789190", "1256789191", "1256789198", "1278005777", "1278005778",
"1278005779", "1513076932", "1513076933", "1513076934", "1513076935",
"1513076936", "1513076937", "1513076938", "1513076939", "1513076943",
"1513076947", "1513076949", "1513076952", "1513076954", "1513076955",
"1513076961", "1513076967", "1513076969", "1513076970", "1513076971",
"1513076980", "1513076999", "1513077000", "1513077001", "1513077003",
"1513077008", "1513077012", "1513077013", "1513077014", "1513077038",
"1513077054", "1513077062", "1513077073", "1513077074", "1513077075",
"1513077076", "1513077077", "1513077080", "1514349799", "1603899023",
"1603899025", "1603899027", "1611111803", "1737314262", "1737314270",
"1737314271", "1737314272", "1737314273", "1737314274", "1737314275",
"1737314282", "1737314283", "1737314284", "1737314286", "1737314288",
"1737314290", "1737314291", "1737314294", "1737314304", "1737314306",
"1737314308", "1737314310", "1737314311", "1737314313", "1737314315",
"1737314319", "1737314322", "1737314325", "1868389062", "1868389090",
"1868389092", "1868389095", "1868389098", "1868389101", "1868389105",
"1868389106", "1942418794", "1991402715", "1991402721", "2149996723",
"2149996730", "2149996743", "2149996746", "2149996755", "2149996770",
"2149996787", "2150455272", "2150455329", "2301210581", "2355175960",
"2399040138", "2687584301", "2687584303", "3239092981", "3263357122",
"3263357127", "3825207782", "3825207783", "4103701261", "4103701262",
"4103701263", "4103701266", "4103701267", "4103701268", "4103701269",
"4103701270", "4103701271", "4103701272", "4103701274", "4103701275",
"4103701276", "4103701277", "4103701278", "4103701279", "4103701280",
"5046878828", "5046878830", "5200880764", "7275520072", "7275597689",
"7275597690", "7275597691", "7275597743", "7275597744", "7275597745",
"7275597746", "7275597749", "7275597751", "7275597764", "7275597765",
"7275597766", "7275597767", "7275597768", "7275597769", "7275597770",
"7275597771", "7275597772", "7275597773", "7275597774", "7275597775",
"7275597776", "7275597777", "8200300056", NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, "gate", NA, NA, NA, NA, "gate",
NA, NA, NA, NA, NA, "gate", NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, "gate", NA, NA, NA, NA, NA, "gate", NA, "gate",
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, "gate", NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "seen", NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, "c(7.1596728, 50.8675326)",
"c(7.1594811, 50.8732307)", "c(7.1588775, 50.8736457)", "c(7.1709033, 50.8563279)",
"c(7.1684331, 50.8580434)", "c(7.1215113, 50.8846538)", "c(7.1577605, 50.8740119)",
"c(7.1582833, 50.8738986)", "c(7.1593787, 50.8670762)", "c(7.1579936, 50.8652953)",
"c(7.1579382, 50.8651661)", "c(7.1637246, 50.8612768)", "c(7.1744018, 50.8485948)",
"c(7.1685356, 50.8495791)", "c(7.1645922, 50.850256)", "c(7.1583425, 50.853538)",
"c(7.152706, 50.8562489)", "c(7.1451792, 50.8546241)", "c(7.1180104, 50.8579515)",
"c(7.1184121, 50.8588979)", "c(7.1178592, 50.8679345)", "c(7.1173157, 50.8690389)",
"c(7.1149798, 50.8721996)", "c(7.1109705, 50.8730305)", "c(7.1187524, 50.8606415)",
"c(7.1190139, 50.8620776)", "c(7.1185084, 50.8633001)", "c(7.1168392, 50.8667116)",
"c(7.1187245, 50.8578149)", "c(7.1594448, 50.8672126)", "c(7.1593147, 50.8662857)",
"c(7.1192087, 50.8862498)", "c(7.1274656, 50.8560652)", "c(7.1200316, 50.8571792)",
"c(7.1375415, 50.8539322)", "c(7.1607277, 50.8684893)", "c(7.1094338, 50.8756193)",
"c(7.1318781, 50.8546793)", "c(7.1334321, 50.854118)", "c(7.122546, 50.856602)",
"c(7.1161954, 50.8704297)", "c(7.1189396, 50.8623565)", "c(7.1788073, 50.8518339)",
"c(7.1754817, 50.8498641)", "c(7.1756599, 50.849335)", "c(7.1744335, 50.8538987)",
"c(7.1121063, 50.8835169)", "c(7.1111398, 50.8835777)", "c(7.1107519, 50.8835921)",
"c(7.1611519, 50.8526031)", "c(7.1595574, 50.8527078)", "c(7.1750686, 50.8538773)",
"c(7.1383822, 50.853999)", "c(7.1390607, 50.8541726)", "c(7.1400722, 50.854275)",
"c(7.1416068, 50.8543694)", "c(7.1444638, 50.8545775)", "c(7.1582625, 50.854622)",
"c(7.148056, 50.855367)", "c(7.1291405, 50.8559914)", "c(7.1490328, 50.8556219)",
"c(7.1505143, 50.8557426)", "c(7.1549338, 50.8569102)", "c(7.1654299, 50.86011)",
"c(7.1600634, 50.8637924)", "c(7.159879, 50.8639859)", "c(7.1592812, 50.8645083)",
"c(7.1580069, 50.8650761)", "c(7.1602408, 50.8680314)", "c(7.1487208, 50.8725832)",
"c(7.1462354, 50.8727484)", "c(7.1514029, 50.8728809)", "c(7.1530627, 50.8731089)",
"c(7.155243, 50.8736174)", "c(7.1570646, 50.8740068)", "c(7.143621, 50.8744925)",
"c(7.1435235, 50.8750864)", "c(7.1413533, 50.876645)", "c(7.1392444, 50.8781201)",
"c(7.1357114, 50.880533)", "c(7.130943, 50.8838309)", "c(7.1294039, 50.8849008)",
"c(7.1237363, 50.8850928)", "c(7.1278527, 50.885909)", "c(7.1222151, 50.886153)",
"c(7.1207726, 50.8871502)", "c(7.143246, 50.8753309)", "c(7.1166652, 50.8670108)",
"c(7.1165737, 50.8672025)", "c(7.1166426, 50.8672302)", "c(7.1145735, 50.87147)",
"c(7.1312116, 50.8554401)", "c(7.1308343, 50.8558053)", "c(7.1254629, 50.8559264)",
"c(7.1266752, 50.8559774)", "c(7.1304234, 50.8559932)", "c(7.1185501, 50.8594183)",
"c(7.1189222, 50.859728)", "c(7.1155802, 50.8708666)", "c(7.1163261, 50.8713979)",
"c(7.1095918, 50.8725286)", "c(7.1102637, 50.8730573)", "c(7.1090923, 50.8800228)",
"c(7.1072915, 50.8802163)", "c(7.1065359, 50.8803151)", "c(7.1082283, 50.882398)",
"c(7.1086125, 50.8827628)", "c(7.1082363, 50.8829883)", "c(7.1077811, 50.8831816)",
"c(7.1076365, 50.8832918)", "c(7.1052847, 50.8833852)", "c(7.1075706, 50.8835207)",
"c(7.1094057, 50.8836983)", "c(7.1075655, 50.8839013)", "c(7.1075276, 50.8840923)",
"c(7.1073947, 50.8842792)", "c(7.1092781, 50.8778496)", "c(7.1093589, 50.8802181)",
"c(7.1085314, 50.8802345)", "c(7.1086788, 50.8802715)", "c(7.1092265, 50.8803148)",
"c(7.1090858, 50.8803856)", "c(7.1088111, 50.8804417)", "c(7.109075, 50.8804459)",
"c(7.1177331, 50.8676678)", "c(7.1100975, 50.8725404)", "c(7.1107719, 50.8730983)",
"c(7.1142993, 50.8715419)", "c(7.115582, 50.8717896)", "c(7.1119801, 50.871955)",
"c(7.1124218, 50.8719669)", "c(7.1118905, 50.8720537)", "c(7.1118081, 50.8722463)",
"c(7.111641, 50.8724831)", "c(7.1149582, 50.8833278)", "c(7.1201726, 50.8843959)",
"c(7.1593171, 50.8663043)", "c(7.118445, 50.859766)", "c(7.1194211, 50.857447)",
"c(7.1500275, 50.8727031)", "c(7.1526174, 50.8730609)", "c(7.1189395, 50.8613577)",
"c(7.1593273, 50.8663837)", "c(7.1593185, 50.8667754)", "c(7.1436339, 50.8745573)",
"c(7.1436404, 50.8745903)", "c(7.1611741, 50.8689405)", "c(7.1613083, 50.8690611)",
"c(7.1614478, 50.869211)", "c(7.1616027, 50.8694204)", "c(7.1616643, 50.8695406)",
"c(7.1617032, 50.8696618)", "c(7.1617288, 50.8697871)", "c(7.1617413, 50.8698967)",
"c(7.1617464, 50.8699928)", "c(7.1617196, 50.8701947)", "c(7.1616774, 50.8703124)",
"c(7.1616162, 50.8704459)", "c(7.1614907, 50.8706298)", "c(7.1613351, 50.8708402)",
"c(7.1612432, 50.8709595)", "c(7.16104, 50.8712324)", "c(7.160784, 50.8715545)",
"c(7.1476107, 50.8725826)", "c(7.1467738, 50.8725822)", "c(7.1601743, 50.872335)",
"c(7.1485387, 50.8725831)", "c(7.1527403, 50.8730706)", "c(7.1521925, 50.8729995)",
"c(7.1507954, 50.8727878)", "c(7.1615326, 50.8693127)", "c(7.1617406, 50.8700858)",
"c(7.1524845, 50.8730428)", "c(7.1529269, 50.8730885)", "c(7.1542061, 50.8733772)",
"c(7.1559625, 50.8737844)", "c(7.1568231, 50.8739759)", "c(7.1566424, 50.8739383)",
"c(7.1572663, 50.8740187)", "c(7.1574735, 50.8740215)", "c(7.1579433, 50.8739838)",
"c(7.1581309, 50.8739495)", "c(7.1584374, 50.8738404)", "c(7.1585793, 50.8737825)",
"c(7.1590852, 50.8735495)", "c(7.1594221, 50.8733138)", "c(7.1593438, 50.8733907)",
"c(7.159221, 50.8734731)", "c(7.1596607, 50.873005)", "c(7.1598357, 50.8727748)",
"c(7.1185362, 50.8593659)"), .Dim = c(191L, 4L), .Dimnames = list(
NULL, c("osm_id", "barrier", "source", "geometry")))
