SHPRead
Signatures
SHPRead(VARCHAR path);
SHPRead(VARCHAR path, VARCHAR tableName);
SHPRead(VARCHAR path, VARCHAR tableName, VARCHAR fileEncoding);Description
Reads the file specified by path as a shapefile and copies its
contents into a new table tableName in the database.
Define fileEncoding to force encoding (useful when the header is
missing encoding information).
If the tablename parameter is not specified, then the resulting table has the same name as the shapefile.
Warning on the input file name
When a tablename is not specified, special caracters in the input file name are not allowed. The possible caracters are as follow: A to Z, _ and 0 to 9.
Examples
-- Basic syntax:
CALL SHPRead('/home/user/file.shp', 'tableName');
-- In the next two examples, we show what happens when we attempt to
-- read a SHP file with the wrong encoding, and how to fix it. Here
-- UTF-8 doesn't understand accented characters, so "Sévérac" is
-- displayed as "S".
CALL SHPRead('/home/user/COMMUNE.SHP', 'commune44utf',
'utf-8');
SELECT * FROM commune44utf LIMIT 2;
-- Answer:
-- | THE_GEOM | NOM |
-- | ----------------------------------------- | ------- |
-- | MULTIPOLYGON(((350075.2 6719771.8, | Puceul |
-- | 350072.7 6719775.5, 350073 6719780.7, | |
-- | 350075.2 6719771.8))) | |
-- | MULTIPOLYGON(((317341.5 6727021, | S |
-- | 317309.9 6727036.8, 317193.3 6727066.5, | |
-- | 317341.5 6727021))) | |
-- To fix this problem, we specify the right encoding:
CALL SHPRead('/home/user/COMMUNE.SHP', 'commune44iso',
'iso-8859-1');
SELECT * FROM commune44iso LIMIT 2;
-- Answer:
-- | THE_GEOM | NOM |
-- | ----------------------------------------- | ------- |
-- | MULTIPOLYGON(((350075.2 6719771.8, | Puceul |
-- | 350072.7 6719775.5, 350073 6719780.7, | |
-- | 350075.2 6719771.8))) | |
-- | MULTIPOLYGON(((317341.5 6727021, | Sévérac |
-- | 317309.9 6727036.8, 317193.3 6727066.5, | |
-- | 317341.5 6727021))) | |