Polygon boundary plan xml to pdf converter. About XML Converter. Data mapping example

Announcement

XML Document File Format

Designed as a format for storing textual data, XML is a document that is understood not only by humans, but also by machines. XML is a platform independent language that was created to store a variety of data. With its simplicity and ease of use, this language is not inferior in popularity to the HTML language. It is also quite common on the Internet. The fact that XML files can be easily edited with the simplest text editors only increases its popularity.

Technical details of XML files

An XML document is a sequence of characters in which each Unicode character can be found in every single document. This Unicode character code that makes up an XML document is split into tokens and textual content based on simple syntax rules. This format has an important advantage over HTML: XML format supports arbitrary tagging to clearly define the data that such tags cover.

More information on the XML format

32- and 64-bit versions

Viewing files of various geoformats.

GeoViewer supports the following formats:

  • ArcView (SHP);
  • MapInfo (MID / MIF);
  • MapInfo (TAB);
  • AutoCAD (DXF);
  • MicroStation (DGN version up to 8);
  • Keyhole Markup Language (KML);
  • GPS eXchange format (GPX);
  • Rosreestr Statements (XML).

32- and 64-bit versions


Converter of XML statements of Rosreestr to geoformats

Converter of XML-statements of Rosreestr into a printed representation

© GeoConverter. All rights reserved.

e-mail: This e-mail address is being protected from spambots. You need JavaScript enabled to view it.

Free legal advice:


Rosreestr converter from xml file

Converter of graphic XML files provided by Rosreestr to various geoformats

XML to printable converter

Attention: Free versions have no functional limitations and work 3 (three) days from the moment of installation.

Designed to familiarize yourself with the functionality of the program.

Example of installing the RosreestrXML program

To install the program on a computer, you must have administrator rights.

Free legal advice:


Free converter of statements to XML to mif / mid format

A free converter of KPT and KVZU in the form of XML has been developed, which allows converting them into mif / mid format.

You can get it for free, for everyone at the address: http://www.geomerpro.ru/download/XMLtoMIDMIF.rar

  • ereminmihail
  • March 1, 2012, 12:21 pm

17 comments

here's an XML file for you. 38 MB, practice on it - http://hdd.tomsk.ru/file/qzswrwmr

  • filippov70
  • March 1, 2012, 12:30
  • ereminmihail
  • March 1, 2012, 17:25

and there are no problems with the size of the downloaded / uploaded for a long time, so I don’t press the files, it’s a habit.

  • filippov70
  • March 1, 2012, 18:01
  • ereminmihail
  • March 1, 2012, 19:36
  • ereminmihail
  • March 2, 2012, 18:35

my craft and Inster cope in less than 30 seconds

Free legal advice:


  • filippov70
  • March 1, 2012, 12:43 pm

CoordSys NonEarth Units "m" Bounds (,) (,) where numbers are known to be the limits of the coordinate system.

In our chamber (possibly in others), the requirements for the limit to be Bounds (,) (0,0). It doesn't matter what the maximum and minimum coordinates are set, the main thing is that the length of the coordinate system in X and Y is in meters

Accordingly, areas are calculated incorrectly for the same coordinates.

With Bounds (,) (,) my area is obtained. 77

with Bounds (,) (0,0) the same area. 4

Free legal advice:


  • Passenger
  • March 1, 2012, 13:22

Please explain what the "requirements" in the chamber are, and how they are related to the conversion - it is assumed that we carry out the conversion for our own needs, and not for the needs of the chamber.

About squares: I specifically tried (what if!)) To import the same mif into Mapinfo:

in the first case Bounds (,) (,)

in the second Bounds (0, 0) (,)

I draw your attention, I was correcting the same Mif. The squares turned out to be the same as expected. Maybe the problem is in the software in which you are working with the resulting Mif?

Free legal advice:


  • ereminmihail
  • March 1, 2012, 17:20

In your case, dX and dy are and

You write that you changed the initial and final coordinates, but the delta has not changed, of course nothing will change in your calculations. The delta should be exactly 20mln by 20mln so that the minimum cell is square with an accuracy of 0.01x0.01m. (as required when drawing up a boundary plan)

in your case, the cell turns out to be rectangular with an accuracy of 0.0105x0.047 from there and distortion.

Converter of new XML-files of Rosreestr in 2016 formats

You have received a new XML file from the USRN in Rosreestr since 01.01.2017, or earlier, but you cannot import it into the programs. What to do?

There is a simple solution to the problem: convert the XML file from the new 2017 (or 2016) format to the old 2015 format (valid until 06/23/2016) using this web service. After that, the file obtained here can be imported into any cadastral programs, printed according to the previous print templates.

Free legal advice:


What is this web service for?

The service is designed to convert the following types of files issued by Rosreestr from 01.01.2017, as well as files of an earlier format issued from 23.06.2016:

  • Cadastral plan of the territory
  • Cadastral extract of the land plot
  • Cadastral passport of the land plot
  • Cadastral extract of the capital construction object
  • Cadastral passport of the capital construction object
  • Notice of lack of information
  • Extract on the main characteristics of the land plot from the USRN
  • Extract (full) on the characteristics of the land plot from the USRN
  • Extract on the main characteristics of the capital construction object from the USRN
  • Extract (full) on the characteristics of the capital construction object from the USRN

Instructions:

Using the Select file (Browse) button, select the source XML file to be converted, or a ZIP archive, click the Convert button. After that, the page will be refreshed, and a link for downloading the resulting file will appear on the screen. To save the file, right-click on the link and select Save to Link (As).

Warning: by uploading an XML file, you automatically agree with the rules of the CPT Archive service. Import from XML-files works in the program: Polygon Pro.

Attention: the transfer of the file to the server and the conversion process may take some time (even several minutes depending on the file size). After clicking the Convert button, do not close the browser window and do not follow the links.

The service works for free. The number of converted files is not limited.

Free legal advice:


The service works for free, but you can thank us:

  • Share the link on social networks
  • Write on the forums about this service
  • Tell your colleagues about the existence of this service
  • Write a review on our website

Converting Rosreestr statements from XML to MID / MIF format

According to the Order of Rosreestr dated June 15, 2010 No. P / 284. check

An approved electronic document containing information from the State Property Committee is an xml file.

Unfortunately, on the official website of the converter for converting the received statement into the GIS format, no, third-party developers offer an impressive set of utilities to solve the problem.

Free legal advice:


In order to save time, I propose a small overview of software products for converting statements into GIS formats. The list may not be complete. If you found software which, in your opinion, copes with the task better, please let us know.

General remarks

