範例如下:
SELECT [ogr_fid]
,[geometry]
,[countyid]
,[countyname]
,[COUNTY_CODE]
FROM [WraLandMap].[dbo].[map_county]
where geometry::STGeomFromText([geometry].STAsText( ), 4326).MakeValid().STContains(geometry::STGeomFromText('POINT(277466 2681304)', 4326)) = 1
沒有留言:
張貼留言