5.1. Age and Gender

Population breakdowns by age and gender.

5.1.1. Children under 18 Years of Age

../_images/us.census.acs.B09001001.png

The number of people within each geography who are under 18 years of age.

Measure “Children under 18 Years of Age” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B09001001'
    );

Measure “Children under 18 Years of Age” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B09001001'
    );

5.1.2. Median Age

../_images/us.census.acs.B01002001.png

The median age of all people in a given geographic area.

Measure “Median Age” for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01002001'
    );

Median Age is only available for point lookups.

5.1.3. Men age 45 to 64 (“middle aged”)

../_images/us.census.acs.B15001027.png

The male population between the age of fourty-five years to sixty-four years within the specified area.

Measure “Men age 45 to 64 (“middle aged”)” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B15001027'
    );

Measure “Men age 45 to 64 (“middle aged”)” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B15001027'
    );

5.1.4. Population 1 year and over

../_images/us.census.acs.B07204001.png

All people, male and female, child and adult, living in a given geographic area that are 1 year and older.

Measure “Population 1 year and over” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B07204001'
    );

Measure “Population 1 year and over” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B07204001'
    );

5.1.5. Population 15 Years and Over

../_images/us.census.acs.B12005001.png

The number of people in a geographic area who are over the age of 15. This is used mostly as a denominator of marital status.

Measure “Population 15 Years and Over” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B12005001'
    );

Measure “Population 15 Years and Over” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B12005001'
    );

5.1.6. Population age 16 and over

../_images/us.census.acs.B23025001.png

The number of people in each geography who are age 16 or over.

Measure “Population age 16 and over” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B23025001'
    );

Measure “Population age 16 and over” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B23025001'
    );

5.1.7. Total Population

../_images/us.census.acs.B01003001.png

The total number of all people living in a given geographic area. This is a very useful catch-all denominator when calculating rates.

Measure “Total Population” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01003001'
    );

Measure “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01003001'
    );

5.1.7.1. Female age 5 to 9

../_images/us.census.acs.B01001028.png

The female population between the age of five years to nine years within the specified area.

Measure “Female age 5 to 9” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001028'
    );

Measure “Female age 5 to 9” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001028'
    );

Measure “Female age 5 to 9” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001028',
      'denominator'
    );

Measure “Female age 5 to 9” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001028',
      'denominator'
    );
denominator:Total Population

5.1.7.2. Female age 10 to 14

../_images/us.census.acs.B01001029.png

The female population between the age of ten years to fourteen years within the specified area.

Measure “Female age 10 to 14” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001029'
    );

Measure “Female age 10 to 14” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001029'
    );

Measure “Female age 10 to 14” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001029',
      'denominator'
    );

Measure “Female age 10 to 14” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001029',
      'denominator'
    );
denominator:Total Population

5.1.7.3. Female age 15 to 17

../_images/us.census.acs.B01001030.png

The female population between the age of fifteeen years to seventeen years within the specified area.

Measure “Female age 15 to 17” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001030'
    );

Measure “Female age 15 to 17” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001030'
    );

Measure “Female age 15 to 17” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001030',
      'denominator'
    );

Measure “Female age 15 to 17” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001030',
      'denominator'
    );
denominator:Total Population

5.1.7.4. Female age 18 and 19

../_images/us.census.acs.B01001031.png

The female population between the age of eighteen years to nineteen years within the specified area.

Measure “Female age 18 and 19” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001031'
    );

Measure “Female age 18 and 19” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001031'
    );

Measure “Female age 18 and 19” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001031',
      'denominator'
    );

Measure “Female age 18 and 19” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001031',
      'denominator'
    );
denominator:Total Population

5.1.7.5. Female age 20

../_images/us.census.acs.B01001032.png

The female population with an age of twenty years within the specified area.

Measure “Female age 20” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001032'
    );

Measure “Female age 20” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001032'
    );

Measure “Female age 20” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001032',
      'denominator'
    );

Measure “Female age 20” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001032',
      'denominator'
    );
denominator:Total Population

5.1.7.6. Female age 21

../_images/us.census.acs.B01001033.png

The female population with an age of twenty-one years within the specified area.

Measure “Female age 21” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001033'
    );

Measure “Female age 21” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001033'
    );

Measure “Female age 21” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001033',
      'denominator'
    );

Measure “Female age 21” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001033',
      'denominator'
    );
denominator:Total Population

5.1.7.7. Female age 22 to 24

