Soft Upgrade Pre 9.1+ or without extensions 26 3.4.2 Hard upgrade 27 # 4 Data Management 29 4.1 GIS (⊗⊗) ⊗⊗⊗⊗ 29 4.1.1 OGC Geometry 29 4.1.1.1 Point 30 4.1.1.2 LineString 30 4.1.1.3 LinearRing 12. PostGIS Functions new or enhanced in 3.0 . . . . . ## Abstract PostGIS PostgreSQL GIS( ) PostGIS GiST R-Tree GIS .  created by Refractions Research Inc, as a spatial database technology research project. Refractions is a GIS and database consulting company in Victoria, British Columbia, Canada, specializing in data integration

# 3 PostGIS Frequently Asked Questions 40 # 4 Using PostGIS: Data Management and Queries 44 4.1 GIS Objects 44 4.1.1 OpenGIS WKB and WKT 44 4.1.2 PostGIS EWKB, EWKT and Canonical Forms 45 4.1.3 SQL-MM (DE-9IM) 58 4.3.6.1 Theory 60 4.4 Loading GIS (Vector) Data 64 4.4.1 Loading Data Using SQL 64 4.4.2 shp2pgsql: Using the ESRI Shapefile Loader 64 4.5 Retrieving GIS Data 66 4.5.1 Using SQL to Retrieve allows GIS (Geographic Information Systems) objects to be stored in the database. PostGIS includes support for GiST-based R-Tree spatial indexes, and functions for analysis and processing of GIS objects

allows GIS (Geographic Information Systems) objects to be stored in the database. PostGIS includes support for GiST-based R-Tree spatial indexes, and functions for analysis and processing of GIS objects created by Refractions Research Inc, as a spatial database technology research project. Refractions is a GIS and database consulting company in Victoria, British Columbia, Canada, specializing in data integration development group plans on supporting and enhancing PostGIS to better support a range of important GIS functionality in the areas of OGC and SQL/MM spatial standards, advanced topological constructs (coverages

allows GIS (Geographic Information Systems) objects to be stored in the database. PostGIS includes support for GiST-based R-Tree spatial indexes, and functions for analysis and processing of GIS objects created by Refractions Research Inc, as a spatial database technology research project. Refractions is a GIS and database consulting company in Victoria, British Columbia, Canada, specializing in data integration development group plans on supporting and enhancing PostGIS to better support a range of important GIS functionality in the areas of OGC and SQL/MM spatial standards, advanced topological constructs (coverages

“sites” framework The staticfiles app The syndication feed framework admin auth contenttypes flatpages gis humanize messages postgres redirects sessions sites sitemaps syndication Other add-ons Cross Site Request to be a world-class geographic Web framework. Its goal is to make it as easy as possible to build GIS Web applications and harness the power of spatially enabled data. Common Web application tools Django database. See the flatpages documentation. Requires the sites contrib package to be installed as well. gis A world-class geospatial framework built on top of Django, that enables storage, manipulation and display

“sites” framework The staticfiles app The syndication feed framework admin auth contenttypes flatpages gis humanize messages postgres redirects sessions sites sitemaps syndication Other add-ons Cross Site to be a world-class geographic web framework. Its goal is to make it as easy as possible to build GIS web applications and harness the power of spatially enabled data. Common web application tools Django database. See the flatpages documentation. Requires the sites contrib package to be installed as well. gis A world-class geospatial framework built on top of Django, that enables storage, manipulation and display

“sites” framework The staticfiles app The syndication feed framework admin auth contenttypes flatpages gis humanize messages postgres redirects sessions sites sitemaps syndication Other add-ons Cross Site Request to be a world-class geographic Web framework. Its goal is to make it as easy as possible to build GIS Web applications and harness the power of spatially enabled data. Common Web application tools Django database. See the flatpages documentation. Requires the sites contrib package to be installed as well. gis A world-class geospatial framework built on top of Django, that enables storage, manipulation and display

to be a world-class geographic Web framework. Its goal is to make it as easy as possible to build GIS Web applications and harness the power of spatially enabled data. 1.14 Common Web application tools to be a world-class geographic Web framework. Its goal is to make it as easy as possible to build GIS Web applications and harness the power of spatially enabled data. 770 Chapter 6. API Reference Django ORM for querying and manipulating spatial data. • Loosely-coupled, high-level Python interfaces for GIS geometry and raster operations and data manipulation in different formats. • Editing geometry fields

to be a world-class geographic Web framework. Its goal is to make it as easy as possible to build GIS Web applications and harness the power of spatially enabled data. 1.15 Common Web application tools to be a world-class geographic Web framework. Its goal is to make it as easy as possible to build GIS Web applications and harness the power of spatially enabled data. GeoDjango Tutorial Introduction GeoDjango Documentation, Release 1.11.30.dev20200305075726 • Loosely-coupled, high-level Python interfaces for GIS geometry and raster operations and data manipulation in different formats. • Editing geometry fields

“sites” framework The staticfiles app The syndication feed framework admin auth contenttypes flatpages gis humanize messages postgres redirects sessions sites sitemaps syndication Other add-ons Cross Site Request to be a world-class geographic Web framework. Its goal is to make it as easy as possible to build GIS Web applications and harness the power of spatially enabled data. Common Web application tools Django database. See the flatpages documentation. Requires the sites contrib package to be installed as well. gis A world-class geospatial framework built on top of Django, that enables storage, manipulation and display