Speeding Up Queries

[Eric Katherman]

Here is a sample record from that table just for good measure.

 gid | area  |       address       | dbt_end  | dbt_begin | end_date |
begin_date | filename | floor |   apn    |  id   |
the_geom
-----+-------+---------------------+----------+-----------+----------+------------+----------+-------+----------+-------+-----------------------------------------------------------------------------------------------------------------------------------------
 100 | 52581 | 11333 W WINSLOW AVE | 99991231 | 20021018  | 99991231 |
19000101   | 1012101  |     1 | 10121028 | 37040 |
SRID=-1;MULTIPOLYGON(((582058.524 880137.609,582060.794 879835.702,581886.216
879832.266,581884.737 880134.033,582058.524 880137.609)))
(1 row)