Re: [OSGeo-Discuss] Need for to to convert/deconstruct a shapefile to create a relational table

2012-03-18 Thread Simon Cropper
On 17/03/12 00:06, Stephen Woodbridge wrote: On 3/16/2012 12:52 AM, Simon Cropper wrote: Hi, Does anyone know of a simple means to take a shapefile and create a either a SQLite or xBase table? Essentially it is taking an attached attribute table, inserting the coordinates in a field and

Re: [OSGeo-Discuss] Need for to to convert/deconstruct a shapefile to create a relational table

2012-03-18 Thread Stephen Woodbridge
On 3/18/2012 7:50 PM, Simon Cropper wrote: On 17/03/12 00:06, Stephen Woodbridge wrote: On 3/16/2012 12:52 AM, Simon Cropper wrote: Hi, Does anyone know of a simple means to take a shapefile and create a either a SQLite or xBase table? Essentially it is taking an attached attribute table,

Re: [OSGeo-Discuss] Need for to to convert/deconstruct a shapefile to create a relational table

2012-03-18 Thread Simon Cropper
On 19/03/12 12:46, Stephen Woodbridge wrote: On 3/18/2012 7:50 PM, Simon Cropper wrote: On 17/03/12 00:06, Stephen Woodbridge wrote: On 3/16/2012 12:52 AM, Simon Cropper wrote: Hi, Does anyone know of a simple means to take a shapefile and create a either a SQLite or xBase table?

Re: [OSGeo-Discuss] Need for to to convert/deconstruct a shapefile to create a relational table

2012-03-18 Thread Tyler Mitchell
On 2012-03-18, at 6:46 PM, Stephen Woodbridge wrote: Does this get you any closer to what you need: SELECT OGR_GEOM_WKT, * FROM data; -Steve That's some nice ogr-foo to learn :) Simon, it sounds like you could wrap this up pretty quickly in a python script too. A rough approach

[OSGeo-Discuss] Need for to to convert/deconstruct a shapefile to create a relational table

2012-03-16 Thread Simon Cropper
Hi, Does anyone know of a simple means to take a shapefile and create a either a SQLite or xBase table? Essentially it is taking an attached attribute table, inserting the coordinates in a field and saving the new file in a designated format. Most of the data being converted is point data

Re: [OSGeo-Discuss] Need for to to convert/deconstruct a shapefile to create a relational table

2012-03-16 Thread Stephen Woodbridge
On 3/16/2012 12:52 AM, Simon Cropper wrote: Hi, Does anyone know of a simple means to take a shapefile and create a either a SQLite or xBase table? Essentially it is taking an attached attribute table, inserting the coordinates in a field and saving the new file in a designated format. Most

Re: [OSGeo-Discuss] Need for to to convert/deconstruct a shapefile to create a relational table

2012-03-16 Thread Micha Silver
On 03/16/2012 06:52 AM, Simon Cropper wrote: Hi, Does anyone know of a simple means to take a shapefile and create a either a SQLite or xBase table? Essentially it is taking an attached attribute table, inserting the coordinates

RE: [OSGeo-Discuss] Need for to to convert/deconstruct a shapefile to create a relational table

2012-03-16 Thread Fawcett, David (MPCA)
This could also likely be scripted using OGR’s Python bindings. From: discuss-boun...@lists.osgeo.org [mailto:discuss-boun...@lists.osgeo.org] On Behalf Of Micha Silver Sent: Friday, March 16, 2012 11:04 AM To: OSGeo Discussions Subject: Re: [OSGeo-Discuss] Need for to to convert/deconstruct a