Skip to content

The Spatial Database Advisor

Spatial Solutions Architect and Database Expert

0 $0.00
Primary Menu
  • Home
  • Articles
    • MySQL SpatialArticles about MySQL Spatial Functions.
    • Oracle Spatial and Locator
    • PostGIS
    • SQL Server Spatial (General)
    • SQL Server Spatial (LRS)
    • Software Change LogDescribes changes to packaged software.
    • Spatial Database Functions
  • About
  • Contact
  • Shop
0 $0.00
x
  • Login/Register
Home / Import Export

Top 5 Recent Articles

Geometry object size when exchanging of WKT/WKB encoded geometries.

Scheduling the Export of Spatial Data in Oracle to a Shapefile each night

PLSQL ST_AsEWKT and ST_FromWKT Functions For Oracle (any version)

STCogo2Line: Creating (Multi)LineStrings geometries from COGO XML instructions

STLine2Cogo: Converting LineStrings to COGO XML

ARTICLES CATEGORIES
  • Algorithms (13)
  • All (407)
  • Biography (1)
  • Blog (44)
  • Business Requirements (1)
  • Commentary (1)
  • Customers (2)
  • Data Models (1)
  • Education (2)
  • GeoRaptor (5)
  • Image Processing (2)
  • Import Export (5)
  • Licensing (2)
  • Linear Referencing (3)
  • Manifold GIS (3)
  • Mapping (1)
  • MySQL Spatial (7)
  • Networking and Routing (including Optimization) (3)
  • Open Source (16)
  • Oracle Spatial and Locator (178)
  • PostGIS (33)
  • Published Articles (1)
  • Recommendations (1)
  • Services (1)
  • Software Change Log (1)
  • Source Code (35)
  • Space Curves (9)
  • Spatial Database Functions (101)
  • Spatial DB comparison (1)
  • Spatial XML Processing (10)
  • SQL Server Spatial (General) (83)
  • SQL Server Spatial (LRS) (38)
  • Standards (1)
  • Stored Procedure (15)
  • Tessellation or Gridding (9)
  • Tools (2)
  • Training (2)

Geometry object size when exchanging of WKT/WKB encoded geometries.

Introduction The ordinates stored in an geometry objects, across all spatial data types do not have any rounding applied to their values. This is one

Read More »
12 December, 2020 No Comments

Scheduling the Export of Spatial Data in Oracle to a Shapefile each night

While there is always a need for software like Safe Software’s Awesome FME to automate import and export tasks from your database, the ability to

Read More »
5 August, 2020 No Comments

PLSQL ST_AsEWKT and ST_FromWKT Functions For Oracle (any version)

Previously I created the following Java stored procedures to enable the import/export of ZM aware WKT. ST_GeomFromText ST_GeomFromEWKT ST_AsText ST_AsEWKT These functions are necessary if

Read More »
5 August, 2020 No Comments

STCogo2Line: Creating (Multi)LineStrings geometries from COGO XML instructions

Previously I wrote about a function that converted the segments of a (Multi)LineString into a COGO XML document that contains all the instructions (bearing, distances,

Read More »
5 August, 2020 No Comments

STLine2Cogo: Converting LineStrings to COGO XML

I have just written a useful function for my new package of TSQL functions for SQL Server Spatial called STLine2Cogo which converts (exports) a (Multi)LineString

Read More »
5 August, 2020 No Comments

Documentation

  • MySQL Spatial General Function Documentation
  • Oracle Spatial Exporter Package Documentation
  • Oracle Spatial Object Function Documentation
  • Oracle Spatial Object Function Documentation (Multi Page Version)
  • PostGIS pl/pgSQL Function Documentation
  • SC4O Oracle Java Topology Suite (Stored Procedures) Package Documentation
  • SQL Server Spatial General TSQL Function Documentation
  • SQL Server Spatial LRS TSQL Function Documentation
© The Spatial Database Advisor 2019