AMF-Perl
view release on metacpan or search on metacpan
doc/examples/sql/park.sql view on Meta::CPAN
-- MySQL dump 8.22
--
-- Host: localhost Database: cfexamples
---------------------------------------------------------
-- Server version 3.23.55-nt
--
-- Table structure for table 'tblparks'
--
CREATE TABLE tblparks (
PARKNAME text,
ADDRESS1 text,
ADDRESS2 text,
ADDRESS3 text,
CITY text,
STATE text,
ZIPCODE text,
COMPHONE text,
REGION text,
SUPTMGR text,
OFFHRS text,
DATEESTB text,
PARKTYPE text
) TYPE=MyISAM;
--
-- Dumping data for table 'tblparks'
--
INSERT INTO tblparks VALUES ('ARAHAM LINCOLN BIRTHPLACE NHS','2995 LINCOLN FARM ROAD','','','HODGENVILLE','KY','42748','502-358-3874','Southeast Region','Link, Carolyn E.','8:00 AM TO 4:45 PM','07/17/1916','National Historical Site');
INSERT INTO tblparks VALUES ('ADAMS NATIONAL HISTORIC SITE','P.O. BOX 531, 135 ADAMS STREET','','','QUINCY','MA','02269-0531','617-773-1177','NORTH ATLANTIC REGION','Peak, Marianne Potts','9:00 AM TO 5:00 PM','12/09/1946','NATIONAL HISTORICAL SITE');...
INSERT INTO tblparks VALUES ('AGATE FOSSIL BEDS NATIONAL MONUMENT','C/O SCOTTS BLUFF NATIONAL MONUMENT','P.O. BOX 27','','GERING','NE','69341-0027','308-668-2211','MIDWEST REGION','LARRY D. REED','8:00 AM TO 5:00 PM','09/26/1970','NATIONAL MONUMENT')...
INSERT INTO tblparks VALUES ('ALAGNAK WILD RIVER','C/O KATMAI NATIONAL PARK','P.O. BOX 7','','KING SALMON','AK','99613','907-246-3305','Alaska Region','BILL PIERCE','','12/02/1980','National (Wild/Senic River (Way)');
INSERT INTO tblparks VALUES ('ALASKA PUBLIC LANDS INFO CTR - ANCHORAGE','605 W. 4TH AVENUE, SUITE 105','','','ANCHORAGE','AK','99501','907-271-2737','Alaska Region','Morris, John, Acting','','08/01/1987','Miscellaneous');
INSERT INTO tblparks VALUES ('ALASKA PUBLIC LANDS INFO CTR - FAIRBANKS','250 CUSHMAN ST., SUITE 1A','','','FAIRBANKS','AK','99701','907-456-0527','Alaska Region','ROSSINI, ELIZABETH','10:00 AM TO 7:00 PM','10/13/1982','Miscellaneous');
INSERT INTO tblparks VALUES ('ALASKA REGIONAL OFFICE','NATIONAL PARK SERVICE','2525 GAMBELL STREET, ROOM 107','','ANCHORAGE','AK','99503','907-257-2690','Alaska Region','Robert D. Barber','7:30 AM TO 4:30 PM','12/03/1980','Regional Office');
INSERT INTO tblparks VALUES ('ALIBATES FLINT QUARRIES NM','C/O LAKE MEREDITH RECREATION AREA','P.O. BOX 1438','','FRITCH','TX','79036','806-857-3151','SOUTHWEST REGION','Mc Crary, Patrick C.','8:30 AM TO 5:00 PM',' / /19','NATIONAL MONUMENT');
INSERT INTO tblparks VALUES ('ALLEGHENY PORTAGE RAILROAD NHS','P.O. BOX 189','','','CRESSON','PA','16630','814-886-6100','MID-ATLANTIC REGION','Nigh, Peter K.','8:30 AM TO 5:00 PM','06/30/1969','NATIONAL HISTORICAL SITE');
INSERT INTO tblparks VALUES ('AMERICAN INDUSTRIAL HERITAGE PROJECT','P.O. BOX 565','','','HOLIDAYSBURG','PA','16648','814-696-9380','MID-ATLANTIC REGION','Cooley, Randy','',' / /19','MISCELLANEOUS');
INSERT INTO tblparks VALUES ('AMERICAN MEMORIAL PARK','P.O. BOX 5198','','','SAIPAN','CM','96950','670-234-7207','Western Region','EDWARD E. WOOD JR.','7:30 AM TO 4:30 PM',' / /19','National Memorial');
INSERT INTO tblparks VALUES ('AMISTAD NATIONAL RECREATION AREA','HCR 3, BOX 5J','','','DEL RIO','TX','78840-9350','210-775-7491','Southwest Region','LAITNER, WILLIAM G.','8:00 AM TO 5:00 PM','11/11/1965','Recreation Area');
INSERT INTO tblparks VALUES ('ANIAKCHAK NATIONAL MONUMENT','C/O KATMAI NATL PARK & PRESERVE','P.O. BOX 7','','KING SALMON','AK','99614','907-246-3305','ALASKA REGION','BILL PIERCE','8:00 AM TO 5:00 PM','12/02/1980','NATIONAL MONUMENT');
INSERT INTO tblparks VALUES ('ANTIETAM NATIONAL BATTLEFIELD','P.O. BOX 158','','','SHARPSBURG','MD','21782-0158','301-432-5124','National Capital Region','SUSAN MOORE','8:30 AM TO 5:00 PM','08/30/1990','National Battlefield');
INSERT INTO tblparks VALUES ('ANTIETAM NATIONAL CEMETERY','C/O ANTIETAM NATL BATTLEFIELD','BOX 158','','SHARPSBURG','MD','21782-0158','301-432-5124','National Capital Region','SUSAN MOORE','8:00 AM TO 5:00 PM','08-30-1890','National Cemetary');
INSERT INTO tblparks VALUES ('APOSTLE ISLANDS NATIONAL LAKESHORE','ROUTE 1, BOX 4','','','BAYFIELD','WI','54814','715-779-3397','MIDWEST REGION','BANTA, ALFORD J.','8:00 AM TO 4:30 PM','09/26/1970','NATIONAL LAKESHORE');
INSERT INTO tblparks VALUES ('APPALACHIAN NATIONAL SCENIC TRAIL','APPALACHIAN TRAIL PROJECT OFFICE','','','HARPERS FERRY','WV','25425','304-535-6278','WASHINGTON OFFICE','BYRNE, JOHN F.','8:00 AM TO 5:00 PM','10/02/1968','NATIONAL TRAIL');
INSERT INTO tblparks VALUES ('APPALACHIAN NATL SCENIC TRAIL','A. T. LAND ACQUISITION OFFICE','P.O. BOX 908','1314 EDWIN MILLER BLVD.','MARTINSBURG','WV','25401','304-263-4943','WASHINGTON OFFICE','KING, DONALD T.','7:45 AM TO 4:15 PM',' / /19','LAN...
INSERT INTO tblparks VALUES ('APPOMATTOX COURT HOUSE NHP','P.O. BOX 218','','','APPOMATTOX','VA','24522','804-352-8987','MID-ATLANTIC REGION','Montgomery, Jon B.','8:30 AM TO 5:00 PM','04/10/1940',NULL);
INSERT INTO tblparks VALUES ('ARCHES NATIONAL PARK','P.O. BOX 907','','','MOAB','UT','84532','801-259-8161','ROCKY MOUNTAIN REGION','Poe, Noel','8:00 AM TO 4:30 PM','04/12/1929','NATIONAL PARK');
INSERT INTO tblparks VALUES ('ARLINGTON HOUSE, THE ROBERT E. LEE MEM','C/O GEORGE WASHINGTON MEMORIAL PARKWAY','TURKEY RUN PARK','','MCLEAN','VA','22101','703-557-3154','National Capital Region','VACANT','9:00 AM TO 5:00 PM','06/29/1955','National Me...
INSERT INTO tblparks VALUES ('ASSATEAGUE ISLAND NATIONAL SEASHORE','ROUTE 611','7206 NATIONAL SEASHORE LANE','','BERLIN','MD','21811','410-641-1441','MID-ATLANTIC REGION','KOENINGS, MARC A.','8:00 AM TO 5:00 PM','08/09/1985','NATIONAL SEASHORE');
INSERT INTO tblparks VALUES ('BADLANDS NATIONAL PARK','P.O. BOX 6','','','INTERIOR','SD','57750','605-433-5361','Rocky Mountain Region','Mortenson, Irvin L.','','01/25/1939','National Park');
INSERT INTO tblparks VALUES ('BANDELIER NATIONAL MONUMENT','HCRI, BOX 1, SUITE 15','','','LOS ALAMOS','NM','87544','505-672-3861','SOUTHWEST REGION','WEAVER, ROY W.','8:00 AM TO 5:00 PM','02/25/1932','NATIONAL MONUMENT');
INSERT INTO tblparks VALUES ('BATTLEGROUND NATIONAL CEMETERY','C/O SUPT, NATL CAP PK-EAST','5210 INDIAN HEAD HGWY','','OXON HILL','MD','20021','301-472-9227','NATIONAL CAPITAL REGION','None','',' / /19','NATIONAL CEMETERY');
INSERT INTO tblparks VALUES ('BENJAMIN FRANKLIN NATIONAL MEMORIAL','C/O THE FRANKLIN INSTITUTE','20TH ST AND BENJAMIN FRANKLIN PKWY','','PHILADELPHIA','PA','19103','215-448-1000','MID-ATLANTIC REGION','None','',' / /19','NATIONAL MEMORIAL');
INSERT INTO tblparks VALUES ('BENT\'S OLD FORT NATIONAL HISTORIC SITE','35110 HIGHWAY 194 EAST','','','LA JUNTA','CO','81050-9523','719-384-2596','ROCKY MOUNTAIN REGION','Hill, Donald C.','8:00 AM TO 4:30 PM','03/15/1963','NATIONAL HISTORICAL SITE');...
INSERT INTO tblparks VALUES ('BIG BEND NATIONAL PARK','P.O BOX 129','','','BIG BEND NATIONAL PARK','TX','79834-129','915-477-2251','Southwest Region','JOSE CISNEROS','8:00 AM TO 5:00 PM','06/12/1944','National Park');
INSERT INTO tblparks VALUES ('BIG HOLE NATIONAL BATTLEFIELD','P.O. BOX 237','WISDOM, MT 59761-0237','','DEER LODGE','MT','59761-0237','406-689-3155','Pacific Northwest Region','BUCHEL, SUSAN','8:00 AM TO 5:00 PM','06/23/1910','National Battlefield')...
INSERT INTO tblparks VALUES ('BIG THICKET NATIONAL PRESERVE','3785 MILAM','','','BEAUMONT','TX','77701','409-839-2689','Southwest Region','VACANT','8:00 AM TO 4:30 PM',' / /19','National Preserve');
INSERT INTO tblparks VALUES ('BIGHORN CANYON NATIONAL RECREATION AREA','P.O. BOX 7458','','','FORT SMITH','MT','59035-7458','406-666-2412','Rocky Mountain Region','COOK, DARRELL J.','8:00 AM TO 5:00 PM','10/15/1966','National Recreation Area');
INSERT INTO tblparks VALUES ('BLACK CANYON OF THE GUNNISON NM','2233 EAST MAIN STREET','','','MONTROSE','CO','81401','303-249-7036','Rocky Mountain Region','Welch, John E.','8:00 AM TO 4:30 PM','03/03/1933','National Monument');
INSERT INTO tblparks VALUES ('BLACKSTONE RIVER VALLEY','NATIONAL HERITAGE CORRIDOR','15 MENDON STREET','P.O. BOX 730','UXBRIDGE','MA','01569','508-278-9400','NORTH ATLANTIC REGION','PEPPER, JAMES R.','8:00 AM TO 5:00 PM',' / /19','MISCELLANEOUS');
INSERT INTO tblparks VALUES ('BLUESTONE NATIONAL SCENIC RIVER','C/O NEW RIVER GORGE NATIONAL RIVER','P.O. BOX 246','','GLEN JEAN','WV','25846-0246','304-465-0508','MID-ATLANTIC REGION','KENNEDY, JOE L.','8AM TO 4:30PM','10/26/1988',NULL);
INSERT INTO tblparks VALUES ('BOOKER T. WASHINGTON NATIONAL MONUMENT','12130 Booker T. Washington Highway','','','HARDY','VA','24101','703-721-2094','Mid-Atlantic Region','HARRIETT, REBECCA','8:30 AM TO 5:00 PM','04/02/1956','National Monument');
INSERT INTO tblparks VALUES ('BOSTON AFRICAN-AMERICAN NHS','46 JOY STREET','BEACON HILL','','BOSTON','MA','02144','617-742-5415','North Atlantic Region','Heidelberg, Kenneth A.','8:00 AM TO 5:00 PM',' / /19',NULL);
INSERT INTO tblparks VALUES ('BOSTON NATIONAL HISTORICAL PARK','CHARLESTOWN NAVY YARD','','','BOSTON','MA','02129','617-242-5644','NORTH ATLANTIC REGION','Burchill, John J.','8:00 AM TO 5:00 PM',' / /19','NATIONAL HISTORICAL PARK');
INSERT INTO tblparks VALUES ('BRYCE CANYON NATIONAL PARK','','','','BRYCE CANYON','UT','84717','801-834-5322','ROCKY MOUNTAIN REGION','Fagergren, Fred J.','8:00 AM TO 5:00 PM','02/25/1928','NATIONAL PARK');
INSERT INTO tblparks VALUES ('BUFFALO NATIONAL RIVER','P.O. BOX 1173','','','HARRISON','AR','72602-1173','501-741-5443','SOUTHWEST REGION','LINAHAN, JOHN D.','8:00 AM TO 5:00 PM','03/01/1972','NATIONAL (WILD/SCENIC) RIVER (WAY)');
INSERT INTO tblparks VALUES ('BUFFALO NATIONAL RIVER LAND ACQ OFFICE','P.O. BOX 1073','','','HARRISON','AR','72602','501-741-7637','SOUTHWEST REGION','Adams, Andrew A.','8:00 AM TO 4:30 PM',' / /19','LAND RESOURCES OFFICE');
INSERT INTO tblparks VALUES ('CABRILLO NATIONAL MONUMENT','P.O. BOX 6670','','','SAN DIEGO','CA','92166-0670','619-557-5450','WESTERN REGION','DI MATTIO, TERRY M.','8:30 AM TO 5:00 PM','10/04/1913','NATIONAL MONUMENT');
INSERT INTO tblparks VALUES ('CANAVERAL NATIONAL SEASHORE','308 JULIA STREET','','','TITUSVILLE','FL','32796-3521','407-267-1110','SOUTHEAST REGION','SIMPSON, WENDELL','7:30 AM TO 4:30 PM','01/03/1975','NATIONAL SEASHORE');
INSERT INTO tblparks VALUES ('CANYON DE CHELLY NATIONAL MONUMENT','P.O. BOX 588','','','CHINLE','AZ','86503','520-674-5500','Southwest Region','YAZHE, HERBERT T.','8:00 AM TO 5:00 PM','02/14/1931','National Monument');
INSERT INTO tblparks VALUES ('CANYONLANDS NATIONAL PARK','125 WEST 200 SOUTH','','','MOAB','UT','84532-2995','801-259-3911','ROCKY MOUNTAIN REGION','DABNEY, WALTER','8:00 AM TO 4:30 PM','09/12/1964','NATIONAL PARK');
INSERT INTO tblparks VALUES ('CAPE COD NATIONAL SEASHORE','','','','SOUTH WELLFLEET','MA','02663','508-349-3785','North Atlantic Region','Maria Burks','8:00 AM TO 4:30 PM','05/30/1966','National Seashore');
INSERT INTO tblparks VALUES ('CAPE KRUSENSTERN NATIONAL MONUMENT','P.O. BOX 1029','','','KOTZEBUE','AK','99752','907-442-3890','Alaska Region','BOB GERHARD','8:00 AM TO 4:30 PM','12/01/1978','National Monument');
INSERT INTO tblparks VALUES ('CAPE LOOKOUT NATIONAL SEASHORE','131 CHARLES STREETT','','28531','HARKERS ISLAND','NC','28531','919-728-2250','SOUTHEAST REGION','HARRIS, WILLIAM A.','8:00 AM TO 4:30 PM',' / /19','NATIONAL SEASHORE');
INSERT INTO tblparks VALUES ('CAPITOL REEF NATIONAL PARK','HC 70, BOX 15','','','TORREY','UT','84775-9602','801-425-3791','ROCKY MOUNTAIN REGION','LUNDY, CHARLES','8:00 AM TO 4:30 PM','08/02/1937','NATIONAL PARK');
INSERT INTO tblparks VALUES ('CAPULIN VOLCANO NATIONAL MONUMENT','P.O. BOX 94','','','CAPULIN','NM','88414','505-278-2201','SOUTHWEST REGION','Karraker, Mary','8:00 AM TO 5:00 PM','08/09/1916','NATIONAL MONUMENT');
INSERT INTO tblparks VALUES ('CARLSBAD CAVERNS NATIONAL PARK','3225 NATIONAL PARK HIGHWAY','','','CARLSBAD','NM','88220','505-785-2232','Southwest Region','FRANK J. DECKERT','8:00 AM TO 4:30 PM','10/25/1923','National Park');
INSERT INTO tblparks VALUES ('CASA GRANDE NATIONAL MONUMENT','1100 RUINS DRIVE','','','COOLIDGE','AZ','85228','520-723-3172','Western Region','Spencer, Donald','7:00 AM TO 6:00 PM','06-22-1892','National Monument');
INSERT INTO tblparks VALUES ('CASTLE CLINTON NATIONAL MONUMENT','C/O MANHATTAN SITES','26 WALL STREET','','NEW YORK','NY','10005','212-344-7220','NORTH ATLANTIC REGION','Brown, Daniel','8:15 AM TO 5:00 PM',' / /19','NATIONAL MONUMENT');
INSERT INTO tblparks VALUES ('CATOCTIN MOUNTAIN PARK','6602 FOXVILLE, ROAD','','','THURMONT','MD','21788-1598','301-663-9343','National Capital Region','Young, J. D.','8:00 AM TO 4:30 PM','11/14/1936','Recreation Area');
INSERT INTO tblparks VALUES ('CEDAR BREAKS NATIONAL MONUMENT','82 NORTH 100 EAST','','','CEDAR CITY','UT','84720-0749','801-586-9451','ROCKY MOUNTAIN REGION','HENRY, THOMAS E.','8:00 AM TO 4:30 PM','08/22/1933','NATIONAL MONUMENT');
INSERT INTO tblparks VALUES ('CHANNEL ISLANDS NATIONAL PARK','1901 SPINNAKER DRIVE','','','VENTURA','CA','93001','805-658-5700','WESTERN REGION','SHAVER, C. MACK','8:30 AM TO 5:00 PM','04/26/1938','NATIONAL PARK');
INSERT INTO tblparks VALUES ('CHARLES PINCKNEY NATIONAL HISTORIC SITE','C/O FORT SUMTER NATIONAL MONUMENT','1214 MIDDLE STREET','','SULLIVAN\'S ISLAND','SC','29482','','SOUTHEAST REGION','Tucker, John N.','','09/08/1988','NATIONAL HISTORICAL SITE');
INSERT INTO tblparks VALUES ('CHATTAHOOCHEE RIVER NATL REC AREA','1978 ISLAND FORD PARKWAY','','','DUNWOODY','GA','30350','404-399-8070','Southeast Region','Madry, Marvin','7:30 AM TO 4:30 PM','08/15/1978','National Recreation Area');
( run in 0.330 second using v1.01-cache-2.11-cpan-5735350b133 )