That's great David, I would love to see the database.  If it's too large to
email, let me know and I'll send details about our file sharing service.
I'm really glad you did this export.

Thanks,
Jeff



On Thu, Jan 19, 2017 at 7:39 AM, David Hodnefield <[log in to unmask]
> wrote:

> I’m pretty sure the ASPRS database has not been updated since 1996.  Some
> years ago I migrated the ASPRS database into MS Access.  I did it by
> exporting all the records to comma delimited text files.  I don’t recall
> the exact process anymore, but I’m pretty sure I did the export based on
> the type of film (B&W, Color, BIR, CIR).  Because all the fields come out
> as pure text, the files were rather large. It was a rather slow process,
> but at least it only had to be done once!   I recommend exporting the
> records and then importing the text files into a more powerful database
> like SQL (MS Access is too wimpy). Splitting the one flat table into
> multiple tables would make for a more efficient database (it may be
> possible to export some of the other tables from ASPRS).  Feel free to
> contact me if you have more questions.
>
>
>
> David
> ------------------------------
>
>    [image: Description: cid:image001.png@01CD70F3.D84978F0]   *limiting
> liability with relevant environmental* *research*
>
>
>
> *David Hodnefield, President*
>
> *Historical Information Gatherers*
>
>
>
> *[log in to unmask] <[log in to unmask]>*
>
> 952-253-2004 ext 111 <(952)%20253-2004>
>
> www.historicalinfo.com
>
>
>
> *From:* Maps-L: Map Librarians, etc. [mailto:[log in to unmask]] *On
> Behalf Of *Jeff Essic
> *Sent:* Wednesday, January 18, 2017 4:07 PM
> *To:* [log in to unmask]
> *Subject:* APSRS CDs - Database of aerial photo missions
>
>
>
> Hello,
>
>
>
> The APSRS CDs released in the mid-1990s contain an database used to list
> all the federal-level aerial photo missions covering any given 7.5 minute
> quadrangle area.  To use, one must install a front-end software app for
> querying the underlying database.  The software is 16-bit and thus cannot
> be installed on modern 64-bit computers.  Meanwhile, the underlying
> database appears to be in a proprietary binary format that can't be easily
> opened and read.
>
>
>
> I am thus wondering if anyone knows of a continuity plan to update the
> software and/or the database?  Or is there an alternative means for
> accessing the data, perhaps something online?  Using EarthExplorer, this
> can be done in a round-about way, but you have to select each agency one at
> a time to see what may possibly be available.
>
>
>
> By the way, APSRS (not to be confused with ASPRS) stands for Aerial
> Photography Summary Record System.
>
>
>
> I appreciate your thoughts and ideas!
>
>
>
> Jeff Essic
>
>
>
>
>
> ------------------------------------------------------------
> ------------------------
>
> Jeff Essic
> Data Services Librarian
> North Carolina State University
> D.H. Hill Library, Research Engagement Department
> Box 7111, Raleigh, NC  27695-7111
> (919) 515-5698
> http://www.lib.ncsu.edu/gis
>
>
>
>
>