new schemas: galaxy local group

[arjunsavel]

Collaborator: Erik Tollerud @eteq

[arjunsavel]

https://app.mural.co/t/stsciinternal7446/m/stsciinternal7446/1726063940720/6b3a93a08fc054bfce3b2d5767fc84286572755c?sender=u33052eb3c0170c5d30937056

[kelle]

@dr-rodriguez , could you please copy and paste some of your notes from today here. At the moment, I'm most interested in the links to the two data sources: the Mc12 paper and the Pace github repo.

[kelle]

Get started in DrawSQL once team account is established (#76).

[kelle]

Mc12: https://www.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/en/community/nearby/
managed by Alan McConnachie

[kelle]

@eteq - Could you comment on this issue with a list of the highest priority/most common fields we want to track for galaxies. (See #104 for parameters already on our list.)

[kelle]

Column Metadata

done?	Column Name	Destination table	Description
[x]	GalaxyName	Sources	Galaxy name
[x]	RA	Sources	Right Ascension (hours minutes seconds)
[x]	Dec	Sources	Declination (degrees arcminutes arcseconds)
[ ]	EB-V	skip	Foreground reddening, E(B-V), measured directly from the Schlegel et al 1998 maps (they do not include the recalibration by Schlafly & Finbiener 2011)
[ ]	dmod	Modeled Parameters	Distance Modulus, (m-M)o err+ err-
[ ]	dmod+
[ ]	dmod-
[ ]	vh	Radial Velocity	Heliocentric radial velocity, vh(km/s) err+ err-
[ ]	vh+
[ ]	vh-
[ ]	Vmag	Photometry	Apparent V magnitude in Vega mags, Vmag err+ err-
[ ]	Vmag+
[ ]	Vmag-
[ ]	Classification	Morphology	galaxy type (Irr, Sph, etc)
[ ]	PA	Morphology	Position Angle of major axis in degrees measured east from north, PA err+ err-
[ ]	PA+
[ ]	PA-
[ ]	e=1-b/a	Morphology	Projected ellipticity, e=1-b/a err+ err-
[ ]	e+
[ ]	e-
[ ]	muVo	Modeled Parameters	Central V surface brightness, muVo(mag/sq.arcsec) err+ err-
[ ]	muVo+
[ ]	muVo-
[ ]	rh	Morphology	Half-light radius measured on major axis, rh(arcmins) err+ err-
[ ]	rh+
[ ]	rh-
[ ]	sigma_s	Modeled Parameters	Stellar radial velocity dispersion, sigma_s(km/s) err+ err-
[ ]	sigma_s+
[ ]	sigma_s-
[ ]	vrot_s	Modeled Parameters	Stellar peak/max rotation velocity, vrot_s(km/s) err+ err-
[ ]	vrot_s+
[ ]	vrot_s-
[ ]	MHI	Modeled Parameters	Mass of HI (calculated for the adopted distance modulus), M_HI (10^6M_sun)
[ ]	sigma_g	Modeled Parameters	HI radial velocity dispersion, sigma_g(km/s) err+ err-
[ ]	sigma_g+
[ ]	sigma_g-
[ ]	vrot_g	Modeled Parameters	HI peak/max rotation velocity, vrot_g(km/s) err+ err-
[ ]	vrot_g+
[ ]	vrot_g-
[ ]	[Fe/H]	Modeled Parameters	Stellar mean metallicity in dex, [Fe/H] err+ err-
[ ]	feh+
[ ]	feh-
[ ]	F		Flag, F, for technique used to measure metallicity: 1=High res. spectroscopy; 2=Spectral synthesis; 3=CaT calibration; 4=CMD modelling; 5=Isochrones; 6=color of red giant branch
[ ]	pmra	Proper Motions	mu_alpha*cos(delta) - proper motion in RA direction in mas/yr, +err, -err
[ ]	epmra+
[ ]	epmra-
[ ]	pmdec	Proper Motions	mu_delta - proper motion in declination direction in mas/yr, +err, -err
[ ]	epmdec+
[ ]	epmdec-
[ ]	References	Publications	References, numbers refer to list given in supplementary file "References.dat"

[dr-rodriguez]

Starting prototype at https://github.com/dr-rodriguez/Galaxy-Local-Group

[kelle]

output from astrodb_bot skill:

Column	Description	Units	Type
GalaxyName	Galaxy name	—	string
RA	Right Ascension (hours minutes seconds)	—	string
Dec	Declination (degrees arcminutes arcseconds)	—	string
EB-V	Foreground reddening, E(B-V), measured directly from the Schlegel et al 1998 maps (they do not include the recalibration by Schlafly & Finbiener 2011)	mag	float32
dmod	Distance Modulus, (m-M)o err+ err-	mag	float32
dmod+	Upper uncertainty on dmod	mag	float32
dmod-	Lower uncertainty on dmod	mag	float32
vh	Heliocentric radial velocity, vh(km/s) err+ err-	km / s	float32
vh+	Upper uncertainty on vh	km / s	float32
vh-	Lower uncertainty on vh	km / s	float32
Vmag	Apparent V magnitude in Vega mags, Vmag err+ err-	mag	float32
Vmag+	Upper uncertainty on Vmag	mag	float32
Vmag-	Lower uncertainty on Vmag	mag	float32
PA	Position Angle of major axis in degrees measured east from north, PA err+ err-	deg	float32
PA+	Upper uncertainty on PA	deg	float32
PA-	Lower uncertainty on PA	deg	float32
e=1-b/a	Projected ellipticity, e=1-b/a err+ err-	dimensionless_unscaled	float32
e+	Upper uncertainty on ellipticity (e=1-b/a)	dimensionless_unscaled	float32
e-	Lower uncertainty on ellipticity (e=1-b/a)	dimensionless_unscaled	float32
muVo	Central V surface brightness, muVo(mag/sq.arcsec) err+ err-	mag / arcsec2	float32
muVo+	Upper uncertainty on muVo	mag / arcsec2	float32
muVo-	Lower uncertainty on muVo	mag / arcsec2	float32
rh	Half-light radius measured on major axis, rh(arcmins) err+ err-	arcmin	float32
rh+	Upper uncertainty on rh	arcmin	float32
rh-	Lower uncertainty on rh	arcmin	float32
sigma_s	Stellar radial velocity dispersion, sigma_s(km/s) err+ err-	km / s	float32
sigma_s+	Upper uncertainty on sigma_s	km / s	float32
sigma_s-	Stellar peak/max rotation velocity, vrot_s(km/s) err+ err-	km / s	float32
vrot_s	Stellar peak/max rotation velocity, vrot_s (km/s)	km / s	float32
vrot_s+	Upper uncertainty on vrot_s	km / s	float32
vrot_s-	Lower uncertainty on vrot_s	km / s	float32
MHI	Mass of HI (calculated for the adopted distance modulus), M_HI (10^6M_sun)	1e+06 solMass	float32
sigma_g	HI radial velocity dispersion, sigma_g(km/s) err+ err-	km / s	float32
sigma_g+	Upper uncertainty on sigma_g	km / s	float32
sigma_g-	Lower uncertainty on sigma_g	km / s	float32
vrot_g	HI peak/max rotation velocity, vrot_g(km/s) err+ err-	km / s	float32
vrot_g+	Upper uncertainty on vrot_g	km / s	float32
vrot_g-	Lower uncertainty on vrot_g	km / s	float32
[Fe/H]	Stellar mean metallicity in dex, [Fe/H] err+ err-	dex	float32
feh+	Upper uncertainty on [Fe/H]	dex	float32
feh-	Lower uncertainty on [Fe/H]	dex	float32
F	Flag, F, for technique used to measure metallicity: 1=High res. spectroscopy; 2=Spectral synthesis; 3=CaT calibration; 4=CMD modelling; 5=Isochrones; 6=color of red giant branch	—	int16
pmra	mu_alpha*cos(delta) - proper motion in RA direction in mas/yr, +err, -err	mas / yr	float32
epmra+	Upper uncertainty on pmra	mas / yr	float32
epmra-	Lower uncertainty on pmra	mas / yr	float32
pmdec	mu_delta - proper motion in declination direction in mas/yr, +err, -err	mas / yr	float32
epmdec+	Upper uncertainty on pmdec	mas / yr	float32
epmdec-	Lower uncertainty on pmdec	mas / yr	float32
References	References, numbers refer to list given in supplementary file "References.dat"	—	string