Index: trunk/workshop-foss4g/about_data.rst
===================================================================
--- trunk/workshop-foss4g/about_data.rst	(revision 81)
+++ trunk/workshop-foss4g/about_data.rst	(revision 1)
@@ -1,62 +1,107 @@
 .. _about_data:
 
-Partie 5 : A propos de nos donnÃ©es
-==================================
+Section 5: About our data
+=========================
 
-Les donnÃ©es utilisÃ©es dans ces travaux pratiques sont quatre shapefiles de la ville de New York, et une table attributaire des variables socio-dÃ©mographiques de la ville. Nous les avons chargÃ©s sous forme de tables PostGIS et nous ajouterons les donnÃ©es  socio-dÃ©mographiques plus tard.
+The data for this workshop is four shapefiles for New York City, and one attribute table of sociodemographic variables.  We've loaded our shapefiles as PostGIS tables and will add sociodemographic data later in the workshop.
 
-Cette partie fournit le nombre d'enregistrements et les attributs de chacun de nos ensembles de donnÃ©es. Ces valeurs attributaires et les relations sont essentielles pour nos futures analyses.
+The following describes the number of records and table attributes for each of our datasets.  These attribute values and relationships are fundamental to our future analysis. 
 
-Pour visualiser la nature de vos tables depuis pgAdmin, cliquez avec le bouton droit sur une table et sÃ©lectionnez **Properties**. Vous trouverez un rÃ©sumÃ© des propriÃ©tÃ©s de la table, incluant la liste des attributs d'une table dans l'onglet **Columns**.
+To explore the nature of your tables in pgAdmin, right-click a highlighted table and select **Properties**.  You will find a summary of table properties, including a list of table attributes within the **Columns** tab.
 
 nyc_census_blocks
 -----------------
 
-Un bloc recensÃ© est la plus petite entitÃ© gÃ©ographique pour laquelle un recensement est rapportÃ©. Toutes les couches reprÃ©sentant les niveaux supÃ©rieurs (rÃ©gions, zones de mÃ©tro, comtÃ©s) peuvent Ãªtre contruites Ã  partir de ces blocs. Nous avons attachÃ© des donnÃ©es dÃ©mographiques aux blocs.
+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.
 
-Nombre d'enregistrements : 36592
+Number of records: 36592
 
 .. list-table::
-   :widths: 20 80
+   :widths: 20 80 
 
    * - **blkid**
-     - Un code Ã  15 chiffres qui permet d'identifier de maniÃšre unique chaque bloc **block**. Eg: 360050001009000
+     - A 15-digit code that uniquely identifies every census **block**. Eg: 360050001009000
    * - **popn_total**
-     - Nombre total de personnes dans le bloc
+     - Total number of people in the census block
    * - **popn_white**
-     - Nombre de personnes se dÃ©clarant comme de couleur blanche
+     - Number of people self-identifying as "White" in the block
    * - **popn_black**
-     - Nombre de personnes se dÃ©clarant comme de couleur noire
+     - Number of people self-identifying as "Black" in the block
    * - **popn_nativ**
-     - Nombre de personnes se dÃ©clarant comme natif d'AmÃ©rique du nord
+     - Number of people self-identifying as "Native American" in the block
    * - **popn_asian**
-     - Nombre de personnes se dÃ©clarant comme asiatique
+     - Number of people self-identifying as "Asian" in the block
    * - **popn_other**
-     - Nombre de personnes se dÃ©clarant comme faisant partie d'une autre catÃ©gorie
+     - Number of people self-identifying with other categories in the block
    * - **hous_total**
-     - Nombre de piÃšces dans le bloc
+     - Number of housing units in the block
    * - **hous_own**
-     - Nombre de propriÃ©taires occupant le bloc
+     - Number of owner-occupied housing units in the block
    * - **hous_rent**
-     - Nombre de locataires occupant le bloc
+     - Number of renter-occupied housing units in the block
    * - **boroname**
-     - Nom du quartier (Manhattan, The Bronx, Brooklyn, Staten Island, Queens)
+     - Name of the New York borough. Manhattan, The Bronx, Brooklyn, Staten Island, Queens
    * - **the_geom**
-     - Polygone reprÃ©sentant les contours d'un bloc
+     - Polygon boundary of the block
 
 .. figure:: ./screenshots/nyc_census_blocks.png
+   
+   *Black population as a percentage of Total Population* 
 
-   *Pourcentage de la population qui est de couleur noire*
+.. note:: 
 
-.. note::
-
-    Pour disposer des donnÃ©es d'un recensement dans votre SIG, vous avez besoin de joindre deux informations: Les donnÃ©es socio-dÃ©mographiques et les limites gÃ©ographiques des blocs/quartiers. Il existe plusieurs moyen de se les procurer, dans notre cas, elles ont Ã©tÃ© rÃ©cupÃ©rÃ©es sur le site Internet du Census Bureau's `American FactFinder <http://factfinder.census.gov>`_.
-
+    To get census data into GIS, you need to join two pieces of information: the actual data (text), and the boundary files (spatial).  There are many options for getting the data, including downloading data and boundaries from the Census Bureau's `American FactFinder <http://factfinder.census.gov>`_. 
+    
 nyc_neighborhoods
 -----------------
 
-Les quartiers de New York
+New York has a rich history of neighborhood names and extent.  Neighborhoods are social constructs that do not follow lines laid down by the government. For example, the Brooklyn neighborhoods of Carroll Gardens, Red Hook, and Cobble Hill were once collectively known as "South Brooklyn." And now, depending on which real estate agent you talk to, the same four blocks in the-neighborhood-formerly-known-as-Red-Hook can be referred to as Columbia Heights, Carroll Gardens West, or Red Hook! 
 
