how to read and write sql spacial data with pascal
lazarus / 39-Graphics

----------------------------------------------------------------------
bernhard · 2017-08-12 11:06

I could not find information on using   sql spacial data with PASCAL (
https://docs.microsoft.com/de-de/sql/relational-
databases/spatial/spatial-data-sql-server )
guess the data access will be stored procedures on the server, but how
to get these data (data types)  into my own code on the client side?


Any code examples will be fine

----------------------------------------------------------------------
Thaddy · 2017-08-12 12:57

This link is a little more appropiate. Not everyone here understands
German:
https://docs.microsoft.com/en-us/sql/relational-
databases/spatial/spatial-data-sql-server

Note that spatial data is not in any way part of any SQL
specification. It is a .net based extension to SQL server only. i:e:
it has not much to do with SQL. It is a language extension. Basically
user-defined procedures. On the client side it simply looks like any
other result set.

----------------------------------------------------------------------
avra · 2017-08-13 10:45

Quote from: Thaddy on August 12, 2017, 02:57:13 pmIt is a .net based
extension to SQL server only.Spatial data is also used a lot with Open
Street Map and SQLite3 via SpatiaLite extension:
http://wiki.openstreetmap.org/wiki/SpatiaLite
https://www.gaia-gis.it/fossil/libspatialite/index
https://www.gaia-gis.it/fossil/spatialite-tools/wiki?name=OSM+tools
https://www.gaia-gis.it/fossil/spatialite-tools/home

For showing OSM data in your pascal application take a look at these:
http://forum.lazarus.freepascal.org/index.php/topic,22103.msg133455.ht
ml#msg133455
http://forum.lazarus.freepascal.org/index.php/topic,16389.msg88763.htm
l#msg88763
http://forum.lazarus.freepascal.org/index.php?topic=12674.0

----------------------------------------------------------------------
marcov · 2017-08-13 10:58

afaik OSM primarily uses Postgresql?  The data side of postgres'
spatial extensions are afaik layered over structure support, which
afaik the FPC driver supports.