-
Notifications
You must be signed in to change notification settings - Fork 4
/
createUDFs.sql
88 lines (88 loc) · 7.97 KB
/
createUDFs.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
CREATE OR REPLACE FUNCTION st_antimeridianSafeGeom as 'com.carto.analyticstoolbox.core.ST_AntimeridianSafeGeom';
CREATE OR REPLACE FUNCTION st_area as 'com.carto.analyticstoolbox.core.ST_Area';
CREATE OR REPLACE FUNCTION st_asBinary as 'com.carto.analyticstoolbox.core.ST_AsBinary';
CREATE OR REPLACE FUNCTION st_asGeoHash as 'com.carto.analyticstoolbox.core.ST_AsGeoHash';
CREATE OR REPLACE FUNCTION st_asGeoJson as 'com.carto.analyticstoolbox.core.ST_AsGeoJson';
CREATE OR REPLACE FUNCTION st_asLatLonText as 'com.carto.analyticstoolbox.core.ST_AsLatLonText';
CREATE OR REPLACE FUNCTION st_asText as 'com.carto.analyticstoolbox.core.ST_AsText';
CREATE OR REPLACE FUNCTION st_asTWKB as 'com.carto.analyticstoolbox.core.ST_AsTWKB';
CREATE OR REPLACE FUNCTION st_boundary as 'com.carto.analyticstoolbox.core.ST_Boundary';
CREATE OR REPLACE FUNCTION st_box2DFromGeoHash as 'com.carto.analyticstoolbox.core.ST_GeomFromGeoHash';
CREATE OR REPLACE FUNCTION st_bufferPoint as 'com.carto.analyticstoolbox.core.ST_BufferPoint';
CREATE OR REPLACE FUNCTION st_byteArray as 'com.carto.analyticstoolbox.core.ST_ByteArray';
CREATE OR REPLACE FUNCTION st_castToGeometry as 'com.carto.analyticstoolbox.core.ST_CastToGeometry';
CREATE OR REPLACE FUNCTION st_castToLineString as 'com.carto.analyticstoolbox.core.ST_CastToLineString';
CREATE OR REPLACE FUNCTION st_castToPoint as 'com.carto.analyticstoolbox.core.ST_CastToPoint';
CREATE OR REPLACE FUNCTION st_castToPolygon as 'com.carto.analyticstoolbox.core.ST_CastToPolygon';
CREATE OR REPLACE FUNCTION st_centroid as 'com.carto.analyticstoolbox.core.ST_Centroid';
CREATE OR REPLACE FUNCTION st_closestPoint as 'com.carto.analyticstoolbox.core.ST_ClosestPoint';
CREATE OR REPLACE FUNCTION st_contains as 'com.carto.analyticstoolbox.core.ST_Contains';
CREATE OR REPLACE FUNCTION st_convexHull as 'com.carto.analyticstoolbox.core.ST_ConvexHull';
CREATE OR REPLACE FUNCTION st_coordDim as 'com.carto.analyticstoolbox.core.ST_CoordDim';
CREATE OR REPLACE FUNCTION st_covers as 'com.carto.analyticstoolbox.core.ST_Covers';
CREATE OR REPLACE FUNCTION st_crosses as 'com.carto.analyticstoolbox.core.ST_Crosses';
CREATE OR REPLACE FUNCTION st_difference as 'com.carto.analyticstoolbox.core.ST_Difference';
CREATE OR REPLACE FUNCTION st_dimension as 'com.carto.analyticstoolbox.core.ST_Dimension';
CREATE OR REPLACE FUNCTION st_disjoint as 'com.carto.analyticstoolbox.core.ST_Disjoint';
CREATE OR REPLACE FUNCTION st_distance as 'com.carto.analyticstoolbox.core.ST_Distance';
CREATE OR REPLACE FUNCTION st_distanceSphere as 'com.carto.analyticstoolbox.core.ST_DistanceSphere';
CREATE OR REPLACE FUNCTION st_envelope as 'com.carto.analyticstoolbox.core.ST_Envelope';
CREATE OR REPLACE FUNCTION st_equals as 'com.carto.analyticstoolbox.core.ST_Equals';
CREATE OR REPLACE FUNCTION st_exteriorRing as 'com.carto.analyticstoolbox.core.ST_ExteriorRing';
CREATE OR REPLACE FUNCTION st_geoHash as 'com.carto.analyticstoolbox.core.ST_GeoHash';
CREATE OR REPLACE FUNCTION st_geomFromGeoHash as 'com.carto.analyticstoolbox.core.ST_GeomFromGeoHash';
CREATE OR REPLACE FUNCTION st_geomFromGeoJson as 'com.carto.analyticstoolbox.core.ST_GeomFromGeoJson';
CREATE OR REPLACE FUNCTION st_geometryFromText as 'com.carto.analyticstoolbox.core.ST_GeomFromWKT';
CREATE OR REPLACE FUNCTION st_geomFromTWKB as 'com.carto.analyticstoolbox.core.ST_GeomFromTWKB';
CREATE OR REPLACE FUNCTION st_geomFromWKB as 'com.carto.analyticstoolbox.core.ST_GeomFromWKB';
CREATE OR REPLACE FUNCTION st_geomFromWKT as 'com.carto.analyticstoolbox.core.ST_GeomFromWKT';
CREATE OR REPLACE FUNCTION st_geometryN as 'com.carto.analyticstoolbox.core.ST_GeometryN';
CREATE OR REPLACE FUNCTION st_idlSafeGeom as 'com.carto.analyticstoolbox.core.ST_AntimeridianSafeGeom';
CREATE OR REPLACE FUNCTION st_interiorRingN as 'com.carto.analyticstoolbox.core.ST_InteriorRingN';
CREATE OR REPLACE FUNCTION st_intersection as 'com.carto.analyticstoolbox.core.ST_Intersection';
CREATE OR REPLACE FUNCTION st_intersects as 'com.carto.analyticstoolbox.core.ST_Intersects';
CREATE OR REPLACE FUNCTION st_icClosed as 'com.carto.analyticstoolbox.core.ST_IsClosed';
CREATE OR REPLACE FUNCTION st_isCollection as 'com.carto.analyticstoolbox.core.ST_IsCollection';
CREATE OR REPLACE FUNCTION st_isEmpty as 'com.carto.analyticstoolbox.core.ST_IsEmpty';
CREATE OR REPLACE FUNCTION st_isGeomField as 'com.carto.analyticstoolbox.core.ST_IsGeomField';
CREATE OR REPLACE FUNCTION st_isRing as 'com.carto.analyticstoolbox.core.ST_IsRing';
CREATE OR REPLACE FUNCTION st_isSimple as 'com.carto.analyticstoolbox.core.ST_IsSimple';
CREATE OR REPLACE FUNCTION st_isValid as 'com.carto.analyticstoolbox.core.ST_IsValid';
CREATE OR REPLACE FUNCTION st_length as 'com.carto.analyticstoolbox.core.ST_Length';
CREATE OR REPLACE FUNCTION st_lengthSphere as 'com.carto.analyticstoolbox.core.ST_LengthSphere';
CREATE OR REPLACE FUNCTION st_lineFromText as 'com.carto.analyticstoolbox.core.ST_LineFromText';
CREATE OR REPLACE FUNCTION st_makeBBOX as 'com.carto.analyticstoolbox.core.ST_MakeBBOX';
CREATE OR REPLACE FUNCTION st_makeBox2D as 'com.carto.analyticstoolbox.core.ST_MakeBox2D';
CREATE OR REPLACE FUNCTION st_makeLine as 'com.carto.analyticstoolbox.core.ST_MakeLine';
CREATE OR REPLACE FUNCTION st_makePoint as 'com.carto.analyticstoolbox.core.ST_MakePoint';
CREATE OR REPLACE FUNCTION st_makePointM as 'com.carto.analyticstoolbox.core.ST_MakePointM';
CREATE OR REPLACE FUNCTION st_makePolygon as 'com.carto.analyticstoolbox.core.ST_MakePolygon';
CREATE OR REPLACE FUNCTION st_mLineFromText as 'com.carto.analyticstoolbox.core.ST_MLineFromText';
CREATE OR REPLACE FUNCTION st_mPointFromText as 'com.carto.analyticstoolbox.core.ST_MPointFromText';
CREATE OR REPLACE FUNCTION st_mPolyFromText as 'com.carto.analyticstoolbox.core.ST_MPolyFromText';
CREATE OR REPLACE FUNCTION st_numGeometries as 'com.carto.analyticstoolbox.core.ST_NumGeometries';
CREATE OR REPLACE FUNCTION st_numPoints as 'com.carto.analyticstoolbox.core.ST_NumPoints';
CREATE OR REPLACE FUNCTION st_overlaps as 'com.carto.analyticstoolbox.core.ST_Overlaps';
CREATE OR REPLACE FUNCTION st_pointFromGeoHash as 'com.carto.analyticstoolbox.core.ST_PointFromGeoHash';
CREATE OR REPLACE FUNCTION st_pointFromText as 'com.carto.analyticstoolbox.core.ST_PointFromText';
CREATE OR REPLACE FUNCTION st_pointFromWKB as 'com.carto.analyticstoolbox.core.ST_PointFromWKB';
CREATE OR REPLACE FUNCTION st_pointN as 'com.carto.analyticstoolbox.core.ST_PointN';
CREATE OR REPLACE FUNCTION st_polygonFromText as 'com.carto.analyticstoolbox.core.ST_PolygonFromText';
CREATE OR REPLACE FUNCTION st_relate as 'com.carto.analyticstoolbox.core.ST_Relate';
CREATE OR REPLACE FUNCTION st_relateBool as 'com.carto.analyticstoolbox.core.ST_RelateBool';
CREATE OR REPLACE FUNCTION st_simplify as 'com.carto.analyticstoolbox.core.ST_Simplify';
CREATE OR REPLACE FUNCTION st_simplifyPreserveTopology as 'com.carto.analyticstoolbox.core.ST_SimplifyPreserveTopology';
CREATE OR REPLACE FUNCTION st_touches as 'com.carto.analyticstoolbox.core.ST_Touches';
CREATE OR REPLACE FUNCTION st_translate as 'com.carto.analyticstoolbox.core.ST_Translate';
CREATE OR REPLACE FUNCTION st_within as 'com.carto.analyticstoolbox.core.ST_Within';
CREATE OR REPLACE FUNCTION st_x as 'com.carto.analyticstoolbox.core.ST_X';
CREATE OR REPLACE FUNCTION st_y as 'com.carto.analyticstoolbox.core.ST_Y';
-- indexing functions
CREATE OR REPLACE FUNCTION H3_ToParent as 'com.carto.analyticstoolbox.index.H3_ToParent';
CREATE OR REPLACE FUNCTION st_crsFromText as 'com.carto.analyticstoolbox.index.ST_CrsFromText';
CREATE OR REPLACE FUNCTION st_extentFromGeom as 'com.carto.analyticstoolbox.index.ST_ExtentFromGeom';
CREATE OR REPLACE FUNCTION st_extentToGeom as 'com.carto.analyticstoolbox.index.ST_ExtentToGeom';
CREATE OR REPLACE FUNCTION st_geomReproject as 'com.carto.analyticstoolbox.index.ST_GeomReproject';
CREATE OR REPLACE FUNCTION st_makeExtent as 'com.carto.analyticstoolbox.index.ST_MakeExtent';
CREATE OR REPLACE FUNCTION st_partitionCentroid as 'com.carto.analyticstoolbox.index.ST_PartitionCentroid';
CREATE OR REPLACE FUNCTION st_z2LatLon as 'com.carto.analyticstoolbox.index.ST_Z2LatLon';