Carbon Cycle Surface Flasks SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=1 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
ALT	Alert, Nunavut	82.45	-62.51	200.0	Canada
AMS *	Amsterdam Island	-37.95	77.53	150.0	France
AMT	Argyle, Maine	45.03	-68.68	53.0	United States
ASC	Ascension Island	-7.97	-14.40	85.0	United Kingdom
ASK	Assekrem	23.18	5.42	1842.0	Algeria
AVI *	St. Croix, Virgin Islands	17.75	-64.75	3.0	United States
AZR	Terceira Island, Azores	38.77	-27.38	19.0	Portugal
BAL *	Baltic Sea	55.35	17.22	3.0	Poland
BAO	Boulder Atmospheric Observatory, Colorado	40.05	-105.00	1584.0	United States
BHD	Baring Head Station	-41.41	174.87	80.0	New Zealand
BKT *	Bukit Kototabang	-0.20	100.32	845.0	Indonesia
BME *	St. Davids Head, Bermuda	32.37	-64.65	12.0	United Kingdom
BMW	Tudor Hill, Bermuda	32.26	-64.88	30.0	United Kingdom
BRW	Barrow, Alaska	71.32	-156.61	11.0	United States
BSC *	Black Sea, Constanta	44.18	28.66	0.0	Romania
CBA	Cold Bay, Alaska	55.21	-162.72	21.3	United States
CGO	Cape Grim, Tasmania	-40.68	144.69	94.0	Australia
CHR	Christmas Island	1.70	-157.15	0.0	Republic of Kiribati
CHS	Cherskii	68.51	161.53	30.0	Russia
CIB	Centro de Investigacion de la Baja Atmosfera (CIBA)	41.81	-4.93	845.0	Spain
CMO *	Cape Meares, Oregon	45.48	-123.97	30.0	United States
COS *	Cosmos	-12.12	-75.33	4600.0	Peru
CPT	Cape Point	-34.35	18.49	230.0	South Africa
CRV	Carbon in Arctic Reservoirs Vulnerability Experiment (CARVE)	64.99	-147.60	611.4	United States
CRZ	Crozet Island	-46.43	51.85	197.0	France
DRP	Drake Passage	-59.00	-64.69	0.0	N/A
DSI	Dongsha Island	20.70	116.73	3.0	Taiwan
EIC	Easter Island	-27.16	-109.43	47.0	Chile
FLK *	Falkland Islands	-51.70	-57.87	51.0	United Kingdom
GLF *	Conejo	18.72	-95.63	113.0	Mexico
GMI	Mariana Islands	13.39	144.66	0.0	Guam
GOZ *	Dwejra Point, Gozo	36.05	14.89	1.0	Malta
HBA	Halley Station, Antarctica	-75.61	-26.21	30.0	United Kingdom
HPB	Hohenpeissenberg	47.80	11.02	936.0	Germany
HSU	Humboldt State University	41.06	-124.75	0.0	United States
HUN	Hegyhatsal	46.95	16.65	248.0	Hungary
ICE	Storhofdi, Vestmannaeyjar	63.40	-20.29	118.0	Iceland
INX	INFLUX (Indiana Flux Experiment)	39.58	-86.42	250.0	United States
ITN *	Grifton, North Carolina	35.37	-77.39	8.0	United States
IZO	Tenerife, Canary Islands	28.31	-16.50	2372.9	Spain
KCO *	Kaashidhoo	4.97	73.47	1.0	Republic of Maldives
KEY	Key Biscayne, Florida	25.67	-80.16	1.0	United States
KPA *	Kitt Peak, Arizona	32.00	-112.00	2083.0	United States
KUM	Cape Kumukahi, Hawaii	19.52	-154.82	3.0	United States
KZD *	Sary Taukum	44.08	76.87	595.0	Kazakhstan
KZM *	Plateau Assy	43.25	77.88	2519.0	Kazakhstan
LEF	Park Falls, Wisconsin	45.95	-90.27	472.0	United States
LEW	Lewisburg, Pennsylvania	40.94	-76.88	161.0	United States
LLB	Lac La Biche, Alberta	54.95	-112.45	540.0	Canada
LLN	Lulin	23.47	120.87	2862.0	Taiwan
LMP	Lampedusa	35.52	12.62	45.0	Italy
MBC *	Mould Bay, Nunavut	76.25	-119.35	30.0	Canada
MBO	Mt. Bachelor Observatory	43.98	-121.69	2731.0	United States
MCM *	McMurdo Station, Antarctica	-77.83	166.60	11.0	United States
MEX	High Altitude Global Climate Observation Center	18.98	-97.31	4464.0	Mexico
MHD	Mace Head, County Galway	53.33	-9.90	5.0	Ireland
MID	Sand Island, Midway	28.21	-177.38	11.0	United States
MKN *	Mt. Kenya	-0.06	37.30	3644.0	Kenya
MKO *	Mauna Kea, Hawaii	19.83	-155.47	4220.0	United States
MLF *	Mauna Loa, Hawaii	19.53	-155.58	3397.0	United States
MLO	Mauna Loa, Hawaii	19.54	-155.58	3397.0	United States
MVY *	Marthas Vineyard, Massachusetts	41.33	-70.52	0.0	United States
MWO	Mt. Wilson Observatory	34.22	-118.06	1728.0	United States
NAT	Maxaranguape	-5.51	-35.26	15.0	Brazil
NMB	Gobabeb	-23.58	15.03	456.0	Namibia
NWF *	Niwot Ridge Forest, Colorado	40.03	-105.55	3050.0	United States
NWR	Niwot Ridge, Colorado	40.05	-105.59	3523.0	United States
NZL *	Kaitorete Spit	-43.83	172.63	3.0	New Zealand
OPW *	Olympic Peninsula, Washington	48.30	-124.63	486.0	United States
OXK	Ochsenkopf	50.03	11.81	1009.0	Germany
PAL	Pallas-Sammaltunturi, GAW Station	67.97	24.12	560.0	Finland
PCO *	Pico, Azores	38.47	-28.40	2225.0	Portugal
POCN00 *	Pacific Ocean (0 N)	0.00	-155.00	10.0	N/A
POCN05 *	Pacific Ocean (5 N)	5.00	-151.00	10.0	N/A
POCN10 *	Pacific Ocean (10 N)	10.00	-149.00	10.0	N/A
POCN15 *	Pacific Ocean (15 N)	15.00	-145.00	10.0	N/A
POCN20 *	Pacific Ocean (20 N)	20.00	-141.00	10.0	N/A
POCN25 *	Pacific Ocean (25 N)	25.00	-139.00	10.0	N/A
POCN30 *	Pacific Ocean (30 N)	30.00	-135.00	10.0	N/A
POCN35 *	Pacific Ocean (35 N)	35.00	-137.00	10.0	N/A
POCN40 *	Pacific Ocean (40 N)	40.00	-136.00	10.0	N/A
POCN45 *	Pacific Ocean (45 N)	45.00	-131.00	10.0	N/A
POCS05 *	Pacific Ocean (5 S)	-5.00	-159.00	10.0	N/A
POCS10 *	Pacific Ocean (10 S)	-10.00	-161.00	10.0	N/A
POCS15 *	Pacific Ocean (15 S)	-15.00	-171.00	10.0	N/A
POCS20 *	Pacific Ocean (20 S)	-20.00	-174.00	10.0	N/A
POCS25 *	Pacific Ocean (25 S)	-25.00	-171.00	10.0	N/A
POCS30 *	Pacific Ocean (30 S)	-30.00	-176.00	10.0	N/A
POCS35 *	Pacific Ocean (35 S)	-35.00	180.00	10.0	N/A
PSA	Palmer Station, Antarctica	-64.92	-64.00	10.0	United States
PSM *	Point Six Mountain, Montana	47.03	-113.98	2462.0	United States
PTA *	Point Arena, California	38.95	-123.74	17.0	United States
RPB	Ragged Point	13.16	-59.43	15.0	Barbados
SCSN03 *	South China Sea (3 N)	3.00	105.00	15.0	N/A
SCSN06 *	South China Sea (6 N)	6.00	107.00	15.0	N/A
SCSN09 *	South China Sea (9 N)	9.00	109.00	15.0	N/A
SCSN12 *	South China Sea (12 N)	12.00	111.00	15.0	N/A
SCSN15 *	South China Sea (15 N)	15.00	113.00	15.0	N/A
SCSN18 *	South China Sea (18 N)	18.00	113.50	15.0	N/A
SCSN21 *	South China Sea (21 N)	21.00	114.00	15.0	N/A
SCT	Beech Island, South Carolina	33.41	-81.83	115.2	United States
SDZ	Shangdianzi	40.65	117.12	293.0	Peoples Republic of China
SEY	Mahe Island	-4.68	55.53	2.0	Seychelles
SGI *	Bird Island, South Georgia	-54.00	-38.05	30.0	United Kingdom
SGP	Southern Great Plains, Oklahoma	36.61	-97.49	314.0	United States
SHM	Shemya Island, Alaska	52.71	174.13	23.0	United States
SIO *	La Jolla, California	32.83	-117.27	14.0	United States
SMO	Tutuila	-14.25	-170.56	42.0	American Samoa
SNP	Shenandoah National Park	38.62	-78.35	1008.0	United States
SPO	South Pole, Antarctica	-89.98	-24.80	2810.0	United States
STC *	Ocean Station C	54.00	-35.00	6.0	United States
STM *	Ocean Station M	66.00	2.00	0.0	Norway
STR	Sutro Tower, San Francisco, California	37.76	-122.45	254.0	United States
SUM	Summit	72.60	-38.42	3209.5	Greenland
SYO	Syowa Station, Antarctica	-69.00	39.58	0.0	Japan
TAP	Tae-ahn Peninsula	36.74	126.13	16.0	Republic of Korea
TDF	Tierra Del Fuego, Ushuaia	-54.85	-68.31	12.0	Argentina
THD	Trinidad Head, California	41.05	-124.15	107.0	United States
TIK	Hydrometeorological Observatory of Tiksi	71.60	128.89	31.0	Russia
UTA	Wendover, Utah	39.90	-113.72	1327.0	United States
UUM	Ulaan Uul	44.45	111.10	1007.0	Mongolia
WBI	West Branch, Iowa	41.72	-91.35	241.7	United States
WGC	Walnut Grove, California	38.27	-121.49	0.0	United States
WIS	WIS Station, Negev Desert	30.86	34.78	477.0	Israel
WKT	Moody, Texas	31.31	-97.33	251.0	United States
WLG	Mt. Waliguan	36.29	100.90	3810.0	Peoples Republic of China
ZEP	Ny-Alesund, Svalbard	78.91	11.89	474.0	Norway and Sweden

