split_polygon_n¶

In [ ]:

split_polygon_n(p: str, 
                cursor=None, 
                nbins: int = 100)

Splits a polygon into (nbins ** 2) smaller polygons with approximately the same total area.

Parameters¶

Name	Type	Optional	Description
p	str	❌	String representation of the Polygon.
cursor	DBcursor	✓	Vertica database cursor.
nbins	int	✓	Number of bins used to cut the longitude and the latitude.

Returns¶

vDataFrame : output vDataFrame including the new polygons.

Example¶

In [32]:

from verticapy.geo import *
from verticapy import *

p = 'POLYGON ((121.334030916 31.5081948415, 121.334030917 31.5079167872, 121.333748304 31.5081948413, 121.334030916 31.5081948415))'
poly = tablesample({"triangle": [p]}).to_vdf()
poly["triangle"].apply("ST_GeomFromText({})")
poly["triangle"].geo_plot(color="white",
                          edgecolor="black")

Out[32]:

<AxesSubplot:>

In [33]:

split_p = split_polygon_n(p)
split_p

Out[33]:

	123 gid Int	🌎 Geometry(2024)
1	99
2	100
3	199
4	200
5	201
6	299
7	300
8	301
9	302
10	399
11	400
12	401
13	402
14	403
15	499
16	500
17	501
18	502
19	503
20	504
21	599
22	600
23	601
24	602
25	603
26	604
27	605
28	699
29	700
30	701
31	702
32	703
33	704
34	705
35	706
36	799
37	800
38	801
39	802
40	803
41	804
42	805
43	806
44	807
45	899
46	900
47	901
48	902
49	903
50	904
51	905
52	906
53	907
54	908
55	999
56	1000
57	1001
58	1002
59	1003
60	1004
61	1005
62	1006
63	1007
64	1008
65	1009
66	1099
67	1100
68	1101
69	1102
70	1103
71	1104
72	1105
73	1106
74	1107
75	1108
76	1109
77	1110
78	1199
79	1200
80	1201
81	1202
82	1203
83	1204
84	1205
85	1206
86	1207
87	1208
88	1209
89	1210
90	1211
91	1299
92	1300
93	1301
94	1302
95	1303
96	1304
97	1305
98	1306
99	1307
100	1308

Rows: 1-100 | Columns: 2

In [34]:

split_p["geom"].geo_plot(color="white",
                         edgecolor="black")

Out[34]:

<AxesSubplot:>