I loaded a bunch raster data into separate tables. One for each us western
state. I thought it maybe handy to query a view instead of the individual
tables. Anyways everything seemed ok but I started to get errors on a few ids I
was testing. I knew what table it should be pulling from so I queried the table
and no issues. So i must assume the error is because of the “union all” in the
view. Can anyone confirm this and why? I am on postgres 9.2.8 and postgis
2.1.2.
thanks,
jason
query>>>
SELECT
report_id, incident_id,
ST_SummaryStats(
ST_UNION(
ST_Clip(c.rast, 1,
ST_Transform(w.geom, 5070), true)
),
1
) as hdesc
FROM rasters c
JOIN w_reports w
ON ST_Intersects(c.rast, ST_Transform(w.geom, 5070))
where w.incident_id = 5443
group by incident_id, report_id
error>>>
ERROR: rt_raster_from_two_rasters: The two rasters provided do not
have the same alignment
********** Error **********
ERROR: rt_raster_from_two_rasters: The two rasters provided do not have
the same alignment
SQL state: XX000
--
This transmission contains confidential and privileged information intended
solely for the party identified above. If you receive this message in
error, you must not use it or convey it to others. Please destroy it
immediately and contact the sender at (303) 386-3955 or by return e-mail to
the sender.
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
