vDataFrame.to_shp¶

In [ ]:

vDataFrame.to_shp(name: str,
                  path: str, 
                  usecols: list = [],
                  overwrite: bool = True,
                  shape: str = "Polygon",)

Creates a SHP file of the current vDataFrame relation. These files are exported to the Vertica database.

Parameters¶

Name	Type	Optional	Description
name	str	❌	Name of the SHP file.
path	str	❌	Absolute path to which to save the SHP file.
usecols	list	✓	vcolumns to select from the final vDataFrame relation. If empty, all the vcolumns will be selected.
overwrite	bool	✓	If set to True, the function will overwrite the index if an index exists.
shape	str	✓	One of the following spatial classes: Point, Polygon, Linestring, Multipoint, Multipolygon, Multilinestring. Polygons and Multipolygons always have a clockwise orientation.

Returns¶

vDataFrame : self

Example¶

In [9]:

from verticapy.datasets import load_cities
cities = load_cities()
display(cities)

	Abc city Varchar(82)	🌎 Geometry(1048576)
1	Abidjan
2	Abu Dhabi
3	Abuja
4	Accra
5	Addis Ababa
6	Algiers
7	Amman
8	Amsterdam
9	Andorra
10	Ankara
11	Antananarivo
12	Apia
13	Ashgabat
14	Asmara
15	Astana
16	Asuncion
17	Athens
18	Baghdad
19	Baku
20	Bamako
21	Bandar Seri Begawan
22	Bangkok
23	Bangui
24	Banjul
25	Basseterre
26	Beijing
27	Beirut
28	Belgrade
29	Belmopan
30	Berlin
31	Bern
32	Bishkek
33	Bissau
34	Bloemfontein
35	Bogota
36	Brasilia
37	Bratislava
38	Brazzaville
39	Bridgetown
40	Brussels
41	Bucharest
42	Budapest
43	Buenos Aires
44	Bujumbura
45	Cairo
46	Canberra
47	Cape Town
48	Caracas
49	Castries
50	Chisinau
51	Colombo
52	Conakry
53	Cotonou
54	Dakar
55	Damascus
56	Dar es Salaam
57	Dhaka
58	Dili
59	Djibouti
60	Doha
61	Dublin
62	Dushanbe
63	Freetown
64	Funafuti
65	Gaborone
66	Georgetown
67	Guatemala
68	Hanoi
69	Harare
70	Hargeysa
71	Havana
72	Helsinki
73	Honiara
74	Islamabad
75	Jakarta
76	Jerusalem
77	Johannesburg
78	Juba
79	Kabul
80	Kampala
81	Kathmandu
82	Khartoum
83	Kiev
84	Kigali
85	Kingston
86	Kingstown
87	Kinshasa
88	Kuala Lumpur
89	Kuwait
90	København
91	La Paz
92	Libreville
93	Lilongwe
94	Lima
95	Lisbon
96	Ljubljana
97	Lome
98	London
99	Luanda
100	Lusaka

Rows: 1-100 | Columns: 2

In [12]:

# Creating the SHP file of the current vDataFrame
# A folder will be created
cities.to_shp("cities", 
              "/home/dbadmin/",
              shape = "Point")