Adrian, On 02/02/11 12:16, Adrian Klaver wrote: > On Tuesday, February 01, 2011 5:10:17 pm Paul McNett wrote: >> On 2/1/11 4:46 PM, Simon Cropper wrote: >>> Just starting to play with Dabo App Wizard. >>> >>> Does anyone know how to make this work on dbase or VFP files directly? >> >> Currently, there's no support for it. Best to convert dbase or VFP data to >> a supported database such as SQLite. >> >>> I know that files can be imported to SQLLite but some of these files are >>> associated with spatial data in ESRI Shapefiles (that is, I can't change >>> them). >> >> You can't convert the Shapefiles? >> > > If you use Postgres with the Postgis extension you can use the shp2pgsql > loader > documented here to convert files: > http://www.postgis.org/docs/ch04.html#id2637968 >
Same comment as I just made to Paul. Global import and export of shapefiles, loose tables or databases is an option but adds to the workflow of a project. This certainly seems to be the way I kept getting pushed when ever I try and resolve the shapefile issue. I am not keen however in creating an enormous reference and transitory file database of geospatial data that I will need to manage. Shapefiles have their advantage in they are localised and can be stored in the project directory. I could probably create a separate PostgreSQL+PostGIS database for every project but this is excessive. All existing GIS packages still read shapefiles it is just their table editing solutions are quite primitive. SQLLite has the option of having localised files in project directories but I am not sure how easy it will be to import/export dbase so it does not add significantly to the workflow. If I could do this programmatically, either with scripts or dabo, this would be good. There has been a push of late to make SQLLite Spatially aware but as this is a new area few of the FOSS GIS are setup to interact with these tables -- at best you can get data in but not out. I need both directions. Cheers Simon _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
