点在多边形里面



    判断点在图层里面:
    CREATE TABLE SpatialTable
        ( id int IDENTITY (1,1),
        GeomCol1 geometry,
        GeomCol2 AS GeomCol1.STAsText() );
    GO

    多边形：起始经纬度和终止经纬度一样

    INSERT INTO SpatialTable (GeomCol1)
    VALUES (geometry::STGeomFromText('POLYGON ((116.386428 39.870515,116.386085 39.8705,116.379875     39.870107,116.375907 39.869832,116.37577 39.869821,116.374389 39.869741,116.373626 39.869691,116.372886     39.869641,116.368644 39.869371,116.36779 39.869306,116.365966 39.869149,116.363075 39.868894,116.360305     39.868726,116.358352 39.868573,116.355186 39.86836,116.349952 39.867936,116.346939 39.867746,116.34645     39.8677,116.346145 39.867669,116.345649 39.867631,116.345199 39.867608,116.344909 39.867643,116.344741     39.8677,116.344558 39.868783,116.344276 39.870988,116.344108 39.872426,116.340682 39.872457,116.339767     39.872468,116.338943 39.872461,116.338088 39.872441,116.337944 39.872457,116.337715 39.873834,116.337539     39.874002,116.337173 39.874269,116.33683 39.874501,116.336586 39.874612,116.33628 39.874685,116.33609     39.8747,116.335304 39.874704,116.333534 39.874643,116.331047 39.874513,116.327323 39.874238,116.326797     39.874189,116.326271 39.8742,116.325935 39.874242,116.325317 39.874356,116.323936 39.874627,116.322616     39.874868,116.322059 39.874929,116.319053 39.874959,116.318374 39.874868,116.317832 39.874795,116.31723     39.874768,116.31652 39.875066,116.315254 39.875463,116.315223 39.880258,116.315696 39.880273,116.317146     39.880277,116.317176 39.88157,116.317146 39.882383,116.317161 39.88273,116.317306 39.883031,116.317443     39.883294,116.31826 39.883317,116.318206 39.885606,116.318229 39.886937,116.318191 39.888566,116.318435     39.888593,116.319412 39.888677,116.32032 39.888723,116.320297 39.888883,116.320121 39.889218,116.319793     39.889653,116.31974 39.889875,116.319747 39.890382,116.319778 39.891713,116.319801 39.892007,116.319755     39.89578,116.321014 39.895776,116.32183 39.895799,116.326622 39.895871,116.331718 39.896154,116.334266     39.896291,116.335853 39.896363,116.337181 39.896451,116.338462 39.896508,116.341888 39.896505,116.343185     39.896485,116.343002 39.898851,116.350814 39.899064,116.350944 39.898244,116.35102 39.898008,116.351142     39.897885,116.35131 39.897802,116.351448 39.897805,116.352745 39.89792,116.353713 39.897996,116.355186     39.897992,116.355278 39.897996,116.35617 39.898004,116.357666 39.898072,116.35852 39.898091,116.359161     39.898111,116.359436 39.898118,116.360359 39.898153,116.360862 39.898179,116.368164 39.898423,116.368347     39.898427,116.373619 39.898603,116.374359 39.898622,116.37577 39.89866,116.377891 39.898725,116.377967     39.898721,116.386924 39.898984,116.388259 39.898915,116.389717 39.898763,116.389839 39.898744,116.389869     39.89842,116.389984 39.898175,116.390174 39.897969,116.390464 39.89776,116.390823 39.897615,116.391204     39.897523,116.391731 39.897458,116.391777 39.897363,116.391807 39.8961,116.391883 39.895124,116.392143     39.890023,116.392776 39.878751,116.392898 39.875592,116.392974 39.873548,116.39302 39.871377,116.393028     39.870813,116.390556 39.870713,116.389167 39.870637,116.386428 39.870515))', 0));
GO

    判断点在图层内:

    DECLARE @PointA GEOMETRY --定义变量
    SET @PointA = GEOMETRY::Point(116.386428,39.870515,0) --返回值1OR0

    SELECT GeomCol1,GeomCol1.STContains(GEOMETRY::Point(116.376428,39.870515,0)) FROM SpatialTable