Approve the Cookies
This website uses cookies to improve your user experience. By using this site, you agree to our use of cookies and our Privacy Policy.
OK
Forums  •   • New posts  •   • RTAT  •   • 'Best of'  •   • Gallery  •   • Gear
Guest
Forums  •   • New posts  •   • RTAT  •   • 'Best of'  •   • Gallery  •   • Gear
Register to forums    Log in

 
FORUMS Photo Sharing & Discussion Astronomy & Celestial 
Thread started 01 Feb 2009 (Sunday) 17:56
Search threadPrev/next
sponsored links (only for non-logged)

MySQL databases of Messier and NGC catalogues

 
troypiggo
Goldmember
Avatar
4,743 posts
Likes: 172
Joined Jun 2007
Location: Brisbane, AUSTRALIA
     
Feb 01, 2009 17:56 |  #1

Anyone have these catalogues as MySQL databases and/or know where I can get a copy?


"Interesting. You're afraid of insects and women. Ladybugs must render you catatonic." - Sheldon
Flickr (external link) | Gear List | Macro Rig | Astro Rig | Astro Software Post

  
  LOG IN TO REPLY
Jeff
Goldmember
Avatar
1,462 posts
Likes: 28
Joined Nov 2007
Location: 42° 34' N 87° 55' W Kenosha, WI
     
Feb 02, 2009 14:27 |  #2

http://haimannonline.c​om/Messier/ (external link)

I just found it and downloaded the files. It looks like there's one file to create the table structure but then each of the other 3 drop those tables and re-write them. Not sure why unless they're meant to be in independent databases.

If you're looking for this in this particular format you probably know what you're doing with MySQL, but let me know and I'll combine them if you want.


Jeff
70D | Tokina 12-24 | Tamron 17-50 f/2.8 | Canon 28-135 IS| 430EX
Astrophotograpy: QHY268m, Astronomik Deepsky LRGBHaO3S2 filters, Meade 10" SCT, Astrotect 130EDT APO (.8x), iOptron CEM60 to keep it all off the ground.
MY AIRPLANE PICS (external link) | MY ASTRO PICS (external link)

  
  LOG IN TO REPLY
troypiggo
THREAD ­ STARTER
Goldmember
Avatar
4,743 posts
Likes: 172
Joined Jun 2007
Location: Brisbane, AUSTRALIA
     
Feb 02, 2009 14:57 |  #3

Thanks mate. Yeah, I think know what I'm doing :) I'll look into that one.

I'm trying to create a database that contains all Messier objects with their "M42" number, their common names like "Orion Nebula", and a similar one for NGC objects with a cross-reference between them for objects in both catalogues. I'm rewriting my homepage and gallery to use MySQL, and thought it'd be cool to be able to reference this astro database as I shoot objects.


"Interesting. You're afraid of insects and women. Ladybugs must render you catatonic." - Sheldon
Flickr (external link) | Gear List | Macro Rig | Astro Rig | Astro Software Post

  
  LOG IN TO REPLY
Jeff
Goldmember
Avatar
1,462 posts
Likes: 28
Joined Nov 2007
Location: 42° 34' N 87° 55' W Kenosha, WI
     
Feb 02, 2009 15:11 |  #4

I got a little curious and looked into these files some more. I combined them into one database table and added a field for object category. Looks like a lot of the stuff can be dropped.

I'll attach a zip file with the sql in it.


Jeff
70D | Tokina 12-24 | Tamron 17-50 f/2.8 | Canon 28-135 IS| 430EX
Astrophotograpy: QHY268m, Astronomik Deepsky LRGBHaO3S2 filters, Meade 10" SCT, Astrotect 130EDT APO (.8x), iOptron CEM60 to keep it all off the ground.
MY AIRPLANE PICS (external link) | MY ASTRO PICS (external link)

  
  LOG IN TO REPLY
Jeff
Goldmember
Avatar
1,462 posts
Likes: 28
Joined Nov 2007
Location: 42° 34' N 87° 55' W Kenosha, WI
     
Feb 02, 2009 15:13 |  #5

And good idea on the cross referencing of object data with it's image.


Jeff
70D | Tokina 12-24 | Tamron 17-50 f/2.8 | Canon 28-135 IS| 430EX
Astrophotograpy: QHY268m, Astronomik Deepsky LRGBHaO3S2 filters, Meade 10" SCT, Astrotect 130EDT APO (.8x), iOptron CEM60 to keep it all off the ground.
MY AIRPLANE PICS (external link) | MY ASTRO PICS (external link)

  
  LOG IN TO REPLY
troypiggo
THREAD ­ STARTER
Goldmember
Avatar
4,743 posts
Likes: 172
Joined Jun 2007
Location: Brisbane, AUSTRALIA
     
Feb 02, 2009 16:09 |  #6

Thanks Jeff. I'll (try to remember to) keep you posted. :)


"Interesting. You're afraid of insects and women. Ladybugs must render you catatonic." - Sheldon
Flickr (external link) | Gear List | Macro Rig | Astro Rig | Astro Software Post

  
  LOG IN TO REPLY
sponsored links (only for non-logged)

1,394 views & 0 likes for this thread, 2 members have posted to it.
MySQL databases of Messier and NGC catalogues
FORUMS Photo Sharing & Discussion Astronomy & Celestial 
AAA
x 1600
y 1600

Jump to forum...   •  Rules   •  Forums   •  New posts   •  RTAT   •  'Best of'   •  Gallery   •  Gear   •  Reviews   •  Member list   •  Polls   •  Image rules   •  Search   •  Password reset   •  Home

Not a member yet?
Register to forums
Registered members may log in to forums and access all the features: full search, image upload, follow forums, own gear list and ratings, likes, more forums, private messaging, thread follow, notifications, own gallery, all settings, view hosted photos, own reviews, see more and do more... and all is free. Don't be a stranger - register now and start posting!


COOKIES DISCLAIMER: This website uses cookies to improve your user experience. By using this site, you agree to our use of cookies and to our privacy policy.
Privacy policy and cookie usage info.


POWERED BY AMASS forum software 2.58forum software
version 2.58 /
code and design
by Pekka Saarinen ©
for photography-on-the.net

Latest registered member is IoDaLi Photography
1631 guests, 141 members online
Simultaneous users record so far is 15,144, that happened on Nov 22, 2018

Photography-on-the.net Digital Photography Forums is the website for photographers and all who love great photos, camera and post processing techniques, gear talk, discussion and sharing. Professionals, hobbyists, newbies and those who don't even own a camera -- all are welcome regardless of skill, favourite brand, gear, gender or age. Registering and usage is free.