Ticket #4273 (new enhancement)

Opened 15 months ago

Last modified 15 months ago

Update axis lookup table to epsg database version 7.9.8

Reported by: mko Owned by: sdlime
Priority: normal Milestone:
Component: MapServer C Library Version: svn-trunk (development)
Severity: trivial Keywords: axis order, epsg, axis orientation, mapaxisorder
Cc: mko

Description

There are a couple of new epsg codes with north-east axes orientation MapServer should be aware of. See also #3582. Current EPSG database version is 7.9.8.

Attachments

mapaxisorder.v798.csv.patch Download (0.8 KB) - added by mko 15 months ago.

Change History

Changed 15 months ago by mko

Changed 15 months ago by mko

Here's the SQL snippet

SELECT * 
FROM epsg_coordinatereferencesystem
WHERE coord_sys_code IN 
( 
	SELECT CAA.coord_sys_code 
	FROM epsg_coordinateaxis AS CAA 
	INNER JOIN epsg_coordinateaxis AS CAB ON CAA.coord_sys_code = CAB.coord_sys_code 
	WHERE 
	   CAA.coord_axis_order=1 AND CAB.coord_axis_order=2
	  AND 
	  ( 
	    ( CAA.coord_axis_orientation ILIKE 'north%' AND CAB.coord_axis_orientation ILIKE 'east%' ) 
	   OR
	    ( CAA.coord_axis_orientation ILIKE 'south%'  AND CAB.coord_axis_orientation ILIKE 'west%' ) 
	  ) 
)
ORDER BY coord_ref_sys_code;
Note: See TracTickets for help on using tickets.