Improve SHPRead function ?

[ebocher]

It would be nice if the SHPRead function returns a ValueResulSet as CSVRead function. So the user will be able to do something like

SELECT SUM(ST_AREA(THE_GEOM)) AS total from (SELECT * FROM SHPREAD('/tmp/myFile.shp')) GROUP BY CODE_INSEE;

It is closer to the SQL syntax than "CALL SHPRead".

[nicolas-f]

SHPREAD must create a primary key column. This thing is not possible with table result set.

[ebocher]

So you think that we cannot emulate a SERIAL column with a SimpleResultSet ?

[nicolas-f]

SERIAL is not a column type its an alias for auto increment primary key when creating tables.

[ebocher]

Ok. According to you it's not possible to do that ?

[nicolas-f]

It should be another function name.

[ebocher]

Maybe :

SHPREAD -> Read a file
SHPImport -> Import a file (previously SHPREAD)

[ebocher]

@gpetit

[gpetit]

Ok to distinguish the behaviours.

• SHPRead : the shape file is imported as a whole and there is no possibility to make query on it.
• SHPImport : the shape file is imported and we can call it thanks to sub query

In both cases, a PK is added

[ebocher]

When the SHP is imported the data are stored in the database so you can do what you want in SQL.

[gpetit]

Yes I know but your initial question was to be able to make SQL selection during the import step (not once the shp is stored into a table) ? Isn't it ?

[ebocher]

It would be nice to support this syntax for all driver functions

CALL SHPWRITE('/tmp/theshape.shp', '(SELECT * FROM geomtable where st_area(the_geom) >10000 )');

[ebocher]

CALL SHPWRITE('/tmp/theshape.shp', '(SELECT * FROM geomtable where st_area(the_geom) >10000 )'[,encoding] );

is now supported

@gpetit

[ebocher]

@gpetit ping for doc

[gpetit]

I'm on it

[gpetit]

The SHPWRITE function has been updated (in the code and the doc).
But what about the SHPREAD one ? Are we still planning to update it following @ebocher 's reflexions?

[ebocher]

SHPREAD has been updated with the signature :

 addProperty(PROP_REMARKS, "Read a shape file and copy the content in the specified table."+
                "\n SHPRead(..."+
                "\n Supported arguments :" +
                "\n path of the file" +
                "\n path of the file, table name"+
                "\n path of the file, true for delete the table with the same file name"+
                "\n path of the file, table name, true to delete the table name"+
                "\n path of the file, table name, true to delete the table name"+
                "\n path of the file, table name, encoding chartset"+
                "\n path of the file, table name, encoding chartset, true to delete the table name");

Note that SHPRead doesn't support zip archive as entry

[gpetit]

Ok thanks