这是什么空间 SRID? (尝试将 .shp 文件转换为 WSG84)
我正在尝试将一些 Shapefile 映射数据导入到 Sql2008 中。在此之前,我需要将其转换为 WGS84 / SRID 4326
,因为我所有现有的数据都是这种格式。
这是源文件信息:
GEOGCS["GCS_GDA_1994",DATUM["D_GDA_1994",
SPHEROID["GRS_1980",6378137,298.257222101]],
PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]]
我尝试过谷歌搜索,但运气不佳。 其次,我尝试检查 spatial_reference_systems
表,但在其中看不到它。
例如。 SELECT * from sys.spatial_reference_systems
那么,有人可以帮助我吗?如果我不知道当前的 SRID,则无法将其转换为 SRID 4326
。
更新 1
我发现此页面解释了 GDA 1994 的技术规格..但没有暗示任何 SRID 号码...???
UPDATE 2
此搜索结果页面也有一些有趣的结果。从这里,如果您单击SR-ORG:6643:澳大利亚阿尔伯斯等面积圆锥曲线 链接,它解释了该数据..并且它与我正在搜索的数据几乎相同。这意味着 SRID 是 6643。
这就是答案吗?
I'm trying to import some Shapefile mapping data into Sql2008. Before I do that, I need to convert it to WGS84 / SRID 4326
, because all my existing data is in this format.
This is the source file info:
GEOGCS["GCS_GDA_1994",DATUM["D_GDA_1994",
SPHEROID["GRS_1980",6378137,298.257222101]],
PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]]
I've tried googling for this and haven't had too much luck.
Secondly, I've tried to check the spatial_reference_systems
table and I can't see it in there.
eg. SELECT * from sys.spatial_reference_systems
So, can anyone help me? I can't covert it to SRID 4326
if i don't know it's current SRID.
UPDATE 1
I found this page which explains the tech specs of GDA 1994 .. but doesn't hint at any SRID number... ???
UPDATE 2
This search result page also has some interesting results. From here, if you click on the SR-ORG:6643: Australia Albers Equal Area Conic link, it explains that datum .. and it's pretty much identical to the one I'm searching for. This means the SRID is 6643.
So is that the answer?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
使用 FME 作为我的参考,此 (GDA94) 映射到 EPSG:4283,这意味着您需要使用 SRID 4283(假设您使用的是符合 EPSG 的 SRID 值)
Using FME as my reference, this (GDA94) maps to EPSG:4283, which means that you need to use SRID 4283 (assuming that you're using EPSG-compliant SRID values)
使用此链接可以将 GDA94 映射到覆盖澳大利亚大陆的 SRID = 4283。例如,如果知道这是西澳大利亚州,则最好使用 SRID = 28350 并保持更高的准确性。
Using this link GDA94 can be mapped to SRID = 4283 covering the Australian continent. If one knows, for example, that it is Western Australia it may be better to use SRID = 28350 and preserve greater accuracy.