Spatialite tends to be a drop in replacement for Postgis for these kinds of things.
As pointed out, another way to go would be to use TileStache+Spatialite+CartoCSS(Import to TileMill/Mapbox studio, then export to Mapnik xml)+Mapnik Thanks, Alex On 06/27/2015 05:19 PM, James Keener wrote: > Ah, if you're already using mapserver, I'd see about just exporting the > PostGIS db as a shapefile. Are you worried it'll be too large/too slow? > > Also, the OSM styles are available as CartoCSS, which is supported by > other tilers too. > > Jim > > On 06/27/2015 08:13 PM, Brent Wood wrote: >> Thanks James, >> >> I have looked at >> http://docs.qgis.org/2.8/en/docs/user_manual/working_with_ogc/ogc_server_support.html?highlight=server >> >> which seems like it would work - but I'd still need to avoid Postgis as >> the data source (read only filesystem) and sort out the rendering styles >> for use with QGIS - it may be possible to export the OSM Postgis tables >> as shapefiles & use those as the data source, but I don't know how to go >> about adapting the rendering styles, which is a large part of the value >> of OSM - data plus style. >> >> Cheers, >> >> Brent >> ------------------------------------------------------------------------ >> *From:* James Keener <[email protected]> >> *To:* Brent Wood <[email protected]>; Qgis-user List >> <[email protected]>; Mapserver-users >> <[email protected]>; OSGeo Discussions >> <[email protected]>; Nzopengis <[email protected]>; >> Live-demo <[email protected]> >> *Sent:* Sunday, June 28, 2015 11:52 AM >> *Subject:* Re: [Qgis-user] Live DVD advice >> >> Could you use QGIS Server? It'd take a qgs file and the data it needs >> (which can be any input type QGIS uses, including shapefiles and >> spatialite dbs along with PostGIS). >> >> Jim >> >> >> >> On 06/27/2015 07:46 PM, Brent Wood wrote: >>> Hi, >>> >>> I'm looking to build a LiveDVD/USB key with QGIS, OSM base layer and web >>> services for New Zealand. >>> >>> Our road & topo data is very up to date in OSM, and we have numerous >>> government (central, regional & local) agencies and others providing >>> data via OGC services, so I'm hoping the system will have embedded OSM, >>> and pre-loaded OGC servers to connect to, as well as some QGIS plugins >>> specific to New Zealand. >>> >>> The disk/key is intended for schools & demonstrations showing FOSS, FOSS >>> GIS, Open Data and Open Standards, focused on NZ data. >>> >>> Some years ago I built a laptop system demo'ed at several local schools >>> which worked OK, with mapserver serving OSM via WMS direct from Postgis. >>> NZ is small enough that the data could be rendered dynamically from the >>> vector data in a reasonably interactive system. >>> >>> I can't reasonably use Postgis on a read only filesystem, and all the >>> later guides assume that tiles will be used. Does anyone have any advice >>> as to how I might best do this? >>> >>> Thanks, >>> >>> Brent Wood >> >>> _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
