NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
'''CR without polygon/polyline'''
<pre>
SELECT hazreducDISTINCT hazard.hazreduc_localidhazard_guid FROM hazreduc hazard Inner Join imsmaenum ON hazreduchazard.hazreductypeenum_guid maareatype_guid = imsmaenum.imsmaenum_guid WHERE imsmaenum.enumvalue = 'CompletionReportCHA' AND ( hazreduchazard.hasgeodata = FALSE OR hazreduc hazard.hazreduc_guid hazard_guid NOT IN (SELECT DISTINCT hazreduchazard.hazreduc_guid hazard_guid FROM hazreduc hazard Inner Join hazreduc_has_geospatialinfo hazard_has_geospatialinfo ON hazreduchazard.hazreduc_guid hazard_guid = hazreduc_has_geospatialinfohazard_has_geospatialinfo.hazreduc_guid hazard_guid Inner Join geospatialinfo ON hazreduc_has_geospatialinfohazard_has_geospatialinfo.geospatialinfo_guid = geospatialinfo.geospatialinfo_guid
Inner Join imsmaenum ON geospatialinfo.shapeenum_guid = imsmaenum.imsmaenum_guid
WHERE imsmaenum.enumvalue LIKE 'Poly%'))ORDER BYhazreduc.hazreduc_localid</pre>
'''Open Hazards with links to HazRed or QM'''
<pre>
