Static dashboard for open data in Denton.
A geo server is being setup to access a postgresql database. Here's a test URL:
http://gis01.cloudapp.net:8080/geoserver/Private/wms?service=WMS&version=1.1.0&request=GetMap&layers=Private:parcel_unt_data&styles=&bbox=2374140.5,7119699.0,2388426.5,7128551.5&width=768&height=475&srs=EPSG:2276&format=image%2Fjpeg
| Key | Value | Description |
|---|---|---|
| service | WMS |
N/A |
| version | 1.1.0 |
Assumed version of the Geo Server |
| request | GetMap |
Type of data being returned |
| layers | Private:parcel_unt_data |
Specific to the data hosted on the UNT Geo server. |
| styles | bbox=2374140.5,7119699.0,2388426.5,7128551.5 |
¯\_(ツ)_/¯ |
| width | 768 |
Width of image in px |
| height | 475 |
Height of image in px |
| srs | EPSG:2276 |
¯\_(ツ)_/¯ |
| format | image%2Fjpeg |
Format of data, HTML encoded. |
The SQL view parameters are specified by adding the viewparams parameter to the WMS GetMap or the WFS GetFeature request. The viewparams argument is a list of key:value pairs, separated by semicolons:
viewparams=p1:v1;p2:v2;...
If the values contain semicolons or commas these must be escaped with a backslash (e.g. \, and \;).
For example, the popstates SQL View layer can be displayed by invoking the Layer Preview. Initially no parameter values are supplied, so the defaults are used and all the states are displayed,
To display all states having more than 20 million inhabitants the following parameter is added to the GetMap request: &viewparams=low:20000000
To display all states having between 2 and 5 millions inhabitants the view parameters are: &viewparams=low:2000000;high:5000000
Parameters can be provided for multiple layers by separating each parameter map with a comma:
&viewparams=l1p1:v1;l1p2:v2,l2p1:v1;l2p2:v2,...
The number of parameter maps must match the number of layers (featuretypes) included in the request.
View the Sheetsu API docs (beta).
| Dataset | API URL | Description |
|---|---|---|
| Community Facilities | https://sheetsu.com/apis/2705ee3b | A list of facilities around town. |
| Code Violations | https://sheetsu.com/apis/41293eb6 | List of code violations filtered by GeoID (block) |
| Crime Reports | https://sheetsu.com/apis/bb1d8d0d | Aggregation of crime reports. |
| Homeless Survey (2013) | https://sheetsu.com/apis/6208b1ef | Survey of homelessness in City of Denton for 2013. |