Code


Version 21 (modified by Jeremy Dunck <jdunck@…>, 7 years ago) (diff)

--

The gis branch intends to add a contrib app implementing geographic support.

What's GIS?

  • Series of blog posts giving intro to GIS; choice quote from an early post: "If you feel like ending a conversation with a developer then simply bring up the topic of character encodings ... [o]r ... coordinate systems. ... So in the spirit of Tim Bray's and Joel Spolsky's wonderful writeups of character encodings, I thought I'd put together a basic survival guide to coordinate systems over my next few posts and then tie it back to Google Maps."
  • More on map projections, including why people can't agree on just one (utf-8).
  • geodesy the field of science for this stuff.

Useful code

Questions

  • When dealing with points (say, degrees) from, do they need to be converted to be useful on the back-end data, assuming -that- data is in degrees? Is it enough to have the same datum and origin? (Reading the intro above is likely to answer the question.)

Implementation

Phase 1

Assume existing data and columns, and that the UOM given is same as backing data. Support a custom manager (and queryset) to support lookups.

GeoTypes

GeoTypes 0.7 supports both psycopg1 and psycopg2. Upside is conversion from type params to SQL. Simplifies (avoids?) QuerySet modification. Maintainer of GeoTypes has been responsive as of Feb 26 2007 on the psycopg mailing list. Example code, where point and box are types from GeoTypes.OG*:

from django.db import models
from django.contrib.gis import db as gis_db

class School(meta.Model):
  name = ...
  objects = gis_db.Manager()

Assume a location column has already been added to the DB, e.g.
select addgeometrycolumn('','schools_school','location',-1, 'POINT', 2);

Then this would work:
from django.contrib.gis.geometry import Point
x = Point(-95.36819458007812, 30.2184318620219)
School.objects.geo_near('location', point=x, radius=1.0)

This could construct a LinearRing approximating the circle around x
and issue something like:

poly = "POLYGON (...points from curve approximation...)"
_where.append("""
where schools_school.location && %s and
within(schools_school.location, %s)
""")
_params.append(poly, poly)}}}

=== Geos ===
  I'm not sure how we can use GEOS without also doing something like GeoTypes down in the QuerySet.  Ideas?



== Phase 2 ==
=== Field Types ===
 * To allow update through ORM, new fieldtypes would be needed.


=== GIS utilities ===
wrapper for geos, have the ability to do something like

{{{
from django.contrib.gis import area
area(bbox.geom)
}}}