Changes between Version 241 and Version 242 of UserGuidelines/GIS/Data

Timestamp:

10/25/17 10:32:04 (8 years ago)

Author:

Fran Boon

Comment:

Import from CSV

UserGuidelines/GIS/Data

@@ -203 +203 @@
 
  * http://docs.geoserver.org/stable/en/user/gettingstarted/web-admin-quickstart/index.html
+
+==== Import CSV ====
+1. Prepare CSV (no extraneous columns, must be labelled same as schema, WKT data in a column)
+2. Create the Schema in PostGIS:
+{{{
+CREATE TABLE my_table
+(
+  gid serial NOT NULL,
+  name character varying(50),
+  the_geom geometry,
+  CONSTRAINT my_table_pkey PRIMARY KEY (gid),
+  CONSTRAINT enforce_dims_the_geom CHECK (st_ndims(the_geom) = 2)
+);
+
+CREATE INDEX my_table_the_geom_gist
+  ON my_table
+  USING gist
+  (the_geom );
+}}}
+2. Import the CSV
+{{{
+psql
+\c gis
+\copy my_table(name,the_geom) FROM 'my_csv.csv' DELIMITERS ',' CSV HEADER;
+}}}
+
+* Help was taken from: http://www.kevfoo.com/2012/01/Importing-CSV-to-PostGIS/
 
 ==== Import GeoJSON ====