...
Example SQL queries
Locations
| No Format |
|---|
SELECT name, y,x from Locations ORDER BY name DESC
SELECT name, y,x from Locations WHERE X > '161000'
SELECT * from Locations where id = '46DP0003' OR id = '46DP0004'
SELECT name from Locations WHERE name <> 'Meerselsche Peel (WAM)'
SELECT id, name, y, x from Locations WHERE id LIKE '254%'
SELECT id, name, y, x from Locations WHERE name LIKE '%STUW%' or name LIKE '%Gemaal%'
|
Filters
Return all location and parameter combinations from a specific filter
| No Format |
|---|
SELECT id, locationid, parameterid FROM filters WHERE id = 'ImportSHEF' ORDER BY location
|
Miscellaneous
Using a different port number (available 200901)
...