随笔分类 -  PostgreSQL/PostGIS

PostGIS9.3安装
摘要：1. 软件下载postgresql-9.4.19-1-windows-x64-binaries.ziphttps://www.postgresql.org/download/windows/postgis-bundle-pg94x64-2.2.0.ziphttp://download.osgeo.org/postgis/windows/pg94/2. 将postgresql.zip解压解压post... 阅读全文
posted @ 2020-06-25 00:03 ParamousGIS 阅读(388) 评论(0) 推荐(0) 编辑
CentOS8安装PostgreSQL12
摘要：1.PostgreSQL的安装1.1 下载并安装PostgreSQL官方yum源配置文件dnf install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm1.2 禁用系统内置yum源的PostgreSQL安装模块PostgreSQL官方的y... 阅读全文
posted @ 2020-06-06 12:40 ParamousGIS 阅读(6553) 评论(0) 推荐(0) 编辑
ERROR: extension “postgis” does not support SET SCHEMA.
摘要：参考： http://postgis.net/2017/11/07/tip-move-postgis-schema/Move PostGIS extension to a different schemaAs of PostGIS 2.3, the postgis extension was changed to no longer allow relocation. All function ... 阅读全文
posted @ 2020-06-01 11:25 ParamousGIS 阅读(879) 评论(0) 推荐(0) 编辑
PostGIS空间查询
摘要：select * from footprints t where ST_intersects(t.geom,ST_GeomFromGeoJSON('{"type":"Polygon","crs": { "type": "name", "properties": { "name": "EPSG:4326" } },"co... 阅读全文
posted @ 2019-04-16 15:09 ParamousGIS 阅读(2888) 评论(0) 推荐(0) 编辑
PostGIS中生成GUID字段值
摘要：create extension "uuid-ossp" update base_region set region_id = uuid_generate_v4()update base_region set region_id = upper( replace(region_id,'-','')) 阅读全文
posted @ 2019-03-26 10:36 ParamousGIS 阅读(452) 评论(0) 推荐(0) 编辑
PostGIS中导入Shapefile
摘要：shp2pgsql -s 4326 /var/www/apps/map/data/ShaanXi/station.shp postgis.station | psql -d geodb -U username 阅读全文
posted @ 2019-03-21 23:22 ParamousGIS 编辑

点击右上角即可分享
微信分享提示