3 (h~@sddlZddlmZmZmZmZddlmZddlm Z m Z m Z m Z ddl mZddlmZmZddlmZddlmZdd lmZdd lmZdd lmZdd lmZdd lmZGdddeZ dS)N) GeometryFieldLineStringField PointField get_srid_info) GISLookup) AreaField DistanceField GeomFieldGMLField)Geometry)AreaDistance) connections) LOOKUP_SEP)RawSQL)Field)QuerySet)six)RemovedInDjango20Warningc@s6eZdZdZdLddZddZddZd d Zd d Zd dZ dMddZ dNddZ dOddZ ddZ ddZddZdd Zd!d"Zd#d$Zd%d&Zd'd(Zd)d*ZdPd,d-Zd.d/ZdQd0d1Zd2d3ZdRd4d5ZdSd7d8Zd9d:ZdTdd?ZdVd@dAZdWdBdCZ dXdDdEZ!dFdGZ"dYdHdIZ#dZdJdKZ$d;S)[ GeoQuerySetzThe Geographic QuerySet.皙?cKs|jd|jdd\}}||dd}t|j}|j}|jr\d|d<||dd <td |d <nL|jsh|jr|j r|td |d <n,|j |stt j |j ||d <ntd |jd|f|S) z~ Returns the area of the geographic field in an `area` attribute on each element of this GeoQuerySet. area field_name)rF)procedure_args geo_fieldsetupz%(geo_col)s,%(tolerance)s procedure_fmtr toleranceZsq_m select_fieldz2Area on geodetic coordinate systems not supported.)_spatial_setupgetrdbopsoraclerpostgis spatialite geographygeodeticr unit_attname units_name Exception_spatial_attribute)selfrkwargsrrs connectionbackendr1F/tmp/pip-install-q3hcpn_q/Django/django/contrib/gis/db/models/query.pyrs$    zGeoQuerySet.areacKs |jd|S)z Returns the centroid of the geographic field in a `centroid` attribute on each element of this GeoQuerySet. centroid)r3)_geom_attribute)r,r-r1r1r2r38szGeoQuerySet.centroidcKs|jd|f|S)z Returns the spatial difference of the geographic field in a `difference` attribute on each element of this GeoQuerySet. difference)_geomset_attribute)r,geomr-r1r1r2r5?szGeoQuerySet.differencecKs|jd|f|S)a~ Returns the distance from the given geographic field name to the given geometry in a `distance` attribute on each element of the GeoQuerySet. Keyword Arguments: `spheroid` => 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,r7r-r1r1r2r8FszGeoQuerySet.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)r:)r4)r,r-r1r1r2r:XszGeoQuerySet.envelopecKs |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)r;)r4)r,r-r1r1r2r;`szGeoQuerySet.force_rhrFcKstt|jj}|jstdt|tjs.tdd}|r@|r@d}n|rJd}n|rRd}d||dd d }|j d |f|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. z:Only PostGIS and SpatiaLite support GeoJSON serialization.z.Precision keyword must be set with an integer.rZGeoJSON) precisionoptionsz%%(geo_col)s,%(precision)s,%(options)s)descrrgeojson) rr!r"rCNotImplementedError isinstancer integer_types TypeErrorr+)r,r@ZcrsZbboxr-r0rAr.r1r1r2rCis  zGeoQuerySet.geojsoncKs dd|idd}|jd|f|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. ZGeoHashr@z%(geo_col)s,%(precision)s)rBrrgeohash)r+)r,r@r-r.r1r1r2rIszGeoQuerySet.geohashr?cKsVt|jj}dd|id}|jr6d|d<||d|d<|jrFt|d<|jd |f|S) z Returns GML representation of the given field in a `gml` attribute on each element of the GeoQuerySet. ZGMLr@)rBrz%%(version)s,%(geo_col)s,%(precision)sr)r@versionrrgml)rr!r"r$r#r r+)r,r@rJr-r0r.r1r1r2rKs  zGeoQuerySet.gmlcKs|jd|f|S)z Returns the spatial intersection of the Geometry field in an `intersection` attribute on each element of this GeoQuerySet. intersection)r6)r,r7r-r1r1r2rLszGeoQuerySet.intersectioncKs(ddd|jddid}|jd|f|S)z Returns KML representation of the geometry field in a `kml` attribute on each element of this GeoQuerySet. ZKMLz%(geo_col)s,%(precision)sr@r<)rBrrkml)popr+)r,r-r.r1r1r2rMszGeoQuerySet.kmlcKs |jd|S)z Returns the length of the geometry field as a `Distance` object stored in a `length` attribute on each element of this GeoQuerySet. lengthN)rON)r9)r,r-r1r1r2rOszGeoQuerySet.lengthcKs|jdif|S)z Returns the memory size (number of bytes) that the geometry field takes in a `mem_size` attribute on each element of this GeoQuerySet. mem_size)r+)r,r-r1r1r2rPszGeoQuerySet.mem_sizecKs|jdif|S)z 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. num_geom)r+)r,r-r1r1r2rQszGeoQuerySet.num_geomcKs|jdif|S)z 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. num_points)r+)r,r-r1r1r2rRszGeoQuerySet.num_pointscKs |jd|S)z Returns the perimeter of the geometry field as a `Distance` object stored in a `perimeter` attribute on each element of this GeoQuerySet. perimeterN)rSN)r9)r,r-r1r1r2rSszGeoQuerySet.perimetercKs |jd|S)z 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. point_on_surface)rT)r4)r,r-r1r1r2rTszGeoQuerySet.point_on_surfacecKs<dti}|jddt|jjjr,t|d<|jd|f|S)z Reverses the coordinate order of the geometry, and attaches as a `reverse` attribute on each element of this GeoQuerySet. r model_att reverse_geomgeo_field_typereverse)r setdefaultrr!r"r#rr+)r,r-r.r1r1r2rVs   zGeoQuerySet.reverse_geomcKsZt|jjjr4|dkrtdd||dtd}nd|||dtd}|jd|f|S) z| Scales the geometry to a new size by multiplying the ordinates with the given x,y,z scale factors. gz'SpatiaLite does not support 3D scaling.z%(geo_col)s,%(x)s,%(y)s)xy)rrrz%(geo_col)s,%(x)s,%(y)s,%(z)s)r[r\zscale)rr!r"r%rDr r+)r,r[r\r]r-r.r1r1r2r^s   zGeoQuerySet.scalec Osddd|Dkrtdt|}|dkr@|d}d}d|i}nP|d kr`|\}}d }||d }n0|d kr|\}}} } d }||| | d}ntd||td} |jd| f|S)ag 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. FcSsg|]}t|tftjqSr1)rEfloatrrF).0argr1r1r2 sz,GeoQuerySet.snap_to_grid..z@Size argument(s) for the grid must be a float or integer values.r>rz%(geo_col)s,%(size)ssizer?z%(geo_col)s,%(xsize)s,%(ysize)s)xsizeysizez7%(geo_col)s,%(xorigin)s,%(yorigin)s,%(xsize)s,%(ysize)s)rdrexoriginyoriginz4Must provide 1, 2, or 4 arguments to `snap_to_grid`.)rrr snap_to_grid)rGlen ValueErrorr r+) r,argsr-nargsrcrrrdrergrhr.r1r1r2ris*      zGeoQuerySet.snap_to_gridcKsBtt|}t|tjs tddd||dd}|jd|f|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.ZSVGz!%(geo_col)s,%(rel)s,%(precision)s)relr@)rBrrsvg)intboolrErrFrGr+)r,Zrelativer@r-r.r1r1r2ro&s   zGeoQuerySet.svgcKs|jd|f|S)z Returns the symmetric difference of the geographic field in a `sym_difference` attribute on each element of this GeoQuerySet. sym_difference)r6)r,r7r-r1r1r2rr?szGeoQuerySet.sym_differencecKsZt|jjjr4|dkrtdd||dtd}nd|||dtd}|jd|f|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)s)r[r\)rrrz%(geo_col)s,%(x)s,%(y)s,%(z)s)r[r\r] translate)rr!r"r%rDr r+)r,r[r\r]r-r.r1r1r2rsFs   zGeoQuerySet.translatecKsBt|tjstd|jd}|jd|d|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 transform)rtransformed_srid) rErrFrGr rqueryZ add_contextZ_clone)r,sridr-rr1r1r2ruYs   zGeoQuerySet.transformcKs|jd|f|S)z Returns the union of the geographic field with the given Geometry in a `union` attribute on each element of this GeoQuerySet. union)r6)r,r7r-r1r1r2ryeszGeoQuerySet.unionNc Cst|j}t|j|d}|dkr$|}|s|r|jj)r|r|j%d |j*in| r|j%d |j+it,| d|||d"}|r$d'|d$<||d%d#<n|r:|j-|g|d&<|j.||f|S)(zJ DRY routine for GeoQuerySet distance attribute routines. r)rmr8rOrSzUnknown distance function: %sr=z POINT (0 0)rspheroidZ distance_lte)r/z"%(geo_col)s,%(geom)s,%(tolerance)sz%(geo_col)s,%(tolerance)srrvz[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'r>)rzrrzz %(geo_col)s)rrrrrr7rrr)r7)/rr rr!r'r&r r(r)rkZdimr"r$appendrrrqr#rwZ get_contextrlowerZgeodetic_unitsfeaturesZsupports_distance_geodeticrurxr%Z from_textrErstrr r memoryviewZewkbZ geom_typeupdateZdistance_spheroidZdistance_sphereZlength_spheroidZsupports_3d_functionsZ perimeter3dZlength3drZAdapterr+)r,rr7rrr-rrr/r'r&Zdist_attr8rOrSZgeom_3dZ lookup_paramsr0rrrrxuZ unit_namer.r1r1r2r9s               zGeoQuerySet._distance_attributecKs<dti}t|jjjr,d|d<d|i|d<|j||f|S)z DRY routine for setting up a GeoQuerySet method that attaches a Geometry attribute (e.g., `centroid`, `point_on_surface`). rz%(geo_col)s,%(tolerance)srrr)r rr!r"r#r+)r,rrr-r.r1r1r2r4~s   zGeoQuerySet._geom_attributecKsNdtdd|id}t|jjjr>|dd7<||dd<|j||f|S) a DRY routine for setting up a GeoQuerySet method that attaches a Geometry attribute and takes a Geoemtry parameter. This is used for geometry set-like operations (e.g., intersection, difference, union, sym_difference). r7z%(geo_col)s,%(geom)s)rrrrrz,%(tolerance)srr)r7)r rr!r"r#r+)r,rr7rr-r.r1r1r2r6s  zGeoQuerySet._geomset_attributecCs|jj|j}|jj}||jkr|jj|jtddg|j x0|j D]&\}}}|j |krJ|j ||j dSqJWtd|n2||jkr|jjj}|j|||jjS|j||SdS)z 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. r>rz(%r not in compiler's related_select_colsN)rwZ get_compilerr!model_metafieldsZadd_select_relatedrsplitrZ pre_sql_setupselectZ output_fieldZas_sqlr/rkZ local_fieldsZconcrete_model _field_columndb_table)r,rrcompileroptscol_Z parent_modelr1r1r2rs    zGeoQuerySet._geocol_selectcCsB|dkr.x |jjjD]}t|tr|SqWdStj|jj|SdS)a' Returns the first Geometry field encountered or the one specified via the `field_name` keyword. The `field_name` may be a string specifying the geometry field on this GeoQuerySet's model, or a lookup string to a geometry field via a ForeignKey relation. NF)rrrrErrZ_check_geo_field)r,rfieldr1r1r2r}s  zGeoQuerySet._geo_fieldcCs6|dkr|jjj}d|j||jjj|p.|jfS)a Helper function that returns the database column for the given field. The table and column are returned (quoted) in the proper format, e.g., `"geoapp_city"."point"`. If `table_alias` is not specified, the database table associated with the model of this `GeoQuerySet` will be used. If `column` is specified, it will be used instead of the value in `field.column`. Nz%s.%s)rwZget_metarZquote_name_unless_aliasr/r"Z quote_namecolumn)r,rrZ table_aliasrr1r1r2rs   zGeoQuerySet._field_column)r)r<FF)rH)r<r?)rZ)Fr<)rZ)rt)NNN)NN)NrF)r)r)N)NN)%r~ __module__ __qualname____doc__rr3r5r8r:r;rCrIrKrLrMrOrPrQrRrSrTrVr^rirorrrsruryrr+r9r4r6rr}rr1r1r1r2rsF       $    ! W   r)!rZ#django.contrib.gis.db.models.fieldsrrrrZ$django.contrib.gis.db.models.lookupsrZ django.contrib.gis.db.models.sqlrrr r Z#django.contrib.gis.geometry.backendr Zdjango.contrib.gis.measurer r Z django.dbrZdjango.db.models.constantsrZdjango.db.models.expressionsrZdjango.db.models.fieldsrZdjango.db.models.queryrZ django.utilsrZdjango.utils.deprecationrrr1r1r1r2s