Ygthkb

Is it ethical to apply for a job on someone's behalf?

Was Opportunity's last message to Earth "My battery is low and it's getting dark"?

Why is Shelob considered evil?

Why do we interpret the accelerated expansion of the universe as the proof for the existence of dark energy?

Do these large-scale, human power-plant-tending robots from the Matrix movies have a name, in-universe or out?

80-bit collision resistence because of 80-bit x87 registers?

How do I add a strong "onion flavor" to the biryani (in restaurant style)?

Found a major flaw in paper from home university – to which I would like to return

Question: "Are you hungry?" Answer: "I feel like eating."

Is layered encryption more secure than long passwords?

Cryptic cross... with words

What does an unprocessed RAW file look like?

What does "don't have a baby" imply or mean in this sentence?

Log to console in a Lightning Web Component

Have any astronauts or cosmonauts died in space?

How to typeset a small black square as a binary operator?

How do I split ammo?

How to know if I am a 'Real Developer'

When distributing a Linux kernel driver as source code, what's the difference between Proprietary and GPL license?

Now...where was I?

Is Screenshot Time-tracking Common?

For the Circle of Spores druid's Halo of Spores feature, is your reaction used regardless of whether the other creature succeeds on the saving throw?

Coworker is trying to get me to sign his petition to run for office. How to decline politely?

Given the mapping a = 1, b = 2, ... z = 26, and an encoded message, count the number of ways it can be decoded

Is there a data type I can use for RA & Dec in astronomy

Data type for currency 'type' column, e.g. usd, cat, etc.Is there such thing as automatic ENUMs?What kind of data type to use for numbering in the Harmonized System?Best practice for a Table with private columnsMySQL does not use index for wildcard-free query on an INT field - why?Is it possible to create a function for transactions that use more than one database?What data type for a column which can have three states: yes, no, unknownAccess Field Data Type ChangedHow can I use Spatial Indexes for timestamps (non-spatial 1d data)?best column type for hashed data in mysql

1

1

I need to have fields in my database for the following:

• RA (hh:mm:ss.00)


• Dec (Degrees:arcseconds:arcminutes.00)

I need to have the facility to search for a range within each field.

Any ideas?

mysql datatypes

share|improve this question

edited Sep 29 '14 at 19:52

Mat

8,03123338

asked Sep 29 '14 at 18:25

sarahsarah

61

bumped to the homepage by Community♦ 13 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Which DBMS do you use?
  
  – ypercubeᵀᴹ
  Sep 29 '14 at 19:47
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  mysql workbench on mac
  
  – sarah
  Sep 29 '14 at 19:47
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  On Microsoft SQL Server, Spatial Data features were used to build the SkyServer for astronomical use. See: technet.microsoft.com/en-us/library/aa964138(v=sql.90).aspx. I know that MySQL also has extensions for Spatial Data, so it might be possible to leverage that functionality. dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html
  
  – RLF
  Sep 29 '14 at 20:41
  
  
  

  
  
  
  

add a comment | 

1

1

I need to have fields in my database for the following:

• RA (hh:mm:ss.00)


• Dec (Degrees:arcseconds:arcminutes.00)

I need to have the facility to search for a range within each field.

Any ideas?

mysql datatypes

share|improve this question

edited Sep 29 '14 at 19:52

Mat

8,03123338

asked Sep 29 '14 at 18:25

sarahsarah

61

bumped to the homepage by Community♦ 13 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Which DBMS do you use?
  
  – ypercubeᵀᴹ
  Sep 29 '14 at 19:47
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  mysql workbench on mac
  
  – sarah
  Sep 29 '14 at 19:47
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  On Microsoft SQL Server, Spatial Data features were used to build the SkyServer for astronomical use. See: technet.microsoft.com/en-us/library/aa964138(v=sql.90).aspx. I know that MySQL also has extensions for Spatial Data, so it might be possible to leverage that functionality. dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html
  
  – RLF
  Sep 29 '14 at 20:41
  
  
  

  
  
  
  