-Nombre d'enregistrements: 129
+Number of records: 129
+
+.. list-table::
+   :widths: 20 80 
+
+   * - **name**
+     - Name of the neighborhood
+   * - **boroname**
+     - Name of the New York borough. Manhattan, The Bronx, Brooklyn, Staten Island, Queens
+   * - **the_geom**
+     - Polygon boundary of the neighborhood
+   
+.. figure:: ./screenshots/nyc_neighborhoods.png
+
+    *The neighborhoods of New York City* 
+
+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
+
+.. list-table::
+   :widths: 20 80 
+
+   * - **name**
+     - Name of the street
+   * - **oneway**
+     - Is the street one-way? "yes" = yes, "" = no
+   * - **type**
+     - Road type. Eg. primary, secondary, residential, motorway
+   * - **the_geom**
+     - Linear centerline of the street
+   
+.. figure:: ./screenshots/nyc_streets.png
+
+     *The streets of New York City. Major roads are in red.*
+
+   
+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
 
 .. list-table::
@@ -64,73 +109,28 @@
 
    * - **name**
-     - Nom du quartier
-   * - **boroname**
-     - Nom de la section dans New York (Manhattan, The Bronx, Brooklyn, Staten Island, Queens)
+     - 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
    * - **the_geom**
-     - Limite polygonale du quartier
-
-.. figure:: ./screenshots/nyc_neighborhoods.png
-
-    *Les quartiers de New York*
-
-nyc_streets
------------
-
-Les rues de New York
-
-Nombre d'enregistrements: 19091
-
-.. list-table::
-   :widths: 20 80
-
-   * - **name**
-     - Nom de la rue
-   * - **oneway**
-     - Est-ce que la rue est Ã  sens unique ? "yes" = yes, "" = no
-   * - **type**
-     - Type de voie (Cf: primary, secondary, residential, motorway)
-   * - **the_geom**
-     - Ligne du centre de la rue.
-
-.. figure:: ./screenshots/nyc_streets.png
-
-     *Les rues de New York (les rues principales apparaissent en rouge)*
-
-
-nyc_subway_stations
--------------------
-
-Les stations de mÃ©tro de New York
-
-Nombre d'enregistrements: 491
-
-.. list-table::
-   :widths: 20 80
-
-   * - **name**
-     - Nom de la station
-   * - **borough**
-     - Nom de la section dans New York (Manhattan, The Bronx, Brooklyn, Staten Island, Queens)
-   * - **routes**
-     - Lignes de mÃ©tro passant par cette station
-   * - **transfers**
-     - Lignes de mÃ©tro accessibles depuis cette station
-   * - **express**
-     - Stations ou le train express s'arrÃªte, "express" = yes, "" = no
-   * - **the_geom**
-     - Localisation ponctuelle de la station
+     - Point location of the station
 
 .. figure:: ./screenshots/nyc_subway_stations.png
 
-    *Localisation ponctuelle des stations de mÃ©tro de New York*
+    *Point locations for New York City subway stations*
 
 nyc_census_sociodata
 --------------------
 
-DonnÃ©es socio-dÃ©mographiques de la ville de New York
+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. 
 
 .. note::
 
-   La donnÃ©e ``nyc_census_sociodata`` est une table attributaire. Nous devrons nous connecter aux gÃ©omÃ©tries correspondant Ã  la zone du recensement avant de conduire toute analyse spatiale .
+   The ``nyc_census_sociodata`` is a data table.  We will need to connect it to Census geographies before conducting any spatial analysis. 
 
 .. list-table::
@@ -138,30 +138,30 @@
 
    * - **tractid**
-     - Un code Ã  11 chiffre qui identifie chaque secteur de recensement. **tract**. Eg: 36005000100
+     - An 11-digit code that uniquely identifies every census **tract**. Eg: 36005000100
    * - **transit_total**
-     - Nombre de travailleurs dans le secteur
+     - Number of workers in the tract
    * - **transit_public**
-     - Nombre de travailleurs dans le secteur utilisant les transports en commun
+     - Number of workers in the tract who take public transit
    * - **transit_private**
-     - Nombre de travailleurs dans le secteur utilisant un vÃ©hicule privÃ©
+     - Number of workers in the tract who use private automobiles / motorcycles
    * - **transit_other**
-     - Nombre de travailleurs dans le secteur utilisant un autre moyen de transport
+     - Number of workers in the tract who use other forms like walking / biking
    * - **transit_time_mins**
-     - Nombre total de minutes passÃ©es dans les transports par l'ensemble des travailleurs du secteur (minutes)
+     - Total number of minutes spent in transit by all workers in the tract (minutes)
    * - **family_count**
-     - Nombre de familles dans le secteur
+     - Number of familes in the tract
    * - **family_income_median**
-     - Revenu mÃ©dian par famille du secteur (dollars)
+     - Median family income in the tract (dollars)
    * - **family_income_aggregate**
-     -  Revenu total de toutes les familles du secteur (dollars)
+     - Total income of all families in the tract (dollars)
    * - **edu_total**
-     - Nombre de personnes ayant un parcours scolaire
+     - Number of people with educational history
    * - **edu_no_highschool_dipl**
-     - Nombre de personnes n'ayant pas de diplÃŽme d'Ã©ducation secondaire
+     - Number of people with no highschool diploma
    * - **edu_highschool_dipl**
-     - Nombre de personnes ayant un diplÃŽme d'Ã©ducation secondaire
+     - Number of people with highschool diploma and no further education
    * - **edu_college_dipl**
-     - Nombre de personnes ayant un diplÃŽme de lycÃ©e
+     - Number of people with college diploma and no further education
    * - **edu_graduate_dipl**
-     - Nombre de personnes ayant un diplÃŽme de collÃšge
+     - Number of people with graduate school diploma 
 
