PostgreSQL Connection Database Error: PostgreSQL Query Error: On: SELECT id,name,itinerary,description,route_type_id,horizontal_distance,positive_difference,negative_difference,aproximated_time,aproximated_reverse_time,mide_harshness,mide_orientation,mide_difficulty,mide_effort,mide_reverse_effort,reference,published,btt_level,ST_ZMax(geom) AS max_altitude,mide_rappel,mide_climb_grade,mide_snow_possible,mide_snow_certain,alternate_name,override_time,override_reverse_time,surface_percent_high,surface_percent_medium,surface_percent_low,created_year,created_by,last_maintenance_year,last_maintenance_by,alerts,description2,override_horizontal_distance,override_positive_difference,override_negative_difference FROM routes WHERE published='t' ORDER BY name;PostgreSQL Query Error: On: SELECT
MAX(ST_X((table_extent).geom)) AS max_long, MAX(ST_Y((table_extent).geom)) AS max_lat,
MIN(ST_X((table_extent).geom)) AS min_long, MIN(ST_Y((table_extent).geom)) AS min_lat
FROM (
SELECT ST_DumpPoints(ST_Extent(geom)) as table_extent FROM routes WHERE id=791
) AS extent;
Senderos Turísticos de Aragón - Rutas en 3D