'*' Indicates discontinued site.

Carbon Cycle Airborne Flasks SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=2 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
AAO *	Airborne Aerosol Observing, Bondville, Illinois	40.05	-88.37	230.0	United States
ARM *	Atmospheric Radiation Measurement (SGP)	36.80	-97.50	-10000.0	United States
BAO *	Boulder Atmospheric Observatory, Colorado	40.05	-105.00	1584.0	United States
BGI *	Bradgate, Iowa	42.82	-94.41	355.1	United States
BLD *	Boulder, Colorado	39.99	-105.26	1628.0	United States
BNE *	Beaver Crossing, Nebraska	40.80	-97.18	465.9	United States
CAR	Briggsdale, Colorado	40.37	-104.30	1740.0	United States
CMA	Cape May, New Jersey	38.83	-74.32	0.0	United States
CRV	Carbon in Arctic Reservoirs Vulnerability Experiment (CARVE)	64.99	-147.60	611.4	United States
DND	Dahlen, North Dakota	47.50	-99.24	472.4	United States
ESP	Estevan Point, British Columbia	49.38	-126.54	7.0	Canada
ETL	East Trout Lake, Saskatchewan	54.35	-104.98	492.0	Canada
FTL *	Fortaleza	-3.52	-38.28	3.0	Brazil
FWI *	Fairchild, Wisconsin	44.66	-90.96	334.3	United States
HAA *	Molokai Island, Hawaii	21.23	-158.95	3.0	United States
HFM *	Harvard Forest, Massachusetts	42.54	-72.17	340.0	United States
HIL	Homer, Illinois	40.07	-87.91	201.5	United States
INX	INFLUX (Indiana Flux Experiment)	39.58	-86.42	250.0	United States
LEF	Park Falls, Wisconsin	45.95	-90.27	472.0	United States
MVY *	Marthas Vineyard, Massachusetts	41.33	-70.52	0.0	United States
NHA	Worcester, Massachusetts	42.95	-70.63	0.0	United States
OIL *	Oglesby, Illinois	41.28	-88.94	192.6	United States
PFA	Poker Flat, Alaska	65.07	-147.29	210.0	United States
RIA *	Rowley, Iowa	42.40	-91.84	298.7	United States
RTA	Rarotonga	-21.25	-159.83	3.0	Cook Islands
SAN *	Santarem	-2.85	-54.95	78.0	Brazil
SCA	Charleston, South Carolina	32.77	-79.55	0.0	United States
SGP	Southern Great Plains, Oklahoma	36.61	-97.49	314.0	United States
TGC	Sinton, Texas	27.73	-96.86	0.0	United States
THD	Trinidad Head, California	41.05	-124.15	107.0	United States
ULB *	Ulaanbaatar	47.40	106.00	1350.0	Mongolia
VAA *	Cartersville, Georgia	32.91	-79.36	239.9	United States
WBI	West Branch, Iowa	41.72	-91.35	241.7	United States
WGC *	Walnut Grove, California	38.27	-121.49	0.0	United States

