<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12">
<TITLE>Problem with postgis table in qgis 1.80</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->

<P DIR=LTR><SPAN LANG="de"></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">Hallo,</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">i have some problems with data from postgresql db (v. 9.1.3) only in qgis 1.80.  The spatial data will view, but in the attribute table is shown in some rows only ERROR. In this case the corresponding value in the Identify Results is a big negative value – it looks like an overflow error?! </FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">I have tested it on Win and Ubuntu with the same result. In the db manager the table will shown right, but the qgis browser has the same problems.</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">In qgis 1.7.4 all works proper!</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">Appending the sql-Code of the test-table.</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">Many thanks for any help!</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="de"><FONT FACE="Calibri">Siegfried Blank</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><BR>
</SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><FONT SIZE=2 FACE="Arial">------------------------------------------------------------</FONT></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><BR>
</SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><FONT SIZE=2 FACE="Arial">Landwirtschaftliches Zentrum für Rinderhaltung,<BR>
Grünlandwirtschaft, Milchwirtschaft, Wild und Fischerei<BR>
Baden-Württemberg</FONT></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"> <FONT COLOR="#000000" SIZE=2 FACE="Arial">(LAZBW)</FONT></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><BR>
</SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><FONT FACE="Arial">Fischereiforschungsstelle Baden-Württemberg<BR>
</FONT></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><FONT SIZE=2 FACE="Arial">(Fisheries Research Station)</FONT></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><BR>
</SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><FONT SIZE=2 FACE="Arial">Argenweg 50/1<BR>
88085 Langenargen</FONT></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><BR>
</SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><FONT SIZE=2 FACE="Arial">Tel.: 0049-(0)7543-9308313</FONT></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><BR>
</SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><FONT SIZE=2 FACE="Arial">Fax: 0049-(0)7543-9308320</FONT></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><BR>
</SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><FONT SIZE=2 FACE="Arial">(Germany)</FONT></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><BR>
</SPAN><SPAN LANG="de"></SPAN><A HREF="http://www.lazbw.de/"><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"><U></U></SPAN><U><SPAN LANG="de-de"><FONT COLOR="#000000" SIZE=2 FACE="Arial">http://www.lazbw.de</FONT></SPAN></U><SPAN LANG="de"></SPAN></A><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><BR>
</SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><FONT SIZE=2 FACE="Arial">-----------------------------------------------------------</FONT></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"><FONT FACE="Times New Roman"> </FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="de-de"></SPAN></P>

<P DIR=LTR><SPAN LANG="de"></SPAN></P>

<P DIR=LTR><SPAN LANG="de"></SPAN><SPAN LANG="en-us"><FONT FACE="Calibri">--</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">-- PostgreSQL database dump</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">--</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">-- Dumped from database version 9.1.3</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">--</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">CREATE TABLE tbl_test (</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">    probestellennummer bigint NOT NULL,</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">    the_geom public.geometry</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">);</FONT></SPAN></P>
<BR>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">INSERT INTO tbl_test VALUES (6402145001, '0105000020EB7A0000010000000102000000170000004C3789319C3C4B41FCA9F10AF8535441931804869D3C4B4121B072B0F45354417D3F357EA13C4B41E4839E65EA5354411904563EA53C4B41E5D0224BE4535441F6285C7FA93C4B410C022BAFDD5354416C787A1DAD3C4B41E0BE0E48D85354417593187CB33C4B417E8CB967D15354412BF69795B63C4B41BADA8A15CE5354412BF69795B63C4B41BADA8A15CE535441516B9A87C23C4B41E4141D49C1535441EF3845A7CD3C4B41EC51B806B6535441F7065F70D13C4B411D3867ACB2535441EA0434F1E13C4B4199BB9680A653544157EC2F4BF43C4B4148BF7D3199535441A779C7D9013D4B413D9B55EF8F5354414C3789491E3D4B41E4839EBD7E5354415EBA49FC2E3D4B41705F073E74535441AF25E40B3C3D4B41CE88D2EA68535441F7065F78453D4B410E2DB2295F535441AED85F964B3D4B41AED85FD25553544170CE88BA4E3D4B419CA2230D4E535441CE1951B2523D4B41BBB88D7E40535441E9263178523D4B4154E3A51335535441');</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">INSERT INTO tbl_test VALUES (6401063001, '0105000020EB7A00000100000001020000008D000000A167B32A3B214B413411369C1E4A5441CE19511239214B4168226C8C1F4A5441E09C11CD2D214B416F128398244A54413333337B21214B41DF4F8D3B2A4A5441E63FA4E716214B4198DD93672F4A5441DD2406010A214B41DC4603CC354A5441DD240609F9204B41A8C64B8F3F4A54417FD93D39F2204B41759318B4434A5441499D8086ED204B410E4FAF34474A5441E6AE250CED204B418716D99A474A54414A0C0223E7204B41F5DBD7E94D4A5441984C1504E6204B41B6847C504F4A54413BDF4F65E0204B414694F656564A5441AED85F9EDC204B413EE8D9585A4A54418CB96BA1DB204B4111363C655B4A544103098AC7D9204B413D2CD4F65C4A544122FDF6C5D4204B41B003E734614A5441E71DA748CF204B414260E514654A544104E78CD8CE204B41B98D0664654A5441F931E6F6C9204B41000000B4684A5441363CBD62C4204B41BD5296B96B4A5441894160D5B7204B4196438BD0724A5441FA7E6A5CB3204B4194878506754A5441986E129BAD204B4160E5D0DE774A5441C5FEB213A4204B41DE9387857B4A5441F0A7C68B97204B4117D9CE077F4A5441378941C084204B41BA490C12834A5441F0A7C64B6F204B41355EBAB9864A54414772F99F6D204B4185EB51EC864A54415986386E65204B413A92CB5F884A5441BE30997A5D204B419CA22391894A54418CDB68F85A204B41903177F1894A54414B5986B84D204B41CA54C1388B4A5441DD24060145204B418104C5AF8B4A5441F7065FB02E204B413108ACAC8C4A54414850FCB818204B410534116E8D4A54414C37896109204B417D3F35D68D4A5441FB5C6D2DFD1F4B41C74B374D8E4A5441D578E9FEF31F4B41516B9A978E4A54418FE4F2E7EC1F4B41A323B9888E4A5441645DDCA6E91F4B41C74B374D8E4A54412497FFD0E51F4B418F5374B88D4A54419A9999D1E01F4B4183C0CA9D8C4A54419EEFA796DF1F4B41ED0DBE408C4A54414A0C0243DE1F4B4141F163DC8B4A54418B6CE713DA1F4B4152499DD08A4A54415DFE4332D51F4B41302AA9F7874A5441C286A7EFCB1F4B41BF0E9C47804A54411904562EC61F4B4117D9CE177C4A5441A8C64BB7BE1F4B41CFF75323774A5441FA7E6A3CBA1F4B413F355E0A754A544193180436B51F4B41A69BC4B0724A54414C378921AF1F4B41F853E345704A544167D5E712AD1F4B414182E2FB6E4A54416F81046DAA1F4B410B4625D16D4A54410E4FAF449F1F4B41567DAE7E664A544193A98239991F4B4196438BD8614A5441545227A8961F4B41A1D6344F5F4A5441E4839E75941F4B41956588235D4A544168B3EA33901F4B4117B7D16C594A5441A779C711891F4B419B559F33534A544119045636821F4B41857CD0FB4C4A5441E8D9ACEA731F4B412A3A925F404A5441A4703D2A701F4B411CEBE2AE3C4A5441107A366B641F4B412EFF214D324A544189D2DEF8601F4B4132E6AEE12E4A5441AB3E5753571F4B41E8D9ACEE254A5441AB3E5753571F4B41E8D9ACEE254A5441613255604E1F4B414ED191F81D4A5441613255604E1F4B414ED191F81D4A5441832F4CF6441F4B41567DAEF6144A54415305A3C23F1F4B414D840D2B104A5441759318243D1F4B4154E3A53B0D4A5441865AD354391F4B41D42B65F9084A5441BF7D1DF8351F4B4144696F1C044A5441D578E9FE2E1F4B41B4C8768EFC49544116FBCB462B1F4B418FC2F514F8495441A1D634DF2A1F4B41567DAEBAF7495441CA32C4E1291F4B410C93A956F649544104E78CA0251F4B41075F9818F149544198DD935F231F4B41C442AD51EE495441857CD01B221F4B41FE65F7C8EC4954416519E2181D1F4B41F4FDD4B4E6495441022B877E191F4B4152499D44DF495441C976BE6F181F4B415BB1BF28DB4954415BD3BCFB171F4B4105341166D9495441EB73B50D171F4B416DE7FB5DD24954416744694F151F4B4110E9B7D3C4495441C0EC9ECC131F4B414A0C0223B549544121B072B8131F4B4155302A41B0495441645DDCAE131F4B41832F4CEEAD4954415474247F141F4B418CDB68ECA4495441CC7F486F151F4B41022B87CE9F495441EB73B50D171F4B41B7D100FA9649544153962176181F4B41BE3099B68B49544127C28607191F4B4103098A2B8749544127C28607191F4B4103098A2B8749544160E5D062191F4B419CC420C08549544176E09CE1191F4B41F7E461A182495441728A8E6C1A1F4B4109F9A03B7D495441BEC117961B1F4B4198DD93E3724954412041F1831C1F4B413480B7386F4954417F6ABC941C1F4B41F853E3A56E4954416ABC74131E1F4B41355EBA5967495441E63FA4CF1F1F4B41EE7C3F255E49544104560ECD211F4B417D3F351E54495441894160E5221F4B41F853E3B5494954414C3789C1241F4B415EBA492C3F4954416AC3C595241F4B41498F630A3F495441D122DB19261F4B41A69BC4F03349544121B07230261F4B4141F163943049544167D5E782261F4B41D0B359212F495441B30C71AC271F4B410BB5A6A12C495441DA1B7C11291F4B4134A2B43F2A49544116FBCB462B1F4B41643BDF572749544109F9A0B72D1F4B41DFE00BE724495441BC969057341F4B41E3C7980B1E495441FE43FACD391F4B4182E2C75C17495441F2D24D7A3C1F4B410DE02DE01349544188855AFB3C1F4B41DDB584F012495441F5B9DA1A3E1F4B41508D97DA104954411D5A64BB3F1F4B411283C0F20D495441A245B623411F4B411A51DAEB094954413F355E5A411F4B41C7293A0A09495441A8C64B97411F4B418716D90E08495441560E2D12421F4B4121B0724802495441DBF97EAA411F4B419CC420F0FB485441E3A59BB4401F4B41C442AD65F6485441E63FA46F401F4B4117D9CED7F4485441BC7493F83F1F4B414A0C022BF2485441894160C53D1F4B41355EBA59E94854417FFB3A003B1F4B41304CA6FAE2485441560E2DD23A1F4B41A69BC490E24854410E2DB27D371F4B412B871629DC485441F931E61E371F4B41D9CEF79BDB48544189416025331F4B41B07268B1D5485441C74B37E92D1F4B413F355E4ACF4854414F4013812B1F4B4143AD69DECC4854412DB29D0F291F4B412B871669CA485441CAC34295251F4B4166F7E411C748544155302AE91D1F4B4125750202C1485441');</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">INSERT INTO tbl_test VALUES (6501038002, '0105000020EB7A00000100000001020000002B0000004260E5B0AA334B412DB29D87EC765441621058C9A2334B41736891B5EC765441B30C710CA2334B41AD69DEB9EC765441D578E9B69A334B4196438BE4EC765441B072685188334B41F6285C77EE765441A245B6E376334B41E17A1486F07654413789419070334B41F54A599EF1765441560E2D0264334B4177BE9FCAF376544185EB510854334B4181954393F6765441C1CAA1953B334B41DBF97E62FC765441C1CAA1552C334B41E5D0222BFF765441022B878627334B41F2D24DC2FF765441FED478891E334B411B2FDDDC00775441759318340A334B41B81E85E3037754411FF46C16FF324B411CEBE22E05775441E71DA788F8324B410F9C33F205775441AAF1D25DEE324B410C022B4F067754410C022BB7E3324B4185EB5138057754413108AC9CE3324B4181954333057754413108AC6CE0324B4123DBF9960477544139B4C856D8324B4177BE9F0A03775441F7065FE8CE324B41B1E1E9F5FE76544171AC8BDBCC324B41A857CA12FE765441D34D62C0CB324B4185EB5198FD7654410A68228CCA324B41DBF97EA2FC7654415C8FC295C1324B41FA7E6A7CF5765441E6AE2544BC324B417DD0B3D9EF7654412D431C6BB7324B418716D9B6EA76544146B6F31DA2324B412DB29D47DD7654419EEFA7E69C324B41A8C64BE7DA7654415DDC46C397324B41E3361A90D87654416210583997324B4114AE4751D8765441EEEBC07994324B41C5FEB27BD77654414ED191CC8D324B41F085C974D5765441E5D022AB89324B413D0AD733D4765441BBB88D3685324B41C7BAB875D3765441BBB88D3685324B41C7BAB875D3765441F9A067B384324B41F90FE95FD37654414E6210F87D324B412E90A040D276544114AE47B179324B41560E2D8AD176544114AE47B179324B41560E2D8AD17654417B14AEC767324B416ABC747BCF765441A4703D6A54324B4119045616D0765441');</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">INSERT INTO tbl_test VALUES (6451017002, '0105000020EB7A000001000000010200000010000000C2172633A8404B41B8AF03172A735441B1E1E97582404B41AAF1D20D1F7354418F5374F44F404B41D734EF4810735441E09C11E53D404B417FD93D810B7354417AC7292A30404B41666666D607735441A2B4376825404B4133C4B1BE04735441A52C433C20404B41C139234203735441166A4D131E404B417AA52CA302735441865AD30C17404B41A3923A41007354411F85EBB10F404B4105A392C2FD7254411361C33309404B41B515FBF3FA725441FBCBEE1900404B4138F8C204F7725441A60A46C5E63F4B41AA825111EC725441D8817326C33F4B41A301BC15D6725441107A361BC13F4B41499D801ED472544171AC8B8B9B3F4B41EC51B8FEAF725441');</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">INSERT INTO tbl_test VALUES (6503036003, '0105000020EB7A000001000000010200000031000000E7FBA9E93D6A4B413D9B5503738A54414850FC08406A4B419A9999E9758A5441EFC9C3A2416A4B41F31FD223778A5441E7FBA989426A4B417B14AE57788A544137894128486A4B413A92CB3B7D8A5441BA490CB24B6A4B414BC807F5828A5441736891354C6A4B41C13923A28C8A544148BF7D3D486A4B41E71DA7909A8A54416EA301FC456A4B416A4DF3BA9C8A544189D2DE98436A4B41FBCBEE9D9E8A54417B14AE47416A4B41C286A7679F8A54419A081B4E3C6A4B415DFE431AA18A5441516B9A47316A4B41956588FBA18A544187A7579A1C6A4B41E3A59B98A28A54414E621080136A4B41933A011DA38A5441D26F5F970B6A4B41A835CD97A28A5441029A08A3076A4B41BF7D1D58A18A5441B0726829046A4B419B559FFF9E8A5441B0726829046A4B419B559FFF9E8A5441B0726829046A4B419B559FFF9E8A5441EA0434D1026A4B41378941549E8A5441EA0434D1026A4B41378941549E8A544162105801016A4B41A8C64BC39D8A5441B003E724006A4B41D509687E9D8A54412D431C9BFC694B416D567D2E9D8A54412D431C9BFC694B416D567D2E9D8A544151DA1BCCFB694B41CA54C1409D8A544186C95411F9694B41D509687E9D8A544161325568F2694B41D6C56D18A08A54410C022B5FEC694B41933A011DA38A5441B7D10056E6694B41E6AE258CA68A544113F24157E1694B414F1E1676A98A5441BDE3144DDE694B41A52C43D4AA8A5441E4839E2DDD694B41E4839E55AB8A5441174850C4D7694B41B98D0660AC8A544116FBCBC6CD694B41E63FA4EFAD8A54416F81043DCA694B41D044D874AE8A5441984C1564C2694B41A835CD5BAF8A54416ADE7192B7694B411895D479B28A5441B37BF280AF694B41B6F3FDC8B68A54413D0AD7BB9F694B417958A84DBE8A544180B7405295694B4141F16390C48A54413D9B553F91694B416ABC7403C78A544101DE02A188694B41B072689DCD8A544105C58F5987694B410E2DB2B1CE8A54411826530D82694B41F241CFF2D38A54413F575B9180694B41C976BED7D68A5441B6847C0080694B4180B740F2D78A54410B4625A57E694B410AD7A300E28A5441');</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">INSERT INTO tbl_test VALUES (6351000001, '0105000020EB7A00000100000001020000002F000000D734EFA8A0084B41DDB584940B6454413EE8D96CB0084B41613255480B645441840D4F6FBF084B4142CF662D09645441151DC995D4084B41107A36C3036454416ABC7443FB084B41C898BBA6F363544133C4B1FE13094B4176E09C59E96354412063EE7A22094B413D0AD743E5635441E258177735094B415C8FC255E363544134A2B46744094B41C3F5284CE4635441984C15FC7D094B4119E258AFF1635441143FC66C90094B41FBCBEE71F1635441B8AF0357B1094B4114AE4731ED635441575BB1EFC9094B41AA6054EEE66354415C8FC295EB094B419031775DDE6354413D2CD4BA1B0A4B41BDE314B5D463544151DA1B1C370A4B4167D5E73ACD635441F775E08C5A0A4B419A081B2EBD6354413411369C670A4B41FB5C6D1DB7635441840D4F6F7A0A4B4101DE02F9A96354417AA52CF38A0A4B41B8AF0387A4635441AEB6622F9B0A4B418BFD65EFA2635441A2B43718DD0A4B41D88173C6A1635441D7A370FDED0A4B4148E17A24A3635441711B0D00FD0A4B418048BF35A6635441E3C7988B130B4B41C364AAE0AE63544185EB51181E0B4B41143FC68CB56354413F575B013F0B4B4162A1D6ACD36354413F575B013F0B4B4162A1D6ACD3635441EB73B5D5430B4B417CF2B0D0D5635441CC7F488F500B4B414E621060D6635441ED0DBED0610B4B4194F606E7D5635441D6C56D747A0B4B41D7A3702DD3635441F697DD23960B4B41B81E85DBCB63544187A7572A9D0B4B41A835CD73C86354415227A099A20B4B41E6AE253CC3635441956588D3A80B4B418A1F632EB963544101DE02E9B00B4B4152499D20AC63544100917E2BB80B4B415DFE435AA6635441A9A44E90BE0B4B412A3A9253A26354410F0BB55ECB0B4B414C378929A1635441B98D0640E30B4B4133C4B1AEA56354419CC420F0E70B4B41C6DCB5BCA5635441ADFA5CBDFB0B4B41C286A7F7A5635441CC5D4B78380C4B41857CD0139D63544152B81EC5690C4B41FBCBEE9199635441E10B9379740C4B4171AC8BBB99635441931804B6A40C4B416E3480BF93635441');</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">INSERT INTO tbl_test VALUES (6302035003, '0105000020EB7A00000100000001020000003B000000545227D0DB034B416666667A93655441711B0DC8D5034B416666667A93655441401361E3CE034B41F697DD1B936554411973D75AC7034B4132E6AE4193655441BF7D1DF8BF034B41F697DD1B93655441A089B089BB034B41E3A59B8492655441E4141DA1B5034B419E5E291392655441FA7E6A74AE034B41956588C791655441AE47E112A9034B41956588C791655441B30C71A4A4034B414A7B839792655441857CD05BA0034B417958A81194655441BE3099929C034B418716D93296655441EEEBC0A19B034B413CBD52BA96655441C74B371994034B417F6ABCF89B6554415C8FC24D8D034B41933A01BD9F655441F697DD8B87034B4146B6F39DA2655441780B240885034B41B003E7CCA36554411895D4B97B034B415DFE437EA76554413411360473034B41C21726ABAA65544154E3A58B6D034B4139D6C5A9AC6554413789418063034B418126C2A6B06554415BB1BF545E034B41E25817FBB1655441B22E6E0359034B41A167B316B3655441ACADD81757034B41696FF07DB4655441ACADD81757034B41FF21FD0AB66554411283C06A57034B41D49AE6F5B66554414F40130157034B41E25817A3B765544186C954E955034B41E4141D55B86554414BC807F552034B41ED0DBEA0B86554411361C31B50034B4133333327B8655441CD3B4EB94E034B41006F81ACB7655441F4FDD4C04C034B4112143FA2B66554410BB5A6E948034B41158C4A02B56554411AC05B3045034B4103098AE3B46554411AC05B3045034B4103098AE3B465544142CF665544034B41D93D79DCB465544174B5153B42034B411058391CB565544174B5153B42034B411058391CB565544121B072B83E034B415305A386B5655441EFC9C3B239034B4179E926B5B6655441F38E534435034B411B0DE0EDB665544188635D1432034B418AB0E1A5B6655441E561A13E30034B4144696F7CB665544116FBCBBE29034B41E3361A28B5655441143FC66423034B412D211F58B4655441F31FD2C71D034B418BFD651FB465544104560E0518034B41BD5296F9B3655441B30C71BC13034B41AA605462B3655441DDB5847C10034B41EC51B846B2655441ADFA5CE50E034B41DC68005BB1655441AEB6626F0D034B41FFB27B82B06554412041F1930A034B41226C78B2AD6554416ADE711A07034B41A245B6C7AB655441AEB6622704034B4158A835F1AA6554410A6822DC01034B41151DC985AA6554416891ED3C00034B411895D439AA655441DC460300F9024B4176711B01AA6554412D431CC3F1024B4188635D98AA65544109F9A01FEE024B418E06F08EAB655441');</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">INSERT INTO tbl_test VALUES (6351000002, '0105000020EB7A0000010000000102000000160000009FCDAA8F7B064B41992A18753E635441371AC0EB7C064B4131992A28406354410E4FAFA47E064B41A301BCAD446354419A081BCE85064B415C2041F14E6354414A7B83D78B064B417B832FA4566354411F85EB118D064B41E78C28355863544148E17A34CB064B412FDD24EE80635441F46C56CDD5064B4152499D5086635441F54A5936DB064B415DDC46F38863544166F7E4D1E5064B41423EE8B18D635441865AD32CF1064B41C3F5284C906354414772F93F39074B4152B81E259A635441849ECD3A48074B41A301BC259D635441539621CE59074B4148E17A24A3635441C1A8A4DE86074B4100917E9BBA63544114AE4721C1074B41151DC995DE6354415C8FC2F5DC074B41BD529609E76354412B18953402084B419EEFA7DEEF6354419031775D1D084B415227A0B9F36354416EA301FC24084B41DD240639F363544129CB10D73E084B414D840D77F7635441287E8CD97C084B414C37893905645441');</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">INSERT INTO tbl_test VALUES (6505130001, '0105000020EB7A00000100000001020000001A000000F775E0D430754B4174469452079B5441D93D79E825754B413B70CE740E9B5441C3D32B8D1E754B414ED191E8109B5441DDB584440A754B417B832FE8159B5441FC187357FF744B4190317799189B54415396210EEB744B413CBD52F21C9B544155302A59DE744B41105839D81F9B54413BDF4F35D5744B41CDCCCC4C239B54416DE7FB81CA744B41C442AD51299B5441006F815CBF744B410DE02D58319B54410612148FB7744B41E17A143E349B54419D802632AE744B4192CB7F94359B5441EE5A42B6A1744B411C7C61CE369B5441DDB584AC95744B416EA301D0389B5441355EBAC18C744B41A167B30A3B9B5441DC68002F87744B41A9A44E603B9B5441956588F37C744B41D0B359AD3B9B5441A5BDC12776744B41061214873D9B5441F0A7C65B6F744B411F85EB19439B54419A081BBE62744B416ADE71724D9B5441D734EF085D744B41BC749320529B5441492EFF3159744B414D840D47559B544186C954A158744B41304CA60A569B54418FE4F2AF53744B41158C4ACE599B5441787AA5544C744B418638D661609B54419D80265245744B41C442ADAD6E9B5441');</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">INSERT INTO tbl_test VALUES (6505130002, '0105000020EB7A00000100000001020000001300000029ED0D4E31784B4135EF389531945441C217261322784B416C787AB53894544129ED0D4E20784B41E02D9044399454416A4DF30E05784B412A3A92CB449454412653052BEF774B419D11A5754E9454412653052BEF774B419D11A5754E945441E5D02263E5774B41E561A1EE5394544106121447D9774B411D5A64F75B945441C976BEC7CD774B419A081BDE649454411C7C61DAC3774B412575023A709454411C7C61DAC3774B412575023A70945441182653B5BD774B4187A757827994544190A0F8B1B9774B41DC680067819454414F401381B7774B41AD69DE5184945441C364AA30B5774B41E6AE250C87945441E3361AA0B2774B418A1F63D6899454413D0AD743AE774B41C8073D838D9454415DDC4653AB774B412063EECA8F945441D7A370BDA7774B413D0AD76392945441');</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">INSERT INTO tbl_test VALUES (6504126001, '0105000020EB7A0000010000000102000000240000003E795818C46D4B4188635D1862875441EC2FBB47A56D4B4175029AA069875441F2B05093896D4B419D80268A6E87544160764F5E716D4B41865AD3687287544111363C4D606D4B415C20410D76875441158C4ABA566D4B41D93D792C79875441F1F44A11506D4B41575BB14B7C87544199BB9628486D4B417FD93DC580875441ED9E3C34446D4B413F575BA9858754414BC80715416D4B41A835CDE78B875441E86A2BEE406D4B41840D4F438D8754410E2DB20D406D4B410C022B1B958754415C8FC2F5406D4B416B2BF63FAB8754416744690F3F6D4B414850FCF8B2875441AD69DE91386D4B41431CEB1ABD875441F697DDE32F6D4B4167D5E7DAC58754417B14AE072C6D4B4194F606B7CD875441D6C56D142C6D4B4124287EF4DD875441D6C56D142C6D4B4124287EF4DD8754415EBA49FC2C6D4B41F2B05073E287544177BE9F5A2F6D4B417F6ABC34EE875441C364AAD02F6D4B41567DAE7EF08754417B14AE47236D4B41CD3B4E410D8854417B14AE47236D4B41CD3B4E410D8854417B14AE47236D4B41CD3B4E410D885441B6847C401E6D4B41F46C56B51688544148BF7DDD1C6D4B410AD7A35019885441D734EFC8196D4B411B0DE0E51B885441158C4AAA0E6D4B412497FF3825885441FA7E6AB4016D4B4196218ED52C88544100917E8BFE6C4B4199FE40C32E885441ED9E3C2CF96C4B41B537F81A3188544167D5E7DAEB6C4B41575BB117378854413D9B55AFD76C4B41D200DE1A3E8854415DFE432AC96C4B41E78C28A5418854413E7958B8AC6C4B41D26F5F2F47885441');</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">INSERT INTO tbl_test VALUES (6402145003, '0105000020EB7A0000010000000102000000120000009D8026C285334B41AAF1D2DDE66654413F355E1A83334B412B8716A1E26654416ABC74F377334B41C1392326D3665441764F1E866B334B41713D0A1BC46654413F575B8961334B41B6F3FD08B46654413D2CD48A56334B41E4839EF1A4665441333333534D334B412731087C99665441B1506BC241334B417A36ABA28966544160E5D0FA35334B410A6822007A665441EC51B88E29334B418A1F63C268665441228E75591D334B41EF38453B5966544146B6F33515334B41B7D1006A51665441C898BB360F334B41014D84614C665441D5E76A9305334B417F6ABC3445665441D044D878F9324B415C20418D3C665441D044D878F9324B415C20418D3C665441A8C64B879D324B419CC420680166544144696F187C324B415E4BC80FEB655441');</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">ALTER TABLE ONLY tbl_test</FONT></SPAN></P>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">    ADD CONSTRAINT pri PRIMARY KEY (probestellennummer);</FONT></SPAN></P>
<BR>

<P DIR=LTR><SPAN LANG="en-us"><FONT FACE="Calibri">CREATE INDEX gist ON tbl_test USING gist (the_geom);</FONT></SPAN></P>
<BR>
<BR>

<P DIR=LTR><SPAN LANG="de"></SPAN><SPAN LANG="de"></SPAN><SPAN LANG="en-us"></SPAN></P>

</BODY>
</HTML>