select distance(T1.Geom,T2.Geom) as Distance, T1.POI_ID, T2.LINK_ID from temp1 as T1, temp2 as T2 where T1.POI_ID = T2.POI_ID AND Distance < 100
temp1 having point geometry temp2 having line geometry
While I running above query through C# program I am getting Error ::
Assertion failed !
Program: ... File: geos_ts_c.cpp Line : 3472
(look attached snapshot)
I am having database in .db format. I am using SQLlite and spatialite for gis functionality.
From code ::
I am loading spatialite.dll and then with sqllitecommand running query..
ExecuteStatement("select load_extension('spatialite.dll')", con); SQLiteCommand selectCommand11 = new SQLiteCommand(selectSQL10, con); SQLiteDataReader dataReader10 = selectCommand11.ExecuteReader();
anybody have idea why I am getting this error ? and how can i resolve this ?