Opened 19 years ago

Last modified 5 years ago

#812 closed defect (fixed)

OGC WKT EWKT warnings for every insert — at Initial Version

Reported by: brian@… Owned by: warmerdam
Priority: normal Milestone:
Component: default Version: unspecified
Severity: normal Keywords:
Cc:

Description

I'm importing the Tiger dataset into PostgreSQL.  After applying two patches 
(dimension enforcement and array termination), i rebuilt the debian packages 
and installed them. 
 
The import seems to go smoothly but i get a warning for each insert: 
 
WARNING:  OGC WKT expected, EWKT provided - use GeomFromEWKT() for this   
 
I moved this line from ogrpgtablelayer.cpp, line 850: 
  CPLDebug( "OGR_PG", "PQexec(%s)\n", pszCommand ); 
to before the PGexec().  Here are a couple inserts statements 
 
OGR_PG: PQexec(INSERT INTO "completechain" (wkb_geometry , "module", "tlid", 
"source", "fename", "fetype", "fedirs", "cfcc", "fraddl", "toaddl", "fraddr", 
"toaddr", "friaddl", "toiaddl", "friaddr", "toiaddr", "zipl", "zipr", 
"statel", "stater", "countyl", "countyr", "cousubl", "cousubr", "placel", 
"placer","tractl", "tractr", "blockl", "blockr") VALUES 
(GeometryFromText('LINESTRING (-77.10766200 38.929550000.000,-77.10775400 
38.92954800 0.000,-77.10790500 38.92968600 0.000,-77.10812200 38.92990800 
0.000,-77.10861700 38.93039500 0.000,-77.10905100 38.93082500 
0.000,-77.10908200 38.93085900 0.000)'::TEXT,1) , 'TGR11001', 76219112, 'A', 
'Sherrier', 'Pl', 'NW', 'A41', '       5500', '       5598', '       5501', '       
5599', '0', '0', '0', '0', 20016, 20016, 11, 11, 1, 1, 50000, 50000, 50000, 
50000, 902, 902, 4013, 4012)) 
 
OGR_PG_NOTICE: WARNING:  OGC WKT expected, EWKT provided - use GeomFromEWKT() 
for this 
 
OGR_PG: PQexec(INSERT INTO "completechain" (wkb_geometry , "module", "tlid", 
"source", "fename", "fetype", "fedirs", "cfcc", "fraddl", "toaddl", "fraddr", 
"toaddr", "friaddl", "toiaddl", "friaddr", "toiaddr", "zipl", "zipr", 
"statel", "stater", "countyl", "countyr", "cousubl", "cousubr", "placel", 
"placer","tractl", "tractr", "blockl", "blockr") VALUES 
(GeometryFromText('LINESTRING (-77.10881500 38.926940000.000,-77.10884000 
38.92696400 0.000,-77.10887300 38.92700000 0.000,-77.10890300 38.92703900 
0.000,-77.10904000 38.92723300 0.000,-77.10917100 38.92744100 
0.000,-77.10933900 38.92771500 0.000,-77.10951700 38.92801900 
0.000,-77.10965100 38.92825300 0.000,-77.10968000 38.92830100 
0.000)'::TEXT,1) , 'TGR11001', 76219113, 'A', 'Potomac', 'Ave', 'NW', 'A41', '       
5400', '       5498', '       5401', '       5499', '0', '0', '0', '0', 20016, 
20016, 11, 11, 1, 1, 50000, 50000, 50000, 50000, 902, 902, 4005, 4015)) 
 
OGR_PG_NOTICE: WARNING:  OGC WKT expected, EWKT provided - use GeomFromEWKT() 
for this 
 
I don't know what the error is, but if you point me in the right direction, 
i'll try to fix it.

Change History (0)

Note: See TracTickets for help on using tickets.