PostGIS: Closest polygon to point
Finding the closest Geometry in PostGIS
Is the use of a hyphen between "non" and an adjective strictly necessary? Do I need to put a "-" between "non" and an adjective? As an example in physics we say "a non isolated photon", "non tight photon"... The context is very formal (paper publications and similar). Is there a general rule? Are there some differences between countries? What is the C# equivalent of NaN or IsNumeric? What is the most efficient way of testing an input string whether it contains a numeric value (or conversely Not A Number)? I guess I can use Double.Parse or a regex (see below) but I was wondering if there is some built in way to do this, such as javascript's NaN() or IsNumeric() (was that VB, I can't remember?).  public static bool IsNumeric(this string value) {     return Regex.IsMatch(value, "^\\d+$"); } How can one request reconsideration of a   after a certain period of time, let us say after one year? So to help prevent brute force attacks against my phpmyadmin install I've configured nginx to require HTTP Basic Auth (extra username and password) and then the requests need to come from a whitelisted IP Address. However the IP Address whitelist works fine if I run  however without adding the extra .php block I could load  without my IP being whitelisted. This issue doesn't affect the HTTP Basic Auth. Is there a reason this happens? Anyway to get around having to add extra .php blocks? A copy of the config area for phpmyadmin is below.  # Setup and secure phpMyAdmin location /phpmyadmin/ {   allow 1.2.3.4;   deny all;   auth_basic "phpMyAdmin - HTTP Basic Login";       auth_basic_user_file /etc/nginx/pma_pass;     location ~ \.php$ {     include snippets/fastcgi-php.conf;             fastcgi_pass unix:/run/php/php7.0-fpm.sock;     allow 1.2.3.4;     deny all;     } } Can anyone can suggest where I can freely download ArcObjects SDKs for ArcGIS?  I am using version 10.2. So, @AndrewO mentioned recently that he has had 'encounters' with people wondering why D-Wave has a lot more qubits than IBM. Of course, this comparison is faulty, since the IBM and D-Wave's machine may both exploit quantum effects to a certain degree, IBM's machine matches the thing the TCS people call a 'Quantum computer' a bit more than D-Waves's alleged quantum annealer.   How do you explain to a novice why IBM is still reaching important milesstones, even though the D-Wave has a lot more 'qubits'. I understand that an easy answer is, 'well, you're comparing apples and pears', but that is merely relying on your possible authority and simply doesn't explain anything!   How can you explain that those devices are different, how can you dispell the myth that the number of qubits is not the only metric to judge quantum devices? (preferably to a layman, but assuming basic (undergrad?) physics knowledge is ok, if needed) Trigger to check for duplicate contacts on lead conversion I'd like to write a Lead trigger, to check for duplicate Contacts before inserting the lead, or converting it.   Contacts fields I'd like to check:   Firstname - should not be the same as the leads name Lastname - should not be the same as the leads name Email - should not be the same as the leads phone   After checking these fields &amp; failing to find a duplicate, only then should the lead be converted. Random real numbers that sum up to specific value Possible to change where Android Virtual Devices are saved? I want to perform performance testing on my test server.  How can I capture workload from production and replay on my test server?   Basically I'm looking for detailed steps so that I can replay the workload from production to my test environment. Let $X_1$ and $X_2$ be two independent exponential random variables with the PDFs $f_{X_1}(x_1)=\lambda_1 \exp(-\lambda_1 x_1)$ and $f_{X_2}(x_2)=\lambda_2 \exp(-\lambda_2 x_2)$.   Let $X= \frac{X_1X_2}{X_1+X_2+a}$ be a r.v. for which I want to derive the CDF, where $a$ is a positive constant.  In other words, I need to calculate $\mathbb{P}\{X &lt;x \}$.  Any ideas or hints?  Edit (attempt):  Using a similar approach to that used , we have $X_1 \in [0, \infty)$ and  $X_2 \in [0, \frac{x(x_1+a)}{x_1-x})$. The latter interval results from: $\frac{x_1x_2}{x_1+x_2+a} &lt; x$, thus $x_2(x_1-x)&lt;x(x_1+a)$ which implies $x_2 &lt; \frac{x(x_1+a)}{x_1-x}$; but I am not sure if this is correct since $x_1-x$ can sometimes be negative (?). Based on the above, we can write: \begin{align}  \mathbb{P} \{ \frac{X_1X_2}{X_1+X_2+a} &lt; x \}  &amp; = \int_{x_1=0}^\infty \int_{x_2=0}^{ \frac{x(x_1+a)}{x_1-x}} \lambda_1 \exp(-\lambda_1 x_1) \lambda_2 \exp(-\lambda_2 x_2)  dx_2 dx_1  \\ &amp;= \int_{x_1=0}^\infty \left(1-\exp(-\lambda_2\frac{x(x_1+a)}{x_1-x}) \right) \lambda_1 \exp(-\lambda_1 x_1) dx_1  \\ &amp; = 1-\lambda_1 \int_{x_1=x}^\infty \exp(-\lambda_2\frac{x(x_1+a)}{x_1-x} ) \exp(-\lambda_1 x_1)   dx_1 \end{align} In the last equality: for the integral of $\lambda_1 \exp(-\lambda_1 x_1) dx_1$, I suppose that $x_1 \in [0,\infty)$, whereas for the second term I suppose that $x_1 \ge x$ (since $x_2$ should be positive) (?).  Is my approach correct ? JavaScript window resize event Checking if two Poisson samples have the same mean This is an elementary question, but I wasn't able to find the answer.  I have two measurements: n1 events in time t1 and n2 events in time t2, both produced (say) by Poisson processes with possibly-different lambda values.  This is actually from a news article, which essentially claims that since $n_1/t_1\neq n_2/t_2$ that the two are different, but I'm not sure that the claim is valid.  Suppose that the time periods were not chosen maliciously (to maximize the events in one or the other).  Can I just do a t-test, or would that not be appropriate?  The number of events is too small for me to comfortably call the distributions approximately normal. How should references in non-Latin script language be treated in English paper? Let's say I want to cite a Russian text in my own paper which is written in English. Should I:   reference it as is, in the original Cyrillic alphabet, although the readers won't be able even to pronounce it? transliterate the authors' names, while keeping the rest as is? transliterate the names and translate the title of the work, journal name, etc. into English? Can a child inherit both their parents' clans jutsu? Can a child in Naruto inherit both abilities from his parents' clans?  For example, if Ino and Sasuke had a child is there a possibility for it to have both Uchiha's Sharingan and Yamanaka's mind transfer jutsu? I posted a question which was closed as off-topic and it seems like it could fit on another site in the network. How can I go about moving it there?   What is migration? When can a question be migrated, and who can migrate it? When should I consider migration, and when is it inappropriate? What causes a migration to be blocked and what happens after? What causes a migration to be rejected and what happens after? Anything else I should know about migration? How do I Uninstall Windows 10 or Windows 10 preview? I joined in the  and I don't like it. However, this question may also be relevant to those who install the full version of Windows 10.  How can I downgrade back to Windows 8/7 from Windows 10 or Windows 10 preview? Information on month old flights Where can I get flight info for a flight a month ago for an insurance claim? Flight stat sites will only show a weeks worth of data. The Monty Hall problem I was watching the movie 21 yesterday, and in the first 15 minutes or so the main character is in a classroom, being asked a "trick" question (in the sense that the teacher believes that he'll get the wrong answer) which revolves around theoretical probability.  The question goes a little something like this (I'm paraphrasing, but the numbers are all exact):  You're on a game show, and you're given three doors. Behind one of the doors is a brand new car, behind the other two are donkeys. With each door you have a $1/3$ chance of winning. Which door would you pick?  The character picks A, as the odds are all equally in his favor.  The teacher then opens door C, revealing a donkey to be behind there, and asks him if he would like to change his choice. At this point he also explains that most people change their choices out of fear; paranoia; emotion and such.  The character does change his answer to B, but because (according to the movie), the odds are now in favor of door B with a $1/3$ chance of winning if door A is picked and $2/3$ if door B is picked.  What I don't understand is how removing the final door increases the odds of winning if door B is picked only. Surely the split should be 50/50 now, as removal of the final door tells you nothing about the first two?  I assume that I'm wrong; as I'd really like to think that they wouldn't make a movie that's so mathematically incorrect, but I just can't seem to understand why this is the case.  So, if anyone could tell me whether I'm right; or if not explain why, I would be extremely grateful. Moving Grub to a new drive to get rid of Windows