Insert Pickup Points

[ssp6]

select load_extension('mod_spatialite');

insert into pickuppoint (name, area) values ('Charlotte Square',GeomFromText('POLYGON ((55.9521440 -3.2088281, 55.9510267 -3.2083344, 55.9513451 -3.2063485, 55.9524804 -3.2069925, 55.9521440 -3.2088281))',27700));
insert into pickuppoint (name, area) values ('Teviot', GeomFromText('POLYGON ((55.9453309 -3.1902911, 55.9510267 -3.2083344, 55.9513451 -3.2063485, 55.9524804 -3.2069925, 55.9521440 -3.2088281))',27700));
insert into pickuppoint (name, area) values ('Toll Cross', GeomFromText('POLYGON ((55.9441173 -3.2041895, 55.9438168 -3.2037926, 55.9439070 -3.2032242, 55.9442915 -3.2029775, 55.9441353 -3.2033422, 55.9441473 -3.2039321, 55.9441173 -3.2041895 ))',27700));
insert into pickuppoint (name, area) values ('Toll Cross', GeomFromText('POLYGON ((55.94779 -3.2069743, 55.9473695 -3.2068776, 55.9474596 -3.206137, 55.94779 -3.2069743))',27700));


select *, AsWKT(pickuppoint.area, 227700) from pickuppoint;

Got geo points using - https://www.keene.edu/campus/maps/tool/