<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=utf-8">
<META content="MSHTML 6.00.2900.5512" name=GENERATOR>
<STYLE>@font-face {
font-family: 宋体;
}
@font-face {
font-family: Verdana;
}
@font-face {
font-family: @宋体;
}
@page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; layout-grid: 15.6pt; }
P.MsoNormal {
TEXT-JUSTIFY: inter-ideograph; FONT-SIZE: 10.5pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; TEXT-ALIGN: justify
}
LI.MsoNormal {
TEXT-JUSTIFY: inter-ideograph; FONT-SIZE: 10.5pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; TEXT-ALIGN: justify
}
DIV.MsoNormal {
TEXT-JUSTIFY: inter-ideograph; FONT-SIZE: 10.5pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; TEXT-ALIGN: justify
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
FONT-WEIGHT: normal; COLOR: windowtext; FONT-STYLE: normal; FONT-FAMILY: Verdana; TEXT-DECORATION: none; mso-style-type: personal-compose
}
DIV.Section1 {
page: Section1
}
UNKNOWN {
FONT-SIZE: 10pt
}
BLOCKQUOTE {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 2em
}
OL {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
UL {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
</STYLE>
</HEAD>
<BODY style="FONT-SIZE: 10pt; MARGIN: 10px; FONT-FAMILY: verdana">
<DIV><FONT face=Verdana color=#000080 size=2>thanks! but I think that the method
you mentioned will depress the performance, for example, when using the
python <FONT
color=#000000>driver.CreateCopy(source, "geor:user/pwd@db,tab,col", <create options>),
in fact it will use the gdal_translate function. And the performance
of PL/SQL will exceed the gdal_translate. so I want to use cx_Oracle, but I
don't know how to use PL/SQL by cx_Oracle.</FONT></FONT></DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV><FONT face=Verdana color=#c0c0c0 size=2>2009-12-21 </FONT></DIV><FONT
face=Verdana color=#000080 size=2>
<HR style="WIDTH: 100px" align=left color=#b5c4df SIZE=1>
</FONT>
<DIV><FONT face=Verdana color=#c0c0c0 size=2><SPAN>gispowerfan</SPAN>
</FONT></DIV>
<HR color=#b5c4df SIZE=1>
<DIV><FONT face=Verdana size=2><STRONG>发件人：</STRONG> Ivan </FONT></DIV>
<DIV><FONT face=Verdana size=2><STRONG>发送时间：</STRONG> 2009-12-21 02:11:53
</FONT></DIV>
<DIV><FONT face=Verdana size=2><STRONG>收件人：</STRONG> gispowerfan </FONT></DIV>
<DIV><FONT face=Verdana size=2><STRONG>抄送：</STRONG> gdal-dev </FONT></DIV>
<DIV><FONT face=Verdana size=2><STRONG>主题：</STRONG> Re: [gdal-dev] question
about georaster and python </FONT></DIV>
<DIV><FONT face=Verdana size=2></FONT> </DIV>
<DIV><FONT face=Verdana size=2>
<DIV>gispowerfan wrote:</DIV>
<DIV>> hi list,</DIV>
<DIV>> </DIV>
<DIV>> I have a question about georaster and python, it's maybe not related to </DIV>
<DIV>> GDAL code directly, but I think it is related question.</DIV>
<DIV>> Now I want to connect to ORACLE by cx_Oracle(which is Python interface to ORACLE), I can use cx_Oracle to create table,insert simple data, </DIV>
<DIV>> but can't run the image loader pl/sql, do anyone have any idea? I don't know whether or not that some image loader pl/sql can run by cx_Oracle? </DIV>
<DIV>> I know that I can use gdal python interface to connect Georaster, but I </DIV>
<DIV>> need to test the performance.</DIV>
<DIV>> thanks in advance.</DIV>
<DIV>> </DIV>
<DIV>> 2009-12-20</DIV>
<DIV>> ------------------------------------------------------------------------</DIV>
<DIV>> gispowerfan</DIV>
<DIV>> </DIV>
<DIV>> </DIV>
<DIV>> ------------------------------------------------------------------------</DIV>
<DIV>> </DIV>
<DIV>> _______________________________________________</DIV>
<DIV>> gdal-dev mailing list</DIV>
<DIV>> gdal-dev@lists.osgeo.org</DIV>
<DIV>> http://lists.osgeo.org/mailman/listinfo/gdal-dev</DIV>
<DIV></DIV>
<DIV>Example:</DIV>
<DIV></DIV>
<DIV> >>> from osgeo import gdal</DIV>
<DIV> >>> driver = gdal.GetDriverByName("georaster")</DIV>
<DIV> >>> source = gdal.Open("example.tif")</DIV>
<DIV> >>> target = driver.CreateCopy(source, "geor:user/pwd@db,tab,col", <create options>)</DIV>
<DIV> >>> target = None</DIV>
<DIV> >>> source = None</DIV>
<DIV></DIV>
<DIV>That would load the geotiff file to GeoRaster.</DIV>
<DIV></DIV></FONT></DIV></BODY></HTML>