ls.jgt-apps.0.8.0.source-code.spl_sql_keywords.txt Maven / Gradle / Ivy
spatialite_version
spatialite_target_cpu
freexl_version
proj4_version
geos_version
lwgeom_version
libxml2_version
HasIconv
HasMathSQL
HasGeoCallbacks
HasProj
HasGeos
HasGeosAdvanced
HasGeosTrunk
HasGeosReentrant
HasGeosOnlyReentrant
HasLwGeom
HasLibXML2
HasEpsg
HasFreeXL
HasGeoPackage
HasGCP
HasTopology
CastToInteger
CastToDouble
CastToText
CastToBlob
ForceAsNull
CreateUUID
MD5Checksum
MD5TotalChecksum
EncodeURL
DecodeURL
DirNameFromPath
FullFileNameFromPath
FileNameFromPath
FileExtFromPath
eval
EnableGpkgMode
DisableGpkgMode
GetGpkgMode
EnableGpkgAmphibiousMode
DisableGpkgAmphibiousMode
GetGpkgAmphibiousMode
SetDecimalPrecision
GetDecimalPrecision
SQL math functions
Function
Abs
Acos
Asin
Atan
Atan2
"Ceil
Ceiling"
Cos
Cot
Degrees
Exp
Floor
"Ln
Log"
Log
Log2
Log10
PI
"Pow
Power"
Radians
Sign
Sin
Sqrt
Stddev_pop
Stddev_samp
Tan
Var_pop
Var_samp
GEOS_GetLastWarningMsg
GEOS_GetLastErrorMsg
GEOS_GetLastAuxErrorMsg
GEOS_GetCriticalPointFromMsg
LWGEOM_GetLastWarningMsg
LWGEOM_GetLastErrorMsg
Kilometer
Decimeter
Centimeter
Millimeter
International Nautical Mile
International Inch
International Foot
International Yard
International Statute Mile
International Fathom
International Chain
International Link
U.S. Inch
U.S. Foot
U.S. Yard
U.S. Statute Mile
U.S. Chain
Indian Foot
Indian Yard
Indian Chain
DD to DMS
DMS to DD
IsZipBlob
IsPdfBlob
IsGifBlob
IsPngBlob
IsTiffBlob
IsJpegBlob
IsExifBlob
IsExifGpsBlob
IsWebpBlob
IsJP2Blob
GetMimeType
BlobFromFile
BlobToFile
CountUnsafeTriggers
GeomFromExifGpsBlob
ST_Point
MakePoint
MakePointZ
MakePointM
MakePointZM
MakeLine
MakeLine
MakeLine
MakeCircle
MakeEllipse
MakeArc
MakeEllipticArc
MakeCircularSector
MakeEllipticSector
MakeCircularStripe
SquareGrid
TriangularGrid
HexagonalGrid
BuildMbr
BuildCircleMbr
Extent
ToGARS
GARSMbr
MbrMinX
MbrMinY
MbrMaxX
MbrMaxY
MinZ
MaxZ
MinM
MaxM
GeomFromText
ST_WKTToSQL
PointFromText
"LineFromText
LineStringFromText"
"PolyFromText
PolygonFromText"
"MPointFromText
MultiPointFromText"
"MLineFromText
MultiLineStringFromText"
"MPolyFromText
MultiPolygonFromText"
"GeomCollFromText
GeometryCollectionFromText"
BdPolyFromText
BdMPolyFromText
GeomFromWKB
ST_WKBToSQL
PointFromWKB
"LineFromWKB
LineStringFromWKB"
"PolyFromWKB
PolygonFromWKB"
"MPointFromWKB
MultiPointFromWKB"
"MLineFromWKB
MultiLineStringFromWKB"
"MPolyFromWKB
MultiPolygonFromWKB"
"GeomCollFromWKB
GeometryCollectionFromWKB"
BdPolyFromWKB
BdMPolyFromWKB
AsText
AsWKT
AsBinary
AsSVG
AsKml
GeomFromKml
AsGml
GeomFromGML
AsGeoJSON
GeomFromGeoJSON
AsEWKB
GeomFromEWKB
AsEWKT
GeomFromEWKT
AsFGF
GeomFromFGF
Dimension
CoordDimension
NDims
Is3D
IsMeasured
GeometryType
SRID
SetSRID
IsEmpty
IsSimple
IsValid
IsValidReason
IsValidDetail
Boundary
Envelope
Expand
NPoints
NRings
Reverse
ForceLHR
SanitizeGeometry
CompressGeometry
UncompressGeometry
CastToPoint
CastToLinestring
CastToPolygon
CastToMultiPoint
CastToMultiLinestring
CastToMultiPolygon
CastToGeometyCollection
CastToMulti
CastToSingle
CastToXY
CastToXYZ
CastToXYM
CastToXYZM
X
Y
Z
M
StartPoint
EndPoint
Length
Perimeter
Geodesic Length
Great Circle Length
IsClosed
IsRing
PointOnSurface
Simplify
SimplifyPreserveTopology
NumPoints
PointN
AddPoint
SetPoint
SetStartPoint
SetEndPoint
RemovePoint
Centroid
Area
ExteriorRing
"NumInteriorRing
NumInteriorRings"
InteriorRingN
NumGeometries
GeometryN
MbrEqual
MbrDisjoint
MbrTouches
MbrWithin
MbrOverlaps
MbrIntersects
EnvelopesIntersects
MbrContains
Equals
Disjoint
Touches
Within
Overlaps
Crosses
Intersects
Contains
Covers
CoveredBy
Relate
Distance
PtDistWithin
Intersection
Difference
GUnion
GUnion
SymDifference
Buffer
ConvexHull
HausdorffDistance
OffestCurve
SingleSidedBuffer
SharedPaths
Line_Interpolate_Point
Line_Interpolate_Equidistant_Points
Line_Locate_Point
Line_Substring
ClosestPoint
ShortestLine
Snap
Collect
Collect
LineMerge
BuildArea
Polygonize
MakePolygon
UnaryUnion
DissolveSegments
DissolvePoints
LinesFromRings
LinesCutAtNodes
RingsCutAtNodes
CollectionExtract
ExtractMultiPoint
ExtractMultiLinestring
ExtractMultiPolygon
LocateAlongMeasure
LocateBetweenMeasures
DelaunayTriangulation
VoronojDiagram
ConcaveHull
MakeValid
MakeValidDiscarded
Segmentize
Split
SplitLeft
SplitRight
Azimuth
Project
SnapToGrid
GeoHash
AsX3D
MaxDistance
3DDistance
3DMaxDistance
3dLength
ST_Node
SelfIntersections
Transform
SridFromAuthCRS
"ShiftCoords
ShiftCoordinates"
ST_Translate
ST_Shift_Longitude
NormalizeLonLat
"ScaleCoords
ScaleCoordinates"
"RotateCoords
RotateCoordinates"
"ReflectCoords
ReflectCoordinates"
"SwapCoords
SwapCoordinates"
ATM_Create
ATM_CreateTranslate
ATM_CreateScale
ATM_CreateRotate
ATM_CreateXRoll
ATM_CreateYRoll
ATM_Multiply
ATM_Translate
ATM_Scale
ATM_Rotate
ATM_XRoll
ATM_YRoll
ATM_Determinant
ATM_IsInvertible
ATM_Invert
ATM_IsValid
ATM_AsText
ATM_Transform
GCP_Compute
GCP_IsValid
GCP_AsText
GCP2ATM
GCP_Transform
InitSpatialMetaData
InsertEpsgSrid
AddGeometryColumn
RecoverGeometryColumn
DiscardGeometryColumn
RegisterVirtualGeometry
DropVirtualGeometry
CreateSpatialIndex
CreateMbrCache
DisableSpatialIndex
CheckShadowedRowid
CheckWithoutRowid
CheckSpatialIndex
RecoverSpatialIndex
InvalidateLayerStatistics
UpdateLayerStatistics
GetLayerExtent
CreateRasterCoveragesTable
CreateVectorCoveragesTables
RebuildGeometryTriggers
UpgradeGeometryTriggers
CreateMetaCatalogTables
UpdateMetaCatalogStatistics
CreateStylingTables
SE_RegisterVectorCoverage
SE_UnregisterVectorCoverage
SE_SetVectorCoverageInfos
SE_RegisterVectorCoverageSrid
SE_UnregisterVectorCoverageSrid
SE_UpdateVectorCoverageExtent
SE_RegisterVectorCoverageKeyword
SE_UnregisterVectorCoverageKeyword
SE_RegisterExternalGraphic
SE_UnregisterExternalGraphic
SE_RegisterVectorStyle
SE_UnregisterVectorStyle
SE_ReloadVectorStyle
SE_RegisterVectorStyledLayer
SE_UnregisterVectorStyledLayer
SE_RegisterRasterStyle
SE_UnregisterRasterStyle
SE_ReloadRasterStyle
SE_RegisterRasterStyledLayer
SE_UnregisterRasterStyledLayer
SE_RegisterRasterCoverageSrid
SE_UnregisterRasterCoverageSrid
SE_UpdateRasterCoverageExtent
SE_RegisterRasterCoverageKeyword
SE_UnregisterRasterCoverageKeyword
SE_SetStyledGroupInfos
SE_UnregisterStyledGroup
SE_RegisterStyledGroupVector
SE_RegisterStyledGroupRaster
SE_SetStyledGroupLayerPaintOrder
SE_SetStyledGroupVectorPaintOrder
SE_SetStyledGroupRasterPaintOrder
SE_UnregisterStyledGroupLayer
SE_UnregisterStyledGroupVector
SE_UnregisterStyledGroupRaster
SE_RegisterGroupStyle
SE_UnregisterGroupStyle
SE_ReloadGroupStyle
SE_RegisterStyledGroupStyle
SE_UnregisterStyledGroupStyle
CreateIsoMetadataTables
RegisterIsoMetadata
GetIsoMetadataId
CheckSpatialMetaData
AutoFDOStart
AutoFDOStop
InitFDOSpatialMetaData
AddFDOGeometryColumn
RecoverFDOGeometryColumn
DiscardFDOGeometryColumn
CheckGeoPackageMetaData
AutoGPKGStart
AutoGPKGStop
gpkgCreateBaseTables
gpkgInsertEpsgSRID
gpkgCreateTilesTable
gpkgCreateTilesZoomLevel
gpkgAddTileTriggers
gpkgGetNormalZoom
gpkgGetNormalRow
gpkgGetImageType
gpkgAddGeometryColumn
gpkgAddGeometryTriggers
gpkgAddSpatialIndex
gpkgMakePoint
gpkgMakePointZ
gpkgMakePointM
gpkgMakePointZM
IsValidGPB
AsGPB
GeomFromGPB
CastAutomagic
GPKG_IsAssignable
FilterMbrWithin
FilterMbrContains
FilterMbrIntersects
BuildMbrFilter
RTreeIntersects
RTreeWithin
RTreeContains
RTreeDistWithin
XB_Create
XB_GetPayload
XB_GetDocument
XB_SchemaValidate
XB_Compress
XB_Uncompress
XB_IsValid
XB_IsCompressed
XB_IsSchemaValidated
XB_IsIsoMetadata
XB_IsSldSeVectorStyle
XB_IsSldSeRasterStyle
XB_IsSvg
XB_IsGpx
XB_GetDocumentSize
XB_GetEncoding
XB_GetSchemaURI
XB_GetInternalSchemaURI
XB_GetFileId
XB_SetFileId
XB_AddFileId
XB_GetParentId
XB_SetParentId
XB_AddParentId
XB_GetTitle
XB_GetAbstract
XB_GetGeometry
XB_MLineFromGPX
XB_GetLastParseError
XB_GetLastValidateError
XB_IsValidXPathExpression
XB_GetLastXPathError
XB_CacheFlush
XB_LoadXML
XB_StoreXML
SQL functions supporting SRID inspection
Function
SridIsGeographic
SridIsProjected
SridHasFlippedAxes
SridGetSpheroid
SridGetPrimeMeridian
SridGetDatum
SridGetUnit
SridGetProjection
SridGetAxis_1_Name
SridGetAxis_1_Orientation
SridGetAxis_2_Name
SridGetAxis_2_Orientation
GetLastTopologyException
InitTopoGeo
CreateTopology
DropTopology
AddIsoNode
MoveIsoNode
RemIsoNode
AddIsoEdge
ChangeEdgeGeom
RemIsoEdge
NewEdgesSplit
ModEdgeSplit
NewEdgeHeal
ModEdgeHeal
AddEdgeNewFaces
AddEdgeModFace
RemEdgeNewFace
RemEdgeModFace
GetFaceGeometry
GetFaceEdges
ValidateTopoGeo
CreateTopoGeo
GetNodeByPoint
GetEdgeByPoint
GetFaceByPoint
TopoGeo_AddPoint
TopoGeo_AddLineString
TopoGeo_SubdivideLines
TopoGeo_FromGeoTable
TopoGeo_Clone
TopoGeo_GetEdgeSeed
TopoGeo_GetFaceSeed
TopoGeo_UpdateSeeds
TopoGeo_ToGeoTable
TopoGeo_ToGeoTableGeneralize
TopoGeo_CreateTopoLayer
TopoGeo_InitTopoLayer
TopoGeo_RemoveTopoLayer
TopoGeo_ExportTopoLayer
TopoGeo_InsertFeatureFromTopoLayer
GetLastNetworkException
InitTopoNet
CreateNetwork
DropNetwork
AddIsoNetNode
MoveIsoNetNode
RemIsoNetNode
AddLink
ChangeLinkGeom
RemoveLink
NewLogLinkSplit
ModLogLinkSplit
NewGeoLinkSplit
ModGeoLinkSplit
NewLinkHeal
ModLinkHeal
LogiNetFromTGeo
SpatNetFromTGeo
SpatNetFromGeom
ValidLogicalNet
ValidSpatialNet
GetNetNodeByPoint
GetLinkByPoint
TopoNet_FromGeoTable
TopoNet_Clone
TopoNet_GetLinkSeed
TopoNet_UpdateSeeds
TopoNet_ToGeoTable
TopoNet_ToGeoTableGeneralize
CloneTable
CreateClonedTable
CheckDuplicateRows
RemoveDuplicateRows
ElementaryGeometries
DropGeoTable
ImportSHP
ExportSHP
ImportDBF
ExportDBF
ExportKML
ExportGeoJSON
ImportXLS
ImportWFS
ImportDXF
ImportDXFfromDir
ExportDXF
ST_Cutter
GetCutterMessage
© 2015 - 2024 Weber Informatics LLC | Privacy Policy