[postgis-users] Shapes to PG

[Neil.Young]

OK, it turns out, that just one the_geom is treated to be invalid (for 
unknown reasons). It also seems, that all of my shape records have been 
imported well, even if some of them are "invisible".

The record in question is

INSERT INTO "onb" ("vorwahl","name","kennung",the_geom) VALUES 
('04793','Hambergen',NULL,'SRID=31467;010600000001000000010300000001000000F0000000000000F0CE944A410000003CAC8D5641000000083B954A4100000098C98D5641000000C46D954A41000000DCCE8D564100000050F2954A410000001CDA8D5641000000AC23964A410000008C458E56410000004038964A41000000B85A8E5641000000A09B964A41000000B0568E56410000009CAB964A4100000098778E564100000054C9964A41000000108A8E56414E8417E80F974A411F08B0188E8E5641A6E24BEB0F974A41EC4A64D58D8E5641000000F410974A41000000288E8E56414E8417E80F974A411F08B0188E8E564194D0E4780F974A4167C6D837978E564182BE7D060F974A4142222751A98E5641E01BDE000B974A410769B139C18E56410646D85A4B974A41ECCD168EC08E5641D91B89F57C974A413216EC53E88E56419FE2F6DF81974A41EACD4F8AE68E564186CAD5F08D974A4101668D77ED8E564100000038AB974A4100000064D28E564100000070C2974A4100000074D98E56410000000CCC974A4100000080CB8E564100000094E4974A410000003CBF8E56410000005876984A41000000F8838E56410000007400994A4100000060B28E56410000002051994A4100000084D88E5641000000B4859A4A410000000CB68E564100000080CE9B4A4100000070A58E5641000000F8759C4A410000000CB88E5641000000AC399E4A41000000103C8E56410000004C099F4A41000000A0FD8D5641000000FC859F4A41000000D4848D564100000010AF9F4A41000000088B8D5641000000E0BF9F4A41000000F0878D5641000000840DA04A4100000024988D5641000000AC6EA04A41000000D4B08D564100000010C1A04A4100000034C18D5641000000FCF1A04A4100000034CC8D56410000000413A14A4100000018DB8D56410000004828A14A41000000D4EE8D56410000000C3AA14A41000000FC038E56410000001C63A14A410000000C0A8E5641000000007FA14A41000000B0068E5641000000A497A14A41000000E80A8E56410000003CB0A14A41000000D8118E564100000080C0A14A4100000068088E5641000000BCFBA14A4100000090048E5641000000C83EA24A41000000D4088E5641000000CC77A24A41000000A8048E564100000050A6A24A41000000D0058E564100000050E8A24A410000000C118E5641000000F01BA34A41000000980E8E5641000000784DA34A41000000C8028E5641000000A872A34A410000006CF68D5641000000C097A34A4100000000F28D5641000000B0CEA34A4100000064FC8D56410000000410A44A41000000000A8E5641000000A44DA44A4100000068118E56410000002C7EA44A410000008C098E56410000001CB7A44A41000000EC0A8E56410000004CDCA44A4100000040188E5641000000DCEBA44A41000000D02B8E56410000006004A54A410000003C398E5641000000A023A54A410000003C3F8E5641000000644DA54A41000000E43F8E5641000000646EA54A41000000303A8E56410000009093A54A41000000782E8E5641000000208AA54A41000000FCF98D564100000038F7A54A4100000064888D564100000010B6A54A410000000C868D564100000050BCA54A41000000D8738D564100000084D0A54A41000000085F8D564100000074EDA54A4100000038548D56410000003012A64A41000000D0528D5641000000F833A64A410000004C598D5641000000FC37A64A410000005C488D5641000000506AA64A4100000008308D5641000000C014A74A41000000F0DA8C5641000000AC87A74A4100000014D98C564100000014A0A74A41000000F4ED8C564100000080BAA74A4100000060FB8C5641000000C0E5A74A4100000058038D56410000003017A84A41000000F8FE8C5641000000E03EA84A4100000004F58C56410000000060A84A4100000050E58C5641000000045DA84A4100000034D78C5641000000404FA84A4100000078CA8C5641000000CC60A84A4100000018C08C5641000000AC5AA84A410000002CB18C56410000006863A84A4100000000A28C56410000003863A84A41000000B0978C5641000000F447A84A41000000C4838C564100000054D9A74A4100000004788C5641000000C4FFA74A41000000980C8C564100000050FEA74A4100000034EA8B5641000000E0BBA74A4100000028E88B56410000007CA0A74A41000000BCDD8B56410000002C99A74A4100000050C88B5641000000C06DA74A410000001C6B8B5641000000083CA74A41000000946D8B5641000000F435A74A41000000D85A8B56410000005062A74A410000009C568B5641000000806CA74A41000000FC398B5641000000D06BA74A4100000060258B56410000004851A74A4100000080A98A56410000004C48A74A41000000949A8A56410000003433A74A41000000C4918A564100000030C5A74A41000000702B8A56410000006C26A84A41000000740D8A5641000000CC91A84A410000000CEF89564100000030E9A84A4100000040D38956410000008043A94A4100000030B389564100000030A4A94A41000000A88F8956410000007860AA4A41000000B049895641000000F046AA4A410000004CF5885641000000E4EBA94A41000000944488564100000058E0A74A41000000ACF4885641000000C0B9A74A410000007C0B8956410000005485A74A4100000008F2885641000000986EA44A41000000F0668756410000003C24A44A41000000AC4E875641000000DC01A44A41000000F04487564100000050F6A34A41000000A81E87564100000008D7A34A410000001CFB865641000000E8D4A34A4100000054D9865641000000889BA34A41000000A8AA8656410000000885A34A41000000648C865641000000C876A34A41000000F87B865641000000443DA34A410000006462865641000000BCFFA24A41000000E043865641000000D4D6A24A41000000A425865641000000F4AEA24A4100000050038656410000009C92A24A4100000020DC855641000000446EA24A410000008CD5855641000000F85BA24A41000000F0DE855641000000804DA24A4100000024D98556410000003826A24A4100000084D685564100000064FBA14A410000003CD685564100000090BAA14A4100000000E9855641000000149AA14A4100000068FD8556410000000883A14A410000009C06865641000000403FA14A4100000084F2855641000000D408A14A4100000058EB855641000000F491A04A41000000D0208656410000006459A04A41000000A033865641000000C8309E4A410000005C3E86564100000020EC9D4A41000000D84586564100000048D19D4A41000000941B86564100000040099D4A41000000601B8656410000006CFD9C4A41000000C8058656410000003C899C4A41000000642086564100000020699C4A4100000088EA85564100000050EB9B4A4100000050F1855641000000A8FB9A4A410000000C6086564100000084B89A4A41000000305186564100000068319A4A410000002843865641000000F0AE994A41000000C43F8656410000008844994A410000003045865641000000E010994A41000000FC1D8656410000004C91984A410000008CDE85564100000074AC974A410000001C11865641000000506C974A41000000C8D7855641000000584D974A41000000E0E6855641000000841B974A410000008CC885564100000050DE964A410000007CC18556410000001C73964A41000000BCB6855641000000784A964A41000000E4D385564100000034EA954A4100000028F7855641000000C020964A41000000401A8656410000009C3F964A41000000E04D8656410000006C8D964A41000000BCA486564100000084C4964A4100000014ED86564100000038E9964A410000000432875641000000DC4B974A41000000B4088856410000002819974A41000000403A885641000000345E974A41000000104A885641000000E052974A410000005C5D885641000000A83C974A410000001C7A88564100000084EB964A4100000098E1885641000000C45C964A4100000010F38856410000001C2E954A41000000BCF98856410000005427954A41000000A4E78856410000009C28954A4100000010C98856410000003C12954A41000000CC9B88564100000038FA944A410000006491885641000000A0CA944A41000000248F885641000000B073944A41000000EC88885641000000D443944A41000000F4808856410000003807944A41000000A47E8856410000001CEA934A41000000B49188564100000064D9934A41000000ECA5885641000000FCC4934A4100000048CA88564100000034B6934A4100000030F88856410000006CA1934A4100000018068956410000000080934A41000000A0108956410000008858934A41000000F418895641000000F028934A410000006C12895641000000C8F1924A410000001C0E895641000000C8BE924A41000000C40D895641000000209E924A41000000FC0A895641000000507E924A410000004001895641000000A863924A4100000058FD885641000000EC3F924A4100000098008956410000000833924A410000004807895641000000F025924A41000000F014895641000000B80F924A4100000028288956410000000484914A41000000987C8956410000003429914A4100000034988956410000000843914A410000000CBA895641000000C860914A410000008CB88956410000001882914A410000006CE9895641000000E8EC914A4100000078C38956410000002CB6924A41000000BC278A564100000040E2924A41000000442B8A5641000000BC0C934A41000000A82E8A5641000000242D934A41000000DC358A5641000000403B934A41000000D0428A5641000000103D934A4100000004528A56410000007021934A41000000AC638A5641000000D4F8924A4100000014748A5641000000FCB0934A41000000F8198B564100000070CE934A41000000341A8B56410000003815944A410000008C668B5641000000D012944A41000000446F8B5641000000C851944A41000000D8AD8B56410000005C41944A410000000CB18B5641000000E046944A4100000010BA8B56410000005CF4934A41000000F0D98B5641000000A021944A41000000CC308C5641000000FCF6934A4100000080388C5641000000B813944A4100000050748C5641000000104B944A410000006C6F8C5641000000C447944A41000000F07B8C5641000000D438944A41000000FC8E8C5641000000CC0B944A410000000CA08C5641000000E0C1924A41000000C0FB8C56410000000026944A410000004C768D5641000000F06D944A41000000788F8D5641000000F0CE944A410000003CAC8D5641');

So, my next question will be: How to re-project this database? I need 
SRID 4326 data...

Regards



Nicolas Ribot schrieb:
>> The first returns 0 of 5204 records.
>>     
>
> Meaning you don't have null geometries in your table.
>
>   
>> The output of the latter I don't understand (see screenshot)
>>
>>     
>
> the result of st_isvalid is a boolean value: t for true, f for false.
> meaning some geometries are invalid.
>
> select <some attributes> from onb where not st_isvalid(the_geom);
> will allow you to identify invalid objects.
>
> Nico
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>