[GIS] Any free Tools to display more than 5000 geography objects in SQL Server

roadspatial-databasesql servervisualisation

SQL Server 2008 and up allow you to create a spatial index. If you select records that include a geography or geometry object, a spatial data tab appears that can display up to 5000 points or lines or other shapes. You can select a label column, pan, and zoom. I am trying to debug a road network dataset that has disconnected islands of roads and need to be able to display all the line segments for a given state and label the disconnected ones so I can see where the missing roads are. That means I need to display more than 5000 objects.

Are there any free tools that can do this, including the labeling (color labels would be ok if text labels are not supported)? I have about 250,000 line segments, but anything that can display 50,000 would be okay for my work. A plugin for SSMS would be best, but an external tool would work, too. If there is a C# .NET library, I could use that, too.

Best Answer

You might try SharpGIS SqlSpatial Query Tool.

Related Solutions

[GIS] ArcSDE – Registering table with Geography spatial column fails with error -138 (SQL Server 2008)

The geography data type only supports SRIDs that appear in the view sys.spatial_reference_systems. On my server, the SRID 1047 did not appear in that view so I suspect you are attempting to use a spatial reference that is incompatible with the geography data type.

Use the following query to see what SRIDs are supported:

select * from sys.spatial_reference_systems;

Bill

[GIS] Insert Geography data into SQL Server 2008

Hopefully you've found the answer you're looking for by now but I just came across this and figured I'd take a stab at answering it for others at least.

From C# here's what I do for inserting a Polygon. I'm deriving this on the fly from some working code I have but not actually testing it so forgive any typo errors.

You'll need the following assemblies. System.Data.SqlClient; System.Data.SqlTypes; System.Data.SqlServer.Types;

public void Main()
{
    // the coordinate parameters below are doubles that can gathered from wherever, you can add additional points as necessary to the POLYGON list just make sure that they from a counter-clockwise 'circle'

    string areaName = "Texas";
    string extents = string.Format("POLYGON(({0} {1}, {0} {2}, {3} {2}, {3} {1}, {0} {1}))", leftLongitude, upperLatitude, lowerLatitude, rightLongitude));

    InsertArea(areaName, extents);

}

public void InsertArea(string nameParameter, string extentsString)
{
    SqlConnection sqlConn = new SqlConnection(...)

    sqlConn.Open();

    SqlCommand sqlCom = new SqlCommand("INSERT INTO areas (name, extents) VALUES (@name, @extents)", sqlConn);

    sqlCom.Parameters.AddWithValue("@name", nameParameter);

    SqlParamater extents = new SqlParameter("@extents", SqlDbType.Udt);
    extents.UdtTypeName = "Geography";
    extents.Value = GetGeographyFromText(extentsString);

    sqlCom.Parameters.Add(extents);

    sqlCom.ExecuteNonQuery();

    sqlConn.Close();
}

public SqlGeography GetGeographyFromText(String pText)
{
    SqlString ss = new SqlString(pText);
    SqlChars sc = new SqlChars(ss);
    try
    {
        return SqlGeography.STPolyFromText(sc, 4326);
    }
    catch (Exception ex)
    {
        throw ex;
    }
}

I hope this helps someone.

Best Answer

Related Solutions

[GIS] ArcSDE – Registering table with Geography spatial column fails with error -138 (SQL Server 2008)

[GIS] Insert Geography data into SQL Server 2008

Related Question