selecting block groups for los angles in postgres-- using census tiger data, place geographies and postgis.
create table la_bg as select b.geoid,b.namelsad,b.aland, b.awater, b.geom from bg b, (select * from places where namelsad ilike '%los angeles%') p where st_intersects(b.geom, p.geom);