This is a very broad question, so I won't go into details on every step. Instead, I summarized the basic process you would want to follow, along with proper terminology to help you locate instructions elsewhere.
Step One: Find a route between two known points
This process is called routing. Here's an excellent blog post by Anita Graser summarizing the ...
There is a coordinate system called "The_World_From_Space", which projects your data into the shape of the Globe:
You can see there are artifacts in this display (of Natural Earth Data), and it doesn't appear to be very raster friendly.
I am used to changing the central meridian of a coordinate system to center the display on a certain longitude, but can't ...
How your map looks like, depends on the projection you use. But since you map an ellipsoid on a flat map, you have a distortion in one way or the other (area, distance, shape, angle, etc.). The best way to show the curvature of the earth would probably be to use a projection, that looks like an ellipsoid, like the Mollweide projection for example. Displaying ...
Have you checked the Planet Explorer gui to confirm the status of your order? It may not have finished processing yet. I suggest using this tool for faster, more user friendly downloads https://github.com/samapriya/porder
First step is to visualize tiles and their unique ID:
SELECT rid, rast::geometry
Then you can visualise specific tiles and group of pixel values:
SELECT (gv).geom, (gv).val
FROM (SELECT ST_DumpAsPolygons(rast) gv
WHERE rid = XX) foo;
You can replace ST_DumpAsPolygons() with ST_PixelAsPolygons() if ...
OpenJUMP does not support PostGIS rasters at all as normal raster images. However, it can be used for visualizing vector data that is returned in the Well Known Binary (WKB) format by the PostGIS Raster function ST_AsBinary https://postgis.net/docs/RT_ST_AsBinary.html.
There is a tutorial about how OpenJUMP can be used for visualizing PostGIS raster data ...