delete from mdsys.OpenLS_Namespaces;
INSERT INTO mdsys.OpenLS_Namespaces(
shortcut,
version,
uri)
VALUES (
'xls',
'1.0',
'http://www.opengis.net/xls');
INSERT INTO mdsys.OpenLS_Namespaces(
shortcut,
version,
uri)
VALUES (
'gml',
'1.0',
'http://www.opengis.net/gml');
INSERT INTO mdsys.OpenLS_Namespaces(
shortcut,
version,
uri) (
SELECT
shortcut,
'1.1',
uri
FROM
mdsys.OpenLS_Namespaces
WHERE
version = '1.0');
delete from mdsys.OpenLS_Classifications;
INSERT INTO mdsys.OpenLS_Classifications (
criterion,
classification,
version,
characteristic_XPath)
VALUES (
'address format',
'by street address',
'1.0',
'/xls:Address/xls:StreetAddress');
INSERT INTO mdsys.OpenLS_Classifications (
criterion,
classification,
version,
characteristic_XPath)
VALUES (
'address format',
'by street intersection',
'1.0',
'/xls:Address/xls:StreetIntersection');
INSERT INTO mdsys.OpenLS_Classifications (
criterion,
classification,
version,
characteristic_XPath)
VALUES (
'location type',
'street address',
'1.0',
'/*/xls:Address/xls:StreetAddress');
INSERT INTO mdsys.OpenLS_Classifications (
criterion,
classification,
version,
characteristic_XPath)
VALUES (
'location type',
'street intersection address',
'1.0',
'/*/xls:Address/xls:StreetIntersection');
INSERT INTO mdsys.OpenLS_Classifications (
criterion,
classification,
version,
characteristic_XPath)
VALUES (
'location type',
'position point',
'1.0',
'/*/xls:Position/gml:Point');
INSERT INTO mdsys.OpenLS_Classifications (
criterion,
classification,
version,
characteristic_XPath)
VALUES (
'location type',
'POI point',
'1.0',
'/*/xls:POI/gml:Point');
INSERT INTO mdsys.OpenLS_Classifications (
criterion,
classification,
version,
characteristic_XPath)
VALUES (
'location type',
'POI street address',
'1.0',
'/*/xls:POI/xls:Address/xls:StreetAddress');
INSERT INTO mdsys.OpenLS_Classifications (
criterion,
classification,
version,
characteristic_XPath)
VALUES (
'location type',
'POI street intersection address',
'1.0',
'/*/xls:POI/xls:Address/xls:StreetIntersection');
INSERT INTO mdsys.OpenLS_Classifications (
criterion,
classification,
version,
characteristic_XPath)
VALUES (
'map bounding box definition',
'by bounding box',
'1.0',
'/*/xls:BBoxContext');
INSERT INTO mdsys.OpenLS_Classifications (
criterion,
classification,
version,
characteristic_XPath)
VALUES (
'map bounding box definition',
'by center and radius',
'1.0',
'/*/xls:CenterContext/xls:Radius');
INSERT INTO mdsys.OpenLS_Classifications (
criterion,
classification,
version,
characteristic_XPath)
VALUES (
'map bounding box definition',
'by center and scale',
'1.0',
'/*/xls:CenterContext/xls:DisplayScale');
INSERT INTO mdsys.OpenLS_Classifications (
criterion,
classification,
version,
characteristic_XPath) (
SELECT
criterion,
classification,
'1.1',
characteristic_XPath
FROM
mdsys.OpenLS_Classifications
WHERE
version = '1.0');
delete from mdsys.OpenLS_Nodes;
INSERT INTO mdsys.OpenLS_Nodes (
name,
version,
OpenLS)
VALUES (
'map response',
'1.0',
XMLTYPE('
place holder
place holder
place holder
'));
INSERT INTO mdsys.OpenLS_Nodes (
name,
version,
OpenLS)
VALUES (
'route response',
'1.0',
XMLTYPE('
place holder
place holder
place holder
place holder
place holder
place holder
place holder
place holder
place holder
place holder
place holder
place holder
place holder
'));
INSERT INTO mdsys.OpenLS_Nodes (
name,
version,
OpenLS)
VALUES (
'geocode request',
'1.0',
XMLTYPE('
Post Street
CA
San Francisco
94102
'));
INSERT INTO mdsys.OpenLS_Nodes (
name,
version,
OpenLS)
VALUES (
'geocode response',
'1.0',
XMLTYPE('
-122.4083257 37.788208
POST ST
CA
SAN FRANCISCO
94102
'));
INSERT INTO mdsys.OpenLS_Nodes (
name,
version,
OpenLS)
VALUES (
'yp response',
'1.0',
XMLTYPE('
place holder
place holder
place holder
place holder
place holder
place holder
place holder
place holder
place holder
place holder
place holder
place holder
place holder
place holder
place holder
'));
INSERT INTO mdsys.OpenLS_Nodes (
name,
version,
OpenLS)
VALUES (
'OpenLS error',
'1.0',
XMLTYPE('
'));
INSERT INTO mdsys.OpenLS_Nodes (
name,
version,
OpenLS)
VALUES (
'Unknown OpenLS error',
'1.0',
XMLTYPE('
'));
INSERT INTO mdsys.OpenLS_Nodes (
name,
version,
OpenLS) (
SELECT
name,
'1.1',
OpenLS
FROM
mdsys.OpenLS_Nodes
WHERE
version = '1.0');
INSERT INTO mdsys.OpenLS_Nodes (
name,
version,
OpenLS)
VALUES (
'Oracle Mapviewer request',
'1.0',
XMLTYPE('
place holder
-122.2615 37.5266
'));
INSERT INTO mdsys.OpenLS_Nodes (
name,
version,
OpenLS)
VALUES (
'Oracle Mapviewer mbr',
'1.0',
XMLTYPE('
-122.260443,37.531621 -120.345,39.543
'));
INSERT INTO mdsys.OpenLS_Nodes (
name,
version,
OpenLS)
VALUES (
'Oracle router request',
'1.0',
XMLTYPE('
'));
COMMIT;
CREATE OR REPLACE PACKAGE BODY MDSYS.sdo_ols wrapped
a000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
b
2696 d8f
f3xORYJn0hGFqZv5jfMCMvRO/Y4wg5Wr3iAFV58k+Oov+2/Cyc/bzeBKVz5g931UTVbeoibw
H0Q2eMz9u4OnscAbsnx1mrzQjmzxe354kDGUgzZmmpXGv9W8OLwqSHxFM9itl7nrV0wBhcqQ
y+a3hSqEBcezsp9ScEZX1DWPREy05oVOLR7IzqTL50Q1u1/dbquvChwFkDjmFj0GzL8d5PZG
oRG6jUztt51bV1/hH1X/bri5C5G33DVJ3dv+caxt7X+KcYb9BQEvNtq0dK24XbrKZd0yDH7g
Qi3ByK+yy2Sy4LZFJukTqiAlsLKbYfrUqBYxzSWQPApurruNoqDunFyfUh4vM9pawnlF+vHe
wlOun369Xp7/ZQVtxO6WHhTZb0+2ykdcx1+PpZxMm0/GFAUFb8qNq9pKM7rC2acp6J9Gh7er
cSU7diGdHQWy7UrlwDN7vTSID8Rmaoi/eyUQlMjSCUv2XEfJ5A0bPcmCsFRtS/TPnNbfUjvH
p/VxBFvEnvrLviGSPgeBANOnQAREy0ng6nJ9/cfGgtjPbU/BFE/jbi9YSr9iaK9FQfe0beYk
nlulJJ9+H78NP2qMr/Ora74hd1kWzb9A6z0FcLo+DOGHcajRgj1bbD7RpolmifiwfEhG/2xC
7qiRc5nyOs1O/eIPmFeLJv7cf8Wc3Jzb8NoIIXRzBFnICbJOsfs0Sgqm2+qm4yS5hRtqhRVe
VMsQdCxxr2Y4DjaLuR7qJPmljIemWOuFEAyKqosIVfDJsVcOsfjQTk7HKmaCAB06N4hwuEov
cs+WfKxC6lpQhDgv7kGmbC/K3hSrCo5N0MURQ8vkB2qrPPjdyy3/CwlCSKxqtLBKLuaKQC0p
vkhZZixd55iJxzfKJpRKCVEDA9tomph33Pdglm8GCmD7QIyvQjjvnnI+WkbW4sqZ58lFMUkT
ECTPGSXDDmJhBT2bSC0HMADkJaojI/yq8r8e+YZIjX65Jfhd+Qo+2vqLTvn7Edq07b2wTM3Z
I5ROWcBjKX344NYFbj/F1t7szSaFHsHO0VV5W78pkpHu5PXGuKqssEDbSGJAWaTlWuWPrSXb
mcgukJEhBN1VvsnEuq3LdmlUFyzw0jg65e/GTuRRe1cVQaKxjzZEMRz8g3P3+ZDKcwCrgTaw
5m0hjmkbhtw9KAG3rFNvH74J4KMEUaUcFAzYU8I4Q6gM4LO2vBOYwyniwurWdgZD/pr3PLM2
VCnMWT6tbgbAcTFsREzgo8Jejcr0sv2ywRu83TQqLa6EFz6z+D6fXOEZFMljJ+fabLQpWXCY
K6ClhlKpGHRZ4ShTRGaGKzAfgXd3uGJbxjR1TYkEdKXqWysX7fxRKZNUTJFrAmwv2xCmzV4a
s/2MQkaHdpKgVOLx+DfoFGvkyidj6Qp6YFVskZ44cl8VJ+lB2XFvTnkqKy1WnCwDQnZEYYnV
EW9QE57Hou4RAZOPUCfT11ZlSR3iIbGpm7R4WVlNBh1f8jdkkSk1s00vM/KUh/o8rSzMUTcb
o41OZpSgd1ghMHnCCoKfOK0osuXSwhuWGHm00Xz/L2q+pksf7hCHZMN6VFfjsKRpmaJq3XyE
TTRmbvZbGBPkSTs/wBO+gfC4oy3vnG4nezQWfoqGoq/nBR3RWZwIHvuZuZczRsYbyr3p44Z9
R3+ZQPUBR8sRrsOcFzjLFoT6IqnApom2wPIhIYQWA1X9K/UzjmlNHIq4HLp1RfYp9cLlq43O
SSm7cBLHZ67xXyrrlhOPbnh2ba1wC3IZPLtPaE92u7THb7JzSQ7qmK4qJ6ldrRyZq3ZGpEPy
e2+isrxc8KRSiHr8JjXAt+YP5WYX1Lput2uvxE2OQ+iBVC5yr8D995RcxdAkZi4IoEM6x0JM
YW3xkblgNPY4CiNC/xVy24ieOkT7TN7bV/wtFRw2EqE4clCjmfjfoDmOcjKLdoxmlktpU5QU
YMGV64wNVU2IBQjnp1AK5vr4Iwtr+1oC6Sqr3BN583Kl/XkeGq03wMTlApS6ga+rUzjXVWu2
XRczy4qNd4MGmCUM9pyYFBJxzfNy7Cj4czPgV0afEci5b78KRt/9an6ZECXgKs+X/xlxGUlP
QCDRB60ZEzQ2BrV3sOXeofB57D++pwJF7I1m6EE9TGv9NdZFbG3A6RAmkQHcO+oTHcInzBwd
5aIwMt1FPOxwmtQJHFTffw3ZiAv/sSHd5hjpvmjJJUP6bj7oVsGX2quQ6gaJIosN7fLJ0nmR
S4RLcafZkRoj7XyRvkax0TUkLm/tAssQWLLfvRMoTz4BJMUY3X4mygDtOa7Oes8yPyKr4YLA
/sjYH3NDGwWW37+h8GBhNIUE47eLagKE08pOBmr4Xe+hn51iu/FHmmO18rkzLMBEcwj8HXYL
pWyYZGXuM5X2/yUn3hfAM+jhEpNY8cS5jCVGV0w47F+lNeIRTlP5dYo0rkQqaeRNG5m41VvS
ge3gxDgda1b7M9lzTj2I1q32NgbW+QqCuW/6EKgh/Px9f09JeIzCqANYGZldv62Lflg7H/iY
BwM4at5AO8a+dm/sab/RB7iwICG+OB+GmfyJgNo4DR2n4QW136l3kuKEgj+tUzNKxEOBvapi
hKBsL/NcvCICR7hXgVYr4qet4NL8SRDP5qwIy4r5D7ZZPgS4oI0iTHu5xKED3DMoKe2YVEkP
t882EmwgaBQ+kLzABqPWCt8UlFhJd6zJjnvW71hggbysEmdqWad2LwZkXT+3iilTn8QwQWJh
i+CYzlNxYv7ZFNVErdSk/NXh7cI17QbjdCq5rDITm7XyuSvCrp8eQxu9JcZzbSEsMMzjrgnP
Hf5Dy9MgRRJIDZgLaGLaqUiDmYvGbFdpXXbPjrlRqRcmHgeoLsVJ9yawbs/tbycMCD1w9jXG
iEd+H8boC2fqrS0un4abFmT0ZGWpzMwLt59YNWosgsOALE0zF7KAyUzJji+WTaXv4GBRWTXl
wPSgot7mZzaIqJZYfxNOpS7eZQlY8MN1nm3VwRRnU3o6XJgJ29JdUOQa0aqBtKooNP6Bp7gJ
6675YsM9ddKt20H1TJaKxYTfUpPtbwHL7PUWqRO1ZlFulvw9+qqt2cxCFmSbF/N79NiqZvdb
p2j7g4oTQjcsMBthUabvmufnqTCHcJW8OE4nB+22M3++4PrEAvFRyKph17HBDTJMVMF+HMcY
spS9+HW7LrRHQYzlH9VLqK9qTL7bNwbYE2SBff5JzjcY4KDheXJFQ54HyLSzJxVjDynyBFh3
eaGsqtm3DmAAWMtzWYX3i1vINkDRIr7D0Q7AJDsPRuPQLiMmOqNx+b6JI0yUFnu/p7xTwXxv
QQT3tiu99FDDkATBszjJ+xXKfH4vqslSs6CIOzQqWkmlCiQjAJI6wYeZHTMpS5q7v0eVCzkA
/8bBmTOXksKL643y9lCeffC5paLf+QWq++4BZKk=
/
show errors;
GRANT EXECUTE ON MDSYS.sdo_ols TO PUBLIC;