Mr.Combet Webshell
Your IP :
216.73.216.136
Server IP :
103.233.58.157
Server :
Windows NT WIN-4PGF72KEHKB 10.0 build 17763 (Windows Server 2016) AMD64
Server Software :
Microsoft-IIS/10.0
PHP Version :
7.3.25
Add File :
Submit
Add Directory :
Submit
Dir :
C:
/
Program Files
/
PostgreSQL
/
14
/
share
/
extension
/
Edit File Name :
h3_postgis--4.0.0--4.0.1.sql
/* * Copyright 2018-2022 Bytes & Brains * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ -- complain if script is sourced in psql, rather than via CREATE EXTENSION \echo Use "ALTER EXTENSION h3_postgis UPDATE TO '4.0.1'" to load this file. \quit -- deprecated DROP FUNCTION IF EXISTS h3_cell_to_boundary_geometry(h3index, boolean); CREATE OR REPLACE FUNCTION h3_cell_to_boundary_geometry(h3index, extend_antimeridian boolean) RETURNS geometry AS $$ SELECT ST_SetSRID(h3_cell_to_boundary($1, extend_antimeridian)::geometry, 4326) $$ IMMUTABLE STRICT PARALLEL SAFE LANGUAGE SQL; DROP FUNCTION IF EXISTS h3_cell_to_boundary_geography(h3index, boolean); CREATE OR REPLACE FUNCTION h3_cell_to_boundary_geography(h3index, extend_antimeridian boolean) RETURNS geography AS $$ SELECT ST_SetSRID(h3_cell_to_boundary($1, extend_antimeridian)::geometry, 4326) $$ IMMUTABLE STRICT PARALLEL SAFE LANGUAGE SQL; -- new splitted version CREATE OR REPLACE FUNCTION h3_cell_to_boundary_geometry(h3index) RETURNS geometry AS $$ SELECT h3_cell_to_boundary_wkb($1)::geometry $$ IMMUTABLE STRICT PARALLEL SAFE LANGUAGE SQL; CREATE OR REPLACE FUNCTION h3_cell_to_boundary_geography(h3index) RETURNS geography AS $$ SELECT h3_cell_to_boundary_wkb($1)::geography $$ IMMUTABLE STRICT PARALLEL SAFE LANGUAGE SQL; -- comments COMMENT ON FUNCTION h3_lat_lng_to_cell(geometry, resolution integer) IS 'Indexes the location at the specified resolution.'; COMMENT ON FUNCTION h3_lat_lng_to_cell(geometry, resolution integer) IS 'Indexes the location at the specified resolution.'; COMMENT ON FUNCTION h3_cell_to_geometry(h3index) IS 'Finds the centroid of the index.'; COMMENT ON FUNCTION h3_cell_to_geography(h3index) IS 'Finds the centroid of the index.'; COMMENT ON FUNCTION h3_cell_to_boundary_geometry(h3index) IS 'Finds the boundary of the index. Splits polygons when crossing 180th meridian.'; COMMENT ON FUNCTION h3_cell_to_boundary_geography(h3index) IS 'Finds the boundary of the index. Splits polygons when crossing 180th meridian.';
Save