I have a two tables.
1 table have srid=4326
2 table have srid=70066
I want to compare geometry columns of this tables. I find function
ST_Equals(geometry, geometry) but its not what i want. I need something what can compare geometries which slightly different from each other like on picture.
i have test polygon in tables with area=9098.79m^2 in first table and with area=9721.82m^2 in sacond table. I try this query
SELECT st_area(ST_Intersection(ST_TRANSFORM(filedata.the_geom,70066),filedata_temp.the_geom)) FROM filedata, filedata_temp Where filedata.num=1
srid=70066 is rectangular coordinate system
and i get query result
why so much?