PostGIS学习笔记3——数据说明

我们使用PostGIS的目的就是存储数据，查询数据。所以了解数据的各种信息是有必要的。

在此对使用的数据进行简要的说明。

详细信息在笔记2中下载的数据中（postgis-workshop-2018/print/nyc_data_dictionary)

点击此处获取表的属性

一、nyc_census_blocks

人口普查区块（census block）是报告人口普查数据的最小地理单位。

二、nyc_neighborhoods

纽约街区

三、nyc_streets

街道

四、nyc_subway_stations

地铁站

五、nyc_census_sociodata

社会人口经济数据。

注意：nyc_census_sociodata是一个非空间属性数据表。在进行任何空间分析之前，我们需要将其与人口普查的地理几何信息联系起来。

六、所有数据

nyc_census_blocks (38794 records)

blkid	A 15-digit code that uniquely identifies every census block. Eg: 360050001009000
popn_total	Total number of people in the census block
popn_white	Number of people self-identifying as “White” in the block
popn_black	Number of people self-identifying as “Black” in the block
popn_nativ	Number of people self-identifying as “Native American” in the block
popn_asian	Number of people self-identifying as “Asian” in the block
popn_other	Number of people self-identifying with other categories in the block
boroname	Name of the New York borough. Manhattan, The Bronx, Brooklyn, Staten Island, Queens
geom	Polygon boundary of the block

nyc_neighborhoods (129 records)

name	Name of the neighborhood
boroname	Name of the New York borough. Manhattan, The Bronx, Brooklyn, Staten Island, Queens
geom	Polygon boundary of the neighborhood

nyc_streets (19091 records)

name	Name of the street
oneway	Is the street one-way? “yes” = yes, “” = no
type	Road type. Eg. primary, secondary, residential, motorway
geom	Linear centerline of the street

nyc_subway_stations (491 records)

name	Name of the station
borough	Name of the New York borough. Manhattan, The Bronx, Brooklyn, Staten Island, Queens
routes	Subway lines that run through this station
transfers	Lines you can transfer to via this station
express	Stations where express trains stop, “express” = yes, “” = no
geom	Point location of the station

nyc_census_sociodata (2167 records)

tractid	An 11-digit code that uniquely identifies every census tract. Eg: 36005000100
transit_total	Number of workers in the tract
transit_private	Number of workers in the tract who use private automobiles / motorcycles
transit_public	Number of workers in the tract who take public transit
transit_walk	Number of workers in the tract who walk
transit_other	Number of workers in the tract who use other forms like walking / biking
transit_none	Number of workers in the tract who work from home
transit_time_mins	Total number of minutes spent in transit by all workers in the tract (minutes)
family_count	Number of familes in the tract
family_income_median	Median family income in the tract (dollars)
family_income_mean	Average family income in the tract (dollars)
family_income_aggregate	Total income of all families in the tract (dollars)
edu_total	Number of people with educational history
edu_no_highschool_dipl	Number of people with no highschool diploma
edu_highschool_dipl	Number of people with highschool diploma and no further education
edu_college_dipl	Number of people with college diploma and no further education
edu_graduate_dipl	Number of people with graduate school diploma