Hello,
I'm having an issue ingesting GeoTIFFs as an Image Mosaic. I have a service
that connects to a server and downloads a set of GeoTIFFs. It then calls
geoserver/rest/workspaces/<myWorkspace>/coveragestores/<myCoverageName>/external.imagemosaic?configure=all
to ingest the files into GeoServer. This used to work with PostGIS 1.5.8 and
Geotools 13.1. We have since updated to PostGIS 2.2.5 r15298 and Geotools 15.1
and are now seeing a problem. It fails with a 500 Internal Server Error.
The logs show this error:
Caused by: org.postgresql.util.PSQLException: ERROR: Geometry SRID (0) does not
match column SRID (4326)
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:303)
at
org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:289)
at
org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:266)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:262)
at
org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:157)
at org.geotools.jdbc.JDBCDataStore.insertNonPS(JDBCDataStore.java:1859)
at org.geotools.jdbc.JDBCDataStore.insert(JDBCDataStore.java:1693)
... 123 more
It is my understanding that sometime since PostGIS 1.5.8, the SRID became
required. This leads me to believe that I don't have a CRS set, but this is
the gdalinfo:
Driver: GTiff/GeoTIFF
Files: MY_FILE_201703202303.tiff
Size is 1150, 1150
Coordinate System is:
GEOGCS["WGS 84",
DATUM["WGS_1984",
SPHEROID["WGS 84",6378137,298.257223563,
AUTHORITY["EPSG","7030"]],
AUTHORITY["EPSG","6326"]],
PRIMEM["Greenwich",0],
UNIT["degree",0.0174532925199433],
AUTHORITY["EPSG","4326"]]
Origin = (-78.535599899987162,38.848734082198298)
Pixel Size = (0.004481043304325,-0.003604754925562)
Metadata:
AREA_OR_POINT=Area
TIFFTAG_RESOLUTIONUNIT=1 (unitless)
TIFFTAG_XRESOLUTION=1
TIFFTAG_YRESOLUTION=1
Image Structure Metadata:
INTERLEAVE=PIXEL
Corner Coordinates:
Upper Left ( -78.5355999, 38.8487341) ( 78d32' 8.16"W, 38d50'55.44"N)
Lower Left ( -78.5355999, 34.7032659) ( 78d32' 8.16"W, 34d42'11.76"N)
Upper Right ( -73.3824001, 38.8487341) ( 73d22'56.64"W, 38d50'55.44"N)
Lower Right ( -73.3824001, 34.7032659) ( 73d22'56.64"W, 34d42'11.76"N)
Center ( -75.9590000, 36.7760000) ( 75d57'32.40"W, 36d46'33.60"N)
Band 1 Block=1150x1 Type=Byte, ColorInterp=Red
Mask Flags: PER_DATASET ALPHA
Band 2 Block=1150x1 Type=Byte, ColorInterp=Green
Mask Flags: PER_DATASET ALPHA
Band 3 Block=1150x1 Type=Byte, ColorInterp=Blue
Mask Flags: PER_DATASET ALPHA
Band 4 Block=1150x1 Type=Byte, ColorInterp=Alpha
It looks like the CRS is set, so I'm assuming the SRID would be parsed from the
CRS. Is that assumption not correct? What can I do to resolve this issue?
Thank you,
David Rogers
Software Engineer
General Dynamics Information Technology
[email protected]<mailto:[email protected]>
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users