[SEDONA-58] is there a good way to form multipoint

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Assignee: Unassigned
• Reporter: blingqiu
• Created: 11/Aug/21 13:30
• Updated: 17/Apr/22 06:07
• Resolved: 14/Nov/21 19:25

Description

I get a collect of lng and lat array, how to form a multipoint geom?
sql1 = f"""
select
buyer_addr_state,buyer_addr,
collect_list(array(geo_lng,geo_lat)) as pins,
count(1) as pins_cnt
from tmp_my_address_tab_tab
group by buyer_addr_state,buyer_addr
"""
df1 = spark.sql(sql1)
 

Issue Links

• is fixed by: SEDONA-68 Add ST_Collect function to Apache Sedona.
• is fixed by: SEDONA-69 Add merging geometries functions to geometry collection or multi geometry while using group by statement
• relates to: SEDONA-69 Add merging geometries functions to geometry collection or multi geometry while using group by statement