Advertisement
Guest User

Untitled

a guest
Apr 28th, 2016
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.48 KB | None | 0 0
  1. ogr2ogr -append -f PostgreSQL PG:"host=... dbname=... user=... password=..." 2016-04-26_15-32-01.xml
  2.  
  3. exec("ogr2ogr -append -f PostgreSQL PG:"host=".HOST." dbname=".DATABASE." user=".USER." password=".PASSWORD."" /var/www/html/plantas/gps/2016-04-26_15-32-01.xml 2>&1",$output,$retval);
  4.  
  5. ERROR 1: INSERT command for new feature failed.
  6. ERROR: Geometry SRID (0) does not match column SRID (4326)
  7.  
  8. Command: INSERT INTO "waypoints" ("wkb_geometry" , "ele", "time", "name", "cmt", "desc", "sym", "type", "gpxx_waypointextension", "wptx1_waypointextension", "ctx_creationtimeextension") VALUES ('010100000000008C76C2DF4EC00100C0A13A450E40'::GEOMETRY, 594, '2015/11/16 17:22:09+00', 'ROP_2904', '08-NOV-15 9:56:51
  9. PONTO 60', '08-NOV-15 9:56:51
  10. PONTO 60', 'Flag, Blue', 'user', ' SymbolAndName ', ' SymbolAndName ', ' 2015-11-16T17:22:09Z ') RETURNING "ogc_fid"
  11. ERROR 1: Terminating translation prematurely after failed
  12. translation of layer waypoints (use -skipfailures to skip errors)
  13.  
  14. $linha = "ogr2ogr -append -f PostgreSQL PG:"host=".HOST." dbname=".DATABASE." user=".USER." password=".PASSWORD."" -s_srs EPSG:4326 /var/www/html/plantas/gps/2016-04-26_15-32-01.xml 2>&1";
  15. // or $linha = "ogr2ogr -s_srs EPSG:4326 -append -f PostgreSQL PG:"host=".HOST." dbname=".DATABASE." user=".USER." password=".PASSWORD."" /var/www/html/plantas/gps/2016-04-26_15-32-01.xml 2>&1";
  16. exec($linha,$output,$retval);
  17.  
  18. ERROR 1: INSERT command for new feature failed.
  19. ERROR: Geometry SRID (0) does not match column SRID (4326)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement