Andy,

Thanks for the info.  I already have the collections locations in a database, but am hoping to make it easier to decide if something has more room -- we have four sizes of standard boxes so I can tell by the location information what size box it is.  having something visual will make it easier than having to get the key to the cabinet and physically looking to confirm the space is allocated.  

Cheers,

Marybeth 
________________________________________
From: Museum discussion list [[log in to unmask]] on behalf of MUSEUM-L automatic digest system [[log in to unmask]]
Sent: Thursday, February 14, 2013 10:00 PM
To: [log in to unmask]
Subject: MUSEUM-L Digest - 13 Feb 2013 to 14 Feb 2013 (#2013-39)

There are 10 messages totaling 1898 lines in this issue.

Topics of the day:

  1. interactive map of storage locations (3)
  2. Cheap Art Storage Racks (2)
  3. Collaboration Survey
  4. Curation Internship at the BLM-Anasazi Heritage Center- Dolores, Colorado
  5. Announcing 2013 Kress Scholarships for SEI
  6. Louvre Delacroix Defaced * Serbia's Ugly Side * Female Artists Dismissed *
     Thatcher Statue Suspension * Assumptions Pricked * Courbet's Explicit Nude
     * Redskins Racial Slur * Miniscule Micrarium * More!
  7. email change

=========================================================


Date:    Thu, 14 Feb 2013 19:08:12 +0000
From:    "Bentley, Andrew Charles" <[log in to unmask]>
Subject: Re: interactive map of storage locations

Marybeth

The software that we use here at KU for our natural history collections, Specify (www.specifysoftware.org<http://www.specifysoftware.org>) and that is used by over 400 collections worldwide has a storage tree that is used to store all information about storage location of objects.  It functions on a true parent-child relationship so that the parent of a room is a building etc.  At any level you can also get the tree to report to you how many collection objects are represented at that level and so if you had a level called shelf, you could get a total of the number of collection objects that are contained on that shelf.  This would not give you a true value for amount of space available but you could have an additional field indicating the size of each object that would give you more detail.

Hope that helps

Andy

    A  :             A  :             A  :
 }<(((_°>.,.,.,.}<(((_°>.,.,.,.}<)))_°>
    V                V                V
 Andy Bentley
 Ichthyology Collection Manager
 University of Kansas
Biodiversity Institute
 Dyche Hall
 1345 Jayhawk Boulevard
 Lawrence, KS, 66045-7561
 USA

Tel: (785) 864-3863
Fax: (785) 864-5335
 Email: [log in to unmask]<mailto:[log in to unmask]>
http://ichthyology.biodiversity.ku.edu<http://ichthyology.biodiversity.ku.edu/>

SPNHC President-Elect
http://www.spnhc.org

                           :                 :
    A  :             A  :             A  :
 }<(((_°>.,.,.,.}<(((_°>.,.,.,.}<)))_°>
    V                V                V

From: Museum discussion list [mailto:[log in to unmask]] On Behalf Of Marybeth Tomka
Sent: Thursday, February 14, 2013 10:09 AM
To: [log in to unmask]
Subject: interactive map of storage locations

Good morning all,

I am thinking about creating an interactive map of my storage locations, so that I could click on a location and find out if there is any room left in that cabinet.  Has anyone tried something like this or have any ideas about what software would be best suited for the task?

Welcome to any ideas; please share either on-list or off.

Thanks.

Marybeth
Marybeth S.F. Tomka, M.A.
Curator (Lead Curatorial Researcher)
Center for Archaeological Research
The University of Texas at San Antonio
State Certified Curatorial Repository
One UTSA Circle
San Antonio, Texas 78249
(210) 458-7822
(210) 458-4397 Fax
http://car.utsa.edu/
. . . herding cats in a forest of catnip . . .





=========================================================
Important Subscriber Information:

The Museum-L FAQ file is located at http://www.finalchapter.com/museum-l-faq/ . You may obtain detailed information about the listserv commands by sending a one line e-mail message to [log in to unmask] . The body of the message should read "help" (without the quotes).

If you decide to leave Museum-L, please send a one line e-mail message to [log in to unmask] . The body of the message should read "Signoff Museum-L" (without the quotes).