[Eng] Installation - diogofdsilva/MS-OSM-Querys GitHub Wiki

Requisites:

  • Microsoft SQL Server Database that supports Spatial querys (after SQL Server 2008 R2);
  • Download OSM file containing the extract of the map (link).

Step by step:

  1. Create the DataBase;
  2. Create the tables using the script OSM-SIAT-Tables.sql;
  3. Load the osm file with the OSM to DB tool, provided in this project;
  4. Build the geografic fields of the tables, using the script OSM-SIAT-GeoBuilder.sql (this operation can take several minutes - between 35-50 minutes);
  5. Build the Indexes of the tables, used to improve the performance of the querys through the use of the geographic fields. Use the following script: OSM-SIAT-Indexes.sql;
  6. At last, create the stored procedures with some of the querys used by the service. These querys are stored in the script OSM-SIAT-QueryProcedures.sql.

For now, you have builded the database that holds the information used by the service. The only thing left is to install the Web Service.