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

Zen

	English	Chinese (Simplified)	Actions
	Spatial Relationships Exercises	空间关系练习
	Here's a reminder of the functions we saw in the last section. 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:`sum(expression)`聚合函数用于返回一组记录的大小
	:command:`ST_Contains(geometry A, geometry B)` returns true if geometry A contains geometry B	:command:`ST_Contains(geometry A, geometry B)`如果几何图形 A 包含几何图形 B，则返回 true
	:command:`ST_Crosses(geometry A, geometry B)` returns true if geometry A crosses geometry B	:command:`ST_Crosses(geometry A, geometry B)`如果几何图形A与几何图形B交叉，则返回true
	:command:`ST_Disjoint(geometry A , geometry B)` returns true if the geometries do not "spatially intersect"	:command:`ST_Disjoint(geometry A , geometry 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 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_Equals(geometry A, geometry B)` returns true if geometry A is the same as geometry B	:command:`ST_Equals(geometry A, geometry B)`如果几何图形 A 与几何图形 B 相同，则返回 true
	:command:`ST_Intersects(geometry A, geometry B)` returns true if geometry A intersects geometry B	:command:`ST_Intersects(geometry A, geometry B)`如果几何图形 A 与几何图形 B 相交，则返回 true
	:command:`ST_Overlaps(geometry A, geometry B)` returns true if geometry A and geometry B share space, but are not completely contained by each other.	:command:`ST_Overlaps(geometry A, geometry B)`如果几何体A和几何体B有公共空间，但不完全由彼此包含，则返回true。
	:command:`ST_Touches(geometry A, geometry B)` returns 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 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``
	blkid, popn_total, boroname, geom	blkid, popn_total, boroname, geom
	``nyc_streets``	``nyc_streets``
	name, type, geom	name, type, geom
	``nyc_subway_stations``	``nyc_subway_stations``
	name, geom	name, geom
	``nyc_neighborhoods``	``nyc_neighborhoods``
	name, boroname, geom	name, boroname, geom
	Exercises	练习
	What is the geometry value for the street named 'Atlantic Commons'?	名为“Atlantic Commons”的街道的几何值是多少？
	What neighborhood and borough is Atlantic Commons in?	“Atlantic Commons ”位于哪个街区和行政区?
	"Hey, why did you change from a 'MULTILINESTRING' to a 'LINESTRING'?" Spatially they describe the same shape, so going from a single-item multi-geometry to a singleton saves a few keystrokes.	“嘿，为什么从‘MULTILINESTRING’更改为‘LINESTRING’？”它们在空间上描述相同的形状，因此从单项多几何图形到单项可以节省一些击键次数。
	More importantly, we also rounded the coordinates to make them easier to read, which does actually change results: we couldn't use the ST_Touches() predicate to find out which roads join Atlantic Commons, because the coordinates are not exactly the same anymore.	更重要的是，我们还对坐标进行了舍入，以使其更易读，这实际上改变了结果：我们无法使用 ST_Touches() 谓词来确定哪些道路连接到 Atlantic Commons，因为坐标不再完全相同。
	What streets does Atlantic Commons join with?	“Atlantic Commons” 与哪些街道相连
	Approximately how many people live on (within 50 meters of) Atlantic Commons?	大约有多少人居住在 “Atlantic Commons”（50 米范围内）

Loading…

None Suggestion removed during cleanup postgis-workshop spatial_relationships_exercises Chinese (Simplified)	English ``nyc_census_blocks`` Chinese (Simplified) 21 characters edited Current translation ``nyc_census_blocks`` 9 months ago
xinbo Translation added postgis-workshop spatial_relationships_exercises Chinese (Simplified)	English ``nyc_census_blocks`` Chinese (Simplified) 21 characters edited Current translation Translated ``nyc_census_blocks`` 9 months ago
mt:weblate-translation-memory Suggestion added postgis-workshop spatial_relationships_exercises Chinese (Simplified)	English ``nyc_census_blocks`` Chinese (Simplified) 21 characters edited Current translation ``nyc_census_blocks`` 11 months ago
None String updated in the repository postgis-workshop spatial_relationships_exercises Chinese (Simplified)	English ``nyc_census_blocks`` Chinese (Simplified) 0 characters edited Empty 11 months ago