Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Tree: 18de79ebc1
Fetching contributors…

Cannot retrieve contributors at this time

103 lines (103 sloc) 2.426 kB
CREATE TABLE geo2010 (
FILEID VARCHAR(6) NOT NULL,
STUSAB VARCHAR(2) NOT NULL,
SUMLEV VARCHAR(3) NOT NULL,
GEOCOMP VARCHAR(2) NOT NULL,
CHARITER VARCHAR(3) NOT NULL,
CIFSN VARCHAR(2),
LOGRECNO VARCHAR(7) NOT NULL PRIMARY KEY,
REGION VARCHAR(1),
DIVISION VARCHAR(1),
STATE VARCHAR(2),
COUNTY VARCHAR(3),
COUNTYCC VARCHAR(2),
COUNTYSC VARCHAR(2),
COUSUB VARCHAR(5),
COUSUBCC VARCHAR(2),
COUSUBSC VARCHAR(2),
PLACE VARCHAR(5),
PLACECC VARCHAR(2),
PLACESC VARCHAR(2),
TRACT VARCHAR(6),
BLKGRP VARCHAR(1),
BLOCK VARCHAR(4),
IUC VARCHAR(2),
CONCIT VARCHAR(5),
CONCITCC VARCHAR(2),
CONCITSC VARCHAR(2),
AIANHH VARCHAR(4),
AIANHHFP VARCHAR(5),
AIANHHCC VARCHAR(2),
AIHHTLI VARCHAR(1),
AITSCE VARCHAR(3),
AITS VARCHAR(5),
AITSCC VARCHAR(2),
TTRACT VARCHAR(6),
TBLKGRP VARCHAR(1),
ANRC VARCHAR(5),
ANRCCC VARCHAR(2),
CBSA VARCHAR(5),
CBSASC VARCHAR(2),
METDIV VARCHAR(5),
CSA VARCHAR(3),
NECTA VARCHAR(5),
NECTASC VARCHAR(2),
NECTADIV VARCHAR(5),
CNECTA VARCHAR(3),
CBSAPCI VARCHAR(1),
NECTAPCI VARCHAR(1),
UA VARCHAR(5),
UASC VARCHAR(2),
UATYPE VARCHAR(1),
UR VARCHAR(1),
CD VARCHAR(2),
SLDU VARCHAR(3),
SLDL VARCHAR(3),
VTD VARCHAR(6),
VDT1 VARCHAR(1),
RESERVE2 VARCHAR(3),
ZCTA5 VARCHAR(5),
SUBMCD VARCHAR(5),
SUBMCDCC VARCHAR(2),
SDELM VARCHAR(5),
SDSEC VARCHAR(5),
SDUNI VARCHAR(5),
AREALAND VARCHAR(14),
AREAWATR VARCHAR(14),
NAME VARCHAR(90),
FUNCSTAT VARCHAR(1),
GCUNI VARCHAR(1),
POP100 VARCHAR(9),
HU100 VARCHAR(9),
INTPTLAT VARCHAR(11),
INTPTLON VARCHAR(12),
LSADC VARCHAR(2),
PARTFLAG VARCHAR(1),
RESERVE3 VARCHAR(6),
UGA VARCHAR(5),
STATENS VARCHAR(8),
COUNTYNS VARCHAR(8),
COUSUBNS VARCHAR(8),
PLACENS VARCHAR(8),
CONCITNS VARCHAR(8),
AIANHHNS VARCHAR(8),
AITSNS VARCHAR(8),
ANRCNS VARCHAR(8),
SUBMCDNS VARCHAR(8),
CD113 VARCHAR(2),
CD114 VARCHAR(2),
CD115 VARCHAR(2),
SLDU2 VARCHAR(3),
SLDU3 VARCHAR(3),
SLDU4 VARCHAR(3),
SLDL2 VARCHAR(3),
SLDL3 VARCHAR(3),
SLDL4 VARCHAR(3),
AIANHHLSC VARCHAR(2),
CSASC VARCHAR(2),
CNECTASC VARCHAR(2),
MEMI VARCHAR(1),
NMEMI VARCHAR(1),
PUMA VARCHAR(5),
RESERVED VARCHAR(18)
);
Jump to Line
Something went wrong with that request. Please try again.