I have a simple CSV of {lat,lon,text} and I want to export it as a WGS84 Shapefile.   How can I achieve this?
I am using QGIS 2.6.1 and have worked in an Excel file database (which was actually converted from a Shapefile). I have managed to convert it as CSV file and load it into QGIS (displays data fine) but I have trouble to convert it to a shapefile.  I can view it but I can´t add or alter data in this file. I think I have to save it as a database.   Any clues how to convert the xlsl-data to a database and finally to a shapefile?
I know that the product of two Gaussians is a Gaussian, and I know that the convolution of two Gaussians is also a Gaussian. I guess I was just wondering if there's a proof out there to show that the convolution of two Gaussians is a Gaussian. L1 & L2 Regularization in Light GBM This question pertains to L1 &amp; L2 regularization parameters in Light GBM. As per official documentation:  reg_alpha (float, optional (default=0.)) – L1 regularization term on weights.  reg_lambda (float, optional (default=0.)) – L2 regularization term on weights  I have seen data scientists using both of these parameters at the same time, ideally either you use L1 or L2 not both together.   While reading about tuning LGBM parameters I cam across one such case: Kaggle official GBDT Specification and Optimization Workshop in Paris where Instructors are ML experts. And these experts have used positive values of both L1 &amp; L2 params in LGBM model. Link below (Ctrl+F 'search_spaces' to directly reach parameter grid in this long kernel)      I have seen same in XGBoost implementations.  My question is why use both at the same time in LGBM/XGBoost.  Thanks. I'm looking at creating a basic ORM (purely for fun), and was wondering, is there a way to return the list of tables in a database and also the fields for every table?  Using this, I want to be able to loop through the result set (in C#) and then say for each table in the result set, do this (e.g. use reflection to make a class that will do or contain xyz).  Further to this, what are some good online blogs for SQL Server? I know this question is really about using system SPs and databases in Sql Server, and I am ok with general queries, so I'm interested in some blogs which cover this sort of functionality.  Thanks How is floating point stored? When does it matter? In follow up to , it appears that some numbers cannot be represented by floating point at all, and instead are approximated.  How are floating point numbers stored?  Is there a common standard for the different sizes?  What kind of gotchas do I need to watch out for if I use floating point?  Are they cross-language compatible (ie, what conversions do I need to deal with to send a floating point number from a python program to a C program over TCP/IP)? Human & Alien captured, observed by higher beings From a collection of short stories I read at least 30 years ago. :/  This is going to be incredibly vague, so apologies in advance.  A human and alien (blob/octopus-like...I think) from warring races are captured by an unidentified higher intelligence and put in an enclosure (more like a zoo habitat rather than a prison cell). They are separated by an invisible barrier and can see each other.  I think they were both trying to escape or trying to figure out how they could kill the other first. There was a bulldozer/loader type vehicle they could use at one point to build a shelter (or something).  I believe they were crafting makeshift weapons as well. There was no communication between the two as far as I remember.  The main tension in the story seemed to be was the race to get to the other first.  This has been stuck in my head forever. I know its a very common theme.  The short stories may have included Asimov. Complete beginner here.  I'm trying to follow  tutorial on Anisotropic shaders, but my property panel looks nothing like the property panel in the tutorial.  For example, when creating a material, this is what his property panel looks like:    But this is what mine looks like, if I follow the same path:    I'm sure I'm missing something obvious.  How can I see the property panel shown in the tutorial? Sometimes I wonder if he is actually/really  as lavish as he   pretends to be.   I know that this sentence can work without either actually or really, but if we were to use one of them to make an impact on the listener, which one should it be? Can the “while attuned” powers of Solarian stellar revelations be used while attuned to either mode, or only the matching one? How to change the light grey text that many web sites seem to use these days? Of late, I've noticed that many web sites seem to be using light grey text for many sections of their sites. Some such sections include - the text (link, usually) that shows in the status bar at the bottom of the browser when you hover the mouse over a link on their page, the indicator text in form fields to be filled in (e.g. the word "email" in the email address field), and many other elements on the page.  That light grey makes it much less readable.    Not sure whether is a new trend, or something to do with my browser settings (I haven't changed them lately, AFAIK), or Google Chrome, which is my browser. This is on Windows 7 running on a Dell Vostro laptop. I added the info about the laptop because I suspect the problem may even be due to my hardware settings, since I found the default brightness to be too high after I bought it, and changed it via Control Panel.  Would like to know what are some of the things I can check or change to solve this.  Thanks. We know that some people were aware of the fact that Lord Voldemort was Tom Marvolo Riddle prior to his return in Goblet of Fire; at the very least his close soon-to-be-Death-Eater &quot;friends&quot; and Albus Dumbledore:  “Very few people know that Lord Voldemort was once called Tom Riddle. I taught him myself, fifty years ago, at Hogwarts...&quot; ... underwent so many dangerous, magical transformations, that when he resurfaced as Lord Voldemort, he was barely recognizable. Hardly anyone connected Lord Voldemort with the clever, handsome boy who was once Head Boy here.” (Professor Dumbledore to Weasleys, Chamber of Secrets, CHAPTER EIGHTEEN, Dobby’s Reward)  and  “Voldemort,” said Riddle softly, “is my past, present, and future, Harry Potter…” He pulled Harry’s wand from his pocket and began to trace it through the air, writing three shimmering words: TOM MARVOLO RIDDLE Then he waved the wand once, and the letters of his name rearranged themselves: I AM LORD VOLDEMORT “You see?” he whispered. “It was a name I was already using at Hogwarts, to my most intimate friends only, of course. ...  (Tom's Diary manifestation in the Chamber of Secrets).  QUESTION: Who - based on canon (books/interviews/pottermore) - knew about the fact that Lord Voldemort was Tom Marvolo Riddle prior to Ginny being taken to the Chamber of Secrets? Obviously, Albus Dumbledore and Tom himself. Who else? Where did the pardon come from? In the  episode  (S04E08), Barristan Selmy is presented with a Royal Pardon supposedly signed by the late Robert Baratheon for Ser Jorah Morment by a lowly boy of Meereen.  However, it is a bit confusing to me as where this actually came from.  Is this the same pardon that Jorah had towards the beginning of the series while Robert was actually alive, or is this pardon one that Tywin actually forged and wrote in a previous episode (remember he asks Mace Tyrell for a quill after learning about Dany's recent actions and allies).  It being from Tywin makes sense but this point is brought up by Jorah and then defeated a sentence later as he himself states it is not a forged Pardon.    So which is it and why would Jorah say it is not a forged copy if it indeed is? How to use grep/awk/unix to match all lines from one file in another file, even if they are duplicates I'm trying to retrieve the the matching lines from a file, however the file that has the "index" or list of matches to retrieve also has duplicate entries and I want to print out the duplicates as well.  Example:  File 1 (index file or list of strings to match)  abc tgf abc ggg aaa fff   File 2 (what I want to retrieve for each of the matches in file 1)  Fred   1   3   abc Amy    2   4   ggg Dan    5   6   tgf Mike   9   1   fff Steve  2   1   aaa   My desired result would be (order is not important, just that I match every line):  Fred   1   3   abc Dan    5   6   tgf Fred   1   3   abc Amy    2   4   ggg Steve  2   1   aaa Mike   9   1   fff   I'm familiar and have tried grep as follows, but it does not print the duplicate entries.  grep -Fwf file1.txt file2.txt  Fred   1   3   abc Amy    2   4   ggg Dan    5   6   tgf Mike   9   1   fff Steve  2   1   aaa does not appear to actually define what a rigid shape is. Rather it defines 'same shape' and 'rigid transformations' without giving any definitions of what is necessary and sufficient for a shape to be considered rigid.  For instance, I've seen the following image:    I understand intuitively why the triangle is rigid and quadrilateral is non-rigid. It is also my understanding that inserting a single diagonal connection into the quadrilateral would make the shape rigid? However, given the following image (labeling the shapes $S_1$, $S_2$ and $S_3$ in sequence left to right):    If $S_1$ had a single diagonal connection AB, it would be possible to flip ADB over axis q to obtain a shape similar to $S_2$ with the addition of connection AB (my explanation may not be the greatest). This shape is clearly not the same as $S_1$, so how can we say $S_1$ with a single diagonal connection CD is rigid? I feel I am unclear on what the definition of rigidity actually is. I have an old Facebook account that I created, uploaded a couple of photos and simply ignored (i.e. no friends added). Now, I can't remember the email address associated with the account and I don't remember the password either. How can I find out which email address I had associated with that account?  P.S. I have created a new Facebook account and my picture can be used to identify me (if I can get someone at Facebook to take a look). Other than that, I'm willing to have that old account deleted altogether if recovery isn't possible.  Is there a way to resolve this issue? Prove for any $a&gt;1$ there exist a natural number, $N$, such that $a^n&gt;n$ for all $n \ge N$  My attempt:  By definition, for $N$ to be a natural number $1\le N \le ∞$ for any integer $N$.  By induction, the base case $n=1$ is true because $a^1&gt;1$ which is true.  Now assume that $a^k&gt;k$ is true, then it is also true for $n= k+1$.  Hypothesis  $a^{k+1}&gt;k+1$  Now I am not sure if I am on the right track How can I check for an empty/undefined/null string in JavaScript? I don't see the gear button next to the Sign in button at the login screen. I have Nvidia drivers installed (for Nvidia 730 GT card). Ubuntu boots into Xorg as seen from the terminal with echo $XDG_SESSION_TYPE which outputs x11.  How do I switch to Wayland? PDF video Embedding Problem I have embed an mp4 video in the PDF file as given below:  \documentclass{beamer} \usetheme{Singapore} \usepackage{media9} \usepackage{hyperref} \begin{document}  \begin{frame}\frametitle{Title}  \includemedia[ width=\paperwidth,height=0.7\linewidth, activate=pageopen, flashvars={aaa.mp4 &amp;autoPlay=true} ]{}{C:/Users/name/Desktop/aaa.mp4}  \end{frame}  \end{document}    There is no compile time error in the code but after running it this massage comes along a  blank pd f file....  "To view the Flash @R Technology content in this pd f file, please install the required version of Flash Player"  I would like to add here that I already have installed the latest version of Flash Player(Adobe Flash Player 12 ActiveX). So,Can anyone tell what version is required to be installed to obtain Video in pd f file. $f:I=[\pi,2\pi]\to \mathbb{R}^2$ be given by $f(t)=(\cos t,\sin t)$  which of the following are necessarily correct?  $1$. $\exists t_0\in I$ such that $f'(t_0)=\frac{1}{\pi}(f(2\pi)-f(\pi))$  $2$. $\nexists t_0\in I$ such that $f'(t_0)=\frac{1}{\pi}(f(2\pi)-f(\pi))$  $3$.$\exists t_0\in I$ such that $\pi||f'(t_0)||\ge ||(f(2\pi)-f(\pi)||$  $4$. $f'(t)=(-\sin t,\cos t)\forall t$  $4$ is clearly true, $1$ is true by Mean Value Theorem as $f$  satisfies all the conditions of MVT? have no idea of $2$ and $3$, Thank you for help I am trying to write a VF page to list all the id and name columns from a custom object but found an error "List has more than 1 row" in the VF page.  Can anyone tell me what have I done wrong?  VF Page:  &lt;apex:page Controller="MP_controller" showHeader="false" sidebar="false"&gt;   &lt;apex:pageBlock&gt;      &lt;apex:pageBlockTable value="{! mp}" var="item"&gt;         &lt;apex:column value="{! item.id}"/&gt;         &lt;apex:column value="{! item.name}"/&gt;       &lt;/apex:pageBlockTable&gt;   &lt;/apex:pageBlock&gt; &lt;/apex:page&gt;   Apex controller  global with sharing class MP_controller {     public Merchant_Profile__c mp{get;set;}     public MP_controller(){         mp = [SELECT                  ID, name, Profile_account_name__c, Merchant_ID__c, Bank_Code__c, Country_Code__c,                 Currency_Code__c, Merchant_Level__c, Merchant_Type__c, MSO__c, Region__c,                 Retail_Products__c, Transaction_Mode__c, Created_Date__c, Date_Disabled__c, Date_Live__c,                 Merchant_Category_Code__c                FROM Merchant_Profile__c               WHERE Profile_Account_Name__c = '001O000000bQFnyIAG'];     } }