Convert My Maps KML to Spreadsheet

This is an extremely loose tutorial for the project I was requested — to export the 3D Printers in Libraries Map to a spreadsheet. Unfortunately, doing so loses a lot of data which is on the Google My Maps application. So this tutorial goes through how to correct it…with a lot of steps.

Export My Maps
https://support.google.com/mymaps/answer/3109452?hl=en

You will then need to unpack the KMZ file. Use 7-zip for this. Just right click and unpack.
http://www.7-zip.org/

Download this program and install it.
http://sourceforge.net/projects/kmlcsv/?source=typ_redirect

Create a folder on your computer and drag your KML file into it.

Set it up according to the following tutorial. In configuration settings, have the watched folder be the one you created in the previous step.
http://choonchernlim.com/kmlcsv/tutorials/using-kmlcsv-converter-with-google-maps/

Click the magnifying glass in the top right corner of the Watched Folder column on the left. You should now see your KML file in the leftmost column under KML Files. Double click on the KML file. Then click on the Create File button in the middle of the screen.

Your new CSV file will be in the folder you created earlier.

Issues: you will only see the lat, long, name of place, and notes field. You will need to add an additional column to fill in the information from the layers in your My Maps. Check your My Maps layers to see what are the first and last items of that layer. You will then:

Type in your layer name in the first blank column’s first cell. Then click on that cell. In the bottom right will be a little square. Click on that and then move your mouse downwards to drag that layer name through the rest of the rows within that layer. Repeat for each new layer.

Next, you need to convert the lat/long to addresses. First, you have to create an extra column to the left of column A. Do this by right clicking on A and then clicking on Insert. A new column will appear to the left of it. Then follow these instructions on how to move the data from one column to the next: http://www.gcflearnfree.org/excel2013/8.5

Delete column B.

You then need to use CONCATENATE to merge column A and B together with a comma between them. Read instructions here: http://superuser.com/a/405436
You want to put the formula in the first cell of the first blank column you have.

Highlight the new column and copy it. Then paste it into this website: http://www.findlatitudeandlongitude.com/batch-reverse-geocode/ For the Batch Reverse Geocode Output Fields field, make sure only address is checked.

In Excel, add a new column in front of column C. We’re going to copy the address from the previous step into this column.

Hopping ahead, I’ve copied the first batch out of that reverse geocode site. Fortunately, it drops the quotation marks when pasted into Excel. So I paste that into a new column. THEN I need to create 5 blank columns to the right of the one I just put data into. I then use Data > Text to Columns to separate by the delimiter of a comma. This will break the data up. Then I repeat so I can break up the State/Zip Code pairing. Use the delimiter of a space. You may notice weird spaces in front of your items.

To remove those weird spaces, you’ll need to follow these steps: http://www.extendoffice.com/documents/excel/667-excel-remove-first-space.html
Make sure to create a new column to the right of the data you want to extract. Put in this formula in the top cell: =TRIM(A2) This formula assumes that the first row is your headers. If it’s not, change the number to whatever. Then drag the bottom right corner of the cell all the way down. Then copy this cell’s data. Click the letter of the column to the left. You will then paste as Values.

Now I’m trying to find a bulk tool that matches up zip codes or City/State to congressional districts. More to come later if needed.

Emerging Leader Appearance in American Libraries

EL_group_full

Here are the photos from the American Libraries issue which feature this year’s crop of Emerging Leaders — a group that I am lucky to be a part of. I haven’t written much about this yet, mostly because my part of the project (building a website) won’t come up until May. Right now, we’re conducting a survey to see who reads the New Member Round Table’s newsletter, Footnotes. Confession: I wasn’t aware NMRT even had a newsletter or a journal.

My group has joined up with the journal group for the purposes of the survey. Both groups have more or less come to the same conclusion which we discussed at the all-day Emerging Leader workshop on Friday, January 30th. However, the survey results will reveal if we were right. We will then give advice as to what we think the future of both publications should be, if they should move to a new platform (we’re favoring WordPress), and how to increase readership with publicity efforts.

EL_2015_Group

Now to the thing which I’ve disappointed in: my name appears wrong in the magazine. I repeatedly told the magazine people the day of the photoshoot that my name was wrong on their paperwork. I then reached out through official channels to ensure that my name appeared correctly as Amanda L. Goodman. So when it came to my attention that the issue was released, I was very unhappy that my insistence on getting my name correct went unheeded. Other members also had their names appear incorrectly (or whole names were dropped out). However, I’m not sure if they want to bring public attention to this fact, so I won’t name them.

I’m frustrated. I feel disrespected. In stories, people believe that names hold power and so hide away their True Name. The naming of a thing has meaning. My name and its appearance is how I choose to appear before the world. I do not like being misrepresented.

Another confession: I actually prefer my middle name, but since I’ve never been called it (and thus feel that it’s far too late to change now that you all know me by Amanda), I instead honor the beautiful swooping shape of the cursive L and immoralize that instead in my signature.

Digital Sign: Marie Curie

Property of Darien Library

Property of Darien Library

The Children’s Library is celebrating Women’s History Month by dressing up as their favorite real life heroines. Here we have Amy (@AmySaurusRex) as photographed by Krishna (@DarcyEyre). The original photo was one of the most beautiful shots I’ve seen.

I’m pleased with this piece because my spouse just asked if Amy had actually been in a laboratory(!).