FunctionSet - Набор функций sql-диалекта

class axioma.core.sql.FunctionName

Идентификаторы функций

Возможные функции диалектов FunctionName:

Тип

Значение

Название функции

FunctionAbsent

0

Отсутствующая в списке функция

FunctionATMAsText

231

ATM_AsText

FunctionATMCreate

415

ATM_Create

FunctionATMCreateRotate

302

ATM_CreateRotate

FunctionATMCreateScale

443

ATM_CreateScale

FunctionATMCreateTranslate

428

ATM_CreateTranslate

FunctionATMCreateXRoll

592

ATM_CreateXRoll

FunctionATMCreateYRoll

543

ATM_CreateYRoll

FunctionATMCreateZRoll

389

ATM_CreateZRoll

FunctionATMDeterminant

251

ATM_Determinant

FunctionATMInvert

406

ATM_Invert

FunctionATMIsInvertible

261

ATM_IsInvertible

FunctionATMIsValid

475

ATM_IsValid

FunctionATMMultiply

212

ATM_Multiply

FunctionATMRotate

567

ATM_Rotate

FunctionATMScale

407

ATM_Scale

FunctionATMTransform

668

ATM_Transform

FunctionATMTranslate

165

ATM_Translate

FunctionATMXRoll

646

ATM_XRoll

FunctionATMYRoll

420

ATM_YRoll

FunctionATMZRoll

533

ATM_ZRoll

FunctionAbs

1

Abs

FunctionAcos

171

Acos

FunctionAddPoint

322

AddPoint

FunctionArea

17

Area

FunctionAsBinary

289

AsBinary

FunctionAsEWKB

673

AsEWKB

FunctionAsEWKT

244

AsEWKT

FunctionAsFGF

374

AsFGF

FunctionAsGPB

597

AsGPB

FunctionAsGeoJSON

613

AsGeoJSON

FunctionAsGml

526

AsGml

FunctionAsKml

391

AsKml

FunctionAsSVG

527

AsSVG

FunctionAsText

411

AsText

FunctionAsWKT

284

AsWKT

FunctionAsc

77

Asc

FunctionAsin

307

Asin

FunctionAtan

300

Atan

FunctionAtan2

589

Atan2

FunctionAvg

44

Avg

FunctionAxiomaCentroid

62

AxiomaCentroid

FunctionBdMPolyFromText

480

BdMPolyFromText

FunctionBdMPolyFromWKB

160

BdMPolyFromWKB

FunctionBdPolyFromText

318

BdPolyFromText

FunctionBdPolyFromWKB

641

BdPolyFromWKB

FunctionBoundary

517

Boundary

FunctionBuffer

230

Buffer

FunctionBuildArea

607

BuildArea

FunctionBuildCircleMbr

360

BuildCircleMbr

FunctionBuildMbr

262

BuildMbr

FunctionCartesianArea

19

CartesianArea

FunctionCartesianObjectDistance

28

CartesianObjectDistance

FunctionCartesianObjectLen

25

CartesianObjectLen

FunctionCartesianPerimeter

22

CartesianPerimeter

FunctionCastAutomagic

255

CastAutomagic

FunctionCastToBlob

604

CastToBlob

FunctionCastToDouble

611

CastToDouble

FunctionCastToGeometryCollection

173

CastToGeometryCollection

FunctionCastToInteger

380

CastToInteger

FunctionCastToLinestring

445

CastToLinestring

FunctionCastToMulti

409

CastToMulti

FunctionCastToMultiLinestring

504

CastToMultiLinestring

FunctionCastToMultiPoint

433

CastToMultiPoint

FunctionCastToMultiPolygon

225

CastToMultiPolygon

FunctionCastToPoint

150

CastToPoint

FunctionCastToPolygon

623

CastToPolygon

FunctionCastToSingle

489

CastToSingle

FunctionCastToText

434

CastToText

FunctionCastToXY

240

CastToXY

FunctionCastToXYM

379

CastToXYM

FunctionCastToXYZ

288

CastToXYZ

FunctionCastToXYZM

172

CastToXYZM

FunctionCeil

601

Ceil

FunctionCeiling

273

Ceiling

FunctionCentroid

495

Centroid

FunctionCentroidX

26

CentroidX

FunctionCentroidY

27

CentroidY

FunctionChar

114

Char

FunctionChr

677

Chr

FunctionChrDollar

30

Chr$

FunctionCircularity

306

Circularity

FunctionClosestPoint

363

ClosestPoint

FunctionCoalesce

117

Coalesce

FunctionCollect

619

Collect

FunctionCollectionExtract

369

CollectionExtract

FunctionCompressGeometry

505

CompressGeometry

FunctionConcat

78

concat

FunctionConcaveHull

515

ConcaveHull

FunctionContains

53

ContainsCentroid

FunctionContainsEntirely

56

ST_Contains

FunctionConvexHull

147

ConvexHull

FunctionCoordDimension

603

CoordDimension

FunctionCoordSys

