Re: How to get the SRID of a geometry column

[William Choy]

For Drupal, I like to put the Authors UID as the SRID value.

create table geom(g point) engine=myisam;
insert into geom (g) values (pointfromtext('point(1 1)', 101));
insert into geom (g) values (pointfromtext('point(1 2)', 102));
insert into geom (g) values (pointfromtext('point(2 2)', 202));
insert into geom (g) values (pointfromtext('point(10 1)', 101));
insert into geom (g) values (pointfromtext('point(10 2)', 102));
insert into geom (g) values (pointfromtext('point(20 2)', 202));
select astext(g), SRID(g) from geom;
select astext(g), SRID(g) from geom WHERE SRID(g) = 102;