Effectively managing extensive,multi-source,and multi-level real-scene 3D models for responsive retrieval scheduling and rapid visualization in the Web environment is a significant challenge in the current development...Effectively managing extensive,multi-source,and multi-level real-scene 3D models for responsive retrieval scheduling and rapid visualization in the Web environment is a significant challenge in the current development of real-scene 3D applications in China.In this paper,we address this challenge by reorganizing spatial and temporal information into a 3D geospatial grid.It introduces the Global 3D Geocoding System(G_(3)DGS),leveraging neighborhood similarity and uniqueness for efficient storage,retrieval,updating,and scheduling of these models.A combination of G_(3)DGS and non-relational databases is implemented,enhancing data storage scalability and flexibility.Additionally,a model detail management scheduling strategy(TLOD)based on G_(3)DGS and an importance factor T is designed.Compared with mainstream commercial and open-source platforms,this method significantly enhances the loadable capacity of massive multi-source real-scene 3D models in the Web environment by 33%,improves browsing efficiency by 48%,and accelerates invocation speed by 40%.展开更多
Data acquisition and modeling are the two important, difficult and costful aspects in a Cybercity project. 2D-GIS is mature and can manage a lot of spatial data. Thus 3D-GIS should make the best of data and technology...Data acquisition and modeling are the two important, difficult and costful aspects in a Cybercity project. 2D-GIS is mature and can manage a lot of spatial data. Thus 3D-GIS should make the best of data and technology of 2D-GIS. Construction of a useful synthetic environment requires integration of multiple types of information like DEM, texture images and 3D representation of objects such as buildings. In this paper, the method for 3D city landscape data model and visualization based on integrated databases is presented. Since the data volume of raster are very huge, special strategies(for example, pyramid gridded method) must be adopted in order to manage raster data efficiently. Three different methods of data acquisition, the proper data structure and a simple modeling method are presented as well. At last, a pilot project of Shanghai Cybercity is illustrated.展开更多
In order to store and manage a large amount of ground and indoor image data with high resolution, an integrated data management system needs to be developed. Possible strategies for this purpose were discussed togethe...In order to store and manage a large amount of ground and indoor image data with high resolution, an integrated data management system needs to be developed. Possible strategies for this purpose were discussed together with initial test on the newly defined 3D maps. The features of such 3D maps, data organization, key techniques used for the map storage, such as image compression based on wavelet transformation, quadtree index, update and retrieval, were analyzed, with the goals of bringing some profits to the storage and management of the digital data in the visual construction of digital mine, digital city and digital community.展开更多
In city planning managing, the third dimension is becoming a necessity. Using 3D GIS modeling offers a flexible interactive system while providing one of the best visual interpretation of data which supports planning ...In city planning managing, the third dimension is becoming a necessity. Using 3D GIS modeling offers a flexible interactive system while providing one of the best visual interpretation of data which supports planning and decision processes for city planners. As a result, 3D GIS model expresses terrain features in an intuitive way which enhances the management and analysis of a proposed project through 3D visualization. This paper discusses the concept of 3D GIS modeling techniques using a simple procedure to generate a university campus model (real 3D GIS model) which will show the effectiveness of this approach. The 3D GIS model provides access to mapping data to support planning, design and data management. Intelligent GIS models and GIS tools help community planning and apply regional and discipline-specific standards. Integration of GIS spatial data with campus organization helps to improve quality, productivity and asset management. The following study built 3D GIS map and all utility information for AI al-Bayt University campus as an example. The primary objective is to improve data management (e.g., maps, plans, usage of facilities and services) and to develop methods using 3D spatial analysis for specific applications at the university.展开更多
To improve the reusability of three-dimensional (3D) models and simplify the complexity of natural scene reconstruction, this paper presents a 3D model database for universal 3D GIS. After the introduction of its ex...To improve the reusability of three-dimensional (3D) models and simplify the complexity of natural scene reconstruction, this paper presents a 3D model database for universal 3D GIS. After the introduction of its extensible function architecture, accompanied by the conclusion of implicit spatial-temporal hierarchy of models in any reconstructed scene of 3D GIS for general purpose, several key issues are discussed in detail, such as the storage and management of 3D models and related retrieval and load method, as well as the interfaces for further on-demand development. Finally, the validity and feasibility of this model database are proved through its application in the development of 3D visualization system of railway operation.展开更多
For storing and modeling three-dimensional(3D)topographic objects(e.g.buildings,roads,dykes,and the terrain),tetrahedralizations have been proposed as an alternative to boundary representations.While in theory they ha...For storing and modeling three-dimensional(3D)topographic objects(e.g.buildings,roads,dykes,and the terrain),tetrahedralizations have been proposed as an alternative to boundary representations.While in theory they have several advantages,current implementations are either not space efficient or do not store topological relationships(which makes spatial analysis and updating slow,or require the use of an expensive 3D spatial index).We discuss in this paper an alternative data structure for storing tetrahedralizations in a database management system(DBMS).It is based on the idea of storing only the vertices and stars of edges;triangles and tetrahedra are represented implicitly.It has been used previously in main memory,but not in a DBMS.We describe how to modify it to obtain an efficient implementation in a DBMS,and we describe how it can be used for modeling 3D topography.As we demonstrate with different real-world examples,the structure is compacter than known alternatives,it permits us to store attributes for any primitives,and has the added benefit of being topological,which permits us to query it efficiently.The structure can be easily implemented in most DBMS(we describe our implementation in PostgreSQL),and we present some of the engineering choices we made for the implementation.展开更多
The traditional power design, construction, has been able to meet the requirements, but it has not been established engineering data database support and the correlation between the data is poor, due to inadequate coo...The traditional power design, construction, has been able to meet the requirements, but it has not been established engineering data database support and the correlation between the data is poor, due to inadequate coordination among design professionals, design easily lead to mistakes, field problems, and design results failed in all aspects of the project to be fully utilized. With the technology of three-dimensional integrated design system penetrates in all walks of life, the introduction of three-dimensional integrated design system substation design solutions and the application of common devices of State Grid Corporation in recent years, which provide technical conditions for the application of virtual reality technology in substation design. According to its own characteristics of substation project, we now propose prospect on virtual reality technology in substation design application.展开更多
This paper presents selected results of research connected with the development of a (3D) geostatistical hydrogeochemical model of the Klodzko Drainage Basin, dedicated to the spatial and time variation in the selec...This paper presents selected results of research connected with the development of a (3D) geostatistical hydrogeochemical model of the Klodzko Drainage Basin, dedicated to the spatial and time variation in the selected quality parameters of underground water in the Klodzko water intake area (SW part of Poland) [1-6]. The research covers the period 1977-2012. Spatial analyses of the variation in different quality parameters, between others, Fe [gFe/m3], Mn [gMn/m3], ammonium ion [gNH4+/m3] contents and oxidation capacity [gO2/m3], were carried out on the basis of the chemical determinations of the quality parameters of underground water samples taken from the wells in the water intake area [2-4]. Spatial and time variation in the parameters was analyzed on the basis of archival data (period 1977-1999) for 22 (pump and siphon) wells, later data obtained (November 2011) from tests of water taken from 14 existing wells and the latest data (January 2012) acquired from 3 new piezometers, which were made in other locations in the relevant area. Thematic databases, containing original data on coordinates X, Y (latitude, longitude) and Z (terrain elevation and time-years) and on regionalized variables, i.e. the underground water quality parameters in the Klodzko water intake area determined for different analytical configurations (22 wells, 14 wells, 14 wells + 3 piezometers), were created [2]. Both archival data (acquired in the years 1977-1999) and the latest data (collected in 2011-2012) were analyzed. These data were subjected to spatial analyses [2-6] using statistical and geostatistical methods [7-12]. The evaluation of basic statistics of the investigated quality parameters, including their histograms of distributions, scatter diagrams between these parameters and also correlation coefficients r, were presented in this article. The directional semivariogram function and the ordinary (block) kriging procedure were used to build the 3D geostatistical model. The geostatistical parameters of the theoretical models of directional semivariograms of the studied water quality parameters, calculated along the time interval and the well depth (taking into account the terrain elevation), were used in the ordinary (block) kriging estimation. The obtained results of estimation, allowed to determine the levels of increased values Z* of studied underground water quality parameters [2, 4-6]. Generally, the behaviour of the underground water quality parameters has been found to vary in space and time. Thanks to the spatial analyses of the variation in the quality parameters in the Klodzko underground water intake area some regularities (trends) in the variation in water quality have been identified.展开更多
The discrete excitation-emission-matrix fluorescence spectra (EEMS) at 12 excitation wavelengths (400, 430, 450, 460, 470, 490, 500, 510, 525, 550, 570, and 590 nm) and emission wavelengths ranging from 600-750 nm wer...The discrete excitation-emission-matrix fluorescence spectra (EEMS) at 12 excitation wavelengths (400, 430, 450, 460, 470, 490, 500, 510, 525, 550, 570, and 590 nm) and emission wavelengths ranging from 600-750 nm were determined for 43 phytoplankton species. A two-rank fluorescence spectra database was established by wavelet analysis and a fluorometric discrimination technique for determining phytoplankton population was developed. For laboratory simulatively mixed samples, the samples mixed from 43 algal species (the algae of one division accounted for 25%, 50%, 75%, 85%, and 100% of the gross biomass, respectively), the average discrimination rates at the level of division were 65.0%, 87.5%, 98.6%, 99.0%, and 99.1%, with average relative contents of 18.9%, 44.5%, 68.9%, 73.4%, and 82.9%, respectively; the samples mixed from 32 red tide algal species (the dominant species accounted for 60%, 70%, 80%, 90%, and 100% of the gross biomass, respectively), the average correct discrimination rates of the dominant species at the level of genus were 63.3%, 74.2%, 78.8%, 83.4%, and 79.4%, respectively. For the 81 laboratory mixed samples with the dominant species accounting for 75% of the gross biomass (chlorophyll), the discrimination rates of the dominant species were 95.1% and 72.8% at the level of division and genus, respectively. For the 12 samples collected from the mesocosm experiment in Maidao Bay of Qingdao in August 2007, the dominant species of the 11 samples were recognized at the division level and the dominant species of four of the five samples in which the dominant species accounted for more than 80% of the gross biomass were discriminated at the genus level; for the 12 samples obtained from Jiaozhou Bay in August 2007, the dominant species of all the 12 samples were recognized at the division level. The technique can be directly applied to fluorescence spectrophotometers and to the developing of an in situ algae fluorescence auto-analyzer for phytoplankton population.展开更多
Installation, detection, maintenance, mapping, and management of underground utility assets present challenges to owners, engineers and contractors. Industry-wide practices include the use of geophysical and similar t...Installation, detection, maintenance, mapping, and management of underground utility assets present challenges to owners, engineers and contractors. Industry-wide practices include the use of geophysical and similar technologies to determine depth and location, and 2D as-built plans integrated with GIS databases for information management. The feasibility of incorporating 3D BIM models of the subsurface to replace the 2D plans to improve visualization and data management is examined in this paper. Obtaining an accurate image of the underground infrastructure would help minimize excavation accidents due to equipment-utility collisions and prevent property damage. Further, the inclusion of automated data collection and sharing features realized through BIM technology can enhance operations of smart cities. The research methodology consists of a state-of-the-art review of the current underground utility management systems, combined with statistical analysis of survey responses received from utility providers and one-call centers in the U.S. Three categories of utility practices are identified based on the level of digital technology integration. It is found that a vast majority of utility firms have adopted GIS databases with 2D plans, depth and other asset information, while a smaller percentage of providers have achieved full GIS-BIM in<span style="font-family:Verdana;">tegration, incorporating a wide range of asset data. Future progress on</span><span style="font-family:Verdana;"> broader implementation appears to be constrained by the digital literacy of personnel </span><span style="font-family:Verdana;">and high costs of technology acquisition and application. A three-step frame</span><span style="font-family:Verdana;">work for converting 2D plans to 3D BIM models is also presented and discussed. The process model proposed for this purpose allows the utilization of commercially available software with minimal need for additional coding.</span>展开更多
In the past ten years,research on face recognition has shifted to using 3D facial surfaces,as 3D geometric information provides more discriminative features.This comprehensive survey reviews 3D face recognition techni...In the past ten years,research on face recognition has shifted to using 3D facial surfaces,as 3D geometric information provides more discriminative features.This comprehensive survey reviews 3D face recognition techniques developed in the past decade,both conventional methods and deep learning methods.These methods are evaluated with detailed descriptions of selected representative works.Their advantages and disadvantages are summarized in terms of accuracy,complexity,and robustness to facial variations(expression,pose,occlusion,etc.).A review of 3D face databases is also provided,and a discussion of future research challenges and directions of the topic.展开更多
In this paper,an overview of phases for modelling and mapping third dimension of spatial objects in a database is presented based on a selected spatial database management system(DBMS).These phases include(1)defining ...In this paper,an overview of phases for modelling and mapping third dimension of spatial objects in a database is presented based on a selected spatial database management system(DBMS).These phases include(1)defining a spatial reference system for representing three-dimensional(3D)objects with real-world coordinates,(2)geometric modelling of 3D objects in the database,(3)3D spatial indexing for fast accessing/querying the 3D data,3D spatial queries and representation of 3D data.Then,a case study is performed to assess needs,possibilities and potential limitations of 3D data modelling in the spatial database.展开更多
基金National Key Research and Development Program of China(No.2023YFB3907103).
文摘Effectively managing extensive,multi-source,and multi-level real-scene 3D models for responsive retrieval scheduling and rapid visualization in the Web environment is a significant challenge in the current development of real-scene 3D applications in China.In this paper,we address this challenge by reorganizing spatial and temporal information into a 3D geospatial grid.It introduces the Global 3D Geocoding System(G_(3)DGS),leveraging neighborhood similarity and uniqueness for efficient storage,retrieval,updating,and scheduling of these models.A combination of G_(3)DGS and non-relational databases is implemented,enhancing data storage scalability and flexibility.Additionally,a model detail management scheduling strategy(TLOD)based on G_(3)DGS and an importance factor T is designed.Compared with mainstream commercial and open-source platforms,this method significantly enhances the loadable capacity of massive multi-source real-scene 3D models in the Web environment by 33%,improves browsing efficiency by 48%,and accelerates invocation speed by 40%.
文摘Data acquisition and modeling are the two important, difficult and costful aspects in a Cybercity project. 2D-GIS is mature and can manage a lot of spatial data. Thus 3D-GIS should make the best of data and technology of 2D-GIS. Construction of a useful synthetic environment requires integration of multiple types of information like DEM, texture images and 3D representation of objects such as buildings. In this paper, the method for 3D city landscape data model and visualization based on integrated databases is presented. Since the data volume of raster are very huge, special strategies(for example, pyramid gridded method) must be adopted in order to manage raster data efficiently. Three different methods of data acquisition, the proper data structure and a simple modeling method are presented as well. At last, a pilot project of Shanghai Cybercity is illustrated.
文摘In order to store and manage a large amount of ground and indoor image data with high resolution, an integrated data management system needs to be developed. Possible strategies for this purpose were discussed together with initial test on the newly defined 3D maps. The features of such 3D maps, data organization, key techniques used for the map storage, such as image compression based on wavelet transformation, quadtree index, update and retrieval, were analyzed, with the goals of bringing some profits to the storage and management of the digital data in the visual construction of digital mine, digital city and digital community.
文摘In city planning managing, the third dimension is becoming a necessity. Using 3D GIS modeling offers a flexible interactive system while providing one of the best visual interpretation of data which supports planning and decision processes for city planners. As a result, 3D GIS model expresses terrain features in an intuitive way which enhances the management and analysis of a proposed project through 3D visualization. This paper discusses the concept of 3D GIS modeling techniques using a simple procedure to generate a university campus model (real 3D GIS model) which will show the effectiveness of this approach. The 3D GIS model provides access to mapping data to support planning, design and data management. Intelligent GIS models and GIS tools help community planning and apply regional and discipline-specific standards. Integration of GIS spatial data with campus organization helps to improve quality, productivity and asset management. The following study built 3D GIS map and all utility information for AI al-Bayt University campus as an example. The primary objective is to improve data management (e.g., maps, plans, usage of facilities and services) and to develop methods using 3D spatial analysis for specific applications at the university.
基金Supported by the National Natural Science Foundation of China (No.40871212, No.40671158)the National High Technology Research and Development Program of China (No.2008AA121600)
文摘To improve the reusability of three-dimensional (3D) models and simplify the complexity of natural scene reconstruction, this paper presents a 3D model database for universal 3D GIS. After the introduction of its extensible function architecture, accompanied by the conclusion of implicit spatial-temporal hierarchy of models in any reconstructed scene of 3D GIS for general purpose, several key issues are discussed in detail, such as the storage and management of 3D models and related retrieval and load method, as well as the interfaces for further on-demand development. Finally, the validity and feasibility of this model database are proved through its application in the development of 3D visualization system of railway operation.
基金This research is supported by the Dutch Technology Foundation STW,which is part of the Netherlands Organization for Scientific Research(NWO),and which is partly funded by the Ministry of Economic Affairs(project codes:11300 and 11185).
文摘For storing and modeling three-dimensional(3D)topographic objects(e.g.buildings,roads,dykes,and the terrain),tetrahedralizations have been proposed as an alternative to boundary representations.While in theory they have several advantages,current implementations are either not space efficient or do not store topological relationships(which makes spatial analysis and updating slow,or require the use of an expensive 3D spatial index).We discuss in this paper an alternative data structure for storing tetrahedralizations in a database management system(DBMS).It is based on the idea of storing only the vertices and stars of edges;triangles and tetrahedra are represented implicitly.It has been used previously in main memory,but not in a DBMS.We describe how to modify it to obtain an efficient implementation in a DBMS,and we describe how it can be used for modeling 3D topography.As we demonstrate with different real-world examples,the structure is compacter than known alternatives,it permits us to store attributes for any primitives,and has the added benefit of being topological,which permits us to query it efficiently.The structure can be easily implemented in most DBMS(we describe our implementation in PostgreSQL),and we present some of the engineering choices we made for the implementation.
文摘The traditional power design, construction, has been able to meet the requirements, but it has not been established engineering data database support and the correlation between the data is poor, due to inadequate coordination among design professionals, design easily lead to mistakes, field problems, and design results failed in all aspects of the project to be fully utilized. With the technology of three-dimensional integrated design system penetrates in all walks of life, the introduction of three-dimensional integrated design system substation design solutions and the application of common devices of State Grid Corporation in recent years, which provide technical conditions for the application of virtual reality technology in substation design. According to its own characteristics of substation project, we now propose prospect on virtual reality technology in substation design application.
文摘This paper presents selected results of research connected with the development of a (3D) geostatistical hydrogeochemical model of the Klodzko Drainage Basin, dedicated to the spatial and time variation in the selected quality parameters of underground water in the Klodzko water intake area (SW part of Poland) [1-6]. The research covers the period 1977-2012. Spatial analyses of the variation in different quality parameters, between others, Fe [gFe/m3], Mn [gMn/m3], ammonium ion [gNH4+/m3] contents and oxidation capacity [gO2/m3], were carried out on the basis of the chemical determinations of the quality parameters of underground water samples taken from the wells in the water intake area [2-4]. Spatial and time variation in the parameters was analyzed on the basis of archival data (period 1977-1999) for 22 (pump and siphon) wells, later data obtained (November 2011) from tests of water taken from 14 existing wells and the latest data (January 2012) acquired from 3 new piezometers, which were made in other locations in the relevant area. Thematic databases, containing original data on coordinates X, Y (latitude, longitude) and Z (terrain elevation and time-years) and on regionalized variables, i.e. the underground water quality parameters in the Klodzko water intake area determined for different analytical configurations (22 wells, 14 wells, 14 wells + 3 piezometers), were created [2]. Both archival data (acquired in the years 1977-1999) and the latest data (collected in 2011-2012) were analyzed. These data were subjected to spatial analyses [2-6] using statistical and geostatistical methods [7-12]. The evaluation of basic statistics of the investigated quality parameters, including their histograms of distributions, scatter diagrams between these parameters and also correlation coefficients r, were presented in this article. The directional semivariogram function and the ordinary (block) kriging procedure were used to build the 3D geostatistical model. The geostatistical parameters of the theoretical models of directional semivariograms of the studied water quality parameters, calculated along the time interval and the well depth (taking into account the terrain elevation), were used in the ordinary (block) kriging estimation. The obtained results of estimation, allowed to determine the levels of increased values Z* of studied underground water quality parameters [2, 4-6]. Generally, the behaviour of the underground water quality parameters has been found to vary in space and time. Thanks to the spatial analyses of the variation in the quality parameters in the Klodzko underground water intake area some regularities (trends) in the variation in water quality have been identified.
基金supported by National High-Tech Research and Development Program of China (863 Program)(No.2009AA063005)Natural Science Foundation of Shandong Province (No.ZR2009EM001)
文摘The discrete excitation-emission-matrix fluorescence spectra (EEMS) at 12 excitation wavelengths (400, 430, 450, 460, 470, 490, 500, 510, 525, 550, 570, and 590 nm) and emission wavelengths ranging from 600-750 nm were determined for 43 phytoplankton species. A two-rank fluorescence spectra database was established by wavelet analysis and a fluorometric discrimination technique for determining phytoplankton population was developed. For laboratory simulatively mixed samples, the samples mixed from 43 algal species (the algae of one division accounted for 25%, 50%, 75%, 85%, and 100% of the gross biomass, respectively), the average discrimination rates at the level of division were 65.0%, 87.5%, 98.6%, 99.0%, and 99.1%, with average relative contents of 18.9%, 44.5%, 68.9%, 73.4%, and 82.9%, respectively; the samples mixed from 32 red tide algal species (the dominant species accounted for 60%, 70%, 80%, 90%, and 100% of the gross biomass, respectively), the average correct discrimination rates of the dominant species at the level of genus were 63.3%, 74.2%, 78.8%, 83.4%, and 79.4%, respectively. For the 81 laboratory mixed samples with the dominant species accounting for 75% of the gross biomass (chlorophyll), the discrimination rates of the dominant species were 95.1% and 72.8% at the level of division and genus, respectively. For the 12 samples collected from the mesocosm experiment in Maidao Bay of Qingdao in August 2007, the dominant species of the 11 samples were recognized at the division level and the dominant species of four of the five samples in which the dominant species accounted for more than 80% of the gross biomass were discriminated at the genus level; for the 12 samples obtained from Jiaozhou Bay in August 2007, the dominant species of all the 12 samples were recognized at the division level. The technique can be directly applied to fluorescence spectrophotometers and to the developing of an in situ algae fluorescence auto-analyzer for phytoplankton population.
文摘Installation, detection, maintenance, mapping, and management of underground utility assets present challenges to owners, engineers and contractors. Industry-wide practices include the use of geophysical and similar technologies to determine depth and location, and 2D as-built plans integrated with GIS databases for information management. The feasibility of incorporating 3D BIM models of the subsurface to replace the 2D plans to improve visualization and data management is examined in this paper. Obtaining an accurate image of the underground infrastructure would help minimize excavation accidents due to equipment-utility collisions and prevent property damage. Further, the inclusion of automated data collection and sharing features realized through BIM technology can enhance operations of smart cities. The research methodology consists of a state-of-the-art review of the current underground utility management systems, combined with statistical analysis of survey responses received from utility providers and one-call centers in the U.S. Three categories of utility practices are identified based on the level of digital technology integration. It is found that a vast majority of utility firms have adopted GIS databases with 2D plans, depth and other asset information, while a smaller percentage of providers have achieved full GIS-BIM in<span style="font-family:Verdana;">tegration, incorporating a wide range of asset data. Future progress on</span><span style="font-family:Verdana;"> broader implementation appears to be constrained by the digital literacy of personnel </span><span style="font-family:Verdana;">and high costs of technology acquisition and application. A three-step frame</span><span style="font-family:Verdana;">work for converting 2D plans to 3D BIM models is also presented and discussed. The process model proposed for this purpose allows the utilization of commercially available software with minimal need for additional coding.</span>
文摘In the past ten years,research on face recognition has shifted to using 3D facial surfaces,as 3D geometric information provides more discriminative features.This comprehensive survey reviews 3D face recognition techniques developed in the past decade,both conventional methods and deep learning methods.These methods are evaluated with detailed descriptions of selected representative works.Their advantages and disadvantages are summarized in terms of accuracy,complexity,and robustness to facial variations(expression,pose,occlusion,etc.).A review of 3D face databases is also provided,and a discussion of future research challenges and directions of the topic.
基金This research project was supported by the Scientific Research Projects Programme established under the Karadeniz Technical University(number:2008.112.006.1).
文摘In this paper,an overview of phases for modelling and mapping third dimension of spatial objects in a database is presented based on a selected spatial database management system(DBMS).These phases include(1)defining a spatial reference system for representing three-dimensional(3D)objects with real-world coordinates,(2)geometric modelling of 3D objects in the database,(3)3D spatial indexing for fast accessing/querying the 3D data,3D spatial queries and representation of 3D data.Then,a case study is performed to assess needs,possibilities and potential limitations of 3D data modelling in the spatial database.