../_images/us.census.acs.B01001034.png

The female population between the age of twenty-two years to twenty-four years within the specified area.

Measure “Female age 22 to 24” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001034'
    );

Measure “Female age 22 to 24” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001034'
    );

Measure “Female age 22 to 24” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001034',
      'denominator'
    );

Measure “Female age 22 to 24” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001034',
      'denominator'
    );
denominator:Total Population

5.1.7.8. Female age 25 to 29

../_images/us.census.acs.B01001035.png

The female population between the age of twenty-five years to twenty-nine years within the specified area.

Measure “Female age 25 to 29” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001035'
    );

Measure “Female age 25 to 29” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001035'
    );

Measure “Female age 25 to 29” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001035',
      'denominator'
    );

Measure “Female age 25 to 29” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001035',
      'denominator'
    );
denominator:Total Population

5.1.7.9. Female age 30 to 34

../_images/us.census.acs.B01001036.png

The female population between the age of thirty years to thirty-four years within the specified area.

Measure “Female age 30 to 34” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001036'
    );

Measure “Female age 30 to 34” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001036'
    );

Measure “Female age 30 to 34” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001036',
      'denominator'
    );

Measure “Female age 30 to 34” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001036',
      'denominator'
    );
denominator:Total Population

5.1.7.10. Female age 35 to 39

../_images/us.census.acs.B01001037.png

The female population between the age of thirty-five years to thirty-nine years within the specified area.

Measure “Female age 35 to 39” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001037'
    );

Measure “Female age 35 to 39” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001037'
    );

Measure “Female age 35 to 39” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001037',
      'denominator'
    );

Measure “Female age 35 to 39” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001037',
      'denominator'
    );
denominator:Total Population

5.1.7.11. Female age 40 to 44

../_images/us.census.acs.B01001038.png

The female population between the age of fourty years to fourty-four years within the specified area.

Measure “Female age 40 to 44” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001038'
    );

Measure “Female age 40 to 44” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001038'
    );

Measure “Female age 40 to 44” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001038',
      'denominator'
    );

Measure “Female age 40 to 44” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001038',
      'denominator'
    );
denominator:Total Population

5.1.7.12. Female age 45 to 49

../_images/us.census.acs.B01001039.png

The female population between the age of fourty-five years to fourty-nine years within the specified area.

Measure “Female age 45 to 49” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001039'
    );

Measure “Female age 45 to 49” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001039'
    );

Measure “Female age 45 to 49” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001039',
      'denominator'
    );

Measure “Female age 45 to 49” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001039',
      'denominator'
    );
denominator:Total Population

5.1.7.13. Female age 50 to 54

../_images/us.census.acs.B01001040.png

The female population between the age of fifty years to fifty-four years within the specified area.

Measure “Female age 50 to 54” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001040'
    );

Measure “Female age 50 to 54” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001040'
    );

Measure “Female age 50 to 54” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001040',
      'denominator'
    );

Measure “Female age 50 to 54” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001040',
      'denominator'
    );
denominator:Total Population

5.1.7.14. Female age 55 to 59

../_images/us.census.acs.B01001041.png

The female population between the age of fifty-five years to fifty-nine years within the specified area.

Measure “Female age 55 to 59” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001041'
    );

Measure “Female age 55 to 59” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001041'
    );

Measure “Female age 55 to 59” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001041',
      'denominator'
    );

Measure “Female age 55 to 59” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001041',
      'denominator'
    );
denominator:Total Population

5.1.7.15. Female age 60 and 61

../_images/us.census.acs.B01001042.png

The female population between the age of sixty years to sixty-one years within the specified area.

Measure “Female age 60 and 61” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001042'
    );

Measure “Female age 60 and 61” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001042'
    );

Measure “Female age 60 and 61” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001042',
      'denominator'
    );

Measure “Female age 60 and 61” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001042',
      'denominator'
    );
denominator:Total Population

5.1.7.16. Female age 62 to 64

../_images/us.census.acs.B01001043.png

The female population between the age of sixty-two years to sixty-four years within the specified area.

Measure “Female age 62 to 64” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001043'
    );

Measure “Female age 62 to 64” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001043'
    );

Measure “Female age 62 to 64” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001043',
      'denominator'
    );

Measure “Female age 62 to 64” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001043',
      'denominator'
    );
denominator:Total Population

5.1.7.17. Female age 65 to 66

../_images/us.census.acs.B01001044.png

