Suljettu

develop dotnet core application to measure distance

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

Taidot: .NET

Näytä lisää: develop simple iphone application 2008, develop voip mobile application, develop desktop flash application, calculating distance using google maps in asp net, how does google maps calculate distance, develop a .net c# web service for calculating distance, google distance matrix api in c#, distance calculator code in asp net, google maps calculate distance multiple locations, calculate distance between two points google maps javascript, how to calculate distance between two latitude and longitude in google map, develop online test application, develop inventory management application using visual basic, develop iphone flashcard application, develop iphone reader application, call dotnet window application, develop web sms application html, develop text messaging application, develop fantasy football application, develop php sms application management software

Tietoa työnantajasta:
( 14 arvostelua ) São Paulo, Brazil

Projektin tunnus: #17623603

3 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

shivnarayan

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 h Lisää

$250 USD 5 päivässä
(18 arvostelua)
6.6
sreyanshsonu

i have access and expertise to do these: "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, Lisää

$45 USD 7 päivässä
(0 arvostelua)
0.0
hebaalansaary

I can make this project using angular6 ,asp.net core 2.1 using geo code ,[login to view URL] please provide me with UI

$50 USD 7 päivässä
(0 arvostelua)
0.0