Types¶
This module defines the geoalchemy2.types.Geometry
,
geoalchemy2.types.Geography
, and geoalchemy2.types.Raster
classes, that are used when defining geometry, geography and raster
columns/properties in models.
Reference¶
-
class
geoalchemy2.types.
CompositeType
[source]¶ Bases:
sqlalchemy.sql.type_api.UserDefinedType
A wrapper for
geoalchemy2.elements.CompositeElement
, that can be used as the return type in PostgreSQL functions that return composite values.This is used as the base class of
geoalchemy2.types.GeometryDump
.-
typemap
= {}¶ Dictionary used for defining the content types and their corresponding keys. Set in subclasses.
-
-
class
geoalchemy2.types.
Geography
(geometry_type='GEOMETRY', srid=-1, dimension=2, spatial_index=True, management=False, use_typmod=None)[source]¶ Bases:
geoalchemy2.types._GISType
The Geography type.
Creating a geography column is done like this:
Column(Geography(geometry_type='POINT', srid=4326))
See
geoalchemy2.types._GISType
for the list of arguments that can be passed to the constructor.-
as_binary
= 'ST_AsBinary'¶ The “as binary” function to use. Used by the parent class’
column_expression
method.
-
from_text
= 'ST_GeogFromText'¶ The
FromText
geography constructor. Used by the parent class’bind_expression
method.
-
name
= 'geography'¶ Type name used for defining geography columns in
CREATE TABLE
.
-
-
class
geoalchemy2.types.
Geometry
(geometry_type='GEOMETRY', srid=-1, dimension=2, spatial_index=True, management=False, use_typmod=None)[source]¶ Bases:
geoalchemy2.types._GISType
The Geometry type.
Creating a geometry column is done like this:
Column(Geometry(geometry_type='POINT', srid=4326))
See
geoalchemy2.types._GISType
for the list of arguments that can be passed to the constructor.-
as_binary
= 'ST_AsEWKB'¶ The “as binary” function to use. Used by the parent class’
column_expression
method.
-
from_text
= 'ST_GeomFromEWKT'¶ The “from text” geometry constructor. Used by the parent class’
bind_expression
method.
-
name
= 'geometry'¶ Type name used for defining geometry columns in
CREATE TABLE
.
-
-
class
geoalchemy2.types.
GeometryDump
[source]¶ Bases:
geoalchemy2.types.CompositeType
The return type for functions like
ST_Dump
, consisting of a path and a geom field. You should normally never use this class directly.-
typemap
= {'path': ARRAY(Integer()), 'geom': <class 'geoalchemy2.types.Geometry'>}¶ Dictionary defining the contents of a
geometry_dump
.
-
-
class
geoalchemy2.types.
Raster
(spatial_index=True)[source]¶ Bases:
sqlalchemy.sql.type_api.UserDefinedType
The Raster column type.
Creating a raster column is done like this:
Column(Raster)
This class defines the
result_processor
method, so that raster values received from the database are converted togeoalchemy2.elements.RasterElement
objects.Constructor arguments:
spatial_index
Indicate if a spatial index should be created. Default isTrue
.-
comparator_factory
¶ This is the way by which spatial operators and functions are defined for raster columns.
alias of
BaseComparator
-
-
class
geoalchemy2.types.
_GISType
(geometry_type='GEOMETRY', srid=-1, dimension=2, spatial_index=True, management=False, use_typmod=None)[source]¶ Bases:
sqlalchemy.sql.type_api.UserDefinedType
The base class for
geoalchemy2.types.Geometry
andgeoalchemy2.types.Geography
.This class defines
bind_expression
andcolumn_expression
methods that wrap column expressions inST_GeomFromEWKT
,ST_GeogFromText
, orST_AsEWKB
calls.This class also defines
result_processor
andbind_processor
methods. The function returned byresult_processor
converts WKB values received from the database togeoalchemy2.elements.WKBElement
objects. The function returned bybind_processor
convertsgeoalchemy2.elements.WKTElement
objects to EWKT strings.Constructor arguments:
geometry_type
The geometry type.
Possible values are:
"GEOMETRY"
,"POINT"
,"LINESTRING"
,"POLYGON"
,"MULTIPOINT"
,"MULTILINESTRING"
,"MULTIPOLYGON"
,"GEOMETRYCOLLECTION"
"CURVE"
.
The latter is actually not supported with
geoalchemy2.types.Geography
.Default is
"GEOMETRY"
.srid
The SRID for this column. E.g. 4326. Default is-1
.dimension
The dimension of the geometry. Default is2
.spatial_index
Indicate if a spatial index should be created. Default isTrue
.management
Indicate if theAddGeometryColumn
andDropGeometryColumn
managements functions should be called when adding and dropping the geometry column. Should be set toTrue
for PostGIS 1.x. Default isFalse
. Note that this option has no effect forgeoalchemy2.types.Geography
.use_typmod
By default PostgreSQL type modifiers are used to create the geometry column. To use check constraints instead setuse_typmod
toFalse
. By default this option is not included in the call toAddGeometryColumn
. Note that this option is only taken into account ifmanagement
is set toTrue
and is only available for PostGIS 2.x.-
as_binary
= None¶ The name of the “as binary” function for this type. Set in subclasses.
-
comparator_factory
¶ This is the way by which spatial operators are defined for geometry/geography columns.
alias of
Comparator
-
from_text
= None¶ The name of “from text” function for this type. Set in subclasses.
-
name
= None¶ Name used for defining the main geo type (geometry or geography) in CREATE TABLE statements. Set in subclasses.