<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div><span>Hi Nicholas,</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br><span></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span>We use Geonetwork as an online catalogue - if the record describes a spatial dataset, we have links to (for example - depends on what is available) a geotiff, a shapefile to download, a WFS service, a WMS service, a spreadsheet, a report/paper describing the dataset, presentations, etc.</span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style:
normal;"><br><span></span></div><div class="yui_3_7_2_33_1388524770431_122" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span>You can create the files any way you like, but Geonetwork is (IMHO) a more powerful, interoperable & standards compliant tool than ESRI's Geoportal. In the areas involving environmental information where I work, I'd suggest Geonetwork is far more the "standard" tool than Geoportal, which is only really useful for ESRI users & spatial datasets - related aspatial content is not so well supported by Geoportal - yet spatial datasets often have related documents it is useful to provide as well.</span></div><div class="yui_3_7_2_33_1388524770431_122" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br><span></span></div><div
style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span>We also embed such catalogues in web portals, so that projects can be well documented with relavant reports, data, presentations, online maps etc, are all readily available.<br></span></div><div class="yui_3_7_2_33_1388524770431_125 yui_3_7_2_33_1388524770431_162" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div class="yui_3_7_2_33_1388524770431_125 yui_3_7_2_33_1388524770431_162" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">One of our catalogues: see data & reports at (fully open source based):</div><div class="yui_3_7_2_33_1388524770431_125" style="color: rgb(0, 0, 0); font-size:
16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><a href="http://www.os2020.org.nz/bay-of-islands-coastal-survey-project/">http://www.os2020.org.nz/bay-of-islands-coastal-survey-project/</a></div><div class="yui_3_7_2_33_1388524770431_125" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><a href="https://secure.niwa.co.nz/boi_dc/srv/en/main.home">https://secure.niwa.co.nz/boi_dc/srv/en/main.home</a></div><div class="yui_3_7_2_33_1388524770431_125" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">For Geonetwork,
see:<br><span></span></div><div class="yui_3_7_2_33_1388524770431_54" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><span><a href="http://geonetwork-opensource.org/">http://geonetwork-opensource.org/</a></span></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><a href="http://geonetwork-opensource.org/gallery/gallery.html">http://geonetwork-opensource.org/gallery/gallery.html</a><br><span></span></div><div><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">Alternatively, some
OGC server products support other formats as well as the OGC ones - including shapefiles...</div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div class="yui_3_7_2_33_1388524770431_235" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">UMN mapserver uses OGR to generate content - so formats supported by OGR are supported, including shapefiles built on the fly & zipped up... <br></div><div class="yui_3_7_2_33_1388524770431_235" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"> <a href="http://mapserver.org/output/ogr_output.html#ogr-output">http://mapserver.org/output/ogr_output.html#ogr-output</a></div><div
class="yui_3_7_2_33_1388524770431_235" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">in the mapfile you define a shapefile as a supported format:</div><div class="yui_3_7_2_33_1388524770431_235" style="color: rgb(0, 0, 0); font-size: 16px; background-color: transparent; font-style: normal;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span class="k">OUTPUTFORMAT</span>
<span class="k"><br></span></span></div><div class="yui_3_7_2_33_1388524770431_235" style="color: rgb(0, 0, 0); font-size: 16px; background-color: transparent; font-style: normal;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span class="k"> NAME</span> <span class="s">"SHAPEZIP"</span></span></div><div class="yui_3_7_2_33_1388524770431_235" style="color: rgb(0, 0, 0); font-size: 16px; background-color: transparent; font-style: normal; font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span class="s"> </span><span class="k">DRIVER</span> <span class="s">"OGR/ESRI Shapefile"</span> <br></span></div><div class="yui_3_7_2_33_1388524770431_235" style="color: rgb(0, 0, 0); font-size: 16px; background-color: transparent; font-style: normal; font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family:
Courier New,courier,monaco,monospace,sans-serif;"><span class="k"> FORMATOPTION</span> <span class="s">"STORAGE=memory"</span> <br></span></div><div class="yui_3_7_2_33_1388524770431_235" style="color: rgb(0, 0, 0); font-size: 16px; background-color: transparent; font-style: normal; font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span class="k"> FORMATOPTION</span> <span class="s">"FORM=zip"</span>
<span class="k"><br></span></span></div><div class="yui_3_7_2_33_1388524770431_235" style="color: rgb(0, 0, 0); font-size: 16px; background-color: transparent; font-style: normal; font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span class="k"> FORMATOPTION</span> <span class="s">"FILENAME=result.zip"</span></span></div><div class="yui_3_7_2_33_1388524770431_235" style="color: rgb(0, 0, 0); font-size: 16px; background-color: transparent; font-style: normal; font-family: Courier New,courier,monaco,monospace,sans-serif;"><span style="font-family: Courier New,courier,monaco,monospace,sans-serif;"><span class="s"></span>
<span class="k">END</span></span></div><div class="yui_3_7_2_33_1388524770431_217" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div class="yui_3_7_2_33_1388524770431_217" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">Geoserver also allows layers to be downloaded as zipped up shapefiles rather than OGC Web Services:</div><div class="yui_3_7_2_33_1388524770431_217" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><a href="https://wiki.state.ma.us/confluence/display/massgis/GeoServer+-+WFS+-+Extract+-+Shapefile+Format">https://wiki.state.ma.us/confluence/display/massgis/GeoServer+-+WFS+-+Extract+-+Shapefile+Format</a></div><div
class="yui_3_7_2_33_1388524770431_61" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">you specify the format as a parameter in the URL:<a href="http://giswebservices.massgis.state.ma.us/geoserver/wfs?request=GetFeature&service=wfs&version=1.0.0&typename=massgis:GISDATA.TOWNS_POLY&outputformat=SHAPE-ZIP" class="external-link" rel="nofollow"> ...&outputformat=SHAPE-ZIP</a></div><div class="yui_3_7_2_33_1388524770431_61" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div class="yui_3_7_2_33_1388524770431_61" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div class="yui_3_7_2_33_1388524770431_61" style="color: rgb(0, 0,
0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">Hope this helps, no shortage of Open Source options to deliver data as shapefiles :-)</div><div class="yui_3_7_2_33_1388524770431_61" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div class="yui_3_7_2_33_1388524770431_61" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">(I'm off to sea for a month in a couple of hours - so will not be able to respond to further emails until Feb...)</div><div class="yui_3_7_2_33_1388524770431_61" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div
class="yui_3_7_2_33_1388524770431_61" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div class="yui_3_7_2_33_1388524770431_61" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">Cheers,</div><div class="yui_3_7_2_33_1388524770431_61" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div class="yui_3_7_2_33_1388524770431_61" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"> Brent Wood<br></div><div class="yui_3_7_2_33_1388524770431_61" style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif;
background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font face="Arial" size="2"> <b><span style="font-weight:bold;">From:</span></b> Ben Madin <ben@ausvet.com.au><br> <b><span style="font-weight: bold;">To:</span></b> PostGIS Users Discussion <postgis-users@lists.osgeo.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, December 31, 2013 7:37 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [postgis-users] Geoportal Server vs Postgres Geoportal<br> </font> </div> <div class="y_msg_container"><br>
G’day Nicholas,<br><br>We typically use a workflow like :<br><br>1. create a table with the desired geometry;<br>2. use pgsql2shp to dump it as a shapefile;<br>3. run shptree over it to create a .qix index (for mapserver and qgis, maybe not really necessary);<br>4. zip the files into an archive;<br>5. move them to a web accessible directory;<br>6. change the permissions to allow download.<br><br>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.<br><br>cheers<br><br>Ben<br><br><br><br><br><br><br>On 2013-12-23, at 08:45 , Nicholas Tapia <<a ymailto="mailto:tapia.nicholas@gmail.com"
href="mailto:tapia.nicholas@gmail.com">tapia.nicholas@gmail.com</a>> wrote:<br><br>> If this is the wrong place to ask this question, please point me in the right direction!<br>> <br>> I'm very new to databases and GIS. I'm researching geoportals and how they offer geometries for download.<br>> <br>> 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>> <br>> 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?<br>> <br>> 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?<br>> <br>> Thanks!<br>> <br>> -Nicholas<br>> <br>> _______________________________________________<br>> postgis-users mailing list<br>> <a ymailto="mailto:postgis-users@lists.osgeo.org" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users<br><br><br>-- <br><br>Ben Madin<br><br>t : +61 8 6102 5535<br>m : +61 448 887 220<br>e : <a ymailto="mailto:ben@ausvet.com.au" href="mailto:ben@ausvet.com.au">ben@ausvet.com.au</a><br><br>AusVet Animal Health Services<br>Western Australia<br><br>AusVet's website: http://www.ausvet.com.au<br><br>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.<br><br>_______________________________________________<br>postgis-users mailing list<br><a ymailto="mailto:postgis-users@lists.osgeo.org" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br><br><br></div> </div> </div> </div></body></html>