CN114443657A - Spatial data layer field checking method and system applied to digital twin city - Google Patents

Spatial data layer field checking method and system applied to digital twin city Download PDF

Info

Publication number
CN114443657A
CN114443657A CN202210075844.7A CN202210075844A CN114443657A CN 114443657 A CN114443657 A CN 114443657A CN 202210075844 A CN202210075844 A CN 202210075844A CN 114443657 A CN114443657 A CN 114443657A
Authority
CN
China
Prior art keywords
field
data
spatial data
configuration file
interface
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.)
Pending
Application number
CN202210075844.7A
Other languages
Chinese (zh)
Inventor
郭振
白玉坤
柴青
崔维康
马凌雁
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Jinan Langchao Zhitou Intelligent Technology Co ltd
Original Assignee
Jinan Langchao Zhitou Intelligent Technology Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Jinan Langchao Zhitou Intelligent Technology Co ltd filed Critical Jinan Langchao Zhitou Intelligent Technology Co ltd
Priority to CN202210075844.7A priority Critical patent/CN114443657A/en
Publication of CN114443657A publication Critical patent/CN114443657A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/29Geographical information databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F11/00Error detection; Error correction; Monitoring
    • G06F11/07Responding to the occurrence of a fault, e.g. fault tolerance
    • G06F11/08Error detection or correction by redundancy in data representation, e.g. by using checking codes
    • G06F11/10Adding special bits or symbols to the coded information, e.g. parity check, casting out 9's or 11's
    • G06F11/1004Adding special bits or symbols to the coded information, e.g. parity check, casting out 9's or 11's to protect a block of data words, e.g. CRC or checksum
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • General Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Computer Security & Cryptography (AREA)
  • Quality & Reliability (AREA)
  • Software Systems (AREA)
  • Remote Sensing (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a method and a system for checking a field of a spatial data layer applied to a digital twin city, belongs to the technical field of digital twin data processing, and solves the technical problem of how to automatically check and process spatial data of the digital twin city. The method comprises the following steps: setting a configuration file, including an inspection form, for filling in field information to be inspected; respectively setting data sources of the spatial data according to the classification, and acquiring various types of spatial data; the fields recorded in the configuration file are used as target fields, the fields to be checked of the spatial data are used as source fields, batch check processing is carried out on various types of spatial data through check items set by the configuration file based on ArcGIS, if the target fields are not matched with the source fields, the fields are recorded, layers are identified and stored in a created error identification file, so that layer elements which are marked with check errors can be selected and corrected, and attribute assignment is carried out on the spatial data which are verified to be correct.

Description

Spatial data layer field checking method and system applied to digital twin city
Technical Field
The invention relates to the technical field of digital twin data processing, in particular to a method and a system for checking a field of a spatial data layer applied to a digital twin city.
Background
With the continuous development and evolution of the digital twinning technology, the digital twinning technology is not only a technology, but also a new development mode, a new transformation path and a new power for promoting the deep revolution of various industries. The technology of the digital twin city is gradually fallen to the ground and implemented in the industry, and the digital twin city is not only an innovative concept and a technical scheme but also a necessary route and future selection for the construction and development of a novel smart city. With the construction process of the digital twin city, a series of practical problems are exposed, for example, the processing efficiency of urban space data is low, the types of urban space basic data are complicated, the data volume is large, and the current requirements can not be met by simply processing the urban space basic data manually.
In the process of constructing and warehousing the basic data of the digital twin city, all spatial data need to be subjected to quality inspection, wherein the field attribute inspection of the data is indispensable, but the efficiency is greatly influenced because the interpretation inspection can only be carried out manually at present, and because the manual interpretation also has errors, a method for automatically inspecting the spatial data is urgently needed.
Based on the analysis, how to automatically check and process the spatial data of the digital twin city is a technical problem to be solved.
Disclosure of Invention
The technical task of the invention is to provide a method and a system for checking the layer field of the spatial data applied to the digital twin city to solve the technical problem of how to automatically check and process the spatial data of the digital twin city.
In a first aspect, the method for checking a field of a layer of spatial data applied to a digital twin city according to the present invention checks a field of each layer of spatial data according to a type based on ArcGIS, and outputs a field with an error, the method comprising the steps of:
setting a configuration file, wherein the configuration file comprises an inspection form used for filling field information to be inspected;
respectively setting data sources of the spatial data according to the classification, and acquiring various types of spatial data;
the fields recorded in the configuration file are used as target fields, the fields to be checked of the spatial data are used as source fields, batch check processing is carried out on various types of spatial data through check items set by the configuration file based on ArcGIS, if the target fields are not matched with the source fields, the fields are recorded, layers are identified and stored in a created error identification file, so that layer elements which are marked with check errors can be selected and corrected, and attribute assignment is carried out on the spatial data which are verified to be correct.
Preferably, the check table is in an excel format, the column a of the check table is a layer name and is used for introducing a setting format of a layer field, the column B of the check table is a Shape field and is used for checking whether a Z value exists, and the columns C and the columns thereafter of the check table are other fields in the layer, and the format is field name-field type-length-precision-decimal point digit.
3. The method for checking the field of the spatial data layer applied to the digital twin city according to claim 1, wherein the spatial data sources comprise an urban road data source, an urban river data source, an urban house data source and an urban green land data source;
the formats of the urban road data source, the urban river data source, the urban house data source and the urban green land data source may be SHP, MDB or GDB data formats.
4. The method for checking the field of the layer of the spatial data applied to the digital twin city according to claim 1, wherein the batch checking process is performed on various types of spatial data through checking items set by a configuration file based on ArcGIS, and the method comprises the following steps:
providing an interface IFeatureWorkspace through ArcGIS to instantiate a FeatureWorkspace method, using an IFields interface to instantiate a Field method, circularly traversing the Field and matching the Field in a configuration file, judging the Field type after configuration, and judging whether the Field type is correct;
based on an IGeometridef interface, an IFeature interface, an IDataset interface and an IFieldedit interface provided by ArcGIS, the type and the length of a field are obtained by instantiating the IGeometridef interface and using a get _ GridSize method in a GeometryDef class, space data are read by instantiating the IFeature interface and using a Store method of a Feature class, judgment is carried out according to the format of a configuration file, if the space data contain a data set, the space data set needs to be read by using the IDataset interface, a Feature instance is found for field reading and detection, and if the detected data need to be modified, the data type and the data are modified by using a method in the IFieldedit interface.
5. Spatial data layer field inspection system applied to digital twin city, which is characterized by comprising:
the system comprises a configuration file generation module, a configuration file generation module and a configuration file processing module, wherein the configuration file generation module is used for setting a configuration file, the configuration file comprises an inspection form, and the inspection form is used for filling field information to be inspected;
the data source module is used for respectively setting data sources of the spatial data according to classification and acquiring various types of spatial data;
the checking module is used for taking the field recorded in the configuration file as a target field and taking the field to be checked of the spatial data as a source field, carrying out batch checking processing on various types of spatial data based on ArcGIS and checking items set through the configuration file, recording the field if the target field is not matched with the source field, identifying the layer, storing the layer into a created error identification file, so that the layer elements which mark the checking error are selected and corrected, and carrying out attribute assignment on the spatial data which are verified to be correct.
6. The system according to claim 5, wherein the check form is in excel format, column a of the check form is layer name for introducing the setting format of layer field, column B of the check form is Shape field for checking if there is Z value, column C of the check form and the following columns are other fields in the layer, and the format is field name-field type-length-precision-decimal point digit.
7. The system for checking the field of the spatial data layer applied to the digital twin city according to claim 5, wherein the spatial data sources comprise an urban road data source, an urban river data source, an urban house data source and an urban green land data source;
the formats of the urban road data source, the urban river data source, the urban house data source and the urban green land data source may be SHP, MDB or GDB data formats.
8. The system according to claim 5, wherein the inspection module is configured to perform batch inspection processing on various types of spatial data according to the inspection items set by the configuration file based on ArcGIS by the following steps:
providing an interface IFeatureWorkspace through ArcGIS to instantiate a FeatureWorkspace method, using an IFields interface to instantiate a Field method, circularly traversing the Field and matching the Field in a configuration file, judging the Field type after configuration, and judging whether the Field type is correct;
based on an IGeometridef interface, an IFeature interface, an IDataset interface and an IFieldedit interface provided by ArcGIS, the type and the length of a field are obtained by instantiating the IGeometridef interface and using a get _ GridSize method in a GeometryDef class, space data are read by instantiating the IFeature interface and using a Store method of a Feature class, judgment is carried out according to the format of a configuration file, if the space data contain a data set, the space data set needs to be read by using the IDataset interface, a Feature instance is found for field reading and detection, and if the detected data need to be modified, the data type and the data are modified by using a method in the IFieldedit interface.
9. An apparatus, comprising: at least one memory and at least one processor;
the at least one memory to store a machine readable program;
the at least one processor, configured to invoke the machine readable program to perform the method of any of claims 1 to 4.
10. Computer readable medium, characterized in that it has stored thereon computer instructions which, when executed by a processor, cause the processor to carry out the method of any one of claims 1 to 4.
The method and the system for checking the field of the spatial data layer applied to the digital twin city have the following advantages: the method comprises the steps of setting a configuration file comprising an inspection form, wherein the inspection form is used for filling field information to be inspected, inspecting various spatial data through inspection items set in the configuration file based on ArcGIS, recording fields if the fields are wrong, identifying layers, storing the fields in a created error identification file and outputting the error identification file, so that automatic inspection is realized, the bottleneck of the existing manual operation is broken, and the quality inspection of the data and the efficiency of data warehousing are improved.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings needed for the embodiments or the prior art descriptions will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art to obtain other drawings based on the drawings without creative efforts.
The invention is further described below with reference to the accompanying drawings.
FIG. 1 is a block diagram illustrating a method for checking a field of a spatial data layer applied to a digital twin city according to embodiment 1;
fig. 2 is a schematic structural diagram of an inspection table in the method for inspecting a field of a spatial data layer applied to a digital twin city in embodiment 1;
fig. 3 is a schematic diagram of an error of an inspection table in the method for inspecting a field of a spatial data layer applied to a digital twin city according to embodiment 1.
Detailed Description
The present invention is further described in the following with reference to the drawings and the specific embodiments so that those skilled in the art can better understand the present invention and can implement the present invention, but the embodiments are not to be construed as limiting the present invention, and the embodiments and the technical features of the embodiments can be combined with each other without conflict.
The embodiment of the invention provides a method and a system for checking a layer field of spatial data applied to a digital twin city, which are used for solving the technical problem of how to automatically check and process the spatial data of the digital twin city.
Example 1:
the invention is applied to the field inspection method of the spatial data layer of the digital twin city, based on ArcGIS, the field of each layer of the spatial data is inspected according to the type, and the error field is output, the method includes the following steps:
s100, setting a configuration file, wherein the configuration file comprises an inspection form, and the inspection form is used for filling field information to be inspected;
s200, respectively setting data sources of the spatial data according to the classification, and acquiring various types of spatial data;
s300, taking the field recorded in the configuration file as a target field, taking the field to be checked of the spatial data as a source field, carrying out batch check processing on various types of spatial data through check items set by the configuration file based on ArcGIS, recording the field and identifying the layer if the target field is not matched with the source field, storing the layer into the created error identification file so as to conveniently select and correct the layer elements marked with check errors and assign attributes to the spatial data without errors.
In this embodiment, the check form is in an excel format, the column a of the check form is a layer name and is used to introduce a setting format of a layer field, the column B of the check form is a Shape field and is used to check whether a Z value exists, and the column C of the check form and the subsequent columns are other fields in the layer, and the format is field name-field type-length-precision-decimal point digit.
Step S100 sets a configuration file, a "reference file path" in the system selects a form xlsx in excel2007 format, only field information to be checked needs to be filled in the form, fields that do not need to be checked do not fill in, and the content format of the checked form is as shown in fig. 2.
excel format: layer name, Shape field, field … …. Other texts can be exchanged, the purpose of the first row is to introduce the setting format of the layer field, the program does not have the operation on the first row, and other texts can be exchanged, but: the arrangement of layers cannot be placed in the first row as shown in fig. 3.
Column a must be the layer name. Column B must be a setting to the shape field to check if there is a Z value. If there is a Z value in the shp file, then in column B, fill in a "Z", so the case is silent, and if there is no Z value, do not fill in.
Column C and the following columns are other fields in the layer. The format is as follows: field name-field type-length-precision-decimal point digit. If only the field name needs to be checked, then only the field name is written, as in Geocode, if the name and type format need to be checked: geocode-text, if field length needs to be checked, the format is: geocode-text-50, separated by "-". If one wants to check the accuracy of an integer, the format is Geocode-longinteger-0-3, the middle relates to length, since no length is set, so 0 instead, the accuracy cannot be set directly across the length, e.g. Geocode-longinteger-3 is wrong.
The field types correspond to:
short integer-short integer type
longInteger-long shaping
Float- - -Single precision floating point type (Float)
Double-precision floating-point type
Text-character type
Date-type Date
OID- -fid field
Geometry- -type of Geometry
Blob,
Raster,
GUID,
GlobalID,
XML,
Attached descriptions: (for reference only)
The length of the field name must not exceed 10 characters; redundant characters are cut off, Chinese occupies two characters, and special characters such as: "-".
Precision-the number of bits that can be stored in the number field. For example, accuracy of 56.78 is 4.
Scale-the number of bits to the right of the decimal point of the numerical value in the floating point or double precision type field. For example, 56.78 has a scale of 2. The scale is applicable only to floating point and double precision field types.
Length-the length of a text field specified in units of characters.
The precision of short integer is 4 bits at most, if it is more than 4 bits, it will automatically become Long integer. The short type can only store integer values between-999 and 9999.
The precision of the long integer is at least 5 bits and at most 9 bits, wherein > -5 and < 9. If it is greater than 9 bits, it will automatically change to double floating point type. The value range is as follows: 99999999 to 9999999.
If the precision of the long integer is less than 5, it will automatically change to short type.
The float and double types, single precision and double precision, are composed of two parts: precision and decimal point number. The length of the precision is equal to the length of the integer part + the length of the fractional part.
If the float and double decimal place number is 0 and the precision is less than or equal to 9, namely scale is 0, precision < ═ 9, then it will automatically change to short or long type, depending on the precision. For example, the precision is less than 5 to short, and the precision is greater than or equal to 5 to long.
float stores 6-bit integer parts at maximum with a precision of 7 at maximum. If the precision is greater than 7, then the double type is automatically changed.
double stores a maximum of 15 bits of precision.
In this embodiment, the configuration file data includes: the method comprises the following steps of checking and configuring urban building notations, assigning attributes, configuring templates and assigning attributes, and specifying the corresponding relation of classification codes between urban building data and urban building notations.
In step S200, data sources of the spatial data are set, including an urban road data source, an urban river data source, an urban house data source, and an urban green space data source. In this embodiment, the road data in the city space data is selected and selected, and the format may be the data format of SHP, MDB or GDB; and selecting house data in the city space data, wherein the format can be the data format of SHP, MDB or GDB, and selecting greenbelt data in the city space data, and the format can be the data format of SHP, MDB or GDB.
In this embodiment, when each layer in the spatial data is checked according to the field type by the check item in the configuration file, the field with an error is recorded, and the layer is identified and recorded in the error identification file, so that the error identification file is created before the check, the layer elements marked with the check error can be quickly selected and corrected by creating the error identification file, and attribute assignment can be performed on the verified urban building data.
Step S300, performing batch inspection on the spatial data, in the method for inspecting the fields of the urban spatial data in this embodiment, the various urban spatial data are inspected by recording inspection items of the configuration file, after finding that the target field is not matched with the source field, the fields are recorded, and the layer is identified and stored in the final error file. Relates to a method for checking and batching map layer fields of urban spatial data and a method for checking the format of the map layer fields of the urban spatial data.
A city space data layer Field verification batch processing method includes the steps of providing an interface IFeatureWorkspace through ArcGIS to instantiate a FeatureWorkspace method, using an IFields interface to instantiate a Field method, circularly traversing a Field to be matched with a Field in a configuration file, judging the Field type after configuration, and judging whether the Field type is correct or not.
The method for checking the urban spatial data field format is used through an IGeometridef interface, an IFeature interface, an IDataset interface and an IFieldEdit interface provided by ArcGIS. The method comprises the steps of obtaining the type and the length of a field by instantiating an IGeometriDef interface and using a get _ GridSize method in a GeometryDef class, reading spatial data by instantiating an IFeature interface and using a Store method of a Feature class, and judging according to the format of a configuration file. If the city space data contains the data set, the space data set needs to be read by using the IDataset interface, and the Feature instance is found to carry out the read check of the field. The data type and the data are modified through a method in an IFIELDEdit interface.
The method can improve the efficiency of data quality inspection and data storage for the inspection of the planning space data, and breaks the bottleneck of the existing manual operation.
Example 2:
the invention is applied to the field checking system of the spatial data layer of a digital twin city, and comprises a configuration file generating module, a data source module and a checking module, wherein the configuration file generating module is used for setting configuration files, the configuration files comprise checking forms, and the checking forms are used for filling field information to be checked; the data module is used for respectively setting data sources of the spatial data according to the classification and acquiring various types of spatial data; the checking module is used for taking the field recorded in the configuration file as a target field, taking the field to be checked of the spatial data as a source field, carrying out batch checking processing on various spatial data through checking items set by the configuration file based on ArcGIS, recording the field if the target field is not matched with the source field, identifying the layer, storing the layer into a created error identification file, so as to conveniently select and correct the layer elements marked with the checked errors and assign attributes to the spatial data without errors.
Wherein, the check table is in an excel format: layer name, Shape field, field … …. Other texts can be exchanged, the purpose of the first row is to introduce the setting format of the layer field, the program does not have the operation on the first row, and other texts can be exchanged, but: the arrangement of layers cannot be placed in the first row.
Column A must be the layer name. Column B must be a setting to the shape field to check if there is a Z value. If there is a Z value in the shp file, then in column B, fill in a "Z", so the case is silent, and if there is no Z value, do not fill in.
Column C and the following columns are other fields in the layer. The format is as follows: field name-field type-length-precision-decimal point digit. If only the field name needs to be checked, then only the field name is written, as in Geocode, if the name and type format need to be checked: geocode-text, if field length needs to be checked, the format is: geocode-text-50, separated by "-". If one wants to check the accuracy of an integer, the format is Geocode-longinteger-0-3, the middle relates to length, since no length is set, so 0 instead, the accuracy cannot be set directly across the length, e.g. Geocode-longinteger-3 is wrong.
The field types correspond to:
short integer-short integer type
longInteger-long shaping
Float- - -Single precision floating point type (Float)
Double-precision floating-point type
Text-character type
Date-type Date
OID- -fid field
Geometry- -type of Geometry
Blob,
Raster,
GUID,
GlobalID,
XML,
Attached descriptions: (for reference only)
The length of the field name must not exceed 10 characters; redundant characters are cut off, Chinese occupies two characters, and special characters such as: "-".
Precision-the number of bits that can be stored in the number field. For example, accuracy of 56.78 is 4.
Scale-the number of bits to the right of the decimal point of the numerical value in the floating point or double precision type field. For example, 56.78 has a scale of 2. The scale is applicable only to floating point and double precision field types.
Length-the length of a text field specified in units of characters.
The precision of short integer is 4 bits at most, if it is more than 4 bits, it will automatically become Long integer. The short type can only store integer values between-999 and 9999.
The precision of the long integer is at least 5 bits and at most 9 bits, wherein > -5 and < 9. If it is greater than 9 bits, it will automatically change to double floating point type. The value range is as follows: 99999999 to 9999999.
If the precision of the long integer is less than 5, it will automatically change to short type.
The float and double types, single precision and double precision, are composed of two parts: precision and decimal point number. The length of the precision is equal to the length of the integer part + the length of the fractional part.
If the float and double decimal place number is 0 and the precision is less than or equal to 9, namely scale is 0, precision < ═ 9, then it will automatically change to short or long type, depending on the precision. For example, the precision is less than 5 and changed to short, and the precision is greater than or equal to 5 and changed to long.
float stores 6-bit integer parts at maximum with a precision of 7 at maximum. If the precision is greater than 7, then the double type is automatically changed.
double stores a maximum of 15 bits of precision.
The configuration file data comprises a city building annotation checking configuration template, a city building annotation checking, an annotation city building checking configuration template, an annotation city building checking, an attribute assignment configuration template and an attribute assignment, and the corresponding relation of classification codes between the city building data and the city building annotation data is specified.
The data source module is used for setting data sources of spatial data, and the data sources comprise an urban road data source, an urban river data source, an urban house data source and an urban green land data source. In this embodiment, the data source module selects and selects road data in the urban spatial data, and the data format may be a data format of SHP, MDB, or GDB; and selecting house data in the city space data, wherein the format can be the data format of SHP, MDB or GDB, and selecting greenbelt data in the city space data, and the format can be the data format of SHP, MDB or GDB.
When each layer in the spatial data is checked according to the field type through the check item in the configuration file, the field with an error is recorded, the layer is identified and recorded in the error identification file, therefore, before the check, the detection module is used for creating the error identification file, the layer elements marked with the checked errors can be quickly selected and corrected through creating the error identification file, and the attribute assignment can be carried out on the verified urban building data.
The checking method of the urban spatial data field in the embodiment checks various urban spatial data by recording the checking items of the configuration file, records the field after finding that the target field is not matched with the source field, identifies the layer, and stores the layer in a final error file. The checking module relates to a city space data layer field checking batch processing method and a city space data field format checking method.
A city space data layer Field verification batch processing method includes the steps of providing an interface IFeatureWorkspace through ArcGIS to instantiate a FeatureWorkspace method, using an IFields interface to instantiate a Field method, circularly traversing a Field to be matched with a Field in a configuration file, judging the Field type after configuration, and judging whether the Field type is correct or not.
The method for checking the urban spatial data field format is used through an IGeometridef interface, an IFeature interface, an IDataset interface and an IFieldEdit interface provided by ArcGIS. The method comprises the steps of obtaining the type and the length of a field by instantiating an IGeometriDef interface and using a get _ GridSize method in a GeometryDef class, reading spatial data by instantiating an IFeature interface and using a Store method of a Feature class, and judging according to the format of a configuration file. If the city space data contains the data set, the space data set needs to be read by using the IDataset interface, and the Feature instance is found to carry out the read check of the field. The data type and the data are required to be modified through a method in an IFieldEdit interface.
The system of this embodiment may perform the method disclosed in embodiment 1, by which the spatial data is automatically checked and the error field is output.
While the invention has been shown and described in detail in the drawings and in the preferred embodiments, it is not intended to limit the invention to the embodiments disclosed, and it will be apparent to those skilled in the art that many more embodiments of the invention are possible that combine the features of the different embodiments described above and still fall within the scope of the invention.

Claims (10)

1. The method for checking the field of the spatial data layer applied to the digital twin city is characterized in that based on ArcGIS, the field of each layer of the spatial data is checked according to the type, and the field with an error is output, and the method comprises the following steps:
setting a configuration file, wherein the configuration file comprises an inspection form used for filling field information to be inspected;
respectively setting data sources of the spatial data according to the classification, and acquiring various types of spatial data;
the fields recorded in the configuration file are used as target fields, the fields to be checked of the spatial data are used as source fields, batch check processing is carried out on various types of spatial data through check items set by the configuration file based on ArcGIS, if the target fields are not matched with the source fields, the fields are recorded, layers are identified and stored in a created error identification file, so that layer elements which are marked with check errors can be selected and corrected, and attribute assignment is carried out on the spatial data which are verified to be correct.
2. The method as claimed in claim 1, wherein the check form is in excel format, column a of the check form is layer name for introducing the setting format of layer field, column B of the check form is Shape field for checking if there is Z value, column C of the check form and the following columns are other fields in the layer, and the format is field name-field type-length-precision-decimal point digit.
3. The method according to claim 1, wherein the data of the configuration file includes a city building annotation checking configuration template, a city building annotation checking, a annotated city building checking configuration template, an annotated city building checking, an attribute assignment configuration template, and an attribute assignment, and a correspondence of classification codes between the city building data and the city building annotation data is specified.
4. The method for checking the field of the spatial data layer applied to the digital twin city according to claim 1, wherein the spatial data sources comprise an urban road data source, an urban river data source, an urban house data source and an urban green land data source;
the formats of the urban road data source, the urban river data source, the urban house data source and the urban green land data source may be SHP, MDB or GDB data formats.
5. The method for inspecting the field of the layer of the spatial data applied to the digital twin city according to any one of claims 1 to 4, wherein the batch inspection processing is performed on various types of spatial data based on ArcGIS through the inspection items set by the configuration file, and the method comprises the following steps:
providing an interface IFeatureWorkspace through ArcGIS to instantiate a FeatureWorkspace method, using an IFields interface to instantiate a Field method, circularly traversing the Field and matching the Field in a configuration file, judging the Field type after configuration, and judging whether the Field type is correct;
based on an IGeometridef interface, an IFeature interface, an IDataset interface and an IFieldedit interface provided by ArcGIS, the type and the length of a field are obtained by instantiating the IGeometridef interface and using a get _ GridSize method in a GeometryDef class, space data are read by instantiating the IFeature interface and using a Store method of a Feature class, judgment is carried out according to the format of a configuration file, if the space data contain a data set, the space data set needs to be read by using the IDataset interface, a Feature instance is found for field reading and detection, and if the detected data need to be modified, the data type and the data are modified by using a method in the IFieldedit interface.
6. Spatial data layer field inspection system applied to digital twin cities, characterized in that spatial data is inspected by a spatial data layer field inspection method applied to digital twin cities as claimed in any one of claims 1 to 5, the system comprising:
the system comprises a configuration file generation module, a configuration file generation module and a configuration file processing module, wherein the configuration file generation module is used for setting a configuration file, the configuration file comprises an inspection form, and the inspection form is used for filling field information to be inspected;
the data source module is used for respectively setting data sources of the spatial data according to classification and acquiring various types of spatial data;
the checking module is used for taking the field recorded in the configuration file as a target field and taking the field to be checked of the spatial data as a source field, carrying out batch checking processing on various types of spatial data based on ArcGIS and checking items set through the configuration file, recording the field if the target field is not matched with the source field, identifying the layer, storing the layer into a created error identification file, so that the layer elements which mark the checking error are selected and corrected, and carrying out attribute assignment on the spatial data which are verified to be correct.
7. The system according to claim 6, wherein the check form is in excel format, column a of the check form is layer name for introducing the setting format of layer field, column B of the check form is Shape field for checking if there is Z value, column C of the check form and the following columns are other fields in the layer, and the format is field name-field type-length-precision-decimal point digit.
8. The system according to claim 6, wherein said configuration file data includes a city building annotation checking configuration template, a city building annotation checking, a annotated city building checking configuration template, an annotated city building checking, an attribute assignment configuration template, and an attribute assignment, and specifies a correspondence of classification codes between city building data and city building annotation data.
9. The system for checking the field of the spatial data layer applied to the digital twin city according to claim 6, wherein the spatial data sources comprise an urban road data source, an urban river data source, an urban house data source and an urban green land data source;
the formats of the urban road data source, the urban river data source, the urban house data source and the urban green land data source can be SHP, MDB or GDB data formats.
10. The system for inspecting the field of the layer of the spatial data applied to the digital twin city according to any one of claims 6 to 9, wherein the inspection module is configured to perform the batch inspection processing on various types of spatial data based on the ArcGIS by using the inspection items set by the configuration file through the following steps:
providing an interface IFeatureWorkspace through ArcGIS to instantiate a FeatureWorkspace method, using an IFields interface to instantiate a Field method, circularly traversing the Field and matching the Field in a configuration file, judging the Field type after configuration, and judging whether the Field type is correct;
based on an IGeometridef interface, an IFeature interface, an IDataset interface and an IFieldedit interface provided by ArcGIS, the type and the length of a field are obtained by instantiating the IGeometridef interface and using a get _ GridSize method in a GeometryDef class, space data are read by instantiating the IFeature interface and using a Store method of a Feature class, judgment is carried out according to the format of a configuration file, if the space data contain a data set, the space data set needs to be read by using the IDataset interface, a Feature instance is found for field reading and detection, and if the detected data need to be modified, the data type and the data are modified by using a method in the IFieldedit interface.
CN202210075844.7A 2022-01-23 2022-01-23 Spatial data layer field checking method and system applied to digital twin city Pending CN114443657A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210075844.7A CN114443657A (en) 2022-01-23 2022-01-23 Spatial data layer field checking method and system applied to digital twin city

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210075844.7A CN114443657A (en) 2022-01-23 2022-01-23 Spatial data layer field checking method and system applied to digital twin city

Publications (1)

Publication Number Publication Date
CN114443657A true CN114443657A (en) 2022-05-06

Family

ID=81369810

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210075844.7A Pending CN114443657A (en) 2022-01-23 2022-01-23 Spatial data layer field checking method and system applied to digital twin city

Country Status (1)

Country Link
CN (1) CN114443657A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117290458A (en) * 2023-11-27 2023-12-26 潍坊威龙电子商务科技有限公司 Spatial database engine system, method, computer device and storage medium

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117290458A (en) * 2023-11-27 2023-12-26 潍坊威龙电子商务科技有限公司 Spatial database engine system, method, computer device and storage medium
CN117290458B (en) * 2023-11-27 2024-03-19 潍坊威龙电子商务科技有限公司 Spatial database engine system, method, computer device and storage medium

Similar Documents

Publication Publication Date Title
US9690788B2 (en) File type recognition analysis method and system
US20070136660A1 (en) Creation of semantic objects for providing logical structure to markup language representations of documents
CN113609820A (en) Method, device and equipment for generating word file based on extensible markup language file
CN109961259B (en) Address standardization processing method and equipment
CN110738027A (en) Computer-implemented method, apparatus, and storage medium for generating spreadsheet formulas
CN114443657A (en) Spatial data layer field checking method and system applied to digital twin city
CN111221813A (en) Database index and database query processing method, device and equipment
CN117808740A (en) Method for generating three-dimensional detection element inspection sequence of part
CN112700886A (en) Medical data processing method and device and storage medium
CN109784236B (en) Method for identifying table contents in railway drawing
CN116360794A (en) Database language analysis method, device, computer equipment and storage medium
CN113254455B (en) Dynamic configuration method and device of database, computer equipment and storage medium
CN113642291B (en) Method, system, storage medium and terminal for constructing logical structure tree reported by listed companies
CN115455561A (en) Ship design modification suggestion management method and system and ship design method
CN113176877B (en) Entity class generation method, device and storage medium
CN110675729B (en) Multi-version local geographic information integrated drawing method and system
CN101256556A (en) Method for detecting Thai data
CN118069656B (en) Data structured storage method, equipment and medium for paper quality inspection form
CN116186008A (en) Method for checking connected high Cheng Xiangao pass value applied to smart city
CN117874306B (en) Engineering data source processing method and device, electronic equipment and storage medium
CN115828866A (en) Excel data importing and exporting method and device
CN116359979A (en) Quick checking method, device, equipment and medium for format of seismic data header
CN110543732A (en) free-form finite element model data reading method based on regional navigation code
CN116779080A (en) Data importing method, device, equipment and medium of medical detection result
KR100216068B1 (en) A method of converting dxf data format to informap database

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