SRID、SRID...
SRIDはシステムビュー sys.spatiral_reference_systems に入っています。
select count(spatial_reference_id)'srid count' from sys.spatial_reference_systems; select MIN(spatial_reference_id)'min srid' from sys.spatial_reference_systems; select MAX(spatial_reference_id)'max srid' from sys.spatial_reference_systems;
srid count ----------- 389 min srid ----------- 4120 max srid ----------- 4999
足りねえよ。ていうか投影座標自体ねえよ。Googleメルカトルとかボンヌ図法とかそんなレベルじゃねえ、もっと恐ろしいものの片鱗を(ry
念のため東京測地系とWGS84のWKTをみてみる。
select spatial_reference_id 'srid', well_known_text from sys.spatial_reference_systems where spatial_reference_id in (4301, 4326);
srid well_known_text ---- ------------------------------------------------------------------------------------------------------------------------------------------------------------- 4301 GEOGCS["Tokyo", DATUM["Tokyo", ELLIPSOID["Bessel 1841", 6377397.155, 299.1528128]], PRIMEM["Greenwich", 0], UNIT["Degree", 0.0174532925199433]] 4326 GEOGCS["WGS 84", DATUM["World Geodetic System 1984", ELLIPSOID["WGS 84", 6378137, 298.257223563]], PRIMEM["Greenwich", 0], UNIT["Degree", 0.0174532925199433]]