addGeometryColumnSql function

String addGeometryColumnSql(
  1. String table,
  2. String column, {
  3. int srid = 4326,
  4. String geometryType = 'POINT',
  5. int dimension = 2,
})

Builds the SQL for AddGeometryColumn, SpatiaLite's function for adding a geometry column to an existing table and registering it in geometry_columns metadata.

srid is the spatial reference system identifier (defaults to 4326, WGS 84). geometryType is one of SpatiaLite's geometry type names (POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, GEOMETRYCOLLECTION). dimension is 2 for XY, 3 for XYZ.

Implementation

String addGeometryColumnSql(
  String table,
  String column, {
  int srid = 4326,
  String geometryType = 'POINT',
  int dimension = 2,
}) => "SELECT AddGeometryColumn('$table', '$column', $srid, '$geometryType', $dimension)";