/* Copyright 2017 Amazon.com Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. */ -------------------------------------------------------- -- File created - Monday-August-29-2016 -------------------------------------------------------- REM INSERTING into NFL_STADIUM_DATA SET DEFINE OFF; Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Los Angeles Memorial Coliseum',93607,'Los Angeles, California','Natural grass','Open','Los Angeles Rams','1923',32); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('MetLife Stadium',82500,'East Rutherford, New Jersey','UBU Speed Series S5-M Synthetic Turf','Open','New York Giants','2010',33); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('MetLife Stadium',82500,'East Rutherford, New Jersey','UBU Speed Series S5-M Synthetic Turf','Open','New York Jets','2010',34); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('FedExField',82000,'Landover, Maryland','Latitude 36 Bermuda Grass','Open','Washington Redskins','1997',35); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Lambeau Field',81435,'Green Bay, Wisconsin','Hybrid Grass-Synthetic','Open','Green Bay Packers','1957',36); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('AT&T Stadium',80000,'Arlington, Texas','Matrix RealGrass artificial turf','Retractable','Dallas Cowboys','2009',37); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Arrowhead Stadium',76416,'Kansas City, Missouri','Latitude 36 Bermuda Grass','Open','Kansas City Chiefs','1972',38); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Sports Authority Field at Mile High',76125,'Denver, Colorado','Kentucky Bluegrass','Open','Denver Broncos','2001',39); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Bank of America Stadium',75419,'Charlotte, North Carolina','Voyager Bermuda Grass','Open','Carolina Panthers','1996',40); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Mercedes-Benz Superdome',73000,'New Orleans, Louisiana','UBU Turf (artificial)','Fixed','New Orleans Saints','1975',41); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('NRG Stadium',72220,'Houston, Texas','AstroTurf GameDay Grass 3D','Retractable','Houston Texans','2002',42); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('New Era Field',71870,'Orchard Park, New York','A-Turf Titan 50 (artificial)','Open','Buffalo Bills','1973',43); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Georgia Dome',71250,'Atlanta, Georgia','FieldTurf Classic HD','Fixed','Atlanta Falcons','1992',44); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('M&T Bank Stadium',71008,'Baltimore, Maryland','Latitude 36 Bermuda Grass','Open','Baltimore Ravens','1998',45); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Qualcomm Stadium',70561,'San Diego, California','Bandera Bermuda Grass','Open','San Diego Chargers','1967',46); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Lincoln Financial Field',69596,'Philadelphia, Pennsylvania','Desso GrassMaster','Open','Philadelphia Eagles','2003',47); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Nissan Stadium',69143,'Nashville, Tennessee','TifSport Bermuda Grass','Open','Tennessee Titans','1999',48); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Levi''s Stadium',68500,'Santa Clara, California','Tifway II Bermuda Grass / Perennial Ryegrass mixture','Open','San Francisco 49ers','2014',49); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Heinz Field',68400,'Pittsburgh, Pennsylvania','Kentucky Bluegrass','Open','Pittsburgh Steelers','2001',50); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('CenturyLink Field',68000,'Seattle, Washington','FieldTurf Revolution','Open','Seattle Seahawks','2002',51); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('FirstEnergy Stadium',67431,'Cleveland, Ohio','Kentucky Bluegrass','Open','Cleveland Browns','1999',52); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('EverBank Field',67246,'Jacksonville, Florida','Tifway 419 Bermuda Grass','Open','Jacksonville Jaguars','1995',53); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Lucas Oil Stadium',67000,'Indianapolis, Indiana','FieldTurf Classic HD','Retractable','Indianapolis Colts','2008',54); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Gillette Stadium',66829,'Foxborough, Massachusetts','FieldTurf Revolution','Open','New England Patriots','2002',55); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('U.S. Bank Stadium',66200,'Minneapolis, Minnesota','UBU Speed Series S5-M Synthetic Turf','Fixed','Minnesota Vikings','2016',56); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Raymond James Stadium',65890,'Tampa, Florida','Tifway 419 Bermuda Grass','Open','Tampa Bay Buccaneers','1998',57); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Paul Brown Stadium',65515,'Cincinnati, Ohio','UBU Speed Series S5-M Synthetic Turf','Open','Cincinnati Bengals','2000',58); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Hard Rock Stadium',65326,'Miami Gardens, Florida','Platinum TE Paspalum','Open','Miami Dolphins','1987',59); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Ford Field',65000,'Detroit, Michigan','FieldTurf Classic HD','Fixed','Detroit Lions','2002',60); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('University of Phoenix Stadium',63400,'Glendale, Arizona','Tifway 419 Bermuda Grass','Retractable','Arizona Cardinals','2006',61); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Soldier Field',61500,'Chicago, Illinois','Kentucky Bluegrass','Open','Chicago Bears','1924',62); Insert into NFL_STADIUM_DATA (STADIUM,SEATING_CAPACITY,LOCATION,SURFACE,ROOF,TEAM,OPENED,SPORT_LOCATION_ID) values ('Oakland Alameda Coliseum',56063,'Oakland, California','Tifway II Bermuda Grass','Open','Oakland Raiders','1966',63);