作业帮 > 英语 > 作业

地理标记语言gml的问题

来源:学生作业帮 编辑:作业帮 分类:英语作业 时间:2024/05/18 19:47:59
地理标记语言gml的问题
求大神帮忙,如何用gml表达如下两个事物(coordinate system: EPSG=4326),要求用FeatureCollection作为root element, 并且要用到featureMember:
1 road
Name: E22
Type: Motorway
Geometry: Line (choose your own coordinate values)
1 local municipality
Name: Lund
Inhabitants: 100 000
Geometry: Polygon (choose your own coordinate values).
我自己尝试写了下,可以肯定的是我肯定犯错了:




55,13 57,16






Road
E22
Motoway


55.7,13.2 56.0,14.2







Municipality
Lund
100000


55.7,13.2





CREATE PROCEDURE GetNearbyStoresGML @Lat nvarchar(10), @Long nvarchar(10)
AS
-- Create a point geography instance based on the supplied location
DECLARE @SearchPoint geography
SET @SearchPoint = geography::Point(@Lat, @Long, 4326)
-- Create a polygon geography instance by adding a 100km buffer to the point
DECLARE @SearchArea geography
SET @SearchArea = @SearchPoint.STBuffer(100000)
--Return the search area and all store locations that intersect it
SELECT 'Search Area', '100 KM radius', @SearchArea.AsGml()
UNION ALL
SELECT StoreName,
StoreAddress + ', Tel:' + StorePhone AS ContactDetails,
StoreLocation.AsGml() As StoreGML
FROM Stores
WHERE StoreLocation.STIntersects(@SearchArea) = 1
GO