Discussion REST API for system data?

Has anyone taken the EDDB information and made it available through REST? I'm particularly interested in the obtaining the system data (allegiance, government, population etc). given the system's name.
 
Thanks, but I'm trying to avoid downloading 20MB per client to pull a very small amount of data. Will keep looking.

Well, if you Inspect the eddb page, you can see that the station search goes like this (e.g. "jameson"):

Code:
https://eddb.io/station/search?station%5Bname%5D=jameson&expand=system&_=1453305835620

This returns a JSON array of matches with EDDB id's:

Code:
[{"id":571,"name":"Jameson Memorial","system_id":16827,"max_landing_pad_size":"L","distance_to_star":346,"faction":"The Pilots Federation","government":"Democracy","allegiance":"Independent","state":"None","type_id":8,"type":"Orbis Starport","has_blackmarket":0,"has_market":1,"has_refuel":1,"has_repair":1,"has_rearm":1,"has_outfitting":1,"has_shipyard":1,"has_commodities":1,"import_commodities":["Cobalt","Rutile","Natural Fabrics"],"export_commodities":["Hydrogen Fuel","Microbial Furnaces","Power Generators"],"prohibited_commodities":["Narcotics","Combat Stabilisers","Imperial Slaves","Slaves","Personal Weapons","Battle Weapons","Toxic Waste"],"economies":["High Tech","Industrial"],"updated_at":1444494454,"shipyard_updated_at":1453302164,"outfitting_updated_at":1453304743,"market_updated_at":1453304740,"is_planetary":0,"selling_ships":["Adder","Anaconda","Asp Explorer","Cobra Mk. III","Diamondback Explorer","Diamondback Scout","Eagle Mk. II","Federal Assault Ship","Federal Dropship","Federal Gunship","Fer-de-Lance","Hauler","Imperial Clipper","Imperial Courier","Imperial Eagle","Orca","Python","Sidewinder Mk. I","Type-6 Transporter","Type-7 Transporter","Type-9 Heavy","Viper Mk III","Vulture","Asp Scout","Federal Corvette","Imperial Cutter","Keelback","Viper MK IV","Cobra MK IV"],"selling_modules":[738,739,740,741,742,743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,848,849,850,851,852,853,854,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869,870,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,924,925,926,927,928,929,930,931,932,933,934,935,936,937,938,939,940,941,942,943,944,945,946,947,948,949,950,951,952,953,954,955,956,957,958,959,960,961,962,963,964,965,966,967,968,969,970,971,972,973,974,975,976,977,978,979,980,981,982,983,984,985,986,987,988,989,990,991,992,993,994,995,996,997,998,999,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084,1085,1086,1087,1088,1089,1090,1091,1092,1093,1094,1095,1096,1097,1098,1099,1100,1101,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1125,1126,1127,1128,1129,1130,1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1141,1142,1143,1144,1145,1146,1147,1148,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1172,1173,1174,1175,1176,1177,1178,1179,1180,1181,1182,1183,1184,1185,1186,1187,1188,1189,1190,1191,1192,1193,1194,1195,1196,1197,1198,1199,1200,1201,1202,1203,1204,1205,1206,1207,1208,1209,1210,1211,1212,1213,1214,1215,1216,1217,1218,1219,1220,1221,1222,1223,1224,1225,1226,1227,1228,1229,1230,1231,1232,1233,1234,1235,1236,1237,1238,1239,1240,1241,1242,1243,1244,1245,1246,1247,1248,1249,1250,1251,1252,1253,1254,1255,1256,1257,1258,1259,1260,1261,1262,1263,1264,1265,1266,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276,1277,1278,1279,1280,1281,1282,1283,1284,1285,1286,1287,1288,1289,1290,1291,1292,1293,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1314,1315,1316,1317,1318,1319,1320,1321,1322,1323,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1335,1336,1337,1338,1339,1340,1341,1342,1343,1344,1345,1346,1347,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1358,1359,1360,1361,1362,1363,1364,1365,1366,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1377,1378,1379,1380,1381,1382,1383,1384,1385,1386,1387,1388,1389,1390,1391,1392,1393,1394,1395,1396,1397,1398,1399,1400,1401,1402,1403,1404,1405,1406,1407,1408,1409,1410,1411,1412,1413,1414,1415,1416,1417,1418,1419,1420,1421,1422,1423,1424,1425,1426,1427,1428,1429,1430,1431,1432,1433,1434,1435,1436,1437,1438,1439,1440,1441,1442,1443,1444,1445,1446,1447,1448,1449,1450,1451,1452,1453,1454,1455,1456,1457,1458,1459,1460,1461,1462,1463,1464,1465,1466,1467,1468,1469,1470,1471,1472,1473,1474,1475,1493,1494,1495,1496,1497,1498,1499,1500,1501,1502,1503,1504,1505,1506,1507,1508,1509,1510,1511,1512,1513,1514,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1527,1528,1529,1530,1531,1532,1533,1534,1535,1536,1537],"system":{"id":16827,"name":"Shinrarta Dezhra","x":55.71875,"y":17.59375,"z":27.15625,"faction":"The Pilots Federation","population":85206935,"government":"Democracy","allegiance":"Independent","state":"None","security":"High","primary_economy":"High Tech","power":"?","power_state":"?","needs_permit":1,"updated_at":1451665547,"simbad_ref":""}}]

