CN109885572A - A three-dimensional data encoding and storage method for massive marine environmental data management - Google Patents
A three-dimensional data encoding and storage method for massive marine environmental data management Download PDFInfo
- Publication number
- CN109885572A CN109885572A CN201910126716.9A CN201910126716A CN109885572A CN 109885572 A CN109885572 A CN 109885572A CN 201910126716 A CN201910126716 A CN 201910126716A CN 109885572 A CN109885572 A CN 109885572A
- Authority
- CN
- China
- Prior art keywords
- data
- dimensional
- latitude
- longitude
- ocean
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 32
- 230000007613 environmental effect Effects 0.000 title claims abstract description 31
- 238000013523 data management Methods 0.000 title claims abstract description 21
- 101100182247 Caenorhabditis elegans lat-1 gene Proteins 0.000 claims description 5
- 101150061388 LON1 gene Proteins 0.000 claims description 5
- 239000003653 coastal water Substances 0.000 claims description 3
- 239000000203 mixture Substances 0.000 claims description 3
- 238000012545 processing Methods 0.000 claims description 3
- 230000009466 transformation Effects 0.000 claims description 3
- 230000008520 organization Effects 0.000 abstract description 4
- 238000000605 extraction Methods 0.000 abstract description 2
- 230000008569 process Effects 0.000 description 4
- 230000008859 change Effects 0.000 description 3
- 238000007726 management method Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000013480 data collection Methods 0.000 description 2
- 238000013500 data storage Methods 0.000 description 2
- 238000013461 design Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 238000009472 formulation Methods 0.000 description 2
- 238000005192 partition Methods 0.000 description 2
- 238000011160 research Methods 0.000 description 2
- 101100182248 Caenorhabditis elegans lat-2 gene Proteins 0.000 description 1
- 241001269238 Data Species 0.000 description 1
- PEDCQBHIVMGVHV-UHFFFAOYSA-N Glycerine Chemical compound OCC(O)CO PEDCQBHIVMGVHV-UHFFFAOYSA-N 0.000 description 1
- 230000009471 action Effects 0.000 description 1
- 238000013459 approach Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 239000004744 fabric Substances 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 101150004293 lon2 gene Proteins 0.000 description 1
- 230000007774 longterm Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012950 reanalysis Methods 0.000 description 1
- 150000003839 salts Chemical group 0.000 description 1
- 241000894007 species Species 0.000 description 1
- 230000002123 temporal effect Effects 0.000 description 1
- KMIOJWCYOHBUJS-HAKPAVFJSA-N vorolanib Chemical class C1N(C(=O)N(C)C)CC[C@@H]1NC(=O)C1=C(C)NC(\C=C/2C3=CC(F)=CC=C3NC\2=O)=C1C KMIOJWCYOHBUJS-HAKPAVFJSA-N 0.000 description 1
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02A—TECHNOLOGIES FOR ADAPTATION TO CLIMATE CHANGE
- Y02A90/00—Technologies having an indirect contribution to adaptation to climate change
- Y02A90/10—Information and communication technologies [ICT] supporting adaptation to climate change, e.g. for weather forecasting or climate simulation
Landscapes
- Navigation (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
本发明属于海洋空间信息组织、空间数据管理、空间索引技术领域，具体涉及一种用于海量海洋环境数据管理的三维数据编码及存储方法。包括获取待处理的海洋环境数据的经度、纬度、深度范围；设定对待处理数据进行剖分所要求的分辨率；根据分辨率对环境要素数据进行剖分处理组成数据集合，每个数据集合包含最小单位的各种环境要素信息；使用编码方案对每个数据集合进行编码，作为空间索引号；将索引号和包含环境要素信息的数据集合对应存入数据库中。本发明统一了全球海洋环境数据的存储方式，可根据用户需求提供不同分辨率的数据集，减少了数据冗余，提高了数据的利用率，而且能精准定位到指定的空间范围，从而有利于对指定区域的数据高效提取。
The invention belongs to the technical fields of marine spatial information organization, spatial data management, and spatial indexing, and in particular relates to a three-dimensional data encoding and storage method for massive marine environmental data management. Including obtaining the range of longitude, latitude and depth of the marine environmental data to be processed; setting the resolution required for the subdivision of the data to be processed; subdividing the environmental element data according to the resolution to form a data set, each data set contains Various environmental element information of the smallest unit; use the coding scheme to encode each data set as a spatial index number; store the index number and the data set containing environmental element information in the database correspondingly. The invention unifies the storage method of global marine environment data, can provide data sets with different resolutions according to user requirements, reduces data redundancy, improves the utilization rate of data, and can accurately locate to a designated space range, thereby facilitating Efficient extraction of data in a specified area.
Description
Technical field
The invention belongs to ocean space information tissue, spatial data management, Spatial Data Index Technology fields, and in particular to a kind of
Three-dimensional data coding and storage method for magnanimity marine environment data management.
Background technique
Global high-resolution spatiotemporal object ocean analyze product collection again and be include ocean temperature, salinity, density, the velocity of sound,
The Marine Environmental Elements such as ocean current, sea area range are global sea area, from extra large 9000 meters of 0 meter Zhi Hai lower face of surface, horizontal resolution
Rate is 9 kms, vertical to be divided into 50 layers, when temporal resolution is daily 8 time output in every 3 hours once, no less than 30 years and
The mass data collection updated year by year.Since data set is complicated huge, the format and Species differences of data are larger, for ocean
The simple storage method of space massive information is no longer satisfied the demand of development, how from massive information fast accurate obtains
It takes the data of needs to be analyzed and processed, is one of the developing direction in Spatial Information Science future.In order to which this is better achieved
Point, efficient spatial information tissue, management and expression are important research contents.
Currently, National Oceanic Information Center is directed to digital ocean spatial information warehouse, construct using data warehouse as frame
Country " digital ocean " integrated platform；The digital ocean spatial database of the Maritime Affairs University Of Dalian and Chinese Marine University
MAGIS platform similarly achieves great breakthrough in terms of ocean space data management；Su Fenzhen etc. has developed for ocean
The data model of data multiple characteristic solves tissue and the expression of the ocean entity of dynamic change.But current research work
It is concentrated mainly in the common question for solving data management, analyzes the mass data of product again for long-term sequence ocean
Collection, existing method is unfavorable for effective storage of data and positioning extraction efficiency is slower, is not able to satisfy and is analyzed again global high-resolution
The mass data collection of product realizes the requirement effectively unifying storage and quick and precisely positioning.
It can be seen that being designed for global high-resolution reanalysis datasets a kind of with Global Scale, different resolution
And support very three-dimensional spatial information expression model, to provide a kind of succinct convenient approach in order to solve the above problem, become
Application background and starting point of the invention.
Summary of the invention
The purpose of the present invention is to provide a kind of for the three-dimensional data coding of magnanimity marine environment data management and storage
Method can quickly and accurately navigate to any one region of ocean space.
A kind of three-dimensional data coding and storage method for magnanimity marine environment data management, specifically includes following step
It is rapid:
Step 1, longitude, latitude, the depth bounds for obtaining marine environment data to be processed；
Step 2, setting carry out resolution ratio required by subdivision to pending data；
Step 3 carries out subdivision processing group to temperature, salinity, density, the velocity of sound, ocean current environmental element data according to resolution ratio
At data acquisition system, each data acquisition system includes the various environmental element information of minimum unit；
Step 4 encodes each data acquisition system using encoding scheme, as Spatial Cable quotation marks；
Step 5, will be in call number and the corresponding deposit database of data acquisition system comprising environmental element information.
A kind of three-dimensional data coding and storage method for magnanimity marine environment data management, according to data set
Information description, is defined as i for step 2 intermediate-resolution, wherein i can indicate range at 1/32 ° to 1 ° as unit of spending.
A kind of three-dimensional data for magnanimity marine environment data management encodes and storage method, specific in step 3
Environmental data include temperature, salinity, density, the velocity of sound, ocean current horizontal component, ocean current vertical component this 6 kinds of basic ocean essentials
Value.
A kind of three-dimensional data for magnanimity marine environment data management encodes and storage method, three-dimensional in step 4
Encoding scheme is the wherein two-dimensional encoded part of longitude and latitude 8 by longitude and latitude is two-dimensional encoded and the coding of depth dimension is constituted, depth
Dimension 2, collectively constitutes 10 position digital codings, coded format D0D1D2d3D4D5D6d7D8D9, wherein D expression decimal values,
The d resolution ratio according to setting can be the numerical value such as the decimal system, hexadecimal, duotricemary notation.
A kind of three-dimensional data coding and storage method for magnanimity marine environment data management, step 4 are specifically wrapped
Include following steps:
Step 4.1 is defined based on latitude and longitude coordinates space and the two-dimensional encoded part of resolution ratio pair warp and weft degree, specific to count
Calculation process is as follows:
Geospatial location is projected into single quadrant rectangular coordinate system, if abscissa value is x, transformed vertical seat after transformation
Scale value is y, wherein x=lat1+90=132.125, y=lon1+180=280.25；
D0It represents the longitude first order: taking the hundreds D of y0=[y ÷ 100]=2；
D1It represents the longitude second level: taking the tens D of y1=[y-100 × D0]=8；
D2It represents the longitude third level: taking the units D of y2=[y-100 × D0-10×D1]=0；
d3It represents longitude resolution ratio: d is calculated according to resolution ratio i3=[(y-100 × D0-10×D1-D2) ÷ i]=2, similarly,
The same above formula when resolution ratio takes other values, when i < 1/10 °, d3It is indicated using hexadecimal or duotricemary notation number；
D4It represents the latitude first order: taking the hundreds D of x0=[x ÷ 100]=1；
D5It represents the latitude second level: taking the tens D of x5=[x-100 × D4]=3；
D6It represents the latitude third level: taking the units D of x6=[x-100 × D4-10×D5]=2；
d7Represent latitude resolution ratio: d7=[(x-100 × D4-10×D5-D6) ÷ i]=1, similarly, when resolution ratio takes other
Same above formula when value, when i < 1/10 °, d7It is indicated using hexadecimal or duotricemary notation number；
Step 4.2 is defined depth dimension coded portion based on depth, different from common three-dimensional uniform grid point
Cloth, ocean space data are unevenly distributed in the horizontal direction, and coastal waters space of planes Marine Environmental Elements change greatly, and at deep-sea
The variation of space Marine Environmental Elements is smaller；And the ocean depth very little for longitude and latitude distance, so depth dimension encodes
It is divided according to the number of plies, D8D9For two decimal numbers, data level is represented, indicates 0~99 layer.
A kind of three-dimensional data coding and storage method for magnanimity marine environment data management, step 5 are specifically wrapped
Include following steps:
Step 5.1 establishes ocean according to the source of data and analyzes product database again；
Step 5.2, in each database, establish two kinds of table respectively, a seed type is metadata table, another
For specific tables of data, tissue divides several tables of data as unit of the time.
Step 5.3, in each specific tables of data, using the encoded radio being calculated by 3-dimensional encoding as call number,
Temperature in one-to-one data acquisition system therewith, salinity, density, the velocity of sound, ocean current horizontal component, ocean current vertical component element is incited somebody to action to make
For each attribute value, two-dimensional table is established, and sets major key index for ID value.
The beneficial effects of the present invention are:
The 3-dimensional encoding method of ocean space data provided by the present invention can be based on it to global ocean environmental data
Affiliated spatial position carries out universal formulation, and establishes concordance list to the data acquisition system marked off, and this method has unified global sea
The storage mode of foreign environmental data, and the data set of different resolution can be provided according to user demand, reduce data redundancy,
Improve the utilization rate of data.On the basis of above-mentioned 3-dimensional encoding method, data managing method provided by the present invention is used
Marine environment data is stored, since call number is directly corresponding with data acquisition system, passes through index fast searching number
According to precise positioning is to specified spatial dimension, to be conducive to extract the data efficient in specified region.
Detailed description of the invention
Fig. 1 is ocean space subdivision volume elements schematic diagram；
Fig. 2 is the data partition pretreatment process figure of the invention based on three-dimensional data coding；
Fig. 3 is the database metadata table figure that the present invention establishes；
Fig. 4 is the specific tables of data figure of database that the present invention establishes.
Specific embodiment
The present invention is described further with reference to the accompanying drawing.
The three-dimensional data coding extracted for ocean space data proposed by the invention and storage method main thought are:
Subdivision is carried out to initial data to be processed using the resolution ratio of setting, obtains a series of numbers comprising all Ocean environment informations
According to set；Data acquisition system is encoded using the three-dimensional data encoding scheme of design, is denoted as call number；By call number and data
Set corresponds, and design storage organization saves in the database, is believed using specified marine environment of the call number to specified region
Breath extracts.
The raw data set that example of the present invention uses is distributed across E99 ° to E150 ° of longitude range, latitude scope N-
10 ° to N52 °, 0 layer to 49 layers of depth bounds, time range be 1 day 0 January in 1988 of space-time when 31 days 21 December in 2017
Range, comprising temperature, salinity, density, the velocity of sound, ocean current horizontal component, ocean current vertical component element, resolution ratio is 1/8 °
Such a raw data set.
It as shown in Fig. 1, is ocean space subdivision volume elements schematic diagram；Attached drawing 2 is of the invention based on three-dimensional data coding
Data partition pretreatment process figure；Attached drawing 3 is the database metadata table figure that the present invention establishes；Attached drawing 4 is that the present invention establishes
The specific tables of data figure of database.
One, the step of 3-dimensional encoding scheme of the invention and data prediction, is described in detail below with reference to Fig. 2:
Step 1, longitude, latitude, the depth bounds for obtaining marine environment data to be processed；
For marine environment data, it includes certain space range informations, according to the property file or letter of initial data
Breath description, obtains its space-time unique.If longitude range variable is lon1 and lon2, latitude scope variable is lat1 and lat2, deep
Degree bound variable is h1 and h2, and time range variable is time1 and time2；
Step 2, setting carry out resolution ratio required by subdivision to pending data；
It is described according to the information of data set, resolution ratio is defined as i, wherein i can indicate range 1/ as unit of spending
32 ° to 1 °.It can be by the description degree of being converted to of other unit in actual application.I=1/8 ° in this example；
Step 3 carries out subdivision processing group to temperature, salinity, density, the velocity of sound, ocean current environmental element data according to resolution ratio
At data acquisition system, each data acquisition system includes the various environmental element information of minimum unit；
Specific environmental data includes temperature, salinity, density, the velocity of sound, ocean current horizontal component, this 6 kinds of ocean current vertical component
The value of basic ocean essential, if temperature variable is temperature, salinity variable is salinity, and density variables are
Density, velocity of sound variable are soundvelocity, and ocean current horizontal component is u, and ocean current vertical component is v.Choose ocean space
It is described in detail for certain point.For the point A concentrated for example, by using initial data, the spatial position of A point is longitude
E100.25 °, N42.125 ° of latitude, the 0th layer of depth, when the time is on September 27,03 2016, temperature value 20.0417, salinity
Value is 34.0927, density value 1021.6816, acoustic velocity value 1520.9167, and ocean current horizontal component is 9999.0000, ocean current
Vertical component is 9999.0000.Then according to above-mentioned definition, lon1=100.25, lat1=42.125, h1=0, time1=
2016092703, temperature=20.0417, salinity=34.0927, density=1520.9167,
Soundvelocity=1021.6816, u=9999.0000, v=9999.0000；
Can similarly subdivision be carried out to other spatial position points that data are concentrated and integration is handled；
Step 4 encodes each data acquisition system using encoding scheme, as Spatial Cable quotation marks；
3-dimensional encoding scheme of the invention is by longitude and latitude is two-dimensional encoded and the coding of depth dimension is constituted；Wherein longitude and latitude
Two-dimensional encoded part 8, collectively constitutes 10 position digital codings by depth dimension 2.If coded format is D0D1D2d3D4D5D6d7D8D9,
Encoded radio is set as dm, calculation formula are as follows:
Dm=1000000000 × D0+100000000×D1+10000000×D2+1000000×d3+100000×D4+
10000×D5+1000×D6+100×d7+10D8+D9
Wherein D indicates decimal value, and d can be the decimal system, hexadecimal, duotricemary notation number according to the resolution ratio of setting
Value.
WhenWhen, resolution bits d is indicated using decimal integer；When such as i=1/8 °, d selectable value 0,1,2,3,
4,5,6,7,8,9；
WhenWhen, resolution bits d is indicated using hexadecimal integers；When such as i=1/12 °, d selectable value 0,1,
2,3,4,5,6,7,8,9,A,B；
WhenWhen, resolution bits d is indicated using hexadecimal integers；When such as i=1/20 °, d selectable value 0,1,
2,3,4,5,6,7,8,9,A,B,C,D,E,F,G,H,J,K；
Longitude and latitude is two-dimensional encoded to be based partially on latitude and longitude coordinates space and resolution ratio is defined；By taking sampled point A as an example, tool
Body calculating process is as follows:
Geospatial location is projected into single quadrant rectangular coordinate system, if abscissa value is x, transformed vertical seat after transformation
Scale value is y, wherein x=lat1+90=132.125, y=lon1+180=280.25；
D0It represents the longitude first order: taking the hundreds D of y0=[y ÷ 100]=2；
D1It represents the longitude second level: taking the tens D of y1=[y-100 × D0]=8；
D2It represents the longitude third level: taking the units D of y2=[y-100 × D0-10×D1]=0；
d3It represents longitude resolution ratio: d is calculated according to resolution ratio i3=[(y-100 × D0-10×D1-D2) ÷ i]=2, similarly,
The same above formula when resolution ratio takes other values, when i < 1/10 °, d3It is indicated using hexadecimal or duotricemary notation number；
D4It represents the latitude first order: taking the hundreds D of x0=[x ÷ 100]=1；
D5It represents the latitude second level: taking the tens D of x5=[x-100 × D4]=3；
D6It represents the latitude third level: taking the units D of x6=[x-100 × D4-10×D5]=2；
d7Represent latitude resolution ratio: d7=[(x-100 × D4-10×D5-D6) ÷ i]=1, similarly, when resolution ratio takes other
Same above formula when value, when i < 1/10 °, d7It is indicated using hexadecimal or duotricemary notation number.
Depth dimension coded portion is defined based on depth.It is distributed different from common three-dimensional uniform grid, ocean space
Data are unevenly distributed in the horizontal direction, and coastal waters space of planes Marine Environmental Elements change greatly, and in deep-sea space ocean ring
The variation of border element is smaller；And the ocean depth very little for longitude and latitude distance.In summary consider, depth dimension encodes root
It is divided according to the number of plies, D8D9For two decimal numbers, data level is represented, can indicate 0~99 layer.D in this example8=0, D9=0.
The then dm=2802132100 of sampled point A；
Shown in example as above, uniquely tagged is carried out to each data acquisition system by three-dimensional data encoding scheme, coding is made
For the call number of each set.
Above step realizes the pretreatment and tri-bit encoding to marine environment initial data, is global ocean spatial data
Organization of unity and management lay a good foundation.
Two, the unified storage management of data.
Above-mentioned steps have determined the call number of subdivision data acquisition system, for each subdivision data set, by itself and call number one
One is corresponding, constitutes an information of storage ocean space data file, by obtained call number and includes environmental element information
It is managed in the corresponding deposit database of data acquisition system.The present invention devises a kind of data file and unifies storage scheme, specific to walk
It is rapid as follows:
Step 1 establishes ocean according to the source of data and analyzes product database again.
It is as follows using sql like language creation database by taking MySQL database as an example:
CREATE DATABASE reanalysisdata；
Step 2, in each database, establish two kinds of table respectively.One seed type is metadata table, for illustrating
Some description informations such as data type, storage format in this library, the understanding convenient for user to database Global Information；It is another
For specific tables of data, tissue divides several tables of data as unit of the time, and table is named as MEDyyyymmddhh, and wherein MED is sea
The english abbreviation of foreign environmental data Marine Environmental Data, yyyy indicate year, and mm indicates that the moon, dd indicate day, hh
When expression, such as by May 17,03 2016 when all marine environment datas be stored in a tables of data, table is named as
MED2016051703.Every 3 hours of 30 years primary specific tables of data totally 87600 (30* can be created according to raw data set
365*8) open.
It is as follows to create metadata table example:
Wherein cust_id is from increasing number, and cust_range is space-time unit information, and cust_element is environmental element
Information, cust_i are resolution ratio, and table content is as shown in Figure 3；
Step 3, in each specific tables of data, will be with using the dm value being calculated by 3-dimensional encoding as call number
One-to-one data acquisition system in temperature, salinity, density, the velocity of sound, ocean current horizontal component, ocean current vertical component element as each
Attribute value establishes two-dimensional table, and sets major key index for ID value, to accelerate the search speed of data；
It is as follows to create specific tables of data example MED2016051703:
Wherein dm is three-dimensional data coding, and temperature is temperature value, and salinity is salt angle value, and density is close
Angle value, soundvelocity are acoustic velocity value, and u and v are ocean current level, vertical direction component；
It is as follows that factor data is imported into table:
LOAD DATA INFILE'E:/dmfile/zuobiaodmt.txt'INTO TABLE MED2016051703
fields terminated by','
lines terminated by'\r\n'
(dm,temperature,salinity,density,soundvelocity,u,v)；
Based on above scheme, the Marine Environmental Elements data of i.e. extractable designated position are needed according to user.
The invention proposes a kind of 3-dimensional encoding methods of ocean space data, and to data based on this coding method
Unified organization and administration are carried out, data storage scheme is devised.On the one hand global ocean environmental data can be based on belonging to it
Spatial position carry out universal formulation, convenient for the accurate positionin of Ocean environment information；On the other hand global ocean environment has been unified
The storage mode of data can reduce data redundancy, index is avoided to repeat, improve search efficiency.
The above is merely preferred embodiments of the present invention, in summary, it is not intended to limit the scope of the present invention.
All within the spirits and principles of the present invention, any modification, equivalent replacement, improvement and so on should be included in of the invention
Within protection scope.
Claims (6)
1. a kind of three-dimensional data coding and storage method for magnanimity marine environment data management, which is characterized in that specific packet
Include following steps:
Step 1, longitude, latitude, the depth bounds for obtaining marine environment data to be processed；
Step 2, setting carry out resolution ratio required by subdivision to pending data；
Step 3 carries out subdivision processing composition number to temperature, salinity, density, the velocity of sound, ocean current environmental element data according to resolution ratio
According to set, each data acquisition system includes the various environmental element information of minimum unit；
Step 4 encodes each data acquisition system using encoding scheme, as Spatial Cable quotation marks；
Step 5, will be in call number and the corresponding deposit database of data acquisition system comprising environmental element information.
2. a kind of three-dimensional data coding and storage method for magnanimity marine environment data management according to claim 1,
It is characterized in that, describing according to the information of data set, resolution ratio described in step 2 is defined as i, i indicates model as unit of spending
It is trapped among 1/32 ° to 1 °.
3. a kind of three-dimensional data coding and storage method for magnanimity marine environment data management according to claim 1,
It is characterized in that, environmental element data described in step 3 includes that temperature, salinity, density, the velocity of sound, ocean current horizontal component, ocean current are perpendicular
The value of this 6 kinds of ocean essentials of straight component.
4. a kind of three-dimensional data coding and storage method for magnanimity marine environment data management according to claim 1,
It is characterized in that, 3-dimensional encoding scheme described in step 4 be by longitude and latitude is two-dimensional encoded and the coding of depth dimension is constituted, wherein
The two-dimensional encoded part of longitude and latitude 8, depth dimension 2, collectively constitutes 10 position digital codings, coded format is
D0D1D2d3D4D5D6d7D8D9, wherein D expression decimal values, d according to the resolution ratio set as the decimal system, hexadecimal
Or duotricemary notation numerical value.
5. a kind of three-dimensional data coding and storage method for magnanimity marine environment data management according to claim 1,
It is characterized in that, the step 4 specifically comprises the following steps:
Step 4.1 is defined based on latitude and longitude coordinates space and the two-dimensional encoded part of resolution ratio pair warp and weft degree, is specifically calculated
Journey is as follows:
Geospatial location is projected into single quadrant rectangular coordinate system, if abscissa value is x, transformed ordinate value after transformation
For y, wherein x=lat1+90=132.125, y=lon1+180=280.25；
D0It represents the longitude first order: taking the hundreds D of y0=[y ÷ 100]=2；
D1It represents the longitude second level: taking the tens D of y1=[y-100 × D0]=8；
D2It represents the longitude third level: taking the units D of y2=[y-100 × D0-10×D1]=0；
d3It represents longitude resolution ratio: d is calculated according to resolution ratio i3=[(y-100 × D0-10×D1-D2) ÷ i]=2, when i < 1/10 °
When, d3It is indicated using hexadecimal or duotricemary notation number；
D4It represents the latitude first order: taking the hundreds D of x0=[x ÷ 100]=1；
D5It represents the latitude second level: taking the tens D of x5=[x-100 × D4]=3；
D6It represents the latitude third level: taking the units D of x6=[x-100 × D4-10×D5]=2；
d7Represent latitude resolution ratio: d7=[(x-100 × D4-10×D5-D6) ÷ i] and=1, i < 1/10 ° when, d7Using hexadecimal
Or duotricemary notation number indicates；
Step 4.2 is defined depth dimension coded portion based on depth, is distributed different from common three-dimensional uniform grid, sea
Foreign spatial data is unevenly distributed in the horizontal direction, and the variation of coastal waters space of planes Marine Environmental Elements is big, and in deep-sea space sea
The variation of foreign environmental element is small；And ocean depth is small for longitude and latitude distance, so depth dimension coding is drawn according to the number of plies
Point, D8D9For two decimal numbers, data level is represented, indicates 0~99 layer.
6. a kind of three-dimensional data coding and storage method for magnanimity marine environment data management according to claim 1,
It is characterized in that, the step 5 specifically comprises the following steps:
Step 5.1 establishes ocean according to the source of data and analyzes product database again；
Step 5.2, in each database, establish two kinds of table respectively, a seed type is metadata table, and another kind is tool
Volume data table, tissue divides several tables of data as unit of the time；
Step 5.3, in each specific tables of data, will be with using the encoded radio being calculated by 3-dimensional encoding as call number
Corresponding data acquisition system in temperature, salinity, density, the velocity of sound, ocean current horizontal component, ocean current vertical component element as each attribute
Value, establishes two-dimensional table, and set major key index for ID value.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910126716.9A CN109885572B (en) | 2019-02-20 | 2019-02-20 | A three-dimensional data encoding and storage method for massive marine environmental data management |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910126716.9A CN109885572B (en) | 2019-02-20 | 2019-02-20 | A three-dimensional data encoding and storage method for massive marine environmental data management |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109885572A true CN109885572A (en) | 2019-06-14 |
| CN109885572B CN109885572B (en) | 2023-05-30 |
Family
ID=66928668
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910126716.9A Active CN109885572B (en) | 2019-02-20 | 2019-02-20 | A three-dimensional data encoding and storage method for massive marine environmental data management |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109885572B (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111324683A (en) * | 2020-02-19 | 2020-06-23 | 中国电子科技集团公司第二十八研究所 | Data management method for unified coding of space-time and elements |
| CN111368023A (en) * | 2020-03-29 | 2020-07-03 | 北京量子时代智能设备有限公司 | A Safe Representation Method for Matrix Text Data Storage |
| CN111695250A (en) * | 2020-06-04 | 2020-09-22 | 哈尔滨工程大学 | Method for extracting internal tide features |
| CN111931006A (en) * | 2020-07-29 | 2020-11-13 | 厦门蓝海天信息技术有限公司 | Storage method of ocean lattice point data |
| CN112364119A (en) * | 2020-12-01 | 2021-02-12 | 国家海洋信息中心 | Ocean buoy track prediction method based on LSTM coding and decoding model |
| CN112612777A (en) * | 2020-12-24 | 2021-04-06 | 浙江大学 | MySQL database-based marine data management and visualization system and method |
| CN112905686A (en) * | 2021-03-24 | 2021-06-04 | 中国海洋大学 | Python program-based ocean profile water body data extraction method |
| CN114693699A (en) * | 2022-03-03 | 2022-07-01 | 青岛国实科技集团有限公司 | Marine data pricing method and device based on custom map division |
| CN119537423A (en) * | 2025-01-17 | 2025-02-28 | 中国人民解放军国防科技大学 | Atmospheric and oceanic data retrieval optimization method and device based on column database |
| CN120086423A (en) * | 2025-04-30 | 2025-06-03 | 中国科学院空天信息创新研究院 | Ocean environment field data loading method and device, electronic equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2007142507A1 (en) * | 2006-06-09 | 2007-12-13 | Richard George Azlan Abas | System and method for identifying geographic locations |
| CN103150338A (en) * | 2013-02-04 | 2013-06-12 | 北京大学 | Subdivision pretreatment method and data extraction method used for image data extraction |
| CN108235057A (en) * | 2018-03-21 | 2018-06-29 | 中国科学院遥感与数字地球研究所 | A kind of network transmission and method for visualizing of extensive utilizing ocean current data |
-
2019
- 2019-02-20 CN CN201910126716.9A patent/CN109885572B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2007142507A1 (en) * | 2006-06-09 | 2007-12-13 | Richard George Azlan Abas | System and method for identifying geographic locations |
| CN103150338A (en) * | 2013-02-04 | 2013-06-12 | 北京大学 | Subdivision pretreatment method and data extraction method used for image data extraction |
| CN108235057A (en) * | 2018-03-21 | 2018-06-29 | 中国科学院遥感与数字地球研究所 | A kind of network transmission and method for visualizing of extensive utilizing ocean current data |
Non-Patent Citations (2)
| Title |
|---|
| 李康荣等: "基于经纬度剖分的空间信息编码研究", 《四川师范大学学报(自然科学版)》 * |
| 杨明远等: "基于Hilbert编码索引的海洋环境数据库优化", 《地理空间信息》 * |
Cited By (16)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111324683B (en) * | 2020-02-19 | 2023-08-25 | 中国电子科技集团公司第二十八研究所 | Space-time and element unified coding data management method |
| CN111324683A (en) * | 2020-02-19 | 2020-06-23 | 中国电子科技集团公司第二十八研究所 | Data management method for unified coding of space-time and elements |
| CN111368023A (en) * | 2020-03-29 | 2020-07-03 | 北京量子时代智能设备有限公司 | A Safe Representation Method for Matrix Text Data Storage |
| CN111695250A (en) * | 2020-06-04 | 2020-09-22 | 哈尔滨工程大学 | Method for extracting internal tide features |
| CN111931006A (en) * | 2020-07-29 | 2020-11-13 | 厦门蓝海天信息技术有限公司 | Storage method of ocean lattice point data |
| CN112364119B (en) * | 2020-12-01 | 2023-04-18 | 国家海洋信息中心 | Ocean buoy trajectory prediction method based on LSTM coding and decoding model |
| CN112364119A (en) * | 2020-12-01 | 2021-02-12 | 国家海洋信息中心 | Ocean buoy track prediction method based on LSTM coding and decoding model |
| CN112612777A (en) * | 2020-12-24 | 2021-04-06 | 浙江大学 | MySQL database-based marine data management and visualization system and method |
| CN112612777B (en) * | 2020-12-24 | 2023-12-12 | 浙江大学 | Ocean data management and visualization system and method based on MySQL database |
| CN112905686B (en) * | 2021-03-24 | 2022-08-05 | 中国海洋大学 | A method for extracting water body data of ocean profile based on Python program |
| CN112905686A (en) * | 2021-03-24 | 2021-06-04 | 中国海洋大学 | Python program-based ocean profile water body data extraction method |
| CN114693699A (en) * | 2022-03-03 | 2022-07-01 | 青岛国实科技集团有限公司 | Marine data pricing method and device based on custom map division |
| CN119537423A (en) * | 2025-01-17 | 2025-02-28 | 中国人民解放军国防科技大学 | Atmospheric and oceanic data retrieval optimization method and device based on column database |
| CN119537423B (en) * | 2025-01-17 | 2025-04-01 | 中国人民解放军国防科技大学 | Atmospheric ocean data retrieval optimization method and device based on column type database |
| CN120086423A (en) * | 2025-04-30 | 2025-06-03 | 中国科学院空天信息创新研究院 | Ocean environment field data loading method and device, electronic equipment and storage medium |
| CN120086423B (en) * | 2025-04-30 | 2025-07-11 | 中国科学院空天信息创新研究院 | Ocean environment field data loading method and device, electronic equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109885572B (en) | 2023-05-30 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109885572A (en) | A three-dimensional data encoding and storage method for massive marine environmental data management | |
| CN112685407A (en) | Spatial data indexing method based on GeoSOT global subdivision grid code | |
| CN115129795A (en) | Data space-time storage method based on geospatial grid | |
| CN116912441A (en) | A visualization method, device and medium for marine hydrometeorological data | |
| CN110633282A (en) | Airspace resource multistage three-dimensional gridding method and tool | |
| CN116860905B (en) | Space unit coding generation method of city information model | |
| CN104182475A (en) | A Fast Retrieval Method of Location Information Based on Mask Technology and Subdivision Coding | |
| CN110765298B (en) | Tile coding method for decoupling geometric attributes of vector data | |
| CN109241217A (en) | A kind of the condition of a disaster data space statistics, inquiry and methods of exhibiting based on geographic grid | |
| Xiao et al. | Agreement Analysis and Accuracy Assessment of Multiple Mangrove Datasets in Guangxi Beibu Gulf and Guangdong-Hong Kong-Macau Greater Bay, China, for 2000–2020 | |
| Kim et al. | Efficient encoding and decoding extended geocodes for massive point cloud data | |
| Hu et al. | Exploring geospatial data visualization based on python | |
| CN116630564B (en) | Three-dimensional geocoding method for large-scale full-element scene | |
| Hong et al. | A model and framework of self-adaptive spatial information multi-grid | |
| Heslin et al. | Baseline for the coast of Puerto Rico's main island generated to calculate shoreline change rates using the Digital Shoreline Analysis System version 5.1 (ver. 2.0, March 2023) | |
| Xiong et al. | Construction of an electronic chart visualisation platform integrating NetCDF information | |
| Heslin et al. | Shoreline change rates for the islands of Vieques and Culebra, Puerto Rico, calculated using the Digital Shoreline Analysis System version 5.1 | |
| WANG et al. | Geological database for plate tectonic reconstruction: a conceptual model | |
| Qianqian et al. | Geographic Information System Oriented GIS Automatic Surveying and Mapping Technology | |
| Qi et al. | A Grid-Based Identification Code for Buildings: Perspective from Spatial Fault Tolerance | |
| Sui et al. | Discussion on integrated digital chart data model and display platform for pocket navigator system (PNS) | |
| CN119537662A (en) | A method for retrieving marine environment spatial data | |
| Zawada et al. | Projected Seafloor Elevation Along the Florida Reef Tract From Deerfield Beach to Homestead, Florida—100 Years From 2014 Based on Historical Rates of Mean Elevation Change | |
| Sui et al. | Design of integrated electronic chart pocket navigator system (PNS) and application for passage ship auto-track | |
| Li et al. | Application Research on WebGIS Index System Based on Fractal Theory |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |