Home  |  Forums  |  914 Info  |  Blogs
 
914World.com - The fastest growing online 914 community!
 
Porsche, and the Porsche crest are registered trademarks of Dr. Ing. h.c. F. Porsche AG. This site is not affiliated with Porsche in any way.
Its only purpose is to provide an online forum for car enthusiasts. All other trademarks are property of their respective owners.
 

Welcome Guest ( Log In | Register )

2 Pages V  1 2 >  
Reply to this topicStart new topic
> Would you all be interested in a 914 owners map/database?
ThePaintedMan
post Sep 5 2012, 02:00 PM
Post #1


Advanced Member
****

Group: Members
Posts: 3,887
Joined: 6-September 11
From: St. Petersburg, FL
Member No.: 13,527
Region Association: South East States



Hello all,
I've been thinking about this for a little bit. I work with GIS (Geographic Information Systems), maps and databases for my research and day job when I'm not at school. I was thinking, would it be at all useful to you guys if we had some sort of 914World database in which you could locate other members? I might try to utilize something pretty much point-and-click like Google Earth, but if it got enough use, I could look into something a bit more handy, in which you could pull up more information, including phone numbers, etc. Essentially if you were on a road trip and wanted to meet up with someone on your route, you would know that they were nearby, or if in the case of breakdowns, you could look up nearest owners, etc.

Of course the information would be voluntary and could be accessed with security so as not to broadcast people's information to the world (I mean the other one). In addition, it would be a nice visual to see where all of us are located across the U.S. The VIN database is a great start, this would be like an extension of it. Think of it like push-pins on a map but with as much or as little data as each person wants to share.

Give it some thought and let me know.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
rgolia
post Sep 5 2012, 02:03 PM
Post #2


GeoJoe
***

Group: Members
Posts: 719
Joined: 5-February 10
From: PA
Member No.: 11,329
Region Association: North East States



sounds great...we use GIS a lot at my work. Great tool. I am in PA and I do not know how many 914 owners are near me.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
SirAndy
post Sep 5 2012, 02:04 PM
Post #3


Resident German
*************************

Group: Admin
Posts: 42,207
Joined: 21-January 03
From: Oakland, Kalifornia
Member No.: 179
Region Association: Northern California



QUOTE(ThePaintedMan @ Sep 5 2012, 01:00 PM) *
Give it some thought and let me know.

We used to have a frappr owner database but unfortunately that died with Howard.
(IMG:style_emoticons/default/sad.gif)

He was the only one with a login and we could not retrieve the data before frappr went offline.


A few years ago, i started on a Google maps implementation that was to be integrated into the website and hooked into the existing 914world database, but real life work has been very busy for the last two years so no progress has been made on that codebase.

