VGaD0L41

1'Somewhere', -0.574823, 51.150771, '0x0101000000000000000000F03F000000000000F0BF'
2	
3CREATE TABLE IF NOT EXISTS `mapping` (
4  `id` int AUTO_INCREMENT PRIMARY KEY,
5  `location` varchar(80) DEFAULT NULL,
6  `longitude` double DEFAULT NULL,
7  `latitude` double DEFAULT NULL,
8  `geom` geometry NOT NULL,
9  INDEX mapping_by_location (location),
10  SPATIAL KEY `mapping_by_geom` (`geom`)
11) ENGINE=MyISAM DEFAULT CHARSET=utf8;
12	
13LOAD DATA LOCAL INFILE '{$file}'
14REPLACE INTO TABLE `mapping`
15FIELDS TERMINATED BY ','
16OPTIONALLY ENCLOSED BY '"'
17LINES TERMINATED BY 'n'
18(@col1, @col2, @col3, @col4)
19SET
20`location` = @col1,
21`latitude` = @col2,
22`longitude` = @col3,
23`geom` = GeomFromWKB(@col4);
24	
25`geom` = GeomFromWKB(0x0101000000000000000000F03F000000000000F0BF);