-- erotima simeiou - query 1
SELECT name, geom
FROM natura
WHERE ST_WITHIN( ST_GeomFromText('POINT(501567  4174606)', 2100), geom);
-- erotima simeiou - query 2
SELECT periphery, geom
FROM perifereies
WHERE ST_WITHIN( ST_GeomFromText('POINT(501567  4174606)', 2100), geom);
-- erotima parathyrou  - query 3
SELECT name, geom
FROM katafygia
WHERE ST_CONTAINS( ST_GeomFromText('POLYGON((186869  4388552,497655 4402847,504044 4047630,255874 4069881,186869  4388552))', 2100), geom);
-- erotima apostasis - query 4
SELECT name, ST_Distance(geom, 'SRID=2100;POINT(501413  4171840)'::geometry) as calc_distance
FROM kpe
ORDER BY calc_distance DESC;
--  - query 5
SELECT  kpe.name,
        natura.name,
        ST_DISTANCE(ST_Transform(kpe.geom, 2100), ST_Transform(natura.geom, 2100)) AS Distance_KPE
FROM    kpe, natura
WHERE ST_DWithin(kpe.geom, natura.geom, 20000);
--erotima xorikis syndesis - query 6
SELECT natura.name, katafygia.name
FROM natura, katafygia
WHERE ST_INTERSECTS(natura.geom, katafygia.geom);
-- - query 7
SELECT natura.name, katafygia.name, ST_Intersection(natura.geom, katafygia.geom)
FROM natura, katafygia
WHERE ST_INTERSECTS(natura.geom, katafygia.geom);
-- - query 8
SELECT railnetwork.gid, railnetwork.geom
FROM railnetwork, katafygia
WHERE ST_Crosses(railnetwork.geom, katafygia.geom);
-- - query 9
SELECT railnetwork.gid, perifereies.periphery, ST_Intersection(railnetwork.geom, perifereies.geom)
FROM railnetwork, perifereies
WHERE ST_Crosses(railnetwork.geom, perifereies.geom);
-- - query 10
SELECT perifereies.periphery, ST_Length(railnetwork.geom), ST_Length(ST_INTERSECTION(railnetwork.geom, perifereies.geom)), ST_INTERSECTION(railnetwork.geom, perifereies.geom)
FROM railnetwork, perifereies
WHERE ST_Crosses(railnetwork.geom, perifereies.geom);
--