[mapserver-users] maporaclespatial

[Joel D. Schlagel]

Andries

you can download the shp2sdo program from

http://otn.oracle.com/software/products/spatial/content.html

to access the page you need to sign up for an oracle tech net account, but
its free.

the utility is available for solaris and nt.

the format for oracle spatial geometry types changed from a 1 digit to a
four digit code, shp2sdo still output the one digit geometry code, while
maporaclespatial needs the four digit code.

e.g.

sed 's/3|1|3|1|/2003|1|3|1|/g'  vt_cty_P.dat > vt_cty_Px.dat

then use sqlloader to load

-----Original Message-----
From: owner-mapserver-users at lists.gis.umn.edu
[mailto:owner-mapserver-users at lists.gis.umn.edu]On Behalf Of Andries J.
Algera
Sent: Friday, November 16, 2001 12:04 PM
To: mapserver-users at lists.gis.umn.edu
Subject: Re: [mapserver-users] maporaclespatial



Great to read that oracle spatial is working with mapserver. I'd like to
do some tests, but haven't been able to find the shp2sdo utility in the
oracle in the oracle distributions we have over here.

Anyone out there knows where to find it?

Thanks,

Andries

On Wed, 14 Nov 2001, Joel Schlagel wrote:

>
> we used oracle shp2sdo utility to convert shape files to oracle
> loader format.
>
>

--------------------------------------------------------------------
Andries Algera
CSR - IBAMA
SAIN L4, Lote 4, Ed. IBAMA Sede
70800.200  Brasilia / DF
BRASIL
ph: +5561 316-1326
          316-1453
fax:+5561 223-7108
--------------------------------------------------------------------