Changes

SQL Saved search No geo data

510 bytes added, 08:32, 13 February 2014

Created page with "Note: These queries are in 5.x format '''Accident''' <pre> SELECT accident.accident_localid FROM accident WHERE accident.hasgeodata = '0' ORDER BY accident.accident_localid A..."

Note: These queries are in 5.x format
'''Accident'''
<pre>
SELECT
accident.accident_localid
FROM
accident
WHERE
accident.hasgeodata = '0'
ORDER BY
accident.accident_localid ASC
</pre>
'''Hazard'''
<pre>
SELECT
hazard.hazard_localid
FROM
hazard
WHERE
hazard.hasgeodata = '0'
ORDER BY
hazard.hazard_localid ASC
</pre>
'''Haz Red'''
<pre>
SELECT
hazreduc.hazreduc_localid
FROM
hazreduc
WHERE
hazreduc.hasgeodata = '0'
ORDER BY
hazreduc.hazreduc_localid ASC
</pre>
[[Category:NoPublic]]
[[Category:SQL Queries]]

• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits