Changes

Jump to navigation Jump to search
157 bytes added ,  12:00, 7 August 2018
--44740
The API occasionally will give erroneous latitude and longitude readings. In order to catch only the good ones, I found the latitude and longitude lines that encompass the mainland US and created an exclude flag to make sure companies were in this box. I then created flags to include companies in Puerto Rico, Hawaii, and Alaska. Companies that were in these places often had wrong latitude and longitude readings of 44.93, 7.54, so I ran a query making sure that these weren't listed.
DROP TABLE geoallcoords;
158

edits

Navigation menu