Advertisement
Sky_Black

Bellhelicopter - By Zero

Jan 20th, 2013
400
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 136.10 KB | None | 0 0
  1. _ _ _________ __
  2. __| || |__\_ ____ \__________ _____| |__
  3. \ __ // \ \/_ __ \__ \/ ___/ | \
  4. | || | | \__| | \/ __ \__ \| Y \
  5. /_ ~~ _\\_____ /|__| (____ /___ >___| /
  6. |_||_| \/ \/ \/ \/
  7. ##############################################
  8. XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
  9.  
  10. Target : http://WWW.bellhelicopter.com/
  11. IP : 165.193.56.140
  12. Web Server : Apache/2.0.52 (Red Hat)
  13. DB : MySQL
  14.  
  15.  
  16. Databases :
  17. [*] BELL
  18. [*] CTXSYS
  19. [*] EXFSYS
  20. [*] MDSYS
  21. [*] OLAPSYS
  22. [*] SYS
  23. [*] SYSTEM
  24.  
  25.  
  26.  
  27.  
  28. Database:SYSTEM
  29.  
  30. +----------------------+
  31. | DEF$_TEMP$LOB |
  32. | HELP |
  33. | MVIEW$_ADV_INDEX |
  34. | MVIEW$_ADV_OWB |
  35. | MVIEW$_ADV_PARTITION |
  36. | OL$ |
  37. | OL$HINTS |
  38. | OL$NODES |
  39. +----------------------+
  40.  
  41.  
  42. Database:BELL
  43.  
  44. +----------------+
  45. | CATEGORIES |
  46. | CSFS |
  47. | DOTCOM_ADMIN |
  48. | FILES |
  49. | JOBLANG |
  50. | JOBLOCS |
  51. | JOBS |
  52. | JOBTYPES |
  53. | JOB_FAIRS |
  54. | JOB_FAIR_TYPES |
  55. | LN |
  56. | MENU |
  57. | SERVICES |
  58. +----------------+
  59.  
  60.  
  61.  
  62. Table: DOTCOM_ADMIN
  63.  
  64. +----------------+----------+
  65. | Column | Type |
  66. +----------------+----------+
  67. | ADMIN_COMMPUBS | CHAR |
  68. | ADMIN_CSF | CHAR |
  69. | BELLCUSTOMER | CHAR |
  70. | CORP_COMMS | CHAR |
  71. | ID | VARCHAR2 |
  72. | PW | VARCHAR2 |
  73. | SUPERADMIN | CHAR |
  74. +----------------+----------+
  75.  
  76.  
  77.  
  78.  
  79. Table: DOTCOM_ADMIN
  80.  
  81. +---------+----------------------------------+-----------+------------+------------+--------------+----------------+
  82. | ID | PW | ADMIN_CSF | SUPERADMIN | CORP_COMMS | BELLCUSTOMER | ADMIN_COMMPUBS |
  83. +---------+----------------------------------+-----------+------------+------------+--------------+----------------+
  84. | bh40733 | 9D955667304F8C4763466C1E93D21165 | n | n | n | y | y |
  85. | ii33214 | E46CE7E78EC2F9F6A64BF4034D5C0F37 | y | n | n | n | n |
  86. | ii34803 | 6996B8DE3B1FED144B69466AE3C0F836 | y | n | n | y | y |
  87. | bh42898 | EA9383A77CF45EB13E2AF4034582DF63 | n | n | n | y | n |
  88. | bh44986 | 8F5D480D62CC3A22A3617A0414CFE33B | y | y | y | y | y |
  89. | bh40943 | 60ED7B821089975AC98942EDD2E32BF5 | y | n | n | n | n |
  90. | sb28804 | D98DDAE4687891F7908B9712DB9175C2 | y | y | y | y | y |
  91. | bh40501 | 904633A020A671CC9DB90B9E7A7060D8 | y | y | y | y | y |
  92. | ii35724 | 95600FC2E1C4DCE343C9E59F21F5A843 | n | n | n | y | y |
  93. | ii22045 | ABF74C754D14070F9653EEC183AC48C0 | n | n | n | y | n |
  94. | PRS34 | C21F969B5F03D33D43E04F8F136E7682 | n | n | n | n | y |
  95. | bh77666 | 8FF861BCFD87BD85E9B207EA74CB6596 | y | n | y | n | n |
  96. | ii31448 | 1DC4A636F48C2467D5A28B133C21AEBF | n | n | n | y | n |
  97. | prscu | 0C40478CC73C4F0920A658C7431C04CC | n | n | n | n | y |
  98. | en28499 | E29E13AC702A77BCD28A4463A211EBA4 | n | n | n | y | n |
  99. | prsa5 | C21F969B5F03D33D43E04F8F136E7682 | n | n | n | n | y |
  100. | prs88 | 7AB0AF0FE82DD7A9C450E444EE7BE44C | n | n | n | n | y |
  101. | ii33116 | 111484AAF4D848E37ED314AF126FBC59 | y | y | y | y | y |
  102. | bh45667 | C21F969B5F03D33D43E04F8F136E7682 | y | y | n | y | y |
  103. | ii04075 | F994B85879CDB4D73BE59AAC8EB4D832 | n | n | n | y | n |
  104. | ii27882 | 0227AF233ABB930606A42847F2185187 | n | n | n | y | n |
  105. | ii32897 | 5BDE3BBF86BE7A2510D081CF0F59E107 | y | n | n | n | n |
  106. +---------+----------------------------------+-----------+------------+------------+--------------+----------------+
  107.  
  108.  
  109.  
  110. Table: CATEGORIES
  111.  
  112. +--------+----------+
  113. | Column | Type |
  114. +--------+----------+
  115. | ID | NUMBER |
  116. | NAME | VARCHAR2 |
  117. +--------+----------+
  118.  
  119.  
  120.  
  121.  
  122. Table: CATEGORIES
  123.  
  124. +-----+-----------------------------------------+
  125. | ID | NAME |
  126. +-----+-----------------------------------------+
  127. | 113 | 47 Operations Safety Notices |
  128. | 116 | 206L Service Instructions |
  129. | 119 | 429 Flight Manual Revisions |
  130. | 120 | 429 Maintenance Manual Revisions |
  131. | 1 | 407 Alert Service Bulletins |
  132. | 2 | 430 Technical Bulletins |
  133. | 4 | 214ST Operations Safety Notices |
  134. | 3 | 47 Alert Service Bulletins |
  135. | 5 | 206 Operations Safety Notices |
  136. | 6 | 412 Alert Service Bulletins |
  137. | 7 | 222/222B Operations Safety Notices |
  138. | 8 | 206L Information Letters |
  139. | 9 | General Operations Safety Notices |
  140. | 10 | 222U Operations Safety Notices |
  141. | 11 | 212 Information Letters |
  142. | 12 | 47 Technical Bulletins |
  143. | 13 | 430 Alert Service Bulletins |
  144. | 14 | 230 Operations Safety Notices |
  145. | 15 | 214B Operations Safety Notices |
  146. | 16 | 205/205A-1 Technical Bulletins |
  147. | 17 | General Information Letters |
  148. | 19 | 427 Information Letters |
  149. | 20 | 407 Operations Safety Notices |
  150. | 21 | 407 Information Letters |
  151. | 22 | 407 Technical Bulletins |
  152. | 23 | 412 Flight Manual Revisions |
  153. | 24 | 206L Alert Service Bulletins |
  154. | 25 | 206 Information Letters |
  155. | 26 | 205/205A1 Information Letters |
  156. | 27 | 214B Alert Service Bulletins |
  157. | 28 | 214ST Alert Service Bulletins |
  158. | 29 | 206L Operations Safety Notices |
  159. | 30 | 412 Information Letters |
  160. | 31 | 205/205A-1 Alert Service Bulletins |
  161. | 32 | 206 Technical Bulletins |
  162. | 33 | 206L Technical Bulletins |
  163. | 34 | 430 Operations Safety Notices |
  164. | 35 | 214ST Information Letters |
  165. | 36 | 222/222B Technical Bulletins |
  166. | 37 | 222U Technical Bulletins |
  167. | 38 | 230 Technical Bulletins |
  168. | 39 | 222/222B Information Letters |
  169. | 40 | 222U Information Letters |
  170. | 41 | 230 Information Letters |
  171. | 42 | 430 Information Letters |
  172. | 43 | 222/222B Alert Service Bulletins |
  173. | 44 | 222U Alert Service Bulletins |
  174. | 45 | 230 Alert Service Bulletins |
  175. | 46 | 212 Technical Bulletins |
  176. | 47 | 412 Technical Bulletins |
  177. | 48 | 412CF Technical Bulletins |
  178. | 49 | 206 Alert Service Bulletins |
  179. | 50 | 214B Technical Bulletins |
  180. | 51 | 214ST Technical Bulletins |
  181. | 52 | 204 Flight Manual Revisions |
  182. | 53 | 204B Operations Safety Notices |
  183. | 54 | 205/205A-1 Operations Safety Notices |
  184. | 55 | 212 Operations Safety Notices |
  185. | 56 | 205 Flight Manual Revisions |
  186. | 57 | 412CF Alert Service Bulletins |
  187. | 58 | 204B Information Letters |
  188. | 59 | UH-1H-II Information Letters |
  189. | 60 | 205B Information Letters |
  190. | 61 | 412 Operations Safety Notices |
  191. | 62 | 204B Alert Service Bulletins |
  192. | 63 | 205B Alert Service Bulletins |
  193. | 64 | UH-1H-II Alert Service Bulletin |
  194. | 65 | 212 Alert Service Bulletins |
  195. | 66 | 204B Technical Bulletins |
  196. | 67 | 412CF Information Letters |
  197. | 68 | 47 Information Letters |
  198. | 69 | 205B Operations Safety Notices |
  199. | 70 | 412CF Operations Safety Notices |
  200. | 71 | UH-1H-II Operations Safety Notices |
  201. | 72 | 205B Technical Bulletins |
  202. | 73 | 427 Technical Bulletins |
  203. | 74 | 427 Alert Service Bulletins |
  204. | 75 | 427 Operations Safety Notices |
  205. | 76 | UH-1H-II Technical Bulletins |
  206. | 77 | 206 Maintenance Manual Revisions |
  207. | 78 | 214B Information Letters |
  208. | 79 | BELL 407 PRODUCT UPDATES |
  209. | 80 | 210 Flight Manual Revisions |
  210. | 81 | 206L Flight Manual Revisions |
  211. | 82 | 230 Flight Manual Revisions |
  212. | 83 | 212 Flight Manual Revisions |
  213. | 84 | 210 Alert Service Bulletins |
  214. | 85 | 210 Information Letters |
  215. | 86 | 210 Operation Safety Notices |
  216. | 87 | 210 Technical Bulletins |
  217. | 88 | 230 Maintenance Manual Revisions |
  218. | 89 | 222/222B Maintenance Manual Revisions |
  219. | 90 | 206 Flight Manual Revisions |
  220. | 91 | 222U Maintenance Manual Revisions |
  221. | 92 | UH-1H Alert Service Bulletins |
  222. | 93 | UH-1H Special Use Technical Bulletins |
  223. | 94 | UH-1H Technical Bulletins |
  224. | 95 | UH-1H Operations Safety Notices |
  225. | 96 | UH-1H Information Letters |
  226. | 97 | 214 Flight Manual Revisions |
  227. | 114 | 429 Alert Service Bulletins |
  228. | 98 | 204 Maintenance Manual Revisions |
  229. | 99 | 205 Maintenance Manual Revisions |
  230. | 100 | 206L Maintenance Manual Revisions |
  231. | 101 | 210 Maintenance Manual Revisions |
  232. | 102 | 212 Maintenance Manual Revisions |
  233. | 103 | 214 Maintenance Manual Revisions |
  234. | 104 | 222 Flight Manual Revisions |
  235. | 105 | 230 Series Maintenance Manual Revisions |
  236. | 106 | 412 Maintenance Manual Revisions |
  237. | 107 | 407 Maintenance Manual Revisions |
  238. | 108 | 407 Flight Manual Revisions |
  239. | 109 | 430 Maintenance Manual Revisions |
  240. | 110 | 430 Flight Manual Revisions |
  241. | 111 | 427 Maintenance Manual Revisions |
  242. | 112 | 427 Flight Manual Revisions |
  243. | 115 | 429 Technical Bulletins |
  244. | 117 | 429 Information Letters |
  245. | 118 | 429 Operations Safety Notices |
  246. +-----+-----------------------------------------+
  247.  
  248.  
  249.  
  250. Table: SERVICES
  251.  
  252. +------------+----------+
  253. | Column | Type |
  254. +------------+----------+
  255. | ARF_ | VARCHAR2 |
  256. | B07 | VARCHAR2 |
  257. | B12 | VARCHAR2 |
  258. | B122 | VARCHAR2 |
  259. | B14 | VARCHAR2 |
  260. | B14B | VARCHAR2 |
  261. | B14ST | VARCHAR2 |
  262. | B22 | VARCHAR2 |
  263. | B30 | VARCHAR2 |
  264. | B302 | VARCHAR2 |
  265. | B4 | VARCHAR2 |
  266. | B5 | VARCHAR2 |
  267. | B7 | VARCHAR2 |
  268. | F_M_ONLY | VARCHAR2 |
  269. | ID | NUMBER |
  270. | M_204 | VARCHAR2 |
  271. | M_205 | VARCHAR2 |
  272. | M_212 | VARCHAR2 |
  273. | M_214 | VARCHAR2 |
  274. | M_214B | VARCHAR2 |
  275. | M_214ST | VARCHAR2 |
  276. | M_222 | VARCHAR2 |
  277. | M_230 | VARCHAR2 |
  278. | M_407 | VARCHAR2 |
  279. | M_412 | VARCHAR2 |
  280. | M_430 | VARCHAR2 |
  281. | M_47 | VARCHAR2 |
  282. | MDL30 | VARCHAR2 |
  283. | MDL_204 | VARCHAR2 |
  284. | MDL_205 | VARCHAR2 |
  285. | MDL_212 | VARCHAR2 |
  286. | MDL_214 | VARCHAR2 |
  287. | MDL_214B | VARCHAR2 |
  288. | MDL_214ST | VARCHAR2 |
  289. | MDL_222 | VARCHAR2 |
  290. | MDL_230 | VARCHAR2 |
  291. | MDL_407 | VARCHAR2 |
  292. | MDL_412 | VARCHAR2 |
  293. | MDL_47 | VARCHAR2 |
  294. | MILITARY__ | VARCHAR2 |
  295. | MILITARY_O | VARCHAR2 |
  296. | MILITARY_U | VARCHAR2 |
  297. | RBR | VARCHAR2 |
  298. | STANDARD | VARCHAR2 |
  299. +------------+----------+
  300.  
  301.  
  302.  
  303.  
  304.  
  305. Table: SERVICES
  306.  
  307. +-----+------+------+------+------+------+------+------------+------+------+------+------+------+------+------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+---------+---------+---------+---------+---------+---------+---------+---------+---------+----------+----------+------------+-----------+------------+------------+------------+
  308. | ID | B4 | B5 | B7 | B14 | B12 | B30 | RBR | B07 | B22 | B122 | B14B | ARF_ | B302 | M_47 | M_430 | M_222 | M_205 | M_412 | B14ST | M_230 | M_204 | M_212 | M_214 | M_407 | MDL30 | MDL_47 | M_214B | M_214ST | MDL_222 | MDL_412 | MDL_212 | MDL_214 | MDL_230 | MDL_407 | MDL_205 | MDL_204 | MDL_214B | F_M_ONLY | STANDARD | MDL_214ST | MILITARY_U | MILITARY_O | MILITARY__ |
  309. +-----+------+------+------+------+------+------+------------+------+------+------+------+------+------+------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+---------+---------+---------+---------+---------+---------+---------+---------+---------+----------+----------+------------+-----------+------------+------------+------------+
  310. | 126 | NULL | NULL | NULL | NULL | NULL | NULL | 206 SERIES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 47 | NULL | NULL | NULL | 412 | 212 | NULL | NULL | 407 | 205 | 204 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
  311. | 143 | NULL | NULL | NULL | NULL | 212 | NULL | NULL | NULL | NULL | 412 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 206 SERIES | NULL | NULL | NULL | NULL |
  312. | 153 | NULL | 205 | NULL | NULL | 212 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 206 SERIES | NULL | NULL | NULL | NULL |
  313. | 126 | NULL | NULL | NULL | NULL | NULL | NULL | 206 SERIES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 47 | NULL | NULL | NULL | 412 | 212 | NULL | NULL | 407 | 205 | 204 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
  314. | 143 | NULL | NULL | NULL | NULL | 212 | NULL | NULL | NULL | NULL | 412 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 206 SERIES | NULL | NULL | NULL | NULL |
  315. | 153 | NULL | 205 | NULL | NULL | 212 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 206 SERIES | NULL | NULL | NULL | NULL |
  316. +-----+------+------+------+------+------+------+------------+------+------+------+------+------+------+------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+---------+---------+---------+---------+---------+---------+---------+---------+---------+----------+----------+------------+-----------+------------+------------+------------+
  317.  
  318.  
  319.  
  320.  
  321. Table: JOB_FAIRS
  322. [
  323. +---------------------+----------+
  324. | Column | Type |
  325. +---------------------+----------+
  326. | CREATED | DATE |
  327. | DESCRIPTION | VARCHAR2 |
  328. | JOB_REQUISITION_NBR | VARCHAR2 |
  329. | JOBCODE | VARCHAR2 |
  330. | JOBLANG | VARCHAR2 |
  331. | JOBLOC | VARCHAR2 |
  332. | JOBTYPE | VARCHAR2 |
  333. | NAME | VARCHAR2 |
  334. +---------------------+----------+
  335.  
  336.  
  337.  
  338.  
  339. Table: JOBS
  340.  
  341. +----------------------------------------------------------------+-------------------+-----------+---------+------------------+----------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+
  342. | NAME | JOBLOC | CREATED | JOBCODE | JOBLANG | JOBTYPE | DESCRIPTION | JOB_REQUISITION_NBR |
  343. +----------------------------------------------------------------+-------------------+-----------+---------+------------------+----------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+
  344. | ENG-02 Sr Technical Specialist, Dynamic Structures | Mirabel, Canada | 13-OCT-05 | NULL | Canadian English | Engineering | \t\t\t\tThe incumbent will support \r\nthe CH146 Griffon programs \r\n(Structural Condition Monitoring, Usage Spectrum, ASIP \r\netc), regarding system integration, software requirements, \r\ndata management, and system development. In conjunction \r\nwith DND and other sub-contractors, conduct studies and \r\ninvestigative analysis, develop new structural condition \r\nmonitoring techniques, and identify and develop \r\nimprovements to CH146 Aircraft Structural Integrity \r\nProgram (ASIP). In coordination with other departments and \r\noutside contractors, conduct research projects and develop \r\nnew approaches, techniques, hardware and software for \r\nexpanding usage monitoring capabilities, and integrate \r\nthese new capabilities in the effective fleet management \r\nprogram. Minimum required qualifications : -Bachelor \r\nDegree in Mechanical, or Aeronautical Engineering -An \r\nadvanced degree would be an asset -Six (6) years of \r\nworking experience related to ASIP, helicopters, and \r\nsystem integration -Knowledge aircraft structural \r\nintegrity programs, usage and structural condition \r\nmonitoring systems, including their development, \r\nintegration, use and data management for aeronautical \r\napplications -Good communication interpersonal and \r\norganizational skills -Functional knowledge of English and \r\nFrench | 10000 |
  345. | ING-01 Sp\xe9cialiste technique principal, liaison | Mirabel, Canada | 08-JUL-04 | NULL | French | Ing\xe9nierie | \t\t\t\tVous avez un minimum de \r\ndix \r\nans d'exp\xe9rience pertinente en mati\xe8re de conception et/ou \r\nde liaison avec au moins cinq ans d'exp\xe9rience en support \r\n\xe0 \r\nla production. Vous serez responsable d'apporter des \r\nmodifications techniques, d'implanter des strat\xe9gies de \r\nr\xe9paration de structures m\xe9talliques et composites, et de \r\ndonner des conseils techniques au personnel de l'atelier \r\nde \r\nproduction et aux employ\xe9s associ\xe9s. | 5877 |
  346. | ING-02 Sp\xe9cialiste technique principal, structure dynamique | Mirabel, Canada | 19-OCT-06 | NULL | French | Ing\xe9nierie | \t\t\t\tSommaire des t\xe2ches : La \r\nou le titulaire apportera son concours aux programmes du \r\nCH146 Griffon (surveillance de conditions structurelles, \r\ngammes d'utilisation, Programme de v\xe9rification de la \r\nr\xe9sistance structurelle des a\xe9ronefs, ASIP, etc.) en ce \r\nqui a trait \xe0 l'int\xe9gration des syst\xe8mes, aux exigences \r\nlogicielles, \xe0 la gestion de donn\xe9es, et au d\xe9veloppement \r\nde syst\xe8me. En liaison avec le MDN et d'autres sous-\r\ntraitants, effectuer des \xe9tudes et des analyses \r\napprofondies, \xe9laborer de nouvelles techniques de \r\nsurveillance de conditions structurelles, et identifier et \r\nd\xe9velopper des am\xe9liorations au programme de la \r\nv\xe9rification de la r\xe9sistance structurelle (ASIP) du \r\nmod\xe8le CH146. En accord avec d'autres d\xe9partements et sous-\r\ntraitants externes, mettre en oeuvre des projets de \r\nrecherche et \xe9laborer de nouvelles approches et techniques \r\nainsi que du nouveaux appareils et logiciels en vue \r\nd'\xe9largir nos capacit\xe9s d'utilisation, et int\xe9grer ces \r\nnouvelles capacit\xe9s au programme de gestion de la flotte \r\nactive (d'a\xe9ronefs). Exigences minimales requises : -\r\nBaccalaur\xe9at en g\xe9nie m\xe9canique ou a\xe9ronautique -Dipl\xf4me \r\nde deuxi\xe8me ou troisi\xe8me cycle serait un atout -Six (6) \r\nans d'exp\xe9rience de travail li\xe9e aux ASIP, h\xe9licopt\xe8res, \r\net int\xe9gration de syst\xe8mes -Connaissance des programmes de \r\nla v\xe9rification de la r\xe9sistance structurelle d'a\xe9ronefs, \r\nde syst\xe8me de surveillance d'utilisation et de conditions \r\nstructurelles incluant le d\xe9veloppement, l'int\xe9gration, \r\nl'usage et la gestion de donn\xe9es li\xe9s aux applications \r\na\xe9ronautiques -Bon sens de communication interpersonnelle \r\net d'organisation -Connaissance fonctionnelle du fran\xe7ais \r\net de l'anglais | 00000 |
  347. | Logistics/Customer Support | Fort Worth, Texas | 04-AUG-03 | NULL | English | Logistics/Customer Support | If an open position is available for Logistics/Customer Support it will be listed on the Textron website. Click on <A HREF=http://www.textronjobs.com>www.textronjobs.com</A> \r\nto access the Textron website. | NULL |
  348. | ING-04 Sp\xe9cialiste technique, analyse structurale | Mirabel, Canada | 20-OCT-06 | NULL | French | Ing\xe9nierie | \t\t\t\tSommaire des t\xe2ches : \r\nRelevant du Chef, Structure de la Cellule, vos fonctions \r\ncomprendront: -l'assistance technique \xe0 l'\xe9gard des \r\ndivergences survenues en atelier -l'assistance au service \r\ndu soutien technique en ce qui concerne les strat\xe9gies de \r\nr\xe9paration de l'h\xe9licopt\xe8re -l'analyse de structures \r\nreli\xe9e \xe0 la cellule ainsi que l'\xe9laboration des rapports \r\nde certification pour les structures de cellule nouvelles \r\nou modifi\xe9es. Exigences minimales requises : -Baccalaur\xe9at \r\nen g\xe9nie m\xe9canique ou en g\xe9nie a\xe9rospatial -Trois (3) ans \r\nd'exp\xe9rience dans l'industrie a\xe9rospatiale en analyses de \r\nstructure -Pr\xe9f\xe9rablement ing\xe9nieur attitr\xe9 ou ayant les \r\nqualifications requises pour le devenir -Connaissance de \r\nla conception assist\xe9e par ordinateur (CATIA), la \r\nmod\xe9lisation par la m\xe9thode d'\xe9l\xe9ments finis \r\n(PATRAN/NASTRAN) ainsi que des outils permettant leur \r\ninterface -Bonne compr\xe9hension des m\xe9thodes de fabrication \r\nutilis\xe9es dans l'industrie a\xe9rospatiale -Connaissance en \r\nconception et analyse des mat\xe9riaux composites serait tr\xe8s \r\nsouhaitable -Connaissance fonctionnelle de l'anglais et \r\nconnaissance du fran\xe7ais | 10401 |
  349. | ENG-04 Technical Specialist, structure | Mirabel, Canada | 20-OCT-06 | NULL | Canadian English | Engineering | \t\t\t\tSummary of job \r\ndescription : Reporting to the Chief, Airframe Structures, \r\nyour tasks will include : -Engineering support with regard \r\nto shop floor discrepancies\r\n-Assistance to the Product Support department in preparing \r\nhelicopter repair schemes -Airframe structural analyses \r\nand certification report preparation on new or modified \r\nairframe structures. Minimum required qualifications : -\r\nBachelor degree in Mechanical Engineering or Aeronautical \r\nEngineering -Three (3) years of experience in the \r\naerospace industry in structural analyses -Preferably a \r\nprofessional engineer, or with the qualifications to \r\nbecome one -Knowledge of computer aided design (CATIA), \r\nfinite element modelling (PATRAN/NASTRAN) and their \r\ninterface tools -A good understanding of the manufacturing \r\nmethods used in the aerospace industry -Knowledge of \r\ncomposite material design and analysis methods is highly \r\ndesirable -Functional knowledge of English and knowledge \r\nof French | 10401 |
  350. | ING-06 Sp\xe9cialiste technique, mat. et proc\xe9d\xe9s | Mirabel, Canada | 20-OCT-06 | NULL | French | Ing\xe9nierie | \t\t\t\tSommaire des t\xe2ches : -\r\n\xc9valuer et solutionner des probl\xe8mes non-m\xe9talliques \r\n(adh\xe9sifs et composites) reli\xe9s \xe0 la production, \xe0 \r\nl'assurance de la qualit\xe9 et au soutien \xe0 la production. \r\nDe plus, assurer le soutien technique en ce qui a trait \r\naux questions \xe0 l'assurance de la qualit\xe9 aupr\xe8s des \r\nfournisseurs, \xe0 l'approvisionnement de m\xeame qu'\xe0 d'autres \r\nd\xe9partements. -Surveiller et approuver les essais et les \r\n\xe9valuations des mat\xe9riaux non-m\xe9talliques (adh\xe9sifs et \r\ncomposites) des proc\xe9d\xe9s, des pi\xe8ces ou des ensembles -\r\nAssurer le soutien technique \xe0 la conception technique en \r\nr\xe9visant et approuvant les dessins techniques, et ce, au \r\ncours de toutes les phases de la s\xe9lection et proc\xe9d\xe9s des \r\nmat\xe9riaux non-m\xe9talliques.\r\nExigences minimales requises : -Baccalaur\xe9at en ing\xe9nierie \r\nm\xe9canique ou en science des mat\xe9riaux -Trois (3) ans \r\nd'exp\xe9rience pertinente dans le domaine des mat\xe9riaux non-\r\nm\xe9talliques et des proc\xe9d\xe9s en milieu a\xe9ronautique -\r\nMa\xeetrise en g\xe9nie est un atout -Connaissance fonctionnelle \r\ndu fran\xe7ais et de l'anglais | 10006 |
  351. | ENG-06 Technical Specialist, Materials and Process | Mirabel, Canada | 20-OCT-06 | NULL | Canadian English | Engineering | \t\t\t\tSummary of job \r\ndescription : -Evaluate and solve Production, Quality \r\nAssurance and Product Support related non-metallic \r\n(adhesive and composite) problems. Also, provide \r\ntechnical support to SQA, Procurement and other \r\ndepartments on non-metallic issues -Supervise and approve \r\ntest and evaluation of non-metallic materials, processes, \r\nparts or assemblies -Provide technical support to Design \r\nEngineering by review and approval of Engineering drawings \r\nin all phases of non-metallic material selection and \r\nprocessing. Minimum required qualifications : -Bachelor \r\ndegree in Mechanical Engineering or Materials Science -\r\nThree (3) years of pertinent experience in non-metallic, \r\nmaterials and processing in an aerospace environment -\r\nMasters Degree is an asset -Functional knowledge of French \r\nand English | 10006 |
  352. | ENG-01 Sr Technical Specialist, Liaison | Mirabel, Canada | 14-MAY-04 | NULL | Canadian English | Engineering | \t\t\t\tYou have a minimum of ten \r\nyears' pertinent experience in Design and/or Liaison with \r\nat least five years of experience in an MRB environment. \r\nYou will be responsible for designing changes and \r\nimplementing repair schemes on metal and composite \r\nstructures, as well as providing technical guidance to \r\nProduction and associated staff. | 95877 |
  353. | Senior Eng Manufacturing Development 4212 | Grand Prairie, TX | 09-JUN-06 | B3806 | English | Manufacturing Support | <P><B>Position Requirements:</b> Approximately 5-7 years of experience in manufacturing development or related discipline in manufacturing to include experience in designing, constructing, maintaining and estimating complex mechanical test stands/equipment is preferred with working knowledge of machine part manufacturing methods, tolerancing, material applications and processes. Good communications skills (oral and written). Working knowledge of PC applications such a Microsoft Office is desirable. </P> \r\n<P><B>Education Requirements:</b> B.S. Mechanical, Electrical, or other related engineering discipline with 5-7 years of experience in Mechanical Power Distribution, Automated Controls, and/or Fluid Mechanics. ~cb~ </P> | 4212 |
  354. | Sr Engineer Specialist (Reliability and Maintainability) 6933 | Fort Worth, Texas | 27-APR-06 | B3407 | English | Engineering | <b>Education:</b> BS degree in engineering or other applicable technical discipline.\r\n\r\n<b>Position Requirements: </b> Strong R&M experience (typically 12-15 years, minimum 8 years). Knowledge of R&M parameters to include MTBF, MTTR, fault detection, and fault isolation. Proficiency in the collection, analysis, and scoring of FRACAS data. Demonstrated ability to monitor, and recommend corrective actions, to collected FRACAS data. Knowledge of CARTS and ability to become proficient in maintaining the integrity of this data. Knowledge of maintainability/testability analysis requirements, and the ability to render corrective actions from an analysis of flight-test data. Ability to provide constructive comments to maintenance concepts. Proficient in Microsoft Office applications.\r\n\r\n<b>Preferred:</b> Additional R&M experience (typically 12-15 yeas total) working with aerospace components/systems.\r\n\r\n<b>Textron is an Equal Opportunity Employer (M/F/D/V) </b>\r\n | 6933 |
  355. | Engineer Specialist - Civil Certification 4782 | Arlington, TX | 26-JAN-06 | B3358 | English | Engineering | \t\t\t\t<P><B>Responsibilities:</b>\r\nThis Position is responsible for identifying, facilitating \r\ncompletion, and formalizing any necessary efforts which \r\nmust be completed to achieve civil certification of BHT \r\nproducts by the FAA and CAAs world wide. Specific \r\nresponsibilities include, but are not limited to:\r\n- Conduct formal communications with FAA/CAAs to initiate \r\nprojects and facilitate efforts (type data submittal, \r\ncertification issues resolution discussions, compliance \r\ndemonstrations, etc.) necessary to obtain type \r\ncertification.\r\n- Generate Project Specific Certification Plans and \r\nfacilitate generation of System Specific Certification \r\nPlans for BHT products requiring certification and obtain \r\nAuthority (FAA/JAA/EASA/CAAs) acceptance to these \r\ndocuments. Certification Plans include identification of \r\ncertification basis and methods of showing compliance to \r\neach regulation in the certification basis.\r\n- Coordinate BHT Technical Specialists in establishing \r\nApplicant's positions for decisions effecting certification \r\nof BHT products.\r\n- Coordinate Applicant/Authority Technical Specialists \r\ninteractions in establishing agreements for decisions \r\neffecting certification of BHT products.\r\n\r\n<p><b>Education:</b> BS or MS in Engineering or other \r\nrelated technical field.\r\n\r\n<P><B>Position Requirements:</b> \r\n- Minimum 5 years experience executing aircraft \r\ncertification procedures governing Applicant and Authority \r\n(FAA, JAA, EASA, foreign CAAs) interactions addressing: \r\nProject/System Specific Certification Plans, Certification \r\nBasis, Compliance Plan/Checklist, Statement of Compliance \r\n(type design data approval), and Certification Testing.\r\n- Proven ability in problem solving and effective \r\ncommunication skills.\r\n- Efficient PC skills/software knowledge for conducting \r\ninformation management including MS Word, Access, and \r\nOutlook.\r\n\r\n<P><B>Preferred:</b>\r\n- Additional strong experience (typically 8-15 years) \r\nexecuting aircraft certification procedures\r\n- Experienced and knowledgeable to the content of FAA, JAA, \r\nEASA, and foreign CAAs documentation governing aircraft \r\ncertification and continued airworthiness (FARs & JARs, \r\nAdvisory Circulars, Notice of Proposed Rule Making, Issue \r\nPapers, FAA Orders, and Airworthiness Directives)\r\n- Understanding of FAA\x19s Designee Systems\r\n- Experience with management of civil certification \r\nprojects (TCs and STCs)\r\n- Experience with software programs for tracking \r\nrequirements compliance and producing metrics reporting \r\nprogram progress.\r\n\r\n<P><B>Textron is an Equal Opportunity Employer (M/F/D/V)</b> | 4782 |
  356. | Product Support Representative | Mirabel, Canada | 14-JUN-07 | NULL | Canadian English | Product Support | Working on a flexible schedule, you will use your extensive technical and business expertise to provide Bell Helicopter customers with world-class after-delivery support. \r\n\r\nYou will develop inspection, maintenance, trouble-shooting, and repair/overhaul functions according to our industry-leading standards. You will also be called upon to: provide information and assistance to maintain a balanced spare parts inventory, participate in domestic and international customer interactions, prepare product training and educational aids, and perform off-site assignments worldwide. You possess an Aircraft Maintenance Engineer License (category M1, M2 and/or E or S) with six (6) years of (preferably commercial rotary wing) experience, of which four (4) years are field experience (where overhaul activity would be an asset). You have a working knowledge of international governing aviation agencies with abilities to interpret engineering design drawings and specifications. Also, with your working knowledge of MS Windows and MS Office, and an aptitude for proficiensy in other software.\r\n\r\nCandidates will be challenged to demonstrate business and management potential, projecting visible talent in effective customer relations.\r\nThis position requires access to or use of ''controlled goods'', which includes controlled technical data, information, hardware and software. Any applicant must, accordingly, be eligible to meet requirements of the Canadian Controlled Goods Program (CGP), the U.S. International Traffic in Arms Regulations (ITAR), and any other relevant government security clearance(s) and applicable requirements.''\r\n\r\n | 12110 |
  357. | Repr\xe9sentant, soutien technique | Mirabel, Canada | 14-JUN-07 | NULL | French | Soutien technique | Travaillant sur un horaire flexible, vous vous servirez de vos vastes comp\xe9tences techniques et de votre expertise dans le domaine des affaires afin de procurer aux clients de Bell Helicopter un soutien apr\xe8s livraison de niveau international.\r\n\r\nVous d\xe9velopperez vos responsabilit\xe9s d\x19inspection, d\x19entretien, de diagnostic d\x19anomalies et de r\xe9paration / r\xe9vision selon les premi\xe8res normes de l\x19industrie. Vous serez \xe9galement appel\xe9 \xe0 fournir des renseignements et de l\x19assistance afin de maintenir un inventaire \xe9quilibr\xe9 de pi\xe8ces de rechange, d\x19interagir avec des clients nationaux et internationaux, de pr\xe9parer du mat\xe9riel d\x19instruction sur le produit et des moyens didactiques, et d\x19accepter \xe0 effectuer du travail hors site partout dans le monde. Vous poss\xe9dez une licence de m\xe9canicien d'entretien d'a\xe9ronefs (cat\xe9gorie M1, M2), ayant six (6) ans d\x19exp\xe9rience (de pr\xe9f\xe9rence dans le domaine d\x19a\xe9ronefs commerciaux \xe0 voilure tournante) dont quatre (4) ans sur le terrain. Vous avez une connaissance fonctionnelle des organismes dirigeants d\x19aviation internationaux, ayant des comp\xe9tences en mati\xe8re de l\x19interpr\xe9tation de dessins de conception technique et de sp\xe9cifications. De plus, ayant une connaissance fonctionnelle de MS Windows et de MS Office, ainsi que l\x19aptitude \xe0 ma\xeetriser d\x19autres logiciels.\r\n\r\nLes candidats seront appel\xe9s \xe0 d\xe9montrer leurs aptitudes en administration et en gestion en faisant preuve de leur talent \xe9vident pour les rapports utiles avec les clients.\r\nCet emploi requiert l'acc\xe8s ou l'utilisation de \xabmarchandises contr\xf4l\xe9es\xbb, y compris des donn\xe9es techniques, des renseignments, de l'\xe9quipement et des logiciels. Par cons\xe9quent, tout postulant doit \xeatre en mesure de satisfaire aux exigences du Programme des marchandises contr\xf4l\xe9es du gouvernement canadien (PMC), des U.S. International Traffic in Arms Regulations (ITAR), et de tout autre attestation de s\xe9curit\xe9 gouvernementale ou exigence pertinente. | 12110 |
  358. +----------------------------------------------------------------+-------------------+-----------+---------+------------------+----------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------------------+
  359.  
  360.  
  361.  
  362. Table: MENU
  363.  
  364. +----------------+----------+
  365. | Column | Type |
  366. +----------------+----------+
  367. | HREF | VARCHAR2 |
  368. | MENU_ID | NUMBER |
  369. | NAME | VARCHAR2 |
  370. | PARENT_MENU_ID | NUMBER |
  371. +----------------+----------+
  372.  
  373.  
  374.  
  375.  
  376. Table: MENU
  377.  
  378. +---------+----------------+-----------------------------+------------------+
  379. | MENU_ID | PARENT_MENU_ID | HREF | NAME |
  380. +---------+----------------+-----------------------------+------------------+
  381. | 1 | NULL | NULL | Company Info |
  382. | 2 | NULL | NULL | Products |
  383. | 3 | NULL | NULL | Training |
  384. | 4 | NULL | NULL | Contact Us |
  385. | 5 | NULL | NULL | Encyclopedia |
  386. | 6 | 1 | /companyInfo/welcomeToBell/ | About |
  387. | 7 | 8 | /customerSupport/overview | Overview |
  388. | 8 | NULL | NULL | Customer Support |
  389. | 10 | 8 | /customerSupport/claims | Claims |
  390. | 1 | NULL | NULL | Company Info |
  391. | 2 | NULL | NULL | Products |
  392. | 3 | NULL | NULL | Training |
  393. | 4 | NULL | NULL | Contact Us |
  394. | 5 | NULL | NULL | Encyclopedia |
  395. | 6 | 1 | /companyInfo/welcomeToBell/ | About |
  396. | 7 | 8 | /customerSupport/overview | Overview |
  397. | 8 | NULL | NULL | Customer Support |
  398. | 10 | 8 | /customerSupport/claims | Claims |
  399. +---------+----------------+-----------------------------+------------------+
  400.  
  401.  
  402.  
  403.  
  404. Database:MDSYS
  405.  
  406. +--------------------------------+
  407. | OGIS_GEOMETRY_COLUMNS |
  408. | OGIS_SPATIAL_REFERENCE_SYSTEMS |
  409. | SDO_COORD_AXES |
  410. | SDO_COORD_AXIS_NAMES |
  411. | SDO_COORD_OPS |
  412. | SDO_COORD_OP_METHODS |
  413. | SDO_COORD_OP_PARAMS |
  414. | SDO_COORD_OP_PARAM_USE |
  415. | SDO_COORD_OP_PARAM_VALS |
  416. | SDO_COORD_OP_PATHS |
  417. | SDO_COORD_REF_SYS |
  418. | SDO_COORD_SYS |
  419. | SDO_CS_SRS |
  420. | SDO_DATUMS |
  421. | SDO_DATUMS_OLD_SNAPSHOT |
  422. | SDO_ELLIPSOIDS |
  423. | SDO_ELLIPSOIDS_OLD_SNAPSHOT |
  424. | SDO_GEOR_PLUGIN_REGISTRY |
  425. | SDO_GEOR_XMLSCHEMA_TABLE |
  426. | SDO_GR_MOSAIC_0 |
  427. | SDO_GR_MOSAIC_1 |
  428. | SDO_GR_MOSAIC_2 |
  429. | SDO_GR_MOSAIC_3 |
  430. | SDO_GR_RDT_1 |
  431. | SDO_PREFERRED_OPS_SYSTEM |
  432. | SDO_PREFERRED_OPS_USER |
  433. | SDO_PRIME_MERIDIANS |
  434. | SDO_PROJECTIONS_OLD_SNAPSHOT |
  435. | SDO_ST_TOLERANCE |
  436. | SDO_TOPO_DATA$ |
  437. | SDO_TOPO_RELATION_DATA |
  438. | SDO_TOPO_TRANSACT_DATA |
  439. | SDO_TXN_IDX_DELETES |
  440. | SDO_TXN_IDX_EXP_UPD_RGN |
  441. | SDO_TXN_IDX_INSERTS |
  442. | SDO_UNITS_OF_MEASURE |
  443. | SDO_XML_SCHEMAS |
  444. +--------------------------------+
  445.  
  446.  
  447.  
  448.  
  449.  
  450. Table: SDO_COORD_OP_METHODS
  451.  
  452. +------------------------+----------+
  453. | Column | Type |
  454. +------------------------+----------+
  455. | COORD_OP_METHOD_ID | NUMBER |
  456. | COORD_OP_METHOD_NAME | VARCHAR2 |
  457. | DATA_SOURCE | VARCHAR2 |
  458. | INFORMATION_SOURCE | VARCHAR2 |
  459. | IS_IMPLEMENTED_FORWARD | NUMBER |
  460. | IS_IMPLEMENTED_REVERSE | NUMBER |
  461. | LEGACY_NAME | VARCHAR2 |
  462. | REVERSE_OP | NUMBER |
  463. +------------------------+----------+
  464.  
  465.  
  466.  
  467.  
  468. Table: SDO_COORD_OP_METHODS
  469.  
  470. +--------------------+------------+-------------+----------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------+------------------------+------------------------+
  471. | COORD_OP_METHOD_ID | REVERSE_OP | DATA_SOURCE | LEGACY_NAME | INFORMATION_SOURCE | COORD_OP_METHOD_NAME | IS_IMPLEMENTED_FORWARD | IS_IMPLEMENTED_REVERSE |
  472. +--------------------+------------+-------------+----------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------+------------------------+------------------------+
  473. | 9601 | 1 | EPSG | NULL | EPSG guidance note #7. | Longitude rotation | 1 | 1 |
  474. | 9602 | 1 | EPSG | NULL | EPSG guidance note #7 from "Transformation from spatial to geographical coordinates"; B. R. Bowring; Survey Review number 181; July 1976. | Geographic/geocentric conversions | 0 | 0 |
  475. | 9603 | 1 | EPSG | NULL | EPSG guidance note #7. | Geocentric translations | 1 | 1 |
  476. | 9604 | 1 | EPSG | NULL | NULL | Molodenski | 0 | 0 |
  477. | 9605 | 1 | EPSG | NULL | EPSG guidance note #7. | Abridged Molodenski | 0 | 0 |
  478. | 9606 | 1 | EPSG | NULL | EPSG guidance note #7. | Position Vector 7-param. transformation | 1 | 1 |
  479. | 9607 | 1 | EPSG | NULL | EPSG guidance note #7. | Coordinate Frame rotation | 1 | 1 |
  480. | 9613 | 1 | EPSG | NULL | US Coast and geodetic Survey - http://www.ngs.noaa.gov | NADCON | 1 | 1 |
  481. | 9614 | 1 | EPSG | NULL | Geomatics Canada - Geodetic Survey Division. | NTv1 | 0 | 0 |
  482. | 9615 | 1 | EPSG | NULL | http://www.geod.nrcan.gc.ca/products/html-public/GSDapps/English/NTv2_Fact_Sheet.html | NTv2 | 1 | 1 |
  483. | 9616 | 1 | EPSG | NULL | EPSG guidance note #7. | Vertical Offset | 0 | 0 |
  484. | 9617 | 0 | EPSG | NULL | EPSG guidance note #7, after Institut de Geomatica; Barcelona. | Madrid to ED50 | 0 | 0 |
  485. | 9618 | 1 | EPSG | NULL | EPSG guidance note #7. | Geographical and Height Offsets | 1 | 1 |
  486. | 9619 | 1 | EPSG | NULL | EPSG guidance note #7. | Geographical Offsets | 1 | 1 |
  487. | 9620 | 0 | EPSG | NULL | Norwegian Mapping Authority note of 13-Feb-1991 "Om Transformasjon mellom Geodetiske Datum i Norge". | Norway Offshore Interpolation | 0 | 0 |
  488. | 9621 | 0 | EPSG | NULL | EPSG guidance note #7. | Similarity transformation | 0 | 0 |
  489. | 9622 | 0 | EPSG | NULL | EPSG guidance note #7. | Affine orthogonal geometric transformation | 0 | 0 |
  490. | 9623 | 0 | EPSG | NULL | EPSG guidance note #7. | Affine general geometric transformation | 0 | 0 |
  491. | 9624 | 0 | EPSG | NULL | EPSG guidance note #7 | Affine general parametric transformation | 0 | 0 |
  492. | 9625 | 0 | EPSG | NULL | EPSG guidance note #7. | General polynomial (2nd-order) | 0 | 0 |
  493. | 9626 | 0 | EPSG | NULL | EPSG guidance note #7. | General polynomial (3rd-order) | 0 | 0 |
  494. | 9627 | 0 | EPSG | NULL | EPSG guidance note #7. | General polynomial (4th-order) | 0 | 0 |
  495. | 9628 | 1 | EPSG | NULL | EPSG guidance note #7. | Reversible polynomial (2nd-order) | 0 | 0 |
  496. | 9629 | 1 | EPSG | NULL | EPSG guidance note #7. | Reversible polynomial (3rd-order) | 0 | 0 |
  497. | 9630 | 1 | EPSG | NULL | EPSG guidance note #7. | Reversible polynomial (4th-order) | 0 | 0 |
  498. | 9631 | 0 | EPSG | NULL | EPSG guidance note #7. | Complex polynomial (3rd-order) | 0 | 0 |
  499. | 9632 | 0 | EPSG | NULL | EPSG guidance note #7. | Complex polynomial (4th-order) | 0 | 0 |
  500. | 9633 | 1 | EPSG | NULL | http://www.gps.gov.uk/gpssurveying.asp | Ordnance Survey National Transformation | 0 | 0 |
  501. | 9634 | 0 | EPSG | NULL | Survey of New Brunswick | Maritime Provinces polynomial interpolation | 0 | 0 |
  502. | 9635 | 1 | EPSG | NULL | NULL | Geographic3D to Geographic2D+GravityRelatedHeight | 0 | 0 |
  503. | 9636 | 1 | EPSG | NULL | EPSG guidance note #7. | Molodenski-Badekas transformation | 0 | 0 |
  504. | 9637 | 1 | EPSG | NULL | EPSG guidance note #7. | Degree representation conversion: deg to DMSH | 0 | 0 |
  505. | 9638 | 1 | EPSG | NULL | EPSG guidance note #7. | Degree representation conversion: degH to DMSH | 0 | 0 |
  506. | 9639 | 1 | EPSG | NULL | EPSG guidance note #7. | Degree representation conversion: Hdeg to DMSH | 0 | 0 |
  507. | 9640 | 1 | EPSG | NULL | EPSG guidance note #7. | Degree representation conversion: DM to DMSH | 0 | 0 |
  508. | 9641 | 1 | EPSG | NULL | EPSG guidance note #7. | Degree representation conversion: DMH to DMSH | 0 | 0 |
  509. | 9642 | 1 | EPSG | NULL | EPSG guidance note #7. | Degree representation conversion: HDM to DMSH | 0 | 0 |
  510. | 9643 | 1 | EPSG | NULL | EPSG guidance note #7. | Degree representation conversion: DMS to DMSH | 0 | 0 |
  511. | 9644 | 1 | EPSG | NULL | EPSG guidance note #7. | Degree representation conversion: HDMS to DMSH | 0 | 0 |
  512. | 9645 | 0 | EPSG | NULL | EPSG guidance note #7. | General polynomial of degree 2 | 0 | 0 |
  513. | 9646 | 0 | EPSG | NULL | EPSG guidance note #7. | General polynomial of degree 3 | 0 | 0 |
  514. | 9647 | 0 | EPSG | NULL | EPSG guidance note #7. | General polynomial of degree 4 | 0 | 0 |
  515. | 9648 | 0 | EPSG | NULL | EPSG guidance note #7. | General polynomial of degree 6 | 0 | 0 |
  516. | 9649 | 1 | EPSG | NULL | EPSG guidance note #7. | Reversible polynomial of degree 2 | 0 | 0 |
  517. | 9650 | 1 | EPSG | NULL | EPSG guidance note #7. | Reversible polynomial of degree 3 | 0 | 0 |
  518. | 9651 | 1 | EPSG | NULL | EPSG guidance note #7. | Reversible polynomial of degree 4 | 0 | 0 |
  519. | 9652 | 0 | EPSG | NULL | EPSG guidance note #7. | Complex polynomial of degree 3 | 0 | 0 |
  520. | 9653 | 0 | EPSG | NULL | EPSG guidance note #7. | Complex polynomial of degree 4 | 0 | 0 |
  521. | 9654 | 1 | EPSG | NULL | EPSG guidance note #7. | Reversible polynomial of degree 13 | 0 | 0 |
  522. | 9801 | 1 | EPSG | NULL | EPSG guidance note #7. | Lambert Conic Conformal (1SP) | 1 | 1 |
  523. | 9802 | 1 | EPSG | Lambert Conformal Conic | EPSG guidance note #7. | Lambert Conic Conformal (2SP) | 1 | 1 |
  524. | 9803 | 1 | EPSG | Lambert Conformal Conic (Belgium 1972) | EPSG guidance note #7. | Lambert Conic Conformal (2SP Belgium) | 1 | 1 |
  525. | 9804 | 1 | EPSG | NULL | EPSG guidance note #7. | Mercator (1SP) | 1 | 1 |
  526. | 9805 | 1 | EPSG | Mercator | EPSG guidance note #7. | Mercator (2SP) | 1 | 1 |
  527. | 9806 | 1 | EPSG | Cassini | EPSG guidance note #7. | Cassini-Soldner | 1 | 1 |
  528. | 9807 | 1 | EPSG | Transverse Mercator | EPSG guidance note #7. | Transverse Mercator | 1 | 1 |
  529. | 9808 | 1 | EPSG | NULL | EPSG guidance note #7. | Transverse Mercator (South Orientated) | 1 | 1 |
  530. | 9809 | 1 | EPSG | NULL | EPSG guidance note #7. | Oblique Stereographic | 1 | 1 |
  531. | 9810 | 1 | EPSG | NULL | EPSG guidance note #7. | Polar Stereographic (variant A) | 1 | 1 |
  532. | 9811 | 1 | EPSG | NULL | New Zealand Department of Lands technical circular 1973/32 | New Zealand Map Grid | 1 | 1 |
  533. | 9812 | 1 | EPSG | NULL | EPSG guidance note #7. | Hotine Oblique Mercator | 1 | 1 |
  534. | 9813 | 1 | EPSG | NULL | "La nouvelle projection du Service Geographique de Madagascar"; J. Laborde; 1928 | Laborde Oblique Mercator | 0 | 0 |
  535. | 9814 | 1 | EPSG | NULL | "Die projecktionen der Schweizerischen Plan und Kartenwerke"; J Bollinger; 1967 | Swiss Oblique Cylindrical | 0 | 0 |
  536. | 9815 | 1 | EPSG | NULL | EPSG guidance note #7. | Oblique Mercator | 1 | 1 |
  537. | 9816 | 1 | EPSG | NULL | EPSG guidance note #7. | Tunisia Mining Grid | 0 | 0 |
  538. | 9817 | 1 | EPSG | NULL | EPSG guidance note #7. | Lambert Conic Near-Conformal | 1 | 1 |
  539. | 9818 | 1 | EPSG | NULL | US Geological Survey Professional Paper 1395; "Map Projections - A Working Manual"; J. Snyder | American Polyconic | 0 | 0 |
  540. | 9819 | 1 | EPSG | NULL | Research Institute for Geodesy Topography and Cartography (VUGTK); Prague. | Krovak Oblique Conic Conformal | 1 | 1 |
  541. | 9820 | 1 | EPSG | NULL | USGS Professional Paper 1395, "Map Projections - A Working Manual" by John P. Snyder. | Lambert Azimuthal Equal Area | 1 | 1 |
  542. | 9821 | 1 | EPSG | NULL | USGS Professional Paper 1395, "Map Projections - A Working Manual" by John P. Snyder. | Lambert Azimuthal Equal Area (Spherical) | 0 | 0 |
  543. | 9822 | 1 | EPSG | NULL | USGS Professional Paper 1395, "Map Projections - A Working Manual" by John P. Snyder. | Albers Equal Area | 1 | 1 |
  544. | 9823 | 1 | EPSG | NULL | US Geological Survey Professional Paper 1395; "Map Projections - A Working Manual"; J. Snyder. | Equidistant Cylindrical | 1 | 1 |
  545. | 9824 | 1 | EPSG | NULL | EPSG Guidance Note #7. | Transverse Mercator Zoned Grid System | 0 | 0 |
  546. | 9825 | 1 | EPSG | NULL | EPSG | Pseudo Plate Carree | 1 | 1 |
  547. | 9826 | 1 | EPSG | NULL | EPSG guidance note #7. | Lambert Conic Conformal (West Orientated) | 1 | 1 |
  548. | 9827 | 1 | EPSG | NULL | US Geological Survey Professional Paper 1395, "Map Projections - A Working Manual" by John P Snyder. | Bonne | 0 | 0 |
  549. | 9828 | 1 | EPSG | NULL | EPSG guidance note #7. | Bonne (South Orientated) | 0 | 0 |
  550. | 9829 | 1 | EPSG | Polar Stereographic | EPSG guidance note #7. | Polar Stereographic (variant B) | 1 | 1 |
  551. | 9830 | 1 | EPSG | NULL | EPSG guidance note #7. | Polar Stereographic (variant C) | 1 | 1 |
  552. | 98250 | 1 | EPSG | NULL | EPSG | Pseudo Plate Carree variant A | 1 | 1 |
  553. | 999999 | 1 | Oracle | NULL | Oracle | Unsupported Method | 0 | 0 |
  554. | 1000000000 | 1 | Oracle | NULL | Oracle | No-Op | 1 | 1 |
  555. | 1000000001 | 1 | Oracle | NULL | Oracle | Test-Op | 1 | 1 |
  556. +--------------------+------------+-------------+----------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------+---------------------------------------------------+------------------------+------------------------+
  557.  
  558.  
  559.  
  560.  
  561. Table: SDO_COORD_AXIS_NAMES
  562.  
  563. +--------------------+----------+
  564. | Column | Type |
  565. +--------------------+----------+
  566. | COORD_AXIS_NAME | VARCHAR2 |
  567. | COORD_AXIS_NAME_ID | NUMBER |
  568. +--------------------+----------+
  569.  
  570.  
  571. Table: SDO_COORD_AXIS_NAMES
  572.  
  573. +--------------------+------------------------+
  574. | COORD_AXIS_NAME_ID | COORD_AXIS_NAME |
  575. +--------------------+------------------------+
  576. | 9920 | Bin grid I |
  577. | 9921 | Bin grid J |
  578. | 9923 | Crossline |
  579. | 9906 | Easting |
  580. | 9903 | Ellipsoidal height |
  581. | 9913 | First local axis |
  582. | 9910 | Geocentric X |
  583. | 9911 | Geocentric Y |
  584. | 9912 | Geocentric Z |
  585. | 9928 | Geocentric radius |
  586. | 9901 | Geodetic latitude |
  587. | 9902 | Geodetic longitude |
  588. | 9905 | Gravity-related depth |
  589. | 9904 | Gravity-related height |
  590. | 9922 | Inline |
  591. | 9917 | Local depth |
  592. | 9916 | Local height |
  593. | 9907 | Northing |
  594. | 9918 | Plant East |
  595. | 9919 | Plant North |
  596. | 9924 | Platform East |
  597. | 9925 | Platform North |
  598. | 9914 | Second local axis |
  599. | 9909 | Southing |
  600. | 9926 | Spherical latitude |
  601. | 9927 | Spherical longitude |
  602. | 9915 | Third local axis |
  603. | 9908 | Westing |
  604. +--------------------+------------------------+
  605.  
  606.  
  607.  
  608. Table: SDO_COORD_OP_PARAMS
  609.  
  610. +--------------------+----------+
  611. | Column | Type |
  612. +--------------------+----------+
  613. | DATA_SOURCE | VARCHAR2 |
  614. | INFORMATION_SOURCE | VARCHAR2 |
  615. | PARAMETER_ID | NUMBER |
  616. | PARAMETER_NAME | VARCHAR2 |
  617. +--------------------+----------+
  618.  
  619.  
  620.  
  621.  
  622. Table: SDO_COORD_OP_PARAMS
  623.  
  624. +--------------+-------------+------------------------------------------------------------------+--------------------------------------------------+
  625. | PARAMETER_ID | DATA_SOURCE | PARAMETER_NAME | INFORMATION_SOURCE |
  626. +--------------+-------------+------------------------------------------------------------------+--------------------------------------------------+
  627. | 8695 | EPSG | Scaling factor for target CRS coord differences | EPSG guidance note number 7. |
  628. | 8696 | EPSG | Scaling factor for coord differences | EPSG guidance note number 7. |
  629. | 8697 | EPSG | Au5v2 | EPSG guidance note number 7. |
  630. | 8698 | EPSG | Au0v8 | EPSG guidance note number 7. |
  631. | 8699 | EPSG | Au9v0 | EPSG guidance note number 7. |
  632. | 8700 | EPSG | Au2v7 | EPSG guidance note number 7. |
  633. | 8701 | EPSG | Au1v9 | EPSG guidance note number 7. |
  634. | 8702 | EPSG | Au3v9 | EPSG guidance note number 7. |
  635. | 8703 | EPSG | Bu7v0 | EPSG guidance note number 7. |
  636. | 8704 | EPSG | Bu6v1 | EPSG guidance note number 7. |
  637. | 8705 | EPSG | Bu4v4 | EPSG guidance note number 7. |
  638. | 8706 | EPSG | Bu8v1 | EPSG guidance note number 7. |
  639. | 8707 | EPSG | Bu7v2 | EPSG guidance note number 7. |
  640. | 8708 | EPSG | Bu2v7 | EPSG guidance note number 7. |
  641. | 8709 | EPSG | Bu0v9 | EPSG guidance note number 7. |
  642. | 8710 | EPSG | Bu4v6 | EPSG guidance note number 7. |
  643. | 8711 | EPSG | Bu9v2 | EPSG guidance note number 7. |
  644. | 8712 | EPSG | Bu8v3 | EPSG guidance note number 7. |
  645. | 8713 | EPSG | Bu5v7 | EPSG guidance note number 7. |
  646. | 8714 | EPSG | Bu9v4 | EPSG guidance note number 7. |
  647. | 8715 | EPSG | Bu4v9 | EPSG guidance note number 7. |
  648. | 8716 | EPSG | Au1v0 | EPSG guidance note number 7. |
  649. | 8717 | EPSG | Au0v1 | EPSG guidance note number 7. |
  650. | 8718 | EPSG | Au2v0 | EPSG guidance note number 7. |
  651. | 8719 | EPSG | Au1v1 | EPSG guidance note number 7. |
  652. | 8720 | EPSG | Au0v2 | EPSG guidance note number 7. |
  653. | 8721 | EPSG | Au3v0 | EPSG guidance note number 7. |
  654. | 8722 | EPSG | Au2v1 | EPSG guidance note number 7. |
  655. | 8723 | EPSG | Au1v2 | EPSG guidance note number 7. |
  656. | 8724 | EPSG | Bu1v0 | EPSG guidance note number 7. |
  657. | 8725 | EPSG | Bu0v1 | EPSG guidance note number 7. |
  658. | 8726 | EPSG | Bu2v0 | EPSG guidance note number 7. |
  659. | 8832 | EPSG | Latitude of standard parallel | EPSG guidance note number 7. |
  660. | 8833 | EPSG | Longitude of origin | EPSG guidance note number 7. |
  661. | 1000000001 | Oracle | Test postfix | Oracle |
  662. | 8601 | EPSG | Latitude offset | EPSG guidance note number 7. |
  663. | 8602 | EPSG | Longitude offset | EPSG guidance note number 7. |
  664. | 8603 | EPSG | Vertical Offset | EPSG guidance note number 7. |
  665. | 8604 | EPSG | Geoid undulation | EPSG guidance note number 7. |
  666. | 8605 | EPSG | X-axis translation | EPSG guidance note number 7. |
  667. | 8606 | EPSG | Y-axis translation | EPSG guidance note number 7. |
  668. | 8607 | EPSG | Z-axis translation | EPSG guidance note number 7. |
  669. | 8608 | EPSG | X-axis rotation | EPSG guidance note number 7. |
  670. | 8609 | EPSG | Y-axis rotation | EPSG guidance note number 7. |
  671. | 8610 | EPSG | Z-axis rotation | EPSG guidance note number 7. |
  672. | 8611 | EPSG | Scale difference | EPSG guidance note number 7. |
  673. | 8612 | EPSG | Scale factor for source coordinate reference system first axis | EPSG guidance note number 7. |
  674. | 8613 | EPSG | Scale factor for source coordinate reference system second axis | EPSG guidance note number 7. |
  675. | 8614 | EPSG | Rotation angle of source coordinate reference system axes | EPSG guidance note number 7. |
  676. | 8615 | EPSG | Rotation angle of source coordinate reference system first axis | EPSG guidance note number 7. |
  677. | 8616 | EPSG | Rotation angle of source coordinate reference system second axis | EPSG guidance note number 7. |
  678. | 8617 | EPSG | Ordinate 1 of evaluation point | EPSG guidance note number 7. |
  679. | 8618 | EPSG | Ordinate 2 of evaluation point | EPSG guidance note number 7. |
  680. | 8619 | EPSG | Ordinate 1 of evaluation point in source CRS | EPSG guidance note number 7. |
  681. | 8620 | EPSG | Ordinate 2 of evaluation point in source CRS | EPSG guidance note number 7. |
  682. | 8621 | EPSG | Ordinate 1 of evaluation point in target CRS | EPSG guidance note number 7. |
  683. | 8622 | EPSG | Ordinate 2 of evaluation point in target CRS | EPSG guidance note number 7. |
  684. | 8623 | EPSG | A0 | EPSG guidance note number 7. |
  685. | 8624 | EPSG | A1 | EPSG guidance note number 7. |
  686. | 8625 | EPSG | A2 | EPSG guidance note number 7. |
  687. | 8626 | EPSG | A3 | EPSG guidance note number 7. |
  688. | 8627 | EPSG | A4 | EPSG guidance note number 7. |
  689. | 8628 | EPSG | A5 | EPSG guidance note number 7. |
  690. | 8629 | EPSG | A6 | EPSG guidance note number 7. |
  691. | 8630 | EPSG | A7 | EPSG guidance note number 7. |
  692. | 8631 | EPSG | A8 | EPSG guidance note number 7. |
  693. | 8632 | EPSG | Au0v3 | EPSG guidance note number 7. |
  694. | 8633 | EPSG | Au4v0 | EPSG guidance note number 7. |
  695. | 8634 | EPSG | Au3v1 | EPSG guidance note number 7. |
  696. | 8635 | EPSG | Au2v2 | EPSG guidance note number 7. |
  697. | 8636 | EPSG | Au1v3 | EPSG guidance note number 7. |
  698. | 8637 | EPSG | Au0v4 | EPSG guidance note number 7. |
  699. | 8638 | EPSG | B00 | EPSG guidance note number 7. |
  700. | 8639 | EPSG | B0 | EPSG guidance note number 7. |
  701. | 8640 | EPSG | B1 | EPSG guidance note number 7. |
  702. | 8641 | EPSG | B2 | EPSG guidance note number 7. |
  703. | 8642 | EPSG | B3 | EPSG guidance note number 7. |
  704. | 8643 | EPSG | Bu1v1 | EPSG guidance note number 7. |
  705. | 8644 | EPSG | Bu0v2 | EPSG guidance note number 7. |
  706. | 8645 | EPSG | Bu3v0 | EPSG guidance note number 7. |
  707. | 8646 | EPSG | Bu2v1 | EPSG guidance note number 7. |
  708. | 8647 | EPSG | Bu1v2 | EPSG guidance note number 7. |
  709. | 8648 | EPSG | Bu0v3 | EPSG guidance note number 7. |
  710. | 8649 | EPSG | Bu4v0 | EPSG guidance note number 7. |
  711. | 8650 | EPSG | Bu3v1 | EPSG guidance note number 7. |
  712. | 8651 | EPSG | Bu2v2 | EPSG guidance note number 7. |
  713. | 8652 | EPSG | Bu1v3 | EPSG guidance note number 7. |
  714. | 8653 | EPSG | Bu0v4 | EPSG guidance note number 7. |
  715. | 8654 | EPSG | Semi-major axis length difference | EPSG guidance note number 7. |
  716. | 8655 | EPSG | Flattening difference | EPSG guidance note number 7. |
  717. | 8656 | EPSG | Latitude and longitude difference file | EPSG guidance note number 7. |
  718. | 8657 | EPSG | Latitude difference file | EPSG guidance note number 7. |
  719. | 8658 | EPSG | Longitude difference file | EPSG guidance note number 7. |
  720. | 8659 | EPSG | Geod. tfm. code for northern boundary | EPSG guidance note number 7. |
  721. | 8660 | EPSG | Geod. tfm. code for southern boundary | EPSG guidance note number 7. |
  722. | 8661 | EPSG | Geod. tfm. name for northern boundary | EPSG guidance note number 7. |
  723. | 8662 | EPSG | Geod. tfm. name for southern boundary | EPSG guidance note number 7. |
  724. | 8663 | EPSG | Point scale factor | EPSG guidance note number 7 (June 2000 Revision) |
  725. | 8664 | EPSG | Easting and northing difference file | Ordnance Survey of Great Britain |
  726. | 8665 | EPSG | Maritime Province residual file | Survey of New Brunswick |
  727. +--------------+-------------+------------------------------------------------------------------+--------------------------------------------------+
  728.  
  729.  
  730.  
  731.  
  732. Table: SDO_COORD_OP_PARAMS
  733.  
  734. +--------------+-------------+-------------------------------------------------+------------------------------+
  735. | PARAMETER_ID | DATA_SOURCE | PARAMETER_NAME | INFORMATION_SOURCE |
  736. +--------------+-------------+-------------------------------------------------+------------------------------+
  737. | 8666 | EPSG | Geoid model file | EPSG |
  738. | 8667 | EPSG | Ordinate 3 of evaluation point | EPSG guidance note number 7. |
  739. | 8801 | EPSG | Latitude of natural origin | EPSG guidance note number 7. |
  740. | 8802 | EPSG | Longitude of natural origin | EPSG guidance note number 7. |
  741. | 8805 | EPSG | Scale factor at natural origin | EPSG guidance note number 7. |
  742. | 8806 | EPSG | False easting | EPSG guidance note number 7. |
  743. | 8807 | EPSG | False northing | EPSG guidance note number 7. |
  744. | 8811 | EPSG | Latitude of projection centre | EPSG guidance note number 7. |
  745. | 8812 | EPSG | Longitude of projection centre | EPSG guidance note number 7. |
  746. | 8813 | EPSG | Azimuth of initial line | EPSG guidance note number 7. |
  747. | 8814 | EPSG | Angle from Rectified to Skew Grid | EPSG guidance note number 7. |
  748. | 8815 | EPSG | Scale factor on initial line | EPSG guidance note number 7. |
  749. | 8816 | EPSG | Easting at projection centre | EPSG guidance note number 7. |
  750. | 8817 | EPSG | Northing at projection centre | EPSG guidance note number 7. |
  751. | 8818 | EPSG | Latitude of pseudo standard parallel | EPSG guidance note number 7 |
  752. | 8819 | EPSG | Scale factor on pseudo standard parallel | EPSG guidance note number 7. |
  753. | 8821 | EPSG | Latitude of false origin | EPSG guidance note number 7. |
  754. | 8822 | EPSG | Longitude of false origin | EPSG guidance note number 7. |
  755. | 8823 | EPSG | Latitude of 1st standard parallel | EPSG guidance note number 7. |
  756. | 8824 | EPSG | Latitude of 2nd standard parallel | EPSG guidance note number 7. |
  757. | 8826 | EPSG | Easting at false origin | EPSG guidance note number 7. |
  758. | 8827 | EPSG | Northing at false origin | EPSG guidance note number 7. |
  759. | 8828 | EPSG | Spherical latitude of origin | EPSG guidance note number 7. |
  760. | 8829 | EPSG | Spherical longitude of origin | EPSG guidance note number 7. |
  761. | 8830 | EPSG | Initial longitude | EPSG |
  762. | 8831 | EPSG | Zone width | EPSG |
  763. | 8668 | EPSG | Au5v0 | EPSG guidance note number 7. |
  764. | 8669 | EPSG | Au4v1 | EPSG guidance note number 7. |
  765. | 8670 | EPSG | Au3v2 | EPSG guidance note number 7. |
  766. | 8671 | EPSG | Au2v3 | EPSG guidance note number 7. |
  767. | 8672 | EPSG | Au1v4 | EPSG guidance note number 7. |
  768. | 8673 | EPSG | Au0v5 | EPSG guidance note number 7. |
  769. | 8674 | EPSG | Au6v0 | EPSG guidance note number 7. |
  770. | 8675 | EPSG | Au5v1 | EPSG guidance note number 7. |
  771. | 8676 | EPSG | Au4v2 | EPSG guidance note number 7. |
  772. | 8677 | EPSG | Au3v3 | EPSG guidance note number 7. |
  773. | 8678 | EPSG | Au2v4 | EPSG guidance note number 7. |
  774. | 8679 | EPSG | Au1v5 | EPSG guidance note number 7. |
  775. | 8680 | EPSG | Au0v6 | EPSG guidance note number 7. |
  776. | 8681 | EPSG | Bu5v0 | EPSG guidance note number 7. |
  777. | 8682 | EPSG | Bu4v1 | EPSG guidance note number 7. |
  778. | 8683 | EPSG | Bu3v2 | EPSG guidance note number 7. |
  779. | 8684 | EPSG | Bu2v3 | EPSG guidance note number 7. |
  780. | 8685 | EPSG | Bu1v4 | EPSG guidance note number 7. |
  781. | 8686 | EPSG | Bu0v5 | EPSG guidance note number 7. |
  782. | 8687 | EPSG | Bu6v0 | EPSG guidance note number 7. |
  783. | 8688 | EPSG | Bu5v1 | EPSG guidance note number 7. |
  784. | 8689 | EPSG | Bu4v2 | EPSG guidance note number 7. |
  785. | 8690 | EPSG | Bu3v3 | EPSG guidance note number 7. |
  786. | 8691 | EPSG | Bu2v4 | EPSG guidance note number 7. |
  787. | 8692 | EPSG | Bu1v5 | EPSG guidance note number 7. |
  788. | 8693 | EPSG | Bu0v6 | EPSG guidance note number 7. |
  789. | 8694 | EPSG | Scaling factor for source CRS coord differences | EPSG guidance note number 7. |
  790. +--------------+-------------+-------------------------------------------------+------------------------------+
  791.  
  792.  
  793.  
  794. Table: SDO_PREFERRED_OPS_USER
  795.  
  796. +-------------+----------+
  797. | Column | Type |
  798. +-------------+----------+
  799. | COORD_OP_ID | NUMBER |
  800. | SOURCE_SRID | NUMBER |
  801. | TARGET_SRID | NUMBER |
  802. | USE_CASE | VARCHAR2 |
  803. +-------------+----------+
  804.  
  805.  
  806.  
  807. Database:SYS
  808.  
  809. +--------------------------+
  810. | AUDIT_ACTIONS |
  811. | AW$AWCREATE |
  812. | AW$AWCREATE10G |
  813. | AW$AWMD |
  814. | AW$AWREPORT |
  815. | AW$AWXML |
  816. | AW$EXPRESS |
  817. | DUAL |
  818. | IMPDP_STATS |
  819. | KU$NOEXP_TAB |
  820. | KU$_LIST_FILTER_TEMP |
  821. | ODCI_SECOBJ$ |
  822. | ODCI_WARNINGS$ |
  823. | OLAPTABLEVELS |
  824. | OLAPTABLEVELTUPLES |
  825. | OLAP_OLEDB_FUNCTIONS_PVT |
  826. | OLAP_OLEDB_KEYWORDS |
  827. | OLAP_OLEDB_MDPROPS |
  828. | OLAP_OLEDB_MDPROPVALS |
  829. | PLAN_TABLE$ |
  830. | PSTUBTBL |
  831. | STMT_AUDIT_OPTION_MAP |
  832. | SYSTEM_PRIVILEGE_MAP |
  833. | TABLE_PRIVILEGE_MAP |
  834. | WRI$_ADV_ASA_RECO_DATA |
  835. +--------------------------+
  836.  
  837.  
  838.  
  839. Table: SYSTEM_PRIVILEGE_MAP
  840.  
  841. +-----------+----------+
  842. | Column | Type |
  843. +-----------+----------+
  844. | NAME | VARCHAR2 |
  845. | PRIVILEGE | NUMBER |
  846. | PROPERTY | NUMBER |
  847. +-----------+----------+
  848.  
  849.  
  850.  
  851. Table: SYSTEM_PRIVILEGE_MAP
  852.  
  853. +--------------------------------+----------+-----------+
  854. | NAME | PROPERTY | PRIVILEGE |
  855. +--------------------------------+----------+-----------+
  856. | ALTER SYSTEM | 0 | -3 |
  857. | AUDIT SYSTEM | 0 | -4 |
  858. | CREATE SESSION | 0 | -5 |
  859. | ALTER SESSION | 0 | -6 |
  860. | RESTRICTED SESSION | 0 | -7 |
  861. | CREATE TABLESPACE | 0 | -10 |
  862. | ALTER TABLESPACE | 0 | -11 |
  863. | MANAGE TABLESPACE | 0 | -12 |
  864. | DROP TABLESPACE | 0 | -13 |
  865. | UNLIMITED TABLESPACE | 0 | -15 |
  866. | CREATE USER | 0 | -20 |
  867. | BECOME USER | 0 | -21 |
  868. | ALTER USER | 0 | -22 |
  869. | DROP USER | 0 | -23 |
  870. | CREATE ROLLBACK SEGMENT | 0 | -30 |
  871. | ALTER ROLLBACK SEGMENT | 0 | -31 |
  872. | DROP ROLLBACK SEGMENT | 0 | -32 |
  873. | CREATE TABLE | 0 | -40 |
  874. | CREATE ANY TABLE | 0 | -41 |
  875. | ALTER ANY TABLE | 0 | -42 |
  876. | BACKUP ANY TABLE | 0 | -43 |
  877. | DROP ANY TABLE | 0 | -44 |
  878. | LOCK ANY TABLE | 0 | -45 |
  879. | COMMENT ANY TABLE | 0 | -46 |
  880. | SELECT ANY TABLE | 0 | -47 |
  881. | INSERT ANY TABLE | 0 | -48 |
  882. | UPDATE ANY TABLE | 0 | -49 |
  883. | DELETE ANY TABLE | 0 | -50 |
  884. | CREATE CLUSTER | 0 | -60 |
  885. | CREATE ANY CLUSTER | 0 | -61 |
  886. | ALTER ANY CLUSTER | 0 | -62 |
  887. | DROP ANY CLUSTER | 0 | -63 |
  888. | CREATE ANY INDEX | 0 | -71 |
  889. | ALTER ANY INDEX | 0 | -72 |
  890. | DROP ANY INDEX | 0 | -73 |
  891. | CREATE SYNONYM | 0 | -80 |
  892. | CREATE ANY SYNONYM | 0 | -81 |
  893. | DROP ANY SYNONYM | 0 | -82 |
  894. | SYSDBA | 0 | -83 |
  895. | SYSOPER | 0 | -84 |
  896. | CREATE PUBLIC SYNONYM | 0 | -85 |
  897. | DROP PUBLIC SYNONYM | 0 | -86 |
  898. | CREATE VIEW | 0 | -90 |
  899. | CREATE ANY VIEW | 0 | -91 |
  900. | DROP ANY VIEW | 0 | -92 |
  901. | CREATE SEQUENCE | 0 | -105 |
  902. | CREATE ANY SEQUENCE | 0 | -106 |
  903. | ALTER ANY SEQUENCE | 0 | -107 |
  904. | DROP ANY SEQUENCE | 0 | -108 |
  905. | SELECT ANY SEQUENCE | 0 | -109 |
  906. | CREATE DATABASE LINK | 0 | -115 |
  907. | CREATE PUBLIC DATABASE LINK | 0 | -120 |
  908. | DROP PUBLIC DATABASE LINK | 0 | -121 |
  909. | CREATE ROLE | 0 | -125 |
  910. | DROP ANY ROLE | 0 | -126 |
  911. | GRANT ANY ROLE | 0 | -127 |
  912. | ALTER ANY ROLE | 0 | -128 |
  913. | AUDIT ANY | 0 | -130 |
  914. | ALTER DATABASE | 0 | -135 |
  915. | FORCE TRANSACTION | 0 | -138 |
  916. | FORCE ANY TRANSACTION | 0 | -139 |
  917. | CREATE PROCEDURE | 0 | -140 |
  918. | CREATE ANY PROCEDURE | 0 | -141 |
  919. | ALTER ANY PROCEDURE | 0 | -142 |
  920. | DROP ANY PROCEDURE | 0 | -143 |
  921. | EXECUTE ANY PROCEDURE | 0 | -144 |
  922. | CREATE TRIGGER | 0 | -151 |
  923. | CREATE ANY TRIGGER | 0 | -152 |
  924. | ALTER ANY TRIGGER | 0 | -153 |
  925. | DROP ANY TRIGGER | 0 | -154 |
  926. | CREATE PROFILE | 0 | -160 |
  927. | ALTER PROFILE | 0 | -161 |
  928. | DROP PROFILE | 0 | -162 |
  929. | ALTER RESOURCE COST | 0 | -163 |
  930. | ANALYZE ANY | 0 | -165 |
  931. | GRANT ANY PRIVILEGE | 0 | -167 |
  932. | CREATE MATERIALIZED VIEW | 0 | -172 |
  933. | CREATE ANY MATERIALIZED VIEW | 0 | -173 |
  934. | ALTER ANY MATERIALIZED VIEW | 0 | -174 |
  935. | DROP ANY MATERIALIZED VIEW | 0 | -175 |
  936. | CREATE ANY DIRECTORY | 0 | -177 |
  937. | DROP ANY DIRECTORY | 0 | -178 |
  938. | CREATE TYPE | 0 | -180 |
  939. | CREATE ANY TYPE | 0 | -181 |
  940. | ALTER ANY TYPE | 0 | -182 |
  941. | DROP ANY TYPE | 0 | -183 |
  942. | EXECUTE ANY TYPE | 0 | -184 |
  943. | UNDER ANY TYPE | 0 | -186 |
  944. | CREATE LIBRARY | 0 | -188 |
  945. | CREATE ANY LIBRARY | 0 | -189 |
  946. | ALTER ANY LIBRARY | 0 | -190 |
  947. | DROP ANY LIBRARY | 0 | -191 |
  948. | EXECUTE ANY LIBRARY | 0 | -192 |
  949. | CREATE OPERATOR | 0 | -200 |
  950. | CREATE ANY OPERATOR | 0 | -201 |
  951. | ALTER ANY OPERATOR | 0 | -202 |
  952. | DROP ANY OPERATOR | 0 | -203 |
  953. | EXECUTE ANY OPERATOR | 0 | -204 |
  954. | CREATE INDEXTYPE | 0 | -205 |
  955. | CREATE ANY INDEXTYPE | 0 | -206 |
  956. | ALTER ANY INDEXTYPE | 0 | -207 |
  957. | DROP ANY INDEXTYPE | 0 | -208 |
  958. | UNDER ANY VIEW | 0 | -209 |
  959. | QUERY REWRITE | 0 | -210 |
  960. | GLOBAL QUERY REWRITE | 0 | -211 |
  961. | EXECUTE ANY INDEXTYPE | 0 | -212 |
  962. | UNDER ANY TABLE | 0 | -213 |
  963. | CREATE DIMENSION | 0 | -214 |
  964. | CREATE ANY DIMENSION | 0 | -215 |
  965. | ALTER ANY DIMENSION | 0 | -216 |
  966. | DROP ANY DIMENSION | 0 | -217 |
  967. | MANAGE ANY QUEUE | 1 | -218 |
  968. | ENQUEUE ANY QUEUE | 1 | -219 |
  969. | DEQUEUE ANY QUEUE | 1 | -220 |
  970. | CREATE ANY CONTEXT | 0 | -222 |
  971. | DROP ANY CONTEXT | 0 | -223 |
  972. | CREATE ANY OUTLINE | 0 | -224 |
  973. | ALTER ANY OUTLINE | 0 | -225 |
  974. | DROP ANY OUTLINE | 0 | -226 |
  975. | ADMINISTER RESOURCE MANAGER | 1 | -227 |
  976. | ADMINISTER DATABASE TRIGGER | 0 | -228 |
  977. | MERGE ANY VIEW | 0 | -233 |
  978. | ON COMMIT REFRESH | 0 | -234 |
  979. | EXEMPT ACCESS POLICY | 0 | -235 |
  980. | RESUMABLE | 0 | -236 |
  981. | SELECT ANY DICTIONARY | 0 | -237 |
  982. | DEBUG CONNECT SESSION | 0 | -238 |
  983. | DEBUG ANY PROCEDURE | 0 | -241 |
  984. | FLASHBACK ANY TABLE | 0 | -243 |
  985. | GRANT ANY OBJECT PRIVILEGE | 0 | -244 |
  986. | CREATE EVALUATION CONTEXT | 1 | -245 |
  987. | CREATE ANY EVALUATION CONTEXT | 1 | -246 |
  988. | ALTER ANY EVALUATION CONTEXT | 1 | -247 |
  989. | DROP ANY EVALUATION CONTEXT | 1 | -248 |
  990. | EXECUTE ANY EVALUATION CONTEXT | 1 | -249 |
  991. | CREATE RULE SET | 1 | -250 |
  992. | CREATE ANY RULE SET | 1 | -251 |
  993. | ALTER ANY RULE SET | 1 | -252 |
  994. | DROP ANY RULE SET | 1 | -253 |
  995. | EXECUTE ANY RULE SET | 1 | -254 |
  996. | EXPORT FULL DATABASE | 0 | -255 |
  997. | IMPORT FULL DATABASE | 0 | -256 |
  998. | CREATE RULE | 1 | -257 |
  999. | CREATE ANY RULE | 1 | -258 |
  1000. | ALTER ANY RULE | 1 | -259 |
  1001. | DROP ANY RULE | 1 | -260 |
  1002. | EXECUTE ANY RULE | 1 | -261 |
  1003. | ANALYZE ANY DICTIONARY | 0 | -262 |
  1004. | ADVISOR | 0 | -263 |
  1005. | CREATE JOB | 0 | -264 |
  1006. | CREATE ANY JOB | 0 | -265 |
  1007. | EXECUTE ANY PROGRAM | 0 | -266 |
  1008. | EXECUTE ANY CLASS | 0 | -267 |
  1009. | MANAGE SCHEDULER | 0 | -268 |
  1010. | SELECT ANY TRANSACTION | 0 | -269 |
  1011. | DROP ANY SQL PROFILE | 0 | -270 |
  1012. | ALTER ANY SQL PROFILE | 0 | -271 |
  1013. | ADMINISTER SQL TUNING SET | 0 | -272 |
  1014. | ADMINISTER ANY SQL TUNING SET | 0 | -273 |
  1015. | CREATE ANY SQL PROFILE | 0 | -274 |
  1016. | EXEMPT IDENTITY POLICY | 0 | -275 |
  1017. | MANAGE FILE GROUP | 1 | -276 |
  1018. | MANAGE ANY FILE GROUP | 1 | -277 |
  1019. | READ ANY FILE GROUP | 1 | -278 |
  1020. | CHANGE NOTIFICATION | 0 | -279 |
  1021. | CREATE EXTERNAL JOB | 0 | -280 |
  1022. +--------------------------------+----------+-----------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement