
CREATE TABLE nwcolleges (
    name text,
    latitude double precision,
    longitude double precision
);

INSERT INTO nwcolleges VALUES
('Willamette University', 44.93521826899255, -123.03075301629585),
('Linfield University', 45.200665040160594, -123.1994223316798),
('Pacific University', 45.52330260979122, -123.11063637039692),
('Lewis and Clark College', 45.44878623602386, -122.67070905318472),
('University of Puget Sound', 47.261829546233265, -122.48121889078884),
('Pacific Lutheran University', 47.145163873058344, -122.44384929186788),
('Whitman College', 46.07084139041181, -118.32970751683007),
('Whitworth College', 47.75479341732155, -117.41799104966499),
('George Fox University', 45.30342693791853, -122.96688830259366);
