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