The female population between the age of sixty-five years to sixty-six years within the specified area.

Measure “Female age 65 to 66” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001044'
    );

Measure “Female age 65 to 66” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001044'
    );

Measure “Female age 65 to 66” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001044',
      'denominator'
    );

Measure “Female age 65 to 66” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001044',
      'denominator'
    );
denominator:Total Population

5.1.7.18. Female age 67 to 69

../_images/us.census.acs.B01001045.png

The female population between the age of sixty-seven years to sixty-nine years within the specified area.

Measure “Female age 67 to 69” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001045'
    );

Measure “Female age 67 to 69” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001045'
    );

Measure “Female age 67 to 69” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001045',
      'denominator'
    );

Measure “Female age 67 to 69” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001045',
      'denominator'
    );
denominator:Total Population

5.1.7.19. Female age 70 to 74

../_images/us.census.acs.B01001046.png

The female population between the age of seventy years to seventy-four years within the specified area.

Measure “Female age 70 to 74” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001046'
    );

Measure “Female age 70 to 74” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001046'
    );

Measure “Female age 70 to 74” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001046',
      'denominator'
    );

Measure “Female age 70 to 74” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001046',
      'denominator'
    );
denominator:Total Population

5.1.7.20. Female age 75 to 79

../_images/us.census.acs.B01001047.png

The female population between the age of seventy-five years to seventy-nine years within the specified area.

Measure “Female age 75 to 79” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001047'
    );

Measure “Female age 75 to 79” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001047'
    );

Measure “Female age 75 to 79” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001047',
      'denominator'
    );

Measure “Female age 75 to 79” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001047',
      'denominator'
    );
denominator:Total Population

5.1.7.21. Female age 80 to 84

../_images/us.census.acs.B01001048.png

The female population between the age of eighty years to eighty-four years within the specified area.

Measure “Female age 80 to 84” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001048'
    );

Measure “Female age 80 to 84” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001048'
    );

Measure “Female age 80 to 84” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001048',
      'denominator'
    );

Measure “Female age 80 to 84” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001048',
      'denominator'
    );
denominator:Total Population

5.1.7.22. Female age 85 and over

../_images/us.census.acs.B01001049.png

The female population of the age of eighty-five years and over within the specified area.

Measure “Female age 85 and over” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001049'
    );

Measure “Female age 85 and over” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001049'
    );

Measure “Female age 85 and over” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001049',
      'denominator'
    );

Measure “Female age 85 and over” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001049',
      'denominator'
    );
denominator:Total Population

5.1.7.23. Female Population

../_images/us.census.acs.B01001026.png

The number of people within each geography who are female.

Measure “Female Population” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001026'
    );

Measure “Female Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001026'
    );

Measure “Female Population” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001026',
      'denominator'
    );

Measure “Female Population” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001026',
      'denominator'
    );
denominator:Total Population

5.1.7.24. Female under 5 years

../_images/us.census.acs.B01001027.png

The female population over the age of five years within the specified area.

Measure “Female under 5 years” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001027'
    );

Measure “Female under 5 years” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001027'
    );

Measure “Female under 5 years” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001027',
      'denominator'
    );

Measure “Female under 5 years” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001027',
      'denominator'
    );
denominator:Total Population

5.1.7.25. Male age 10 to 14

../_images/us.census.acs.B01001004.png

The male population between the age of ten years to fourteen years within the specified area.

Measure “Male age 10 to 14” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001004'
    );

Measure “Male age 10 to 14” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001004'
    );

Measure “Male age 10 to 14” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001004',
      'denominator'
    );

Measure “Male age 10 to 14” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001004',
      'denominator'
    );
denominator:Total Population

5.1.7.26. Male age 15 to 17

../_images/us.census.acs.B01001006.png

The male population between the age of fifteeen years to seventeen years within the specified area.

Measure “Male age 15 to 17” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001006'
    );

Measure “Male age 15 to 17” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001006'
    );

Measure “Male age 15 to 17” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001006',
      'denominator'
    );

Measure “Male age 15 to 17” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001006',
      'denominator'
    );
denominator:Total Population

5.1.7.27. Male age 18 and 19

../_images/us.census.acs.B01001007.png

The male population between the age of eighteen years to nineteen years within the specified area.

Measure “Male age 18 and 19” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001007'
    );

Measure “Male age 18 and 19” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001007'
    );

Measure “Male age 18 and 19” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001007',
      'denominator'
    );

