Thursday, 2 March 2017

postgis - What does the ST prefix stand for, e.g. in ST_Polygonize?


I was just curious, and couldn't find any reference to this anywhere - is it Spatial Types? Spatial Topography? Something else?



Answer



I did find it - it stands for Spatial Type -



PostGIS has begun a transition from the existing naming convention to an SQL-MM-centric convention. As a result, most of the functions that you know and love have been renamed using the standard spatial type (ST) prefix. Previous functions are still available, though are not listed in this document where updated functions are equivalent. The non ST_ functions not listed in this documentation are deprecated and will be removed in a future release so STOP USING THEM.

https://postgis.net/docs/reference.html





And SQL-MM refers to an ISO standard that defines the spatial types and their associated routines - the MM stands for MultiMedia -



The ISO/IEC 13249-3 SQL/MM Spatial extends the Simple Features data model
https://en.wikipedia.org/wiki/Simple_Features


ISO/IEC 13249-3:2016 Information technology -- Database languages -- SQL multimedia and application packages -- Part 3: Spatial
ISO/IEC 13249:2016
a) defines concepts specific to this part of ISO/IEC 13249,

b) defines spatial user-defined types and their associated routines.
Publication date : 2016-01
Number of pages : 1328
https://www.iso.org/standard/60343.html



No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...