Devon,

Thanks for your help. The table is created for me by the plugin when I provide 
configuration for my postgres datastore in datastore.properties. The create 
table it issues ends up looking like this.

  DEBUG [geotools.jdbc] - Create schema: CREATE TABLE "Temperature_surface" ( 
"fid" int AUTO_INCREMENT(1) PRIMARY KEY, "the_geom" BYTEA COMMENT 'POLYGON', 
"location" VARCHAR(255), "imageindex" INTEGER, "time" TIMESTAMP )

I do have GEOTOOLS_DEVELOPER logging turned on but nothing jumps out at me why 
the time column is not populated in the first place. I can see in the insert 
statement it is passed as null but there is no mention as to why it is null.


After creating the store and layer, when I first try to preview the layer I get 
an exception from the WMS server :

Unable to compute extrema value:TIME_DOMAIN_MINIMUM

which I assume is related to the time column being null.

When I populate the time column with a value, then there appears to be no data, 
and blank tiles returning from the layer.

Thanks in advance for any help.

Steve

From: Devon Tucker [mailto:devonrtuc...@gmail.com]
Sent: Monday, August 15, 2016 9:36 AM
To: Ferguson, Steve -FS <sfergu...@fs.fed.us>
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] Working Grib2 data source does not work as image 
mosaic

Hi Steve,

I'm not an expert in serving GRIB in image mosaic, but would it be possible to 
post your table schema? Possibly as a CREATE TABLE script for testing?

Also, trying to check off some of the obvious stuff, have you tried turning on 
the GEOTOOLS_DEVELOPER logging profile and checking the logs?

On Fri, Aug 12, 2016 at 12:23 PM, Ferguson, Steve -FS 
<sfergu...@fs.fed.us<mailto:sfergu...@fs.fed.us>> wrote:
Greetings,

I am attempting to make a time series using an image mosaic over data from 
Nomads. The grib2 files I get from Nomads work perfectly as a grib2 data 
source. However, when I attempt to create an image mosaic on top of the grib2 
files all I end up with is blank tiles, and requests for data against the 
exposed layer return no data, as though each point on the mosaic has no value. 
I’ve created a datastore.properties, with valid postgres connection 
information. I see the layer is represented in the postgres database, but a 
couple of things are amiss. First the time column on the layer is null. Second 
so is the imageindex column. The time column being null makes it impossible to 
create a layer from the mosaic. If I populate the time column with a value I am 
able to create a layer, but it is completely blank.

This is the grib file : 
http://nomads.ncep.noaa.gov/cgi-bin/filter_hiresconus.pl?file=hiresw.t00z.arw_5km.f00.conus.grib2&lev_surface=on&var_TMP=on&leftlon=0&rightlon=360&toplat=90&bottomlat=-90&dir=%2Fhiresw.20160812


This is my indexer.xml

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Indexer>
  <domains>
    <domain name="time">
      <attributes><attribute>time</attribute></attributes>
    </domain>
  </domains>

    <coverages>
        <coverage>
            <schema name="Temperature_surface">
                
<attributes>the_geom:Polygon,location:String,imageindex:Integer,time:java.util.Date</attributes>
            </schema>
      <domains>
        <domain ref="time" />
      </domains>

            <origName>Temperature_surface</origName>
            <name>Temperature_surface</name>
        </coverage>
    </coverages>
  <parameters>
    <parameter name="AuxiliaryFile" 
value="/gdata/grib/nomads_img/_auxiliary.xml" />


    <parameter name="AbsolutePath" value="true" />
  </parameters>

</Indexer>


This is my _auxiliary.xml

<?xml version="1.0" encoding="UTF-8"?><Indexer>
  <coverages>
    <coverage>
      <schema name="Temperature_surface">
        
<attributes>the_geom:Polygon,location:String,imageindex:Integer,time:java.util.Date</attributes>
      </schema>
      <origName>Temperature_surface</origName>
      <name>Temperature_surface</name>
    </coverage>
  </coverages>
</Indexer>



Any pointers would be greatly appreciated on how to get this grib2 data 
functioning properly as an image mosaic. Many thanks!



[cid:image001.jpg@01D16575.4DC28DF0]

Steve Ferguson
Senior Software Systems Engineer

Forest Service Contractor
Digital Visions Enterprise Team

p: 919-999-4930<tel:919-999-4930> (PST)
sfergu...@fs.fed.us<mailto:sfergu...@fs.fed.us>
[cid:image002.png@01D16575.4DC28DF0]<http://usda.gov/>[cid:image003.png@01D16575.4DC28DF0]<https://twitter.com/forestservice>[cid:image004.png@01D16575.4DC28DF0]<http://facebook.com/USDA>


Caring for the land and serving people










This electronic message contains information generated by the USDA solely for 
the intended recipients. Any unauthorized interception of this message or the 
use or disclosure of the information it contains may violate the law and 
subject the violator to civil or criminal penalties. If you believe you have 
received this message in error, please notify the sender and delete the email 
immediately.

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. http://sdm.link/zohodev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net<mailto:Geoserver-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/geoserver-users

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. http://sdm.link/zohodev2dev
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to