±Recent Visitors

Recent Visitors to Com-Central!

±User Info-big


Welcome Anonymous

Nickname
Password

Membership:
Latest: cgsimpson
New Today: 0
New Yesterday: 0
Overall: 6645

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