baptx

geonames_places_structure.sql

Oct 18th, 2017
116
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE places (
  2.     geonameid INT,
  3.     name VARCHAR(200),
  4.     asciiname VARCHAR(200),
  5.     alternatenames VARCHAR(10000),
  6.     latitude DECIMAL(7,5),
  7.     longitude DECIMAL(8,5),
  8.     feature_class CHAR(1),
  9.     feature_code VARCHAR(10),
  10.     country_code CHAR(2),
  11.     cc2 CHAR(200),
  12.     admin1_code VARCHAR(20),
  13.     admin2_code VARCHAR(80),
  14.     admin3_code VARCHAR(20),
  15.     admin4_code VARCHAR(20),
  16.     population BIGINT,
  17.     elevation VARCHAR(10),
  18.     dem INT,
  19.     timezone VARCHAR(40),
  20.     modification_date DATE
  21. );
RAW Paste Data