<!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.16798"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=471084618-03032014><FONT color=#0000ff
size=2 face=Arial>Mike,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=471084618-03032014><FONT color=#0000ff
size=2 face=Arial>GDAL is a hard one in the sense that there are too many things
you can and can't compile into it. I don't think there is any packaged
distribution of PostGIS (even Linux/Unix) that can claim they support all the
available GDAL drivers. I could be wrong. They probably don't
support a lot of the proprietary ones that require signing NDAs to download
the SDK at any rate.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=471084618-03032014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=471084618-03032014><FONT color=#0000ff
size=2 face=Arial>The only other thing we don't package is SFCGAL which we are
planning to package as part of PostGIS 2.2. Again I don't think
any Linux/Unix PostGIS distributions package SFCGAL at this
point.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=471084618-03032014><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=471084618-03032014><FONT color=#0000ff
size=2 face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=471084618-03032014><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV><BR>
<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>Mike
T<BR><B>Sent:</B> Monday, March 03, 2014 1:28 PM<BR><B>To:</B> PostGIS Users
Discussion<BR><B>Subject:</B> Re: [postgis-users] raster2pgsql, netcdf, and
windows<BR></FONT><BR></DIV>
<DIV></DIV>Regina,<BR><BR>Thanks for the feedback. At least I know I
understood the problem correctly. I'll try converting the data as you
suggest, or teasing it with SciPy, at least until I can move the project onto a
Linux box.<BR><BR>Is there a list of any other differences between the full
PostGIS, and what's in the Win executables? That would be good info to
have.<BR><BR>Thanks again!<BR>-Mike<BR><BR>At 10:13 AM 3/3/2014, you wrote:<BR>
<BLOCKQUOTE class=cite cite="" type="cite"><FONT color=#0000ff
size=2>Mike,<BR></FONT> <BR><FONT color=#0000ff size=2>You are correct
the PostGIS windows GDAL lib for raster support (which includes raster2pgsql)
is not built with netcdf support. We built it to not require extra
dependencies beyond what gdal includes,<BR>what you could do is use MS4W
or <A
href="http://www.gisinternals.com/sdk/">http://www.gisinternals.com/sdk/</A>
and use gdal_translate to convert to a supported format. Though this may
not be an option depending on what you want to read from
it.<BR></FONT> <BR><FONT color=#0000ff size=2>I recall trying once to
build in with netcdf and ran into issues (mostly with additional dependencies
required like hdf this that) so put it aside as a non-trivial bit of
effort to include that.<BR></FONT> <BR><FONT color=#0000ff size=2>If
there is enough interest and people are willing to subsidize our effort, we'd
be willing to put in the work to add it and maintain it as part of PostGIS
windows distribution.<BR></FONT> <BR><FONT color=#0000ff
size=2>Thanks,<BR>Regina<BR><A
href="http://www.postgis.us">http://www.postgis.us</A><BR>Windows PostGIS
Stack Builder maintainer<BR></FONT> <BR> <BR> <BR><BR>
<HR>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[<A href="mailto:postgis-users-bounces@lists.osgeo.org" eudora="autourl">
mailto:postgis-users-bounces@lists.osgeo.org</A>] <B>On Behalf Of </B>Mike
T<BR><B>Sent:</B> Thursday, February 27, 2014 1:28 PM<BR><B>To:</B> PostGIS
Users Discussion<BR><B>Subject:</B> [postgis-users] raster2pgsql, netcdf, and
windows<BR></FONT><BR>Hi all,<BR><BR>I'm new to PostGIS, so I apologize in
advance if this has been asked and answered, or if this the wrong
place.<BR><BR>I've just installed Postgres 9.3 on Windows 8.1 from pre-built
binaries, and had installed PostGIS 2.1.1 via Stack Builder . I'm trying
to use raster2pgsql on a netcdf file. Does anyone know if this is
supported on Windows? All I get is "unable to read raster file".
<BR><BR>raster2pgsql -G yields a long list with nothing that looks like
netcdf. From what I've able to gather from the docs, there's some
underlying dependency with GDAL stuff. But on Windows, installing from
pre-built binaries, there's no separate gdal toolkit I can see. I
believe it's all already baked into the distributed executable. If I
need to alter the underlying tools, or rebuild with a netcdf library, I'm not
sure how I'd go about that. I can probably build from sources if I have
to, but I'd really rather not go down that rabbit hole.<BR><BR>I tried
reinstalling PostGIS from the latest dev binary distribution, but there's no
difference.<BR><BR>I was able to install MS4W, which includes a version of
gdal tools for Windows, and, using <I>that</I>, I can read the netcdf
metadata, so I know the file itself is good.<BR><BR>Does anyone know how I can
get raster2pgsql to recognize it? Did I miss a step, or is this just not
possible on Windows?<BR><BR>Any suggestions, or pointers to additional info
would be a big help!<BR><BR>Thanks,<BR>Mike
<BR>_______________________________________________<BR>postgis-users mailing
list<BR>postgis-users@lists.osgeo.org<BR><A
href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users"
eudora="autourl">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</A>
</BLOCKQUOTE></BODY></HTML>