Astrologers' Community  

Go Back   Astrologers' Community > General Astrology > Natal Astrology > Relocation Astrology

Relocation Astrology For discussions on relocation astrology techniques: astro*carto*graphy, relocated charts, local space directions etc.


Reply
Thread Tools Display Modes
  #1  
Unread 01-14-2016, 11:48 PM
HoldOrFold's Avatar
HoldOrFold HoldOrFold is offline
Senior Member
 
Join Date: Nov 2010
Posts: 466
List of all big cities in the world, their lattitude, longitude and timezone required

As some of you may know, I made an online midpoint calculator last year which calculates all your midpoints and aspects in one go. It's been doing quite well, ranking number 1 in Google for the term "astrology midpoint calculator".

Currently, I've been quite interested in relocational astrology, but I'm finding it a very tedious and time consuming process. The way it's done at the moment, you have to look at planetary lines on say astro.com, pick a place on a line, generate a chart for that place and then analyse it, only to find it has many qualities you don't like, so then you must rinse and repeat many times. Even if you spent half a year analyzing 200 relocation places and decided on a place, you may have missed 400 better places you didn't consider... not to mention spending a half a year on chart analysis.

So I'm about to start working on a new astrocartography program which will generate a list of cities best suited for an individual to relocate to.

It will do the following:
- Behind the scenes, it will generate an individual's relocated chart for each major city in the world
- Automatically analyse each chart and score points based on pre-set criteria (ascendant ruler condition, planets on angles, aspects to benefics/malefics, midpoint activation, POF etc.)
- Output a list of top cities for relocation ranked by their overall score in catagories e.g. Career, Relationships, Family etc. and show you those few golden places in the world which are generally the best regardless of catagory
- It will allow you to look at the charts and give a breakdown of the scores and rank

I'll be looking for beta-testers when it's ready if anyone would be interested when that time comes.

But for now it's in the design phase, and a critical thing I need to make it work is a list of all the major cities in the world and their lattitude, longitude and timezone, preferably in an excel spreadsheet format. I'd imagine there would be about 4000+ cities. So if anyone knows where I could obtain such a list, or how to generate one, that would be awesome.


Last edited by HoldOrFold; 01-14-2016 at 11:50 PM.
Reply With Quote
  #2  
Unread 01-15-2016, 12:16 AM
JUPITERASC's Avatar
JUPITERASC JUPITERASC is offline
Senior Member
 
Join Date: Jan 2008
Posts: 74,786
Re: List of all big cities in the world, their lattitude, longitude and timezone requ

Quote:
Originally Posted by HoldOrFold View Post
As some of you may know, I made an online midpoint calculator last year which calculates all your midpoints and aspects in one go.
It's been doing quite well, ranking number 1 in Google for the term "astrology midpoint calculator".

Currently, I've been quite interested in relocational astrology, but I'm finding it a very tedious and time consuming process.
The way it's done at the moment, you have to look at planetary lines on say astro.com, pick a place on a line,
generate a chart for that place and then analyse it, only to find it has many qualities you don't like,
so then you must rinse and repeat many times.
Even if you spent half a year analyzing 200 relocation places and decided on a place,
you may have missed 400 better places you didn't consider...
not to mention spending a half a year on chart analysis.

So I'm about to start working on a new astrocartography program
which will generate a list of cities best suited for an individual to relocate to.

It will do the following:
- Behind the scenes, it will generate an individual's relocated chart for each major city in the world
- Automatically analyse each chart and score points based on pre-set criteria (ascendant ruler condition, planets on angles, aspects to benefics/malefics, midpoint activation, POF etc.)
- Output a list of top cities for relocation ranked by their overall score in catagories e.g. Career, Relationships, Family etc. and show you those few golden places in the world which are generally the best regardless of catagory
- It will allow you to look at the charts and give a breakdown of the scores and rank

I'll be looking for beta-testers when it's ready if anyone would be interested when that time comes.

But for now it's in the design phase,
and a critical thing I need to make it work is a list of all the major cities in the world and their lattitude, longitude and timezone,
preferably in an excel spreadsheet format. I'd imagine there would be about 4000+ cities.
So if anyone knows where I could obtain such a list, or how to generate one, that would be awesome.
Countries, Capitals, Latitude and Longitude Table http://www.csgnetwork.com/llinfotable.html
__________________
http://www.youtube.com/watch?v=82p-D...eature=related Hippocrates Let food be your medicine: let medicine be your food. https://www.youtube.com/watch?v=cvz9uSK3zXo Rosencrantz & Guildenstern are Dead Tom Stoppard http://www.youtube.com/watch?v=KchhSIVwMdY Every exit is an entrance to somewhere else. VETTIUS VALENS FREE http://www.csus.edu/indiv/r/rileymt/...s%20entire.pdf
Reply With Quote
The Following 2 Users Say Thank You to JUPITERASC For This Useful Post:
comdoc (01-15-2016), Saggal (01-15-2016)
  #3  
