本文介绍了您如何知道用于shp文件的SRID?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我正在尝试将SHP文件放入我的PostGIS数据库中,但数据有点不足.我认为这是因为我使用了错误的SRID. PRJ文件的内容如下:

I am trying to put a SHP file into my PostGIS database, the the data is just a little off. I think this is because I am using the wrong SRID. The contents of the PRJ file are as follows:

GEOGCS["GCS_North_American_1983",
DATUM["D_North_American_1983",
SPHEROID["GRS_1980",6378137.0,298.257222101]],
PRIMEM["Greenwich",0.0],
UNIT["Degree",0.0174532925199433]]

这与什么SRID相关?更一般而言,如何根据PRJ文件中的信息查找SRID?在某处是否有一个查找表列出所有SRID及其等效的"geogcs"?

What SRID does this correlate to? And more generally, how can I look up the SRID based on the information found in the PRJ file? Is there a lookup table somewhere that lists all SRID's and their 'geogcs' equivalents?

使用srid=4269和4326导入的数据完全相同.

The data imported using srid=4269 and 4326 were the exact same results.

这是否意味着我使用了错误的SRID,或者这仅仅是预期的误差范围?

Does this mean I'm using the wrong SRID, or is this just expected margin of error?

shp文件来自此处.

推荐答案

详细说明的答案,SRID有时称为"EPSG"代码. SRID/EPSG代码是投影的熟知文本表示​​形式的事实上的简写.

To elaborate on synecdoche's answer, the SRID is sometimes called an "EPSG" code. The SRID/EPSG code is a defacto short-hand for the Well-Known-Text representations of projections.

您可以在SRID表上进行快速搜索,以查看是否可以找到完全匹配或类似的匹配项:
SELECT srid, srtext, proj4text FROM spatial_ref_sys WHERE srtext ILIKE '%BLAH%'

You can do a quick search on the SRID table to see if you can find an exact or similar match:
SELECT srid, srtext, proj4text FROM spatial_ref_sys WHERE srtext ILIKE '%BLAH%'

以上内容位于 http://www.bostongis.com/?content_name=postgis_tut01.

您还可以在 spatialreference.org 上搜索此类内容.搜索工具是原始的,因此您可能必须使用Google搜索并指定站点,但是任何结果都将向您显示ESRI PRJ内容,PostGIS SQL INSERT和许多其他表示形式.

You can also search on spatialreference.org for these kinds of things. The search tool is primitive so you may have to use a Google search and specify the site, but any results will show you the ESRI PRJ contents, the PostGIS SQL INSERT, and a bunch of other representations.

我认为您的PRJ位于: http://spatialreference.org/ref/sr -org/15/

I think your PRJ is at: http://spatialreference.org/ref/sr-org/15/

这篇关于您如何知道用于shp文件的SRID?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-18 17:52