public ActionResult getParcelsUnderCaltivation()
{
var geojsonndata = new FeatureCollection()
{
CRS = new GeoJSON.Net.CoordinateReferenceSystem.NamedCRS("urn:ogc:def:crs:OGC::CRS84")
};
var cadastralMaps = _context.AndroidViewtbl.ToList();
var wktParcels = new WKTWriter();
cadastralMaps.ForEach(sa =>
{
var wkt = wktParcels.Write(sa.Polygon);
SqlGeometry sqlGeometry = SqlGeometry.Parse(wkt);
var geojsonobject = sqlGeometry.ToGeoJSONGeometry();
androidViewModel androidViewModel = new androidViewModel();
androidViewModel.Id = sa.Id;
androidViewModel.Acreage = sa.Acreage * 0.404686;
androidViewModel.Purpose = sa.Purpose;
var feature = new Feature(geojsonobject, androidViewModel);
geojsonndata.Features.Add(feature);
});
return(Json(geojsonndata));
}
//public IEnumerable<Parceltbl> getCadastralLayers()
//{
// var cadastralMaps = _context.Parceltbl
// .FromSql("EXECUTE cadastralDataSp")
// .ToList();
// return cadastralMaps;
//}
public FeatureCollection getCadastralLayers()
{
var geojsonndata = new FeatureCollection()
{
CRS = new GeoJSON.Net.CoordinateReferenceSystem.NamedCRS("urn:ogc:def:crs:OGC::CRS84")
};
var cadastralMaps = _context.AndroidViewtbl.ToList();
var wktParcels = new WKTWriter();
cadastralMaps.ForEach(sa =>
{
var wkt = wktParcels.Write(sa.Polygon);
SqlGeometry sqlGeometry = SqlGeometry.Parse(new System.Data.SqlTypes.SqlString(wkt));
var geojsonobject = sqlGeometry.ToGeoJSONGeometry();
androidViewModel androidViewModel = new androidViewModel();
androidViewModel.Id = sa.Id;
//var geojson = JsonConvert.DeserializeObject<Polygon>(geojsonobject);
var feature = new Feature(geojsonobject, androidViewModel);
geojsonndata.Features.Add(feature);
});
return(geojsonndata);
}
