6. About our data¶
Los datos para este taller constan de cuatro shapefiles de la ciudad de Nueva York y una tabla de atributos de variables sociodemográficas. Hemos cargado los shapefiles como tablas de PostGIS y los datos sociodemográficos se añadirán más tarde durante el taller.
A continuación se describe el número de registros y la tabla de atributos para cada uno de los conjuntos de datos. Estos valores de atributos y relaciones son fundamentales para nuestros análisis posteriores.
Para explorar la naturaleza de las tablas en pgAdmin, botón derecho en una tabla resaltada y seleccionar Propiedades. Aparecerá un resumen de las propiedades de la tabla, incluyendo una lista de los atriburos de la tabla dentro de la pestaña Columnas.
6.1. nyc_census_blocks¶
A census block is the smallest geography for which census data is reported. All higher level census geographies (block groups, tracts, metro areas, counties, etc) can be built from unions of census blocks. We have attached some demographic data to our collection of blocks.
Number of records: 38794
blkid |
Un código de 15 dígitos que identifica de forma única cada bloque del censo. Ej: 360050001009000 |
popn_total |
Número total de personas en el bloque del censo |
popn_white |
Número de personas que se auto-identifican como «Blanco/a» |
popn_black |
Número de personas que se auto-identifican con «Negro/a» |
popn_nativ |
Número de personas que se auto-identifican como «Nativo/a Americano/a» |
popn_asian |
Número de personas que se auto-identifican como «Asiático/a» |
popn_other |
Número de personas que se auto-identifican como otras categorías |
boroname |
Nombre del distrito de Nueva York New York. Manhattan, The Bronx, Brooklyn, Staten Island, Queens |
geom |
Polygon boundary of the block |
Nota
Para introducir los datos del censo dentro del SIG, hay que unir dos piezas de información: los datos reales (texto) y los archivos de limites (espacial). Hay muchas formas para conseguir estos datos, incluyendo descargar ambos desde Census Bureau’s American FactFinder.
6.2. nyc_neighborhoods¶
Nueva York tiene una rica historia sobre los nombres y extensiones de sus barrios. Los barrios son constructos sociales que no siguen las lineas puestas por el gobierno. Por ejemplo, los barrios de Brooklyn de Carroll Gardens, Red Hook, y Cobble Hill se conocieron en cierto momento colectivamente como «Brooklyn Sur». Y ahora, en función del agente inmobiliario con el que se hable, los mismos cuatro bloques del barrio antes conocido como Red Hook ¡pueden ser Columbia Heights, Carroll Gardens West, o Red Hook!
Número de registros: 129
name |
Nombre del barrio |
boroname |
Nombre del distrito de Nueva York New York. Manhattan, The Bronx, Brooklyn, Staten Island, Queens |
geom |
Polígono de límite del barrio |
6.3. nyc_streets¶
The street centerlines form the transportation network of the city. These streets have been flagged with types in order to distinguish between such thoroughfares as back alleys, arterial streets, freeways, and smaller streets. Desirable areas to live might be on residential streets rather than next to a freeway.
Number of records: 19091
name |
Name of the street |
oneway |
Is the street one-way? «yes» = yes, «» = no |
tipo |
Road type (primary, secondary, residential, motorway) |
geom |
Linear centerline of the street |
6.4. nyc_subway_stations¶
The subway stations link the upper world where people live to the invisible network of subways beneath. As portals to the public transportation system, station locations help determine how easy it is for different people to enter the subway system.
Number of records: 491
name |
Name of the station |
borough |
Nombre del distrito de Nueva York New York. 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 |
6.5. nyc_census_sociodata¶
There is a rich collection of social-economic data collected during the census process, but only at the larger geography level of census tract. Census blocks combine to form census tracts (and block groups). We have collected some social-economic at a census tract level to answer some of these more interesting questions about New York City.
Nota
The nyc_census_sociodata
is a data table. We will need to connect it to Census geographies before conducting any spatial analysis.
tractid |
An 11-digit code that uniquely identifies every census tract. («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 families 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 high school diploma |
edu_highschool_dipl |
Number of people with high school 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 |