Secure websites use HTTPS
Real-time APIs will be unavailable from September 19th, 2024, 06:00 pm to September 19th, 2024, 10:00 pm due to upstream service's system maintenance. We apologise for the inconvenience caused.
Updated 4 months ago
SFA (Singapore Food Agency)Attribute Legends
| Attributes | Data Type | Description |
|---|---|---|
| Name | Text | - |
| Description | Text | - |
Dataset preview
This code can be used to view the raw JSON dataset for Certificate Grading Info of Licensed Eating Establishments (GEOJSON). 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>LICENSEE_NAME<\/th> <td>CANTON PARADISE PTE. LTD.<\/td> <\/tr><tr bgcolor=\"\"> <th>LICENCE_NUMBER<\/th> <td>CE16G95X000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>PREMISES_ADDRESS<\/th> <td>10 BAYFRONT AVENUE #01-02 MARINA BAY SANDS SINGAPORE 018956<\/td> <\/tr><tr bgcolor=\"\"> <th>GRADE<\/th> <td>A<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>DEMERIT_POINTS<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>SUSPENSION_START_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>SUSPENSION_END_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>POSTAL_CODE<\/th> <td>018956<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>ADDR_TYPE<\/th> <td>Address<\/td> <\/tr><tr bgcolor=\"\"> <th>X<\/th> <td>30790.54899900000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>Y<\/th> <td>29427.58903700000<\/td> <\/tr><tr bgcolor=\"\"> <th>INC_CRC<\/th> <td>6FA14DE49A51D153<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D<\/th> <td>20190208131515<\/td> <\/tr><\/table><\/center>" }, "geometry": { "type": "Point", "coordinates": [ 103.858308386809995, 1.28233336454775, 0.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>LICENSEE_NAME<\/th> <td>ROYAL T GROUP PTE. LTD.<\/td> <\/tr><tr bgcolor=\"\"> <th>LICENCE_NUMBER<\/th> <td>CE11H51K000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>PREMISES_ADDRESS<\/th> <td>10 BAYFRONT AVENUE #01-72 MARINA BAY SANDS SINGAPORE 018956<\/td> <\/tr><tr bgcolor=\"\"> <th>GRADE<\/th> <td>A<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>DEMERIT_POINTS<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>SUSPENSION_START_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>SUSPENSION_END_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>POSTAL_CODE<\/th> <td>018956<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>ADDR_TYPE<\/th> <td>Address<\/td> <\/tr><tr bgcolor=\"\"> <th>X<\/th> <td>30790.54899900000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>Y<\/th> <td>29427.58903700000<\/td> <\/tr><tr bgcolor=\"\"> <th>INC_CRC<\/th> <td>6FA14DE422F559F3<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D<\/th> <td>20190208131515<\/td> <\/tr><\/table><\/center>" }, "geometry": { "type": "Point", "coordinates": [ 103.858308386809995, 1.28233336454775, 0.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>LICENSEE_NAME<\/th> <td>SEAFOOD PARADISE (S) PTE. LTD.<\/td> <\/tr><tr bgcolor=\"\"> <th>LICENCE_NUMBER<\/th> <td>CE16A90V000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>PREMISES_ADDRESS<\/th> <td>10 BAYFRONT AVENUE #02-03 MARINA BAY SANDS SINGAPORE 018956<\/td> <\/tr><tr bgcolor=\"\"> <th>GRADE<\/th> <td>A<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>DEMERIT_POINTS<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>SUSPENSION_START_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>SUSPENSION_END_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>POSTAL_CODE<\/th> <td>018956<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>ADDR_TYPE<\/th> <td>Address<\/td> <\/tr><tr bgcolor=\"\"> <th>X<\/th> <td>30790.54899900000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>Y<\/th> <td>29427.58903700000<\/td> <\/tr><tr bgcolor=\"\"> <th>INC_CRC<\/th> <td>6FA14DE416AAB7B6<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D<\/th> <td>20190208131515<\/td> <\/tr><\/table><\/center>" }, "geometry": { "type": "Point", "coordinates": [ 103.858308386809995, 1.28233336454775, 0.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>LICENSEE_NAME<\/th> <td>MARINA BAY SANDS PTE. LTD.<\/td> <\/tr><tr bgcolor=\"\"> <th>LICENCE_NUMBER<\/th> <td>CE12U27L000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>PREMISES_ADDRESS<\/th> <td>10 BAYFRONT AVENUE #03-01 MARINA BAY SANDS SINGAPORE 018956<\/td> <\/tr><tr bgcolor=\"\"> <th>GRADE<\/th> <td>A<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>DEMERIT_POINTS<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>SUSPENSION_START_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>SUSPENSION_END_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>POSTAL_CODE<\/th> <td>018956<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>ADDR_TYPE<\/th> <td>Address<\/td> <\/tr><tr bgcolor=\"\"> <th>X<\/th> <td>30790.54899900000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>Y<\/th> <td>29427.58903700000<\/td> <\/tr><tr bgcolor=\"\"> <th>INC_CRC<\/th> <td>6FA14DE4C1DD686C<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D<\/th> <td>20190208131515<\/td> <\/tr><\/table><\/center>" }, "geometry": { "type": "Point", "coordinates": [ 103.858308386809995, 1.28233336454775, 0.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>LICENSEE_NAME<\/th> <td>MARINA BAY SANDS PTE. LTD.<\/td> <\/tr><tr bgcolor=\"\"> <th>LICENCE_NUMBER<\/th> <td>CE14P28B000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>PREMISES_ADDRESS<\/th> <td>10 BAYFRONT AVENUE #55-00 MARINA BAY SANDS (55TH STOREY) SINGAPORE 018956<\/td> <\/tr><tr bgcolor=\"\"> <th>GRADE<\/th> <td>A<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>DEMERIT_POINTS<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>SUSPENSION_START_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>SUSPENSION_END_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>POSTAL_CODE<\/th> <td>018956<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>ADDR_TYPE<\/th> <td>Address<\/td> <\/tr><tr bgcolor=\"\"> <th>X<\/th> <td>30790.54899900000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>Y<\/th> <td>29427.58903700000<\/td> <\/tr><tr bgcolor=\"\"> <th>INC_CRC<\/th> <td>6FA14DE4E11A4798<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D<\/th> <td>20190208131515<\/td> <\/tr><\/table><\/center>" }, "geometry": { "type": "Point", "coordinates": [ 103.858308386809995, 1.28233336454775, 0.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>LICENSEE_NAME<\/th> <td>MARINA BAY SANDS PTE. LTD.<\/td> <\/tr><tr bgcolor=\"\"> <th>LICENCE_NUMBER<\/th> <td>CE13U45A000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>PREMISES_ADDRESS<\/th> <td>10 BAYFRONT AVENUE (BASEMENT 2) MARINA BAY SANDS SINGAPORE 018956<\/td> <\/tr><tr bgcolor=\"\"> <th>GRADE<\/th> <td>A<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>DEMERIT_POINTS<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>SUSPENSION_START_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>SUSPENSION_END_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>POSTAL_CODE<\/th> <td>018956<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>ADDR_TYPE<\/th> <td>Address<\/td> <\/tr><tr bgcolor=\"\"> <th>X<\/th> <td>30790.54899900000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>Y<\/th> <td>29427.58903700000<\/td> <\/tr><tr bgcolor=\"\"> <th>INC_CRC<\/th> <td>6FA14DE4FBEBC4E4<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D<\/th> <td>20190208131515<\/td> <\/tr><\/table><\/center>" }, "geometry": { "type": "Point", "coordinates": [ 103.858308386809995, 1.28233336454775, 0.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>LICENSEE_NAME<\/th> <td>MARINA BAY SANDS PTE. LTD.<\/td> <\/tr><tr bgcolor=\"\"> <th>LICENCE_NUMBER<\/th> <td>CE11H75P000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>PREMISES_ADDRESS<\/th> <td>10 BAYFRONT AVENUE 3RD STOREY (SERVICE PANTRY 1) MARINA BAY SANDS SINGAPORE 018956<\/td> <\/tr><tr bgcolor=\"\"> <th>GRADE<\/th> <td>A<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>DEMERIT_POINTS<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>SUSPENSION_START_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>SUSPENSION_END_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>POSTAL_CODE<\/th> <td>018956<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>ADDR_TYPE<\/th> <td>Address<\/td> <\/tr><tr bgcolor=\"\"> <th>X<\/th> <td>30790.54899900000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>Y<\/th> <td>29427.58903700000<\/td> <\/tr><tr bgcolor=\"\"> <th>INC_CRC<\/th> <td>6FA14DE47D508C8E<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>FMEL_UPD_D<\/th> <td>20190208131515<\/td> <\/tr><\/table><\/center>" }, "geometry": { "type": "Point", "coordinates": [ 103.858308386809995, 1.28233336454775, 0.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>LICENSEE_NAME<\/th> <td>MARINA BAY SANDS PTE. LTD.<\/td> <\/tr><tr bgcolor=\"\"> <th>LICENCE_NUMBER<\/th> <td>CE11H76N000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>PREMISES_ADDRESS<\/th> <td>10 BAYFRONT AVENUE 3RD STOREY (SERVICE PANTRY 2) MARINA BAY SANDS SINGAPORE 018956<\/td> <\/tr><tr bgcolor=\"\"> <th>GRADE<\/th> <td>A<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>DEMERIT_POINTS<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>SUSPENSION_START_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>SUSPENSION_END_DATE<\/th> <td><\/td> <\/tr><tr bgcolor=\"\"> <th>POSTAL_CODE<\/th> <td>018956<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>ADDR_TYPE<\/th> <td>Address<\/td> <\/tr><tr bgcolor=\"\"> <th>X<\/th> <td>30790.54899900000<\/td> <\/tr><tr bgcolor=\"#E3E3F3\"> <th>Y<\/th> <td>29427.58903700000<\/td> <\/tr><tr bgcolor=\"\"> <th>INC_CRC<\/th> <td>6FA14DE4174FB05E<\/td> <\/tr><tr bgcolor=\"#E3E3FThis 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
datasetId = "d_546a95c5e6a0a264a82247ec107a0629"
url = "https://api-open.data.gov.sg/v1/public/api/datasets/" + datasetId + "/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)07 Feb 2019
Free forever for personal or commercial use, under the Open Data Licence.