Changes between Version 33 and Version 34 of InstallationGuidelines/PostgreSQL

Timestamp:

12/03/10 15:04:52 (14 years ago)

Author:

Fran Boon

Comment:

--

InstallationGuidelines/PostgreSQL

@@ -133 +133 @@
 == Add Geometry column to gis_location ==
 If using PostGIS, then once the tables have been created:
-
-Add geometry Column:
 {{{
 su postgres
 psql
 \d sahana
+# Ensure all POINTs have WKT entries
+UPDATE public.gis_location SET wkt = 'POINT (' || lon || ' ' || lat || ')' WHERE gis_feature_type = 1;
+# Add geometry Column
 SELECT AddGeometryColumn( 'public', 'gis_location', 'the_geom', 4326, 'GEOMETRY', 2 );
-exit
-}}}
-(if using Windows can use the Query Editor that comes with pgAdmin III)
-
-Populate existing entries:
-{{{
-su postgres
-psql
-\d sahana
+# Populate existing entries
 UPDATE public.gis_location SET the_geom = ST_SetSRID(ST_GeomFromText(wkt), 4326);
 exit
 }}}
+(if using Windows can use the Query Editor that comes with pgAdmin III)
 
 Ensure that future entries auto-populate properly: