I want to include this column of data that are in WKT format (they are mostly straight lines). What data type should I use?
I need to create this database for mapping. There are about 30000 features and their magnitude will be colour mapped and shown in 300 time intervals.
The database will be in this format:
magnitude; time; WKT coordinate
4; 2015-01-01; (642044 4862161, 642319 4862144)
I am wondering what column type should i input for the WKT column
Best Answer
You should add a PostGIS extension, and use the
geometry
type instead. It will handle 30000 features easily, and work with many GIS systems (e.g. QGIS). You can always extract the WKT equivalent from ageometry
column usingST_AsText
.Here's an example workflow, assuming it's a table in postgres
Now to query the table with proper WKT: