Importing shpfiles in python about noisemodelling HOT 6 CLOSED

Have you followed the tutorial https://github.com/Ifsttar/NoiseModelling/wiki/11-Scripting-with-Python

Does it run without errors ?

from noisemodelling.

Yes, the tutorial runs without errors.
However, when importing a shapefile for the buildings, instead of creating mock building via SQL commands, this happens:
CALL SHPREAD('/home/USER/orbisgis_noise/orbisgis_h2gis/input_shape/buildings_shp/buildings.shp', 'buildings');
org.h2.jdbc.JdbcSQLException:
General error: "java.lang.NullPointerException" [50000-182]; SQL statement:

       CALL SHPREAD('/home/USER/orbisgis_noise/orbisgis_h2gis/input_shape/buildings_shp/buildings.shp', 'buildings') [0-182]
at org.h2.message.DbException.addSQL(DbException.java:132)
at org.h2.command.Command.executeQuery(Command.java:213)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:179)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158)
at org.h2.server.pg.PgServerThread.process(PgServerThread.java:392)
at org.h2.server.pg.PgServerThread.run(PgServerThread.java:90)
at java.lang.Thread.run(Thread.java:748)

Thanks for your help!

from noisemodelling.

Hi !

I've updated the tutorial for the last version of NoiseModelling released.

I've tested to use 'Call SPHREAD', and 'CALL TABLE_FILE' too. And it worked after I've removed the line "create table buildings ( the_geom GEOMETRY );" in the python script.

Can you try this ?

from noisemodelling.

maybe there is something wrong with my shapefile. would you be able to provide your test shp file?
Thank you!

from noisemodelling.

CALL SHPREAD('/home/andre/noise_new/orbisgis-noisemodelling-2018-07-18/input_shape/buildings_shp/buildings.shp', 'buildings');
org.h2.jdbc.JdbcSQLException:
General error: "java.lang.NullPointerException" [50000-197]; SQL statement:

    CALL SHPREAD('/home/andre/noise_new/orbisgis-noisemodelling-2018-07-18/input_shape/buildings_shp/buildings.shp', 'buildings') [0-197]
    at org.h2.message.DbException.addSQL(DbException.java:133)
    at org.h2.command.Command.executeQuery(Command.java:220)
    at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:227)
    at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:205)
    at org.h2.server.pg.PgServerThread.process(PgServerThread.java:423)
    at org.h2.server.pg.PgServerThread.run(PgServerThread.java:100)
    at java.lang.Thread.run(Thread.java:748)

Caused by: java.sql.SQLException:

from noisemodelling.

https://noisemodelling.readthedocs.io/en/latest/NoiseModellingScripting.html

from noisemodelling.