ducktype spatial

2024-10-09  本文已影响0人  hehehehe
    t = conn.sql(f"select ST_GeomFromText('{wkt}') as geom")
    conn.sql(f"select linestring_length_2d('{wkt}') from t ").show()
    # conn.sql(f"select ST_Length(ST_GeomFromText('{wkt}'))").show()
    conn.sql(f"select ST_NPoints(geom),ST_NumGeometries(geom),ST_Length(geom),"
             f"ST_FlipCoordinates(geom) "
             f" from t").show()
    conn.sql(f"select  ST_Points(geom),ST_Length_Spheroid(ST_FlipCoordinates(geom)),"
             f"ST_ZMax(geom),ST_Distance(ST_GeomFromText('point(116 38)'),ST_GeomFromText('point(116 39)')),"
             f"ST_Distance_Sphere(ST_GeomFromText('point(115 39)'),ST_GeomFromText('point(116 39)'))"
             f" from t").show()
上一篇 下一篇

猜你喜欢

热点阅读