sqlgeography
How to bulk insert geography into a new sql server 2008 table
I have a very large shape file with hundreds of thousands of rows of polygons and other associated data, like formatted addressing and APN numbers.How do I get this data into a table with geography wi[详细]
2023-03-29 23:14 分类:问答Convert XAML to ShapeFile or SqlGeometry formats
I have some XAML based diagrams that consist of Paths embedded in Canvas objects e.g. <Canvas x:Name=\"c1\" Width=\"55.2533\" Height=\"18.2933\" Canvas.Left=\"194.606\" Canvas.Top=\"194.131\">[详细]
2023-03-22 13:19 分类:问答Reformat SQLGeography polygons to JSON
I am building a web service that serves geographic boundary data in JSON format. The geographic data is stored in an SQL Server 2008 R2 database using the geography type in a table. I use [ColumnName[详细]
2023-03-16 09:00 分类:问答Ms SQL geography.STDistance returns wrong distance
I\'m trying to query any locations within a specified distance from another location. The query is not the problem, but the distance returned by geography.STDistance is.[详细]
2023-03-16 02:48 分类:问答SQL Server Geography datatype: weird behavior
I have an application that has been running for years now with no issues. Recently I decided to add a Geography type column to one of the table开发者_如何学JAVAs, application uses. After doing so, the[详细]
2023-03-09 06:50 分类:问答Geospatial data in SQL
I have been experimenting with geography datatype lately and just love it. But I can\'t decide should i convert from my current schema, that stores latitude and longitude in two separate numeric(9,5)[详细]
2023-03-04 06:24 分类:问答SQL Server 2008 geography - spatial result - color based on another column value
I have a table like this in SQL Server 2008: serv_typecoords ------------------------ shop0xE6100000010CE4857478080B49401CD2A8C0C9DE2C40[详细]
2023-02-10 08:38 分类:问答SQL Server GEOGRAPHY_GRID x & y range
I have a table that needs to record geographical points (long, lat) for the whole world. The input data is traditional longitudinal & latitudinal (-180, -90, 180, 90).[详细]
2023-01-26 05:22 分类:问答KML to SqlGeography
Anyone have a function or DLL that will co开发者_JAVA技巧nvert KML to SqlGeography (SQLServer DataType)?[详细]
2023-01-21 02:56 分类:问答Is there a silverlight replacement for SqlGeography?
I\'m looking for a replacement for Microsoft.SqlServer.Types.SqlGeography that will work in Silverlight. I\'m primarily interested in arbitrary collection of data (point, path, or polygon) and the STB[详细]
2023-01-17 18:09 分类:问答