66

CoordSys

FunctionCos

49

Cos

FunctionCot

626

Cot

FunctionCount

47

Count

FunctionCoveredBy

317

CoveredBy

FunctionCovers

639

Covers

FunctionCreateUUID

313

CreateUUID

FunctionCrosses

642

Crosses

FunctionCumeDist

121

Cume_Dist

FunctionCurDate

9

CurDate

FunctionCurDateTime

10

CurDateTime

FunctionCurTime

11

CurTime

FunctionCurrentDate

124

Current_Date

FunctionCurrentTime

125

Current_Time

FunctionCurrentTimestamp

91

Current_Timestamp

FunctionCurvosityIndex

483

CurvosityIndex

FunctionCvtFromCh

397

CvtFromCh

FunctionCvtFromCm

201

CvtFromCm

FunctionCvtFromDm

154

CvtFromDm

FunctionCvtFromFath

518

CvtFromFath

FunctionCvtFromFt

308

CvtFromFt

FunctionCvtFromIn

388

CvtFromIn

FunctionCvtFromIndCh

538

CvtFromIndCh

FunctionCvtFromIndFt

627

CvtFromIndFt

FunctionCvtFromIndYd

286

CvtFromIndYd

FunctionCvtFromKm

653

CvtFromKm

FunctionCvtFromKmi

181

CvtFromKmi

FunctionCvtFromLink

162

CvtFromLink

FunctionCvtFromMi

539

CvtFromMi

FunctionCvtFromMm

440

CvtFromMm

FunctionCvtFromUsCh

301

CvtFromUsCh

FunctionCvtFromUsFt

418

CvtFromUsFt

FunctionCvtFromUsIn

566

CvtFromUsIn

FunctionCvtFromUsMi

344

CvtFromUsMi

FunctionCvtFromUsYd

590

CvtFromUsYd

FunctionCvtFromYd

193

CvtFromYd

FunctionCvtToCh

274

CvtToCh

FunctionCvtToCm

551

CvtToCm

FunctionCvtToDm

210

CvtToDm

FunctionCvtToFath

427

CvtToFath

FunctionCvtToFt

281

CvtToFt

FunctionCvtToIn

540

CvtToIn

FunctionCvtToIndCh

617

CvtToIndCh

FunctionCvtToIndFt

139

CvtToIndFt

FunctionCvtToIndYd

498

CvtToIndYd

FunctionCvtToKm

499

CvtToKm

FunctionCvtToKmi

209

CvtToKmi

FunctionCvtToLink

400

CvtToLink

FunctionCvtToMi

591

CvtToMi

FunctionCvtToMm

293

CvtToMm

FunctionCvtToUsCh

419

CvtToUsCh

FunctionCvtToUsFt

155

CvtToUsFt

FunctionCvtToUsIn

559

CvtToUsIn

FunctionCvtToUsMi

580

CvtToUsMi

FunctionCvtToUsYd

414

CvtToUsYd

FunctionCvtToYd

602

CvtToYd

FunctionDate

115

Date

FunctionDateTime

120

DateTime

FunctionDay

5

Day

FunctionDecodeURL

372

DecodeURL

FunctionDeformatNumber

687

DeformatNumber

FunctionDeformatNumberDollar

81

DeformatNumber$

FunctionDegrees

237

Degrees

FunctionDelaunayTriangulation

508

DelaunayTriangulation

FunctionDenseRank

122

Dense_Rank

FunctionDifference

546

Difference

FunctionDimension

622

Dimension

FunctionDirNameFromPath

205

DirNameFromPath

FunctionDisjoint

529

Disjoint

FunctionDissolvePoints

628

DissolvePoints

FunctionDissolveSegments

238

DissolveSegments

FunctionDistance

439

Distance

FunctionDivide

696

divide

FunctionDownhillHeight

453

DownhillHeight

FunctionEncodeURL

216

EncodeURL

FunctionEndPoint

215

EndPoint

FunctionEnsureClosedRings

241

EnsureClosedRings

FunctionEntirelyWithin

57

ST_Within

FunctionEnvelope

583

Envelope

FunctionEquals

272

Equals

FunctionExp

667

Exp

FunctionExtent

148

Extent

FunctionExteriorRing

158

ExteriorRing

FunctionExtractMultiLinestring

144

ExtractMultiLinestring

FunctionExtractMultiPoint

555

ExtractMultiPoint

FunctionExtractMultiPolygon

585

ExtractMultiPolygon

FunctionFileExtFromPath

647

FileExtFromPath

FunctionFileNameFromPath

159

FileNameFromPath

FunctionFirst

0

FunctionFirstValue

130

First_Value

FunctionFix

73

Fix

FunctionFloor

180

Floor

FunctionForceAsNull

586

ForceAsNull

FunctionFormat

685

Format

FunctionFormatDate

686

FormatDate

FunctionFormatDateDollar

80

FormatDate$

FunctionFormatDollar

79

Format$

FunctionFormatNumber

688

FormatNumber

