[postgis-users] Geoportal Server vs Postgres Geoportal

[Ben Madin]

G’day Nicholas,

We typically use a workflow like :

1. create a table with the desired geometry;
2. use pgsql2shp to dump it as a shapefile;
3. run shptree over it to create a .qix index (for mapserver and qgis, maybe not really necessary);
4. zip the files into an archive;
5. move them to a web accessible directory;
6. change the permissions to allow download.

I’d note that we have recently started using ogr2ogr as pgsql2shp has been stopping about 5 records short of our typical full dataset (global first level administrative districts, with half of Zimbabwe missing!) ogr2ogr is a bit more complex, but can also output other file formats, not just shape file. You can also provide a query (not just a table name) but we don’t do it that way.

cheers

Ben






On 2013-12-23, at 08:45 , Nicholas Tapia <tapia.nicholas at gmail.com> wrote:

> If this is the wrong place to ask this question, please point me in the right direction!
> 
> I'm very new to databases and GIS.  I'm researching geoportals and how they offer geometries for download.
> 
> As I understand it, Esri's "open source" Geoportal Server is the standard method of offering data for download (besides offering shape files for download as a file...like the census website).  It is a software layer on top of the database that allows you to select the geometries you want by drawing a polygon.  It also manages metadata and offers some search methods.
> 
> But it doesn't allow me to make awesome sql queries.  So I want to use pgsql2shp to allow people to download the geometries.   Are there any reasons why I shouldn't offer geometry downloads from a postgres database using pgsql2shp?
> 
> Also, are there any examples of what I'm talking about now?  Are there any postgres dbs that allow for direct download of geometries? And don't use esri geoportal server?
> 
> Thanks!
> 
> -Nicholas
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users


-- 

Ben Madin

t : +61 8 6102 5535
m : +61 448 887 220
e : ben at ausvet.com.au

AusVet Animal Health Services
Western Australia

AusVet's website:  http://www.ausvet.com.au

This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this email are the opinion of the writer only and are not endorsed by AusVet Animal Health Services unless expressly stated otherwise. Although AusVet uses virus scanning software we do not accept liability for viruses or similar in any attachments. Thanks for reading.