Difference between revisions of "PostGIS"

From gnewarchaeology wiki
Jump to: navigation, search
(Install & Configure)
 
Line 31: Line 31:
  
 
* [[PostGIS_update]]
 
* [[PostGIS_update]]
 +
 +
== Query tables ==
 +
 +
* [[PostGIS_query]]
  
 
== 3D functions ==
 
== 3D functions ==

Latest revision as of 16:10, 12 December 2016

PostGIS



References

Install & Configure

Alter table

Explicitly force the geometries into XYZ mode.

# ALTER TABLE geo ALTER COLUMN multigeom TYPE geometry(MultiPointZ) USING ST_Force3D(geom);

Insert geometries

Update geometries

Query tables

3D functions