Reimers.dk

Browse by Tags

• dotNet
• Google Maps
• KML
• Shapefiles
• Site
• SQL Server 2008
• SqlGeography
• SqlGeometry
• Tutorial
• Updates

• Ensuring Valid SqlGeography Objects

  Yesterday I wrote a post about the release of a project that can convert shapefiles and KML files to SqlGeography objects for use in a SQL Server 2008 spatial database. This post shows how you can validate SqlGeography objects in code. The SqlSpatial project has been updated with the validation code, as recommended by k.van.daalen. Read More... Posted 10. februar 2009 22:33 by jjrdk | 2 Comments Filed under: Database, SQL Server 2008, Shapefiles, KML, SqlGeometry, SqlGeography

• Reading Overlay Data From a MySQL Database

  I have previously written a post about how to read overlay information from an MS SQL Server database. To start off the new series on how to use databases in your map application I am going to supplement that post with a post about how to do the same thing with marker data stored in a MySQL database. Many web hosts give you MySQL capacity when hosting your website - MS SQL databases are frequently limited in size, which is not the case for MySQL databases. Read More... Posted 21. april 2007 12:54 by jjrdk | 0 Comments Filed under: Google Maps, Tutorial, Database

• Start of Database Tutorial Series

  What I want to do is to write a series of posts on how to perform different actions using both MS SQL and MySQL. To start this I have uploaded a file with a script to create a sample database in both MS SQL and MySQL. This sample database will be the base example for all posts on using databases. Read More... Posted 21. april 2007 08:14 by jjrdk | 0 Comments Filed under: Google Maps, Tutorial, Database

• Setting Up the Sql Server 2005 Integration Assembly

  The SQL Server 2005 Integration Assembly adds two User-Defined Types and several geospatial functions to your database. The assembly allows you to make geospatial calculations directly inside the database and thus lighten the load on your webserver when displaying geographically defined data. Setting up the assembly is simple and can be done in just a few steps. Read More... Posted 9. marts 2007 08:07 by jjrdk | 0 Comments Filed under: Tutorial, Database

• Sql Server 2005 Assembly is Final

  Just to announce that the Sql Server 2005 Integration assembly is no longer beta. Read More... Posted 22. februar 2007 05:59 by jjrdk | 0 Comments Filed under: Updates, Database

• How Much Geospatial Ability Can You Squeeze Out of SQL Server 2005 Express?

  When developing map applications in a .NET environment it is almost natural to use MS SQL Server (Express) as the supporting database for the application. There is however one major drawback to this database - it doesn't have any built-in geospatial functionality. This is why I created the User Defined Types SqlLatLng and SqlBounds to handle geospatial data directly in the database. In this experiment will test how well SQL Server 2005 Express handles geospatial data. Read More... Posted 18. februar 2007 03:32 by jjrdk | 5 Comments Filed under: Google Maps, Database, Site

• Sql Server 2005 Integration

  SQL Server 2005 (both full and Express) has support for CLR (Common Language Runtime) assemblies. This greatly simplifies the task of creating User Defined Functions (UDF) or User Defined Types (UDT). So the idea of integrating the data model from the Google Maps .NET Control to SQL Server seems straightforward. This post is meant as a preliminary introduction to SQL Server integration, which will be developed further in future versions (version 3.4+). Read More... Posted 26. januar 2007 10:36 by jjrdk | 1 Comments Filed under: Google Maps, dotNet, Updates, Database

• Reading Overlay Data From a Database

  Retrieving data from a database is perhaps one of the most common tasks for all but the most static websites. Retrieving data for map overlays is in principle no different from retrieving any other data. The main caveat for this is that if any data analysis is performed while the data is being read back one risks keeping the database connection open longer than necessary. This post shows different examples of how to quickly fetch data and then performing the analysis after the connection has been closed. Read More... Posted 26. januar 2007 08:03 by jjrdk | 10 Comments Filed under: Google Maps, Tutorial, Database