News for hackers. Stuff that matters.
Re:Ask HN: Storing spatial data in SQL by nym on Wednesday November 17, 2010 @11:33PM (#1916886)
I recently built a site for finding vineyards, and used GeoDjango with Postgres+PostGIS.

Setting up was a small PITA, but a bounding box query looks like this:

  footprint = Polygon(((ullon, ullat), (lrlon, ullat), (lrlon, lrlat), (ullon, lrlat), (ullon, ullat)))
  vineyards = Winery.objects.filter(loc__within=footprint)
If you're interested, check it out: http://finelocalwine.com/
Re:Ask HN: Storing spatial data in SQL by Azuldolphin on Wednesday November 17, 2010 @11:52PM (#1916930)
Thanks a lot, that looks like it's along the same lines as what I'm trying to do. How did you test this locally? Does Sqlite support this? Or did you set up PostgreSQL on your development machine?
Re:Ask HN: Storing spatial data in SQL by nym on Thursday November 18, 2010 @12:02AM (#1916947)
Yeah, you have to set it up locally, but again, it's worth it.