Thread

1. shp2pgsql error under windows

   Raivo Rebane <raivore55@gmail.com> — 2023-03-04T15:53:10Z

   Hi
   
   
   
   I am usingPS F:\3D-data\Kataster> shp2pgsql -g piirid SHP_KATASTRIYKSUS
   kataster > kataster.sql under Windows 10
   
   
   
   And it’s output is  full of zeroe
   
   
   
   Cygwin helps to find them out,
   
   
   
   Raivo@DESKTOP-69FUU49 /cygdrive/f/3D-data/Kataster
   
   $ cat kataster.sql | less
   
   
   
   <FF><FE>S^@E^@T^@ ^@C^@L^@I^@E^@N^@T^@_^@E^@N^@C^@O^@D^@I^@N^@G^@ ^@T^@O^@
   ^@U^@T^@F^@8^@;^@^M^@
   
   ^@S^@E^@T^@
   ^@S^@T^@A^@N^@D^@A^@R^@D^@_^@C^@O^@N^@F^@O^@R^@M^@I^@N^@G^@_^@S^@T^@R^@I^@N^@G^@S^@
   ^@T^@O^@ ^@O^@N^@;^@^M^@
   
   ^@B^@E^@G^@I^@N^@;^@^M^@
   
   ^@C^@R^@E^@A^@T^@E^@ ^@T^@A^@B^@L^@E^@ ^@"^@k^@a^@t^@a^@s^@t^@e^@r^@"^@
   ^@(^@g^@i^@d^@ ^@s^@e^@r^@i^@a^@l^@,^@^M^@
   
   ^@"^@t^@u^@n^@n^@u^@s^@"^@ ^@v^@a^@r^@c^@h^@a^@r^@(^@2^@5^@)^@,^@^M^@
   
   ^@"^@h^@k^@o^@o^@d^@"^@ ^@v^@a^@r^@c^@h^@a^@r^@(^@4^@)^@,^@^M^@
   
   ^@"^@m^@k^@_^@n^@i^@m^@i^@"^@ ^@v^@a^@r^@c^@h^@a^@r^@(^@1^@0^@0^@)^@,^@^M^@
   
   ^@"^@o^@v^@_^@n^@i^@m^@i^@"^@ ^@v^@a^@r^@c^@h^@a^@r^@(^@1^@0^@0^@)^@,^@^M^@
   
   ^@"^@a^@y^@_^@n^@i^@m^@i^@"^@ ^@v^@a^@r^@c^@h^@a^@r^@(^@1^@0^@0^@)^@,^@^M^@
   
   ^@"^@l^@_^@a^@a^@d^@r^@e^@s^@s^@"^@
   ^@v^@a^@r^@c^@h^@a^@r^@(^@2^@4^@0^@)^@,^@^M^@
   
   ^@"^@r^@e^@g^@i^@s^@t^@r^@"^@ ^@d^@a^@t^@e^@,^@^M^@
   
   ^@"^@m^@u^@u^@d^@e^@t^@"^@ ^@d^@a^@t^@e^@,^@^M^@
   
   ^@"^@s^@i^@h^@t^@1^@"^@ ^@v^@a^@r^@c^@h^@a^@r^@(^@4^@5^@)^@,^@^M^@
   
   ^@"^@s^@i^@h^@t^@2^@"^@ ^@v^@a^@r^@c^@h^@a^@r^@(^@4^@5^@)^@,^@^M^@
   
   ^@"^@s^@i^@h^@t^@3^@"^@ ^@v^@a^@r^@c^@h^@a^@r^@(^@4^@5
   
   
   
   How to generate proper sql output
   
   
   
   Regards
   
   
   
   Raivo
   

2. Re: shp2pgsql error under windows

   Christoph Moench-Tegeder <cmt@burggraben.net> — 2023-03-04T16:05:36Z

   ## Raivo Rebane (raivore55@gmail.com):
   
   > Raivo@DESKTOP-69FUU49 /cygdrive/f/3D-data/Kataster
   > 
   > $ cat kataster.sql | less
   > 
   > 
   > 
   > <FF><FE>S^@E^@T^@ ^@C^@L^@I^@E^@N^@T^@_^@E^@N^@C^@O^@D^@I^@N^@G^@ ^@T^@O^@
   
   That's a BOM and the rest looks like UTF-16 (or UCS-2). You can use
   recode (also available in Cygwin) to convert that. You could also use
   shp2pgsql in Cygwin and be done with that (Windows is a quite bloated
   bootloader for Cygwin, but you do you)).
   
   Regards,
   Christoph
   
   -- 
   Spare Space