FunctionFormatNumberDollar

82

FormatNumber$

FunctionFormatTime

694

FormatTime

FunctionFormatTimeDollar

693

FormatTime$

FunctionFrechetDistance

375

FrechetDistance

FunctionFromAxiGeo

65

FromAxiGeo

FunctionFullFileNameFromPath

258

FullFileNameFromPath

FunctionGARSMbr

582

GARSMbr

FunctionGLength

285

GLength

FunctionGUnion

549

GUnion

FunctionGeodesicArcArea

645

GeodesicArcArea

FunctionGeodesicArcHeight

339

GeodesicArcHeight

FunctionGeodesicArcLength

309

GeodesicArcLength

FunctionGeodesicCentralAngle

358

GeodesicCentralAngle

FunctionGeodesicChordLength

465

GeodesicChordLength

FunctionGeodesicLength

140

GeodesicLength

FunctionGeomCollFromText

316

GeomCollFromText

FunctionGeomCollFromWKB

460

GeomCollFromWKB

FunctionGeomFromEWKB

259

GeomFromEWKB

FunctionGeomFromEWKT

353

GeomFromEWKT

FunctionGeomFromExifGpsBlob

222

GeomFromExifGpsBlob

FunctionGeomFromFGF

563

GeomFromFGF

FunctionGeomFromGML

382

GeomFromGML

FunctionGeomFromGPB

461

GeomFromGPB

FunctionGeomFromGeoJSON

264

GeomFromGeoJSON

FunctionGeomFromKml

577

GeomFromKml

FunctionGeomFromText

228

GeomFromText

FunctionGeomFromWKB

491

GeomFromWKB

FunctionGeometryCollectionFromText

218

GeometryCollectionFromText

FunctionGeometryCollectionFromWKB

557

GeometryCollectionFromWKB

FunctionGeometryFromText

470

GeometryFromText

FunctionGeometryFromWKB

525

GeometryFromWKB

FunctionGeometryN

234

GeometryN

FunctionGeometryPointEncode

535

GeometryPointEncode

FunctionGeometryType

196

GeometryType

FunctionGeosVersion

436

geos_version

FunctionGetDate

13

GetDate

FunctionGetDecimalPrecision

547

GetDecimalPrecision

FunctionGetGpkgMode

134

GetGpkgMode

FunctionGetMimeType

456

GetMimeType

FunctionGetTime

12

GetTime

FunctionGlob

59

glob

FunctionGpkgGetImageType

187

gpkgGetImageType

FunctionGpkgMakePoint

199

gpkgMakePoint

FunctionGpkgMakePointM

133

gpkgMakePointM

FunctionGpkgMakePointZ

437

gpkgMakePointZ

FunctionGpkgMakePointZM

383

gpkgMakePointZM

FunctionGreatCircleLength

367

GreatCircleLength

FunctionGroupConcat

87

Group_Concat

FunctionHausdorffDistance

662

HausdorffDistance

FunctionHex

119

Hex

FunctionHexagonalGrid

598

HexagonalGrid

FunctionHour

14

Hour

FunctionIfNull

123

IfNull

FunctionInStr

31

InStr

FunctionInt

51

Int

FunctionInteriorRingN

283

InteriorRingN

FunctionIntersection

365

Intersection

FunctionIntersects

55

ST_Intersects

FunctionInvolution

71

involution

FunctionIsClosed

588

IsClosed

FunctionIsCompressedGeometryBlob

266

IsCompressedGeometryBlob

FunctionIsDecimalNumber

514

IsDecimalNumber

FunctionIsEmpty

312

IsEmpty

FunctionIsExifBlob

368

IsExifBlob

FunctionIsExifGpsBlob

202

IsExifGpsBlob

FunctionIsGeometryBlob

542

IsGeometryBlob

FunctionIsGifBlob

211

IsGifBlob

FunctionIsInteger

295

IsInteger

FunctionIsJP2Blob

349

IsJP2Blob

FunctionIsJpegBlob

223

IsJpegBlob

FunctionIsLowASCII

541

IsLowASCII

FunctionIsNumber

416

IsNumber

FunctionIsPauseEnabled

141

IsPauseEnabled

FunctionIsPdfBlob

256

IsPdfBlob

FunctionIsPngBlob

571

IsPngBlob

FunctionIsRing

246

IsRing

FunctionIsSimple

625

IsSimple

FunctionIsTiffBlob

532

IsTiffBlob

FunctionIsTinyPointBlob

655

IsTinyPointBlob

FunctionIsValid

245

IsValid

FunctionIsValidDetail

161

IsValidDetail

FunctionIsValidGPB

412

IsValidGPB

FunctionIsValidReason

531

IsValidReason

FunctionIsWebpBlob

654

IsWebpBlob

FunctionIsZipBlob

195

IsZipBlob

FunctionJulianDay

88

JulianDay

FunctionLCase

678

LCase

FunctionLCaseDollar

32

LCase$

FunctionLTrim

129

LTrim