(IMG:style_emoticons/default/type.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
ThePaintedMan
post Sep 5 2012, 02:11 PM
Post #4


Advanced Member
****

Group: Members
Posts: 3,887
Joined: 6-September 11
From: St. Petersburg, FL
Member No.: 13,527
Region Association: South East States



QUOTE(SirAndy @ Sep 5 2012, 04:04 PM) *

QUOTE(ThePaintedMan @ Sep 5 2012, 01:00 PM) *
Give it some thought and let me know.

We used to have a frappr owner database but unfortunately that died with Howard.
(IMG:style_emoticons/default/sad.gif)

He was the only one with a login and we could not retrieve the data before frappr went offline.


A few years ago, i started on a Google maps implementation that was to be integrated into the website and hooked into the existing 914world database, but real life work has been very busy for the last two years so no progress has been made on that codebase.

(IMG:style_emoticons/default/type.gif)


Good info Andy. If you would like help, I would be glad to assist. Sorry to hear that info went with Howard. I wish I could have met him (IMG:style_emoticons/default/sad.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Rand
post Sep 5 2012, 02:12 PM
Post #5


Cross Member
*****

Group: Members
Posts: 7,411
Joined: 8-February 05
From: OR
Member No.: 3,573
Region Association: None



New enthusiasm to an old idea around here. Do it George! Just use open standards technology so it doesn't depend on a service that could die and kill all the effort (like frappr)

http://www.914world.com/bbs2/index.php?showtopic=62034

http://www.914world.com/bbs2/index.php?showtopic=114309

http://www.914world.com/bbs2/index.php?showtopic=71867

yada yada, searchage....
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
SirAndy
post Sep 5 2012, 02:15 PM
Post #6


Resident German
*************************

Group: Admin
Posts: 42,207
Joined: 21-January 03
From: Oakland, Kalifornia
Member No.: 179
Region Association: Northern California



QUOTE(ThePaintedMan @ Sep 5 2012, 01:11 PM) *
Good info Andy. If you would like help, I would be glad to assist. Sorry to hear that info went with Howard. I wish I could have met him (IMG:style_emoticons/default/sad.gif)

Here's how far i got:
http://www.914world.com/bbs2/index.php?act=membersmap

Obviously, the data (Lat/Lng) you see is fake but it's already tied into existing user accounts and database driven.

I also added clustering to the map. If you zoom out of the view, you can see how it starts clustering datapoints. That would allow for potentially having several thousand vehicles on the map at once.

(IMG:style_emoticons/default/type.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
ThePaintedMan
post Sep 5 2012, 02:25 PM
Post #7


Advanced Member
****

Group: Members
Posts: 3,887
Joined: 6-September 11
From: St. Petersburg, FL
Member No.: 13,527
Region Association: South East States



I figured I wasn't the first to bring this up (IMG:style_emoticons/default/smile.gif)

Andy, do you have an offline database already started then? I'll have to look into integrating an online point-and-click DB using something like Google Docs to allow people to automatically update it. Forgive me, most of the html coding stuff is still a bit new to me, but I should be able to get up to speed over the next few weeks. Maybe a little longer as my big comp exam is next week.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
SirAndy
post Sep 5 2012, 02:30 PM
Post #8


Resident German
*************************

Group: Admin
Posts: 42,207
Joined: 21-January 03
From: Oakland, Kalifornia
Member No.: 179
Region Association: Northern California



QUOTE(ThePaintedMan @ Sep 5 2012, 01:25 PM) *

I figured I wasn't the first to bring this up (IMG:style_emoticons/default/smile.gif)

Andy, do you have an offline database already started then? I'll have to look into integrating an online point-and-click DB using something like Google Docs to allow people to automatically update it. Forgive me, most of the html coding stuff is still a bit new to me, but I should be able to get up to speed over the next few weeks. Maybe a little longer as my big comp exam is next week.

The database is MySql, the Lat/Lng is exported to JSON when needed and the map page reads the JSON from the server using AJAX.
Everything else is Google Maps using API v2, which will become deprecated soon and should probably be converted to API v3.

Adding locations is easy, i already have code to allow members to drag&drop an icon anywhere on the map which then would be saved as their Lat/Lng.
The idea was to also support uploads of car images and some text info.

None of this is hard to do, i just don't have the time right now ...
(IMG:style_emoticons/default/type.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
ericoneal
post Sep 5 2012, 02:43 PM
Post #9


Member
**

Group: Members
Posts: 320
Joined: 13-August 12
From: Crestwood, KY
Member No.: 14,795
Region Association: South East States



This would be a great Google Fusion Tables app..
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
bigkensteele
post Sep 5 2012, 05:43 PM
Post #10


Major Member
****

Group: Members
Posts: 2,200
Joined: 30-August 04
From: Cincinnati, OH
Member No.: 2,660
Region Association: South East States



This would be great if you can pull it together! I really miss the old one.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Elliot Cannon
post Sep 5 2012, 05:53 PM
Post #11


914 Guru
*****

Group: Retired Members
Posts: 8,487
Joined: 29-December 06
From: Paso Robles Ca. (Central coast)
Member No.: 7,407
Region Association: None



We used to also have a phone list. I believe it was name, city and phone number. Also, what tools you had. ie A lift, jack stands, tools, spare parts etc. Something like that would come in handy when you break down in a strange city. I can start with mine. Elliot Cannon, Paso Robles California (central coast). Scissor lift. Jack stands. Tools and limited expertise. I also have a pickup to tow you with if needed.
Cheers, Elliot
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Mike Bellis
post Sep 5 2012, 06:44 PM
Post #12


Resident Electrician
*****

Group: Members
Posts: 8,347
Joined: 22-June 09
From: Midlothian TX
Member No.: 10,496
Region Association: None



Due to privacy and security issues, maybe just use a zip code data base.

I don't mind if most members know where I live exactly but I'm not sure I want them all to know since I don't know all of you. But my zip code is 94583. Which I think is harmless.

If anyone wants to know exactly where I live just PM me and I'll send you the address and my schedule when I'm not home. I can leave a key under the mat too so you won't have to break in... (IMG:style_emoticons/default/biggrin.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Andyrew
post Sep 5 2012, 06:47 PM
Post #13


Spooling.... Please wait
**********

Group: Members
Posts: 13,378
Joined: 20-January 03
From: Riverbank, Ca
Member No.: 172
Region Association: Northern California



^ I agree.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
SirAndy
post Sep 5 2012, 07:53 PM
Post #14


Resident German
*************************

Group: Admin
Posts: 42,207
Joined: 21-January 03
From: Oakland, Kalifornia
Member No.: 179
Region Association: Northern California



QUOTE(kg6dxn @ Sep 5 2012, 05:44 PM) *

Due to privacy and security issues, maybe just use a zip code data base.

I don't mind if most members know where I live exactly but I'm not sure I want them all to know since I don't know all of you. But my zip code is 94583. Which I think is harmless.

If anyone wants to know exactly where I live just PM me and I'll send you the address and my schedule when I'm not home. I can leave a key under the mat too so you won't have to break in... (IMG:style_emoticons/default/biggrin.gif)

You are over-thinking this ... (IMG:style_emoticons/default/rolleyes.gif)

No one cares about your address or street. With the way i wanted the map to work, *you* are in control of where you place the icon.
Put it in the town center or off the shore in the bay or in front of the house of the guy you can't stand.

The whole map idea is more about who is in what general area of the country (or world).
(IMG:style_emoticons/default/shades.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
bigkensteele
post Sep 5 2012, 08:24 PM
Post #15


Major Member
****

Group: Members
Posts: 2,200
Joined: 30-August 04
From: Cincinnati, OH
Member No.: 2,660
Region Association: South East States



QUOTE(SirAndy @ Sep 5 2012, 05:53 PM) *

QUOTE(kg6dxn @ Sep 5 2012, 05:44 PM) *

Due to privacy and security issues, maybe just use a zip code data base.

I don't mind if most members know where I live exactly but I'm not sure I want them all to know since I don't know all of you. But my zip code is 94583. Which I think is harmless.

If anyone wants to know exactly where I live just PM me and I'll send you the address and my schedule when I'm not home. I can leave a key under the mat too so you won't have to break in... (IMG:style_emoticons/default/biggrin.gif)

You are over-thinking this ... (IMG:style_emoticons/default/rolleyes.gif)

No one cares about your address or street. With the way i wanted the map to work, *you* are in control of where you place the icon.
Put it in the town center or off the shore in the bay or in front of the house of the guy you can't stand.

The whole map idea is more about who is in what general area of the country (or world).
(IMG:style_emoticons/default/shades.gif)

(IMG:style_emoticons/default/agree.gif) It would be nice to know who is within a 50 - 100 mile radius of me. I don't need to see the Google Maps image of their home to decide whether or not I want to affiliate with them.

It would come in handy to have the ability to contact a local group of folks without starting a thread in the Garage and hoping that everyone in the area notices the thread before it goes to page 4.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Dr Evil
post Sep 5 2012, 08:36 PM
Post #16


Send me your transmission!
***************

Group: Members
Posts: 23,038
Joined: 21-November 03
From: Loveland, OH 45140
Member No.: 1,372
Region Association: MidAtlantic Region



QUOTE(rgolia @ Sep 5 2012, 04:03 PM) *

sounds great...we use GIS a lot at my work. Great tool. I am in PA and I do not know how many 914 owners are near me.


It would help if you posted WHAT part of PA you lived in. Its a big state and plenty of us in it (IMG:style_emoticons/default/wink.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Mike Bellis
post Sep 5 2012, 08:37 PM
Post #17


Resident Electrician
*****

Group: Members
Posts: 8,347
Joined: 22-June 09
From: Midlothian TX
Member No.: 10,496
Region Association: None



QUOTE(SirAndy @ Sep 5 2012, 06:53 PM) *

You are over-thinking this ... (IMG:style_emoticons/default/rolleyes.gif)

I do that a lot.

Along with speaking my mind and pissing people off... (IMG:style_emoticons/default/happy11.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
Rob-O
post Sep 5 2012, 09:43 PM
Post #18


Senior Member
***

Group: Members
Posts: 1,271
Joined: 5-December 03
From: Mansfield, TX
Member No.: 1,419
Region Association: Southwest Region



So just for clarification, you aren't pulling everyone's info that they already have in their profile and putting that into GIS? Instead, the map starts off empty and members have to personally add whatever location information they see fit to release?
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
SirAndy
post Sep 5 2012, 10:54 PM
Post #19


Resident German
*************************

Group: Admin
Posts: 42,207
Joined: 21-January 03
From: Oakland, Kalifornia
Member No.: 179
Region Association: Northern California



QUOTE(Rob-O @ Sep 5 2012, 08:43 PM) *

So just for clarification, you aren't pulling everyone's info that they already have in their profile and putting that into GIS? Instead, the map starts off empty and members have to personally add whatever location information they see fit to release?

Correct ...

(IMG:style_emoticons/default/chowtime.gif)
User is offlineProfile CardPM
Go to the top of the page
+Quote Post
matthepcat
post Sep 6 2012, 08:16 AM
Post #20


Meat Popsicle
***

Group: Members
Posts: 1,462
Joined: 13-December 09
From: Saratoga CA
Member No.: 11,125
Region Association: Northern California



Cool idea.
User is offlineProfile CardPM
Go to the top of the page
+Quote Post

2 Pages V  1 2 >
Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



- Lo-Fi Version Time is now: 12th May 2025 - 05:32 PM