arminakvn
12/12/2017 - 7:35 PM

selecting block groups for los angles in postgres-- using census tiger data, place geographies and postgis.

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);