read_shp

In [ ]:
read_shp(path: str, 
         cursor=None, 
         schema: str = "public", 
         table_name: str = "",)

Ingests a SHP file. Currently, only files stored in a Vertica database can be ingested.

Parameters

Name Type Optional Description
path
str
Absolute path where the SHP file is located.
cursor
DBcursor
Vertica DB cursor.
schema
str
Schema where the SHP file will be ingested.
table_name
str
Final relation name.

Returns

vDataFrame : The vDataFrame of the relation.

Example

In [52]:
from verticapy.utilities import *

# Ingesting the SHP file
read_shp("/home/dbadmin/toulouse_buildings/toulouse_buildings.shp", 
         schema = "public", 
         table_name = "buildings")
The table "public"."buildings" has been successfully created.
Out[52]:
123
gid
Int
Abc
osm_id
Varchar(10)
Abc
lastchange
Varchar(20)
123
code
Int
Abc
fclass
Varchar(28)
Abc
geomtype
Varchar(1)
Abc
Varchar(100)
Abc
type
Varchar(20)
123
height
Int
123
levels
Int
🌎
Geometry(17661)
1180740322016-11-19T21:26:49Z1500buildingWretail00
22103601902016-01-13T22:35:34Z1500buildingWhall00
33146871872015-05-03T21:20:49Z1500buildingW00
44148043882012-03-15T17:58:33Z1500buildingW00
55170278462016-09-22T12:28:59Z1500buildingW00
66170278672017-05-12T14:32:24Z1500buildingW00
77170282322016-01-14T19:28:48Z1500buildingW00
88170282922016-01-14T19:28:48Z1500buildingW00
99186281292016-01-19T19:02:25Z1500buildingW00
1010186281582015-06-02T14:23:04Z1500buildingW00
1111186281672016-01-19T19:02:25Z1500buildingW00
1212186282362017-01-27T10:23:10Z1500buildingW04
1313186283062016-09-22T12:47:11Z1500buildingW00
1414186286262016-09-23T12:24:13Z1500buildingW00
1515186286522016-09-22T12:13:16Z1500buildingW00
1616186287102016-09-22T12:51:21Z1500buildingW00
1717186287932013-01-23T23:32:14Z1500buildingW00
1818186288222013-01-23T23:34:20Z1500buildingW00
1919186289002011-10-28T11:58:22Z1500buildingW00
2020186289582016-09-23T12:24:13Z1500buildingW00
2121186290112013-01-23T23:34:13Z1500buildingW00
2222186290542011-01-06T16:44:55Z1500buildingW00
2323187522622016-09-22T12:08:54Z1500buildingW00
2424187523462016-01-19T19:02:12Z1500buildingW00
2525187524912014-01-26T19:52:04Z1500buildingWuniversity00
2626187532222016-01-19T19:02:15Z1500buildingW00
2727187532772013-01-23T23:34:21Z1500buildingW00
2828187533092016-01-19T19:02:15Z1500buildingW00
2929187533632016-01-14T19:28:50Z1500buildingW00
3030187534172014-01-19T16:13:09Z1500buildingWcivic00
3131187952912011-06-15T01:58:47Z1500buildingW00
3232210434222010-09-07T13:57:20Z1500buildingW00
3333210531712017-05-27T10:22:10Z1500buildingWchurch00
3434212465222011-12-10T16:59:20Z1500buildingWoffice00
3535223871302010-04-19T23:31:53Z1500buildingW00
3636223871322010-04-19T23:31:48Z1500buildingW00
3737226894232017-03-22T20:29:28Z1500buildingW140
3838227177862016-04-07T20:17:49Z1500buildingWpublic00
3939227177872016-04-07T20:17:48Z1500buildingWpublic013
4040227177882016-04-07T20:17:47Z1500buildingWno00
4141227182532015-07-20T22:29:26Z1500buildingW00
4242227681712015-10-12T00:49:15Z1500buildingW100
4343227767372016-02-05T15:44:23Z1500buildingWshop00
4444227767382017-01-29T12:22:49Z1500buildingWretail00
4545227767612017-01-29T12:22:49Z1500buildingWretail00
4646227768412016-02-05T15:44:24Z1500buildingW00
4747227795632013-12-08T09:49:28Z1500buildingWapartments00
4848227795642013-12-08T09:49:27Z1500buildingWapartments00
4949227797432016-02-22T19:55:13Z1500buildingW00
5050227797442016-02-22T19:55:11Z1500buildingW00
5151227797612013-12-25T01:00:58Z1500buildingWindustrial00
5252227891932012-07-19T19:42:39Z1500buildingW00
5353227891942013-01-23T23:33:23Z1500buildingW00
5454227891952010-03-17T01:34:01Z1500buildingW00
5555227891962012-07-19T19:42:37Z1500buildingW00
5656227891982013-01-23T23:33:22Z1500buildingW00
5757227891992013-01-23T23:33:23Z1500buildingW00
5858228018982013-01-09T22:26:35Z1500buildingW00
5959228963772017-04-03T10:47:21Z1500buildingW00
6060229152532016-01-14T19:28:50Z1500buildingW00
6161229152552013-01-23T23:32:16Z1500buildingW00
6262229152562013-01-23T23:32:16Z1500buildingW00
6363229152572016-01-14T19:28:50Z1500buildingW00
6464229155442016-01-14T19:28:51Z1500buildingWtrain_station00
6565229478652016-01-14T22:28:38Z1500buildingW00
6666229744482015-11-21T01:27:33Z1500buildingW00
6767229891992016-02-21T19:17:17Z1500buildingW03
6868229892012016-02-21T19:17:17Z1500buildingW03
6969229892022016-02-21T19:17:17Z1500buildingW03
7070229893902013-01-23T23:33:23Z1500buildingW00
7171229893942013-01-23T23:33:23Z1500buildingW00
7272229989302014-10-04T21:38:17Z1500buildingW00
7373229989322014-10-04T21:38:16Z1500buildingW00
7474230275712016-02-24T19:35:44Z1500buildingW00
7575230275722016-02-24T19:35:44Z1500buildingW00
7676230275872016-02-24T19:35:43Z1500buildingW00
7777230275902016-02-24T19:35:44Z1500buildingW00
7878230275952016-02-24T19:35:40Z1500buildingW00
7979230276002014-03-03T12:45:11Z1500buildingW00
8080230276022016-06-13T15:35:06Z1500buildingW00
8181230276192016-04-05T09:42:28Z1500buildingW00
8282230276212016-04-05T09:43:02Z1500buildingW00
8383230276222016-02-24T19:35:36Z1500buildingW00
8484231495912010-02-02T08:50:27Z1500buildingW00
8585232474642017-04-05T14:37:20Z1500buildingW00
8686233152102017-01-16T20:44:01Z1500buildingWchurch00
8787234973812016-12-12T16:13:57Z1500buildingW00
8888238014822010-04-20T00:43:16Z1500buildingW00
8989238014852010-04-20T00:43:17Z1500buildingW00
9090238995652015-11-03T20:26:33Z1500buildingW00
9191239050902013-01-23T23:34:13Z1500buildingW00
9292239051632017-01-27T10:21:14Z1500buildingW04
9393239052832013-01-23T23:34:19Z1500buildingW00
9494239053152016-09-22T14:57:43Z1500buildingW00
9595239053352016-01-19T19:02:13Z1500buildingW00
9696239053792013-01-23T23:34:21Z1500buildingW00
9797239054772009-11-07T13:30:13Z1500buildingW00
9898239054872016-09-22T14:57:43Z1500buildingW00
9999239056192010-03-02T21:17:11Z1500buildingW00
100100239056592013-01-23T23:34:14Z1500buildingW00
Rows: 1-100 | Columns: 11