The gridcells_in_geography table

This table shows whether each grid cell is contained in the polygons of each geography. If a grid cell is listed for a particular polygon, it means that the cell is entirely or partially within the polygon; if it isn't listed, that grid cell is not in the given polygon (or is partially outside the polygon). (See cells partially within a polygon.)

Column Name	Data Type	Description
grid_id	integer	The grid cell
geography_type_id	integer	The geography containing this grid cell
geography_id	integer	A unique identifier for a particular polygon of the geography with this geography_type_id

• geography_id must be between polygon_id_valid_min and polygon_id_valid_max, inclusive, of the geography with geography_type_id as specified in the geographies table.

This table is copied from the appropriate baseyear or scenario database into the output database, so that it is easily accessible when writing SQL indicator computations.