FunctionLTrimDollar

34

LTrim$

FunctionLag

126

Lag

FunctionLastValue

95

Last_Value

FunctionLatitudeFromDMS

509

LatitudeFromDMS

FunctionLead

127

Lead

FunctionLeft

681

Left

FunctionLeftDollar

38

Left$

FunctionLen

37

Len

FunctionLength

131

Length

FunctionLike

58

like

FunctionLikelihood

94

Likelihood

FunctionLikely

132

Likely

FunctionLineFromText

207

LineFromText

FunctionLineFromWKB

575

LineFromWKB

FunctionLineInterpolateEquidistantPoints

528

Line_Interpolate_Equidistant_Points

FunctionLineInterpolatePoint

537

Line_Interpolate_Point

FunctionLineLocatePoint

386

Line_Locate_Point

FunctionLineMerge

385

LineMerge

FunctionLineStringFromText

507

LineStringFromText

FunctionLineStringFromWKB

637

LineStringFromWKB

FunctionLineSubstring

494

Line_Substring

FunctionLinesCutAtNodes

462

LinesCutAtNodes

FunctionLinesFromRings

182

LinesFromRings

FunctionLinestringAvgSegmentLength

643

LinestringAvgSegmentLength

FunctionLinestringMaxSegmentLength

291

LinestringMaxSegmentLength

FunctionLinestringMinSegmentLength

496

LinestringMinSegmentLength

FunctionLn

292

Ln

FunctionLog

179

Log

FunctionLog10

357

Log10

FunctionLog2

299

Log2

FunctionLongLatToDMS

387

LongLatToDMS

FunctionLongitudeFromDMS

426

LongitudeFromDMS

FunctionLower

128

Lower

FunctionM

671

M

FunctionMD5Checksum

610

MD5Checksum

FunctionMD5TotalChecksum

446

MD5TotalChecksum

FunctionMLineFromText

198

MLineFromText

FunctionMLineFromWKB

448

MLineFromWKB

FunctionMPointFromText

576

MPointFromText

FunctionMPointFromWKB

243

MPointFromWKB

FunctionMPolyFromText

297

MPolyFromText

FunctionMPolyFromWKB

659

MPolyFromWKB

FunctionMakeArc

510

MakeArc

FunctionMakeCircle

485

MakeCircle

FunctionMakeCircularSector

359

MakeCircularSector

FunctionMakeCircularStripe

232

MakeCircularStripe

FunctionMakeEllipse

398

MakeEllipse

FunctionMakeEllipticArc

233

MakeEllipticArc

FunctionMakeEllipticSector

519

MakeEllipticSector

FunctionMakeLine

620

MakeLine

FunctionMakePoint

390

MakePoint

FunctionMakePointM

466

MakePointM

FunctionMakePointZ

183

MakePointZ

FunctionMakePointZM

166

MakePointZM

FunctionMakePolygon

593

MakePolygon

FunctionMakeStringList

221

MakeStringList

FunctionMakeValid

697

MakeValid

FunctionMakeValidGeo

698

MakeValidGeo

FunctionMax

46

Max

FunctionMaximum

2

Maximum

FunctionMbrContains

487

MbrContains

FunctionMbrDisjoint

468

MbrDisjoint

FunctionMbrEqual

408

MbrEqual

FunctionMbrIntersects

467

MbrIntersects

FunctionMbrMaxX

561

MbrMaxX

FunctionMbrMaxY

552

MbrMaxY

FunctionMbrMinX

476

MbrMinX

FunctionMbrMinY

135

MbrMinY

FunctionMbrOverlaps

669

MbrOverlaps

FunctionMbrTouches

378

MbrTouches

FunctionMbrWithin

511

MbrWithin

FunctionMid

683

Mid

FunctionMidDollar

40

Mid$

FunctionMin

45

Min

FunctionMinimum

3

Minimum

FunctionMinute

15

Minute

FunctionMonth

6

Month

FunctionMultiLineStringFromText

327

MultiLineStringFromText

FunctionMultiLineStringFromWKB

649

MultiLineStringFromWKB

FunctionMultiPointFromText

587

MultiPointFromText

FunctionMultiPointFromWKB

478

MultiPointFromWKB

FunctionMultiPolygonFromText

270

MultiPolygonFromText

FunctionMultiPolygonFromWKB

315

MultiPolygonFromWKB

FunctionNTile

89

NTile

FunctionNormalizeLonLat

275

NormalizeLonLat

FunctionNthValue

98

Nth_Value

FunctionNullIf

90

NullIf

FunctionNumGeometries

512

NumGeometries

FunctionNumInteriorRing

254

NumInteriorRing

FunctionNumInteriorRings

345

NumInteriorRings

FunctionNumPoints

670

NumPoints

FunctionNumberToDate

86

NumberToDate

FunctionObjectArea

64

ObjectArea

FunctionObjectLen

23

ObjectLen

FunctionObjectPerimeter

63

ObjectPerimeter

