search

AISViz / AISdb

AISdb Python package for smart AIS data storage and interaction.
https://aisviz.cs.dal.ca
GNU Affero General Public License v3.0
9 stars 0 forks source link

Ship Type = 0 in SQLite while loading CSV #22

Closed JayKumarr closed 9 months ago

JayKumarr commented 9 months ago

decoding the CSV to create the SQLite. When we open the database, there are mainy five tables, among them one contains metadata for vessels. The ship type, draught, IMO are available in the data but not inserted in the database.

dbpath_ = 'D:/AIS_2020_01_01/data/AIS_2020_01_01_aisdb_sample.db'
with aisdb.SQLiteDBConn(dbpath_) as dbconn:
            aisdb.decode_msgs(filepaths=["D:/AIS_2020_01_01/data/AIS_2020_01_01_aisdb_sample.csv"],
                              dbconn=dbconn,
                              source='Testing',
                              verbose=True)
JayKumarr commented 9 months ago

Modified the CSV reading code in the Tutorial. The data types in the csvreader.rs are set strictly to be integer.