tag:blogger.com,1999:blog-373683552024-03-19T09:48:44.011+01:00Oracle Maps (SPATIAL/Mapviewer)Hier findest Du Infos zu Oracle Maps und Oracle Spatial/Mapviewer Themen.
Viel Spaß damit. Here you will find interesting things about Oracle Maps and Mapviewer I came across. Have fun !B. Fischer-Waselshttp://www.blogger.com/profile/02019839104452667248noreply@blogger.comBlogger103125tag:blogger.com,1999:blog-37368355.post-4494304487318064082021-09-09T09:00:00.000+02:002021-09-09T09:00:08.943+02:00Oracle Support HOT Topics (September 2021)<p>Es gibt 2 neue Artikel im <i>Knowledge</i> Bereich von MyOracleSupport (MOS), auf die ich hier hinweisen möchte:</p><ol style="text-align: left;"><li><span style="color: black; font-family: "Arial",sans-serif; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;"><span style="color: black; font-family: "Arial",sans-serif; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;"><!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>DE</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>AR-SA</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false"
DefSemiHidden="false" DefQFormat="false" DefPriority="99"
LatentStyleCount="376">
<w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 9"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="header"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footer"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index heading"/>
<w:LsdException Locked="false" Priority="35" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of figures"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope return"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="line number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="page number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of authorities"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="macro"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="toa heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 5"/>
<w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Closing"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Signature"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="true"
UnhideWhenUsed="true" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Message Header"/>
<w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Salutation"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Date"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Note Heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Block Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Hyperlink"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="FollowedHyperlink"/>
<w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Document Map"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Plain Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="E-mail Signature"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Top of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Bottom of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal (Web)"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Acronym"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Cite"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Code"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Definition"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Keyboard"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Preformatted"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Sample"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Typewriter"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Variable"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Table"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation subject"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="No List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Contemporary"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Elegant"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Professional"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Balloon Text"/>
<w:LsdException Locked="false" Priority="39" Name="Table Grid"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Theme"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" QFormat="true"
Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" QFormat="true"
Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" QFormat="true"
Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" QFormat="true"
Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" QFormat="true"
Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" QFormat="true"
Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" SemiHidden="true"
UnhideWhenUsed="true" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/>
<w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/>
<w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/>
<w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/>
<w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/>
<w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/>
<w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/>
<w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Mention"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Smart Hyperlink"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Hashtag"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Unresolved Mention"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Smart Link"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:Arial;
mso-bidi-theme-font:minor-bidi;}
</style>
<![endif]--></span><span style="color: black; font-family: "Arial",sans-serif; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;"><a href="https://mosemp.us.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?id=2799479.1">Spatial
Is INVALID After Upgrade To 19c</a></span> (Symptome sind: Invalide Spatial Komponente und Java Klassen nach dem Upgrade)<br /></span></li><li><span style="color: black; font-family: "Arial",sans-serif; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;"><span style="color: black; font-family: "Arial",sans-serif; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;"><!--[if gte mso 9]><xml>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>DE</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>AR-SA</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false"
DefSemiHidden="false" DefQFormat="false" DefPriority="99"
LatentStyleCount="376">
<w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 9"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="header"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footer"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index heading"/>
<w:LsdException Locked="false" Priority="35" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of figures"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope return"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="line number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="page number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of authorities"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="macro"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="toa heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 5"/>
<w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Closing"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Signature"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="true"
UnhideWhenUsed="true" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Message Header"/>
<w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Salutation"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Date"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Note Heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Block Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Hyperlink"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="FollowedHyperlink"/>
<w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Document Map"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Plain Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="E-mail Signature"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Top of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Bottom of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal (Web)"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Acronym"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Cite"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Code"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Definition"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Keyboard"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Preformatted"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Sample"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Typewriter"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Variable"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Table"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation subject"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="No List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Contemporary"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Elegant"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Professional"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Balloon Text"/>
<w:LsdException Locked="false" Priority="39" Name="Table Grid"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Theme"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" QFormat="true"
Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" QFormat="true"
Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" QFormat="true"
Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" QFormat="true"
Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" QFormat="true"
Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" QFormat="true"
Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" SemiHidden="true"
UnhideWhenUsed="true" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/>
<w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/>
<w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/>
<w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/>
<w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/>
<w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/>
<w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/>
<w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Mention"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Smart Hyperlink"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Hashtag"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Unresolved Mention"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Smart Link"/>
</w:LatentStyles>
</xml><![endif]--><!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:Arial;
mso-bidi-theme-font:minor-bidi;}
</style>
<![endif]--></span><span style="color: black; font-family: "Arial",sans-serif; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;"><a href="https://mosemp.us.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?id=2798006.1">Sporadic
Cases of SDO_GEOMETRY Values Being Different After Insert As Select In Sender
And Receiver Table </a></span></span></li></ol><span style="color: black; font-family: "Arial",sans-serif; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;"><span style="color: black; font-family: "Arial",sans-serif; font-size: 10.0pt; mso-ansi-language: EN-US; mso-bidi-language: AR-SA; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin;"> Bitte schaut immer mal wieder nach aktuellen Informationen im Support Forum oder abonniert diese direkt.<br /></span></span>Karin Patengehttp://www.blogger.com/profile/07393355977167541886noreply@blogger.com0tag:blogger.com,1999:blog-37368355.post-8538011802816855392021-08-16T10:00:00.004+02:002021-08-16T10:00:45.022+02:00Oracle Spatial Studio<p>Hi again - long time no action hear... sorry for that. My focus has been more on APEX...</p><p>By coincidence I came across the <a href="https://www.oracle.com/database/technologies/spatial-studio/get-started.html" target="_blank">SPATIAL STUDIO</a>, which might be of interest to Oracle Maps users/developers. Worth mentioning - Try it out !!!</p><p>Concerning Spatial Studio Carsten Czarski also posted an interesting <a href="https://datavizmark.com/apex-21-1-maps-nearest-neighbours/" target="_blank">"Nearest Neighbour" search here</a>.</p><p>In combination with Oracle APEX Colin Archer posted this interesting blog-post after the APEX-Team had invested quite a lot on maps in APEX called "<a href="https://content.dsp.co.uk/apex/native-maps-in-apex-21.1" target="_blank">NATIVE MAPS</a>".<br />NATIVE MAPS <span style="font-family: Roboto;"><span style="color: #333333;"><span style="font-size: 1.125rem;">Contents:</span><span style="font-size: 18px;"><br /></span></span></span><a class="toc-link node-name--H3 is-active-link" href="https://content.dsp.co.uk/apex/native-maps-in-apex-21.1#adding_a_new_map_page_via_the_wizard" style="--base-100: #c1bccb; --base-200: #a39ead; --base-300: #85808f; --base-400: #676271; --base-500: #494453; --base-50: #d0cbda; --base-600: #2b2635; --base-700: #0d0817; --base-800: #000; --base-900: #000; --base: #494453; --danger-100: #fff; --danger-200: #fff; --danger-300: #fff; --danger-400: #fff; --danger-500: #fafafa; --danger-50: #fff; --danger-600: #dcdcdc; --danger-700: #bebebe; --danger-800: #a0a0a0; --danger-900: #828282; --danger: #fafafa; --dark-100: #96919f; --dark-200: #787381; --dark-300: #5a5563; --dark-400: #3c3745; --dark-500: #1e1927; --dark-50: #a5a0ae; --dark-600: #000009; --dark-700: #000; --dark-800: #000; --dark-900: #000; --dark: #1e1927; --gray-100: #f3f4f6; --gray-200: #e5e7eb; --gray-300: #d1d5db; --gray-400: #9ca3af; --gray-500: #6b7280; --gray-50: #f9fafb; --gray-600: #4b5563; --gray-700: #374151; --gray-800: #1f2937; --gray-900: #111827; --gray: #6b7280; --h1_color: #333; --h2_color: #333; --h3_color: #333; --h4_color: #333; --h5_color: #333; --h6_color: #494453; --primary-100: #848bc2; --primary-200: #666da4; --primary-300: #484f86; --primary-400: #2a3168; --primary-500: #0c134a; --primary-50: #939ad1; --primary-600: #00002c; --primary-700: #00000e; --primary-800: #000; --primary-900: #000; --primary: #0c134a; --secondary-100: #dff; --secondary-200: #bfe6ff; --secondary-300: #a1c8e7; --secondary-400: #83aac9; --secondary-500: #658cab; --secondary-50: #ecffff; --secondary-600: #476e8d; --secondary-700: #29506f; --secondary-800: #0b3251; --secondary-900: #001433; --secondary: #658cab; --success-100: #d89cfa; --success-200: #ba7edc; --success-300: #9c60be; --success-400: #7e42a0; --success-500: #602482; --success-50: #e7abff; --success-600: #420664; --success-700: #240046; --success-800: #060028; --success-900: #00000a; --success: #602482; --tertiary-100: #ffffc3; --tertiary-200: #ffeda5; --tertiary-300: #ffcf87; --tertiary-400: #ffb169; --tertiary-500: #f8934b; --tertiary-50: #ffffd2; --tertiary-600: #da752d; --tertiary-700: #bc570f; --tertiary-800: #9e3900; --tertiary-900: #801b00; --tertiary: #f8934b; --tw-shadow: 0 0 #0000; --warning-100: #d89cfa; --warning-200: #ba7edc; --warning-300: #9c60be; --warning-400: #7e42a0; --warning-500: #602482; --warning-50: #e7abff; --warning-600: #420664; --warning-700: #240046; --warning-800: #060028; --warning-900: #00000a; --warning: #602482; --white-100: #fff; --white-200: #fff; --white-300: #fff; --white-400: #fff; --white-500: #fff; --white-50: #fff; --white-600: #fff; --white-700: #fff; --white-800: #fff; --white-900: #fff; --white: #fff; -webkit-font-smoothing: subpixel-antialiased; border: 0px solid rgb(226, 232, 240); box-sizing: border-box; color: #716c7b; font-family: Roboto; font-size: 14px; font-weight: bold; height: 100%; text-decoration-line: none; transition: all 0.2s ease 0s;">Adding a new Map page via the wizard</a><br /><a class="toc-link node-name--H3 " href="https://content.dsp.co.uk/apex/native-maps-in-apex-21.1#map_region_attributes" style="--base-100: #c1bccb; --base-200: #a39ead; --base-300: #85808f; --base-400: #676271; --base-500: #494453; --base-50: #d0cbda; --base-600: #2b2635; --base-700: #0d0817; --base-800: #000; --base-900: #000; --base: #494453; --danger-100: #fff; --danger-200: #fff; --danger-300: #fff; --danger-400: #fff; --danger-500: #fafafa; --danger-50: #fff; --danger-600: #dcdcdc; --danger-700: #bebebe; --danger-800: #a0a0a0; --danger-900: #828282; --danger: #fafafa; --dark-100: #96919f; --dark-200: #787381; --dark-300: #5a5563; --dark-400: #3c3745; --dark-500: #1e1927; --dark-50: #a5a0ae; --dark-600: #000009; --dark-700: #000; --dark-800: #000; --dark-900: #000; --dark: #1e1927; --gray-100: #f3f4f6; --gray-200: #e5e7eb; --gray-300: #d1d5db; --gray-400: #9ca3af; --gray-500: #6b7280; --gray-50: #f9fafb; --gray-600: #4b5563; --gray-700: #374151; --gray-800: #1f2937; --gray-900: #111827; --gray: #6b7280; --h1_color: #333; --h2_color: #333; --h3_color: #333; --h4_color: #333; --h5_color: #333; --h6_color: #494453; --primary-100: #848bc2; --primary-200: #666da4; --primary-300: #484f86; --primary-400: #2a3168; --primary-500: #0c134a; --primary-50: #939ad1; --primary-600: #00002c; --primary-700: #00000e; --primary-800: #000; --primary-900: #000; --primary: #0c134a; --secondary-100: #dff; --secondary-200: #bfe6ff; --secondary-300: #a1c8e7; --secondary-400: #83aac9; --secondary-500: #658cab; --secondary-50: #ecffff; --secondary-600: #476e8d; --secondary-700: #29506f; --secondary-800: #0b3251; --secondary-900: #001433; --secondary: #658cab; --success-100: #d89cfa; --success-200: #ba7edc; --success-300: #9c60be; --success-400: #7e42a0; --success-500: #602482; --success-50: #e7abff; --success-600: #420664; --success-700: #240046; --success-800: #060028; --success-900: #00000a; --success: #602482; --tertiary-100: #ffffc3; --tertiary-200: #ffeda5; --tertiary-300: #ffcf87; --tertiary-400: #ffb169; --tertiary-500: #f8934b; --tertiary-50: #ffffd2; --tertiary-600: #da752d; --tertiary-700: #bc570f; --tertiary-800: #9e3900; --tertiary-900: #801b00; --tertiary: #f8934b; --tw-shadow: 0 0 #0000; --warning-100: #d89cfa; --warning-200: #ba7edc; --warning-300: #9c60be; --warning-400: #7e42a0; --warning-500: #602482; --warning-50: #e7abff; --warning-600: #420664; --warning-700: #240046; --warning-800: #060028; --warning-900: #00000a; --warning: #602482; --white-100: #fff; --white-200: #fff; --white-300: #fff; --white-400: #fff; --white-500: #fff; --white-50: #fff; --white-600: #fff; --white-700: #fff; --white-800: #fff; --white-900: #fff; --white: #fff; -webkit-font-smoothing: subpixel-antialiased; border: 0px solid rgb(226, 232, 240); box-sizing: border-box; color: #716c7b; font-family: Roboto; font-size: 14px; height: 100%; text-decoration-line: none; transition: all 0.2s ease 0s;">Map Region Attributes</a><br /><a class="toc-link node-name--H3 " href="https://content.dsp.co.uk/apex/native-maps-in-apex-21.1#layer_attributes" style="--base-100: #c1bccb; --base-200: #a39ead; --base-300: #85808f; --base-400: #676271; --base-500: #494453; --base-50: #d0cbda; --base-600: #2b2635; --base-700: #0d0817; --base-800: #000; --base-900: #000; --base: #494453; --danger-100: #fff; --danger-200: #fff; --danger-300: #fff; --danger-400: #fff; --danger-500: #fafafa; --danger-50: #fff; --danger-600: #dcdcdc; --danger-700: #bebebe; --danger-800: #a0a0a0; --danger-900: #828282; --danger: #fafafa; --dark-100: #96919f; --dark-200: #787381; --dark-300: #5a5563; --dark-400: #3c3745; --dark-500: #1e1927; --dark-50: #a5a0ae; --dark-600: #000009; --dark-700: #000; --dark-800: #000; --dark-900: #000; --dark: #1e1927; --gray-100: #f3f4f6; --gray-200: #e5e7eb; --gray-300: #d1d5db; --gray-400: #9ca3af; --gray-500: #6b7280; --gray-50: #f9fafb; --gray-600: #4b5563; --gray-700: #374151; --gray-800: #1f2937; --gray-900: #111827; --gray: #6b7280; --h1_color: #333; --h2_color: #333; --h3_color: #333; --h4_color: #333; --h5_color: #333; --h6_color: #494453; --primary-100: #848bc2; --primary-200: #666da4; --primary-300: #484f86; --primary-400: #2a3168; --primary-500: #0c134a; --primary-50: #939ad1; --primary-600: #00002c; --primary-700: #00000e; --primary-800: #000; --primary-900: #000; --primary: #0c134a; --secondary-100: #dff; --secondary-200: #bfe6ff; --secondary-300: #a1c8e7; --secondary-400: #83aac9; --secondary-500: #658cab; --secondary-50: #ecffff; --secondary-600: #476e8d; --secondary-700: #29506f; --secondary-800: #0b3251; --secondary-900: #001433; --secondary: #658cab; --success-100: #d89cfa; --success-200: #ba7edc; --success-300: #9c60be; --success-400: #7e42a0; --success-500: #602482; --success-50: #e7abff; --success-600: #420664; --success-700: #240046; --success-800: #060028; --success-900: #00000a; --success: #602482; --tertiary-100: #ffffc3; --tertiary-200: #ffeda5; --tertiary-300: #ffcf87; --tertiary-400: #ffb169; --tertiary-500: #f8934b; --tertiary-50: #ffffd2; --tertiary-600: #da752d; --tertiary-700: #bc570f; --tertiary-800: #9e3900; --tertiary-900: #801b00; --tertiary: #f8934b; --tw-shadow: 0 0 #0000; --warning-100: #d89cfa; --warning-200: #ba7edc; --warning-300: #9c60be; --warning-400: #7e42a0; --warning-500: #602482; --warning-50: #e7abff; --warning-600: #420664; --warning-700: #240046; --warning-800: #060028; --warning-900: #00000a; --warning: #602482; --white-100: #fff; --white-200: #fff; --white-300: #fff; --white-400: #fff; --white-500: #fff; --white-50: #fff; --white-600: #fff; --white-700: #fff; --white-800: #fff; --white-900: #fff; --white: #fff; -webkit-font-smoothing: subpixel-antialiased; border: 0px solid rgb(226, 232, 240); box-sizing: border-box; color: #716c7b; font-family: Roboto; font-size: 14px; height: 100%; text-decoration-line: none; transition: all 0.2s ease 0s;">Layer Attributes</a><br /><a class="toc-link node-name--H3 " href="https://content.dsp.co.uk/apex/native-maps-in-apex-21.1#customising_my_map_page" style="--base-100: #c1bccb; --base-200: #a39ead; --base-300: #85808f; --base-400: #676271; --base-500: #494453; --base-50: #d0cbda; --base-600: #2b2635; --base-700: #0d0817; --base-800: #000; --base-900: #000; --base: #494453; --danger-100: #fff; --danger-200: #fff; --danger-300: #fff; --danger-400: #fff; --danger-500: #fafafa; --danger-50: #fff; --danger-600: #dcdcdc; --danger-700: #bebebe; --danger-800: #a0a0a0; --danger-900: #828282; --danger: #fafafa; --dark-100: #96919f; --dark-200: #787381; --dark-300: #5a5563; --dark-400: #3c3745; --dark-500: #1e1927; --dark-50: #a5a0ae; --dark-600: #000009; --dark-700: #000; --dark-800: #000; --dark-900: #000; --dark: #1e1927; --gray-100: #f3f4f6; --gray-200: #e5e7eb; --gray-300: #d1d5db; --gray-400: #9ca3af; --gray-500: #6b7280; --gray-50: #f9fafb; --gray-600: #4b5563; --gray-700: #374151; --gray-800: #1f2937; --gray-900: #111827; --gray: #6b7280; --h1_color: #333; --h2_color: #333; --h3_color: #333; --h4_color: #333; --h5_color: #333; --h6_color: #494453; --primary-100: #848bc2; --primary-200: #666da4; --primary-300: #484f86; --primary-400: #2a3168; --primary-500: #0c134a; --primary-50: #939ad1; --primary-600: #00002c; --primary-700: #00000e; --primary-800: #000; --primary-900: #000; --primary: #0c134a; --secondary-100: #dff; --secondary-200: #bfe6ff; --secondary-300: #a1c8e7; --secondary-400: #83aac9; --secondary-500: #658cab; --secondary-50: #ecffff; --secondary-600: #476e8d; --secondary-700: #29506f; --secondary-800: #0b3251; --secondary-900: #001433; --secondary: #658cab; --success-100: #d89cfa; --success-200: #ba7edc; --success-300: #9c60be; --success-400: #7e42a0; --success-500: #602482; --success-50: #e7abff; --success-600: #420664; --success-700: #240046; --success-800: #060028; --success-900: #00000a; --success: #602482; --tertiary-100: #ffffc3; --tertiary-200: #ffeda5; --tertiary-300: #ffcf87; --tertiary-400: #ffb169; --tertiary-500: #f8934b; --tertiary-50: #ffffd2; --tertiary-600: #da752d; --tertiary-700: #bc570f; --tertiary-800: #9e3900; --tertiary-900: #801b00; --tertiary: #f8934b; --tw-shadow: 0 0 #0000; --warning-100: #d89cfa; --warning-200: #ba7edc; --warning-300: #9c60be; --warning-400: #7e42a0; --warning-500: #602482; --warning-50: #e7abff; --warning-600: #420664; --warning-700: #240046; --warning-800: #060028; --warning-900: #00000a; --warning: #602482; --white-100: #fff; --white-200: #fff; --white-300: #fff; --white-400: #fff; --white-500: #fff; --white-50: #fff; --white-600: #fff; --white-700: #fff; --white-800: #fff; --white-900: #fff; --white: #fff; -webkit-font-smoothing: subpixel-antialiased; border: 0px solid rgb(226, 232, 240); box-sizing: border-box; color: #716c7b; font-family: Roboto; font-size: 14px; height: 100%; text-decoration-line: none; transition: all 0.2s ease 0s;">Customising my map page</a><br /><a class="toc-link node-name--H3 " href="https://content.dsp.co.uk/apex/native-maps-in-apex-21.1#dynamic_actions" style="--base-100: #c1bccb; --base-200: #a39ead; --base-300: #85808f; --base-400: #676271; --base-500: #494453; --base-50: #d0cbda; --base-600: #2b2635; --base-700: #0d0817; --base-800: #000; --base-900: #000; --base: #494453; --danger-100: #fff; --danger-200: #fff; --danger-300: #fff; --danger-400: #fff; --danger-500: #fafafa; --danger-50: #fff; --danger-600: #dcdcdc; --danger-700: #bebebe; --danger-800: #a0a0a0; --danger-900: #828282; --danger: #fafafa; --dark-100: #96919f; --dark-200: #787381; --dark-300: #5a5563; --dark-400: #3c3745; --dark-500: #1e1927; --dark-50: #a5a0ae; --dark-600: #000009; --dark-700: #000; --dark-800: #000; --dark-900: #000; --dark: #1e1927; --gray-100: #f3f4f6; --gray-200: #e5e7eb; --gray-300: #d1d5db; --gray-400: #9ca3af; --gray-500: #6b7280; --gray-50: #f9fafb; --gray-600: #4b5563; --gray-700: #374151; --gray-800: #1f2937; --gray-900: #111827; --gray: #6b7280; --h1_color: #333; --h2_color: #333; --h3_color: #333; --h4_color: #333; --h5_color: #333; --h6_color: #494453; --primary-100: #848bc2; --primary-200: #666da4; --primary-300: #484f86; --primary-400: #2a3168; --primary-500: #0c134a; --primary-50: #939ad1; --primary-600: #00002c; --primary-700: #00000e; --primary-800: #000; --primary-900: #000; --primary: #0c134a; --secondary-100: #dff; --secondary-200: #bfe6ff; --secondary-300: #a1c8e7; --secondary-400: #83aac9; --secondary-500: #658cab; --secondary-50: #ecffff; --secondary-600: #476e8d; --secondary-700: #29506f; --secondary-800: #0b3251; --secondary-900: #001433; --secondary: #658cab; --success-100: #d89cfa; --success-200: #ba7edc; --success-300: #9c60be; --success-400: #7e42a0; --success-500: #602482; --success-50: #e7abff; --success-600: #420664; --success-700: #240046; --success-800: #060028; --success-900: #00000a; --success: #602482; --tertiary-100: #ffffc3; --tertiary-200: #ffeda5; --tertiary-300: #ffcf87; --tertiary-400: #ffb169; --tertiary-500: #f8934b; --tertiary-50: #ffffd2; --tertiary-600: #da752d; --tertiary-700: #bc570f; --tertiary-800: #9e3900; --tertiary-900: #801b00; --tertiary: #f8934b; --tw-shadow: 0 0 #0000; --warning-100: #d89cfa; --warning-200: #ba7edc; --warning-300: #9c60be; --warning-400: #7e42a0; --warning-500: #602482; --warning-50: #e7abff; --warning-600: #420664; --warning-700: #240046; --warning-800: #060028; --warning-900: #00000a; --warning: #602482; --white-100: #fff; --white-200: #fff; --white-300: #fff; --white-400: #fff; --white-500: #fff; --white-50: #fff; --white-600: #fff; --white-700: #fff; --white-800: #fff; --white-900: #fff; --white: #fff; -webkit-font-smoothing: subpixel-antialiased; border: 0px solid rgb(226, 232, 240); box-sizing: border-box; color: #716c7b; font-family: Roboto; font-size: 14px; height: 100%; text-decoration-line: none; transition: all 0.2s ease 0s;">Dynamic Actions</a></p>B. Fischer-Waselshttp://www.blogger.com/profile/02019839104452667248noreply@blogger.com0tag:blogger.com,1999:blog-37368355.post-59232755680636495552015-11-03T08:40:00.002+01:002015-11-03T08:40:21.991+01:00MapViewer Version 12.2.1 released<div dir="ltr" style="text-align: left;" trbidi="on">
MapViewer 12.2.1 is now available for download from OTN at <a class="moz-txt-link-freetext" href="http://www.oracle.com/technetwork/middleware/mapviewer/downloads/index.html">http://www.oracle.com/technetwork/middleware/mapviewer/downloads/index.html</a><br />
<br />
This version includes a generic EAR file which can be deployed to
other JEE containers such as Tomcat or GlassFish. The WebLogic
specific EAR requires WLS with JRF.<br />
<br />
<span style="-webkit-text-stroke-width: 0px; background-color: #f6f6f6; color: #3d3d3d; display: inline !important; float: none; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 19.5px; orphans: auto; text-align: left; text-indent: 0px; text-transform: none; white-space: normal; widows: 1; word-spacing: 0px;"><span class="Apple-converted-space"></span></span> All MapViewer
functionality is included in this kit, including the latest V2
JavaScript Mapping API.<br />
<br />
In addition, a new feature, dynamic tile layer, allows a client map
application to define and create tile layers dynamically. Because
it is independent from MapViewer's metadata definition for tile
layers, any number of dynamic tile layers can be created on the
client side, making it very useful in big data analytics. Dynamic
tile layer capabilities include:<br />
<br />
<ul>
<li>A new HTML5 API that can define the dynamic tile layers
directly, without relying on pre-defined tile layers on the
server</li>
<li>Ability to fetch fresh map images (not cached images) from a
MapViewer server or a third party map service provider</li>
<li>Allowing a client application to provide a custom
URL-generation function to specify where its tile images are to
be fetched<br />
</li>
<li>Ability to configure a dynamic tile layer such that attribute
values of all the displayed features are embedded in the tile
images and displayed via info window or tooltip on mouse over
any feature</li>
</ul>
The Oracle Fusion Middleware User's Guide for MapViewer can be found <a href="http://docs.oracle.com/middleware/1221/core/JIMPV/toc.htm" target="_blank">here</a>. </div>
Karin Patengehttp://www.blogger.com/profile/07393355977167541886noreply@blogger.com1tag:blogger.com,1999:blog-37368355.post-35324866447539489162014-10-16T17:10:00.002+02:002014-10-17T08:17:05.592+02:00How to make use of maps in Forms 11g?<div>
Author: Cătălin Bulancea</div>
<p>
<div>
This blog posting is about how easy it is to integrate your existing or new <b>Oracle Forms 11g</b> applications with <b>map visualization and navigation</b> capabilities. Oracle FMW MapViewer is the key to that since it provides Oracle Maps with JavaScript API.</div><p>
<div>
For all the Oracle Forms users out there…have you wondered lately what are the key features of Oracle Forms 11g?</div><p>
<div>
Of course, you can read it all from <a href="http://www.oracle.com/technetwork/developer-tools/forms/forms11gr2newfeatures-497502-en-gb.pdf">here</a> or <a href="http://www.oracle.com/technetwork/developer-tools/forms/new-features-134509.pdf">here</a>. With the increased utilization of Java, web technologies (HTML5) and integration strategies, Oracle Forms 11g tries to keep up with the New. And I feel it succeeds in doing just that!
<p>
What I would like to focus on this topic is one of the most important features: Oracle Forms 11g is JavaScript enabled! This new functionality makes it possible to execute JavaScript in the page in which the Forms applet is embedded.
<p>
JavaScript can be used to integrate Forms with any application that provides a JavaScript API, or simply with custom HTML/ADF pages that embed JavaScript functionality.
</div><p>
<div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-CRHM1OLFXR0/VD_Gq1R37_I/AAAAAAAAAP4/2Ce9x3MZ9Ss/s1600/FormsJavaScriptArchitecture.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://2.bp.blogspot.com/-CRHM1OLFXR0/VD_Gq1R37_I/AAAAAAAAAP4/2Ce9x3MZ9Ss/s400/FormsJavaScriptArchitecture.png" /></a></div>
</div><p>
<div>
While integrating Forms with HTML controls is nice, the integration of Oracle Forms with a map displays a spectacular result! It’s time for the main character in this play to step on the stage: Oracle Fusion Middleware MapViewer! See more <a href="http://www.oracle.com/technetwork/middleware/mapviewer/overview/index-090261.html">here</a>.
<p>
Oracle FMW MapViewer currently provides 2 JavaScript APIs (the newer one supports HTML 5) for incorporating highly interactive maps and spatial analysis. The integration with Oracle Forms is done via one of these JavaScript APIs.
<p>
What would an integrated application look like? Let’s suppose you’re a company with multiple offices that provide different services based on the location and office type. Displaying that info in an HTML table doesn’t look very appealing to the customers, while they get lost in the tons of information.
<p>
Why not displaying all the office locations on a map? When a customer clicks on a location, an information window provides all necessary information at the first glance. May be also a thumbnail of an image representing the office, as well as a link to a web resource giving even more information.
<p>
How is this done?
<p>
First, make sure you have an Oracle Database 11g (11.2.0.3 minimum) with Oracle Spatial or at least Oracle Multimedia (which includes Oracle Locator) installed.
<p>
Then, you need to have Oracle Forms 11g and install Oracle FMW MapViewer on top of it.
Download MapViewer from <a href="http://www.oracle.com/technetwork/middleware/mapviewer/downloads/index-100641.html">here</a> and then install the <i>Mapviewer.ear</i> according to the <a href="http://docs.oracle.com/cd/E23943_01/web.1111/e10145/vis_start.htm#i1006838">documentation</a>.
<p>
Oracle FMW MapViewer comes with a <a href="http://slc02okf.oracle.com/mvdemo/">demo application called MVDEMO</a> (please note that this web resource is not assured to be available 24x7) which is a great way to get you started! After importing the MVDEMO sample data into your database, deploy <i>MVDEMO.war</i> onto a WebLogic Server and configure the data source in the MapViewer Administration Console:
</div>
<pre><map_data_source name="mvdemo"
jdbc_host="<i>&ltYOUR DB HOST></i>"
jdbc_sid ="<i>&ltDB SID></i>"
jdbc_port="<i>&ltDB PORT></i>"
jdbc_user="mvdemo"
jdbc_password="!mvdemo"
jdbc_mode="thin"
number_of_mappers="3"
allow_jdbc_theme_based_foi="false"
editable="false"
/>
</pre>
<div>
The samples page will be accessible at this URL:
<i>http://formshost:formsport/mvdemo</i></div>
<p>
<div>
In Oracle Forms <i>formsweb.cfg</i> configuration file, you add a section as below:</div>
<p>
<pre>[formsmapviewer]
baseHTMLjpi=jsmap.html
userid=dbuser/dbpass@host:port/SID
form=formsmapviewer.fmx
width=320
height=763
# Config for javascript integration
applet_name=formsmapviewer_applet
enableJavascriptEvent=true
JavaScriptBlocksHeartBeat=true
splashScreen=no
guiMode=3
lookAndFeel=Oracle
colorScheme=blue
</pre>
<div>
Calling your forms application using above section will assure that JavaScript is used. Notice the <i>baseHTMLjpi</i> parameter which takes a custom file built on the template <i>basejpi.htm</i>, called <i>jsmap.html</i>. This file will contain our Forms application applet embedded and all the JavaScript code.
<p>
This is how we display the map, centering it at Oracle Munich office:
</div><p>
<pre>function showMap()
{
mapview = new MVMapView(document.getElementById("map"), baseURL);
mapview.addMapTileLayer(osmBasemap);
//Oracle Munich office
var mpoint = MVSdoGeometry.createPoint(11.56, 48.13, 8307);
mapview.setCenterAndZoomLevel(mpoint,7);
mapview.addNavigationPanel() ;
mapview.display();
mapview.addCopyRightNote("&2014 Powered by Oracle ©2010 GfK GeoMarketing");
mapview.addNavigationPanel("EAST");
mapview.addScaleBar();
}
</pre><p>
<div>
If you are asking yourselves where does <i>osmBasemap</i> come from, this is a custom map tile layer based on the tile configuration. For more details, check out Jayant's <a href="http://oraclemaps.blogspot.co.uk/2009/05/using-openstreetmap-tiles-with-oracle.html">post</a>.
The <i>baseURL</i> is the URL where Mapviewer was installed:
<i>http://host:port/mapviewer</i></div><p>
<div>
The map itself is a DIV element in HTML and it can be referenced by its id in JavaScript:</div><p>
<pre><div id="map" style="left:0px; top:0px; width:1250; height:763"></div>
</pre>
<div>
Last but not least, you need to develop/modify your Forms application in order to "speak" JavaScript. For example, we have a ZoomIn button in Forms that will zoom in the map. The code used to do that is found in the WHEN-BUTTON-PRESSED trigger and it's easy-peasy:</div>
<pre>web.javascript_eval_expression('zoomIn();');
</pre>
<div>
web.javascript_eval_expression is a procedure which takes an expression as the argument. This legal JavaScript expression is interpreted in the Web page in which the Forms applet is embedded and in our case is the JavaScript function zoomIn().</div><p>
<div>
Another example is creating a <i>Feature of Interest</i> (FOI) on the map with the longitude and latitude coordinates given inside the Forms application:</div><p>
<pre>web.javascript_eval_expression('createFOI('||:CONTROL.LONG||','||:CONTROL.LAT||', 8307);');
</pre>
<div>
For more information on Oracle Forms and JavaScript integration, read Oracle© Fusion Middleware Forms Services Deployment Guide <a href="http://docs.oracle.com/cd/E23943_01/web.1111/e10240/javascript.htm">here</a> and Metalink Note: "A Guide to Integrating JavaScript with Forms&quot (Doc ID 853911.1);.</div><p>
<div>
The Forms application eventually looks like this:</div><p>
<pre>http://formshost:formsport/forms/frmservlet?config=formsmapviewer
</pre>
</br>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-YvZOiFdsooA/VD_ZxgaH7QI/AAAAAAAAAQI/HNuSatwDfTA/s1600/FormsApp.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://4.bp.blogspot.com/-YvZOiFdsooA/VD_ZxgaH7QI/AAAAAAAAAQI/HNuSatwDfTA/s400/FormsApp.png" /></a></div>
</br>
<div>
Application features used for this demo:
<ul>
<li>Zoom in, zoom out from both map and the Forms application</li>
<li>Pan up, down, left, right from both map (navigation panel) and the Forms application</li>
<li>Overview map on the right bottom corner with the possibility to move the map</li>
<li>Scale bar on the left bottom corner of the map</li>
<li>Copyright note on the right bottom corner</li>
<li>Features of Interest:</li>
<ul>
<li>When hitting "Create FOI" button an image is created on the map at the longitude and latitude coordinates specified as parameters.</br>
When clicking the image an Information Window with Oracle is opened and you can navigate to the webpage</li>
<li>Hit Remove FOI to delete the feature of interest (needs the id of the FOI)</li>
<li>Alternatively, you can create other FOIs by specifying different coordinates</li>
</ul>
<li>Custom themes: (In Germany appear when selecting the checkboxes "On mouse over" the airports or highways, you'll see their name.)
</li>
<ul>
<li>Airports and</li>
<li>Highways</li>
</ul>
</ul>
</div>
<div><p>
<b>Feel free to try it out</b> and enhance your Forms application with a nice map.</div><p>
<div>
Any feedback is highly appreciated.</div><p>
<div>
Thanks, Cătălin
</div>
Karin Patengehttp://www.blogger.com/profile/07393355977167541886noreply@blogger.com5tag:blogger.com,1999:blog-37368355.post-14212870322733566942014-02-10T09:40:00.002+01:002014-02-10T09:58:08.722+01:00Mitschnitt eines Web-Seminars zum MapViewer 11.1.1.7 mit HTML5 APIUnter dem Titel <span class="PlayerRcoTitle">"Oracle MapViewer 11.1.1.7: Building HTML5 Maps for Web and Mobile Apps"</span><br />
gibt es den Mitschnitt einer MapViewer Training Session.<br />
<br />
<a class="moz-txt-link-freetext" href="http://oukc.oracle.com/static12/opn/login/?t=checkusercookies%7Cr=-1%7Cc=1453384237">http://oukc.oracle.com/static12/opn/login/?t=checkusercookies%7Cr=-1%7Cc=1453384237</a><br />
<br />
<br />
Vorausgesetzt wird ein Oracle Technology Network (OTN) Account. Für diesen können Sie sich jederzeit kostenlos registrieren.<br />
<br />
Vorgestellt wird darin auch der neue <i>Map Data Editor</i>.<br />
Was ist das?<br />
<ul>
<li>Web-based spatial data editing tool (Java applet)</li>
<li>Supports versioned, concurrent editing through editing sessions</li>
<li>Supports Oracle Workspace Manager (long transactions)</li>
<li>Supports geometry model </li>
<li>Supports WFS-T </li>
<li>All aspects of an editing session are saved in database</li>
</ul>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-Eh9MW1l7p5g/UviQBo_sD3I/AAAAAAAAAMs/Yp3K-JsRWZU/s1600/MapViewer11117_Capture.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-Eh9MW1l7p5g/UviQBo_sD3I/AAAAAAAAAMs/Yp3K-JsRWZU/s1600/MapViewer11117_Capture.JPG" height="168" width="320" /></a></div>
<div style="text-align: center;">
<span style="font-size: x-small;"><i>(Abb.: MapViewer 11.1.1.7 -Gitter-Darstellung mehrerer voll interaktiver Karten)</i></span></div>
<br />Karin Patengehttp://www.blogger.com/profile/07393355977167541886noreply@blogger.com2tag:blogger.com,1999:blog-37368355.post-70654350727127108052013-11-14T13:35:00.000+01:002013-11-14T13:35:36.305+01:00Architektur von MapViewer 11.1.1.7Ergänzend zu meinem Posting eben will ich hier noch einen Überblick zur Architektur des MapViewers geben.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/--lUBsaq-swU/UoTDVV8UJxI/AAAAAAAAAMU/0f4sFx28HlA/s1600/OracleFMWMapViewer_Architecture.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="183" src="http://4.bp.blogspot.com/--lUBsaq-swU/UoTDVV8UJxI/AAAAAAAAAMU/0f4sFx28HlA/s320/OracleFMWMapViewer_Architecture.JPG" width="320" /></a></div>
<br />Karin Patengehttp://www.blogger.com/profile/07393355977167541886noreply@blogger.com0tag:blogger.com,1999:blog-37368355.post-72880997824760219362013-11-14T11:11:00.001+01:002013-11-14T11:32:49.938+01:00HTML 5 API von MapViewer 11.1.1.7. nutzen für coole KartenIm Blogpost vom 25. April 2013 wurde auf die neue Version von Oracle Fusion Middleware MapViewers (und Maps) verwiesen.<br />
Diese kommt mit einer neuen Javascript API daher, welche HTML 5 unterstützt. <br />
<br />
Wie für die bisherige API auch, stehen Javascript Reference und jede Menge Tutorials mit Codebeispielen bereit. Darüberhinaus gibt es online verfügbar Beispielanwendungen, welche die neuen HTML 5 Features einsetzen.<br />
Zu finden ist das alles auf dieser extern verfügbaren Seite: <a href="http://slc02okf.oracle.com/mvdemo/">http://slc02okf.oracle.com/mvdemo/</a><br />
<br />
Im Detail:<br />
<ul type="disc">
<li class="MsoNormal" style="mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">Tutorials: <br /><a href="http://slc02okf.oracle.com/mvdemo/jslib/v2/tutorial/demo.html">http://slc02okf.oracle.com/mvdemo/jslib/v2/tutorial/demo.html</a></li>
<li class="MsoNormal" style="mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">Feature Demo Visualisierung von Flugrouten: <a href="http://slc02okf.oracle.com/mvdemo/jslib/v2/demos/flights/index.html"><br />http://slc02okf.oracle.com/mvdemo/jslib/v2/demos/flights/index.html</a></li>
<li class="MsoNormal" style="mso-list: l0 level1 lfo1; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto;">Feature Demo Visualisierung von Naturereignissen und der von diesen verursachten Schäden:<br /><a href="http://slc02okf.oracle.com/mvdemo/jslib/v2/demos/storm/storm.html">http://slc02okf.oracle.com/mvdemo/jslib/v2/demos/storm/storm.html</a></li>
</ul>
Karin Patengehttp://www.blogger.com/profile/07393355977167541886noreply@blogger.com0tag:blogger.com,1999:blog-37368355.post-16026466889310452192013-09-06T12:17:00.003+02:002013-09-06T12:25:21.956+02:00Mapviewer Update Webcast September 12, 2013 - 11:00AM ET - 17:00h German Time<span style="font-family: Arial, Helvetica, sans-serif;">The Oracle Mapviewer team of Oracle Spatial & Graph will host a webcast with an update of the new MV features on September 12th, 2013:</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">T</span><span style="color: #545454; font-family: Arial, Helvetica, sans-serif;">his webcast will concentrate on the following new MapViewer 11.1.1.7 enhancements:</span><br />
<br />
<div style="color: #545454;">
<span style="font-family: Arial, Helvetica, sans-serif;">Join the MapViewer team and learn how these new features can help you to quickly integrate and visualize business data with maps. Live Q & A will follow the presentation. </span></div>
<ul style="color: #545454;">
<li><span style="font-family: Arial, Helvetica, sans-serif;">Web-based editor (Java
applet) that edits spatial
data with workspace and
versioning support </span></li>
</ul>
<ul style="color: #545454;">
<li><span style="font-family: Arial, Helvetica, sans-serif;">Templates: prepackaged map
data files that are readily
consumed by the new API </span></li>
</ul>
<ul style="color: #545454;">
<li><span style="font-family: Arial, Helvetica, sans-serif;">Support for OGR/GDAL to
access 3rd party spatial data
sources </span></li>
</ul>
<span style="font-family: Arial, Helvetica, sans-serif;"><strong>Duration</strong>:
1 hour</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /><u>Telephone conference details:</u><br />US/Canada
Dial-In Number:
(855) 227-3163 <br />
International
Dial-In Number:
(213) 784-8014</span><br />
<a href="http://www.intercall.com/national/oracleuniversity/gdnam.html" moz-do-not-send="true" style="font-family: Arial, Helvetica, sans-serif;">Toll-Free International Dial-In Numbers</a><br />
<span style="font-family: Arial, Helvetica, sans-serif;">German dial in # 0800 1815 287</span><span style="background-color: white; font-size: 12px; line-height: 14px;"><span style="font-family: Arial, Helvetica, sans-serif;"> </span></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;">
Session Number:
256 954 725<br />
Password:
Oracle123</span><br />
<br />
<span style="color: #545454; font-family: Arial, Helvetica, sans-serif;"><u>Webcast Details:</u></span><br />
<div style="color: #545454;">
<strong style="font-family: Arial, Helvetica, sans-serif;">Date:
</strong><span style="font-family: Arial, Helvetica, sans-serif;">September
12, 2013</span></div>
<div style="color: #545454;">
<span style="font-family: Arial, Helvetica, sans-serif;"><strong>Time: </strong>11:00am
ET --> 17:00h German Time (CEST)</span></div>
<div style="color: #545454;">
<span style="font-family: Arial, Helvetica, sans-serif;"><strong>Conference
ID: </strong>47402540</span></div>
<div style="color: #545454;">
<span style="font-family: Arial, Helvetica, sans-serif;"><a href="https://enablement20.webex.com/">Link to the WEBEX conference</a></span></div>
<div style="color: #545454;">
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div style="color: #545454;">
<span style="font-family: Arial, Helvetica, sans-serif;">Good luck </span><span style="font-family: Arial, Helvetica, sans-serif;">!</span></div>
B. Fischer-Waselshttp://www.blogger.com/profile/02019839104452667248noreply@blogger.com1tag:blogger.com,1999:blog-37368355.post-42918086073627666292013-04-25T11:33:00.001+02:002013-04-25T11:54:02.557+02:00MapViewer 11.1.1.7.0 has been shippedYou might have noticed:
MapViewer 11.1.1.7.0 has shipped (as part of FMW PS6).<br />
<br />
It's available on support.oracle as Patch # 16589883
<a href="https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=16589883">https://support.oracle.com/epmos/faces/ui/patch/PatchDetail.jspx?patchId=16589883 </a><br />
<br />
Notable enhancements include:<br />
- V2 of oraclemaps javascript API which depends on, and uses, HTML5 Canvas and SVG for client side rendering of interactive map content. <br />Requires HTML5 Canvas support in the browser and hence won't work with IE8.<br />
- A web-based spatial data editor (Java applet)<br />
- Support for 3rd party spatial data sources via GDAL/OGR<br />
<br />
I haven't had time to test this all.<br />
I am extremely interested in the Java applet for editing...<br />
Have fun !
(oh, sorry, english)<br />
<br />
NB: A new site has been launch for <a href="http://elocation.oracle.com/maps_oracle_dot_com_main.html">Oracle Maps</a> recently -<br />
with a <a href="http://maps.oracle.com/elocation/ajax/index.jsp">Test Drive for Oracle Maps with the new look and feel</a>.B. Fischer-Waselshttp://www.blogger.com/profile/02019839104452667248noreply@blogger.com0tag:blogger.com,1999:blog-37368355.post-27924923533211380052012-09-04T16:09:00.001+02:002012-09-12T16:18:35.051+02:00Oracle Spatial Conference - CollateralEine ganze Reihe interessanter Dokumentationen wurde nach der Oracle Spatial User Conference (im Mai 2012) veröffentlicht und sind <a href="http://www.oracle.com/technetwork/database/options/spatial/overview/introduction/spatial-conf-1205-idx-1640479.html" target="_blank">über diese Seite</a> erreichbar.<br />
<br />
Speziell die Integration mit OBI EE (Oracle Business Intelligence) wurde in einem umfassenden <a href="http://download.oracle.com/otndocs/products/spatial/pdf/osuc2012_presentations/osuc12_advbi_lappsharma.pdf" target="_blank">Vortrag von PM Jayant Sharma</a> (pdf, 14 MB) erläutert und mag für weitere Anwendungsentwicklung nützlich sein. Auch ein sehr<a href="http://www.rittmanmead.com/files/biforum2011/Heljula_Spatial.pdf%20" target="_blank"> ausführlicher Vortrag (106 slides)</a> von <a href="http://www.rittmanmead.com/files/biforum2011/Heljula_Spatial.pdf%20" target="_blank">Peak Indicators Ltd.</a> hilft weiter bei der Umsetzung.<br />
<br />
Hier Screenshot einer Heatmap basierend auf einem WMS in OBI EE:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-t6kTSCxpiNw/UEYLatJduII/AAAAAAAAFUY/jNA_IKnusHY/s1600/HeatMap_WMS.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="242" src="http://2.bp.blogspot.com/-t6kTSCxpiNw/UEYLatJduII/AAAAAAAAFUY/jNA_IKnusHY/s400/HeatMap_WMS.gif" width="400" /> </a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
oder die Kombination von Karte und Liste inkl. "Verschneide"-Möglichkeit...:</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-SEGCgGPQJWs/UFCXlDBhM2I/AAAAAAAAFe0/w-D5b4Cu9qA/s1600/Beispiel_Dashboard.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="206" src="http://1.bp.blogspot.com/-SEGCgGPQJWs/UFCXlDBhM2I/AAAAAAAAFe0/w-D5b4Cu9qA/s400/Beispiel_Dashboard.GIF" width="400" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<br />
und ein gutes Video von KPI Partners, was alles möglich ist (Oracle Maps ab 8:37 min) und wie ein Dashboard erstellt wird (ab 10:00 min):<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen='allowfullscreen' webkitallowfullscreen='webkitallowfullscreen' mozallowfullscreen='mozallowfullscreen' width='320' height='266' src='https://www.youtube.com/embed/HG-la4r69Wk?feature=player_embedded' frameborder='0'></iframe></div>
<br />
und noch beeindruckender mit Hilfe der <a href="http://www.oracle.com/us/solutions/ent-performance-bi/business-intelligence/exalytics-bi-machine/overview/index.html" target="_blank">Oracle Exalytics</a> Lösung am Beispiel einer Airline:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen='allowfullscreen' webkitallowfullscreen='webkitallowfullscreen' mozallowfullscreen='mozallowfullscreen' width='320' height='266' src='https://www.youtube.com/embed/1NMqPjdeCVU?feature=player_embedded' frameborder='0'></iframe></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://4.bp.blogspot.com/-5o-IkNXivk4/UFCZdulsKfI/AAAAAAAAFe8/2XU8kXwbrq8/s1600/Dashboard_Airline_MAP.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="180" src="http://4.bp.blogspot.com/-5o-IkNXivk4/UFCZdulsKfI/AAAAAAAAFe8/2XU8kXwbrq8/s320/Dashboard_Airline_MAP.gif" width="320" /></a></div>
<div style="text-align: center;">
in obigem Video ab 2:00 min diese Routen Analyse</div>
<br />
<br />
oder "mobile" auf einem iPad:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<iframe allowfullscreen='allowfullscreen' webkitallowfullscreen='webkitallowfullscreen' mozallowfullscreen='mozallowfullscreen' width='320' height='266' src='https://www.youtube.com/embed/fdbazqdXBeE?feature=player_embedded' frameborder='0'></iframe></div>
<br />B. Fischer-Waselshttp://www.blogger.com/profile/02019839104452667248noreply@blogger.com1tag:blogger.com,1999:blog-37368355.post-1595231102669103552012-03-19T13:55:00.000+01:002012-03-19T14:06:07.105+01:00ADF: use custom image (eigene Bilder) in MapPointThemeEin kurzer Tipp zur Nutzung von "eigenen" Bildern als POI in ADF... dieses Beispiel basiert auf JDeveloper 11.1.2.1.<br />
Als alter Schifffahrtskaufmann hatte ich die Herausforderung, auf einer (Welt-) Karte die Schiffspositionen "meiner" Reederei darzustellen. Ich wollte diese nun nicht mittels "Fähnchen" oder den default "Bubbles" markieren, sondern mit einem "richtigen" Schiff.<br />
Hier zunächst das Ergebnis:<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://1.bp.blogspot.com/-0Ekse4Q4ItA/T2cuFVys1aI/AAAAAAAAEwc/XOXHXr1BaFI/s1600/Screenshot_vessel_positions3.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="404" src="http://1.bp.blogspot.com/-0Ekse4Q4ItA/T2cuFVys1aI/AAAAAAAAEwc/XOXHXr1BaFI/s640/Screenshot_vessel_positions3.PNG" width="640" /></a></div>
<br />
Dazu habe ich eine dvt:mapPointTheme verwendet, welches die Schiffspositionen aus der Datenbank ließt. Standardmäßig wird im dvt:mapPointTheme als "Image" (wie bei den Oracle Offices in DE zu sehen) der rosa Bubble als InBuilt Image genutzt (es stehen da auch noch weitere 20 zur Auswahl wie Flaggen, Zeichen, usw.).<br />
Dann habe ich mir ein "Containershiff" besorgt... und es in mein Images-Verzeichnis meiner Anwendung hochgeladen (C:\...\JDEV11121\mywork\ADF-GEO\ViewController\public_html\images<br />
Im JDeveloper: ..ViewController - Application Sources - Web-Content - images (evtl. neu zu erstellen).<br />
Für den POI gibt es jetzt unter den DVT Komponenten einen: "dvt:PointStyleItem".<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-ArvXlIStUUE/T2cr-ux9RfI/AAAAAAAAEwM/xUXNbDKixEs/s1600/DVT_MAP_component.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://3.bp.blogspot.com/-ArvXlIStUUE/T2cr-ux9RfI/AAAAAAAAEwM/xUXNbDKixEs/s320/DVT_MAP_component.PNG" width="245" /></a></div>
<br />
<br />
Diese Komponente ziehe ich jetzt auf mein dvt:MapPointTheme;<br />
<br />
und setze im Point Style Item IsDefault: auf true and selektiere mein Image aus der Liste.<br />
Fertig ! <br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-Eh2VyiKRNHs/T2csAqSefeI/AAAAAAAAEwU/FU90YwAzS58/s1600/DVT_MAP_PointStyleItem.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="http://3.bp.blogspot.com/-Eh2VyiKRNHs/T2csAqSefeI/AAAAAAAAEwU/FU90YwAzS58/s1600/DVT_MAP_PointStyleItem.PNG" /></a></div>
<br />Dies Beispiel beruht übrigens auf der <a href="http://oracle-maps.blogspot.co.uk/2012/03/adf-news-session-geodaten-integration.html" target="_blank">kleinen Übung in meiner ADF News Session</a> und kommt ebenfalls ohne eigene "Geodaten-Infrastruktur" aus...B. Fischer-Waselshttp://www.blogger.com/profile/02019839104452667248noreply@blogger.com0tag:blogger.com,1999:blog-37368355.post-53366601311380992442012-03-16T09:47:00.000+01:002016-01-19T07:48:02.521+01:00ADF News Session - Geodaten Integration - Recap<div style="font-family: Arial,Helvetica,sans-serif;">
Eine kurze Zusammenfassung zur ADF News Session vom Freitag, 16.3.2012:</div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br />
Wir erstellen eine Seite mit einer Karte und Point-Layer/Theme <b><i>ohne eigene Geodaten Infrastruktur</i></b>... - wir nutzen lediglich den JDeveloper 11g/12g, ADF und die ADF Data Visualizations.<br />
Die Karte kommt vom Oracle "Elocation Server" - die POI (Points of Interest) entstammen einer eigenen .csv Datei.<br />
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
Das Ergebnis vorweg: Oracle Niederlassungen auf der Deutschland/Europa Karte</div>
<div class="separator" style="clear: both; font-family: Arial,Helvetica,sans-serif; text-align: center;">
<a href="http://4.bp.blogspot.com/-bJO1pMJsu4Q/T2L2IX0ftMI/AAAAAAAAEvs/qhywI4BTwxU/s1600/Oracle_Ndl_Resultat.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="190" src="http://4.bp.blogspot.com/-bJO1pMJsu4Q/T2L2IX0ftMI/AAAAAAAAEvs/qhywI4BTwxU/s400/Oracle_Ndl_Resultat.PNG" width="400" /></a></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
Die Steps dahin:</div>
<div style="font-family: Arial,Helvetica,sans-serif;">
1. Neue "ADF_GEO.jsf" anlegen<br />
Einzelschritte:<br />
New Application - ADF Fusion Application - OK -<br />
Application Name: "Map-App" - Finish - warten...<br />
Auf Viewcontroller-Projekt klicken und recht Maustaste: New .. - Page:<br />
Page-Wizard startet..: File Name: Karte.jsf - OK<br />
<br />
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
2. Component Palette (standardmäßig: oben rechts) auswählen: ADF Data Visualizations:<br />
<br /></div>
<div class="separator" style="clear: both; font-family: Arial,Helvetica,sans-serif; text-align: center;">
<a href="http://4.bp.blogspot.com/-8dt_PyXCDTg/T2L3AMXHlZI/AAAAAAAAEv0/K5eGlILzULk/s1600/Component_Palette_DVT.PNG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="320" src="http://4.bp.blogspot.com/-8dt_PyXCDTg/T2L3AMXHlZI/AAAAAAAAEv0/K5eGlILzULk/s320/Component_Palette_DVT.PNG" width="204" /></a></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br />
<br />
<br />
die Komponente "map" auf die Seite ziehen...</div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
der "Create Geographic Map" Wizard startet.</div>
<div style="font-family: Arial,Helvetica,sans-serif;">
</div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br />
<br />
<br />
<br />
<br />
<br />
3. Bei "Map Configuration" die Mapviewer url eingeben. In unserem Beispiel war es der<br />
Oracle Mapviewer auf dem "elocation-server":<br />
<br />
<b>Mapviewer url: http://elocation.oracle.com/mapviewer </b>- dann: Test Connection<br />
<br />
-- OK</div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br />
Als Geocoder url verwenden wir ebenfalls die Oracle Instanz:<br />
<br />
<b>Geocoder url: http://elocation.oracle.com/geocoder/gcserver </b>- dann: Test Connection<br />
<br />
- der "Geocoder" wird unsere Adressdaten aus der .csv Datei in "POI"s auf der Karte umrechnen... </div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
4. Karte zentrieren (Klick auf das Zentrum der Karte) - Zoom-Level über den Slider auf 4 setzen --> OK<br />
Bei Hinweis: "Please specify numeric value", bei den Koordinaten X und Y evtl. das "Komma" mit einem "Punkt" ersetzen (passiert manchmal bei deutschem Character Set). </div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br />Im Property Window (rechts unten) können nachträglich Länge (Y) und Breite (X) sowie das Zoomlevel angepasst werden.</div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
5.Layer hinzufügen. Hier über Placeholder Data Control zur Nutzung einer CSV Datei.</div>
<div style="font-family: Arial,Helvetica,sans-serif;">
Die Datei hatte die Struktur: 1. Zeile: Name,strasse,land,plz,ort,Land,Anzahl oder Umsatz - ab 2. zeile die Adressen..</div>
<div style="font-family: Arial,Helvetica,sans-serif;">
File --> New --> From Gallery, Data Control --> Placeholder Data Control --> Name vergeben: Oracle_NDL --> OK</div>
<div style="font-family: Arial,Helvetica,sans-serif;">
wechseln zu: Data Controls: (Refresh klicken!!) dann rechte Maustaste auf "Oracle_NDL" und: "Create Place Holder Data Type" </div>
<div style="font-family: Arial,Helvetica,sans-serif;">
Name des Placeholders vergeben --> - OK.<br />
Update (29.12.2015) für JDEV 12.1.3:<br />
Zunächst über "Data" und "+" die Spalten der Tabelle hinzufügen wie : Name, Strasse, plz, Ort, Land, Anzahl... dann (weiter)...</div>
<div style="font-family: Arial,Helvetica,sans-serif;">
--> Data --> Import... - csv Datei im Dateisystem suchen..(Filename, Browse..). - Character set: Cp1252 sollte passen...OK --> evtl. Spaltenüberschriften anpassen --> OK</div>
<div style="font-family: Arial,Helvetica,sans-serif;">
Jetzt Layer/Theme hinzufügen: Das Placeholder Data Control auf die Karte ziehen und der Create Theme Wizard started --> PointTheme selektieren:</div>
<div class="separator" style="clear: both; font-family: Arial,Helvetica,sans-serif; text-align: center;">
<a href="http://4.bp.blogspot.com/-oIOymYil7yc/T2L8GpmwLLI/AAAAAAAAEv8/My5XzWtv4Yg/s1600/Create_PointTheme.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="141" src="http://4.bp.blogspot.com/-oIOymYil7yc/T2L8GpmwLLI/AAAAAAAAEv8/My5XzWtv4Yg/s200/Create_PointTheme.png" width="200" /></a></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
Der CreatePoint Theme Wizard startet - Namen vergeben (erscheint im UI des Users!) - Location: Address Type: "International Address" (mit unserem Format) auswählen und "mappings" mit unserer Datenstruktur herstellen. street = Strasse, city = ort, usw. </div>
<div style="font-family: Arial,Helvetica,sans-serif;">
Bei Point Data könnten wir "Umsatz" oder "Anzahl" nehmen und als Label "Umsatz" oder "Anzahl Mitarbeiter" eintragen (Category kann leer bleiben) --> OK - speichern... (;-)<br />
Sollte es im Design Window einen Fehler geben (rote Markierung) mit dem Hinweis, daß "Summary" ausgefüllt sein muß, auf den Hinweis klicken und bestätigen, dass es OK ist - dann --> <br />
Deployment:<br />
Linker Hand bei ""Projects" - "Viewcontroller" aus wählen und oben aus dem Hauptmenue "Applications" auswählen .. dann: "Deploy" und den Wizard bis zum Ende durchgehen.<br />
Bei "Popup" der einzubindenden URL von "elocation" und "geocoder" - mit OK bestätigen.<br />
Im Deployment-log (unten) erscheint dann die URL für die Page/Seite wie:<br />
localhost:7101/7Applicationname-ViewController-context-root...<br />
hier ergänzen wir: /faces/Karte.jsf<br />
<br />
Updated 4.1.2016:<br />
Kleine Erweiterung (<b>Navigation Bar, Meter-Bar</b>):</div>
<div style="font-family: Arial,Helvetica,sans-serif;">
Im JDEV im Property Window (standardmäßig unten rechts) in der Sektion "Appearance" ergänzen:<br />
ShowScaleBar: true<br />
Starting X: 10 (geografische Länge - östlich Greenwich - entspricht Hamburg, Lombardsbrücke)<br />
Starting Y: 50 (geografische Breite - Breite nördlich des Äquators, ca. Höhe Frankfurt)<br />
Summary: ... (ist Mußfeld; deswegen kam vorhin der Fehler, weil es hier leer war)<br />
Unit: METERS<br />
<br />
"<b>Icons/Pins</b>" anpassen für die Locations:<br />
Default-mäßig ist als Icon oder Pin der orangene "Bubble" gesetzt.<br />
Andere Optionen gibt es auch noch...<br />
Wie? Im "Structure-Window" (unten links) in der Baumstruktur zu dvt:map hangeln und aufklappen - darunter findet man: dvt:MapPointTheme - anklicken und rechts im "Property Window" bei "Appearance" - "BuiltInImage" ein anderes auswählen.<br />
Falls Du "eigene" Pins/Icons verwenden möchtest, siehe bitte diesen <a href="http://oracle-maps.blogspot.de/2012/03/adf-use-custom-image-eigene-bilder-in.html" target="_blank">BLOG Beitrag mit den Schiffen</a>....<br />
<br />
<b>Toolbar</b> hinzufügen:<br />
Man kann z.B. oberhalb der Karte einen nützlichen "Toolbar" einblenden wie folgt:<br />
Aus der "Component Palette" und " ADF Data Visualisations" wähle man aus der Sektion "Type-specific-Child-Tags" den "Toolbar" und setze ihn oberhalb der Karte - am besten im "Structure Window"...</div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br />
Viel Spaß und Erfolg weiterhin mit ADF und Geodaten....!!</div>
B. Fischer-Waselshttp://www.blogger.com/profile/02019839104452667248noreply@blogger.com0tag:blogger.com,1999:blog-37368355.post-84052140361370013772012-03-13T14:35:00.002+01:002012-03-13T14:36:24.538+01:00ADF DVT Visualisation Components - Map mit Colortheme, Pie- und Bar-GraphIn Vorbereitung auf eine <a href="http://apex.oracle.com/pls/apex/f?p=38040:1:0::NO:RP:P1_WORKSHOP_ID,P1_KATEGORIE:901,ADFINFO" target="_blank">ADF Java News Session am Freitag, 16.3.2012 08:30h</a> habe ich wieder mal in die DVT Komponenten geschaut und coole Grafiken erstellt:<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://3.bp.blogspot.com/-LuGeXgIs08U/T19LmcAEFMI/AAAAAAAAEvc/FL32iEIKVXM/s1600/Kaufkraft_GY_Beer_Pies_color_theme.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="180" src="http://3.bp.blogspot.com/-LuGeXgIs08U/T19LmcAEFMI/AAAAAAAAEvc/FL32iEIKVXM/s400/Kaufkraft_GY_Beer_Pies_color_theme.PNG" width="400" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Zoom Level 2: Pie-Graphs</td></tr>
</tbody></table>
<div style="text-align: justify;">
Weiter "Rein-Zoomen" und ...</div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://1.bp.blogspot.com/-oW8Meqk_TS0/T19LjDE21GI/AAAAAAAAEvU/ah1qhdIFL5g/s1600/Kaufkraft_GY_Beer_Bars_color_theme_Zoom_Level_3.PNG" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="242" src="http://1.bp.blogspot.com/-oW8Meqk_TS0/T19LjDE21GI/AAAAAAAAEvU/ah1qhdIFL5g/s400/Kaufkraft_GY_Beer_Bars_color_theme_Zoom_Level_3.PNG" width="400" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Zoom Level 4: Color Theme plus Bar-Graphs</td><td class="tr-caption" style="text-align: center;"><br /></td><td class="tr-caption" style="text-align: center;"><br /></td></tr>
</tbody></table>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="http://3.bp.blogspot.com/-Z_X7guFRwyA/T19LnvgUv6I/AAAAAAAAEvk/mNEQObgvXL8/s1600/Kaufkraft_GY_Beer_Bars_color_theme_Zoom_Level_4.PNG" style="margin-left: auto; margin-right: auto;"><img border="0" height="180" src="http://3.bp.blogspot.com/-Z_X7guFRwyA/T19LnvgUv6I/AAAAAAAAEvk/mNEQObgvXL8/s400/Kaufkraft_GY_Beer_Bars_color_theme_Zoom_Level_4.PNG" width="400" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Zoom Level 5: Color Theme plus Bar-Graphs</td></tr>
</tbody></table>B. Fischer-Waselshttp://www.blogger.com/profile/02019839104452667248noreply@blogger.com0tag:blogger.com,1999:blog-37368355.post-15303615403069654542011-11-29T10:52:00.001+01:002012-03-13T11:37:50.692+01:00ADF mit Karte und Tabelle selektierter FOIs<div style="text-align: right;">
</div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Ein weiterer Schritt des typischen GIS "Verschneidens" soll hier dokumentiert werden -</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">mit dem aktuellen Mapviewer 11g PS3 bzw. Oracle Maps und JDeveloper 11.2.</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Ich nutze dazu die ADF DVT (Data Visualisation Technology) im JDeveloper</span></div>
<div style="font-family: Arial,Helvetica,sans-serif; text-align: left;">
<span style="font-size: small;">Hier der Hinweis auf die<a href="http://jdevadf.oracle.com/adf-richclient-demo/faces/feature/geoMap/geoMapSelectionEvent.jspx" target="_blank"> offizielle Demo Site der Oracle ADF DVT Komponenten</a>.</span><br />
<span style="font-size: small;"><br /></span></div>
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; font-family: Arial,Helvetica,sans-serif; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><span style="font-size: small;"><a href="http://3.bp.blogspot.com/-lnQ0aGy5ZB4/TuDtREQSbKI/AAAAAAAAEuc/81CMeZf6iJc/s1600/MapPointThemeWithSelectedPointsInTableDE_mit_Rectangle_Pfeil.gif" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="288" src="http://3.bp.blogspot.com/-lnQ0aGy5ZB4/TuDtREQSbKI/AAAAAAAAEuc/81CMeZf6iJc/s640/MapPointThemeWithSelectedPointsInTableDE_mit_Rectangle_Pfeil.gif" width="640" /></a></span></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-size: small;">Abb. 3 - "Verschneiden" (in Oracle Spatial: SDO_Relate) - Karte und Ergebnistabelle</span></td></tr>
</tbody></table>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Im Gegensatz zu meinem letzten <a href="http://oracle-maps.blogspot.com/2011/10/adf-hilft-fusion-bottle-co.html" target="_blank">BLOG Eintrag</a> wollen wir jetzt die Getränkemärkte mit dem Redline Tool "Circle" oder "Rectangle" selektieren/verschneiden und entsprechend rechts daneben in der Tabelle die Namen und Umsätze darstellen....</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Hier die Variante ohne lokale/eigene Mapviewer Installation und ohne Oracle Spatial... (;-) - ich nutze Addressdaten aus einer Tabelle und lasse den Oracle-Geocoder die Geokoordinaten "on-the-fly" berechnen. </span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Neben dem ausführlichen Viewlet (folgt) hier die Kurzform:</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">1. New "Fusion Web Application"</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">2. model -- New "ADF Business Components for tables"</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">3. Connection zur DB, <i>Tabelle mit Addressdaten ist ausreichend</i>... - Query - Tabelle selektieren</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">4. <b>Seite:</b> ViewController -- New Webtier - JSF Page - Format 2-spaltig / verticale Anordnung</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">5. <b>Karte:</b> Von rechts "Compoment Pallette" und ADF Data Visualisations -- Map -- Geographic map auf das linke (first) facelet ziehen</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">6. Connection zum Mapviewer definieren </span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">6.1 Mapviewer url: http://elocation.oracle.com/mapviewer und zum</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">6.2 Geocoder url: Geocoder url: http://elocation.oracle.com/geocoder/gcserver</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Info: der Geocoder auf dem Oracle elocation server errechnet uns "on the fly" die Geokoordinaten..!! cool !</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">7. In Karte reinzoomen und Zentrum auf Deutschland setzen (Doppelklick in DE)</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">8. <b>Toolbar:</b> Aus Component Palette und "Map" den Toolbar über die Karte ziehen - optional im "Structure Pane" (links) oberhalb der "map" loslassen - Map ID bestätigen (default ist m1, falls nicht umbenannt).</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">9. <b>PointTheme/Layer</b> erstellen: Aus "DataControls" das ViewObjekt anklicken und auf die Karte ziehen - PointMapTheme selektieren und im Wizard bei Location: "Address" anklicken und Variante "international address" mit "Street, city, location, zip" auswählen und folgend die Spalten aus der Tabelle (ViewObject) zuweisen. Bei "Point Data" den z.B. numerischen Umsatz-Wert selektieren und einen Namen wie "Umsatz" benennen. Wichtig: Checkbox "Enable Row Selection" LEER lassen! Ja !!! Dies muss jetzt ausprogrammiert werden über eine Managed Bean (s.u.) </span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">9. <b>Tabelle:</b> neben die Karte in das 2. Facelet eine "leere" Tabelle aus ADF Faces Components - Data Views - Table - ziehen</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">10. Im Table Wizard nur eine Column stehen lassen und "row.col1" in "row" in den geschweiften Klammern umbennnen. OK</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">11. <b>Finetuning, Binding, SelctionListener, PartialTrigger</b></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">MapPointTheme im Structure Pane selektieren und im Properties Window bei "Behaviour" -- Selection Listener -- edit (ganz rechts) - New: Managed Bean erstellen namens "ShopSelectionBean" und Class (Neu) - Name egal - und jeweils anpassen</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">12. Managed Bean ausprogrammieren: d.h.: vorgenerierten Code mit Beispiel Code (siehe unten) per copy und Paste ersetzen. Wie ? Im Application explorer "ShopSelectionBean.java" öffnen...</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">13. Table anpassen in Properties Window: Value: Edit - Binding: managedBean -- Session -- ProcessSelection</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">14. Behaviours: PartialTriggers "::m1" setzen bzw. über Edit selektieren</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">... das sollte es sein...</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<pre id="line34" style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;">Hier der Code für die Managed Bean: ShopSelectionBean: </span></pre>
<pre id="line34" style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;"> </span></pre>
<pre id="line34" style="font-family: Arial,Helvetica,sans-serif;"><span style="font-size: small;"><span style="font-family: "Courier New",Courier,monospace;">package view;</span>
<span style="font-family: "Courier New",Courier,monospace;">import java.io.Serializable;</span>
<span style="font-family: "Courier New",Courier,monospace;">import java.util.Iterator;</span>
<span style="font-family: "Courier New",Courier,monospace;">import java.util.LinkedList;</span>
<span style="font-family: "Courier New",Courier,monospace;">import java.util.List;</span>
<span style="font-family: "Courier New",Courier,monospace;">import oracle.adf.view.faces.bi.component.geoMap.DataContent;</span>
<span style="font-family: "Courier New",Courier,monospace;">import oracle.adf.view.faces.bi.event.MapSelectionEvent;</span>
<span style="font-family: "Courier New",Courier,monospace;">public class ShopSelectionBean implements Serializable {</span>
<span style="font-family: "Courier New",Courier,monospace;"> List m_collection = null;</span>
<span style="font-family: "Courier New",Courier,monospace;"> </span>
<span style="font-family: "Courier New",Courier,monospace;"> public ShopSelectionBean() {</span>
<span style="font-family: "Courier New",Courier,monospace;"> }</span>
<span style="font-family: "Courier New",Courier,monospace;"> public void ProcessSelection(MapSelectionEvent mapSelectionEvent) {</span>
<span style="font-family: "Courier New",Courier,monospace;"> Iterator iter;</span>
<span style="font-family: "Courier New",Courier,monospace;"> iter = mapSelectionEvent.getIterator();</span>
<span style="font-family: "Courier New",Courier,monospace;"> if (m_collection == null)</span>
<span style="font-family: "Courier New",Courier,monospace;"> m_collection = new LinkedList();</span>
<span style="font-family: "Courier New",Courier,monospace;"> m_collection.clear();</span>
<span style="font-family: "Courier New",Courier,monospace;"> </span>
<span style="font-family: "Courier New",Courier,monospace;"> while (iter.hasNext())</span>
<span style="font-family: "Courier New",Courier,monospace;"> {</span>
<span style="font-family: "Courier New",Courier,monospace;"> DataContent dt = (DataContent) iter.next();</span>
<span style="font-family: "Courier New",Courier,monospace;"> String locationName = dt.getLocationName();</span>
<span style="font-family: "Courier New",Courier,monospace;"> Double[] values = dt.getValues();</span>
<span style="font-family: "Courier New",Courier,monospace;"> </span>
<span style="font-family: "Courier New",Courier,monospace;"> if (mapSelectionEvent.getSelectionMode().equals(MapSelectionEvent.SELECTIONMODE_SELECTED))</span>
<span style="font-family: "Courier New",Courier,monospace;"> {</span>
<span style="font-family: "Courier New",Courier,monospace;"> String displayData = locationName;</span>
<span style="font-family: "Courier New",Courier,monospace;"> if (values == null || values.length <= 0) {</span>
<span style="font-family: "Courier New",Courier,monospace;"> } else </span>
<span style="font-family: "Courier New",Courier,monospace;"> {</span>
<span style="font-family: "Courier New",Courier,monospace;"> displayData = displayData + ":" + values[0].toString();</span>
<span style="font-family: "Courier New",Courier,monospace;"> }</span>
<span style="font-family: "Courier New",Courier,monospace;"> m_collection.add(displayData); </span>
<span style="font-family: "Courier New",Courier,monospace;"> </span>
<span style="font-family: "Courier New",Courier,monospace;"> System.out.println(locationName);</span>
<span style="font-family: "Courier New",Courier,monospace;"> }</span>
<span style="font-family: "Courier New",Courier,monospace;"> } </span>
<span style="font-family: "Courier New",Courier,monospace;"> } </span>
<span style="font-family: "Courier New",Courier,monospace;"> public List getData(){</span>
<span style="font-family: "Courier New",Courier,monospace;"> return m_collection;</span>
<span style="font-family: "Courier New",Courier,monospace;"> }</span>
<span style="font-family: "Courier New",Courier,monospace;"> } </span></span></pre>B. Fischer-Waselshttp://www.blogger.com/profile/02019839104452667248noreply@blogger.com0tag:blogger.com,1999:blog-37368355.post-30544217783582041432011-10-27T16:11:00.000+02:002012-03-13T14:25:28.361+01:00ADF hilft Fusion Bottle & Co Getränkemärkte gegen Freibier<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><b>Mein Vortrag von der DOAG Konferenz 2011:<br /><br />Karten in Java Anwendungen einbinden - ADF und Oracle Maps</b></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
</div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><b>Herausforderung:</b></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">"Fusion Bottle & Co" will expandieren... wo sollen die nächsten Getränkemärkte gebaut werden?</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Wir wollen das Management der Firma bei der Entscheidung durch aussagekräftiges Kartenmaterial und Marktdaten unterstützen.</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><b>Umsetzung:</b></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Ziel soll es sein, mittels JDeveloper und ADF eine Karte in die Anwendung zu zaubern, die auf Oracle Spatial bzw. Oracle Mapviewer/Oracle Maps basiert. Ich werde Marktdaten der <a href="http://www.gfk-geomarketing.de/ls_en_oracle">GfK Marketing</a> zu Hilfe nehmen. Wir wollen die Bier-/ Wein-Konsumdaten bzw. die dahinter steckende Kaufkraft in Deutschland im Verhältnis zur Bevölkerung bzw. Bevölkerungsdichte anschauen können..., um zu entscheiden, wo wir für Fusion Bottle & Co noch einen Getränkemarkt hinbauen sollten - und endlich unser Freibier bekommen...(;-).</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">So wird das Ergebnis aussehen:</span></div>
<div class="separator" style="clear: both; font-family: Arial,Helvetica,sans-serif; text-align: center;">
<span style="font-size: small;"><a href="http://2.bp.blogspot.com/-iitfWEzyqOs/TsELll9l_KI/AAAAAAAAEts/GbKzZ4cCjtc/s1600/ColorMapTheme_GFK_Germany_Purchasing_power_beer.GIF" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="240" src="http://2.bp.blogspot.com/-iitfWEzyqOs/TsELll9l_KI/AAAAAAAAEts/GbKzZ4cCjtc/s400/ColorMapTheme_GFK_Germany_Purchasing_power_beer.GIF" width="400" /></a></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"> </span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
</div>
<div style="font-family: Arial,Helvetica,sans-serif;">
</div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-size: small;">1. Welche Komponenten brauchen wir?</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">- Oracle <a href="http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html" target="_blank">Datenbank</a> (10g, 11g)<br />- Oracle <a href="http://www.oracle.com/technetwork/middleware/mapviewer/overview/index.html" target="_blank">Mapviewer</a>, Mapbuilder (optional)<br />- Oracle <a href="http://www.oracle.com/technetwork/middleware/ias/downloads/wls-main-097127.html" target="_blank">Weblogic Server</a> oder Oracle AS (OC4J) mit <a href="http://www.oracle.com/technetwork/middleware/mapviewer/overview/index.html" target="_blank">Quickstart Kit</a><br />- Kartendaten bzw. demografische Daten (hier: <a href="http://www.gfk-geomarketing.de/ls_en_oracle" target="_blank">von GFK Marketing</a>)<br />- <a href="http://www.oracle.com/technetwork/developer-tools/jdev/downloads/index.html" target="_blank">JDeveloper 11g</a></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">2. Vorgehensweise</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small; font-weight: bold;">Step 1:</span><span style="font-size: small;"> Zunächst installiere ich eine </span><span style="font-size: small; font-weight: bold;">Oracle Datenbank 11g </span><span style="font-size: small;">- Editon egal, XE tut es auch.</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small; font-weight: bold;">Step 2:</span><span style="font-size: small;"> Danach besorge ich mir </span><span style="font-size: small; font-weight: bold;">Karten und Marktforschungsdaten von <a href="http://www.gfk-geomarketing.de/ls_en_oracle" target="_blank">GfK Marketing</a>.</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small; font-weight: bold;"><br />Step 3:</span><span style="font-size: small;"> Danach </span><span style="font-size: small; font-weight: bold;">importiere ich</span><span style="font-size: small;"> die </span><span style="font-size: small; font-weight: bold;">GFK Marketing Demodaten</span><span style="font-size: small;"> mittels "Load_DE_2010.sql" und gemäß des ReadME.txt</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small; font-weight: bold;"><br />Step 4: <a href="http://www.oracle.com/technetwork/middleware/mapviewer/downloads/index.html" target="_blank">Mapviewer</a> - ich download</span><span style="font-size: small;"><b>e</b> den aktuellen Mapviewer, Mapbuilder und das Mapviewer Quickstart Kit (OC4J inkl. Mapviewer installiert) - benötigt wird noch ein aktuelles JDK - recommended JDK 6.</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small; font-weight: bold;"><br />Step 5: Mapviewer Quickstart-Kit</span><span style="font-size: small;"> unzippen und mittels start.bat oder start.sh starten, nachdem die Verzeichnisstruktur im start-Batchfile angepasst wurde.</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Während des Startvorgangs werden wir aufgefordert, für den Standart-Administrator "OC4JAdmin" ein Passwort zu vergeben.(z.B. Oracle 123).., welches wir uns bitte merken (aufschreiben!!!(;-)</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small; font-weight: bold;"><br />Step 6: Mapviewer konfigurieren</span><span style="font-size: small;"> - um das in der Datenbank liegende Kartenmaterial nutzen zu können, muss die Datenbank Connection angepasst werden.</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Dazu rufen wir den Mapviewer im Browser auf:</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">http://localhost:8888/mapviewer (wir werden weitergeleitet zur Startseite).</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Auf der Mapviewer Startseite klicken wir oben rechts den Link "ADMIN" und gelangen auf die Login-Seite: User: OC4JAdmin, Passwort: Oracle 123</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Linker Hand im Menue: Manage Mapviewer klicken wir auf "Configuration".</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Hier erscheint ein Editor für die </span><span class="x6" id="_id3:_id17" style="font-size: small;">"mapViewerConfig.xml"</span><span style="font-size: small;"> - wir scrollen bis zum Ende nach unten...</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Dort finden sich die </span><span style="font-size: small; font-style: italic;">permanenten</span><span style="font-size: small;"> Einträge für die DB connections:</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">(möglicherweise auskommentiert - als bitte "scharf schalten" und <--- bzw. --> rausnehmen.</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;"><map_data_source name="MVDEMO"</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">jdbc_host="localhost"</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">jdbc_sid="xe"</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">jdbc_port="1521"</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">jdbc_user="mvdemo"</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">jdbc_password="BBZwqpVvIIOAUp6UlVxgBQdri7Z6VvtW"</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">jdbc_mode="thin"</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">number_of_mappers="3"</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">allow_jdbc_theme_based_foi="true"</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">/></span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">Wir kopieren uns am Besten diesen Block und passen ihn an wie folgt:</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;"><map_data_source name="GFK-Daten"</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">jdbc_host="localhost"</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">jdbc_sid="xe"</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">jdbc_port="1521"</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">jdbc_user="GFK"</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">jdbc_password="!gfk"</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">jdbc_mode="thin"</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">number_of_mappers="3"</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">allow_jdbc_theme_based_foi="true"</span></div>
<div style="font-family: "Courier New",Courier,monospace;">
<span style="font-size: small;">/></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Dann unten: Save & Restart klicken - eine positive Bestätigung sollte oben auf der Seite erscheinen.</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small; font-style: italic;">Tipp zum Quickstart-Kit:</span><span style="font-size: small;"> Sollte im nächsten Schritt keine Verbindung zur DB angezeigt werden, bitte Passwort überprüfen/anpassen. Es sind nur "kleingeschriebene" Passwörter zulässig im Quickstart-Kit 10g. - oder Treiber aktualisieren - aber Passwort anpassen auf SQL Ebene geht schneller (SQL-Plus: connect as SYS as SYSDBA, dann</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">SQL-plus>alter user gfk identified by gfk; ) - bei mir war der GFK Account (=Schema) "gelockt"... dann:</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">SQL-plus>alter user gfk identified by gfk account unlock;</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Wenn wir dann auf "Datasources" klicken erscheinen die Datasources und "GFK-Daten" sollte dabeisein:</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><a href="http://3.bp.blogspot.com/-DD1ZmWD-2Bg/TgCwn3U17vI/AAAAAAAAD60/62MrSngG8V0/s1600/MV_Admin_datasources.GIF"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5620686533871136498" src="http://3.bp.blogspot.com/-DD1ZmWD-2Bg/TgCwn3U17vI/AAAAAAAAD60/62MrSngG8V0/s400/MV_Admin_datasources.GIF" style="cursor: pointer; height: 103px; width: 400px;" /></a></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small; font-weight: bold;">Step 7: GFK-Germany Basemap erzeugen</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Wir gehen im Mapviewer Admin Menue zu: </span><span style="font-size: small; font-style: italic;">Manage Map Tile Layers</span><span style="font-size: small;"> und klicken links </span><span style="font-size: small; font-style: italic;">Create</span><span style="font-size: small;"> --> Internal (eine interne, auf unserem Server liegende Karte ; external wäre: WebMapService) --> Continue --></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Name: GfK-Germany</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Datasource: GFK</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Base-Map: Germany</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">- alle anderen default Werte können wir so übernehmen; fertig ist die Karte im Mapviewer.</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Zum Überprüfen: Wiede im Menue: </span><span style="font-size: small; font-style: italic;">Manager Map Tile Layer</span><span style="font-size: small;"> links </span><span style="font-size: small; font-style: italic;">Manage </span><span style="font-size: small;">anklicken.</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">In der Übersicht erscheint unsere GfK-Germany Karte</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">--> Checkbox selektieren --> </span><span style="font-size: small; font-style: italic;">View Map - manage Tiles </span><span style="font-size: small;"> anklicken.</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Es erscheint das Karten Test UI - die Karte erscheint, nachdem wir den Button </span><span style="font-size: small; font-style: italic;">Show Map</span><span style="font-size: small;"> anklicken und 2x Doppelklick auf die Karten (zum Vergrössern):</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><a href="http://2.bp.blogspot.com/-anHpvIwK2Jk/TgGnfzdHAzI/AAAAAAAAD7E/9Fec5gBY0jg/s1600/MV_Admin_Karten_test_Ui.GIF"><img alt="" border="0" id="BLOGGER_PHOTO_ID_5620957974765175602" src="http://2.bp.blogspot.com/-anHpvIwK2Jk/TgGnfzdHAzI/AAAAAAAAD7E/9Fec5gBY0jg/s400/MV_Admin_Karten_test_Ui.GIF" style="cursor: pointer; height: 293px; width: 400px;" /></a></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;">Die Basemap zur Nutzung in ADF/JDeveloper ist fertig.</span></div>
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><b>Step 8 -</b> <b>Anwendung
erstellen:</b></span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />Nach dem <a href="http://www.oracle.com/technetwork/developer-tools/jdev/downloads/index.html" target="_blank">JDeveloper Download</a> starten wir den JDeveloper 11g (11.1...)<br /><br />
</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">1.
Application anlegen vom Typ: Fusion Web App - Name: FusionMapApp -->
alles default --> Finish</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />
</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><b>Entity
Objekte erstellen (Verbindung zu Tabellen/DB):</b></span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />
</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">2. -->
"model" --> New --> "Business Tier" -->
"ADf Bus. Components" --> "Business Components from
Tables" </span>
</div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />
</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">3.
Connection zu DB (XE) User/Passwort gfk/gfk</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />
</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">4.
DE_COUNTIES2010 als Tabelle für "Entity Object" und "View
Objekt" nutzen</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />
</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<b><span style="font-size: small;">Seite
erstellen:</span></b></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />
</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">5. -->
Viewcontroller --> New --> Webtier --> JSF/Facelets -->
Page --> Name anpassen --> Quickstart Layout --> Browse </span>
</div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">-->
Two Columns --> Layout mit 2 übereinanderliegenden Regionen
auswählen.</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />
</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><b>Karte
einbinden:</b></span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />
</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">6. Karte
auf "First" (obere Region) ziehen: --> Component Palette
--> "ADF Data Visualizations" auswählen --> Map </span>
</div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">-->
"Geographic Map" auf "first"(obere)-Region
ziehen.</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />
</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">7.
Karten-Wizard: Name eingeben: "Mapviewer" - url für
Mapviewer eingeben (standard: http://localhost:8888/mapviewer)</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">7a.
Mapviewer starten</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">7b.
Authentication: "Basic" auswählen - user: gfk - pwasswort:
gfk (muss natürlich mit dem Schema korrespondieren)</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">7c.
Connection Testen : Success! --> OK</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">7d.
"BaseMap" auswählen und durch Doppelklick positionieren
bzw. Zoom Level (Schieberegler) einstellen --> OK</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />
</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">8. Layer
auf der Karte einbinden: --> "DataControls" (refresh!)
--> DECOUNTIES2010View1 auswählen und auf Karte ziehen.</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">8a.
Start "Layer Wizard" --> Layer/Theme Typ "Color
Theme" auswählen</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">8b.
ThemeID: (sieht der User!) Name: "Kaufkraft Bier in Euro
p/Person" </span><br />
<span style="font-size: small;">--> Map Theme --> Name: DECounties2010
auswählen </span>
</div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">-->
Location Column: Name Ascii</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">-->
Appearance/Buckets: Werte übernehmen </span>
</div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">-->
Data: Location "Name Ascii"</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">--------->
Location Label: "Name Ascii"</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">--------->
Location Value: "Nr0121e"</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">--------->
Location Data Label: "Kaufkraft Bier"</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">Wichtig!
--> (x) "Enable Row Selection" anklicken !</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">-->
OK - Layer fertig (sieht man auf Karte nicht - nur im Structure Pane
unter "map" (links unten)</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />
</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">9.
Details synchron zum Layer in unterer Region anzeigen:</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">-->
DataControls --> DECOUNTIES2010View1 auf die untere (second
facelet) ziehen</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">aus dem
Kontext Menü "Create" auswählen: "Form" -->
dann: "ADF Read-Only Form"</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">Der Form
Layout Wizard startet --> nur 2 Spalten des Entity Objekts
auswählen: "NameAscii" und "Nr.0122e" - </span>
</div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">die
anderen Spalten löschen --> OK</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">9a.
(optional) Label "Nr.0121e" anklicken und im Property
Inspector (rechts unten) </span>
</div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">bei
"Common" --> Label: umbenennen in: "Kaufkraft für
Bier pro Person in Euro:"</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />
</span></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">Ergebnis im JDeveloper 11g:</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-NudFBKwcEp0/TsEP5WonjiI/AAAAAAAAEt0/xoL4AcF3Sxs/s1600/JDEV_screenshot_map.GIF" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="301" src="http://3.bp.blogspot.com/-NudFBKwcEp0/TsEP5WonjiI/AAAAAAAAEt0/xoL4AcF3Sxs/s400/JDEV_screenshot_map.GIF" width="400" /></a></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />
</span></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />
</span></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />
</span></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />
</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<br /></div>
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">10.
Anwendung testen: mit rechte Maustaste auf die Seite klicken -->
Kontextmenü --> Run (grüner Pfeil)</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">Falls
der Weblogic Server noch nicht gestartet wurde, startet er jetzt und
"deployed" die Anwendung </span>
</div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">optional:
unten Tab "Deployment" anklicken und Fortschritt
beobachten.</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">wenn
Anwendung fertig deployed, öffnet der Default Browser mit der
Anwendung - oder man klickt auf den angebotenen Link.</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />
</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;">11. Beim
Klicken auf die Regionen in der Karte, sollten "Name" und
"Nr121e" (Kaufkraft Bier) synchron angezeigt werden.</span><br />
<br />
<span style="font-size: small;">Edit 28.11.2011: <br />Ich habe ein <a href="http://oracle.fewo-jever-barbara-schmidt.de/adfmaps/adfmaps01_viewlet_swf.html" target="_blank">kommentiertes Viewlet</a> erstellt zur besseren Illustration und Erklärung der Architektur. </span><br />
<span style="font-size: small;"> </span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif; margin-bottom: 0cm;">
<span style="font-size: small;"><br />
</span></div>
<span style="font-family: Arial,Helvetica,sans-serif; font-size: small;">
</span><br />
<div style="font-family: Arial,Helvetica,sans-serif;">
<span style="font-size: small;"><br /></span></div>B. Fischer-Waselshttp://www.blogger.com/profile/02019839104452667248noreply@blogger.com1tag:blogger.com,1999:blog-37368355.post-29363609193679629632011-09-07T08:04:00.001+02:002012-03-13T14:24:28.056+01:00Oracle Maps und Spatial mit ADF - How To presentation auf DOAG Konferenz 15.-17. Nov. 2011Auf der diesjährigen <a href="http://www.doag.org/konferenz/doag/2011/">DOAG Konferenz (15.-17.11.11 in Nürnberg)</a> werde ich einen Vortrag halten zum Thema "Oracle Maps (Spatial) - Karten in Java Anwendungen: How to... (ADF)" (am 3. Tag - 14h) schaut gerne vorbei !<br />
<br />
Im "Abstract" habe ich in der <i><b>Einleitung</b></i> geschrieben:<br />
<br />
Daten-Visualisierungs-Komponenten (Grafiken, Karten) können mittels ADF im JDeveloper 11g bereits<br />
mit wenigen Mausklicks eingebunden werden.<br />
Wie das speziell mit geografischen Karten basierend auf der Spatial Technologie und Oracle Maps<br />
funktioniert, soll in diesem Beitrag vorgestellt werden.<br />
Die beispielhafte Darstellung von Marketing Daten wird den Vortrag abrunden wie: Kaufkraft,<br />
Einwohnerdichte, Konsumenten pro Region.<br />
<br />
Das<i><b> Ergebnis</b></i> sieht so aus (kleiner Vorgeschmack):<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://2.bp.blogspot.com/-g1BkPqhvryw/TmcI9cNJf7I/AAAAAAAAEdg/5bse_4R-OXs/s1600/ColorMapTheme_GFK_Germany_Purchasing_power_beer.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="384" src="http://2.bp.blogspot.com/-g1BkPqhvryw/TmcI9cNJf7I/AAAAAAAAEdg/5bse_4R-OXs/s640/ColorMapTheme_GFK_Germany_Purchasing_power_beer.GIF" width="640" /></a></div>
<br />
<br />
Für diejenigen, "die arbeiten müssen" (;-(, werde ich eine Nachlese des How To's <a href="http://oracle-maps.blogspot.com/2011/10/adf-hilft-fusion-bottle-co.html" target="_blank">hier veröffentlichen</a>...<br />
<br />
Zum Thema "<i><b>Die Konferenz rockt</b></i>" gibt es übrigens auf der DOAG Party coole Acts!<br />
<br />
<br />
Die DOAG schreibt: Am Mittwoch, 16. November 2011, sorgen Rolf Stahlhofen und Freunde für
einen unvergesslichen Abendevent. Der frühere Frontmann der Söhne
Mannheims präsentiert ein musikalisches Programm, das keine Wünsche
übrig lässt und sorgt mit PopSoul, Funk-und Rockeinflüssen für beste
Stimmung. An seiner Seite sind dieses Jahr der Entertainer Max Mutzke
sowie die ehemalige Gesangspartnerin von Mousse T. Emma Lanford zu
hören.<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="http://3.bp.blogspot.com/-YkFXU1Jz9NQ/TmcH0w84CEI/AAAAAAAAEdc/piCJzuaHleE/s1600/doag_rockt.GIF" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="http://3.bp.blogspot.com/-YkFXU1Jz9NQ/TmcH0w84CEI/AAAAAAAAEdc/piCJzuaHleE/s320/doag_rockt.GIF" width="319" /></a></div>B. Fischer-Waselshttp://www.blogger.com/profile/02019839104452667248noreply@blogger.com0tag:blogger.com,1999:blog-37368355.post-56929672731581616012011-08-18T13:38:00.006+02:002011-08-30T09:11:14.760+02:00Messstellen-Verwaltung in der WasserwirtschaftDas Landesamt für Umwelt, Wasserwirtschaft und Gewerbeaufsicht Rheinland-Pfalz in Mainz, Deutschland (<a href="http://www.blogger.com/www.luwg.rlp.de">www.luwg.rlp.de</a>) hat bereits im letzten Jahr eine Anwendung für eine kartengestützten Messstellen-Verwaltung in Dienst genommen (AKSMS.web – Zentrales Auskunftssystem für unterschiedlichste Anforderungen) - es wurde mit großer Unterstützung des Oracle Partners <a href="http://www.blogger.com/www.gdv.com">GDV</a> entwickelt:
<br />
<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/-4wgwr0VVnSk/Tkz6ch95liI/AAAAAAAAEcM/a6X4EOoPsFU/s1600/AKSM1_NRW1.GIF"><img style="cursor:pointer; cursor:hand;width: 400px; height: 324px;" src="http://2.bp.blogspot.com/-4wgwr0VVnSk/Tkz6ch95liI/AAAAAAAAEcM/a6X4EOoPsFU/s400/AKSM1_NRW1.GIF" alt="" id="BLOGGER_PHOTO_ID_5642159801249666594" border="0" /></a>
<br />
<br />Es kamen APEX und Oracle Maps zum Einsatz.
<br />
<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/-yHmCRZ9RBvY/Tkz6c7fc2AI/AAAAAAAAEcU/awtx2vySc-8/s1600/AKSM1_NRW2.GIF"><img style="cursor:pointer; cursor:hand;width: 400px; height: 355px;" src="http://2.bp.blogspot.com/-yHmCRZ9RBvY/Tkz6c7fc2AI/AAAAAAAAEcU/awtx2vySc-8/s400/AKSM1_NRW2.GIF" alt="" id="BLOGGER_PHOTO_ID_5642159808101275650" border="0" /></a>
<br />
<br />Eine ausführliche Beschreibung als "<a href="http://www.oracle.com/us/corporate/customers/rheinland-service-snapshot-322039-de.pdf">Case Study" wurde dazu auf Oracle.com</a> veröffentlicht.
<br />Wer näheres erfahren möchte, lese bitte obigen Artikel.
<br />
<br />
<br />
<br />
<br />
<br />B. Fischer-Waselshttp://www.blogger.com/profile/02019839104452667248noreply@blogger.com0tag:blogger.com,1999:blog-37368355.post-63070505407049932102011-08-12T08:56:00.002+02:002011-08-12T09:01:28.320+02:00Aus Länge/Breite mache SDO_GEOMETRYImmer wieder mal angefragt und bei LJ gefunden:
<br />
<br />Ich halte derzeitig die Lokationen (von Kunden, Lagerhäusern, etc.) in einer Tabelle in 2 separaten Spalten: Länge und Breite - nun möchte ich diese aber "Spatial adequat" nutzen und in meiner SDO_GEOMETRY Spalte haben.
<br /><a href="http://oraclemaps.blogspot.com/2009/10/displaying-table-of-longitude-and.html">So geht es - beschrieben von LJ Qian</a>, dem Chefentwickler von Oracle Maps. Danke LJ! (auch wenn er deutsch nicht versteht! (;-) )
<br />Ich hoffe es hilft dem einen oder anderen . Viel Spass damit!
<br />B. Fischer-Waselshttp://www.blogger.com/profile/02019839104452667248noreply@blogger.com0tag:blogger.com,1999:blog-37368355.post-59549588404947314112011-06-20T19:42:00.013+02:002011-06-21T09:54:42.031+02:00BI und Oracle MapsEine sehr ausführliche Zusammenstellung der Integrationsmöglichkeit - ohne Programmierung - der <a href="http://www.rittmanmead.com/files/biforum2011/Heljula_Spatial.pdf">Oracle BI Suite EE und Oracle Maps/Spatial ist kürzlich als PDF</a> (7,9 MB) vom Oracle Partner <a href="http://www.peakindicators.com">Peak Indicators Limited</a> veröffentlicht worden.<br />Ich wollte es Euch nicht vorenthalten.<br />Auch Basisfunktionen von Oracle Spatial werden zum besseren Verständnis erläutert.<br /><br />Solch Funktionen sind möglich und werden ausführlich beschrieben:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://2.bp.blogspot.com/-G--Ou8sCWZ0/Tf-H6suewzI/AAAAAAAAD6s/R63hQC7mDSk/s1600/Beispiel_Dashboard.GIF"><img style="cursor:pointer; cursor:hand;width: 500px; height: 307px;" src="http://2.bp.blogspot.com/-G--Ou8sCWZ0/Tf-H6suewzI/AAAAAAAAD6s/R63hQC7mDSk/s400/Beispiel_Dashboard.GIF" border="0" alt=""id="BLOGGER_PHOTO_ID_5620360302489944882" /></a>B. Fischer-Waselshttp://www.blogger.com/profile/02019839104452667248noreply@blogger.com0tag:blogger.com,1999:blog-37368355.post-7055320822800978402011-02-23T13:41:00.003+01:002011-02-23T13:43:07.267+01:00Treffen der DOAG SIG Spatial in Potsdam<div>Am 15. März trifft sich die <a href="https://mydoag.doag.org/termine/termine.php?tid=417338" target="_blank">DOAG SIG Spatial</a> in Potsdam. Auf der Agenda stehen interessante Themen wie <b>OpenStreetMap-Daten in Oracle</b>, <b>Geodaten und XML</b>, <b>Tipps & Tricks</b>, <b>Netzwerke und Routing</b>.</div><br /><div>Und darüber hinaus steht natürlich das Kennenlernen und Networking im Vordergrund; ein wichtiger Termin der deutschsprachigen Oracle-Spatial-Community, den man sich nicht entgehen lassen sollte ... </div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-37368355.post-61199528887384630242011-02-17T14:03:00.005+01:002011-02-17T14:07:54.835+01:00Dashboard ExamplesThe <a href="http://www.directionsmag.com/articles/out-of-the-box-spatial-dashboards-improve-utility-outage-decisions/164444">Directions Magazine </a>has published an <a href="http://www.directionsmag.com/articles/out-of-the-box-spatial-dashboards-improve-utility-outage-decisions/164444">article</a> with Dashboards based on Oracle Maps - one looks as follows:<br /><br /><a href="http://1.bp.blogspot.com/-homx7VQ3e_k/TV0dTBLlfFI/AAAAAAAADj4/g_y8bR_zj_c/s1600/outage2_lg.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 261px;" src="http://1.bp.blogspot.com/-homx7VQ3e_k/TV0dTBLlfFI/AAAAAAAADj4/g_y8bR_zj_c/s400/outage2_lg.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5574644126326291538" /></a><br /><br />Feel free to look into the <a href="http://www.directionsmag.com/articles/out-of-the-box-spatial-dashboards-improve-utility-outage-decisions/164444">article </a>further .B. Fischer-Waselshttp://www.blogger.com/profile/02019839104452667248noreply@blogger.com0tag:blogger.com,1999:blog-37368355.post-53559481896971125872011-02-08T13:24:00.014+01:002011-03-03T09:08:09.685+01:00Oracle Maps mit ADF Data Visualisation components in JDeveloper 11gDie Funktionalitäten der "Map-Komponente" ist in JDeveloper 11g und ADF weiter ausgebaut worden.<br />Solche anspruchsvolle Anwendungen sind deklarativ möglich:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_8PXbvmaOB6M/TVE2bDPL_jI/AAAAAAAADjo/gB1F_I3AGqI/s1600/ADF_REA_MAps_warehouse_Screenshot.png"><img style="cursor:pointer; cursor:hand;width: 400px; height: 256px;" src="http://3.bp.blogspot.com/_8PXbvmaOB6M/TVE2bDPL_jI/AAAAAAAADjo/gB1F_I3AGqI/s400/ADF_REA_MAps_warehouse_Screenshot.png" border="0" alt=""id="BLOGGER_PHOTO_ID_5571294052387388978" /></a><br /><br />Ein <a href="http://download.oracle.com/otn_hosted_doc/jdeveloper/11gdemos/ADF_DVT_Geomap_Gauge_PivotTable_Runtime/ADFMapGaugePivotTableRuntime.htm">Demo dazu hier</a>.<br /><br />Dokumentation zu Karte und Point-Themes <a href="http://download.oracle.com/docs/cd/E12839_01/web.1111/b31973/dv_map.htm">here</a>. <br />Aus der "Component Palette" können neben ADF auch folgende "ADF Data Visualisation" Komponenten ausgewählt und auf den Designer Teil von JDeveloper gezogen werden:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/_8PXbvmaOB6M/TVE6W6cpD6I/AAAAAAAADjw/kYis6xX-RmQ/s1600/ADF_Dat_Visualisation_Comp_palette.png"><img style="cursor:pointer; cursor:hand;width: 144px; height: 400px;" src="http://4.bp.blogspot.com/_8PXbvmaOB6M/TVE6W6cpD6I/AAAAAAAADjw/kYis6xX-RmQ/s400/ADF_Dat_Visualisation_Comp_palette.png" border="0" alt=""id="BLOGGER_PHOTO_ID_5571298379354935202" /></a><br />Man kann deklarativ - also ohne Programmierung - eine Synchronisierung der obigen Komponenten mit der Karte herstellen... - wie ganz oben zu sehen - cool !<br /><br />Über das Point Theme war ich zunächst etwas "entsetzt", da offensichtlich nicht mit SDO_GEOMETRY der Spatial Technik gearbeitet wurde... - aber das trügt! <br />Es ist nur EINE Option von mehreren, wie mit den POI/FOIs umgegangen wird.<br />Der Point-Theme Wizard ermöglicht auch die Nutzung lediglich einer Adresse und nutzt den <a href="http://elocation.oracle.com/Geocoder">Oracle Geocoder Server</a> zur Errechnung von Länge/Breite für die Standorte - on the fly.<br />Man braucht lediglich eine Tabelle mit Adressen.<br />Testweise kann man obiges Beispiel erstellen ohne eigene Spatial/Mapviewer Infrastruktur, indem man bei Mapviewer und Geocoder den <a href="http://elocation.oracle.com">elocation.oracle.com</a> nutzt.<br /><br />Zum "Probieren" bietet sich die "berühmte" <a href="http://www.oracle.com/technetwork/developer-tools/jdev/index-095536.html">Fusion Order Demo</a> als "How To" an.<br />Die Einbindung der "DVTs" wird im <a href="http://st-curriculum.oracle.com/obe/jdev/obe11jdev/ps1/dvt_graph/gant_chart_pivot_table.htm#tv">st_curriculum</a> beschrieben.<br /><br />JDeveloper 11g Version 11.1.1.4:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/-fzYzb0foaNw/TWqy0zN8T2I/AAAAAAAADkQ/Zy-JSWJ1hmQ/s1600/Jdev_Map.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 242px;" src="http://4.bp.blogspot.com/-fzYzb0foaNw/TWqy0zN8T2I/AAAAAAAADkQ/Zy-JSWJ1hmQ/s400/Jdev_Map.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5578467708623408994" /></a><br /><br />Resultat im Browser:<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://4.bp.blogspot.com/-KzNI5weAbqU/TWqy1J1XthI/AAAAAAAADkY/02pHSyXkV8s/s1600/Jdev_Map_result.jpg"><img style="cursor:pointer; cursor:hand;width: 400px; height: 241px;" src="http://4.bp.blogspot.com/-KzNI5weAbqU/TWqy1J1XthI/AAAAAAAADkY/02pHSyXkV8s/s400/Jdev_Map_result.jpg" border="0" alt=""id="BLOGGER_PHOTO_ID_5578467714694362642" /></a><br /><br />Weiterführende Infos im <a href="http://download.oracle.com/docs/cd/E12839_01/web.1111/b31973/dv_map.htm#BEHECHJF">Oracle® Fusion Middleware Web User Interface Developer's Guide for Oracle Application Development Framework</a>.<br /><br />Viel Spass damit!B. Fischer-Waselshttp://www.blogger.com/profile/02019839104452667248noreply@blogger.com3tag:blogger.com,1999:blog-37368355.post-23420764081358758332011-01-10T09:07:00.002+01:002011-01-10T09:13:14.758+01:00Spatial Basics... - "How to insert Spatial Data"Eine gute ausführliche Dokumentation in Form eines "How To" über das "Befüllen" der Spatial Funktionalität ist auf <a href="http://wiki.oracle.com/page/Oracle+Spatial+Through+SQL+Developer+and+GeoRaptor">dieser Wiki Seite</a> zu finden. <br />Es wird zwar noch auf "Georaptor" Bezug genommen, aber diese "MapView" Funktionalität besteht jetzt ja auch direkt (ohne Plugin/Extension) im SQL Developer 3.0<br />Ist eigentlich "Basic Stuff" - aber für den einen oder anderen doch hilfreich (zumal in der Ausführlichkeit).B. Fischer-Waselshttp://www.blogger.com/profile/02019839104452667248noreply@blogger.com0tag:blogger.com,1999:blog-37368355.post-72350407785977886962011-01-03T09:45:00.000+01:002011-01-03T09:45:29.549+01:00Alles Gute für das Jahr 2011 ...... wünschen wir unseren Blog-Leserinnen und Lesern, allen aktuellen und zukünftigen Oracle Kunden und Partnern.<br />
<br />
Ihr Oracle Spatial Team<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="http://4.bp.blogspot.com/_cX3XTYGgOqY/TSGMPxb9NZI/AAAAAAAAAAo/x7b1M4or1us/s1600/CIMG6151_halfsize.gif" imageanchor="1" style="clear:left; float:left;margin-right:1em; margin-bottom:1em"><img border="0" height="240" width="320" src="http://4.bp.blogspot.com/_cX3XTYGgOqY/TSGMPxb9NZI/AAAAAAAAAAo/x7b1M4or1us/s320/CIMG6151_halfsize.gif" /></a></div>Karin Patengehttp://www.blogger.com/profile/07393355977167541886noreply@blogger.com0tag:blogger.com,1999:blog-37368355.post-34082302679157845042010-12-31T10:57:00.002+01:002010-12-31T11:10:59.618+01:00SQL Developer 3.0 EA with Mapview component<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="http://3.bp.blogspot.com/_8PXbvmaOB6M/TR2sKpg5JKI/AAAAAAAADjE/JghwT0wo6io/s1600/sqldeveloper_30map.png"><img style="cursor:pointer; cursor:hand;width: 400px; height: 271px;" src="http://3.bp.blogspot.com/_8PXbvmaOB6M/TR2sKpg5JKI/AAAAAAAADjE/JghwT0wo6io/s400/sqldeveloper_30map.png" border="0" alt=""id="BLOGGER_PHOTO_ID_5556786814187545762" /></a><br />The SQL Developer 3.0 is out as EA Early Adopter Release and you can <a href="http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html">download it from the official Oracle site</a>.<br />It now incorporates the MAPVIEW aka GEORAPTOR, which is a helpful component for map developers, as you can right away see, if the tables with the SDO_GEOMETRY column do work properly and if your data is consistent.<br />Good Luck ! - also for 2011 !!B. Fischer-Waselshttp://www.blogger.com/profile/02019839104452667248noreply@blogger.com1