FunctionOffsetCurve

393

OffsetCurve

FunctionOverlaps

394

Overlaps

FunctionPI

606

PI

FunctionPROJAsProjString

550

PROJ_AsProjString

FunctionPROJAsWKT

298

PROJ_AsWKT

FunctionPROJGetDatabasePath

248

PROJ_GetDatabasePath

FunctionPROJGuessSridFromWKT

666

PROJ_GuessSridFromWKT

FunctionPause

194

Pause

FunctionPercentRank

111

Percent_Rank

FunctionPerimeter

20

Perimeter

FunctionPointFromText

362

PointFromText

FunctionPointFromWKB

186

PointFromWKB

FunctionPointN

333

PointN

FunctionPointOnSurface

569

PointOnSurface

FunctionPolyFromText

672

PolyFromText

FunctionPolyFromWKB

381

PolyFromWKB

FunctionPolygonFromText

217

PolygonFromText

FunctionPolygonFromWKB

556

PolygonFromWKB

FunctionPolygonize

484

Polygonize

FunctionPow

170

Pow

FunctionPower

631

Power

FunctionPresentFirst

1

Abs

FunctionPrintF

93

PrintF

FunctionProj4Version

675

proj4_version

FunctionProjVersion

558

proj_version

FunctionProper

680

Proper

FunctionProperDollar

36

Proper$

FunctionPtDistWithin

438

PtDistWithin

FunctionQuote

92

Quote

FunctionQuotient

70

quotient

FunctionRTrim

97

RTrim

FunctionRTrimDollar

35

RTrim$

FunctionRadians

153

Radians

FunctionRandom

99

Random

FunctionRandomBLOB

109

RandomBLOB

FunctionRank

96

Rank

FunctionReflectCoordinates

553

ReflectCoordinates

FunctionReflectCoords

562

ReflectCoords

FunctionRelate

442

Relate

FunctionRemoveExtraSpaces

226

RemoveExtraSpaces

FunctionRemovePoint

500

RemovePoint

FunctionRemoveRepeatedPoints

417

RemoveRepeatedPoints

FunctionReplace

105

Replace

FunctionResemblance

69

Resemblance

FunctionRight

682

Right

FunctionRightDollar

39

Right$

FunctionRingsCutAtNodes

660

RingsCutAtNodes

FunctionRotateCoordinates

294

RotateCoordinates

FunctionRotateCoords

657

RotateCoords

FunctionRound

4

Round

FunctionRoundBy

692

RoundBy

FunctionRoundTo

691

RoundTo

FunctionRowNum

48

RowNum

FunctionRowNumber

112

Row_Number

FunctionSRID

184

SRID

FunctionSTAddMeasure

203

ST_AddMeasure

FunctionSTAddPoint

656

ST_AddPoint

FunctionSTArea

236

ST_Area

FunctionSTAsBinary

564

ST_AsBinary

FunctionSTAsText

346

ST_AsText

FunctionSTBdMPolyFromText

168

ST_BdMPolyFromText

FunctionSTBdMPolyFromWKB

464

ST_BdMPolyFromWKB

FunctionSTBdPolyFromText

651

ST_BdPolyFromText

FunctionSTBdPolyFromWKB

145

ST_BdPolyFromWKB

FunctionSTBoundary

454

ST_Boundary

FunctionSTBuffer

565

ST_Buffer

FunctionSTBuildArea

164

ST_BuildArea

FunctionSTCentroid

191

ST_Centroid

FunctionSTClosestPoint

661

ST_ClosestPoint

FunctionSTCollect

267

ST_Collect

FunctionSTCollectionExtract

474

ST_CollectionExtract

FunctionSTConcaveHull

290

ST_ConcaveHull

FunctionSTConvexHull

579

ST_ConvexHull

FunctionSTCoveredBy

605

ST_CoveredBy

FunctionSTCovers

328

ST_Covers

FunctionSTCrosses

146

ST_Crosses

FunctionSTCurvosityIndex

616

ST_CurvosityIndex

FunctionSTDelaunayTriangulation

451

ST_DelaunayTriangulation

FunctionSTDifference

208

ST_Difference

FunctionSTDimension

269

ST_Dimension

FunctionSTDisjoint

229

ST_Disjoint

FunctionSTDissolvePoints

250

ST_DissolvePoints

FunctionSTDissolveSegments

142

ST_DissolveSegments

FunctionSTDistance

260

ST_Distance

FunctionSTDownhillHeight

482

ST_DownhillHeight

FunctionSTDrapeLine

450

ST_DrapeLine

FunctionSTDrapeLineExceptions

265

ST_DrapeLineExceptions

FunctionSTEndPoint

370

ST_EndPoint

FunctionSTEnvIntersects

323

ST_EnvIntersects

FunctionSTEnvelope

522

ST_Envelope

FunctionSTEnvelopesIntersects

311

ST_EnvelopesIntersects

FunctionSTEquals

219

ST_Equals

FunctionSTExpand

595

ST_Expand

