Re: [Geoserver-users] Fwd: Unable to create an ImageMosaic store using a PostGIS tile index (v2.8.2)
I seem to have worked around this issue. Only problem is, I'm not sure I can explain exactly how. Seems setting CanBeEmpty=true in indexer.properties helped. Also, once the store was created, I was unable to create a layer from it until the db table was actually populated with valid tiles. Jason Newmoyer Newmoyer Geospatial Solutions 843.606.0424 ja...@newmoyergeospatial.com On Mon, Mar 14, 2016 at 9:47 AM, Jason Newmoyer < ja...@newmoyergeospatial.com> wrote: > So, you're saying the process should be: > > 1. drop datastore.properties and indexer.properties into the data dir > along with a set of granules. > 2. Point geoserver to the directory, and it will generate the layer > properties file, create the index table in postgis, and populate it with > the granules index records - this requires the geoserver user to have > create access within our database. > > > Jason Newmoyer > Newmoyer Geospatial Solutions > 843.606.0424 > ja...@newmoyergeospatial.com > > > > On Fri, Mar 11, 2016 at 10:54 AM, Simone Giannecchini < > simone.giannecch...@geo-solutions.it> wrote: > >> Ciao Jason, >> that sentencen continues with: >> >> If datastore.properties and indexer.properties exist, they should be >> in the same directory as this configuration file. >> >> but you are right we don't explicitly say ( at least at a first >> glance, I am in a meeting :) ) that the mosaic properties files is >> autogenerated by GeoServer. >> >> I remember at a certaing point we prototyped the functionality to use >> an existing table but I am not sure it got published. >> I will check on Mon. >> >> Regards, >> Simone Giannecchini >> == >> GeoServer Professional Services from the experts! >> Visit http://goo.gl/it488V for more information. >> == >> Ing. Simone Giannecchini >> @simogeo >> Founder/Director >> >> GeoSolutions S.A.S. >> Via di Montramito 3/A >> 55054 Massarosa (LU) >> Italy >> phone: +39 0584 962313 >> fax: +39 0584 1660272 >> mob: +39 333 8128928 >> >> http://www.geo-solutions.it >> http://twitter.com/geosolutions_it >> >> --- >> AVVERTENZE AI SENSI DEL D.Lgs. 196/2003 >> Le informazioni contenute in questo messaggio di posta elettronica e/o >> nel/i file/s allegato/i sono da considerarsi strettamente riservate. >> Il loro utilizzo è consentito esclusivamente al destinatario del >> messaggio, per le finalità indicate nel messaggio stesso. Qualora >> riceviate questo messaggio senza esserne il destinatario, Vi preghiamo >> cortesemente di darcene notizia via e-mail e di procedere alla >> distruzione del messaggio stesso, cancellandolo dal Vostro sistema. >> Conservare il messaggio stesso, divulgarlo anche in parte, >> distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità >> diverse, costituisce comportamento contrario ai principi dettati dal >> D.Lgs. 196/2003. >> >> The information in this message and/or attachments, is intended solely >> for the attention and use of the named addressee(s) and may be >> confidential or proprietary in nature or covered by the provisions of >> privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New >> Data Protection Code).Any use not in accord with its purpose, any >> disclosure, reproduction, copying, distribution, or either >> dissemination, either whole or partial, is strictly forbidden except >> previous formal approval of the named addressee(s). If you are not the >> intended recipient, please contact immediately the sender by >> telephone, fax or e-mail and delete the information in this message >> that has been received in error. The sender does not give any warranty >> or accept liability as the content, accuracy or completeness of sent >> messages and accepts no responsibility for changes made after they >> were sent or for other risks which arise as a result of e-mail >> transmission, viruses, etc. >> >> >> On Fri, Mar 11, 2016 at 4:47 PM, Jason Newmoyer >> wrote: >> > Simone, thanks for your response. >> > >> > If what you are saying is true, then I am very confused about this >> document: >> > >> > >> http://docs.geoserver.org/latest/en/user/tutorials/image_mosaic_plugin/imagemosaic.html#create-a-new-coveragestore >> > >> > Says one of the options for the Connection Parameters field is "The >> absolute >> > path to the configuration file (*.properties) or a directory containing >> the >> > configuration file." >> > >> > >> > Jason Newmoyer >> > Newmoyer Geospatial Solutions >> > 843.606.0424 >> > ja...@newmoyergeospatial.com >> > >> > >> > >> > On Wed, Mar 9, 2016 at 5:24 PM, Simone Giannecchini >> > wrote: >> >> >> >> Ciao Jason, >> >> please, read below... >> >> >> >> >> >> Regards, >> >> Simone Giannecchini >> >> == >> >> GeoServer Professional Services from the experts! >> >> Visit http://goo.gl/it488V for more information. >> >> == >> >> Ing. Simone Giannecchini >> >> @simogeo >> >> Founder/Director >> >> >> >> GeoSolutions S.A.S. >> >> Via di Montramito 3/A >> >> 55054 Massarosa (
Re: [Geoserver-users] Fwd: Unable to create an ImageMosaic store using a PostGIS tile index (v2.8.2)
So, you're saying the process should be: 1. drop datastore.properties and indexer.properties into the data dir along with a set of granules. 2. Point geoserver to the directory, and it will generate the layer properties file, create the index table in postgis, and populate it with the granules index records - this requires the geoserver user to have create access within our database. Jason Newmoyer Newmoyer Geospatial Solutions 843.606.0424 ja...@newmoyergeospatial.com On Fri, Mar 11, 2016 at 10:54 AM, Simone Giannecchini < simone.giannecch...@geo-solutions.it> wrote: > Ciao Jason, > that sentencen continues with: > > If datastore.properties and indexer.properties exist, they should be > in the same directory as this configuration file. > > but you are right we don't explicitly say ( at least at a first > glance, I am in a meeting :) ) that the mosaic properties files is > autogenerated by GeoServer. > > I remember at a certaing point we prototyped the functionality to use > an existing table but I am not sure it got published. > I will check on Mon. > > Regards, > Simone Giannecchini > == > GeoServer Professional Services from the experts! > Visit http://goo.gl/it488V for more information. > == > Ing. Simone Giannecchini > @simogeo > Founder/Director > > GeoSolutions S.A.S. > Via di Montramito 3/A > 55054 Massarosa (LU) > Italy > phone: +39 0584 962313 > fax: +39 0584 1660272 > mob: +39 333 8128928 > > http://www.geo-solutions.it > http://twitter.com/geosolutions_it > > --- > AVVERTENZE AI SENSI DEL D.Lgs. 196/2003 > Le informazioni contenute in questo messaggio di posta elettronica e/o > nel/i file/s allegato/i sono da considerarsi strettamente riservate. > Il loro utilizzo è consentito esclusivamente al destinatario del > messaggio, per le finalità indicate nel messaggio stesso. Qualora > riceviate questo messaggio senza esserne il destinatario, Vi preghiamo > cortesemente di darcene notizia via e-mail e di procedere alla > distruzione del messaggio stesso, cancellandolo dal Vostro sistema. > Conservare il messaggio stesso, divulgarlo anche in parte, > distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità > diverse, costituisce comportamento contrario ai principi dettati dal > D.Lgs. 196/2003. > > The information in this message and/or attachments, is intended solely > for the attention and use of the named addressee(s) and may be > confidential or proprietary in nature or covered by the provisions of > privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New > Data Protection Code).Any use not in accord with its purpose, any > disclosure, reproduction, copying, distribution, or either > dissemination, either whole or partial, is strictly forbidden except > previous formal approval of the named addressee(s). If you are not the > intended recipient, please contact immediately the sender by > telephone, fax or e-mail and delete the information in this message > that has been received in error. The sender does not give any warranty > or accept liability as the content, accuracy or completeness of sent > messages and accepts no responsibility for changes made after they > were sent or for other risks which arise as a result of e-mail > transmission, viruses, etc. > > > On Fri, Mar 11, 2016 at 4:47 PM, Jason Newmoyer > wrote: > > Simone, thanks for your response. > > > > If what you are saying is true, then I am very confused about this > document: > > > > > http://docs.geoserver.org/latest/en/user/tutorials/image_mosaic_plugin/imagemosaic.html#create-a-new-coveragestore > > > > Says one of the options for the Connection Parameters field is "The > absolute > > path to the configuration file (*.properties) or a directory containing > the > > configuration file." > > > > > > Jason Newmoyer > > Newmoyer Geospatial Solutions > > 843.606.0424 > > ja...@newmoyergeospatial.com > > > > > > > > On Wed, Mar 9, 2016 at 5:24 PM, Simone Giannecchini > > wrote: > >> > >> Ciao Jason, > >> please, read below... > >> > >> > >> Regards, > >> Simone Giannecchini > >> == > >> GeoServer Professional Services from the experts! > >> Visit http://goo.gl/it488V for more information. > >> == > >> Ing. Simone Giannecchini > >> @simogeo > >> Founder/Director > >> > >> GeoSolutions S.A.S. > >> Via di Montramito 3/A > >> 55054 Massarosa (LU) > >> Italy > >> phone: +39 0584 962313 > >> fax: +39 0584 1660272 > >> mob: +39 333 8128928 > >> > >> http://www.geo-solutions.it > >> http://twitter.com/geosolutions_it > >> > >> --- > >> AVVERTENZE AI SENSI DEL D.Lgs. 196/2003 > >> Le informazioni contenute in questo messaggio di posta elettronica e/o > >> nel/i file/s allegato/i sono da considerarsi strettamente riservate. > >> Il loro utilizzo è consentito esclusivamente al destinatario del > >> messaggio, per le finalità indicate nel messaggio stesso. Qualora > >> riceviate questo messaggio se
Re: [Geoserver-users] Fwd: Unable to create an ImageMosaic store using a PostGIS tile index (v2.8.2)
Ciao Jason, that sentencen continues with: If datastore.properties and indexer.properties exist, they should be in the same directory as this configuration file. but you are right we don't explicitly say ( at least at a first glance, I am in a meeting :) ) that the mosaic properties files is autogenerated by GeoServer. I remember at a certaing point we prototyped the functionality to use an existing table but I am not sure it got published. I will check on Mon. Regards, Simone Giannecchini == GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Simone Giannecchini @simogeo Founder/Director GeoSolutions S.A.S. Via di Montramito 3/A 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 333 8128928 http://www.geo-solutions.it http://twitter.com/geosolutions_it --- AVVERTENZE AI SENSI DEL D.Lgs. 196/2003 Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003. The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc. On Fri, Mar 11, 2016 at 4:47 PM, Jason Newmoyer wrote: > Simone, thanks for your response. > > If what you are saying is true, then I am very confused about this document: > > http://docs.geoserver.org/latest/en/user/tutorials/image_mosaic_plugin/imagemosaic.html#create-a-new-coveragestore > > Says one of the options for the Connection Parameters field is "The absolute > path to the configuration file (*.properties) or a directory containing the > configuration file." > > > Jason Newmoyer > Newmoyer Geospatial Solutions > 843.606.0424 > ja...@newmoyergeospatial.com > > > > On Wed, Mar 9, 2016 at 5:24 PM, Simone Giannecchini > wrote: >> >> Ciao Jason, >> please, read below... >> >> >> Regards, >> Simone Giannecchini >> == >> GeoServer Professional Services from the experts! >> Visit http://goo.gl/it488V for more information. >> == >> Ing. Simone Giannecchini >> @simogeo >> Founder/Director >> >> GeoSolutions S.A.S. >> Via di Montramito 3/A >> 55054 Massarosa (LU) >> Italy >> phone: +39 0584 962313 >> fax: +39 0584 1660272 >> mob: +39 333 8128928 >> >> http://www.geo-solutions.it >> http://twitter.com/geosolutions_it >> >> --- >> AVVERTENZE AI SENSI DEL D.Lgs. 196/2003 >> Le informazioni contenute in questo messaggio di posta elettronica e/o >> nel/i file/s allegato/i sono da considerarsi strettamente riservate. >> Il loro utilizzo è consentito esclusivamente al destinatario del >> messaggio, per le finalità indicate nel messaggio stesso. Qualora >> riceviate questo messaggio senza esserne il destinatario, Vi preghiamo >> cortesemente di darcene notizia via e-mail e di procedere alla >> distruzione del messaggio stesso, cancellandolo dal Vostro sistema. >> Conservare il messaggio stesso, divulgarlo anche in parte, >> distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità >> diverse, costituisce comportamento contrario ai principi dettati dal >> D.Lgs. 196/2003. >> >> The information in this message and/or attachments, is intended solely >> for the attention and use of the named addressee(s) and may be >> confidential or proprietary in nature or covered by the provisions of >> privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New >> Data Protection Code).Any use not in accord with its purpose, any >> disclosure, reproduction, copying, distribution, or eith
Re: [Geoserver-users] Fwd: Unable to create an ImageMosaic store using a PostGIS tile index (v2.8.2)
Simone, thanks for your response. If what you are saying is true, then I am very confused about this document: http://docs.geoserver.org/latest/en/user/tutorials/image_mosaic_plugin/imagemosaic.html#create-a-new-coveragestore Says one of the options for the Connection Parameters field is "The absolute path to the configuration file (*.properties) or a directory containing the configuration file." Jason Newmoyer Newmoyer Geospatial Solutions 843.606.0424 ja...@newmoyergeospatial.com On Wed, Mar 9, 2016 at 5:24 PM, Simone Giannecchini < simone.giannecch...@geo-solutions.it> wrote: > Ciao Jason, > please, read below... > > > Regards, > Simone Giannecchini > == > GeoServer Professional Services from the experts! > Visit http://goo.gl/it488V for more information. > == > Ing. Simone Giannecchini > @simogeo > Founder/Director > > GeoSolutions S.A.S. > Via di Montramito 3/A > 55054 Massarosa (LU) > Italy > phone: +39 0584 962313 > fax: +39 0584 1660272 > mob: +39 333 8128928 > > http://www.geo-solutions.it > http://twitter.com/geosolutions_it > > --- > AVVERTENZE AI SENSI DEL D.Lgs. 196/2003 > Le informazioni contenute in questo messaggio di posta elettronica e/o > nel/i file/s allegato/i sono da considerarsi strettamente riservate. > Il loro utilizzo è consentito esclusivamente al destinatario del > messaggio, per le finalità indicate nel messaggio stesso. Qualora > riceviate questo messaggio senza esserne il destinatario, Vi preghiamo > cortesemente di darcene notizia via e-mail e di procedere alla > distruzione del messaggio stesso, cancellandolo dal Vostro sistema. > Conservare il messaggio stesso, divulgarlo anche in parte, > distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità > diverse, costituisce comportamento contrario ai principi dettati dal > D.Lgs. 196/2003. > > The information in this message and/or attachments, is intended solely > for the attention and use of the named addressee(s) and may be > confidential or proprietary in nature or covered by the provisions of > privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New > Data Protection Code).Any use not in accord with its purpose, any > disclosure, reproduction, copying, distribution, or either > dissemination, either whole or partial, is strictly forbidden except > previous formal approval of the named addressee(s). If you are not the > intended recipient, please contact immediately the sender by > telephone, fax or e-mail and delete the information in this message > that has been received in error. The sender does not give any warranty > or accept liability as the content, accuracy or completeness of sent > messages and accepts no responsibility for changes made after they > were sent or for other risks which arise as a result of e-mail > transmission, viruses, etc. > > > On Fri, Feb 26, 2016 at 10:20 PM, Jason Newmoyer > wrote: > > Hi GeoServer Users, > > > > I am unable to create an ImageMosaic store using a PostGIS tile index. > I am > > also unable to get GS to produce any meaningful error message. > > > > This is version: GeoServer 2.8.2 > > > > Here are my various config files. I have verified my JNDC datasource is > > available by creating a PostGIS/JNDI store using it to create a layer. > Also > > I can create an ImageMosaic from the geotiffs I'm using by > > removing all the config files and allowing GeoServer to create the > ShapeFile > > index for me. Previewing the layer works fine when doing that. > > > > When creating the store, I have tried pointing the URL to the directory > > where the config files reside, and also directly to the layer.properties. > > layer.properties should be created by GeoServer hence it should not be > around before the mosaic is actually created. > > > From the docs I wasn't sure which is the correct way. > > > > Thanks! > > > > - > > layer.properties > > - > > Levels=0.001038,0.0010063 > > 0.0019875075,0.0020126 > > 0.003975015,0.004025 > > 0.00795003,0.00796969696969702 > > 0.01590006,0.01593939393939404 > > 0.03180012,0.03187878787878808 > > 0.053000201,0.06188235294117687 > > 0.079500301,0.116888964 > > 0.159000603,0.210400134 > > Heterogeneous=false > > AbsolutePath=false > > Name=hires > > TypeName=tiles_hires_view > > Caching=false > > ExpandToRGB=false > > LocationAttribute=location > > SuggestedSPI=it.geosolutions.imageioimpl.plugins.tiff.TIFFImageReaderSpi > > CheckAuxiliaryMetadata=false > > LevelsNum=9 > > > > --- > > datastore.properties > > - > > SPI=org.geotools.data.postgis.PostgisNGJNDIDataStoreFactory > > jndiReferenceName=mydatabase > > Loose\ bbox=true > > preparedStatements=false > > > > > > indexer.properties > >
Re: [Geoserver-users] Fwd: Unable to create an ImageMosaic store using a PostGIS tile index (v2.8.2)
Ciao Jason,
please, read below...
Regards,
Simone Giannecchini
==
GeoServer Professional Services from the experts!
Visit http://goo.gl/it488V for more information.
==
Ing. Simone Giannecchini
@simogeo
Founder/Director
GeoSolutions S.A.S.
Via di Montramito 3/A
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 333 8128928
http://www.geo-solutions.it
http://twitter.com/geosolutions_it
---
AVVERTENZE AI SENSI DEL D.Lgs. 196/2003
Le informazioni contenute in questo messaggio di posta elettronica e/o
nel/i file/s allegato/i sono da considerarsi strettamente riservate.
Il loro utilizzo è consentito esclusivamente al destinatario del
messaggio, per le finalità indicate nel messaggio stesso. Qualora
riceviate questo messaggio senza esserne il destinatario, Vi preghiamo
cortesemente di darcene notizia via e-mail e di procedere alla
distruzione del messaggio stesso, cancellandolo dal Vostro sistema.
Conservare il messaggio stesso, divulgarlo anche in parte,
distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità
diverse, costituisce comportamento contrario ai principi dettati dal
D.Lgs. 196/2003.
The information in this message and/or attachments, is intended solely
for the attention and use of the named addressee(s) and may be
confidential or proprietary in nature or covered by the provisions of
privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New
Data Protection Code).Any use not in accord with its purpose, any
disclosure, reproduction, copying, distribution, or either
dissemination, either whole or partial, is strictly forbidden except
previous formal approval of the named addressee(s). If you are not the
intended recipient, please contact immediately the sender by
telephone, fax or e-mail and delete the information in this message
that has been received in error. The sender does not give any warranty
or accept liability as the content, accuracy or completeness of sent
messages and accepts no responsibility for changes made after they
were sent or for other risks which arise as a result of e-mail
transmission, viruses, etc.
On Fri, Feb 26, 2016 at 10:20 PM, Jason Newmoyer
wrote:
> Hi GeoServer Users,
>
> I am unable to create an ImageMosaic store using a PostGIS tile index. I am
> also unable to get GS to produce any meaningful error message.
>
> This is version: GeoServer 2.8.2
>
> Here are my various config files. I have verified my JNDC datasource is
> available by creating a PostGIS/JNDI store using it to create a layer. Also
> I can create an ImageMosaic from the geotiffs I'm using by
> removing all the config files and allowing GeoServer to create the ShapeFile
> index for me. Previewing the layer works fine when doing that.
>
> When creating the store, I have tried pointing the URL to the directory
> where the config files reside, and also directly to the layer.properties.
layer.properties should be created by GeoServer hence it should not be
around before the mosaic is actually created.
> From the docs I wasn't sure which is the correct way.
>
> Thanks!
>
> -
> layer.properties
> -
> Levels=0.001038,0.0010063
> 0.0019875075,0.0020126
> 0.003975015,0.004025
> 0.00795003,0.00796969696969702
> 0.01590006,0.01593939393939404
> 0.03180012,0.03187878787878808
> 0.053000201,0.06188235294117687
> 0.079500301,0.116888964
> 0.159000603,0.210400134
> Heterogeneous=false
> AbsolutePath=false
> Name=hires
> TypeName=tiles_hires_view
> Caching=false
> ExpandToRGB=false
> LocationAttribute=location
> SuggestedSPI=it.geosolutions.imageioimpl.plugins.tiff.TIFFImageReaderSpi
> CheckAuxiliaryMetadata=false
> LevelsNum=9
>
> ---
> datastore.properties
> -
> SPI=org.geotools.data.postgis.PostgisNGJNDIDataStoreFactory
> jndiReferenceName=mydatabase
> Loose\ bbox=true
> preparedStatements=false
>
>
> indexer.properties
>
> Schema=*bbox:Polygon,location:String,created:java.util.Date
> PropertyCollectors=TimestampFileNameExtractorSPI[timeregex](created)
> TimeAttribute=created
> AbsolutePath=false
> Caching=false
> CanBeEmpty=false
> #ExpandToRGB=false
> UseExistingSchema=true
>
> -
> timeregex.properties (is this even relevant since my timestamps come from
> the database table?
> --
> regex=[0-9]{8}T[0-9]{9}Z(\?!.\*[0-9]{8}T[0-9]{9}Z.\*)
>
> Here is my table in PostGIS (a view actually):
>
> CREATE OR REPLACE VIEW tiles_hires_view AS
> SELECT concat(tile.name, '.tif') AS location,
> tile.created,
> tile.bbox,
> layer.name AS layer
>FROM tile
> JOIN layer ON tile.layer = layer.id
> WHERE layer.name = 'hires'::text;
>
I believe this is the problem.
ImageM
[Geoserver-users] Fwd: Unable to create an ImageMosaic store using a PostGIS tile index (v2.8.2)
Hi GeoServer Users,
I am unable to create an ImageMosaic store using a PostGIS tile index. I
am also unable to get GS to produce any meaningful error message.
This is version: GeoServer 2.8.2
Here are my various config files. I have verified my JNDC datasource is
available by creating a PostGIS/JNDI store using it to create a layer. Also
I can create an ImageMosaic from the geotiffs I'm using by
removing all the config files and allowing GeoServer to create the
ShapeFile index for me. Previewing the layer works fine when doing that.
When creating the store, I have tried pointing the URL to the directory
where the config files reside, and also directly to the layer.properties.
>From the docs I wasn't sure which is the correct way.
Thanks!
-
layer.properties
-
Levels=0.001038,0.0010063
0.0019875075,0.0020126
0.003975015,0.004025
0.00795003,0.00796969696969702
0.01590006,0.01593939393939404
0.03180012,0.03187878787878808
0.053000201,0.06188235294117687
0.079500301,0.116888964
0.159000603,0.210400134
Heterogeneous=false
AbsolutePath=false
Name=hires
TypeName=tiles_hires_view
Caching=false
ExpandToRGB=false
LocationAttribute=location
SuggestedSPI=it.geosolutions.imageioimpl.plugins.tiff.TIFFImageReaderSpi
CheckAuxiliaryMetadata=false
LevelsNum=9
---
datastore.properties
-
SPI=org.geotools.data.postgis.PostgisNGJNDIDataStoreFactory
jndiReferenceName=mydatabase
Loose\ bbox=true
preparedStatements=false
indexer.properties
Schema=*bbox:Polygon,location:String,created:java.util.Date
PropertyCollectors=TimestampFileNameExtractorSPI[timeregex](created)
TimeAttribute=created
AbsolutePath=false
Caching=false
CanBeEmpty=false
#ExpandToRGB=false
UseExistingSchema=true
-
timeregex.properties (is this even relevant since my timestamps come from
the database table?
--
regex=[0-9]{8}T[0-9]{9}Z(\?!.\*[0-9]{8}T[0-9]{9}Z.\*)
Here is my table in PostGIS (a view actually):
CREATE OR REPLACE VIEW tiles_hires_view AS
SELECT concat(tile.name, '.tif') AS location,
tile.created,
tile.bbox,
layer.name AS layer
FROM tile
JOIN layer ON tile.layer = layer.id
WHERE layer.name = 'hires'::text;
Here is the stacktrace in the log:
2016-02-26 13:50:19,349 INFO [geoserver.web] - Getting list of coverages
for saved store file:data/imagery/hires/hires.properties
java.lang.RuntimeException: Could not list layers for this store, an error
occurred retrieving them: Failed to create reader from
file:data/imagery/hires/hires.properties and hints null
at
org.geoserver.web.data.layer.NewLayerPageProvider.getItemsInternal(NewLayerPageProvider.java:151)
at
org.geoserver.web.data.layer.NewLayerPageProvider.getItems(NewLayerPageProvider.java:59)
at
org.geoserver.web.wicket.GeoServerDataProvider.fullSize(GeoServerDataProvider.java:242)
at
org.geoserver.web.wicket.GeoServerTablePanel$PagerDelegate.updateMatched(GeoServerTablePanel.java:567)
at
org.geoserver.web.wicket.GeoServerTablePanel$PagerDelegate.(GeoServerTablePanel.java:560)
at
org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:172)
at
org.geoserver.web.wicket.GeoServerTablePanel.(GeoServerTablePanel.java:96)
at org.geoserver.web.data.layer.NewLayerPage$1.(NewLayerPage.java:106)
at org.geoserver.web.data.layer.NewLayerPage.(NewLayerPage.java:106)
at
org.geoserver.web.data.store.CoverageStoreNewPage.onSuccessfulSave(CoverageStoreNewPage.java:79)
at
org.geoserver.web.data.store.CoverageStoreNewPage.onSave(CoverageStoreNewPage.java:70)
at
org.geoserver.web.data.store.AbstractCoverageStorePage$1.onSubmit(AbstractCoverageStorePage.java:116)
at
org.apache.wicket.ajax.markup.html.form.AjaxSubmitLink$1.onSubmit(AjaxSubmitLink.java:68)
at
org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:143)
at
org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:177)
at
org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:300)
at
org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:119)
at
org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:92)
at
org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1250)
at org.apache.wicket.RequestCycle.step(RequestCycle.java:1329)
at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1436)
at org.apache.wicket.RequestCycle.request(RequestCycle.java:545)
at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:484)
at
org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:160)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servle
