Guest User

Untitled

a guest
Apr 20th, 2018
90
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. insert into cycle_station (station_id, name, location, ward_name)
  2. values ('1', 'Forestgate Velodrome',
  3. ST_Force3DZ('SRID=27700;POLYHEDRALSURFACEZ(((539524 184627 0, 539521 184634 0, 539534 184639 0, 539537 184632 0, 539524 184627 0)),((539534 184639 2.5, 539521 184634 2.5, 539524 184627 2.5, 539537 184632 2.5, 539534 184639 2.5)), ((539521 184634 0, 539521 184634 2.5, 539524 184627 2.5, 539524 184627 0, 539521 184634 0)), ((539534 184639 0, 539537 184632 2.5, 539537 184632 2.5 , 539537 184632 0, 539534 184639 0)), ((539534 184639 0, 539521 184634 0, 539521 184634 2.5, 539534 184639 2.5, 539534 184639 0)),((539524 184627 0, 539524 184627 2.5, 539537 184632 2.5, 539537 184632 0, 539524 184627 0)))'), 'Forest Gate South');
  4.  
  5. select st_Volume(st_MakeSolid(location)) from cycle_station;
  6. ERROR : ERROR: Solid is invalid : PolyhedralSurface (shell) 0 is invalid: not connected : SOLID((((539524/1 184627/1 0/1,539521/1 184634/1 0/1,539534/1 184639/1 0/1,539537/1 184632/1 0/1,539524/1 184627/1 0/1)),((539534/1 184639/1 5/2,539521/1 184634/1 5/2,539524/1 1846
  7. SQL state: XX000
Add Comment
Please, Sign In to add comment