File: nkg_post_customizations.sql

package info (click to toggle)
proj 9.7.1-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 43,800 kB
  • sloc: sh: 218,851; cpp: 171,440; sql: 83,614; python: 8,422; ansic: 6,254; yacc: 1,349; makefile: 33
file content (13 lines) | stat: -rw-r--r-- 363 bytes parent folder | download | duplicates (6) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 

-- Append NKG to authority references
UPDATE
   authority_to_authority_preference
SET
   allowed_authorities = allowed_authorities || ',NKG'
WHERE
   source_auth_name = 'EPSG' AND target_auth_name = 'EPSG';

INSERT INTO "authority_to_authority_preference"
    (source_auth_name,target_auth_name, allowed_authorities)
VALUES
    ('NKG', 'EPSG', 'NKG,PROJ,EPSG');