0
skymama

Dropzone database

Recommended Posts

I'm terrible with maps and directions. Right now I am trying to find the closest dz to Williamsburg, VA and I'm getting frustrated at clicking back and forth between the dz's listed and a map of VA I found online. So it made me think that it would be so nice to be able to type in the name of a major city, and have a list appear of the closest dz's available. It might also cut back on people asking the same type of question on the forums all the time. Would this be too difficult to implement?
She is Da Man, and you better not mess with Da Man,
because she will lay some keepdown on you faster than, well, really fast. ~Billvon

Share this post


Link to post
Share on other sites
The bare minimum required for that would be that each entry for a DZ would have to have a field for "Closest major city". Which would mean that we'd have to define "major city".

Further refining the idea, if one could enter the coordinates of the DZ when entering it to the DB, it could then be compared to the coordinates of any city the coordinates of which were known... The coordinates of major cities could be entered in the database, and then it would be easy to list the DZs near a certain city(and the distance from it!). But making something like this would be a major project.

Share this post


Link to post
Share on other sites
Prohaps an easier option would be to put a field on the Dropzone form/page that asks for the closest major cities. I know a few DZ's have that info in their pages, but if it was a predetermined field that might help things out to get the rest to include it.

Possibly include a field that is X minutes/miles from Y city?
Yesterday is history
And tomorrow is a mystery

Parachutemanuals.com

Share this post


Link to post
Share on other sites
Easier than coordinates is zip/postal codes. There are online mapping services that provide socket connections for distance calculations. It's a relatively minor operation.

The data required is the zip/postal code for the DZ. A user can then enter their zip/postal code and receive a distance ranked list of DZs, starting with closest. The coding on Sangiro's end isn't complicated, although the services charge a fee.

--

Another option is to just graphically place a dot on an GIF outline map of the state or country. DZs don't move all that often so it hardly needs to be dynamic.


First Class Citizen Twice Over

Share this post


Link to post
Share on other sites

>Easier than coordinates is zip/postal codes. There are
>online mapping services that provide socket connections

Works within the US, yes... But a system based on coordinates would serve the whole global community.

>Another option is to just graphically place a dot on an GIF
>outline map of the state or country.

:oBut that would be too easy! Where's the fun in doing something like that??:P

Share this post


Link to post
Share on other sites
Quote

Another option is to just graphically place a dot on an GIF outline map of the state or country. DZs don't move all that often so it hardly needs to be dynamic.



This sounds like the best option so far to me. I don't have any idea how to get the coordinates of a city. And, I suppose I could go to the post office website to find the zip code, but that's still more hunting and pecking than I was hoping for. But, I could probably figure out where I could go if there was a map like this. It would be cool if you could see the whole country, say the US for example, and then be able to click on a state to open in another window. The, if the dz's, some cities and major highways were on the map, it would even be mo' better! B|

How many hours of work did I just suggest for HH to do because I'm geographically challenged? :)
She is Da Man, and you better not mess with Da Man,
because she will lay some keepdown on you faster than, well, really fast. ~Billvon

Share this post


Link to post
Share on other sites
Quote

How many hours of work did I just suggest for HH to do because I'm geographically challenged? :)



Mebbe we can get a hi-res picture of each state, and find a person from each state to volunteer to mark all the DZ's in the state. I'll do Florida if the idea sounds good

--
Hook high, flare on time

Share this post


Link to post
Share on other sites

I'd offer to help, but I'm the one who has the problem of finding places to start with. :P
But, we have a lot of computer techies around here that always say they don't have enough work to do so they post whore instead. Maybe they can help out too.

She is Da Man, and you better not mess with Da Man,
because she will lay some keepdown on you faster than, well, really fast. ~Billvon

Share this post


Link to post
Share on other sites
Quote

Easier than coordinates is zip/postal codes. There are online mapping services that provide socket connections for distance calculations. It's a relatively minor operation.



There is also a Perl module (Geo::PostalCode) that can tell you the distance between postal codes, among other things. It uses the 1999 Census data, but postal codes don't change that often.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

0