Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Update axis lookup table to epsg database version 7.9.8 #4273

Closed
faegi opened this issue Apr 5, 2012 · 2 comments
Closed

Update axis lookup table to epsg database version 7.9.8 #4273

faegi opened this issue Apr 5, 2012 · 2 comments

Comments

@faegi
Copy link

faegi commented Apr 5, 2012

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.

@faegi
Copy link
Author

faegi commented Apr 5, 2012

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;
´´´

@faegi
Copy link
Author

faegi commented Apr 5, 2012

tbonfort added a commit that referenced this issue Apr 12, 2012
* update inverted axis list to epsg 7.9.8 (#4273)
* update lookup to use bit array (modified so the functions
  are not implemented in mapfile.c) (#4268)

@dmorissette in #3852 you seem to have proposed to use a bit array for
inverted axis lookups. Can you check this conforms to what you
expected ?
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant