public JsonResult BufferfeatureJson(string fields, string parameters)
{
var base_url = "http://gis.drcog.org/REST/v1/ws_geo_bufferfeature.php?";
// from_geotable=bicycle_facility_inventory_2011_oct
// &to_geotable=arapahoe_crash_2006
// &distance=250
// &format=json
// &fields=t.gid,t.loc_01,t.loc_02,ST_AsGeoJson%20(ST_Transform(t.the_geom,%20900913))%20as%20geojson
// &srid=2232
// ¶meters=t.acctype='15'%20and%20type_fx_no=4
var url_param = "distance={0}&fields={1}&from_geotable={2}&to_geotable={3}&srid={4}¶meters={5}&format={6}";
var srid = "2232";
var from_geotable = "bicycle_facility_inventory_2011_oct";
var to_geotable = "arapahoe_crash_2006";
//var fields = "t.gid,t.loc_01,t.loc_02,ST_AsGeoJson (ST_Transform(t.the_geom, 900913)) as geojson";
var format = "json";
var distance = 250;
string url = String.Format(base_url + url_param
, distance, fields, from_geotable, to_geotable
, srid, parameters, format);
string result;
// Create the web request
HttpWebRequest request = WebRequest.Create(url) as HttpWebRequest;
request.ContentType = "application/json; charset=utf-8";
// Get response
using (HttpWebResponse response = request.GetResponse() as HttpWebResponse)
{
// Get the response stream
using (var reader = new StreamReader(response.GetResponseStream()))
{
result = reader.ReadToEnd();
}
}
return Json(result, "text/x-json", JsonRequestBehavior.AllowGet);
}