mysql 空间数据库实战

坐标点三公里内

SELECT
	d.UnitName,
round(st_distance_sphere(point(119.531003, 35.421986),point(d.Longitude, d.Latitude))/1000,3) as distance 
FROM
	x_shopmap d
	LEFT JOIN x_typedatadiction datay ON datay.Id = d.ClassificationBig
	LEFT JOIN x_typedatadiction datax ON datax.Id = d.ClassificationSmall
	LEFT JOIN s_residence depart1 ON depart1.Id = d.Country
	LEFT JOIN s_residence depart2 ON depart2.Id = d.Street
	LEFT JOIN s_community depart3 ON depart3.Id = d.Community 
WHERE
	1 = 1 
	AND ClassificationBig = 'dfd95512-6efe-11ea-80a4-00155d017700'
	AND d.CreateDate IS NOT NULL 
HAVING
	distance <3
ORDER BY
	d.CreateDate DESC

坐标落在哪个面内

select * from s_community where  st_INTERSECTS( POINT(119.448105,35.431999) , st_GEOMFROMTEXT(Address))  LIMIT 1

Address字段:
POLYGON((119.548244 35.413535,119.548241 35.413359,119.548238 35.413205,119.548238 35.413193,119.548238 35.413191,119.548241 35.412802,119.548245 35.412286,119.548247 35.412071,119.548247 35.412044,119.548252 35.411444,119.548252 35.411385,119.548258 35.410713,119.548263 35.410065,119.548263 35.410059,119.548265 35.409963,119.548273 35.409595,119.548281 35.409262,119.548298 35.408523,119.548298 35.40852,119.5483 35.40844,119.548387 35.407511,119.548382 35.406864,119.54838 35.406513,119.548378 35.406218,119.548377 35.406114,119.54838 35.405861,119.548387 35.405151,119.548393 35.404588,119.548394 35.404537,119.5484 35.403938,119.548401 35.403856,119.548412 35.402806,119.54824 35.402801,119.547533 35.402788,119.547337 35.402785,119.546502 35.402764,119.546483 35.402763,119.545683 35.402743,119.545319 35.402734,119.544696 35.402718,119.544409 35.402709,119.543768 35.402689,119.543754 35.402888,119.543744 35.403412,119.543742 35.403549,119.543725 35.404461,119.543709 35.405345,119.543708 35.405356,119.543706 35.405518,119.543692 35.406109,119.543691 35.406127,119.543686 35.40637,119.543644 35.406616,119.543602 35.406843,119.543554 35.407103,119.543541 35.407173,119.543526 35.407252,119.543376 35.40806,119.543323 35.408342,119.543335 35.408531,119.543353 35.408844,119.54336 35.409208,119.543363 35.409386,119.543371 35.409807,119.543371 35.409845,119.543379 35.410247,119.543385 35.410603,119.543386 35.410662,119.543398 35.411111,119.543405 35.411354,119.543422 35.412026,119.543423 35.412041,119.543424 35.412054,119.543471 35.412781,119.543517 35.413497,119.543519 35.413523,119.543532 35.413523,119.544635 35.413516,119.54564 35.413508,119.545766 35.41351,119.545976 35.413513,119.548228 35.413535,119.548244 35.413535,119.548244 35.413535))