Error 1 Failed To Load Nad27-83 Correction File
Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Geographic Information Systems Questions Tags Users Badges Unanswered Ask Question _ Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top PostGIS 2.0 and Postgres 9.1: ST_Transform => failed to load NAD27-83 correction file (Windowsx 64) up vote 2 down vote favorite 1 after making a clean install with the latest stable release of postgis (2.0) i can't perform any transformations: SELECT ST_Transform(ST_SetSRID('BOX3D(2644033.2454124987 4580030.29781942,2645409.1119216317 4581406.1643285528)'::box3d,3785), 4326) The above raises the error: NOTICE: PostGIS was unable to transform the point because either no grid shift files were found, or the point does not lie within the range for which the grid shift is defined. Refer to the ST_Transform() section of the PostGIS manual for details on how to configure PostGIS to alter this behaviour. ERROR: transform: couldn't project point (2.64403e+006 4.58003e+006 0): failed to load NAD27-83 correction file (-38) ********** Error ********** ERROR: transform: couldn't project point (2.64403e+006 4.58003e+006 0): failed to load NAD27-83 correction file (-38) SQL state: XX000 Tried the other suggestions of copying proj in contrib folder, restarting pg service with no luck. Any ideas? UPDATE: Something really weird is going on here. When executing the statement right after a PG restart it works! Any following statements after that fail! -- Executing query: SELECT ST_AsText(ST_Transform(ST_GeomFromText('POINT(2649262.94974021 4579345.79221865)', 3785), 4326)) Total query runtime: 20 ms. 1 row retrieved. -- Executing query: SELECT ST_AsText(ST_Transform(ST_GeomFromText('POINT(2649262.94974021 4579345.79221865)', 3785), 4326)) NOTICE: PostGIS was unable to transform the point because either no grid shift files were found, or the point does not lie within the range for which the grid shift is defined. Refer to the ST_Transform() section of the PostGIS manual for details on how to configure PostGIS to alter this behaviour. ERROR: transform: couldn't project po
NAD27 - NAD83 Reported by: dmalav Owned by: warmerdam Priority: high Milestone: Component: OGR_SRS Version: 1.4.2 Severity: critical Keywords: Cc: Description Hi, I am trying to use close to the following code for transforming from Lat-Long NAD27 to NAD83. OGRSpatialReference oSource, oTarget; OGRCoordinateTransformation *poC; double x, http://gis.stackexchange.com/questions/23144/postgis-2-0-and-postgres-9-1-st-transform-failed-to-load-nad27-83-correction y; oSource.SetWellKnownGeogCS( "EPSG:4267" ); oTarget.importFromEPSG(26954); char *projWk; oSource.exportToWkt((char ) &projWk); if(projWk) printf("\nSource Projection: %s\n", projWk); free(projWk); oTarget.exportToWkt((char ) &projWk); if(projWk) printf("\nTarget Projection: %s\n", projWk); free(projWk); poC = OGRCreateCoordinateTransformation( &oSource, &oTarget ); x = -108.754049; y = https://trac.osgeo.org/gdal/ticket/2704 39.374959; if( poC == NULL !poC->Transform( 1, &x, &y ) ) printf( "Transformation failed.\n" ); else printf( "(-108.754049,39.374959) -> (%f,%f)\n", x, y ); double x1 = -108.620719; double y1= 39.499970; if( poC == NULL !poC->Transform( 1, &x1, &y1 ) ) printf( "Transformation failed.\n" ); else printf( "(-108.620719,39.499970) -> (%f,%f)\n", x1, y1 ); / This does not fail but gives me wrong answer. Notice how it converts two different LL to same values. Some times when I transform from Nad27 to Nad83 it gives error: failed to load NAD27-83 correction file Source Projection: GEOGCS["NAD27",DATUM["North_American_Datum_1927",SPHEROID["Clarke 1866",6378206.4,294.9786982139006,AUTHORITY["EPSG","7008"]],AUTHORITY["EPSG","62 67"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251 994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4267"]] Target Projection: PROJCS["NAD83 / Colorado Central",GEOGCS["NAD83",DATUM["North_American_Datum_1983",SPHEROID["GRS 1980",6378137,298.257222101,AUTHORITY["EPSG","7019"]],AUTHORITY["EPSG","6269"]], PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328 ,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4269"]],PROJECTION["Lambert_Conform al_Conic_2SP"],PARAMETER["standard_parallel_1",39.75],PARAMETER["standard_parall el_2",38.45],PARAMETER["latitude_of_origin",37.83333333333334],PARAMETER["centra l_meridian",-105.5],P
von GoogleAnmeldenAusgeblendete FelderNach Gruppen oder Nachrichten suchen
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Weird error calling postgis function up vote 0 down vote favorite I am trying to solve a problem related to what appears to be duplicated functions in a postgis database (original question here), but in my testing I'm getting something very odd happening. I have installed a new postgres database in openshift, activated the postgis extensions, and tried doing a transform twice. The first time it worked, the second time it didn't. Here is the full command line: test=# CREATE EXTENSION postgis; CREATE EXTENSION test=# CREATE EXTENSION postgis_topology; CREATE EXTENSION test=# SELECT ST_Transform('SRID=3857;POINT(-10000000 5200000)'::geometry,4326); st_transform ---------------------------------------------------- 0101000020E6100000E0C1F1C2377556C0F04DCF5946214540 (1 row) test=# SELECT ST_Transform('SRID=3857;POINT(-10000000 5200000)'::geometry,4326); ERROR: transform: couldn't project point (-1e+07 5.2e+06 0): failed to load NAD27-83 correction file (-38) test=# I executed these commands straight after each other. I also tried creating a new database a couple of times but got the same behaviour in each. Why would it work once but not the second time? postgresql postgis share|improve this question asked Dec 11 '13 at 7:28 aquavitae 6,14322165 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote accepted You need to install package called 'proj-nad' So 'yum install proj-nad' Thats is. share|improve this answer answered Jan 15 '14 at 17:06 Jakub Hadvig 7612 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy policy and terms of service. Not the answer you're looking for? Browse other questions tagged postgresql postgis or ask your own question. asked 2 years ago viewed 142 times active 2 years ago Related 2PostGIS intersection troubleshooting128Get PostGIS version19Find n Nearest Neighbors for given Point using PostGIS?1postgis