'*' Indicates discontinued site.

Carbon Cycle In Situ Tall Tower SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=3 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
AMT	Argyle, Maine	45.03	-68.68	53.0	United States
BAO	Boulder Atmospheric Observatory, Colorado	40.05	-105.00	1584.0	United States
CRV	Carbon in Arctic Reservoirs Vulnerability Experiment (CARVE)	64.99	-147.60	611.4	United States
ITN *	Grifton, North Carolina	35.37	-77.39	8.0	United States
LEF	Park Falls, Wisconsin	45.95	-90.27	472.0	United States
MBO	Mt. Bachelor Observatory	43.98	-121.69	2731.0	United States
SCT	Beech Island, South Carolina	33.41	-81.83	115.2	United States
STR	Sutro Tower, San Francisco, California	37.76	-122.45	254.0	United States
WBI	West Branch, Iowa	41.72	-91.35	241.7	United States
WGC	Walnut Grove, California	38.27	-121.49	0.0	United States
WKT	Moody, Texas	31.31	-97.33	251.0	United States

'*' Indicates discontinued site.

Carbon Cycle In Situ Observatory SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=4 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
BRW	Barrow, Alaska	71.32	-156.61	11.0	United States
MLO	Mauna Loa, Hawaii	19.54	-155.58	3397.0	United States
SMO	Tutuila	-14.25	-170.56	42.0	American Samoa
SPO	South Pole, Antarctica	-89.98	-24.80	2810.0	United States

Carbon Cycle Surface In Situ SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=5 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
CHS	Cherskii	68.51	161.53	30.0	Russia
SNP	Shenandoah National Park	38.62	-78.35	1008.0	United States

Aerosol Surface In-Situ SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=8 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
ALT	Alert, Nunavut	82.45	-62.51	200.0	Canada
APP	Appalachian State	36.20	-81.70	1100.0	United States
ARN	El Arenosillo	37.10	-6.73	41.0	Spain
BND	Bondville, Illinois	40.05	-88.37	230.0	United States
BRW	Barrow, Alaska	71.32	-156.61	11.0	United States
CPR	Cape San Juan	18.38	-65.62	66.0	Puerto Rico, USA
CPT	Cape Point	-34.35	18.49	230.0	South Africa
EGB	Egbert, Ontario	44.23	-79.78	251.0	Canada
ETL	East Trout Lake, Saskatchewan	54.35	-104.98	492.0	Canada
KPS	K'puszta, Keszcemet	46.97	19.55	0.0	Hungary
LLN	Lulin	23.47	120.87	2862.0	Taiwan
MLO	Mauna Loa, Hawaii	19.54	-155.58	3397.0	United States
SGP	Southern Great Plains, Oklahoma	36.61	-97.49	314.0	United States
SMO	Tutuila	-14.25	-170.56	42.0	American Samoa
SPO	South Pole, Antarctica	-89.98	-24.80	2810.0	United States
SUM	Summit	72.60	-38.42	3209.5	Greenland
THD	Trinidad Head, California	41.05	-124.15	107.0	United States
WHI	Whistler	50.06	-122.96	2182.0	Canada
WLG	Mt. Waliguan	36.29	100.90	3810.0	Peoples Republic of China
WSA *	Sable Island, Nova Scotia	43.93	-60.02	5.0	Canada

