· 7 years ago · Nov 07, 2018, 08:16 AM
1CREATE TABLE IF NOT EXISTS map_points (
2 `type` VARCHAR(17) CHARACTER SET utf8,
3 `features_type` VARCHAR(7) CHARACTER SET utf8,
4 `features_geometry_type` VARCHAR(5) CHARACTER SET utf8,
5 `features_geometry_coordinates` NUMERIC(12, 10)
6);
7INSERT INTO map_points VALUES
8 ('FeatureCollection','Feature','Point',19.2638397217),
9 ('FeatureCollection','Feature','Point',50.206791161),
10 ('FeatureCollection','Feature','Point',19.2693328857),
11 ('FeatureCollection','Feature','Point',50.1981109199),
12 ('FeatureCollection','Feature','Point',19.2796325684),
13 ('FeatureCollection','Feature','Point',50.2055826144),
14 ('FeatureCollection','Feature','Point',19.2816925049),
15 ('FeatureCollection','Feature','Point',50.2003085985);