Com-Central.net

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

Forum Index › AFV News Discussion Board

View previous topic :: View next topic

Author

Message

Massimo_Foti
Power User

Offline
Joined: Apr 08, 2008
Posts: 5397
Location: Lugano, Switzerland

Posted: 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

L.Delsing
Power User

Offline
Joined: Feb 10, 2006
Posts: 960

Posted: 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

JimWeb
Power User

Offline
Joined: Jan 24, 2006
Posts: 1439
Location: The back of beyond

Posted: 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
***********************

the_shadock
Power User

Offline
Joined: May 27, 2006
Posts: 2865
Location: Normandy, France

Posted: 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

bsmart
Power User

Offline
Joined: Jan 23, 2006
Posts: 2523
Location: Central Maryland

Posted: 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)

Massimo_Foti
Power User

Offline
Joined: Apr 08, 2008
Posts: 5397
Location: Lugano, Switzerland

Posted: 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

JimWeb
Power User

Offline
Joined: Jan 24, 2006
Posts: 1439
Location: The back of beyond

Posted: 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 *********************

Massimo_Foti
Power User

Offline
Joined: Apr 08, 2008
Posts: 5397
Location: Lugano, Switzerland

Posted: 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

armyjunk2
Power User

Offline
Joined: Sep 22, 2006
Posts: 1416

Posted: 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.

the_shadock
Power User

Offline
Joined: May 27, 2006
Posts: 2865
Location: Normandy, France

Posted: 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

Joe_D
Power User

Offline
Joined: Jan 29, 2006
Posts: 2067
Location: Razorback Country

Posted: 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 . 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

L.Delsing
Power User

Offline
Joined: Feb 10, 2006
Posts: 960

Posted: 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

Tichenor
Power User

Offline
Joined: Dec 06, 2007
Posts: 461
Location: Antwerp

Posted: 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

Michel_Krauss
Power User

Offline
Joined: Oct 30, 2009
Posts: 953
Location: Zuid-Holland, The Netherlands

Posted: 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

Tichenor
Power User

Offline
Joined: Dec 06, 2007
Posts: 461
Location: Antwerp

Posted: 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

Forum Index › AFV News Discussion Board
Page 1 of 2

All times are GMT - 6 Hours
Go to page 1, 2 Next

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

Select Language

Login

`±`Recent Visitors

`±`User Info-big

Com-Central.net

Select Language

Login

±Recent Visitors

±User Info-big

`±`Recent Visitors

`±`User Info-big