Zen

Source string Source string

21/10000 · 21

The string is read only.

English Actions
:command:`ST_NumGeometries(multi/geomcollection)` returns the number of parts in the collection
:command:`ST_GeometryN(geometry, integer)` returns the specified part of the collection
:command:`ST_GeomFromText(text)` returns ``geometry``
:command:`ST_AsText(geometry)` returns WKT ``text``
:command:`ST_AsEWKT(geometry)` returns EWKT ``text``
:command:`ST_GeomFromWKB(bytea)` returns ``geometry``
:command:`ST_AsBinary(geometry)` returns WKB ``bytea``
:command:`ST_AsEWKB(geometry)` returns EWKB ``bytea``
:command:`ST_GeomFromGML(text)` returns ``geometry``
:command:`ST_AsGML(geometry)` returns GML ``text``
:command:`ST_GeomFromKML(text)` returns ``geometry``
:command:`ST_AsKML(geometry)` returns KML ``text``
:command:`ST_AsGeoJSON(geometry)` returns JSON ``text``
:command:`ST_AsSVG(geometry)` returns SVG ``text``
Also remember the tables we have available:
``nyc_census_blocks``
blkid, popn_total, boroname, geom
``nyc_streets``
name, type, geom
``nyc_subway_stations``
name, geom
``nyc_neighborhoods``
name, boroname, geom
Exercises
**What is the area of the 'West Village' neighborhood?**
The area is given in square meters. To get an area in hectares, divide by 10000. To get an area in acres, divide by 4047.
**What is the geometry type of ‘Pelham St’? The length?**
**What is the GeoJSON representation of the 'Broad St' subway station?**
**What is the total length of streets (in kilometers) in New York City?** (Hint: The units of measurement of the spatial data are meters, there are 1000 meters in a kilometer.)
**What is the area of Manhattan in acres?** (Hint: both ``nyc_census_blocks`` and ``nyc_neighborhoods`` have a ``boroname`` in them.)
or...

Loading…

No matching activity found.
Browse all string changes

Things to check

Multiple failing checks

Following checks are failing:
Unchanged translation: Spanish, Chinese (Simplified), Japanese, Swedish

Reset

Glossary

English English
No related strings found in the glossary.

String information

Flags
read-only
Source string location
../../en/geometries_exercises.rst:41
String age
3 years ago
Last updated
a year ago
Source string age
3 years ago
Translation file
postgis-intro/sources/locale/pot/geometries_exercises.pot, string 34