right-hand coordinate system

卷发齐腰2022-10-04 11:39:541条回答

已提交，审核后显示！提交回复

地理标记语言gml的问题求大神帮忙,如何用gml表达如下两个事物（coordinate system: EPSG=432 地理标记语言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 henan751年前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年前查看全部