The task of converting xml to GIS format, in my opinion, has not been fully resolved. There are some inaccuracies in the conversion, and therefore there is a risk of partial data loss. It is also worth mentioning the "regional" features ( For example, a quote from the website of the Federal Service state registration, cadastre and cartography "IN THE KIROV REGION, attention! CBT in XML format, generated by the FBU "KP" in the Kirov region before 07/04/2011, do not contain information about the coordinates .), which should be taken into account when working with the received data.

Test data

To minimize the influence of these factors, we used one dataset for testing, thanks to nukevlad.

RosreestrXML - converter of graphic XML files provided by Rosreestr

The current version is RosreestrXML 1.5.3

RosreestrXML is perhaps the first software that a user will find when searching on his own.

Free legal advice:


The program is paid, the cost of the full version of the RosreestrXML program is: -

  • for individuals. (one license)
  • for legal entities (one license).

The free version has limitations. Objects with 5 points or more are not converted. If there are such objects in the log, an entry "Not converted (free version)" is created

  • convert files in batch
  • save the result in .shp .mif .csv formats
  • remove attribute fields when converting
  • the ability to view the coordinates within which the statement objects lie (only from version 1.4)

Batch processing of files

Attributes are not lost when converting

Three different formats when converting

Free legal advice:


When processing information from several statements, the information is not combined into one layer / table

A small part of the attributive information is lost (although most likely it is misread)

Inster GeoConverter

Current version 1.0.3

But unfortunately the attributive information is lost.

  • import of cadastral extracts in html-format
  • import of cadastral extracts, cadastral plans of territories in xml-format
  • export land plots and their parts in mif format
  • bulk file processing

Batch processing of files

Free legal advice:


Two formats for converting

XML Converter

Another paid program for converting statements is the program XML Converter, the cost of the program at the time of this writing is 750 rubles. On the program website you can download an evaluation version that has the following limitations: the program allows you to perform one conversion of one file in one minute.

Current version 1.5.2

5 output file formats for converting (mif, dxf, txt, csv, html)

Free legal advice:


When processing information from several statements, it is possible to combine into one layer / table

The limitations of the evaluation version are not significant

Batch processing of files (disabled in demo mode)

When converting, part of the attributive information is lost

XML Converter CBT, Author Mukhamedyarov I.R. Email:

The program does not require installation

When converting, part of the attributive information is lost

Free legal advice:


No batch processing of files

Some objects are lost during conversion

On-line converter: Information of the reference portal about the Earth http://www.50-14.ru

The first online converter in the review. Unfortunately, it did not work for me (file size limit).

Online converter: Branch of FGBU "FKP Rosreestr" in the Republic of Bashkortostan

Another free online converter is available at:

No need to install additional software

Free legal advice:


No batch processing of files

When converting, part of the attributive information is lost

Requires internet connection

To import a file, you have to do a lot of intermediate operations (load, unload, unzip, etc.)

Free legal advice:


Converting Rosreestr xml statements to MapInfo

To convert xml-statements of Rosreestr into MapInfo there is a free utility (xml-converter) for unloading into tables from statements or cadastral plans, which can be downloaded from the page "Utilities for MapInfo (Russian version)".

Connecting a data converter from Rosreestr XML schemas to MapInfo

To connect this utility, all files presented in the archive must be placed in the Tools folder, usually located on the C: Program FilesMapInfoProfessionalTools drive. Please note that for this operation and the utility to work, you need administrator-level rights. Then start MapInfo and the menu "Programs / Catalog of programs ...", press the button "Add". In the "Location" field, look for and select the "ImportMI" utility in the Tools folder and then click "Open". After that, in the "Title" line, set your name for this utility and press the "OK" button. Next, it is recommended to check the Startup box next to the name of this utility you specified and click the "OK" button. Now this utility called "XML Converter" will be located in the "Programs" menu.

Import of data from xml statement of Rosreestr

Having launched the converter through the menu "Programs / Data converter from XML schemas of Rosreestr" in the import settings window, first of all, select the folder into which the conversion results will be saved by clicking on the "Folder" button. Next, we connect the converted xml file of the cadastral plan of the territory (CPT) or the cadastral extract of the land plot (KVZU) by clicking on the "XML file" button. By clicking the "Styles" button, you can make additional settings for layer styles relative to the standard one. Point numbers in the absence of xml-element Num_Geopoint should be selected from the list Su_Nmb element. If necessary, you can swap the coordinates by checking the corresponding checkbox.

By clicking the "Advanced" button, you can select batch processing of files and at the same time customize the type of conversion with cleaning or updating tables in the folder for the converted data. Conversion is launched by clicking on the "Convert" button.

By checking the box "Generate table output data in plan-schema with extrema from XML file" regardless of the selected coordinate system by clicking the "Projection" button, the data in MapInfo tables will be in the plan-schema. To set the parameters of the local coordinate system, it is necessary to disable the above option by unchecking the checkbox. Click the "Projection" button to select the appropriate projection from the MAPINFOW.PRJ file. But as a rule, the parameters of the local coordinate system in this file are absent.

Free legal advice:


Setting the Local Coordinate System in MapInfo

The need to establish the parameters of the local coordinate system exists in cases where it is necessary to use information from different sources with different coordinate systems. For this it is necessary to register the parameters of the local coordinate system in the coordinate systems catalog MAPINFOW.PRJ. We open this file in a simple notepad and enter the parameters of the local system in the following similarity at the end of the document, omitting one line:

"MSK-12 Zone 1", 8, 1001, 7, 47.55, 0, 1, .504

"MSK-12 Zone 2", 8, 1001, 7, 50.55, 0, 1, .504

It should be noted that in this case, the first line points to a group of coordinate systems called Local Coordinate System. The second and third lines indicate the parameters "MSK-12 zone 1" and "MSK-12 zone 2". These parameters are calculated and approximate, and are taken from the article MSK-12 Republic of Mari El parameters for mapinfow.prj.

Data mapping example

As an example of importing an xml statement of Rosreestr, let us take the CBT, considered in the article "Cadastral plan of the territory". It also contains links to various ways of importing xml statements from Rosreestr.

Free legal advice:


As a result of comparing the data for the corresponding territory from the cadastral plan of the territory in the local coordinate system and data from the SAS. Planets with the connected layer of cadastral zoning of the territory, it turned out that the parameters are still approximate when used in Mapinfo.

Alexander Fadeev

Head of the Internet project GIS Territory.

Add comment Cancel reply

Conversion of open data of the cadastral map

The procedure for obtaining a certificate of cadastral engineer

List of cadastral documents

Preparation for data conversion AWP LESFOND

Geoinformation complex of the Bolshaya Kokshaga nature reserve

Having lemon water first thing in the morning was such a game changer for me.

Where and how can I pass to a cadastral engineer in Barnaul

I personally already have a kind of puppy delight from this opportunity. Until this time, concepts.

Free legal advice:


We are in social networks

About the site

Territory GIS is an internet blog for cadastral engineers and their assistants, students and the curious.

The technology of using various geoinformation systems in the field of land management, cadastral activities and other sectors of the economy.

Training of cadastral engineers and their assistants, examples of documentation in the field of cadastral works, legislation and regulations.

RosreestrXML 1.5.1 x86 + x64

Year / Date of Issue: 2012

Vista Compatibility: Full

Windows 7 compatibility: full

Interface language: Russian

System Requirements: Minimum

Description: The Rosreestr XML program (Rosreestr XML converter) is designed to quickly convert XML files provided by Rosreestr upon a request for the provision of information entered in the state real estate cadastre in the form of a cadastral extract (including CBT and electronic copies of technical plans) into formats ArcView (* .shp), MapInfo (* .mid / mif, tab), AutoCAD (* .dxf), MicroStation (* .dgn), Google (* .kml) and Microsoft Excel (* .csv).

No internet connection required. The convenience of the RosreestrXML program lies in the fact that the conversion operation is grouped and you can convert many XML files at once to the desired format.

It is also possible to transfer additional attributive information during conversion (for ArcView (* .shp), MapInfo (* .mid / mif, tab) and Microsoft Excel (* .csv)), which is available in the provided XML files - cadastral number, address, area and many others.

About XML Converter

Description

XML Converter is designed to convert XML files (XML documents) using one of the standard existing tools for converting XML files - the XQuery technology. In this case, the conversion can be carried out at once several files in a row. In addition to the conversion itself, the program has the function of combining converted files and renaming both the source files and the final conversion files based on the information contained within the files themselves. The renaming function allows you to get meaningful names for the processed files, for example, the number of the cadastral quarter for CBT files. The program has a flexible customization system and has many advantages.

Although the XML Converter program can convert any XML files, at present, it is primarily intended for cadastral engineers, and is aimed at converting XML files / documents of Rosreestr, cadastral registration bodies - cadastral extracts and cadastral plans of the territory (CPT). This is achieved due to the presence in the standard delivery set of a set of XQuery queries designed to convert Rosreestr XML files into other widespread text, exchange formats, including MIF / MID, DXF, CSV, TXT, HTML, etc.

Nevertheless, if there is a need to transform a set of the same type of XML file from another area, potential users of the program can contact the author to work out the issue of developing special requests for converting such files.

Screen

Dignity

using standard XQuery XML transformation technology

ease of use and high speed of work

the ability to batch convert multiple files at once

the ability to combine the conversion results into single files (for example, for Rosreestr XML files, to combine the conversion results of several statements into one bundle of MIF / MID files and, as a result, get a single table in MapInfo)

the ability to rename XML files based on the information contained in the files themselves (for example, for Rosreestr XML files with an arbitrary name, renaming occurs according to the cadastral number of the quarter / site and the date of issue of the statement)

complete with the program there are requests for converting to the most commonly used text formats MIF / MID, DXF, CSV, TXT, HTML

the form of the final tabular information of standard queries is as close as possible to the traditionally used tabular form of an ordinary paper document of a cadastral plan of territories (CPT)

the ability to extract additional information not included in the paper analogue of the document ( for example, extracting all coordinates of parcels within a block from latest version CBT)

the ability to customize the form and formats of the resulting files by editing conversion requests, since requests are provided in an open form

small size of the installer, easy to install

does not require installation of additional libraries - all necessary libraries are already included in the installer

the ability to connect external XQuery query handlers, which can provide a significant increase in the performance of processing large files

Application

Along with the program, requests are supplied for converting Rosreestr XML files such as statements and CBT to the following widespread formats: MIF / MID, DXF, CSV, TXT, HTML.

The MIF / MID format is an exchange format for GIS MapInfo, due to its simplicity, has become widespread and de facto is an exchange format for cadastral work and is widely used by cadastral engineers in their activities.

DXF format - is an exchange format for the automated drawing program AutoCAD and is widely used for the exchange of graphic information related to drawing, design, cartography.

DXF files can be easily and losslessly opened or imported into Microstation.

CSV format is a text format for presenting tabular data. Easily understood by any spreadsheet program such as Excel. Uses a semicolon as the field (column) separator.

TXT format - similar to CSV format, but uses a tab as a separator. Because of this, the information contained in these files is easily readable in a text editor. In addition, there is a special request for conversion to TXT format that extracts point numbers with their coordinates in NXY format.

HTML format is a format used to present pages on the Internet. It is convenient because of the visual presentation and the fact that an Internet browser capable of viewing it is available on every computer.

The information selected from the original XML document for the part representing the data for all formats is identical and as close as possible to the content presented in the table of the paper CBT, namely

  • КН - cadastral number of the plot in full
  • ЕЗ - cadastral number of a single land use, if the site is included in it
  • Address - location (address) of the site
  • Category - land category - number, as in CBT
  • Use - Permitted Use
  • Area - area in square meters rounded up to 1 sq. M.
  • Accuracy - Accuracy without rounding
  • Area_code - type of area (008 - Declared, Refined)
  • Cost - cadastral value in thousand rubles.
  • Rights - a type of property rights, if there are several, they are listed separated by commas
  • Encumbrances - encumbrances, if there are several, are listed separated by commas
  • Date - the date the site was created, i.e. its registration
  • Status - the status of the plot in the cadastre (01 - Previously accounted for, 05 - Certified, 06 - Registered, i.e. temporary plots have the status 05 - certified, but not registered)

Versions

  • Requests have been developed to transform USRN statements and cadastral plans of the territory (CPT), provided in a new, not yet approved format, the introduction of which is due to the transition to the new Law 218-FZ "On State Registration of Real Estate". The set of requests includes conversions to graphic formats MIF / MID, DXF and text CSV, TXT. This format is already used in the Krasnoyarsk Territory.
  • Due to the fact that there is already the third significant change in the format of the provided cadastral data for groups of requests processing various formats, the year has been added to the title when this format began to be applied.
  • Due to the fact that the Unified State Register of Real Estate (USRN), in spite of its name, is still not unified and contains information from the State Real Estate Cadastre (GKN) and information from the State Register of Rights (PIU) separately, the USRN extract of 2017 on land and real estate objects now contain two sections of information on rights. The first, as before, contains GKN information, the second new section contains hydraulic fracturing information. The information in these sections may vary. The program has added queries that, in a tabular form (CSV and TXT formats), extract the characteristics of plots and real estate objects, and the rights and encumbrances in them are extracted two times: separately by the State Property Committee and the State Registration Office.
  • Improved universal requests for converting to DXF format in terms of object recovery round shape(CIRCLE objects are created, while all the others are POLYLINE) and better transformation of XML files of boundary plans.
  • Improved universal queries of conversion to MIF / MID format in terms of better conversion of XML files of boundary plans. (Extraction of circular objects for this format was implemented earlier. In this case, such objects are converted to octagons).
  • Added new queries to extract in a tabular form the detailed characteristics of land plots and real estate objects. Separate conversion requests have been created for parcels and real estate objects, and each of them is in two editions (4 requests in total): conversion to CSV format (semicolon separator) and conversion to TXT format (tab separator). The tables contain headers and the information is combined into a single table (CSV / TXT file). The source files for transformation are XML-files of cadastral extracts, passports, CPT, created according to new versions of the corresponding XML-schemas. The generated tabular presentation is convenient for analyzing information on plots and real estate objects contained in cadastral extracts, passports, CBT.
  • Improved stability of the internal XQuery query processor. The internal processor can now handle larger XML files. (Previously, conversion of large XML files by an internal handler could lead to a crash and abnormal termination of the program)
  • A more reliable way of passing the original XML files into the request for processing using an internal handler is used. (Previously, file processing might not start if there was a hash # symbol in the file name or path to it, or the computer was named in Russian in the network path)
  • The selected transform and the query processor persist between program launches
  • Added two new requests (each of which is in 2 editions XY and YX) for converting XML files of cadastral extracts and KPT, as well as other XML files of Rosreestr, created according to new XML schemes (for example, map plan, cadastral passports OKS etc.) in DXF format with objects layout by layers (the name uses DXF LAYER BY LAYER) and highlighting objects with different colors (see colors in New for version 1.6.6) set for layers. The first request "pulls" only graphics from XML, the second also information that is written to the block attributes. The following layer names are used:
    • GKN_SLOCATIONS - for plots, their contours
    • GKN_PARTS - for parts of plots (encumbrances)
    • GKN_KVARTALY - for cadastral quarters
    • GKN_BOUNDARIES - for the borders of NP and MO
    • GKN_ZONES - for security and territorial zones
    • GKN_NEMOVEZHIMOST - for buildings, structures, ONS
  • The function of combining files obtained as a result of conversion into a single file has been improved. More complex files such as DXF files are now also merged using blocks and attributes. Those. the merge function now works for all target formats. It is also more correct to combine files if there are empty files without objects among them. (Previously, an empty file gave an extra line break in the combined file, which was critical for some formats and could lead to an error)
  • Added a request for converting USRR statements to CSV format. By transforming a set of USRR statements with this query and combining the result, you can get the data of these statements in a tabular form, convenient for analysis, if you open the resulting combined file in one of the programs such as Excel or Calc
  • When converting to graphic formats MIF / MID and DXF, added highlighting of various types of objects found in CBT and extracts with different colors. The following colors are used:
    • purple - for land plots and parts
    • crimson - for cadastral quarters
    • green - for security and territorial zones
    • red - for borders settlements and municipal boundaries
    • orange - for real estate
  • Added a separate query for converting real estate objects, i.e. extracting their contours and characteristics into MIF / MID format from CPT
  • Fixed handling of open contours (linear structures) in universal conversion queries to MIF / MID and DXF formats
  • Reworked requests for converting CBT into text formats for processing new versions of XML schemas
  • Reworked all requests for conversion to DXF and MIF / MID XML-files of cadastral extracts, cadastral passports for plots and real estate objects, cadastral plans of the territory, created according to the new XML schemas that came into force on December 31, 2014.
  • Redesigned universal requests for converting to DXF and MIF / MID formats XML-files of cadastral extracts, cadastral passports for plots and real estate objects, cadastral plans of the territory, created according to new XML-schemes that came into force on December 31, 2014.

IMPORTANT! Due to the fact that the changes in the new XML schemas are quite significant, it is impossible to make it so that one request could be processed as files created by new version schemes, and according to the old one. Requests that process files based on new versions of XML schemas have the NEW prefix in their names.

  • Added queries for extracting OMC items from CPT in MIF / MID format and TXT format with tab delimiter.
  • Added the ability to receive a printable representation of an XML file in HTML format using the XSLT transformation specified in the XML file, i.e. obtaining the usual printed form of statements, CBT, passports by their electronic counterparts in XML format. Transformations are performed by external XSLT transformation engines. Supports two external handlers MSXLS 4.0 (included in the installer) and Saxon-HE 9.5 (installed separately). An Internet connection is required to perform XSLT transformations.
  • Added the ability to use external request handlers, which makes it possible to transform large XML files, reaching hundreds of megabytes. You can download additional external request handlers in the same way as the program itself in the Download section.
  • Drag-and-Drop support and command added for source file list operating system Open with, that is, you can add source files for conversion from Explorer or the file manager simply by dragging and dropping them into the list or by calling the Open with command.
  • More correct processing of parts of parcels and common land uses for XML-files of extracts and CBTs, created according to new versions of XML-schemas.
  • For generic queries, support has been added for processing XML files of landmarks created according to the new 4th version of the XML schema.
  • Added a request to retrieve the formalized address of the plots from KPT and extracts, i.e. decomposed into components, as well as extracting the KLADR and OKATO codes.
  • Conversion requests have been improved for the purpose of more correct processing of Rosreestr XML files such as extracts and CBTs, created according to new versions of XML schemes - the 5th for extracts and the 8th for the CBT. During the revision, the compatibility in the old versions is preserved. The following features of the new versions have been taken into account:
    • The first point of the contour is now duplicated at the end of the spatial component description for closed contours
    • Changed the name or location of some elements in the XML schema, such as area and cadastral value
  • Due to the fact that the new 8th version of the CBT can now contain the coordinates and characteristics of quarters, zones with special conditions of use and territorial zones, the boundaries of settlements and municipalities created special requests for extracting data of objects and their characteristics in the MIF / MID format. Universal queries focused on extracting the spatial component from any XML files of Rosreestr process these objects quite correctly.
    • The requests for converting statements and CBT into the MIF / MID format have been revised and refined, two new fields Owners and Tenants have been added (there is no such information in the CBT), the Tenants field also includes persons and organizations in whose favor the encumbrances have been established.
    • The universal requests for conversion to MIF / MID format have been significantly improved. Now, after transformation, these queries receive the same MapInfo table structure as regular queries, while all the information that was extracted by regular queries is also extracted not only from extracts and CBTs, but from XML files of landmarks, technical plans, etc. (provided, of course, that it is there)
    • The ordering of queries in the list of queries available for conversion was carried out and their clear division into "ordinary" ones, that is, those that convert only extracts and CBTs and "universal" ones, that is, those that extract information not only from extracts and CBTs, but from others Rosreestr XML files - landmarks, technical plans, etc. Now conversion requests to MIF / MID format are available in two versions, conversion requests to DXF format without support for blocks and attributes are universal, conversion requests to DXF format with support for blocks and attributes are common, all conversion requests to tabular formats (CSV, HTML, TXT) are normal.
    • In all requests, added "protection" against the appearance of line breaks in lines (for example, such as Allowed use, Address, etc.) (they should not be there, but for some reason sometimes they are there), the appearance of which led either to mis-synchronization (inconsistency) of data and graphics for files obtained after conversion in MIF / MID format or to an error opening DXF files.
    • In all queries, the function of recovering the full address has been optimized and improved, which is used to recover the full unformalized address from the components if the address is not specified in this form (the Note field is not specified). A reference book of regions has been added and therefore the restored address will now always start with the name of the region.

Differences between "regular" queries and "universal" ones:

    • Regular queries convert only extracts and CBT, universal queries can convert any XML files of Rosreestr, which have graphics (object coordinates).
    • For normal queries, XML processing binding goes to parcels (Parcel node), in generic XML processing binding goes to spatial data (Entity_Spatial node), i.e. if there is no spatial component in the site (declarative site), the universal request will not “notice” and process such a site.
    • Because the universal query for converting to MIF / MID format does not process declarative sections, then records for objects without graphics are not created in MapInfo tables (the None clause in the MIF file). This can be used, for example, for such programs that, when importing files in the MIF / MID exchange format, do not understand or do not correctly process objects without graphics (for example, Digitals).
    • Due to the ability to extract data from any XML files of Rosreestr, universal queries can be used not only to transform information obtained from the inventory, but also to extract and control information entered into XML files intended for transmission to the inventory, for example, in the form of electronic versions of landmarks. , technical plans, maps (plan).
  • The mechanism for storing program settings and used queries has been changed, made by analogy with the programs XML Constructor and XML Reports. Now settings are stored in XML file instead of INI. Requests are stored in a separate resource folder specified during the installation of the program.
  • The registration system of the program has been changed, made by analogy with the programs XML Constructor and XML Reports.
  • The mechanism of the demo mode has been changed - now the program works without restrictions for 30 days, after which it stops working if there is no registration.
  • The list of requests has been expanded with two new general-purpose conversion requests to MIF and DXF. Unlike other queries bound to the structure of XML files for extracts and CBTs, these queries can retrieve graphics from any Rossreetr XML files including extracts, CBT, boundary plans, technical plans, map (plan), etc. the attributive information of various objects retrieved by these queries (existing and generated sites, contours and parts of a site, building, zone, etc.) is significantly different, then only the designation of the object is retrieved in this case. Using these queries allows you to:
    • control the filling of catalogs for the generated boundary and technical plans, maps (plan)
    • restore graphics from XML files in case of loss of original materials
  • The XQuery query for converting XML files to the MIF / MID format has been updated due to changes in XML schemas regarding multi-contour sections - multi-contour sections are now transmitted by separate objects, for each contour its own designation is written, for example: 123 (1) (the previous version of the query did not transmit multi-circuit sections for extracts and CBTs created according to new schemes).
  • Updated XQuery query for converting XML files to DXF format (without attributes, blocks) - the contours of multi-contour sections are now signed (the previous version of the query transmitted the contours of multi-contour sections, but did not put signatures).
  • Updated XQuery query for converting XML files to MIF / MID format - added one more column for creating signatures in MapInfo, containing only the designation of the parcel (or part) number without the cadastral quarter number in the same form in which they are indicated in the CPT and should displayed in the drawing of the boundary plan.
  • Updated XQuery query for converting XML files to DXF format (without attributes, blocks) - text captions are placed in the center of the main (first) contour of objects with symbol the numbers of the site (or part) in the same form in which they are indicated in the KPT and should be displayed on the drawing of the boundary plan.
  • Updated all DXF queries in that after converting and opening the converted file in AutoCAD or MicroStation, the current view displayed the converted parcels.
  • All XQuery queries that retrieve data have been updated in terms of handling the case when there can be several records with permitted use - each permitted use is now displayed separated by commas (similar to handling rights and encumbrances).
  • The XQuery-query for selecting points of objects in the NXY format has been optimized and its extended version has been added, which selects, in addition to the number, coordinates, precision, the method of fixing (for the code according to the reference book, see XML-schema).
  • The procedure for switching from the demo version to the full version of the program has been changed - now all you need to do is enter your personal serial number.
  • Added the function of renaming both target and source documents based on the information contained in the converted XML files (more ...)
  • Updated XQuery-query for converting XML files into MIF / MID format in terms of processing common land uses and parts of parcels (now the incoming parcels of single land uses are converted to the same form as when converting QPT, i.e. as separate contours, and not combined into a multi-contour parcel as it was before; parts of parcels are also created as separate contours, with their own information - have not been created before).
  • The algorithm for determining the limits for the MIF / MID, DXF formats has been changed (previously, the presence of areas with erroneous coordinates could lead to the setting of such limits that the areas did not fall on the working field and disappeared when opening converted files in GIS).

XML to Excel and vice versa, let's take a closer look at the types of these files. It should be noted right away that Excel documents have many formats, while XML is the file format. Therefore, do not confuse these two concepts.

Microsoft Excel is a powerful calculation program with many useful functions.

Microsoft Excel is a special utility for creating and editing tables. With them, you can already do whatever you want: create databases, diagrams, formulas and other types of data. This is a very powerful tool, so we will not discuss all of its capabilities. Today our goal is somewhat different, and we will not deviate from the topic of today's discussion.

XML files, for easier understanding, are designed to store and exchange various data between utilities. This markup language is especially often used when transmitting information over the Internet. And when you need to transfer tabular data from Excel to a site, for example, you will need to transform your document so that it displays correctly. Therefore, let's not delay the moment of truth and immediately proceed to the operation.

How to convert Excel to XML

Dear friends, converting files is actually quite simple. However, some users may have problems when transferring data, so today we will consider several ways to implement our plan. Therefore, we gain patience and proceed to action:

  1. The easiest way, which may not work in some cases, is to save the file in the desired format in the Microsoft Excel program itself. To do this, open required document in this app. Then click on the "File" button (taken as an example of Office 2013, in other versions the saving process may be slightly different) in the upper left corner of the Excel window, then the "Save As" item, then select the location to save the document, give it a name and in the tab of the file type, specify "XML data". After that, check if everything worked out right for you. If not, then try the following methods.
  2. So, if an error occurs in the previous case, then, perhaps, your copy of the program does not provide support and the corresponding add-ons. To install them, go to the Microsoft website http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=3108, download and install this file to your computer or laptop. Next, start the Microsoft Excel program and click on the large colored button in the upper left corner of the application window (here we are already looking at an example for the 2007 version). In the block that appears, click on the parameters to the left of the exit from the utility. Now go to the add-ons item and click on the "Go" button opposite the "Control" item. A dialog box will pop up where you need to click on the overview and find the document that you downloaded from the Microsoft website earlier. Now we click OK and go to the main window of the program, where you now have the XML Tools tab - with it you can now easily create an XML file from an existing table. You need to save it in the same way as in the previous paragraph.
  3. If you do not want to download both yourself and your computer with such information, you can resort to using special converter utilities or online versions of these programs. For example, you can download the Format Factory app, which will allow you to take all the necessary steps. But it is worth remembering that files saved and converted in this way do not always work in the future. That is, during the operation, sectors or areas in the memory of the document may be damaged, which will negatively affect it - it simply may not open in an XML editor, for example. Therefore, it is recommended to use either professional programs or Microsoft Excel itself.

How to translate XML to Excel

Before you can translate XML to Excel, you need to open it first. Consider this whole short process below. So let's get started:

  1. Launch the program using a shortcut on the desktop or through the Explorer menu.
  2. Click on "Open other books" at the bottom home page if you're using Office In other versions, the process may be slightly different.
  3. Next, click on "Computer" or another place where your XML file is located, then click "Browse" and change the data type to "XML Files" in the window that appears.
  4. Now we are looking for the required file and open it in our program using the button of the same name.
  5. Next, we will discuss how to transform our document. Go to the developer tab, then click on the import button.
  6. In the window that opens, you will need to find and select our document again, on which you want to perform an action, then click on the "Import" button.
  7. Then you customize everything for yourself: the import area, the save location and other parameters. After that, you will receive a table, which you can later save in the format you need. As you can see, there is nothing complicated.

Let's sum up

Dear readers, today we have learned not only how to convert XML files to Excel and vice versa, but also how to create and open them when versions are incompatible. We hope that everything worked out for you and there are no more questions left. Do not forget to share your opinion and experience in the comments: perhaps you know an easy way to convert. Tell other users if you managed to translate one type of document. If it worked, then share how you used it.


conclusions

The program is free
+ The program does not require installation

When converting, part of the attributive information is lost
-No batch processing of files
-Part of objects are lost during conversion

On-line converter: Information of the reference portal about the Earth http://www.50-14.ru

The first online converter in the review. Unfortunately, it did not work for me (file size limit).

On-line converter: Branch of FGBU "FKP Rosreestr" in the Republic of Bashkortostan

Another free online converter is available at:
http://zkprb.ru/

conclusions

Is free
+ No need to install additional software

No batch processing of files
-When converting, part of the attributive information is lost

-Requires internet connection
-To import a file, you have to do a lot of intermediate operations (load, unload, unzip, etc.)

Online converter - Converting electronic XML documents into the MapInfo exchange format http://xml-mif.ru/

A free online converter available at http://xml-mif.ru/ could not be tested due to the limitation on the size of the processed file (3mb).

Online converter of the "Federal Service for State Registration, Cadastre and Cartography" FOR KIROV REGION

The converter is free and available at http://zkp.kirov.ru.

Online converter of graphic XML-files provided by Rosreestr to MapInfo format (MIF / MID)

The converter is free and available at http://xmlconverter.ru/

Comparison table of software

File extension .xml
File category
Example file (252.17 KiB)
Associated programs Microsoft Visual Studio 2013
JAPISoft EditiX
Wattle XMLwriter
MacroMates TextMate
Program name \ Characteristics Number of objects after conversion Number of attribute fields after conversion Version at the time of writing the review Possible export formats Terms of distribution Batch processing of files Combining multiple xml files into one
RosreestrXML 2419/3001 68
Inster geoconverter 2757 3
XML converter 2380 16
XML CBT Converter 2380 4

Program XML Converter is designed to transform XML-files (XML-documents) using one of the standard existing tools for transforming XML-files - the XQuery query technology. In this case, the conversion can be carried out at once several files in a row. In addition to the conversion itself, the program has the function of combining converted files and renaming both the source files and the final conversion files based on the information contained within the files themselves. The renaming function allows you to get meaningful names for the processed files, for example, the number of the cadastral quarter for CBT files. The program has a flexible customization system and has many advantages.

Although the program XML Converter can convert any XML files, currently, it is primarily intended cadastral engineers , and is aimed at converting XML files / documents of Rosreestr, cadastral registration bodies - cadastral extracts and cadastral plans of the territory (CPT). This is achieved due to the presence in the standard delivery set of a set of XQuery queries designed to convert Rosreestr XML files into other widespread text, exchange formats, including MIF / MID, DXF, CSV, TXT, HTML, etc.

Nevertheless, if there is a need to transform a set of the same type of XML file from another area, potential users of the program can contact the author to work out the issue of developing special requests for converting such files.

    using standard XQuery XML transformation technology

    ease of use and high speed of work

    the ability to batch convert multiple files at once

    the ability to combine the conversion results into single files (for example, for Rosreestr XML files, to combine the conversion results of several statements into one bundle of MIF / MID files and, as a result, get a single table in MapInfo)

    the ability to rename XML files based on the information contained in the files themselves (for example, for Rosreestr XML files with an arbitrary name, renaming occurs according to the cadastral number of the quarter / site and the date of issue of the statement)

    complete with the program there are requests for converting to the most commonly used text formats MIF / MID, DXF, CSV, TXT, HTML

    the form of the final tabular information of standard queries is as close as possible to the traditionally used tabular form of an ordinary paper document of a cadastral plan of territories (CPT)

    the ability to extract additional information not included in the paper analogue of the document ( for example, extracting all coordinates of parcels within a block from the latest version of KPT)

    the ability to customize the form and formats of the resulting files by editing conversion requests, since requests are provided in an open form

    small size of the installer, easy to install

    does not require installation of additional libraries - all necessary libraries are already included in the installer

    the ability to connect external XQuery query handlers, which can provide a significant increase in the performance of processing large files

Along with the program, requests are supplied for converting Rosreestr XML files such as statements and CBT to the following widespread formats: MIF / MID, DXF, CSV, TXT, HTML.

MIF / MID format- is an exchange format of GIS MapInfo due to its simplicity, has become widespread and de facto is an exchange format for cadastral work and is widely used by cadastral engineers in their activities.

DXF format- is an exchange format for the automated drawing program AutoCAD and is widely used for the exchange of graphic information related to drawing, design, cartography.


Files in DXF format can be easily and losslessly opened or imported into Microstation.


CSV format- text format for presenting tabular data. Easily understood by any spreadsheet program such as Excel. Uses a semicolon as the field (column) separator.


TXT format- is similar to CSV format, but uses a tab character as a separator. Because of this, the information contained in these files is easily readable in a text editor. In addition, there is a special request for conversion to TXT format that extracts point numbers with their coordinates in NXY format.

HTML format- the format used to present pages on the Internet. It is convenient because of the visual presentation and the fact that an Internet browser capable of viewing it is available on every computer.

The information selected from the original XML document for the part representing the data for all formats is identical and as close as possible to the content presented in the table of the paper CBT, namely

  • КН - cadastral number of the plot in full
  • ЕЗ - cadastral number of a single land use, if the site is included in it
  • Address - location (address) of the site
  • Category - land category - number, as in CBT
  • Use - Permitted Use
  • Area - area in square meters rounded up to 1 sq. M.
  • Accuracy - Accuracy without rounding
  • Area_code - type of area (008 - Declared, 009 - Revised)
  • Cost - cadastral value in thousand rubles.
  • Rights - a type of property rights, if there are several, they are listed separated by commas
  • Encumbrances - encumbrances, if there are several, are listed separated by commas
  • Date - the date the site was created, i.e. its registration
  • Status - the status of the site in the cadastre (01 - Previously accounted for, 05 - Certified, 06 - Registered, i.e. temporary plots have the status 05 - certified, but not registered)

New in version 1.8.0

  • Added the ability to correct the source XML files of statements and CBT for some cases when these files are incorrect (received in this form from Rosreestr). Such cases include using incorrect tags for coordinates (<_x >instead of and<_y >instead of ), use of undeclared prefixes (e.g. adrOut :). For the corrected files, copies of the original files are created with the –copy suffix.
  • Added the ability to check and remove duplicates in a merged file. As a rule, when combining CBT into adjacent quarters, CBT data have many common zones and boundaries, which are duplicated in the combined file. The new functionality allows you to remove duplicate zones and borders for this case, leaving only one copy of each zone and border.
  • In graphical data extraction requests, a single layer of zones was previously divided into two separate layers: territorial zones and zones with special conditions for the use of the territory (ZOUIT). Accordingly, for the MIF / MID format, two separate requests were made: Territorial Zones and ZOUIT Zones, which after conversion give two separate layers with the suffixes _terzone and _zouit. For the DXF format, the queries have been corrected so that instead of one layer GKN_ZONE, two separate layers began to be created in the generated DXF files: GKN_TERZONE and GKN_ZOUIT.
  • Stricter control of the program version has been introduced. The "About" dialog now always displays the current version number, taking into account changes in resources.

New in version 1.7.5

  • Added a query that allows you to extract points of parcels with their designation and accuracy in the form of point objects in MIF / MID format from extracts and CBTs of the 2017 format.
  • Some queries for the 2017 format have been slightly improved.

New in version 1.7.4

  • Requests have been developed to transform USRN statements and cadastral plans of the territory (CPT), provided in a new, not yet approved format, the introduction of which is due to the transition to the new Law 218-FZ "On State Registration of Real Estate". The set of requests includes conversions to graphic formats MIF / MID, DXF and text CSV, TXT. This format is already used in the Krasnoyarsk Territory.
  • Due to the fact that there is already the third significant change in the format of the provided cadastral data for groups of requests processing various formats, the year has been added to the title when this format began to be applied.

New in version 1.7.3

  • Due to the fact that the Unified State Register of Real Estate (USRN), despite the name, is still not unified and contains information from the State Real Estate Cadastre (GKN) and information from the State Register of Rights (PIU) separately, extract of USRN 2017 on land plots and real estate objects began to contain two sections of information on rights. The first, as before, contains GKN information, the second new section contains hydraulic fracturing information. The information in these sections may vary. The program has added queries that, in a tabular form (CSV and TXT formats), extract the characteristics of plots and real estate objects, and the rights and encumbrances in them are extracted two times: separately by the State Property Committee and the State Registration Office.

New in version 1.7.2

  • Improved universal queries for converting to DXF format in terms of recovering circular objects (CIRCLE objects are created, while all others are POLYLINE) and better conversion of XML files of boundary plans.
  • Improved universal queries of conversion to MIF / MID format in terms of better conversion of XML files of boundary plans. (Extraction of circular objects for this format was implemented earlier. In this case, such objects are converted to octagons).

New in version 1.7.1

  • Added new queries to extract in a tabular form the detailed characteristics of land plots and real estate objects. Separate conversion requests have been created for parcels and real estate objects, and each of them is in two editions (4 requests in total): conversion to CSV format (semicolon separator) and conversion to TXT format (tab separator). The tables contain headers and the information is combined into a single table (CSV / TXT file). The source files for transformation are XML-files of cadastral extracts, passports, CPT, created according to new versions of the corresponding XML-schemas. The generated tabular presentation is convenient for analyzing information on plots and real estate objects contained in cadastral extracts, passports, CBT.

New in version 1.7.0

  • Improved stability of the internal XQuery query processor. The internal processor can now handle larger XML files. (Previously, conversion of large XML files by an internal handler could lead to a crash and abnormal termination of the program)
  • A more reliable way of passing the original XML files into the request for processing using an internal handler is used. (Previously, file processing might not start if there was a hash # symbol in the file name or path to it, or the computer was named in Russian in the network path)
  • The selected transform and the query processor persist between program launches
  • Added two new requests (each of which is in 2 editions XY and YX) for converting XML files of cadastral extracts and KPT, as well as other XML files of Rosreestr, created according to new XML schemes (for example, map plan, cadastral passports OKS etc.) in DXF format with objects layout by layers (the name uses DXF LAYER BY LAYER) and highlighting objects with different colors (see colors in New for version 1.6.6) set for layers. The first request "pulls" only graphics from XML, the second also information that is written to the block attributes. The following layer names are used:
    • GKN_SLOCATIONS - for plots, their contours
    • GKN_PARTS - for parts of plots (encumbrances)
    • GKN_KVARTALY - for cadastral quarters
    • GKN_BOUNDARIES - for the borders of NP and MO
    • GKN_ZONES - for security and territorial zones
    • GKN_NEMOVEZHIMOST - for buildings, structures, ONS
  • The function of combining files obtained as a result of conversion into a single file has been improved. More complex files such as DXF files are now also merged using blocks and attributes. Those. the merge function now works for all target formats. It is also more correct to combine files if there are empty files without objects among them. (Previously, an empty file gave an extra line break in the combined file, which was critical for some formats and could lead to an error)
  • Added a request for converting USRR statements to CSV format. By transforming a set of USRR statements with this query and combining the result, you can get the data of these statements in a tabular form, convenient for analysis, if you open the resulting combined file in one of the programs such as Excel or Calc

New in version 1.6.6

  • When converting to graphic formats MIF / MID and DXF, added highlighting of various types of objects found in CBT and extracts with different colors. The following colors are used:
    • purple - for land plots and parts
    • crimson - for cadastral quarters
    • green - for security and territorial zones
    • red - for the boundaries of settlements and municipal boundaries
    • orange - for real estate

New in version 1.6.5

  • Added a separate query for converting real estate objects, i.e. extracting their contours and characteristics into MIF / MID format from CPT
  • Fixed handling of open contours (linear structures) in universal conversion queries to MIF / MID and DXF formats
  • Reworked requests for converting CBT into text formats for processing new versions of XML schemas

New in version 1.6.4

  • All requests for conversion into DXF and MIF / MID graphic formats of XML files of cadastral extracts, cadastral passports for plots and real estate objects, cadastral plans of the territory, created according to new XML schemes that came into force on December 31, 2014, have been reworked.

New in version 1.6.3

  • Redesigned universal requests for converting to DXF and MIF / MID formats XML-files of cadastral extracts, cadastral passports for plots and real estate objects, cadastral plans of the territory, created according to new XML-schemes that came into force on December 31, 2014.

IMPORTANT! Due to the fact that the changes in the new XML schemas are quite significant, it is impossible to make it possible to process both files created using the new version of the schema and the old one with one request. Requests that process files based on new versions of XML schemas have the NEW prefix in their names.

New in version 1.6.2

  • Added queries for extracting OMC items from CPT in MIF / MID format and TXT format with tab delimiter.

New in version 1.6.1

  • Added the ability to receive a printable representation of an XML file in HTML format using the XSLT transformation specified in the XML file, i.e. obtaining the usual printed form of statements, CBT, passports by their electronic counterparts in XML format. Transformations are performed by external XSLT transformation engines. Supports two external handlers MSXLS 4.0 (included in the installer) and Saxon-HE 9.5 (installed separately). An Internet connection is required to perform XSLT transformations.

New in version 1.6.0

  • Added the ability to use external request handlers, which makes it possible to transform large XML files, reaching hundreds of megabytes. You can download additional external request handlers in the same way as the program itself in the Download section.
  • Drag-and-Drop support has been added for the list of source files and the operating system commands Open with, that is, you can add source files for conversion from Explorer or the file manager simply by dragging and dropping them into the list or by calling the Open With command.

New in version 1.5.3

  • More correct processing of parts of parcels and common land uses for XML-files of extracts and CBTs, created according to new versions of XML-schemas.
  • For generic queries, support has been added for processing XML files of landmarks created according to the new 4th version of the XML schema.
  • Added a request to retrieve the formalized address of the plots from KPT and extracts, i.e. decomposed into components, as well as extracting the KLADR and OKATO codes.

New in version 1.5.2

  • Conversion requests have been improved for the purpose of more correct processing of Rosreestr XML files such as extracts and CBTs, created according to new versions of XML schemes - the 5th for extracts and the 8th for the CBT. During the revision, the compatibility in the old versions is preserved. The following features of the new versions have been taken into account:
    • The first point of the contour is now duplicated at the end of the spatial component description for closed contours
    • Changed the name or location of some elements in the XML schema, such as area and cadastral value
  • Due to the fact that the new 8th version of CPT can now contain the coordinates and characteristics of quarters, zones with special conditions of use and territorial zones, boundaries of settlements and municipalities, special requests for extracting object data and their characteristics into the MIF / MID format have been created. Universal queries focused on extracting the spatial component from any XML files of Rosreestr process these objects quite correctly.

New in version 1.5.1

    • The requests for converting statements and CBT into the MIF / MID format have been revised and refined, two new fields Owners and Tenants have been added (there is no such information in the CBT), the Tenants field also includes persons and organizations in whose favor the encumbrances have been established.
    • The universal requests for conversion to MIF / MID format have been significantly improved. Now, after transformation, these queries receive the same MapInfo table structure as regular queries, while all the information that was extracted by regular queries is also extracted not only from extracts and CBTs, but from XML files of landmarks, technical plans, etc. (provided, of course, that it is there)
    • The ordering of queries in the list of queries available for conversion was carried out and their clear division into "ordinary" ones, that is, those that convert only extracts and CBTs and "universal" ones, that is, those that extract information not only from extracts and CBTs, but from others Rosreestr XML files - landmarks, technical plans, etc. Now conversion requests to MIF / MID format are available in two versions, conversion requests to DXF format without support for blocks and attributes are universal, conversion requests to DXF format with support for blocks and attributes are common, all conversion requests to tabular formats (CSV, HTML, TXT) are normal.
    • In all requests, added "protection" against the appearance of line breaks in lines (for example, such as Allowed use, Address, etc.) (they should not be there, but for some reason sometimes they are there), the appearance of which led either to mis-synchronization (inconsistency) of data and graphics for files obtained after conversion in MIF / MID format or to an error opening DXF files.
    • In all queries, the function of recovering the full address has been optimized and improved, which is used to recover the full unformalized address from the components if the address is not specified in this form (the Note field is not specified). A reference book of regions has been added and therefore the restored address will now always start with the name of the region.

Differences between "regular" queries and "universal" ones:

    • Regular queries convert only extracts and CBT, universal queries can convert any XML files of Rosreestr, which have graphics (object coordinates).
    • For normal queries, XML processing binding goes to parcels (Parcel node), in generic XML processing binding goes to spatial data (Entity_Spatial node), i.e. if there is no spatial component in the site (declarative site), the universal request will not “notice” and process such a site.
    • Because the universal query for converting to MIF / MID format does not process declarative sections, then records for objects without graphics are not created in MapInfo tables (the None clause in the MIF file). This can be used, for example, for such programs that, when importing files in the MIF / MID exchange format, do not understand or do not correctly process objects without graphics (for example, Digitals).
    • Due to the ability to extract data from any XML files of Rosreestr, universal queries can be used not only to transform information obtained from the inventory, but also to extract and control information entered into XML files intended for transmission to the inventory, for example, in the form of electronic versions of landmarks. , technical plans, maps (plan).

New in version 1.5.0

  • The mechanism for storing program settings and used queries has been changed, made by analogy with the programs XML Constructor and XML Reports. Now settings are stored in XML file instead of INI. Requests are stored in a separate resource folder specified during the installation of the program.
  • The registration system of the program has been changed, made by analogy with the programs XML Constructor and XML Reports.
  • The mechanism of the demo mode has been changed - now the program works without restrictions for 30 days, after which it stops working if there is no registration.
  • The list of requests has been expanded with two new general-purpose conversion requests to MIF and DXF. Unlike other queries bound to the structure of XML files for extracts and CBTs, these queries can extract graphics from any Rossreetr XML files, including extracts, CBTs, boundary plans, technical plans, a map (plan), etc. the attributive information of various objects retrieved by these queries (existing and generated sites, contours and parts of a site, building, zone, etc.) is significantly different, then only the designation of the object is retrieved in this case. Using these queries allows you to:
    • control the filling of catalogs for the generated boundary and technical plans, maps (plan)
    • restore graphics from XML files in case of loss of original materials

What's new in version 1.4.2

  • The XQuery query for converting XML files to the MIF / MID format has been updated due to changes in XML schemas regarding multi-contour sections - multi-contour sections are now transmitted by separate objects, for each contour its own designation is written, for example: 123 (1) (the previous version of the query did not transmit multi-circuit sections for extracts and CBTs created according to new schemes).
  • Updated XQuery query for converting XML files to DXF format (without attributes, blocks) - the contours of multi-contour sections are now signed (the previous version of the query transmitted the contours of multi-contour sections, but did not put signatures).

What's new in version 1.4.1

  • Updated XQuery query for converting XML files to MIF / MID format - added one more column for creating signatures in MapInfo, containing only the designation of the parcel (or part) number without the cadastral quarter number in the same form in which they are indicated in the CPT and should displayed in the drawing of the boundary plan.
  • Updated XQuery-query for converting XML files into DXF format (without attributes, blocks) - text captions are placed in the center of the main (first) contour of objects with a conventional designation of the section (or part) number in the same form in which they are indicated in the CBT and should be displayed on the drawing of the boundary plan.
  • Updated all DXF queries in that after converting and opening the converted file in AutoCAD or MicroStation, the current view displayed the converted parcels.
  • All XQuery queries that retrieve data have been updated in terms of handling the case when there can be several records with permitted use - each permitted use is now displayed separated by commas (similar to handling rights and encumbrances).
  • The XQuery-query for selecting points of objects in the NXY format has been optimized and its extended version has been added, which selects, in addition to the number, coordinates, precision, the method of fixing (for the code according to the reference book, see XML-schema).

New in version 1.4.0

  • The procedure for switching from the demo version to the full version of the program has been changed - now all you need to do is enter your personal serial number.
  • Added the function of renaming both target and source documents based on the information contained in the converted XML files
  • Updated XQuery-query for converting XML files into MIF / MID format in terms of processing common land uses and parts of parcels (now the incoming parcels of single land uses are converted to the same form as when converting QPT, i.e. as separate contours, and not combined into a multi-contour parcel as it was before; parts of parcels are also created as separate contours, with their own information - have not been created before).
  • The algorithm for determining the limits for the MIF / MID, DXF formats has been changed (previously, the presence of areas with erroneous coordinates could lead to the setting of such limits that the areas did not fall on the working field and disappeared when opening converted files in GIS).
Share with friends or save for yourself:

Loading...