:orphan:



.. _sphx_glr_gallery:

.. _gallery:

Gallery
=======



.. raw:: html

    <div class="sphx-glr-thumbcontainer" tooltip="Sometimes the application wants to apply a function in an insert or in a select. For example, t...">

.. only:: html

 .. figure:: /gallery/images/thumb/sphx_glr_test_type_decorator_thumb.png
     :alt: Automatically use a function at insert or select

     :ref:`sphx_glr_gallery_test_type_decorator.py`

.. raw:: html

    </div>


.. toctree::
   :hidden:

   /gallery/test_type_decorator

.. raw:: html

    <div class="sphx-glr-thumbcontainer" tooltip="It is possible to insert a geometry and ask PostgreSQL to compute its length at the same time. ...">

.. only:: html

 .. figure:: /gallery/images/thumb/sphx_glr_test_length_at_insert_thumb.png
     :alt: Compute length on insert

     :ref:`sphx_glr_gallery_test_length_at_insert.py`

.. raw:: html

    </div>


.. toctree::
   :hidden:

   /gallery/test_length_at_insert

.. raw:: html

    <div class="sphx-glr-thumbcontainer" tooltip="The RasterElement objects store the Raster data in WKB form. When using rasters it is usually b...">

.. only:: html

 .. figure:: /gallery/images/thumb/sphx_glr_test_decipher_raster_thumb.png
     :alt: Decipher Raster

     :ref:`sphx_glr_gallery_test_decipher_raster.py`

.. raw:: html

    </div>


.. toctree::
   :hidden:

   /gallery/test_decipher_raster

.. raw:: html

    <div class="sphx-glr-thumbcontainer" tooltip="If the application wants to build queries with GeoAlchemy 2 and gets them as strings, the wrapp...">

.. only:: html

 .. figure:: /gallery/images/thumb/sphx_glr_test_disable_wrapping_thumb.png
     :alt: Disable wrapping in select

     :ref:`sphx_glr_gallery_test_disable_wrapping.py`

.. raw:: html

    </div>


.. toctree::
   :hidden:

   /gallery/test_disable_wrapping

.. raw:: html

    <div class="sphx-glr-thumbcontainer" tooltip="Some functions have different names depending on the dialect. But sometimes one function in one...">

.. only:: html

 .. figure:: /gallery/images/thumb/sphx_glr_test_specific_compilation_thumb.png
     :alt: Function translation for specific dialect

     :ref:`sphx_glr_gallery_test_specific_compilation.py`

.. raw:: html

    </div>


.. toctree::
   :hidden:

   /gallery/test_specific_compilation

.. raw:: html

    <div class="sphx-glr-thumbcontainer" tooltip="The ST_Transform() function (and a few others like ST_SnapToGrid()) can be used on both Geometr...">

.. only:: html

 .. figure:: /gallery/images/thumb/sphx_glr_test_raster_transform_thumb.png
     :alt: Reproject a Raster using ST_Transform

     :ref:`sphx_glr_gallery_test_raster_transform.py`

.. raw:: html

    </div>


.. toctree::
   :hidden:

   /gallery/test_raster_transform

.. raw:: html

    <div class="sphx-glr-thumbcontainer" tooltip="Some functions return composite types. This example shows how to deal with this kind of functio...">

.. only:: html

 .. figure:: /gallery/images/thumb/sphx_glr_test_summarystatsagg_thumb.png
     :alt: Use CompositeType

     :ref:`sphx_glr_gallery_test_summarystatsagg.py`

.. raw:: html

    </div>


.. toctree::
   :hidden:

   /gallery/test_summarystatsagg
.. raw:: html

    <div class="sphx-glr-clear"></div>



.. only:: html

 .. rst-class:: sphx-glr-signature

    `Gallery generated by Sphinx-Gallery <https://sphinx-gallery.github.io>`_