FunctionSTExteriorRing

149

ST_ExteriorRing

FunctionSTForceLHR

276

ST_ForceLHR

FunctionSTForcePolygonCCW

459

ST_ForcePolygonCCW

FunctionSTForcePolygonCW

371

ST_ForcePolygonCW

FunctionSTFrechetDistance

640

ST_FrechetDistance

FunctionSTGeneralize

376

ST_Generalize

FunctionSTGeomCollFromText

206

ST_GeomCollFromText

FunctionSTGeomCollFromWKB

574

ST_GeomCollFromWKB

FunctionSTGeomFromText

636

ST_GeomFromText

FunctionSTGeomFromWKB

174

ST_GeomFromWKB

FunctionSTGeometryCollectionFromText

373

ST_GeometryCollectionFromText

FunctionSTGeometryCollectionFromWKB

630

ST_GeometryCollectionFromWKB

FunctionSTGeometryFromText

277

ST_GeometryFromText

FunctionSTGeometryFromWKB

296

ST_GeometryFromWKB

FunctionSTGeometryN

554

ST_GeometryN

FunctionSTGeometryType

536

ST_GeometryType

FunctionSTHausdorffDistance

424

ST_HausdorffDistance

FunctionSTHexagonalGrid

355

ST_HexagonalGrid

FunctionSTInteriorRingN

568

ST_InteriorRingN

FunctionSTInterpolatePoint

350

ST_InterpolatePoint

FunctionSTIntersection

663

ST_Intersection

FunctionSTIs3D

609

ST_Is3D

FunctionSTIsClosed

377

ST_IsClosed

FunctionSTIsEmpty

224

ST_IsEmpty

FunctionSTIsMeasured

335

ST_IsMeasured

FunctionSTIsPolygonCCW

635

ST_IsPolygonCCW

FunctionSTIsPolygonCW

523

ST_IsPolygonCW

FunctionSTIsRing

644

ST_IsRing

FunctionSTIsSimple

247

ST_IsSimple

FunctionSTIsValid

151

ST_IsValid

FunctionSTIsValidDetail

138

ST_IsValidDetail

FunctionSTIsValidReason

280

ST_IsValidReason

FunctionSTIsValidTrajectory

405

ST_IsValidTrajectory

FunctionSTLength

330

ST_Length

FunctionSTLineFromText

544

ST_LineFromText

FunctionSTLineFromWKB

624

ST_LineFromWKB

FunctionSTLineInterpolateEquidistantPoints

278

ST_Line_Interpolate_Equidistant_Points

FunctionSTLineInterpolatePoint

441

ST_Line_Interpolate_Point

FunctionSTLineLocatePoint

190

ST_Line_Locate_Point

FunctionSTLineMerge

188

ST_LineMerge

FunctionSTLineStringFromText

197

ST_LineStringFromText

FunctionSTLineStringFromWKB

447

ST_LineStringFromWKB

FunctionSTLineSubstring

189

ST_Line_Substring

FunctionSTLinesCutAtNodes

304

ST_LinesCutAtNodes

FunctionSTLinesFromRings

501

ST_LinesFromRings

FunctionSTLinestringAvgSegmentLength

329

ST_LinestringAvgSegmentLength

FunctionSTLinestringMaxSegmentLength

570

ST_LinestringMaxSegmentLength

FunctionSTLinestringMinSegmentLength

192

ST_LinestringMinSegmentLength

FunctionSTLocateAlong

163

ST_LocateAlong

FunctionSTLocateAlongMeasure

560

ST_Locate_Along_Measure

FunctionSTLocateBetween

331

ST_LocateBetween

FunctionSTLocateBetweenMeasures

310

ST_Locate_Between_Measures

FunctionSTM

432

ST_M

FunctionSTMLineFromText

303

ST_MLineFromText

FunctionSTMLineFromWKB

361

ST_MLineFromWKB

FunctionSTMPointFromText

175

ST_MPointFromText

FunctionSTMPointFromWKB

469

ST_MPointFromWKB

FunctionSTMPolyFromText

490

ST_MPolyFromText

FunctionSTMPolyFromWKB

167

ST_MPolyFromWKB

FunctionSTMakePolygon

252

ST_MakePolygon

FunctionSTMaxM

287

ST_MaxM

FunctionSTMaxX

521

ST_MaxX

FunctionSTMaxY

257

ST_MaxY

FunctionSTMaxZ

594

ST_MaxZ

FunctionSTMinM

351

ST_MinM

FunctionSTMinX

340

ST_MinX

FunctionSTMinY

431

ST_MinY

FunctionSTMinZ

513

ST_MinZ

FunctionSTMulti

263

ST_Multi

FunctionSTMultiLineStringFromText

612

ST_MultiLineStringFromText

FunctionSTMultiLineStringFromWKB

336

ST_MultiLineStringFromWKB

FunctionSTMultiPointFromText

524

ST_MultiPointFromText

FunctionSTMultiPointFromWKB

325

