# Dump shape file - strange behaviour

**URL:** <https://mapwindow.discourse.group/t/dump-shape-file-strange-behaviour/998>\
**Category:** Uncategorized\
**Created:** [May 18, 2021, 4:15pm UTC](https://mapwindow.discourse.group/t/dump-shape-file-strange-behaviour/998 "2021-05-18T16:15:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![colleen](https://avatars.discourse-cdn.com/v4/letter/c/f19dbf/32.png) [@colleen](https://mapwindow.discourse.group/u/colleen)\
**Post date:** [May 18, 2021, 4:15pm UTC](https://mapwindow.discourse.group/t/dump-shape-file-strange-behaviour/998/1 "2021-05-18T16:15:18Z")

</div>

Hi

I am putting this here in case it helps someone else. When doing a dump of the shape file - do not create an ogrLayer from an SQL statement and rename the Shape name eg Select ShapeField as ShapeFld. It does not work if you do this. Also if I used a view of the table to load the shape file it also did not work. It seems to want the sql statement to reference the shape in the actual table and not in a view of the table.

---

<div class="post-metadata">

**Author:** ![pmeems](https://yyz2.discourse-cdn.com/free1/user_avatar/mapwindow.discourse.group/pmeems/32/9_2.png) [@pmeems](https://mapwindow.discourse.group/u/pmeems)\
**Post date:** [January 5, 2022, 11:09am UTC](https://mapwindow.discourse.group/t/dump-shape-file-strange-behaviour/998/2 "2022-01-05T11:09:47Z")

</div>