New answers tagged database
Step 1: get the coordinates in the csv to points. You'll first need to determine, if possible, the coordinate system used. You say lat/lon, so right away it should be a Geographic Coordinate System. Frequently it will be GCS WGS84, but there are other datums out there and it's best to be sure. Once you have that info you can use Add Delimited Text Layer and ...
This operation is called a "Spatial Join". You can use the "Join Attributes by Location" tool in QGIS.
I would use the 'Point sampling tool' plugin in QGIS. Check the bottom of How do I use the field-calculator in QGIS to return the name of a country from a different shapefile?
You can easily load Shapefiles into dashDB using the user interface. Instructions here: https://www-01.ibm.com/support/knowledgecenter/SS6NHC/com.ibm.swg.im.dashdb.doc/learn_how/loaddata_gsdata.html
Directly loading KML data is not yet possible with dashDB. But you can load GML. See e.g. https://www-01.ibm.com/support/knowledgecenter/#!/SS6NHC/com.ibm.db2.luw.spatial.topics.doc/doc/db2sb169.html%23db2sb-gen168__fun-constr-geom If you have Esri ArcGIS tooling you can load KML data and store it into dashDB geometry columns.
Top 50 recent answers are included