develop dotnet core application to measure distance
$10-30 USD
Κλειστή
Αναρτήθηκε πάνω από 5 χρόνια πριν
$10-30 USD
Πληρωμή κατά την παράδοση
Task:
Create a DotNet Core console application (or MVC application) to calculate distances between source and destination.
I would like to use Google APIs to do these calculations, as well as SQL Server to do the same.
In [login to view URL] you create an option to indicate whether to use Google or SQL Server method to perform the calculations.
Functionalities:
1 - Geocode: transform a pair of coordinates into a full address, inclusing streetname, number, postalcode, neighborhood, city, state, country
The coordinates must be stored in SQL Server / DotNet Core Geography datatype (tipo 4326)
2 - Geodecode: transform an address into a pair of coordinates
The coordinates must be stored in SQL Server / DotNet Core Geography datatype (tipo 4326)
3 - Calculate distances using these methods:
a) Between 2 addresses
b) Between 2 geographic coordinates
Provide an implementation using SQL Server (I provide some source code below) and one with Google APIs
c) Between an address and 1 geographic coordinate
d) Between a geographic coordinate and 1 address
4 - Show the source and destination coordinates / addresses on the map, with a symbol which indicates the start and end positions
and a straight line between these coordinates
Deliverables:
Visual Studio 2017 Solution with 1 DotNet Core 2.1 project which implements the requirements.
-------------------------------------------------------------------------------------------------------------------
Some useful information:
CREATE TABLE [dbo].[CitiesWorld](
[Id] [smallint] IDENTITY(1,1) NOT NULL,
[City] [nchar](40) NULL,
[Coordinates] [geography] NULL,
CONSTRAINT [PK_CitiesWorld] PRIMARY KEY CLUSTERED
(
[Id] ASC
) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
INSERT INTO [dbo].[CitiesWorld] ([City],[Coordinates])
VALUES ('Cochabamba', geography::STGeomFromText('POINT(-66.1711278 -17.4125)', 4326));
GO
INSERT INTO [dbo].[CitiesWorld]([City],[Coordinates])
VALUES('London', geography::STGeomFromText('POINT(0.0275361 51.5064694)', 4326));
GO
CREATE PROCEDURE Distance
@cityor varchar(50),
@citydest varchar(50),
@unit varchar(5)
AS
declare @or geography, @dest geography
SET @or = (select coordinates from [dbo].[CitiesWorld] where city=@cityor)
SET @dest = (select coordinates from [dbo].[CitiesWorld] where city=@citydest)
IF @unit='miles'
SELECT @[login to view URL](@dest)/1609.344
ELSE
--Else show the distance in km
SELECT @[login to view URL](@dest)/1000
EXECUTE Distance 'Cochabamba','London','miles'
EXECUTE Distance 'Cochabamba','London','km'
-- *** Calculate the distance in KM between 2 points ***
DECLARE @source geography = 'POINT(0 51.5)'
DECLARE @target geography = 'POINT(-3 56)'
SELECT @[login to view URL](@target) as [Distance in KM]
-- *** Function ***
CREATE FUNCTION [login to view URL] (
@source VARCHAR(40),
@destination VARCHAR(40)
)
RETURNS FLOAT
AS
BEGIN
DECLARE @g geography;
DECLARE @h geography;
DECLARE @distance float;
SET @g = geography::STGeomFromText('POINT(' + @source + ')', 4326);
SET @h = geography::STGeomFromText('POINT(' + @destination + ')', 4326);
SET @distance = (SELECT @[login to view URL] (@h) as [Distance in Meters])
Return @distance
END
-- *** [login to view URL] ***
-- *** Call the SQL Server Function ***
select [dbo].[fnCalcDistanceMeters] ('-23.5766949 -46.6871394', '-23.4943056 -46.8038278') as [Distance in Meters] --Distance: 14418,9109882281 meters
Hello,
We are a team of Microsoft Certified Professionals and can complete your vb.net software app as per your requirements. We have 15 years of experience in developing Microsoft Windows applications.
Also we have 5 years of experience in developing iphone ios apps, ipad apps, android apps.
Many of our apps are available on ios store.
Best Regards
Shiv Naryan