Unread 01-15-2016, 06:43 AM
HoldOrFold's Avatar
HoldOrFold HoldOrFold is offline
Senior Member
 
Join Date: Nov 2010
Posts: 466
Re: List of all big cities in the world, their lattitude, longitude and timezone requ

Quote:
Originally Posted by JUPITERASC View Post
Countries, Capitals, Latitude and Longitude Table http://www.csgnetwork.com/llinfotable.html
Thanks, JUPITERASC, looks good but I need a list of all reasonably sized cities in the world (not just capitals) including timezone. Not to worry though, I think I may be on to something somewhere.
Reply With Quote
  #4  
Unread 01-15-2016, 12:18 PM
JUPITERASC's Avatar
JUPITERASC JUPITERASC is offline
Senior Member
 
Join Date: Jan 2008
Posts: 74,786
Re: List of all big cities in the world, their lattitude, longitude and timezone requ

Quote:
Originally Posted by HoldOrFold View Post

Thanks, JUPITERASC, looks good
but I need a list of all reasonably sized cities in the world (not just capitals) including timezone.
Not to worry though, I think I may be on to something somewhere.

OK great HoldOrFold
__________________
http://www.youtube.com/watch?v=82p-D...eature=related Hippocrates Let food be your medicine: let medicine be your food. https://www.youtube.com/watch?v=cvz9uSK3zXo Rosencrantz & Guildenstern are Dead Tom Stoppard http://www.youtube.com/watch?v=KchhSIVwMdY Every exit is an entrance to somewhere else. VETTIUS VALENS FREE http://www.csus.edu/indiv/r/rileymt/...s%20entire.pdf
Reply With Quote
  #5  
Unread 01-15-2016, 09:19 PM
waybread's Avatar
waybread waybread is offline
Senior Member
 
Join Date: Nov 2007
Location: A class M planet near you
Posts: 17,375
Re: List of all big cities in the world, their lattitude, longitude and timezone requ

The back section of a large world atlas, called a gazetteer, should have this information. Hopefully you can find a world gazetteer on-line.
__________________
My friends, love is better than anger. Hope is better than fear. Optimism is better than despair. So let us be loving, hopeful and optimistic. And we’ll change the world. Jack Layton, "Letter to Canadians"

I thought we went along paths--but it seems there are no paths. The going itself is the path.
C.S. Lewis, Perelandra.

Life is not about finding yourself. Life is about creating yourself. Message on a refrigerator magnet.
Reply With Quote
The Following User Says Thank You to waybread For This Useful Post:
HoldOrFold (01-16-2016)
  #6  
Unread 01-16-2016, 06:36 AM
HoldOrFold's Avatar
HoldOrFold HoldOrFold is offline
Senior Member
 
Join Date: Nov 2010
Posts: 466
Re: List of all big cities in the world, their lattitude, longitude and timezone requ

Thanks, Waybread, that's something I might have to look into.

I think I may have found a good resource here: https://www.maxmind.com/en/free-world-cities-database

And then it should just be a matter of applying some kind of algorithm to generate the timezones. Time willing, I should be able to get to work on this soon.
Reply With Quote
  #7  
Unread 01-16-2016, 05:55 PM
JUPITERASC's Avatar
JUPITERASC JUPITERASC is offline
Senior Member
 
Join Date: Jan 2008
Posts: 74,786
Re: List of all big cities in the world, their lattitude, longitude and timezone requ

Quote:
Originally Posted by HoldOrFold View Post

Thanks, Waybread, that's something I might have to look into.

I think I may have found a good resource here:
https://www.maxmind.com/en/free-world-cities-database

And then it should just be a matter of applying some kind of algorithm to generate the timezones. Time willing, I should be able to get to work on this soon.
Great - that's good news HoldOrFold
__________________
http://www.youtube.com/watch?v=82p-D...eature=related Hippocrates Let food be your medicine: let medicine be your food. https://www.youtube.com/watch?v=cvz9uSK3zXo Rosencrantz & Guildenstern are Dead Tom Stoppard http://www.youtube.com/watch?v=KchhSIVwMdY Every exit is an entrance to somewhere else. VETTIUS VALENS FREE http://www.csus.edu/indiv/r/rileymt/...s%20entire.pdf
Reply With Quote
The Following User Says Thank You to JUPITERASC For This Useful Post:
HoldOrFold (01-16-2016)
Reply

Tags
cities, lattitude, list, longitude, required, timezone, world

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT. The time now is 05:06 AM.


Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright © 2005-2018, AstrologyWeekly.com. Boards' structure and all posts are property of AstrologyWeekly.com and their respective creators. No part of the messages sent on these boards may be copied without their owners' explicit consent.