We have a lot of polygons(some of them contain holes) and there are also a lot of points inside different polygon, these data are processed as ESRI geodatabase format.
Now we have to do some spatial and property search in our JavaEE application which use the Oracle 11g as the database, for example, there is one kind of search, once use click in the map, we should return the points within the polygon where the mouse inside, and also we should filter the points by some additional properties.
And there maybe other spatial search in the future.
So I am not sure if I should use the Oracle Spatial in the application or we should use file geodatabase(*.gdb) directly?
1) Use oracle Spatial
Because we are not familiar with Oracle Spatial, so we do not know if there are any challenge?
2) Use file geodatabase
Use geodatabase or shapfile directly, since they support spatial and property query. But we wonder the performance?
أكثر...
Now we have to do some spatial and property search in our JavaEE application which use the Oracle 11g as the database, for example, there is one kind of search, once use click in the map, we should return the points within the polygon where the mouse inside, and also we should filter the points by some additional properties.
And there maybe other spatial search in the future.
So I am not sure if I should use the Oracle Spatial in the application or we should use file geodatabase(*.gdb) directly?
1) Use oracle Spatial
Because we are not familiar with Oracle Spatial, so we do not know if there are any challenge?
2) Use file geodatabase
Use geodatabase or shapfile directly, since they support spatial and property query. But we wonder the performance?
أكثر...