Hello Could anyone please tell me the sql query for the following case. I have a polygon which has id,name,latitude and longitude. I used the query: select ASTEXT(polygon) AS polygon from table_name; This gives me all details but are congested. How can I seperate them?
Can you provide more details? What do you mean by congested? What does your table look like? What results are you getting back? What do you want to get back, i.e. what do you want different from what you have?