andrewxhill/notes.md

## notes.md

      
    Raw
  

              notes.md
            
          
    http://bit.ly/citytracts


import file
explore table and map
Reclaim some space!

update nyct2010 set the_geom = ST_SimplifyPreserveTopology(the_geom, 0.0003)

prompt CartoDB to update tablesize

VACUUM FULL nyct2010
http://bit.ly/city_racks


add numeric column titled racks racks to the
run the following sql

update nyct2010 set racks = (
   SELECT count(*) FROM dot_cityracks_2012 
   WHERE ST_Intersects(the_geom, nyct2010.the_geom)
)

map it
normalize it

UPDATE nyct2010 SET racks_normalized = racks / shape_area

update cartocss