GeoRuby. General SQL Parser: sql engine for various databases. MsSqlSpatial. 0. See Requirements. 1. Download the last released version of MsSqlSpatial and unzip it where you want. You can also download the latest source code and build it using Visual Studio 2005, SharpDevelop 2.x or simply MsBuild. 2. 3. Deploy logged in with Windows authentication (just omit -login and -password options): msscmd -deploy -server=mssql_server -db=mssql_databaseDeploy logged in with SQL Server authentication: msscmd -deploy -server=mssql_server -db=mssql_database -login=username password=password The -deploy_permission option:This option sets the assembly permission value which can be either SAFE, EXTERNAL_ACCESS or UNSAFE. 4. Import from shapefile using the MsSqlSpatial Command Line Tool (msscmd.exe): msscmd -server=mssql_server -db=mssql_database -table=mssql_table -import=shp -shp_filename="C:\..\.. 5.
Filtering by bounding box: Filtering by intersection pattern: Distance queries: Spatial join queries: 6. Javascript Great Circle Calculator. By Ed Williams You need Javascript enabled if you want this page to do anything useful! For Netscape, it's under Options/Network Preferences/Languages. Compute true course and distance between points. Enter lat/lon of points, select distance units and earth model and click "compute". Note that if either point is very close to a pole, the course may be inaccurate, because of its extreme sensitivity to position and inevitable rounding error. Distance Units: Earth model: Compute lat/lon given radial and distance from a known point Enter lat/lon of initial point, true course and distance. Note that the starting point cannot be a pole. Spheroid Enter "user defined" spheroid parameters here: History 6/8/03 Added option to get distance in feet 11/4/02 Added references. 8/20/01 Added FAI sphere. 3/23/00 Added warning notes about not starting at poles. 7/13/98 Removed a line of debugging code, giving irritating Javascript alerts, left over from the 5/16/98 changes.