'*' Indicates discontinued site.

Aerosol Airborne, Light Aircraft SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=16 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
AAO	Airborne Aerosol Observing, Bondville, Illinois	40.05	-88.37	230.0	United States
BNE	Beaver Crossing, Nebraska	40.80	-97.18	465.9	United States
CAR	Briggsdale, Colorado	40.37	-104.30	1740.0	United States
HIL	Homer, Illinois	40.07	-87.91	201.5	United States
MLO	Mauna Loa, Hawaii	19.54	-155.58	3397.0	United States
RIA	Rowley, Iowa	42.40	-91.84	298.7	United States
SGP	Southern Great Plains, Oklahoma	36.61	-97.49	314.0	United States
THD	Trinidad Head, California	41.05	-124.15	107.0	United States
ULB	Ulaanbaatar	47.40	106.00	1350.0	Mongolia

Lidar SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=17 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
BLD	Boulder, Colorado	39.99	-105.26	1628.0	United States
MLO	Mauna Loa, Hawaii	19.54	-155.58	3397.0	United States
SMO	Tutuila	-14.25	-170.56	42.0	American Samoa
SPO	South Pole, Antarctica	-89.98	-24.80	2810.0	United States
THD	Trinidad Head, California	41.05	-124.15	107.0	United States

Aerosol Mobile and Cooperative Platforms SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=23 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country

Radiation In-Situ Observatory SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=9 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
BRW	Barrow, Alaska	71.32	-156.61	11.0	United States
MLO	Mauna Loa, Hawaii	19.54	-155.58	3397.0	United States
SMO	Tutuila	-14.25	-170.56	42.0	American Samoa
SPO	South Pole, Antarctica	-89.98	-24.80	2810.0	United States
SUM	Summit	72.60	-38.42	3209.5	Greenland
THD	Trinidad Head, California	41.05	-124.15	107.0	United States

Baseline Surface Radiation Network SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=10 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
ALT	Alert, Nunavut	82.45	-62.51	200.0	Canada
BAO	Boulder Atmospheric Observatory, Colorado	40.05	-105.00	1584.0	United States
BLD	Boulder, Colorado	39.99	-105.26	1628.0	United States
BMW	Tudor Hill, Bermuda	32.26	-64.88	30.0	United Kingdom
BPH	Prospect Hill, Bermuda	32.30	-64.77	60.0	United Kingdom
EUR	Eureka, Nunavut	79.98	-85.95	0.0	Canada
KWJ	Kwajalein	8.71	167.72	10.0	Marshall Islands
TIK	Hydrometeorological Observatory of Tiksi	71.60	128.89	31.0	Russia

Surface Radiation Budget Monitoring SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=18 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
BND	Bondville, Illinois	40.05	-88.37	230.0	United States
DRA	Desert Rock, Nevada	36.63	-116.02	1007.0	United States
FPK	Fort Peck, Montana	48.31	-105.10	634.0	United States
GWN	Goodwin Creek, Mississippi	34.25	-89.87	98.0	United States
PSU	Penn State, Pennsylvania	40.72	-77.93	376.0	United States
SXF	Sioux Falls, South Dakota	43.73	-96.62	473.0	United States
TBL	Table Mountain	40.13	-105.24	1689.0	United States

Integrated Surface Irradiance Study SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=20 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
ABQ	Albuquerque, New Mexico	35.04	-106.62	1617.0	United States
BIS	Bismarck, North Dakota	46.77	-100.76	511.0	United States
HNX	Hanford, California	36.31	-119.63	73.0	United States
MSN	Madison, Wisconsin	43.13	-89.33	271.0	United States
ORT *	Oak Ridge, Tennesee	35.96	-84.29	334.0	United States
SEA	Seattle, Washington	47.68	-122.25	20.0	United States
SLC	Salt Lake City	40.77	-111.97	1288.0	United States
SVA	Sterling, Virginia	38.98	-77.47	85.0	United States
TLH *	Tallahassee, Florida	30.38	-84.37	18.0	United States

