I have one table that contains 450 locations and a table that has 10'000 rows containing data and no spatial information. I have a column that allows me to join them. The issue is that I want to have the joinig to take place by having my data table as main table. Therefore the solution of using the data table and converting it to a shape data and joining it with my data layer is not an option since it creates a file with only 450 rows and which obviously was not the intended result. What would be the solution to this problem.
I'm trying to create a join/relate in QGIS where I have a shapefile of buildings and to that I would like to join a non-spatial table (.csv-file) containing people who work in each building. So I have multiple records in my table that I would like to be able to join to my single features in my shapefile. I can only run a join in QGIS where the first record is joined to the shapefile feature (ie building) but subsequent records get removed. Could someone let me know how to complete this join/relate in QGIS?
I've tried every combination of "CLEANUP AND OUTPUT" settings that might conceivably prevent munging my HTML, but nothing works.  No matter, what, my HTML gets flattened or in some way rewritten, mainly with whitespace being trimmed off that I want to leave in.  I would suspect CKEditor (version 3.6.4.7575) except that when I tell WYSIWYG to "Apply source formatting", CKEditor doesn't prevent that, so it seems that logically this problem is in the WYSIWYG module.  "Apply source formatting" simply causes the HTML to be screwed up differently.  Some linebreaks are left in place, but spaces at the beginning of the line are left in place.  How can I prevent this, and still use a WYSIWYG editor? I'm trying to determine if 1317 and 116 can be written as the sum of three squares?  I have the condition that if it is not of the form $4^{\alpha}(8k+7)$ then it can be written as a sum of three squares, but how do I use this condition to work it out?  Thank you Is it possible to create 3D red/cyan anaglyphs in a hand drawing? There are plenty tutorials online on how to create 3D red/cyan anaglyphs from existing photos in Photoshop or similar software. However, I'm wondering if it is possible to draw a 3D image by hand on for example a whiteboard using markers.  My plan is to tape together a red and blue marker and draw with it using the same rotation/inclination of the marker across the drawing. Will this give a 3D effect when viewed through red/cyan glasses? Or is the 3D anaglyph method more complex than just offsetting red and cyan lines? scrlttr2: Position of the recipient's address $\sum (-1)^n/n$ fails the p-series test, but passes the alternating series test? I've started trying to make a 3D model that I will end up exporting to an augmented reality app but I've hit a problem in terms of the particle system. The app wants the 3D file in .dae(collada) format which blender allows, but it doesn't seem to export particle systems. I've read that blender doesn't support exporting particle systems at all so I'm now focused on converting the particle system to lots of meshes which will (hopefully)animate using key frames. Then I can export all the meshes and the particles will 'work'.  Currently I'm just using a standard particle system emitting small icospheres. I've tried a few different techniques, such as 'make duplicates real' and using a particle instance instead but they don't seem to animate. Instead it just freezes the current frame into an object(which exports fine but is not what I want). I've also tried recording the animation in the blender game engine but particle systems don't work with it so that didn't work either.  Any help would be appreciated! Thanks I have dual US and UK citizenship, but the US citizenship has only just been realized (wasn't aware I had claim to US citizenship earlier).  Unfortunately I haven't received my US passport yet. Can I still travel to the US only using my UK passport?  I understand that the US does require citizens to travel on a US passport, but would they even know that I am a dual citizen if I've only ever traveled on my UK passport? (Especially considering that my US passport has never been used before in any form - as I haven't received it).  If I was only entering the US for a small trip,  would it show on the screen that I also have US citizenship when they scan my UK passport? I have 256 colors working just fine in konsole,. I thought I'd give tmux a try because, unlike screen, it seems to support vi mode.  However I find that the colors of my prompt show up and this is most likely because I have a 256 color mode prompt. What do I need to do to get tmux to recognize all 256 colors? com.canonical.unity.webapps   In order to work properly, Unity Tweak Tool recommends you install the necessary packages Why do Lagrange Multipliers work? I know that the Lagrange multiplier method helps us evaluate critical points of $f$ on the closed boundary of the restriction.   In other words we solve:$$\nabla f=\lambda \nabla g$$  But why does this method actually work? Can someone please give me an explanation. Thank you! an analytic function from unit disk to unit disk with two fixed point prove that if  $f:\mathbb{D}\rightarrow\mathbb{D}$ is analytic with two distinct fixed point then $f$ is identity. I thought if one of the fixed points was zero by schwarz lemma this statement is easily proved. but what can I do if fixed points were nonzero? Do multiple instances of the Extra Attack feature stack? The WotC article  creates the &quot;Favored Soul&quot; sorcerous origin, which grants the the sorcerer the Extra Attack feature at level 6. Say I made Favored Soul sorcerer go up to level 6, and then multiclassed into Ranger to get its Extra Attack at level 5. Would the two Extra Attack features stack so that I could get 3 or 4 attacks in a turn? My Bash Prompt is currently setting the xterm titlebar using the following sequence:  PS1='\033]0;\u@\h&gt;\w\007'   Is there an easy way to display the current command in the titlebar. For example, if I am tailing a file using tail -f foo.log, I want my titlebar to say tail -f foo.log. How do I draw the graph of inequalities in the coordinate plane? I want to graph the following inequalities (done in desmos) in latex. I need the code. Double orthogonal complement is equal to topological closure How to book this complex multi carrier roundtrip flight I found on ITA? I am trying to book a roundtrip ticket from Chicago O'hare (ORD) to Mumbai, India (BOM). Traveling on Aug 9th and returning on Aug 24th. Now, I've been looking for several days (almost 10days!) for ways to book this itinerary I found on ITA. All other websites like Expedia, Kayak, Travelocity, Momondo, RouteHappy, and even google flights are quoting around $1200 roundtrip cost, sometimes as low as $1150. But the ITA Matrix website shows me several options, the lowest is $916 roundtrip.      You can see there are several flights in the $900 range.     For the return trip there is only one option to get the low price.  Selecting the flights this is what I get:      I'm not sure how to use the fare codes the ITA website provides to purchase this itinerary.  These are some of the things I have tried to book the complex multi-carrier flight from ITA:  My first method was to try coding into HIPMUNK, using the multi-city option, my departure, connections, airlines flights number and dates. Following this method:     And the results page:    Here's what my code into HIPMUNK looks like:  ORD::LH9151 FRA LH756 for the first journey and   BOM::LX155 ZRH SN5104 BRU SN8803 for the return trip.  Don't think I'm making any mistakes in coding it, but there are two adjustments I also made which failed:   I used the dates of the first leg of the flight then tried using the other dates as well. So for example Aug 9th and Aug 10th. I used the codes for the operating carriers and when it didn't work, the marketing carrier leaving the flight number unchanged.   This always returned no results. Breaking up the itinerary to just the oneway from ORD to BOM worked but gave me a price of $624. For some reason the second return trip was creating problems. I tried breaking he return trip down into different segments but no luck. Anyone knows why the return trip is creating difficulties? Coding issues/ hipmunk doesn't have such a large database?   Then I tried method 2: Calling up the airlines  United was able to find all the segments, even price it correctly sometimes (sometimes not) and gave me a confirmation number. I was to call them in 12hrs to check if they were able to procure the seats but when I did call they were not able to get the seats for the SWISS flight from BOM to ZRH and/or from ZRH to BRU. I've tried this at least 5 times changing small things everytime, but the same result. It seems Lufthansa waits for SWISS to confirm the seats but SWISS doesn't respond in time and I'm not able to book.  I tried calling Lufthansa but they were not even able to find the segments and instead told me to look at booking online where I will be able to find it cheaper.  Any insights into the methods that failed or suggestions on how to book this itinerary at the $900 price will be much appreciated. Thanks in advance. Inconsistent line spacing It's taken me almost 10 years of Linux usage to ask this question. It was all trial and error and random late-night internet surfing.  But people shouldn't need 10 years for this. If I were just starting out with Linux, I'd want to know: When to alias, when to script, and when to write a function?  Where aliases are concerned, I use aliases for very simple operations that don't take arguments.   alias houston='cd /home/username/.scripts/'   That seems obvious. But some people do this:  alias command="bash bashscriptname"   (and add it to the .bashrc file)   Is there a good reason to do that? I'm trying really hard, but I genuinely can't think of any circumstances in which I'd want to do that. So, if there is an edge case where that would make a difference, please answer below.  Because that's where I would just put something in my PATH and chmod +x it, which is another thing that came after years of Linux trial-and-error.  Which brings me to the next topic. For instance, I added a hidden folder (.scripts/) in the home directory to my PATH by just adding a line to my .bashrc (PATH=$PATH:/home/username/.scripts/), so anything executable in there automagically autocompletes.  If I needed to.  I don't really need that, though, do I? I would only use that for languages that are not the shell, like Python.  If it's the shell, I can just write a function inside the very same .bashrc:  funcname () {   somecommand -someARGS "$@" }   As I stated, I found a lot of this out through trial and error. And I only truly saw the beauty of functions when my computer died and I was forced to use the computers of the people around me when they weren't using them.   Instead of moving a whole directory of scripts from computer to computer, I ended up just replacing everyone else's .bashrc with my own, since they had never even made a single modification.  But did I miss anything?   So, what would you tell a beginning Linux user about when to alias, when to script, and when to write a function?   If it's not obvious, I'm assuming the people who answer this will make use of all three options. If you only use aliases, or only use scripts, or only use functions—or if you only use aliases and scripts or aliases and functions or scripts and functions—this question isn't really aimed at you. Say, we have a query like this:  select a.*,b.* from  a join b on a.col1=b.col1 and len(a.col1)=10   Assuming the above query uses a Hash Join and has a residual, the probe key will be col1 and the residual will be len(a.col1)=10.  But while going through another example, I could see both the probe and the residual to be the same column. Below is an elaboration on what I am trying to say:  Query:  select * from T1 join T2 on T1.a = T2.a    Execution plan, with probe and residual highlighted:         Test data:    create table T1 (a int, b int, x char(200)) create table T2 (a int, b int, x char(200))  set nocount on declare @i int set @i = 0 while @i &lt; 1000   begin       insert T1 values (@i * 2, @i * 5, @i)     set @i = @i + 1   end  declare @i int set @i = 0 while @i &lt; 10000   begin     insert T2 values (@i * 3, @i * 7, @i)     set @i = @i + 1   end   Question:    How can a probe and a residual be the same column? Why can't SQL Server use the probe column only? Why does it have to use the same column as a residual to filter rows again?  References for test data: How do you convert a C++ string to an int? Possible Duplicate:          How do you convert a C++ string to an int?  Assume you are expecting the string to have actual numbers in it ("1", "345", "38944", for example).  Also, let's assume you don't have boost, and you really want to do it the C++ way, not the crufty old C way.