I am trying to see if two "circles" intersect. The data I have is  two points and two radii (in meters). I am using srid 4326.  My main issue (i think) is getting the radius in meters.  SELECT (ST_Buffer('POINT (-104.949517 39.740264)',300) &amp;&amp;            ST_Buffer('POINT (-104.999924 35.000089)',300))   My questions are   Is there a more clever way to do this? Or how do I convert the radius from dd to meters to get correct buffers?
I'm using PostGIS 1.5.2, with geometries in SRID:900913. I need create a circles using a list of points as centre, with a radius of 600 kilometers. I'm using this query:  INSERT INTO circles (geom) (    SELECT ST_Buffer(point, 600000, 'quad_segs=8')     FROM points );   But circles created have not 600 kilometers of radius (radius is near this length, but not exactly).  Are there other methods to create circles in PostGIS?  NOTE: Information represented is from Spain. Correct projection is 4326, but client use Google rasters, so I am storing data in 900913 to avoid reprojections and increase performance.
I am trying to install linux on my laptop, a Toshiba Satellite C6550-S5200. I did it once but something happened so I removed it then I had to destroy all data on hard drive so now I have nothing on it. Well I got a iso file burned to a CD and to a flash drive. With the flash drive I get.   SYSLINUX 4.06 EDD 4.06-pre7 Copyright (C) 1994-2012 H. Peter Anvin et al  With the CD it will start booting it but somewhere loading it up, the dots turn all orange and stay that way and my CD drive turns quiet.  Oh and some more info the images work because I tried loading them up on another pc and it worked just fine.  I manage to get the CD to boot I just had to let me pc boot up first then insert the CD and have it boot the CD then. Once I get done installing ubuntu it works fine but I have to leave the PC on 24/7 for if I turn it off the PC will freeze 5-10 seconds after booting back up no matter how I install it. Use of .apply() with 'new' operator. Is this possible? I have 24 accounts, how can I delete them all in one go? Is there a way to delete all stack exchange accounts at the same time?  I also want to remove all traces of my posts on the site. Is that possible?   Will I have to delete all of my posts manually?  Can I use the stack exchange API for this? Bind application to a specific network interface I have tried ForceBindIP, but it has a significant downside - it doesn't affect the children of the application I'm trying to bind, it only affects the application itself. It also can't force an application to always run through a specified interface, it has to be run through forcebindip.exe every time. It becomes a problem with applications like League of Legends where the process tree looks like that:    The launcher runs the patcher, the patcher run the client, etc. I can only affect the parent of all these processes in the tree, so the actual game is not bound to the interface I want, making this whole venture pointless.  Is there a more modern alternative to ForceBindIP for Windows 7? There are many questions similar to this one on this site, but they are mostly old. Maybe there is now a better way to solve this problem?  My current idea is to do the following:   Set up local 3proxy server bound to the desired interface. Run the game through Proxifier or similar software configured to run through that local proxy.   I'm not sure if that will work, but even if it will, it seems like a sub-optimal solution. Do you guys have any better ideas?  Edit: My idea didn't work :(  Edit 2: Basically, what I'm trying to achieve is bind a few applications to a regular interface, while VPN is running. The reason is that I need to connect through VPN most of the time, but some applications (such as games) don't work properly this way, because of higher ping and other issues. I've already defeated the Big Bug.   I see the hint that the small bugs disguised as cursors are vulnerable to the three words "Charity", "Uganda", and "Bram".  I think I have all keys available, I've tried undoing with the bugs on the three words, I've tried motions which include the three words in their range, I have each of the three words stored in a named register, but I haven't figured out how to defeat the three small bug minions underground in Level 14 of Vim Adventures.  I suspect I should have defeated them before defeating Big Bug, maybe even before finding 'undo'. Is there instead something I should do in the 'lorem' buffer where I found the three cursors (Blue, White, and Pink) at the beginning of the level?  How does one defeat the three small bug minions in Level 14? Getting the class name of an instance? Cast Double to Integer in Java Nouns can modify nouns: cat food, coffee cup, gold ring, laser surgery, flood insurance. It seems to me there are even cases where a noun sounds better than the corresponding adjective: sociology papers sounds a bit better than sociological papers.  Some noun-noun combinations don&rsquo;t work. You wouldn't say America gangsters or measurement spoons or greed crimes. If you spilled water on your keyboard you probably wouldn't call it a keyboard spill or even a water spill.  Are there rules that tell which combinations are acceptable? When I'm editing a stack snippet, I often want to copy code from the original question into the snippet. But while the snippet editor is on display, there's no way to access the question, other than opening another tab/window. What I often do instead is copy all the code in the question to the clipboard, open the snippet editor, then paste it all in and revise it to what I want. But when the original code is poorly designed, that ends up being more work than just copying the bits and pieces that I want.  There could be a "View Question" button that pops up the question over the snippet editor and allows copying. Or maybe the Snippet Editor could be draggable and resizable, so you can reveal the question and copy from it; but this would require that it not be purely modal. Some time ago, we announced that . This has gone well and we're extremely thankful to everyone for their support and feedback. Because it has been successful so far, we're going to be extending the program to the majority of our graduated sites. Well, we've pretty much already done that, but there are quite a few sites that have ads enabled, yet still display nothing. The thing is, we don't really have an abundance of clients offering products that a  would find relevant, but Amazon has stand mixers, a selection of super fine chinois, deliciously sharp cutlery and enough cast iron to fill the Gulf Of Mexico with . Beginning as early as this week (week of 5 February 2018), our ad team is going to be hand selecting affiliate ads to be displayed on select sites. The use of inventory will of course depend on the availability of relevant ads to display which means:  Some sites might see very few, if any ads. Some topics simply don't come remotely close to orbiting anything worth advertising. Furthermore, while graduated, some sites simply don't have enough activity for ads to make sense.  Since these are hand-selected, it could take a while for ads to appear initially.  These would of course yield to inventory from clients if clients had products that were relevant to any given topic.   Nothing changes when it comes to the . If you're used to occasionally seeing a community promotion ad, you'll just notice that you'll also occasionally see an ad for something that is likely to be of interest to someone interested in the topic that your site covers. In fact, to be clear, this is simply a continuation of the announcement we made in November of 2016. We just wanted folks to know that we're going to be continuing the program where there's good potential to show relevant advertisements, even if we don't have clients lined up with a demand for it. Where can I give feedback about a certain ad on [site]? Open a meta post on your per-site meta and let us know. Please remember, the bulk of advertisements are an effort to get something small back from folks that hit the sites through search engines and are extremely unlikely to ever become contributors. Their soufflé stopped falling, and we'll probably never see them again. Maybe we can get a few bucks once they realized that copper ions help egg whites stiffen properly and buy a bowl or a proper bloom whisk. However, you're the experts on these topics and we're very likely going to listen to you. What sites, specifically? Are any sites exempt? If you're a former Stack Exchange 1.0 site and / or subsequently joined the network under a special charter, nothing changes - don't panic :) For the rest, we're just extending what we're currently doing with ads on graduated sites to also include those where there's an opportunity to make sensible use of affiliate ads. If a site has less than 15k (average) daily visits, or fewer than roughly 50k combined total posts - it might not yet be time to invest in selecting ads to be shown there. But, part of this exercise is also seeing what works best. I don't really have feedback, just some suggestions Ads aren't just an opportunity to sell stuff, they're an opportunity to really show people that we understand a given topic. That, of course, makes suggestions from people that do that stuff every day quite valuable. Post on your per-site meta and our community / ad critters will take a look. Questions? Comments? Kvetches? Let us know in an answer or comment below. If anything about the plan changes, we'll update this post to let folks know. How do I deliver a baby? I'm playing Fallout Shelter, and my newest bonus objective is to "Deliver 1 Baby Dweller."  I've already figured out that I can put a male vault dweller and a female vault dweller together in some residential quarters, and and eventually, if they hit it off, the lady will replace her vault suit with a yellow sweater and a decidedly pregnant figure.   Good enough.  But how long does it take her to deliver the child? Do I have to induce it through some sort of tapping ritual or placing her in the correct room? Does the pregnant dweller need to stay in the living quarters, or can I put her to work in my Diner or Water Treatment Facility? Do the SPECIAL stars of the parents matter?  Tell me everything about  and what I can do to control the process. JavaScript equivalent to printf/String.Format I'm looking for a good JavaScript equivalent of the C/PHP printf() or for C#/Java programmers, String.Format() (IFormatProvider for .NET).  My basic requirement is a thousand separator format for numbers for now, but something that handles lots of combinations (including dates) would be good.  I realize Microsoft's  library provides a version of String.Format(), but we don't want the entire overhead of that framework. Is there a saying or idiom for "trying to get the truth from someone by lying"? context   Mary-Ann got home late from school.  Asked where she had been, she said she had spent the afternoon at the library.  Her father thinks she is lying and says: "I know you haven’t been there because I was there myself".  He is lying because he thinks she will tell the truth if she realizes she has been caught. boyfriend – “your sister told me everything” (sister did nothing) -  girlfriend – “Oh, did she? I’m gonna kill her.    The rationale for doing this is to catch someone by surprise so he will admit having lied.  Soemtimes, however, the person isn’t lying and the real liar will have to reap the consequences of his reproachable action, having to admit he was just/it was just ...........(saying or idiom)..... Correct usage of 'but for'? Does 'but for' mean:  'If we had X (but we didn't), Y would have been the consequence'?  Or can it also mean; because we had X, as a result Y happened?   Some different examples of but for:  (Case 1)     But for a cup coffee, it was to be a productive day of writing.   Unfortunately, I'd run out, and spent the day craving.    (Case 2)     But for the glass of wine I had dinner, the house work didn't get   done.   (Case 3)     But for the glass of wine I had for dinner, I would have got the   house work done   What is the correct usage of "but for"? We always say that tree levels are classical but loop diagrams are quantum.  Let's talk about a concrete example： $$\mathcal{L}=\partial_a \phi\partial^a \phi-\frac{g}{4}\phi^4+\phi J$$ where $J$ is source.   The equation of motion is $$\Box \phi=-g \phi^3+J$$  Let's do perturbation, $\phi=\sum \phi_{n}$ and $\phi_n \sim \mathcal{O}(g^n) $. And define Green function $G(x)$ as $$\Box G(x) =\delta^4(x)$$  Then   Zero order:  $\Box \phi_0 = J$   $\phi_0(x)=\int d^4y G(x-y) J(y) $  This solution corresponds to the following diagram:  First order:  $\Box \phi_1 = -g \phi_0^3   $  $\phi_1(x)=-g \int d^4x_1 d^4x_2 d^4x_3 d^4x_4 G(x-x_1)G(x_1-x_2)G(x_1-x_3)G(x_1-x_4)J(x_2)J(x_3)J(x_4) $  This solution corresponds to the following diagram:  Second order:  $\Box \phi_2 = -3g \phi_0^2\phi_1  $  $\phi_2(x)= 3g^2 \int d^4x_1 d^4x_2 d^4x_3 d^4x_4 d^4x_5 d^4yd^4z  G(x-y)G(y-x_1)G(y-x_2)G(y-z)G(z-x_3)G(z-x_4)G(z-x_5) J(x_1)J(x_2)J(x_3)J(x_4)J(x_5) $ This solution corresponds to the following diagram:  Therefore, we've proved in brute force that up to 2nd order, only tree level diagram make contribution.  However in principle the first order can have the loop diagram, such as  but it really does not occur in above classical calculation.  My question is:   What's the crucial point in classical calculation, which forbids the loop diagram to occur? Because the classical calculation seems similiar with quantum calculation. How to prove the general claim rigorously that loop diagram will not occur in above classical perturbative calculation. Halo particles don't render in Cycles Formula for coordinates (lat, lon), azimuth and distance. I would like to know how to find a set of coordinates on a small circle some distance from another point.   For example, lets say A = (39.73, -104.98) #Denver  B = (39.83, -106.06) #point approximately 50 nautical miles away from A along the great circle track to C  C = (40.75, -111.88) #Salt Lake City, approximately 323 nautical miles away from A  How do I get the set of orange coordinates when I don't know the angle but I do know the cross track distance?  For concreteness, lets say the outer points near B have a cross track distance of +- 30 nautical miles and the inner points have a cross track of +- 15nm.  And the points near C have a cross track of +- 25 nm.  Also I have an initial bearing from A to C of -1.34 #radians I've created a new C++ project in Visual Studio 2008.  No code has been written yet;  Only project settings have been changed.  When I compile the project, I receive the following fatal error:     fatal error LNK1104: cannot open file 'C:\Program.obj' Which Pokemon have the highest CP cap? It's clear that the evolved form of Pokemon have a far higher CP cap (and it looks like minimum too) but it would also seem there is a difference between different Pokemon.   For example I have an Oddish at 184 CP which is at 50% of it's cap, and I also have a Ratata at 185 CP but it is far closer to its cap, around 90%.  Which Pokemon have the highest CP caps? How many roots have a complex number with irrational exponent? If a rational exponent on a complex number $z^q$ is the representation of a finite number of roots, then if the exponent is irrational this mean that there is infinite countable roots?  If this is the case... the cardinality of the number of roots is the same for any irrational exponent? Thanks in advance.  NOTE: there are different questions about irrational exponents but no one answer what Im searching so please dont mark this as repeated.