Index: trunk/workshop-foss4g/projection_exercises.rst
===================================================================
--- trunk/workshop-foss4g/projection_exercises.rst	(revision 81)
+++ trunk/workshop-foss4g/projection_exercises.rst	(revision 1)
@@ -1,45 +1,45 @@
 .. _projection_exercises:
 
-Partie 16 : Exercices sur les projections
-=========================================
+Section 16: Projection Exercises
+================================
 
-Voici un rappel de certaines fonctions que nous avons vu. Elles seront utiles pour les exercices !
+Here's a reminder of some of the functions we have seen.  Hint: they should be useful for the exercises!
 
-* :command:`sum(expression)` agrÃ©gation qui retourne la somme d'un ensemble de valeurs
-* :command:`ST_Length(linestring)` retourne la longueur d'une ligne
-* :command:`ST_SRID(geometry, srid)` retourne le SRID d'une gÃ©omÃ©trie
-* :command:`ST_Transform(geometry, srid)` reprojette des gÃ©omÃ©tries dans un autre systÃšme de rÃ©fÃ©rence spatiale
-* :command:`ST_GeomFromText(text)` retourne un objet ``geometry``
-* :command:`ST_AsText(geometry)` retourne un WKT (``texte``)
-* :command:`ST_AsGML(geometry)` retourne un GML (``texte``)
+* :command:`sum(expression)` aggregate to return a sum for a set of records
+* :command:`ST_Length(linestring)` returns the length of the linestring
+* :command:`ST_SRID(geometry, srid)` returns the SRID of the geometry
+* :command:`ST_Transform(geometry, srid)` converts geometries into different spatial reference systems
+* :command:`ST_GeomFromText(text)` returns ``geometry``
+* :command:`ST_AsText(geometry)` returns WKT ``text``
+* :command:`ST_AsGML(geometry)` returns GML ``text``
 
-Rappelez-vous les ressources en ligne :
+Remember the online resources that are available to you:
 
 * http://spatialreference.org
 * http://prj2epsg.org
 
-Et les tables disponibles :
+Also remember the tables we have available:
 
- * ``nyc_census_blocks``
-
+ * ``nyc_census_blocks`` 
+ 
    * name, popn_total, boroname, the_geom
-
+ 
  * ``nyc_streets``
-
+ 
    * name, type, the_geom
-
+   
  * ``nyc_subway_stations``
-
+ 
    * name, the_geom
-
+ 
  * ``nyc_neighborhoods``
-
+ 
    * name, boroname, the_geom
 
-Exercices
+Exercises
 ---------
 
- * **"Quelle est la longueur des rue de New York, mesurÃ©e en UTM 18 ?"**
-
+ * **"What is the length of all streets in New York, as measured in UTM 18?"**
+ 
    .. code-block:: sql
 
@@ -47,10 +47,10 @@
        FROM nyc_streets;
 
-   ::
-
+   :: 
+   
      10418904.7172
-
- * **"Quelle est la dÃ©finition du SRID 2831 ?"**
-
+      
+ * **"What is the WKT definition of SRID 2831?"**   
+    
    .. code-block:: sql
 
@@ -58,35 +58,35 @@
      WHERE SRID = 2831;
 
-Ou, via `prj2epsg <http://prj2epsg.org/epsg/2831>`_
+Or, via `prj2epsg <http://prj2epsg.org/epsg/2831>`_
 
  ::
 
