Sign up ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have an old table that contains bounding boxes of lat long coordinates in a "box" type. How do I convert them to PostGIS geometry ?

I tried using ST_Transform(ST_SetSRID(se.bound_box::box2d::geometry, 4326), 4326) but it says I can't cast box to box2d or to geometry.

Any help much appreciated

share|improve this question

1 Answer 1

If the boxes are already in WGS84 datum, then the following should work

SELECT box2d(se.bound_box)::geometry
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.