'*' Indicates discontinued site.

Radiation In-Situ Observatory SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=29 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country

NEUBrew UV and Ozone SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=30 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
BND	Bondville, Illinois	40.05	-88.37	230.0	United States
FPK	Fort Peck, Montana	48.31	-105.10	634.0	United States
HST	Houston, Texas	29.72	-95.40	19.0	United States
NWR	Niwot Ridge, Colorado	40.05	-105.59	3523.0	United States
RAL	Raleigh, North Carolina	35.73	-78.68	124.0	United States
TBL	Table Mountain	40.13	-105.24	1689.0	United States

GAW Radiation SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=31 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
BKT	Bukit Kototabang	-0.20	100.32	845.0	Indonesia
TAM	Tamanrasset	22.78	5.52	1377.0	Algeria
USH *	Ushuaia Observatory	-54.82	-68.33	20.0	Argentina
WLG	Mt. Waliguan	36.29	100.90	3810.0	Peoples Republic of China

'*' Indicates discontinued site.

Antarctic UV SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=32 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
MCM	McMurdo Station, Antarctica	-77.83	166.60	11.0	United States
PSA	Palmer Station, Antarctica	-64.92	-64.00	10.0	United States
SPO	South Pole, Antarctica	-89.98	-24.80	2810.0	United States

Meteorology SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=24 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
BLD	Boulder, Colorado	39.99	-105.26	1628.0	United States
BND	Bondville, Illinois	40.05	-88.37	230.0	United States
BRW	Barrow, Alaska	71.32	-156.61	11.0	United States
DRA	Desert Rock, Nevada	36.63	-116.02	1007.0	United States
FPK	Fort Peck, Montana	48.31	-105.10	634.0	United States
GWN	Goodwin Creek, Mississippi	34.25	-89.87	98.0	United States
MLO	Mauna Loa, Hawaii	19.54	-155.58	3397.0	United States
PSU	Penn State, Pennsylvania	40.72	-77.93	376.0	United States
SMO	Tutuila	-14.25	-170.56	42.0	American Samoa
SPO	South Pole, Antarctica	-89.98	-24.80	2810.0	United States
SUM	Summit	72.60	-38.42	3209.5	Greenland
SXF	Sioux Falls, South Dakota	43.73	-96.62	473.0	United States
TBL	Table Mountain	40.13	-105.24	1689.0	United States
THD	Trinidad Head, California	41.05	-124.15	107.0	United States

Black Carbon SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=28 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
SUM	Summit	72.60	-38.42	3209.5	Greenland

Surface Ozone SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=11 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
ARH	Arrival Heights, Antarctica	-77.83	166.20	250.0	New Zealand
BAO	Boulder Atmospheric Observatory, Colorado	40.05	-105.00	1584.0	United States
BMW	Tudor Hill, Bermuda	32.26	-64.88	30.0	United Kingdom
BRW	Barrow, Alaska	71.32	-156.61	11.0	United States
ICE	Storhofdi, Vestmannaeyjar	63.40	-20.29	118.0	Iceland
LDR	Lauder	-45.04	169.68	370.0	New Zealand
MLO	Mauna Loa, Hawaii	19.54	-155.58	3397.0	United States
NWR	Niwot Ridge, Colorado	40.05	-105.59	3523.0	United States
PCO	Pico, Azores	38.47	-28.40	2225.0	Portugal
RPB	Ragged Point	13.16	-59.43	15.0	Barbados
SMO	Tutuila	-14.25	-170.56	42.0	American Samoa
SPO	South Pole, Antarctica	-89.98	-24.80	2810.0	United States
SUM	Summit	72.60	-38.42	3209.5	Greenland
THD	Trinidad Head, California	41.05	-124.15	107.0	United States
TIK	Hydrometeorological Observatory of Tiksi	71.60	128.89	31.0	Russia
WKT	Moody, Texas	31.31	-97.33	251.0	United States
WVR	Weaverville, California	40.73	-122.94	613.0	United States

