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

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