sql server 2008 空间数据类型的插入

来源：互联网发布：哪种理财软件好编辑：程序博客网时间：2024/05/01 11:29

插入点：
INSERT INTO [Diligis].[dbo].[Ms_AccidentPt]
           ([AptName]
           ,[AptDescript]
           ,[AptRemark]
           ,[Geo])
     VALUES(
           'aa'
           ,'bb'
           ,'cc'
           ,geometry::STGeomFromText('POINT (0 0)', 0))

           INSERT INTO [Diligis].[dbo].[Ms_Cross]
           ([CrossName]
           ,[CrossGrade]
           ,[ImgPath]
           ,[ImgPath2]
           ,[Geo])
     VALUES
           ('aaa'
           ,1
           ,'../js/OpenLayersV2.10/theme/default/img/marker.png'
           ,'../js/OpenLayersV2.10/theme/default/img/marker.png'
           ,geography::STGeomFromText('POINT(104.56 30.4)', 4326))

插入线：
           INSERT INTO [Diligis].[dbo].[Ms_AccidentPt]
           ([AptName]
           ,[AptDescript]
           ,[AptRemark]
           ,[Geo])
     VALUES(
           'aa'
           ,'bb'
           ,'cc'
           ,geometry::STGeomFromText('LINESTRING (100 100, 20 180, 180 180)', 0))

           INSERT INTO [Diligis].[dbo].[Ms_Cross]
           ([CrossName]
           ,[CrossGrade]
           ,[ImgPath]
           ,[ImgPath2]
           ,[Geo])
     VALUES
           ('aaa'
           ,1
           ,'../js/OpenLayersV2.10/theme/default/img/marker.png'
           ,'../js/OpenLayersV2.10/theme/default/img/marker.png'
           ,geography::STGeomFromText('LINESTRING(104.56 30.4,104.66 30.56)', 4326))

插入面：
INSERT INTO [Diligis].[dbo].[Ms_AccidentPt]
           ([AptName]
           ,[AptDescript]
           ,[AptRemark]
           ,[Geo])
     VALUES(
           'aa'
           ,'bb'
           ,'cc'
           ,geometry::STGeomFromText('POLYGON ((0 0, 150 0, 150 150, 0 150, 0 0))', 0)


INSERT INTO [Diligis].[dbo].[Ms_Cross]
           ([CrossName]
           ,[CrossGrade]
           ,[ImgPath]
           ,[ImgPath2]
           ,[Geo])
     VALUES
           ('polygon'
           ,1
           ,'../js/OpenLayersV2.10/theme/default/img/marker.png'
           ,'../js/OpenLayersV2.10/theme/default/img/marker.png'
           ,geography::STGeomFromText('POLYGON((80.5 35.5,81.5 35.5,81.5 36.5,80.5 36.5,80.5 35.5))', 4326))