I think it can even upload directly to SQL Server without MapInfo involved at all.
Use free ogr2ogr to convert the kml files into TAB or MIF. Subject: Converting KML/KMZ files as a batch operation Question: is any better way to achieve goal?Īgain our major challenge is to load and convert to SQL Server geometry objects a few hundred KLM/KMZ files as a batch process. Delete the data from the upload temp table.Move the data from the upload temp table into our app data tables to reflect the client relationship to geo objects.run the EazyLoader tool to upload SQL Server tables.For each KML/KMZ file run the MUT.MBX tool to convert to MapInfo native TAB format in place them in a shadow directory structure.Create a shell application in C# and scan our directory/subdirectory and for each subdirectory do:.
The way I see it at this time is to organize the load in stages as follows Maps are grouped in directories based on client submission and they are in KML or KMX format. If that requires writing a separate C# application and call the MAPInfo converter library using the MapInfo Extensions, we are willing to that too. The files are grouped into their own directories, per applicant, and we have iterate through all of them to convert. I know the latest versions of MapInfo contain some batch operation support or at least that was the plan back in 2018 from I can see on different posts.Ĭould somebody point me to the best source of information on this subject, please? This program converts the 1:250,000 NTS maps in DXF format to MapInfo. I am looking to find the best way to convert a bunch of KML/KMX files into SQL Server geometry objects. NTS to MapInfo Translator v.1.0 The 1:250,000 topographic maps produced by the Canadian Federal Government are available through several sources and are now available in digital form.