private static double getPrismPoint(
String spatialcontext, String viewpoint, Database db, InputXML input, Point[] points)
throws SQLException, ClientException, Exception {
double prismPoint;
if (input.getType().equals("PRISM")) {
ResultSet result = db.getViewpoint(spatialcontext, viewpoint);
if (!result.next()) {
throw new ClientException(
"viewpoint " + viewpoint + " in spatialcontext " + spatialcontext + " does not exist",
404);
}
String filename = Config.getProperty("pointcloudpath") + result.getString("filename");
Transformation trans = new Transformation(result.getString("pointcloud_trans"));
trans.transform(new Transformation(result.getString("viewpoint_trans")));
Transformation inv = trans.inverse();
if (result.next()) {
Config.warn(
"more than one viewpoint in spatialcontext "
+ spatialcontext
+ " with name "
+ viewpoint
+ " in the database");
}
PlanarPolygon tmp = new PlanarPolygon(input.getAngles(), points);
tmp.transform(inv);
prismPoint = PTGInteraction.getPrismaPoint(tmp, filename);
tmp.transform(trans);
} else {
prismPoint = 0;
}
return prismPoint;
}
private static Point[] anglesToFeature(
String spatialcontext, String viewpoint, Angle[] angles, Database db)
throws ClientException, SQLException, Exception {
ResultSet result = db.getViewpoint(spatialcontext, viewpoint);
if (!result.next()) {
throw new ClientException(
"viewpoint " + viewpoint + " in spatialcontext " + spatialcontext + " does not exist",
404);
}
String filename = Config.getProperty("pointcloudpath") + result.getString("filename");
Transformation ptrans = new Transformation(result.getString("pointcloud_trans"));
Transformation vtrans = new Transformation(result.getString("viewpoint_trans"));
if (result.next()) {
Config.warn(
"more than one viewpoint in spatialcontext "
+ spatialcontext
+ " with name "
+ viewpoint
+ " in the database");
}
Point[] points = null;
try (Pointcloud pc = new Pointcloud(filename, ptrans)) {
points = pc.getPoints(angles);
pc.close();
} catch (Exception e) {
throw e;
}
for (Point point : points) {
point.transform(vtrans);
}
return points;
}
public static void insertImage(String img, int fid, int width, int height)
throws FileNotFoundException, IOException {
if (img != null && !img.isEmpty()) {
img = img.replace(' ', '+');
String encodingPrefix = "base64,";
int contentStartIndex = img.indexOf(encodingPrefix) + encodingPrefix.length();
byte[] imgData = Base64.decodeBase64(img.substring(contentStartIndex).getBytes());
BufferedImage image = ImageIO.read(new ByteArrayInputStream(imgData));
if (width == 0 || height == 0) {
ImageIO.write(image, "png", new File(Config.getProperty("screenshotpath") + fid + ".png"));
} else {
BufferedImage resizedImage = resizeclip(image, width, height);
ImageIO.write(
resizedImage, "png", new File(Config.getProperty("screenshotpath") + fid + ".png"));
}
}
}
public static Response deleteFeature(String spatialcontext, int fid) {
try (Database db = new Database()) {
db.removeFeature(fid, spatialcontext);
File file = new File(Config.getProperty("screenshotpath") + fid + ".png");
file.delete();
return Config.getResult();
} catch (ClientException e) {
return Config.getResult(e);
} catch (Exception e) {
return Config.getResult(e);
}
}
private static HashMap<String, Double> checkVisibility(
String spatialcontext, GeoFeature feature, Database db, String viewpoint)
throws SQLException, ClassNotFoundException, IOException {
double tolerance;
if (viewpoint == null || viewpoint.isEmpty()) {
tolerance = POINTCLOUD_TOLERANCE;
} else {
ResultSet startViewpoint = db.getViewpoint(spatialcontext, viewpoint);
if (startViewpoint.next()) {
String filename =
Config.getProperty("pointcloudpath") + startViewpoint.getString("filename");
Transformation t = new Transformation(startViewpoint.getString("pointcloud_trans"));
t.transform(new Transformation(startViewpoint.getString("viewpoint_trans")));
feature.transform(t.inverse());
tolerance = feature.getPointTol(filename);
feature.transform(t);
if (tolerance < POINTCLOUD_TOLERANCE) {
tolerance = POINTCLOUD_TOLERANCE;
}
} else {
tolerance = POINTCLOUD_TOLERANCE;
}
}
// result.last();
// int size = result.getRow();
// result.beforeFirst();
ResultSet result = db.getViewpoints(spatialcontext);
HashMap<String, Double> visibility = new HashMap<>();
while (result.next()) {
// user.setStatus(result.getRow() * 90 / size);
String filename = Config.getProperty("pointcloudpath") + result.getString("filename");
Transformation t = new Transformation(result.getString("pointcloud_trans"));
t.transform(new Transformation(result.getString("viewpoint_trans")));
feature.transform(t.inverse());
visibility.put(result.getString("name"), feature.visible(tolerance, filename));
feature.transform(t);
}
return visibility;
}