R j@<SSKrSSKJr SSKJr SSKJr SSKJrJ r SSK J r SSK J r SSKJr SS KJr SS KJr SS KJrJr SS KJr SS KJr SSKJrJr SSKJr SSK J!r! SSK"J#r# SSK$J%r%J&r& SSK'J(r( Sr)"SS\5r*"SS\5r+"SS\\5r,g)N)settings)BaseSpatialOperations)SpatialOperator) GeometryField RasterField) GDALRaster)GEOSGeometryBase)wkb_r)Distance)ImproperlyConfigured)NotSupportedErrorProgrammingError)DatabaseOperations) is_psycopg3)FuncValue)cached_property)get_version_tuple)PostGISAdapter)PostGISGeometryColumnsPostGISSpatialRefSys from_pgraster bilateralcD^\rSrSrSU4SjjrU4SjrSrSrSrU=r $)PostGISOperatorc >>XlX l[TU] "S0UD6 g)N) geographyrastersuper__init__)selfr!r"kwargs __class__s ]D:\diplom_project\venv\Lib\site-packages\django/contrib/gis/db/backends/postgis/operations.pyr$PostGISOperator.__init__s!#   "6"cl>URX#5nURX#5n[TU] "XU/UQ76$N) check_rastercheck_geographyr#as_sql)r% connectionlookuptemplate_paramsargsr's r(r/PostGISOperator.as_sql(s9++FD..vGw~j/IDIIr*cUR=(a URSS:HnURRRS:Hn[ UR [ 5nURb<U(a5UR(d [S5eUS<SUR<3US'URb<U(a5UR(d [S5eUS<SUR<3US'UR(aU(a&U(a SUS-US'U(a SUS-US'U$UR[:Xa4U(aU(d SUS-US'U$U(aU(d SUS-US'U$) NspheroidRASTERzFBand indices are not allowed for this operator, it works on bbox only.lhsz, rhszST_Polygon(%s)) rhs_paramsr9field geom_type isinstancer:rband_lhsfunc ValueErrorband_rhsr" BILATERAL)r%r1r2r7 lhs_is_raster rhs_is_rasters r(r-PostGISOperator.check_raster-si$$L):):2)>*)L ((22h> "6::z:  ?? &=99   &&OE " ?? &=99   &&OE " {{h)9OE[TU]U5 URSn[U[5(aOUR (d=[ UR [UR RS9S9URS'ggg)Nrsrid)rH) r#r$source_expressionsr>r_output_field_or_nonevaluerrV)r%exprr's r(r$ST_Polygon.__init__fsi &&q) dE " "4+E+E). $**//)J*D # #A &,F "r*cV[URSRRS9$)NrrU)rrWr<rVr%s r(rHST_Polygon.output_fieldns$$"9"9!"<"B"B"G"GHHr*r ) rJrKrLrMfunctionr$rrHrNrOrPs@r(rRrRcs#HIIr*rRc^\rSrSrSrSrSr\r\S-r \S-r \S-r \S-r \S -r \S -r\S -r0S \"S SS9_S\"SSSS9_S\"SSS9_S\"S\S9_S\"S\S9_S\"SS9_S\"SS9_S\"SS9_S\"S S9_S!\"S"S9_S#\"S$S9_S%\"S&\S9_S'\"S&\S9_S(\"S)\S*9_S+\"S,\S*9_S-\"S.S\S/9_S0\"S1S\S/9_\"S2S39\"S4\S*9\"S5S39\"S6S\S/9\"S7\S*9\"S8S39\"S9\S*9\"S:\S*9\"S;S\S/9S<. Er\"5r\(aS=OS>rS?r\S@5r\SA5rSBrSCrSDrSErSFrSGr SHr!SIr"SJr#SKr$SLr%SMr&SNr'SOr(SPr)SQr*SRr+U4SSjr,\-ST5r.SUr/SVr0SWr1U=r2$)XPostGISOperationsspostgisTST_CollectExtent3DExtent3DLengthMakeLine 3DPerimeterUnion bbcontains~)opr" bboverlapsz&&)rnr!r" contained@ overlaps_leftz&<overlaps_rightz&>overlaps_belowz&<|)rnoverlaps_abovez|&>leftz<<rightz>>strictly_belowz<<|strictly_abovez|>>same_asz~=exactcontains ST_Contains)r@r"contains_properlyST_ContainsProperly coveredby ST_CoveredBy)r@r!r"covers ST_Covers ST_Crosses)r@ ST_Disjoint ST_Equals ST_Intersects ST_Overlaps ST_Relate ST_Touches ST_Within ST_DWithin) crossesdisjointequals intersectsoverlapsrelatetoucheswithindwithin%sz %s::byteaNcSSSSSSS.nU$)N ST_AsBinary ST_AsTextST_MinimumBoundingCircleST_GeomFromWKBST_GeomFromText ST_NPoints)AsWKBAsWKTBoundingCircleFromWKBFromWKT NumPointsr )r%function_namess r(r PostGISOperations.function_namess%# 8'(%  r*c[[S5(a[RnU$URS5 UR 5nUSSnU$![ a& [ SURRS-5ef=f)z-Determine the version of the PostGIS library.POSTGIS_VERSIONversionzCannot determine PostGIS version for database "%s" using command "SELECT postgis_lib_version()". GeoDjango requires at least PostGIS version 2.5. Was the database created from a spatial database template?NAMErN) hasattrrr_get_postgis_funcpostgis_version_tuplerr r0 settings_dict)r%rvtups r(spatial_version!PostGISOperations.spatial_versions 8. / /..G$  " "9 - 11312hG$ * #'//"?"?"G H s A0BcUcgUSSRS5up#[[UR55upE[[UR55upgXEXg4$)z Return a 4-tuple extent for the `Extent` aggregate by converting the bounding box text returned by PostGIS (`box` argument), for example: "BOX(-90.0 30.0, -85.0 40.0)". Nr6,splitmapfloat)r%boxllurxminyminxmaxymaxs r(convert_extent PostGISOperations.convert_extentsU ;Qr% +  + D''r*cUcgUSSRS5up#[[UR55upEn[[UR55upxn XEXgX4$)z Return a 6-tuple extent for the `Extent3D` aggregate by converting the 3d bounding-box text returned by PostGIS (`box3d` argument), for example: "BOX3D(-90.0 30.0 1, -85.0 40.0 2)". Nr6rr) r%box3drrrrzminrrzmaxs r(convert_extent3d"PostGISOperations.convert_extent3ds_ =q""3'ubhhj1Dubhhj1DD33r*cURS:XagURS:XaURS-nO URnUR(a+URS:wa [ S5eSX!R4-$SX!R4-$) z= Return the database field type for the given spatial field. r8r"Ziz=PostGIS only supports geography columns with an SRID of 4326.zgeography(%s,%d)zgeometry(%s,%d))r=dimr!rVr )r%fr=s r( geo_db_typePostGISOperations.geo_db_types ;;( " 55A: c)I I ;;vv~'S&FF(;; ;$ 66':: :r*cUSnURUR5nURn[U[5(azU(aUR nU/$U(a US:Xa [ S5eUR nU/$[U[R"URUR555nU/$UnU/$)ae Retrieve the distance parameters for the given geometry field, distance lookup value, and the distance lookup type. This is the most complex implementation of the spatial backends due to what is supported on geodetic geometry columns vs. what's available on projected geometry columns. In addition, it has to take into account the geography column type. rrzNOnly numeric values of degree units are allowed on geographic DWithin queries.) geodeticr0r!r>r mrAgetattr unit_attname units_name)r%rdist_val lookup_typerYrr! dist_params r( get_distancePostGISOperations.get_distances ::doo.KK eX & &"WW |)+$A#WW |%800doo1NO |J|r*c>URS5n[US5(a>URRUR:XaSnU$U<SUR<S3nU$UcSnO URnUbXaR:XaSnU$U<SUR<S3nU$)z Provide a proper substitution value for Geometries or rasters that are not in the SRID of the field. Specifically, this routine will substitute in the ST_Transform() function call. Transformr/rz(%s, )N)spatial_function_namerr<rV)r%rrYcompilertransform_func placeholder value_srids r(get_geom_placeholder&PostGISOperations.get_geom_placeholder+s 33K@ 5( # #{{166)"  0>qvvF   =JJ  vv!5K,:166BKr*cURR5nURSU-5 UR5SsSSS5 $!,(df  g=f)zJ Helper routine for calling PostGIS functions and returning their result. z SELECT %s()rN)r0temporary_connectionexecutefetchone)r%r@cursors r(r#PostGISOperations._get_postgis_funcHsB __ 1 1 3v NN=4/ 0??$Q'4 3 3s 'A  Ac$URS5$)z9Return the version of the GEOS library used with PostGIS.postgis_geos_versionrr]s r(r&PostGISOperations.postgis_geos_versionQ%%&<==r*c$URS5$)zFReturn the version number of the PostGIS library used with PostgreSQL.postgis_lib_versionrr]s r(r%PostGISOperations.postgis_lib_versionUs%%&;<[TU]"URU5URU540UD6$r,)r#distance_expr_for_lookup_normalize_distance_lookup_arg)r%r9r:r&r's r(r*PostGISOperations.distance_expr_for_lookups;w/  / / 4  / / 4   r*c[US5(aURRS:HO[U[5nU(a [ U5$U$)Nr<r8)rr<r=r>rrR)arg is_rasters r(r0PostGISOperations._normalize_distance_lookup_argsGsG$$ II  8 +C,  #,z#44r*cl^^[5RmURRmUU4SjnU$)Nc~>[U[5(aURS5nUcS$[T"U5T5$)Nascii)r>strencoder )rY expressionr0 geom_classreads r( converter;PostGISOperations.get_geometry_converter..converters9%%% W- =4 W.>tE{J.W Wr*)r r)rHr()r%r'r*r(r)s @@r(get_geometry_converter(PostGISOperations.get_geometry_converters-w||,,77  X r*cg)Nsq_mr )r%r<s r(get_area_att_for_field(PostGISOperations.get_area_att_for_fieldsr*r )3rJrKrLrMnamercr rAdaptercollectextentr length3dmakeline perimeter3dunionaggrrC gis_operatorssetunsupported_functionsrselect select_extentrrrrrrrrrrrrrrrrrrrrr staticmethodrr,r0rNrOrPs@r(rarass DGG*G  (F*,H*,H*,H"]2K')H!oT:!odK! _D9! DC ! /T)D ! /U3 ! /U3! 4(! D)! /U3! /U3! ?d9=! D;! OyI! _&y !$ _4  %!* /{d9U+!,# 5#yI!{3% D $yI!{3" YG!{9E" YWA!MF E TkFM  : ( 4;.#J:(>=>9>7 N4&$$ 55 r*ra)-r django.confr.django.contrib.gis.db.backends.base.operationsr$django.contrib.gis.db.backends.utilsrdjango.contrib.gis.db.modelsrrdjango.contrib.gis.gdalr django.contrib.gis.geos.geometryr %django.contrib.gis.geos.prototypes.ior django.contrib.gis.measurer django.core.exceptionsr django.dbr r(django.db.backends.postgresql.operationsr)django.db.backends.postgresql.psycopg_anyrdjango.db.modelsrrdjango.utils.functionalrdjango.utils.versionradapterrmodelsrrpgrasterrrCrrRrar r*r(rRst P@C.=7/79GA(32#@#  EoEP I I t-/Atr*