Efficient querying of spatial databases

The spatial data is becoming more widely used from day to day and its area of usage also gains variety. The examinations continue to find easy ways for accessing this kind of data and it gains more importance to use spatial functions and indexes which are used on databases.The aim of this study is to examine the geometry types used on a specific database; functions, indexes and operators supported for rapid access; spatial index usage; the importance of functions and operators for analyses and to determine the important points on the design of queries to create more rapid access to data. Within the scope of this thesis, queries widely used for spatial data such as Stream Gauging Station, River, Stream, Lake and Dam will be designed through the application improved via ASP.NET technology. Geoserver and Google Maps services are used as a resource for underlay display on the web sites accessed via this application.The performance of the indexes allowed to be used on spatial data by the database will be evaluated according to CPU time and the explain plans produced when they are operated on SQL statements. As a result, these efforts indicate that the use of proper spatial operations and database indexing are vital for fast accessing.