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