OraFAQ Forum: Spatial » Problem when Loading ESRI Shapefiles into Spatial

Home » Server Options » Spatial » Problem when Loading ESRI Shapefiles into Spatial (Oracle 10g , CentOS)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem when Loading ESRI Shapefiles into Spatial [message #516544]

Tue, 19 July 2011 03:41

ntt85
Messages: 34
Registered: July 2011
Location: vietnam

Member

Hi all,

I have shapefiles need to load data to Oracle Spatial.
Because of I am using Oracle 10g, I set clpath is : /opt/oracle/102/jdbc/lib/ojdbc14.jar:/opt/oracle/102/md/lib/sdoutl.jar:/opt/oracle/102/md/lib/sdoapi.jar.
Then:

Code: [Select all] [Show/ hide]

java -cp $clpath oracle.spatial.util.SampleShapefileToJGeomFeature -h [server-name] -p [port] -s [sid] -u [user] -d [pass] -t ranhgioi_polyline -f /opt/oracle/shape/ranhgioi_polyline -r 8307 -g geom

The screen display:

Code: [Select all] [Show/ hide]

Parameters:
<Filename>: File name of an input Shapefile (without extension)
<Table name>: Table name for the result
[SRID]: Valid Oracle SRID for coordinate system; use 0 if unknown
<ID Column name>: Column name for unique numeric ID; if required

Could you help me load that shapefile to oracle.Many thanks.

[Updated on: Tue, 19 July 2011 03:43]

Report message to a moderator

Previous Topic:	error while updating SRID to null
Next Topic:	How to determine a point is inside a polygon area?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 13:32:14 CDT 2025