add a comment | 

I need to have fields in my database for the following:

• RA (hh:mm:ss.00)


• Dec (Degrees:arcseconds:arcminutes.00)

I need to have the facility to search for a range within each field.

Any ideas?

mysql datatypes

share|improve this question

edited Sep 29 '14 at 19:52

Mat

8,03123338

asked Sep 29 '14 at 18:25

sarahsarah

61

share|improve this question

edited Sep 29 '14 at 19:52

Mat

8,03123338

asked Sep 29 '14 at 18:25

sarahsarah

61

share|improve this question

edited Sep 29 '14 at 19:52

Mat

8,03123338

asked Sep 29 '14 at 18:25

sarahsarah

61

edited Sep 29 '14 at 19:52

Mat

8,03123338

edited Sep 29 '14 at 19:52

Mat

8,03123338

asked Sep 29 '14 at 18:25

sarahsarah

61

asked Sep 29 '14 at 18:25

sarahsarah

61

1 Answer
1

active

oldest

votes

0

If you just want to store the coordinates, for later searching, your best bet is to convert from degrees-minutes-seconds to decimal degrees, and store as DECIMAL. Here is an answer giving mysql functions that do that conversion, in both directions.

If you want to do more complex things like "Is this point within the constellation Orion" then you probably need to use spatial data extensions, as @RLF suggested in a comment.
http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html
http://dev.mysql.com/doc/refman/5.0/en/using-spatial-data.html

share|improve this answer

edited May 23 '17 at 11:33

Community♦

1

answered Sep 30 '14 at 23:12

Ross PresserRoss Presser

21318

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f77974%2fis-there-a-data-type-i-can-use-for-ra-dec-in-astronomy%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

If you just want to store the coordinates, for later searching, your best bet is to convert from degrees-minutes-seconds to decimal degrees, and store as DECIMAL. Here is an answer giving mysql functions that do that conversion, in both directions.

If you want to do more complex things like "Is this point within the constellation Orion" then you probably need to use spatial data extensions, as @RLF suggested in a comment.
http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html
http://dev.mysql.com/doc/refman/5.0/en/using-spatial-data.html

share|improve this answer

edited May 23 '17 at 11:33

Community♦

1

answered Sep 30 '14 at 23:12

Ross PresserRoss Presser

21318

add a comment | 

0

If you just want to store the coordinates, for later searching, your best bet is to convert from degrees-minutes-seconds to decimal degrees, and store as DECIMAL. Here is an answer giving mysql functions that do that conversion, in both directions.

If you want to do more complex things like "Is this point within the constellation Orion" then you probably need to use spatial data extensions, as @RLF suggested in a comment.
http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html
http://dev.mysql.com/doc/refman/5.0/en/using-spatial-data.html

share|improve this answer

edited May 23 '17 at 11:33

Community♦

1

answered Sep 30 '14 at 23:12

Ross PresserRoss Presser

21318

add a comment | 

If you just want to store the coordinates, for later searching, your best bet is to convert from degrees-minutes-seconds to decimal degrees, and store as DECIMAL. Here is an answer giving mysql functions that do that conversion, in both directions.

If you want to do more complex things like "Is this point within the constellation Orion" then you probably need to use spatial data extensions, as @RLF suggested in a comment.
http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html
http://dev.mysql.com/doc/refman/5.0/en/using-spatial-data.html

share|improve this answer

edited May 23 '17 at 11:33

Community♦

1

answered Sep 30 '14 at 23:12

Ross PresserRoss Presser

21318

share|improve this answer

edited May 23 '17 at 11:33

Community♦

1

answered Sep 30 '14 at 23:12

Ross PresserRoss Presser

21318

edited May 23 '17 at 11:33

Community♦

1

edited May 23 '17 at 11:33

Community♦

1

answered Sep 30 '14 at 23:12

Ross PresserRoss Presser

21318

answered Sep 30 '14 at 23:12

Ross PresserRoss Presser

21318