Measure “Male age 18 and 19” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001007',
      'denominator'
    );
denominator:Total Population

5.1.7.28. Male age 20

../_images/us.census.acs.B01001008.png

The male population with an age of twenty years within the specified area.

Measure “Male age 20” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001008'
    );

Measure “Male age 20” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001008'
    );

Measure “Male age 20” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001008',
      'denominator'
    );

Measure “Male age 20” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001008',
      'denominator'
    );
denominator:Total Population

5.1.7.29. Male age 21

../_images/us.census.acs.B01001009.png

The male population with an age of twenty-one years within the specified area.

Measure “Male age 21” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001009'
    );

Measure “Male age 21” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001009'
    );

Measure “Male age 21” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001009',
      'denominator'
    );

Measure “Male age 21” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001009',
      'denominator'
    );
denominator:Total Population

5.1.7.30. Male age 22 to 24

../_images/us.census.acs.B01001010.png

The male population between the age of twenty-two years to twenty-four years within the specified area.

Measure “Male age 22 to 24” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001010'
    );

Measure “Male age 22 to 24” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001010'
    );

Measure “Male age 22 to 24” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001010',
      'denominator'
    );

Measure “Male age 22 to 24” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001010',
      'denominator'
    );
denominator:Total Population

5.1.7.31. Male age 25 to 29

../_images/us.census.acs.B01001011.png

The male population between the age of twenty-five years to twenty-nine years within the specified area.

Measure “Male age 25 to 29” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001011'
    );

Measure “Male age 25 to 29” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001011'
    );

Measure “Male age 25 to 29” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001011',
      'denominator'
    );

Measure “Male age 25 to 29” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001011',
      'denominator'
    );
denominator:Total Population

5.1.7.32. Male age 30 to 34

../_images/us.census.acs.B01001012.png

The male population between the age of thirty years to thirty-four years within the specified area.

Measure “Male age 30 to 34” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001012'
    );

Measure “Male age 30 to 34” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001012'
    );

Measure “Male age 30 to 34” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001012',
      'denominator'
    );

Measure “Male age 30 to 34” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001012',
      'denominator'
    );
denominator:Total Population

5.1.7.33. Male age 35 to 39

../_images/us.census.acs.B01001013.png

The male population between the age of thirty-five years to thirty-nine years within the specified area.

Measure “Male age 35 to 39” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001013'
    );

Measure “Male age 35 to 39” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001013'
    );

Measure “Male age 35 to 39” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001013',
      'denominator'
    );

Measure “Male age 35 to 39” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001013',
      'denominator'
    );
denominator:Total Population

5.1.7.34. Male age 40 to 44

../_images/us.census.acs.B01001014.png

The male population between the age of fourty years to fourty-four years within the specified area.

Measure “Male age 40 to 44” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001014'
    );

Measure “Male age 40 to 44” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001014'
    );

Measure “Male age 40 to 44” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001014',
      'denominator'
    );

Measure “Male age 40 to 44” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001014',
      'denominator'
    );
denominator:Total Population

5.1.7.35. Male age 65 to 66

../_images/us.census.acs.B01001020.png

The male population between the age of sixty-five years to sixty-six years within the specified area.

Measure “Male age 65 to 66” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001020'
    );

Measure “Male age 65 to 66” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001020'
    );

Measure “Male age 65 to 66” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001020',
      'denominator'
    );

Measure “Male age 65 to 66” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001020',
      'denominator'
    );
denominator:Total Population

5.1.7.36. Male age 67 to 69

../_images/us.census.acs.B01001021.png

The male population between the age of sixty-seven years to sixty-nine years within the specified area.

Measure “Male age 67 to 69” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001021'
    );

Measure “Male age 67 to 69” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001021'
    );

Measure “Male age 67 to 69” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001021',
      'denominator'
    );

Measure “Male age 67 to 69” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001021',
      'denominator'
    );
denominator:Total Population

5.1.7.37. Male age 70 to 74

../_images/us.census.acs.B01001022.png

The male population between the age of seventy years to seventy-four years within the specified area.

Measure “Male age 70 to 74” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001022'
    );

Measure “Male age 70 to 74” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001022'
    );

Measure “Male age 70 to 74” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001022',
      'denominator'
    );

Measure “Male age 70 to 74” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001022',
      'denominator'
    );
denominator:Total Population

5.1.7.38. Male age 75 to 79

../_images/us.census.acs.B01001023.png

The male population between the age of seventy-five years to seventy-nine years within the specified area.