Dobson Total Ozone SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=12 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
BIS	Bismarck, North Dakota	46.77	-100.76	511.0	United States
BLD	Boulder, Colorado	39.99	-105.26	1628.0	United States
BNA	Nashville, Tennessee	36.25	-86.56	182.0	United States
BRW	Barrow, Alaska	71.32	-156.61	11.0	United States
CBM	Caribou, Maine	46.87	-68.01	191.0	United States
FBK	Fairbanks, Alaska	64.86	-147.85	133.0	United States
HNX	Hanford, California	36.31	-119.63	73.0	United States
HUA *	Huancayo	-12.05	-75.32	0.0	Peru
LDR	Lauder	-45.04	169.68	370.0	New Zealand
MLO	Mauna Loa, Hawaii	19.54	-155.58	3397.0	United States
MPO	Maracompoche	-11.40	-76.32	4500.0	Peru
OHP	Haute Provence	43.92	5.75	580.0	France
PTH	Perth	-31.92	115.97	5.0	Australia
SMO	Tutuila	-14.25	-170.56	42.0	American Samoa
SPO	South Pole, Antarctica	-89.98	-24.80	2810.0	United States
TAL *	Tallahassee, Florida	30.43	-84.33	53.0	United States
WAI	Wallops Island, Virginia	37.86	-75.51	13.0	United States

'*' Indicates discontinued site.

Ozonesonde SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=14 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
BLD	Boulder, Colorado	39.99	-105.26	1628.0	United States
HIH	Hilo, Hawaii	19.72	-155.05	11.0	United States
HVA	Huntsville, Alabama	34.72	-86.64	0.0	United States
LDR	Lauder	-45.04	169.68	370.0	New Zealand
NRI	Narragansett, Rhode Island	41.49	-71.42	21.0	United States
RPB	Ragged Point	13.16	-59.43	15.0	Barbados
SCE	Santa Cristobal	-2.00	-77.50	0.0	Ecuador
SCR	San Jose	9.98	-84.21	899.0	Costa Rica
SMO	Tutuila	-14.25	-170.56	42.0	American Samoa
SPO	South Pole, Antarctica	-89.98	-24.80	2810.0	United States
SUM	Summit	72.60	-38.42	3209.5	Greenland
SUV	Suva	-18.00	178.00	0.0	Fiji
THD	Trinidad Head, California	41.05	-124.15	107.0	United States

Dobson Umkehr Ozone SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=25 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
BLD	Boulder, Colorado	39.99	-105.26	1628.0	United States
FBK	Fairbanks, Alaska	64.86	-147.85	133.0	United States
LDR	Lauder	-45.04	169.68	370.0	New Zealand
MLO	Mauna Loa, Hawaii	19.54	-155.58	3397.0	United States
OHP	Haute Provence	43.92	5.75	580.0	France
PTH	Perth	-31.92	115.97	5.0	Australia

Ozone In Situ Tall Tower SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=26 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
BAO	Boulder Atmospheric Observatory, Colorado	40.05	-105.00	1584.0	United States
WKT	Moody, Texas	31.31	-97.33	251.0	United States

Ozone Airborne SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=27 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
AAO *	Airborne Aerosol Observing, Bondville, Illinois	40.05	-88.37	230.0	United States
BGI *	Bradgate, Iowa	42.82	-94.41	355.1	United States
BNE	Beaver Crossing, Nebraska	40.80	-97.18	465.9	United States
CAR	Briggsdale, Colorado	40.37	-104.30	1740.0	United States
CMA	Cape May, New Jersey	38.83	-74.32	0.0	United States
ESP	Estevan Point, British Columbia	49.38	-126.54	7.0	Canada
FWI *	Fairchild, Wisconsin	44.66	-90.96	334.3	United States
HIL	Homer, Illinois	40.07	-87.91	201.5	United States
NHA	Worcester, Massachusetts	42.95	-70.63	0.0	United States
OIL *	Oglesby, Illinois	41.28	-88.94	192.6	United States
SCA	Charleston, South Carolina	32.77	-79.55	0.0	United States
SGP	Southern Great Plains, Oklahoma	36.61	-97.49	314.0	United States
THD	Trinidad Head, California	41.05	-124.15	107.0	United States
ULB *	Ulaanbaatar	47.40	106.00	1350.0	Mongolia
WBI	West Branch, Iowa	41.72	-91.35	241.7	United States

'*' Indicates discontinued site.

