Web API (or Stored Procedure) to list out vehicles in 30 miles radios

Speed is of an essence. The quicker you deliver -- higher the chances of getting bonus.

Technology Required


SQL Server

Visual [login to view URL] (C#.Net)

Google API (or different) Free version

Database Structure


Office (Table ) - This is a table with Columns "OfficeID", "OfficeName", "Address", "City", "State", Zip"

OfficeCars (Table ) -- This is the table with "CarID", "CarNumber", "CarColor", "Langitude", "Lattitude", "LastUpdatedTimeStamp"

Function / Stored procedure can have an input parameter - OfficeID.

Upon calling the function.

The function needs to read the office table to gather the office address (or longitude & Latitude) from "Offices" table. Then the function needs result a list of cars that are currently located with in 30 mile radios. The result can be a temp table, array, csv, excel or in any other usable format.

NOTE: Offices table may have 100 records, however function is only taking one OfficeID as an input parameter. However, OfficeCars table may have over 1000 records



1) Preferably a stored procedure, if not a Web API

2) Instructions to install (In case of Web API) and use

3) Database Script to create tables and sample data.

Habilidades: Programação C#, Microsoft SQL Server , Google Maps API, Web API, RESTful API

Sobre o Cliente:
( 15 comentários ) Royal Oak, United States

ID do Projeto: #30308136

Concedido a:


I have total 8 plus years of experience in SQL DEVELOPMENT. I can help create database tables and complicated stored procedures which can help you. Please ping me over the chat.

$140 USD em 7 dias
(1 Comentário)
(9 Comentários)

12 freelancers estão ofertando em média $221 nesse trabalho

(21 Comentários)

Very skilled, innovative and motivated Sr. Software Engineer with more than 10 years of experience analyzing, designing and developing web applications, desktop application and different software projects. Extensive e Mais

$250 USD in 5 dias
(5 Comentários)
(3 Comentários)

Hello I read your project 'Web API (or Stored Procedure) to list out vehicles in 30 miles radios' and I think I have the necessary skills to complete it. I am software engineer and database developer I have 4+ years of Mais

$200 USD in 7 dias
(2 Comentários)

WEB DESIGN AND DEVELOPMENT Hello, Warm regards and thank you for reviewing our proposal. Problem Statement: Web API (or Stored Procedure) to list out vehicles in 30 miles radios I am confident that the project can be Mais

$223 USD in 7 dias
(0 Comentários)

Having 5 years experience in sql server. Expert in SSMS, SSIS, SSRS and thoroughly using triggers, cursors, dynamic sub queries, jobs and indexing and expert in query optimization and managing performance issues and ha Mais

$140 USD in 7 dias
(0 Comentários)
(0 Comentários)

This is the Plan UI Platform - MVC with LinQ Data Grid - Datatable Jquery plugin Database - Procedure We will write a procedure that will retrieve the data. The retrieved data were processed in an MVC contro Mais

$160 USD em 1 dia
(0 Comentários)

Hello, I have taken a brief note of your project description. I’m an expert developer. My preference is to satisfy all of your venture’s prerequisites. Let’s come over the chat to discuss the project module, so we can Mais

$140 USD in 7 dias
(0 Comentários)

High speed! Hello. I see that you need a web api or stored procedure to list out vehicles. I have rich experience in .NET, MS SQL, Google API. You may see my profile. I can start right now and complete successfully. I Mais

$250 USD em 1 dia
(1 Comentário)