Measure “Male age 75 to 79” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001023'
    );

Measure “Male age 75 to 79” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001023'
    );

Measure “Male age 75 to 79” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001023',
      'denominator'
    );

Measure “Male age 75 to 79” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001023',
      'denominator'
    );
denominator:Total Population

5.1.7.39. Male age 80 to 84

../_images/us.census.acs.B01001024.png

The male population between the age of eighty years to eighty-four years within the specified area.

Measure “Male age 80 to 84” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001024'
    );

Measure “Male age 80 to 84” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001024'
    );

Measure “Male age 80 to 84” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001024',
      'denominator'
    );

Measure “Male age 80 to 84” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001024',
      'denominator'
    );
denominator:Total Population

5.1.7.40. Male age 85 and over

../_images/us.census.acs.B01001025.png

The male population of the age of eighty-five years and over within the specified area.

Measure “Male age 85 and over” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001025'
    );

Measure “Male age 85 and over” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001025'
    );

Measure “Male age 85 and over” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001025',
      'denominator'
    );

Measure “Male age 85 and over” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001025',
      'denominator'
    );
denominator:Total Population

5.1.7.41. Male Population

../_images/us.census.acs.B01001002.png

The number of people within each geography who are male.

Measure “Male Population” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001002'
    );

Measure “Male Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001002'
    );

Measure “Male Population” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001002',
      'denominator'
    );

Measure “Male Population” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001002',
      'denominator'
    );
denominator:Total Population

5.1.7.42. Male under 5 years

../_images/us.census.acs.B01001003.png

The male population over the age of five years within the specified area.

Measure “Male under 5 years” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001003'
    );

Measure “Male under 5 years” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001003'
    );

Measure “Male under 5 years” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001003',
      'denominator'
    );

Measure “Male under 5 years” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001003',
      'denominator'
    );
denominator:Total Population

5.1.7.43. Men age 45 to 49

../_images/us.census.acs.B01001015.png

The male population between the age of fourty-five years to fourty-nine years within the specified area.

Measure “Men age 45 to 49” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001015'
    );

Measure “Men age 45 to 49” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001015'
    );

Measure “Men age 45 to 49” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001015',
      'denominator'
    );

Measure “Men age 45 to 49” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001015',
      'denominator'
    );
denominator:Total Population

5.1.7.44. Men age 50 to 54

../_images/us.census.acs.B01001016.png

The male population between the age of fifty years to fifty-four years within the specified area.

Measure “Men age 50 to 54” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001016'
    );

Measure “Men age 50 to 54” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001016'
    );

Measure “Men age 50 to 54” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001016',
      'denominator'
    );

Measure “Men age 50 to 54” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001016',
      'denominator'
    );
denominator:Total Population

5.1.7.45. Men age 55 to 59

../_images/us.census.acs.B01001017.png

The male population between the age of fifty-five years to fifty-nine years within the specified area.

Measure “Men age 55 to 59” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001017'
    );

Measure “Men age 55 to 59” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001017'
    );

Measure “Men age 55 to 59” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001017',
      'denominator'
    );

Measure “Men age 55 to 59” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001017',
      'denominator'
    );
denominator:Total Population

5.1.7.46. Men age 60 to 61

../_images/us.census.acs.B01001018.png

The male population between the age of sixty years to sixty-one years within the specified area.

Measure “Men age 60 to 61” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001018'
    );

Measure “Men age 60 to 61” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001018'
    );

Measure “Men age 60 to 61” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001018',
      'denominator'
    );

Measure “Men age 60 to 61” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001018',
      'denominator'
    );
denominator:Total Population

5.1.7.47. Men age 62 to 64

../_images/us.census.acs.B01001019.png

The male population between the age of sixty-two years to sixty-four years within the specified area.

Measure “Men age 62 to 64” density per sq. kilometer for one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001019'
    );

Measure “Men age 62 to 64” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001019'
    );

Measure “Men age 62 to 64” percent of “Total Population” at one point:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      CDB_LatLng(40.7, -73.9),
      'us.census.acs.B01001019',
      'denominator'
    );

Measure “Men age 62 to 64” percent of “Total Population” within an area:

UPDATE {table_name}
  SET {new_numeric_column} =
    OBS_GetMeasure(
      ST_Buffer(CDB_LatLng(40.7, -73.9), 0.01),
      'us.census.acs.B01001019',
      'denominator'
    );
denominator:Total Population