Trajectories SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=15 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
ALT	Alert, Nunavut	82.45	-62.51	200.0	Canada
BLD	Boulder, Colorado	39.99	-105.26	1628.0	United States
BMW	Tudor Hill, Bermuda	32.26	-64.88	30.0	United Kingdom
BND	Bondville, Illinois	40.05	-88.37	230.0	United States
BRW	Barrow, Alaska	71.32	-156.61	11.0	United States
CGO	Cape Grim, Tasmania	-40.68	144.69	94.0	Australia
CPT	Cape Point	-34.35	18.49	230.0	South Africa
KUM	Cape Kumukahi, Hawaii	19.52	-154.82	3.0	United States
MLO	Mauna Loa, Hawaii	19.54	-155.58	3397.0	United States
NWR	Niwot Ridge, Colorado	40.05	-105.59	3523.0	United States
SGP	Southern Great Plains, Oklahoma	36.61	-97.49	314.0	United States
SMO	Tutuila	-14.25	-170.56	42.0	American Samoa
SPO	South Pole, Antarctica	-89.98	-24.80	2810.0	United States
SUM	Summit	72.60	-38.42	3209.5	Greenland
TAP	Tae-ahn Peninsula	36.74	126.13	16.0	Republic of Korea
THD	Trinidad Head, California	41.05	-124.15	107.0	United States
WLG	Mt. Waliguan	36.29	100.90	3810.0	Peoples Republic of China

HATS Flask Sampling SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=6 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
ALT	Alert, Nunavut	82.45	-62.51	200.0	Canada
BRW	Barrow, Alaska	71.32	-156.61	11.0	United States
CGO	Cape Grim, Tasmania	-40.68	144.69	94.0	Australia
HFM	Harvard Forest, Massachusetts	42.54	-72.17	340.0	United States
KUM	Cape Kumukahi, Hawaii	19.52	-154.82	3.0	United States
LEF	Park Falls, Wisconsin	45.95	-90.27	472.0	United States
MHD	Mace Head, County Galway	53.33	-9.90	5.0	Ireland
MLO	Mauna Loa, Hawaii	19.54	-155.58	3397.0	United States
NWR	Niwot Ridge, Colorado	40.05	-105.59	3523.0	United States
PSA	Palmer Station, Antarctica	-64.92	-64.00	10.0	United States
SMO	Tutuila	-14.25	-170.56	42.0	American Samoa
SPO	South Pole, Antarctica	-89.98	-24.80	2810.0	United States
SUM	Summit	72.60	-38.42	3209.5	Greenland
TDF	Tierra Del Fuego, Ushuaia	-54.85	-68.31	12.0	Argentina
THD	Trinidad Head, California	41.05	-124.15	107.0	United States

HATS In Situ Observatory SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=7 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
BRW	Barrow, Alaska	71.32	-156.61	11.0	United States
HFM	Harvard Forest, Massachusetts	42.54	-72.17	340.0	United States
MLO	Mauna Loa, Hawaii	19.54	-155.58	3397.0	United States
NWR	Niwot Ridge, Colorado	40.05	-105.59	3523.0	United States
SMO	Tutuila	-14.25	-170.56	42.0	American Samoa
SPO	South Pole, Antarctica	-89.98	-24.80	2810.0	United States
SUM	Summit	72.60	-38.42	3209.5	Greenland
TDF	Tierra Del Fuego, Ushuaia	-54.85	-68.31	12.0	Argentina

Trace Gases Airborne, Large Balloons and Aircraft SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=21 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
FBK	Fairbanks, Alaska	64.86	-147.85	133.0	United States

Trace Gases Unmanned Aircraft Systems (UAS) SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=22 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country

Water Vapor Profiles SELECT DISTINCT site.num,code,name,country,lat,lon,elev,status_num FROM site,site_project WHERE site.num=site_project.site_num AND project_num=13 AND site_project.status_num!=4 AND site_project.status_num!=2 AND lat>-90 AND lon>-900 ORDER BY code

Code	Name	Latitude	Longitude	Elevation (Meters)	Country
BLD	Boulder, Colorado	39.99	-105.26	1628.0	United States
HIH	Hilo, Hawaii	19.72	-155.05	11.0	United States
LDR	Lauder	-45.04	169.68	370.0	New Zealand