private JSONObject reformLastestAirportData(String airportURL) { SensorManager sensorManager = new SensorManager(); Sensor sensor = sensorManager.getSpecifiedSensorWithSensorId(airportURL); JSONObject j = new JSONObject(); if (sensor == null) return j; JSONObject metaJson = new JSONObject(); metaJson.put("name", sensor.getName()); metaJson.put("source", sensor.getSource()); metaJson.put("sourceType", sensor.getSourceType()); metaJson.put("city", sensor.getPlace().getCity()); metaJson.put("country", sensor.getPlace().getCountry()); String airportCode = sensor .getName() .substring(sensor.getName().lastIndexOf("(") + 1, sensor.getName().lastIndexOf(")")); ArrayList<ArrayList> depatures = sensorManager.getAllFlightsWithSpecifiedDeparture(airportCode); ArrayList<ArrayList> arrivals = sensorManager.getAllFlightsWithSpecifiedDestination(airportCode); ArrayList<List> radarFlights = FlightAroundXMLParser.getFlightAroundInformation( sensor.getPlace().getLat(), sensor.getPlace().getLng()); JSONObject depaturesJson = new JSONObject(); String[] aryStrings = {"CallSign", "FlightNumber", "Route"}; depaturesJson.put("vars", aryStrings); depaturesJson.put("data", depatures); JSONObject arrivalsJson = new JSONObject(); arrivalsJson.put("vars", aryStrings); arrivalsJson.put("data", arrivals); JSONObject radarFlightsJson = new JSONObject(); String[] flightStrings = { "Registration", "Model", "CallSign", "Route", "Latitude", "Longitude", "Distance(km)" }; radarFlightsJson.put("vars", flightStrings); radarFlightsJson.put("data", radarFlights); OutputStream result = null; result = DatabaseUtilities.getSensorMetadata(airportURL); JSONObject json = (JSONObject) JSONSerializer.toJSON(result.toString()); json.put("updated", DateUtil.date2StandardString(new Date())); json.put("ntriples", JSONUtil.JSONToNTriple(json.getJSONObject("results"))); json.put("error", "false"); json.put("meta", metaJson); json.put("departures", depaturesJson); json.put("arrivals", arrivalsJson); json.put("radars", radarFlightsJson); System.out.println(json); return json; }