Re: Importing csv files containing multiple geometries in postgis - Mailing list pgsql-admin

Hello ,


This table keep all geometry type (point , polygon, linestring). Your data is including all of them I think. Could you
sendyour csv data . I will try  insert into  a spatial table maybe.
 


CREATE TABLE mygis_table
(
  objectid serial not null,
  poly geometry(Geometry,4326),
  CONSTRAINT mygis_table_pkey PRIMARY KEY (objectid)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE mygis_table
  OWNER TO postgres;

-- Index: "gixB19E787C"

-- DROP INDEX "gixB19E787C";

CREATE INDEX "gixB19E787C"
  ON mygis_table
  USING gist
  (poly);


I hope I will help you.


Best wishes.



-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Rose Beck
Sent: Thursday, March 10, 2016 8:39 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Importing csv files containing multiple geometries in postgis

I have the following data in tab delimited csv file (containing latitude and longitude of places):

    <place1> <geo> "POLYGON((-5.8335446 43.3655635,-5.8336337
43.3655207,-5.8349218 43.3673341,-5.8345197 43.3674013,-5.8336182
43.3660938,-5.8335037 43.365924,-5.8334505 43.3658461,-5.8334702
43.3657311,-5.8335446 43.3655635))" .
    <place2> <geo> "POINT((-5.8374796 43.3687922))" .
    <place3> <geo> "LINESTRING((-5.8427265 43.3678474,-5.8421236 43.3677908))" .
    <place4> <geo> "MULTIPOINT((-5.8445678 43.3589236,-5.8435222
43.358205,-5.8429834 43.3575551,-5.8429127 43.3572642))" .

I want to import this data into postgis. In order to do so, I need to create a table in my database first. I know I can
createa table for one specific geometry(e.g. for POINT) using:
 

    create table myTable (firstColumn varchar(100));
    SELECT AddGeometryColumn( 'myTable', 'geom', 4269, 'POINT', 2 );

But I am not able to understand as to how can I import my csv file containing varied geometries into postgres in a
singletable in a single column myTable. I also want to construct a single "gist" index on the top of myTable
 


--
With Warm Regards,
Rose


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin









SELCUK AYDIN
PROJE UZMANI
selcuk.aydin@netcad.com.tr

Cyber Park B Blok No:409
06800, Bilkent / Ankara
Tel. :(312) 265 0510 - 1192
Faks: (312) 265 0520
[NETCAD] <http://www.netcad.com.tr/>