Abstract: A method, spatial data system, and computer program product for managing spatial data stored in a database by indexing spatial object identifiers associated with spatial objects of varying dimensions using a spatial index for each spatial object identifier comprised of one or more index coordinate variables that define a single point spatially related to the spatial object and one or more index dimension variables that define a bounding shape based on the spatial object's size. The spatial data system is configured to allow querying of the database to determine spatial object identifiers, and associated spatial objects, within a search area by identifying spatial indexes that define bounding shapes intersecting the search area and producing the results on a user interface.

Abstract: The present invention is directed towards systems and methods for providing up-to-date constraint based advertising content. The method according to one embodiment of the present invention comprises receiving a request for advertisement content and selecting a first plurality of advertisements meeting the user profile data. The method then filters the first plurality of advertisements based on advertiser and publisher constraints and selecting a second plurality of advertisements and provides the second plurality of advertisements to a user.