postgresql-postGis空间数据

-bash-4.2$ psql
psql (10.4)
Type “help” for help.

postgres=# \dx
                                     List of installed extensions
  Name   | Version |   Schema   |                             Description                             
———+———+————+———————————————————————
 plpgsql | 1.0     | pg_catalog | PL/pgSQL procedural language
 postgis | 2.4.4   | public     | PostGIS geometry, geography, and raster spatial types and functions
(2 rows)
postgres=# 
postgres=# CREATE EXTENSION postgis;
CREATE EXTENSION
postgres=# 
postgres=# CREATE EXTENSION postgis_topology;
CREATE EXTENSION
postgres=# 
postgres=# 
postgres=# CREATE EXTENSION pgrouting;
ERROR:  could not open extension control file “/usr/pgsql-10/share/extension/pgrouting.control”: No such file or directory
postgres=# 
postgres=# CREATE EXTENSION fuzzystrmatch;
CREATE EXTENSION
postgres=# 
postgres=# CREATE EXTENSION postgis_tiger_geocoder;
CREATE EXTENSION
postgres=# 
postgres=# CREATE EXTENSION address_standardizer;
CREATE EXTENSION
postgres=# 
postgres=# \dx
                                                                    List of installed extensions
          Name          | Version |   Schema   |                                                     Description                                                     
————————+———+————+———————————————————————————————————————
 address_standardizer   | 2.4.4   | public     | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
 fuzzystrmatch          | 1.1     | public     | determine similarities and distance between strings
 plpgsql                | 1.0     | pg_catalog | PL/pgSQL procedural language
 postgis                | 2.4.4   | public     | PostGIS geometry, geography, and raster spatial types and functions
 postgis_tiger_geocoder | 2.4.4   | tiger      | PostGIS tiger geocoder and reverse geocoder
 postgis_topology       | 2.4.4   | topology   | PostGIS topology spatial types and functions
(6 rows)

常用的空间运算函数：

https://blog.csdn.net/pzysoft/article/details/76944160

转载自：https://blog.csdn.net/gguxxing008/article/details/82501387