public string FindIntersect1(List <Latlongs> objs)
{
string polyString = "POLYGON((";
foreach (var o in objs)
{
polyString += o.lng.ToString() + ' ' + o.lat.ToString() + ',';
}
polyString += objs[0].lng.ToString() + ' ' + objs[0].lat.ToString() + ',';
polyString = polyString.TrimEnd(',') + "))";
try
{
string parcelIds = null;
using (var context = new sdeBRTestEntities1())
{
string sql = "select * " +
" from dbo.PropertyList pl " +
" where pl.geom.STIntersects((geography::STGeomFromText('" + polyString + "', 4326)).ReorientObject()) = 1 ";
//string sql = "select * " +
// "from dbo.PropertyList pl " +
// "where pl.geom.STIntersects(geography::STGeomFromText('POLYGON((-90.948429 30.4892, -90.948429 30.49690, -90.9374427 30.49690, -90.9374427 30.489213526, -90.948429 30.4892))', 4326)) = 1 " +
// "and pl.ParcelNumb < 1000";
parcelIds = GetGeoJsonString(context.Database.SqlQuery <PropertyList>(sql).ToList());
}
return(parcelIds);
}
catch (Exception e)
{
return(null);
}
}
public string GetPropertyList()
{
List <PropertyList> properties = null;
using (var context = new sdeBRTestEntities1())
{
properties = (from p in context.PropertyLists select p).ToList();
//var properties = context.PropertyLists.Where(p => new[]{333435,333450,334847,358085,359182}.Any(pn => pn == p.ParcelNumb ));
}
return(GetGeoJsonString(properties));
}
