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 & 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 & 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 & 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 © 2023, PostGIS PSC & 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.