Friday, April 28, 2006

Looking Back on a Great Semester...

Want to see an overview of UT Arlington Library GIS services this Spring 2006 semester? Here is a draft of a summary I just wrote for our library newsletter, Connections. It sure has been one heck of a semester. Felt like much of the time I was running around like a chicken with its head cut off, but looking back a lot was accomplished.

Hello. We are the UT Arlington Library: GIS Services team within the Information Literacy Program Area. We had a most exciting Spring 2006 semester, and want to use this opportunity to show you who we are and what we have been up to this semester.

Meet the Faces:
| | | |
Left: Joshua Been, GIS Librarian
Center: Kaushal Gala, Graduate Research Assistant
Right: Heather Perkins, Student Assistant

Workshops (http://library.uta.edu/gis/gisSeminars.jsp)
Workshops are our primary outreach mechanism. For folks new to geospatial technologies, these workshops demonstrate how mathematics and statistics are a lot of fun, especially when combined with geospatial technologies. For more experienced folks, we always include a new resource (such as a new dataset) or a new analysis procedure (such as geostatistical analysis).

We held three workshops this semester, with an average of 15 folks attending each workshop. The workshops were:
  • To Catch a Thief
  • Create Your Own Google Maps Mashup
  • Where to Open a New Pizzeria in the Metroplex
ESRI Live Training Seminars (http://library.uta.edu/gis/esriTraining.jsp)
We experimented this semester with broadcasting publicly available webcasts. 16 faculty and students attended these two webcasts and these will definitely continue in the Fall.

Class Instruction
We held 20 class instruction sessions this semester for the following subjects:
  • Political Science
  • Earth & Environmental Sciences
  • Urban & Public Affairs
  • Architecture
  • Nursing
  • Social Work
  • Marketing
  • Real Estate
  • Criminal Justice
Assistance/Consultation (http://library.uta.edu/gis/gisAssistance.jsp)
We offer 12.5 hours of walk-in assistance each week. As of April 26, we assisted 499 students during this semester (including phone and email questions). This is up from the 474 questions we answered last Fall. (We do not record the number of unique students/faculty who seek our help, but the average student returns once, and so we have helped app. 250 students.) Here is a breakdown of the students who we helped this semester:

New Outreach
We began working with numerous new faculty and students this semester, but the main accomplishment is our new relationships with the Criminal Justice department. After previous unsuccessful attempts to build relationships with this department, this semester’s workshop, ‘To Catch a Thief’ was incredibly effective. After this workshop, we were invited to provide 4 instruction sessions for 4 criminal justice classes. Hopefully, this is just the beginning.

New Datasets
This semester we acquired the entire premium AGS Demographic Dataset for the state of Texas. This provides blockgroup level (app. neighborhood level) demographics for demographics, purchase patterns, crime, environmental factors, personal finance, and other business information.

Development of the UT Arlington Library Geospatial Catalog (GeoSpat)
We have been working hard on the geospatial catalog this semester. This summer, we are planning to release a much improved version of our geospatial catalog. This new version will include improved and more complete metadata records, the ability to save and edit searches, and much more. It is not much to look at right now, but the development version can be found here: http://gis.uta.edu/geospat4.

Applications & Scripts
In addition to working on GeoSpat (above), we have programmed numerous smaller applications and scripts.Geospatial Digitization of Historic Maps
We referenced and digitized (vectorized) 11 scanned maps from SPCOÂ’s map collection. This gives us a total of 24 completed maps. The process of referencing and digitizing these maps enables replications of these maps to be used with geospatial technologies. Over the summer, our students and faculty (and off-campus friends) will be able to interact with these maps within GIS software, Google Earth, and online via mapping applications such as Google/Yahoo! Maps. If you are a Google Earth user, download this KMZ file to view the Colton 1855 map within Google Earth: http://gis.uta.edu/download/kmz/colton1855.kmz. Many more of these coming soon.

Professional Paper Presentation
Joshua Been and Dr. Jose Gutierrez (political science) co-wrote a paper on our collaborative work creating online maps displaying the Hispanic population projections in Texas through 2040. We presented this paper at the American Political Science Association: Teaching & Learning Conference last February. The paper can be found here: here.

Want to Keep Up With Our GIS Activities??
Check out the blog, Mapz: A GIS Librarian (http://mapzlibrarian.blogspot.com/).

Wednesday, April 26, 2006

Last GIS Library Instruction: Nursing PhD Course

I am getting ready for the last GIS library instruction session this Friday **. This will be the 23rd GIS workshop/instruction session that I held for the library this semester. All of you conspiracy-minded Robert Anton Wilson fans out there should grin at this evidence of the 23 enigma. (I was a college freshman back in '93 when I first read Illuminatus!).

Well, yesterday the professor asked me to make sure that I include information regarding AIDS/HIV in the hands-on demo. As is always the case, I had not prepared this data. No worries. I hopped on over to the Texas Department of State Health Services and sure enough they provide HIV/AIDS stats on the county level. In PDF, though... Not enough time to request the datasets from them, so I extracted the PDF tables into Excel. Worked great. Joined the table to a shapefile, and voila...got some great data to share with them. Then, because I simply could not help myself, I created a Google Map and Zoho attribute table. This will definitely peak their interest...and hopefully have them coming back during the summer for more.

Here is what I plan to cover with the class:
  1. Where Should You Hang Out on a Friday Night
    • This is my best hook to get new students excited about GIS. It is entirely web based, uses the Google Maps API, and performs an automated suitability analysis using weighted averages. Plus, it's zany enough to smooth over anyone's anxiety about learning a new technology.
    • There are no domain restrictions, so if you have a spare moment, go ahead and give it a shot.
    • For more information, see my earlier post.
  2. Explore the Newly Created HIV Google Map
  3. Demo: Where to Open a New Hospital in the DFW Metroplex & What Services to Offer?
    • Workshop materials
    • This is the real meat of the class. This is a nifty little workshop that allows students new to GIS to explore shapes and attributes, play with symbology, and even run a few analysis procedures (with the help of pre-created Python scripts).
** After Friday, I still have 4 more classes to teach for my adjunct teaching positions. Then I will have a short respite until the summer sessions.

Position: Map Librarian - University of Tennessee, Knoxville

Map Librarian - University of Tennessee, Knoxville
"We are seeking a creative, user-oriented professional to serve as Map Librarian and subject liaison for Geography."
This really seems like a great job as there appears to be a nice balance between all of the aspects of map/geospatial librarianship. From user consultation, to general reference duties, to FGDC metadata maintenance, to collection development, to outreach, to faculty liaison, and a blending of traditional cartographic materials and geospatial. I see so much potential for this position, and I definitely encourage interested librarians to apply.

The minimum requirements include an an MLS which I endorse entirely, as well as "knowledge of map librarianship and the application of GIS services in libraries." The preferred requirements include a "degree in geography or related field and experience using GIS software (ArcGIS)."

Here are some snippets:
  • "planning library services and user education programs related to GIS applications, and coordinating the Libraries' collaboration with other campus GIS service providers"
  • "providing subject specific reference, consultation, and instruction for users needing assistance with digital and print cartographic and geospatial resources and geography collections"
The minimum salary is set at $ 42,000 which I consider extremely reasonable considering the cost of living in Knoxville. A well qualified applicant may be able to push upwards to $ 50,000.

Monday, April 24, 2006

From Sample Points to Attractive ArcGlobe Image: Not So Easy

Here's the situation:
Biology professor needs a 3D map of the US, where the z-values represent particular species richness as opposed to the actual elevation of the terrain. The professor (and her GRA) came during my office hours with a delimited text file containing sample lat/long points along with the associated richness values.

Here's a quick shot of the result:


How many hours I spent on this:
Too many. At least 10 hours over the last month.

How I justify spending so much time on this project:
This is my first interaction with this biology professor, and I really, really want the professor to leave with a favorable view of the library's GIS services. I also worked closely with the professor's GRA, and I try to always take advantage of those teachable moments.

How I finally accomplished this task:
My first thought was that this would be a super-easy project. Unfortunately, this was not the case. This is probably due to my lack of experience working with the 3D functions of ArcGIS 3D Analyst/ArcGlobe/ArcScene. After this project, this should no longer be the case.
Here are the steps (from my notes):
  • First Using ArcMap
    • Create point feature class from sample data provided by the professor.
    • Obtain U.S. state boundary shapefile from NationalAtlas.gov.
    • Dissolved the continental (48 states) U.S.
    • Converted the dissolved feature class to raster.
    • Interpolated the sample points using kriging with the following parameters: (100 km radius kriging limit / 1 km cell size). The 100 km radius limit was requested by the professor.
    • Merged the kriging layer with the raster U.S. layer.

  • Next Using ArcGlobe
    • Add merged raster layer
    • Redefine raster layer as elevation.
    • Exaggerate ArcGlobe by 1000. This was essential as this equated 1 richness factor = 1 km of elevation.
    • Add the states layer, with hollow polygon symbology, to drape on top.
What I plan to do with this next:
Why, develop a workshop of course. Keep your eyes peeled for a good workshop on these techniques planned for Fall 2006 semester. If the professor allows me to use the data points, this might really make some inroads into closer connections with he Biology department.

What about Google Earth?:
I would have to create a Tin (which is no problem) and then convert the Tin to KML using Arc2Earth. If I can find a free morning this summer (after finals...), I will compare how the elevation renders compared to ArcGlobe.

Wednesday, April 19, 2006

Spatial Technology Blurs the Virtual & the Real

Imagine driving down the street and your in-car navigation systems tells you, in a soothing Kit voice:
  • You need to turn left in 2500 feet
  • Your bank is on the right-hand corner, account balance of $4.35 (ouch...)
  • 1.4 miles west, along Main Street, is the location of the blog: mapz: a gis librarian
  • You just passed the Chinese restaurant that gave you the runs last Tuesday
  • "Please be careful Michael. Current news headlines indicate a recent series of muggings in this neighborhood."
  • Just passed the residence of ObiWan123, member of the following Frappr Maps: GIS Librarians & VerySpatial
  • You are quick approaching the geotagged photos (adult) of MissKittie69. Click here to view.
What we are beginning to see here is a breakdown between the border separating the virtual and the reality. And the critical technology breaking these borders down are geospatial technologies.

Remember the news reports of that French guy who crashed his car because he followed his GPS instructions? In this story, the GPS unit was directing the French guy to a hotel and instructed him to make an immediate u-turn. This is a classic case of how spatial technologies enabled virtual information (street network, GPS coordinates, and hotel locations) to direct the actions here in the real world. How far away are we from giving navigation devices actual driving privileges? Not very far at all.

Let's take a look at the state of things. More and more virtual materials are being given geotags, which enables these virtuals to be geospatially located. More and more of these geotagged items are being made available via public web services and/or public feeds. Spatial mashups integrating various services/feeds are not a passing fad. Google Earth is set to be integrated with Honda and VW.

This deserves its own paragraph. Google Earth is set to be integrated with Honda and VW. Imagine importing Declan Butler's Google Earth Avian Flu KML file. ArcMap scripts can export to KML, as can MapInfo, and Shape2Earth can convert shapefiles to KML without an additional GIS application. Just think of the various geotagged virtuals that can be uploaded/accessed via your in-car navigation system.

I can think of no medium or technology that will tear down the boundaries between the virtual and the real more succinctly than geospatial technologies. We are all heading toward a society where geospatially-driven augmented reality will become commonplace. I not only foresee, but I yearn for the day when portable augmented reality systems will allow me to spatially see and interact with geotagged virtual items.

Here are some images from Tinmith Augmented Reality Research to give you more of an idea of what augmented reality is.



As I was writing this, however, something that I initially could not put my finger on was bothering me. Something was missing. Now I think I have figured it out. (Isn't it great how writing does this for us?) There is a growing trend to geotag popular and daily consumer items, such as blogs, photos, friends, clubs, even news stories. However, I feel there is a lack of geotagged scholarly resources. Resources such as scholarly journal articles (there are a number of fantastic open source journals out there). Tags can be generated for the author location and more importantly for different geospatial subjects or locations of interest in the article. Scholarly books as well. I want to ensure that when the walls between the virtual and the real come fumbling down, there is a place for the scholarly as well as the popular.

Tuesday, April 18, 2006

Google Map Viewer & Zoho Sheet for Attributes

Student needed a map of the water wells in Arlington, along with the concentrations of fluoride present in each well. Student has no experience working with GIS. None. Absolutely.

So, within 30 minutes of work (fun work, mind you) I created an interactive map, along with an interactive attribute table, and emailed the links. As you can imagine, Student was ecstatic. You've got to love those moments...

The map can be viewed here: http://gis.uta.edu/arcmap2gmap/samples/arlingtonwells.html.

The interactive spreadsheet can be viewed here: http://zohosheet.com/view.do?url=http://gis.uta.edu/arcmap2gmap/samples/arlingtonwells.xls.

Anyone following this blog knows how much I have enjoyed creating my own customized Google Maps, developed using ArcMap2GMap, and this just gave me an excuse to create another Google Map.

But the new (to me) piece of technology I used was Zoho Sheet, a free online spreadsheet application. I exported the shapefile attributes into Excel format, and am using the Zoho API to allow users to view the attributes using Zoho. I love it that users do not need Excel on their computers. I am very impressed with how well Zoho works, even including the ability to create, edit, share, and even to create & include formulas!! For all you tagging junkies, you can even tag your spreadsheets.

Learned about Zoho via: ResourceShelf

So, I have been thinking about the applications of online spreadsheets beyond sending information to a single student. I think the potential here for sharing data and data functions with students is quite high. For example, I can create a Zoho Sheet with an illustration of the spreadsheet function necessary to convert DMS to DD. Or, perhaps I can create s sheet with various public attributes. Students then will have the option to download the table as Excel, Open Office, HTML, or PDF. Of course, the tags will allow me to organize the tables which will allow students to access them easier.

Ah, well. At the moment this idea will just have to go to the end of my growing list of ideas to explore later. Perhaps this summer I'll be able to explore this a tad bit further. At least I jotted this down here.

For those of you familiar with available Texas datasets, the Texas Water Development Board does indeed provide the public ArcIMS-driven WIID System (Water Information Integration & Dissemination), which provides interactive access to Texas wells. However, water quality values, such as fluoride content, is not available via WIID. This data is accessible in the TWDB Groundwater Database.

Sunday, April 16, 2006

Position: Map Librarian (St Paul, MN)

Map Librarian - EastView Cartographic, Inc. (St Paul, MN)

This sounds like an extremely interesting corporate librarian position, with a strong emphasis on Russian and Chinese cartographic materials.

Here is the snippet
"Map Librarian: Mpls. Take charge of corporate Russian/ Chinese specialty map/GIS/ cartographic library of materials in paper, digital, films. Require Master in Library Science or equivalent, courseworks taken in cartography. ArcGIS, database mgmt."
No mention of salary range, but I am indeed curious whether such a corporate position will pay less or more than an academic position...

Friday, April 14, 2006

Blog Facelift

It's been 7 months or so since I migrated my blog here from Bloglines, and the cluttered-ness of the layout was really getting to me. So I replaced the old template with a cleaner, fresher model that actually uses the full width of your screen.

Much more relaxing around here now, isn't it?

Can You Get a Decent Slice of Pizza in Texas? No, Not Really...

There are a couple of places that try hard to serve up a nice hot slice of pizza, but none of them even come close to being great.

So...I held a GIS workshop yesterday, entitled 'Where to Open a New Pizzeria in the D/FW Metroplex?' Went better than expected, with 9 students, 2 faculty, and 2 interested staff members attending.

Monday, April 10, 2006

Position: Social Sciences Data Librarian (Rutgers University)

Social Sciences Data Librarian - Rutgers University at New Brunswick (New Jersey)
"Rutgers University Libraries seeks a librarian to be the primary resource person for the planning and delivery of numeric data services for governmental and non-governmental sources."
This appears to be a fantastic opportunity for GIS and other data librarians with a strong interest in the social sciences. This seems to be a trend to include GIS as a subset of the services provided by data librarians. This is a very good thing as the novelty of GIS in and of itself is wearing off and it is taking its rightful place within the realm of data and statistics.

No mention of the salary range.

Here are some snippets:
  • Responsible for continued development of Geographic Information Systems (GIS) services including consultation and data acquisition to support teaching and research.
  • Responsible for the development of archival and user support services for numeric data in various electronic formats.
  • Experience...using statistical packages such as SPSS or SAS required.
  • Working knowledge of metadata standards for data such as DDI, Geographic Information Systems software packages such as ArcView and ArcIMS.

Sunday, April 09, 2006

More Recent GIS-Related Dissertations

Haven't posted a new crop of GIS/Geography-related dissertations since January 2006.

Here is the latest installment in dissertations that have caught my eye.

Thursday, April 06, 2006

GIS Market Analysis: Hotel Industry

Yesterday, two urban planning students came to the library for advice about where to obtain appropriate datasets to run a gravity model ("predicts the sales potential of an area based on distance, competition, attractiveness factors, and consumer spending") on the hotel industry in Austin, TX.

Well, unbeknownst to them they were indeed in luck as occupancy and sales data for hotels are more readily available in Texas than most other industries. This is why the final project in my advanced real estate market analysis course (syllabus: Flash) is a comprehensive market analysis of the hotel industry in the DFW Metroplex.

Here is a list of free and library-acquired datasets that I am helping the urban planning students to integrate into their analysis. (These are in addition to the standard GIS layers they will need).
  • Texas Comptroller of Public Accounts: Tax Files
    • Free dataset
    • This fantastic resource provides quarterly tax and sales data, by establishment, for hotel occupancy tax receipts, new franchise taxpayers, new sales tax permits, and mixed beverage tax receipts.
    • I first discovered this incredibly open resource (especially for Texas) for a workshop I held last February, called 'Get the Most Out of a Retail Location: Maximize Mixed Drink Sales'. This workshop demonstrates how GIS can be used to provide a spatial dimension to multivariate regression analysis. The workshop documents can be downloaded here.

  • Zip Code Business Patterns
    • Free dataset
    • Provides the number of establishments by establishment size by zip code.
    • The industry code for hotels is '721110'.

  • American Factfinder
    • Free dataset
    • This historical (yes, 2000 demographics are now historical) dataset provides block group-level data from the long form of the U.S. decennial census for 1990 and 2000.

  • Reference USA
    • Subscription database
    • This InfoUSA product, available at many libraries, provides downloadable lists of business and residential establishments. The downloaded tables contain a geocodable address field and even contain geocoded lat/long fields if you do not wish to do the geocoding yourself.

  • AGS Marketing Data
    • Subscription dataset
    • Provides 2005 estimates on the block group-level for demographics, consumer expenditures, business and employee counts, personal finance, crime risk, and environmental risks.

Tuesday, April 04, 2006

Shareware: Christine GIS System 2.01

Christine GIS System 2.01 was just released.

When students have light-weight GIS work (joining Census tables to shapefiles, for example) they need to complete for non-academic purposes, I almost always recommend the freely available (freeware) GIS Christine Viewer. Our educational license for ESRI software prohibit non-academic use of ArcGIS.

I have been hesitant, however, to point out the shareware version, called Christine GIS System, as the capabilities did not seem worth the money. Late March, they released version 2.01 which really impresses me. It can create buffers, work with cad files, connect to WMS files, and is very scriptable.

The one feature that I would really like to see is geocoding support. However, with resources out there such as Batch Geocode, this is manageable. Should the shareware version of Christine offer geocoding support, this would become one heck of cheap, small, GIS app.

DOJ: Identity Theft Stats 2004

U.S. Department of Justice: Identity Theft, 2004

These stats astounded me. Especially this:
"3 in 10 households experiencing any type of identity theft discovered it by missing money or noticing unfamiliar charges on an account; almost 1 in 4 were contacted by a credit bureau."
That's 3 out of 10!!!

Here is a quick customized Google Maps webpage showing the areas in Texas where households are most at risk: http://gis.uta.edu/arcmap2gmap/samples/idtheft.html. The map shows areas that have a high concentration of at-risk households as determined by the report:
  • Income above $75,000
  • Urban area
  • Householder age 18 - 24
Red polygons are those areas that meet all 3 requirements listed above. Green polygons are urban areas where the median income is higher than $75,000. Blue polygons are urban areas where there is a large concentration of households headed by those in ages 18 - 24. Red pushpins are provided for the areas most at risk.

Of course, this map was generated using ArcMap2GMap.

Unimpressive - Google's Related Links Feature

So, I am trying out Google's new 'Google Related Links' service on this blog (bottom of right-hand menu) and I like the idea.

via: ResearchBuzz

Related news, searches, and links (pick 2) are dynamically generated. At this moment, in the 'news' category, there is only a single link to an available job from the Directions Magazine: Job Listings.

:(

Color me spoiled, but I was hoping for a bit more...

Not exactly what I was hoping for. I will leave it on my blog for a few days and see whether it improves. Here is what I would like to see:
  • More variety
  • Dynamic changes

Saturday, April 01, 2006

Woops - ArcMap2GMap Corrected...

Major woops...

Thursday morning, when I posted the development of our script ArcMap2GMap an older and incomplete version was posted to the net. I apologize to anyone who might have actually given it a shot and been disappointed when it did not work. The script can be downloaded from the same URL provided before:

http://gis.uta.edu/download/arcmap2gmap

GIS Discussion Boards out of the Library

Starting this Summer, our library will begin experimenting with topical discussion boards that anyone on campus (and possible off) will be able to participate in. The idea is that this will help to increase scholarly communication (and information literacy) among students, staff, and faculty, and therefore bring us all together.

Well, the initial pilot project will be a GIS-topic discussion board. I think this will be fantastic. Presently, any student not taking a GIS course who wants assistance has only one place to turn to...the library. Now, this is great as it is my job responsibility to provide such assistance. But when I sit back and think of students helping other students, well let me tell you it almost brings a tear to my eye. Seriously.

Currently, information regarding GIS news/activities is sent out via the GIS@listserv.uta.edu list. For the life of me, I cannot convince students to subscribe. Most subscribers are faculty and staff with an interest in GIS. I am of the belief that this is not unique and that student participation in traditional university-run email listservs are low. Therefore, I am convinced that student participation will be so much higher if we change the medium to a discussion board system with public rss feeds.

I know this is improbable, but I like to daydream about one day sending information about a spatial dataset we (the library) are interested in acquiring and hearing immediate and widespread student feedback. We shall see, eh?

Position: Digital Librarian/Cyberinfrastructure for Biodiversity and Ecosystems (NBII)

Digital Librarian/Cyberinfrastructure for Biodiversity and Ecosystems - National Biological Information Infrastructure, Reston, VA or Washington, D.C. via IIa

"...help build the next generation of the National Biological Information Infrastructure (NBII)." Now, how could any librarian with an interest in the life sciences not want in on that?

Unfamiliar with the NBII? Check out their website. U.S. federal agency that provides access to a wealth of biological information, including secondary publications as well as datasets.

Check out the NBII Metadata Clearinghouse, which is a registered node of the National Spatial Data Infrastructure Clearinghouse. The NSDI is a program of the Federal Geographic Data Committee to collect and disseminate U.S. spatial data. (Nice facelife on the FGDC site, BTW.)

Here some snippets from the position description:
  • "Standardizing and providing information content on national plans, priorities, spatial and temporal information on the components of biological diversity."
  • "Development of website and portal areas for the NBII."
Now, this position "requires" an MLS and "desires" GIS experience. As I stated earlier, IMHO this is indeed the best way to go for many libraries.