I have GPS locations with date. These are points.  I want to convert the points to lines, sorted by date.  Using PostgreSQL  Tried:  SELECT observations.id,        ST_MakeLine(observations.geom ORDER BY observations.date) AS newgeom FROM   observations  GROUP BY        observations.id ;   The problem is that the single line values gives the same coordinates. So, there will be no line. 0 and 1 are the same.    How is this possible?
How do i create a linestring from points sort by date in PostgreSQL?  I tried:  SELECT observations.id,    ST_MakeLine(observations.geom ORDER BY observations.date) AS newgeom    FROM   observations     GROUP BY    observations.id;   This is going wrong. It returns me a linestring with same coordinates.  So, instead of a line from a to b, it gives me a to a.    What am I doing wrong?
Android OS without Google Services? In s08e03 we see Melisandre and Arya meet for the second time after Season 3 when Melisandre said to Arya back then:     "I see a darkness in you. And in that darkness, eyes staring back at me. Brown eyes, blue eyes, green eyes. Eyes you'll shut forever. We will meet again. "   I think Blue Eyes referred to the Night King and the White Walkers since we saw Arya killing the Night King in s08e03.   I also believe that Brown Eyes referred to Walder Frey who was also killed by Arya back in Season 6.    But where do the Green Eyes reffer to? I don't remember her executing any important character with green eyes. My guess is that:       they reffer to Cersei. Do you think that  the prophecy implies that she is going to bring her hateful enemy down somehow? $A \subseteq \mathcal{R}(N)$ and given that (by inductive definition):   $N ∈ S$. If $a \in R$, then $R \setminus \{a\} \in A$.    I need to prove that for each $A \in S$, $N\setminus A$ is finite. How can I prove this formally? Let $G$ be a group and $c\in G$. Define $*$ on $G$ by: $x*y=xdy$ for all $x,y\in G$, where $d$ is the inverse of $c$. Prove $(G,*)$ is a group. Let $G$ be a group and $c$ be a fixed element of $G$. Define a new operation $*$ on G by:   $$x*y=xdy$$   for all $x$ and $y$ in $G$, where $d$ is the inverse of $c$. Prove that $G$ is a group under the operation $*$.    If you want to check, this problem is in the book “A Course In Group Theory”, by John F. Humphreys (problem $3$, page $28$)   I know what are the axioms that $(G,*)$ must obey in order to be a group and I did show that all the axioms where obeyed except the inverse axiom.  My problem is that, whenever I try to verify what would the inverse be for some element $x$, I get an equation where the $x$ is cancelled in both sides.  Can please someone guide me?  Thank you!  (P.S.: This is NOT a homework assignment, I’m studying Group Theory by this book and got problems solving this question) I have a large hole in a mesh that I'm trying to fill:    I've been trying an approach like this:    I'm finding it quite tough, since the number of vertices around the perimeter of the hole don't match a grid.  Is there a better approach to filling a hole like this? I think it would be nice to display tags in alphabetical order. Currently, tags are displayed in order of creation.  As a workaround, I remove, and then add the tags, which is a bit dumb, but I like 'em in alphabetical order.  It's probably pretty trivial to implement, and nice to have! Create a shortcut for URL? If $d(x,y)$ is a metric, then $\frac{d(x,y)}{1 + d(x,y)}$ is also a metric Regular expression to match balanced parentheses I need a regular expression to select all the text between two outer brackets.  Example: some text(text here(possible text)text(possible text(more text)))end text  Result: (text here(possible text)text(possible text(more text))) Questions on "All Horse are the Same Color" Proof by Complete Induction Using QGIS3 Processing algorithms from standalone PyQGIS scripts (outside of GUI) I'm writing a script which must work outside of QGIS GUI. I call some API functions from qgis.core but I'd like to use the processing plugin.  I'm able to import processing with sys.path.append() but I can't run any process. Moreover, all "native" algs are missing in QgsApplication.processingRegistry().algorithms()  So is it possible to run processing that way ? What am I missing ?  import os, sys from qgis.core import * QgsApplication.setPrefixPath('/usr', True) qgs = QgsApplication([], False) qgs.initQgis()  sys.path.append('/usr/share/qgis/python/plugins') from processing.core.Processing import Processing Processing.initialize() import processing  layer1 = QgsVectorLayer('data/ROUTE_PRIMAIRE.SHP') layer2 = QgsVectorLayer('data/ROUTE_SECONDAIRE.SHP')  processing.run('qgis:union', layer1, layer2, 'test.shp') # returns nothing   I'm on QGIS 3.0.1 - Debian 9 Modern electronics industry has developed very efficient LEDs with nice and fancy colors (“true green” , “cyan”, and “blue”) based in InGaN technology, or similar. Some of these LEDs are specified as having forward voltages of 3.2 to 4.2 V. Here are examples of such LEDs, , or surface-mount .  But the usual MCUs are powered from 3.3 V supply, and the GPIO output is usually at 3.1-3.2 V, which seems to be barely enough to drive these LEDs . How can I use these LEDs as indicators of some signal statuses, or power rail status? Do I need a series resistor R1 here?    If yes, how do I choose its value?  DISCLAIMER: This "question-answer" comes as elaboration of the original question , to address the particular use case of LEDs as logic state indicators. Is there a website with historical temperatures and weather data? I am interested in hiking this fall in France and camping along the way. In order to figure what gear I need to pack to camp (particularly for the sleeping bag), I would like to know what temperatures to expect.  I am interested in historical temperatures to figure the usual temperature and I might look at them for other seasons. If that matters, I am thinking about hiking in the Pays Basque (South West of France), the mountainous part.  Where (ideally online and for free) can I find such data? Are there resources that cover Europe, or even the whole world? I had the following two problems:     Find a counterexample for $f_*(A \cap B) \supseteq f_*(A) \cap f_*(B)$ and $ f_*(A-B) \subseteq f_*(A) -f_*(B).$ Where $f_*(X)$ is the image of $X$ under $f$ for some function $f:A \rightarrow B $ and some subset $X \subseteq A$.   I came with the following answer:  Let $ f: \mathbb{Z} \rightarrow \mathbb{Z} $, where $f: x\mapsto 0$; let $A=\{1,2\}$, and $B=\{3,4\}$.     For $f_*(A \cap B) \supseteq f_*(A) \cap f_*(B)$, $$ f_*(A \cap B) = f_*\{ \varnothing\} = \varnothing \hspace{1cm} \text{and} \hspace{1cm} f_*(A) \cap f_*(B)=\{0\} \cap \{0\} = \{0\}. $$ It follows that $ \varnothing \nsupseteq \{0\} $. For $ f_*(A-B) \subseteq f_*(A) -f_*(B)$, $$f_*(A-B)=f_*(\{1,2\})=\{0\} \hspace{1cm} \text{and} \hspace{1cm} f_*(A) - f_*(B) = \{0\} - \{0\} = \varnothing$$ It follows that $ \{0\}  \nsubseteq \varnothing $.   Now (assuming my answer is correct), let's say I want to find more counterexamples or maybe a more general answer (e.g. all the conditions under which the inclusion fails). Other than by trial and error or just intuition, how would I do that?   I know this is a broad question, so I'm specifically asking for methods or advice on how to build counterexamples in elementary set theory (for example, tips on where to begin or rules that apply in general that may be unobvious). How to navigate to C drive in bash on WSL-Ubuntu? Why and how is sound produced when two objects hit each other? When two objects collide and undergo a partially inelastic collision (so every one we experience in every-day life), they rebound to a certain degree, but kinetic energy is not conserved. Thus, the energy of motion must be converted to another type of energy. Thus, when two object collide, the most common forms of energy that kinetic energy is converted to are sound energy and thermal energy.   Some collisions are louder than others just because they cause a bigger local variation of pressure (which then propagates through air until finally gets heard). So, why some objects, even if the velocity before and after the collision seems to be the same, are louder than others? I mean, how do the different material properties enter in the phenomenon?  How and why, by means of solid and fluid mechanics or with an heuristical microscopical reasoning, can this process be explained? Should I follow what was mentioned in the “duration of stay” or in the "validity of the visa"? I'm from Tunisia and I got a Schengen visa from the Austrian Embassy for  28 days, the “duration of stay”, and the number of entries is 1. But the validity of the visa is from 02/08/2015 to 13/09/2015.  Do I have to stay only 28 days, for example from 02/08/2015 to 29/08/2015 or can I stay there until 12/09/2015 ?  And if I have got to stay only 28 days, then can I choose the days of stay, that's mean can I stay in Austria for example from 09/08/2015 to 05/09/2015? Ill implement the some UI but its not working in the visualpage , can u know how implement jquery ui in viusalpage ,  Kindly tell the procedure ,     Im using this url its not working ,,,,, Seeing strange things in light I have noticed that if you look directly at tubelight (I have only white ones in my home) and close your eyes little, you see little random shaped colourless things sometimes with slow speed and sometimes with falling down.   They are shaped like circles with something in between and in chains of random length.   My father has also seen them. So, I am sure I am not imagining things. What the hell are they? Reference for general-topology