ST_MultiPointFromWKB

FunctionSTMultiPolygonFromText

341

ST_MultiPolygonFromText

FunctionSTMultiPolygonFromWKB

227

ST_MultiPolygonFromWKB

FunctionSTNDims

204

ST_NDims

FunctionSTNPoints

214

ST_NPoints

FunctionSTNRings

634

ST_NRings

FunctionSTNumGeometries

457

ST_NumGeometries

FunctionSTNumInteriorRing

157

ST_NumInteriorRing

FunctionSTNumPoints

430

ST_NumPoints

FunctionSTOffsetCurve

338

ST_OffsetCurve

FunctionSTOverlaps

178

ST_Overlaps

FunctionSTPerimeter

320

ST_Perimeter

FunctionSTPoint

486

ST_Point

FunctionSTPointFromText

410

ST_PointFromText

FunctionSTPointFromWKB

506

ST_PointFromWKB

FunctionSTPointN

136

ST_PointN

FunctionSTPointOnSurface

169

ST_PointOnSurface

FunctionSTPolyFromText

326

ST_PolyFromText

FunctionSTPolyFromWKB

648

ST_PolyFromWKB

FunctionSTPolygonFromText

352

ST_PolygonFromText

FunctionSTPolygonFromWKB

596

ST_PolygonFromWKB

FunctionSTPolygonize

618

ST_Polygonize

FunctionSTRelate

356

ST_Relate

FunctionSTRelateMatch

481

ST_RelateMatch

FunctionSTRemovePoint

401

ST_RemovePoint

FunctionSTReverse

185

ST_Reverse

FunctionSTRingsCutAtNodes

423

ST_RingsCutAtNodes

FunctionSTSRID

503

ST_SRID

FunctionSTSetEndPoint

421

ST_SetEndPoint

FunctionSTSetPoint

253

ST_SetPoint

FunctionSTSetStartPoint

282

ST_SetStartPoint

FunctionSTSharedPaths

472

ST_SharedPaths

FunctionSTShiftLongitude

402

ST_Shift_Longitude

FunctionSTShortestLine

452

ST_ShortestLine

FunctionSTSimplify

319

ST_Simplify

FunctionSTSimplifyPreserveTopology

395

ST_SimplifyPreserveTopology

FunctionSTSingleSidedBuffer

305

ST_SingleSidedBuffer

FunctionSTSnap

493

ST_Snap

FunctionSTSnapToGrid

213

ST_SnapToGrid

FunctionSTSquareGrid

599

ST_SquareGrid

FunctionSTStartPoint

137

ST_StartPoint

FunctionSTSymDifference

279

ST_SymDifference

FunctionSTTouches

200

ST_Touches

FunctionSTTrajectoryInterpolatePoint

581

ST_TrajectoryInterpolatePoint

FunctionSTTransform

152

ST_Transform

FunctionSTTransformXY

321

ST_TransformXY

FunctionSTTransformXYZ

600

ST_TransformXYZ

FunctionSTTranslate

520

ST_Translate

FunctionSTTriangularGrid

413

ST_TriangularGrid

FunctionSTUnaryUnion

399

ST_UnaryUnion

FunctionSTUnion

235

ST_Union

FunctionSTUpDownHeight

396

ST_UpDownHeight

FunctionSTUphillHeight

665

ST_UphillHeight

FunctionSTVoronojDiagram

492

ST_VoronojDiagram

FunctionSTWKBToSQL

477

ST_WKBToSQL

FunctionSTWKTToSQL

242

ST_WKTToSQL

FunctionSTX

403

ST_X

FunctionSTY

239

ST_Y

FunctionSTZ

573

ST_Z

FunctionSanitizeGeometry

324

SanitizeGeometry

FunctionScaleCoordinates

429

ScaleCoordinates

FunctionScaleCoords

156

ScaleCoords

FunctionSecond

16

Second

FunctionSetEndPoint

444

SetEndPoint

FunctionSetPoint

629

SetPoint

FunctionSetSRID

584

SetSRID

FunctionSetStartPoint

534

SetStartPoint

FunctionSgn

72

Sgn

FunctionSharedPaths

364

SharedPaths

FunctionShiftCoordinates

608

ShiftCoordinates

FunctionShiftCoords

332

ShiftCoords

FunctionShortestLine

516

ShortestLine

FunctionSign

220

Sign

FunctionSimplify

664

Simplify

FunctionSimplifyPreserveTopology

614

SimplifyPreserveTopology

FunctionSin

50

Sin

FunctionSingleSidedBuffer

463

SingleSidedBuffer

FunctionSnap

177

Snap

FunctionSnapToGrid

548

SnapToGrid

FunctionSpace

689

Space

FunctionSpaceDollar

83

Space$

FunctionSpatialiteTargetCPU

479

spatialite_target_cpu

FunctionSpatialiteVersion

471

spatialite_version

FunctionSphericalArea

18

SphericalArea

FunctionSphericalObjectDistance

29

SphericalObjectDistance

