tmap | R package for thematic maps | Data Visualization library

You can use a tFileProperties that you can place right after the tFileList. You have a field name "mtime" which is the creation date of the file (unix timestamp, you'll have to convert it). Then you'll be able to compare this date with the date you have in your database.

Add border.lwd = NA as an argument to tm_symbols(). The documentation states:

border.lwd: line width of the symbol borders. If NA, no symbol borders are drawn.

The geometry entry in row 87 is empty (MULTIPOLYGON EMPTY). You can overcome this issue by:

Only operations in tDB components (create,select,insert, etc) are actually done through SQL. All operations done in other talend components (tMap, tFilter, aggregate, etc) are done through java. Indeed you'll have better performances doing operations SQL-side. You then have to find the right balance between an "all-in-sql" type of job and an "all-java" one. (it could be harder for a talend developer to debug operations if all the sql part is done through a unique query inside a single component...).

You could definitely have your joins inside a tDBInput component, and output the result in a single output flow. You can also check ELT* components : they let you use SQL-engine instead of java-engine to perform all operations (join,aggregate,filter) while using a talend interface.

Welp I found the answer to my own question. The /storage/emulated/0/ folder is supposed to copy itself over to the folder I can access. There was something wrong with my old phone and it wasn't copying it over properly. I got a new phone and my save function is now working correctly.

Use the sf package to read the shapefile:

CsvHelper will output columns in the order specified by the indices, but it will not add empty columns for missing indices. If you need to do that, you can use Map().Index(i).Constant(""); to indicate a constant value should be used at a specific index i. Use that to fill in a constant empty value for the columns you want to leave empty:

You have two options that work with pessimistic locking:

1. getDataCache().getAdvancedCache().lock(k)
2. getDataCache().getAdvancedCache().withFlags(Flag.FORCE_WRITE_LOCK)

There is a third option: use optimistic locking instead, and retry the transaction if another transaction modifies the key. But this would not work with @TransactionalAttribute, you would have to call TransactionManager.commit() yourself and catch the WriteSkewException.

This should give you what you require: With Ghana outlined in red to make it more obvious which country the label refers to.