Top 5 Recent Articles
ARTICLES CATEGORIES
- Algorithms (22)
- All (399)
- Biography (1)
- Blog (44)
- Business Requirements (1)
- Commentary (1)
- Conversion (2)
- Customers (2)
- Data Models (1)
- Education (2)
- GeoRaptor (13)
- GPS (1)
- Image Processing (2)
- Import Export (8)
- Licensing (2)
- LiDAR (1)
- Linear Referencing (4)
- Manifold GIS (3)
- Mapping (1)
- MySQL Spatial (7)
- Networking and Routing (including Optimization) (5)
- Open Source (18)
- Oracle Spatial and Locator (194)
- Partitioning (1)
- PostGIS (36)
- Projections (1)
- Published Articles (1)
- qGIS (1)
- Recommendations (1)
- Services (1)
- Software Change Log (1)
- Source Code (37)
- Space Curves (9)
- Spatial Database Functions (109)
- Spatial DB comparison (1)
- Spatial XML Processing (11)
- SQL Server Spatial (92)
- Standards (3)
- Stored Procedure (17)
- Tessellation or Gridding (10)
- Tools (2)
- Topological Relationships (1)
- Training (2)
- Triangulation (2)
New versions of PL/SQL packages uploaded
It has been a while (GeoRaptor took all my free/spare time) but I have uploaded a new version of the existing free PL/SQL packages to my website.
The changes include:
- Slow migration away from old Types eg VectorSetType to new types T_Vectors that are shared with other packages not in this zip file (GEOPROCESS, LINEAR, SDO_ERROR etc);
- Performance improvement of some critical functions cf GetVector;
- Addition of new functions eg GEOM.concatLines, GEOM.Polygon2Rectangle, GEOM.Rectangle2Polygon etc;
- Slow rationalisation/removal of old functions needed for 9i.
I have updated the Windows install.cmd file but NOT the install.sh as I do not have
a Linux/unix vm currently on my server (I am working on it but there is only me and I am doing all this Java and PL/SQL work AND GeoRaptor for SQL Developer in my own time!). If you compare the two you should be able to work out what has changed and make the relevant changes. If you do this, and get it to work, please send it to me via email for inclusion in the packages.
Finally, I have updated the installer so that it checks the schema into which you are installing the packages (if you chose not to let the installer create its own – which most DBAs do not like) has the required permissions. If you do not it will stop. Check the log to see what permission is required.
Documentation
- MySQL Spatial General Functions
- Oracle LRS Objects
- Oracle Spatial Exporter (Java + pl/SQL)
- Oracle Spatial Object Functions
- Oracle Spatial Object Functions (Multi Page)
- PostGIS pl/pgSQL Functions
- SC4O Oracle Java Topology Suite (Java + pl/SQL)
- SQL Server Spatial General TSQL Functions
- SQL Server Spatial LRS TSQL Functions