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