Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Column | Type |
- -----------------+--------------------------+
- old_id | bigint |
- road_id | bigint |
- road_name | character varying(255) |
- geo | geometry(Geometry,4326) |
- Indexes:
- "roads_final_pkey" PRIMARY KEY, btree ("old_id")
- "roads_final_wkb_geometry_geom_idx" gist (geo)
- Column | Type |
- -------------+-------------------------+
- id | bigint |
- object_id | bigint |
- geoproperty | geometry(Geometry,4326) |
- Indexes:
- "geofeature_pkey" PRIMARY KEY, btree (id)
- "geoproperty_idx" gist (geoproperty)
- "object_id_idx" btree (object_id)
- 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);
- 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