Definiciones de proyecciones frecuentes en diferentes notaciones comunes

CRTM05, PROJ4

+proj=tmerc +lat_0=0 +lon_0=-84 +k=0.9999 +x_0=500000 +y_0=0 +ellps=WGS84 +units=m +no_defs CRTM05 PROJ4

Lambert Norte, PROJ4

+proj=lcc +lat_1=10.46666666666667 +lat_0=10.46666666666667 +lon_0=-84.33333333333333 +k_0=0.99995696 +x_0=500000 +y_0=271820.522 +ellps=clrk66 +towgs84=213.11,9.37,-74.95,0,0,0,0 +units=m +no_defs <>Lambert PROJ4

CRTM05, WKT o PRJ (Incluye Definición de "authority EPSG:5367, para ser identificado correctamente por diferentes SIG)

PROJCS["CR05 / CRTM05", GEOGCS["CR05", DATUM["Costa Rica 2005", SPHEROID["WGS 84", 6378137.0, 298.257223563, AUTHORITY["EPSG","7030"]], TOWGS84[0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0], AUTHORITY["EPSG","1065"]], PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]], UNIT["degree", 0.017453292519943295], AXIS["Geodetic longitude", EAST], AXIS["Geodetic latitude", NORTH], AUTHORITY["EPSG","5365"]], PROJECTION["Transverse_Mercator", AUTHORITY["EPSG","9807"]], PARAMETER["central_meridian", -84.0], PARAMETER["latitude_of_origin", 0.0], PARAMETER["scale_factor", 0.9999], PARAMETER["false_easting", 500000.0], PARAMETER["false_northing", 0.0], UNIT["m", 1.0], AXIS["Easting", EAST], AXIS["Northing", NORTH], AUTHORITY["EPSG","5367"]]

Instrucciones para PostGIS

Insertar proyección CRTM05

INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values ( 5367, 'epsg', 5367, '+proj=tmerc +lat_0=0 +lon_0=-84 +k=0.9999 +x_0=500000 +y_0=0 +ellps=WGS84 +units=m +no_defs ', 'PROJCS["Proyeccion CRTM05", GEOGCS["GCS_WGS_1984", DATUM["D_WGS_1984", SPHEROID["WGS_1984",6378137.0,298.257223563]], PRIMEM["Greenwich",0.0], UNIT["Degree",0.0174532925199433]], PROJECTION["Transverse_Mercator"], PARAMETER["False_Easting",500000.0], PARAMETER["False_Northing",0.0], PARAMETER["Central_Meridian",-84.0], PARAMETER["Scale_Factor",0.9999], PARAMETER["Latitude_Of_Origin",0.0], UNIT["Meter",1.0]]');

Insertar proyección Lambert norte

INSERT into spatial_ref_sys (srid, auth_name, auth_srid, proj4text, srtext) values ( 5456, 'epsg', 5456, '', 'PROJCS["Lambert_Conformal_Conic", GEOGCS["Geographic Coordinate System", DATUM["OCO",SPHEROID["Clarke 1866",6378206.4,294.9786982139006]], PRIMEM["Greenwich",0],UNIT["degree",0.0174532925199433]], PROJECTION["Lambert_Conformal_Conic"], PARAMETER["scale_factor",0.99995696], PARAMETER["standard_parallel_1",9.933333333333334], PARAMETER["standard_parallel_2",11], PARAMETER["central_meridian",-84.33333333333333], PARAMETER["latitude_of_origin",10.46666666666667], PARAMETER["false_easting",500000], PARAMETER["false_northing",271820.522], UNIT["Meter",1]]');

Asignar proyección CRTM05 a una tabla con un código incorrecto o indefinido de proyección (la tabla debe estar en CRTM05 aunque su código no haya sido correctamente definido)

ALTER TABLE tabla ALTER COLUMN geom TYPE geometry(POINT/LINESTRING/POLYGON, 5367) USING ST_SetSRID(geom,5367);