Can you recommend some magazines or other GIS-related papers (printed or digital) which are released on a monthly basis (or every 2-3 months);  I am looking to keep in touch with the GIS fast-growing world and I would prefer something other than books or websites.  Maybe some of you already have a subscription at some magazine.  I am quite interested in Open Source Software but not only.  This post would be the magazine equivalent to another one with useful information about books:
What books, journals, and/or electronic resources have you found most valuable for expanding your knowledge in the GIS field, and why?
I tried to find this question somewhere else on here, and found a couple that were similar to it -- but all the answers seemed pretty convoluted, and I think it was surprising to me because I just imagined that SQL would have a way easier way to do this.  Essentially, I'm using a GROUP BY to group two values on top of each other. The coding is simple and works well, where I get these results using WITH ROLLUP at the end:  Type    Person  Count Type A  Person 1    10 Type A  Person 2    91 Type A  Person 3    13 Type A  Person 4    10 Type A  Person 5    2 Type A  NULL        126 Type B  Person 6    16 Type B  Person 7    63 Type B  Person 8    15 Type B  Person 9    22 Type B  Person 10   16 Type B  Person 11   3 Type B  Person 12   20 Type B  Person 13   44 Type B  NULL        198 NULL    NULL        360   Is there an easy way to substitute something saying if "NULL" is in the "Person" column, then make NULL AS "Subtotal" and if "NULL" is in the "Type" column, NULL AS "Grand Total?"  And if that's weirdly complicated, I'd be totally fine with just calling all of them "Total."  Thanks! What are these stamps in my passport after I was advised to divert via the UK but didn't have a visa? I am from Myanmar. I was on my way to Venice from Brussels while holding Schengen visa (single entry). I bought a British Airways ticket to fly from Brussels to Venice. Unfortunately, on that day, all BA flights from Brussels were canceled. British Airway's customer service centre told me to go to from Brussels to London by train, where I could catch my flight to Venice. I took a taxi to Bruxelles-Midi train station and bought a ticket to London. A Brussels immigration officer inspected and approved my passport.   Then I had to to through UK Border Immigration. There, they said I can't enter to get my flight. Although I explained the situation with the airline and made clear of my destination (I already reserved my hotels in Venice, Switzerland and France as described in my travel itinerary), they detained me for some hours and also took my fingerprints on paper and photo.   They asked questions concerned about my finances and gave me a refusal letter for not having a transit visa. So I had to re-enter Brussels where the immigration officer put the below stamp in my passport. As I had a single entry Schengen visa, I had to buy another airline ticket to Venice and complete my Europe trip.   What do the stamps below mean on my passport?   Can they affect me and, if so, how and why, when I apply for another Schengen visa? How to deal with bibliography items containing long URLs? In the Law of Reflection, the angle of incidence is equal to angle of reflection. Why is this true? This is clearly true experimentally, but how does one prove this true mathematically? How can I get barcode-scan information into my photo metadata, onsite, untethered? I need a DSLR camera with a barcode scanner for on-site tours photography, which means it needs to be untethered! The image would have to contain the barcode scanned information in the image metadata or in the name itself.  I've seen solutions like, Foolography and a $2600 Canon Studio Edition launched in 2010. But I'm not sure of either those products!  So I'm asking the gurus here how I can get this working, which camera would I need and any accessory necessary?  I'm trying to recreate something like I saw the on-site volume photographers do in Disney's parks. creating variable using variable value as part of new variable name I'm trying to create a new variable using the value of an existing variable as part of the variable name.  filemsg"$word1"=" "   I've also tried   filemsg$word1=" "  filemsg${word1}=" "   on all attempts I get the following when that line executes,  cicserrors.sh[45]: filemsgCICS= : not found [No such file or directory] I want to georeference jpg map without any digitizing data How do I scan for Wireless Access Points? What is the shortest way to compute the last 3 digits of $17^{256}$? What is the shortest way to compute the last 3 digits of $17^{256}$ ?  My solution: \begin{align} 17^{256} &amp;=289^{128} \\ &amp;=(290 - 1)^{128}\\ &amp;=\binom{128}{0}290^{128} -  ... +\binom{128}{126}290^2 - \binom{128}{127}290 + \binom{128}{128} \end{align}  Computed the last 3 terms whose last 3 digits gave the last 3 digits of $17^{256}$.  Is there any shorter method to do this(which requires much less computation) ? Is there some kind of icon browser? When making a custom launcher, it is nice to have a matching icon for it from the default usr ubuntu directories. The problem that is: Ubuntu seems to store icons in about 50 or more folders. Browsing all of them in nautilus takes ages.  So my question is: Is there some kind of icon browser that shows an overview of all icons in /usr/share/icons/*? How to send parameter from jsp page to jasper file Is the empty set a group? How to perform Stream functions on an Iterable? When installing or booting from USB flash drive screen goes blank When I was installing Ubuntu 11.10 64-bit on my new PC from a flash drive since the only computers I have do not have disk drives, I ran into a problem.  After the ASUS logo when switching on the PC, and pressing F8 to select the USB flash drive, there was the options thing as normal that allows me to select to either boot form the flash drive or install on the HDD, when I do either of these, there is a bunch of text on a black background, as I would expect, but after a few seconds the screen goes blank and the monitor says No signal.  I have previously installed Ubuntu with a flash drive to fix issues caused my Windows and ran into no problems.  Is it a problem with the pen drive I am using? Or maybe a problem with the system? I tried it in my USB 3.0 ports at the back and the USB 2.0 ones as well.  My Specs are:   &nbsp;&nbsp;AMD Phenom II x4 965BE &nbsp;&nbsp;ASUS AMD Radeon HD 6670 &nbsp;&nbsp;ASUS M5-L75 USB3 (typing this from memory, it's an AM3+ ASUS board with USB3.0 in the AMD700 chipet or something) &nbsp;&nbsp;Corsair XMS3 DDR3 4GB(2x2GB) 1333MHz RAM    I ran the memtest program on the flash drive as well, and it came out clean. Do flight attendants prefer I press the button or walk to the back? (Long-haul flights) Graphics horribly corrupted on Ubuntu 16.04 in VirtualBox, showing random strips of pixelated colors Inside a VirtualBox VM, I have installed myself an Ubuntu 16.04.1 LTS Server installation. However, when I installed the ubuntu-desktop package and rebooted, this happened:    Exact command I used: sudo apt-get update; sudo apt-get install ubuntu-desktop ..and then a reboot command.  This just seems like a corrupted top-left portion of the screen, as my cursor can appear in view (but corrupted):    This is a purely graphical issue because I can use the keyboard to successfully progress to a desktop:    Note: On startup it shows correct graphics for a split-second then reverts to glitch.    Any help on this? How to correctly specify coordinate system? Using QGIS v. 1.9 (1.7 does not seem to be available for Ubuntu Linux 12.04), do the following:   Create new project, specify coordinate system by clicking on button in bottom right hand corner, enable on the fly CRS transformation, set projection to WGS 84 / UTM Zone 18S. Pass mouse over project window and UTM coordinates appear in coordinates window in status bar at the bottom. Add delimited text layer in decimal degrees. When asked for projection, specify same projection as in (1). Points in the layer are plotted but, mousing over the map, the coordinates in the coordinates window are now in decimal degrees (even though the projection is set to UTM).   Is there something I am missing here? I have tried doing this in so many ways, so many times, but the result is always the same. I seem to be setting the projection correctly but only decimal degrees show in the coordinates window.  With thanks, Martin Partitioning with varying partition size Proving that if $A$ is a $8\times 8$ matrix over $\mathbb{R}$ and $A^3=A$, then $A$ is diagonalizable. If $A$ is a $8\times 8$ matrix over $\mathbb{R}$ and $A^3=A$ then prove that $A$ is diagonalizable.   I have got that the minimal polynomial of $A$ may be $x^3-x$ or $x$ or $x(x+1)$ or $x(x-1)$ in the 2nd case it is not possible in the 3rd and 4th cases the matrix will be the identity matrix or identity matrix multiplied by a scalar!  But I cannot reach any further. Is there a way to display the number of messages for any label in the Gmail label list? The Gmail sidebar displays the list of our labels (or some of them, according to settings). Next to every label name there is a number showing how many unread messages we have for that label.  Is there a way to display also the total number of messages for each label?  Example:  [to answer] (0/36) [to do] (0/55) [waiting answer] (0/7) cooking (2/48) family (6/352) friends (1/1828) website (2/412) work (12/12801)