您如何知道用于shp文件的SRID? [英] How do you know what SRID to use for a shp file?

问题描述

我正在尝试将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文件来自此处.

推荐答案

详细说明

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?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！