Advertisement
Guest User

Untitled

a guest
Oct 6th, 2016
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. Column | Type |
  2. -----------------+--------------------------+
  3. old_id | bigint |
  4. road_id | bigint |
  5. road_name | character varying(255) |
  6. geo | geometry(Geometry,4326) |
  7. Indexes:
  8. "roads_final_pkey" PRIMARY KEY, btree ("old_id")
  9. "roads_final_wkb_geometry_geom_idx" gist (geo)
  10.  
  11. Column | Type |
  12. -------------+-------------------------+
  13. id | bigint |
  14. object_id | bigint |
  15. geoproperty | geometry(Geometry,4326) |
  16. Indexes:
  17. "geofeature_pkey" PRIMARY KEY, btree (id)
  18. "geoproperty_idx" gist (geoproperty)
  19. "object_id_idx" btree (object_id)
  20.  
  21. select count(*) from (select * from dblink('port=5432 dbname=db2 user=usr password=pass','SELECT geoproperty from table2' as t(geoproperty Geometry)) r,table1 t1 where st_equals(t1.geo,r.geoproperty);
  22.  
  23. select * from st_equals(st_geomfromtext('LINESTRING(.line from table1.)'),st_geomfromtext('LINESTRING(.line from table2.)'))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement