SQL Query for population values by grid point

[Paul Henshaw]

Experimenting with SQL query to create a GeoTIFF from GED population data for a given region.

SELECT
 point.lat, point.lon, pop.pop_value, att.is_urban
INTO
 gem.pop_vals_ita
FROM
 eqged.grid_point point
JOIN
 eqged.population pop
 ON point.id=pop.grid_point_id
JOIN
 eqged.grid_point_country country
 ON country.grid_point_id=point.id
JOIN
 eqged.grid_point_attribute att
 ON att.grid_point_id=point.id
WHERE
 country.gadm_country_id=112
AND
 pop.population_src_id=5;

For four countries:
 MAC 137 (Macao)
 LUX 135
 ITA = 112
 JPN = 116

[Ben Wyss (bmwyss)]

149591.609375

This is the maximum value for eqged.population.pop_value

[Ben Wyss (bmwyss)]

and the scale for rural should be from 0 to 17052

[Paul Henshaw (paul-sl-henshaw)]

I have also added Switzerland in gem.pop_vals_che (gadm_country_id =188)

[Paul Henshaw (paul-sl-henshaw)]

I have also added Australia gem.pop_vals_aus (gadm_country_id=16)