Thursday, 18 April 2019

postgresql - Purpose of geography_columns and geometry_columns views in PostGIS?


Can anyone tell me what is the purpose of geography_columns view and geometry_columns view in a PostGIS database?


My geography_columns view is empty so I can't see what the purpose of it is.



Answer



geometry_columns is part of the Simple Features specification for OGC and ISO 19125-2:2004 Standards compliance. geography_columns is a non-Standard variation to support the geography type.



From http://postgis.net:



PostGIS follows the Open Geospatial Consortium’s “Simple Features for SQL Specification”



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...