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
________________________________
[Description: cid:image001.png@01CD70F3.D84978F0] limiting liability with relevant environmental research
David Hodnefield, President
Historical Information Gatherers
[log in to unmask]<mailto:[log in to unmask]>
952-253-2004 ext 111
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
|