875:
1135:
204:
132:
84:
38:
50:
Refractions
Research, Paul Ramsey, Dave Blasby, Mark Cave-Ayland, Regina Obe, Sandro Santilli, Olivier Courtin, Nicklas Avén, Bborie Park, Pierre Racine, Daniel Baston, Darafei Praliaskouski, Raúl Marín Rodríguez, Kevin Neufeld, Jeff Lounsbury, Chris Hodgson, Jorge Arévalo, Mateusz Loskot, Norman
353:
So we ended up having like three months where we got almost no direct revenue. We, you know, didn't all go on vacation for three months. We were kind of young, excited about the field. So we thought, you know, let's see if we can build something to store the spatial data in a database. And we had
349:
May of 2001, at that point I was running a small consulting company here in
Victoria, working for the provincial government, mostly working in the geospatial field. Because all of our contracts came from the provincial government, we were very tied to the cycle of when they would release and sign
354:
used
Postgres for one of our data processing projects the year previous, so we were kind of familiar with it. And that experimental work in the spring of 2001 ended up being released at the end of May 2001 as PostGIS version 0.1.
350:
contracts. And the government changed that year, so all the civil servants were very risk averse in terms of signing new contract contracts. They didn't know whether what their budget situation was going to be that year.
286:
Geometry types for Points, LineStrings, Polygons, MultiPoints, MultiLineStrings, MultiPolygons, GeometryCollections, 3D types TINS and polyhedral surfaces, including solids.
337:. Using light-weight geometries helps servers increase the amount of data migrated up from physical disk storage into RAM, improving query performance substantially.
360:
340:
PostGIS is registered as "implements the specified standard" for "Simple
Features for SQL" by the OGC. PostGIS has not been certified as compliant by the OGC.
292:
raster type - supports various pixel types and more than 1000 bands per raster. Since PostGIS 3, is a separate
PostgreSQL extension called postgis_raster.
289:
Spheroidal types under the geography datatype Points, LineStrings, Polygons, MultiPoints, MultiLineStrings, MultiPolygons and
GeometryCollections.
1160:
312:
Spatial operators for determining geospatial set operations, like union, difference, symmetric difference and buffers (provided by GEOS).
880:
250:
167:
1095:
172:
107:
929:
379:
In 2006 the OGC registered PostGIS as "implement the specified standard" for "Simple
Features for SQL".
333:
The PostGIS implementation is based on "light-weight" geometries and indexes optimized to reduce disk and
75:
1150:
369:
267:
184:
309:
Spatial operators for determining geospatial measurements like area, distance, length and perimeter.
942:
83:
915:
303:
17:
759:
788:
1109:
8:
1155:
968:
131:
1134:
1001:
990:
979:
203:
728:(via GISquirrel, ST-Links SpatialKit, ZigGIS, ArcSDE and other third-party connectors)
373:
258:) is an open source software program that adds support for geographic objects to the
151:
1034:
1012:
908:
957:
334:
218:
179:
142:
1056:
51:
Vine, Carl
Anderson, Ralph Mason, Klaus Foerster, Bruno Wolff III, Markus Schaber
1078:
1067:
888:
783:
737:
263:
1045:
1023:
580:
563:
298:
Spatial predicates for determining the interactions of geometries using the 3x3
648:
631:
614:
597:
546:
529:
512:
495:
478:
461:
444:
427:
410:
116:
1144:
830:
368:
Refractions
Research released the first version of PostGIS in 2001 under the
803:
322:(Generalized Search Tree) spatial indexes for high speed spatial querying.
777:
742:
721:
Many software products can use PostGIS as a database backend, including:
326:
259:
45:
853:
809:
799:
765:
753:
897:, the Dimensionally Extended nine-Intersection Model used by PostGIS
665:
295:
SQL/MM Topology support - via
PostgreSQL extension postgis_topology.
847:
841:
824:
814:
747:
155:
891:
and binary, descriptions of geospatial objects used within PostGIS
731:
894:
793:
725:
315:
299:
37:
771:
159:
147:
859:
835:
818:
319:
227:
705:
236:
693:
688:
239:
1128:
325:
Index selectivity support, to provide high performance
196:
376:, a stable "1.0" version followed on April 19, 2005.
251:
242:
230:
870:
233:
224:
1096:"PostGIS 3.3.3, 3.2.5, 3.1.9, 3.0.9 Patch Releases"
221:
1057:PostGIS 3.0.0alpha4, 2.5.3, 2.4.8, 2.3.10 Released
1142:
262:object-relational database. PostGIS follows the
27:Geospatial extension for the PostgreSQL Database
1090:
1088:
1086:
698:
1133:
1102:
1083:
1072:
1061:
1050:
361:Why people care about PostGIS and Postgres
202:
130:
82:
953:
951:
710:
14:
1143:
948:
329:for mixed spatial/non-spatial queries.
881:Free and open-source software portal
1161:Spatial database management systems
24:
650:Old version, yet still maintained:
633:Old version, yet still maintained:
616:Old version, yet still maintained:
599:Old version, no longer maintained:
582:Old version, no longer maintained:
565:Old version, no longer maintained:
548:Old version, no longer maintained:
531:Old version, no longer maintained:
514:Old version, no longer maintained:
497:Old version, no longer maintained:
480:Old version, no longer maintained:
463:Old version, no longer maintained:
446:Old version, no longer maintained:
429:Old version, no longer maintained:
412:Old version, no longer maintained:
25:
1172:
1120:
359:Paul Ramsey (September 8, 2023) "
1024:PostGIS 2.0.7 and 2.1.7 Released
943:OGC Implementing Product Details
873:
217:
36:
1039:
1028:
1017:
266:for SQL specification from the
1006:
995:
984:
973:
962:
936:
922:
13:
1:
1110:"PostGIS 3.3.4 Patch Release"
901:
694:Old version, still maintained
275:PostgreSQL external extension
173:Geographic information system
750:(via third-party connectors)
273:PostGIS is implemented as a
7:
866:
689:Old version, not maintained
280:
10:
1177:
945:Open Geospatial Consortium
370:GNU General Public License
343:
268:Open Geospatial Consortium
185:GNU General Public License
659:
642:
625:
608:
591:
574:
557:
540:
523:
506:
489:
472:
455:
438:
421:
404:
399:
396:
393:
390:
191:
178:
166:
141:
106:
102:
74:
70:
55:
44:
35:
716:
385:(as of 17 February 2022)
59:April 19, 2001
1068:PostGIS 2.4.10 Released
667:Current stable version:
1079:PostGIS 2.5.9 Released
1035:PostGIS 2.1.9 Released
1013:PostGIS 1.5.8 Released
969:PostGIS 1.0.6 Released
706:Latest preview version
366:
89:; 7 months ago
1002:PostGIS 1.4.2 Release
991:PostGIS 1.3.6 Release
980:PostGIS 1.2.1 Release
397:Latest minor version
347:
789:MapInfo Professional
187:(version 2 or later)
932:. 10 February 2022.
387:
363:" Path To Citus Con
32:
382:
374:release candidates
306:software library).
162:-compliant systems
30:
1151:Free GIS software
1046:PostGIS 2.2.8 EOL
930:"H.4. Extensions"
678:
677:
386:
302:(provided by the
210:
209:
87:/ 8 February 2024
16:(Redirected from
1168:
1137:
1132:
1131:
1129:Official website
1114:
1113:
1106:
1100:
1099:
1092:
1081:
1076:
1070:
1065:
1059:
1054:
1048:
1043:
1037:
1032:
1026:
1021:
1015:
1010:
1004:
999:
993:
988:
982:
977:
971:
966:
960:
955:
946:
940:
934:
933:
926:
920:
919:
912:
883:
878:
877:
876:
712:
707:
702:
695:
690:
685:
668:
651:
634:
617:
600:
583:
566:
549:
532:
515:
498:
481:
464:
447:
430:
413:
388:
384:
383:Release history
381:
364:
335:memory footprint
254:
249:
248:
245:
244:
241:
238:
235:
232:
229:
226:
223:
206:
201:
198:
143:Operating system
134:
129:
126:
124:
122:
120:
118:
97:
95:
90:
86:
66:
64:
40:
33:
29:
21:
1176:
1175:
1171:
1170:
1169:
1167:
1166:
1165:
1141:
1140:
1127:
1126:
1123:
1118:
1117:
1108:
1107:
1103:
1094:
1093:
1084:
1077:
1073:
1066:
1062:
1055:
1051:
1044:
1040:
1033:
1029:
1022:
1018:
1011:
1007:
1000:
996:
989:
985:
978:
974:
967:
963:
958:PostGIS History
956:
949:
941:
937:
928:
927:
923:
916:"PostGIS 3.4.2"
914:
913:
909:
904:
889:Well-known text
879:
874:
872:
869:
784:Manifold System
719:
714:
713:
708:
703:
696:
691:
686:
681:
666:
649:
632:
615:
598:
581:
564:
547:
530:
513:
496:
479:
462:
445:
428:
411:
400:Latest release
365:
358:
352:
351:
346:
283:
264:Simple Features
252:
220:
216:
195:
137:
115:
98:
94:8 February 2024
93:
91:
88:
62:
60:
56:Initial release
28:
23:
22:
15:
12:
11:
5:
1174:
1164:
1163:
1158:
1153:
1139:
1138:
1122:
1121:External links
1119:
1116:
1115:
1101:
1082:
1071:
1060:
1049:
1038:
1027:
1016:
1005:
994:
983:
972:
961:
947:
935:
921:
906:
905:
903:
900:
899:
898:
892:
885:
884:
868:
865:
864:
863:
857:
851:
845:
839:
833:
828:
822:
812:
807:
797:
791:
786:
781:
775:
769:
763:
757:
751:
745:
740:
735:
729:
718:
715:
711:Future release
709:
704:
700:Latest version
697:
692:
687:
680:
679:
676:
675:
672:
664:
661:
657:
656:
653:
647:
644:
640:
639:
636:
630:
627:
623:
622:
619:
613:
610:
606:
605:
602:
596:
593:
589:
588:
585:
579:
576:
572:
571:
568:
562:
559:
555:
554:
551:
545:
542:
538:
537:
534:
528:
525:
521:
520:
517:
511:
508:
504:
503:
500:
494:
491:
487:
486:
483:
477:
474:
470:
469:
466:
460:
457:
453:
452:
449:
443:
440:
436:
435:
432:
426:
423:
419:
418:
415:
409:
406:
402:
401:
398:
395:
394:First release
392:
356:
345:
342:
331:
330:
323:
313:
310:
307:
296:
293:
290:
287:
282:
279:
208:
207:
193:
189:
188:
182:
176:
175:
170:
164:
163:
145:
139:
138:
136:
135:
112:
110:
104:
103:
100:
99:
80:
78:
76:Stable release
72:
71:
68:
67:
57:
53:
52:
48:
42:
41:
26:
9:
6:
4:
3:
2:
1173:
1162:
1159:
1157:
1154:
1152:
1149:
1148:
1146:
1136:
1130:
1125:
1124:
1111:
1105:
1097:
1091:
1089:
1087:
1080:
1075:
1069:
1064:
1058:
1053:
1047:
1042:
1036:
1031:
1025:
1020:
1014:
1009:
1003:
998:
992:
987:
981:
976:
970:
965:
959:
954:
952:
944:
939:
931:
925:
917:
911:
907:
896:
893:
890:
887:
886:
882:
871:
861:
858:
855:
852:
849:
846:
843:
840:
837:
834:
832:
831:OpenStreetMap
829:
826:
823:
820:
816:
813:
811:
808:
805:
801:
798:
795:
792:
790:
787:
785:
782:
779:
776:
773:
770:
767:
764:
761:
758:
755:
752:
749:
746:
744:
741:
739:
736:
733:
730:
727:
724:
723:
722:
701:
684:
673:
671:
662:
658:
654:
645:
641:
637:
628:
624:
620:
611:
607:
603:
594:
590:
586:
577:
573:
569:
560:
556:
552:
543:
539:
535:
526:
522:
518:
509:
505:
501:
492:
488:
484:
475:
471:
467:
458:
454:
450:
441:
437:
433:
424:
420:
416:
407:
403:
389:
380:
377:
375:
371:
362:
355:
341:
338:
336:
328:
324:
321:
317:
314:
311:
308:
305:
301:
297:
294:
291:
288:
285:
284:
278:
276:
271:
269:
265:
261:
257:
256:
247:
214:
205:
200:
194:
190:
186:
183:
181:
177:
174:
171:
169:
165:
161:
157:
153:
149:
146:
144:
140:
133:
128:
114:
113:
111:
109:
105:
101:
85:
79:
77:
73:
69:
58:
54:
49:
47:
43:
39:
34:
19:
1104:
1074:
1063:
1052:
1041:
1030:
1019:
1008:
997:
986:
975:
964:
938:
924:
910:
720:
699:
682:
669:
378:
372:. After six
367:
348:
339:
332:
274:
272:
212:
211:
46:Developer(s)
743:CockroachDB
674:2023-07-28
663:2023-05-29
655:2023-05-29
646:2021-12-18
638:2023-05-29
629:2020-12-18
621:2023-05-29
612:2019-10-20
604:2022-11-12
595:2018-09-23
587:2022-04-24
578:2017-09-30
570:2019-08-11
561:2016-09-26
553:2018-11-22
544:2015-10-07
536:2017-09-19
527:2013-08-17
519:2015-04-06
510:2012-04-03
502:2012-11-15
493:2010-02-04
485:2010-03-11
476:2009-07-24
468:2009-05-06
459:2007-08-09
451:2007-01-11
442:2006-12-08
434:2007-01-31
425:2005-12-21
417:2005-12-06
408:2005-04-19
327:query plans
81:3.4.2
1156:PostgreSQL
1145:Categories
902:References
760:GeoNetwork
260:PostgreSQL
108:Repository
63:2001-04-19
854:TerraView
810:Maptitude
800:MapServer
766:GRASS GIS
754:GeoServer
867:See also
848:TerraLib
842:SAGA GIS
825:OpenJUMP
815:MapGuide
748:GeoMedia
391:Release
357:—
281:Features
156:Mac OS X
127:/postgis
125:/postgis
732:Cadcorp
683:Legend:
584:2.4.10
567:2.3.10
344:History
270:(OGC).
213:PostGIS
197:postgis
192:Website
180:License
152:Windows
92: (
61: (
31:PostGIS
18:Postgis
895:DE-9IM
862:(LGPL)
850:(LGPL)
796:(LGPL)
794:Mapnik
726:ArcGIS
670:3.3.4
652:3.2.5
635:3.1.9
618:3.0.9
601:2.5.9
550:2.2.8
533:2.1.9
516:2.0.7
499:1.5.8
482:1.4.2
465:1.3.6
448:1.2.1
431:1.1.7
414:1.0.6
318:-over-
316:R-tree
300:DE-9IM
123:/gitea
119:.osgeo
856:(GPL)
844:(GPL)
838:(GPL)
827:(GPL)
780:(GPL)
778:Kosmo
774:(GPL)
772:gvSIG
768:(GPL)
762:(GPL)
756:(GPL)
738:Carto
717:Users
160:POSIX
148:Linux
860:uDig
836:QGIS
819:LGPL
660:3.3
643:3.2
626:3.1
609:3.0
592:2.5
575:2.4
558:2.3
541:2.2
524:2.1
507:2.0
490:1.5
473:1.4
456:1.3
439:1.2
422:1.1
405:1.0
320:GiST
304:GEOS
255:-jis
253:POST
199:.net
168:Type
121:.org
804:BSD
734:SIS
117:git
1147::
1085:^
950:^
277:.
237:dʒ
228:oʊ
158:,
154:,
150:,
1112:.
1098:.
918:.
821:)
817:(
806:)
802:(
246:/
243:s
240:ɪ
234:t
231:s
225:p
222:ˈ
219:/
215:(
96:)
65:)
20:)
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.