<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 10.00.9200.16736"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=617224219-23122013><FONT color=#0000ff
size=2 face=Arial>Nicholas,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=617224219-23122013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=617224219-23122013><FONT color=#0000ff
size=2 face=Arial>Not too familiar with Geoportal Server. </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=617224219-23122013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=617224219-23122013><FONT color=#0000ff
size=2 face=Arial>pgsql2shp is what I commonly use for light-weight data
dispensing from web apps.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=617224219-23122013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=617224219-23122013><FONT color=#0000ff
size=2 face=Arial>In php I just call it using system(..)
function</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=617224219-23122013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=617224219-23122013><FONT color=#0000ff
size=2 face=Arial>using code something like</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=617224219-23122013><FONT color=#0000ff
size=2 face=Arial> $shell_cmd = "pgsql2shp
otherpgsql2shp_including sql"<BR> system($shell_cmd);</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=617224219-23122013><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=617224219-23122013><FONT color=#0000ff
size=2 face=Arial>Usually I predump the data the user is viewing working on
tagged by user session in a staging table and the query just outputs the
data based on user session.</FONT></SPAN></DIV>
<DIV><FONT color=#0000ff size=2 face=Arial></FONT> </DIV>
<DIV><SPAN class=617224219-23122013></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>I<SPAN class=617224219-23122013>n ASP.NET I use
System.Diagnostics.Process</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=617224219-23122013></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=617224219-23122013>As far as other tools that can dispense files OGR2OGR
part of GDAL package can output more formats and I think internally is what
Mapserver uses for its WFS 1.1 custom output format
option</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=617224219-23122013></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=617224219-23122013><A
href="http://mapserver.org/output/ogr_output.html#ogr-output">http://mapserver.org/output/ogr_output.html#ogr-output</A></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=617224219-23122013></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=617224219-23122013></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=617224219-23122013>Geoserver can also output WFS requests in Shapefile and
other formats:</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=617224219-23122013><A
href="http://docs.geoserver.org/latest/en/user/services/wfs/outputformats.html">http://docs.geoserver.org/latest/en/user/services/wfs/outputformats.html</A></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=617224219-23122013></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=617224219-23122013>Though overall I prefer the simplicity of pgsql2shp
especially for outputting complex user map
queries.</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=617224219-23122013></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=617224219-23122013>Hope that helps,</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=617224219-23122013>Regina</SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=617224219-23122013><A
href="http://www.postgis.us">http://www.postgis.us</A></SPAN></FONT></FONT></FONT></DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=617224219-23122013></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=617224219-23122013></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=617224219-23122013></SPAN></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Arial><FONT color=#0000ff><FONT size=2><SPAN
class=617224219-23122013></SPAN></FONT></FONT></FONT> </DIV>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Nicholas
Tapia<BR><B>Sent:</B> Sunday, December 22, 2013 7:46 PM<BR><B>To:</B>
postgis-users@lists.osgeo.org<BR><B>Subject:</B> [postgis-users] Geoportal
Server vs Postgres Geoportal<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr>
<DIV>If this is the wrong place to ask this question, please point me in the
right direction!</DIV>
<DIV><BR></DIV>I'm <I>very</I> new to databases and GIS. I'm
researching geoportals and how they offer geometries for download.<BR>
<DIV><BR></DIV>
<DIV>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.<BR></DIV>
<DIV><BR></DIV>
<DIV>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?</DIV>
<DIV><BR></DIV>
<DIV>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?</DIV>
<DIV><BR></DIV>
<DIV>Thanks!</DIV>
<DIV><BR></DIV>
<DIV>-Nicholas</DIV>
<DIV>
<DIV dir=ltr>
<DIV><BR></DIV></DIV></DIV></DIV></BODY></HTML>