mersenneforum.org  

Go Back   mersenneforum.org > Extra Stuff > Hobbies > Astronomy

Reply
 
Thread Tools
Old 2017-04-30, 16:50   #1
xilman
Bamboozled!
 
xilman's Avatar
 
"๐’‰บ๐’ŒŒ๐’‡ท๐’†ท๐’€ญ"
May 2003
Down not across

3·7·547 Posts
Default Database design

Anyone here, other than fivemack and I, have a significant number of astronomical images? Despite not having even a primitive webcam attached to even the most rudimentary telescope, I've already accumulated around a thousand images, roughly 10% from Tom. A few hundred more, >600 of them being 0.5ms images of Sirius, were provided by Paul Fellows who is also a member of the Cambridge Astronomical Association. The results of our collaboration can be found in the latest CAA newsletter.

I noticed that Paul had a few difficulties finding historical images in his file systems and before that I'd already recognized the likelihood that I would too in the future. The standard image format, FITS, supports rich meta-data about the image(s) a file contains but it is not easily searchable across many images. Much the same can be said about the NEF format images which Tom provided.

Accordingly I've been thinking about a SQL database and have written a preliminary PostgreSQL schema. The schema is doubtless incomplete, too baroque and/or just plain wrong but the aim is to be able to locate any images which were taken from a particular place, in a particular time period, contain a particular celestial co-ordinate, (type of) celestial object, constellation, photometry band and so on. Explicitly not required is to duplicate all the image meta-data nor all the data contained in the likes of the NOMAD-1 catalogue.

If anyone else is interested in such a database and would like to get involved, please say so in this thread.
xilman is offline   Reply With Quote
Old 2017-04-30, 22:25   #2
Uncwilly
6809 > 6502
 
Uncwilly's Avatar
 
"""""""""""""""""""
Aug 2003
101ร—103 Posts

1071710 Posts
Default

Quote:
Originally Posted by xilman View Post
Anyone here, other than fivemack and I, have a significant number of astronomical images?
....
The standard image format, FITS, supports rich meta-data about the image(s) a file contains but it is not easily searchable across many images. Much the same can be said about the NEF format images which Tom provided.
.....
Accordingly I've been thinking about a SQL database and have written a preliminary PostgreSQL schema. The schema is doubtless incomplete, too baroque and/or just plain wrong but the aim is to be able to locate any images which were taken from a particular place, in a particular time period, contain a particular celestial co-ordinate, (type of) celestial object, constellation, photometry band and so on. Explicitly not required is to duplicate all the image meta-data nor all the data contained in the likes of the NOMAD-1 catalogue.

If anyone else is interested in such a database and would like to get involved, please say so in this thread.
I don't know if any standard image catalogue software would be useful. I have threatened myself with installing some years ago (I downloaded a huge number of images of trains and autos from usenet).

I will be in the same room this Friday with NASA staff from JPL. Their Planetary Data System might be a cannon for your fly. I can see if one or more would be willing to talk to you. Last year at the event I was attending there were 2 JPL projects being presented (along with others): one wrt data set management, large data set transferring (data sets in the 10's of GB size [or even the 100's] that needed to be made available), & hosting; and an automated Mars crater identification and data extraction system (taking image sets and determining size, depth, etc. IIRC correctly this also worked with input from the Zooniverse's crater mappers.) I talked with one of the JPL staff a few months ago (very informally).

Last fiddled with by Uncwilly on 2017-04-30 at 22:38
Uncwilly is online now   Reply With Quote
Reply

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Primenet web design Madpoo PrimeNet 580 2022-08-23 07:00
Theoretical Experiment Design c10ck3r Homework Help 7 2015-02-03 08:54
Digital Logic Design henryzz Puzzles 9 2014-12-04 20:56
new intel design tha Hardware 5 2007-04-19 11:38
design factoring algorithms koders333 Factoring 14 2006-01-25 14:08

All times are UTC. The time now is 23:30.


Sun Sep 25 23:30:20 UTC 2022 up 38 days, 20:58, 0 users, load averages: 1.10, 1.28, 1.25

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.

This forum has received and complied with 0 (zero) government requests for information.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.
A copy of the license is included in the FAQ.

โ‰  ยฑ โˆ“ รท ร— ยท โˆ’ โˆš โ€ฐ โŠ— โŠ• โŠ– โŠ˜ โŠ™ โ‰ค โ‰ฅ โ‰ฆ โ‰ง โ‰จ โ‰ฉ โ‰บ โ‰ป โ‰ผ โ‰ฝ โŠ โŠ โŠ‘ โŠ’ ยฒ ยณ ยฐ
โˆ  โˆŸ ยฐ โ‰… ~ โ€– โŸ‚ โซ›
โ‰ก โ‰œ โ‰ˆ โˆ โˆž โ‰ช โ‰ซ โŒŠโŒ‹ โŒˆโŒ‰ โˆ˜ โˆ โˆ โˆ‘ โˆง โˆจ โˆฉ โˆช โจ€ โŠ• โŠ— ๐–• ๐–– ๐–— โŠฒ โŠณ
โˆ… โˆ– โˆ โ†ฆ โ†ฃ โˆฉ โˆช โŠ† โŠ‚ โŠ„ โŠŠ โŠ‡ โŠƒ โŠ… โŠ‹ โŠ– โˆˆ โˆ‰ โˆ‹ โˆŒ โ„• โ„ค โ„š โ„ โ„‚ โ„ต โ„ถ โ„ท โ„ธ ๐“Ÿ
ยฌ โˆจ โˆง โŠ• โ†’ โ† โ‡’ โ‡ โ‡” โˆ€ โˆƒ โˆ„ โˆด โˆต โŠค โŠฅ โŠข โŠจ โซค โŠฃ โ€ฆ โ‹ฏ โ‹ฎ โ‹ฐ โ‹ฑ
โˆซ โˆฌ โˆญ โˆฎ โˆฏ โˆฐ โˆ‡ โˆ† ฮด โˆ‚ โ„ฑ โ„’ โ„“
๐›ข๐›ผ ๐›ฃ๐›ฝ ๐›ค๐›พ ๐›ฅ๐›ฟ ๐›ฆ๐œ€๐œ– ๐›ง๐œ ๐›จ๐œ‚ ๐›ฉ๐œƒ๐œ— ๐›ช๐œ„ ๐›ซ๐œ… ๐›ฌ๐œ† ๐›ญ๐œ‡ ๐›ฎ๐œˆ ๐›ฏ๐œ‰ ๐›ฐ๐œŠ ๐›ฑ๐œ‹ ๐›ฒ๐œŒ ๐›ด๐œŽ๐œ ๐›ต๐œ ๐›ถ๐œ ๐›ท๐œ™๐œ‘ ๐›ธ๐œ’ ๐›น๐œ“ ๐›บ๐œ”