I think the point is that this query that produces nothing: SELECT id FROM demo_index WHERE minX>=-81.08 AND maxX<=-80.58 AND minY>=35.00 AND maxY<=35.44;
Should produce something as the directions imply. It's just that SQL HQ is not actually inside the city limits apparently (mailing addresses are not restricted to city boundaries). So add another data point of something downtown. Like the Carolina Panthers stadium -80.854201,-80.851489, 35.224511, 35.226925 sqlite> insert into demo_index values(3,-80.854201,-80.851489,35.224511,35.226925); sqlite> SELECT id FROM demo_index WHERE minX>=-81.08 AND maxX<=-80.58 AND minY>=35.00 AND maxY<=35.44; id 3 Michael Black _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
