Would it be too much trouble to check if it has info on the underfilghts for the Skylab Earth Resource Experiment package back in 1972? We have the film but not much documentation. For example, on the 9th flight we have 3 rolls of film. Not sure if that is all or if we are missing rolls. The experiment was to have a plane do aerial photography along the same path as the space station and then compare the two. Thanks, David Bigwood [log in to unmask]<mailto:[log in to unmask]> Lunar and Planetary Institute From: Maps-L: Map Librarians, etc. [mailto:[log in to unmask]] On Behalf Of Jeff Essic Sent: Thursday, January 19, 2017 7:50 AM To: [log in to unmask] Subject: Re: APSRS CDs - Database of aerial photo missions 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]<mailto:[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 ________________________________ [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<tel:(952)%20253-2004> www.historicalinfo.com<http://www.historicalinfo.com> From: Maps-L: Map Librarians, etc. [mailto:[log in to unmask]<mailto:[log in to unmask]>] On Behalf Of Jeff Essic Sent: Wednesday, January 18, 2017 4:07 PM To: [log in to unmask]<mailto:[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<tel:(919)%20515-5698> http://www.lib.ncsu.edu/gis