Ditutup

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

Projek ini menerima 15 bida daripada freelancer berbakat dengan harga bida purata $198 CAD.

Dapatkan sebut harga percuma untuk projek seperti ini
Bajet Projek
$30 - $250 CAD
Jumlah Bida
15
Penerangan Projek

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.

Mencari untuk memperoleh sedikit wang?

  • Tetapkan bajet anda dan tempoh masa
  • Rangkakan cadangan anda
  • Dibayar untuk kerja anda

Upah Freelancer yang juga membida projek ini

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online