±Recent Visitors

Recent Visitors to Com-Central!

±User Info-big


Welcome Anonymous

Nickname
Password

Membership:
Latest: HighestAce
New Today: 0
New Yesterday: 0
Overall: 6648

People Online:
Members: 0
Visitors: 800
Total: 800
Who Is Where:
 Visitors:
01: Community Forums
02: Home
03: Community Forums
04: Downloads
05: Community Forums
06: Home
07: Community Forums
08: Home
09: Home
10: Photo Gallery
11: Home
12: Community Forums
13: Home
14: Home
15: Home
16: News Archive
17: Photo Gallery
18: Home
19: Photo Gallery
20: Statistics
21: Home
22: Community Forums
23: Photo Gallery
24: Community Forums
25: Community Forums
26: Photo Gallery
27: Downloads
28: Community Forums
29: Community Forums
30: Community Forums
31: Photo Gallery
32: Home
33: Home
34: Home
35: Photo Gallery
36: Community Forums
37: Photo Gallery
38: Community Forums
39: Home
40: Home
41: Community Forums
42: Community Forums
43: Community Forums
44: Home
45: Home
46: Home
47: Community Forums
48: Community Forums
49: Community Forums
50: Home
51: Home
52: Photo Gallery
53: Community Forums
54: Photo Gallery
55: Home
56: Community Forums
57: Community Forums
58: Community Forums
59: Community Forums
60: Community Forums
61: Home
62: Community Forums
63: Community Forums
64: Community Forums
65: Photo Gallery
66: Photo Gallery
67: Downloads
68: Community Forums
69: Photo Gallery
70: Home
71: Home
72: Photo Gallery
73: Community Forums
74: Community Forums
75: Community Forums
76: Community Forums
77: Photo Gallery
78: Community Forums
79: Community Forums
80: Downloads
81: Community Forums
82: Member Screenshots
83: Member Screenshots
84: Community Forums
85: Community Forums
86: Photo Gallery
87: Photo Gallery
88: Home
89: Community Forums
90: Home
91: Downloads
92: Community Forums
93: Photo Gallery
94: Downloads
95: Home
96: Community Forums
97: Community Forums
98: Home
99: Home
100: Home
101: Home
102: Home
103: Home
104: Home
105: Home
106: Home
107: Home
108: Home
109: Home
110: Home
111: Home
112: Home
113: Home
114: Member Screenshots
115: Home
116: Home
117: Home
118: Home
119: Home
120: Community Forums
121: Home
122: Home
123: Home
124: Home
125: Community Forums
126: Home
127: Community Forums
128: Community Forums
129: Community Forums
130: Home
131: Community Forums
132: Home
133: Community Forums
134: Photo Gallery
135: Home
136: Home
137: Home
138: Home
139: Home
140: Home
141: Home
142: Home
143: Community Forums
144: Home
145: Home
146: Home
147: Home
148: Home
149: Home
150: Community Forums
151: Home
152: Home
153: Home
154: Home
155: Home
156: Home
157: Home
158: Home
159: Home
160: Home
161: Photo Gallery
162: Community Forums
163: Home
164: Community Forums
165: Community Forums
166: Community Forums
167: Community Forums
168: Home
169: Community Forums
170: Home
171: Community Forums
172: Photo Gallery
173: Home
174: Community Forums
175: Photo Gallery
176: Downloads
177: Community Forums
178: Community Forums
179: Community Forums
180: Community Forums
181: Community Forums
182: Community Forums
183: News Archive
184: Home
185: Home
186: Community Forums
187: Home
188: Home
189: Home
190: Community Forums
191: Home
192: Community Forums
193: News Archive
194: Community Forums
195: Home
196: Photo Gallery
197: Community Forums
198: Home
199: Community Forums
200: Community Forums
201: Photo Gallery
202: Home
203: Home
204: Downloads
205: Member Screenshots
206: Community Forums
207: Community Forums
208: Community Forums
209: News
210: Home
211: Community Forums
212: Home
213: Photo Gallery
214: Community Forums
215: Community Forums
216: Community Forums
217: Home
218: News
219: Community Forums
220: Community Forums
221: Community Forums
222: Photo Gallery
223: Home
224: Community Forums
225: Community Forums
226: Photo Gallery
227: Home
228: Home
229: Community Forums
230: Statistics
231: Home
232: Community Forums
233: Community Forums
234: Member Screenshots
235: Home
236: Home
237: Photo Gallery
238: Community Forums
239: Community Forums
240: Member Screenshots
241: Photo Gallery
242: Community Forums
243: Community Forums
244: Home
245: Home
246: Community Forums
247: Community Forums
248: Photo Gallery
249: Member Screenshots
250: Home
251: Community Forums
252: Home
253: Community Forums
254: Community Forums
255: Home
256: Member Screenshots
257: Photo Gallery
258: Community Forums
259: Photo Gallery
260: Community Forums
261: Community Forums
262: Home
263: Community Forums
264: Community Forums
265: Photo Gallery
266: Home
267: Home
268: Home
269: Home
270: Home
271: Home
272: Home
273: Home
274: Home
275: Home
276: Home
277: Home
278: Home
279: Home
280: Home
281: Home
282: Home
283: Home
284: Home
285: Home
286: Home
287: Home
288: Home
289: Home
290: Home
291: Home
292: Home
293: Home
294: Home
295: Home
296: Home
297: Home
298: Home
299: Home
300: Home
301: Home
302: Home
303: Home
304: Photo Gallery
305: Home
306: Home
307: Member Screenshots
308: Photo Gallery
309: Home
310: Home
311: Home
312: Home
313: Home
314: Home
315: Community Forums
316: Home
317: Home
318: Photo Gallery
319: Photo Gallery
320: Home
321: Home
322: Home
323: LinkToUs
324: Home
325: Photo Gallery
326: Home
327: Photo Gallery
328: Photo Gallery
329: Home
330: Home
331: Home
332: Home
333: News
334: Home
335: Home
336: Home
337: Home
338: Home
339: Home
340: Home
341: Home
342: Home
343: Home
344: Home
345: Home
346: Home
347: Home
348: Downloads
349: Community Forums
350: Community Forums
351: Home
352: Home
353: Home
354: Home
355: Home
356: Home
357: Home
358: Home
359: Home
360: Home
361: Home
362: Photo Gallery
363: Statistics
364: Home
365: Community Forums
366: Home
367: Community Forums
368: Downloads
369: Community Forums
370: Community Forums
371: Photo Gallery
372: Community Forums
373: Community Forums
374: Community Forums
375: Community Forums
376: Photo Gallery
377: Community Forums
378: Community Forums
379: Community Forums
380: Downloads
381: Downloads
382: Community Forums
383: Community Forums
384: Home
385: Community Forums
386: Downloads
387: Downloads
388: Community Forums
389: Community Forums
390: Photo Gallery
391: Home
392: Community Forums
393: Community Forums
394: Community Forums
395: Home
396: Home
397: Community Forums
398: Home
399: Home
400: Home
401: Home
402: Home
403: Home
404: Home
405: Downloads
406: Home
407: Photo Gallery
408: Home
409: Home
410: Home
411: Home
412: Home
413: Home
414: Home
415: Home
416: Home
417: Home
418: Community Forums
419: Downloads
420: Community Forums
421: Community Forums
422: Member Screenshots
423: Member Screenshots
424: Community Forums
425: Community Forums
426: Home
427: Community Forums
428: Home
429: Member Screenshots
430: Home
431: Community Forums
432: Home
433: Home
434: Home
435: Home
436: Home
437: Home
438: Community Forums
439: Home
440: Home
441: Home
442: Home
443: Home
444: Home
445: Home
446: Home
447: Home
448: Community Forums
449: Community Forums
450: Community Forums
451: Home
452: Community Forums
453: Community Forums
454: Home
455: Photo Gallery
456: Community Forums
457: Home
458: Community Forums
459: Community Forums
460: Community Forums
461: Community Forums
462: Photo Gallery
463: Photo Gallery
464: Photo Gallery
465: Community Forums
466: Home
467: Photo Gallery
468: Photo Gallery
469: Home
470: Home
471: Home
472: Community Forums
473: Home
474: Home
475: Home
476: Home
477: Home
478: Home
479: Home
480: Home
481: Home
482: Home
483: Home
484: Home
485: Home
486: Community Forums
487: Home
488: Home
489: Home
490: Home
491: Home
492: Home
493: Home
494: Home
495: Home
496: Downloads
497: Home
498: Home
499: Home
500: Community Forums
501: Community Forums
502: Home
503: Photo Gallery
504: Home
505: Photo Gallery
506: Home
507: Photo Gallery
508: Photo Gallery
509: Photo Gallery
510: Home
511: Community Forums
512: Photo Gallery
513: Community Forums
514: Home
515: Photo Gallery
516: Home
517: Member Screenshots
518: Home
519: Community Forums
520: Home
521: Photo Gallery
522: Photo Gallery
523: Community Forums
524: Photo Gallery
525: Community Forums
526: Photo Gallery
527: Home
528: Community Forums
529: Community Forums
530: Photo Gallery
531: Home
532: Home
533: Member Screenshots
534: Home
535: Home
536: Home
537: Home
538: Home
539: Home
540: Home
541: Home
542: Home
543: Home
544: Home
545: Home
546: Home
547: Home
548: Home
549: Home
550: Home
551: Home
552: Home
553: Photo Gallery
554: Home
555: Home
556: Home
557: Home
558: Home
559: Community Forums
560: Community Forums
561: Home
562: Community Forums
563: Community Forums
564: Home
565: Home
566: Community Forums
567: Community Forums
568: Member Screenshots
569: Home
570: Photo Gallery
571: Community Forums
572: Photo Gallery
573: Photo Gallery
574: Photo Gallery
575: Photo Gallery
576: Community Forums
577: Home
578: Community Forums
579: Community Forums
580: Community Forums
581: Member Screenshots
582: Home
583: Home
584: Photo Gallery
585: Home
586: Photo Gallery
587: Home
588: Community Forums
589: Community Forums
590: Community Forums
591: Home
592: Home
593: Home
594: Home
595: Home
596: Home
597: Home
598: Home
599: Home
600: Home
601: Home
602: Home
603: Home
604: Community Forums
605: Home
606: Home
607: Home
608: Home
609: Home
610: Home
611: Home
612: Home
613: Home
614: Home
615: Home
616: Home
617: Community Forums
618: Home
619: Home
620: Home
621: Home
622: Community Forums
623: Home
624: Home
625: Home
626: Home
627: Home
628: Home
629: Home
630: Home
631: Community Forums
632: Home
633: Home
634: Home
635: Home
636: Home
637: Home
638: Home
639: Home
640: Photo Gallery
641: Community Forums
642: Member Screenshots
643: Photo Gallery
644: Community Forums
645: Home
646: Community Forums
647: Downloads
648: Home
649: Photo Gallery
650: Photo Gallery
651: Community Forums
652: Home
653: Community Forums
654: Photo Gallery
655: Downloads
656: Home
657: Photo Gallery
658: Community Forums
659: Home
660: Home
661: Community Forums
662: Home
663: Community Forums
664: News
665: Community Forums
666: News Archive
667: Home
668: Community Forums
669: Photo Gallery
670: Community Forums
671: Community Forums
672: Community Forums
673: Community Forums
674: Your Account
675: Home
676: Community Forums
677: Community Forums
678: Community Forums
679: Community Forums
680: News
681: Community Forums
682: Home
683: Home
684: Home
685: Home
686: Home
687: Home
688: Photo Gallery
689: Home
690: Photo Gallery
691: Home
692: Home
693: Home
694: Home
695: Home
696: Home
697: Home
698: Home
699: Home
700: Home
701: Home
702: Home
703: Home
704: Home
705: Community Forums
706: Home
707: Home
708: Home
709: Home
710: Home
711: Home
712: Home
713: Community Forums
714: Member Screenshots
715: Community Forums
716: Community Forums
717: Community Forums
718: Member Screenshots
719: Downloads
720: Photo Gallery
721: Community Forums
722: Community Forums
723: Photo Gallery
724: Community Forums
725: Home
726: Photo Gallery
727: Home
728: Community Forums
729: Community Forums
730: Photo Gallery
731: Home
732: Community Forums
733: Member Screenshots
734: Community Forums
735: Home
736: Home
737: Home
738: Home
739: Home
740: Home
741: Home
742: Member Screenshots
743: Home
744: Home
745: Home
746: Home
747: Home
748: Home
749: Photo Gallery
750: Home
751: Photo Gallery
752: Home
753: Home
754: Home
755: Home
756: Home
757: Photo Gallery
758: Community Forums
759: Home
760: Home
761: Community Forums
762: Downloads
763: Photo Gallery
764: Member Screenshots
765: Photo Gallery
766: Member Screenshots
767: Home
768: Community Forums
769: Community Forums
770: Community Forums
771: Home
772: Community Forums
773: Photo Gallery
774: Home
775: Community Forums
776: Photo Gallery
777: Community Forums
778: Community Forums
779: Home
780: Home
781: Photo Gallery
782: Community Forums
783: Home
784: Home
785: Downloads
786: Community Forums
787: Photo Gallery
788: Home
789: Member Screenshots
790: Photo Gallery
791: Photo Gallery
792: Downloads
793: Photo Gallery
794: Photo Gallery
795: Home
796: Community Forums
797: News Archive
798: Photo Gallery
799: Community Forums
800: Community Forums

