I have to create a program that will create a database when using geo points. I will include a previous program and the instructions:You are going to change program 8 so that instead of reading in a list of five or more points from a file you will read the points in from a database.Create a program the will create your database and insert at least five points. Use your own data, something like:100, 200, 123, Main Campus120, 133, 142, Montoya153, 123, 322, Rio Rancho133, 123, 143, STEMULUS Center153, 142, 122, ATC Run your initialization code to create the database.Modify your GUI program from program 8 so that it reads points from your database instead of a file.Turn in the initialization code, the database and your new GUI program. IDLE File EditD2L Program 9 - Geo PoiXbartlebyAsk orKeepincludFormat Run Options Window HelpContatextbohelp.#ral alliCLI IZCU alu ucιανιι CUIISLIULUIdef#Getter_init__(self, lat=0, lon=0, description = 'TBD');self. _lat= latself.__lon = lonself.__description# Setter for setting latitude and longitudedef SetPoint (self, coords):lat coords [0]self.__self.__lon = coords [1]for having pointdef Get Point (self):=return(self.__lat, self.__lon)description#Distance method to calculate distance between pointsdef Distance (self, toPoint):return self.__description##Point property to access and set point valuesPoint = property (Get Point, SetPoint)Aski ##Description property to access adn set point descriptionDescription = property (GetDescription, Set Description)p = pi/180a = 0.5 cos((toPoint [0]-(self.Point)[0])*p)/2 + cos((self.Point) [0] *p) cos (toPoint [0]*p) * (1-cos((toPoint [1]-(self.Point) [1]) *p))/2return 12742 * asin(sqrt(a))#Method that will set the objects self.description attributedef Set Description(self, description):self.__description = description##Method that will return the objects self.description attributedef GetDescription(self):##Open file in read modeO## Created list to store lat lon and description values# #Initialzing listpointList = []YazzieTP9.py - /Users/tishenayazzie/Documents/YazzieTP9.py (3.7.9)file = open("input.txt","r")##Reading points from file input.txtfor line in file:#Close filefile.close()temp = line.split(",")pointList.append(GeoPoint (float(temp [0]), float(temp [1], temp [2].strip()))point GeoPoint()while True:lat, lon= map (float, input ("Enter the location points of latitude and longitude:").split(","))## Use list of values to calculate distance from points [lat, lon]minDistance = pointList[0]. Distance ([lat, lon])for p in pointList:tempDisp. Distance ([lat, lon])if minDistance > tempDis:minDistance = tempDisNOV 122TXTtv ♫AWLn: 58Ơ00Col: 12Tue Nov 22 4:42 PMShellTXTDO01:31:08)se()" for more informatPointsLn

Define class GeoPoint that stores the latitude, longitude and description of points. Define…

Answered: I have to create a program that will…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

100%

I have to create a program that will create a database when using geo points. I will include a previous program and the instructions:

You are going to change program 8 so that instead of reading in a list of five or more points from a file you will read the points in from a database.

Create a program the will create your database and insert at least five points. Use your own data, something like:

100, 200, 123, Main Campus

120, 133, 142, Montoya

153, 123, 322, Rio Rancho

133, 123, 143, STEMULUS Center

153, 142, 122, ATC

Run your initialization code to create the database.
Modify your GUI program from program 8 so that it reads points from your database instead of a file.
Turn in the initialization code, the database and your new GUI program.

IDLE File Edit
D2L Program 9 - Geo Poi
X
bartleby
Ask or
Keep
includ
Format Run Options Window Help
Conta
textbo
help.
#ral alliCLI IZCU alu ucιανιι CUIISLIULUI
def
#Getter
_init__(self, lat=0, lon=0, description = 'TBD');
self. _lat= lat
self.__lon = lon
self.__description
# Setter for setting latitude and longitude
def SetPoint (self, coords):
lat coords [0]
self.__
self.__lon = coords [1]
for having point
def Get Point (self):
=
return(self.__lat, self.__lon)
description
#Distance method to calculate distance between points
def Distance (self, toPoint):
return self.__description
##Point property to access and set point values
Point = property (Get Point, SetPoint)
Aski ##Description property to access adn set point description
Description = property (GetDescription, Set Description)
p = pi/180
a = 0.5 cos((toPoint [0]-(self.Point)[0])*p)/2 + cos((self.Point) [0] *p) cos (toPoint [0]*p) * (1-cos((toPoint [1]-(self.Point) [1]) *p))/2
return 12742 * asin(sqrt(a))
#Method that will set the objects self.description attribute
def Set Description(self, description):
self.__description = description
##Method that will return the objects self.description attribute
def GetDescription(self):
##Open file in read mode
O
## Created list to store lat lon and description values
# #Initialzing list
pointList = []
YazzieTP9.py - /Users/tishenayazzie/Documents/YazzieTP9.py (3.7.9)
file = open("input.txt","r")
##Reading points from file input.txt
for line in file:
#Close file
file.close()
temp = line.split(",")
pointList.append(GeoPoint (float(temp [0]), float(temp [1], temp [2].strip()))
point GeoPoint()
while True:
lat, lon= map (float, input ("Enter the location points of latitude and longitude:").split(","))
## Use list of values to calculate distance from points [lat, lon]
minDistance = pointList[0]. Distance ([lat, lon])
for p in pointList:
tempDisp. Distance ([lat, lon])
if minDistance > tempDis:
minDistance = tempDis
NOV 1
22
TXT
tv ♫
A
W
Ln: 58
Ơ
00
Col: 12
Tue Nov 22 4:42 PM
Shell
TXT
DO
01:31:08)
se()" for more informat
Points
Ln

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 5 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions