// Copyright (C) 2004-2006 Autodesk, Inc. // // This library is free software; you can redistribute it and/or // modify it under the terms of version 2.1 of the GNU Lesser // General Public License as published by the Free Software Foundation. // // This library is distributed in the hope that it will be useful, // but WITHOUT ANY WARRANTY; without even the implied warranty of // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU // Lesser General Public License for more details. // // You should have received a copy of the GNU Lesser General Public // License along with this library; if not, write to the Free Software // Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA // //---------------------------------------------------------------------------- // // This file is used by the SQLServerSpatial provider and serves 2 purposes: // // 1. It gets WKT for coordinate systems that are not in SQL Server's sys.spatial_reference_systems catalogue. // This catalogue only contains Geodetic coordinate systems. However, SQL Server geometry column // values can be associated with coordinate systems that are not in the catalogue. These coordinate systems // are referenced by SRID (usually EPSG number). The SQLServerSpatial provider generates a spatial // context for each of these coordinate systems. It also needs to determine the WKT // (Well-Known Text) for each coordinate system, since that information is needed by FDO API consumers such as // AutoCAD Map 3D and Autodesk MapGuide. This file provides a supplemental place to retrieve the WKT by mapping // SRIDs to WKTs. The SQL Server catalogue is checked first, and then this file, so for SRID's in // sys.spatial_reference_systems, the WKT is retrieved from sys.spatial_reference_systems, and not this file. // // // 2. This file allows the provider to handle coordinate system names specified via the FdoICreateSpatialContext // command. If the coordinate system name is not in the SQL Server catalogue, the SQLServerSpatial provider // stores its SRID in the new datastore. This file is needed to translate the coordinate system name to SRID. // // This file provides a starter set of coordinate systems, but you can add more as needed. Store this file // in the FDO com directory (A sub-directory named 'com' that is in the same directory as the SQLServerSpatial // provider DLL). // // The format for each line in this file is: // // // // where: // SRID: The SRID for each coordinate system. For the initial coordinate system entries, the SRID // is the coordinate system's EPSG number. // // Coordinate System Name: The name that appears on the Map Create Datastore Plugin for SQLServerSpatial. // You can omit this if it is not one of the coordinate systems available from the Plugin. // // WKT: A string in Open Geospatial Well-Known Text format. You can omit this if the coordinate system is in // sys.spatial_reference_systems. If you omit it, you must specify the Coordinate System Name. // // Each field must be separated by spaces (not tabs). // // The Coordinate System Name can have embedded spaces. All words after the EPSG number and before the WKT are treated // as part of the Coordinate System name. Any space separation between these words is maintained, but the name cannot // have leading or trailing spaces. // 1 XY-M LOCAL_CS["Non-Earth Metre",UNIT["Metre",1]] 2 XY-FT 2001 Antigua43.BWIgrid PROJCS["Antigua 1943 / British West Indies Grid",GEOGCS["For testing only",DATUM["Test",SPHEROID["Clarke 1880 (RGS)",6378249.145,293.465,]]]] 4121 GGRS87.LL 4122 LL-ATS77 4123 KKJ.LL 4124 LL-RT90-7P 4125 Samboja.LL 4126 Lithuania94.LL 4127 Tete.LL 4130 Moznet.LL 4131 Indian60.LL 4132 Final58.LL 4133 Estonia92 4134 PDOSurvey93.LL 4135 LL-OLDHI 4139 PRVI.LL 4140 LL-CSRS 4141 Israel.LL 4142 Locodjo65.LL 4143 Abidjan87.LL 4144 Kalianpur37.LL 4145 Kalianpur62.LL 4146 Kalianpur75.LL 4147 Hanoi72.LL 4148 Hartebeesthoek94.LL 4149 LLCH1903 4150 CH1903Plus.LL 4151 CHTRF95.LL 4152 LL-HPGN 4153 Rassadiran.LL 4154 Europ50/77.LL 4155 Dabola81.LL 4156 Czech/JTSK.LL 4158 NAPARIMA.LL 4159 EuropLibyan79.LL 4161 Castillo.LL 4163 YemenNtl96.LL 4164 SouthYemen.LL 4165 Bissau.LL 4166 Korean95.LL 4167 NZGD2000.LL 4168 Accra.LL 4169 AmSamoa62.LL 4170 GRSSA.LL 4171 LL-RGF93 4173 IRENET95.LL 4175 SierraLeone68.LL 4176 Antarctic98.LL 4178 Pulkovo42/83.LL 4179 Pulkovo42/58.LL 4180 Estonia97.LL 4181 Luxembourg30.LL 4182 OBSRV66.LL 4183 AZORES.LL 4184 SAOBRAZ.LL 4188 OSNI52.LL 4189 REGVEN.LL 4190 PGA98.LL 4192 Douala48.LL 4193 Manoca62.LL 4194 Qornoq27.LL 4195 Scoresbysund52.LL 4196 Ammassalik58.LL 4201 Adindan.LL 4202 LL-ASTRLA66-Grid 4203 LL-AGD84-Grid 4204 AinElAbd.LL 4205 Afgooye.LL 4207 Lisbon37.LL 4208 Aratu.LL 4209 Arc1950.LL/01 4210 Arc1960.LL 4211 Batavia.LL 4212 Barbados38.LL 4214 Beijing54.LL 4216 Bermuda.LL 4218 Bogota.LL 4219 BukitRimpah.LL 4220 Camacupa.LL 4221 Campo.LL 4222 Cape-1.LL 4223 Carthage.LL 4224 Chua.LL 4225 Corrego.LL 4227 DeirEzZor.LL 4229 Old-Egyp.LL 4230 LL-ERP50 4231 Europ87.LL 4232 Fahud.LL 4233 Gandajika.LL 4236 HuTzuShan.LL 4237 HD-72.LL 4238 Indonesian74.LL 4239 Indian54.LL 4240 Indian75.LL 4242 Jamaica69.LL 4244 Kandawala.LL 4245 Kertau48.LL 4246 KuwaitOilCo.LL 4247 LaCanoa.LL 4248 LLPSAD56 4250 Leigon.LL 4251 Liberia.LL 4253 Luzon.LL 4254 HitoXVIII63.LL 4255 HeratNorth.LL 4256 Mahe1971.LL 4257 Makassar.LL 4258 LL-ETRF89 4259 Malongo87.LL 4260 Manoca.LL 4261 Merchich/01 4262 Massawa.LL 4263 Minna.LL 4264 Mhast.LL 4265 ROME1940.LL 4266 Mporaloko.LL 4267 LL27 4268 MICHIGAN.LL 4269 LL83 4270 NHRWN-O.LL 4271 Naparima72.LL 4272 LL-GD1949-Grid 4273 NGO48.LL 4274 Datum73.LL 4275 NTF.LL 4277 OSGB.LL 4281 Palestine23.LL 4282 PointeNoire.LL 4283 LL-GDA94 4284 Pulkovo42.LL 4285 Qatar74.LL 4286 Qatar48.LL 4289 Amersfoort.LL 4291 SAD69.LL/01 4292 Sapper.LL 4293 Schwarzk.LL 4294 Segora.LL 4297 Tananarive25.LL 4298 TIMBALAI.LL 4299 TM65.LL 4301 Tokyo 4302 Trinidad03.LL 4304 Voirol1875.LL 4307 NordSahara59.LL 4309 Yacare.LL 4311 Zanderij.LL 4312 MGI-AT.LL 4313 Belge72.LL 4314 DHDN.LL 4315 Conakry05.LL 4316 DealulPiscului33.LL 4317 DealulPiscului70.LL 4318 NtlGeodeticNet.LL 4319 KuwaitUtility.LL 4322 LL72 4324 WGS72-TBE.LL 4326 LL84 4601 Antigua43.LL 4602 Dominica45.LL 4603 Grenada53.LL 4604 Montserrat58.LL 4605 StKitts55.LL 4606 StLucia55.LL 4607 StVincent45.LL 4610 Xian80.LL 4611 HongKong80.LL 4612 JGD2000.LL 4613 Segara.LL 4614 QatarNtl95.LL 4615 MADEIRA.LL 4616 SelvagemGrande.LL 4619 SWEREF99.LL 4620 Point58.LL 4621 FortMarigot.LL 4622 StAnne.LL 4623 CSG67.LL 4624 Guyane95.LL 4625 FortDesaix.LL 4626 REUNION.LL 4627 Reunion92.LL 4628 Tahiti.LL 4629 Tahaa.LL 4630 IGN72NukuHiva.LL 4631 K01949.LL 4632 Combani50.LL 4633 IGN56Lifou.LL 4635 ST87Ouvea.LL 4636 Petrels72.LL 4637 Perroud50.LL 4638 Miquelon50.LL 4639 MOP78.LL 4640 Antilles91.LL 4641 IGN53/Mare.LL 4642 ST84IleDesPins.LL 4643 ST71Belep.LL 4644 NEA74Noumea.LL 4645 Caledonie91.LL 4657 Reykjavik.LL 4658 HJORSEY.LL 4659 IslandsNet1993.LL 4660 Helle1954.LL 4661 Latvia1992.LL 4662 IGN72GrandeTerre.LL 4663 PortoSanto1995.LL 4664 AzoresOriental1995.LL 4665 AzoresCentral1995.LL 4666 Lisbon1890.LL 4667 IraqKuwait1992.LL 4668 EUROP79.LL 4670 IGM1995.LL 4672 CHATHAM.LL 4673 Chatham1979.LL 4674 SRG-SA/2000.LL 4675 GUAM63.LL 4678 Lao1997.LL 4679 Jouik1961.LL 4680 Nouakchott1965.LL 4681 Mauritania1999.LL 4682 Gulshan-303.LL 4683 Philippine1992.LL 4684 Gan1970.LL 4686 MarcoGNR.LL 4687 RGP-Francaise.LL 4688 FatuIva/72.LL 4689 FatuIva/72.LL 4691 Moorea87.LL 4692 Maupiti83.LL 4693 Nakhl-eGhanem.LL 4698 KERGUELN.LL 4699 LePouce1934.LL 4701 CongoBelge1955.LL 4707 Tern1961.LL 4708 Cocos1965.LL 4709 IwoJima1945.LL 4710 StHelena1971.LL 4711 Marcus1952.LL 4712 ASCENSN.LL 4713 Ayabelle.LL 4714 BELLEVUE.LL 4715 CampAreaAstro.LL 4716 CampAreaAstro.LL 4717 CANAVRL.LL 4718 Solomon1968.LL 4719 EASTER.LL 4720 Fiji1986.LL 4721 Fiji1956.LL 4722 SouthGeorgia1968.LL 4723 GrandCayman1959.LL 4724 DiegoGarcia1969.LL 4725 JHNSTN.LL 4726 LittleCayman1961.LL 4727 MIDWAY.LL 4728 CANARY.LL 4729 PITCAIRN.LL 4730 Santo1965.LL 4731 VITI.LL 4732 Marshalls1960.LL 4733 Wake1952.LL 4734 TRISTAN.LL 4735 Kusaie1951.LL 4736 DeceptionIsland.LL 4737 Korean2000.LL 4738 HONGKONG.LL 4739 HongKong1963/67.LL 4740 ParametropZemp1990.LL 4743 Karbala1979/P.LL 4747 Greenland1996.LL 4748 VanuaLevu1915.LL 4749 RGN-Caledonie/91-93.LL 4752 VitiLevu1912.LL 4754 Libyan2006.LL 4755 Nasional1995.LL 4805 MGI-AT/F.LL 4807 LL-NTF-Grid 26741 CA-I PROJCS["California test",GEOGCS["For testing only",DATUM["Test",SPHEROID["NAD 27",6300000,123.465,]]]] 32185 CANQ-M5 PROJCS["Quebec test",GEOGCS["For testing only",DATUM["Test",SPHEROID["NAD 27",6300000,123.465,]]]]