PageSourceSearch

https://postgis.net/

html postgis.net collected 2026-10-01 08:25:42 UTC 52,880 bytes, 1,893 lines download raw bytes

1<!DOCTYPE html>
2<html
3  lang="en"
4  class="color-toggle-hidden"
5  
6>
7  <head>
8    <meta charset="UTF-8" />
9<meta name="referrer" content="no-referrer" />
10<meta name="viewport" content="width=device-width, initial-scale=1.0" />
11<meta name="color-scheme" content="light dark" />
12<meta name="generator" content="Hugo 0.165.0">
13
14
15
16    <title>PostGIS</title>
17
18    <link rel="icon" type="image/svg+xml" href="/favicon/favicon.svg" />
19<link
20  rel="icon"
21  type="image/png"
22  sizes="32x32"
23  href="/favicon/favicon-32x32.png"
24/>
25<link
26  rel="icon"
27  type="image/png"
28  sizes="16x16"
29  href="/favicon/favicon-16x16.png"
30/>
31
32    
33
34    
35  <meta property="og:site_name" content="PostGIS" />
36  <meta property="og:image" content="https://postgis.net/postgis-logo-horizontal.png" />
37<meta property="og:type" content="website" />
38<meta property="og:url" content="https://postgis.net/" />
39
40
41
42
43
44  <meta name="twitter:card" content="summary_large_image" />
45<meta name="twitter:title" content="Home" />
46  <meta property="twitter:image" content="https://postgis.net/postgis-logo-horizontal.png" />
47
48  
48<script type="application/ld+json">
49  {
50      "@context": "http://schema.org",
51      "@type": "WebSite",
52      "name": "PostGIS",
53      "url": "https://postgis.net/",
54      "thumbnailUrl": "https://postgis.net/postgis-logo-horizontal.png",
55      "license": "CC BY-SA 4.0",
56      "inLanguage": "en"
57  }
58  </script>
58
59
60
61    
62  
62<script src="/js/colortheme-d3e4d351.bundle.min.js"></script>
vendor: 1 bytes, line 62
62
63<script src="/js/main-fbb9c8b0.bundle.min.js"></script>
63
64
65<link
66  rel="preload"
67  as="font"
68  href="/fonts/Metropolis.woff2"
69  type="font/woff2"
70  crossorigin="anonymous"
71/>
72<link
73  rel="preload"
74  as="font"
75  href="/fonts/LiberationSans.woff2"
76  type="font/woff2"
77  crossorigin="anonymous"
78/>
79
80<link
81  rel="preload"
82  href="/main-ba0e2765.min.css"
83  as="style"
84/>
85<link
86  rel="stylesheet"
87  href="/main-ba0e2765.min.css"
88  media="all"
89/>
90
91<link
92  rel="preload"
93  href="/mobile-79ddc617.min.css"
94  as="style"
95/>
96<link
97  rel="stylesheet"
98  href="/mobile-79ddc617.min.css"
99  media="screen and (max-width: 45rem)"
100/>
101
102<link
103  rel="preload"
104  href="/print-735ccc12.min.css"
105  as="style"
106/>
107<link
108  rel="stylesheet"
109  href="/print-735ccc12.min.css"
110  media="print"
111/>
112
113<link
114  rel="preload"
115  href="/custom.css"
116  as="style"
117/>
118<link
119  rel="stylesheet"
120  href="/custom.css"
121  media="all"
122/>
123  <link href="https://postgis.net/" rel="canonical" type="text/html" />
124
125<!-- Made with Geekdoc theme https://github.com/thegeeklab/hugo-geekdoc -->
126
127    <link rel="alternate" type="application/rss+xml" href="https://postgis.net/feed.xml" title="PostGIS" />
128
129  </head>
130
131  <body itemscope itemtype="https://schema.org/WebPage">
132    
133  <!-- geekdoc include: /sprites/geekdoc.svg -->
134  <svg class="svg-sprite" xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink"><defs><svg viewBox="-7.27 -7.27 38.55 38.55" id="gdoc_arrow_back" xmlns="http://www.w3.org/2000/svg"><path d="M24 10.526v2.947H5.755l8.351 8.421-2.105 2.105-12-12 12-12 2.105 2.105-8.351 8.421H24z"/></svg><svg viewBox="-7.27 -7.27 38.55 38.55" id="gdoc_arrow_left_alt" xmlns="http://www.w3.org/2000/svg"><path d="M5.965 10.526V6.035L0 12l5.965 5.965v-4.491H24v-2.947H5.965z"/></svg><svg viewBox="-7.27 -7.27 38.55 38.55" id="gdoc_arrow_right_alt" xmlns="http://www.w3.org/2000/svg"><path d="M18.035 10.526V6.035L24 12l-5.965 5.965v-4.491H0v-2.947h18.035z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_bitbucket" xmlns="http://www.w3.org/2000/svg"><path d="M15.905 13.355c.189 1.444-1.564 2.578-2.784 1.839-1.375-.602-1.375-2.784-.034-3.403 1.151-.705 2.818.223 2.818 1.564zm1.907-.361c-.309-2.44-3.076-4.056-5.328-3.042-1.426.636-2.389 2.148-2.32 3.747.086 2.097 2.08 3.815 4.176 3.626s3.729-2.234 3.472-4.331zm4.108-9.315c-.756-.997-2.045-1.169-3.179-1.358-3.214-.516-6.513-.533-9.727.034-1.066.172-2.269.361-2.939 1.323 1.1 1.031 2.664 1.186 4.073 1.358 2.544.327 5.156.344 7.699.017 1.426-.172 3.008-.309 4.073-1.375zm.979 17.788c-.481 1.684-.206 3.953-1.994 4.932-3.076 1.701-6.806 1.89-10.191 1.289-1.787-.327-3.884-.894-4.864-2.578-.43-1.65-.705-3.334-.98-5.018l.103-.275.309-.155c5.121 3.386 12.288 3.386 17.427 0 .808.241.206 1.22.189 1.805zM26.01 4.951c-.584 3.764-1.255 7.51-1.908 11.257-.189 1.1-1.255 1.719-2.148 2.183-3.214 1.615-6.96 1.89-10.483 1.512-2.389-.258-4.829-.894-6.771-2.389-.911-.705-.911-1.908-1.083-2.922-.602-3.523-1.289-7.046-1.719-10.604.206-1.547 1.942-2.217 3.231-2.698C6.848.654 8.686.362 10.508.19c3.884-.378 7.854-.241 11.618.859 1.341.395 2.784.945 3.695 2.097.412.533.275 1.203.189 1.805z"/></svg><svg viewBox="-7.27 -7.27 38.55 38.55" id="gdoc_bookmark" xmlns="http://www.w3.org/2000/svg"><path d="M15.268 4.392q.868 0 1.532.638t.664 1.506v17.463l-7.659-3.268-7.608 3.268V6.536q0-.868.664-1.506t1.532-.638h10.876zm4.34 14.144V4.392q0-.868-.638-1.532t-1.506-.664H6.537q0-.868.664-1.532T8.733 0h10.876q.868 0 1.532.664t.664 1.532v17.412z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_brightness_auto" xmlns="http://www.w3.org/2000/svg"><path d="M16.846 18.938h2.382L15.22 7.785h-2.44L8.772 18.938h2.382l.871-2.44h3.95zm7.087-9.062L27.999 14l-4.066 4.124v5.809h-5.809L14 27.999l-4.124-4.066H4.067v-5.809L.001 14l4.066-4.124V4.067h5.809L14 .001l4.124 4.066h5.809v5.809zm-11.385 4.937L14 10.282l1.452 4.531h-2.904z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_brightness_dark" xmlns="http://www.w3.org/2000/svg"><path d="M14 21.435q3.079 0 5.257-2.178T21.435 14t-2.178-5.257T14 6.565q-1.51 0-3.079.697 1.917.871 3.108 2.701T15.22 14t-1.191 4.037-3.108 2.701q1.568.697 3.079.697zm9.933-11.559L27.999 14l-4.066 4.124v5.809h-5.809L14 27.999l-4.124-4.066H4.067v-5.809L.001 14l4.066-4.124V4.067h5.809L14 .001l4.124 4.066h5.809v5.809z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_brightness_light" xmlns="http://www.w3.org/2000/svg"><path d="M14 21.435q3.079 0 5.257-2.178T21.435 14t-2.178-5.257T14 6.565 8.743 8.743 6.565 14t2.178 5.257T14 21.435zm9.933-3.311v5.809h-5.809L14 27.999l-4.124-4.066H4.067v-5.809L.001 14l4.066-4.124V4.067h5.809L14 .001l4.124 4.066h5.809v5.809L27.999 14z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_check" xmlns="http://www.w3.org/2000/svg"><path d="M8.885 20.197 25.759 3.323l2.24 2.24L8.885 24.677 0 15.792l2.24-2.24z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_check_circle_outline" xmlns="http://www.w3.org/2000/svg"><path d="M14 25.239q4.601 0 7.92-3.319T25.239 14 21.92 6.08 14 2.761 6.08 6.08 2.761 14t3.319 7.92T14 25.239zM14 0q5.784 0 9.892 4.108T28 14t-4.108 9.892T14 28t-9.892-4.108T0 14t4.108-9.892T14 0zm6.441 7.822 1.972 1.972-11.239 11.239L4.207 14l1.972-1.972 4.995 4.995z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_cloud_off" xmlns="http://www.w3.org/2000/svg"><path d="M9.023 10.5H7q-1.914 0-3.281 1.395t-1.367 3.309 1.367 3.281T7 19.852h11.375zM3.5 4.976l1.477-1.477L24.5 23.022l-1.477 1.477-2.352-2.297H6.999q-2.898 0-4.949-2.051t-2.051-4.949q0-2.844 1.969-4.867t4.758-2.133zm19.086 5.578q2.242.164 3.828 1.832T28 16.351q0 3.008-2.461 4.758l-1.695-1.695q1.805-.984 1.805-3.063 0-1.422-1.039-2.461t-2.461-1.039h-1.75v-.602q0-2.68-1.859-4.539t-4.539-1.859q-1.531 0-2.953.711l-1.75-1.695Q11.431 3.5 14.001 3.5q2.953 0 5.496 2.078t3.09 4.977z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_code" xmlns="http://www.w3.org/2000/svg"><path d="M9.917 24.5a1.75 1.75 0 1 0-3.501.001 1.75 1.75 0 0 0 3.501-.001zm0-21a1.75 1.75 0 1 0-3.501.001A1.75 1.75 0 0 0 9.917 3.5zm11.666 2.333a1.75 1.75 0 1 0-3.501.001 1.75 1.75 0 0 0 3.501-.001zm1.75 0a3.502 3.502 0 0 1-1.75 3.026c-.055 6.581-4.721 8.039-7.82 9.023-2.898.911-3.846 1.349-3.846 3.117v.474a3.502 3.502 0 0 1 1.75 3.026c0 1.932-1.568 3.5-3.5 3.5s-3.5-1.568-3.5-3.5c0-1.294.711-2.424 1.75-3.026V6.526A3.502 3.502 0 0 1 4.667 3.5c0-1.932 1.568-3.5 3.5-3.5s3.5 1.568 3.5 3.5a3.502 3.502 0 0 1-1.75 3.026v9.06c.93-.456 1.914-.766 2.807-1.039 3.391-1.075 5.323-1.878 5.359-5.687a3.502 3.502 0 0 1-1.75-3.026c0-1.932 1.568-3.5 3.5-3.5s3.5 1.568 3.5 3.5z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_copy" xmlns="http://www.w3.org/2000/svg"><path d="M23.502 25.438V7.626H9.562v17.812h13.94zm0-20.315q1.013 0 1.787.745t.774 1.757v17.812q0 1.013-.774 1.787t-1.787.774H9.562q-1.013 0-1.787-.774t-.774-1.787V7.625q0-1.013.774-1.757t1.787-.745h13.94zM19.689 0v2.562H4.438v17.812H1.936V2.562q0-1.013.745-1.787T4.438.001h15.251z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_dangerous" xmlns="http://www.w3.org/2000/svg"><path d="M21.802 19.833 15.969 14l5.833-5.833-1.969-1.969L14 12.031 8.167 6.198 6.198 8.167 12.031 14l-5.833 5.833 1.969 1.969L14 15.969l5.833 5.833zM19.833 0 28 8.167v11.666L19.833 28H8.167L0 19.833V8.167L8.167 0h11.666z"/></svg><svg viewBox="-7.27 -7.27 46.55 46.55" id="gdoc_date" xmlns="http://www.w3.org/2000/svg"><path d="M27.192 28.844V11.192H4.808v17.652h22.384zm0-25.689q1.277 0 2.253.976t.976 2.253v22.459q0 1.277-.976 2.216t-2.253.939H4.808q-1.352 0-2.291-.901t-.939-2.253V6.385q0-1.277.939-2.253t2.291-.976h1.5
13477V.001h3.23v3.155h12.769V.001h3.23v3.155h1.577zm-3.155 11.267v3.155h-3.23v-3.155h3.23zm-6.46 0v3.155h-3.155v-3.155h3.155zm-6.384 0v3.155h-3.23v-3.155h3.23z"/></svg><svg viewBox="-7.27 -7.27 46.55 46.55" id="gdoc_download" xmlns="http://www.w3.org/2000/svg"><path d="M2.866 28.209h26.269v3.79H2.866v-3.79zm26.268-16.925L16 24.418 2.866 11.284h7.493V.001h11.283v11.283h7.493z"/></svg><svg viewBox="-7.27 -7.27 46.55 46.55" id="gdoc_email" xmlns="http://www.w3.org/2000/svg"><path d="M28.845 9.615v-3.23L16 14.422 3.155 6.385v3.23L16 17.577zm0-6.46q1.277 0 2.216.977T32 6.385v19.23q0 1.277-.939 2.253t-2.216.977H3.155q-1.277 0-2.216-.977T0 25.615V6.385q0-1.277.939-2.253t2.216-.977h25.69z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_error_outline" xmlns="http://www.w3.org/2000/svg"><path d="M14 25.239q4.601 0 7.92-3.319T25.239 14 21.92 6.08 14 2.761 6.08 6.08 2.761 14t3.319 7.92T14 25.239zM14 0q5.784 0 9.892 4.108T28 14t-4.108 9.892T14 28t-9.892-4.108T0 14t4.108-9.892T14 0zm-1.38 6.967h2.761v8.413H12.62V6.967zm0 11.239h2.761v2.826H12.62v-2.826z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_fire" xmlns="http://www.w3.org/2000/svg"><path d="M17.689 21.998q-.32.32-.8.576t-.864.384q-1.152.384-2.272.032t-1.888-.992q-.128-.128-.096-.256t.16-.192q1.216-.384 1.92-1.216t.96-1.792q.192-.896-.064-1.728t-.384-1.728q-.128-.704-.096-1.376t.288-1.312q0-.128.128-.128t.192.064q.384.832.992 1.472t1.28 1.216 1.216 1.248.672 1.568q.064.384.064.704.064.96-.32 1.92t-1.088 1.536zm3.84-10.944q-.768-.704-1.6-1.28t-1.6-1.344q-1.536-1.536-2.016-3.584t.16-4.16q.128-.32-.096-.544t-.544-.096q-.768.32-1.44.768t-1.312.896q-1.984 1.664-3.136 3.936T8.633 10.51t.8 5.088q0 .128.032.256t.032.256q0 .576-.512.832t-1.024-.192q-.128-.192-.192-.32-1.024-1.28-1.376-2.912t-.096-3.232q.064-.384-.288-.576t-.608.128q-1.28 1.664-1.856 3.68t-.448 4.064q0 .576.096 1.184t.288 1.184q.448 1.536 1.216 2.816 1.216 2.048 3.264 3.424t4.416 1.696q2.496.32 5.024-.256t4.448-2.304q1.408-1.344 2.208-3.104t.864-3.68-.704-3.712q-.064-.128-.096-.224t-.096-.224q-.576-1.088-1.28-1.984-.256-.384-.544-.704t-.672-.64z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_git" xmlns="http://www.w3.org/2000/svg"><path d="M27.472 12.753 15.247.529a1.803 1.803 0 0 0-2.55 0l-2.84 2.84 2.137 2.137a2.625 2.625 0 0 1 3.501 3.501l3.499 3.499a2.625 2.625 0 1 1-1.237 1.237l-3.499-3.499c-.083.04-.169.075-.257.106v7.3a2.626 2.626 0 1 1-1.75 0v-7.3a2.626 2.626 0 0 1-1.494-3.607L8.62 4.606l-8.09 8.09a1.805 1.805 0 0 0 0 2.551l12.225 12.224a1.803 1.803 0 0 0 2.55 0l12.168-12.168a1.805 1.805 0 0 0 0-2.551z"/></svg><svg viewBox="-7.27 -7.27 46.55 46.55" id="gdoc_gitea" xmlns="http://www.w3.org/2000/svg"><path d="M5.581 7.229c-2.46-.005-5.755 1.559-5.573 5.48.284 6.125 6.56 6.693 9.068 6.743.275 1.149 3.227 5.112 5.412 5.32h9.573c5.741-.381 10.04-17.363 6.853-17.427-5.271.248-8.395.373-11.073.395v5.3l-.835-.369-.005-4.928c-3.075-.001-5.781-.144-10.919-.397-.643-.004-1.539-.113-2.501-.116zm.348 2.166h.293c.349 3.14.917 4.976 2.067 7.781-2.933-.347-5.429-1.199-5.888-4.38-.237-1.647.563-3.365 3.528-3.401zm11.409 3.087c.2.003.404.04.596.128l.999.431-.716 1.305h-.007a.996.996 0 0 0-.321.053l.006-.002c-.349.114-.593.406-.593.749 0 .097.019.189.055.275l-.002-.006a.767.767 0 0 0 .151.233l-.001-.001-1.235 2.248a.99.99 0 0 0-.302.052l.006-.002c-.349.114-.593.406-.593.749 0 .097.019.189.055.275l-.002-.006c.128.31.457.527.843.527a.987.987 0 0 0 .31-.049l-.006.002c.348-.114.592-.406.592-.749 0-.097-.02-.19-.056-.277l.002.006a.784.784 0 0 0-.211-.293l1.203-2.189a.999.999 0 0 0 .397-.041l-.006.002a.942.942 0 0 0 .285-.15l-.001.001c.464.195.844.353 1.117.488.411.203.556.337.6.487.044.147-.004.429-.236.925-.173.369-.46.893-.799 1.511h-.02a.991.991 0 0 0-.321.053l.006-.002c-.349.114-.593.406-.593.749 0 .097.019.189.055.275l-.002-.006c.128.31.457.527.843.527a.987.987 0 0 0 .31-.049l-.006.002c.348-.114.592-.406.592-.749a.703.703 0 0 0-.055-.275l.002.006a.802.802 0 0 0-.183-.27l.001.001c.335-.611.623-1.136.808-1.531.251-.536.381-.935.267-1.32s-.467-.636-.933-.867c-.307-.151-.689-.311-1.147-.503a.723.723 0 0 0-.052-.324l.002.006a.792.792 0 0 0-.194-.279l.704-1.284 3.899 1.684c.704.305.995 1.053.653 1.68l-2.68 4.907c-.343.625-1.184.884-1.888.58l-5.516-2.384c-.704-.304-.996-1.053-.653-1.68l2.68-4.905c.235-.431.707-.687 1.207-.707z"/></svg><svg viewBox="-7.27 -7.27 46.55 46.55" id="gdoc_github" xmlns="http://www.w3.org/2000/svg"><path d="M16 .394c8.833 0 15.999 7.166 15.999 15.999 0 7.062-4.583 13.062-10.937 15.187-.813.146-1.104-.354-1.104-.771 0-.521.021-2.25.021-4.396 0-1.5-.5-2.458-1.083-2.958 3.562-.396 7.312-1.75 7.312-7.896 0-1.75-.625-3.167-1.646-4.291.167-.417.708-2.042-.167-4.25-1.333-.417-4.396 1.646-4.396 1.646a15.032 15.032 0 0 0-8 0S8.937 6.602 7.603 7.018c-.875 2.208-.333 3.833-.167 4.25-1.021 1.125-1.
134646 2.542-1.646 4.291 0 6.125 3.729 7.5 7.291 7.896-.458.417-.875 1.125-1.021 2.146-.917.417-3.25 1.125-4.646-1.333-.875-1.521-2.458-1.646-2.458-1.646-1.562-.021-.104.979-.104.979 1.042.479 1.771 2.333 1.771 2.333.938 2.854 5.396 1.896 5.396 1.896 0 1.333.021 2.583.021 2.979 0 .417-.292.917-1.104.771C4.582 29.455-.001 23.455-.001 16.393-.001 7.56 7.165.394 15.998.394zM6.063 23.372c.042-.083-.021-.187-.146-.25-.125-.042-.229-.021-.271.042-.042.083.021.187.146.25.104.062.229.042.271-.042zm.646.709c.083-.062.062-.208-.042-.333-.104-.104-.25-.146-.333-.062-.083.062-.062.208.042.333.104.104.25.146.333.062zm.625.937c.104-.083.104-.25 0-.396-.083-.146-.25-.208-.354-.125-.104.062-.104.229 0 .375s.271.208.354.146zm.875.875c.083-.083.042-.271-.083-.396-.146-.146-.333-.167-.417-.062-.104.083-.062.271.083.396.146.146.333.167.417.062zm1.187.521c.042-.125-.083-.271-.271-.333-.167-.042-.354.021-.396.146s.083.271.271.312c.167.062.354 0 .396-.125zm1.313.104c0-.146-.167-.25-.354-.229-.187 0-.333.104-.333.229 0 .146.146.25.354.229.187 0 .333-.104.333-.229zm1.208-.208c-.021-.125-.187-.208-.375-.187-.187.042-.312.167-.292.312.021.125.187.208.375.167s.312-.167.292-.292z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_gitlab" xmlns="http://www.w3.org/2000/svg"><path d="M1.629 11.034 14 26.888.442 17.048a1.09 1.09 0 0 1-.39-1.203l1.578-4.811zm7.217 0h10.309l-5.154 15.854zM5.753 1.475l3.093 9.559H1.63l3.093-9.559a.548.548 0 0 1 1.031 0zm20.618 9.559 1.578 4.811c.141.437-.016.922-.39 1.203l-13.558 9.84 12.371-15.854zm0 0h-7.216l3.093-9.559a.548.548 0 0 1 1.031 0z"/></svg><svg viewBox="-7.27 -7.27 46.55 46.55" id="gdoc_heart" xmlns="http://www.w3.org/2000/svg"><path d="M16 29.714a1.11 1.11 0 0 1-.786-.321L4.072 18.643c-.143-.125-4.071-3.714-4.071-8 0-5.232 3.196-8.357 8.535-8.357 3.125 0 6.053 2.464 7.464 3.857 1.411-1.393 4.339-3.857 7.464-3.857 5.339 0 8.535 3.125 8.535 8.357 0 4.286-3.928 7.875-4.089 8.035L16.785 29.392c-.214.214-.5.321-.786.321z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_home" xmlns="http://www.w3.org/2000/svg"><path d="M24.003 15.695v8.336c0 .608-.504 1.111-1.111 1.111h-6.669v-6.669h-4.446v6.669H5.108a1.119 1.119 0 0 1-1.111-1.111v-8.336c0-.035.017-.069.017-.104L14 7.359l9.986 8.232a.224.224 0 0 1 .017.104zm3.873-1.198-1.077 1.285a.578.578 0 0 1-.365.191h-.052a.547.547 0 0 1-.365-.122L14 5.831 1.983 15.851a.594.594 0 0 1-.417.122.578.578 0 0 1-.365-.191L.124 14.497a.57.57 0 0 1 .069-.781L12.679 3.314c.729-.608 1.91-.608 2.64 0l4.237 3.543V3.471c0-.313.243-.556.556-.556h3.334c.313 0 .556.243.556.556v7.085l3.803 3.161c.226.191.26.556.069.781z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_info_outline" xmlns="http://www.w3.org/2000/svg"><path d="M12.62 9.793V6.967h2.761v2.826H12.62zM14 25.239q4.601 0 7.92-3.319T25.239 14 21.92 6.08 14 2.761 6.08 6.08 2.761 14t3.319 7.92T14 25.239zM14 0q5.784 0 9.892 4.108T28 14t-4.108 9.892T14 28t-9.892-4.108T0 14t4.108-9.892T14 0zm-1.38 21.033V12.62h2.761v8.413H12.62z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_keyboard_arrow_down" xmlns="http://www.w3.org/2000/svg"><path d="M3.281 5.36 14 16.079 24.719 5.36 28 8.641l-14 14-14-14z"/></svg><svg viewBox="-7.27 -7.27 46.55 46.55" id="gdoc_keyboard_arrow_left" xmlns="http://www.w3.org/2000/svg"><path d="M25.875 28.25 22.125 32 6.126 16.001 22.125.002l3.75 3.75-12.25 12.25z"/></svg><svg viewBox="-7.27 -7.27 46.55 46.55" id="gdoc_keyboard_arrow_right" xmlns="http://www.w3.org/2000/svg"><path d="M6.125 28.25 18.375 16 6.125 3.75 9.875 0l15.999 15.999L9.875 31.998z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_keyboard_arrow_up" xmlns="http://www.w3.org/2000/svg"><path d="M24.719 22.64 14 11.921 3.281 22.64 0 19.359l14-14 14 14z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_language" xmlns="http://www.w3.org/2000/svg"><path d="M20.112 16.826h4.732q.394-1.84.394-2.826t-.394-2.826h-4.732q.197 1.38.197 2.826t-.197 2.826zm-2.497 7.756q1.643-.526 3.418-2.005t2.695-2.991h-4.141q-.657 2.629-1.972 4.995zm-.329-7.756q.197-1.38.197-2.826t-.197-2.826h-6.573q-.197 1.38-.197 2.826t.197 2.826h6.573zM14 25.173q1.84-2.695 2.695-5.587h-5.39q.854 2.892 2.695 5.587zM8.413 8.413q.789-2.826 1.972-4.995-1.643.526-3.451 2.005T4.272 8.414h4.141zM4.272 19.587q.854 1.512 2.662 2.991t3.451 2.005q-1.315-2.366-1.972-4.995H4.272zm-1.117-2.761h4.732Q7.69 15.446 7.
13469 14t.197-2.826H3.155q-.394 1.84-.394 2.826t.394 2.826zM14 2.826q-1.84 2.695-2.695 5.587h5.39Q15.841 5.521 14 2.826zm9.727 5.587q-.92-1.512-2.695-2.991t-3.418-2.005q1.183 2.169 1.972 4.995h4.141zM14 0q5.784 0 9.892 4.108T28 14t-4.108 9.892T14 28t-9.892-4.108T0 14t4.108-9.892T14 0z"/></svg><svg viewBox="-7.27 -7.27 46.55 46.55" id="gdoc_link" xmlns="http://www.w3.org/2000/svg"><path d="M24.037 7.963q3.305 0 5.634 2.366T32 16t-2.329 5.671-5.634 2.366h-6.46v-3.08h6.46q2.028 0 3.493-1.465t1.465-3.493-1.465-3.493-3.493-1.465h-6.46v-3.08h6.46zM9.615 17.578v-3.155h12.77v3.155H9.615zM3.005 16q0 2.028 1.465 3.493t3.493 1.465h6.46v3.08h-6.46q-3.305 0-5.634-2.366T0 16.001t2.329-5.671 5.634-2.366h6.46v3.08h-6.46q-2.028 0-3.493 1.465t-1.465 3.493z"/></svg><svg viewBox="-7.27 -7.27 46.55 46.55" id="gdoc_mastodon" xmlns="http://www.w3.org/2000/svg"><path d="M30.924 10.506c0-6.941-4.548-8.976-4.548-8.976C24.083.477 20.144.034 16.054.001h-.101C11.862.034 7.926.477 5.633 1.53c0 0-4.548 2.035-4.548 8.976 0 1.589-.031 3.491.02 5.505.165 6.79 1.245 13.479 7.522 15.14 2.893.765 5.379.927 7.38.816 3.629-.2 5.667-1.296 5.667-1.296l-.12-2.633s-2.593.817-5.505.719c-2.887-.099-5.932-.311-6.399-3.855a7.069 7.069 0 0 1-.064-.967v-.028.001s2.833.693 6.423.857c2.195.1 4.253-.129 6.344-.377 4.009-.479 7.5-2.949 7.939-5.207.689-3.553.633-8.676.633-8.676zm-5.366 8.945h-3.329v-8.159c0-1.72-.724-2.592-2.171-2.592-1.6 0-2.403 1.035-2.403 3.083v4.465h-3.311v-4.467c0-2.048-.803-3.083-2.403-3.083-1.447 0-2.171.873-2.171 2.592v8.159H6.441v-8.404c0-1.719.437-3.084 1.316-4.093.907-1.011 2.092-1.528 3.565-1.528 1.704 0 2.995.655 3.848 1.965l.828 1.391.829-1.391c.853-1.311 2.144-1.965 3.848-1.965 1.472 0 2.659.517 3.565 1.528.877 1.009 1.315 2.375 1.315 4.093z"/></svg><svg viewBox="-7.27 -7.27 46.55 46.55" id="gdoc_matrix" xmlns="http://www.w3.org/2000/svg"><path d="M.843.734v30.532H3.04v.733H0V0h3.04v.733zm9.391 9.68v1.543h.044a4.417 4.417 0 0 1 1.489-1.365c.577-.327 1.248-.487 2-.487.72 0 1.377.143 1.975.419.597.277 1.047.776 1.36 1.477.339-.499.8-.941 1.379-1.323.579-.383 1.267-.573 2.061-.573.604 0 1.163.075 1.68.223a3.34 3.34 0 0 1 1.324.707c.368.327.652.745.861 1.268.203.523.307 1.151.307 1.889v7.637h-3.132v-6.468c0-.381-.013-.745-.043-1.083a2.315 2.315 0 0 0-.246-.893l.006.013a1.484 1.484 0 0 0-.577-.593l-.007-.004c-.259-.147-.609-.221-1.047-.221-.443 0-.8.085-1.071.252-.267.166-.483.39-.635.656l-.005.009a2.558 2.558 0 0 0-.307.915l-.002.013a7.156 7.156 0 0 0-.08 1.044v6.359h-3.133v-6.4c0-.339-.005-.671-.024-1.003a2.772 2.772 0 0 0-.197-.936l.007.019a1.41 1.41 0 0 0-.548-.667l-.006-.003c-.259-.167-.635-.253-1.139-.253-.148 0-.345.032-.585.099-.24.068-.48.191-.707.376-.228.184-.425.449-.585.793-.16.345-.24.8-.24 1.36v6.621H7.279v-11.42zm20.923 20.852V.734H28.96V.001H32V32h-3.04v-.733z"/></svg><svg viewBox="-7.27 -7.27 46.55 46.55" id="gdoc_menu" xmlns="http://www.w3.org/2000/svg"><path d="M.001 5.334h31.998v3.583H.001V5.334zm0 12.416v-3.5h31.998v3.5H.001zm0 8.916v-3.583h31.998v3.583H.001z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_notification" xmlns="http://www.w3.org/2000/svg"><path d="m22.615 19.384 2.894 2.894v1.413H2.49v-1.413l2.894-2.894V12.25q0-3.365 1.716-5.856t4.745-3.231v-1.01q0-.875.606-1.514T13.999 0t1.548.639.606 1.514v1.01q3.029.74 4.745 3.231t1.716 5.856v7.134zM14 27.999q-1.211 0-2.053-.808t-.841-2.019h5.788q0 1.144-.875 1.986T14 27.999z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_path" xmlns="http://www.w3.org/2000/svg"><path d="M28 12.62h-9.793V8.414h-2.826v11.173h2.826v-4.206H28V26.62h-9.793v-4.206H12.62v-14H9.794v4.206H.001V1.381h9.793v4.206h8.413V1.381H28V12.62z"/></svg><svg viewBox="-7.27 -7.27 46.55 46.55" id="gdoc_person" xmlns="http://www.w3.org/2000/svg"><path d="M16 20.023q5.052 0 10.526 2.199t5.473 5.754v4.023H0v-4.023q0-3.555 5.473-5.754t10.526-2.199zM16 16q-3.275 0-5.614-2.339T8.047 8.047t2.339-5.661T16 0t5.614 2.386 2.339 5.661-2.339 5.614T16 16z"/></svg><svg viewBox="-7.27 -7.27 46.55 46.55" id="gdoc_search" xmlns="http://www.w3.org/2000/svg"><path d="M11.925 20.161q3.432 0 5.834-2.402t2.402-5.834-2.402-5.834-5.834-2.402-5.834 2.402-2.402 5.834 2.402 5.834 5.834 2.402zm10.981 0L32 29.255 29.255 32l-9.094-9.094v-1.458l-.515-.515q-3.26 2.831-7.721 2.831-4.976 0-8.45-3.432T.001 11.925t3.474-8.45 8.45-3.474 8.407 3.474 3.432 8.45q0 1.802-.858 4.075t-1.973 3.646l.515.515h1.458z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_shield" xmlns="http://www.w3.org/2000/svg"><path d="M22.167 15.166V3.5h-8.166v20.726c.93-.492 2.424-1.349 3.883-2.497 1.95-1.531 4.284-3.919 4.284-6.562zm3.499-13.999v14c0 7.674-10.737 12.523-11.192 12.724-.146.073-.31.109-.474.109s-.328-.036-.474-.109c-.456-.201-11.192-5.049-11.192-12.724v-14C2.334.529 2.863 0 3.501 0H24.5c.638 0 1.167.529 1.167 1.167z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_star" xmlns="http://www.w3.org/2000/svg"><path d="M14 22.052 5.324 27.31l2.3-9.859L0 10.813l10.056-.854L14 .692l3.944 9.267L28 10.813l-7.624 6.638 2.3 9.859z"/></svg><svg viewBox="-7.27 -7.27 42.55 42.55" id="gdoc_tag" xmlns="http://www.w3.org/2000/svg"><path d="M17.52 17.52v-7.041h-7.041v7.041h7.041zM28 10.479h-7.041v7.041H28v3.439h-7.041V28H17.52v-7.041h-7.041V28H7.04v-7.041H-.001V17.52H7.04v-7.041H-.001V7.04H7.04V-.001h3.439V7.04h7.041V-.001h3.439V7.04H28v3.439z"/></svg><svg viewBox="-7.27 -7.27 46.55 46.55" id="gdoc_timer" xmlns="http://www.w3.org/2000/svg"><path d="M16 29q4.428 0 7.536-3.143t3.107-7.571-3.107-7.536T16 7.643 8.464 10.75t-3.107 7.536 3.107 7.571T16 29zM26.714 9.786q1.214 1.571 2.107 4.036t.893 4.464q0 5.643-4 9.678T16 32t-9.714-4.036-4-9.678 4-9.678T16 4.572q1.929 0 4.464.929t4.107 2.143l2.143-2.214q1.143.929 2.143 2.143zM14.5 19.857v-9.143h3v9.143h-3zM20.571.001v3.071h-9.143V.001h9.143z"/></svg><svg viewBox="-7.27 -7.27 46.55 46.55" id="gdoc_xmpp" xmlns="http://www.w3.org/2000/svg"><path d="M31.995 4.237c-.449.175-1.12.433-1.936.745-1.544.591-2.328.891-2.924 1.093-.613.208-1.287.409-2.635.813-.911.272-1.672.495-2.212.651-.031.875 0 2.177-.292 3.635a21.837 21.837 0 0 1-2.016 5.765c-1.496 2.944-3.236 4.817-3.88 5.476-.056-.059-.112-.117-.168-.179-.707-.763-2.403-2.703-3.815-5.683-1.053-2.223-1.484-4.044-1.605-4.584-.356-1.589-.427-2.955-.427-4.117 0-.075-.036-.129-.101-.149-.721-.223-1.765-.519-2.887-.853-1.271-.379-2.193-.744-3.408-1.2-.493-.185-1.409-.547-2.217-.859C.723 4.499.113 4.236.041 4.236c-.005 0-.015 0-.023.012a.131.131 0 0 0-.019.076c.009.593.08 1.361.256 2.365.615 3.503 2.688 7.061 4.36 9.244 0 0 3.717 5.035 9.128 8.144l.303.176c-.009.008-.02.015-.028.021-1.717 1.316-3.201 1.977-3.579 2.14a15.71 15.71 0 0 1-2.219.772v.407a25.31 25.31 0 0 0 2.72-.487 26.72 26.72 0 0 0 5.075-1.792c.136.067.276.136.42.204 1.527.725 3.571 1.627 6.073 2.048.613.103 1.136.165 1.507.195a.109.109 0 0 0 .115-.091.55.55 0 0 0 .004-.217.107.107 0 0 0-.063-.073c-.505-.209-1.201-.4-1.983-.719-.935-.381-2.241-1.067-3.648-2.128a13.528 13.528 0 0 1-.367-.287c4.64-2.656 7.989-6.588 7.989-6.588 1.735-2.036 4.441-5.623 5.431-9.795.349-1.473.539-2.741.5-3.628z"/></svg></defs></svg>
135
136
137
138
139    <div
140      class="wrapper "
141    >
142      <input type="checkbox" class="hidden" id="menu-control" />
143      <input type="checkbox" class="hidden" id="menu-header-control" />
144      
145      <header class="gdoc-header">
146  <div class="container flex align-center justify-between">
147    
148      <label for="menu-control" class="gdoc-nav__control" tabindex="0">
149        <svg class="gdoc-icon gdoc_menu">
150          <title>Open Navigation</title>
151          <use xlink:href="#gdoc_menu"></use>
152        </svg>
153        <svg class="gdoc-icon gdoc_arrow_back">
154          <title>Close Navigation</title>
155          <use xlink:href="#gdoc_arrow_back"></use>
156        </svg>
157      </label>
158    
159    <div>
160      <a class="gdoc-brand gdoc-header__link" href="https://postgis.net/">
161        <span class="flex align-center">
162         <img
163            class="gdoc-brand__img"
164            src="/brand.svg"
165            alt=""
166          />
167          <span class="gdoc-brand__title">PostGIS</span>
168        </span>
169      </a>
170    </div>
171    <div class="gdoc-menu-header">
172      <span class="gdoc-menu-header__items">
173        
174
175
176        <span id="gdoc-color-theme">
177          <svg class="gdoc-icon gdoc_brightness_dark">
178            <title>Toggle Dark/Light/Auto mode</title>
179            <use xlink:href="#gdoc_brightness_dark"></use>
180          </svg>
181          <svg class="gdoc-icon gdoc_brightness_light">
182            <title>Toggle Dark/Light/Auto mode</title>
183            <use xlink:href="#gdoc_brightness_light"></use>
184          </svg>
185          <svg class="gdoc-icon gdoc_brightness_auto">
186            <title>Toggle Dark/Light/Auto mode</title>
187            <use xlink:href="#gdoc_brightness_auto"></use>
188          </svg>
189        </span>
190
191        <span class="gdoc-menu-header__home">
192          <a href="https://postgis.net/" class="gdoc-header__link">
193            <svg class="gdoc-icon gdoc_home">
194              <title>Back to homepage</title>
195              <use xlink:href="#gdoc_home"></use>
196            </svg>
197          </a>
198        </span>
199
200        
201
202
203
204
205        <span class="gdoc-menu-header__control">
206          <label for="menu-header-control">
207            <svg class="gdoc-icon gdoc_keyboard_arrow_right">
208              <use xlink:href="#gdoc_keyboard_arrow_right"></use>
209              <title>Close Menu Bar</title>
210            </svg>
211          </label>
212        </span>
213      </span>
214      <label for="menu-header-control" class="gdoc-menu-header__control">
215        <svg class="gdoc-icon gdoc_keyboard_arrow_left">
216          <use xlink:href="#gdoc_keyboard_arrow_left"></use>
217          <title>Open Menu Bar</title>
218        </svg>
219      </label>
220    </div>
221  </div>
222</header>
223
224
225
226      <main class="container flex flex-even">
227        
228          <aside class="gdoc-nav">
229            <nav>
230  
231  <div class="gdoc-search flex align-center">
232    <svg class="gdoc-icon gdoc_search"><use xlink:href="#gdoc_search"></use></svg>
233    <input
234      type="text"
235      id="gdoc-search-input"
236      class="gdoc-search__input"
237      placeholder="Search..."
238      aria-label="Search"
239      maxlength="64"
240      data-site-base-url="https://postgis.net/"
241      data-site-lang="en"
242    />
243    <ul id="gdoc-search-results" class="gdoc-search__list"></ul>
244  </div>
245
246
247
248
249  <section class="gdoc-nav--main">
250    
251    
252      
253
254  
255
256
257  <ul class="gdoc-nav__list">
258    
259    
260      
261
262      
263        
264      
265
266      
267        
268      
269    
270      
271
272      
273        
274      
275
276      
277        
278          
279          
280          
281          
282          
283          
284
285
286          <li>
287            <input
288              type="checkbox"
289              
290                class="hidden"
291              
292            />
293            <label
294              
295            >
296              
297                <span class="flex">
298                  <a
299                    href="/documentation/"
300                    class="gdoc-nav__entry"
301                  >
302                    Documentation
303                  </a>
304                </span>
305              
306              
307            </label>
308
309            
310              
311  
312
313
314  <ul class="gdoc-nav__list">
315    
316    
317      
318
319      
320        
321      
322
323      
324        
325          
326          
327          
328          
329          
330          
331
332
333          <li>
334            <input
335              type="checkbox"
336              
337                class="hidden"
338              
339            />
340            <label
341              
342            >
343              
344                <span class="flex">
345                  <a
346                    href="/documentation/getting_started/"
347                    class="gdoc-nav__entry"
348                  >
349                    Getting Started
350                  </a>
351                </span>
352              
353              
354            </label>
355
356            
357              
358  
359
360
361  <ul class="gdoc-nav__list">
362    
363    
364      
365
366      
367        
368      
369
370      
371        
372      
373        
374      
375        
376      
377        
378      
379        
380      
381    
382      
383
384      
385        
386      
387
388      
389        
390      
391    
392  </ul>
393
394            
395          </li>
396        
397      
398    
399      
400
401      
402        
403      
404
405      
406        
407          
408          
409          
410          
411          
412          
413
414
415          <li>
416            <input
417              type="checkbox"
418              
419                class="hidden"
420              
421            />
422            <label
423              
424            >
425              
426                <span class="flex">
427                  <a
428                    href="/documentation/manual/"
429                    class="gdoc-nav__entry"
430                  >
431                    Official Manual
432                  </a>
433                </span>
434              
435              
436            </label>
437
438            
439          </li>
440        
441      
442    
443      
444
445      
446        
447      
448
449      
450        
451          
452          
453          
454          
455          
456          
457
458
459          <li>
460            <input
461              type="checkbox"
462              
463                class="hidden"
464              
465            />
466            <label
467              
468            >
469              
470                <span class="flex">
471                  <a
472                    href="/documentation/tips/"
473                    class="gdoc-nav__entry"
474                  >
475                    Tips &amp; Tricks
476                  </a>
477                </span>
478              
479              
480            </label>
481
482            
483              
484  
485
486
487  <ul class="gdoc-nav__list">
488    
489    
490      
491
492      
493        
494      
495
496      
497        
498      
499    
500      
501
502      
503        
504      
505
506      
507        
508      
509        
510      
511    
512      
513
514      
515        
516      
517
518      
519        
520      
521    
522      
523
524      
525        
526      
527
528      
529        
530      
531        
532      
533    
534      
535
536      
537        
538      
539
540      
541        
542      
543    
544      
545
546      
547        
548      
549
550      
551        
552      
553        
554      
555    
556      
557
558      
559        
560      
561
562      
563        
564      
565        
566      
567        
568      
569    
570  </ul>
571
572            
573          </li>
574        
575      
576    
577      
578
579      
580        
581      
582
583      
584        
585          
586          
587          
588          
589          
590          
591
592
593          <li>
594            <input
595              type="checkbox"
596              
597                class="hidden"
598              
599            />
600            <label
601              
602            >
603              
604                <span class="flex">
605                  <a
606                    href="/documentation/training/"
607                    class="gdoc-nav__entry"
608                  >
609                    Training Materials
610                  </a>
611                </span>
612              
613              
614            </label>
615
616            
617          </li>
618        
619      
620    
621      
622
623      
624        
625      
626
627      
628        
629          
630          
631          
632          
633          
634          
635
636
637          <li>
638            <input
639              type="checkbox"
640              
641                class="hidden"
642              
643            />
644            <label
645              
646            >
647              
648                <span class="flex">
649                  <a
650                    href="/documentation/developer_docs/"
651                    class="gdoc-nav__entry"
652                  >
653                    Developer Documentation
654                  </a>
655                </span>
656              
657              
658            </label>
659
660            
661          </li>
662        
663      
664    
665      
666
667      
668        
669      
670
671      
672        
673          
674          
675          
676          
677          
678          
679
680
681          <li>
682            <input
683              type="checkbox"
684              
685                class="hidden"
686              
687            />
688            <label
689              
690            >
691              
692                <span class="flex">
693                  <a
694                    href="/documentation/faq/"
695                    class="gdoc-nav__entry"
696                  >
697                    FAQ
698                  </a>
699                </span>
700              
701              
702            </label>
703
704            
705              
706  
707
708
709  <ul class="gdoc-nav__list">
710    
711    
712      
713
714      
715        
716      
717
718      
719        
720      
721        
722      
723        
724      
725        
726      
727        
728      
729        
730      
731        
732      
733        
734      
735        
736      
737        
738      
739        
740      
741    
742  </ul>
743
744            
745          </li>
746        
747      
748    
749  </ul>
750
751            
752          </li>
753        
754      
755    
756      
757
758      
759        
760      
761
762      
763        
764          
765          
766          
767          
768          
769          
770
771
772          <li>
773            <input
774              type="checkbox"
775              
776                class="hidden"
777              
778            />
779            <label
780              
781            >
782              
783                <span class="flex">
784                  <a
785                    href="/community/"
786                    class="gdoc-nav__entry"
787                  >
788                    Community
789                  </a>
790                </span>
791              
792              
793            </label>
794
795            
796              
797  
798
799
800  <ul class="gdoc-nav__list">
801    
802    
803      
804
805      
806        
807      
808
809      
810        
811          
812          
813          
814          
815          
816          
817
818
819          <li>
820            <input
821              type="checkbox"
822              
823                class="hidden"
824              
825            />
826            <label
827              
828            >
829              
830                <span class="flex">
831                  <a
832                    href="/community/events/"
833                    class="gdoc-nav__entry"
834                  >
835                    Events
836                  </a>
837                </span>
838              
839              
840            </label>
841
842            
843              
844  
845
846
847  <ul class="gdoc-nav__list">
848    
849    
850      
851
852      
853        
854      
855
856      
857        
858      
859        
860      
861        
862      
863    
864  </ul>
865
866            
867          </li>
868        
869      
870        
871          
872          
873          
874          
875          
876          
877
878
879          <li>
880            <input
881              type="checkbox"
882              
883                class="hidden"
884              
885            />
886            <label
887              
888            >
889              
890                <span class="flex">
891                  <a
892                    href="/community/support/"
893                    class="gdoc-nav__entry"
894                  >
895                    Support
896                  </a>
897                </span>
898              
899              
900            </label>
901
902            
903          </li>
904        
905      
906    
907      
908
909      
910        
911      
912
913      
914        
915          
916          
917          
918          
919          
920          
921
922
923          <li>
924            <input
925              type="checkbox"
926              
927                class="hidden"
928              
929            />
930            <label
931              
932            >
933              
934                <span class="flex">
935                  <a
936                    href="/community/mailinglists/"
937                    class="gdoc-nav__entry"
938                  >
939                    Mailing Lists
940                  </a>
941                </span>
942              
943              
944            </label>
945
946            
947          </li>
948        
949      
950    
951      
952
953      
954        
955      
956
957      
958        
959          
960          
961          
962          
963          
964          
965
966
967          <li>
968            <input
969              type="checkbox"
970              
971                class="hidden"
972              
973            />
974            <label
975              
976            >
977              
978                <span class="flex">
979                  <a
980                    href="/community/chat/"
981                    class="gdoc-nav__entry"
982                  >
983                    Chat
984                  </a>
985                </span>
986              
987              
988            </label>
989
990            
991          </li>
992        
993      
994    
995      
996
997      
998        
999      
1000
1001      
1002        
1003          
1004          
1005          
1006          
1007          
1008          
1009
1010
1011          <li>
1012            <input
1013              type="checkbox"
1014              
1015                class="hidden"
1016              
1017            />
1018            <label
1019              
1020            >
1021              
1022                <span class="flex">
1023                  <a
1024                    href="/community/video/"
1025                    class="gdoc-nav__entry"
1026                  >
1027                    Video
1028                  </a>
1029                </span>
1030              
1031              
1032            </label>
1033
1034            
1035          </li>
1036        
1037      
1038    
1039      
1040
1041      
1042        
1043      
1044
1045      
1046        
1047          
1048          
1049          
1050          
1051          
1052          
1053
1054
1055          <li>
1056            <input
1057              type="checkbox"
1058              
1059                class="hidden"
1060              
1061            />
1062            <label
1063              
1064            >
1065              
1066                <span class="flex">
1067                  <a
1068                    href="/community/podcast/"
1069                    class="gdoc-nav__entry"
1070                  >
1071                    Podcast
1072                  </a>
1073                </span>
1074              
1075              
1076            </label>
1077
1078            
1079          </li>
1080        
1081      
1082    
1083      
1084
1085      
1086        
1087      
1088
1089      
1090        
1091          
1092          
1093          
1094          
1095          
1096          
1097
1098
1099          <li>
1100            <input
1101              type="checkbox"
1102              
1103                class="hidden"
1104              
1105            />
1106            <label
1107              
1108            >
1109              
1110                <span class="flex">
1111                  <a
1112                    href="/community/web/"
1113                    class="gdoc-nav__entry"
1114                  >
1115                    Web Forums
1116                  </a>
1117                </span>
1118              
1119              
1120            </label>
1121
1122            
1123          </li>
1124        
1125      
1126    
1127      
1128
1129      
1130        
1131      
1132
1133      
1134        
1135          
1136          
1137          
1138          
1139          
1140          
1141
1142
1143          <li>
1144            <input
1145              type="checkbox"
1146              
1147                class="hidden"
1148              
1149            />
1150            <label
1151              
1152            >
1153              
1154                <span class="flex">
1155                  <a
1156                    href="/community/conduct/"
1157                    class="gdoc-nav__entry"
1158                  >
1159                    Code of Conduct
1160                  </a>
1161                </span>
1162              
1163              
1164            </label>
1165
1166            
1167          </li>
1168        
1169      
1170    
1171  </ul>
1172
1173            
1174          </li>
1175        
1176      
1177    
1178      
1179
1180      
1181        
1182      
1183
1184      
1185        
1186          
1187          
1188          
1189          
1190          
1191          
1192
1193
1194          <li>
1195            <input
1196              type="checkbox"
1197              
1198                class="hidden"
1199              
1200            />
1201            <label
1202              
1203            >
1204              
1205                <span class="flex">
1206                  <a
1207                    href="/development/"
1208                    class="gdoc-nav__entry"
1209                  >
1210                    Development
1211                  </a>
1212                </span>
1213              
1214              
1215            </label>
1216
1217            
1218              
1219  
1220
1221
1222  <ul class="gdoc-nav__list">
1223    
1224    
1225      
1226
1227      
1228        
1229      
1230
1231      
1232        
1233      
1234    
1235      
1236
1237      
1238        
1239      
1240
1241      
1242        
1243          
1244          
1245          
1246          
1247          
1248          
1249
1250
1251          <li>
1252            <input
1253              type="checkbox"
1254              
1255                class="hidden"
1256              
1257            />
1258            <label
1259              
1260            >
1261              
1262                <span class="flex">
1263                  <a
1264                    href="/development/source_code/"
1265                    class="gdoc-nav__entry"
1266                  >
1267                    Source Code
1268                  </a>
1269                </span>
1270              
1271              
1272            </label>
1273
1274            
1275          </li>
1276        
1277      
1278    
1279      
1280
1281      
1282        
1283      
1284
1285      
1286        
1287          
1288          
1289          
1290          
1291          
1292          
1293
1294
1295          <li>
1296            <input
1297              type="checkbox"
1298              
1299                class="hidden"
1300              
1301            />
1302            <label
1303              
1304            >
1305              
1306                <span class="flex">
1307                  <a
1308                    href="/development/getting_involved/"
1309                    class="gdoc-nav__entry"
1310                  >
1311                    Getting Involved
1312                  </a>
1313                </span>
1314              
1315              
1316            </label>
1317
1318            
1319          </li>
1320        
1321      
1322    
1323      
1324
1325      
1326        
1327      
1328
1329      
1330        
1331          
1332          
1333          
1334          
1335          
1336          
1337
1338
1339          <li>
1340            <input
1341              type="checkbox"
1342              
1343                class="hidden"
1344              
1345            />
1346            <label
1347              
1348            >
1349              
1350                <span class="flex">
1351                  <a
1352                    href="/development/bug_reporting/"
1353                    class="gdoc-nav__entry"
1354                  >
1355                    Bug Reporting
1356                  </a>
1357                </span>
1358              
1359              
1360            </label>
1361
1362            
1363          </li>
1364        
1365      
1366    
1367      
1368
1369      
1370        
1371      
1372
1373      
1374        
1375          
1376          
1377          
1378          
1379          
1380          
1381
1382
1383          <li>
1384            <input
1385              type="checkbox"
1386              
1387                class="hidden"
1388              
1389            />
1390            <label
1391              
1392            >
1393              
1394                <span class="flex">
1395                  <a
1396                    href="/development/versions_eol/"
1397                    class="gdoc-nav__entry"
1398                  >
1399                    Versioning &amp; EOL
1400                  </a>
1401                </span>
1402              
1403              
1404            </label>
1405
1406            
1407          </li>
1408        
1409      
1410    
1411      
1412
1413      
1414        
1415      
1416
1417      
1418        
1419          
1420          
1421          
1422          
1423          
1424          
1425
1426
1427          <li>
1428            <input
1429              type="checkbox"
1430              
1431                class="hidden"
1432              
1433            />
1434            <label
1435              
1436            >
1437              
1438                <span class="flex">
1439                  <a
1440                    href="/development/compatibility/"
1441                    class="gdoc-nav__entry"
1442                  >
1443                    Compatibility &amp; Support
1444                  </a>
1445                </span>
1446              
1447              
1448            </label>
1449
1450            
1451          </li>
1452        
1453      
1454    
1455      
1456
1457      
1458        
1459      
1460
1461      
1462        
1463          
1464          
1465          
1466          
1467          
1468          
1469
1470
1471          <li>
1472            <input
1473              type="checkbox"
1474              
1475                class="hidden"
1476              
1477            />
1478            <label
1479              
1480            >
1481              
1482                <span class="flex">
1483                  <a
1484                    href="/development/rfcs/"
1485                    class="gdoc-nav__entry"
1486                  >
1487                    RFCs
1488                  </a>
1489                </span>
1490              
1491              
1492            </label>
1493
1494            
1495              
1496  
1497
1498
1499  <ul class="gdoc-nav__list">
1500    
1501    
1502      
1503
1504      
1505        
1506      
1507
1508      
1509        
1510      
1511        
1512      
1513        
1514      
1515        
1516      
1517        
1518      
1519    
1520  </ul>
1521
1522            
1523          </li>
1524        
1525      
1526    
1527  </ul>
1528
1529            
1530          </li>
1531        
1532      
1533    
1534  </ul>
1535
1536
1537
1538
1539
1540
1541    
1542  </section>
1543
1544  
1545
1546
1547  <section class="gdoc-nav--more">
1548    
1549      <h2>More</h2>
1550      
1551
1552  
1553  
1554
1555
1556  <ul class="gdoc-nav__list">
1557    
1558      
1559      
1560
1561
1562      <li>
1563        
1564        
1565          
1566          
1567          
1568          
1569          
1570          
1571          
1572
1573          
1574          
1575
1576          
1577            <input
1578              type="checkbox"
1579              
1580                class="hidden"
1581              
1582            />
1583            <label
1584              
1585            >
1586              <span class="flex">
1587                
1588                  <svg class="gdoc-icon gdoc_notification"><use xlink:href="#gdoc_notification"></use></svg>
1589                
1590                <a
1591                  href="/news"
1592                  class="gdoc-nav__entry"
1593                >
1594                  News
1595                </a>
1596              </span>
1597              
1598            </label>
1599          
1600        
1601
1602        
1603      </li>
1604    
1605      
1606      
1607
1608
1609      <li>
1610        
1611        
1612          
1613          
1614          
1615          
1616          
1617          
1618          
1619
1620          
1621          
1622
1623          
1624            <input
1625              type="checkbox"
1626              
1627                class="hidden"
1628              
1629            />
1630            <label
1631              
1632            >
1633              <span class="flex">
1634                
1635                  <svg class="gdoc-icon gdoc_download"><use xlink:href="#gdoc_download"></use></svg>
1636                
1637                <a
1638                  href="/development/source_code"
1639                  class="gdoc-nav__entry"
1640                >
1641                  Releases
1642                </a>
1643              </span>
1644              
1645            </label>
1646          
1647        
1648
1649        
1650      </li>
1651    
1652      
1653      
1654
1655
1656      <li>
1657        
1658        
1659          
1660          
1661          
1662          
1663          
1664          
1665          
1666
1667          
1668          
1669
1670          
1671            <input
1672              type="checkbox"
1673              
1674                class="hidden"
1675              
1676            />
1677            <label
1678              
1679            >
1680              <span class="flex">
1681                
1682                  <svg class="gdoc-icon gdoc_gitea"><use xlink:href="#gdoc_gitea"></use></svg>
1683                
1684                <a
1685                  href="
1686                    https://gitea.osgeo.org/postgis/postgis"
1687                  class="gdoc-nav__entry"
1688                >
1689                  View Source
1690                </a>
1691              </span>
1692              
1693            </label>
1694          
1695        
1696
1697        
1698      </li>
1699    
1700  </ul>
1701
1702
1703
1704
1705
1706
1707    
1708  </section>
1709</nav>
1710
1711          </aside>
1712        
1713
1714
1715        <div class="gdoc-page">
1716          
1717  
1718
1719
1720  
1721
1722
1723
1724
1725
1726
1727<div
1728  class="gdoc-page__header flex flex-wrap
1729  
1730    justify-between
1731  
1732  hidden-mobile
1733  "
1734  itemprop="breadcrumb"
1735>
1736  
1737    <div>
1738      <svg class="gdoc-icon gdoc_path hidden-mobile"><use xlink:href="#gdoc_path"></use></svg>
1739      <ol class="breadcrumb" itemscope itemtype="https://schema.org/BreadcrumbList">
1740        
1741        
1742        
1743        
1744  
1745  
1746    <li itemprop='itemListElement' itemscope itemtype='https://schema.org/ListItem'><span itemprop='name'>Home</span><meta itemprop='position' content='1' /></li>
1747  
1748
1749      </ol>
1750    </div>
1751  
1752  
1753</div>
1754
1755
1756
1757  <article
1758    class="gdoc-markdown gdoc-markdown__align--left"
1759  >
1760    <h1>Home</h1>
1761    <p>PostGIS extends the capabilities of the <a
1762  class="gdoc-markdown__link"
1763  href="https://postgresql.org"
1764>PostgreSQL</a> relational database by adding support for storing, indexing, and querying geospatial data.</p>
1765<p>PostGIS features include:</p>
1766<ul>
1767<li><strong>Spatial Data Storage</strong>: Store different types of spatial data such as points, lines, polygons, and multi-geometries, in both 2D and <a
1768  class="gdoc-markdown__link"
1769  href="docs/PostGIS_Special_Functions_Index.html#PostGIS_3D_Functions"
1770>3D</a> data.</li>
1771<li><strong>Spatial Indexing</strong>: Quickly <a
1772  class="gdoc-markdown__link"
1773  href="docs/using_postgis_dbmanagement.html#build-indexes"
1774>search</a> and retrieve spatial data based on its location.</li>
1775<li><strong>Spatial Functions</strong>: A wide range of spatial functions that allow you to filter and analyze spatial data, measuring <a
1776  class="gdoc-markdown__link"
1777  href="docs/ST_Distance.html"
1778>distances</a> and <a
1779  class="gdoc-markdown__link"
1780  href="docs/ST_Area.html"
1781>areas</a>, <a
1782  class="gdoc-markdown__link"
1783  href="docs/ST_Intersection.html"
1784>intersecting</a> geometries, <a
1785  class="gdoc-markdown__link"
1786  href="docs/ST_Buffer.html"
1787>buffering</a>, and more.</li>
1788<li><strong>Geometry Processing</strong>: Tools for <a
1789  class="gdoc-markdown__link"
1790  href="docs/ST_Union.html"
1791>processing</a> and <a
1792  class="gdoc-markdown__link"
1793  href="docs/ST_Translate.html"
1794>manipulating</a> geometry data, such as <a
1795  class="gdoc-markdown__link"
1796  href="docs/ST_Simplify.html"
1797>simplification</a>, <a
1798  class="gdoc-markdown__link"
1799  href="docs/ST_AsMVT.html"
1800>conversion</a>, and generalization.</li>
1801<li><strong>Raster Data Support</strong>: Storage and processing of <a
1802  class="gdoc-markdown__link"
1803  href="docs/RT_reference.html"
1804>raster data</a>, such as elevation data and weather data.</li>
1805<li><strong>Geocoding and Reverse Geocoding</strong>: Functions for <a
1806  class="gdoc-markdown__link"
1807  href="docs/postgis_installation.html#loading_extras_tiger_geocoder"
1808>geocoding</a> and reverse geocoding.</li>
1809<li><strong>Integration</strong>: Access and work with PostGIS using third party tools such as <a
1810  class="gdoc-markdown__link"
1811  href="https://qgis.org"
1812>QGIS</a>, <a
1813  class="gdoc-markdown__link"
1814  href="https://geoserver.org"
1815>GeoServer</a>, <a
1816  class="gdoc-markdown__link"
1817  href="https://mapserver.org"
1818>MapServer</a>, ArcGIS, Tableau.</li>
1819</ul>
1820
1821  </article>
1822
1823
1824
1825          <div class="gdoc-page__footer flex flex-wrap justify-between">
1826            
1827
1828
1829
1830
1831
1832
1833
1834
1835  
1836  
1837
1838  
1839
1840
1841
1842
1843
1844
1845
1846          </div>
1847        </div>
1848      </main>
1849
1850      <footer class="gdoc-footer">
1851  <nav class="container flex">
1852    <div>
1853      <section class="flex flex-wrap align-center">
1854        <span class="gdoc-footer__item gdoc-footer__item--row">
1855          Copyright &copy 2023, PostGIS PSC &amp; OSGeo
1856          
1857        </span>
1858        
1859        
1860      </section>
1861      
1862        <section class="flex flex-wrap align-center">
1863          <span class="gdoc-footer__item">
1864            Content licensed under
1865
1866            <a href="https://creativecommons.org/licenses/by-sa/4.0/" class="gdoc-footer__link no-wrap">CC BY-SA 4.0</a>
1867          </span>
1868        </section>
1869      
1870    </div>
1871
1872    
1873      <div class="flex flex-25 justify-end">
1874        <span class="gdoc-footer__item text-right">
1875          <a class="gdoc-footer__link fake-link" href="#" aria-label="Back to top">
1876            <svg class="gdoc-icon gdoc_keyboard_arrow_up">
1877              <use xlink:href="#gdoc_keyboard_arrow_up"></use>
1878            </svg>
1879            <span class="hidden-mobile">Back to top</span>
1880          </a>
1881        </span>
1882      </div>
1883    
1884  </nav>
1885</footer>
1886
1887    </div>
1888
1889    
1890  
1890<script defer src="/js/search-83320133.bundle.min.js"></script>
1890
1891
1892  </body>
1893</html>

Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.