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