地理标记语言gml的问题求大神帮忙,如何用gml表达如下两个事物(coordinate system: EPSG=432

henan752022-10-04 11:39:541条回答

地理标记语言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




已提交,审核后显示!提交回复

共1条回复
Nathan_Ren 共回答了21个问题 | 采纳率81%
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
1年前

相关推荐