Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Spatial Data Rss

   Items 1 to 20 of 41    Older >>
 

SQL Server Spatial Indexes

Spatial Data in SQL Server has special indexing because it has to perform specialised functions. It is able, for example, to break down an indexed space into a grid hierarchy by using a technique called tessellation. This is a rules-based system that, when you compare a shape to an index, works out how many cells in the the grid hierarchy are touched by that shape , and how deep down the grid hierarchy to search. There is powerful magic in Spatial Indexes as Surenda and Roy explain.  Read more...
By Additional Articles 2015/04/15 | Source: SimpleTalk | Category: spatial data
Rating:  Rate this |   Briefcase | 6,161 reads

Introduction to SQL Server Spatial Data

More and more applications require the handling of geospatial data. It is easy to store spatial data, but it takes rather more thought to retrieve and manipulate it. Tasks like searching neighborhoods, and calculating distances between points is often required from databases. But how do you start? Roy and Surenda take you through the basics.  Read more...
By Additional Articles 2015/04/06 | Source: SimpleTalk | Category: spatial data
Rating:  Rate this |   Briefcase | 8,527 reads

Calculate distance between 2 coordinates/latlong

This function is used to get the distance between 2 coordinates/latlong in the different formats  Read more...
By Vignesh Arulmani 2014/11/24 | Source: SQLServerCentral.com | Category: calculate distance
Rating: |  Discuss |   Briefcase | 1,115 reads

Create CNN-style Map in Reporting Services

This article demonstrates how to use US Census' TIGER/Line shapefile to display CNN-style map in Reporting Services.  Read more...
By Peichung Shih 2012/06/01 (first published: 2011/03/07) | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 115,872 reads

Tuning Spatial Point Data Queries in SQL Server 2012

Spatial Point Data queries require particular tuning efforts to enhance performance and improve overall application through put. SQL Server 2012 introduces a few key new features and improvements to assist you in that goal.  Read more...
By Additional Articles 2012/04/27 | Source: MSDN Communities | Category: spatial data
Rating: (not yet rated)  Rate this |   Briefcase | 1,820 reads

Querying Geometry Information

By Michael Kaufmann 2012/02/03 | Category: spatial data
Rating: (not yet rated) |  Discuss |   Briefcase | 1,962 reads

New Spatial Features in SQL Server Code-Named 'Denali'

SQL Server 2008 introduced spatial data support into the database server. This paper describes and discusses the new spatial features in SQL Server Code-Named “Denali” CTP1 and CTP3 that augment existing SQL Server 2008 and SQL Server 2008 R2 spatial functionality.  Read more...
By Additional Articles 2011/11/03 | Source: Microsoft MSDN | Category: sql server 2012
Rating: (not yet rated)  Rate this |   Briefcase | 2,483 reads

Spatial Data Types

By Sudhir Dwivedi 2011/10/26 | Category: spatial data
Rating: (not yet rated) |  Discuss |   Briefcase | 1,861 reads

Vincenty Inverse

Calculates bearing and distance between 2 sets of latlon coordinates  Read more...
Rating: |  Discuss |   Briefcase | 474 reads

Vincenty Direct

Calculates the latlon coordinates for a given bearing and distance from reference latlon coordinates  Read more...
By Peter De Ceulaer 2011/06/22 | Source: SQLServerCentral.com | Category: spatial data
Rating: |  Discuss |   Briefcase | 234 reads

Create CNN-style Map in Reporting Services

This article demonstrates how to use US Census' TIGER/Line shapefile to display CNN-style map in Reporting Services.  Read more...
By Peichung Shih 2012/06/01 (first published: 2011/03/07) | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 115,872 reads

Getting Started with Maps in SQL Server 2008 R2 Reporting Services

I noticed a new feature in SQL Server 2008 R2 Reporting Services that allows you to render maps in your reports. Can you provide some details on this new feature and can I take advantage of it even though don't have any spatial columns in my data warehouse?  Read more...
By Additional Articles 2010/12/08 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 4,202 reads

Standardize data storage for geography spatial data type in SQL Server

Geography is one of the spatial data types introduced in SQL Server 2008. One of the characteristic of the geography data type is that it can accommodate any supported geometry based on any supported spatial reference system in the same field. So if the data that is stored in a column of geography data type is not standardized, it can be a very tedious and resource intensive task to figure out the geometry and spatial reference system associated with each value. To deal with this issue, we need to standardize the data stored in a field of that has the geography data type and in this tip we will look at how to deal with this issue.  Read more...
By Additional Articles 2010/10/04 | Source: MSSQLTips.com | Category: spatial data
Rating: (not yet rated)  Rate this |   Briefcase | 2,015 reads

Achieve Spatial Data Support in SSIS

Spatial data support in SSIS is weak in comparison to SQL Server. This article demonstrates how to use the CLR to achieve the SQL Server levels of spatial data support in SSIS.   Read more...
Rating:  Rate this |   Briefcase | 2,038 reads

Reporting Services 2008 R2: Geospatial Visualization – Part I

Geospatial Visualization is one of the key new features of SQL Server 2008 R2 Reporting Services. This step-by-step tutorial demonstrates the creation of a Map Report.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,389 reads

Working with Spatial Data Part IV - Developing a Geospatial Dashboard (GIS)

In Part IV of the Geo-Spatial series, an interactive dashboard is developed to present and interact with the data.  Read more...
By Additional Articles 2010/05/26 | Source: SQL Server Performance | Category: spatial data
Rating:  Rate this |   Briefcase | 2,757 reads

Working with Spatial Data Part III - Reporting Spatial data using Reports Builder 3.0

Part III of our spatial data series, continues building a demo spatial data app and uses Reports Builder for detailed visual mapping.  Read more...
By Additional Articles 2010/05/20 | Source: SQL Server Performance | Category: spatial data
Rating:  Rate this |   Briefcase | 2,216 reads

Working with Spatial Data Part II - Plotting Shapes and Storing Geocoded Data

Continuing from Part I of the Spatial Data series we model an in-memory/persistent data repository for storing geocoded data and plot the data.   Read more...
By Additional Articles 2010/05/13 | Source: SQL Server Performance | Category: spatial data
Rating: (not yet rated)  Rate this |   Briefcase | 1,781 reads

SQL Server Geography Data Type

We are working on the migration to SQL Server 2008 and have geospatial data that we would like to move over as well. As part of our application we house information on locations across the globe. Which data type should we use?   Read more...
By Additional Articles 2010/04/12 | Source: MSSQLTips.com | Category: spatial data
Rating: (not yet rated)  Rate this |   Briefcase | 2,959 reads
   Items 1 to 20 of 41    Older >>
 
Tags
sql server 2008 (12)    
t-sql (4)    
reporting services (ssrs) (3)    
sql server 2008 r2 (3)    
datatypes (2)    
gis (2)    
visualizations (2)    
calculate distance (1)    
coordinates (1)    
coordinates distance (1)    
data storage (1)    
distance (1)    
filestream (1)    
geography (1)    
geometry (1)    
indexing (1)    
integration services (ssis) (1)    
lat and long distance (1)    
latitude (1)    
latitude longitude distance coordinates vincenty (1)    
longitude (1)    
map (1)    
sql server 2012 (1)    
vincenty (1)