FunctionSphericalObjectLen

24

SphericalObjectLen

FunctionSphericalPerimeter

21

SphericalPerimeter

FunctionSqliteSourceId

674

sqlite_source_id

FunctionSqliteVersion

116

Sqlite_Version

FunctionSqr

676

Sqr

FunctionSqrt

74

Sqrt

FunctionSquareGrid

632

SquareGrid

FunctionSridFromAuthCRS

488

SridFromAuthCRS

FunctionSridGetAxis1Name

638

SridGetAxis_1_Name

FunctionSridGetAxis1Orientation

342

SridGetAxis_1_Orientation

FunctionSridGetAxis2Name

337

SridGetAxis_2_Name

FunctionSridGetAxis2Orientation

435

SridGetAxis_2_Orientation

FunctionSridGetDatum

449

SridGetDatum

FunctionSridGetEllipsoid

545

SridGetEllipsoid

FunctionSridGetPrimeMeridian

392

SridGetPrimeMeridian

FunctionSridGetProjection

347

SridGetProjection

FunctionSridGetSpheroid

578

SridGetSpheroid

FunctionSridGetUnit

650

SridGetUnit

FunctionSridHasFlippedAxes

422

SridHasFlippedAxes

FunctionSridIsGeographic

354

SridIsGeographic

FunctionSridIsProjected

404

SridIsProjected

FunctionStartPoint

334

StartPoint

FunctionStddevPop

497

Stddev_pop

FunctionStddevSamp

455

Stddev_samp

FunctionStr

684

Str

FunctionStrDollar

42

Str$

FunctionStrFTime

108

StrFTime

FunctionString

690

String

FunctionStringCompare

60

StringCompare

FunctionStringDollar

84

String$

FunctionStringLocaleCompare

61

StringCompareIntl

FunctionStringToDate

85

StringToDate

FunctionSubstr

103

Substr

FunctionSubstring

104

Substring

FunctionSum

43

Sum

FunctionSwapCoordinates

621

SwapCoordinates

FunctionSwapCoords

143

SwapCoords

FunctionSymDifference

530

SymDifference

FunctionTableCoordSys

699

TableCoordSys

FunctionTan

425

Tan

FunctionTime

101

Time

FunctionTinyPointEncode

268

TinyPointEncode

FunctionToAxiGeo

67

ToAxiGeo

FunctionToGARS

572

ToGARS

FunctionToSLGeo

695

ToSLGeo

FunctionTotal

102

Total

FunctionTouches

271

Touches

FunctionTransform

249

Transform

FunctionTransformToAxiGeo

68

TransformToAxiGeo

FunctionTransformToSLGeo

700

TransformToSLGeo

FunctionTransformXY

473

TransformXY

FunctionTransformXYZ

633

TransformXYZ

FunctionTriangularGrid

343

TriangularGrid

FunctionTrim

100

Trim

FunctionTypeOf

107

TypeOf

FunctionUCase

679

UCase

FunctionUCaseDollar

33

UCase$

FunctionUnaryUnion

384

UnaryUnion

FunctionUncompressGeometry

314

UncompressGeometry

FunctionUnicode

110

Unicode

FunctionUnlikely

113

Unlikely

FunctionUpDownHeight

615

UpDownHeight

FunctionUphillHeight

366

UphillHeight

FunctionUpper

106

Upper

FunctionVal

41

Val

FunctionVarPop

348

Var_pop

FunctionVarSamp

652

Var_samp

FunctionVoronojDiagram

176

VoronojDiagram

FunctionWeekday

8

Weekday

FunctionWithin

54

CentroidWithin

FunctionWtAvg

75

WtAvg

FunctionWtAvgSafe

76

WtAvgSafe

FunctionX

502

X

FunctionXor

52

xor

FunctionY

658

Y

FunctionYear

7

Year

FunctionZ

458

Z

FunctionZeroBlob

118

ZeroBlob

FunctionNameCount

701

Общее число функций

class axioma.core.sql.FunctionSet

Интерфейс получения информации о функциях sql-диалекта

Методы:

axioma.core.sql.add(functionName)

Добавление функции к набору

Параметры

functionName (FunctionName) – Идентификатор функции

axioma.core.sql.fillByMask(mask, value=true)

Добавить к набору функции указанного типа или исключить их из набора.

Параметры
  • mask (bool) – Тип функций

  • mask – Признак добавления функций к набору (false - исключение функций из набора)

axioma.core.sql.functions(filter)

Получить список функций с описаниями, соответствующих фильтру

Параметры

filter (FunctionFilter) – Фильтр, накладываемый на набор функций

Результат

Список названий и описаний функций

Тип результата

list [NameDescribed]

axioma.core.sql.name(functionName)

Получить название конкретно взятой функции

Параметры

functionName (FunctionName) – Идентификатор функции

Результат

Название функции

Тип результата

str

axioma.core.sql.reserve(size)

Резервирование пространства под указанное число функций

Параметры

size (int) – Размер набора