ó ø¢TQc@s ddlmZddlmZmZmZddlmZddlm Z ddl m Z m Z m Z ddlmZmZmZmZddlmZddlmZmZdd lmZd efd „ƒYZd efd „ƒYZdeefd„ƒYZdS(iÿÿÿÿ(t connections(tQuerySettValuesQuerySettValuesListQuerySet(t memoryview(t aggregates(t get_srid_infot PointFieldtLineStringField(t AreaFieldt DistanceFieldt GeomFieldtGeoQuery(tGeometry(tAreatDistance(tsixt GeoQuerySetcBsÊeZdZd/d/d/d„Zd„Zd„Zdd„Zd„Zd„Z d„Z d „Z d „Z d „Z d „Zd „Zdeed„Zdd„Zddd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zd„Zdd„Zd „Zedd!„Z d"„Z!dd#„Z"d$d%„Z#d&„Z$d'„Z%d/d/d/d(„Z&d/d/dd)„Z'd/d/d*„Z(d/ded+„Z)dd,„Z*dd-„Z+d.„Z,RS(0sThe Geographic QuerySet.cCsAtt|ƒjd|d|d|ƒ|p7t|jƒ|_dS(Ntmodeltquerytusing(tsuperRt__init__R RR(tselfRRR((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRs%cGs|jdtdtd|ƒS(Ntklasstsetupt_fields(t_clonetGeoValuesQuerySettTrue(Rtfields((s;../Django//lib/python/django/contrib/gis/db/models/query.pytvaluessc Os}|jdtƒ}|r4tdt|ƒfƒ‚n|r[t|ƒdkr[tdƒ‚n|jdtdtd|d|ƒS(Ntflats/Unexpected keyword arguments to values_list: %sisH'flat' is not valid when values_list is called with more than one field.RRR(tpoptFalset TypeErrortlisttlenRtGeoValuesListQuerySetR(RRtkwargsR ((s;../Django//lib/python/django/contrib/gis/db/models/query.pyt values_listsgš™™™™™©?cKs|jdd|jdd ƒƒ\}}i|d6|d6td6}t|j}|j}|jrŒd|d<||dd If the geometry field is geodetic and PostGIS is the spatial database, then the more accurate spheroid calculation will be used instead of the quicker sphere calculation. `tolerance` => Used only for Oracle. The tolerance is in meters -- a default of 5 centimeters (0.05) is used. tdistance(t_distance_attribute(RRIR'((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRJXscKs|jd|S(s§ Returns a Geometry representing the bounding box of the Geometry field in an `envelope` attribute on each element of the GeoQuerySet. tenvelope(RC(RR'((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRLjscKs|jtj|S(s¯ Returns the extent (aggregate) of the features in the GeoQuerySet. The extent will be returned as a 4-tuple, consisting of (xmin, ymin, xmax, ymax). (RDRtExtent(RR'((s;../Django//lib/python/django/contrib/gis/db/models/query.pytextentrscKs|jtj|S(s» Returns the aggregate extent, in 3D, of the features in the GeoQuerySet. It is returned as a 6-tuple, comprising: (xmin, ymin, zmin, xmax, ymax, zmax). (RDRtExtent3D(RR'((s;../Django//lib/python/django/contrib/gis/db/models/query.pytextent3dyscKs|jd|S(sø Returns a modified version of the Polygon/MultiPolygon in which all of the vertices follow the Right-Hand-Rule. By default, this is attached as the `force_rhr` attribute on each element of the GeoQuerySet. t force_rhr(RC(RR'((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRQsicKs t|jj}|js(tdƒ‚nt|tjƒsItdƒ‚n|j dkr”d}|rs|rsd}qÍ|r‚d}qÍ|rÍd}qÍn9d}|r¯|r¯d}n|r¾d}n|rÍd}nidd 6i|d 6|d 6d 6d d6}|j d||S(s\ Returns a GeoJSON representation of the geomtry field in a `geojson` attribute on each element of the GeoQuerySet. The `crs` and `bbox` keywords may be set to True if the users wants the coordinate reference system and the bounding box to be included in the GeoJSON representation of the geometry. sFOnly PostGIS 1.3.4+ and SpatiaLite 3.0+ support GeoJSON serialization.s.Precision keyword must be set with an integer.iiiiitGeoJSONtdesct precisiontoptionsR+s%%(geo_col)s,%(precision)s,%(options)sR-tgeojson(iii( RR4R5RVtNotImplementedErrort isinstanceRt integer_typesR#tspatial_versionR>(RRTtcrstbboxR'RARUR?((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRVŠs0          icKs5idd6i|d6d6dd6}|jd||S(s Returns a GeoHash representation of the given field in a `geohash` attribute on each element of the GeoQuerySet. The `precision` keyword may be used to custom the number of _characters_ used in the output GeoHash, the default is 20. tGeoHashRSRTR+s%(geo_col)s,%(precision)sR-tgeohash(R>(RRTR'R?((s;../Django//lib/python/django/contrib/gis/db/models/query.pyR^­s  icKsˆt|jj}idd6i|d6d6}|jru|jd krPd|d(RRTR`R'RAR?((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRa»s   cKs|jd||S(sœ Returns the spatial intersection of the Geometry field in an `intersection` attribute on each element of this GeoQuerySet. t intersection(RH(RRIR'((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRbÍscKsAidd6dd6i|jddƒd6d6}|jd||S( s„ Returns KML representation of the geometry field in a `kml` attribute on each element of this GeoQuerySet. tKMLRSs%(geo_col)s,%(precision)sR-RTiR+tkml(R!R>(RR'R?((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRdÕs cKs|jdd|S(s Returns the length of the geometry field as a `Distance` object stored in a `length` attribute on each element of this GeoQuerySet. tlengthN(RKR3(RR'((s;../Django//lib/python/django/contrib/gis/db/models/query.pyReàscKs|jtjdt|S(sà Creates a linestring from all of the PointField geometries in the this GeoQuerySet and returns it. This is a spatial aggregate method, and thus returns a geometry rather than a GeoQuerySet. tgeo_field_type(RDRtMakeLineR(RR'((s;../Django//lib/python/django/contrib/gis/db/models/query.pyt make_lineçscKs|jdi|S(s¡ Returns the memory size (number of bytes) that the geometry field takes in a `mem_size` attribute on each element of this GeoQuerySet. tmem_size(R>(RR'((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRiïscKs|jdi|S(sÜ Returns the number of geometries if the field is a GeometryCollection or Multi* Field in a `num_geom` attribute on each element of this GeoQuerySet; otherwise the sets with None. tnum_geom(R>(RR'((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRjöscKs|jdi|S(sÇ Returns the number of points in the first linestring in the Geometry field in a `num_points` attribute on each element of this GeoQuerySet; otherwise sets with None. t num_points(R>(RR'((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRkÿscKs|jdd|S(s£ Returns the perimeter of the geometry field as a `Distance` object stored in a `perimeter` attribute on each element of this GeoQuerySet. t perimeterN(RKR3(RR'((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRlscKs|jd|S(sÒ Returns a Point geometry guaranteed to lie on the surface of the Geometry field in a `point_on_surface` attribute on each element of this GeoQuerySet; otherwise sets with None. tpoint_on_surface(RC(RR'((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRmscKsSitƒd6}|jddƒt|jjjr@t|d(RR'R?((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRos  gcKs£t|jjjr]|dkr.tdƒ‚nidd6i|d6|d6d6tƒd6}n3id d6i|d6|d6|d 6d6tƒd6}|jd ||S( s| Scales the geometry to a new size by multiplying the ordinates with the given x,y,z scale factors. gs'SpatiaLite does not support 3D scaling.s%(geo_col)s,%(x)s,%(y)sR-txtyR+R0s%(geo_col)s,%(x)s,%(y)s,%(z)stztscale(RR4R5R8RWR R>(RRrRsRtR'R?((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRu!s    c Os4tg|D]}t|tftjƒ^q krAtdƒ‚nt|ƒ}|dkry|d}d}i|d6}nŠ|dkr®|\}} d}i|d6| d 6}nU|d kr÷|\}} } } d }i|d6| d 6| d 6| d 6}n tdƒ‚i|d6|d6tƒd6} |j d| |S(sg Snap all points of the input geometry to the grid. How the geometry is snapped to the grid depends on how many arguments were given: - 1 argument : A single size to snap both the X and Y grids to. - 2 arguments: X and Y sizes to snap the grid to. - 4 arguments: X, Y sizes and the X, Y origins. s@Size argument(s) for the grid must be a float or integer values.iis%(geo_col)s,%(size)stsizeis%(geo_col)s,%(xsize)s,%(ysize)stxsizetysizeis7%(geo_col)s,%(xorigin)s,%(yorigin)s,%(xsize)s,%(ysize)stxorigintyorigins4Must provide 1, 2, or 4 arguments to `snap_to_grid`.R-R+R0t snap_to_grid( R"RXtfloatRRYR#R%t ValueErrorR R>( RtargsR'targtnargsRvR-R+RwRxRyRzR?((s;../Django//lib/python/django/contrib/gis/db/models/query.pyR{4s* 2         cKsott|ƒƒ}t|tjƒs3tdƒ‚nidd6dd6i|d6|d6d6}|jd ||S( sº Returns SVG representation of the geographic field in a `svg` attribute on each element of this GeoQuerySet. Keyword Arguments: `relative` => If set to True, this will evaluate the path in terms of relative moves (rather than absolute). `precision` => May be used to set the maximum number of decimal digits used in output (defaults to 8). s2SVG precision keyword argument must be an integer.tSVGRSs!%(geo_col)s,%(rel)s,%(precision)sR-trelRTR+tsvg(tinttboolRXRRYR#R>(RtrelativeRTR'R?((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRƒXs   cKs|jd||S(s— Returns the symmetric difference of the geographic field in a `sym_difference` attribute on each element of this GeoQuerySet. tsym_difference(RH(RRIR'((s;../Django//lib/python/django/contrib/gis/db/models/query.pyR‡oscKs£t|jjjr]|dkr.tdƒ‚nidd6i|d6|d6d6tƒd6}n3id d6i|d6|d6|d 6d6tƒd6}|jd ||S( sr Translates the geometry to a new location using the given numeric parameters as offsets. gs+SpatiaLite does not support 3D translation.s%(geo_col)s,%(x)s,%(y)sR-RrRsR+R0s%(geo_col)s,%(x)s,%(y)s,%(z)sRtt translate(RR4R5R8RWR R>(RRrRsRtR'R?((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRˆvs    iæc Ks¾t|tjƒs!tdƒ‚n|jddƒ}|jdd|ƒ\}}|j||ƒ}|jj j||ƒ}dt |j j j ||f}||j_||jj |<|jƒS(s  Transforms the given geometry field to the given SRID. If no SRID is provided, the transformation will default to using 4326 (WGS84). s!An integer SRID must be provided.R*t transforms %s(%s, %s)N(RXRRYR#R2R3R1t_geocol_selectRt custom_selectRR4R5R‰ttransformed_sridR( RtsridR'R*ttmpR,t field_coltgeo_colt custom_sel((s;../Django//lib/python/django/contrib/gis/db/models/query.pyR‰‰s  cKs|jd||S(s— Returns the union of the geographic field with the given Geometry in a `union` attribute on each element of this GeoQuerySet. tunion(RH(RRIR'((s;../Django//lib/python/django/contrib/gis/db/models/query.pyR’¥scKs|jtj|S(s» Performs an aggregate union on the given geometry field. Returns None if the GeoQuerySet is empty. The `tolerance` keyword is for Oracle backends only. (RDRtUnion(RR'((s;../Django//lib/python/django/contrib/gis/db/models/query.pytunionagg¬sc Csìt|j}t|j|tƒ}|dkr7|}n|s\td||jjfƒ‚ni|d6}|jj |ƒ}|s”t d|ƒ‚n|dk rÌt ||ƒ rÌt d||j fƒ‚n|j ||ƒ|d<||fS(sE Performs set up for executing the spatial function. s4%s stored procedure not available on the %s backend.tfunctions+%s output only available on GeometryFields.s1"%s" stored procedures may only be called on %ss.RN(RR4tgetattrR5R"R3RWtnameRt _geo_fieldR#RXt__name__RŠ( RtattRSR*RfR@tfuncR+R,((s;../Django//lib/python/django/contrib/gis/db/models/query.pyR1µs   cCs»|jj|ƒ}|s.td|jƒ‚n|dk rit||ƒ ritd|j|jfƒ‚n|pu|j}i}t|jj j rž||dtj |ƒD] \} } |dj| | ƒqÏWn |d }t |tj ƒs|}nx’|dD]†} |j |d| ƒ} |j d | d |ƒ} |j| |ƒ}d| }|d}|dj||ƒ|d<|dj| ƒq&Wd|d}|jdtƒr3|d}t |tƒr|jr|j|jj|ñsD         cKs°|j|d|jdd%ƒƒ\}}t|j}|j|ƒ} |j} | r[d} ntj|j |ƒƒ} |dk} |dk} |dk}| p¦| p¦|s¼t d|ƒ‚n|j dk}|pÔdd g}|j }|s|j r| r| r| r|jd ƒn|j|ƒ}|jd |d |ƒ}t|ƒ}|jr…| rcd }n| so|rxd}n||d(RR›RIR.RºR'R+R,R@R:R9tdist_attRJReRltgeom_3dt lookup_paramsRAR³R R-tut unit_nameR?((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRK@s˜'                $       ( %  %   cKsTitƒd6}t|jjjrAd|d(RR›R.R'R?((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRCÑs  cKssid d6tƒd6dd6i|d6d6}t|jjjr`|dcd7<||dd(RR›RIR.R'R?((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRHÜs  c Csô|jj}||jkr‚|jj|gƒ|jj|jƒ}|jƒ|jj|jj j |ƒ\}}|j ||ƒS||j krÔ|j |jƒ\}}} } |jj|jƒj ||jjƒS|jj|jƒj |ƒSdS(sÈ Helper routine for constructing the SQL to select the geographic column. Takes into account if the geographic field is in a ForeignKey relation to the current model. N(Rt_metaRRtadd_select_relatedt get_compilerR4t pre_sql_setuptrelated_select_colstrelated_select_fieldstindext _field_columnt local_fieldstget_field_by_nameR—tdb_table( RR,R*toptstcompilert rel_tabletrel_colttmp_fldt parent_modeltdirecttm2m((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRŠís  %%N(-R™t __module__t__doc__R3RRR(R)RBRFRGRJRLRNRPRQR"RVR^RaRbRdReRhRiRjRkRlRmRoRuR{RƒR‡RˆR‰R’R”R1RDR>RKRCRHRŠ(((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRsT          #          $      O‘ RcBseZd„ZRS(cOs)tt|ƒj||Žt|j_dS(N(RRRRRt geo_values(RR~R'((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRs(R™RãR(((s;../Django//lib/python/django/contrib/gis/db/models/query.pyRsR&cBseZRS((R™Rã(((s;../Django//lib/python/django/contrib/gis/db/models/query.pyR& sN(t django.dbRtdjango.db.models.queryRRRtdjango.contrib.gisRtdjango.contrib.gis.db.modelsRt#django.contrib.gis.db.models.fieldsRRRt django.contrib.gis.db.models.sqlR R R R t#django.contrib.gis.geometry.backendR tdjango.contrib.gis.measureRRt django.utilsRRRR&(((s;../Django//lib/python/django/contrib/gis/db/models/query.pyts"ÿÿù