create table TBL_personnel(id int not null auto_increment, name varchar(25) not null, lname varchar(60) not null, adt char(8) not null unique,
 gender enum('M', 'F') not null, monthly_salary decimal(10, 2) default 0.00, home_coords point, primary key(id), spatial index(home_coords));
 
  insert into TBL_personnel(name, lname, adt, gender, monthly_salary, home_coords)values
  ("Jason", "Gideon", "25698655", 'M', 5300.00, ST_GeomFromText('POINT(37.926868,-78.024902)')) 
  ,("Aaron", "Hotchner", "25674839", 'M', 5700.00, ST_GeomFromText('POINT(37.926890 -78.024546)'))
  ,("Derek", "Morgan", "25693674", 'M', 5600.00, ST_GeomFromText('POINT(37.926666 -78.024345)'))
  ,("Spencer", "Reid", "25698387", 'M', 5350.00, ST_GeomFromText('POINT(37.926892 -78.024348)'))
  ,("Jennifer", "Jareau", "25629045", 'F', 5400.00, ST_GeomFromText('POINT(37.926165 -78.024290)'))
  ,("Penelope", "Garcia", "25239469", 'F', 5000.00, ST_GeomFromText('POINT(37.835482 -78.024199)'))
  ,("Emily", "Prentiss", "24537108", 'F', 5600.00, ST_GeomFromText('POINT(48.864716 2.349014)'))
  ,("David", "Rossi", "25670076", 'M', 5400.00, ST_GeomFromText('POINT(37.926554 -78.024998)'))
  ,("Alex", "Blake", "2569121", 'F', 5200.00, ST_GeomFromText('POINT(37.92999 -78.024131)'))
  ,("Ashley", "Seaver", "25698200", 'F', 3400.00, ST_GeomFromText('POINT(37.926111 -78.024367)'));
  
  mysql> select * from TBL_personnel;
+----+----------+----------+----------+--------+----------------+---------------------------+
| id | name     | lname    | adt      | gender | monthly_salary | home_coords               |
+----+----------+----------+----------+--------+----------------+---------------------------+
|  1 | Jason    | Gideon   | 25698655 | M      |        5300.00 |        e����B@A�~��S�         |
|  2 | Aaron    | Hotchner | 25674839 | M      |        5700.00 |        �~�T��B@��b)��S�          |
|  3 | Derek    | Morgan   | 25693674 | M      |        5600.00 |        V(����B@��Tގ�S�          |
|  4 | Spencer  | Reid     | 25698387 | M      |        5350.00 |        Gv�e��B@F��ꎁS�        |
|  5 | Jennifer | Jareau   | 25629045 | F      |        5400.00 |        �� ���B@�����S�             |
|  6 | Penelope | Garcia   | 25239469 | F      |        5000.00 |        �2���B@#f�y��S�         |
|  7 | Emily    | Prentiss | 24537108 | F      |        5600.00 |        �)��nH@�����@         |
|  8 | David    | Rossi    | 25670076 | M      |        5400.00 |        /�KR��B@�6���S�         |
|  9 | Alex     | Blake    | 2569121  | F      |        5200.00 |        �͍��B@w�\��S�          |
| 10 | Ashley   | Seaver   | 25698200 | F      |        3400.00 |        ��$Ί�B@��:��S�          |
+----+----------+----------+----------+--------+----------------+---------------------------+
10 rows in set (0,00 sec)