MacOS PostGIS install : 맥북에 PostGIS 설치하기

MacOS PostGIS install 

맥북에 PostGIS 설치하기

• Homebrew를 통하여 설치한 경우

brew install postgresql

brew install postgis

• dmg 파일로 설치한 경우 

(postgresql-12.2-4-osx.dmg)

/Applications/PostgreSQL 12/Application Stack Builder.app 실행

설치 완료 후 아래 스크립트 실행

-- Enable PostGIS (as of 3.0 contains just geometry/geography)

CREATE EXTENSION postgis;

-- enable raster support (for 3+)

--CREATE EXTENSION postgis_raster;

-- Enable Topology

CREATE EXTENSION postgis_topology;

-- Enable PostGIS Advanced 3D

-- and other geoprocessing algorithms

-- sfcgal not available with all distributions

CREATE EXTENSION postgis_sfcgal;

-- fuzzy matching needed for Tiger

CREATE EXTENSION fuzzystrmatch;

-- rule based standardizer

CREATE EXTENSION address_standardizer;

-- example rule data set

CREATE EXTENSION address_standardizer_data_us;

-- Enable US Tiger Geocoder

CREATE EXTENSION postgis_tiger_geocoder;