postgis-workshop/joins_exercises — Chinese (Simplified) @ OSGeo Weblate: ``nyc_census

Zen

	English	Chinese (Simplified)	Actions
	Spatial Joins Exercises	空间连接练习
	Here's a reminder of some of the functions we have seen. Hint: they should be useful for the exercises!	这里提醒一下我们见过的一些功能。提示：它们应该对练习有用！
	:command:`sum(expression)`: aggregate to return a sum for a set of records	:command:`sum(expression)`聚合函数用于对一组记录进行求和并返回总和
	:command:`count(expression)`: aggregate to return the size of a set of records	:command:`count(expression)`: 聚合函数用于返回一组记录的大小
	:command:`ST_Area(geometry)` returns the area of the polygons	:command:`ST_Area(geometry)` 返回多边形的面积
	:command:`ST_AsText(geometry)` returns WKT ``text``	:command:`ST_AsText(geometry)` 返回 WKT 格式的``text``
	:command:`ST_Contains(geometry A, geometry B)` returns the true if geometry A contains geometry B	:command:`ST_Contains(geometry A, geometry B)` 如果几何体A包含几何体B，则返回true
	:command:`ST_Distance(geometry A, geometry B)` returns the minimum distance between geometry A and geometry B	:command:`ST_Distance(geometry A, geometry B)`返回几何图形A和几何图形B之间的最小距离
	:command:`ST_DWithin(geometry A, geometry B, radius)` returns the true if geometry A is radius distance or less from geometry B	:command:`ST_DWithin(geometry A, geometry B, radius)`如果几何图形 A 与几何图形 B 的距离为‘radius’或更近，则返回 true
	:command:`ST_GeomFromText(text)` returns ``geometry``	:command:`ST_GeomFromText(text)`返回 ``geometry``
	:command:`ST_Intersects(geometry A, geometry B)` returns the true if geometry A intersects geometry B	:command:`ST_Intersects(geometry A, geometry B)`如果几何图形A与几何图形B相交，则返回true
	:command:`ST_Length(linestring)` returns the length of the linestring	:command:`ST_Length(linestring)` 返回线串的长度
	:command:`ST_Touches(geometry A, geometry B)` returns the true if the boundary of geometry A touches geometry B	:command:`ST_Touches(geometry A, geometry B)`如果几何体A的边界接触几何体B，则返回true
	:command:`ST_Within(geometry A, geometry B)` returns the true if geometry A is within geometry B	:command:`ST_Within(geometry A, geometry B)` 如果几何图形 A 在几何图形 B 内部，则返回 true
	Also remember the tables we have available:	当然！我们有以下表可用：
	``nyc_census_blocks``	``nyc_census_blocks``
	name, popn_total, boroname, geom	name, popn_total, boroname, geom
	``nyc_streets``	``nyc_streets``
	name, type, geom	name, type, geom
	``nyc_subway_stations``	``nyc_subway_stations``
	name, routes, geom	name, routes, geom
	``nyc_neighborhoods``	``nyc_neighborhoods``
	name, boroname, geom	name, boroname, geom
	Exercises	练习
	What subway station is in 'Little Italy'? What subway route is it on?	“Little Italy”有哪个地铁站？它在哪条地铁路线上？
	What are all the neighborhoods served by the 6-train? (Hint: The ``routes`` column in the ``nyc_subway_stations`` table has values like 'B,D,6,V' and 'C,6')	6 号列车服务的所有社区有哪些？ (提示： ``nyc_subway_stations`` 表中的``routes``列具有“B,D,6,V”和“C,6”等值)
	We used the ``DISTINCT`` keyword to remove duplicate values from our result set where there were more than one subway station in a neighborhood.	我们使用``DISTINCT``关键字从结果集中删除重复值，其中一个街区内有多个地铁站。
	After 9/11, the 'Battery Park' neighborhood was off limits for several days. How many people had to be evacuated?	9/11 事件后，“Battery Park”社区连续几天禁止进入。有多少人需要疏散？
	What neighborhood has the highest population density (persons/km2)?	哪个社区的人口密度最高（人/平方公里）？

Loading…

None Suggestion removed during cleanup postgis-workshop joins_exercises Chinese (Simplified)	English ``nyc_census_blocks`` Chinese (Simplified) 21 characters edited Current translation ``nyc_census_blocks`` 13 days ago
xinbo Translation added postgis-workshop joins_exercises Chinese (Simplified)	English ``nyc_census_blocks`` Chinese (Simplified) 21 characters edited Current translation Translated ``nyc_census_blocks`` 2 weeks ago
mt:weblate-translation-memory Suggestion added postgis-workshop joins_exercises Chinese (Simplified)	English ``nyc_census_blocks`` Chinese (Simplified) 21 characters edited Current translation ``nyc_census_blocks`` 2 weeks ago
None String added in the repository postgis-workshop joins_exercises Chinese (Simplified)	English ``nyc_census_blocks`` Chinese (Simplified) 0 characters edited Empty 2 weeks ago