[postgis-users] Shapes to PG

[Paragon Corporation]

Neil,

Doing as is valid check on this.  The notice gives this

NOTICE:  Ring Self-intersection at or near point 3.48522e+006 5.91314e+006

As far as transforming goes  -- you should add a new geometry column with
addgeometrycolumn
http://postgis.refractions.net/documentation/manual-svn/AddGeometryColumn.ht
ml


UPDATE onb SET the_geom_4326 = ST_Transform(the_geom, 4326);

Then you can drop the old with dropgeometrycolumn
http://postgis.refractions.net/documentation/manual-svn/DropGeometryColumn.h
tml


Leo

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Neil.Young
Sent: Monday, January 26, 2009 3:25 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Shapes to PG

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;010600000001000000010300000001000000F0
000000000000F0CE944A410000003CAC8D5641000000083B954A4100000098C98D5641000000
C46D954A41000000DCCE8D564100000050F2954A410000001CDA8D5641000000AC23964A4100
00008C458E56410000004038964A41000000B85A8E5641000000A09B964A41000000B0568E56
410000009CAB964A4100000098778E564100000054C9964A41000000108A8E56414E8417E80F
974A411F08B0188E8E5641A6E24BEB0F974A41EC4A64D58D8E5641000000F410974A41000000
288E8E56414E8417E80F974A411F08B0188E8E564194D0E4780F974A4167C6D837978E564182
BE7D060F974A4142222751A98E5641E01BDE000B974A410769B139C18E56410646D85A4B974A
41ECCD168EC08E5641D91B89F57C974A413216EC53E88E56419FE2F6DF81974A41EACD4F8AE6
8E564186CAD5F08D974A4101668D77ED8E564100000038AB974A4100000064D28E5641000000
70C2974A4100000074D98E56410000000CCC974A4100000080CB8E564100000094E4974A4100
00003CBF8E56410000005876984A41000000F8838E56410000007400994A4100000060B28E56
410000002051994A4100000084D88E5641000000B4859A4A410000000CB68E564100000080CE
9B4A4100000070A58E5641000000F8759C4A410000000CB88E5641000000AC399E4A41000000
103C8E56410000004C099F4A41000000A0FD8D5641000000FC859F4A41000000D4848D564100
000010AF9F4A41000000088B8D5641000000E0BF9F4A41000000F0878D5641000000840DA04A
4100000024988D5641000000AC6EA04A41000000D4B08D564100000010C1A04A4100000034C1
8D5641000000FCF1A04A4100000034CC8D56410000000413A14A4100000018DB8D5641000000
4828A14A41000000D4EE8D56410000000C3AA14A41000000FC038E56410000001C63A14A4100
00000C0A8E5641000000007FA14A41000000B0068E5641000000A497A14A41000000E80A8E56
410000003CB0A14A41000000D8118E564100000080C0A14A4100000068088E5641000000BCFB
A14A4100000090048E5641000000C83EA24A41000000D4088E5641000000CC77A24A41000000
A8048E564100000050A6A24A41000000D0058E564100000050E8A24A410000000C118E564100
0000F01BA34A41000000980E8E5641000000784DA34A41000000C8028E5641000000A872A34A
410000006CF68D5641000000C097A34A4100000000F28D5641000000B0CEA34A4100000064FC
8D56410000000410A44A41000000000A8E5641000000A44DA44A4100000068118E5641000000
2C7EA44A410000008C098E56410000001CB7A44A41000000EC0A8E56410000004CDCA44A4100
000040188E5641000000DCEBA44A41000000D02B8E56410000006004A54A410000003C398E56
41000000A023A54A410000003C3F8E5641000000644DA54A41000000E43F8E5641000000646E
A54A41000000303A8E56410000009093A54A41000000782E8E5641000000208AA54A41000000
FCF98D564100000038F7A54A4100000064888D564100000010B6A54A410000000C868D564100
000050BCA54A41000000D8738D564100000084D0A54A41000000085F8D564100000074EDA54A
4100000038548D56410000003012A64A41000000D0528D5641000000F833A64A410000004C59
8D5641000000FC37A64A410000005C488D5641000000506AA64A4100000008308D5641000000
C014A74A41000000F0DA8C5641000000AC87A74A4100000014D98C564100000014A0A74A4100
0000F4ED8C564100000080BAA74A4100000060FB8C5641000000C0E5A74A4100000058038D56
410000003017A84A41000000F8FE8C5641000000E03EA84A4100000004F58C56410000000060
A84A4100000050E58C5641000000045DA84A4100000034D78C5641000000404FA84A41000000
78CA8C5641000000CC60A84A4100000018C08C5641000000AC5AA84A410000002CB18C564100
00006863A84A4100000000A28C56410000003863A84A41000000B0978C5641000000F447A84A
41000000C4838C564100000054D9A74A4100000004788C5641000000C4FFA74A41000000980C
8C564100000050FEA74A4100000034EA8B5641000000E0BBA74A4100000028E88B5641000000
7CA0A74A41000000BCDD8B56410000002C99A74A4100000050C88B5641000000C06DA74A4100
00001C6B8B5641000000083CA74A41000000946D8B5641000000F435A74A41000000D85A8B56
410000005062A74A410000009C568B5641000000806CA74A41000000FC398B5641000000D06B
A74A4100000060258B56410000004851A74A4100000080A98A56410000004C48A74A41000000
949A8A56410000003433A74A41000000C4918A564100000030C5A74A41000000702B8A564100
00006C26A84A41000000740D8A5641000000CC91A84A410000000CEF89564100000030E9A84A
4100000040D38956410000008043A94A4100000030B389564100000030A4A94A41000000A88F
8956410000007860AA4A41000000B049895641000000F046AA4A410000004CF5885641000000
E4EBA94A41000000944488564100000058E0A74A41000000ACF4885641000000C0B9A74A4100
00007C0B8956410000005485A74A4100000008F2885641000000986EA44A41000000F0668756
410000003C24A44A41000000AC4E875641000000DC01A44A41000000F04487564100000050F6
A34A41000000A81E87564100000008D7A34A410000001CFB865641000000E8D4A34A41000000
54D9865641000000889BA34A41000000A8AA8656410000000885A34A41000000648C86564100
0000C876A34A41000000F87B865641000000443DA34A410000006462865641000000BCFFA24A
41000000E043865641000000D4D6A24A41000000A425865641000000F4AEA24A410000005003
8656410000009C92A24A4100000020DC855641000000446EA24A410000008CD5855641000000
F85BA24A41000000F0DE855641000000804DA24A4100000024D98556410000003826A24A4100
000084D685564100000064FBA14A410000003CD685564100000090BAA14A4100000000E98556
41000000149AA14A4100000068FD8556410000000883A14A410000009C06865641000000403F
A14A4100000084F2855641000000D408A14A4100000058EB855641000000F491A04A41000000
D0208656410000006459A04A41000000A033865641000000C8309E4A410000005C3E86564100
000020EC9D4A41000000D84586564100000048D19D4A41000000941B86564100000040099D4A
41000000601B8656410000006CFD9C4A41000000C8058656410000003C899C4A410000006420
86564100000020699C4A4100000088EA85564100000050EB9B4A4100000050F1855641000000
A8FB9A4A410000000C6086564100000084B89A4A41000000305186564100000068319A4A4100
00002843865641000000F0AE994A41000000C43F8656410000008844994A4100000030458656
41000000E010994A41000000FC1D8656410000004C91984A410000008CDE85564100000074AC
974A410000001C11865641000000506C974A41000000C8D7855641000000584D974A41000000
E0E6855641000000841B974A410000008CC885564100000050DE964A410000007CC185564100
00001C73964A41000000BCB6855641000000784A964A41000000E4D385564100000034EA954A
4100000028F7855641000000C020964A41000000401A8656410000009C3F964A41000000E04D
8656410000006C8D964A41000000BCA486564100000084C4964A4100000014ED865641000000
38E9964A410000000432875641000000DC4B974A41000000B4088856410000002819974A4100
0000403A885641000000345E974A41000000104A885641000000E052974A410000005C5D8856
41000000A83C974A410000001C7A88564100000084EB964A4100000098E1885641000000C45C
964A4100000010F38856410000001C2E954A41000000BCF98856410000005427954A41000000
A4E78856410000009C28954A4100000010C98856410000003C12954A41000000CC9B88564100
000038FA944A410000006491885641000000A0CA944A41000000248F885641000000B073944A
41000000EC88885641000000D443944A41000000F4808856410000003807944A41000000A47E
8856410000001CEA934A41000000B49188564100000064D9934A41000000ECA5885641000000
FCC4934A4100000048CA88564100000034B6934A4100000030F88856410000006CA1934A4100
000018068956410000000080934A41000000A0108956410000008858934A41000000F4188956
41000000F028934A410000006C12895641000000C8F1924A410000001C0E895641000000C8BE
924A41000000C40D895641000000209E924A41000000FC0A895641000000507E924A41000000
4001895641000000A863924A4100000058FD885641000000EC3F924A41000000980089564100
00000833924A410000004807895641000000F025924A41000000F014895641000000B80F924A
4100000028288956410000000484914A41000000987C8956410000003429914A410000003498
8956410000000843914A410000000CBA895641000000C860914A410000008CB8895641000000
1882914A410000006CE9895641000000E8EC914A4100000078C38956410000002CB6924A4100
0000BC278A564100000040E2924A41000000442B8A5641000000BC0C934A41000000A82E8A56
41000000242D934A41000000DC358A5641000000403B934A41000000D0428A5641000000103D
934A4100000004528A56410000007021934A41000000AC638A5641000000D4F8924A41000000
14748A5641000000FCB0934A41000000F8198B564100000070CE934A41000000341A8B564100
00003815944A410000008C668B5641000000D012944A41000000446F8B5641000000C851944A
41000000D8AD8B56410000005C41944A410000000CB18B5641000000E046944A4100000010BA
8B56410000005CF4934A41000000F0D98B5641000000A021944A41000000CC308C5641000000
FCF6934A4100000080388C5641000000B813944A4100000050748C5641000000104B944A4100
00006C6F8C5641000000C447944A41000000F07B8C5641000000D438944A41000000FC8E8C56
41000000CC0B944A410000000CA08C5641000000E0C1924A41000000C0FB8C56410000000026
944A410000004C768D5641000000F06D944A41000000788F8D5641000000F0CE944A41000000
3CAC8D5641');

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
>   


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users