-  PROJCS["NAD83(HARN) / New York Long Island",
-  GEOGCS["NAD83(HARN)",
-    DATUM["NAD83 (High Accuracy Regional Network)",
-      SPHEROID["GRS 1980", 6378137.0, 298.257222101, AUTHORITY["EPSG","7019"]],
-      TOWGS84[-0.991, 1.9072, 0.5129, 0.0257899075194932, -0.009650098960270402, -0.011659943232342112, 0.0],
-      AUTHORITY["EPSG","6152"]],
-    PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]],
-    UNIT["degree", 0.017453292519943295],
-    AXIS["Geodetic longitude", EAST],
-    AXIS["Geodetic latitude", NORTH],
-    AUTHORITY["EPSG","4152"]],
-  PROJECTION["Lambert Conic Conformal (2SP)", AUTHORITY["EPSG","9802"]],
-  PARAMETER["central_meridian", -74.0],
-  PARAMETER["latitude_of_origin", 40.166666666666664],
-  PARAMETER["standard_parallel_1", 41.03333333333333],
-  PARAMETER["false_easting", 300000.0],
-  PARAMETER["false_northing", 0.0],
-  PARAMETER["scale_factor", 1.0],
-  PARAMETER["standard_parallel_2", 40.666666666666664],
-  UNIT["m", 1.0],
-  AXIS["Easting", EAST],
-  AXIS["Northing", NORTH],
+  PROJCS["NAD83(HARN) / New York Long Island", 
+  GEOGCS["NAD83(HARN)", 
+    DATUM["NAD83 (High Accuracy Regional Network)", 
+      SPHEROID["GRS 1980", 6378137.0, 298.257222101, AUTHORITY["EPSG","7019"]], 
+      TOWGS84[-0.991, 1.9072, 0.5129, 0.0257899075194932, -0.009650098960270402, -0.011659943232342112, 0.0], 
+      AUTHORITY["EPSG","6152"]], 
+    PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]], 
+    UNIT["degree", 0.017453292519943295], 
+    AXIS["Geodetic longitude", EAST], 
+    AXIS["Geodetic latitude", NORTH], 
+    AUTHORITY["EPSG","4152"]], 
+  PROJECTION["Lambert Conic Conformal (2SP)", AUTHORITY["EPSG","9802"]], 
+  PARAMETER["central_meridian", -74.0], 
+  PARAMETER["latitude_of_origin", 40.166666666666664], 
+  PARAMETER["standard_parallel_1", 41.03333333333333], 
+  PARAMETER["false_easting", 300000.0], 
+  PARAMETER["false_northing", 0.0], 
+  PARAMETER["scale_factor", 1.0], 
+  PARAMETER["standard_parallel_2", 40.666666666666664], 
+  UNIT["m", 1.0], 
+  AXIS["Easting", EAST], 
+  AXIS["Northing", NORTH], 
   AUTHORITY["EPSG","2831"]]
+  
 
-
- * **"Quelle est la longueur des rues de New York, mesurÃ©e en utilisant le SRID 2831 ?"**
-
+ * **"What is the length of all streets in New York, as measured in SRID 2831?"**
+ 
    .. code-block:: sql
 
@@ -94,24 +94,23 @@
        FROM nyc_streets;
 
-   ::
-
+   :: 
+   
      10421993.706374
-
+     
    .. note::
-
-     La diffÃ©rence entre les mesure en UTM 18 et en Stateplane Long Island est de (10421993 - 10418904)/10418904, soit 0.02%. CalculÃ© sur la sphÃ©roÃ¯de en utilissant en :ref:`geography`, le total des longueurs des routes est 10421999, ce qui est proche de la valeur dans l'autre systÃšme de projection (Stateplane Long Island). Ce dernier est prÃ©cisÃ©ment calibrÃ© pour une petite zone gÃ©ographique (la ville de New York) alors que le systÃšme UTM 18 doit fournir un rÃ©sultat raisonnable pour une zone rÃ©gionale beaucoup plus large.
-
- * **"Quelle est la reprÃ©sentation KML du point de la station de mÃ©tris 'Broad St' ?"**
-
+   
+     The difference between the UTM 18 and the Stateplane Long Island measurements is (10421993 - 10418904)/10418904, or 0.02%. Calculated on the spheroid using :ref:`geography` the total street length is 10421999, which is closer to the Stateplane value. This is not surprising, since the Stateplane Long Island projection is precisely calibrated for a very small area (New York City) while UTM 18 has to provide reasonable results for a large regional area.
+     
+ * **"What is the KML representation of the point at 'Broad St' subway station?"**
+ 
    .. code-block:: sql
-
-     SELECT ST_AsKML(the_geom)
+   
+     SELECT ST_AsKML(the_geom) 
      FROM nyc_subway_stations
      WHERE name = 'Broad St';
-
-   ::
-
+     
+   :: 
+   
      <Point><coordinates>-74.010671468873468,40.707104815584088</coordinates></Point>
-
-HÃ© ! les coordonnÃ©es sont gÃ©ographiques bien que nous n'ayons pas fait appel Ã  la fonction  :command:`ST_Transform`, mais pourquoi ? Parce que le standard KML spÃ©cifie que toutes les coordonnÃ©es *doivent* Ãªtre gÃ©ographiques (en fait, dans le systÃšme EPSG:4326), donc la fonction :command:`ST_AsKML` rÃ©alise la transformation automatiquement.
-
+     
+Hey! The coordinates are in geographics even though we didn't call :command:`ST_Transform`, why? Because the KML standard dictates that all coordinates *must* be in geographics (ESPG:4326, in fact) so the :command:`ST_AsKML` function does the transformation automatically.