Staff Online:

No staff members are online!
About AFV databases, locations, regions and the like
The AFV ASSOCIATION was formed in 1964 to support the thoughts and research of all those interested in Armored Fighting Vehicles and related topics, such as AFV drawings. The emphasis has always been on sharing information and communicating with other members of similar interests; e.g. German armor, Japanese AFVs, or whatever.
Go to page 1, 2  Next
Post new topic    Reply to topic    Printer Friendly Page     Forum Index ›  AFV News Discussion Board

View previous topic :: View next topic  
Author Message
Massimo_Foti
Power User

Offline Offline
Joined: Apr 08, 2008
Posts: 5397
Location: Lugano, Switzerland
PostPosted: Tue Dec 22, 2009 11:56 am
Post subject: About AFV databases, locations, regions and the like

I am looking into a project that will require a database storing locations and historical AFVs. In order to refine my ideas I have been looking at existing country registers for the USA, Canada, Belgium, France and Poland (thank you guys for the hard work!).

I see they all group locations by states/regions/provinces. Now, I am not sure I always agree with this approach. Grouping things by state in the USA is a good thing for sure, it's a huge country with too many locations, but I wonder if it's worth doing the same for other countries too. I know for sure it's not worth splitting Switzerland into cantons, and I believe it would be overkill to split Italy in 20 regions while I have to handle 70 locations at most.

