Contains information about Plant's geographical location from where plant's data is retrieved
locid int(11) NO PRI auto_increment
locname varchar(255) YES //Location information with co-ordintes
1 (MPEG) Belem, PA, Brazil
2 (Montenegro) Velika Kalica
3 (TARI), Tehran, Iran
4 Abha, Saudi Arabia
5 Abidjan
6 Abidjan, south Ivory Coast
7 Abomy-calavy, Benin
8 Adana, Turkey
9 Adriatic coast
10 Afaka, Kaduna
41 Anjanisain (Tehri Garhwal), Uttarakhand, India (30°18'56.20"N, 78°35'4.34"E, 1747m)
46 Apani, Italy (40° 40’ 47.2” N, 17° 55’ 24.2” E, 5m)
68 Avetrana, Italy (40° 20’ 24.1” N, 17° 44’ 55.3” E, 48m)
152 Cardigliano, Italy (39° 56’ 36.5” N, 18° 15’ 59.8” E, 174m)
154 Castro, Italy (40° 00’ 24.6” N, 18° 25’ 14.9” E, 169m)
163 Chakhutia (Almora), Uttarakhand, India (29°52'59.99"N, 79°20'59.99"E, 988m)
This requires more columns. Discuss with Gita
A: separate coordinates into separate column
B: probably separate country
C: separate geographical regions?
D: geo-resolve and give Wikidata ID where possible
Currently
This requires more columns. Discuss with Gita A: separate coordinates into separate column B: probably separate country C: separate geographical regions? D: geo-resolve and give Wikidata ID where possible