NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
These queries depends on the business rules in the country. More queries than the ones below are added to V6.0 as Saved searches with a syntax that works as Saved search <br />
'''CR where area/calc area have 15% difference'''
<pre>
SELECT
hazreduc_localid,
areasize,
calculated_area
FROM hazreduc Inner Join imsmaenum ON hazreduc.hazreductypeenum_guid = imsmaenum.imsmaenum_guid
WHERE imsmaenum.enumvalue = 'CompletionReport' AND
( (coalesce(areasize,0) > (coalesce( hazreduc.calculated_area, 0 ) * 1.15 )) OR
( coalesce( areasize, 0 ) < (coalesce( hazreduc.calculated_area, 0 ) * 0.85) ))
ORDER BY
hazreduc_localid
</pre>
'''CR without devices'''
<pre>
SELECT hazreduc.hazreduc_localid
FROM hazreduc Inner Join imsmaenum ON hazreduc.hazreductypeenum_guid = imsmaenum.imsmaenum_guid
Left Join hazreducdeviceinfo ON hazreduc.hazreduc_guid = hazreducdeviceinfo.hazreduc_guid
WHERE imsmaenum.enumvalue = 'CompletionReport' AND
hazreducdeviceinfo.hazreduc_guid IS NULL
ORDER BY
hazreduc.hazreduc_localid
</pre>
'''CR without polygon/polyline'''
<pre>