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

template| |Upgrading spatial databases| |Soft upgrade| |Hard upgrade| 1. PostGIS Usage Data Management GIS Objects PostGIS Geography Type Spatial Metadata Tables Geometry Validation Loading Spatial Data 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

|Loader/Dumper| 3. PostGIS Frequently Asked Questions 1. Using PostGIS: Data Management and Queries GIS Objects OpenGIS WKB and WKT PostGIS EWKB, EWKT and Canonical Forms SQL-MM Part 3 PostGIS Geography Dimensionally Extended 9 Intersection Model (DE-9IM) Loading GIS (Vector) Data Loading Data Using SQL shp2pgsql: Using the ESRI Shapefile Loader Retrieving GIS Data Using SQL to Retrieve Data Using the Dumper 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