Census Tracts
City of Chicago
@usgov.city_of_chicago_census_tracts_c46f1
Table 1
@usgov.city_of_chicago_census_tracts_c46f1.table_1
- 3.15 MB
- 878 rows
- 18 columns
the_geomThe Geom | objectidOBJECTID | census_traCENSUS TRA | census_t_1CENSUS T 1 | tract_fipsTRACT FIPS | tract_centTRACT CENT | tract_ce_1TRACT CE 1 | tract_ce_2TRACT CE 2 | tract_ce_3TRACT CE 3 | tract_commTRACT COMM | tract_numaTRACT NUMA | tract_censTRACT CENS | perimeterPERIMETER | data_adminDATA ADMIN | tract_creaTRACT CREA | tract_cr_1TRACT CR 1 | shape_areaSHAPE AREA | shape_lenSHAPE LEN |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MULTIPOLYGON (((-87.69148523416723 41.70636229447373, -87.6914754960293 41.706316345296074, -87.69107315502133 41.70631746052196, -87.69077830359282 41.70632155035861, -87.6904336528242 41.706328230043404, -87.69025375994657 41.70633055181571, -87.69012348728083 41.706332232798374, -87.6898435238436… | 1 | 720500 | 17031720500 | 17031 | 1160171.70454335 | 1834962.2944345 | -87.68910702 | 41.70283387 | 72 | 36 | 2000 | 11228197.5722 | 14047.0507089 | ||||
| MULTIPOLYGON (((-87.64651275537268 41.732526590727836, -87.64655980183484 41.73243601703265, -87.64673086418252 41.731984803843936, -87.64685992359608 41.73164171239967, -87.64687928295783 41.731589851020146, -87.64687930672375 41.731589786670746, -87.64695574866539 41.73138500538614, -87.6471481448… | 2 | 730200 | 17031730200 | 17031 | 1169816.30242459 | 1843710.10211415 | -87.65353787 | 41.72663578 | 73 | 113 | 2000 | 20199335.5566 | 19738.525071 | ||||
| MULTIPOLYGON (((-87.66332792156787 41.72120307722428, -87.66344522717199 41.72120162660872, -87.66441444244973 41.723022626607396, -87.66536214972447 41.72480337097818, -87.66537700101595 41.724831223501766, -87.66708438610303 41.72803314093893, -87.66716132932197 41.728164970954886, -87.66731972340… | 3 | 730300 | 17031730300 | 17031 | 1166814.1830406 | 1843978.09707551 | -87.66452735 | 41.72743573 | 73 | 22 | 2000 | 3170252.61205 | 9848.21406776 | ||||
| MULTIPOLYGON (((-87.69645961375069 41.70714491311911, -87.69643643133804 41.70626199020595, -87.69631721263883 41.702704825927626, -87.69631248484181 41.70258096178059, -87.6963009301957 41.702285861546095, -87.69614814752514 41.69894057556605, -87.69602076977927 41.69892817508599, -87.6960164122129… | 4 | 740100 | 17031740100 | 17031 | 1157599.24855614 | 1832915.38233703 | -87.69858205 | 41.69726919 | 74 | 45 | 2000 | 9690785.77117 | 18058.3722532 | ||||
| MULTIPOLYGON (((-87.66338805460082 41.748478194296965, -87.6633496289828 41.74694000506063, -87.66334475088242 41.746714888192315, -87.66334076379856 41.746530886797004, -87.66332202623177 41.745774336365606, -87.66330657481171 41.745149284835925, -87.6633034672394 41.74493713163438, -87.66330237910… | 5 | 710500 | 17031710500 | 17031 | 1165053.80574048 | 1851288.62298081 | -87.67076974 | 41.74753426 | 71 | 33 | 2000 | 8038189.85397 | 12094.2889266 | ||||
| MULTIPOLYGON (((-87.6432732880789 41.830790161604774, -87.64367331037944 41.8307814347812, -87.64367832814499 41.83108173026176, -87.64368383230828 41.831300481385014, -87.64368928977544 41.83154409527644, -87.6436943634615 41.83176877141322, -87.64369971359744 41.83200533187517, -87.64370576010599 … | 37 | 601200 | 17031601200 | 17031 | 1172519.95496059 | 1882355.10264247 | -87.64249685 | 41.83262306 | 60 | 2 | 2000 | 882336.109774 | 3987.7210951 | ||||
| MULTIPOLYGON (((-87.66330237910246 41.74489404567535, -87.6632926698463 41.744509477872214, -87.66327941758269 41.74403951995413, -87.66327670887325 41.743944084519306, -87.66325400596213 41.743220085574535, -87.66325155885002 41.74307676371909, -87.6632494737065 41.74295462922027, -87.6632320549701… | 6 | 711200 | 17031711200 | 17031 | 1165328.30868512 | 1848758.35148806 | -87.66983536 | 41.74058502 | 71 | 56 | 2000 | 11845174.4386 | 13762.5188737 | ||||
| MULTIPOLYGON (((-87.66306513463402 41.73578978493854, -87.6630550556713 41.735357213298364, -87.66305306820797 41.735288483820085, -87.66301501006953 41.733972282640664, -87.66298992344137 41.733104657153255, -87.6629732309042 41.73257830998754, -87.66296089097114 41.73218920556312, -87.663333450422… | 7 | 711300 | 17031711300 | 17031 | 1166045.58905159 | 1846185.79267211 | -87.66728026 | 41.73351033 | 71 | 20 | 2000 | 3757463.37024 | 8553.67144808 | ||||
| MULTIPOLYGON (((-87.66208354218533 41.70670107920429, -87.6622307038326 41.70669977920317, -87.66227376533962 41.70670035834446, -87.6624545312561 41.70669688565753, -87.66286633965126 41.70668693985752, -87.66319384555874 41.70668036994959, -87.66359541719126 41.70667225515075, -87.6640425446487 41… | 8 | 720200 | 17031720200 | 17031 | 1166429.86748929 | 1838752.2573972 | -87.66608353 | 41.71310339 | 72 | 56 | 2000 | 17996571.0532 | 18245.0260748 | ||||
| MULTIPOLYGON (((-87.66576558201085 41.85233675822092, -87.66602422922897 41.85233105651881, -87.66602809926886 41.85282520685102, -87.66602891800888 41.852929712956644, -87.66603199045588 41.85322106068957, -87.66603211305869 41.85323264271926, -87.66603284381773 41.8533019666457, -87.66604140719689… | 97 | 310700 | 17031310700 | 17031 | 1166346.3655478 | 1890821.57159622 | -87.66490689 | 41.85598987 | 31 | 10 | 2000 | 1723521.25085 | 6609.22187367 |
CREATE TABLE table_1 (
"the_geom" VARCHAR,
"objectid" BIGINT,
"census_tra" BIGINT,
"census_t_1" BIGINT,
"tract_fips" BIGINT,
"tract_cent" DOUBLE,
"tract_ce_1" DOUBLE,
"tract_ce_2" DOUBLE,
"tract_ce_3" DOUBLE,
"tract_comm" BIGINT,
"tract_numa" BIGINT,
"tract_cens" BIGINT,
"perimeter" BIGINT,
"data_admin" BIGINT,
"tract_crea" VARCHAR,
"tract_cr_1" VARCHAR,
"shape_area" DOUBLE,
"shape_len" DOUBLE
);