MaptimeSF part 1: creating databases

CREATE TABLE events (
    event_name	varchar(64) NOT NULL,
    venue_name	varchar(64),
    street_addr	varchar(64),
    city		varchar(64),
    state		char(2) DEFAULT 'CA',
    url			varchar(64),
    day			varchar(12),
    time		time,
    lat			numeric(10,7),
    lng			numeric(10,7)
);


INSERT INTO events (event_name, venue_name, street_addr, city, url, day, time) VALUES ('MaptimeSF', 'Stamen', '2017 Mission Street', 'San Francisco', 'http://www.meetup.com/Maptime-SF/', 'Weds', '6:30 PM');
INSERT INTO events (event_name, venue_name, street_addr, city, url, day, time) VALUES ('GeoBreakfast', 'Pork Store Cafe', '3122 16th St', 'San Francisco', NULL, 'Fri', '8:30 AM');
INSERT INTO events (event_name, venue_name, street_addr, city, url, day, time) VALUES ('GeoLunch', 'Geospatial Innovation Facility', '103 Mulford Hall, UC Berkeley', 'Berkeley', 'http://gif.berkeley.edu/about/geolunch.html', 'Thurs', '13:10');
INSERT INTO events (event_name, venue_name, street_addr, city, url, day, time) VALUES ('GeoBeers', 'City Beer Store', '1168 Folsom St, Suite 101', 'San Francisco', '#geoBeers', 'varies', NULL);
INSERT INTO events (event_name, venue_name, street_addr, city, url, day, time) VALUES ('BAAMA Educational Meetings', 'Metropolitan Transit Commission', '101 Eighth Street', 'Oakland', 'http://baama.org/meetings', 'Thurs', '8:30 AM');


SELECT * FROM events;
SELECT event_name, url FROM events WHERE day='Thurs';

SELECT '"' || street_addr || ', ' || city || ', ' || state || '"' || ', ' FROM events;

["2017 Mission Street, San Francisco, CA", "3122 16th St, San Francisco, CA", "103 Mulford Hall, UC Berkeley, Berkeley, CA", "1168 Folsom St, Suite 101, San Francisco, CA", "101 Eighth Street, Oakland, CA"]

UPDATE events SET (lat, lng) = (37.796931,-122.265491) WHERE street_addr='101 Eighth Street';
UPDATE events SET (lat, lng) = (37.764972,-122.42215)  WHERE street_addr='3122 16th St';
UPDATE events SET (lat, lng) = (37.775715,-122.409211) WHERE street_addr='1168 Folsom St, Suite 101';
UPDATE events SET (lat, lng) = (37.879916,-122.261404) WHERE street_addr='103 Mulford Hall, UC Berkeley';
UPDATE events SET (lat, lng) = (37.764792,-122.419574) WHERE street_addr='2017 Mission Street';


# select min(lng), max(lng), min(lat), max(lat) from events;
     min      |     max      |    min     |    max     
--------------+--------------+------------+------------
 -122.4221500 | -122.2614040 | 37.7647920 | 37.8799160