环境
Oracle Database 21c Express Edition Release 21.0.0.0.0
OracleSpatial函数
SELECT
sdo_inside(
sdo_geometry(
2001,
NULL,
SDO_POINT_TYPE(
118.439140,
31.385456,
NULL
),
NULL,
NULL
),
SDO_GEOMETRY(
2003,
NULL,
NULL,
sdo_elem_info_array(
1,
2003,
2
),
SDO_ORDINATE_ARRAY(
118.392992, 31.381136 ,
118.39694, 31.377399 ,
118.433933, 31.378169 ,
118.479852, 31.372599 ,
118.510322, 31.366883 ,
118.51663, 31.394503 ,
118.435605, 31.436145 ,
118.392992, 31.381136
)
)
)
FROM DUAL
;
百度地图验证
<!DOCTYPE html>
<html lang="zh-CN">
<head>
<meta charset="utf-8">
<title>添加点标记</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="viewport" content="initial-scale=1.0, user-scalable=no">
<meta http-equiv="X-UA-Compatible" content="IE=Edge">
<style>
body,
html,
overflow: hidden;
width: 100%;
height: 100%;
margin: 0;
font-family: "微软雅黑";
}
</style>
<script src="//api.map.baidu.com/api?type=webgl&v=1.0&ak=百度地图APIKEY"></script>
</head>
<body>
<div id="container"></div>
</body>
</html>
<script>
var map = new BMapGL.Map('container');
map.centerAndZoom(new BMapGL.Point(118.439140, 31.385456), 15);
map.enableScrollWheelZoom(true);
// 创建点标记
var marker = new BMapGL.Marker(new BMapGL.Point(118.439, 31.385));
// 在地图上添加点标记
map.addOverlay(marker);
var polygon = new BMapGL.Polygon([
new BMapGL.Point(118.392992, 31.381136),
new BMapGL.Point(118.39694, 31.377399),
new BMapGL.Point(118.433933, 31.378169),
new BMapGL.Point(118.479852, 31.372599),
new BMapGL.Point(118.510322, 31.366883),
new BMapGL.Point(118.51663, 31.394503),
new BMapGL.Point(118.435605, 31.436145)
], {strokeColor:"blue", strokeWeight:2, strokeOpacity:0.5});
map.addOverlay(polygon);
</script>