New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Loading OS ITN GML files to SQL Server database #45

Open

rfromthecastle opened this issue Oct 11, 2016 · 1 comment

rfromthecastle commented Oct 11, 2016

Hello,

I was wondering if you had a configuration file/example available to load Ordnance Survey ITN data in GML format into a SQL Server database.

Member

walkermatt commented Oct 11, 2016

Hi, I don't know of anyone that has used Loader to load ITN into MS SQL Server but it should be possible.

I would of thought that you would be able to use osmm_itn_postgres.gfs to define the output tables with little or no modification.

You would also need a suitable MS SQL Server ogr_cmd in your configuration. See the OGR MS SQL page for details.

The supplied views however will probably need some work as I'm not sure the array functions we use in Postgres are available in MS SQL Server.

I'd be happy to add a section to complement the [ITN Postgres section in the wiki]https://github.com/AstunTechnology/Loader/wiki/Configuration-examples#ordnance-survey-itn-to-postgresqlpostgis).

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment