This PL/SQL package converts a query with a sdo_geometry into an ESRI shape file and a shape file into a Oracle table. It can also convert a Oracle table into a dBase file and vice versa.

Sample 1 - create a shape file (alk.shp, alk.shx, alk.dbf) of type 5 (=Polygon) from table MYTABLE with sdo-column="geo" and SDO_GTYPE=3003:
select zvk_shape.write_shp('DATA_PUMP_DIR','alk',
'select t.C01 "NAME",
t.C20 "FLST",
t.GEO
from MYTABLE t
where t.C02 = ''ALK''
order by t.C01','GEO',5) "alk" FROM dual;

Features

  • Convert sdo_geometry from 2D to 3D and vice versa
  • Convert sdo_geometry from line to area and vice versa
  • Create shape file from oracle query
  • Read shape file into sdo_geometry

Project Activity

See All Activity >

License

GNU Library or Lesser General Public License version 2.0 (LGPLv2)

Follow PL/SQL ESRI Shape & dBase Converter

PL/SQL ESRI Shape & dBase Converter Web Site

Other Useful Business Software
AI-powered service management for IT and enterprise teams Icon
AI-powered service management for IT and enterprise teams

Enterprise-grade ITSM, for every business

Give your IT, operations, and business teams the ability to deliver exceptional services—without the complexity. Maximize operational efficiency with refreshingly simple, AI-powered Freshservice.
Try it Free
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of PL/SQL ESRI Shape & dBase Converter!

Additional Project Details

Languages

English, German

Intended Audience

Developers

Programming Language

PL/SQL

Database Environment

Oracle

Related Categories

PL/SQL Database Software, PL/SQL Database Engines Servers

Registered

2015-02-20