XI@sMddlZddlmZddlmZddlmZddlmZddl m Z ddl m Z ddl mZdd lmZdd lmZdd lmZdd lmZd dlmZd dlmZmZd dlmZmZmZdZ GdddeZ!Gddde!Z"GdddeeZ#dS)N)settings)BaseSpatialOperations)SpatialOperator) GDALRaster)Geometry)Distance)ImproperlyConfigured)DatabaseOperations)ProgrammingError)six)cached_property)PostGISAdapter)PostGISGeometryColumnsPostGISSpatialRefSys) from_pgrasterget_pgraster_srid to_pgrasterZ bilateralcsFeZdZddfddZfddZddZS)PostGISOperatorFc s,||_||_tt|j|dS)N) geographyrastersuperr__init__)selfrrkwargs) __class___/home/ubuntu/projects/ifolica/build/django/django/contrib/gis/db/backends/postgis/operations.pyrs  zPostGISOperator.__init__csl|jjjr;|j r;td|jp.|jfn|j||}tt|j ||||S)Nz>PostGIS geography does not support the "%s" function/operator.) lhs output_fieldr ValueErrorfuncop check_rasterrras_sql)r connectionlookuptemplate_paramsargs)rrrr$$s zPostGISOperator.as_sqlcCst|jttfr;|jd}|jd dk}n|j}d}|jjjdk}t|t}|jdk r|r|j st dnd|d|jf|ddd?d dd@6ed!d>ddAd ddB6ed!d>ddCd ddD6ed!d>ddEd ddF6ZeZidGdH6dIdJ6dKdL6ZfdMdNZedOdPZdQdRZdSdTZdUdVZdWdXZddYdZZd[d\Zd]d^Zd_d`ZdadbZdcddZdedfZ dgdhZ!didjZ"dkdlZ#dmdnZ$dodpZ%dqdrZ&dsdtZ'dudvZ(S)wPostGISOperationspostgisTZST_z/^(?P\d)\.(?P\d)\.(?P\d+)r"~rZ bbcontainsz&&rZ bboverlaps@Z containedz&Zoverlaps_rightz&<|Zoverlaps_belowz|&>Zoverlaps_abovez<<leftz>>rightz<<|Zstrictly_belowz|>>Zstrictly_abovez~=Zsame_asexactr!Z ST_ContainscontainsZST_ContainsProperlyZcontains_properlyZ ST_CoveredByZ coveredbyZ ST_CoversZcoversZ ST_CrossesZcrossesZ ST_DisjointZdisjointZ ST_EqualsequalsZ ST_IntersectsZ intersectsZ ST_IsValidisvalidZ ST_OverlapsZoverlapsZ ST_RelateZrelateZ ST_TouchesZtouchesZ ST_WithinZwithinZ ST_DWithindwithinZ ST_Distance>Z distance_gtz>=Z distance_gtergeom_func_prefixareaZbounding_circleZcentroidZcollect differenceZdistancerKrLZenvelopeZextentextent3dZ force_rhrZgeohashZgeojsonZgml intersectionrGZkmllengthZlength3drMZmakelineZ makevalidrNZnum_geomZ num_pointsZ perimeterZ perimeter3dZpoint_on_surfaceZ polygonizereverseZscaleZ snap_to_gridsvgZsym_difference transform translateunionZunionagg)rr%prefix)rrrrsR                                       zPostGISOperations.__init__c Cs{ttdrtj}n\|jdy|j}Wn,tk rftd|jjdYnX|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 2.0. Was the database created from a spatial database template?NAMEr N) hasattrrr\_get_postgis_funcpostgis_version_tupler rr%Z settings_dict)rr]Zvtuprrrspatial_versions    z!PostGISOperations.spatial_versionc Csu|dkrdS|ddjd\}}tt|j\}}tt|j\}}||||fS)z Returns 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)". Nr ,r,)splitmapfloat) rZboxsridllurxminyminxmaxymaxrrrconvert_extents  z PostGISOperations.convert_extentc Cs|dkrdS|ddjd\}}tt|j\}}}tt|j\}} } ||||| | fS)z Returns 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)". Nr rdr,)rerfrg) rZbox3drhrirjrkrlZzminrmrnZzmaxrrrconvert_extent3ds  z"PostGISOperations.convert_extent3dcCs!|rt|d|jSdSdS)zI Converts the geometry returned from PostGIS aggregates. rhN)rrh)rhexZ geo_fieldrrr convert_geomszPostGISOperations.convert_geomcCs|jdkrdS|jdkr2|jd}n |j}|jrs|jdkrbtdnd||jfSd||jfSd S) zM Return the database field type for the given spatial field. r*rr7Ziz=PostGIS only supports geography columns with an SRID of 4326.zgeography(%s,%d)zgeometry(%s,%d)N)r1ZdimrrhNotImplementedError)rfr1rrr geo_db_type s  zPostGISOperations.geo_db_typec Cs |d}|j|j}|j}t|tr|rF|j}q|rs|dkrgtdn|j}qt|tj|j |j}n|}|g} |r t |dkr |d} | r |r |dkr | dkr | j d|j q n| S)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. rrHzNOnly numeric values of degree units are allowed on geographic DWithin queries.r r)) r8r%rr-rmr getattrZ unit_attnameZ units_namer:r<r=) rrvZdist_valZ lookup_typeZhandle_spheroidvaluer8rZ dist_paramparamsoptionrrr get_distances$     '  %zPostGISOperations.get_distancecCs|dkrd}n9|jdkrEt|tjrEt|}n |j}|dksi||jkrrd}nP|jdkrt|tjrd|j|jf}nd|j|jf}t|dr|j|\}}||}n|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. Nr*z%sz%s((%%s)::raster, %s)z %s(%%s, %s)r$) r1r-r string_typesrrhrXr_compile)rrvrzcompilerZ value_srid placeholderZsql_rrrget_geom_placeholderHs  !  ! z&PostGISOperations.get_geom_placeholderc Cs;|jj&}|jd||jdSWdQXdS)zZ Helper routine for calling PostGIS functions and returning their result. z SELECT %s()rN)r%Ztemporary_connectionexecuteZfetchone)rr!cursorrrrr`hsz#PostGISOperations._get_postgis_funccCs |jdS)z:Returns the version of the GEOS library used with PostGIS.postgis_geos_version)r`)rrrrrqsz&PostGISOperations.postgis_geos_versioncCs |jdS)zGReturns the version number of the PostGIS library used with PostgreSQL.postgis_lib_version)r`)rrrrrusz%PostGISOperations.postgis_lib_versioncCs |jdS)zis   - *          r>)$rZ django.confrZ.django.contrib.gis.db.backends.base.operationsrZ$django.contrib.gis.db.backends.utilsrZdjango.contrib.gis.gdalrZ#django.contrib.gis.geometry.backendrZdjango.contrib.gis.measurerZdjango.core.exceptionsrZ(django.db.backends.postgresql.operationsr Zdjango.db.utilsr Z django.utilsr Zdjango.utils.functionalr adapterrmodelsrrZpgrasterrrrr2rr6r>rrrrs$ >