_V&@sddlZddlmZddlmZmZmZmZddlm Z ddl m Z m Z m Z mZddlmZddlmZmZddlmZdd lmZdd lmZdd lmZdd lmZdd lmZm Z GdddeZ!dS)N) aggregates) GeometryFieldLineStringField PointField get_srid_info) GISLookup) AreaField DistanceField GeomFieldGMLField)Geometry)AreaDistance) connections)RawSQL)Field)QuerySet)six)RemovedInDjango20WarningRemovedInDjango110Warningc@s>eZdZdZdddZddZddZd d Zd d Zd dZ ddZ ddZ ddZ dddddZ dddZddddZdd Zd!d"Zd#d$Zd%d&Zd'd(Zd)d*Zd+d,Zd-d.Zd/d0Zd1d2Zd3d4d5Zd6d7Zddd8d9Zd:d;Zd3d<d=Zd>d?d@ZdAdBZ dCdDZ!dEdEdEdFdGZ"dEdEddHdIZ#dEdEdJdKZ$dEdddLdMZ%ddNdOZ&ddPdQZ'dRdSZ(dEdTdUZ)dEdEdVdWZ*dES)X GeoQuerySetzThe Geographic QuerySet.g?cKs |jdd|jd\}}i|d6|d6dd6}t|j}|j}|jrd|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. distance)_distance_attribute)r,r=r-r1r1r2r>UszGeoQuerySet.distancecKs|jd|S)z Returns a Geometry representing the bounding box of the Geometry field in an `envelope` attribute on each element of the GeoQuerySet. envelope)r4)r,r-r1r1r2r@gszGeoQuerySet.envelopecKs)tjdtdd|jtj|S)z 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). zoThe extent GeoQuerySet method is deprecated. Use the Extent() aggregate in an aggregate() or annotate() method.r5r6)r7r8rr9rZExtent)r,r-r1r1r2extentos zGeoQuerySet.extentcKs)tjdtdd|jtj|S)z 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). zsThe extent3d GeoQuerySet method is deprecated. Use the Extent3D() aggregate in an aggregate() or annotate() method.r5r6)r7r8rr9rZExtent3D)r,r-r1r1r2extent3d{s zGeoQuerySet.extent3dcKs|jd|S)z 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. force_rhr)r4)r,r-r1r1r2rCszGeoQuerySet.force_rhrFcKst|jj}|js(tdnt|tjsItdnd}|rd|rdd}n|rsd}n|rd}nidd6i|d 6|d 6d 6d d 6}|j d||S)a\ Returns a GeoJSON representation of the geometry field in a `geojson` attribute on each element of the GeoQuerySet. The `crs` and `bbox` keywords may be set to True if the user wants the coordinate reference system and the bounding box to be included in the GeoJSON representation of the geometry. zFOnly PostGIS 1.3.4+ and SpatiaLite 3.0+ support GeoJSON serialization.z.Precision keyword must be set with an integer.rr6ZGeoJSONdesc precisionoptionsrz%%(geo_col)s,%(precision)s,%(options)srgeojson) rr!r"rJNotImplementedError isinstancer integer_types TypeErrorr+)r,rHZcrsZbboxr-r0rIr.r1r1r2rJs        zGeoQuerySet.geojsoncKs5idd6i|d6d6dd6}|jd||S)a 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. ZGeoHashrGrHrz%(geo_col)s,%(precision)srgeohash)r+)r,rHr-r.r1r1r2rPs  zGeoQuerySet.geohashr6cKst|jj}idd6i|d6d6}|jrYd|dAs z,GeoQuerySet.snap_to_grid..z@Size argument(s) for the grid must be a float or integer values.rFrz%(geo_col)s,%(size)ssizer6z%(geo_col)s,%(xsize)s,%(ysize)sxsizeysizez7%(geo_col)s,%(xorigin)s,%(yorigin)s,%(xsize)s,%(ysize)sxoriginyoriginz4Must provide 1, 2, or 4 arguments to `snap_to_grid`.rrr snap_to_grid)rNlen ValueErrorr r+) r,argsr-nargsrjrrrkrlrnror.r1r1r2rp8s*          zGeoQuerySet.snap_to_gridcKsott|}t|tjs3tdnidd6dd6i|d6|d6d6}|jd ||S) a 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). z2SVG precision keyword argument must be an integer.ZSVGrGz!%(geo_col)s,%(rel)s,%(precision)srrelrHrsvg)intboolrLrrMrNr+)r,ZrelativerHr-r.r1r1r2rv\s zGeoQuerySet.svgcKs|jd||S)z Returns the symmetric difference of the geographic field in a `sym_difference` attribute on each element of this GeoQuerySet. sym_difference)r<)r,r=r-r1r1r2ryuszGeoQuerySet.sym_differencecKst|jjjr]|dkr.tdnidd6i|d6|d6d6td6}n3id d6i|d6|d6|d 6d6td6}|jd ||S) zr Translates the geometry to a new location using the given numeric parameters as offsets. gz+SpatiaLite does not support 3D translation.z%(geo_col)s,%(x)s,%(y)srrbrcrrz%(geo_col)s,%(x)s,%(y)s,%(z)srd translate)rr!r"r%rKr r+)r,rbrcrdr-r.r1r1r2rz|s    zGeoQuerySet.translateicKs`t|tjs!tdn|jd}|jdd||jjd||jS)z Transforms the given geometry field to the given SRID. If no SRID is provided, the transformation will default to using 4326 (WGS84). z!An integer SRID must be provided.r transformtransformed_srid) rLrrMrNr rqueryZ add_contextZ_clone)r,sridr-rr1r1r2r{s zGeoQuerySet.transformcKs|jd||S)z Returns the union of the geographic field with the given Geometry in a `union` attribute on each element of this GeoQuerySet. union)r<)r,r=r-r1r1r2rszGeoQuerySet.unioncKs)tjdtdd|jtj|S)z Performs an aggregate union on the given geometry field. Returns None if the GeoQuerySet is empty. The `tolerance` keyword is for Oracle backends only. zpThe unionagg GeoQuerySet method is deprecated. Use the Union() aggregate in an aggregate() or annotate() method.r5r6)r7r8rr9rUnion)r,r-r1r1r2unionaggs zGeoQuerySet.unionaggNc Cst|j}t|j|d}|dkr7|}n|s\td||jjfni|d6}|j|}|std|n|dk rt|| rtd||j fn|j |||d<||fS)zE Performs set up for executing the spatial function. FNz4%s stored procedure not available on the %s backend.functionz+%s output only available on GeometryFields.z1"%s" stored procedures may only be called on %ss.Zgeo_col) rr!getattrr"rKname _geo_fieldrNrL__name___geocol_select) r,attrGrrWr/funcrrr1r1r2rs    zGeoQuerySet._spatial_setupcCs|j|}|s+td|jn|dk rft|| rftd|j|jfn|pr|j}i}t|jjjr||dtj |D] \}} |dj|| qWn |d}t |tj s)|}nx|dD]} |j |d| } |j d| d|} |j| d|} d| }| d}|d j|||d <|d j| q4Wd|d }|jdr|d}|jjr d|_q n t}|jjt||d|d |||S)a DRY routine for calling a spatial stored procedure on a geometry column and attaching its output as an attribute of the model. Arguments: att: The name of the spatial attribute that holds the spatial SQL function to call. settings: Dictionary of internal settings to customize for the spatial procedure. Public Keyword Arguments: field_name: The name of the geographic field to call the spatial function on. May also be a lookup to a geometry field as part of a foreign key relation. model_att: The name of the model attribute to attach the output of the spatial function to. zxThe %s GeoQuerySet method is deprecated. See GeoDjango Functions documentation to find the expression-based replacement.r5r6rGN geom_argsZ geom_fieldrrz %(geo_col)s select_paramsrTrrWrcontainsr/z%%(%s)sz%%sz%%(function)s(%s)rF)r7r8rrarr!r rr iteritemsrL string_typesget_prep_valueget_db_prep_lookupZget_placeholderreplaceextendr"r#Zempty_strings_allowedrr}Zadd_annotationr)r,rsettingsrr^r/Z default_argsrkvrr=paramsZgeom_placeholderZold_fmtZnew_fmtfmtrr1r1r2r+sL          zGeoQuerySet._spatial_attributecKs|j|d|jd\}}t|j}|j|} |j} | rXd} ntj|j|} |dk} |dk} |dk}| p| p|st d|n|j dk}|pdd g}|j }|s|j r| r| r| r|j d n|j|}|jd |d |}t|}|jr| r`d }n| sl|rud}n||drVr\zUnknown distance function: %srEz POINT (0 0)rspheroidZ distance_lter/z"%(geo_col)s,%(geom)s,%(tolerance)sz%(geo_col)s,%(tolerance)srr|z[This database does not support linear distance calculations on geodetic coordinate systems.Fz%s(%%(geo_col)s, %s)Nz, %s(%%%%s, %s)z, %%sz, %s(%s(%%%%s, %s), %s)z%(geo_col)s,%(geom)sz=Spherical distance calculation only supported on PointFields.ZPointzLSpherical distance calculation only supported with Point Geometry parametersz,'%(spheroid)s'rrFz %(geo_col)srrrrrr=rr)zgeom)/rr rr!r'r&rr(r)rrZdimr"r$appendrrrxr#r}Z get_contextrlowerZgeodetic_unitsfeaturesZsupports_distance_geodeticr{r~r%Z from_textrLrstrr r memoryviewZewkbZ geom_typeupdateZdistance_spheroidZdistance_sphereZlength_spheroidZsupports_3d_functionsZ perimeter3dZlength3dr ZAdapterr+)r,rr=rrr-rrr/r'r&Zdist_attr>rVr\Zgeom_3dZ lookup_paramsr0rrrr~uZ unit_namer.r1r1r2r?Es$                     + %  %   zGeoQuerySet._distance_attributecKsTitd6}t|jjjrAd|dr@rArBrCrJrPrRrSrTrVrXrYrZr[r\r]r_rerprvryrzr{rrrr9r+r?r4r<rrrr1r1r1r2rsR              $   !W  r)"r7Zdjango.contrib.gis.db.modelsrZ#django.contrib.gis.db.models.fieldsrrrrZ$django.contrib.gis.db.models.lookupsrZ django.contrib.gis.db.models.sqlrr r r Z#django.contrib.gis.geometry.backendr Zdjango.contrib.gis.measurer rZ django.dbrZdjango.db.models.expressionsrZdjango.db.models.fieldsrZdjango.db.models.queryrZ django.utilsrZdjango.utils.deprecationrrrr1r1r1r2s ""