Secure websites use HTTPS
Updated 6 months ago
PUB (PUB, Singapore's national water agency)Attribute Legend
Attributes | Data Type | Description |
---|---|---|
Name | Text | - |
Description | Text | - |
Dataset preview
This code can be used to view the raw JSON dataset for PUB CCTV. Large datasets may be truncated in the preview. Please download the dataset for complete data.
{
"type": "FeatureCollection",
"crs": {
"type": "name",
"properties": {
"name": "urn:ogc:def:crs:OGC:1.3:CRS84"
}
},
"features": [
{
"type": "Feature",
"properties": {
"Name": "kml_1",
"Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>CCTVID</th> <td>CU015</td> </tr><tr bgcolor=\"\"> <th>CATCHMENT</th> <td>Stamford/Marina</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>REF_NAME</th> <td>Maxwell Road</td> </tr><tr bgcolor=\"\"> <th>GPS_LONG</th> <td>103.84404</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>GPS_LAT</th> <td>1.28016</td> </tr><tr bgcolor=\"\"> <th>X</th> <td>29193.20719</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>Y</th> <td>29179.11121</td> </tr><tr bgcolor=\"\"> <th>HYPERLINK</th> <td>http://Pub.cloudapp.net/CCTVS/016</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>INC_CRC</th> <td>8B3D289549952885</td> </tr><tr bgcolor=\"\"> <th>FMEL_UPD_D</th> <td>20190611163416</td> </tr></table></center>"
},
"geometry": {
"type": "Point",
"coordinates": [
103.844040000026,
1.28015999988484,
0
]
}
},
{
"type": "Feature",
"properties": {
"Name": "kml_2",
"Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>CCTVID</th> <td>CU016</td> </tr><tr bgcolor=\"\"> <th>CATCHMENT</th> <td>Stamford/Marina</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>REF_NAME</th> <td>Shenton Way</td> </tr><tr bgcolor=\"\"> <th>GPS_LONG</th> <td>103.84994</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>GPS_LAT</th> <td>1.27906</td> </tr><tr bgcolor=\"\"> <th>X</th> <td>29849.83016</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>Y</th> <td>29057.48239</td> </tr><tr bgcolor=\"\"> <th>HYPERLINK</th> <td>http://Pub.cloudapp.net/CCTVS/015</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>INC_CRC</th> <td>8BA7152AC72D4657</td> </tr><tr bgcolor=\"\"> <th>FMEL_UPD_D</th> <td>20190611163416</td> </tr></table></center>"
},
"geometry": {
"type": "Point",
"coordinates": [
103.849940000304,
1.27906000007533,
0
]
}
},
{
"type": "Feature",
"properties": {
"Name": "kml_3",
"Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>CCTVID</th> <td>EC006</td> </tr><tr bgcolor=\"\"> <th>CATCHMENT</th> <td>Changi</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>REF_NAME</th> <td>New Upp Changi Road / Chai Chee Road</td> </tr><tr bgcolor=\"\"> <th>GPS_LONG</th> <td>103.92326</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>GPS_LAT</th> <td>1.32312</td> </tr><tr bgcolor=\"\"> <th>X</th> <td>38009.58564</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>Y</th> <td>33929.58558</td> </tr><tr bgcolor=\"\"> <th>HYPERLINK</th> <td>http://pub.cloudapp.net/CCTVS/296</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>INC_CRC</th> <td>4C793FAA19B80D5B</td> </tr><tr bgcolor=\"\"> <th>FMEL_UPD_D</th> <td>20190611163416</td> </tr></table></center>"
},
"geometry": {
"type": "Point",
"coordinates": [
103.923259999617,
1.32312000016647,
0
]
}
},
{
"type": "Feature",
"properties": {
"Name": "kml_4",
"Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>CCTVID</th> <td>EP004</td> </tr><tr bgcolor=\"\"> <th>CATCHMENT</th> <td>Punggol</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>REF_NAME</th> <td>Pasir Ris St 51</td> </tr><tr bgcolor=\"\"> <th>GPS_LONG</th> <td>103.94869</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>GPS_LAT</th> <td>1.36862</td> </tr><tr bgcolor=\"\"> <th>X</th> <td>40839.45723</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>Y</th> <td>38960.87032</td> </tr><tr bgcolor=\"\"> <th>HYPERLINK</th> <td>http://Pub.cloudapp.net/CCTVS/203</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>INC_CRC</th> <td>62202286626CEF69</td> </tr><tr bgcolor=\"\"> <th>FMEL_UPD_D</th> <td>20190611163416</td> </tr></table></center>"
},
"geometry": {
"type": "Point",
"coordinates": [
103.948689999701,
1.36861999974055,
0
]
}
},
{
"type": "Feature",
"properties": {
"Name": "kml_5",
"Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>CCTVID</th> <td>EP005</td> </tr><tr bgcolor=\"\"> <th>CATCHMENT</th> <td>Punggol</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>REF_NAME</th> <td>Punggol West Flyover (TPE towards PIE, slip road t</td> </tr><tr bgcolor=\"\"> <th>GPS_LONG</th> <td>103.89623</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>GPS_LAT</th> <td>1.40012</td> </tr><tr bgcolor=\"\"> <th>X</th> <td>35001.19189</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>Y</th> <td>42443.76563</td> </tr><tr bgcolor=\"\"> <th>HYPERLINK</th> <td>http://Pub.cloudapp.net/CCTVS/021</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>INC_CRC</th> <td>3FD2490046F8D585</td> </tr><tr bgcolor=\"\"> <th>FMEL_UPD_D</th> <td>20190611163416</td> </tr></table></center>"
},
"geometry": {
"type": "Point",
"coordinates": [
103.896230000068,
1.40011999970993,
0
]
}
},
{
"type": "Feature",
"properties": {
"Name": "kml_6",
"Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>CCTVID</th> <td>EP007</td> </tr><tr bgcolor=\"\"> <th>CATCHMENT</th> <td>Punggol</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>REF_NAME</th> <td>Jln Teliti</td> </tr><tr bgcolor=\"\"> <th>GPS_LONG</th> <td>103.89098</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>GPS_LAT</th> <td>1.3611</td> </tr><tr bgcolor=\"\"> <th>X</th> <td>34417.04215</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>Y</th> <td>38129.11502</td> </tr><tr bgcolor=\"\"> <th>HYPERLINK</th> <td>http://Pub.cloudapp.net/CCTVS/201</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>INC_CRC</th> <td>D5193FD47EE21381</td> </tr><tr bgcolor=\"\"> <th>FMEL_UPD_D</th> <td>20190611163416</td> </tr></table></center>"
},
"geometry": {
"type": "Point",
"coordinates": [
103.89098000042,
1.36109999978782,
0
]
}
},
{
"type": "Feature",
"properties": {
"Name": "kml_7",
"Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>CCTVID</th> <td>EP009</td> </tr><tr bgcolor=\"\"> <th>CATCHMENT</th> <td>Punggol</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>REF_NAME</th> <td>Mimosa Walk</td> </tr><tr bgcolor=\"\"> <th>GPS_LONG</th> <td>103.85994</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>GPS_LAT</th> <td>1.38137</td> </tr><tr bgcolor=\"\"> <th>X</th> <td>30962.62768</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>Y</th> <td>40370.40839</td> </tr><tr bgcolor=\"\"> <th>HYPERLINK</th> <td>http://Pub.cloudapp.net/CCTVS/202</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>INC_CRC</th> <td>46574A8BCFC09C96</td> </tr><tr bgcolor=\"\"> <th>FMEL_UPD_D</th> <td>20190611163416</td> </tr></table></center>"
},
"geometry": {
"type": "Point",
"coordinates": [
103.859940000133,
1.381370000033,
0
]
}
},
{
"type": "Feature",
"properties": {
"Name": "kml_8",
"Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>CCTVID</th> <td>EW006</td> </tr><tr bgcolor=\"\"> <th>CATCHMENT</th> <td>Woodlands</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>REF_NAME</th> <td>Gambas Ave / Woodlands Ave 10</td> </tr><tr bgcolor=\"\"> <th>GPS_LONG</th> <td>103.8119</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>GPS_LAT</th> <td>1.4456</td> </tr><tr bgcolor=\"\"> <th>X</th> <td>25616.44848</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>Y</th> <td>47472.63221</td> </tr><tr bgcolor=\"\"> <th>HYPERLINK</th> <td>http://Pub.cloudapp.net/CCTVS/055</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>INC_CRC</th> <td>0F73686764984526</td> </tr><tr bgcolor=\"\"> <th>FMEL_UPD_D</th> <td>20190611163416</td> </tr></table></center>"
},
"geometry": {
"type": "Point",
"coordinates": [
103.811900000092,
1.44559999985158,
0
]
}
},
{
"type": "Feature",
"properties": {
"Name": "kml_9",
"Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>CCTVID</th> <td>EW007</td> </tr><tr bgcolor=\"\"> <th>CATCHMENT</th> <td>Woodlands</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>REF_NAME</th> <td>Woodlands Ave 2 (Slip road towards SLE)</td> </tr><tr bgcolor=\"\"> <th>GPS_LONG</th> <td>103.78665</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>GPS_LAT</th> <td>1.42746</td> </tr><tr bgcolor=\"\"> <th>X</th> <td>22806.47847</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>Y</th> <td>45466.84366</td> </tr><tr bgcolor=\"\"> <th>HYPERLINK</th> <td>http://Pub.cloudapp.net/CCTVS/056</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>INC_CRC</th> <td>02397366F24135A2</td> </tr><tr bgcolor=\"\"> <th>FMEL_UPD_D</th> <td>20190611163416</td> </tr></table></center>"
},
"geometry": {
"type": "Point",
"coordinates": [
103.786650000257,
1.42746000033543,
0
]
}
},
{
"type": "Feature",
"properties": {
"Name": "kml_10",
"Description": "<center><table><tr><th colspan='2' align='center'><em>Attributes</em></th></tr><tr bgcolor=\"#E3E3F3\"> <th>CCTVID</th> <td>EW008</td> </tr><tr bgcolor=\"\"> <th>CATCHMENT</th> <td>Woodlands</td> </tr><tr bgcolor=\"#E3E3F3\"> <th>REF_NAME</th> <td>Sembawang Shopping Centre</td> </tr><tr bgcolor=\"\"> <th>GPS_LONG</th> <td>103.82414</td> </tr><tr bgcolor=\"#E3E3F3\"> <
This code can be used to test a sample API query. It retrieves the data catalogue of this dataset. For a complete guide on query parameters and syntax, please refer to the API documentation
import requests
dataset_id = "d_1de1c45043183bec57e762d01c636eee"
url = "https://api-open.data.gov.sg/v1/public/api/datasets/" + dataset_id + "/poll-download"
response = requests.get(url)
json_data = response.json()
if json_data['code'] != 0:
print(json_data['errMsg'])
exit(1)
url = json_data['data']['url']
response = requests.get(url)
print(response.text)
This dataset can be reused and cited in research publications.
31 Jul 2023
Free forever for personal or commercial use, under the Open Data Licence.