空间sql

最新推荐文章于 2023-05-10 09:11:15 发布

weixin_30487701

最新推荐文章于 2023-05-10 09:11:15 发布

阅读量121

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/shinesea/p/9284876.html

sqlserver



DECLARE @g GEOMETRY

SET @g = (
			GEOMETRY::STGeomFromText('POLYGON ${geom}',
			4326)
			)

SET @g = @g.MakeValid();

@g.STContains(GEOMETRY::STGeomFromText('POINT ('+ CONVERT(VARCHAR(50),lon)+ ' '+ CONVERT (VARCHAR(50), lat)+ ')', 4326)) = 1

oracle

 declare geom sdo_geometry:=sdo_geometry('POLYGON((80.83422302246095
                                                        20.518481140136714,
                                                        120.4135076904297
                                                        50.314989929199214,
                                                        80.83422302246095
                                                        50.314989929199214,
                                                        80.83422302246095
                                                       20.518481140136714))',4326);
  begin
     --输出并换行
   dbms_output.put_line(sdo_Geom.SDO_BUFFER(geom,1,0.002).get_wkt());
　end;