next up previous index
Next: Database Tables about Grid Up: Database Tables about Geographies Previous: The gridcells_in_geography table   Index

The geography_names table

This table provides names for each of the geography polygons. The names are optional - if a name does not exist for a combination of geography_type_id and geography_id, the indicator visualization programs uses the geography_type_title and the geography_id number, e.g., ``district 5''. In particular, you almost certainly don't want names for the ``grid'' geography, since that would require naming each grid cell.

Column Name Data Type Description
geography_type_id integer The geography
geography_id integer A unique identifier for a particular polygon of the geography with this geography_type_id
name varchar The name of this polygon, e.g., ``Seattle'' or ``PSRC'' or ``downtown''

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.


next up previous index
Next: Database Tables about Grid Up: Database Tables about Geographies Previous: The gridcells_in_geography table   Index
info (at) urbansim.org