Adapting point geometry for storing address density

A system for adapting point geometry for storing address density, comprising:

• means for accumulating a count of addresses on each of a plurality of streets;
• means for storing the accumulated count for each street as one dimension of a 4-dimensional point geometry, wherein remaining ones of the 4 dimensions store:
• (1) a state identification, (2) a city identification, and (3) a zip code identification of the street;
• and
• means for querying the point geometries to determine a density of a selected one of the streets, wherein the means for querying locates the 4-dimensional point geometry for the selected one of the streets and returns the accumulated count stored in that located point geometry.

A computer program product for adapting point geometry for storing address density, the computer program product embodied on one or more computer-readable media and comprising:

• computer-readable program code means for accumulating a count of addresses on each of a plurality of streets;
• computer-readable program code means for storing the accumulated count for each street as one dimension of a 4-dimensional point geometry in a spatially-enabled table of a relational database, wherein remaining ones of the 4 dimensions store:
• (1) a state identification, (2) a city identification, and (3) a zip code identification of the street;
• and
• computer-readable program code means for querying the relational database to determine a density of a selected one of the streets, wherein the computer-readable program code means for querying locates the 4-dimensional point geometry for the selected one of the streets and returns the accumulated count stored in that located point geometry.