Initial Experience of SQL server space data

After reading the books online, sqlserver spatial data can be divided into geometry and geography. The former belongs to the plane coordinate system (it is a headache when you see it, and you have not studied whether to configure projection parameters, fortunately, Google map uses the 84 Coordinate System and geography. There are more than 10 types of spatial data when reading the document, but only geometry and geograhy types are found during table creation. Let's look at the following! It turns out that a field in sqlserver 2008 can have multiple shape types. when inserting data, text is used to describe the collection type! It seems that you have to add control on your own. To improve the performance, you can create a spatial index. Only Right-click the index to add the index, select a field of the spatial type, and confirm the boundary. This is more convenient :). Currently, the project is still in the planning stage. It is estimated that the technical route will not be available in a week.