Which contains the info you seem to be looking for. If you use this URL using the EDDB station id, you get the full info in HTML format (where 571 is Jameson Memorial):

Code:
https://eddb.io/station/571

HTH
 
  • Like (+1)
Reactions: jgm

Interesting; thanks for this. All I have to start with is the system name so I'm trying to obtain the systems whose name are an exact match. I tried

Code:
https://eddb.io/system/search?system[multiname]=maia&_=1453306384039

But it returns anything with a substring match. I tried various options instead of multiname but didn't have any luck; is there something that will only return exact matches?

Also, this returns the systems and their stations but doesn't return the extended system data. How can I pull the extended system data at the same time? I know I could run another request but would prefer to keep volume down if at all possible.

Finally, I assume that the number is a timestamp. IS this correct?
 
Well, if you Inspect the eddb page, you can see that the station search goes like this (e.g. "jameson"):

Code:
https://eddb.io/station/search?station%5Bname%5D=jameson&expand=system&_=1453305835620
That works. But when I asked themroc he said that this and the system search are not supported APIs, and will go away at some point.
So use at your own risk (and the risk of ing off themroc).
 
Last edited:
  • Like (+1)
Reactions: jgm
That works. But when I asked themroc he said that this and the system search are not supported APIs, and will go away at some point.
So use at your own risk (and the risk of ing off themroc).

Pah. Fair enough though; I'll just have to put something together myself. Thanks for the info.
 
Slight ot question, but does the availability of this db mean that we can find out where all the earth likes or bh's are? Or is it just the inhabited systems?
 
Last edited:
The independent use of https://eddb.io/station/search is not recommended. It is not officially supported and not meant to be used from other 3rd party tools. However, I can deliver a special dump with only a minimum set of data as CSV if required. That would be way smaller and faster to download/process. Also, I recommend to mirror any nightly dump to your own server which then serves your userbase.

Can you please describe what data you need? You can hit me up on chat too: https://kiwiirc.com/client/irc.quakenet.org/eddb
 
The independent use of https://eddb.io/station/search is not recommended. It is not officially supported and not meant to be used from other 3rd party tools. However, I can deliver a special dump with only a minimum set of data as CSV if required. That would be way smaller and faster to download/process. Also, I recommend to mirror any nightly dump to your own server which then serves your userbase.

Can you please describe what data you need? You can hit me up on chat too: https://kiwiirc.com/client/irc.quakenet.org/eddb

I've been chided for hacking your site :p :D

Maybe he could use your station dump to get the eddb id, and then just do a GET on the https://eddb.io/station/<insert id here> URL. Avoids the search.
 
I think that the best approach is going to be for me to take the dumps and munge the data as needed. I'll report back when I've put something together. Thanks all.
 
Top Bottom