public override void Convert(dynamic jsonElement, ref QueryTable query)
{
if (jsonElement.Value == null)
{
return;
}
var geometry = new CHXGeometry();
geometry.ReadGeoJson(jsonElement.Value.location.shape.ToString());
var distance = jsonElement.Value.location.distance == null ? 0 : double.Parse(jsonElement.Value.location.distance.ToString());
var relation = (CHXGeometryRelation)System.Enum.Parse(typeof(CHXGeometryRelation), jsonElement.Value.location.relation.ToString());
if (geometry == null)
{
return;
}
query.QueryGeometryList = new List <QueryGeometry>();
query.QueryGeometryList.Add(new QueryGeometry()
{
Geometry = geometry,
Relation = relation,
Distance = distance
});
}
static void Main(string[] args)
{
string aaa = "denemeveri";
var test = aaa.HasSpecialChars();
var tt = new CHXGeometry();
tt.ReadWkt("MULTILINESTRING((31.4496904 36.7991082,31.4504789 36.7986288), (31.4496904 36.7991082,31.4504789 36.7986288))");
var parameters = new CHXDatabaseParameters();
parameters.Add("Server", "192.168.2.188");
parameters.Add("Port", "5432");
parameters.Add("Database", "atakumgis");
parameters.Add("User Id", "postgres");
parameters.Add("Password", "ntc123*");
var mydatabase = new CHXDatabase.IO.CHXDatabase(parameters, CHXDatabaseType.PostgreSql);
var manager = new CHXDatabaseLibrary.CHXDatabaseManager(mydatabase);
//var query = manager.ConvertQuery<string>(@"{ ""server"": ""kbb2"", ""schema"": ""public"", ""query"": { ""geoyol"": { ""type"": ""table"", ""addgeometry"": true, ""field"": [ ""objectid"", ""yol_adi"" ], ""find"": [ { ""yol_tipi_id"": 4, ""yol_turu_id"": 5 }, { ""yol_turu_id"": 4 } ] }, ""kod_yol_turu"": { ""type"": ""table"", ""field"": [ ""adi => yol_turu"" ] }, ""kod_yol_tipi"": { ""type"": ""table"", ""field"": [ ""adi => yol_tipi"" ] } }, ""join"": { ""inner"": { ""kod_yol_turu.kod"": ""geoyol.yol_turu_id"" }, ""left"": { ""kod_yol_tipi.kod"": ""geoyol.yol_tipi_id"" } } }",
// CHXDatabaseLibrary.CHXQueryType.Json);
//var query = manager.ConvertQuery<string>(@"{ ""server"": ""atakumgis"", ""schema"": ""public"", ""query"": { ""parsel"": { ""type"": ""table"", ""addgeometry"": true, ""field"": [ ""objectid"", ""adaparsel"", ""alan"" ], ""find"": [ { ""tapu_mah_adi"": ""AKALAN"" } ], ""geo_shape"": { ""location"": { ""shape"": { ""type"": ""Point"", ""coordinates"" : [515458.256064797, 4585609.61491352] }, ""relation"": ""intersect"" } } } } }",
// CHXQueryType.Json);
var query = manager.ConvertQuery <string>(@"{ ""server"": ""atakumgis"", ""schema"": ""public"", ""limit"":2, ""query"": { ""parsel"": { ""type"": ""table"", ""addgeometry"": true, ""field"": [ ""objectid"", ""adaparsel"", ""alan"" ], ""geo_shape"": { ""location"": { ""shape"": { ""type"": ""Point"", ""coordinates"" : [515458.256064797, 4585609.61491352] }, ""relation"": ""distance"", ""distance"" : 20 } } } } }",
CHXQueryType.Json);
var result = manager.RunQuery <dynamic>(query);
var json = JsonConvert.SerializeObject(result, Newtonsoft.Json.Formatting.Indented,
new Newtonsoft.Json.JsonSerializerSettings()
{
ReferenceLoopHandling = Newtonsoft.Json.ReferenceLoopHandling.Ignore
}
);
}
public override IEnumerable <T> Convert <T>(CHXQuery query, dynamic data)
{
var collection = new CHXFeatureCollection();
foreach (var row in data)
{
var feature = new CHXFeature();
feature.properties = new Dictionary <string, object>();
foreach (var col in (row as IDictionary <string, object>))
{
if (col.Key == query.GeometryColumn)
{
if (query.AddGeometry)
{
var geom = new CHXGeometry();
geom.ReadWkt(col.Value.ToString());
feature.geometry = geom;
}
}
else
{
feature.properties.Add(col);
}
}
collection.features.Add(feature);
}
return(collection.features as IEnumerable <T>);
}
