- Visit http://exoplanetarchive.ipac.caltech.edu/cgi-bin/TblView/nph-tblView?app=ExoTbls&config=planets
- Select only Planet Mass/Planet M*sin(i) (both are Jupiter Planet Mass)
- 'Download Table' => Download selected records and columns
- Use http://www.convertcsv.com/csv-to-json.htm to conver to JSON
- Inspect using Node; copy/paste to a variable assignment (ex: var epd = .. then copypaste)
- Check length -
epd.length
- Inspect data source
- Each object in the JSON array is structured to display the planet number
- Each object in the JSON array is structured to display the first value
- Each object in the JSON array is structured to display a second value if it exists
- They are split using: 'planet_no,first_mass,second_mass' or
rowid,pl_massj,pl_msinij
- We will need to look through data and verify this data - could be done using regex or
.split()
- Can skip first 5 items in collection; they contain metadata information
- Create test object like so:
var test = {
"FIELD1":"1884,,1.98100",
"FIELD2":"",
"FIELD3":""
};
- There is a Planetary Mass Classification organization (http://phl.upr.edu/library/notes/amassclassificationforbothsolarandextrasolarplanets)
- This scale is based on relative earth mass
- Our exoplanet data is jupiter mass.. time to convert
- Jupiter is equivilent to 317.83 Earth masses (https://en.wikipedia.org/wiki/Jupiter_mass)
- Convert Jupiter mass to Earth Mass
1 (jupiter mass) input_value
______ = ___________
317.83 (earth mass) output_value