I am creating a query that finds the shortest path from dangerous crossing nodes to hospitals (many-to-many). I have the proper output from pgr_dijkstra, with output as follows  seq | path_seq | start_vid | end_vid | node | edge | cost | agg_cost  -----+----------+-----------+---------+------+------+------+----------    1 |        1 |         2 |       3 |    2 |    4 |    1 |        0    2 |        2 |         2 |       3 |    5 |    8 |    1 |        1    3 |        3 |         2 |       3 |    6 |    9 |    1 |        2    4 |        4 |         2 |       3 |    9 |   16 |    1 |        3    5 |        5 |         2 |       3 |    4 |    3 |    1 |        4    6 |        6 |         2 |       3 |    3 |   -1 |    0 |        5    7 |        1 |         2 |       5 |    2 |    4 |    1 |        0    8 |        2 |         2 |       5 |    5 |   -1 |    0 |        1   I am trying to use st_makeline to create seperate lines for each individual node path, however thus far the function has been creating one big line SELECT  st_transform(st_makeline(t1.the_geom),4326)         FROM pgr_dijkstra(                 'SELECT osm_id as id, source, target, cost FROM spatial.melbourne_edges',                 array(select hospital_id from hospitals_in_vicinity),                  array(select crossing_id from dangerous_crossing_nodes), false) as route                 inner join spatial.melbourne_nodes t1 on route.node = t1.id --);  How am i able to make a column of all the different paths?
I am creating a query that finds the shortest path from dangerous crossing nodes to hospitals (many-to-many). I have the proper output from pgr_dijkstra, with output as follows  seq | path_seq | start_vid | end_vid | node | edge | cost | agg_cost  -----+----------+-----------+---------+------+------+------+----------    1 |        1 |         2 |       3 |    2 |    4 |    1 |        0    2 |        2 |         2 |       3 |    5 |    8 |    1 |        1    3 |        3 |         2 |       3 |    6 |    9 |    1 |        2    4 |        4 |         2 |       3 |    9 |   16 |    1 |        3    5 |        5 |         2 |       3 |    4 |    3 |    1 |        4    6 |        6 |         2 |       3 |    3 |   -1 |    0 |        5    7 |        1 |         2 |       5 |    2 |    4 |    1 |        0    8 |        2 |         2 |       5 |    5 |   -1 |    0 |        1   I am trying to use st_makeline to create seperate lines for each individual node path, however thus far the function has been creating one big line SELECT  st_transform(st_makeline(t1.the_geom),4326)         FROM pgr_dijkstra(                 'SELECT osm_id as id, source, target, cost FROM spatial.melbourne_edges',                 array(select hospital_id from hospitals_in_vicinity),                  array(select crossing_id from dangerous_crossing_nodes), false) as route                 inner join spatial.melbourne_nodes t1 on route.node = t1.id --);  How am i able to make a column of all the different paths?
How do I change skins in minecraft pe? How to generate a random integer number from within a range I tried sudo yum update but it just keeps java "1.7.0_75". I need 1.8 for it to work with another application but can't figure out how to upgrade it. Do I need to manually install it somehow? There's not much information on this on the internet as far as I can see. Specs:   java version "1.7.0_75" OpenJDK Runtime Environment (amzn-2.5.4.0.53.amzn1-x86_64 u75-b13) OpenJDK 64-Bit Server VM (build 24.75-b04, mixed mode)   When I try update now:     [ec2-________]$ sudo yum update Loaded plugins: priorities, update-motd, upgrade-helper amzn-main/latest                                         | 2.1 kB     00:00 amzn-updates/latest                                      | 2.3 kB     00:00 No packages marked for update   Is there anything else I need to do? Thanks. Why was Severus Snape placed in Slytherin? When going to any page of  with a new reputation gain, the achievements dropdown keeps showing a new badge green highlight:    And then trying to dismiss the notification by clicking on it gets rid of the green badge notification, but the +5 remains even after I've clicked away from the dropdown. I hope somebody has already figured this one out. I just installed Geoserver 2.9 on a vanilla Ubuntu 16.04 distro. The Geoserver 2.8 method of enabling CORS with the shanbe.hezoun class does no longer work with Jetty 9.2.13.  There are mentions that CORS support is already packaged with Jetty 9.2.13 in the jetty-servlets.jar.  The Jetty lib which is compiled with Geoserver contains a jetty-servlet-9.2.13.v20150730.jar in geoserver/lib but not jetty-servlets.9.2.13.v20150730.jar. Are these supposed to be the same jar with a different name?  It should be possible to enable CORS either in geoserver/etc/webdefault.xml or in geoserver/webapps/geoserver/WEB-INF/web.xml.  My understanding is that the webdefault.xml is applied first and the web.xml thereafter.  I have tried following filter in both xml. I haven't got as far as adding a filter mapping. Adding the filter alone will cause the Geoserver/Jetty service to not start proper.  &lt;filter&gt;     &lt;filter-name&gt;cross-origin&lt;/filter-name&gt;     &lt;filter-class&gt;org.eclipse.jetty.servlets.CrossOriginFilter&lt;/filter-class&gt; &lt;/filter&gt; Dollar-cost-averaging interval based on decay of autocorrelation? At what time will the upcoming Ubuntu release be made available? Every six months a new Ubuntu version will be released. Does anyone know at which time this will be? Deleting multiple elements from a list Is it possible to delete multiple elements from a list at the same time? If I want to delete elements at index 0 and 2, and try something like del somelist[0], followed by del somelist[2], the second statement will actually delete somelist[3].  I suppose I could always delete the higher numbered elements first but I'm hoping there is a better way. if command in find -exec I was just trying to list all directories and files under current directory and also write if they are file or directory with the following command:  find -exec echo `echo {} : ;if [ -f {} ]; then echo file; else echo directory;fi` \;   I know it is a silly command, I can use other things like -type f or -type d, but I want to learn why that piece of code did not work as I expected. It just prints directory to all of them. For example while output of find is:  . ./dir ./dir/file   output of my code is :  . : directory ./dir : directory ./dir/file : directory   And output of   echo `echo dir/file : ;if [ -f dir/file ]; then echo file; else echo directory;fi`   is  dir/file : file   I am working on Ubuntu 14.10 and using find (GNU findutils) 4.4.2 Is it possible to run Android apps on Ubuntu? And I don't mean inside an emulator, but natively, as you would with any other application installed using the Ubuntu Software Center. How do you convert a matrix to a cell array of equivalent size? Creating polyline-based "heatmap" from GPS tracks? This winter I am planning to track my downhill skiing/snowboarding using a GPS.  Most of my riding will occur at the same resort.  I would like to be able to create a sort of "heatmap" that shows the amount of runs that I have made in a given area.  As I add more and more GPS traces to my database, my goal would be to see a sort of linear heatmap of the most traveled areas.  Given the nature of downhill skiing, you would expect the uphill chairlift lines will be the "hottest" because it will be the only places visited over-and-over again.  Given that 1) my track will not be the same every time and 2) the area covered by following one "run" may be a few hundred feet wide, what might be the best way to analyze this "linear" data to create a sort of heatmap?  My thoughts were to buffer the lines, then intersect the polys to get a sort of Venn Diagram thing going.  My preference is to use open-source technologies.  I've got QGIS and PostGIS loaded and available.  UPDATE: In regards to @blah238's response, I was thinking of something that might be able to "collect" the number of passes ("runs") through an area, and then symbolize by the count.  Conceptually, this would be similar to ArcGIS "" (but for lines, not points) or  (but for multiple line in roughly the same area).  A more visual example of a similar concept might be a traffic-flow map, where highly-congested areas would equate to "highly-traveled" ski runs/areas:    I've read the following questions that may give some ideas, but they don't really address what I am trying to accomplish: How does a wheelie work? So I've been trying to create a mathematical model for an electric motorcycle and began to wonder about the maximum possible torque that could be supplied to the rear driven wheel without having the bike begin to lift up on one wheel.  I found ways to calculate this value online; however, the basic concept as to how the bike actually lifts escapes me.    My problem started when I began to think about what axis the bike will rotate about when it is doing the wheelie.  My first intuition was that the frame and front wheel, together, rotate about the rear axle.  But when I drew a free body diagram of the frame/front wheel system just at liftoff (see below) I made note that the only forces acting about the rear axle, point O, is the force of weight.  This means that an increase in applied torque and subsequently, the applied force Fa, should not effect the rotation about the rear axle.  I know that the applied force on the back wheel is indeed correlated with the propensity for a bike to wheelie, so I considered that the axis of rotation I was choosing was wrong.  If we take the free body diagram above and sum the moments about the center of mass, we would find that an increased applied force would in fact cause the solid body to rotate.  The problem with this understanding is that during rotation, the center of mass of the drawn system should actually rises relative to the surface the bike is moving across.  If the bike were to be truly rotating about its center of mass, then the back wheel would begin to dip below the surface of the road like you might see in a glitchy video game.    So I suspect that the bike is in fact rotating about the back axle, but I don't understand why, please help!  edit: I added the external torque from the back wheel to the frame, which would allow the bike to rotate about the back axle  edit 2:  I suppose that the torque acting on the frame via the engine should not effect the rotation as the movement of a motorcycle can be perfectly replicated by applying a force at the back axle.  A third possible axis of rotation might be the lowest point of the back wheel. Sci-fi book where humanity is rebuilt on a new planet after being wiped out Finding local maximum and minimum How to drive multiple LEDs from a Li-ion battery (with varying voltage)? I've tried different ways to install iTunes, but to no avail. I tried with Wine, but it didn't work. Is it possible to have iTunes on Ubuntu? What "exactly" happens when someone turns to the Dark Side? When I saw the original Star Wars saga as a kid, the concept of the Dark Side imprinted in me was quite simple. You did a bad thing, so you're a bad person so you go to the Dark Side and keep doing bad things.  Now, obviously this doesn't hold true in reality. In my mind it is perfectly reasonable for Luke to kill the Emperor and Vader and then just flee the Death Star and rejoin the Alliance. After all they are at war, those are enemy officers that have captured him and are taunting him by threatening with death of all loved ones and the whole operation was intended to kill the Emperor anyway.   The same would hold true for Anakin. He could have killed Mace Windu to save the Chancellor and Padme but that doesn't mean he's going to then go mad and kill all Jedis including children. It doesn't add up from a merely psychological point of view. He had a set of objectives and that made him want to keep the Chancellor alive (quite valid by the way, Mace Windu is quite clumsy on that) but just after killing him he goes into "Yes master I'll do whatever you say" which from a normal point of view will NEVER ever make sense.  In both cases it seems like the assumption is once you use the Dark Side you completely turn to the Dark Side and become a different person that you were before. That would be coherent with Anakin "dying" and Vader being born.  Is that the way the Dark Side works? Is there any canon information about what happens when someone turns to the Dark Side? Specifically to whether they become a different person or how he or she actually changes?  Note: Vader is angry after he finds out Padme is dead, even though he's already turned.  Example of what I mean. In Buffy they explain how people that turn into Vampires lose their soul and it's taken over by a demon, and thus they are, in all effects, a different person with their memories. "Goose"–"geese" vs. "moose"–"moose" Why is it that the plural of goose is geese but the plural of moose is moose? The same goes for mouse and house. Mouse becomes mice, yet house becomes houses.