The number OF Lat's and Lon's have to be the same.
The Lat number and Lon number have to be different.
I make count unique so i have no same count. i write be low also.
Thanksy for information write line 14. I then have change my program and make better (maybe take time)
i look what can do make program GUI. DOS simple: fpc flyby.pas for compile and then terminal open and make run "flyby name_of_byairport.txt" (not quote) then enter.
That is, unless you know for sure that there no two airport with the same latitude or no two airports with the same longitude. If so, then there is an error somewhere.
That correct.
I make quick add export ByAirport.dat my program aptidat and make check use my program flyby and i write result and explain:
$ ./aptidat apt.dat Airport.txt
Processing file "apt.dat"
Line Airport Land Sea Heli Land_R Water_R Helipad Time
7970312 35242 28458 585 6199 34893 784 9719 95 sec (83210.44 lines/second)
$ ./flyby Airport.txt
Processing file "Airport.txt"
... show unique count
Line Error ICAO hash City Country Region Lat lon Time
35241 0 35241 35241 14272 259 248 35109 35135 35 sec (983.01 lines/second))
No errors encountered during processing data
Statistics dtICAO :
Shortest = "00C" (3 characters)
Longest = "XCYCDL8" (7 characters)
Lowest count = "00C" (1 times)
Highest count = "00CA" (1 times)
Statistics dtHash :
Shortest = "4" (1 characters)
Longest = "1022949" (7 characters)
Lowest count = "1021615" (1 times)
Highest count = "1022949" (1 times)
Statistics dtCity :
Shortest = "Ie" (2 characters)
Longest = "Charlotte Amalie - Harry S. Truman Airport" (42 characters)
Lowest count = "(Cagayan De Oro)" (1 times)
Highest count = "Nil" (9552 times)
Statistics dtCountry :
Shortest = "CA" (2 characters)
Longest = "United States Minor Outlying Islands" (36 characters)
Lowest count = "Anguilla" (1 times)
Highest count = "United States" (14971 times)
Statistics dtRegion :
Shortest = "AG" (2 characters)
Longest = "Nil" (3 characters)
Lowest count = "AN" (1 times)
Highest count = "Nil" (23023 times)
Statistics dtLat :
Shortest = "0.00000000" (10 characters)
Longest = "-10.00499742" (12 characters)
Lowest count = "-0.02069980" (1 times)
Highest count = "-23.59055556" (6 times)
Statistics dtLon :
Shortest = "0.00000000" (10 characters)
Longest = "-100.00039500" (13 characters)
Lowest count = "-0.00094400" (1 times)
Highest count = "-46.65805556" (4 times)
---------- List dtCountry ----------
1 : (10) "Afghanistan"
2 : (5) "Albania"
3 : (47) "Algeria"
4 : (3) "American Samoa"
5 : (27) "Angola"
6 : (1) "Anguilla"
7 : (9) "Antarctica"
8 : (3) "Antigua and Barbuda"
9 : (164) "Argentina"
10 : (1) "Arizona"
11 : (5) "Armenia"
12 : (1) "Aruba"
13 : (1492) "Australia"
14 : (54) "Austria"
15 : (9) "Azerbaijan"
16 : (38) "Bahamas"
17 : (2) "Bahrain"
18 : (13) "Bangladesh"
19 : (1) "Barbados"
20 : (9) "Belarus"
21 : (43) "Belgium"
22 : (1) "Belize"
23 : (2) "Benin"
24 : (1) "Bermuda"
25 : (3) "Bhutan"
26 : (38) "Bolivia"
27 : (4) "Bosnia and Herzegovina"
28 : (28) "Botswana"
29 : (3758) "Brazil"
30 : (1) "British Indian Ocean Territory"
31 : (2) "British Virgin Islands"
32 : (2) "Brunei"
33 : (22) "Bulgaria"
34 : (2) "Burkina Faso"
35 : (1) "Burkina Faso7"
36 : (36) "Burma"
37 : (1) "Burundi"
38 : (15) "CA"
39 : (6) "Cambodia"
40 : (10) "Cameroon"
41 : (704) "Canada"
42 : (9) "Cape Verde"
43 : (3) "Caribbean Netherlands"
44 : (1) "Carroll"
45 : (3) "Cayman Islands"
46 : (2) "Central African Republic"
47 : (5) "Chad"
48 : (176) "Chile"
49 : (102) "China"
50 : (1) "Christmas Island"
51 : (1) "Cocos (Keeling) Islands"
52 : (92) "Colombia"
53 : (3) "Comoros"
54 : (4) "Congo (Brazzaville)"
55 : (27) "Congo (Kinshasa)"
56 : (10) "Cook Islands"
57 : (26) "Costa Rica"
58 : (18) "Croatia"
59 : (31) "Cuba"
60 : (1) "Curaçao"
61 : (3) "Cyprus"
62 : (99) "Czechia"
63 : (7) "Côte d'Ivoire"
64 : (87) "Denmark"
65 : (1) "Djibouti"
66 : (2) "Dominica"
67 : (15) "Dominican Republic"
68 : (50) "Ecuador"
69 : (56) "Egypt"
70 : (4) "El Salvador"
71 : (2) "Equatorial Guinea"
72 : (3) "Eritrea"
73 : (13) "Estonia"
74 : (22) "Ethiopia"
75 : (2) "Falkland Islands"
76 : (8) "Faroe Islands"
77 : (23) "Fiji"
78 : (92) "Finland"
79 : (3) "FR"
80 : (441) "France"
81 : (5) "French Guiana"
82 : (48) "French Polynesia"
83 : (11) "Gabon"
84 : (1) "Gambia"
85 : (9) "Georgia"
86 : (505) "Germany"
87 : (8) "Ghana"
88 : (1) "Gibraltar"
89 : (56) "Greece"
90 : (17) "Greenland"
91 : (1) "Greenville"
92 : (2) "Grenada"
93 : (5) "Guadeloupe"
94 : (2) "Guam"
95 : (10) "Guatemala"
96 : (2) "Guernsey"
97 : (4) "Guinea"
98 : (3) "Guinea-Bissau"
99 : (16) "Guyana"
100 : (6) "Haiti"
101 : (10) "Honduras"
102 : (1) "Hong Kong"
103 : (76) "Hungary"
104 : (81) "Iceland"
105 : (195) "India"
106 : (181) "Indonesia"
107 : (88) "Iran"
108 : (16) "Iraq"
109 : (36) "Ireland"
110 : (1) "Isle of Man"
111 : (21) "Israel"
112 : (120) "Italy"
113 : (6) "Jamaica"
114 : (130) "Japan"
115 : (1) "Jersey"
116 : (8) "Jordan"
117 : (1) "K1"
118 : (21) "Kazakhstan"
119 : (14) "Kenya"
120 : (20) "Kiribati"
121 : (1) "Kosovo"
122 : (3) "Kuwait"
123 : (4) "Kyrgyzstan"
124 : (8) "Laos"
125 : (7) "Latvia"
126 : (3) "Lebanon"
127 : (5) "Lesotho"
128 : (2) "Liberia"
129 : (41) "Libya"
130 : (1) "Liechtenstein"
131 : (7) "Lithuania"
132 : (3) "Luxembourg"
133 : (1) "Macau"
134 : (12) "Macedonia"
135 : (28) "Madagascar"
136 : (7) "Malawi"
137 : (43) "Malaysia"
138 : (6) "Maldives"
139 : (8) "Mali"
140 : (2) "Malta"
141 : (7) "Marshall Islands"
142 : (1) "Martinique"
143 : (10) "Mauritania"
144 : (2) "Mauritius"
145 : (1) "Mayotte"
146 : (132) "Mexico"
147 : (4) "Micronesia"
148 : (3) "Moldova"
149 : (1) "Monaco"
150 : (22) "Mongolia"
151 : (3) "Montenegro"
152 : (1) "Montserrat"
153 : (26) "Morocco"
154 : (18) "Mozambique"
155 : (1) "Myanmar"
156 : (55) "Namibia"
157 : (1) "Namibia."
158 : (1) "Nauru"
159 : (41) "Nepal"
160 : (34) "Netherlands"
161 : (17) "New Caledonia"
162 : (109) "New Zealand"
163 : (10) "Nicaragua"
164 : (7) "Niger"
165 : (27) "Nigeria"
166 : (7294) "Nil"
167 : (1) "Niue"
168 : (1) "Norfolk Island"
169 : (1) "North Korea"
170 : (9) "Northern Mariana Islands"
171 : (142) "Norway"
172 : (6) "Oman"
173 : (68) "Pakistan"
174 : (3) "Palau"
175 : (2) "Palestinian Territory"
176 : (22) "Panama"
177 : (75) "Papua New Guinea"
178 : (11) "Paraguay"
179 : (1) "Peoples Republic of China"
180 : (1) "Peru"
181 : (79) "Perú"
182 : (73) "Philippines"
183 : (92) "Poland"
184 : (52) "Portugal"
185 : (32) "Puerto Rico"
186 : (3) "Qatar"
187 : (1) "Republic of Ireland (Eire)"
188 : (39) "Romania"
189 : (167) "Russia"
190 : (7) "Russian Federation"
191 : (1) "Russin Federation"
192 : (5) "Rwanda"
193 : (2) "Réunion"
194 : (1) "Saint Barthélemy"
195 : (2) "Saint Helena"
196 : (2) "Saint Kitts and Nevis"
197 : (2) "Saint Lucia"
198 : (1) "Saint Martin"
199 : (2) "Saint Pierre and Miquelon"
200 : (5) "Saint Vincent and the Grenadines"
201 : (4) "Samoa"
202 : (2) "Sao Tome and Principe"
203 : (62) "Saudi Arabia"
204 : (10) "Senegal"
205 : (7) "Serbia"
206 : (8) "Seychelles"
207 : (1) "Sierra Leone"
208 : (6) "Singapore"
209 : (30) "Slovakia"
210 : (16) "Slovenia"
211 : (23) "Solomon Islands"
212 : (6) "Somalia"
213 : (109) "South Africa"
214 : (77) "South Korea"
215 : (4) "South Sudan"
216 : (107) "Spain"
217 : (10) "Sri Lanka"
218 : (11) "Sudan"
219 : (8) "Suriname"
220 : (1) "Swaziland"
221 : (164) "Sweden"
222 : (1) "Swiss"
223 : (70) "Switzerland"
224 : (23) "Syria"
225 : (21) "Taiwan"
226 : (6) "Tajikistan"
227 : (14) "Tanzania"
228 : (61) "Thailand"
229 : (6) "Timor-Leste"
230 : (2) "Togo"
231 : (6) "Tonga"
232 : (2) "Trinidad and Tobago"
233 : (13) "Tunisia"
234 : (74) "Turkey"
235 : (10) "Turkmenistan"
236 : (7) "Turks and Caicos Islands"
237 : (1) "Tuvalu"
238 : (6) "U.S. Virgin Islands"
239 : (1) "U.S.A."
240 : (18) "Uganda"
241 : (26) "Ukraine"
242 : (19) "United Arab Emirates"
243 : (251) "United Kingdom"
244 : (1) "United Sates"
245 : (14971) "United States"
246 : (4) "United States Minor Outlying Islands"
247 : (2) "United States of America"
248 : (11) "Uruguay"
249 : (25) "US"
250 : (26) "USA"
251 : (15) "Uzbekistan"
252 : (23) "Vanuatu"
253 : (100) "Venezuela"
254 : (24) "Vietnam"
255 : (2) "Wallis and Futuna"
256 : (3) "Western Sahara"
257 : (13) "Yemen"
258 : (8) "Zambia"
259 : (17) "Zimbabwe"
First i see i have wrong count airport (i not know why. I make quick export so think have small error. I look later).
then have more better look:
Statistics dtLat :
Shortest = "0.00000000" (10 characters)
Longest = "-10.00499742" (12 characters)
Lowest count = "-0.02069980" (1 times)
Highest count = "-23.59055556" (6 times)
Lowest count = 1 times, Highest count is 6 times.
That mean Airport latitude "-23.59055556" is count 6 times. Then 6 airport in apt.dat have coordinate latitude -23.59055556
then:
Statistics dtLon :
Shortest = "0.00000000" (10 characters)
Longest = "-100.00039500" (13 characters)
Lowest count = "-0.00094400" (1 times)
Highest count = "-46.65805556" (4 times)
Lowest count = 1 times, Highest count is 4 times.
That mean Airport longitude "-46.65805556" is count 4 times. Then 4 airport in apt.dat have coordinate longitude -46.65805556.
Is many coincidence have 6 airport (from 35241) same latitude 23.59055556 and have 4 airport (from 35241) same longitutude -46.65805556 but i think that possible when have big planet earth
add:
is same for country and then no problem understand
Country
259
245 : (14971) "United States"
Country name ""United States" is count 14971 and Country count is 259. My program no write Country count = 35242 because have ICAO 35242. Have 259 unique name country