On top of that I assume many foreign people will have no idea about where swiss cantons or italian regions are located, just like I know almost nothing about french regions, belgian provinces or german lands.

Since this is going to be a web-based project, I think I could do something along the lines of what Trevor is doing on preservedtanks.com, leveraging Googlemaps and storing data for states only for USA based locations.

What do you think about it, do you feel the need to group locations by region/canton/district even outside the USA?

Thanks in advance for any feedback

Massimo
Back to top
View user's profile
L.Delsing
Power User

Offline Offline
Joined: Feb 10, 2006
Posts: 960

PostPosted: Tue Dec 22, 2009 12:44 pm
Post subject: Re: About AFV databases, locations, regions and the like

Hello Massimo,
I have put everything (only MBTs) in a access database and don't use word or so anymore



I have a column in this database for the province/region/canton etc, but I almost never use it. But when needed it is there. There are more columns with various details which are not on the picture.

Regards,
Lesley


Last edited by L.Delsing on Tue Dec 22, 2009 3:05 pm; edited 2 times in total
Back to top
View user's profile
JimWeb
Power User

Offline Offline
Joined: Jan 24, 2006
Posts: 1439
Location: The back of beyond
PostPosted: Tue Dec 22, 2009 1:24 pm
Post subject: Re: About AFV databases, locations, regions and the like

