Dvg@PddlZddlmZddlmZddlmZddlmZm Z ddl m Z ddl m Z ddlmZdd lmZdd lmZdd lmZmZdd lmZdd lmZddlmZmZddlmZddl m!Z!ddl"m#Z#ddl$m%Z%m&Z&ddl'm(Z(dZ)GddeZ*GddeZ+GddeeZ,dS)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 bilateralc6eZdZdfd ZfdZdZdZxZS)PostGISOperatorFc V||_||_tjdi|dS)N) geographyrastersuper__init__)selfr r!kwargs __class__s n/var/www/pixelcanvas.ch/venv/lib/python3.11/site-packages/django/contrib/gis/db/backends/postgis/operations.pyr#zPostGISOperator.__init__s8#  ""6"""""c|||}|||}tj|||g|RSN) check_rastercheck_geographyr"as_sql)r$ connectionlookuptemplate_paramsargsr&s r'r-zPostGISOperator.as_sql(sO++FODD..vGGuww~j&/IDIIIIr(c"|jo|jddk}|jjjdk}t |jt }|j-|r+|jstd|dd|j|d<|j -|r+|jstd|dd|j |d<|j r|r!|rd|dz|d<|rd|dz|d<n5|j tkr%|r|sd|dz|d<n|r|sd|dz|d<|S) NspheroidRASTERzFBand indices are not allowed for this operator, it works on bbox only.lhsz, rhszST_Polygon(%s)) rhs_paramsr6field geom_type isinstancer7rband_lhsfunc ValueErrorband_rhsr! BILATERAL)r$r/r0r4 lhs_is_raster rhs_is_rasters r'r+zPostGISOperator.check_raster-s$L):2)>*)L (2h> "6:z::  ? &= &9    &&&&OE " ? &= &9    &&&&OE " { Sh S S)9OEZed?Zed@ZdAZdBZdCZdDZdEZdFZdGZ dHZ!dIZ"dJZ#dKZ$dLZ%dMZ&dNZ'dOZ(dPZ)dQZ*fdRZ+e,dSZ-dTZ.dUZ/xZ0S)VPostGISOperationspostgisTST_CollectExtent3DExtent3DLengthMakeLine 3DPerimeterUnion bbcontains~)opr! bboverlapsz&&)rcr r! contained@ overlaps_leftz&<overlaps_rightz&>overlaps_belowz&<|)rcoverlaps_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::byteaNcddddddd}|S)N ST_AsBinary ST_AsTextST_MinimumBoundingCircleST_GeomFromWKBST_GeomFromText ST_NPoints)AsWKBAsWKTBoundingCircleFromWKBFromWKT NumPointsr)r$function_namess r'rz PostGISOperations.function_namess*# 8'(%   r(cttdr tj}ne|d |}n0#t $r#t d|jjdzwxYw|dd}|S)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 3.0. Was the database created from a spatial database template?NAMErN) hasattrrr_get_postgis_funcpostgis_version_tuplerr r. settings_dict)r$rvtups r'spatial_versionz!PostGISOperations.spatial_versions 8. / / .GG  " "9 - - - 1133#   * #'/"?"G H 122hGs A-A;c|dS|ddd\}}tt|\}}tt|\}}||||fS)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)". Nr3,splitmapfloat)r$boxllurxminyminxmaxymaxs r'convert_extentz PostGISOperations.convert_extentsp ;4QrT%%B ++ d ++ ddD$''r(c|dS|ddd\}}tt|\}}}tt|\}}} |||||| fS)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)". Nr3rr) r$box3drrrrzminrrzmaxs r'convert_extent3dz"PostGISOperations.convert_extent3ds| =4qt""3''Bubhhjj11dDubhhjj11dDdD$d33r(c|jdkrdS|jdkr |jdz}n|j}|jr&|jdkrt dd||jfzSd||jfzS) zM Return the database field type for the given spatial field. r5r!Ziz=PostGIS only supports geography columns with an SRID of 4326.zgeography(%s,%d)zgeometry(%s,%d))r:dimr rNr )r$fr:s r' geo_db_typezPostGISOperations.geo_db_types ;( " "8 5A:: c)II I ; ;v~~'S&AF(;; ;$ 16':: :r(cP|d}||j}|j}t|trd|r|j}n\|r|dkrt d|j}n=t|t j| |j}n|}|gS)a 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.) geodeticr.r r;r mr>getattr unit_attname units_name)r$rdist_val lookup_typerQrr dist_params r' get_distancezPostGISOperations.get_distances ::do..K eX & &  "W  )++$A#W $80do1N1NOO J|r(c|d}t|dr'|jj|jkrd}n |d|jd}|S|d}n|j}| ||jkrd}n |d|jd}|S)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_namerr9rN)r$rrQcompilertransform_func placeholder value_srids r'get_geom_placeholderz&PostGISOperations.get_geom_placeholder+s 33K@@ 5( # # {16))" /=~~qvvvF   =JJJ  qv!5!5KK+9>>1666BKr(c|j5}|d|z|dcdddS#1swxYwYdS)zZ Helper routine for calling PostGIS functions and returning their result. z SELECT %s()rN)r.temporary_connectionexecutefetchone)r$r=cursors r'rz#PostGISOperations._get_postgis_funcHs _ 1 1 3 3 (v NN=4/ 0 0 0??$$Q' ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( ( (s2AA Ac,|dS)z9Return the version of the GEOS library used with PostGIS.postgis_geos_versionrrTs r'rz&PostGISOperations.postgis_geos_versionQ%%&<===r(c,|dS)zFReturn the version number of the PostGIS library used with PostgreSQL.postgis_lib_versionrrTs r'rz%PostGISOperations.postgis_lib_versionUs%%&;<<.convertersG%%% . W-- =44.>ttE{{J.W.W Wr()r r rDr)r$rr rr s @@r'get_geometry_converterz(PostGISOperations.get_geometry_convertersFww|,7  X X X X X X r(cdS)Nsq_mr)r$r9s r'get_area_att_for_fieldz(PostGISOperations.get_area_att_for_fieldsvr()1rErFrGnamerXrrAdaptercollectextentrlength3dmakeline perimeter3dunionaggrr@ gis_operatorssetunsupported_functionsrselect select_extentrrrrrrrrrrrrrrrrrrrrr staticmethodrr rrHrIs@r'rWrWss DGG*G  (F*,H*,H*,H"]2K')H!ooT:::!oodKKK! __D999! DCCC ! //T)DDD ! //U333 ! //U333! 4(((! D)))! //U333! //U333! ??d9===! D;;;! OOyIII! __&y   !$ __4    %!* //{d9UUU+!,#? 555#OyIII!/{333%o D   $OyIII!/{333"? YGGG!/{9EEE"? YWWWA!!!MF CEE 1TTkFM  _ _: ( ( ( 4 4 4;;;.###J:(((>>>===>>>999>>>777 N N N444&&&$$$$$$     55\5   r(rW)-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.versionradapterrmodelsrrpgrasterrr@rrKrWrr(r'r/s PPPPPP@@@@@@CCCCCCCC......======777777//////77777799999999GGGGGGAAAAAA((((((((333333222222######@@@@@@@@######  EEEEEoEEEP I I I I I I I I ttttt-/Atttttr(