XProfan

- Page 5 -

Gerhard
Praher

Hello Thomas !

The new Postleitzahlen there with us now since ca. one year - or already longer - as accurate knows I it now none.
around the hither To explain take I over again the example with the postcode 4730.
Heiligenberg - one Nachbargemeinde of Waizenkirchen - having by then The same postcode How Waizenkirchen - means 4730.
there but increasingly communities no Postamt More having, would it the case been, that increasingly communities The
same postcode had hätten - means those number the zuständigen Postamtes.
there so no eindeutige identification the communities More possible been is, watts those communities, The accordingly no
Postamt More had, with of/ one new postcode "beglückt". so got Heiligenberg The number 4733.

then there yet The thing with the Ortschaften - and there knows I do not wieweit this in Germany famous, or. same is.
we've here a very rural structure and so small or small Ansiedlungen, a town form and
to a designed Gemeinde belong. accordingly having these Ortschaften The postcode the Gemeinde To which
Gemeindegebiet tappt im dunkeln belong.

in the attachment finds your The actually Postleitzahlen with Ortschaften (stood Aug. 2008).
though are here no Coordinates present.

love Regards
Gerhard

PLZ_BESTIMMUNGSORT_AUG08.zip	203 kB

Hochgeladen:	09/20/08

Downloadcounter:
		Download

Windows XP Pro, SP3
Jetzt: XProfan 11
Was ich liebe sind 3 "F": meine Familie, meine Firma, meine Freizeit.

09/20/08 ▲

Jörg
Sellmeyer

If with the the Umsetzen of my Vorschlages kappt, need one eh no Postleitzahlen More.

Windows XP SP2 XProfan X4
... und hier mal was ganz anderes als Profan ...

09/20/08 ▲

Thomas
Freier

@Jörg, your suggestion found iF still one- and umsetzsetzbar. I coming not faster moreover, iFs wish after a PLZ>csv, these here einzutragen. and How Gerhard noticed, is the PLZ-list ca. circa 3000 PLZ larger (grown?), where , if it circa Aufteilung of Bezirken goes, The Coordinates with this Kartenmaßstab as same angesetzt go could.
@ Gerhard, here example the voliegenden data:

INSERT INTO geodb_textdata VALUES(60000,400100000,124,zero,zero,zero,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(60000,400200000,3,zero,zero,zero,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(60000,400300000,borough,de,1,1,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(60000,500100000,Eisenstadt,de,1,1,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(60000,500100002,EISENSTADT,de,1,1,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(60000,500600000,101,zero,zero,zero,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_intdata VALUES(60000,600700000,12061,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_floatdata VALUES(60000,610000000,42.9098,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_coordinates VALUES(60001,200100000,16.5833333,47.8333333,zero,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(60001,400100000,60000,zero,zero,zero,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(60001,400200000,5,zero,zero,zero,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(60001,400300000,Gemeinde,de,1,1,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(60001,500100000,Eisenstadt,de,1,1,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(60001,500100002,EISENSTADT,de,1,1,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(60001,500600000,10101,zero,zero,zero,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(60001,500300000,7000,zero,zero,zero,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_intdata VALUES(60001,600700000,12061,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_floatdata VALUES(60001,610000000,42.9098,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_coordinates VALUES(29237,200100000,16.5166667,47.85,zero,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(29237,400100000,60001,zero,zero,zero,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(29237,400200000,7,zero,zero,zero,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(29237,400300000,place,de,1,1,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(29237,500100000,Eisenstadt,de,1,1,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(29237,500100002,EISENSTADT,de,1,1,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(29237,500600000,1010101,zero,zero,zero,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_textdata VALUES(29237,500300000,7000,zero,zero,zero,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_intdata VALUES(29237,600700000,7462,zero,zero,3000-01-01,300500000)
INSERT INTO geodb_coordinates VALUES(60002,200100000,16.5000000,47.8333,zero,zero,zero,3000-01-01,300500000)

I give To, I only The PLZ the locations sought have. and the thing komplizierter becomes, because How on the example Eisenstadt To see is, has The Gemeinde no 4 stellige PLZ has. others, How you say , however a having. Wien is a Sonderfall and has for a small Fehlerquote provided.

Gruß Thomas
Windows XP SP2, XProfan X2

makes we it means on whom Ländercodes or. Vorwahlen solid?

Thomas
Freier

mandatory You as Admin know, what Bestand has. with whom ph. numbers can I in the present Bekanntenkreis only yet 90% over The T-number one area zuordnen (tlw. only yet mobil-Nr., etc.). How is it in some years?

Gruß Thomas
Windows XP SP2, XProfan X2

Gerhard
Praher

Hello all !

any Postleitzahlen in Österreich are 4-stellig. others there not.
what Wien anbelangt, so counts following rule:

The mittleren both numbers are The number the Bezirks.
example: 1200 = 20. borough

Each Gemeinde in Österreich has a postcode - since the Änderung The I described have.
it went then therefore either generally The Gemeindekennzahl (there has each Gemeinde long ago a Own) To take
or even The Postleitzahlen To strain, or. To give away where it no given.
there this the einfachere lane was watts it chosen. And so has each Gemeinde a eindeutige Kennung.

for Wien is yet To notice, that everything what with "1" starting Wien is.

love Regards
Gerhard

Windows XP Pro, SP3
Jetzt: XProfan 11
Was ich liebe sind 3 "F": meine Familie, meine Firma, meine Freizeit.

Jörg
Sellmeyer

It's all right not around the Telefonvorwahlen! it go only The Länderkennungen needed. Germany has z.B. 43, Östereeich 34. The go too only for einfacheren Access to The cards needed. eachone gives its Standortkoordinaten and the Landestelefonkennzahl one and the wars then already.

Windows XP SP2 XProfan X4
... und hier mal was ganz anderes als Profan ...

Gerhard
Praher

@Jörg:

an small Korrektur: Germany has 49 and Österreich has 43.

Windows XP Pro, SP3
Jetzt: XProfan 11
Was ich liebe sind 3 "F": meine Familie, meine Firma, meine Freizeit.