All Projects → cusco → ctt

cusco / ctt

Licence: other
ctt postal codes into MySQL with latitude and longitude from google

Programming Languages

PHP
23972 projects - #3 most used programming language

Projects that are alternatives of or similar to ctt

geodesy-php
Geodesy PHP - Port of some known geodesic/math functions for getting distance from a known point A to a known point B given their coordinates. It also supports conversion between units of length, Polar position to Cartesian coordinates, and different Reference Datums.
Stars: ✭ 26 (-21.21%)
Mutual labels:  latitude, longitude
PHPCoord
PHPCoord is a PHP library to aid in handling coordinates. It can convert coordinates for a point from one system to another and also calculate distance between points
Stars: ✭ 78 (+136.36%)
Mutual labels:  latitude, longitude
Open Location Code
Open Location Code is a library to generate short codes, called "plus codes", that can be used as digital addresses where street addresses don't exist.
Stars: ✭ 3,567 (+10709.09%)
Mutual labels:  latitude, longitude
llttz
The easy way to get java TimeZone from latitude/longitude
Stars: ✭ 27 (-18.18%)
Mutual labels:  latitude, longitude
Positional
An elegant and colorful location information app for Android with Compass, Clock, Level, Sun, Moon, Trail Marker and many other features.
Stars: ✭ 72 (+118.18%)
Mutual labels:  latitude, longitude
beihu-geo
地理位置解析服务,可供爬虫使用!供参考学习!
Stars: ✭ 16 (-51.52%)
Mutual labels:  latitude, longitude
pikaz-location
定位插件(限中国)
Stars: ✭ 78 (+136.36%)
Mutual labels:  latitude, longitude
laravel-geoly
Perform fast and efficient radius searches on your Laravel Eloquent models.
Stars: ✭ 25 (-24.24%)
Mutual labels:  latitude, longitude
react-cartographer
Generic component for displaying Yahoo / Google / Bing maps.
Stars: ✭ 82 (+148.48%)
Mutual labels:  latitude, longitude
Solar-Calculator
Calculates the sunrise and sunset for a given date and location (using GEO coordinates). This library uses the method outlined NOAA Solar Calculations Day spreadsheet found at http://www.esrl.noaa.gov/gmd/grad/solcalc/calcdetails.html.
Stars: ✭ 36 (+9.09%)
Mutual labels:  latitude, longitude
geolocation-php-api
This Geolocation PHP class connects to Google Maps API to find latitude/longitude or the address.
Stars: ✭ 71 (+115.15%)
Mutual labels:  latitude, longitude
haversine-js
JavaScript implementation of the Haversine formula
Stars: ✭ 12 (-63.64%)
Mutual labels:  latitude, longitude
Seeker
Accurately Locate Smartphones using Social Engineering
Stars: ✭ 2,772 (+8300%)
Mutual labels:  latitude, longitude
php-haversine-formula
Calculates de distance between two geocode points 📌🗺
Stars: ✭ 44 (+33.33%)
Mutual labels:  latitude, longitude
Vincenty-Excel
Thaddeus Vincenty's Direct and Inverse formulae for geodesic calculations in Excel (distance, azimuth, latitude, longitude).
Stars: ✭ 29 (-12.12%)
Mutual labels:  latitude, longitude
Trilateration
Trilateration system using 3 latitude and longitude points, and 3 radius distances in PHP, C#, Java and Javascript
Stars: ✭ 22 (-33.33%)
Mutual labels:  latitude, longitude
orange3-geo
🍊 🌍 Orange add-on for dealing with geography and geo-location
Stars: ✭ 22 (-33.33%)
Mutual labels:  latitude
laravel-5.3-app
🗺️ Get started with Laravel 5.3, Vue.js and Google Maps API
Stars: ✭ 28 (-15.15%)
Mutual labels:  google-maps-api
jqIpLocation
jqIpLocation – jQuery Plugin that returns the location of an IP address in JSON format
Stars: ✭ 18 (-45.45%)
Mutual labels:  latitude
go-satellite
Calculate orbital information of satellites in GoLang.
Stars: ✭ 55 (+66.67%)
Mutual labels:  longitude

CTT database with Lat Lng

update: upon much requested, added a csv export: https://github.com/cusco/ctt/raw/master/ctt-lat-lng-csv.zip

this file already has the scanned address and found address viaq google.


ctt postal codes into MySQL with latitude and longitude from google

external - files downloaded from CTT ( http://www.ctt.pt/feapl_2/app/restricted/postalCodeSearch/feapl_2_31-postalCodeDownloadFiles.jspx )

basically:

updateGeo.php uses google to get latitude and longitude.

Google has some daily usage restrictions .. There is a piece of code commented to use a different IP when the limit is reached (in my case I have several internal IP's on the operating system, that will be NAT'ed to different public IP's)

You will have to run getGeo.php several times until your table is populated, or remove the initial select limit.

new - added file CTT.sql which contains structure and data generated from these scripts. This is probably what everybody wants.

new - updated CTT.sql with new latitudes and longitudes based on feedback from: http://www.portugal-a-programar.pt/forums/topic/74313-pesquisa-por-latitude-e-longitude-por-c%C3%B3digos-postais/?do=findComment&comment=599669

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].