AMET Notes - Revision history

Zac at 18:50, 21 October 2021

2021-10-21T18:50:02Z

2020-08-18T14:27:46Z

‎Update the MET database to include state IDs, NCLD 2011 landcover categories, and shoreline distance

2020-08-18T14:27:06Z

2020-08-18T14:26:27Z

2020-08-18T14:21:00Z

2020-08-18T14:15:39Z

2020-08-18T14:12:50Z

2020-08-18T14:10:06Z

2020-08-17T21:27:52Z

‎Update the MET database to include state IDs, NCLD 2011 landcover categories, and shoreline distance

2020-08-17T21:27:31Z

‎Update the MET database to include state IDs, NCLD 2011 landcover categories, and shoreline distance

@@ Line 1: / Line 1: @@
-== Update the MET database to include state IDs, NCLD 2011 landcover categories, and shoreline distance ==
+= Update the MET database to include state IDs, NCLD 2011 landcover categories, and shoreline distance =
 Steps:
 # Download a METAR stations file and convert it to a CSV with three columns: Line number (id), 2-digit state code, METAR 4-digit station ID, and use a GIS to add in distance from shoreline and NLCD 2011 codes ([https://drive.google.com/file/d/1WLqQ7WvAAyD2kIAQ-HUNrxXPJsbJjAwW/view?usp=sharing Download CSV file prepared by LADCO])
@@ Line 43: / Line 43: @@
 Why the NLCD2011 codes? Why not? In case we want to evaluate performance at monitors with different land cover classifications (e.g., urban vs agricultural vs forest); [https://www.mrlc.gov/data/legends/national-land-cover-database-2011-nlcd2011-legend link to the NLCD 2011 legend]

@@ Line 34: / Line 34: @@
   | KSAN    | METAR      | 32.7300 | -117.1700 | NULL | NULL |    9.00 |    NULL | SAN_DIEGO/LINDBERG | CA    | NULL    | 24     | 1.5       |
   +---------+------------+---------+-----------+------+------+---------+---------+--------------------+-------+---------+--------+-----------+
 rows in set (0.00 sec)
 {| class="wikitable"

@@ Line 3: / Line 3: @@
 # Download a METAR stations file and convert it to a CSV with three columns: Line number (id), 2-digit state code, METAR 4-digit station ID, and use a GIS to add in distance from shoreline and NLCD 2011 codes ([https://drive.google.com/file/d/1WLqQ7WvAAyD2kIAQ-HUNrxXPJsbJjAwW/view?usp=sharing Download CSV file prepared by LADCO])
 # Create a new table in the AMET database called "states"
-# Load the updated MADIS stations file into the new states table
+# Load the updated METAR stations file into the new states table
-# Add columns to the existing stations table for the NLCD and Shoreline data
+# Add columns to the existing AMET stations table for the NLCD and Shoreline data
 # Join the states table to the stations table on the station ID field to add in the new fields

@@ Line 3: / Line 3: @@
 # Download a METAR stations file and convert it to a CSV with three columns: Line number (id), 2-digit state code, METAR 4-digit station ID, and use a GIS to add in distance from shoreline and NLCD 2011 codes ([https://drive.google.com/file/d/1WLqQ7WvAAyD2kIAQ-HUNrxXPJsbJjAwW/view?usp=sharing Download CSV file prepared by LADCO])
 # Create a new table in the AMET database called "states"
-# Load the process stations.csv file into the states table
+# Load the updated MADIS stations file into the new states table
 # Add columns to the existing stations table for the NLCD and Shoreline data
 # Join the states table to the stations table on the station ID field to add in the new fields

@@ Line 38: / Line 38: @@
 {| class="wikitable"
 |-
-| [[File:MADIS States.png|thumb|left|Map of MADIS monitors with state tags]] || [[File:MADIS Shoreline.png|thumb|left|Map of MADIS inland (green) vs shoreline monitors]] || [[File:MADIS Shoreline SLakeMI.png|thumb|left|Southern Lake MI shoreline MADIS monitors ]]
+| [[File:MADIS States.png|thumb|left|Map of MADIS monitors with state tags]] || [[File:MADIS Shoreline.png|thumb|left|Map of MADIS inland (green) vs shoreline monitors]] || [[File:MADIS Shoreline SLakeMI.png|thumb|left|Southern Lake MI shoreline MADIS monitors ]] ||
-|}
+[[File:MADIS NLCD11.png|thumb|left|MADIS sites with NLCD2011 landcover categories]]

← Older revision		Revision as of 14:12, 18 August 2020
Line 36:		Line 36:
	12 rows in set (0.00 sec)		12 rows in set (0.00 sec)

−	[[File:MADIS States.png\|thumb\|Map of MADIS monitors with state tags]]	+	[[File:MADIS States.png\|thumb\|left\|Map of MADIS monitors with state tags]]
		+
		+	[[File:MADIS Shoreline.png\|thumb\|left\|Map of MADIS inland (green) vs shoreline monitors]]