LoganWinston

SELECT count(*), state
FROM compcorp 
GROUP BY state

LoganWinston

Update extracttokml_9_ set area =(ST_Area(the_geom_webmercator) * 10.7639)

LoganWinston

Who am I

• Account Manager at CartoDB
• loganwinston on twitter
• m 415 694 2144

Creating your accounts

Set you up with accounts here, signup.

LoganWinston

SELECT ne_50m_admin_1_states.the_geom, ne_50m_admin_1_states.the_geom_webmercator, ne_50m_admin_1_states.cartodb_id FROM ne_50m_admin_1_states WHERE ne_50m_admin_1_states.name = 'Texas'

LoganWinston

SELECT tl_2010_48_county10_dpsf.name10, usgs_windturbine_201307.the_geom, usgs_windturbine_201307.the_geom_webmercator, usgs_windturbine_201307.cartodb_id,
usgs_windturbine_201307.mw_turbine, 
usgs_windturbine_201307.manufac,
usgs_windturbine_201307.on_year, usgs_windturbine_201307.blade_l, usgs_windturbine_201307.rotor_dia, usgs_windturbine_201307.model, 
usgs_windturbine_201307.tower_h, usgs_windturbine_201307.total_ht
FROM usgs_windturbine_201307, tl_2010_48_county10_dpsf WHERE
ST_Intersects(usgs_windturbine_201307.the_geom, tl_2010_48_county10_dpsf.the_geom)

LoganWinston

--PART 2
--	a. 
		SELECT * FROM tornados
		SELECT cartodb_id FROM tornados
--	b. 
		SELECT * FROM tornados LIMIT 1
		SELECT * FROM tornados LIMIT 1 OFFSET 1
		SELECT * FROM tornados ORDER BY damage DESC LIMIT 10

LoganWinston

--PART 2
--	a. 
		SELECT * FROM tornados
		SELECT cartodb_id FROM tornados
--	b. 
		SELECT * FROM tornados LIMIT 1
		SELECT * FROM tornados LIMIT 1 OFFSET 1
		SELECT * FROM tornados ORDER BY damage DESC LIMIT 10
--	c. 
		SELECT * FROM tornados WHERE cartodb_id < 30