Import Open Street Map to MS SQL Database & Inverse Geo-code

Suljettu

Kuvaus

First part of this project is to download North America file from Geofarbik website. North America file is provided in different formats (.[url removed, login to view], .[url removed, login to view], .[url removed, login to view]). OSM file contains xml code, every singe part of map is inside.

Your task is to download North America file from: ([url removed, login to view]) and to import whole file in MS SQL database called osm. Database must contain all data that is inside xml file, you can use up to 6 tables to organize data and you must identify each record by id that is already in xml code.

After import is done, you have to test if database works properly. Best way to do that is to download QGIS and connect your database to QGIS. If osm data is imported properly you should get a road map of North America

Next task is to build Inverse Geocoder. It means that you have to get full address from database by providing input coordinates. You have to find nearest point for provided input and output should be full address of given coordinates. Example for input (STPointFromText('POINT([url removed, login to view] [url removed, login to view])',4326)), you should get 125 Water Street, NYC 10038. You can either build query or stored procedure, whatever is better for you.

Taidot: tietojenkäsittely, GPS, Microsoft SQL Server, tietojärjestelmäarkkitehtuuri, SQL

Näytä lisää: open street map, zip code database sql, open street map data extraction, open street map extract austria, gpsmid open street map, software write mq4, software write chip epson, java mobile navigation open street map, useful software write book, iphone navigation open street map, flash frontend code behind sql server database, software write web specs, vba code convert access database sql server, vba code create sql database open sql database, free software write user guide, software write edid, google map api marker database sql, free software write company profile, software write websites idea, software write book images, simple vb6 code restore sql database, software write books, software write protection, free software write book, software write book

Projektin tunnus: #13465602

15 freelanceria on tarjonnut keskimäärin 198 $ tähän työhön

sheikDev

Hello, I gone through the details. I'm comfortable to achieve this. Please message me. We will discuss in detail. Thanks, Sheik

138 $ CAD 4 päivässä
(34 arvostelua)
5.2
ifriends710

Hello. I am a GIS expert and Web&Mobile(iOS&Android) developer. Since 10 years before I have been developing GIS applications. I graduated GIS special education course and I have rich experiences for development Lisää

200 $ CAD 3 päivässä
(6 arvostelua)
4.9
AliSafder

I can work on it. Let me know when to start? I have over 8 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming languages like MVC, .Net technologies(Asp.Net, Vb.N Lisää

250 $ CAD 11 päivässä
(26 arvostelua)
4.6
mauricemarinus

Hi there. I already have a tool which converts osm to mssql. All we need is the inverse geocoder. anyways contact me to discuss. Kind regards Maurice Marinus

200 $ CAD 3 päivässä
(29 arvostelua)
4.4
novepi1

Hi there, My current bid is just a placeholder. Let me know if your budget is flexible enough for $650, otherwise just ignore my bid. Thanks Ibrahim

155 $ CAD 3 päivässä
(9 arvostelua)
4.1
techtechnocrats

Dear Hiring Manager, Hi, After reading over your application this looks like a perfect fit for my skill sets. I have built a large number of Google map API applications, specifically on the wordpress platform. I l Lisää

250 $ CAD 3 päivässä
(3 arvostelua)
2.1
erndsglts

i have 6 years experience on Qt,C++,MySql,QGIS on linux and window.i done project on QGIS,so i can complete your project ASAP.

150 $ CAD 2 päivässä
(3 arvostelua)
2.3
277 $ CAD 3 päivässä
(2 arvostelua)
1.5
irsg

Exciting job. Actually i have experience to convert pbf file(OSM db) to mysql using C++ code. I have checked your project. Very similar. So, I can do this within 2 days. Last time, I downloaded china pbf (size more t Lisää

166 $ CAD 3 päivässä
(3 arvostelua)
1.1
veskojl

Hi, I'm a DB expert from Bulgaria (EU) with 7+ years of experience in that field. Over the years I've gained hands-on experience in wide variety of tools: a. RDBMS - Oracle, Teradata, MSSQL Server, MySQL, Postg Lisää

300 $ CAD 8 päivässä
(1 arvostelu)
0.4
155 $ CAD 3 päivässä
(0 arvostelua)
0.0
adnanrauf143

With a Degree in GIS from Royal Institute of Technology Stockholm, Sweden (Ranked among world Top 150 Institutes i am Adnan Rauf having 8 to 10 years of GIS experience under my belt. I have previously worked on project Lisää

222 $ CAD 10 päivässä
(0 arvostelua)
0.0
155 $ CAD 3 päivässä
(0 arvostelua)
0.0
Paultechm

A proposal has not yet been provided

222 $ CAD 15 päivässä
(0 arvostelua)
0.0
sanjaybhansali

hello sir, i have 7 year of experience in sql server technolgy. in my carrier, i have many website using sql server database. i also work google map search directory web project. which also take parameter as geo cor Lisää

133 $ CAD 3 päivässä
(0 arvostelua)
0.0