I have an iPhone version coming out soon as part of my JED app (its about to go to iTunes for approval) and I am listing monuments by country, region, town/city, address in that order. Probably best to include include the region as quite a few countries have locations with similar names.

One of the other things that will be included in the next version will be an equipment identifier...

_________________
TTFN
Jim

If your not a member of JED then your
not serious about anything military..

***********************
www.jedsite.info
JED Military Equipment
***********************
Back to top
View user's profile Visit poster's website ICQ Number
the_shadock
Power User

Offline Offline
Joined: May 27, 2006
Posts: 2865
Location: Normandy, France
PostPosted: Tue Dec 22, 2009 7:46 pm
Post subject: Re: About AFV databases, locations, regions and the like

- Massimo_Foti
What do you think about it, do you feel the need to group locations by region/canton/district even outside the USA?


Outside the USA I don't know, but for Russia and France you will need at least the regions.

In France, some towns have the same name from a department to another.. sometimes the only way to differentiate a town from another is to have the department number, but the most reliable piece of information is the postal code, so that you are sure it's the good location (there are 100 departments in France, incl. overseas).

P-O

_________________
soldat_ryan @ hotmail.com

Looking for photos of Sherman manufacturer's plates
Back to top
View user's profile Send e-mail Visit poster's website MSN Messenger
bsmart
Power User

Offline Offline
Joined: Jan 23, 2006
Posts: 2523
Location: Central Maryland
PostPosted: Tue Dec 22, 2009 8:28 pm
Post subject: Re: About AFV databases, locations, regions and the like

I think including something like postal codes is good also. In the U.S. there are sometimes variations of twon or city names but having the 5 digit ZIP code assigned by the post office can tell you if they are the same. It can also help you determine what towns in larger states (like Texas, California, New York, etc) are nearby and worth trying to see in the same trip or if they are on the other side of the state. (They also can help you find locations that are just across stae lines from where you are) I think most countries have some form of postal code.

Oh and of course LAT/LONG is always useful with GPS and Google maps

_________________
Bob Smart ([email protected])
Back to top
View user's profile Send e-mail
Massimo_Foti
Power User

Offline Offline
Joined: Apr 08, 2008
Posts: 5397
Location: Lugano, Switzerland
PostPosted: Tue Dec 22, 2009 8:42 pm
Post subject: Re: About AFV databases, locations, regions and the like

Thanks all for the feedback. I understimate the issue of places with similar/same name. I think I'll go with postal codes, because in order to properly handle regions/cantons/departments and referential integritty, I would have to list all of them inside a separated table that have to be populated upfront.

Massimo
Back to top
View user's profile
JimWeb
Power User

Offline Offline
Joined: Jan 24, 2006
Posts: 1439
Location: The back of beyond
PostPosted: Tue Dec 22, 2009 9:21 pm
Post subject: Re: About AFV databases, locations, regions and the like

So we need to encourage people to post the gogglemaps link & the GPS co-ordinates!

_________________
TTFN
Jim

If your not a member of JED then your
not serious about anything military..

***********************
www.jedsite.info
JED Military Equipment
***********************
Back to top
View user's profile Visit poster's website ICQ Number
Massimo_Foti
Power User

Offline Offline
Joined: Apr 08, 2008
Posts: 5397
Location: Lugano, Switzerland
PostPosted: Tue Dec 22, 2009 9:45 pm
Post subject: Re: About AFV databases, locations, regions and the like

Sure! I keep a little personal googlemap of places I visited or would like to visit:
maps.google.com/maps/m...d69b3f&z=4

Feel free to ask if you have questions about some less-know italian or swiss places

Massimo
Back to top
View user's profile
armyjunk2
Power User

Offline Offline
Joined: Sep 22, 2006
Posts: 1416

PostPosted: Tue Dec 22, 2009 9:51 pm
Post subject: Re: About AFV databases, locations, regions and the like

I like Access due to the ability to sort in many different ways, it can be sorted by any of the columns and the hyperlink feature for photos. I use it for my WWI artillery list.

Back to top
View user's profile
the_shadock
Power User

Offline Offline
Joined: May 27, 2006
Posts: 2865
Location: Normandy, France
PostPosted: Tue Dec 22, 2009 10:56 pm
Post subject: Re: About AFV databases, locations, regions and the like

- Massimo_Foti
Thanks all for the feedback. I understimate the issue of places with similar/same name.


just a typical example, for France.

If you want to go from Armancourt (80700) to Armancourt (60880), you have to drive 47 kilometers :



and I have other examples of the same problem//

FORTUNATELY THERE ARE NO TANKS AT ARMANCOURT

P-O

_________________
soldat_ryan @ hotmail.com

Looking for photos of Sherman manufacturer's plates
Back to top
View user's profile Send e-mail Visit poster's website MSN Messenger
Joe_D
Power User

Offline Offline
Joined: Jan 29, 2006
Posts: 2069
Location: Razorback Country
PostPosted: Tue Dec 22, 2009 11:07 pm
Post subject: Re: About AFV databases, locations, regions and the like

So we need to encourage people to post the gogglemaps link & the GPS co-ordinates!


I may not post a Google map but I do post the co-ordinates Smile .

I know it's kinda lazy, but I don't even bother getting street addresses anymore, since those can be very confusing. Google/Bing/Mapquest don't give exact locations for them either.

_________________
Joe_D
Back to top
View user's profile Photo Gallery
L.Delsing
Power User

Offline Offline
Joined: Feb 10, 2006
Posts: 960

PostPosted: Wed Dec 23, 2009 8:17 am
Post subject: Re: About AFV databases, locations, regions and the like

@ Armyjunk2: how do you make the hyperlink to your pictures?

@ Joe D: coordinates are indeed very nice, especially in the field. Instead of ''tank located at training area x'' you have an exact location!
regards,
Lesley
Back to top
View user's profile
Tichenor
Power User

Offline Offline
Joined: Dec 06, 2007
Posts: 461
Location: Antwerp
PostPosted: Wed Dec 23, 2009 2:08 pm
Post subject: Re: About AFV databases, locations, regions and the like

Hi Massimo

The region/state/province question is the same i had last year (or the year before that), my conclusion was almost the same as what P-O says. For instance Kapellen in Belgium (alot of armour there) There are two or three of them in Belgium, without the province (or the postal code) you will be driving a lot around Belgium. Coordinates are great, only there are some locations the governement is't very happy about when they are published. So that gets us back to the state/province/region or the postal code.

Michel
Back to top
View user's profile Visit poster's website Photo Gallery
Michel_Krauss
Power User

Offline Offline
Joined: Oct 30, 2009
Posts: 953
Location: Zuid-Holland, The Netherlands
PostPosted: Wed Dec 23, 2009 3:21 pm
Post subject: Re: About AFV databases, locations, regions and the like

Coordinates are great, only there are some locations the governement is't very happy about when they are published.


If the goverment is not to happy about publishing some locations, they also will not be happy when some-one show's up uninvited
Not even considering the fact that the person may starts taking picture's

In my opinion the big disadvantage of using postal codes or similair, you will need the internet to get an location
And even then it will be very hard to find because they are an national thing
I have tried it with my own postal code at Google.co.uk (so an English site and not Dutch) and my home town is not within the first 100 hits
And I know where to find it, so it is not suited for international use

You will need something that can be used in combination with an travel guide like Garmin or TomTom

So geographic coordinates or street, town, etc
Then people can use it during vacation, whatever

If some-one want to try an postalcode in Holland: 5825 AM
Michel aka Tichenor, you will find it Wink

Michel

_________________
I'm Not Crazy, I'm Just Not You
Back to top
View user's profile
Tichenor
Power User

Offline Offline
Joined: Dec 06, 2007
Posts: 461
Location: Antwerp
PostPosted: Wed Dec 23, 2009 3:34 pm
Post subject: Re: About AFV databases, locations, regions and the like

Michel

easy, even not so far from where I live ( should I mention it's Overloon?)

What I wanted to say with the governement thing is that here in Belgium every army base has open doors, public days and so one. Easy to get the coordinates then ( and pictures), but the latest time there are people thinking google earth and stuff like that is maybe not such a great thing. I know Holland has the same "problem".

michel
Back to top
View user's profile Visit poster's website Photo Gallery
Display posts from previous:   
Post new topic    Reply to topic    Printer Friendly Page    Forum Index ›  AFV News Discussion Board
Page 1 of 2
All times are GMT - 6 Hours
Go to page 1, 2  Next



Jump to:  


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum