±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: 1046
Total: 1046
Who Is Where:
 Visitors:
01: Community Forums
02: Community Forums
03: Community Forums
04: Home
05: Community Forums
06: Downloads
07: Community Forums
08: Member Screenshots
09: Community Forums
10: Community Forums
11: Downloads
12: Downloads
13: Community Forums
14: Community Forums
15: News
16: Community Forums
17: Member Screenshots
18: Home
19: Photo Gallery
20: Photo Gallery
21: Community Forums
22: Member Screenshots
23: Community Forums
24: Home
25: Home
26: Community Forums
27: Community Forums
28: Home
29: Community Forums
30: Downloads
31: Home
32: Community Forums
33: Community Forums
34: Community Forums
35: Community Forums
36: Community Forums
37: Community Forums
38: Home
39: Home
40: Photo Gallery
41: Photo Gallery
42: Community Forums
43: Community Forums
44: Photo Gallery
45: Community Forums
46: Community Forums
47: Home
48: Community Forums
49: Community Forums
50: Photo Gallery
51: Community Forums
52: News Archive
53: Photo Gallery
54: Community Forums
55: Community Forums
56: Community Forums
57: Community Forums
58: Community Forums
59: Community Forums
60: Community Forums
61: Community Forums
62: Community Forums
63: Home
64: Community Forums
65: Member Screenshots
66: Photo Gallery
67: Home
68: Member Screenshots
69: Community Forums
70: Home
71: Statistics
72: Community Forums
73: Home
74: Home
75: Community Forums
76: Home
77: Community Forums
78: Community Forums
79: Community Forums
80: Community Forums
81: Downloads
82: Home
83: Community Forums
84: Community Forums
85: Home
86: Member Screenshots
87: Community Forums
88: Community Forums
89: Photo Gallery
90: Community Forums
91: Member Screenshots
92: Photo Gallery
93: Photo Gallery
94: Community Forums
95: Photo Gallery
96: Home
97: Downloads
98: Community Forums
99: Member Screenshots
100: Photo Gallery
101: Community Forums
102: Community Forums
103: Photo Gallery
104: Community Forums
105: Community Forums
106: Community Forums
107: Community Forums
108: Member Screenshots
109: Community Forums
110: Community Forums
111: Home
112: Community Forums
113: Community Forums
114: Member Screenshots
115: Photo Gallery
116: Community Forums
117: Member Screenshots
118: Community Forums
119: Downloads
120: Downloads
121: Community Forums
122: Photo Gallery
123: Community Forums
124: Community Forums
125: Community Forums
126: Community Forums
127: Home
128: Downloads
129: Member Screenshots
130: Community Forums
131: Home
132: Community Forums
133: Home
134: Community Forums
135: Photo Gallery
136: Community Forums
137: Community Forums
138: Photo Gallery
139: Home
140: Home
141: Community Forums
142: Community Forums
143: Photo Gallery
144: Community Forums
145: Community Forums
146: Community Forums
147: Community Forums
148: Community Forums
149: Downloads
150: Your Account
151: Community Forums
152: Community Forums
153: Community Forums
154: Home
155: Community Forums
156: Statistics
157: Community Forums
158: Community Forums
159: Photo Gallery
160: Community Forums
161: Home
162: Member Screenshots
163: Photo Gallery
164: Home
165: Home
166: Community Forums
167: Community Forums
168: Member Screenshots
169: Downloads
170: Community Forums
171: Community Forums
172: Community Forums
173: Home
174: Community Forums
175: Home
176: News Archive
177: Community Forums
178: Home
179: Community Forums
180: Home
181: Photo Gallery
182: Community Forums
183: Member Screenshots
184: Photo Gallery
185: Downloads
186: Community Forums
187: Home
188: Your Account
189: Photo Gallery
190: News Archive
191: News
192: Photo Gallery
193: Photo Gallery
194: Member Screenshots
195: News
196: Member Screenshots
197: Downloads
198: Member Screenshots
199: Home
200: Community Forums
201: Home
202: Member Screenshots
203: News
204: News
205: Home
206: Photo Gallery
207: Community Forums
208: Photo Gallery
209: Community Forums
210: Community Forums
211: Photo Gallery
212: Photo Gallery
213: Community Forums
214: Community Forums
215: Photo Gallery
216: Community Forums
217: Community Forums
218: Community Forums
219: News Archive
220: Community Forums
221: Home
222: Member Screenshots
223: Downloads
224: Home
225: Home
226: Community Forums
227: Community Forums
228: Community Forums
229: Community Forums
230: Home
231: Community Forums
232: Photo Gallery
233: Home
234: Home
235: Photo Gallery
236: Community Forums
237: Community Forums
238: Community Forums
239: Community Forums
240: Community Forums
241: Community Forums
242: Community Forums
243: Member Screenshots
244: Community Forums
245: Community Forums
246: Community Forums
247: Community Forums
248: Community Forums
249: News Archive
250: Home
251: News Archive
252: Community Forums
253: Photo Gallery
254: Your Account
255: Downloads
256: Community Forums
257: Home
258: News
259: Community Forums
260: Home
261: Community Forums
262: Community Forums
263: Community Forums
264: Community Forums
265: Community Forums
266: Home
267: Home
268: Home
269: Photo Gallery
270: Community Forums
271: Home
272: Community Forums
273: Member Screenshots
274: Your Account
275: Community Forums
276: Community Forums
277: Community Forums
278: News
279: Community Forums
280: Photo Gallery
281: Community Forums
282: Community Forums
283: Member Screenshots
284: Community Forums
285: Community Forums
286: Photo Gallery
287: Community Forums
288: Downloads
289: Community Forums
290: Home
291: Home
292: Community Forums
293: Community Forums
294: Home
295: Photo Gallery
296: Community Forums
297: Downloads
298: Photo Gallery
299: Community Forums
300: Community Forums
301: Photo Gallery
302: Community Forums
303: Member Screenshots
304: Community Forums
305: Photo Gallery
306: Community Forums
307: Community Forums
308: News Archive
309: Community Forums
310: Community Forums
311: Home
312: Home
313: Community Forums
314: Community Forums
315: News Archive
316: Community Forums
317: Photo Gallery
318: Photo Gallery
319: Community Forums
320: Member Screenshots
321: Community Forums
322: Your Account
323: Community Forums
324: Home
325: Community Forums
326: Community Forums
327: Community Forums
328: Community Forums
329: Community Forums
330: Photo Gallery
331: Home
332: Community Forums
333: Home
334: Home
335: Photo Gallery
336: Community Forums
337: Community Forums
338: Community Forums
339: Community Forums
340: Community Forums
341: Your Account
342: Community Forums
343: Community Forums
344: Community Forums
345: Community Forums
346: Community Forums
347: Community Forums
348: News Archive
349: Community Forums
350: Photo Gallery
351: Community Forums
352: Member Screenshots
353: News
354: Photo Gallery
355: Home
356: Community Forums
357: Community Forums
358: Home
359: Community Forums
360: Community Forums
361: Member Screenshots
362: Community Forums
363: Your Account
364: Community Forums
365: Photo Gallery
366: Your Account
367: Community Forums
368: Community Forums
369: Home
370: Community Forums
371: Home
372: Community Forums
373: Photo Gallery
374: Home
375: Photo Gallery
376: Supporters
377: Member Screenshots
378: Member Screenshots
379: Community Forums
380: News
381: Statistics
382: Member Screenshots
383: Community Forums
384: Community Forums
385: Community Forums
386: Community Forums
387: Community Forums
388: Community Forums
389: Home
390: Member Screenshots
391: Home
392: Community Forums
393: Photo Gallery
394: Community Forums
395: Community Forums
396: Downloads
397: Downloads
398: Photo Gallery
399: Community Forums
400: Community Forums
401: Community Forums
402: Community Forums
403: Community Forums
404: Community Forums
405: Community Forums
406: Community Forums
407: Downloads
408: Community Forums
409: Community Forums
410: Community Forums
411: Photo Gallery
412: Home
413: Community Forums
414: Community Forums
415: Community Forums
416: Community Forums
417: Downloads
418: Community Forums
419: Community Forums
420: Downloads
421: Member Screenshots
422: Home
423: Home
424: Photo Gallery
425: News Archive
426: Community Forums
427: Home
428: Home
429: Home
430: Community Forums
431: Community Forums
432: Community Forums
433: Community Forums
434: Home
435: Member Screenshots
436: Community Forums
437: Community Forums
438: Community Forums
439: News
440: Photo Gallery
441: Community Forums
442: Community Forums
443: Home
444: Community Forums
445: Member Screenshots
446: Community Forums
447: Home
448: Community Forums
449: Community Forums
450: Photo Gallery
451: Community Forums
452: Community Forums
453: Home
454: Photo Gallery
455: Community Forums
456: Photo Gallery
457: Photo Gallery
458: Community Forums
459: Photo Gallery
460: Photo Gallery
461: Member Screenshots
462: Member Screenshots
463: Photo Gallery
464: News Archive
465: Home
466: Community Forums
467: Community Forums
468: Community Forums
469: Community Forums
470: Community Forums
471: Community Forums
472: Community Forums
473: Photo Gallery
474: Photo Gallery
475: Photo Gallery
476: Photo Gallery
477: Photo Gallery
478: Photo Gallery
479: Photo Gallery
480: Community Forums
481: Photo Gallery
482: Home
483: Community Forums
484: Community Forums
485: Community Forums
486: Home
487: Home
488: Downloads
489: Community Forums
490: Photo Gallery
491: Member Screenshots
492: Member Screenshots
493: Photo Gallery
494: Community Forums
495: Community Forums
496: Community Forums
497: Community Forums
498: Community Forums
499: Community Forums
500: Home
501: Community Forums
502: Community Forums
503: Downloads
504: Member Screenshots
505: Downloads
506: Photo Gallery
507: Downloads
508: Community Forums
509: Community Forums
510: Community Forums
511: News Archive
512: Community Forums
513: Community Forums
514: Photo Gallery
515: Community Forums
516: Member Screenshots
517: Community Forums
518: Home
519: Home
520: Your Account
521: Community Forums
522: Community Forums
523: Community Forums
524: Community Forums
525: News Archive
526: Downloads
527: Photo Gallery
528: News Archive
529: News Archive
530: Photo Gallery
531: Community Forums
532: Member Screenshots
533: Community Forums
534: Community Forums
535: Community Forums
536: Community Forums
537: Community Forums
538: Photo Gallery
539: Community Forums
540: Home
541: Community Forums
542: Photo Gallery
543: Photo Gallery
544: Community Forums
545: Community Forums
546: Community Forums
547: Community Forums
548: Community Forums
549: Photo Gallery
550: Community Forums
551: Community Forums
552: Community Forums
553: Community Forums
554: News Archive
555: Photo Gallery
556: Home
557: News
558: Statistics
559: News Archive
560: News Archive
561: Community Forums
562: Downloads
563: Community Forums
564: Photo Gallery
565: Downloads
566: Community Forums
567: Downloads
568: Community Forums
569: Photo Gallery
570: Member Screenshots
571: Photo Gallery
572: Community Forums
573: Photo Gallery
574: Community Forums
575: Photo Gallery
576: Community Forums
577: Community Forums
578: Downloads
579: Statistics
580: Downloads
581: Home
582: Community Forums
583: News Archive
584: Photo Gallery
585: Community Forums
586: Community Forums
587: Community Forums
588: Photo Gallery
589: Community Forums
590: Community Forums
591: Photo Gallery
592: Downloads
593: Community Forums
594: Community Forums
595: Photo Gallery
596: Photo Gallery
597: Member Screenshots
598: Community Forums
599: Community Forums
600: Community Forums
601: Community Forums
602: News Archive
603: Community Forums
604: News
605: Community Forums
606: Community Forums
607: Home
608: Home
609: Home
610: Home
611: Community Forums
612: Community Forums
613: Community Forums
614: Community Forums
615: Community Forums
616: Home
617: Community Forums
618: Community Forums
619: Community Forums
620: Home
621: Photo Gallery
622: News
623: Photo Gallery
624: Community Forums
625: Community Forums
626: News Archive
627: Community Forums
628: Community Forums
629: Home
630: Community Forums
631: Community Forums
632: Community Forums
633: Community Forums
634: Home
635: Community Forums
636: Photo Gallery
637: Home
638: Community Forums
639: Downloads
640: Community Forums
641: Home
642: Member Screenshots
643: Community Forums
644: Community Forums
645: Community Forums
646: Community Forums
647: Community Forums
648: Community Forums
649: Community Forums
650: Community Forums
651: Community Forums
652: Photo Gallery
653: Community Forums
654: Community Forums
655: Community Forums
656: Home
657: Downloads
658: News
659: Home
660: Community Forums
661: Community Forums
662: Community Forums
663: Member Screenshots
664: Photo Gallery
665: News Archive
666: Community Forums
667: News Archive
668: News Archive
669: Community Forums
670: Community Forums
671: Home
672: News Archive
673: Home
674: Community Forums
675: Photo Gallery
676: Home
677: Statistics
678: Statistics
679: Community Forums
680: Home
681: Home
682: Community Forums
683: Member Screenshots
684: Community Forums
685: Community Forums
686: Community Forums
687: Community Forums
688: Community Forums
689: Photo Gallery
690: Community Forums
691: Home
692: Home
693: Community Forums
694: Community Forums
695: Photo Gallery
696: News
697: Community Forums
698: Treasury
699: Photo Gallery
700: Community Forums
701: Downloads
702: Community Forums
703: Home
704: Photo Gallery
705: Downloads
706: Community Forums
707: Community Forums
708: Home
709: Home
710: Home
711: Community Forums
712: Downloads
713: Member Screenshots
714: Community Forums
715: Downloads
716: Member Screenshots
717: Home
718: Home
719: Community Forums
720: Downloads
721: Community Forums
722: Photo Gallery
723: Home
724: Community Forums
725: Community Forums
726: Community Forums
727: Photo Gallery
728: Downloads
729: Community Forums
730: News Archive
731: Home
732: Community Forums
733: Home
734: Photo Gallery
735: Community Forums
736: Home
737: Home
738: Community Forums
739: Community Forums
740: Community Forums
741: Community Forums
742: Home
743: Member Screenshots
744: Statistics
745: Home
746: Community Forums
747: Member Screenshots
748: Photo Gallery
749: Community Forums
750: Member Screenshots
751: Community Forums
752: Member Screenshots
753: Home
754: Home
755: Member Screenshots
756: Community Forums
757: Downloads
758: Community Forums
759: Community Forums
760: Community Forums
761: Community Forums
762: Community Forums
763: Photo Gallery
764: News Archive
765: Community Forums
766: Photo Gallery
767: Community Forums
768: Community Forums
769: Community Forums
770: Community Forums
771: Photo Gallery
772: Member Screenshots
773: Photo Gallery
774: Community Forums
775: Community Forums
776: Member Screenshots
777: Community Forums
778: Home
779: Downloads
780: Home
781: News
782: Downloads
783: Downloads
784: Community Forums
785: Member Screenshots
786: Community Forums
787: Member Screenshots
788: Community Forums
789: Member Screenshots
790: Community Forums
791: Home
792: Photo Gallery
793: Photo Gallery
794: Community Forums
795: Community Forums
796: Community Forums
797: Community Forums
798: Community Forums
799: Community Forums
800: Downloads
801: Home
802: Member Screenshots
803: Home
804: Home
805: Community Forums
806: Community Forums
807: Community Forums
808: Community Forums
809: Downloads
810: Photo Gallery
811: Photo Gallery
812: Community Forums
813: Community Forums
814: Member Screenshots
815: Community Forums
816: Photo Gallery
817: Photo Gallery
818: Photo Gallery
819: Home
820: Member Screenshots
821: Community Forums
822: News
823: Community Forums
824: Member Screenshots
825: News Archive
826: Community Forums
827: Downloads
828: Community Forums
829: Community Forums
830: Community Forums
831: Member Screenshots
832: Home
833: Photo Gallery
834: Community Forums
835: Downloads
836: Home
837: Photo Gallery
838: Community Forums
839: Community Forums
840: Community Forums
841: Community Forums
842: Member Screenshots
843: Community Forums
844: Home
845: Community Forums
846: Community Forums
847: Home
848: Photo Gallery
849: Community Forums
850: Community Forums
851: Community Forums
852: Member Screenshots
853: Community Forums
854: Community Forums
855: Member Screenshots
856: Community Forums
857: Community Forums
858: Community Forums
859: Downloads
860: Photo Gallery
861: Member Screenshots
862: Community Forums
863: Photo Gallery
864: Member Screenshots
865: Community Forums
866: Community Forums
867: Community Forums
868: Home
869: Home
870: Community Forums
871: Photo Gallery
872: Community Forums
873: News
874: News Archive
875: Community Forums
876: Member Screenshots
877: Home
878: Community Forums
879: Home
880: Community Forums
881: Community Forums
882: Community Forums
883: Community Forums
884: Community Forums
885: Photo Gallery
886: Photo Gallery
887: Community Forums
888: Home
889: Photo Gallery
890: Member Screenshots
891: Community Forums
892: Community Forums
893: Photo Gallery
894: Home
895: Home
896: Community Forums
897: Home
898: Community Forums
899: Community Forums
900: Community Forums
901: Community Forums
902: Community Forums
903: Photo Gallery
904: Community Forums
905: Community Forums
906: Downloads
907: Community Forums
908: Community Forums
909: Photo Gallery
910: Home
911: Downloads
912: Community Forums
913: Community Forums
914: Downloads
915: Home
916: Community Forums
917: Community Forums
918: Community Forums
919: Home
920: Community Forums
921: Community Forums
922: Community Forums
923: Community Forums
924: Community Forums
925: Downloads
926: Community Forums
927: Community Forums
928: Member Screenshots
929: Member Screenshots
930: Community Forums
931: Downloads
932: Community Forums
933: Community Forums
934: Community Forums
935: Home
936: Home
937: Community Forums
938: Community Forums
939: Community Forums
940: Community Forums
941: Community Forums
942: Community Forums
943: Community Forums
944: Member Screenshots
945: Member Screenshots
946: Community Forums
947: Community Forums
948: Photo Gallery
949: Community Forums
950: News Archive
951: Community Forums
952: Community Forums
953: Downloads
954: Community Forums
955: Home
956: Downloads
957: Community Forums
958: Member Screenshots
959: Community Forums
960: Home
961: Community Forums
962: Community Forums
963: Community Forums
964: Downloads
965: Your Account
966: Community Forums
967: Home
968: Photo Gallery
969: Downloads
970: Member Screenshots
971: Home
972: Community Forums
973: Home
974: Community Forums
975: Community Forums
976: Community Forums
977: Photo Gallery
978: Community Forums
979: Community Forums
980: Community Forums
981: Member Screenshots
982: Community Forums
983: Community Forums
984: Community Forums
985: Community Forums
986: News Archive
987: News Archive
988: Community Forums
989: Photo Gallery
990: Member Screenshots
991: Home
992: Community Forums
993: Community Forums
994: Member Screenshots
995: Community Forums
996: Community Forums
997: Community Forums
998: Community Forums
999: Community Forums
1000: Member Screenshots
1001: Community Forums
1002: Home
1003: Community Forums
1004: Home
1005: Community Forums
1006: Community Forums
1007: Photo Gallery
1008: Community Forums
1009: Home
1010: Home
1011: Community Forums
1012: Community Forums
1013: Community Forums
1014: Home
1015: Downloads
1016: Community Forums
1017: Community Forums
1018: Community Forums
1019: News Archive
1020: Home
1021: Community Forums
1022: Community Forums
1023: Member Screenshots
1024: Community Forums
1025: Home
1026: Community Forums
1027: Community Forums
1028: Community Forums
1029: Home
1030: Downloads
1031: Community Forums
1032: Community Forums
1033: Community Forums
1034: Community Forums
1035: Home
1036: Member Screenshots
1037: Community Forums
1038: Photo Gallery
1039: Community Forums
1040: Community Forums
1041: Photo Gallery
1042: Statistics
1043: Photo Gallery
1044: Home
1045: Community Forums
1046: Downloads

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