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
License
GNU Library or Lesser General Public License version 2.0 (LGPLv2)Follow PL/SQL ESRI Shape & dBase Converter
Other Useful Business Software
AI-powered service management for IT and enterprise teams
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.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of PL/SQL ESRI Shape & dBase Converter!