Create a PostgreSQL table to hold the Individual_Landmarks.csv data

gistfile1.sql

CREATE TABLE landmarks
(
  gid serial NOT NULL,
  name character varying(50),
  address character varying(50),
  date_built character varying(10),
  architect character varying(50),
  landmark character varying(10),
  latitude double precision,
  longitude double precision,
  the_geom geometry,
  CONSTRAINT landmarks_pkey PRIMARY KEY (gid),
  CONSTRAINT enforce_dims_the_geom CHECK (st_ndims(the_geom) = 2),
  CONSTRAINT enforce_geotype_geom CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL),
  CONSTRAINT enforce_srid_the_geom CHECK (st_srid(the_geom) = 4326)
);

CREATE INDEX landmarks_the_geom_gist
  ON landmarks
  USING gist
  (the_geom );
  

I think lat and long are missing from this file , add these two lines before line 10:
latitude double precision,
longitude double precision,

I agree with atiwari87: in fact, when importing data from csv file, postgres says these columns are missing

Thanks @atiwari87 & @annalisapg. This has been updated (finally! 😄 ).